Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Lab
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| LabID | INTEGER | ? | MANDATORY | FK |
| LabType | CHARACTER(1) | MANDATORY | User entered. Type of laboratory interface. Field is supported by the lookup types:[LabType]. Values are defined in the LookupCode table for the above lookup types. | |
| MaxTestsPerReq | INTEGER | 0 | MANDATORY | User entered maximum number of tests that the lab allows on a requisition. |
| MaxDiagsPerReq | INTEGER | 0 | MANDATORY | User entered maximum number of diagnoses that the lab allows on a requisition. |
| LastBatchNumber | INTEGER | 0 | OPTIONAL | System generated sequence number of the last transmitted batch. |
| LastTransmitDate | DATE | OPTIONAL | System generated date of the last transmission. | |
| LastTransmitTime | INTEGER | 0 | OPTIONAL | System generated time of the last transmission. |
| NumberArchiveFiles | INTEGER | 0 | MANDATORY | User entered number of transmission/result files kept in the system. |
| DefaultNumberReqs | INTEGER | 0 | OPTIONAL | User entered default number of requisitions printed. |
| RealTimeTransmission | CHARACTER(1) | OPTIONAL | User entered indicator to determine if a requisition must be printed prior to transmission. This field is validated by the 'confirmation' lookup. | |
| RequisitionPrefix | CHARACTER(10) | OPTIONAL | User entered prefix that is pre-pended to the requisition number. | |
| 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. |
| ResultFormCode | CHARACTER(10) | "" | MANDATORY | FK |
| ManifestFormCode | CHARACTER(10) | "" | MANDATORY | FK |
| RequisitionFormCode | CHARACTER(10) | "" | MANDATORY | FK |
| RequisitionPrefixType | CHARACTER(1) | OPTIONAL | System defined. Defines the type of prefix assigned to the requisition number. Based on the prefix type the value of the requisition prefix will be used to determine the requisition number prefix. Field is supported by the lookup types:[LabReqPrefixType]. Values are defined in the LookupCode table for the above lookup types. | |
| DefaultWeightUnits | CHARACTER(3) | OPTIONAL | User entered units of weight. Acceptable values are LBS or KGS. | |
| DefaultSpecVolUnits | CHARACTER(5) | OPTIONAL | User entered units of specimen volume. Acceptable values are LBS or KGS. | |
| PrintNewResult | CHARACTER(1) | OPTIONAL | System defined. User-entered indicator of when new results are printed. Field is supported by the lookup types:[LabPrintNewResults]. Values are defined in the LookupCode table for the above lookup types. | |
| UnlistedCarrierCode | CHARACTER(6) | OPTIONAL | User-entered code that represents a carrier that the lab does not have a cross-reference for. | |
| DefaultSpecDate | CHARACTER(1) | OPTIONAL | User entered option for specimen date default. Possible values are: (S)ystem or (N)one. This is supported by the lookup type 'LabDefaultSpecDate'. | |
| RequisitionPrintReq | CHARACTER(1) | OPTIONAL | User-entered indicator to determine when a requisition print is required before transmission. Possible values: (Y)es, (N)o Supported by confirmation lookup type. | |
| RequisitionSeqSize | CHARACTER(1) | OPTIONAL | User-entered number of digits to be used in the formatting of the requisition number. Valid values are: 5, 6, 7 Supported by lookup type LabReqSeqSize. | |
| PatientBillingAllowed | CHARACTER(1) | OPTIONAL | User entered indicator that indicates that the laboratory provides direct patient billing. Possible values: (Y)es, (N)o Supported by LookupType: Confirmation | |
| ProviderBillingAllowed | CHARACTER(1) | OPTIONAL | User entered indicator that indicates that the laboratory provides direct provider billing. Possible values: (Y)es, (N)o Supported by LookupType: Confirmation | |
| InsuranceBillingAllowed | CHARACTER(1) | OPTIONAL | User entered indicator that indicates that the laboratory provides direct insurance billing. Possible values: (Y)es, (N)o Supported by LookupType: Confirmation | |
| LastRequisitionNumber | INTEGER | 0 | OPTIONAL | System generated number corresponding to the last requisition number generated for the laboratory. |
| FacilityApplication | CHARACTER(10) | OPTIONAL | User-entered laboratory processing application supplied by the laboratory representative. | |
| PracticeApplication | CHARACTER(10) | OPTIONAL | User-entered laboratory processing application supplied by the practice. | |
| ErrorCheckOption | CHARACTER(15) | OPTIONAL | User-entered error reporting options. | |
| RequisitionSuffixType | CHARACTER(1) | OPTIONAL | User-entered requisition number suffix type. Possible values are: (L)etter (N)one Supported by lookup type LabReqSuffixType. | |
| RequisitionSuffix | CHARACTER(1) | OPTIONAL | System generated suffix for the requisition number based on the requisition suffix type. | |
| SpecialProviderAidTag | CHARACTER(8) | OPTIONAL | User entered ID Tag used to label an ID number for a provider assigned to an alternate ID class of 'D'. | |
| RefProviderAidTag | CHARACTER(8) | OPTIONAL | User entered ID Tag used to label an ID number for a referring provider assigned to an alternate ID class of 'D'. | |
| ClinicianCorpID | CHARACTER(20) | OPTIONAL | ||
| CatalogVersion | CHARACTER(20) | OPTIONAL | This is the name/version of the catalog update file sent from the laboratory. | |
| MedNecVersion | CHARACTER(20) | OPTIONAL | This is the name/version of the medical necessity update file sent from the laboratory. | |
| ExpandMethod | CHARACTER(1) | M | OPTIONAL | Indicates if the components of a lab profile are expanded on one test ('O') or many tests ('M'). (O,M) are currently the only possible values. |
| RefDocXrefID | CHAR(8) | ? | OPTIONAL | This field is a cross reference for an alternate id on the referring doctor record. This id represents clinician's client id which is an identifier for the referring doctor by the lab that is needed to support the copy to feature. |
| AllowOverrideABN | LOGICAL | Logical_False | OPTIONAL | Determines if override of the ABN requirements is allowed during order entry (Yes/No). |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| ServiceCenter | Lab.LabID = ServiceCenter.ServiceCenterID | CASCADE if Lab exists |
| Child Table | Join Phrase | When deleting Lab record... |
|---|---|---|
| LabSpecimenType | LabSpecimenType.LabID = Lab.LabID | CASCADE if LabSpecimenType exists |
| LabOrder | LabOrder.LabID = Lab.LabID | RESTRICT if LabOrder exists |