Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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
To Location          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
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
Sequence Number      This 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
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
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)
Diag Desc

CPD-RELATIVE-WGHTS   Signed 8.4                                  CXCP.1  WH130
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
Geometric 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
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
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
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
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