Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabSpecimenType
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| LabID | INTEGER | ? | MANDATORY | FK |
| SpecimenCode | CHAR(8) | MANDATORY | User entered code for the specimen. | |
| Description | CHARACTER(60) | OPTIONAL | User entered specimen description. | |
| SpecimenSource | CHARACTER(20) | MANDATORY | User entered source of specimen. | |
| Volume | INTEGER | 0 | OPTIONAL | User entered volume of specimen. |
| VolumeUnits | CHARACTER(5) | OPTIONAL | User entered units of measurement of specimen volume. | |
| Electronic | CHARACTER(1) | OPTIONAL | Defines whether or not the lab specimen type was electronically downloaded or created manually. Possible values: (Y)es (N)o Supported by lookup type Confirmation. | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the service center. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| 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. |
| SNOMEDCode | CHARACTER(30) | OPTIONAL | SNOMED Code, which is derived from ValueSets: [Specimen type] |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Lab | LabSpecimenType.LabID = Lab.LabID | CASCADE if LabSpecimenType exists |
| Child Table | Join Phrase | When deleting LabSpecimenType record... |
|---|---|---|
| LabOrderTest | LabOrderTest.LabID = LabSpecimenType.LabID and LabOrderTest.SpecimenCode = LabSpecimenType.SpecimenCode |
NONE if LabOrderTest exists |