CASE_MGMT
Description:
The CASE_MGMT table is the master table for reporting on case data. This table includes foreign keys to other tables containing information about the case, such as employer, coverage, and diagnosis information.

Primary Key
Column Name Ordinal Position
CASE_ID 1

Column Information
Name Type Discontinued?
1 CASE_ID NUMERIC No
The unique ID assigned to the case record.
2 CASE_NAME VARCHAR No
The name of the case.
3 PAT_ID VARCHAR No
The unique ID of the patient linked to the case record.
4 CASE_TYPE_C_NAME VARCHAR No
The category value assigned to classify the case record and determine default case priorities.
May contain organization-specific values: Yes
5 CASE_STATUS_C_NAME VARCHAR No
The category value associated with the status of the case.
May contain organization-specific values: No
Category Entries:
New
Open
Re-Opened
Closed
6 PRIORITY_ID NUMERIC No
The unique ID of the priority record assigned to the case.
7 PRIORITY_ID_PRIORITY_NAME VARCHAR No
The name of the priority record.
8 MANAGER_USER_ID VARCHAR No
The unique ID of the user who is assigned this case.
9 MANAGER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 ROSTER_ID VARCHAR No
The unique ID of the roster to which this case belongs.
11 ROSTER_ID_ROSTER_NAME VARCHAR No
The name of the roster.
12 RAW_BD_ADJST NUMERIC No
The manual adjustment to the case’s total number of raw days.
13 CONV_BD_ADJST NUMERIC No
The manual adjustment to the case’s total number of converted days.
14 RAW_RFL_BD_TOT NUMERIC No
The sum of raw bed days for all the referrals linked to the case.
15 CONV_RFL_BD_TOT NUMERIC No
The sum of converted bed days for all the referrals linked to the case.
16 CASE_RAW_TOTAL NUMERIC No
The sum of raw bed days for all the referrals linked to the case and any adjustments entered for raw days.
17 TOTAL_COST_OF_CASE NUMERIC No
The dollar amount representing the sum of the claims, charges and adjustments linked to this case.
18 DATE_REPORTED DATETIME No
The date the accident was reported.
19 DAYS_OF_TREATMENT NUMERIC No
The number of days of treatment that the patient underwent as a result of the injury.
20 HOURS_ON_CASE NUMERIC No
The hours spent by the cost tracking manager on the case.
21 CARRIER_ID VARCHAR No
The unique ID of the carrier record linked to this case record.
22 CARRIER_ID_CARRIER_NAME VARCHAR No
The name of the carrier record.
23 EMPLOYER_ID VARCHAR No
This is the unique ID of the employer record linked to this case record if Patient Employer Linked Free Text or Linked to Employer(I EAF 6410) is set to 1. This is free text if I EAF 6410 is set to 2.
24 EMPLOYER_ID_EMPLOYER_NAME VARCHAR No
The name of the employer.
25 ACCIDENT_TYPE_C_NAME VARCHAR No
The category value assigned to the case record to explain the type of accident that resulted in the creation of this case.
May contain organization-specific values: Yes
26 INJURY_TYPE_C_NAME VARCHAR No
The category value assigned to the case record to explain the type of injury arising out of the accident.
May contain organization-specific values: Yes
27 INJURY_DATE DATETIME No
The date the patient was injured.
28 TREATMENT_DATE DATETIME No
The date the patient started treatment for the injury.
29 WORK_DAYS_MISSED FLOAT No
The number of days of work missed by the patient.
30 DISCHARGE_LOCATION VARCHAR No
The free text describing the location from which the patient is released after treatment.
31 CLASSIFIER_ID VARCHAR No
The unique ID of the classifier record that triggered the case creation message for this case.
32 CLASSIFIER_ID_CLASSIFIER_NAME VARCHAR No
The title of the classifier record.
33 TRG_DIAGNOSIS_ID_DX_NAME VARCHAR No
The name of the diagnosis.
34 TRG_DIAG_COMP_ID VARCHAR No
The unique ID of the diagnosis component record (if any) that triggered the case creation message for this case.
35 TRG_DIAG_COMP_ID_COMPONENT_NAME VARCHAR No
The name of the component
36 TRG_PROCEDURE_ID_PROC_NAME VARCHAR No
The name of each procedure.
37 TRG_PROC_COMP_ID VARCHAR No
The unique ID of the procedure component (if any) that triggered the case creation message for this case.
38 TRG_PROC_COMP_ID_COMPONENT_NAME VARCHAR No
The name of the component
39 TRG_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
40 TRG_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
41 LOB_ID VARCHAR No
The case line of business.
42 LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
43 TRG_MIN_AGE INTEGER No
The minimum age threshold set in the case classifier that generated the case create message for this case.
44 TRG_MAX_AGE INTEGER No
The maximum age threshold set in the case management classifier that generated the case create message for this case.
45 TRG_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.
46 TRG_SPEC_C_NAME VARCHAR No
The specialty of the provider (if any) that triggered the case creation message for this case.
May contain organization-specific values: Yes
47 TRG_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
48 TRG_LOB_ID VARCHAR No
The unique ID of the Line of Business (if any) that triggered the case creation message for this case.
49 TRG_LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
50 TRG_PRIM_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
51 ESCALATION_DATE DATETIME No
The escalation date of the case.
52 EOW_MESSAGE_ID VARCHAR No
The In Basket message ID for the case.
53 EOW_STATUS_C_NAME VARCHAR No
The In Basket message status for the case.
May contain organization-specific values: No
Category Entries:
No Message
Normal Due Message
Escalated Due Message
54 CASE_CONV_TOTAL INTEGER No
Case level converted bed days total.
55 TRG_REVCODE_ID NUMERIC No
Displays the revenue code matched in a case classifier, resulting in a case create In Basket message. The associated case was created from this In Basket message.
56 TRG_REVCODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
57 TRG_REV_COMP_ID VARCHAR No
Displays the revenue code component matched in a case classifier, resulting in a case created In Basket message. The associated case was created from this In Basket message.
58 TRG_REV_COMP_ID_COMPONENT_NAME VARCHAR No
The name of the component
59 TRG_COMPON_GRP_ID VARCHAR No
Specifies the trigger component group.
60 TRG_COMPON_GRP_ID_COMPONENT_GRP_NAME VARCHAR No
The name of the component group
61 TRG_ICD_PX_ID VARCHAR No
The unique ID of the ICD Procedure Code (if any) that triggered the case creation message for this case.
62 TRG_ICD_PX_ID_ICD_PX_NAME VARCHAR No
The name of the ICD procedure record.
63 TRG_APPLY_TO_C_NAME VARCHAR No
Specify whether this case should apply to referrals, AP claims or both. The default (blank value) is referrals.
May contain organization-specific values: No
Category Entries:
Referrals
AP Claims
Both Referrals and AP Claims
64 TRG_RFL_TYPE_C_NAME VARCHAR No
The type of referral (if any) that triggered the case creation message for this case.
May contain organization-specific values: Yes
65 TRG_DRG_ID VARCHAR No
The unique ID of the Diagnosis Related Group (DRG) code (if any) that triggered the case creation message for this case.
66 TRG_DRG_ID_DRG_NAME VARCHAR No
The name of the Diagnoses Related Group name.
67 TRG_DRG_COMP_ID VARCHAR No
The unique ID of the Diagnosis Related Group (DRG) component (if any) that triggered the case creation message for this case.
68 TRG_DRG_COMP_ID_COMPONENT_NAME VARCHAR No
The name of the component
69 TRG_CVG_PRIM_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
70 TIME_OF_TREATMENT_TM DATETIME (Local) No
Holds the time of treatment for accident information.
71 WORK_COMP_CLAIM_NUM VARCHAR No
Workers' compensation claim number associated with the case.
72 WORK_COMP_CARRIER VARCHAR No
Workers' compensation carrier associated with the case.
73 TPA_ADMINISTRATOR VARCHAR No
Name of the third party administrator.