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