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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CDISET1DIAG-TYPE, DIAG-CODEPrimaryCX03.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)