Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            CXDIAGNOST FILE

                         Case Cart Diagnostics

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.

REFERENCED BY

BL92.1    CX05.1    CX05.2    CX100     CX20.1    CX20.2
CX20.3    CX20.4    CX20.5    CX207     CX220     CX235
CX30.1    CX300     CX506     CX805     CXA2.1    CXA3.1
CXCP.1    OE114     WH130     WH132     WH190     WH222
WH30.1    WH30.2    WH30.3    WH31.1    WH31.2    WH31.3
WH32.1    WH32.2    WH32.3    WH33.5    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

CX03.1    CX503

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CDI-DIAG-TYPE        Alpha 8                                     CX03.1  CX503
Diagnostic Type      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.

CDI-DIAG-CODE        Alpha 6                                     CX03.1  CX503
Diagnostic Code      The 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.

CDI-DIAG-DESC        Alpha 250  (Lower Case)                     CX03.1  CX503
Description          This field contains the description of
                     the diagnosis.

CDI-RELATIVE-WGHTS   Signed 8.4                                  CX03.1  CX503
Relative Weight      This 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.

CDI-GEOMETRIC-LOS    Signed 5.2                                  CX03.1  CX503
Geometric Mean       This field contains the geometric mean
Length of Stay       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.

CDI-ARITHMETIC-LOS   Signed 5.2                                  CX03.1  CX503
Arithmetic Length    This value is the arithmetic mean
of Stay              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.

CDI-OUTLIER          Numeric 2                                   CX03.1  CX503
Outlier              This value is the length of stay that
                     triggers a reimbursement exception.
                     The Health Care Financing
                     Administration (HCFA) or another insurer
                     provides this value.

CDI-STATUS           Numeric 1                                   CX503
Status               This value is the transaction status.
                     0 = Active
                     1 = Inactive

CDI-DIAG-DESC50      Derived
Description          This field contains the Diagnostic
                     description.

                         CXDIAGNOST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CDISET1   DIAG-TYPE     This index is used to access the Case    BL92.1  CX03.1
          DIAG-CODE     Cart Diagnostics file records in         CX05.1  CX05.2
                        Diagnostic Type followed by Diagnostic   CX100   CX20.1
                        Code order.                              CX20.2  CX20.3
                                                                 CX20.4  CX20.5
                                                                 CX207   CX220
                                                                 CX235   CX30.1
                                                                 CX300   CX503
                                                                 CX506   CX805
                                                                 CXA2.1  CXA3.1
                                                                 CXCP.1  OE114
                                                                 WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH31.1
                                                                 ...