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
CX225 CX230 CX235 CX240 CX50.1 PC310
PC521
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 OE114 WH130
WH132 WH190 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CXH-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
Valid values are CX220 CX30.1
CX300 CX506
Any Case Carts system company, defined OE114 WH130
in CX01.1 (Healthcare Company) with an WH132 WH190
equivalent Inventory Control company in WH222 WH30.1
IC01.1 (Company). WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-REQ-LOCATION Alpha 5 BL92.1 CX100
To Location This field contains the location CX20.1 CX20.2
requisitioning items and receiving CX20.4 CX20.5
charges for the items. This location can CX220 CX30.1
be an inventory or noninventory CX300 CX506
location. OE114 WH130
WH132 WH190
This value appears as the to location WH222 WH30.1
on the pick lists printed when you run WH30.2 WH30.3
CX100 (Pick List Print) and WH130 (Pick WH31.1 WH31.2
List Print). WH31.3 WH32.1
WH32.2 WH32.3
Valid values are WH33.5 WH34.1
WH34.2 WH34.3
A requesting location defined in RQ01.1 WH34.4 WH40.1
(Requesting Location) for the specified WH40.2 WH520
healthcare company. WH830
CXH-CASE Alpha 10 BL92.1 CX100
Case This field contains the unique, CX20.1 CX20.2
user-assigned identifier for the case. CX20.4 CX20.5
CX220 CX30.1
A case identifier is used in the Case CX300 CX50.1
Carts system to associate specific CX506 OE114
tasks, practitioners, preference lists, WH130 WH132
and other information with a particular WH190 WH222
treatment course. This treatment course WH30.1 WH30.2
may consist of one or more procedures. WH30.3 WH31.1
WH31.2 WH31.3
The Case Carts system uses the case WH32.1 WH32.2
number to interface with an outside WH32.3 WH33.5
scheduling system. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXH-SUITE Alpha 5 BL92.1 CX100
Suite This field contains the specific CX20.1 CX20.2
location ID for the surgery suite, CX20.4 CX20.5
patient room, and so on. CX220 CX240
CX30.1 CX300
The Case Carts system can import the CX506 OE114
suite number from an outside scheduling WH130 WH132
system. WH190 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXH-VISIT-NBR Alpha 12 BL92.1 CX100
Visit Number This field contains the identifier that CX20.1 CX20.2
makes a visit unique with a company. CX20.4 CX20.5
CX220 CX30.1
The Case Carts system can import this CX300 CX506
value from an outside scheduling system. OE114 WH130
Alternatively, when using CX20.1 (Case WH132 WH190
Build), you can select a value from the WH222 WH30.1
Patient Charge system for assignment to WH30.2 WH30.3
the case. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-PATIENT-ID Alpha 12 BL92.1 CX100
Patient ID This field uniquely identifies a CX20.1 CX20.2
patient within a company. CX20.4 CX20.5
CX220 CX240
The Case Carts system can import this CX30.1 CX300
value from an outside scheduling system. CX50.1 CX506
Alternatively, when using CX20.1 (Case OE114 WH130
Build), you can select a value from the WH132 WH190
Patient Charge system for assignment to WH222 WH30.1
the case. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-CX-START-TIME Numeric 4 BL92.1 CX100
Case Start Time This field contains the start time for CX20.1 CX20.2
the case. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-START-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Start Date This field contains the date when the CX20.1 CX20.2
case starts. CX20.4 CX20.5
CX220 CX30.1
This value is used in CX206 (Case Value CX300 CX50.1
Report) or the Case Carts Analyzer to CX506 OE114
report on how long procedures are taking WH130 WH132
to complete WH190 WH222
WH30.1 WH30.2
For instructions on using these WH30.3 WH31.1
programs, see the Case Carts Procedures WH31.2 WH31.3
Manual. WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXH-COMPLETED-TIME Numeric 4 BL92.1 CX100
Completed Time This field contains the completion time CX20.1 CX20.2
for the case. CX20.4 CX20.5
CX220 CX30.1
This value is a user-defined time added CX300 CX506
in CX30.1 (Case Completion Feedback) OE114 WH130
when finishing a case. WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-COMPLETED-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Completed Date This field contains the completion date CX20.1 CX20.2
for the case. CX20.4 CX20.5
CX220 CX30.1
For cases assigned multiple procedures, CX300 CX50.1
this date equals the procedure CX506 OE114
completion date of the procedure WH130 WH132
assigned the final preference sequence WH190 WH222
number on the case. (The completion date WH30.1 WH30.2
is a user-defined date added in CX30.1 WH30.3 WH31.1
(Case Completion Feedback) when WH31.2 WH31.3
finishing a case.) WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXH-SERVICE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Service Date This field identifies the date the item CX20.1 CX20.2
was used. This date is used by the CX20.4 CX20.5
billing system to identify the charges CX220 CX30.1
associated with this case. In the CX300 CX506
Patient Charge system, this date is OE114 WH130
called the Charge Date. WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-STATUS Numeric 1 BL92.1 CX100
Status This field contains the case CX20.1 CX20.2
transaction status. CX20.4 CX20.5
CX220 CX30.1
You can continue to change a case until CX300 CX50.1
the status has changed to 4 (Charges CX506 OE114
Passed) or 5 (No Charges). WH130 WH132
WH190 WH222
Note: If you add or change a line that WH30.1 WH30.2
is to be picked and the case status is 3 WH30.3 WH31.1
(Complete), the case status returns to 2 WH31.2 WH31.3
(Released). WH32.1 WH32.2
WH32.3 WH33.5
This status appears in case inquiry WH34.1 WH34.2
forms, such as CX20.1 (Case Build) and WH34.3 WH34.4
CX50.1 (Preference List Status). It is WH40.1 WH40.2
updated from the Warehouse system. WH520 WH830
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 BL92.1 CX100
Print Flag This field contains Yes or No. The CX20.1 CX20.2
value indicates whether to print the CX20.4 CX20.5
Preference/Case listing using CX220 CX220 CX30.1
(Case/Preference Listing). CX300 CX506
Y = Yes OE114 WH130
N = No WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-OPERATOR-ID Alpha 10 BL92.1 CX100
Operator This is the terminal signon identifier CX20.1 CX20.2
Identification Code that was active when this update to the CX20.4 CX20.5
database was performed. CX220 CX30.1
CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-LAST-PREF-SEQ Numeric 3 BL92.1 CX100
Last Preference This field contains the record sequence CX20.1 CX20.2
Sequence number. CX20.4 CX20.5
CX220 CX30.1
The Case Carts system uses this value CX300 CX506
to track placement of procedures in a OE114 WH130
multiprocedure case. View and add these WH132 WH190
values in CX20.2 (Case Detail) and WH222 WH30.1
CX30.1 (Case Completion Feedback). WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-LAST-ALT-LINE Numeric 6 BL92.1 CX100
Last Alternate Line This field contains the last CX20.1 CX20.2
alternative line. CX20.4 CX20.5
CX220 CX30.1
The system uses this value to track CX300 CX506
multiple procedures on a case. OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-AUTO-REDUCTION Alpha 1 BL92.1 CX100
Autoreduction This field is reserved for a future CX20.1 CX20.2
release of the Case Carts system. CX20.4 CX20.5
Y = Yes CX220 CX30.1
N = No CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-NORMAL-TIME Numeric 4 BL92.1 CX100
Normal Time This field contains the user-defined CX20.1 CX20.2
typical time to complete a procedure. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-SALARY-RANGE Alpha 1 BL92.1 CX100
Salary Range This field contains the indicator for CX20.1 CX20.2
the salary range used for cost analysis. CX20.4 CX20.5
This is the default salary range the CX220 CX30.1
Case Carts system logic uses when CX300 CX506
defaulting labor costs to preference OE114 WH130
templates and patient cases. WH132 WH190
1 = Min WH222 WH30.1
2 = Mid WH30.2 WH30.3
3 = Max WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-CLINICAL-CST Currency 15.2 BL92.1 CX100
Clinical Cost This field contains the sum of the CX20.1 CX20.2
user-defined clinical costs for each CX20.4 CX20.5
case preference. CX220 CX30.1
CX300 CX506
When you add a case using CX20.1 (Case OE114 WH130
Build), the Case Carts system totals the WH132 WH190
applicable clinical costs from the Case WH222 WH30.1
Cart Preferences file to get this value. WH30.2 WH30.3
WH31.1 WH31.2
Change this value indirectly in one of WH31.3 WH32.1
two ways. The first way is to use CX05.1 WH32.2 WH32.3
(Preference Template) to change the WH33.5 WH34.1
clinical costs on the applicable WH34.2 WH34.3
template and then delete and re-add the WH34.4 WH40.1
template to the applicable case using WH40.2 WH520
CX20.1 (Case Build). The second way is WH830
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 BL92.1 CX100
Distribution Cost This field contains the sum of the CX20.1 CX20.2
user-defined distribution costs for each CX20.4 CX20.5
case preference. CX220 CX30.1
CX300 CX506
When you add a case using CX20.1 (Case OE114 WH130
Build), the Case Carts system totals the WH132 WH190
applicable distribution costs from the WH222 WH30.1
Case Cart Preferences file to get this WH30.2 WH30.3
value. WH31.1 WH31.2
WH31.3 WH32.1
Change this value indirectly in one of WH32.2 WH32.3
two ways. The first way is to use CX05.1 WH33.5 WH34.1
(Preference Template) to change the WH34.2 WH34.3
distribution costs on the applicable WH34.4 WH40.1
template and then delete and re-add the WH40.2 WH520
template to the case. The second way is WH830
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 BL92.1 CX100
Supply Cost This field contains the sum of the CX20.1 CX20.2
user-defined supply costs for items on a CX20.4 CX20.5
case. (A preference is a preference CX220 CX30.1
template attached to a case.) CX300 CX506
OE114 WH130
This value is updated each time any WH132 WH190
item cost-related element is changed by WH222 WH30.1
adding, deleting, changing quantity, and WH30.2 WH30.3
so on. WH31.1 WH31.2
WH31.3 WH32.1
When you add a case using CX20.1 (Case WH32.2 WH32.3
Build), the Case Carts system totals the WH33.5 WH34.1
applicable supply costs (Issue Costs) in WH34.2 WH34.3
the Preference Items file to get this WH34.4 WH40.1
value. Inquire on CX20.2 (Case Detail) WH40.2 WH520
to view each supply cost value of the WH830
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 BL92.1 CX100
Total Cost This field contains the total of all CX20.1 CX20.2
costs for a procedure. The costs CX20.4 CX20.5
included are those for supplies (items), CX220 CX30.1
burden, clinical resources, and CX300 CX506
distribution resources. OE114 WH130
WH132 WH190
This value is updated each time any WH222 WH30.1
cost-related element is changed on a WH30.2 WH30.3
case by adding, deleting, changing WH31.1 WH31.2
quantity, and so on. WH31.3 WH32.1
WH32.2 WH32.3
Note: To view this value, use one of WH33.5 WH34.1
the following features: the Drill Around WH34.2 WH34.3
(F5) feature in the Pref Code field of WH34.4 WH40.1
CX20.1 (Case Build), the Case Carts WH40.2 WH520
Analyzer, or a file editor. WH830
CXH-TOTAL-BURDEN Currency 15.2 BL92.1 CX100
Total Burden This field contains the total costs CX20.1 CX20.2
associated with procedure burden codes. CX20.4 CX20.5
CX220 CX30.1
A burden is a resource with a CX300 CX506
measurable cost assigned to a case. The OE114 WH130
measurable cost can be an indirect cost, WH132 WH190
assigned to but not directly related to WH222 WH30.1
a case. Examples of burden are salaries, WH30.2 WH30.3
equipment, services, and other indirect WH31.1 WH31.2
costs for capital depreciation, building WH31.3 WH32.1
management, and so on. WH32.2 WH32.3
WH33.5 WH34.1
Use CX15.1 (Burden) or CX504 (HR Labor WH34.2 WH34.3
Import) to define burden codes. Use WH34.4 WH40.1
CX15.1 to view burden codes. WH40.2 WH520
WH830
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 BL92.1 CX100
Pick-List Print Flag Select the proper value to create a CX20.1 CX20.2
pick ticket, post items, or complete the CX20.4 CX20.5
case. CX220 CX30.1
1 = Create Pick List CX300 CX506
2 = Process Post Items OE114 WH130
3 = Complete WH132 WH190
4 = Reprocess WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-PATIENT-CLASS Alpha 1 BL92.1 CX100
Patient Class This field provides for a category of CX20.1 CX20.2
patient. CX20.4 CX20.5
I = Inpatient CX220 CX30.1
O = Outpatient CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-ONLINE-ALLOCAT Alpha 1 BL92.1 CX100
Online Allocation This field indicates whether to allow CX20.1 CX20.2
online or batch allocation. CX20.4 CX20.5
CX220 CX30.1
Select Yes to allow online allocation. CX300 CX506
OE114 WH130
If you select Yes, when you release the WH132 WH190
case, the Case Carts system tries to WH222 WH30.1
allocate all items to the requesting WH30.2 WH30.3
location. WH31.1 WH31.2
WH31.3 WH32.1
Select No to allow batch allocation. WH32.2 WH32.3
WH33.5 WH34.1
If you select No, when you release the WH34.2 WH34.3
case, you must run WH110 (Batch WH34.4 WH40.1
Allocation) to allocate inventory items WH40.2 WH520
for the case. WH830
Y = Yes
N = No
CXH-LAST-REF-NBR Numeric 9 BL92.1 CX100
Last Reference This field contains the last reference CX20.1 CX20.2
Number number. CX20.4 CX20.5
CX220 CX30.1
The system uses this value with the CX300 CX506
Reference Number value in the Case Cart OE114 WH130
Preference Items file to interface with WH132 WH190
WH130 (Pick List Print). WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-AM-PM-FLAG Alpha 2 BL92.1 CX100
A.M. or P.M. Flag This field indicates whether the case CX20.1 CX20.2
start time is for the morning or for the CX20.4 CX20.5
afternoon or evening. CX220 CX30.1
AM = Morning CX300 CX506
PM = Afternoon or Evening OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-COMPL-AM-PM Alpha 2
Completed 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
CXCASEHEAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXHSET1 COMPANY This index is used to access case BL92.1 CX100
REQ-LOCATION header information in Company, CX20.1 CX20.2
CASE Requesting Location, and Case order, CX20.4 CX20.5
CX220 CX225
CX230 CX235
CX240 CX30.1
CX300 CX50.1
CX506 OE114
WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.5
...
CXHSET2 COMPANY The index is used to access Case Cart CX220
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 CX50.1
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 BL92.1 CX100
CASE Header file records in Company, Case, CX20.1 CX20.2
REQ-LOCATION and Requesting Location order. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
...
CXCASEHEAD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxcompany CXCOMPANY Required
CXH-COMPANY -> CXC-COMPANY
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
|