Lawson Insight Technical Documentation |
|
CXCASEPREF
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 IC28.1 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
PO100 PO101 PO122 PO131 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 POI3.1
POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ35.1
WH20.2 WH20.7 WO132 WO140
UPDATED BY
BL92.1 CXCP.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
CXP-COMPANY Numeric 4 BL92.1 CXCP.1
Element: Company This field contains the company number. OE114 WH130
WH132 WH190
Valid entries: WH222 WH30.1
WH30.2 WH30.3
Any Case Carts system company, defined WH30.4 WH31.1
in CX01.1 (Healthcare Company) and with WH31.2 WH31.3
an equivalent Inventory Control company WH31.4 WH32.1
in IC01.1 (Company). WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-REQ-LOCATION Alpha 5 BL92.1 CXCP.1
Element: To Location This field contains the location OE114 WH130
requisitioning items and to be charged WH132 WH190
for the items. This location can be an WH222 WH30.1
inventory or noninventory location. WH30.2 WH30.3
WH30.4 WH31.1
This value appears as the to location WH31.2 WH31.3
on CX100 (Pick List Print) and WH130 WH31.4 WH32.1
(Pick List Print). WH32.2 WH32.3
WH32.4 WH33.5
Valid values are WH34.1 WH34.2
WH34.3 WH34.4
A requesting location defined in RQ01.1 WH40.1 WH40.2
(Requesting Location) for the specified WH520 WH830
healthcare company.
CXP-CASE Alpha 15 BL92.1 CXCP.1
Element: Case This field contains the unique OE114 WH130
identifier for the case. WH132 WH190
WH222 WH30.1
A case identifier is used in the Case WH30.2 WH30.3
Carts system to associate specific WH30.4 WH31.1
tasks, practitioners, preference lists, WH31.2 WH31.3
and other information with a particular WH31.4 WH32.1
treatment course. This treatment course WH32.2 WH32.3
may consist of one or more procedures. WH32.4 WH33.5
WH34.1 WH34.2
The case number can be used to WH34.3 WH34.4
interface with an outside scheduling WH40.1 WH40.2
system. WH520 WH830
CXP-PREF-CODE Alpha 8 BL92.1 CXCP.1
Element: Procedure CodeThis field contains a Preference Code OE114 WH130
for a preference template defined in WH132 WH190
CX05.1 (Preference Template). The WH222 WH30.1
preference code is one of the key fields WH30.2 WH30.3
that define a preference template. You WH30.4 WH31.1
might decide to define a preference code WH31.2 WH31.3
as a procedure category found in a WH31.4 WH32.1
procedure code catalog issued by the WH32.2 WH32.3
government, insurer, or regulatory body. WH32.4 WH33.5
Based on such an approach, you might WH34.1 WH34.2
define a preference code as ANESTH for WH34.3 WH34.4
Anesthesia-related procedures. For WH40.1 WH40.2
another example, you might define RESP WH520 WH830
for Respiratory-related procedures.
CXP-SEQ Numeric 3 BL92.1 CXCP.1
Element: Sequence NumbeThis field contains the record sequence OE114 WH130
number for a procedure assigned to the WH132 WH190
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
CXP-PROC-TYPE Alpha 8 BL92.1 CXCP.1
Element: Procedure CodeThe procedure type is the first of two OE114 WH130
fields that uniquely identify a WH132 WH190
procedure. The procedure type can WH222 WH30.1
identify the code set to which the WH30.2 WH30.3
procedure code belongs. WH30.4 WH31.1
WH31.2 WH31.3
For example, you can use one of the WH31.4 WH32.1
following codes: WH32.2 WH32.3
- CPT-4 for a code in the Current WH32.4 WH33.5
Procedural Terminology listing compiled WH34.1 WH34.2
by the American Medical Association WH34.3 WH34.4
-HCPCS for a code in HCFA's (Health WH40.1 WH40.2
Care Financing Administration's) Common WH520 WH830
Procedure Coding System, or
- A code defined for your
organization's own procedures listing.
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 CXCP.1
Element: Procedure CodeThe procedure code is the second of two OE114 WH130
fields that uniquely identify a WH132 WH190
procedure. The procedure code is an WH222 WH30.1
identifier for a specific procedure WH30.2 WH30.3
within a procedure type. WH30.4 WH31.1
WH31.2 WH31.3
This value defaults from the Preference WH31.4 WH32.1
Template file when you add a preference WH32.2 WH32.3
template to a case. This value cannot be WH32.4 WH33.5
changed on a case. WH34.1 WH34.2
WH34.3 WH34.4
Use CX05.1 (Preference Template) to WH40.1 WH40.2
change the Procedure Code assigned to a WH520 WH830
procedure on a preference template.
CXP-PRACTNR-ID Alpha 15 BL92.1 CXCP.1
Element: Practitioner IThis field contains the practitioner OE114 WH130
ID. This value must be unique for each WH132 WH190
practitioner in the Case Carts system. WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file. WH30.4 WH31.1
WH31.2 WH31.3
This value cannot be changed on a case. WH31.4 WH32.1
Use CX05.1 (Preference Template) to WH32.2 WH32.3
change the practitioner ID assigned to a WH32.4 WH33.5
procedure on a template. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PREF-DESCRIPT Alpha 15 BL92.1 CXCP.1
Preference This field contains a short description OE114 WH130
Description for the procedure that may contain a WH132 WH190
more generic short description as an WH222 WH30.1
alternative to the standard procedure WH30.2 WH30.3
description. WH30.4 WH31.1
WH31.2 WH31.3
This value defaults from the Preference WH31.4 WH32.1
Template file when you add a preference WH32.2 WH32.3
template to a case. WH32.4 WH33.5
WH34.1 WH34.2
This value cannot be changed on a case. WH34.3 WH34.4
WH40.1 WH40.2
Use CX05.1 (Preference Template) to WH520 WH830
change the Preference Description
assigned to a procedure on a template.
CXP-LAST-LINE-NBR Numeric 6 BL92.1 CXCP.1
Element: Line Number This field contains the number of the OE114 WH130
last line item added to the case. The WH132 WH190
number is used to determine the number WH222 WH30.1
when the next line is added to the case. WH30.2 WH30.3
This value is automatically updated as WH30.4 WH31.1
you add case lines. 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
CXP-PROC-DESC Alpha 250 (Lower Case) CXCP.1
Element: Diag Desc 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 Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the user-defined OE114 WH130
clinical costs for a preference. This is WH132 WH190
a user-defined subtotal that is part of WH222 WH30.1
the Total Procedure Cost. The clinical WH30.2 WH30.3
costs can be any costs not included in WH30.4 WH31.1
distribution, supplies, and burden WH31.2 WH31.3
costs. These latter costs along with the WH31.4 WH32.1
clinical costs make up the Total WH32.2 WH32.3
Procedure Cost. WH32.4 WH33.5
WH34.1 WH34.2
When you add a case using CX20.1 (Case WH34.3 WH34.4
Build), this value defaults from the WH40.1 WH40.2
appropriate record of the Preference WH520 WH830
Template file.
Change this value indirectly in one of
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 Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the user-defined OE114 WH130
total distribution costs for the case WH132 WH190
procedure. WH222 WH30.1
WH30.2 WH30.3
Distribution costs are a subtotal of WH30.4 WH31.1
the Total Procedure Cost. The subtotal WH31.2 WH31.3
represents costs not included in costs WH31.4 WH32.1
for clinical resources, supplies, and WH32.2 WH32.3
burden. WH32.4 WH33.5
WH34.1 WH34.2
This value defaults from the Preference WH34.3 WH34.4
Template file when you add a preference WH40.1 WH40.2
template to a case. WH520 WH830
Change this value indirectly in one of
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-SUPPLY-CST Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the user-defined OE114 WH130
total supply costs for the case WH132 WH190
procedure. WH222 WH30.1
WH30.2 WH30.3
Supplies are items assigned to a case. WH30.4 WH31.1
WH31.2 WH31.3
This value defaults from the Preference WH31.4 WH32.1
Template file when you add a preference WH32.2 WH32.3
template to a case. 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
extended supply 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 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 Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the total of all OE114 WH130
costs (clinical, distribution, supply, WH132 WH190
and burden) recorded for the case WH222 WH30.1
procedure in the Case Carts system. WH30.2 WH30.3
WH30.4 WH31.1
This value defaults from the Preference WH31.2 WH31.3
Template file when you add a preference WH31.4 WH32.1
template to a case. WH32.2 WH32.3
WH32.4 WH33.5
This value is updated each time any WH34.1 WH34.2
cost-related element is changed on a WH34.3 WH34.4
case by adding, deleting, changing WH40.1 WH40.2
quantity, and so on. WH520 WH830
Change this value indirectly in one of
two ways. The first way is to use CX05.1
(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 Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the total burden OE114 WH130
costs for the case procedure. WH132 WH190
WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file when you add a preference WH30.4 WH31.1
template to a case. WH31.2 WH31.3
WH31.4 WH32.1
Change this value indirectly in one of WH32.2 WH32.3
two ways. The first way is to use CX05.1 WH32.4 WH33.5
(Preference Template) to change the WH34.1 WH34.2
burden cost-related data on the WH34.3 WH34.4
applicable template and then delete and WH40.1 WH40.2
re-add the template to the case. The WH520 WH830
second way is to type a new value (if
blank) or type over the value in the
applicable burden cost-related data in
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 CXCP.1
Element: Actual Time This field defines the typical (normal) OE114 WH130
time taken to perform a specific WH132 WH190
procedure. WH222 WH30.1
WH30.2 WH30.3
This value defaults from the Preference WH30.4 WH31.1
Template file when you add a preference WH31.2 WH31.3
template to a case. WH31.4 WH32.1
WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the normal time assigned to a WH34.1 WH34.2
procedure on a template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-EST-PROC-TIME Numeric 4 BL92.1 CXCP.1
Element: Actual Time This field contains the estimated time OE114 WH130
to complete the procedure. WH132 WH190
WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file when you add a preference WH30.4 WH31.1
template to a case. This value cannot be WH31.2 WH31.3
changed on a case. WH31.4 WH32.1
WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the estimated procedure time WH34.1 WH34.2
assigned to a procedure on a template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PROCEDURE-TIME Numeric 4 BL92.1 CXCP.1
Element: Actual Time This field contains the actual time to OE114 WH130
complete the procedure. WH132 WH190
WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file when you add a preference WH30.4 WH31.1
template to a case. This value cannot be WH31.2 WH31.3
changed on a case. WH31.4 WH32.1
WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the procedure time assigned to a WH34.1 WH34.2
procedure on a template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-ACCT-CATEGORY Alpha 5 BL92.1 CXCP.1
Element: Account CategoThis field contains a valid account OE114 WH130
category as defined in the Activity WH132 WH190
Management system. WH222 WH30.1
WH30.2 WH30.3
This value defaults from the Preference WH30.4 WH31.1
Template file when you add a preference WH31.2 WH31.3
template to a case. WH31.4 WH32.1
WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the account category assigned to WH34.1 WH34.2
a procedure on a template. WH34.3 WH34.4
WH40.1 WH40.2
Note: Use of the Activity Management WH520 WH830
system to track and report costs
recorded in the Case Carts system is
reserved for a future release.
CXP-ACTIVITY Alpha 15 BL92.1 CXCP.1
Element: Activity This field contains a valid activity OE114 WH130
code of the Activity Management system. WH132 WH190
WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file when you add a preference WH30.4 WH31.1
template to a case. WH31.2 WH31.3
WH31.4 WH32.1
Use CX05.1 (Preference Template) to WH32.2 WH32.3
change the activity assigned to a WH32.4 WH33.5
procedure on a template. WH34.1 WH34.2
WH34.3 WH34.4
Note: Use of the Activity Management WH40.1 WH40.2
system to track and report costs WH520 WH830
recorded in the Case Carts system is
reserved for a future release.
CXP-ATN-OBJ-ID Numeric 12 BL92.1 CXCP.1
Object This field contains a system-assigned OE114 WH130
Identification identifier that provides access to data WH132 WH190
in related files. WH222 WH30.1
WH30.2 WH30.3
This value defaults from the Preference WH30.4 WH31.1
Template file when you add a preference WH31.2 WH31.3
template to a case. This value cannot be WH31.4 WH32.1
changed on a case. WH32.2 WH32.3
WH32.4 WH33.5
Use CX05.1 (Preference Template) to WH34.1 WH34.2
change the value assigned to a procedure WH34.3 WH34.4
on a template. WH40.1 WH40.2
WH520 WH830
Note: Use of this field is reserved
for a future release.
CXP-DATE-COMPLETED Numeric 8 (yyyymmdd) BL92.1 CXCP.1
Element: Date CompletedThis field contains the date the case OE114 WH130
was completed. WH132 WH190
WH222 WH30.1
This value defaults from the Preference WH30.2 WH30.3
Template file when you add a preference WH30.4 WH31.1
template to a case. This value cannot be WH31.2 WH31.3
changed on a case. WH31.4 WH32.1
WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the date assigned to a procedure WH34.1 WH34.2
on a template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-LST-PRFJOB-SEQ Numeric 3 BL92.1 CXCP.1
Element: Sequence NumbeThis field contains the record sequence OE114 WH130
number assigned to the burden code on WH132 WH190
the template. This value is WH222 WH30.1
automatically updated as you add case WH30.2 WH30.3
burden codes. WH30.4 WH31.1
WH31.2 WH31.3
This value defaults from the Preference WH31.4 WH32.1
Template file when you add a preference WH32.2 WH32.3
template to a case. WH32.4 WH33.5
WH34.1 WH34.2
Use CX05.1 (Preference Template) to WH34.3 WH34.4
change the Prf Job Seq assigned to a WH40.1 WH40.2
procedure on a template. WH520 WH830
CXP-STATUS Numeric 1 BL92.1 CXCP.1
Element: Status This field contains the procedure OE114 WH130
transaction status. WH132 WH190
1 = Created WH222 WH30.1
2 = Complete 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
CXP-STOCKLESS-FL Alpha 1 BL92.1 CXCP.1
Element: All Flag Select Yes to indicate that the item is OE114 WH130
a stockless item. WH132 WH190
WH222 WH30.1
Note: Use of this field is reserved WH30.2 WH30.3
for a future release. 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
CXP-DEL-TO-LOC Alpha 5 BL92.1 CXCP.1
Element: Location Code This field defines the deliver-to OE114 WH130
location. 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
CXP-HR-RATE-TOTAL Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field defines the hourly rate OE114 WH130
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
CXP-OT-RATE-TOTAL Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field defines the other rate total. OE114 WH130
WH132 WH190
This is a system-maintained subtotal, WH222 WH30.1
consisting of the total for Unit, Flat WH30.2 WH30.3
Fee, Rental Hourly, and Daily Rental WH30.4 WH31.1
types, used to calculate the total WH31.2 WH31.3
procedure cost. The Case Carts system WH31.4 WH32.1
logic also updates the other rate total WH32.2 WH32.3
in the Case Cart Preferences file. WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-CX-START-TIME Numeric 4 BL92.1 CXCP.1
Element: Actual Time This field contains the time when the OE114 WH130
procedure starts. 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
CXP-START-DATE Numeric 8 (yyyymmdd) BL92.1 CXCP.1
Element: Start Date This field contains the date when the OE114 WH130
procedure starts. 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
CXP-LAST-CHG-DATE Numeric 8 (yyyymmdd) BL92.1 CXCP.1
Element: Last Change DaThis date indicates the last date when OE114 WH130
changes were made. 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
CXP-LAST-CHG-TIME Numeric 4 BL92.1 CXCP.1
Element: Actual Time This field contains the time of the OE114 WH130
last change to the case. 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
CXP-OPERATOR-ID Alpha 10 BL92.1 CXCP.1
Element: Operator Code This field contains the terminal signon OE114 WH130
identifier when this update to the WH132 WH190
database was performed. 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
CXP-AM-PM-FLAG Alpha 2 BL92.1 CXCP.1
Element: A.M. or P.M. FThis field indicates whether the start OE114 WH130
time is for the morning or for the WH132 WH190
afternoon or evening. WH222 WH30.1
AM = Morning WH30.2 WH30.3
PM = Afternoon or Evening 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
CXP-LEADTIME-DAYS Numeric 3
Leadtime Number of This field contains the leadtime (in
Days 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 OE114
Element: Actual Time This field contains the completion time WH130 WH132
for the 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
CXP-COMPL-AM-PM Alpha 2 BL92.1 OE114
Complete A.M. or This field indicates whether the time WH130 WH132
P.M. Flag is for the morning or for the afternoon WH190 WH222
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
CXP-FLAT-FEE-FL Alpha 1 BL92.1 OE114
Element: Flat Fee Fl 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
CXCASEPREF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CXPSET1 COMPANY This index is used to access the Case AP125 AP126
REQ-LOCATION Cart Preferences file records in AP131 AP25.1
CASE Company, Requesting Location, Case, and AP25.2 AP26.1
SEQ Sequence number order. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
CXPSET2 COMPANY This index is used to access the Case
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
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
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
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, Subset
Where ATN-OBJ-ID != Zeroes
CXPSET7 COMPANY This index is used to access the Case
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 (CXHSET1)
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
|