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 evaluation document |
|
| datesigned | varchar | 30 | √ | null |
|
|
Date signed - Date when the evaluation form was signed (as text from scanned form) |
|
| signature | varchar | 30 | √ | null |
|
|
Signature indicator - Indicator of signature presence on the scanned evaluation form |
|
| DateScan | varchar | 30 | √ | null |
|
|
Scan date - Date when the evaluation document was scanned (as text) |
|
| FormID | varchar | 30 | √ | null |
|
|
Form identifier - ID of the evaluation form type that was scanned |
|
| ServiceTypeid | varchar | 50 | √ | null |
|
|
Service type identifier - Type of evaluation service documented on the scanned form, references iCS2.dbo.ServiceType for standardized service classification |
|
| Procedureid | varchar | 50 | √ | null |
|
|
Procedure identifier - Evaluation procedure code from the scanned form |
|
| Modifierid | varchar | 50 | √ | null |
|
|
Modifier identifier - Procedure modifier from the scanned evaluation form, references iCS2.dbo.Modifier for standardized modifier codes |
|
| Admitid | int | 4 | √ | null |
|
|
Admission identifier - Patient case ID from the scanned evaluation form |
|
| AuthID | int | 4 | √ | null |
|
|
Authorization identifier - Authorization ID from the scanned evaluation form |
|
| CPID | varchar | 50 | √ | null |
|
|
Claim type program identifier - Claim type and program combination from scanned evaluation form |
|
| PaysourceID | varchar | 20 | √ | null |
|
|
Payment source identifier - Payment source ID from the scanned evaluation form |
|
| Comments | varchar | 500 | √ | null |
|
|
Form comments - Comments or notes from the scanned evaluation form |
|
| DateService | varchar | 10 | null |
|
|
Service date placeholder - Standardized placeholder for evaluation service date |
||
| Agencypatientid | varchar | 12 | null |
|
|
Agency patient ID placeholder - Standardized placeholder for agency patient identifier |
||
| Attcode | varchar | 1 | null |
|
|
Attendance code placeholder - Standardized placeholder for attendance code |
||
| BiPA | varchar | 16 | null |
|
|
Bilingual PA placeholder - Standardized placeholder for bilingual professional assistant |
||
| EvPA | varchar | 16 | null |
|
|
Evaluation PA placeholder - Standardized placeholder for evaluation professional assistant |
||
| Bilingual | varchar | 1 | null |
|
|
Bilingual indicator placeholder - Standardized placeholder for bilingual service indicator |
