Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabOrder
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| LabOrderSID | INTEGER | ? | MANDATORY | System generated unique ID using LAB sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK - various tables |
| PatientID | INTEGER | ? | OPTIONAL | FK - From PatientAccount |
| AccountSID | INTEGER | ? | OPTIONAL | FK - From PatientAccount |
| LabID | INTEGER | ? | MANDATORY | FK From Lab |
| StaffID | INTEGER | ? | OPTIONAL | FK from Staff |
| RefDoctorID | INTEGER | ? | OPTIONAL | FK - RefDoctorID |
| RequisitionNumber | CHARACTER(20) | OPTIONAL | System generated number based on a lab defined format. | |
| BillingMethod | CHARACTER(1) | OPTIONAL | User entered method of billing lab. Acceptable values are (I)nsurance, (D)octor, and (P)atient. The values are system defined lookup codes for the lookup type 'LabBillMethod'. | |
| PatientWeight | INTEGER | 0 | OPTIONAL | User entered weight of patient. |
| PatientWeightUnits | CHARACTER(3) | OPTIONAL | User entered units of weight. Acceptable values are LBS or KGS. | |
| Priority | CHARACTER(1) | OPTIONAL | User entered priority of lab order. Acceptable values are (S)tat or (R)outine. | |
| PatientFasting | CHARACTER(1) | OPTIONAL | User entered flag to indicate if patient was fasting. Acceptable values are (Y)es or (N)o. | |
| Confidential | CHARACTER(1) | OPTIONAL | User entered confidentiality value. | |
| OrderDate | DATE | OPTIONAL | User entered date lab was ordered. | |
| OrderStatus | CHARACTER(1) | OPTIONAL | User entered status of order. Acceptable values are (O)pen, (H)old, (T)ransmit or (D)elete. | |
| TransmissionDate | DATE | OPTIONAL | Date lab order was transmitted. | |
| TransmissionTime | INTEGER | 0 | OPTIONAL | Time lab order was transmitted. |
| LabReceiptDate | DATE | OPTIONAL | Date of lab receipt. | |
| LabReportDate | DATE | OPTIONAL | Date results were reported. | |
| ResultStatus | CHARACTER(1) | OPTIONAL | Status of results. Acceptable values are (T)ransmitted, (P)artial, (F)inal, (C)orrected, or (D)elete. | |
| RequisitionPrintStatus | CHARACTER(1) | OPTIONAL | Print status of requisition. Acceptable values are (Y)es, (N)o or blank. | |
| ResultPrintStatus | CHARACTER(1) | OPTIONAL | System recorded value to indicate if the results have been printed. Possible values are: (Y)es, (N)o | |
| ElectronicResults | CHARACTER(1) | OPTIONAL | Flag to indicate if requisition has electronic results. Acceptable values are (Y)es or (N)o. | |
| ReferenceNote | CHARACTER(60) | OPTIONAL | User entered note that may be transmitted to the laboratory regarding the order. | |
| ClientNote | CHARACTER(60) | OPTIONAL | User entered note regarding the test or specimen that the client (Dr. Office) wishes to record. | |
| 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. |
| PatientAcceptABN | CHARACTER(1) | OPTIONAL | Indicates that the patient has agreed to accept the ABN waiver as presented to them. Possible values: (Y)es, (N)o | |
| AbnormalResults | CHARACTER(1) | No_Value__N_ | OPTIONAL | Indicates if there are any abnormal results for the order. Possible values: (Y)es, (N)o |
| ReviewedResults | CHARACTER(1) | OPTIONAL | Indicates that the Lab Results have been reviewed. Possible values: (Y)es, (N)o | |
| ReviewUser | INTEGER | ? | OPTIONAL | User id of the user that reviewed the lab results. |
| ReviewedStamp | CHARACTER(14) | OPTIONAL | Reviwed timestamp. | |
| PanicResults | INTEGER | 0 | OPTIONAL | Indicates if panic results were posted for the lab order. Possible values: 1 - Panic 2 - No Panic |
| EncounterSID | INTEGER | ? | OPTIONAL | System generated unique id using Encounter sequence. |
| ClinicianOrderID | INTEGER | ? | OPTIONAL | Clinician Order ID |
| PatientOrderSetSID | INTEGER | ? | OPTIONAL | FK - PatientOrderSet - Indicates which PatientOrderSet was the source for this Lab Order. This is useful for doing things like tying EDI lab results back to the original PatientOrderSet |
| SourcePatLastName | CHAR(35) | OPTIONAL | Patient's last name as reported by the lab | |
| SourcePatFirstName | CHAR(35) | OPTIONAL | Patient's first name as reported by the lab | |
| SourcePatMiddleName | CHAR(35) | OPTIONAL | Patient's middle name as reported by the lab | |
| SourcePatSSN | CHAR(11) | OPTIONAL | Patient's SSN as reported by the lab | |
| SourcePatNumber | CHAR(9) | OPTIONAL | Patient's practice assigned id as reported by the lab | |
| SourcePatDOB | DATE | OPTIONAL | Patient's DOB as reported by the lab | |
| SourcePatSex | CHARACTER(1) | OPTIONAL | Patient's Sex as reported by the lab | |
| MatchedUser | INTEGER | ? | OPTIONAL | User id of the user that matched the patient on lab result. |
| MatchedDateTime | DATETIME | OPTIONAL | Timestamp indicating when the lab result was matched to a patient. | |
| ShareWithPatientOverride | LOGICAL | Logical_True | OPTIONAL | Indicates whether or not the lab results should be shown to the patient. |
| SourceProvID | INTEGER | 0 | OPTIONAL | This field has been obsoleted and replaced by the SourceProvCode field. |
| SourceProvLabAcct | CHAR(20) | OPTIONAL | Provider's Lab Account id as reported by the lab | |
| SourceProvUPIN | CHAR(20) | OPTIONAL | Provider's UPIN as reported by the lab | |
| SourceProvNPI | CHAR(10) | OPTIONAL | Provider's NPI as reported by the lab | |
| SourceProvLastName | CHAR(20) | OPTIONAL | Provider's Last Name as reported by the lab | |
| SourceProvFirstName | CHAR(15) | OPTIONAL | Provider's First Name as reported by the lab | |
| SourceProvMiddleName | CHAR(15) | OPTIONAL | Provider's Middle Name as reported by the lab | |
| SourceProvSuffix | CHAR(20) | OPTIONAL | Provider's Suffix as reported by the lab | |
| DNMatched | LOGICAL | OPTIONAL | Specifies if the LabOrder as been matched to a patient and a provider. (maintained by db trigger). | |
| ClinicianOrderType | CHAR(10) | OPTIONAL | Specifies the Clinician Order Type. Possible values: PSC or Standard | |
| ClinicianRefDoctorSortName | CHAR(60) | ? | OPTIONAL | Copy To Provider name as supplied by Clinician. |
| SourcePatTOB | INTEGER | ? | OPTIONAL | User entered - This is the patient's time of birth in number of seconds since midnight. |
| ClinicianObjectID | CHAR(26) | OPTIONAL | Clinician Object ID | |
| SourceProvCode | CHAR(26) | OPTIONAL | This value is reported in the results to identify the ordering provider. For a Clinician order, it contains a Clinician Object ID. | |
| CallBack | LOGICAL | Logical_False | OPTIONAL | User entered flag to indicate if lab needs to call back regarding the results. |
| CallBackPhoneNumber | CHAR(20) | OPTIONAL | User entered call back phone number | |
| CallBackPhoneNumberExtension | CHAR(6) | OPTIONAL | User entered call back phone number extension | |
| CallBackFaxNumber | CHAR(20) | OPTIONAL | User entered call back fax number | |
| CallBackFaxNumberExtension | CHAR(6) | OPTIONAL | User entered call back fax number extension | |
| FastingInstructions | CHAR(60) | OPTIONAL | Instructions for fasting. | |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientOrderSet | LabOrder.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | SET NULL if LabOrder exists |
| Encounter | LabOrder.EncounterSID = Encounter.EncounterSID | NONE if LabOrder exists |
| PatientAccount | LabOrder.PracticeID = PatientAccount.PracticeID and LabOrder.PatientID = PatientAccount.PatientID and LabOrder.AccountSID = PatientAccount.AccountSID |
RESTRICT if LabOrder exists |
| Lab | LabOrder.LabID = Lab.LabID | RESTRICT if LabOrder exists |
| RefDoctor | LabOrder.RefDoctorID = RefDoctor.RefDoctorID | RESTRICT if LabOrder exists |
| Staff | LabOrder.PracticeID = Staff.PracticeID and LabOrder.StaffID = Staff.StaffID |
RESTRICT if LabOrder exists |
| Child Table | Join Phrase | When deleting LabOrder record... |
|---|---|---|
| LabOrderCopyToProvider | LabOrderCopyToProvider.LabOrderSID = LabOrder.LabOrderSID | CASCADE if LabOrderCopyToProvider exists |
| LabOrderActivity | LabOrderActivity.LabOrderSID = LabOrder.LabOrderSID | CASCADE if LabOrderActivity exists |
| PatientOrderSetResult | PatientOrderSetResult.LabOrderSID = LabOrder.LabOrderSID | CASCADE if PatientOrderSetResult exists |
| LabOrderInsCoverage | LabOrderInsCoverage.LabOrderSID = LabOrder.LabOrderSID | CASCADE if LabOrderInsCoverage exists |
| LabOrderTest | LabOrderTest.LabOrderSID = LabOrder.LabOrderSID | CASCADE if LabOrderTest exists |