Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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

CXCP.1    POIJ.1    WH130     WH33.1    WH33.2    WH33.3
WH33.4    WH33.5    WH33.6    WH33.8    WH33.9    WH34.1
WH34.2    WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CIH-COMPANY          Numeric 4                                   CXCP.1  POIJ.1
Company              This field contains the company number.     WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-REQ-LOCATION     Alpha 5                                     CXCP.1  POIJ.1
To Location          This field contains the location            WH130   WH33.1
                     requisitioning items and to be charged      WH33.2  WH33.3
                     for the items. This location can be an      WH33.4  WH33.5
                     inventory or noninventory location.         WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                     This value appears as the to location       WH34.2  WH34.3
                     on the pick lists printed when you run      WH34.4
                     CX100 (Pick List Print)  and  WH130
                     (Pick List Print).

                     Valid values are

                     A requesting location defined in RQ01.1
                     (Requesting Location) for the specified
                     healthcare company.

CIH-CASE             Alpha 15                                    CXCP.1  POIJ.1
Case                 This field contains the unique              WH130   WH33.1
                     identifier for the case.                    WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                     A case is a record of the                   WH33.6  WH33.8
                     practitioners, preference lists, and        WH33.9  WH34.1
                     associated information assigned to a        WH34.2  WH34.3
                     specific patient visit.                     WH34.4

                     You can use this number to interface
                     with an outside scheduling system.

CIH-SEQ              Numeric 3                                   CXCP.1  POIJ.1
Sequence Number      This field contains the record sequence     WH130   WH33.1
                     number within the case.                     WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-LINE-NBR         Numeric 6                                   CXCP.1  POIJ.1
Line Number          This field contains the line number.        WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-PROC-TYPE        Alpha 8                                     CXCP.1  POIJ.1
Proc Type            The procedure type is the first of two      WH130   WH33.1
                     fields that uniquely identify a             WH33.2  WH33.3
                     procedure. The procedure type can           WH33.4  WH33.5
                     identify the code set to which the          WH33.6  WH33.8
                     procedure code belongs.                     WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                     For example, you can use one of the         WH34.4
                     following codes:
                     - CPT-4  for a code in the Current
                     Procedural Terminology listing compiled
                     by the American Medical Association
                     -HCPCS for a code in HCFA's (Health
                     Care Financing Administration's) Common
                     Procedure Coding System, or
                     - A code defined for your
                     organization's own procedures listing.

CIH-PROC-CODE        Alpha 8                                     CXCP.1  POIJ.1
Procedure Code       The procedure code is the second of two     WH130   WH33.1
                     fields that uniquely identify a             WH33.2  WH33.3
                     procedure.  The procedure code is an        WH33.4  WH33.5
                     identifier for a specific procedure         WH33.6  WH33.8
                     within a procedure type.                    WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-ALT-LINE-NBR     Numeric 6                                   CXCP.1  POIJ.1
Alt Line Nbr         This field contains the display value       WH130   WH33.1
                     of the item line number.                    WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                     When you assign more that one               WH33.6  WH33.8
                     preference template to a case, the          WH33.9  WH34.1
                     system assigns numbers to the items on      WH34.2  WH34.3
                     the case sequentially. The numbers start    WH34.4
                     with 1 on the  first preference and
                     continue sequentially.

CIH-SYSTEM-DATE      Numeric 8  (yyyymmdd)                       CXCP.1  POIJ.1
System Date          This field contains the system date.        WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-SYSTEM-TIME      Numeric 4                                   CXCP.1  POIJ.1
System Time          This field contains the system time.        WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-ITEM             Alpha 32                                    CXCP.1  POIJ.1
Item Number          This field contains the item                WH130   WH33.1
                     identifier.                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-QTY              Signed 13.4                                 CXCP.1  POIJ.1
Quantity             This field contains the quantity of the     WH130   WH33.1
                     item.                                       WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-UOM              Alpha 4                                     CXCP.1  POIJ.1
Unit of Measure      This field contains the valid stock         WH130   WH33.1
                     unit of measure for this item.              WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-ISS-COST         Signed 13.5                                 CXCP.1  POIJ.1
Iss Cost             This field contains the issue cost.         WH130   WH33.1
                                                                 WH33.2  WH33.3
                     If you report waste and return items        WH33.4  WH33.5
                     for a case by using CX30.1 (Case            WH33.6  WH33.8
                     Completion Feedback), this cost defaults    WH33.9  WH34.1
                     from the case detail when you finish the    WH34.2  WH34.3
                     case.                                       WH34.4

CIH-PRICE            Signed 15.2                                 CXCP.1  POIJ.1
Price                This field contains the flat amount         WH130   WH33.1
                     that is applied as an add-on charge.        WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-REASON-CODE      Alpha 4                                     CXCP.1  POIJ.1
Reason Code          This field contains the reason code         WH130   WH33.1
                     used primarily for reporting returns and    WH33.2  WH33.3
                     waste by CX230 (Waste Return Items).        WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-DESCRIPTION      Alpha 30  (Lower Case)                      CXCP.1  POIJ.1
Description          This field displays the description.        WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-DESCRIPTION2     Alpha 30  (Lower Case)                      CXCP.1  POIJ.1
Second Description   This field contains the second line of      WH130   WH33.1
                     the description.                            WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-REASON-TYPE      Alpha 2                                     CXCP.1  POIJ.1
Reason Type          This field contains the reason type.        WH130   WH33.1
                     1 = Waste                                   WH33.2  WH33.3
                     2 = Leftovers                               WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

CIH-CASE-DATE        Numeric 8  (yyyymmdd)                       CXCP.1  POIJ.1
Case Date            This field contains the case date.          WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

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    CXCP.1  POIJ.1
          REQ-LOCATION  Cart Item History file records in        WH130   WH33.1
          CASE          Company, Requesting Location, Case,      WH33.2  WH33.3
          SEQ           Sequence number, Line Number, Reason     WH33.4  WH33.5
          LINE-NBR      Code, and Reason Type order.             WH33.6  WH33.8
          REASON-CODE                                            WH33.9  WH34.1
          REASON-TYPE                                            WH34.2  WH34.3
                                                                 WH34.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