Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabOrderTestResult
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| LabOrderTestSID | INTEGER | ? | MANDATORY | System generated ID for the ordered test. This must be a SID to link to the EA tables. |
| TestResultNumber | INTEGER | 0 | MANDATORY | The result number as transmitted from the laboratory. |
| TestCode | CHARACTER(20) | MANDATORY | System set test code as transmitted from the laboratory. | |
| TestName | CHARACTER(60) | OPTIONAL | Test name as returned by the lab. | |
| ComponentID | CHARACTER(20) | MANDATORY | System set component identifier as transmitted from that laboratory. | |
| ComponentName | CHARACTER(60) | OPTIONAL | System set component name as transmitted from that laboratory. | |
| ReportDate | DATE | OPTIONAL | Date result was reported by the lab. | |
| ReportTime | INTEGER | 0 | OPTIONAL | Time result was reported by the lab. |
| ModifyDate | DATE | OPTIONAL | Last date result was modified by the lab. | |
| ModifyTime | INTEGER | 0 | OPTIONAL | Last time result was modified by the lab. |
| ResultType | CHARACTER(2) | OPTIONAL | Result type as returned by the lab. | |
| ResultStatus | CHARACTER(1) | OPTIONAL | Result status as returned by the lab. | |
| ResultValue | CHARACTER(40) | OPTIONAL | Result value as returned by the lab. | |
| ResultUnits | CHARACTER(15) | OPTIONAL | Result units of measure as returned by the lab. | |
| ResultConfidence | CHAR(50) | OPTIONAL | Result confidence as returned by the lab. | |
| Abnormal | CHAR(5) | OPTIONAL | Indicates if results were abnormal as returned by the lab. | |
| 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. |
| PerformingLab | CHAR(12) | OPTIONAL | This field is the Lab downloaded code that identifies the performing laboratory. The lab that processes the order sometimes sends the specimen and test request to another lab to perform the test. This information must be displayed on the result report. | |
| DNLabID | INTEGER | ? | OPTIONAL | Denormalized from LabOrder. Not implemented as of 5.50.00. |
| DNPracticeID | INTEGER | ? | OPTIONAL | Denormalized from LabOrder. Not implemented as of 5.50.00. |
| DNPatientID | INTEGER | ? | OPTIONAL | Denormalized from LabOrder. Not implemented as of 5.50.00. |
| LabResponsibleObserverSID | INTEGER | 0 | OPTIONAL | FK - from Medman.LabResponsibleObserver |
| PerformingLabID | INTEGER | ? | OPTIONAL | FK - From LabPerformingLab table |
| ObservationSubID | INTEGER | ? | OPTIONAL | The parent observation identifier |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. | |
| SnomedCode | CHARACTER(20) | OPTIONAL | This will store SNOMEDCode value for the test result |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| LabPerformingLab | LabOrderTestResult.PerformingLabID = LabPerformingLab.LabPerformingLabID | RESTRICT if LabOrderTestResult exists |
| LabOrderTest | LabOrderTestResult.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestResult exists |
| Child Table | Join Phrase | When deleting LabOrderTestResult record... |
|---|---|---|
| LabOrderTestResultNote | LabOrderTestResultNote.LabOrderTestSID = LabOrderTestResult.LabOrderTestSID and LabOrderTestResultNote.TestResultNumber = LabOrderTestResult.TestResultNumber |
CASCADE if LabOrderTestResultNote exists |