HSC_SPEC_INFO
Description:
This table holds the specimen details.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
This column holds the specimen record ID.
2 RECORD_NAME VARCHAR No
This column holds the system generated name for the specimen record.
3 RECORD_STATUS_C_NAME VARCHAR No
Stores the record status (hidden, soft-deleted, etc...).
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
4 SPECIMEN_TYPE_C_NAME VARCHAR No
This column is used to store type of specimen.
May contain organization-specific values: Yes
5 SPECIMEN_DESC VARCHAR No
This column stores a short description about the specimen that is being collected.
6 SPECIMEN_SOURCE_C_NAME VARCHAR No
This column is used to store source from where specimen is collected.
May contain organization-specific values: Yes
7 SPECIMEN_ID VARCHAR No
This column is used to store unique ID for the specimen.
8 COLL_BY_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
9 COLL_DATE DATETIME No
This column is used to store collection date for specimen.
10 COLL_TIME DATETIME (Local) No
This column is used to store collection time for specimen.
11 DEST_C_NAME VARCHAR No
This column is used to store destination where specimen was sent.
May contain organization-specific values: Yes
Category Entries:
Pathology
Microbiology
Cytology
Histology
Radiology
Chemistry
12 TRANSPORTED_BY_ID VARCHAR No
A free-text description of the method that transported the specimen.
13 PRIORITY_C_NAME VARCHAR No
This column stores the priority of the specimen when it is sent to the lab.
May contain organization-specific values: Yes
14 SENT_DATE DATETIME No
This column stores the date when the requisition was printed using the Specimens section and its copies.
15 SENT_TIME DATETIME (Local) No
This column stores the time when the requisition was printed using the Specimens section and its copies.
16 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
17 PAT_CSN NUMERIC No
This column stores the patient's contact serial number.
18 DELETE_REASON_C_NAME VARCHAR No
This column will hold the reason for deleting the specimen record.
May contain organization-specific values: Yes
Category Entries:
Documentation Error
Other
19 RECORD_CREATION_DT DATETIME No
Stores the date the record was created.
20 INSTANT_OF_UPD_TM DATETIME (Local) No
Stores the instant the record was last locked/unlocked.
21 FROZEN_YN VARCHAR No
Indicates if the specimen is frozen.
May contain organization-specific values: No
Category Entries:
No
Yes
22 SPEC_LABEL_PRT_DTTM DATETIME (Local) No
The most recent instant that a label was printed for the specimen. It is updated every time a label is printed for the specimen.
23 EPISODE_ID NUMERIC No
Stores Diagnose Behandel Combinatie (DBC) Episode linked to a specimen in DBC enabled environments.
24 MARKED_AS_SENT_DTTM DATETIME (Local) No
This is the instant that the specimen is marked as sent to Lab.
25 IN_FIXATIVE_DTTM DATETIME (UTC) No
Enter time when specimen was fixed in fixative (example:formalin). This is applicable only if specimen is indicated as fixed in fixative or fixed in formalin.
26 LOG_ID VARCHAR No
This item stores the surgical log where this specimen is collected and documented.
27 AUTHRZING_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
28 CLINICAL_IMPRESSION VARCHAR No
Free text clinical impressions for the specimen.
29 LATERALITY_C_NAME VARCHAR No
The category ID for the laterality of the specimen.
May contain organization-specific values: Yes
Category Entries:
Right
Left
Bilateral
Midline
Indeterminate
Both
Not applicable
Not Specified
Other
30 SPECIMEN_WEIGHT NUMERIC No
This column stores the specimen weight.
31 SPECIMEN_UNIT_C_NAME VARCHAR No
This item is used to indicate the unit corresponding to the specimen weight documented.
May contain organization-specific values: Yes
Category Entries:
Gram
Kilogram
Ounce
Pound
32 OTHER_REC_CREATE_WF_C_NAME VARCHAR No
Store workflows other than specimen navigator which created this record
May contain organization-specific values: No
Category Entries:
Integrated Laboratory System
Interfaced
33 SPECIMEN_SIZE NUMERIC No
This item is used to document the size of the specimen collected.
34 SPECIMEN_SIZE_UNIT_C_NAME VARCHAR No
This item is used to indicate the unit corresponding to the specimen size documented.
May contain organization-specific values: Yes
No Entries Defined
35 SOURCE_MODIFIER_C_NAME VARCHAR No
This item documents an additional modifier to the specimen's source.
May contain organization-specific values: Yes
36 CALCIFICATION_SPREADING INTEGER No
This column stores the spread of calcification in mm.
37 NUMBER_OF_TUMORS INTEGER No
This column stores the number of tumors.
38 TUMOR_1_DISTANCE_FROM_PAP INTEGER No
This column stores the distance of tumor 1 from the papilla in mm.
39 TUMOR_1_SIZE INTEGER No
This column stores the size of tumor 1 in mm.
40 TUMOR_2_DISTANCE_FROM_PAP INTEGER No
This column stores the distance of tumor 2 from the papilla in mm.
41 TUMOR_2_SIZE INTEGER No
This column stores the size of tumor 2 in mm.
42 TUMOR_3_DISTANCE_FROM_PAP INTEGER No
This column stores the distance of tumor 3 from the papilla in mm.
43 TUMOR_3_SIZE INTEGER No
This column stores the size of tumor 3 in mm.
44 TUMOR_4_DISTANCE_FROM_PAP INTEGER No
This column stores the distance of tumor 4 from the papilla in mm.
45 TUMOR_4_SIZE INTEGER No
This column stores the size of tumor 4 in mm.
46 TUMOR_5_DISTANCE_FROM_PAP INTEGER No
This column stores the distance of tumor 5 from the papilla in mm.
47 TUMOR_5_SIZE INTEGER No
This column stores the size of tumor 5 in mm.
48 SPECIMEN_VOLUME NUMERIC No
This column stores specimen volume.
49 SPECIFY_MATERIAL_FT VARCHAR No
This column stores the material that was removed.
50 ENDOSCOPIC_FINDINGS_FT VARCHAR No
This column stores the endoscopic findings of a specimen.
51 DISTANCE_TO_BORDER INTEGER No
This column stores the distance to the border, in mm.
52 MEDICAL_TREATMENT_FT VARCHAR No
This column stores the medical treatment needed if necessary.
53 SIZE_OF_TUM_ULTRASOUND INTEGER No
The size of the tumor in mm, discovered via ultrasound.
54 SIZE_OF_TUMOR_MAMMOGRAPHY INTEGER No
The size of the tumor in mm, discovered via mammography.
55 SPECIMEN_READING NUMERIC No
This item stores the radiologic reading for a specimen.
56 PRIORITY_DUE_UTC_DTTM DATETIME (UTC) No
Stores the due date and time for a specimen priority.
57 TOTAL_NUMBER_OF_CORES INTEGER No
For needle biopsy procedures, stores the total number of cores taken.
58 NUM_OF_CORES_W_CALCIFICATION INTEGER No
For needle biopsy procedures, stores the number of cores taken with calcification.
59 PROTOCOL_ID_STRING VARCHAR No
Stores a free text ID for research protocols.
60 ID_PREFIX VARCHAR No
Short name of the group that the specimen falls under (e.g. clinical, pathology, etc.).
61 USER_MOD_SPEC_ID_YN VARCHAR No
Flag that stores whether or not a user manually modified the specimen ID.
The category values for this column were already listed for column: FROZEN_YN
62 SPECIMEN_ORIENTATION_FREE_TEXT VARCHAR No
Stores the orientation of the specimen.
63 SPECIMEN_TISSUE_EXCISION_DTTM DATETIME (UTC) No
Stores when a specimen was excised.
64 SPECIMEN_NUMBER_OF_CONTAINERS INTEGER No
Stores the number of containers used for storing the specimen.
65 NEEDLE_GAUGE INTEGER No
Stores the gauge of the needle used when retrieving a specimen.
66 NUMBER_OF_PASSES INTEGER No
Stores the number of passes performed when retrieving a specimen.
67 NUMBER_OF_SLIDES INTEGER No
Stores the number of slides used when collecting a specimen.
68 REASON_FOR_VISIT VARCHAR No
Stores the reason for the patient visit as documented on a surgical specimen. This documentation is for reference only and does not update any diagnosis or problem list documentation.
69 DISTANCE_FROM_NIPPLE INTEGER No
Stores the distance from the nipple to the specimen collection site.
70 MAN_REL_TO_MYCHRT_YN VARCHAR No
This item indicates whether the order result of the specimen should be manually released to MyChart.
The category values for this column were already listed for column: FROZEN_YN
71 MATERIAL_SUPPLEMENTARY_DESC VARCHAR No
The supplementary description of the material.
72 PLACENTA_WEIGHT NUMERIC No
The weight of the placenta.
73 MEMBRANE_CONDITION VARCHAR No
The condition of the membrane.
74 MARKING_OF_UMBILICAL_CORD VARCHAR No
The marking of the umbilical cord.
75 GESTATIONAL_AGE_IN_WEEKS INTEGER No
The gestational age in weeks.
76 EXTERNAL_SPECIMEN_IDENT VARCHAR No
The external identifier for this specimen collection record.
77 SUGGESTED_SPECIMEN_SOURCE_C_NAME VARCHAR No
If the specimen was generated from a suggestion, the source that was suggested.
The category values for this column were already listed for column: SPECIMEN_SOURCE_C_NAME
78 SUGGESTED_SPECIMEN_TYPE_C_NAME VARCHAR No
If the specimen was generated from a suggestion, the type that was suggested.
The category values for this column were already listed for column: SPECIMEN_TYPE_C_NAME
79 SPECIMEN_TRANSPORT_UTC_DTTM DATETIME (UTC) No
This column stores the moment a specimen was picked up for transport as a date/time instant.
80 COLD_ISCHEMIA_DURATION INTEGER No
This column stores the time between specimen collection and fixation.
81 ASSOCIATED_PROC_ORDER_ID NUMERIC No
The ID of the order for the procedure that the specimen is associated with. This is expected to generally be the procedure during which the specimen was collected.