CXLABRHIST – Case Cart Labor History

System: Case Carts (CX)
Prefix: CLH
Primary key: COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ
Fields: 12
Updated by: 1 program
Referenced by: 0 programs

CXLABRHIST is the Case Cart Labor History table in Lawson Case Carts (prefix CLH). It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ (CLHSET1); alternate indexes: CLHSET2. It is related 1:1 to CXCASEPREF. It is updated by CX30.1. The table has 12 fields, 2 indexes and 1 documented relation.

About CXLABRHIST

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the CLH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CLH-COMPANY` PK COMPANY	Numeric 4	This field contains the company number.	CX30.1
`CLH-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	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.	CX30.1
`CLH-CASE` PK CASE	Alpha 15	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.	CX30.1
`CLH-SEQ` PK SEQ	Numeric 3	This field contains the record sequence number.	CX30.1
`CLH-JOB-CODE` PK JOB_CODE	Alpha 9	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.	CX30.1
`CLH-SCHEDULE` PK SCHEDULE	Alpha 9	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.	CX30.1
`CLH-PAY-GRADE` PK PAY_GRADE	Alpha 3	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.	CX30.1
`CLH-PRFJOB-SEQ` PK PRFJOB_SEQ	Numeric 3	This field contains the preference sequence number.	CX30.1
`CLH-LABOR-HRS` LABOR_HRS	Numeric 4	This field contains the number of hours of chargeable time for the burden code.	CX30.1
`CLH-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	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.	CX30.1
`CLH-ACTIVITY` ACTIVITY	Alpha 15	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.	CX30.1
`CLH-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This field contains a system-assigned identifier that provides access to data in related files.	CX30.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CLHSET1`	`COMPANY`, `REQ-LOCATION`, `CASE`, `SEQ`, `JOB-CODE`, `SCHEDULE`, `PAY-GRADE`, `PRFJOB-SEQ`	Primary		CX30.1
`CLHSET2`	`ATN-OBJ-ID`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cxcasepref	CXCASEPREF	Required		`CLH-COMPANY` → `CXP-COMPANY (CXPSET1)`, `CLH-REQ-LOCATION` → `CXP-REQ-LOCATION`, `CLH-CASE` → `CXP-CASE`, `CLH-SEQ` → `CXP-SEQ`

Programs

Updated by (1)

CX30.1 Case Completion Feedback