Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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.

REFERENCED BY

CX04.1

UPDATED BY

CX01.1    CXCP.1    PC530     POIJ.1    WH130     WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CXC-COMPANY          Numeric 4                                   CX01.1
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 15.2                                 CX01.1
Exchange Rate        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)                      CX01.1
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                                    CX01.1
Special Dfault       This 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                                    CX01.1
Service Dfault       This 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                                     CX01.1
Auto Batch Numbering This 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                                   CX01.1  PC530
Last Batch Used      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                                     CX01.1
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                                   CX01.1
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                                   CX01.1
End 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)
Name                 Displays the company description.

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

CXC-IF-REF-NBR       Numeric 9                                   CXCP.1  POIJ.1
Reference Number     This field contains an internally           WH130   WH33.1
                     generated reference number used by the      WH33.2  WH33.3
                     Requisition system.                         WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CXC-GENERIC-REQ      Alpha 1
Generic Req          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)
City                 This field contains the city of the
                     address.


CXC-STATE            Alpha 2
State or Province    This 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
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                                                CX01.1  CX04.1
                                                                 CXCP.1  PC530
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

                         CXCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            CXC-COMPANY    -> ICC-COMPANY