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