The labreportspecimens table manages one-to-many relationships between a lab report that is managed in the labreports table and specimens that were collected and analyzed to generate the lab report.
| Name |
Type
|
Description |
| id |
VARCHAR |
Surrogate key. Primary key for the labreportspecimens table.
|
| setid |
VARCHAR |
Id for the specimen provided by the lab.
|
| placerspecimenidentifier |
VARCHAR |
An order number created in a provider’s information system to uniquely identify the specimen.
|
| fillerspecimenidentifier |
VARCHAR |
An order number created in a provider’s information system to uniquely identify the specimen.
|
| collectionstartdate |
VARCHAR |
The start date of the period in which the specimen was collected.
|
| collectionenddate |
VARCHAR |
The end date of the period in which the specimen was collected.
|
| conditiontext |
VARCHAR |
A text field to manage uncoded information related to conditionterm_id.
|
| receiveddate |
VARCHAR |
The date the specimen was recieved by the lab that evaluated it.
|
| typetext |
VARCHAR |
A text field to manage uncoded information related to typeterm_id.
|
| typemodifiertext |
VARCHAR |
A text field to manage uncoded information related to typemodifierterm_id.
|
| additivetext |
VARCHAR |
A text field to manage uncoded information related to additiveterm_id.
|
| collectionmethodtext |
VARCHAR |
A text field to manage uncoded information related to collectionmethodterm_id.
|
| quantity |
VARCHAR |
If applicable, a quantity to describe the specimen.
|
| rejectreasontext |
VARCHAR |
A text field to manage uncoded information related to rejectreasonterm_id.
|
| roletext |
VARCHAR |
A text field to manage uncoded information related to roleterm_id.
|
| sourcesitetext |
VARCHAR |
A text field to manage uncoded information related to sourcesiteterm_id.
|
| sourcesitemodifiertext |
VARCHAR |
A text field to manage uncoded information related to sourcesitemodifierterm_id.
|
| unitstext |
VARCHAR |
A text field to manage uncoded information related to unitsterm_id.
|
| typeterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| typealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| typemodifierterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| typemodifieralternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| rejectreasonterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| rejectreasonalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| conditionterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| conditionalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| additiveterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| additivealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| collectionmethodterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| collectionmethodalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| sourcesiteterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| sourcesitealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| sourcesitemodifierterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| sourcesitemodifieralternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| roleterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| rolealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| unitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| unitsalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| placerspecimenassigningauthority_id |
INTEGER |
Surrogate key. Foreign key reference to assigningauthorityies.id
|
| fillerspecimenassigningauthority_id |
INTEGER |
Surrogate key. Foreign key reference to assigningauthorityies.id
|
| labreport_id |
VARCHAR |
Surrogate key. Foreign key reference to labreports.id
|
| inserteddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was first inserted into HIEBus.
|
| insertedbyapplication_id |
SMALLINT |
The application that first inserted the row into HIEBus. Foreign key reference to applications.id.
|
| insertedbyuser_id |
VARCHAR |
The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.
|
| modifieddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was last modified.
|
| modifiedbyapplication_id |
SMALLINT |
The application that last modified the row. Foreign key reference to applications.id.
|
| modifiedbyuser_id |
VARCHAR |
The user associated with the process that last modified the row. Foreign key reference to users.id.
|
| tenant_id |
SMALLINT |
Surrogate key. Foreign key reference to tenants.id
|
