ScanEvalclaim_vw


Description

Scanned evaluation claim view providing formatted view of scanned evaluation claim forms and documents. This view consolidates scanned form header information with standardized field mappings for evaluation claims, supporting document processing workflows, evaluation billing, and integration with assessment and billing systems for scanned evaluation forms.

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

Relationships

View Definition


Possibly Referenced Tables/Views