Tables [dbo].[Doc_Detail]
Page level information for a given batch (ie where the scan image is located)
KeyNameData TypeMax Length (Bytes)NullabilityDescription
PatientIDnumeric(16,0)9NOT NULLPatient. Link to Works.dbo.Patient_Member.ID
SubFoldervarchar(130)130NOT NULLFolder Name
FileNamevarchar(256)256NOT NULLName of the File
Cluster Key CIX_Doc_Detail_DocumentID: DocumentIDDocumentIDbigint8NOT NULLUnique Identifier used for document on patients chart
Pagesmallint2NOT NULLPage number
Check Constraints CK_Doc_Detail_Orientation : ([Orientation]=(4) OR [Orientation]=(3) OR [Orientation]=(2) OR [Orientation]=(1) OR [Orientation]=(0))Orientationtinyint1NOT NULL0-4, used to control orientation we display image to end user
LastChangedatetime8NOT NULLDate image was last edited.
AcquireDatedatetime8NOT NULLDate image was scanned into new scan
ObjectStorageIDbigint8NOT NULLExternal Storage identifier.