 |
Lawson Insight Technical Documentation |
|
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 IC28.1 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 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
UPDATED BY
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 CXCP.1 WH130
Company This field contains the company number. WH132 WH190
WH222 WH30.1
Valid entries: WH30.2 WH30.3
WH30.4 WH31.1
Any Case Carts system company, defined WH31.2 WH31.3
in CX01.1 (Healthcare Company) and with WH31.4 WH32.1
an equivalent Inventory Control company WH32.2 WH32.3
in IC01.1 (Company). WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-REQ-LOCATION Alpha 5 CXCP.1 WH130
To Location This field contains the location WH132 WH190
requisitioning items and to be charged WH222 WH30.1
for the items. This location can be an WH30.2 WH30.3
inventory or noninventory location. WH30.4 WH31.1
WH31.2 WH31.3
This value appears as the to location WH31.4 WH32.1
on CX100 (Pick List Print) and WH130 WH32.2 WH32.3
(Pick List Print). WH32.4 WH33.5
WH34.1 WH34.2
Valid values are WH34.3 WH34.4
WH40.1 WH40.2
A requesting location defined in RQ01.1 WH520 WH830
(Requesting Location) for the specified
healthcare company.
CXP-CASE Alpha 15 CXCP.1 WH130
Case This field contains the unique WH132 WH190
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 number can be used to WH40.1 WH40.2
interface with an outside scheduling WH520 WH830
system.
CXP-PREF-CODE Alpha 8 CXCP.1 WH130
Preference Code This field contains a Preference Code WH132 WH190
for a preference template defined in WH222 WH30.1
CX05.1 (Preference Template). The WH30.2 WH30.3
preference code is one of the key fields WH30.4 WH31.1
that define a preference template. You WH31.2 WH31.3
might decide to define a preference code WH31.4 WH32.1
as a procedure category found in a WH32.2 WH32.3
procedure code catalog issued by the WH32.4 WH33.5
government, insurer, or regulatory body. WH34.1 WH34.2
Based on such an approach, you might WH34.3 WH34.4
define a preference code as ANESTH for WH40.1 WH40.2
Anesthesia-related procedures. For WH520 WH830
another example, you might define RESP
for Respiratory-related procedures.
CXP-SEQ Numeric 3 CXCP.1 WH130
Sequence Number This field contains the record sequence WH132 WH190
number for a procedure assigned to the WH222 WH30.1
case. 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 CXCP.1 WH130
Proc Type The procedure type is the first of two WH132 WH190
fields that uniquely identify a WH222 WH30.1
procedure. The procedure type can WH30.2 WH30.3
identify the code set to which the WH30.4 WH31.1
procedure code belongs. WH31.2 WH31.3
WH31.4 WH32.1
For example, you can use one of the WH32.2 WH32.3
following codes: WH32.4 WH33.5
- CPT-4 for a code in the Current WH34.1 WH34.2
Procedural Terminology listing compiled WH34.3 WH34.4
by the American Medical Association WH40.1 WH40.2
-HCPCS for a code in HCFA's (Health WH520 WH830
Care Financing Administration's) Common
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 CXCP.1 WH130
Procedure Code The procedure code is the second of two WH132 WH190
fields that uniquely identify a WH222 WH30.1
procedure. The procedure code is an WH30.2 WH30.3
identifier for a specific procedure WH30.4 WH31.1
within a procedure type. WH31.2 WH31.3
WH31.4 WH32.1
This value defaults from the Preference WH32.2 WH32.3
Template file when you add a preference WH32.4 WH33.5
template to a case. This value cannot be WH34.1 WH34.2
changed on a case. WH34.3 WH34.4
WH40.1 WH40.2
Use CX05.1 (Preference Template) to WH520 WH830
change the Procedure Code assigned to a
procedure on a preference template.
CXP-PRACTNR-ID Alpha 15 CXCP.1 WH130
Practitioner ID This field contains the practitioner WH132 WH190
ID. This value must be unique for each WH222 WH30.1
practitioner in the Case Carts system. WH30.2 WH30.3
This value defaults from the Preference WH30.4 WH31.1
Template file. WH31.2 WH31.3
WH31.4 WH32.1
This value cannot be changed on a case. WH32.2 WH32.3
Use CX05.1 (Preference Template) to WH32.4 WH33.5
change the practitioner ID assigned to a WH34.1 WH34.2
procedure on a template. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-PREF-DESCRIPT Alpha 15 CXCP.1 WH130
Preference This field contains a short description WH132 WH190
Description for the procedure that may contain a WH222 WH30.1
more generic short description as an WH30.2 WH30.3
alternative to the standard procedure WH30.4 WH31.1
description. WH31.2 WH31.3
WH31.4 WH32.1
This value defaults from the Preference WH32.2 WH32.3
Template file when you add a preference WH32.4 WH33.5
template to a case. WH34.1 WH34.2
WH34.3 WH34.4
This value cannot be changed on a case. WH40.1 WH40.2
WH520 WH830
Use CX05.1 (Preference Template) to
change the Preference Description
assigned to a procedure on a template.
CXP-LAST-LINE-NBR Numeric 6 CXCP.1 WH130
Last Line Number This field contains the number of the WH132 WH190
last line item added to the case. The WH222 WH30.1
number is used to determine the number WH30.2 WH30.3
when the next line is added to the case. WH30.4 WH31.1
This value is automatically updated as WH31.2 WH31.3
you add case lines. 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
Process 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 CXCP.1 WH130
Clinical Cost This field contains the user-defined WH132 WH190
clinical costs for a preference. This is WH222 WH30.1
a user-defined subtotal that is part of WH30.2 WH30.3
the Total Procedure Cost. The clinical WH30.4 WH31.1
costs can be any costs not included in WH31.2 WH31.3
distribution, supplies, and burden WH31.4 WH32.1
costs. These latter costs along with the WH32.2 WH32.3
clinical costs make up the Total WH32.4 WH33.5
Procedure Cost. WH34.1 WH34.2
WH34.3 WH34.4
When you add a case using CX20.1 (Case WH40.1 WH40.2
Build), this value defaults from the WH520 WH830
appropriate record of the Preference
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 Currency 15.2 CXCP.1 WH130
Distribution Cost This field contains the user-defined WH132 WH190
total distribution costs for the case WH222 WH30.1
procedure. WH30.2 WH30.3
WH30.4 WH31.1
Distribution costs are a subtotal of WH31.2 WH31.3
the Total Procedure Cost. The subtotal WH31.4 WH32.1
represents costs not included in costs WH32.2 WH32.3
for clinical resources, supplies, and WH32.4 WH33.5
burden. WH34.1 WH34.2
WH34.3 WH34.4
This value defaults from the Preference WH40.1 WH40.2
Template file when you add a preference WH520 WH830
template to a case.
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 Currency 15.2 CXCP.1 WH130
Supply Cost This field contains the user-defined WH132 WH190
total supply costs for the case WH222 WH30.1
procedure. WH30.2 WH30.3
WH30.4 WH31.1
Supplies are items assigned to a case. WH31.2 WH31.3
WH31.4 WH32.1
This value defaults from the Preference WH32.2 WH32.3
Template file when you add a preference WH32.4 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
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 Currency 15.2 CXCP.1 WH130
Total Cst This field contains the total of all WH132 WH190
costs (clinical, distribution, supply, WH222 WH30.1
and burden) recorded for the case WH30.2 WH30.3
procedure in the Case Carts system. 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 is updated each time any WH34.3 WH34.4
cost-related element is changed on a WH40.1 WH40.2
case by adding, deleting, changing WH520 WH830
quantity, and so on.
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 Currency 15.2 CXCP.1 WH130
Total Burden This field contains the total burden WH132 WH190
costs for the case 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
Change this value indirectly in one of WH32.4 WH33.5
two ways. The first way is to use CX05.1 WH34.1 WH34.2
(Preference Template) to change the WH34.3 WH34.4
burden cost-related data on the WH40.1 WH40.2
applicable template and then delete and WH520 WH830
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 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 CXCP.1 WH130
Normal Time This field defines the typical (normal) WH132 WH190
time taken to perform a specific WH222 WH30.1
procedure. 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
Use CX05.1 (Preference Template) to WH34.1 WH34.2
change the normal time assigned to a WH34.3 WH34.4
procedure on a template. WH40.1 WH40.2
WH520 WH830
CXP-EST-PROC-TIME Numeric 4 CXCP.1 WH130
Est Proc Time This field contains the estimated time WH132 WH190
to complete the 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. 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 estimated procedure time WH34.3 WH34.4
assigned to a procedure on a template. WH40.1 WH40.2
WH520 WH830
CXP-PROCEDURE-TIME Numeric 4 CXCP.1 WH130
Procedure Time This field contains the actual time to WH132 WH190
complete the 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. 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 procedure time assigned to a WH34.3 WH34.4
procedure on a template. WH40.1 WH40.2
WH520 WH830
CXP-ACCT-CATEGORY Alpha 5 CXCP.1 WH130
Account Category This field contains a valid account WH132 WH190
category as defined in the Activity WH222 WH30.1
Management 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
Use CX05.1 (Preference Template) to WH34.1 WH34.2
change the account category assigned to WH34.3 WH34.4
a procedure on a template. WH40.1 WH40.2
WH520 WH830
Note: Use of the Activity Management
system to track and report costs
recorded in the Case Carts system is
reserved for a future release.
CXP-ACTIVITY Alpha 15 CXCP.1 WH130
Activity This field contains a valid activity WH132 WH190
code of the Activity 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 activity assigned to a WH34.1 WH34.2
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-ATN-OBJ-ID Numeric 12 CXCP.1 WH130
Atn Object ID This field contains a system-assigned WH132 WH190
identifier that provides access to data WH222 WH30.1
in related files. 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. This value cannot be WH32.2 WH32.3
changed on a case. WH32.4 WH33.5
WH34.1 WH34.2
Use CX05.1 (Preference Template) to WH34.3 WH34.4
change the value assigned to a procedure WH40.1 WH40.2
on a template. WH520 WH830
Note: Use of this field is reserved
for a future release.
CXP-DATE-COMPLETED Numeric 8 (yyyymmdd) CXCP.1 WH130
Date Completed This field contains the date the case WH132 WH190
was completed. 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 date assigned to a procedure WH34.3 WH34.4
on a template. WH40.1 WH40.2
WH520 WH830
CXP-LST-PRFJOB-SEQ Numeric 3 CXCP.1 WH130
Lst Prfjob Seq This field contains the record sequence WH132 WH190
number assigned to the burden code on WH222 WH30.1
the template. This value is WH30.2 WH30.3
automatically updated as you add case WH30.4 WH31.1
burden codes. WH31.2 WH31.3
WH31.4 WH32.1
This value defaults from the Preference WH32.2 WH32.3
Template file when you add a preference WH32.4 WH33.5
template to a case. WH34.1 WH34.2
WH34.3 WH34.4
Use CX05.1 (Preference Template) to WH40.1 WH40.2
change the Prf Job Seq assigned to a WH520 WH830
procedure on a template.
CXP-STATUS Numeric 1 CXCP.1 WH130
Status This field contains the procedure WH132 WH190
transaction status. WH222 WH30.1
1 = Created WH30.2 WH30.3
2 = Complete 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 CXCP.1 WH130
Stockless Fl Select Yes to indicate that the item is WH132 WH190
a stockless item. WH222 WH30.1
WH30.2 WH30.3
Note: Use of this field is reserved WH30.4 WH31.1
for a future release. WH31.2 WH31.3
Y = Yes WH31.4 WH32.1
N = No 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 CXCP.1 WH130
Del To Loc This field defines the deliver-to WH132 WH190
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
CXP-HR-RATE-TOTAL Currency 15.2 CXCP.1 WH130
Hr Rate Total This field defines the hourly rate WH132 WH190
total. 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 Currency 15.2 CXCP.1 WH130
Ot Rate Total This field defines the other rate total. WH132 WH190
WH222 WH30.1
This is a system-maintained subtotal, WH30.2 WH30.3
consisting of the total for Unit, Flat WH30.4 WH31.1
Fee, Rental Hourly, and Daily Rental WH31.2 WH31.3
types, used to calculate the total WH31.4 WH32.1
procedure cost. The Case Carts system WH32.2 WH32.3
logic also updates the other rate total WH32.4 WH33.5
in the Case Cart Preferences file. WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXP-CX-START-TIME Numeric 4 CXCP.1 WH130
Case Start Time This field contains the time when the WH132 WH190
procedure starts. 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) CXCP.1 WH130
Start Date This field contains the date when the WH132 WH190
procedure starts. 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) CXCP.1 WH130
Last Change Date This date indicates the last date when WH132 WH190
changes were made. 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 CXCP.1 WH130
Last Change Time This field contains the time of the WH132 WH190
last change to 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
CXP-OPERATOR-ID Alpha 10 CXCP.1 WH130
Operator This field contains the terminal signon WH132 WH190
Identification Code identifier 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
CXP-AM-PM-FLAG Alpha 2 CXCP.1 WH130
A.M. or P.M. Flag This field indicates whether the start WH132 WH190
time is for the morning or for the WH222 WH30.1
afternoon or evening. WH30.2 WH30.3
AM = Morning WH30.4 WH31.1
PM = Afternoon or Evening 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 WH130 WH132
Completed Time This field contains the completion time WH190 WH222
for the procedure. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-COMPL-AM-PM Alpha 2 WH130 WH132
Complete A.M. or This field indicates whether the time WH190 WH222
P.M. Flag is for the morning or for the afternoon WH30.1 WH30.2
or evening. WH30.3 WH30.4
AM = AM WH31.1 WH31.2
PM = PM WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CXP-FLAT-FEE-FL Alpha 1 WH130 WH132
Flat Fee Fl 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 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
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
|