CXCASEHEAD – Case Cart Header

System: Case Carts (CX)
Prefix: CXH
Primary key: COMPANY, REQ-LOCATION, CASE
Fields: 36
Updated by: 35 programs
Referenced by: 9 programs

CXCASEHEAD is the Case Cart Header table in Lawson Case Carts (prefix CXH). It is indexed by COMPANY, REQ-LOCATION, CASE (CXHSET1); alternate indexes: CXHSET2, CXHSET3, CXHSET4, CXHSET5 and CXHSET6. It is related 1:1 to CXCOMPANY, HCPATIENT, RQLOC and WHDEMNDHDR and 1:M to CXCASEPREF and WHSHIPMENT. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 27 more and referenced by CX225, CX230, CX235, CX240, CX50.1, CX55.1, PC310, PC521 and 1 more. The table has 36 fields, 6 indexes and 6 documented relations.

About CXCASEHEAD

The Case Cart Header file contains key information for each case. Each record contains basic information on the patient and the case. With Lawson-defined relations to other files, this is the primary file for the case structure. You add data to this file using a manual, automatic, or combined process. Use CX20.1 (Case Build) to manually add or delete case header information. Run CX506 (HL7 Schedules Import Interface) to automatically import header data from an outside scheduling system. To upload ADT information and then add the uploaded cases and patients, run PC520 (Patient Upload), then PC521 (Patient Interface), and then use CX20.1. For information on using the Patient Charge programs, see the Inventory Control Procedures Manual. You delete case information, which includes header information in this file, using CX20.1. (A case consists of one or more practitioner-specific preference templates assigned to a patient visit and related header data.) Fields in each record include information on the case visit such as company and requesting location, start and completion dates, total cost breakdown, and so on. The completion date is a user-defined date added in CX30.1 (Case Completion Feedback) when finishing a case. Note that for stock or non-inventory tracked stock on hand, you must use a Warehouse system picking process to close out all demand before you can finish a case. (For instructions on completing a case, see the Case Carts Procedures Manual.)

Fields (36)

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

Field / column	Type	Description & values	Updated by
`CXH-COMPANY` PK COMPANY	Numeric 4	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 in IC01.1 (Company).	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	This field contains the location requisitioning items and receiving charges for the items. This location can be an inventory or noninventory location. This value appears as the to location on the pick lists printed when you run CX100 (Pick List Print) and WH130 (Pick List Print). Valid values are A requesting location defined in RQ01.1 (Requesting Location) for the specified healthcare company.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-CASE` PK CASE	Alpha 15	This field contains the unique, user-assigned identifier for the case. A case identifier is used in the Case Carts system to associate specific tasks, practitioners, preference lists, and other information with a particular treatment course. This treatment course may consist of one or more procedures. The Case Carts system uses the case number to interface with an outside scheduling system.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
`CXH-SUITE` SUITE	Alpha 5	This field contains the specific location ID for the surgery suite, patient room, and so on. The Case Carts system can import the suite number from an outside scheduling system.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX240, CX30.1 +28 more
`CXH-VISIT-NBR` VISIT_NBR	Alpha 12	This field contains the identifier that makes a visit unique with a company. The Case Carts system can import this value from an outside scheduling system. Alternatively, when using CX20.1 (Case Build), you can select a value from the Patient Charge system for assignment to the case.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-PATIENT-ID` PATIENT_ID	Alpha 12	This field uniquely identifies a patient within a company. The Case Carts system can import this value from an outside scheduling system. Alternatively, when using CX20.1 (Case Build), you can select a value from the Patient Charge system for assignment to the case.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX240, CX30.1 +29 more
`CXH-CX-START-TIME` CX_START_TIME	Numeric 4	This field contains the start time for the case.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-START-DATE` START_DATE	Numeric 8 (yyyymmdd)	This field contains the date when the case starts. This value is used in CX206 (Case Value Report) or the Case Carts Analyzer to report on how long procedures are taking to complete For instructions on using these programs, see the Case Carts Procedures Manual.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
`CXH-COMPLETED-TIME` COMPLETED_TIME	Numeric 4	This field contains the completion time for the case. This value is a user-defined time added in CX30.1 (Case Completion Feedback) when finishing a case.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-COMPLETED-DATE` COMPLETED_DATE	Numeric 8 (yyyymmdd)	This field contains the completion date for the case. For cases assigned multiple procedures, this date equals the procedure completion date of the procedure assigned the final preference sequence number on the case. (The completion date is a user-defined date added in CX30.1 (Case Completion Feedback) when finishing a case.)	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
`CXH-SERVICE-DATE` SERVICE_DATE	Numeric 8 (yyyymmdd)	This field identifies the date the item was used. This date is used by the billing system to identify the charges associated with this case. In the Patient Charge system, this date is called the Charge Date.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-STATUS` STATUS	Numeric 1	This field contains the case transaction status. You can continue to change a case until the status has changed to 4 (Charges Passed) or 5 (No Charges). Note: If you add or change a line that is to be picked and the case status is 3 (Complete), the case status returns to 2 (Released). This status appears in case inquiry forms, such as CX20.1 (Case Build) and CX50.1 (Preference List Status). It is updated from the Warehouse system. The status helps you to determine when to pick items or close demand records. CX30.1 (Case Completion Feedback) displays this value. To finish a case, this status must be set to Complete. `1` Unreleased `2` Released `3` Complete `4` Charges Passed `5` No Charges	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
`CXH-PRINT-FLAG` PRINT_FLAG	Alpha 1	This field contains Yes or No. The value indicates whether to print the Preference/Case listing using CX220 (Case/Preference Listing). `Y` Yes `N` No	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-OPERATOR-ID` OPERATOR_ID	Alpha 10	This is the terminal signon identifier that was active when this update to the database was performed.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-LAST-PREF-SEQ` LAST_PREF_SEQ	Numeric 3	This field contains the record sequence number. The Case Carts system uses this value to track placement of procedures in a multiprocedure case. View and add these values in CX20.2 (Case Detail) and CX30.1 (Case Completion Feedback).	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-LAST-ALT-LINE` LAST_ALT_LINE	Numeric 6	This field contains the last alternative line. The system uses this value to track multiple procedures on a case.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-AUTO-REDUCTION` AUTO_REDUCTION	Alpha 1	This field is reserved for a future release of the Case Carts system. `Y` Yes `N` No	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-NORMAL-TIME` NORMAL_TIME	Numeric 4	This field contains the user-defined typical time to complete a procedure.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-SALARY-RANGE` SALARY_RANGE	Alpha 1	This field contains the indicator for the salary range used for cost analysis. This is the default salary range the Case Carts system logic uses when defaulting labor costs to preference templates and patient cases. `1` Min `2` Mid `3` Max	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-CLINICAL-CST` CLINICAL_CST	Signed 18.2	This field contains the sum of the user-defined clinical costs for each case preference. When you add a case using CX20.1 (Case Build), the Case Carts system totals the applicable clinical costs from the Case Cart Preferences file to get this value. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the clinical costs on the applicable template and then delete and re-add the template to the applicable case using CX20.1 (Case Build). The second way is to type new values in the Procedure Cost tab of CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Drill Around (F5) feature in the Pref Code field of CX20.1 (Case Build), the Case Carts Analyzer, or a file editor.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-DIST-CST` DIST_CST	Signed 18.2	This field contains the sum of the user-defined distribution costs for each case preference. When you add a case using CX20.1 (Case Build), the Case Carts system totals the applicable distribution costs from the Case Cart Preferences file to get this value. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the distribution costs on the applicable template and then delete and re-add the template to the case. The second way is to type new values in the Procedure Cost tab of CX20.2 (Case Detail). In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Drill Around (F5) feature in the Pref Code of CX20.1 (Case Build), the Case Cart Analyzer, or a file editor.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-SUPPLY-CST` SUPPLY_CST	Signed 18.2	This field contains the sum of the user-defined supply costs for items on a case. (A preference is a preference template attached to a case.) This value is updated each time any item cost-related element is changed by adding, deleting, changing quantity, and so on. When you add a case using CX20.1 (Case Build), the Case Carts system totals the applicable supply costs (Issue Costs) in the Preference Items file to get this value. Inquire on CX20.2 (Case Detail) to view each supply cost value of the Preference Items file. View each supply cost in the Items tab, in the Cost field of the Detail detail tab for each item. Change this value indirectly in one of two ways. The first way is to use CX05.1 (Preference Template) to change the supply costs on the applicable template and then reassign the template to and change the case. The second way is to use CX20.2 (Case Detail) to type new values in the Cost field of the Items tab, Detail detail tab for each applicable item. In the second way, the costs are recorded for the case preference only and are not captured in templates for future use. Note: To view this value, use one of the following features: the Drill Around (F5) feature in the Pref Code field of CX20.1 (Case Build), the Case Carts Analyzer, or a file editor.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-TOTAL-CST` TOTAL_CST	Signed 18.2	This field contains the total of all costs for a procedure. The costs included are those for supplies (items), burden, clinical resources, and distribution resources. This value is updated each time any cost-related element is changed on a case by adding, deleting, changing quantity, and so on. Note: To view this value, use one of the following features: the Drill Around (F5) feature in the Pref Code field of Case Build (CX20.1), the Case Carts Analyzer, or a file editor.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-TOTAL-BURDEN` TOTAL_BURDEN	Signed 18.2	This field contains the total costs associated with procedure burden codes. A burden is a resource with a measurable cost assigned to a case. The measurable cost can be an indirect cost, assigned to but not directly related to a case. Examples of burden are salaries, equipment, services, and other indirect costs for capital depreciation, building management, and so on. Use CX15.1 (Burden) or CX504 (HR Labor Import) to define burden codes. Use CX15.1 to view burden codes. Note: To view this value, use one of the following features: the Drill Around (F5) feature in the Pref Code field of CX20.1 (Case Build), the Case Carts Analyzer, or a file editor.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-PK-PRINT-FLAG` PK_PRINT_FLAG	Alpha 1	Select the proper value to create a pick ticket, post items, or complete the case. `1` Create Pick List `2` Process Post Items `3` Complete `4` Reprocess	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-PATIENT-CLASS` PATIENT_CLASS	Alpha 1	This field provides for a category of patient. `I` Inpatient `O` Outpatient `B` Both	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-ONLINE-ALLOCAT` ONLINE_ALLOCAT	Alpha 1	This field indicates whether to allow online or batch allocation. Select Yes to allow online allocation. If you select Yes, when you release the case, the Case Carts system tries to allocate all items to the requesting location. Select No to allow batch allocation. If you select No, when you release the case, you must run WH110 (Batch Allocation) to allocate inventory items for the case. `Y` Yes `N` No	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-LAST-REF-NBR` LAST_REF_NBR	Numeric 9	This field contains the last reference number. The system uses this value with the Reference Number value in the Case Cart Preference Items file to interface with WH130 (Pick List Print).	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-AM-PM-FLAG` AM_PM_FLAG	Alpha 2	This field indicates whether the case start time is for the morning or for the afternoon or evening. `AM` AM `PM` PM	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-COMPL-AM-PM` COMPL_AM_PM	Alpha 2	This field indicates whether the case completion time is for the morning or for the afternoon or evening. `AM` AM `PM` PM	—
`CXH-FICA-NBR` FICA_NBR	Alpha 20	—	—
`CXH-FLAT-FEE-FL` FLAT_FEE_FL	Alpha 1	— `N` No `Y` Yes	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-AUTO-TOTAL` AUTO_TOTAL	Alpha 1	—	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more
`CXH-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +27 more

Indexes (6)

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

Index	Keys	Flags	Condition	Used in
`CXHSET1`	`COMPANY`, `REQ-LOCATION`, `CASE`	Primary		CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX225, CX230 +22 more (list truncated in source)
`CXHSET2`	`COMPANY`, `REQ-LOCATION`, `START-DATE`, `CASE`	KeyChange		CX220
`CXHSET3`	`COMPANY`, `VISIT-NBR`, `REQ-LOCATION`, `CASE`	KeyChange		PC310, PC521
`CXHSET4`	`COMPANY`, `REQ-LOCATION`, `STATUS`, `COMPLETED-DATE`, `START-DATE`, `CASE`	KeyChange		CX50.1
`CXHSET5`	`COMPANY`, `CASE`, `REQ-LOCATION`			CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
`CXHSET6`	`ATN-OBJ-ID`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Cxcompany	CXCOMPANY	Required	`CXH-COMPANY` → `CXC-COMPANY (CXCSET1)`
Hcpatient	HCPATIENT	Required	`CXH-COMPANY` → `HPT-COMPANY`, `CXH-PATIENT-ID` → `HPT-PATIENT-ID`
Reqlocation	RQLOC	Required	`CXH-COMPANY` → `RQL-COMPANY`, `CXH-REQ-LOCATION` → `RQL-REQ-LOCATION`
Whdemndhdr	WHDEMNDHDR	Not Required	`CXH-COMPANY` → `WDH-COMPANY`, `"CX"` → `WDH-SYSTEM-CD`, `CXH-CASE` → `WDH-DOC-NBR`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Cccasepref	CXCASEPREF	Delete Cascades		`CXH-COMPANY` → `CXP-COMPANY`, `CXH-REQ-LOCATION` → `CXP-REQ-LOCATION`, `CXH-CASE` → `CXP-CASE`, → `CXP-SEQ`
Whshipment	WHSHIPMENT			`CXH-COMPANY` → `WHS-COMPANY`, `"CX"` → `WHS-SYSTEM-CD`, `CXH-CASE` → `WHS-DOC-NBR`, → `WHS-SHIPMENT-NBR`, → `WHS-LOCATION`

Programs

Updated by (35)

CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.5 Additional Shipment Information
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program

Referenced by (9)

CX225 Practitioner Case Load
CX230 Waste, Return Items
CX235 Procedure Cost versus Diagnosis Related Group
CX240 Item Returns
CX50.1 Preference List Status
CX55.1 Case Procedure Inquiry
PC310 Patient Purge
PC521 HL7 ADT Patient Interface
PO23.1 Purchase Order Worksheet