CXCOMPANY – Case Cart Company

System
Case Carts (CX)
Prefix
CXC
Primary key
COMPANY
Fields
18
Updated by
222 programs
Referenced by
15 programs

CXCOMPANY is the Case Cart Company table in Lawson Case Carts (prefix CXC). It is indexed by COMPANY (CXCSET1). It is related 1:1 to ICCOMPANY. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more and referenced by CX04.1, CX05.1, CX05.2, CX15.1, CX205, CX207, CX225, CX230 and 7 more. The table has 18 fields, 1 index and 1 documented relation.

About CXCOMPANY

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.

Fields (18)

Column = COBOL field name without the CXC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CXC-COMPANY PK
COMPANY		Numeric 4This 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.CX01.1
CXC-BASE-RATE
BASE_RATE		Signed 18.2This 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.)CX01.1
CXC-DISCOUNT
DISCOUNT		Percent 2.0 (Percent)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.CX01.1
CXC-SPECIAL-DFAULT
SPECIAL_DFAULT		Alpha 32This 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.CX01.1
CXC-SERVICE-DFAULT
SERVICE_DFAULT		Alpha 32This 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.CX01.1
CXC-AUTO-BTCH-FL
AUTO_BTCH_FL		Alpha 1This 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
CX01.1
CXC-LAST-BATCH
LAST_BATCH		Numeric 6This value is the system-displayed value for the last batch number assigned. The system automatically increments the number as batches are assigned.CX01.1, PC530
CXC-SAL-RANGE-FL
SAL_RANGE_FL		Alpha 1This 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
CX01.1
CXC-BEG-RANGE
BEG_RANGE		Numeric 6This 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.CX01.1
CXC-END-RANGE
END_RANGE		Numeric 6This field contains the last number that will be used by the system for automatic assignment of batch numbers.CX01.1
CXC-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.—
CXC-VALIDATE-LOC
VALIDATE_LOC		Alpha 1This field is reserved for a future release of the Case Carts system.
  • Y Yes
  • N No
—
CXC-IF-REF-NBR
IF_REF_NBR		Numeric 9This field contains an internally generated reference number used by the Requisition system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CXC-GENERIC-REQ
GENERIC_REQ		Alpha 1This 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
CITY		Alpha 18 (Lower Case)This field contains the city of the address.—
CXC-STATE
STATE		Alpha 2This field contains the two-character state code of the address.—
CXC-LEADTIME-DAYS
LEADTIME_DAYS		Numeric 3This field contains the default 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
IC_NAME		DerivedThis field displays the company name from the Inventory Control system.—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CXCSET1COMPANYPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredCXC-COMPANY → ICC-COMPANY

Programs

Updated by (222)

Referenced by (15)