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    OE114     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.   OE114   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: To Location   This field contains the location          OE114   WH130
                       requisitioning items and to be charged    WH132   WH190
                       for the items. This location can be an    WH222   WH30.1
                       inventory or noninventory location.       WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                       This value appears as the to location     WH31.2  WH31.3
                       on pick lists printed when you run CX100  WH31.4  WH32.1
                       (Pick  List Print) and WH130 (Pick List   WH32.2  WH32.3
                       Print).                                   WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                       Valid values are                          WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                       A requesting location defined in RQ01.1   WH520   WH830
                       (Requesting Location) for the specified
                       healthcare company.

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

CPD-SEQ                Numeric 3                                 BL92.1  CXCP.1
Element: Sequence NumbeThis field contains the record sequence   OE114   WH130
                       number.                                   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-DIAG-TYPE          Alpha 8                                   BL92.1  CXCP.1
Element: Diag Type     The diagnostic type is the first of two   OE114   WH130
                       fields that uniquely identify a           WH132   WH190
                       diagnosis. The diagnostic type may be     WH222   WH30.1
                       used to define different systems of       WH30.2  WH30.3
                       diagnosis identification.                 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-CODE          Alpha 6                                   BL92.1  CXCP.1
Element: Diag Code     The diagnostic code is the second of      OE114   WH130
                       two fields that uniquely identify a       WH132   WH190
                       diagnosis. The diagnostic code is an      WH222   WH30.1
                       identifier for a specific diagnosis       WH30.2  WH30.3
                       within a diagnostic type.                 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-DESC          Alpha 250  (Lower Case)
Element: Diag Desc

CPD-RELATIVE-WGHTS     Signed 8.4                                BL92.1  CXCP.1
Element: Relative Wghts                                          OE114   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                                          OE114   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                                          OE114   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                                                 OE114   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                                                OE114   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                                                OE114   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                                           OE114   WH130
          CASE                                                   WH132   WH190
          SEQ                                                    WH222   WH30.1
          DIAG-TYPE                                              WH30.2  WH30.3
          DIAG-CODE                                              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

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

CPDSET3   COMPANY       This index is used by CX207 (Preference
          DIAG-TYPE     List Comparison) to search for case
          DIAG-CODE     preference lists based on company,
          REQ-LOCATION  requesting location (optional),
          SEQ           diagnostic type, and  diagnostic code.
          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