RaFiles_EiMedicaid_vw


Description

Early Intervention Medicaid files view - Filtered view of raFiles table showing only active Early Intervention Medicaid files for billing and reimbursement processing. This view provides access to EIMedicaid file types with active status, supporting Medicaid claims processing, reimbursement tracking, and compliance reporting for early intervention services covered by Medicaid programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fileID int identity 4 null

File primary key - Unique identifier for each Medicaid file record
fileName nvarchar 200 √ null

File name - Name of the uploaded Early Intervention Medicaid file
suppFileName nvarchar 200 √ null

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

File sender - Organization or system that sent the Medicaid file
Receiver nvarchar 100 √ null

File receiver - Organization or system that receives the Medicaid file
fileDate datetime 16,3 √ null

File date - Date associated with the Medicaid file content or creation
suppFileDate datetime 16,3 √ null

Supplemental file date - Date of the supplemental Medicaid file
uploadBy int 4 √ null

Uploaded by user - UserID of the person who uploaded the Medicaid file
uploadDate datetime 16,3 √ null

Upload date - Date and time when the Medicaid file was uploaded
fkCheckLogID int 4 √ null

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

File comments - Comments or notes about the Medicaid file
fkStatusID int 4 √ null

Status reference - Links to status table (filtered to status 1 - active)
DateProcessed smalldatetime 16 √ null

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

Processing message - Messages or errors from Medicaid file processing
DateImported smalldatetime 16 √ null

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

Source reference - Links to source system or organization for Medicaid processing
FileNumber int 4 √ null

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

File type - Type of file (filtered to ‘EIMedicaid’ files)

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views