SPEC_DB_MAIN
Description:
The SPEC_DB_MAIN table contains basic information about your specimen records. These include clinical pathology, anatomic pathology, and quality control specimens. One row in this table represents one specimen.

Primary Key
Column Name Ordinal Position
SPECIMEN_ID 1

Column Information
Name Type Discontinued?
1 SPECIMEN_ID VARCHAR No
The unique ID of the specimen record
2 SPEC_NUMBER_LN1 VARCHAR No
The main external identifier of the specimen
3 SPEC_DTM_COLLECTED DATETIME (Local) No
The date and time when the specimen was collected.
4 SPEC_DTM_RECEIVED DATETIME (Local) No
The date and time when the specimen was received.
5 SPEC_CONTAINER_ID VARCHAR No
The unique identifier of the container associated with this specimen
6 SPEC_CONTAINER_ID_CONTAINER_TYPE_NAME VARCHAR No
The name of the container type record.
7 SPEC_SOURCE_C_NAME VARCHAR No
The specimen source category for the specimen.
May contain organization-specific values: Yes
8 SPEC_EPT_PAT_ID VARCHAR No
The unique identifier of the patient whom this specimen belongs to.
9 SPEC_SUB_SPEC_NO VARCHAR No
The submitter's specimen number.
10 SPEC_DRAW_TYPE_C_NAME VARCHAR No
The draw type category number for the specimen
May contain organization-specific values: Yes
11 SPEC_REQ_GRP_ID NUMERIC No
The unique ID of the requisition grouper associated with this specimen if this is a non-EPT patient
12 REQ_SMT_ID NUMERIC No
The unique identifier of the submitter that collected this specimen. This is only populated for reference lab specimens.
13 REQ_SMT_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
14 REQ_ID NUMERIC No
The unique identifier of the requisition this specimen is attached to. This is only populated for reference lab specimens.
15 ACUTE_CONVAL_C_NAME VARCHAR No
The acute/convalescent category number for the specimen record.
May contain organization-specific values: No
Category Entries:
Acute
Convalescent
16 CASE_ID NUMERIC No
The unique identifier of the case this specimen is attached to. This is only populated for anatomic pathology specimens.
17 RECV_QUEUE_COMM_ID VARCHAR No
The unique ID of the internal receiving comment that is associated with this specimen.
18 SPEC_COLL_UTC_DTTM DATETIME (UTC) No
The date and time when the specimen was collected in the UTC time zone.
19 SPEC_RCVD_UTC_DTTM DATETIME (UTC) No
The date and time when the specimen was received in the UTC time zone.
20 SPEC_FROZEN_YN VARCHAR No
Indicates whether this specimen is a frozen specimen.
May contain organization-specific values: No
Category Entries:
No
Yes
21 SPECIMEN_COL_ID NUMERIC No
The unique identifier of the specimen collection record which is associated with this specimen.
22 AP_RECEIVE_UTC_DTTM DATETIME (UTC) No
The date and time when the anatomic pathology specimen was received in the UTC time zone. This is only populated for anatomic pathology specimens.
23 DRAW_SESS_UTC_DTTM DATETIME (UTC) No
The date and time when the draw session this specimen belongs to was started. It is stored in the UTC time zone.
24 SPECIMEN_TYPE_C_NAME VARCHAR No
The specimen type category ID for the specimen. This is calculated from the specimen type for the first order on the specimen that has a specimen type set and has not been redrawn or removed. If all orders on the specimen have been redrawn or removed, it is calculated from the specimen type for the first removed order that has a specimen type set.
May contain organization-specific values: Yes
25 SPEC_FROM_DSL_YN VARCHAR No
Stores whether a specimen was created from the Specimen Linking activity. The default value is No.
The category values for this column were already listed for column: SPEC_FROZEN_YN
26 ONSET_DATE DATETIME No
The onset date that symptoms began for the associated specimen. This is a legacy item and this data is no longer populated in Chronicles.
27 BIOHAZARD_C_NAME VARCHAR No
The biohazard category ID for the specimen. This is legacy data that is no longer populated.
May contain organization-specific values: No
Category Entries:
*
28 DRAW_CHGS_TRGRD_YN VARCHAR No
Indicates whether draw charges have been triggered for the specimen. 'Y' indicates that a draw charge has been triggered. 'N' or NULL indicate that a draw charge has not been triggered.
The category values for this column were already listed for column: SPEC_FROZEN_YN
29 SPEC_SOURCE VARCHAR No
The specimen source for the specimen. This is legacy data that is no longer populated.
30 SPEC_ORIGIN_C_NAME VARCHAR No
The special specimen origin category ID for the specimen.
May contain organization-specific values: No
Category Entries:
Import Specs
Interface
Auto-Import
31 IMPORT_RUN_BATCH_NUMBER_ID VARCHAR No
The batch ID associated to an imported specimen
32 CREATION_DEPARTMENT_ID NUMERIC Yes
The unique ID of the department that the specimen was created in.
33 COLL_PPID_OVRIDE_YN VARCHAR No
Indicates whether PPID was overridden during collection for this specimen.
The category values for this column were already listed for column: SPEC_FROZEN_YN
34 COLL_PSID_OVRIDE_YN VARCHAR No
Indicates whether PSID was overridden during collection for this specimen.
The category values for this column were already listed for column: SPEC_FROZEN_YN
35 REQ_OR_GEN_SUBMITTER_ID NUMERIC No
The unique identifier of the submitter of the requisition that this specimen is attached to. This is only populated for reference lab specimens. This will include a generic submitter that is placed on orders that were placed at your organization and collected at an EpicCare Link site.
36 REQ_OR_GEN_SUBMITTER_ID_RECORD_NAME VARCHAR No
The name of the submitter record.