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 |