CXPREFJOBS – Preference Burdens

System
Case Carts (CX)
Prefix
CPJ
Primary key
COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ
Fields
23
Updated by
36 programs
Referenced by
0 programs

CXPREFJOBS is the Preference Burdens table in Lawson Case Carts (prefix CPJ). It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQ (CPJSET1). It is related 1:1 to CXBURDEN and CXCASEPREF. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 28 more. The table has 23 fields, 1 index and 2 documented relations.

About CXPREFJOBS

No description in the Lawson data dictionary.

Fields (23)

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

Field / columnTypeDescription & valuesUpdated by
CPJ-COMPANY PK
COMPANY		Numeric 4This field contains the company number.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-REQ-LOCATION PK
REQ_LOCATION		Alpha 5This 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.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-CASE PK
CASE		Alpha 15This 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 number can be used to interface with an outside scheduling system.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PREF-CODE
PREF_CODE		Alpha 8This field contains the unique code to identify a template.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PROC-TYPE
PROC_TYPE		Alpha 8The procedure type is the first of two fields that uniquely identify a procedure. The procedure type can identify the code set to which the procedure code belongs. For example, you can use one of the 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.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PROC-CODE
PROC_CODE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-JOB-CODE PK
JOB_CODE		Alpha 9This field contains a user-assigned code that represents a type of job or burden. You cannot change a value in this file, but you can delete or add a value. 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.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-SCHEDULE PK
SCHEDULE		Alpha 9Schedule is the location information assigned to a burden (job) code. The data passes from the Human Resources interface record if the information is there, or the data can be entered on the form by the user. Schedule values can include employment locations for practitioners or for assistants or the inventory or noninventory locations of a piece of equipment.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PAY-GRADE PK
PAY_GRADE		Alpha 3This field contains the grade of a grade range schedule associated with the job code. A grade range schedule is used for wage analysis.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PRFJOB-SEQ PK
PRFJOB_SEQ		Numeric 3This field contains the record sequence number.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-BURDEN-TYPES
BURDEN_TYPES		Alpha 1This field defines whether the burden rate is an hourly rate, annual rate, flat fee, units, rental (hourly), or daily rental. For job codes imported from the Human Resources system, this value is typically A for Annual. When you add a preference template to a case, this value typically defaults from the Preference Template file. For burden codes only assigned to the case, not to the preference template, add this value from CX20.2 (Case Detail) after you build the case using CX20.1 (Case Build). The Case Carts system logic uses these values to decide which totals to update when adding a case: For all burden types, the Case Carts system logic updates the Total Burden cost in the Case Cart Preferences file and the Burden Cost for the case in the Case Cart Header file. In addition, for Hourly or Annual types, the Case Carts system logic also updates the Hourly Rate Total in the Case Cart Preferences file. For Unit, Flat Fee, Rental Hourly, and Daily Rental types, the Case Carts system logic also updates the Other Rate total in the Case Cart Preferences file.
  • H Hourly
  • A Annual
  • F Flat
  • U Units
  • R Rental Hourly
  • D Daily Rental
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-RATE-AMT
RATE_AMT		Signed 18.2This field contains the rate assigned to the associated burden (job) code. This field contains a salary range amount for the job code. The Human Resources system uses steps in the HR206 (Job Code Listing) to calculate the minimum, mid-, and maximum ranges. This value, which can be blank, defaults from the Case Cart Burden file based on the Salary Range flag in CX01.1 (Healthcare Company). Use the Salary Range flag in CX01.1 (Healthcare Company) to indicate which salary range (minimum, mid-range, or maximum) to default. The value defaults from the Burden file to this case Rate field when a burden code is assigned to the case. The Case Carts system logic uses this value to calculate the Hourly Rate Total and Total Burden Cost in the Case Cart Preferences file and the Case Burden Cost total in the Case Cart Header file.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-QTY
QTY		Signed 13.4This field contains a units quantity used to price a burden. For example, the field can contain the number of units in a package. Use this field only for nonlabor burden types. The value is used by the Case Carts system to calculate the Rate for the Burdens tab in CX05.1 (Preference Template) or CX20.2 (Case Detail). The value must be greater than zero (0) if the burden type is Units. If not provided, defaults to zero (0).CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-PERCENTAGE
PERCENTAGE		Percent 3.0 (Percent)This field can contain a factor assigned for additional costs such as benefits or hourly rate adjustments by shift. This value defaults from the Template Burdens file when you assign a valid preference template to the case or you can assign a unique burden code with this percentage for the case. When a template is assigned to the case, the Case Carts system uses this value to compute labor costs for the case. The value must equal any whole number from 1 through 100. If not provided, default to zero (0).CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-OVERRIDE-FL
OVERRIDE_FL		Alpha 1Select a cost range value that the Case Carts system uses to automatically override the existing cost range for the burden. (Cost (salary) ranges consist of minimum, mid-range, and maximum salary amounts. For example, at one company a minimum cost range might be $20,001 to $25,000. A mid-range cost range might be $25,001 to $30,000. A maximum cost range might be $30,001 to $35,000.) Defaults to 4 (None) if not provided.
  • 1 Min
  • 2 Mid
  • 3 Max
  • 4 None
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-EFF-DATE
EFF_DATE		Numeric 8 (yyyymmdd)This field defines the effective date for the burden.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-ACTIVITY
ACTIVITY		Alpha 15This field contains a valid activity code from 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.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This 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.CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-ORIGIN-ID
ORIGIN_ID		Alpha 2This field contains a valid system identifier for the Case Carts system where the burden data originated. For example, HR would indicate that the data came from the Human Resources system.
  • HR Human Resources system
  • CX CX15.1 (Burden)
  • TM CX05.1 (Preference Template)
  • CS CX20.1 (Case Build)
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-STAFF-UTILIZ
STAFF_UTILIZ		Alpha 1—
  • 1 Surgery
  • 2 Pre-op
  • 3 Post-op
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +28 more
CPJ-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.CX30.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CPJSET1COMPANY, REQ-LOCATION, CASE, SEQ, JOB-CODE, SCHEDULE, PAY-GRADE, PRFJOB-SEQPrimaryCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CxburdenCXBURDENNot RequiredCPJ-COMPANY → CXB-COMPANY, CPJ-REQ-LOCATION → CXB-REQ-LOCATION, CPJ-JOB-CODE → CXB-JOB-CODE, CPJ-SCHEDULE → CXB-SCHEDULE, CPJ-PAY-GRADE → CXB-PAY-GRADE
CxcaseprefCXCASEPREFRequiredCPJ-COMPANY → CXP-COMPANY, CPJ-REQ-LOCATION → CXP-REQ-LOCATION, CPJ-CASE → CXP-CASE, CPJ-SEQ → CXP-SEQ

Programs

Updated by (36)