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.