CXITEMHIST FILE
Case Cart Item History
The Case Cart Item History file stores item history for case visits.
When you finish a case using CX30.1 (Case Completion Feedback), the Case
Carts system sends the case item data to this file. Once item data for a case
resides in this file, you can no longer access the case through the Case Carts
system for updating.
The data defaults from the case but originates from the burden record, the
preference template, or the case.
The Case Carts system logic for CX20.2 (Case Detail) uses this file and the
Case Cart Labor History file to calculate the total cost of the case.
Note: Use the Case Carts Analyzer or an online editor to report on data in
this file. For instructions on using the Case Carts Analyzer, see the Case
Carts Procedures Manual and the Information Access Procedures Manual.
REFERENCED BY
CX240 CX230
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 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
WH130 WH132 WH190 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CIH-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-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 OE30.1 OE30.2
on the pick lists printed when you run OE30.3 OE30.4
CX100 (Pick List Print) and WH130 OE30.5 OE30.6
(Pick List Print). OE30.7 OE30.9
OE830 OE950
Valid values are PO31.1 RQ35.1
WH130 WH132
A requesting location defined in RQ01.1 WH190 WH20.7
(Requesting Location) for the specified WH222 WH30.1
healthcare company. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-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 is a record of the CX300 CX506
practitioners, preference lists, and CXCP.1 OE114
associated information assigned to a OE30.1 OE30.2
specific patient visit. OE30.3 OE30.4
OE30.5 OE30.6
You can use this number to interface OE30.7 OE30.9
with an outside scheduling system. OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-SEQ Numeric 3 BL92.1 CX100
Sequence This field contains the record sequence CX20.1 CX20.2
number within the case. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-LINE-NBR Numeric 6 BL92.1 CX100
Line Nbr This field contains the line number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-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
OE30.1 OE30.2
For example, you can use one of the OE30.3 OE30.4
following codes: OE30.5 OE30.6
- CPT-4 for a code in the Current OE30.7 OE30.9
Procedural Terminology listing compiled OE830 OE950
by the American Medical Association PO31.1 RQ35.1
-HCPCS for a code in HCFA's (Health WH130 WH132
Care Financing Administration's) Common WH190 WH20.7
Procedure Coding System, or WH222 WH30.1
- A code defined for your WH30.2 WH30.3
organization's own procedures listing. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-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
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-ALT-LINE-NBR Numeric 6 BL92.1 CX100
Alt Line Nbr This field contains the display value CX20.1 CX20.2
of the item line number. CX20.4 CX20.5
CX220 CX30.1
When you assign more that one CX300 CX506
preference template to a case, the CXCP.1 OE114
system assigns numbers to the items on OE30.1 OE30.2
the case sequentially. The numbers start OE30.3 OE30.4
with 1 on the first preference and OE30.5 OE30.6
continue sequentially. OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-SYSTEM-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
System Date This field contains the system date. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-SYSTEM-TIME Numeric 4 BL92.1 CX100
System Time This field contains the system time. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-ITEM Alpha 32 BL92.1 CX100
Item This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-QTY Signed 13.4 BL92.1 CX100
Qty This field contains the quantity of the CX20.1 CX20.2
item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-UOM Alpha 4 BL92.1 CX100
UOM This field contains the valid stock CX20.1 CX20.2
unit of measure for this item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-ISS-COST Signed 13.5 BL92.1 CX100
Issue Cost This field contains the issue cost. CX20.1 CX20.2
CX20.4 CX20.5
If you report waste and return items CX220 CX30.1
for a case by using CX30.1 (Case CX300 CX506
Completion Feedback), this cost defaults CXCP.1 OE114
from the case detail when you finish the OE30.1 OE30.2
case. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-PRICE Signed 15.2 BL92.1 CX100
Price This field contains the flat amount CX20.1 CX20.2
that is applied as an add-on charge. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-REASON-CODE Alpha 4 BL92.1 CX100
Reason Code This field contains the reason code CX20.1 CX20.2
used primarily for reporting returns and CX20.4 CX20.5
waste by CX230 (Waste Return Items). CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-DESCRIPTION Alpha 30 (Lower Case) BL92.1 CX100
Description This field contains the description. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-DESCRIPTION2 Alpha 30 (Lower Case) BL92.1 CX100
Description 2 This field contains the second line of CX20.1 CX20.2
the description. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-REASON-TYPE Alpha 2 BL92.1 CX100
Reason Type This field contains the reason type. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CIH-CASE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Case Date This field contains the case date. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CXITEMHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIHSET1 COMPANY This index is used to access the Case BL92.1 CX100
REQ-LOCATION Cart Item History file records in CX20.1 CX20.2
CASE Company, Requesting Location, Case, CX20.4 CX20.5
SEQ Sequence number, Line Number, Reason CX220 CX240
LINE-NBR Code, and Reason Type order. CX30.1 CX300
REASON-CODE CX506 CXCP.1
REASON-TYPE OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
...
CIHSET2 COMPANY This index is used to access the Case CX230
REQ-LOCATION Cart Item History file records in
ITEM Company, Requesting Location, Item,
CASE Case, Sequence number, and Alternate
SEQ Line Number order.
ALT-LINE-NBR KeyChange, Duplicates
|