Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            CXLABRHIST FILE

                        Case Cart Labor History

The Case Cart Labor History file stores labor history for case visits. When
you finish a case using CX30.1 (Case Completion Feedback), the Case Carts
system sends the case to the Case History file. Once you finish a case, the
system logic for CX20.2 (Case Detail) uses this file and the Case Cart Item
History file to calculate the total cost of the case. Once case data is in
this file, you can no longer change the case in the Case Carts system.

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

CX30.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CLH-COMPANY          Numeric 4
Company              This field contains the company number.

CLH-REQ-LOCATION     Alpha 5
Requesting Location  This field contains the location
                     requisitioning items and to be charged
                     for the items. This location can be an
                     inventory or noninventory location.

                     This value appears as the to location
                     on pick lists printed when you run 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.

CLH-CASE             Alpha 10
Case                 This field contains the unique
                     identifier for the case.

                     A case is a record of the
                     practitioners, preference lists, and
                     associated information assigned to a
                     specific patient visit.

                     The Case Carts system can use this
                     number to interface with an outside
                     scheduling system.

CLH-SEQ              Numeric 3
Sequence             This field contains the record sequence
                     number.

CLH-JOB-CODE         Alpha 9
Job Code             This field contains a user-defined code
                     that represents a type of job or burden.


                      A burden is a resource with a
                     measurable cost assigned to a case. The
                     measurable cost can be an indirect cost,
                     assigned to but not directly related to
                     a case. Examples of burden are salaries,
                     equipment, services, and indirect costs
                     such as costs for capital depreciation
                     or building management.

CLH-SCHEDULE         Alpha 9
Schedule             Schedule is the location information
                     assigned to a burden (job) code.

                     Schedule values can include employment
                     locations for practitioners or for
                     assistants or the inventory or
                     noninventory locations of a piece of
                     equipment.

CLH-PAY-GRADE        Alpha 3
Pay Grade            This field contains the pay grade of a
                     grade range schedule associated with the
                     burden code if for a specific job. The
                     grade comes from the CSV (comma
                     separated file) made in the Human
                     Resources system by HR206 (Job Code
                     Listing) or in a third-party system.

CLH-PRFJOB-SEQ       Numeric 3
Preference Sequence  This field contains the preference
                     sequence number.

CLH-LABOR-HRS        Numeric 4
Labor Hours          This field contains the number of hours
                     of chargeable time for the burden code.

CLH-ACCT-CATEGORY    Alpha 5
Account Category     This field contains a valid account
                     category as defined in the Activity
                     Management system.
                     Note:  Use of the Activity Management
                     system to track and report costs
                     recorded in the Case Carts system is
                     reserved for a future release.

CLH-ACTIVITY         Alpha 15
Activity             This field contains a valid activity
                     code as defined in the Activity
                     Management system.
                     Note:  Use of the Activity Management
                     system to track and report costs
                     recorded in the Case Carts system is
                     reserved for a future release.

CLH-ATN-OBJ-ID       Numeric 12
Atn Object ID        This field contains a system-assigned
                     identifier that provides access to data
                     in related files.

                         CXLABRHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CLHSET1   COMPANY       This index is used to access Case Cart   CX30.1
          REQ-LOCATION  Labor History file records in Company,
          CASE          Requesting Location, Case, Sequence
          SEQ           number, Job Code, Schedule, Pay Grade,
          JOB-CODE      and Preference Job Sequence number
          SCHEDULE      order.
          PAY-GRADE
          PRFJOB-SEQ

CLHSET2   ATN-OBJ-ID    This index is used to access Case Cart
                        Labor History file records in object ID
                        order.
                        Note:  This index is planned for a
                        future release.
                        KeyChange, Duplicates

                         CXLABRHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cxcasepref     CXCASEPREF   Required

                            CLH-COMPANY         -> CXP-COMPANY  (CXPSET1)
                            CLH-REQ-LOCATION    -> CXP-REQ-LOCATION
                            CLH-CASE            -> CXP-CASE
                            CLH-SEQ             -> CXP-SEQ