 |
Lawson Insight Technical Documentation |
|
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.
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
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
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 WH130 WH132
WH190 WH20.2 WH20.7 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.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CIH-COMPANY Numeric 4 AP125 AP126
Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-REQ-LOCATION Alpha 5 AP125 AP126
To Location This field contains the location AP131 AP25.1
requisitioning items and to be charged AP25.2 AP26.1
for the items. This location can be an AP27.1 CXCP.1
inventory or noninventory location. IC28.1 MA180
MA43.9 MA530
This value appears as the to location MA531 MA60.2
on the pick lists printed when you run MA60.3 MA60.5
CX100 (Pick List Print) and WH130 MA61.1 MA66.3
(Pick List Print). MA67.1 MA67.2
MA70.1 MAI1.1
Valid values are PO100 PO101
PO122 PO131
A requesting location defined in RQ01.1 PO20.1 PO21.2
(Requesting Location) for the specified PO21.3 PO21.4
healthcare company. 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
WH130 WH132
...
CIH-CASE Alpha 15 AP125 AP126
Case This field contains the unique AP131 AP25.1
identifier for the case. AP25.2 AP26.1
AP27.1 CXCP.1
A case is a record of the IC28.1 MA180
practitioners, preference lists, and MA43.9 MA530
associated information assigned to a MA531 MA60.2
specific patient visit. MA60.3 MA60.5
MA61.1 MA66.3
You can use this number to interface MA67.1 MA67.2
with an outside scheduling system. 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
WH130 WH132
...
CIH-SEQ Numeric 3 AP125 AP126
Sequence Number This field contains the record sequence AP131 AP25.1
number within the case. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-PROC-TYPE Alpha 8 AP125 AP126
Proc Type The procedure type is the first of two AP131 AP25.1
fields that uniquely identify a AP25.2 AP26.1
procedure. The procedure type can AP27.1 CXCP.1
identify the code set to which the IC28.1 MA180
procedure code belongs. MA43.9 MA530
MA531 MA60.2
For example, you can use one of the MA60.3 MA60.5
following codes: MA61.1 MA66.3
- CPT-4 for a code in the Current MA67.1 MA67.2
Procedural Terminology listing compiled MA70.1 MAI1.1
by the American Medical Association PO100 PO101
-HCPCS for a code in HCFA's (Health PO122 PO131
Care Financing Administration's) Common PO20.1 PO21.2
Procedure Coding System, or PO21.3 PO21.4
- A code defined for your PO21.5 PO22.1
organization's own procedures listing. 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
WH130 WH132
...
CIH-PROC-CODE Alpha 8 AP125 AP126
Procedure Code The procedure code is the second of two AP131 AP25.1
fields that uniquely identify a AP25.2 AP26.1
procedure. The procedure code is an AP27.1 CXCP.1
identifier for a specific procedure IC28.1 MA180
within a procedure type. 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
WH130 WH132
...
CIH-ALT-LINE-NBR Numeric 6 AP125 AP126
Alt Line Nbr This field contains the display value AP131 AP25.1
of the item line number. AP25.2 AP26.1
AP27.1 CXCP.1
When you assign more that one IC28.1 MA180
preference template to a case, the MA43.9 MA530
system assigns numbers to the items on MA531 MA60.2
the case sequentially. The numbers start MA60.3 MA60.5
with 1 on the first preference and MA61.1 MA66.3
continue sequentially. 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
WH130 WH132
...
CIH-SYSTEM-DATE Numeric 8 (yyyymmdd) AP125 AP126
System Date This field contains the system date. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-SYSTEM-TIME Numeric 4 AP125 AP126
System Time This field contains the system time. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-QTY Signed 13.4 AP125 AP126
Quantity This field contains the quantity of the AP131 AP25.1
item. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-UOM Alpha 4 AP125 AP126
Unit of Measure This field contains the valid stock AP131 AP25.1
unit of measure for this item. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-ISS-COST Signed 13.5 AP125 AP126
Iss Cost This field contains the issue cost. AP131 AP25.1
AP25.2 AP26.1
If you report waste and return items AP27.1 CXCP.1
for a case by using CX30.1 (Case IC28.1 MA180
Completion Feedback), this cost defaults MA43.9 MA530
from the case detail when you finish the MA531 MA60.2
case. 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
WH130 WH132
...
CIH-PRICE Signed 15.2 AP125 AP126
Price This field contains the flat amount AP131 AP25.1
that is applied as an add-on charge. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-REASON-CODE Alpha 4 AP125 AP126
Reason Code This field contains the reason code AP131 AP25.1
used primarily for reporting returns and AP25.2 AP26.1
waste by CX230 (Waste Return Items). 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
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
WH130 WH132
...
CIH-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description This field displays the description. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-DESCRIPTION2 Alpha 30 (Lower Case) AP125 AP126
Second Description This field contains the second line of AP131 AP25.1
the description. AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-REASON-TYPE Alpha 2 AP125 AP126
Reason Type This field contains the reason type. AP131 AP25.1
1 = Waste AP25.2 AP26.1
2 = Leftovers 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
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
WH130 WH132
...
CIH-CASE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Case Date This field contains the case date. AP131 AP25.1
AP25.2 AP26.1
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
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
WH130 WH132
...
CIH-USE-IDENTIFIER Alpha 1
Use Identifier
CIH-CONSIGNMENT-FL Alpha 1
Consignment Fl
CXITEMHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIHSET1 COMPANY This index is used to access the Case AP125 AP126
REQ-LOCATION Cart Item History file records in AP131 AP25.1
CASE Company, Requesting Location, Case, AP25.2 AP26.1
SEQ Sequence number, Line Number, Reason AP27.1 CXCP.1
LINE-NBR Code, and Reason Type order. IC28.1 MA180
REASON-CODE MA43.9 MA530
REASON-TYPE 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
...
CIHSET2 COMPANY This index is used to access the Case
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
SYSTEM-TIME
|