Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            CXCPIUAVAL FILE

                      Case Cart Case User Analysis

This file stores the user analysis values defined for patient cases. The
values represent information your organization can use to measure
profitability. Data is written to this file as you add or maintain items on
patient cases. After you release the transactions in the Case Carts system,
complete the Strategic Ledger processing cycle to analyze profitability. For
additional information on user analysis values, see the Strategic Ledger
Procedures Manual.

REFERENCED BY

PO100

UPDATED BY

BL92.1    CX100     CX20.1    CX20.2    CX20.4    CX20.5
CX220     CX30.1    CX300     CX506     CXCP.1    OE114
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE830     OE950     PO31.1    RQ35.1
WH130     WH132     WH190     WH20.7    WH222     WH30.1
WH30.2    WH30.3    WH31.1    WH31.2    WH31.3    WH32.1
WH32.2    WH32.3    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830
WO132     WO140

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CXV-COMPANY          Numeric 4                                   BL92.1  CX100
Company              The company number represents an            CX20.1  CX20.2
                     established company and is entered on       CX20.4  CX20.5
                     all function codes.                         CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO31.1  RQ35.1
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

CXV-REQ-LOCATION     Alpha 5                                     BL92.1  CX100
Requesting Location  The location requisitioning items.          CX20.1  CX20.2
                     This location can be an inventory or        CX20.4  CX20.5
                     noninventory location.                      CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO31.1  RQ35.1
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

CXV-CASE             Alpha 10                                    BL92.1  CX100
Case                 This field contains the unique,             CX20.1  CX20.2
                     user-assigned identifier for the case.      CX20.4  CX20.5
                     A case identifier is used in the Case       CX220   CX30.1
                     Carts system to associate specific          CX300   CX506
                     tasks, practitioners, preference lists,     CXCP.1  OE114
                     and other information with a particular     OE30.1  OE30.2
                     treatment course. This treatment course     OE30.3  OE30.4
                     may consist of one or more procedures.      OE30.5  OE30.6
                     The Case Carts system uses the case         OE30.7  OE30.9
                     number to interface with an outside         OE830   OE950
                     scheduling system.                          PO31.1  RQ35.1
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

CXV-SEQ              Numeric 3                                   BL92.1  CX100
Sequence             This field contains the record sequence     CX20.1  CX20.2
                     number.                                     CX20.4  CX20.5
                                                                 CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO31.1  RQ35.1
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

CXV-LINE-NBR         Numeric 6                                   BL92.1  CX100
Line Nbr             This field contains the line number.        CX20.1  CX20.2
                                                                 CX20.4  CX20.5
                                                                 CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO31.1  RQ35.1
                                                                 WH130   WH132
                                                                 WH190   WH20.7
                                                                 WH222   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH31.1  WH31.2
                                                                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

CXV-SEGMENT-BLOCK    Alpha 103                                   BL92.1  CX100
Segment Block        This field identifies the user analysis     CX20.1  CX20.2
                     values included in the transaction.         CX20.4  CX20.5
                                                                 CX220   CX30.1
                     You can either type up to four values       CX300   CX506
                     or use Define (F6) to open the User         CXCP.1  OE114
                     Analysis Entry subform. Use this subform    OE30.1  OE30.2
                     to select the user analysis values you      OE30.3  OE30.4
                     want to include in the transaction. If      OE30.5  OE30.6
                     you choose to type values, use commas to    OE30.7  OE30.9
                     separate them. For example:                 OE830   OE950
                     value1,value2,value3,value4                 PO31.1  RQ35.1
                                                                 WH130   WH132
                     There are three conditions that affect      WH190   WH20.7
                     how you can select user analysis values.    WH222   WH30.1
                     See the User Analysis Entry form help or    WH30.2  WH30.3
                     the Strategic Ledger procedures manual      WH31.1  WH31.2
                     for additional information.                 WH31.3  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830
                                                                 WO132   WO140

                         CXCPIUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CXVSET1   COMPANY                                                BL92.1  CX100
          REQ-LOCATION                                           CX20.1  CX20.2
          CASE                                                   CX20.4  CX20.5
          SEQ                                                    CX220   CX30.1
          LINE-NBR                                               CX300   CX506
                                                                 CXCP.1  OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE830   OE950
                                                                 PO100   PO31.1
                                                                 RQ35.1  WH130
                                                                 WH132   WH190
                                                                 WH20.7  WH222
                                                                 ...