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