raFiles


Description

Remittance advice file management tracking uploaded remittance advice files and electronic payment notifications for claims processing. This table manages RA file metadata including file names, sender/receiver information, upload tracking, and check log associations to support electronic remittance processing, payment reconciliation, and automated claims adjudication workflows.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fileID int identity 4 √ null
NyeisFfileImport.fkFileID FK_NyeisFfileImport_raFiles R
ra_835Import.fkFileID FK_ra_835Import_raFiles R

Primary key - Unique identifier for each remittance advice file
fileName nvarchar 200 √ null

File name - Name of the uploaded remittance advice file
suppFileName nvarchar 200 √ null

Supplemental file name - Name of any supplemental file associated with the RA
Sender nvarchar 100 √ null

File sender - Organization or entity that sent the remittance advice file
Receiver nvarchar 100 √ null

File receiver - Organization or entity that received the remittance advice file
fileDate datetime 16,3 √ null

File date - Date associated with the remittance advice file
suppFileDate datetime 16,3 √ null

Supplemental file date - Date associated with the supplemental file
uploadBy int 4 √ null
AccessUser.UserID FK_raFiles_AccessUser R

Uploaded by user - UserID of the person who uploaded the file
uploadDate datetime 16,3 √ (getdate())

Upload date - Date when the file was uploaded to the system
fkCheckLogID int 4 √ null
checkLog.checkLogID FK_raFiles_checkLog R

Check log reference - Links to CheckLog table for payment batch association
comment varchar 500 √ null

File comments - Comments or notes about the remittance advice file processing
fkStatusID int 4 √ null

Status reference - Links to status table for file processing status
DateProcessed smalldatetime 16 √ null

Processing date - Date when the remittance advice file was processed
Msg varchar 1000 √ null

Processing message - System messages or errors from file processing
DateImported smalldatetime 16 √ null

Import date - Date when the file data was imported into the system
fkSourceID varchar 50 √ null

Source identifier - Identifier for the source system or organization
FileNumber int 4 √ null

File number - Sequential or reference number for the file
FileType varchar 20 √ null

File type - Type or format of the remittance advice file
CheckDate datetime 16,3 √ null

Check date - Date associated with the payment check or transaction

Indexes

Constraint Name Type Sort Column(s)
PK_raFiles Primary key Asc fileID

Relationships

Close relationships within degrees of separation