Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
LabOrderTestSpecimen
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. |
| LabSpecimenID | CHAR(20) | MANDATORY | This field is the Lab downloaded identifier (at result time) for this test/specimen. | |
| SpecimenNumber | CHAR(20) | MANDATORY | Unique identifier for the specimen as referenced by the Placer application, the Filler application, or both | |
| ParentID | CHAR(20) | OPTIONAL | The identifiers for the specimen or specimens that contributed to the specimen that is described in this record. | |
| SpecimenType | CHAR(60) | OPTIONAL | Description of the precise nature of the entity that is the source material for the observation. | |
| SpecimenTypeModifier | CHAR(60) | OPTIONAL | Allows sending qualifiers for a SNOMED CT term from a single axis. Blank unless SpecimenType is a SNOMED code. | |
| Additives | CHAR(60) | OPTIONAL | Identifies any additives introduced to the specimen before or at the time of collection. | |
| CollectionMethod | CHAR(20) | OPTIONAL | The procedure or process by which the specimen was obtained. | |
| SourceSite | CHAR(20) | OPTIONAL | Source from which the specimen was obtained. | |
| SrcSiteModifier | CHAR(20) | OPTIONAL | Modifier or qualifier for the specimen source site | |
| CollectionSite | CHAR(20) | OPTIONAL | This differs from Source Site in cases where the source site must be approached via a particular anatomic location. | |
| Role | CHAR(20) | OPTIONAL | Indicates the Role of the sample. | |
| CollectionAmount | CHAR(20) | OPTIONAL | Amount of sample collected. This can be reported as a volume or a weight/mass. | |
| GroupedSpecimenCount | CHAR(60) | OPTIONAL | The number of individual specimens of a particular type represented by this instance of a specimen. | |
| SpecimenDescription | CHAR(60) | OPTIONAL | Additional information about the specimen. | |
| HandlingCode | CHAR(20) | OPTIONAL | Describes how the specimen and/or container need to be handled from the time of collection through the initiation of testing. | |
| RiskCode | CHAR(20) | OPTIONAL | Any known or suspected hazards. | |
| CollectionStartDateTime | DATETIME | OPTIONAL | The start date / time of the range over which the sample was collected. | |
| CollectionEndDateTime | DATETIME | OPTIONAL | The end date / time of the range over which the sample was collected. | |
| ReceivedDateTime | DATETIME | OPTIONAL | Time the specimen was received at the diagnostic service. | |
| ExpirationDateTime | DATETIME | OPTIONAL | The date and time the specimen can no longer be used for the purpose implied by the order. | |
| Availability | CHAR(20) | OPTIONAL | Whether the specimen, as it exists, is currently available to use in an analysis. | |
| RejectReason | CHAR(60) | OPTIONAL | Specifies one or more reasons the specimen is rejected for specified observation/result/analysis. | |
| Quality | CHAR(60) | OPTIONAL | The degree or grade of excellence of the specimen at receipt. | |
| Appropriateness | CHAR(20) | OPTIONAL | The suitability of the specimen for the particular planned use as determined by the filler. | |
| Condition | CHAR(20) | OPTIONAL | A mode or state of being that describes the nature of the specimen. | |
| CurrentQuantity | CHAR(20) | OPTIONAL | The amount of specimen that currently exists or is available for use in further testing. | |
| NumOfContainers | INTEGER | 0 | OPTIONAL | The number of containers for a given sample. |
| ContainerType | CHAR(20) | OPTIONAL | The container in which a specimen is transported. | |
| ContainerCondition | CHAR(20) | OPTIONAL | The status of the container that the specimen is shipped at the time or receipt. | |
| ChildRole | CHAR(20) | OPTIONAL | Identifies the relationship between this specimen and the parent specimen. | |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| LabOrderTest | LabOrderTestSpecimen.LabOrderTestSID = LabOrderTest.LabOrderTestSID | CASCADE if LabOrderTestSpecimen exists |
| Child Table | Join Phrase | When deleting LabOrderTestSpecimen record... |
|---|