Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            CXCPIUAVAL FILE

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.

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    CXCP.1    IC28.1    MA180     MA43.9    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.3
MA67.1    MA67.2    MA70.1    MAI1.1    PO100     PO101
PO122     PO131     PO20.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO33.1
PO34.1    PO35.1    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     POI3.1    POIE.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ35.1    WH130     WH132
WH190     WH20.2    WH20.7    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.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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CXV-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP131   AP25.1
                     established company and is entered on       AP25.2  AP26.1
                     all function codes.                         AP27.1  CXCP.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

CXV-REQ-LOCATION     Alpha 5                                     AP125   AP126
To Location          The location requisitioning items.          AP131   AP25.1
                     This location can be an inventory or        AP25.2  AP26.1
                     noninventory location.                      AP27.1  CXCP.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

CXV-CASE             Alpha 15                                    AP125   AP126
Case                 This field contains the unique,             AP131   AP25.1
                     user-assigned identifier for the case.      AP25.2  AP26.1
                     A case identifier is used in the Case       AP27.1  CXCP.1
                     Carts system to associate specific          IC28.1  MA180
                     tasks, practitioners, preference lists,     MA43.9  MA530
                     and other information with a particular     MA531   MA60.2
                     treatment course. This treatment course     MA60.3  MA60.5
                     may consist of one or more procedures.      MA61.1  MA66.3
                     The Case Carts system uses the case         MA67.1  MA67.2
                     number to interface with an outside         MA70.1  MAI1.1
                     scheduling system.                          PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

CXV-SEQ              Numeric 3                                   AP125   AP126
Sequence Number      This field contains the record sequence     AP131   AP25.1
                     number.                                     AP25.2  AP26.1
                                                                 AP27.1  CXCP.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

CXV-LINE-NBR         Numeric 6                                   AP125   AP126
Line Number          This field contains the line number.        AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  CXCP.1
                                                                 IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO29.1
                                                                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

CXV-SEGMENT-BLOCK    Alpha 103                                   AP125   AP126
User Analysis        This field identifies the user analysis     AP131   AP25.1
                     values included in the transaction.         AP25.2  AP26.1
                                                                 AP27.1  CXCP.1
                     You can either type up to four values       IC28.1  MA180
                     or use Define (F6) to open the User         MA43.9  MA530
                     Analysis Entry subform. Use this subform    MA531   MA60.2
                     to select the user analysis values you      MA60.3  MA60.5
                     want to include in the transaction. If      MA61.1  MA66.3
                     you choose to type values, use commas to    MA67.1  MA67.2
                     separate them. For example:                 MA70.1  MAI1.1
                     value1,value2,value3,value4                 PO100   PO101
                                                                 PO122   PO131
                     There are three conditions that affect      PO20.1  PO21.2
                     how you can select user analysis values.    PO21.3  PO21.4
                     See the User Analysis Entry form help or    PO21.5  PO22.1
                     the Strategic Ledger procedures manual      PO23.1  PO29.1
                     for additional information.                 PO30.1  PO30.2
                                                                 PO30.3  PO300
                                                                 PO31.1  PO31.2
                                                                 PO32.2  PO33.1
                                                                 PO34.1  PO35.1
                                                                 PO38.1  PO39.1
                                                                 PO39.2  PO44.1
                                                                 PO50.1  PO52.1
                                                                 PO520   POI3.1
                                                                 POIE.1  POII.1
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.2  RQ35.1
                                                                 WH130   WH132
                                                                 ...

                         CXCPIUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CXVSET1   COMPANY                                                AP125   AP126
          REQ-LOCATION                                           AP131   AP25.1
          CASE                                                   AP25.2  AP26.1
          SEQ                                                    AP27.1  CXCP.1
          LINE-NBR                                               IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 ...