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: Default HLA phenotyped HPA phenotyped IgA deficient RBC phenotyped RBC antibody(ies) present RBC antibody absent Specific antibody present CMV seronegative CMV seropositive HLA antibody(ies) present HLA antibody absent HPA antibody(ies) present HPA antibody absent HLA phenotyped; HPA phenotyped HLA phenotyped; IgA deficient HLA phenotyped; RBC phenotyped HLA phenotyped; RBC antibody(ies) present HLA phenotyped; RBC antibody absent HLA phenotyped; CMV seropositive HLA phenotyped; CMV seronegative HLA phenotyped; HLA antibody(ies) present HLA phenotyped; HLA antibody absent HLA phenotyped; HPA antibody(ies) present HLA phenotyped; HPA antibody absent HLA phenotyped; HPA phenotyped; RBC phenotyped HLA phenotyped; HPA phenotyped; RBC phenotyped; CMV seronegative HLA phenotyped; HPA phenotyped; RBC phenotyped; CMV seropositive HLA antibody(ies) present; HPA phenotyped HLA phenotyped; RBC phenotyped; RBC antibody absent HLA phenotyped; HLA antibody absent; RBC phenotyped HLA phenotyped; HLA antibody absent; RBC phenotyped; CMV seronegative HPA phenotyped; IgA deficient HPA phenotyped; RBC phenotyped HPA phenotyped; RBC antibody(ies) present HPA phenotyped; RBC antibody absent HPA phenotyped; CMV seronegative HPA phenotyped; CMV seropositive HLA phenotyped; RBC phenotyped; RBC antibody(ies) present HLA antibody absent; HPA phenotyped HPA phenotyped; HPA antibody(ies) present HPA phenotyped; HPA antibody absent RBC phenotyped; IgA deficient IgA deficient; CMV seronegative IgA deficient; CMV seropositive RBC phenotyped; RBC antibody(ies) present RBC phenotyped; RBC antibody absent RBC phenotyped; Specific antibody present RBC phenotyped; CMV seronegative RBC phenotyped; CMV seropositive HLA antibody(ies) present; RBC phenotyped HLA antibody absent; RBC phenotyped HPA antibody(ies) present; RBC phenotyped HPA antibody absent; RBC phenotyped RBC phenotyped; RBC antibody absent; CMV seronegative RBC phenotyped; RBC antibody absent; CMV seropositive HLA antibody absent; RBC phenotyped; RBC antibody absent; CMV seronegative HLA antibody absent; RBC phenotyped; RBC antibody absent; CMV seropositive HLA antibody absent; HPA antibody absent; RBC phenotyped; RBC antibody absent; CMV seronegative HLA antibody absent; HPA antibody absent; RBC phenotyped; RBC antibody absent; CMV seropositive RBC antibody(ies) present; Specific antibody(ies) present RBC antibody(ies) present; CMV seronegative RBC antibody(ies) present; CMV seropositive HLA antibody(ies) present; RBC antibody(ies) present HLA antibody absent; RBC antibody(ies) present HPA antibody(ies) present; RBC antibody(ies) present HPA antibody absent; RBC antibody(ies) present RBC antibody absent; Specific antibody present RBC antibody absent; CMV seronegative RBC antibody absent; CMV seropositive HLA antibody(ies) present; RBC antibody absent HLA antibody absent; RBC antibody absent HPA antibody(ies) present; RBC antibody absent HPA antibody absent; RBC antibody absent CMV seronegative; Specific antibody present CMV seropositive; Specific antibody present HLA antibody(ies) present; Specific antibody present HLA antibody absent; Specific antibody present HPA antibody(ies) present; Specific antibody present HPA antibody absent; Specific antibody present HLA antibody(ies) present; CMV seronegative HLA antibody absent; CMV seronegative HPA antibody(ies) present; CMV seronegative HPA antibody absent; CMV seronegative HLA antibody(ies) present; CMV seropositive HLA antibody absent; CMV seropositive HPA antibody(ies) present; CMV seropositive HPA antibody absent; CMV seropositive HLA antibody(ies) present; HPA antibody(ies) present HLA antibody(ies) present; HPA antibody absent HLA antibody absent; HPA antibody(ies) present HLA antibody absent; HPA antibody absent Anti-D present HAV antibody present HBV antibody present Tetanus antibody present Varicella Zoster antibody present Hemoglobin S negative CMV seronegative; Hemoglobin S negative Aspirin free High titer antibody to either the A or B antigens present High titer antibody to A antigen present High titer antibody to B antigen present CMV seronegative; High titer antibody to either the A or B antigens present CMV seronegative; High titer antibody to A antigen present CMV seronegative; High titer antibody to B antigen present Hemoglobin S positive CMV seronegative; Hemoglobin S positive CMV seropositive; Hemoglobin S positive CMV seropositive; Hemoglobin S negative CMV seronegative and product meets additional nationally specified requirements for pediatric use No high titer antibody to B antigen detected No high titer antibody to A antigen detected Parvovirus B19 seropositive HLA phenotyped; Parvovirus B19 seropositive No high titer antibody to either the A or B antigens detected Investigational test(s) CMV seronegative; Investigational test(s) Test for Zika virus negative CMV seronegative; Test for Zika virus negative Hemoglobin S negative; Test for Zika virus negative CMV seronegative; Hemoglobin S negative; Test for Zika virus negative High titer antibody to either the A or B antigens present; Test for Zika virus negative CMV seronegative; High titer antibody to either the A or B antigens present; Test for Zika virus negative No high titer antibody to either the A or B antigens detected; CMV seronegative; Test for Zika virus negative CMV seronegative; No high titer antibody to either the A or B antigens detected RBCs CMV seronegative; Plasma not tested for CMV SARS-CoV-2 antibody present High titer for SARS-CoV-2 antibody Low titer for SARS-CoV-2 antibody The D antigen is maybe not detectable by routine testing CMV seronegative; No high titer antibody to B antigen detected CMV seronegative; No high titer antibody to A antigen detected
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
58	PRODUCT_STATUS_C_NAME	VARCHAR	No
	Contains the status of a product specimen May contain organization-specific values: No Category Entries: Expected Pending Available Not Available
59	SPEC_CUMULATIVE_VOLUME	INTEGER	No
	The cumulative volume of all containers on the specimen, in milliliters
60	DEST_EPT_PAT_ID	VARCHAR	No
	The unique ID of the patient record this product is destined to be administered to, regardless of whether or not the administration has happened yet
61	DEST_REQ_GROUPER_ID	NUMERIC	No
	The unique ID of the grouper this product is destined to be administered to, regardless of whether or not the administration has happened yet