Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabOrderTest
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. |
| SpecimenCode | CHAR(8) | OPTIONAL | User entered code for the specimen. | |
| LabOrderSID | INTEGER | ? | MANDATORY | FK from LabOrder |
| LabID | INTEGER | ? | MANDATORY | FK from Lab |
| TestCode | CHARACTER(20) | MANDATORY | FK from LabCatalogTest | |
| OrderLine | INTEGER | 0 | MANDATORY | System generated next sequential number for the item on the lab order. |
| ResultOrder | INTEGER | 0 | OPTIONAL | The order that the test was reported by the lab. |
| Charge | DECIMAL(10,2) | 0 | OPTIONAL | The amount of the charge posted for the test. |
| Posted | CHARACTER(1) | OPTIONAL | System set flag that indicates if a charge was posted for this test. The value is set to (Y)es or (N)o. | |
| Modifier | CHARACTER(2) | OPTIONAL | The modifier used when posting a charge. | |
| TestStatus | CHARACTER(1) | OPTIONAL | Status of the test. | |
| 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. |
| SpecimenSource | CHARACTER(20) | OPTIONAL | User entered source of specimen. | |
| SpecimenDate | DATE | OPTIONAL | User entered date specimen was collected. | |
| SpecimenTime | INTEGER | ? | OPTIONAL | User entered time (saved as seconds since midnight) specimen was collected. |
| Volume | INTEGER | 0 | OPTIONAL | User entered volume of specimen. |
| VolumeUnits | CHARACTER(5) | OPTIONAL | User entered units of measurement of specimen volume. | |
| Duration | INTEGER | 0 | OPTIONAL | The duration time of the specimen collection. |
| MNVTestList | CHARACTER(32000) | OPTIONAL | A pipe delimited list of frequency validation tests as used by medical necessity. | |
| MNVDateList | CHARACTER(32000) | OPTIONAL | A pipe delimited list of dates as used by medical necessity. | |
| LabSpecimenID | CHARACTER(20) | OPTIONAL | This field is the Lab downloaded identifier (at result time) for this test/specimen. | |
| TestNote | CHAR(32000) | OPTIONAL | This field is the Lab downloaded (at result time) text information regarding this test. | |
| 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. | |
| ReportDate | DATE | OPTIONAL | Date result was reported by the lab. | |
| ReportTime | INTEGER | 0 | OPTIONAL | Time result was reported by the lab. |
| LabSpecimenReceiptDate | DATE | OPTIONAL | Date lab specimen was received. | |
| LabSpecimenReceiptTime | INTEGER | 0 | OPTIONAL | Time the lab specimen was received. |
| PerformingLabID | INTEGER | ? | OPTIONAL | FK - From LabPerformingLab table |
| ClinicianOrderableID | CHAR(15) | OPTIONAL | Clinician Orderable ID | |
| HasAOE | LOGICAL | Logical_False | OPTIONAL | Indicates whether or not the lab test has AOE questions |
| TestDescription | CHAR(60) | OPTIONAL | Description of the lab order test | |
| ClinicianOrderTestID | CHAR(15) | OPTIONAL | Clinician's order test reference | |
| ExclusiveTest | LOGICAL | Logical_False | OPTIONAL | Indicates whether this test is exclusive. |
| SplitCode | CHAR(60) | OPTIONAL | Code used to group tests and split them to a seperate requisition | |
| ParentLabOrderTestSID | INTEGER | ? | OPTIONAL | The parent lab order test identifier used for micro results. |
| SendTestToPortal | CHAR(1) | OPTIONAL | Indicates whether this lab test should be sent to Portal. Expected values are 'Y' and 'N'. | |
| SpecimenDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the SpecimenDate and SpecimenTime. This field contains the Date, Time and timezone offset. If the SpecimenTime is null then the SpecimenTime will be set to midnight. | |
| ConfidentialityLevel | CHAR(2) | Alpha_-_N | OPTIONAL | The field will hold the Confidentiality Level for the Lab Test |
| ResultReleaseConfiguration | CHARACTER(2) | OPTIONAL | This field will hold lookup codes of 'ResultReleaseClass' type. | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| LabPerformingLab | LabOrderTest.PerformingLabID = LabPerformingLab.LabPerformingLabID | RESTRICT if LabOrderTest exists |
| LabSpecimenType | LabOrderTest.LabID = LabSpecimenType.LabID and LabOrderTest.SpecimenCode = LabSpecimenType.SpecimenCode |
NONE if LabOrderTest exists |
| LabOrder | LabOrderTest.LabOrderSID = LabOrder.LabOrderSID | CASCADE if LabOrderTest exists |
| Child Table | Join Phrase | When deleting LabOrderTest record... |
|---|---|---|
| LabOrderTestSpecimen | LabOrderTestSpecimen.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestSpecimen exists |
| LabOrderTestNote | LabOrderTestNote.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestNote exists |
| EAObjectData | EAObjectData.EAObjectSID = LabOrderTest.LabOrderTestSID | CASCADE if EAObjectData exists |
| LabOrderTestDiag | LabOrderTestDiag.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestDiag exists |
| LabOrderTestResult | LabOrderTestResult.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestResult exists |