CXCASEPREF FILE
Case Cart Preferences
The Case Cart Preferences file contains header records for case preference
lists. The header information consists of data for a specific procedure for a
case. Use CX20.1 (Case Build) or CX506 (HL7 Schedules Import Interface) to
create records in this file. In CX20.1, when you add a preference template to
a case, the Case Carts system adds the applicable preference template data to
this file. To delete a record from this file, use CX20.1, select the Delete
line action for the procedure to delete, and select the Change form action. If
you import cases using CX506, the Case Carts system automatically assigns this
information based on the procedure code imported from the outside scheduling
system.
A different practitioner can be assigned to each procedure within a case.
Additional files store other case preference data. The Preference Items file
contains items, the Preference Diagnostics file contains diagnostic codes, and
Attachment files in the Environment contain comments.
REFERENCED BY
CX230 CX235 CX240 CX50.1 CXA3.1 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE830 OE950 PO31.1 RQ35.1 WH20.7
WO132 WO140 CX225
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 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
CXP-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
Valid entries: CX220 CX30.1
CX300 CX506
Any Case Carts system company, defined CXCP.1 OE114
in CX01.1 (Healthcare Company) and with WH130 WH132
an equivalent Inventory Control company WH190 WH222
in IC01.1 (Company). 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
CXP-REQ-LOCATION Alpha 5 BL92.1 CX100
Requesting Location This field contains the location CX20.1 CX20.2
requisitioning items and to be charged CX20.4 CX20.5
for the items. This location can be an CX220 CX30.1
inventory or noninventory location. CX300 CX506
CXCP.1 OE114
This value appears as the to location WH130 WH132
on CX100 (Pick List Print) and WH130 WH190 WH222
(Pick List Print). WH30.1 WH30.2
WH30.3 WH31.1
Valid values are WH31.2 WH31.3
WH32.1 WH32.2
A requesting location defined in RQ01.1 WH32.3 WH33.5
(Requesting Location) for the specified WH34.1 WH34.2
healthcare company. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-CASE Alpha 10 BL92.1 CX100
Case This field contains the unique CX20.1 CX20.2
identifier for the case. CX20.4 CX20.5
CX220 CX30.1
A case identifier is used in the Case CX300 CX506
Carts system to associate specific CXCP.1 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 number can be used to WH32.1 WH32.2
interface with an outside scheduling WH32.3 WH33.5
system. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PREF-CODE Alpha 8 BL92.1 CX100
Preference Code This field contains a Preference Code CX20.1 CX20.2
for a preference template defined in CX20.4 CX20.5
CX05.1 (Preference Template). The CX220 CX30.1
preference code is one of the key fields CX300 CX506
that define a preference template. You CXCP.1 OE114
might decide to define a preference code WH130 WH132
as a procedure category found in a WH190 WH222
procedure code catalog issued by the WH30.1 WH30.2
government, insurer, or regulatory body. WH30.3 WH31.1
Based on such an approach, you might WH31.2 WH31.3
define a preference code as ANESTH for WH32.1 WH32.2
Anesthesia-related procedures. For WH32.3 WH33.5
another example, you might define RESP WH34.1 WH34.2
for Respiratory-related procedures. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-SEQ Numeric 3 BL92.1 CX100
Sequence This field contains the record sequence CX20.1 CX20.2
number for a procedure assigned to the CX20.4 CX20.5
case. CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-PROC-TYPE Alpha 8 BL92.1 CX100
Procedure Type The procedure type is the first of two CX20.1 CX20.2
fields that uniquely identify a CX20.4 CX20.5
procedure. The procedure type can CX220 CX30.1
identify the code set to which the CX300 CX506
procedure code belongs. CXCP.1 OE114
WH130 WH132
For example, you can use one of the WH190 WH222
following codes: WH30.1 WH30.2
- CPT-4 for a code in the Current WH30.3 WH31.1
Procedural Terminology listing compiled WH31.2 WH31.3
by the American Medical Association WH32.1 WH32.2
-HCPCS for a code in HCFA's (Health WH32.3 WH33.5
Care Financing Administration's) Common WH34.1 WH34.2
Procedure Coding System, or WH34.3 WH34.4
- A code defined for your WH40.1 WH40.2
organization's own procedures listing. WH520 WH830
This value defaults from the Preference
Template file when you add a preference
template to a case. This value cannot be
changed on a case.
Use CX05.1 (Preference Template) to
change the procedure type assigned to a
procedure on a template.
CXP-PROC-CODE Alpha 8 BL92.1 CX100
Procedure Code The procedure code is the second of two CX20.1 CX20.2
fields that uniquely identify a CX20.4 CX20.5
procedure. The procedure code is an CX220 CX30.1
identifier for a specific procedure CX300 CX506
within a procedure type. CXCP.1 OE114
WH130 WH132
This value defaults from the Preference WH190 WH222
Template file when you add a preference WH30.1 WH30.2
template to a case. This value cannot be WH30.3 WH31.1
changed on a case. WH31.2 WH31.3
WH32.1 WH32.2
Use CX05.1 (Preference Template) to WH32.3 WH33.5
change the Procedure Code assigned to a WH34.1 WH34.2
procedure on a preference template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PRACTNR-ID Alpha 15 BL92.1 CX100
Practitioner ID This field contains the practitioner CX20.1 CX20.2
ID. This value must be unique for each CX20.4 CX20.5
practitioner in the Case Carts system. CX220 CX240
This value defaults from the Preference CX30.1 CX300
Template file. CX506 CXCP.1
OE114 WH130
This value cannot be changed on a case. WH132 WH190
Use CX05.1 (Preference Template) to WH222 WH30.1
change the practitioner ID assigned to a WH30.2 WH30.3
procedure on a template. 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
CXP-PREF-DESCRIPT Alpha 15 BL92.1 CX100
Description This field contains a short description CX20.1 CX20.2
for the procedure that may contain a CX20.4 CX20.5
more generic short description as an CX220 CX30.1
alternative to the standard procedure CX300 CX506
description. CXCP.1 OE114
WH130 WH132
This value defaults from the Preference WH190 WH222
Template file when you add a preference WH30.1 WH30.2
template to a case. WH30.3 WH31.1
WH31.2 WH31.3
This value cannot be changed on a case. WH32.1 WH32.2
WH32.3 WH33.5
Use CX05.1 (Preference Template) to WH34.1 WH34.2
change the Preference Description WH34.3 WH34.4
assigned to a procedure on a template. WH40.1 WH40.2
WH520 WH830
CXP-LAST-LINE-NBR Numeric 6 BL92.1 CX100
Last Line Nbr This field contains the number of the CX20.1 CX20.2
last line item added to the case. The CX20.4 CX20.5
number is used to determine the number CX220 CX30.1
when the next line is added to the case. CX300 CX506
This value is automatically updated as CXCP.1 OE114
you add case lines. 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
CXP-PROC-DESC Alpha 250 (Lower Case) CXCP.1
Description This field contains the procedure
description.
Until a case status changes to 4 for
Charges Passed or 5 for No Charges, this
value displays from the Procedures file.
After a case is finished (status 4 or
5), this value cannot be changed here.
CXP-CLINICAL-CST Currency 15.2 BL92.1 CX100
Clinical Cost This field contains the user-defined CX20.1 CX20.2
clinical costs for a preference. This is CX20.4 CX20.5
a user-defined subtotal that is part of CX220 CX30.1
the Total Procedure Cost. The clinical CX300 CX506
costs can be any costs not included in CXCP.1 OE114
distribution, supplies, and burden WH130 WH132
costs. These latter costs along with the WH190 WH222
clinical costs make up the Total WH30.1 WH30.2
Procedure Cost. WH30.3 WH31.1
WH31.2 WH31.3
When you add a case using CX20.1 (Case WH32.1 WH32.2
Build), this value defaults from the WH32.3 WH33.5
appropriate record of the Preference WH34.1 WH34.2
Template file. WH34.3 WH34.4
WH40.1 WH40.2
Change this value indirectly in one of WH520 WH830
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 case. The second way is
to type a new value (if blank) or type
over the existing value in the Clinical
Cost field. The Clinical Cost field
appears 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 Procedure
Cost tab of CX20.2 (Case Detail), the
Case Carts Analyzer, or a file editor.
CXP-DIST-CST Currency 15.2 BL92.1 CX100
Distribution Cost This field contains the user-defined CX20.1 CX20.2
total distribution costs for the case CX20.4 CX20.5
procedure. CX220 CX30.1
CX300 CX506
Distribution costs are a subtotal of CXCP.1 OE114
the Total Procedure Cost. The subtotal WH130 WH132
represents costs not included in costs WH190 WH222
for clinical resources, supplies, and WH30.1 WH30.2
burden. WH30.3 WH31.1
WH31.2 WH31.3
This value defaults from the Preference WH32.1 WH32.2
Template file when you add a preference WH32.3 WH33.5
template to a case. 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
clinical costs on the applicable
template and then delete and re-add the
template to the case. The second way is
to type a new value (if blank) or type
over the existing value in the Clinical
Cost field. The Clinical Cost field
appears 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 Procedure
Cost tab of CX20.2 (Case Detail), the
Case Carts Analyzer, or a file editor.
CXP-SUPPLY-CST Currency 15.2 BL92.1 CX100
Supply Cost This field contains the user-defined CX20.1 CX20.2
total supply costs for the case CX20.4 CX20.5
procedure. CX220 CX30.1
CX300 CX506
Supplies are items assigned to a case. CXCP.1 OE114
WH130 WH132
This value defaults from the Preference WH190 WH222
Template file when you add a preference WH30.1 WH30.2
template to a case. WH30.3 WH31.1
WH31.2 WH31.3
Change this value indirectly in one of WH32.1 WH32.2
two ways. The first way is to use CX05.1 WH32.3 WH33.5
(Preference Template) to change the WH34.1 WH34.2
extended supply costs on the applicable WH34.3 WH34.4
template and then delete and re-add the WH40.1 WH40.2
template to the case. The second way is WH520 WH830
to type a new value (if blank) or type
over the value in the Cost field for
items to be changed. The Cost field
appears in the Items tab, Detail detail
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 Procedure
Cost tab of CX20.2 (Case Detail), the
Case Carts Analyzer, or a file editor.
CXP-TOTAL-CST Currency 15.2 BL92.1 CX100
Total Cost This field contains the total of all CX20.1 CX20.2
costs (clinical, distribution, supply, CX20.4 CX20.5
and burden) recorded for the case CX220 CX30.1
procedure in the Case Carts system. CX300 CX506
CXCP.1 OE114
This value defaults from the Preference WH130 WH132
Template file when you add a preference WH190 WH222
template to a case. WH30.1 WH30.2
WH30.3 WH31.1
This value is updated each time any WH31.2 WH31.3
cost-related element is changed on a WH32.1 WH32.2
case by adding, deleting, changing WH32.3 WH33.5
quantity, and so on. 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
cost-related data on the applicable
template and then delete and re-add the
template to the case. The second way is
to type a new value (if blank) or type
over the value in the applicable
cost-related data in CX20.2 (Case
Detail) for items to be changed. 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 Procedure
Cost tab of CX20.2 (Case Detail), the
Case Carts Analyzer, or a file editor.
CXP-TOTAL-BURDEN Currency 15.2 BL92.1 CX100
Total Burden This field contains the total burden CX20.1 CX20.2
costs for the case procedure. CX20.4 CX20.5
CX220 CX30.1
This value defaults from the Preference CX300 CX506
Template file when you add a preference CXCP.1 OE114
template to a case. WH130 WH132
WH190 WH222
Change this value indirectly in one of WH30.1 WH30.2
two ways. The first way is to use CX05.1 WH30.3 WH31.1
(Preference Template) to change the WH31.2 WH31.3
burden cost-related data on the WH32.1 WH32.2
applicable template and then delete and WH32.3 WH33.5
re-add the template to the case. The WH34.1 WH34.2
second way is to type a new value (if WH34.3 WH34.4
blank) or type over the value in the WH40.1 WH40.2
applicable burden cost-related data in WH520 WH830
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 Procedure
Cost tab of CX20.2 (Case Detail), the
Case Carts Analyzer, or a file editor.
To view individual Burden codes on a
case preference, choose the Burden tab
in CX20.2 (Case Detail).
CXP-NORMAL-TIME Numeric 4 BL92.1 CX100
Normal Time This field defines the typical (normal) CX20.1 CX20.2
time taken to perform a specific CX20.4 CX20.5
procedure. CX220 CX30.1
CX300 CX506
This value defaults from the Preference CXCP.1 OE114
Template file when you add a preference WH130 WH132
template to a case. WH190 WH222
WH30.1 WH30.2
Use CX05.1 (Preference Template) to WH30.3 WH31.1
change the normal time assigned to a WH31.2 WH31.3
procedure on a template. WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-EST-PROC-TIME Numeric 4 BL92.1 CX100
Estimated Procedure This field contains the estimated time CX20.1 CX20.2
Time to complete the procedure. CX20.4 CX20.5
CX220 CX30.1
This value defaults from the Preference CX300 CX506
Template file when you add a preference CXCP.1 OE114
template to a case. This value cannot be WH130 WH132
changed on a case. WH190 WH222
WH30.1 WH30.2
Use CX05.1 (Preference Template) to WH30.3 WH31.1
change the estimated procedure time WH31.2 WH31.3
assigned to a procedure on a template. WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROCEDURE-TIME Numeric 4 BL92.1 CX100
Procedure Time This field contains the actual time to CX20.1 CX20.2
complete the procedure. CX20.4 CX20.5
CX220 CX30.1
This value defaults from the Preference CX300 CX506
Template file when you add a preference CXCP.1 OE114
template to a case. This value cannot be WH130 WH132
changed on a case. WH190 WH222
WH30.1 WH30.2
Use CX05.1 (Preference Template) to WH30.3 WH31.1
change the procedure time assigned to a WH31.2 WH31.3
procedure on a template. WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-ACCT-CATEGORY Alpha 5 BL92.1 CX100
Account Category This field contains a valid account CX20.1 CX20.2
category as defined in the Activity CX20.4 CX20.5
Management system. CX220 CX30.1
CX300 CX506
This value defaults from the Preference CXCP.1 OE114
Template file when you add a preference WH130 WH132
template to a case. WH190 WH222
WH30.1 WH30.2
Use CX05.1 (Preference Template) to WH30.3 WH31.1
change the account category assigned to WH31.2 WH31.3
a procedure on a template. WH32.1 WH32.2
WH32.3 WH33.5
Note: Use of the Activity Management WH34.1 WH34.2
system to track and report costs WH34.3 WH34.4
recorded in the Case Carts system is WH40.1 WH40.2
reserved for a future release. WH520 WH830
CXP-ACTIVITY Alpha 15 BL92.1 CX100
Activity This field contains a valid activity CX20.1 CX20.2
code of the Activity Management system. CX20.4 CX20.5
CX220 CX30.1
This value defaults from the Preference CX300 CX506
Template file when you add a preference CXCP.1 OE114
template to a case. WH130 WH132
WH190 WH222
Use CX05.1 (Preference Template) to WH30.1 WH30.2
change the activity assigned to a WH30.3 WH31.1
procedure on a template. WH31.2 WH31.3
WH32.1 WH32.2
Note: Use of the Activity Management WH32.3 WH33.5
system to track and report costs WH34.1 WH34.2
recorded in the Case Carts system is WH34.3 WH34.4
reserved for a future release. WH40.1 WH40.2
WH520 WH830
CXP-ATN-OBJ-ID Numeric 12 BL92.1 CX100
Atn Object ID This field contains a system-assigned CX20.1 CX20.2
identifier that provides access to data CX20.4 CX20.5
in related files. CX220 CX30.1
CX300 CX506
This value defaults from the Preference CXCP.1 OE114
Template file when you add a preference WH130 WH132
template to a case. This value cannot be WH190 WH222
changed on a case. WH30.1 WH30.2
WH30.3 WH31.1
Use CX05.1 (Preference Template) to WH31.2 WH31.3
change the value assigned to a procedure WH32.1 WH32.2
on a template. WH32.3 WH33.5
WH34.1 WH34.2
Note: Use of this field is reserved WH34.3 WH34.4
for a future release. WH40.1 WH40.2
WH520 WH830
CXP-DATE-COMPLETED Numeric 8 (yyyymmdd) BL92.1 CX100
Date Completed This field contains the date the case CX20.1 CX20.2
was completed. CX20.4 CX20.5
CX220 CX30.1
This value defaults from the Preference CX300 CX506
Template file when you add a preference CXCP.1 OE114
template to a case. This value cannot be WH130 WH132
changed on a case. WH190 WH222
WH30.1 WH30.2
Use CX05.1 (Preference Template) to WH30.3 WH31.1
change the date assigned to a procedure WH31.2 WH31.3
on a template. WH32.1 WH32.2
WH32.3 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LST-PRFJOB-SEQ Numeric 3 BL92.1 CX100
Last Preference Job This field contains the record sequence CX20.1 CX20.2
Sequence number assigned to the burden code on CX20.4 CX20.5
the template. This value is CX220 CX30.1
automatically updated as you add case CX300 CX506
burden codes. CXCP.1 OE114
WH130 WH132
This value defaults from the Preference WH190 WH222
Template file when you add a preference WH30.1 WH30.2
template to a case. WH30.3 WH31.1
WH31.2 WH31.3
Use CX05.1 (Preference Template) to WH32.1 WH32.2
change the Prf Job Seq assigned to a WH32.3 WH33.5
procedure on a template. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-STATUS Numeric 1 BL92.1 CX100
Status This field contains the procedure CX20.1 CX20.2
transaction status. CX20.4 CX20.5
1 = Created CX220 CX30.1
2 = Complete CX300 CX506
CXCP.1 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
CXP-STOCKLESS-FL Alpha 1 BL92.1 CX100
Stockless Flag Select Yes to indicate that the item is CX20.1 CX20.2
a stockless item. CX20.4 CX20.5
CX220 CX30.1
Note: Use of this field is reserved CX300 CX506
for a future release. CXCP.1 OE114
Y = Yes WH130 WH132
N = No 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
CXP-DEL-TO-LOC Alpha 5 BL92.1 CX100
Delete To Location This field defines the deliver-to CX20.1 CX20.2
location. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-HR-RATE-TOTAL Currency 15.2 BL92.1 CX100
HR Rate Total This field defines the hourly rate CX20.1 CX20.2
total. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-OT-RATE-TOTAL Currency 15.2 BL92.1 CX100
OT Rate Total This field defines the other rate total. CX20.1 CX20.2
CX20.4 CX20.5
This is a system-maintained subtotal, CX220 CX30.1
consisting of the total for Unit, Flat CX300 CX506
Fee, Rental Hourly, and Daily Rental CXCP.1 OE114
types, used to calculate the total WH130 WH132
procedure cost. The Case Carts system WH190 WH222
logic also updates the other rate total WH30.1 WH30.2
in the Case Cart Preferences file. 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
CXP-CX-START-TIME Numeric 4 BL92.1 CX100
Case Start Time This field contains the time when the CX20.1 CX20.2
procedure starts. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-START-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Start Date This field contains the date when the CX20.1 CX20.2
procedure starts. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-LAST-CHG-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Last Charge Date This date indicates the last date when CX20.1 CX20.2
changes were made. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-LAST-CHG-TIME Numeric 4 BL92.1 CX100
Last Charge Time This field contains the time of the CX20.1 CX20.2
last change to the case. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-OPERATOR-ID Alpha 10 BL92.1 CX100
Operator ID This field contains the terminal signon CX20.1 CX20.2
identifier when this update to the CX20.4 CX20.5
database was performed. CX220 CX30.1
CX300 CX506
CXCP.1 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
CXP-AM-PM-FLAG Alpha 2 BL92.1 CX100
A.M. or P.M. Flag This field indicates whether the start CX20.1 CX20.2
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 CXCP.1 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
CXP-LEADTIME-DAYS Numeric 3
Leadtime Days This field contains the leadtime (in
days) required to allocate inventory
items. If the preference template has a
leadtime defined, the value defaults to
the case preference. Otherwise, the case
company default leadtime defaults.
CXP-COMPLETED-TIME Numeric 4 BL92.1 CX100
Completed Time This field contains the completion time CX20.1 CX20.2
for the 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
CXP-COMPL-AM-PM Alpha 2 BL92.1 CX100
Completed A.M. or This field indicates whether the time CX20.1 CX20.2
P.M. Flag is for the morning or for the afternoon CX20.4 CX20.5
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
CXCASEPREF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXPSET1 COMPANY This index is used to access the Case BL92.1 CX100
REQ-LOCATION Cart Preferences file records in CX20.1 CX20.2
CASE Company, Requesting Location, Case, and CX20.3 CX20.4
SEQ Sequence number order. CX20.5 CX220
CX230 CX235
CX240 CX30.1
CX300 CX50.1
CX506 CXA3.1
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
...
CXPSET2 COMPANY This index is used to access the Case CX50.1
REQ-LOCATION Cart Preferences file records in
PROC-TYPE Company, Requesting Location, Procedure
PROC-CODE Type, Procedure Code, Case, and Sequence
CASE number order.
SEQ
CXPSET3 COMPANY This index is used to access the Case CX225
REQ-LOCATION Cart Preferences file records in
PRACTNR-ID Company, Requesting Location,
CASE Practitioner ID, Case, and Sequence
SEQ number order.
CXPSET4 COMPANY This index is used to access the Case CX50.1
REQ-LOCATION Cart Preferences file records in
PREF-DESCRIPT Company, Requesting Location, Preference
CASE Description, Case, and Sequence number
SEQ order.
CXPSET5 COMPANY This index is used to access the Case CX225
PRACTNR-ID Cart Preferences file records in
REQ-LOCATION Company, Practitioner ID, Requesting
CASE Location, Case, and Sequence number
SEQ order.
CXPSET6 ATN-OBJ-ID This index is used to access the Case
Cart Preferences file object records.
Note: This feature is planned for a
future release.
KeyChange, Duplicates
CXPSET7 COMPANY This index is used to access the Case CX50.1
REQ-LOCATION Cart Preferences file records in
PREF-CODE Company, Requesting Location,
CASE Preference Code, Case, and Sequence
SEQ number order.
CXCASEPREF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cccasehead CXCASEHEAD Required
CXP-COMPANY -> CXH-COMPANY
CXP-REQ-LOCATION -> CXH-REQ-LOCATION
CXP-CASE -> CXH-CASE
Ccpracproc CXPRACPROC Required
CXP-COMPANY -> CPP-COMPANY
CXP-PRACTNR-ID -> CPP-PRACTNR-ID
CXP-PROC-TYPE -> CPP-PROC-TYPE
CXP-PROC-CODE -> CPP-PROC-CODE
Cxprocedr CXPROCEDR Required
CXP-PROC-TYPE -> CPC-PROC-TYPE
CXP-PROC-CODE -> CPC-PROC-CODE
Gen Pref Temp CXPREFTEMP Required
CXP-COMPANY -> CPT-COMPANY
CXP-REQ-LOCATION -> CPT-REQ-LOCATION
CXP-PREF-CODE -> CPT-PREF-CODE
CXP-PROC-TYPE -> CPT-PROC-TYPE
CXP-PROC-CODE -> CPT-PROC-CODE
Spaces -> CPT-PRACTNR-ID
Prac Pref Temp CXPREFTEMP Required
CXP-COMPANY -> CPT-COMPANY
CXP-REQ-LOCATION -> CPT-REQ-LOCATION
CXP-PREF-CODE -> CPT-PREF-CODE
CXP-PROC-TYPE -> CPT-PROC-TYPE
CXP-PROC-CODE -> CPT-PROC-CODE
CXP-PRACTNR-ID -> CPT-PRACTNR-ID
Practitioner CXPRACTNR Required
CXP-PRACTNR-ID -> CPR-PRACTNR-ID
CXCASEPREF FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ccprefdiag CXPREFDIAG Delete Cascades
CXP-COMPANY -> CPD-COMPANY
CXP-REQ-LOCATION -> CPD-REQ-LOCATION
CXP-CASE -> CPD-CASE
CXP-SEQ -> CPD-SEQ
CPD-DIAG-TYPE
CPD-DIAG-CODE
Cxprefitem CXPREFITEM Delete Cascades
CXP-COMPANY -> CPI-COMPANY
CXP-REQ-LOCATION -> CPI-REQ-LOCATION
CXP-CASE -> CPI-CASE
CXP-SEQ -> CPI-SEQ
CPI-LINE-NBR
Cxprefjobs CXPREFJOBS Delete Cascades
CXP-COMPANY -> CPJ-COMPANY
CXP-REQ-LOCATION -> CPJ-REQ-LOCATION
CXP-CASE -> CPJ-CASE
CXP-SEQ -> CPJ-SEQ
CPJ-JOB-CODE
CPJ-SCHEDULE
CPJ-PAY-GRADE
CPJ-PRFJOB-SEQ
Itemhistory CXITEMHIST
CXP-COMPANY -> CIH-COMPANY
CXP-REQ-LOCATION -> CIH-REQ-LOCATION
CXP-CASE -> CIH-CASE
CXP-SEQ -> CIH-SEQ
CIH-LINE-NBR
CIH-REASON-CODE
CIH-REASON-TYPE
Laborhistory CXLABRHIST
CXP-COMPANY -> CLH-COMPANY
CXP-REQ-LOCATION -> CLH-REQ-LOCATION
CXP-CASE -> CLH-CASE
CXP-SEQ -> CLH-SEQ
CLH-JOB-CODE
CLH-SCHEDULE
CLH-PAY-GRADE
CLH-PRFJOB-SEQ
|