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

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

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

CPD-SEQ                Numeric 3                                 CXCP.1  WH130
Element: Sequence NumbeThis field contains the record sequence   WH132   WH190
                       number.                                   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                                   CXCP.1  WH130
Element: Diag Type     The diagnostic type is the first of two   WH132   WH190
                       fields that uniquely identify a           WH222   WH30.1
                       diagnosis. The diagnostic type may be     WH30.2  WH30.3
                       used to define different systems of       WH30.4  WH31.1
                       diagnosis identification.                 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                                   CXCP.1  WH130
Element: Diag Code     The diagnostic code is the second of      WH132   WH190
                       two fields that uniquely identify a       WH222   WH30.1
                       diagnosis. The diagnostic code is an      WH30.2  WH30.3
                       identifier for a specific diagnosis       WH30.4  WH31.1
                       within a diagnostic type.                 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                                CXCP.1  WH130
Element: Relative Wghts                                          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                                CXCP.1  WH130
Element: Arithmetic Los                                          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                                CXCP.1  WH130
Element: Arithmetic Los                                          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                                 CXCP.1  WH130
Element: Outlier                                                 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 15.2                               CXCP.1  WH130
Element: Exchange Rate                                           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)                    CXCP.1  WH130
Element: Discount                                                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                                                CXCP.1  WH130
          REQ-LOCATION                                           WH132   WH190
          CASE                                                   WH222   WH30.1
          SEQ                                                    WH30.2  WH30.3
          DIAG-TYPE                                              WH30.4  WH31.1
          DIAG-CODE                                              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