Lawson Insight Technical Documentation |
|
CXCASEHEAD
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
PO23.1 PC310 PC521
UPDATED BY
BL92.1 OE114 WH130 WH132 WH190 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
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 OE114
Element: Company This field contains the company number. WH130 WH132
WH190 WH222
Valid values are WH30.1 WH30.2
WH30.3 WH30.4
Any Case Carts system company, defined WH31.1 WH31.2
in CX01.1 (Healthcare Company) with an WH31.3 WH31.4
equivalent Inventory Control company in WH32.1 WH32.2
IC01.1 (Company). WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-REQ-LOCATION Alpha 5 BL92.1 OE114
Element: To Location This field contains the location WH130 WH132
requisitioning items and receiving WH190 WH222
charges for the items. This location can WH30.1 WH30.2
be an inventory or noninventory WH30.3 WH30.4
location. WH31.1 WH31.2
WH31.3 WH31.4
This value appears as the to location WH32.1 WH32.2
on the pick lists printed when you run WH32.3 WH32.4
CX100 (Pick List Print) and WH130 (Pick WH33.5 WH34.1
List Print). WH34.2 WH34.3
WH34.4 WH40.1
Valid values are WH40.2 WH520
WH830
A requesting location defined in RQ01.1
(Requesting Location) for the specified
healthcare company.
CXH-CASE Alpha 15 BL92.1 OE114
Element: Case This field contains the unique, WH130 WH132
user-assigned identifier for the case. WH190 WH222
WH30.1 WH30.2
A case identifier is used in the Case WH30.3 WH30.4
Carts system to associate specific WH31.1 WH31.2
tasks, practitioners, preference lists, WH31.3 WH31.4
and other information with a particular WH32.1 WH32.2
treatment course. This treatment course WH32.3 WH32.4
may consist of one or more procedures. WH33.5 WH34.1
WH34.2 WH34.3
The Case Carts system uses the case WH34.4 WH40.1
number to interface with an outside WH40.2 WH520
scheduling system. WH830
CXH-SUITE Alpha 5 BL92.1 OE114
Element: Suite This field contains the specific WH130 WH132
location ID for the surgery suite, WH190 WH222
patient room, and so on. WH30.1 WH30.2
WH30.3 WH30.4
The Case Carts system can import the WH31.1 WH31.2
suite number from an outside scheduling WH31.3 WH31.4
system. WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-VISIT-NBR Alpha 12 BL92.1 OE114
Element: Visit Number This field contains the identifier that WH130 WH132
makes a visit unique with a company. WH190 WH222
WH30.1 WH30.2
The Case Carts system can import this WH30.3 WH30.4
value from an outside scheduling system. WH31.1 WH31.2
Alternatively, when using CX20.1 (Case WH31.3 WH31.4
Build), you can select a value from the WH32.1 WH32.2
Patient Charge system for assignment to WH32.3 WH32.4
the case. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-PATIENT-ID Alpha 12 BL92.1 OE114
Element: Patient ID This field uniquely identifies a WH130 WH132
patient within a company. WH190 WH222
WH30.1 WH30.2
The Case Carts system can import this WH30.3 WH30.4
value from an outside scheduling system. WH31.1 WH31.2
Alternatively, when using CX20.1 (Case WH31.3 WH31.4
Build), you can select a value from the WH32.1 WH32.2
Patient Charge system for assignment to WH32.3 WH32.4
the case. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-CX-START-TIME Numeric 4 BL92.1 OE114
Element: Actual Time This field contains the start time for WH130 WH132
the case. WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-START-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Start Date This field contains the date when the WH130 WH132
case starts. WH190 WH222
WH30.1 WH30.2
This value is used in CX206 (Case Value WH30.3 WH30.4
Report) or the Case Carts Analyzer to WH31.1 WH31.2
report on how long procedures are taking WH31.3 WH31.4
to complete WH32.1 WH32.2
WH32.3 WH32.4
For instructions on using these WH33.5 WH34.1
programs, see the Case Carts Procedures WH34.2 WH34.3
Manual. WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-COMPLETED-TIME Numeric 4 BL92.1 OE114
Element: Actual Time This field contains the completion time WH130 WH132
for the case. WH190 WH222
WH30.1 WH30.2
This value is a user-defined time added WH30.3 WH30.4
in CX30.1 (Case Completion Feedback) WH31.1 WH31.2
when finishing a case. WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-COMPLETED-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Completed DateThis field contains the completion date WH130 WH132
for the case. WH190 WH222
WH30.1 WH30.2
For cases assigned multiple procedures, WH30.3 WH30.4
this date equals the procedure WH31.1 WH31.2
completion date of the procedure WH31.3 WH31.4
assigned the final preference sequence WH32.1 WH32.2
number on the case. (The completion date WH32.3 WH32.4
is a user-defined date added in CX30.1 WH33.5 WH34.1
(Case Completion Feedback) when WH34.2 WH34.3
finishing a case.) WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-SERVICE-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Service Date This field identifies the date the item WH130 WH132
was used. This date is used by the WH190 WH222
billing system to identify the charges WH30.1 WH30.2
associated with this case. In the WH30.3 WH30.4
Patient Charge system, this date is WH31.1 WH31.2
called the Charge Date. WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-STATUS Numeric 1 BL92.1 OE114
Element: Status This field contains the case WH130 WH132
transaction status. WH190 WH222
WH30.1 WH30.2
You can continue to change a case until WH30.3 WH30.4
the status has changed to 4 (Charges WH31.1 WH31.2
Passed) or 5 (No Charges). WH31.3 WH31.4
WH32.1 WH32.2
Note: If you add or change a line that WH32.3 WH32.4
is to be picked and the case status is 3 WH33.5 WH34.1
(Complete), the case status returns to 2 WH34.2 WH34.3
(Released). WH34.4 WH40.1
WH40.2 WH520
This status appears in case inquiry WH830
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 BL92.1 OE114
Element: Print Flag This field contains Yes or No. The WH130 WH132
value indicates whether to print the WH190 WH222
Preference/Case listing using CX220 WH30.1 WH30.2
(Case/Preference Listing). WH30.3 WH30.4
Y = Yes WH31.1 WH31.2
N = No WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-OPERATOR-ID Alpha 10 BL92.1 OE114
Element: Operator Code This is the terminal signon identifier WH130 WH132
that was active when this update to the WH190 WH222
database was performed. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-LAST-PREF-SEQ Numeric 3 BL92.1 OE114
Element: Sequence NumbeThis field contains the record sequence WH130 WH132
number. WH190 WH222
WH30.1 WH30.2
The Case Carts system uses this value WH30.3 WH30.4
to track placement of procedures in a WH31.1 WH31.2
multiprocedure case. View and add these WH31.3 WH31.4
values in CX20.2 (Case Detail) and WH32.1 WH32.2
CX30.1 (Case Completion Feedback). WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-LAST-ALT-LINE Numeric 6 BL92.1 OE114
Element: Line Number This field contains the last WH130 WH132
alternative line. WH190 WH222
WH30.1 WH30.2
The system uses this value to track WH30.3 WH30.4
multiple procedures on a case. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-AUTO-REDUCTION Alpha 1 BL92.1 OE114
Element: All Flag This field is reserved for a future WH130 WH132
release of the Case Carts system. WH190 WH222
Y = Yes WH30.1 WH30.2
N = No WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-NORMAL-TIME Numeric 4 BL92.1 OE114
Element: Actual Time This field contains the user-defined WH130 WH132
typical time to complete a procedure. WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-SALARY-RANGE Alpha 1 BL92.1 OE114
Element: Sal Range Fl This field contains the indicator for WH130 WH132
the salary range used for cost analysis. WH190 WH222
This is the default salary range the WH30.1 WH30.2
Case Carts system logic uses when WH30.3 WH30.4
defaulting labor costs to preference WH31.1 WH31.2
templates and patient cases. WH31.3 WH31.4
1 = Min WH32.1 WH32.2
2 = Mid WH32.3 WH32.4
3 = Max WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-CLINICAL-CST Signed 18.2 BL92.1 OE114
Element: Intl Amt This field contains the sum of the WH130 WH132
user-defined clinical costs for each WH190 WH222
case preference. WH30.1 WH30.2
WH30.3 WH30.4
When you add a case using CX20.1 (Case WH31.1 WH31.2
Build), the Case Carts system totals the WH31.3 WH31.4
applicable clinical costs from the Case WH32.1 WH32.2
Cart Preferences file to get this value. WH32.3 WH32.4
WH33.5 WH34.1
Change this value indirectly in one of WH34.2 WH34.3
two ways. The first way is to use CX05.1 WH34.4 WH40.1
(Preference Template) to change the WH40.2 WH520
clinical costs on the applicable WH830
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 Signed 18.2 BL92.1 OE114
Element: Intl Amt This field contains the sum of the WH130 WH132
user-defined distribution costs for each WH190 WH222
case preference. WH30.1 WH30.2
WH30.3 WH30.4
When you add a case using CX20.1 (Case WH31.1 WH31.2
Build), the Case Carts system totals the WH31.3 WH31.4
applicable distribution costs from the WH32.1 WH32.2
Case Cart Preferences file to get this WH32.3 WH32.4
value. WH33.5 WH34.1
WH34.2 WH34.3
Change this value indirectly in one of WH34.4 WH40.1
two ways. The first way is to use CX05.1 WH40.2 WH520
(Preference Template) to change the WH830
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 Signed 18.2 BL92.1 OE114
Element: Intl Amt This field contains the sum of the WH130 WH132
user-defined supply costs for items on a WH190 WH222
case. (A preference is a preference WH30.1 WH30.2
template attached to a case.) WH30.3 WH30.4
WH31.1 WH31.2
This value is updated each time any WH31.3 WH31.4
item cost-related element is changed by WH32.1 WH32.2
adding, deleting, changing quantity, and WH32.3 WH32.4
so on. WH33.5 WH34.1
WH34.2 WH34.3
When you add a case using CX20.1 (Case WH34.4 WH40.1
Build), the Case Carts system totals the WH40.2 WH520
applicable supply costs (Issue Costs) in WH830
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 Signed 18.2 BL92.1 OE114
Element: Intl Amt This field contains the total of all WH130 WH132
costs for a procedure. The costs WH190 WH222
included are those for supplies (items), WH30.1 WH30.2
burden, clinical resources, and WH30.3 WH30.4
distribution resources. WH31.1 WH31.2
WH31.3 WH31.4
This value is updated each time any WH32.1 WH32.2
cost-related element is changed on a WH32.3 WH32.4
case by adding, deleting, changing WH33.5 WH34.1
quantity, and so on. WH34.2 WH34.3
WH34.4 WH40.1
Note: To view this value, use one of WH40.2 WH520
the following features: the Drill Around WH830
(F5) feature in the Pref Code field of
CX20.1 (Case Build), the Case Carts
Analyzer, or a file editor.
CXH-TOTAL-BURDEN Signed 18.2 BL92.1 OE114
Element: Intl Amt This field contains the total costs WH130 WH132
associated with procedure burden codes. WH190 WH222
WH30.1 WH30.2
A burden is a resource with a WH30.3 WH30.4
measurable cost assigned to a case. The WH31.1 WH31.2
measurable cost can be an indirect cost, WH31.3 WH31.4
assigned to but not directly related to WH32.1 WH32.2
a case. Examples of burden are salaries, WH32.3 WH32.4
equipment, services, and other indirect WH33.5 WH34.1
costs for capital depreciation, building WH34.2 WH34.3
management, and so on. WH34.4 WH40.1
WH40.2 WH520
Use CX15.1 (Burden) or CX504 (HR Labor WH830
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 BL92.1 OE114
Element: Pick-List PrinSelect the proper value to create a WH130 WH132
pick ticket, post items, or complete the WH190 WH222
case. WH30.1 WH30.2
1 = Create Pick List WH30.3 WH30.4
2 = Process Post Items WH31.1 WH31.2
3 = Complete WH31.3 WH31.4
4 = Reprocess WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-PATIENT-CLASS Alpha 1 BL92.1 OE114
Element: Patient Class This field provides for a category of WH130 WH132
patient. WH190 WH222
I = Inpatient WH30.1 WH30.2
O = Outpatient WH30.3 WH30.4
B = Both WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-ONLINE-ALLOCAT Alpha 1 BL92.1 OE114
Element: All Flag This field indicates whether to allow WH130 WH132
online or batch allocation. WH190 WH222
WH30.1 WH30.2
Select Yes to allow online allocation. WH30.3 WH30.4
WH31.1 WH31.2
If you select Yes, when you release the WH31.3 WH31.4
case, the Case Carts system tries to WH32.1 WH32.2
allocate all items to the requesting WH32.3 WH32.4
location. WH33.5 WH34.1
WH34.2 WH34.3
Select No to allow batch allocation. WH34.4 WH40.1
WH40.2 WH520
If you select No, when you release the WH830
case, you must run WH110 (Batch
Allocation) to allocate inventory items
for the case.
Y = Yes
N = No
CXH-LAST-REF-NBR Numeric 9 BL92.1 OE114
Last Reference This field contains the last reference WH130 WH132
Number number. WH190 WH222
WH30.1 WH30.2
The system uses this value with the WH30.3 WH30.4
Reference Number value in the Case Cart WH31.1 WH31.2
Preference Items file to interface with WH31.3 WH31.4
WH130 (Pick List Print). WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-AM-PM-FLAG Alpha 2 BL92.1 OE114
Element: A.M. or P.M. FThis field indicates whether the case WH130 WH132
start time is for the morning or for the WH190 WH222
afternoon or evening. WH30.1 WH30.2
AM = AM WH30.3 WH30.4
PM = PM WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
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 20
Social Security
Number
CXH-FLAT-FEE-FL Alpha 1 BL92.1 OE114
Element: Flat Fee Fl N = No WH130 WH132
Y = Yes WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-AUTO-TOTAL Alpha 1 BL92.1 OE114
Element: Auto Total WH130 WH132
WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-ACCT-CATEGORY Alpha 5 BL92.1 OE114
Element: Account CategoAccount categories are groupings of WH130 WH132
costs, revenues, or a combination of WH190 WH222
both used for reporting and inquiries WH30.1 WH30.2
for activities in the Activity WH30.3 WH30.4
Management system. All transactions are WH31.1 WH31.2
posted to an account category within an WH31.3 WH31.4
activity. You can assign a specific WH32.1 WH32.2
General Ledger account or range of WH32.3 WH32.4
accounts (company, accounting unit, WH33.5 WH34.1
account, and subaccount) that make up WH34.2 WH34.3
the transactions posted to an account WH34.4 WH40.1
category using AC07.1 (Account WH40.2 WH520
Assignment). WH830
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
CXH-ACTIVITY Alpha 15 BL92.1 OE114
Element: Activity Activities are the processes or WH130 WH132
procedures that produce work. Cost WH190 WH222
objects (products, services, customers, WH30.1 WH30.2
and so on) are the reasons for WH30.3 WH30.4
performing the activity. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXH-ATN-OBJ-ID Numeric 12 BL92.1 OE114
Object The system-defined object id WH130 WH132
Identification representing the Activity Management WH190 WH222
commitment. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXCASEHEAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXHSET1 COMPANY This index is used to access case BL92.1 OE114
REQ-LOCATION header information in Company, PO23.1 WH130
CASE Requesting Location, and Case order, WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
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 BL92.1 OE114
CASE Header file records in Company, Case, WH130 WH132
REQ-LOCATION and Requesting Location order. WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
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
|