Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| fileID | int identity | 4 | null |
|
|
File primary key - Unique identifier for each file record |
||
| fileName | nvarchar | 200 | √ | null |
|
|
File name - Name of the uploaded NYEIS F-file |
|
| suppFileName | nvarchar | 200 | √ | null |
|
|
Supplemental file name - Name of any supplemental file associated with the main file |
|
| Sender | nvarchar | 100 | √ | null |
|
|
File sender - Organization or system that sent the file (empty for F-files) |
|
| Receiver | nvarchar | 100 | √ | null |
|
|
File receiver - Organization or system that receives the file (empty for F-files) |
|
| fileDate | datetime | 16,3 | √ | null |
|
|
File date - Date associated with the file content or creation |
|
| suppFileDate | datetime | 16,3 | √ | null |
|
|
Supplemental file date - Date of the supplemental file |
|
| uploadBy | int | 4 | √ | null |
|
|
Uploaded by user - UserID of the person who uploaded the file |
|
| uploadDate | datetime | 16,3 | √ | null |
|
|
Upload date - Date and time when the 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 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 file was processed |
|
| Msg | varchar | 1000 | √ | null |
|
|
Processing message - Messages or errors from file processing |
|
| DateImported | smalldatetime | 16 | √ | null |
|
|
Import date - Date when file data was imported into the system |
|
| fkSourceID | varchar | 50 | √ | null |
|
|
Source reference - Links to source system or organization |
|
| FileNumber | int | 4 | √ | null |
|
|
File number - Sequential or reference number for the file |
|
| FileType | varchar | 20 | √ | null |
|
|
File type - Type of file (filtered to ‘NYEIS F’ files) |
Relationships
Close relationships within degrees of separation
