|
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_LAB_NAME |
VARCHAR |
No |
|
|
|
The name of the lab record. |
|
|
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 |
|
|
17 |
PRIMARY_SPECIMEN_ID |
VARCHAR |
No |
|
|
|
The unique ID of the primary specimen on the case. |
|
|
18 |
SERVICE_LINE_PROVIDERTEAM_ID |
NUMERIC |
No |
|
|
|
The unique ID of the provider team which represents the service line assigned to the case. |
|
|
19 |
SERVICE_LINE_PROVIDERTEAM_ID_RECORD_NAME |
VARCHAR |
No |
|
|
|
|
20 |
PRIM_SPEC_OVRIDE_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who overrode the primary specimen of this case. This column is frequently used to link to the CLARITY_EMP table. |
|
|
21 |
PRIM_SPEC_OVRIDE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
22 |
PRIM_SPEC_OVRIDE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
UTC date and time of when the primary specimen was overridden by the user |
|
|
23 |
CTZN_OVRIDE_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who overrode the categorization of this case. This column is frequently used to link to the CLARITY_EMP table. |
|
|
24 |
CTZN_OVRIDE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
25 |
CTZN_OVRIDE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
UTC date and time of when either the subspecialty or service categorization of the case were overridden |
|
|