LAB_CASE_DB_MAIN

Description:

The main table for Lab Anatomic Pathology cases. It contains mostly items that do not change much over time.

Primary Key

Column Name	Ordinal Position
CASE_ID	1

Column Information

	Name	Type	Discontinued?
1	CASE_ID	NUMERIC	No
	The unique identifier for the case record.
2	CASE_ACCESSION_DTTM	DATETIME (Local)	No
	The instant that the case was accessioned. Currently, 'accessioned' means the time when the case is first accepted in Case Builder.
3	CASE_RECEIVED_DTTM	DATETIME (Local)	No
	The instant that the case was received. This is equivalent to the instant when the first specimen on the case was received.
4	CASE_OVERDUE_DTTM	DATETIME (Local)	No
	The instant when the case is considered overdue. This is equivalent to the Case Accession Instant plus the Case Expected Length.
5	CASE_GROUPER_ID	NUMERIC	No
	Stores the Requisition Grouper record ID that this case is linked to.
6	CASE_PAT_CONTACT	VARCHAR	No
	Stores the patient contact that this case is linked to.
7	CASE_LAB_ID	VARCHAR	No
	Stores the laboratory associated with this case.
8	DATE_ENTR_DT	DATETIME	No
	Stores the date the case was created.
9	CASE_COLL_DTTM	DATETIME (Local)	No
	The date and time when the case was first collected.
10	CASE_SIGNOUT_DTTM	DATETIME (Local)	No
	The date and time when the case was completely signed out.
11	CONTAINER_ID	VARCHAR	No
	The unique identifier of the tracking container associated with this case record.
12	CASE_TASK_ADD_DTTM	DATETIME (Local)	No
	The latest date and time when a task was added to the case.
13	INSTANT_PAT_ASSOC_UTC_DTTM	DATETIME (UTC)	No
	The date and time when the patient was associated with the case.
14	CASE_SUBSPECIALTY_C_NAME	VARCHAR	No
	The subspecialty category identifier for the case. May contain organization-specific values: Yes
15	LAST_TASK_ADDED_UTC_DTTM	DATETIME (UTC)	No
	The last date and time in UTC that a task was added to this case.
16	CASE_ACCESSION_UTC_DTTM	DATETIME (UTC)	No
	The date and time that the case was accessioned, in UTC