Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Document
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| DocumentSID | INTEGER | ? | MANDATORY | System generated document identifier. The identifier value is obtained from the DOCUMENT sequence. |
| DocumentCategorySID | INTEGER | ? | MANDATORY | FK |
| DocumentStatus | CHARACTER(1) | MANDATORY | Image Status: S - Image/document has been scanned or otherwise captured into the database. R - Image/document has only been requested. | |
| DocumentType | CHARACTER(1) | MANDATORY | Document type: F - Use the FileX viewer to display the image. W - Use the registered viewer for the file type to display the document. | |
| AccessLevel | INTEGER | 0 | MANDATORY | |
| EntitySID | INTEGER | ? | OPTIONAL | System generated unique id using the Entity sequence. |
| ReferenceDate | DATE | MANDATORY | Reference date for the document. | |
| RequestPriority | INTEGER | 0 | OPTIONAL | Priority of the document request. |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| Description | CHARACTER(60) | OPTIONAL | Denormalize description value. | |
| SourceName | CHARACTER(50) | OPTIONAL | The name of the document source is denormalized into this field. | |
| DocumentCategoryTypeSID | INTEGER | ? | OPTIONAL | Denormalized key value from DocumentCategory table for performance improvement. |
| Category | CHARACTER(25) | OPTIONAL | Denormalized value from the DocumentCategory table field Description for performance improvement. | |
| PACSStudySID | INTEGER | ? | OPTIONAL | FK - System generated sequence using PACS sequence. |
| RISStudySID | INTEGER | ? | OPTIONAL | FK - From RISStudy - OBSOLETE - This field is no longer used in 1.20. It will be removed in 1.21. |
| DxQuality | LOGICAL | OPTIONAL | System defined - Indicates whether the document is of diagnostic quality and can be viewed by PACS viewers. Set by HL7 inbound document message transaction. | |
| EncounterSID | INTEGER | ? | OPTIONAL | FK - From Encounter |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| FHIRType | CHAR(8) | OPTIONAL | FHIR Type for Imaging document.(Lookup type - FHIRType) | |
| DiagnosticReportType | CHAR(10) | OPTIONAL | Denotes what type of a Diagnostic Report this record represents. Possible values come from lookuptype FHIRDiagnosticReportCategory | |
| ConfidentialityLevel | CHAR(2) | Alpha_-_N | OPTIONAL | The field will hold the Confidentiality Level for the images tied to a Document |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Encounter | Document.EncounterSID = Encounter.EncounterSID | SET NULL if Document exists |
| RISStudy | Document.RISStudySID = RISStudy.RISStudySID | SET NULL if Document exists |
| Entity | Document.EntitySID = Entity.EntitySID | RESTRICT if Document exists |
| Child Table | Join Phrase | When deleting Document record... |
|---|---|---|
| DocumentInterpretation | DocumentInterpretation.DocumentSID = Document.DocumentSID | CASCADE if DocumentInterpretation exists |
| AdvanceDirective | AdvanceDirective.DocumentSID = Document.DocumentSID | SET NULL if AdvanceDirective exists |
| PatientOrderSetResult | PatientOrderSetResult.DocumentSID = Document.DocumentSID | RESTRICT if PatientOrderSetResult exists |
| DocumentNote | DocumentNote.DocumentSID = Document.DocumentSID | CASCADE if DocumentNote exists |
| DocumentAttributeValue | DocumentAttributeValue.DocumentSID = Document.DocumentSID | CASCADE if DocumentAttributeValue exists |