CXCASEHEAD FILE
Case Cart Header
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.)
REFERENCED BY
PC310 PC521
UPDATED BY
WH130 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXH-COMPANY Numeric 4 WH130 WH33.5
Company This field contains the company number. WH34.1 WH34.2
WH34.3 WH34.4
Valid values are
Any Case Carts system company, defined
in CX01.1 (Healthcare Company) with an
equivalent Inventory Control company in
IC01.1 (Company).
CXH-REQ-LOCATION Alpha 5 WH130 WH33.5
To Location This field contains the location WH34.1 WH34.2
requisitioning items and receiving WH34.3 WH34.4
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.
CXH-CASE Alpha 15 WH130 WH33.5
Case This field contains the unique, WH34.1 WH34.2
user-assigned identifier for the case. WH34.3 WH34.4
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.
CXH-SUITE Alpha 5 WH130 WH33.5
Suite This field contains the specific WH34.1 WH34.2
location ID for the surgery suite, WH34.3 WH34.4
patient room, and so on.
The Case Carts system can import the
suite number from an outside scheduling
system.
CXH-VISIT-NBR Alpha 12 WH130 WH33.5
Visit Number This field contains the identifier that WH34.1 WH34.2
makes a visit unique with a company. WH34.3 WH34.4
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.
CXH-PATIENT-ID Alpha 12 WH130 WH33.5
Patient ID This field uniquely identifies a WH34.1 WH34.2
patient within a company. WH34.3 WH34.4
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.
CXH-CX-START-TIME Numeric 4 WH130 WH33.5
Case Start Time This field contains the start time for WH34.1 WH34.2
the case. WH34.3 WH34.4
CXH-START-DATE Numeric 8 (yyyymmdd) WH130 WH33.5
Start Date This field contains the date when the WH34.1 WH34.2
case starts. WH34.3 WH34.4
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.
CXH-COMPLETED-TIME Numeric 4 WH130 WH33.5
Completed Time This field contains the completion time WH34.1 WH34.2
for the case. WH34.3 WH34.4
This value is a user-defined time added
in CX30.1 (Case Completion Feedback)
when finishing a case.
CXH-COMPLETED-DATE Numeric 8 (yyyymmdd) WH130 WH33.5
Completed Date This field contains the completion date WH34.1 WH34.2
for the case. WH34.3 WH34.4
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.)
CXH-SERVICE-DATE Numeric 8 (yyyymmdd) WH130 WH33.5
Service Date This field identifies the date the item WH34.1 WH34.2
was used. This date is used by the WH34.3 WH34.4
billing system to identify the charges
associated with this case. In the
Patient Charge system, this date is
called the Charge Date.
CXH-STATUS Numeric 1 WH130 WH33.5
Status This field contains the case WH34.1 WH34.2
transaction status. WH34.3 WH34.4
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
CXH-PRINT-FLAG Alpha 1 WH130 WH33.5
Print Flag This field contains Yes or No. The WH34.1 WH34.2
value indicates whether to print the WH34.3 WH34.4
Preference/Case listing using CX220
(Case/Preference Listing).
Y = Yes
N = No
CXH-OPERATOR-ID Alpha 10 WH130 WH33.5
Operator This is the terminal signon identifier WH34.1 WH34.2
Identification Code that was active when this update to the WH34.3 WH34.4
database was performed.
CXH-LAST-PREF-SEQ Numeric 3 WH130 WH33.5
Last Preference This field contains the record sequence WH34.1 WH34.2
Sequence number. WH34.3 WH34.4
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).
CXH-LAST-ALT-LINE Numeric 6 WH130 WH33.5
Last Alternate Line This field contains the last WH34.1 WH34.2
alternative line. WH34.3 WH34.4
The system uses this value to track
multiple procedures on a case.
CXH-AUTO-REDUCTION Alpha 1 WH130 WH33.5
Autoreduction This field is reserved for a future WH34.1 WH34.2
release of the Case Carts system. WH34.3 WH34.4
Y = Yes
N = No
CXH-NORMAL-TIME Numeric 4 WH130 WH33.5
Normal Time This field contains the user-defined WH34.1 WH34.2
typical time to complete a procedure. WH34.3 WH34.4
CXH-SALARY-RANGE Alpha 1 WH130 WH33.5
Salary Range This field contains the indicator for WH34.1 WH34.2
the salary range used for cost analysis. WH34.3 WH34.4
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
CXH-CLINICAL-CST Currency 15.2 WH130 WH33.5
Clinical Cost This field contains the sum of the WH34.1 WH34.2
user-defined clinical costs for each WH34.3 WH34.4
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.
CXH-DIST-CST Currency 15.2 WH130 WH33.5
Distribution Cost This field contains the sum of the WH34.1 WH34.2
user-defined distribution costs for each WH34.3 WH34.4
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.
CXH-SUPPLY-CST Currency 15.2 WH130 WH33.5
Supply Cost This field contains the sum of the WH34.1 WH34.2
user-defined supply costs for items on a WH34.3 WH34.4
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.
CXH-TOTAL-CST Currency 15.2 WH130 WH33.5
Total Cst This field contains the total of all WH34.1 WH34.2
costs for a procedure. The costs WH34.3 WH34.4
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
CX20.1 (Case Build), the Case Carts
Analyzer, or a file editor.
CXH-TOTAL-BURDEN Currency 15.2 WH130 WH33.5
Total Burden This field contains the total costs WH34.1 WH34.2
associated with procedure burden codes. WH34.3 WH34.4
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.
CXH-PK-PRINT-FLAG Alpha 1 WH130 WH33.5
Pick-List Print Flag Select the proper value to create a WH34.1 WH34.2
pick ticket, post items, or complete the WH34.3 WH34.4
case.
1 = Create Pick List
2 = Process Post Items
3 = Complete
4 = Reprocess
CXH-PATIENT-CLASS Alpha 1 WH130 WH33.5
Patient Class This field provides for a category of WH34.1 WH34.2
patient. WH34.3 WH34.4
I = Inpatient
O = Outpatient
B = Both
CXH-ONLINE-ALLOCAT Alpha 1 WH130 WH33.5
Online Allocation This field indicates whether to allow WH34.1 WH34.2
online or batch allocation. WH34.3 WH34.4
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
CXH-LAST-REF-NBR Numeric 9 WH130 WH33.5
Last Reference This field contains the last reference WH34.1 WH34.2
Number number. WH34.3 WH34.4
The system uses this value with the
Reference Number value in the Case Cart
Preference Items file to interface with
WH130 (Pick List Print).
CXH-AM-PM-FLAG Alpha 2 WH130 WH33.5
A.M. or P.M. Flag This field indicates whether the case WH34.1 WH34.2
start time is for the morning or for the WH34.3 WH34.4
afternoon or evening.
AM = AM
PM = PM
CXH-COMPL-AM-PM Alpha 2
Complete A.M. or This field indicates whether the case
P.M. Flag completion time is for the morning or
for the afternoon or evening.
AM = AM
PM = PM
CXH-FICA-NBR Alpha 15
Social Security
Number
CXH-FLAT-FEE-FL Alpha 1 WH130 WH33.5
Flat Fee Fl N = No WH34.1 WH34.2
Y = Yes WH34.3 WH34.4
CXH-AUTO-TOTAL Alpha 1 WH130 WH33.5
Auto Total WH34.1 WH34.2
WH34.3 WH34.4
CXH-ACCT-CATEGORY Alpha 5 WH130 WH33.5
Account Category Account categories are groupings of WH34.1 WH34.2
costs, revenues, or a combination of WH34.3 WH34.4
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.
CXH-ACTIVITY Alpha 15 WH130 WH33.5
Activity Activities are the processes or WH34.1 WH34.2
procedures that produce work. Cost WH34.3 WH34.4
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
CXH-ATN-OBJ-ID Numeric 12 WH130 WH33.5
Atn Object ID The system-defined object id WH34.1 WH34.2
representing the Activity Management WH34.3 WH34.4
commitment.
CXCASEHEAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXHSET1 COMPANY This index is used to access case WH130 WH33.5
REQ-LOCATION header information in Company, WH34.1 WH34.2
CASE Requesting Location, and Case order, WH34.3 WH34.4
CXHSET2 COMPANY The index is used to access Case Cart
REQ-LOCATION Header file records in Company,
START-DATE Requesting Location, Start Date, and
CASE Case order,
KeyChange
CXHSET3 COMPANY This index is used to access Case Cart PC310 PC521
VISIT-NBR Header file records in Company, Visit
REQ-LOCATION Number, Requesting Location, and Case
CASE order.
KeyChange
CXHSET4 COMPANY This index is used to access Case Cart
REQ-LOCATION Header file records in Company, Visit
STATUS Number, Requesting Location, and Case
COMPLETED-DATEorder.
START-DATE KeyChange
CASE
CXHSET5 COMPANY This index is used to access Case Cart WH130 WH33.5
CASE Header file records in Company, Case, WH34.1 WH34.2
REQ-LOCATION and Requesting Location order. WH34.3 WH34.4
CXHSET6 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
CXCASEHEAD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
CXCASEHEAD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
