ScanFormHeader


Description

Scanned form header information managing metadata and header details for scanned healthcare forms and documents. This table stores essential information about scanned forms including timestamps, user identification, patient references, service details, and processing status, supporting document management workflows, form processing automation, and audit trails for scanned healthcare documentation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ScanID int identity 4 √ null
ScanEIData.HeaderID FK__ScanEIDat__Heade__2141CF68 C
ScanSCData.HeaderID FK_ScanSCData_ScanFormHeader C

Primary key - Unique identifier for each scanned form header record
MilliSecs nvarchar 40 null

Millisecond timestamp - Precise timestamp in milliseconds for form scanning and processing
UserID varchar 30 √ null

User identifier - ID of the user who scanned or processed the form
Agencypatientid varchar 10 √ null

Agency patient identifier - Patient ID as used by the agency
DocName varchar 255 √ null

Document name - Name or title of the scanned document
Signature varchar 30 √ null

Signature indicator - Indicates presence or type of signature on the form
DateSigned varchar 30 √ null

Date signed - Date when the form was signed (as text from scanned form)
DateScan varchar 30 √ (getdate())

Scan date - Date when the document was scanned into the system
FormID varchar 30 √ null

Form identifier - ID of the form type or template
ServiceTypeid varchar 50 √ null

Service type identifier - Type of service documented on the 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 - Links to patient case/admission record
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
Comments varchar 500 √ null

Form comments - Comments or notes from the scanned form
PaysourceID varchar 20 √ null

Payment source identifier - Payment source ID from the scanned form
Status varchar 20 √ null

Processing status - Current status of the scanned form processing

Indexes

Constraint Name Type Sort Column(s)
PK__ScanFormHeader__010A0A00 Primary key Asc ScanID
Milli_reference_indx Performance Asc MilliSecs

Relationships

Close relationships within degrees of separation