SPECIMEN_TRACKING

Description:

Contains the post resulted tracking information about specimens.

Primary Key

Column Name	Ordinal Position
SPECIMEN_RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SPECIMEN_RECORD_ID	NUMERIC	No
	The unique identifier for the finding record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	TRACKING_STATUS_C_NAME	VARCHAR	No
	Contains the current status for tracking a specimen after it's been resulted. May contain organization-specific values: Yes Category Entries: No Treatment Required Patient/Caregiver Needs to be Contacted Patient/Caregiver Informed Schedule Follow-up Schedule Procedure Refer Mohs/Surgeon Follow-up Arranged Treatment Complete Unable to Contact Patient Patient Refused Refer for Excision Refer to Resident Surgery Clinic Refer to Other Specialties Awaiting Additional Workup
4	TRACKING_COMP_C_NAME	VARCHAR	No
	Stores whether this specimen is considered complete with respect to tracking after the specimen is resulted. May contain organization-specific values: No Category Entries: Completed Not Tracked
5	POST_RESULT_DX_C_NAME	VARCHAR	No
	Contains the diagnosis used for tracking purposes after the specimen has been resulted. Not to be used as a clinical diagnosis. May contain organization-specific values: Yes Category Entries: BCC BCC, Superficial SCC SCC in Situ Melanoma Melanoma in Situ Other Skin Cancer Other Malignant Neoplasm Atypical Nevus - Mild Atypical Nevus - Moderate Atypical Nevus - Severe Actinic Keratosis Other Benign Neoplasm Other Skin Eruption Neoplasm of Uncertain Behavior Other
6	TRACKING_DESC_ID	VARCHAR	No
	Contains the a summary/comment about the specimen tracking done after the specimen has been resulted.
7	TRACK_ORD_ID	NUMERIC	No
	The order that the tracking data relates to. This is a virtual item linked to other rows containing the same information.