Lawson Insight Technical Documentation


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).

REFERENCED BY

CX235     CXA3.1

UPDATED BY

BL92.1    CX100     CX20.1    CX20.2    CX20.3    CX20.4
CX20.5    CX220     CX30.1    CX300     CX506     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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CPD-COMPANY          Numeric 4                                   BL92.1  CX100
Company              This field contains the company number.     CX20.1  CX20.2
                                                                 CX20.3  CX20.4
                                                                 CX20.5  CX220
                                                                 CX30.1  CX300
                                                                 CX506   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

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

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

CPD-SEQ              Numeric 3                                   BL92.1  CX100
Sequence             This field contains the record sequence     CX20.1  CX20.2
                     number.                                     CX20.3  CX20.4
                                                                 CX20.5  CX220
                                                                 CX30.1  CX300
                                                                 CX506   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

CPD-DIAG-TYPE        Alpha 8                                     BL92.1  CX100
Diagnostic Type      The diagnostic type is the first of two     CX20.1  CX20.2
                     fields that uniquely identify a             CX20.3  CX20.4
                     diagnosis. The diagnostic type may be       CX20.5  CX220
                     used to define different systems of         CX30.1  CX300
                     diagnosis identification.                   CX506   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

CPD-DIAG-CODE        Alpha 6                                     BL92.1  CX100
Diagnostic Code      The diagnostic code is the second of        CX20.1  CX20.2
                     two fields that uniquely identify a         CX20.3  CX20.4
                     diagnosis. The diagnostic code is an        CX20.5  CX220
                     identifier for a specific diagnosis         CX30.1  CX300
                     within a diagnostic type.                   CX506   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

                         CXPREFDIAG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CPDSET1   COMPANY                                                BL92.1  CX100
          REQ-LOCATION                                           CX20.1  CX20.2
          CASE                                                   CX20.3  CX20.4
          SEQ                                                    CX20.5  CX220
          DIAG-TYPE                                              CX235   CX30.1
          DIAG-CODE                                              CX300   CX506
                                                                 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
                                                                 ...

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),
                        diagnostic type, and  diagnostic code.
                        Duplicates

                         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