Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXPREFDIAG


                            CXPREFDIAG FILE

                         Preference Diagnostics

The Preference Diagnostics file contains the diagnostic codes associated with
a case preference list. These codes define the diagnosis for each preference
list. The Case Carts system uses this file to store diagnostic codes defined
for a case preference. This file contains all diagnostics originating from any
preference templates assigned to a case plus updates made to the case
diagnostic data.

Use CX20.3 (Preference List Diagnosis Edit) to assign or update a diagnosis
on a preference list. Also, use CX20.3 to delete records from the preference
list (and thereby from this file). You cannot delete diagnostic codes when the
case status is 4 (Charges Passed) or 5 (No Charges).

UPDATED BY

BL92.1    CXCP.1    WH130     WH132     WH190     WH222
WH30.1    WH30.2    WH30.3    WH30.4    WH31.1    WH31.2
WH31.3    WH31.4    WH32.1    WH32.2    WH32.3    WH32.4
WH33.5    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CPD-COMPANY            Numeric 4                                 BL92.1  CXCP.1
Element: Company       This field contains the company number.   WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-REQ-LOCATION       Alpha 5                                   BL92.1  CXCP.1
Element: Req Location  This field contains the location          WH130   WH132
                       requisitioning items and to be charged    WH190   WH222
                       for the items. This location can be an    WH30.1  WH30.2
                       inventory or noninventory location.       WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                       This value appears as the to location     WH31.3  WH31.4
                       on pick lists printed when you run CX100  WH32.1  WH32.2
                       (Pick  List Print) and WH130 (Pick List   WH32.3  WH32.4
                       Print).                                   WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                       Valid values are                          WH34.4  WH40.1
                                                                 WH40.2  WH520
                       A requesting location defined in RQ01.1   WH830
                       (Requesting Location) for the specified
                       healthcare company.

CPD-CASE               Alpha 15                                  BL92.1  CXCP.1
Element: Case          This field contains the unique            WH130   WH132
                       identifier for the case.                  WH190   WH222
                                                                 WH30.1  WH30.2
                       A case is a record of the                 WH30.3  WH30.4
                       practitioners, preference lists, and      WH31.1  WH31.2
                       associated information assigned to a      WH31.3  WH31.4
                       specific patient visit.                   WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                       The Case Carts system uses this number    WH33.5  WH34.1
                       to interface with an outside scheduling   WH34.2  WH34.3
                       system.                                   WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-SEQ                Numeric 3                                 BL92.1  CXCP.1
Element: Seq           This field contains the record sequence   WH130   WH132
                       number.                                   WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-DIAG-TYPE          Alpha 8                                   BL92.1  CXCP.1
Element: Diag Type     The diagnostic type is the first of two   WH130   WH132
                       fields that uniquely identify a           WH190   WH222
                       diagnosis. The diagnostic type may be     WH30.1  WH30.2
                       used to define different systems of       WH30.3  WH30.4
                       diagnosis identification.                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-DIAG-CODE          Alpha 6                                   BL92.1  CXCP.1
Element: Diag Code     The diagnostic code is the second of      WH130   WH132
                       two fields that uniquely identify a       WH190   WH222
                       diagnosis. The diagnostic code is an      WH30.1  WH30.2
                       identifier for a specific diagnosis       WH30.3  WH30.4
                       within a diagnostic type.                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-DIAG-DESC          Alpha 250  (Lower Case)
Element: Diag Desc

CPD-RELATIVE-WGHTS     Signed 8.4                                BL92.1  CXCP.1
Element: Relative Wghts                                          WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-GEOMETRIC-LOS      Signed 5.2                                BL92.1  CXCP.1
Element: Arithmetic Los                                          WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-ARITHMETIC-LOS     Signed 5.2                                BL92.1  CXCP.1
Element: Arithmetic Los                                          WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-OUTLIER            Numeric 2                                 BL92.1  CXCP.1
Element: Outlier                                                 WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-BASE-RATE          Signed 18.2                               BL92.1  CXCP.1
Element: Intl Amt                                                WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPD-DISCOUNT           Percent 2.0  (Percent)                    BL92.1  CXCP.1
Element: Discount                                                WH130   WH132
                                                                 WH190   WH222
                                                                 WH30.1  WH30.2
                                                                 WH30.3  WH30.4
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

                         CXPREFDIAG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CPDSET1   COMPANY                                                BL92.1  CXCP.1
          REQ-LOCATION                                           WH130   WH132
          CASE                                                   WH190   WH222
          SEQ                                                    WH30.1  WH30.2
          DIAG-TYPE                                              WH30.3  WH30.4
          DIAG-CODE                                              WH31.1  WH31.2
                                                                 WH31.3  WH31.4
                                                                 WH32.1  WH32.2
                                                                 WH32.3  WH32.4
                                                                 WH33.5  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4  WH40.1
                                                                 WH40.2  WH520
                                                                 WH830

CPDSET2   COMPANY
          REQ-LOCATION
          DIAG-TYPE
          DIAG-CODE
          CASE
          SEQ

CPDSET3   COMPANY
          DIAG-TYPE
          DIAG-CODE
          REQ-LOCATION
          SEQ
          CASE

                         CXPREFDIAG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cccasepref     CXCASEPREF   Required

                            CPD-COMPANY         -> CXP-COMPANY  (CXPSET1)
                            CPD-REQ-LOCATION    -> CXP-REQ-LOCATION
                            CPD-CASE            -> CXP-CASE
                            CPD-SEQ             -> CXP-SEQ

Ccdiagnost     CXDIAGNOST   Required

                            CPD-DIAG-TYPE       -> CDI-DIAG-TYPE
                            CPD-DIAG-CODE       -> CDI-DIAG-CODE