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