Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXCOMPANY


                             CXCOMPANY FILE

                           Case Cart Company

The Case Cart Company file (CXCOMPANY) contains parameters for healthcare
companies. The fields define values used in diagnosis calculations, purchase
order defaults, and patient charges. Each Case Carts system company ID must
match each Inventory Control company ID.

General Ledger companies should have matching Inventory Control companies.

Note that there is no relationship required between the Human Resources
system companies and the Case Carts system companies.

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    CXCP.1    IC28.1    PC530     MA180
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    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.4    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE81.1
OE810     OE830     OE90.1    OE90.2    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     WO132     WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CXC-COMPANY            Numeric 4
Element: Company       This field contains the company number.

                       Valid values are

                       Any Case Carts system company, defined
                       in CX01.1 (Healthcare Company) with an
                       equivalent Inventory Control company.

CXC-BASE-RATE          Signed 18.2
Element: Intl Amt      This field contains a single currency
                       value assigned to a medical facility by
                       the government or other insurer. The
                       Case Carts system uses the value to
                       calculate the anticipated reimbursement,
                       which is displayed in utilization review
                       reports (such as in CX235 (Procedure
                       Cost Vs DRG)). The base rate equals the
                       reimbursement amount for a diagnosis
                       with a relative weight of 1.000.

                       (Relative weight is the multiplier used
                       with the base rate to calculate the
                       reimbursement. The higher the relative
                       weight, the greater the payment to the
                       healthcare company.)

CXC-DISCOUNT           Percent 2.0  (Percent)
Element: Discount      This value is the teaching discount
                       assigned to your facility.
                       For certain reports, such as CX235
                       (Procedure Cost Vs DRG), the Case Carts
                       system adds this value to the
                       system-calculated reimbursement total.

CXC-SPECIAL-DFAULT     Alpha 32
Element: Special DfaultThis field defines an item number that
                       defaults to special (X) item number
                       fields.

                       Define such a default to allow fast
                       entry of special items. You must go to
                       the case detail record (CX20.2 (Case
                       Detail)) to overwrite the defaulted
                       value.

                       The text automatically displays on
                       forms, pick lists, and purchase orders
                       where the Item Number field is left
                       blank.

                       This default saves keystrokes during
                       data entry.

CXC-SERVICE-DFAULT     Alpha 32
Element: Service DfaultThis field defines text that defaults
                       to the item number field for service (S)
                       items.

                       To overwrite the defaulted value, you
                       must go to the case record.

                       The text automatically displays on
                       forms, pick tickets, and purchase orders
                       where the item number field is left
                       blank. This default saves keystrokes
                       during data entry.

CXC-AUTO-BTCH-FL       Alpha 1
Element: Auto Batch NumThis field indicates whether or not to
                       have the system automatically assign
                       batch numbers to cases.

                       Select Yes to allow the system to
                       automatically assign batch numbers to
                       cases for processing in the Patient
                       Charge system.

                       Select No to require manual assignment
                       of batch numbers to cases for processing
                       in the Patient Charge system.
                       Y = Yes
                       N = No

CXC-LAST-BATCH         Numeric 6                                 PC530
Element: Batch Number  This value is the system-displayed
                       value for the last batch number
                       assigned.

                       The system automatically increments the
                       number as batches are assigned.

CXC-SAL-RANGE-FL       Alpha 1
Element: Sal Range Fl  This field indicates the default salary
                       range that the Case Carts system
                       defaults to the burden Rate Amt field in
                       the Preference Burdens or Template
                       Burdens file. View the defaulted burden
                       rates in CX05.1 (Preference Template) or
                       CX20.2 (Case Detail) in the Burdens tab
                       for the company.

                       This field represents a cost range from
                       the Human Resources system. Select a
                       salary category of either minimum (1)
                       mid-range (2), or maximum (3), to
                       characterize the salary for burden
                       codes. (Burden is a generic term for a
                       resource with a measurable cost for a
                       case or with an indirect cost assigned
                       to but not directly related to a case.
                       Examples of burden are salaries,
                       equipment, services, and other resources
                       such as capital depreciation or building
                       management.)

                       Salary range applies to job codes only,
                       not to nonsalary burden codes. (Cost
                       (salary) ranges consist of a minimum and
                       maximum salary amount. For example, a
                       minimum cost range might be $20,001 to
                       $25,000. A mid-range cost range might be
                       $25,001 to $30,000. A maximum cost range
                       might be $30,001 to $35,000.)
                       1 = Min
                       2 = Mid
                       3 = Max

CXC-BEG-RANGE          Numeric 6
Element: Beg Range     This field defines the beginning batch
                       number for the batch range.

                       This number is the first batch number
                       used by the system to automatically
                       assign batch numbers to cases for
                       processing in the Patient Charge system.

CXC-END-RANGE          Numeric 6
Element: Beg Range     This field contains the last number
                       that will be used by the system for
                       automatic assignment of batch numbers.

CXC-NAME               Alpha 30  (Lower Case)
Element: Name          Displays the company description.

CXC-VALIDATE-LOC       Alpha 1
Element: All Flag      This field is reserved for a future
                       release of the Case Carts system.
                       Y = Yes
                       N = No

CXC-IF-REF-NBR         Numeric 9                                 AP125   AP126
Element: Reference NumbThis field contains an internally         AP131   AP25.1
                       generated reference number used by the    AP25.2  AP26.1
                       Requisition system.                       AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  IC28.1
                                                                 MA180   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  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

CXC-GENERIC-REQ        Alpha 1
Element: All Flag      This field indicates whether the
                       request is generic.

                       Select Yes if this is a generic request.

                       Select No if this is not a generic
                       request.
                       Y = Yes
                       N = No

CXC-CITY               Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

CXC-STATE              Alpha 2
Element: State or ProviThis field contains the two-character
                       state code of the address.

CXC-LEADTIME-DAYS      Numeric 3
Leadtime Number of     This field contains the default
Days                   leadtime (in days) required for
                       allocating inventory items. You may also
                       assign a leadtime to each preference
                       template. If you do not specify a
                       leadtime on the template, the leadtime
                       defined on the company defaults when you
                       add the template to a case.

CXC-IC-NAME            Derived
Element: Ic Name       This field displays the company name
                       from the Inventory Control system.

                         CXCOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CXCSET1   COMPANY                                                AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  IC28.1
                                                                 PC530   MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 ...

                         CXCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            CXC-COMPANY    -> ICC-COMPANY