Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabPerformingLab
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| LabPerformingLabID | INTEGER | ? | MANDATORY | System generated unique id using the General System sequence. |
| CLIANumber | CHAR(20) | OPTIONAL | CLIA number for this lab. | |
| CorporateID | CHAR(20) | OPTIONAL | Corporate identifier for this lab. | |
| RegionalID | CHAR(10) | OPTIONAL | Regional identifier for this lab. | |
| LabName | CHAR(60) | OPTIONAL | Name for this Lab. | |
| AddressLine1 | CHAR(40) | OPTIONAL | First line of the Address for this lab. | |
| AddressLine2 | CHAR(40) | OPTIONAL | Second line of the Address for this lab | |
| City | CHAR(20) | OPTIONAL | City of the Address for this lab. | |
| State | CHAR(2) | OPTIONAL | State of the Address for this lab. | |
| Zip | CHAR(10) | OPTIONAL | Zip of the Address for this lab. | |
| ContactPerson | CHAR(20) | OPTIONAL | Contact Person for this 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. |
| CountryCode | CHAR(10) | Set_To_Empty_String | OPTIONAL | The country code of the lab |
| CountyCode | CHAR(10) | Set_To_Empty_String | OPTIONAL | The county/parish code for the lab |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting LabPerformingLab record... |
|---|---|---|
| LabOrderTestResult | LabOrderTestResult.PerformingLabID = LabPerformingLab.LabPerformingLabID | RESTRICT if LabOrderTestResult exists |
| LabOrderTest | LabOrderTest.PerformingLabID = LabPerformingLab.LabPerformingLabID | RESTRICT if LabOrderTest exists |