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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ35.1
WH20.2 WH20.7
UPDATED BY
BL92.1 CXCP.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
CXP-COMPANY Numeric 4 BL92.1 CXCP.1
Element: Company This field contains the company number. WH130 WH132
WH190 WH222
Valid entries: WH30.1 WH30.2
WH30.3 WH30.4
Any Case Carts system company, defined WH31.1 WH31.2
in CX01.1 (Healthcare Company) and with WH31.3 WH31.4
an equivalent Inventory Control company WH32.1 WH32.2
in IC01.1 (Company). 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: Req Location This field contains the location WH130 WH132
requisitioning items and to be charged WH190 WH222
for the items. This location can be an WH30.1 WH30.2
inventory or noninventory location. WH30.3 WH30.4
WH31.1 WH31.2
This value appears as the to location WH31.3 WH31.4
on CX100 (Pick List Print) and WH130 WH32.1 WH32.2
(Pick List Print). WH32.3 WH32.4
WH33.5 WH34.1
Valid values are WH34.2 WH34.3
WH34.4 WH40.1
A requesting location defined in RQ01.1 WH40.2 WH520
(Requesting Location) for the specified WH830
healthcare company.
CXP-CASE Alpha 15 BL92.1 CXCP.1
Element: Case This field contains the unique WH130 WH132
identifier for the case. WH190 WH222
WH30.1 WH30.2
A case identifier is used in the Case WH30.3 WH30.4
Carts system to associate specific WH31.1 WH31.2
tasks, practitioners, preference lists, WH31.3 WH31.4
and other information with a particular WH32.1 WH32.2
treatment course. This treatment course WH32.3 WH32.4
may consist of one or more procedures. WH33.5 WH34.1
WH34.2 WH34.3
The case number can be used to WH34.4 WH40.1
interface with an outside scheduling WH40.2 WH520
system. WH830
CXP-PREF-CODE Alpha 8 BL92.1 CXCP.1
Element: Proc Code This field contains a Preference Code WH130 WH132
for a preference template defined in WH190 WH222
CX05.1 (Preference Template). The WH30.1 WH30.2
preference code is one of the key fields WH30.3 WH30.4
that define a preference template. You WH31.1 WH31.2
might decide to define a preference code WH31.3 WH31.4
as a procedure category found in a WH32.1 WH32.2
procedure code catalog issued by the WH32.3 WH32.4
government, insurer, or regulatory body. WH33.5 WH34.1
Based on such an approach, you might WH34.2 WH34.3
define a preference code as ANESTH for WH34.4 WH40.1
Anesthesia-related procedures. For WH40.2 WH520
another example, you might define RESP WH830
for Respiratory-related procedures.
CXP-SEQ Numeric 3 BL92.1 CXCP.1
Element: Seq This field contains the record sequence WH130 WH132
number for a procedure assigned to the WH190 WH222
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
CXP-PROC-TYPE Alpha 8 BL92.1 CXCP.1
Element: Proc Code The procedure type is the first of two WH130 WH132
fields that uniquely identify a WH190 WH222
procedure. The procedure type can WH30.1 WH30.2
identify the code set to which the WH30.3 WH30.4
procedure code belongs. WH31.1 WH31.2
WH31.3 WH31.4
For example, you can use one of the WH32.1 WH32.2
following codes: WH32.3 WH32.4
- CPT-4 for a code in the Current WH33.5 WH34.1
Procedural Terminology listing compiled WH34.2 WH34.3
by the American Medical Association WH34.4 WH40.1
-HCPCS for a code in HCFA's (Health WH40.2 WH520
Care Financing Administration's) Common 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: Proc Code The procedure code is the second of two WH130 WH132
fields that uniquely identify a WH190 WH222
procedure. The procedure code is an WH30.1 WH30.2
identifier for a specific procedure WH30.3 WH30.4
within a procedure type. WH31.1 WH31.2
WH31.3 WH31.4
This value defaults from the Preference WH32.1 WH32.2
Template file when you add a preference WH32.3 WH32.4
template to a case. This value cannot be WH33.5 WH34.1
changed on a case. WH34.2 WH34.3
WH34.4 WH40.1
Use CX05.1 (Preference Template) to WH40.2 WH520
change the Procedure Code assigned to a WH830
procedure on a preference template.
CXP-PRACTNR-ID Alpha 15 BL92.1 CXCP.1
Element: Practnr Id This field contains the practitioner WH130 WH132
ID. This value must be unique for each WH190 WH222
practitioner in the Case Carts system. WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file. WH31.1 WH31.2
WH31.3 WH31.4
This value cannot be changed on a case. WH32.1 WH32.2
Use CX05.1 (Preference Template) to WH32.3 WH32.4
change the practitioner ID assigned to a WH33.5 WH34.1
procedure on a template. WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-PREF-DESCRIPT Alpha 15 BL92.1 CXCP.1
Element: Pref Descript This field contains a short description WH130 WH132
for the procedure that may contain a WH190 WH222
more generic short description as an WH30.1 WH30.2
alternative to the standard procedure WH30.3 WH30.4
description. WH31.1 WH31.2
WH31.3 WH31.4
This value defaults from the Preference WH32.1 WH32.2
Template file when you add a preference WH32.3 WH32.4
template to a case. WH33.5 WH34.1
WH34.2 WH34.3
This value cannot be changed on a case. WH34.4 WH40.1
WH40.2 WH520
Use CX05.1 (Preference Template) to WH830
change the Preference Description
assigned to a procedure on a template.
CXP-LAST-LINE-NBR Numeric 6 BL92.1 CXCP.1
Element: Line Nbr This field contains the number of the WH130 WH132
last line item added to the case. The WH190 WH222
number is used to determine the number WH30.1 WH30.2
when the next line is added to the case. WH30.3 WH30.4
This value is automatically updated as WH31.1 WH31.2
you add case lines. 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 WH130 WH132
clinical costs for a preference. This is WH190 WH222
a user-defined subtotal that is part of WH30.1 WH30.2
the Total Procedure Cost. The clinical WH30.3 WH30.4
costs can be any costs not included in WH31.1 WH31.2
distribution, supplies, and burden WH31.3 WH31.4
costs. These latter costs along with the WH32.1 WH32.2
clinical costs make up the Total WH32.3 WH32.4
Procedure Cost. WH33.5 WH34.1
WH34.2 WH34.3
When you add a case using CX20.1 (Case WH34.4 WH40.1
Build), this value defaults from the WH40.2 WH520
appropriate record of the Preference 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 WH130 WH132
total distribution costs for the case WH190 WH222
procedure. WH30.1 WH30.2
WH30.3 WH30.4
Distribution costs are a subtotal of WH31.1 WH31.2
the Total Procedure Cost. The subtotal WH31.3 WH31.4
represents costs not included in costs WH32.1 WH32.2
for clinical resources, supplies, and WH32.3 WH32.4
burden. WH33.5 WH34.1
WH34.2 WH34.3
This value defaults from the Preference WH34.4 WH40.1
Template file when you add a preference WH40.2 WH520
template to a case. 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 WH130 WH132
total supply costs for the case WH190 WH222
procedure. WH30.1 WH30.2
WH30.3 WH30.4
Supplies are items assigned to a case. WH31.1 WH31.2
WH31.3 WH31.4
This value defaults from the Preference WH32.1 WH32.2
Template file when you add a preference WH32.3 WH32.4
template to a case. 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
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 WH130 WH132
costs (clinical, distribution, supply, WH190 WH222
and burden) recorded for the case WH30.1 WH30.2
procedure in the Case Carts system. WH30.3 WH30.4
WH31.1 WH31.2
This value defaults from the Preference WH31.3 WH31.4
Template file when you add a preference WH32.1 WH32.2
template to a case. WH32.3 WH32.4
WH33.5 WH34.1
This value is updated each time any WH34.2 WH34.3
cost-related element is changed on a WH34.4 WH40.1
case by adding, deleting, changing WH40.2 WH520
quantity, and so on. 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 WH130 WH132
costs for the case procedure. WH190 WH222
WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file when you add a preference WH31.1 WH31.2
template to a case. WH31.3 WH31.4
WH32.1 WH32.2
Change this value indirectly in one of WH32.3 WH32.4
two ways. The first way is to use CX05.1 WH33.5 WH34.1
(Preference Template) to change the WH34.2 WH34.3
burden cost-related data on the WH34.4 WH40.1
applicable template and then delete and WH40.2 WH520
re-add the template to the case. The 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) WH130 WH132
time taken to perform a specific WH190 WH222
procedure. WH30.1 WH30.2
WH30.3 WH30.4
This value defaults from the Preference WH31.1 WH31.2
Template file when you add a preference WH31.3 WH31.4
template to a case. WH32.1 WH32.2
WH32.3 WH32.4
Use CX05.1 (Preference Template) to WH33.5 WH34.1
change the normal time assigned to a WH34.2 WH34.3
procedure on a template. 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 WH130 WH132
to complete the procedure. WH190 WH222
WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file when you add a preference WH31.1 WH31.2
template to a case. This value cannot be WH31.3 WH31.4
changed on a case. WH32.1 WH32.2
WH32.3 WH32.4
Use CX05.1 (Preference Template) to WH33.5 WH34.1
change the estimated procedure time WH34.2 WH34.3
assigned to a procedure on a template. 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 WH130 WH132
complete the procedure. WH190 WH222
WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file when you add a preference WH31.1 WH31.2
template to a case. This value cannot be WH31.3 WH31.4
changed on a case. WH32.1 WH32.2
WH32.3 WH32.4
Use CX05.1 (Preference Template) to WH33.5 WH34.1
change the procedure time assigned to a WH34.2 WH34.3
procedure on a template. WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-ACCT-CATEGORY Alpha 5 BL92.1 CXCP.1
Element: Acct Category This field contains a valid account WH130 WH132
category as defined in the Activity WH190 WH222
Management system. WH30.1 WH30.2
WH30.3 WH30.4
This value defaults from the Preference WH31.1 WH31.2
Template file when you add a preference WH31.3 WH31.4
template to a case. WH32.1 WH32.2
WH32.3 WH32.4
Use CX05.1 (Preference Template) to WH33.5 WH34.1
change the account category assigned to WH34.2 WH34.3
a procedure on a template. WH34.4 WH40.1
WH40.2 WH520
Note: Use of the Activity Management 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 WH130 WH132
code of the Activity Management system. WH190 WH222
WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file when you add a preference WH31.1 WH31.2
template to a case. WH31.3 WH31.4
WH32.1 WH32.2
Use CX05.1 (Preference Template) to WH32.3 WH32.4
change the activity assigned to a WH33.5 WH34.1
procedure on a template. WH34.2 WH34.3
WH34.4 WH40.1
Note: Use of the Activity Management WH40.2 WH520
system to track and report costs WH830
recorded in the Case Carts system is
reserved for a future release.
CXP-ATN-OBJ-ID Numeric 12 BL92.1 CXCP.1
Element: Obj Id This field contains a system-assigned WH130 WH132
identifier that provides access to data WH190 WH222
in related files. WH30.1 WH30.2
WH30.3 WH30.4
This value defaults from the Preference WH31.1 WH31.2
Template file when you add a preference WH31.3 WH31.4
template to a case. This value cannot be WH32.1 WH32.2
changed on a case. WH32.3 WH32.4
WH33.5 WH34.1
Use CX05.1 (Preference Template) to WH34.2 WH34.3
change the value assigned to a procedure WH34.4 WH40.1
on a template. 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 WH130 WH132
was completed. WH190 WH222
WH30.1 WH30.2
This value defaults from the Preference WH30.3 WH30.4
Template file when you add a preference WH31.1 WH31.2
template to a case. This value cannot be WH31.3 WH31.4
changed on a case. WH32.1 WH32.2
WH32.3 WH32.4
Use CX05.1 (Preference Template) to WH33.5 WH34.1
change the date assigned to a procedure WH34.2 WH34.3
on a template. WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-LST-PRFJOB-SEQ Numeric 3 BL92.1 CXCP.1
Element: Seq This field contains the record sequence WH130 WH132
number assigned to the burden code on WH190 WH222
the template. This value is WH30.1 WH30.2
automatically updated as you add case WH30.3 WH30.4
burden codes. WH31.1 WH31.2
WH31.3 WH31.4
This value defaults from the Preference WH32.1 WH32.2
Template file when you add a preference WH32.3 WH32.4
template to a case. WH33.5 WH34.1
WH34.2 WH34.3
Use CX05.1 (Preference Template) to WH34.4 WH40.1
change the Prf Job Seq assigned to a WH40.2 WH520
procedure on a template. WH830
CXP-STATUS Numeric 1 BL92.1 CXCP.1
Element: Status This field contains the procedure WH130 WH132
transaction status. WH190 WH222
1 = Created WH30.1 WH30.2
2 = Complete 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 WH130 WH132
a stockless item. WH190 WH222
WH30.1 WH30.2
Note: Use of this field is reserved WH30.3 WH30.4
for a future release. 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
CXP-DEL-TO-LOC Alpha 5 BL92.1 CXCP.1
Element: Location This field defines the deliver-to WH130 WH132
location. 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 WH130 WH132
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
CXP-OT-RATE-TOTAL Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field defines the other rate total. WH130 WH132
WH190 WH222
This is a system-maintained subtotal, WH30.1 WH30.2
consisting of the total for Unit, Flat WH30.3 WH30.4
Fee, Rental Hourly, and Daily Rental WH31.1 WH31.2
types, used to calculate the total WH31.3 WH31.4
procedure cost. The Case Carts system WH32.1 WH32.2
logic also updates the other rate total WH32.3 WH32.4
in the Case Cart Preferences file. 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 WH130 WH132
procedure starts. 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 WH130 WH132
procedure starts. 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 Chg Date This date indicates the last date when WH130 WH132
changes were made. 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 WH130 WH132
last change to the case. WH190 WH222
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-OPERATOR-ID Alpha 10 BL92.1 CXCP.1
Element: Operator This field is used to store the login WH130 WH132
id of the person who entered the record. 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-AM-PM-FLAG Alpha 2 BL92.1 CXCP.1
Element: Am Pm Flag This field indicates whether the start WH130 WH132
time is for the morning or for the WH190 WH222
afternoon or evening. WH30.1 WH30.2
AM = Morning WH30.3 WH30.4
PM = Afternoon or Evening 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
Element: 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 WH130
Element: Actual Time This field contains the completion time WH132 WH190
for the 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
CXP-COMPL-AM-PM Alpha 2 BL92.1 WH130
Element: Compl Am Pm This field indicates whether the time WH132 WH190
is for the morning or for the afternoon WH222 WH30.1
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
CXP-FLAT-FEE-FL Alpha 1 BL92.1 WH130
Element: Flat Fee Fl 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 AP125 AP126
REQ-LOCATION AP131 AP20.1
CASE AP20.2 AP20.3
SEQ AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
CXPSET2 COMPANY
REQ-LOCATION
PROC-TYPE
PROC-CODE
CASE
SEQ
CXPSET3 COMPANY
REQ-LOCATION
PRACTNR-ID
CASE
SEQ
CXPSET4 COMPANY
REQ-LOCATION
PREF-DESCRIPT
CASE
SEQ
CXPSET5 COMPANY
PRACTNR-ID
REQ-LOCATION
CASE
SEQ
CXPSET6 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
CXPSET7 COMPANY
REQ-LOCATION
PREF-CODE
CASE
SEQ
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
|