NyeisFfileImport


Description

NYEIS F-file import tracking - Import tracking table for New York Early Intervention System F-files managing import status, error handling, and data validation. This table tracks the import process for NYEIS F-files including error messages, reference numbers, claim details, and processing dates to support automated data import, error resolution, and compliance reporting for New York State early intervention data exchange.

Columns

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

Import primary key - Unique identifier for each NYEIS F-file import record
fkFileID int 4 √ null
raFiles.fileID FK_NyeisFfileImport_raFiles R

File reference - Links to raFiles table for the source file
ErrorMessage varchar 200 √ null

Error message - Error message if import failed or encountered issues
ErrorData varchar 100 √ null

Error data - Specific data that caused the error
GSReference varchar 20 √ null

GS reference - Group segment reference number from EDI file
ISAReference varchar 20 √ null

ISA reference - Interchange segment reference number from EDI file
DateCycle varchar 20 √ null

Date cycle - Billing cycle date from the NYEIS file
FileName varchar 50 √ null

File name - Name of the imported NYEIS F-file
ClaimNumber varchar 50 √ null

Claim number - Claim number from the NYEIS file
SANumber varchar 50 √ null

Service authorization number - Service authorization number from NYEIS
ChildNumber varchar 50 √ null

Child number - Child identifier from NYEIS system
ServiceDate varchar 20 √ null

Service date - Date of service from the NYEIS file
DateImported smalldatetime 16 √ (getdate())

Import date - Date when the file was imported into the system
DateApplied smalldatetime 16 √ null

Applied date - Date when the imported data was applied to claims

Indexes

Constraint Name Type Sort Column(s)
PK_NyeisFfileImport Primary key Asc fImportId

Relationships

Close relationships within degrees of separation