Lawson Insight Technical Documentation |
|
CXITEMHIST
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 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 BL92.1 CXCP.1
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 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
Element: Company This field contains the company number. 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
BL92.1 CXCP.1
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
...
CIH-REQ-LOCATION Alpha 5 AP125 AP126
Element: Req Location This field contains the location AP131 AP20.1
requisitioning items and to be charged AP20.2 AP20.3
for the items. This location can be an AP20.4 AP20.5
inventory or noninventory location. AP20.7 AP21.1
AP23.1 AP25.1
This value appears as the to location AP25.2 AP26.1
on the pick lists printed when you run AP27.1 AP30.4
CX100 (Pick List Print) and WH130 API1.1 BL120
(Pick List Print). BL122 BL130
BL20.1 BL20.3
Valid values are BL21.2 BL21.5
BL29.1 BL29.2
A requesting location defined in RQ01.1 BL520 BL820
(Requesting Location) for the specified BL92.1 CXCP.1
healthcare company. 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
...
CIH-CASE Alpha 15 AP125 AP126
Element: Case This field contains the unique AP131 AP20.1
identifier for the case. AP20.2 AP20.3
AP20.4 AP20.5
A case is a record of the AP20.7 AP21.1
practitioners, preference lists, and AP23.1 AP25.1
associated information assigned to a AP25.2 AP26.1
specific patient visit. AP27.1 AP30.4
API1.1 BL120
You can use this number to interface BL122 BL130
with an outside scheduling system. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
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
...
CIH-SEQ Numeric 3 AP125 AP126
Element: Seq This field contains the record sequence AP131 AP20.1
number within the case. 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
BL92.1 CXCP.1
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
...
CIH-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the line number. 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
BL92.1 CXCP.1
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
...
CIH-PROC-TYPE Alpha 8 AP125 AP126
Element: Proc Code The procedure type is the first of two AP131 AP20.1
fields that uniquely identify a AP20.2 AP20.3
procedure. The procedure type can AP20.4 AP20.5
identify the code set to which the AP20.7 AP21.1
procedure code belongs. AP23.1 AP25.1
AP25.2 AP26.1
For example, you can use one of the AP27.1 AP30.4
following codes: API1.1 BL120
- CPT-4 for a code in the Current BL122 BL130
Procedural Terminology listing compiled BL20.1 BL20.3
by the American Medical Association BL21.2 BL21.5
-HCPCS for a code in HCFA's (Health BL29.1 BL29.2
Care Financing Administration's) Common BL520 BL820
Procedure Coding System, or BL92.1 CXCP.1
- A code defined for your MA180 MA41.1
organization's own procedures listing. 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
...
CIH-PROC-CODE Alpha 8 AP125 AP126
Element: Proc Code The procedure code is the second of two AP131 AP20.1
fields that uniquely identify a AP20.2 AP20.3
procedure. The procedure code is an AP20.4 AP20.5
identifier for a specific procedure AP20.7 AP21.1
within a procedure type. 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
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
...
CIH-ALT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the display value AP131 AP20.1
of the item line number. AP20.2 AP20.3
AP20.4 AP20.5
When you assign more that one AP20.7 AP21.1
preference template to a case, the AP23.1 AP25.1
system assigns numbers to the items on AP25.2 AP26.1
the case sequentially. The numbers start AP27.1 AP30.4
with 1 on the first preference and API1.1 BL120
continue sequentially. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
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
...
CIH-SYSTEM-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the system date. 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
BL92.1 CXCP.1
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
...
CIH-SYSTEM-TIME Numeric 4 AP125 AP126
Element: Actual Time This field contains the system time. 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
BL92.1 CXCP.1
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
...
CIH-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP131 AP20.1
identifier. 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
BL92.1 CXCP.1
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
...
CIH-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity of the AP131 AP20.1
item. 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
BL92.1 CXCP.1
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
...
CIH-UOM Alpha 4 AP125 AP126
Element: Uom This field contains the valid stock AP131 AP20.1
unit of measure for this item. 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
BL92.1 CXCP.1
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
...
CIH-ISS-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the issue cost. AP131 AP20.1
AP20.2 AP20.3
If you report waste and return items AP20.4 AP20.5
for a case by using CX30.1 (Case AP20.7 AP21.1
Completion Feedback), this cost defaults AP23.1 AP25.1
from the case detail when you finish the AP25.2 AP26.1
case. 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
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
...
CIH-PRICE Signed 18.2 AP125 AP126
Element: Intl Amt 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
BL92.1 CXCP.1
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
...
CIH-REASON-CODE Alpha 4 AP125 AP126
Element: Reason Code This field contains the reason code AP131 AP20.1
used primarily for reporting returns and AP20.2 AP20.3
waste by CX230 (Waste Return Items). 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
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
...
CIH-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field displays the description. 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
BL92.1 CXCP.1
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
...
CIH-DESCRIPTION2 Alpha 30 (Lower Case) AP125 AP126
Element: Description This field displays the description. 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
BL92.1 CXCP.1
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
...
CIH-REASON-TYPE Alpha 2 AP125 AP126
Element: Reason Type This field contains the reason type. AP131 AP20.1
1 = Waste AP20.2 AP20.3
2 = Leftovers 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
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
...
CIH-CASE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Case Date This field contains the case date. 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
BL92.1 CXCP.1
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
...
CIH-USE-IDENTIFIER Alpha 1
Element: Use Identifier
CIH-CONSIGNMENT-FL Alpha 1
Element: Consignment Fl
CXITEMHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIHSET1 COMPANY AP125 AP126
REQ-LOCATION AP131 AP20.1
CASE AP20.2 AP20.3
SEQ AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
REASON-CODE AP23.1 AP25.1
REASON-TYPE 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
...
CIHSET2 COMPANY KeyChange
REQ-LOCATION
ITEM
CASE
SEQ
ALT-LINE-NBR
SYSTEM-TIME
|