Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXCPIUAVAL


                            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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    CXCP.1    IC28.1
MA180     MA41.2    MA41.7    MA43.1    MA43.2    MA43.3
MA43.9    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PO100     PO101     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POI3.1
POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ35.1
RQIE.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     WO132
WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CXV-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number represents an          AP131   AP20.1
                       established company and is entered on     AP20.2  AP20.3
                       all function codes.                       AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

CXV-REQ-LOCATION       Alpha 5                                   AP125   AP126
Element: Location Code                                           AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

CXV-CASE               Alpha 15                                  AP125   AP126
Element: Case          This field contains the unique,           AP131   AP20.1
                       user-assigned identifier for the case.    AP20.2  AP20.3
                       A case identifier is used in the Case     AP20.4  AP20.5
                       Carts system to associate specific        AP20.7  AP23.1
                       tasks, practitioners, preference lists,   AP25.1  AP25.2
                       and other information with a particular   AP26.1  AP27.1
                       treatment course. This treatment course   AP30.4  API1.1
                       may consist of one or more procedures.    CXCP.1  IC28.1
                       The Case Carts system uses the case       MA180   MA41.2
                       number to interface with an outside       MA41.7  MA43.1
                       scheduling system.                        MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

CXV-SEQ                Numeric 3                                 AP125   AP126
Element: Sequence NumbeThis field contains the record sequence   AP131   AP20.1
                       number.                                   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

CXV-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Number   This field contains the line number.      AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

CXV-SEGMENT-BLOCK      Alpha 103                                 AP125   AP126
Element: User Analysis This field identifies the user analysis   AP131   AP20.1
                       values included in the transaction.       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       You can either type up to four values     AP20.7  AP23.1
                       or use Define (F6) to open the User       AP25.1  AP25.2
                       Analysis Entry subform. Use this subform  AP26.1  AP27.1
                       to select the user analysis values you    AP30.4  API1.1
                       want to include in the transaction. If    CXCP.1  IC28.1
                       you choose to type values, use commas to  MA180   MA41.2
                       separate them. For example:               MA41.7  MA43.1
                       value1,value2,value3,value4               MA43.2  MA43.3
                                                                 MA43.9  MA530
                       There are three conditions that affect    MA531   MA60.2
                       how you can select user analysis values.  MA60.3  MA60.5
                       See the User Analysis Entry form help or  MA61.1  MA66.2
                       the Strategic Ledger procedures manual    MA66.3  MA67.1
                       for additional information.               MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 PO30.2  PO30.3
                                                                 ...

                         CXCPIUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CXVSET1   COMPANY                                                AP125   AP126
          REQ-LOCATION                                           AP131   AP20.1
          CASE                                                   AP20.2  AP20.3
          SEQ                                                    AP20.4  AP20.5
          LINE-NBR                                               AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 ...