CXDIAGNOST – Case Cart Diagnostics

System
Case Carts (CX)
Prefix
CDI
Primary key
DIAG-TYPE, DIAG-CODE
Fields
9
Updated by
2 programs
Referenced by
42 programs

CXDIAGNOST is the Case Cart Diagnostics table in Lawson Case Carts (prefix CDI). It is indexed by DIAG-TYPE, DIAG-CODE (CDISET1). It is updated by CX03.1 and CX503 and referenced by CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.3, CX20.4, CX20.5 and 34 more. The table has 9 fields, 1 index and 0 documented relations.

About CXDIAGNOST

The Case Cart Diagnostic file primarily stores all valid diagnostic codes. Before anyone can use the codes on preference templates or cases, the codes must be in this file. Before you set up this file, you must decide what diagnostic types you want to define. The diagnostic type is the first of two fields used to uniquely identify a diagnosis. The diagnostic type is used to identify different coding systems such as HCPCS (HCFA's (Health Care Financing Administration's) Common Procedure Coding System), CPT-4 (Current Procedural Terminology, 1994), ICD-9 (International Classification of Diseases, 9th Revision), and a code for your organization's own coding system. Use CX03.1 (Diagnostics) to add, delete, or change records in this file. The Case Carts system uses diagnostic codes to assign and validate diagnostic codes on preference templates and cases. In addition, form CX235 (Procedure Cost Vs DRG) uses the codes for reimbursement calculations. The Case Carts system uses the diagnostic code descriptions in all reporting and all applicable forms.

Fields (9)

Column = COBOL field name without the CDI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CDI-DIAG-TYPE PK
DIAG_TYPE		Alpha 8The diagnostic type is the first of two fields used to uniquely identify a diagnosis. The diagnostic type is used to identify different coding systems such as HCPCS (HCFA's (Health Care Financing Administration's) Common Procedure Coding System), CPT-4 (Current Procedural Terminology, 1994), ICD-9 (International Classification of Diseases, 9th Revision), and a code for your organization's own coding system.CX03.1, CX503
#CDI-DIAG-CODE PK
DIAG_CODE		Alpha 6The diagnostic code is the second of two fields that uniquely identify a diagnosis. The diagnostic code is an identifier for a specific diagnosis within a diagnostic type. Diagnostic codes can come from many sources such as HCPCS (HCFA's (Health Care Financing Administration's) Common Procedure Coding System), CPT-4 (Current Procedural Terminology, 1994), ICD-9 (International Classification of Diseases, 9th Revision), and a code for your organization's own coding system.CX03.1, CX503
#CDI-DIAG-DESC
DIAG_DESC		Alpha 250 (Lower Case)This field contains the description of the diagnosis.CX03.1, CX503
#CDI-RELATIVE-WGHTS
RELATIVE_WGHTS		Signed 8.4This field contains the relative weight. Relative weight is a multiplier used to calculate the reimbursement for treating a diagnosis. The higher the relative weight, the greater the payment to the hospital.CX03.1, CX503
#CDI-GEOMETRIC-LOS
GEOMETRIC_LOS		Signed 5.2This field contains the geometric mean length of stay (GMLOS), when applicable. The GMLOS is a measure for the central tendency of nationally reported lengths of stay for a specific diagnostic-related group. A company compares its length of stay results with this value for monitoring purposes.CX03.1, CX503
#CDI-ARITHMETIC-LOS
ARITHMETIC_LOS		Signed 5.2This value is the arithmetic mean length of stay (AMLOS). AMLOS is the average number of days patients assigned a given diagnostic code stay in the hospital (also referred to as the average length of stay). Practitioners can try to get the lowest patient length of stay (LOS), using the AMLOS as a guide.CX03.1, CX503
#CDI-OUTLIER
OUTLIER		Numeric 2This value is the length of stay that triggers a reimbursement exception. The Health Care Financing Administration (HCFA) or another insurer provides this value.CX03.1, CX503
#CDI-STATUS
STATUS		Numeric 1This value is the transaction status.
  • 0 Active
  • 1 Inactive
CX503
#CDI-DIAG-DESC50
DIAG_DESC50		DerivedThis field contains the Diagnostic description.—

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CDISET1
  1. DIAG-TYPE
  2. DIAG-CODE
PrimaryCX03.1, CX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.3, CX20.4 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (42)