Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FHeadID | int identity | 4 | null |
|
|
Form header identifier - Unique identifier for the scanned form header record |
||
| MilliSecs | nvarchar | 40 | null |
|
|
Millisecond timestamp - Precise timestamp in milliseconds for form processing |
||
| UserID | varchar | 30 | √ | null |
|
|
User identifier - ID of the user who processed or scanned the form |
|
| DocName | varchar | 255 | √ | null |
|
|
Document name - Name or title of the scanned document |
|
| datesigned | varchar | 30 | √ | null |
|
|
Date signed - Date when the form was signed (as text from scanned form) |
|
| signature | varchar | 30 | √ | null |
|
|
Signature indicator - Indicator of signature presence on the scanned form |
|
| DateScan | varchar | 30 | √ | null |
|
|
Scan date - Date when the document was scanned (as text) |
|
| FormID | varchar | 30 | √ | null |
|
|
Form identifier - ID of the form type that was scanned |
|
| ServiceTypeid | varchar | 50 | √ | null |
|
|
Service type identifier - Type of service documented on the scanned form, references iCS2.dbo.ServiceType for standardized service classification |
|
| Procedureid | varchar | 50 | √ | null |
|
|
Procedure identifier - Procedure code from the scanned form |
|
| Modifierid | varchar | 50 | √ | null |
|
|
Modifier identifier - Procedure modifier from the scanned form, references iCS2.dbo.Modifier for standardized modifier codes |
|
| DateStart | varchar | 50 | √ | null |
|
|
Start date - Service start date from the scanned form (as text) |
|
| Admitid | int | 4 | √ | null |
|
|
Admission identifier - Patient case ID from the scanned form |
|
| Comments | varchar | 500 | √ | null |
|
|
Form comments - Comments or notes from the scanned form |
|
| AuthID | int | 4 | √ | null |
|
|
Authorization identifier - Authorization ID from the scanned form |
|
| CPID | varchar | 50 | √ | null |
|
|
Claim type program identifier - Claim type and program combination from scanned form |
|
| PaysourceID | varchar | 20 | √ | null |
|
|
Payment source identifier - Payment source ID from the scanned form |
|
| san | varchar | 10 | null |
|
|
SAN placeholder - Standardized placeholder field for SAN (State Authorization Number) |
||
| AgencyPatientID | varchar | 10 | null |
|
|
Agency patient ID placeholder - Standardized placeholder for agency patient identifier |
||
| Attcode | varchar | 1 | null |
|
|
Attendance code placeholder - Standardized placeholder for attendance code |
||
| StaffID | int | 4 | √ | null |
|
|
Staff identifier - ID of the staff member from the scanned form |
|
| dateservice | varchar | 10 | null |
|
|
Service date placeholder - Standardized placeholder for service date |
||
| scanid | int | 4 | √ | null |
|
|
Scan identifier - Reference to the scan record |
|
| ST | varchar | 20 | null |
|
|
Start time placeholder - Standardized placeholder for service start time |
||
| ET | varchar | 20 | null |
|
|
End time placeholder - Standardized placeholder for service end time |
Relationships
Close relationships within degrees of separation
