Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
DocumentInterpretation
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. |
| Interpretation | CHAR(32000) | MANDATORY | Interpretation notes for the Diagnostic Image. | |
| 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. |
| LOINCCode | CHAR(50) | OPTIONAL | LOINC Code that is associated with this Document Interpretation. | |
| ProcedureCode | CHARACTER(10) | OPTIONAL | FK - ProcedureCode. Procedure Code that is associated with this Document Interpretation |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Procedure | DocumentInterpretation.ProcedureCode = Procedure.ProcedureCode | SET NULL if DocumentInterpretation exists |
| Document | DocumentInterpretation.DocumentSID = Document.DocumentSID | CASCADE if DocumentInterpretation exists |
| Child Table | Join Phrase | When deleting DocumentInterpretation record... |
|---|