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_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
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.
37 COLL_PRTR_OVRIDE_YN VARCHAR No
Indicates whether a required printer scan was overridden. 'Y' indicates that a printer scan was overridden during the collection process. 'N' or NULL indicates that the printer scan was completed or not required.
The category values for this column were already listed for column: SPEC_FROZEN_YN
38 COLL_PPID_REQ_YN VARCHAR No
Indicates if positive patient identification (PPID) was required during the collection process (printing labels or collection documentation). Workflows that never require PPID (for example, Requisition Entry) will not populate this item.
The category values for this column were already listed for column: SPEC_FROZEN_YN
39 COLL_PSID_REQ_YN VARCHAR No
Indicates if positive specimen identification (PSID) was required during collection documentation. Workflows that never require PSID (for example, Requisition Entry) will not populate this item.
The category values for this column were already listed for column: SPEC_FROZEN_YN
40 SPECIAL_ABO_PHENOTYPE_C_NAME VARCHAR No
The nonstandard ABO category ID for the blood product specimen.
May contain organization-specific values: No
Category Entries:
Para-Bombay
Pooled
A1
A2
41 INTENDED_USE_ATTRIBUTE_C_NAME VARCHAR No
The indended use category ID for the blood product specimen.
May contain organization-specific values: No
Category Entries:
Directed Collection Use Only
For Emergency Use Only
Directed Collection/Biohazardous
Directed Collection/Eligible for Crossover
Intended Use Not Specified
Autologous Collection/Eligible for Crossover
For Autologous Use Only
For Autologous Use Only/Biohazardous
42 BLOOD_GROUP_SPEC_MSG_C_NAME VARCHAR No
The blood groups special message category ID for the blood product specimen.
May contain organization-specific values: No
Category Entries:
No ABO or Rh information is available
Autologous collection
Biohazardous
For fractionation use only
Quarantine/hold for further testing or processing
For research use only
Not for transfusion based on test results
Discard (to be destroyed)
43 COLLECTION_TYPE_CODE_C_NAME VARCHAR No
The collection type category ID for the donor product specimen.
May contain organization-specific values: No
Category Entries:
Not Specified
Volunteer homologous (allogeneic)
Volunteer research (Product not intended for human application)
Volunteer source
Volunteer therapeutic
Paid homologous (allogeneic)
Paid research (Product not intended for human application)
Paid source
Autologous, eligible for crossover
For autologous use only
For autologous use only, biohazard
Volunteer directed, eligible for crossover
Paid directed, eligible for crossover
For directed recipient use only
For directed recipient use only, limited exposure
Medical exception, for specified recipient only (allogeneic)
See (i.e., scan) Special Testing bar code
For directed recipient use only, biohazard
Designated
Dedicated
Designated, biohazard
Family reserved
Replacement
For allogeneic use
For autologous use. Contains allogeneic material.
Directed/Dedicated/Designated Collection Use Only
Directed/Dedicated/Designated Collection/Biohazardous
Directed/Dedicated/Designated Collection/Eligible for Crossover
For Emergency Use Only
44 PRODUCT_COLLECTION_DATE DATETIME No
The date at which this blood product specimen was collected. This column is populated only for certain blood product types, according to the ISBT-128 specification.
45 PRODUCT_COLLECTION_UTC_DTTM DATETIME (UTC) No
The date and time at which this blood product specimen was collected. This column is populated only for certain blood product types, according to the ISBT-128 specification.
46 SPECIAL_TESTING_CODE_C_NAME VARCHAR No
The special testing "N-Code" category ID for the blood product specimen.
May contain organization-specific values: No
Category Entries:
CMV seronegative
47 RBC_ANTIGEN_BARCODE VARCHAR No
Stores a barcoded string containing antigen test info for RBC blood product specimens, according to the ISBT-128 specification.
48 PLATELET_ANTIGEN_BARCODE VARCHAR No
Stores a barcoded string with information about platelet HLA and HPA testing for a blood product specimen, according to the ISBT-128 specification.
49 COLL_TIMER_EXPIRATIONS INTEGER No
Indicates how many times a scan workflow timer expired after accessioning for this specimen.
50 PROD_DESC_CODE_ID NUMERIC No
The unique ID of the product description code corresonding to this donor product specimen, according to the ISBT-128 specification.
51 PROD_DESC_CODE_ID_PROD_DESC_CODE_NAME VARCHAR No
Name of the product description code.
52 EXPIRATION_UTC_DTTM DATETIME (UTC) No
The UTC date and time at which this specimen expires.
53 FACILITY_IDENTIFIER_RECORD_ID NUMERIC No
Unique ID of the submitter corresponding to the donor facility that prepared this product specimen.
54 FACILITY_IDENTIFIER_RECORD_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
55 DESC_CODE_CSN_ID NUMERIC No
Stores the CSN of the product description code for this row.
56 ABO_PHENOTYPE_C_NAME VARCHAR No
Stores the ABO blood group type for a blood product specimen, as encoded by a Blood Groups barcode (I OVS 76010).
May contain organization-specific values: No
Category Entries:
A
B
AB
O
Bombay
Indeterminate
57 RHD_LAB_ANTIGEN_RESULT_C_NAME VARCHAR No
Stores the RhD type for a blood product specimen, as encoded by a Blood Groups barcode (I OVS 76010).
May contain organization-specific values: No
Category Entries:
Positive
Negative
Indeterminate