CXTMPJOBS – Template Burdens

System
Case Carts (CX)
Prefix
CTJ
Primary key
COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, JOB-CODE, SCHEDULE, PAY-GRADE, TMPJOB-SEQ
Fields
21
Updated by
4 programs
Referenced by
37 programs

CXTMPJOBS is the Template Burdens table in Lawson Case Carts (prefix CTJ). It is indexed by COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, JOB-CODE, SCHEDULE, PAY-GRADE, TMPJOB-SEQ (CTJSET1). It is related 1:1 to CXBURDEN and CXPREFTEMP. It is updated by CX05.1, CX05.2, CX805 and CXMC.1 and referenced by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX207, CX220, CX30.1 and 29 more. The table has 21 fields, 1 index and 2 documented relations.

About CXTMPJOBS

The Template Burdens file contains the burden codes that are assigned to a preference template. (Burden codes define resources (both salaried and nonsalaried) and associated costs.) The Case Carts system uses this file to provide default burden data to the Preference Burdens file records when adding preference templates to a case. Use the Burdens tab in CX05.1 (Preference Template) to add or delete records from this file. When you assign the preference templates to cases by using CX20.1 (Case Build), the Case Carts system defaults the associated values in this file to a case.

Fields (21)

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

Field / columnTypeDescription & valuesUpdated by
CTJ-COMPANY PK
COMPANY		Numeric 4This field contains the company number.CX05.1, CX05.2, CX805, CXMC.1
CTJ-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.CX05.1, CX05.2, CX805, CXMC.1
CTJ-PREF-CODE PK
PREF_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.CX05.1, CX05.2, CX805, CXMC.1
CTJ-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID.CX05.1, CX05.2, CX805, CXMC.1
CTJ-PROC-TYPE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTJ-PROC-CODE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTJ-JOB-CODE PK
JOB_CODE		Alpha 9This 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.CX05.1, CX05.2, CX805
CTJ-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 it 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.CX05.1, CX05.2, CX805
CTJ-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.CX05.1, CX05.2, CX805
CTJ-TMPJOB-SEQ PK
TMPJOB_SEQ		Numeric 3This field contains the record sequence number.CX05.1, CX05.2, CX805
CTJ-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. Users can add this value using the Burdens tab in CX05.1 (Preference Template). 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 fee
  • U Units
  • R Rental Hourly
  • D Daily Rental
CX05.1, CX05.2, CX805
CTJ-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description.CX05.1, CX05.2, CX805
CTJ-RATE-AMT
RATE_AMT		Signed 18.2This field contains the rate assigned to the associated burden 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 in part 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. This value defaults from the Burden file when a burden code is assigned to the template. When a case is built using the template with this rate amount, the Case Carts system logic uses this value to calculate costs. The costs calculated are 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. This value must be provided.CX05.1, CX05.2, CX805
CTJ-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 Burdens tab in CX05.1 (Preference Template) or CX20.2 (Case Detail). This field contains the user-defined units used to price a burden. The value must be greater than zero (0) if the burden type is Units.CX05.1, CX05.2, CX805
CTJ-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 Case Cart Burden file when you assign a valid burden code or you can assign a unique burden code with this percentage for the template. When the template is assigned to a case, the Case Carts system uses this value to compute labor costs for a case. The value must equal any whole number from 1 through 100.CX05.1, CX05.2, CX805
CTJ-OVERRIDE-FL
OVERRIDE_FL		Alpha 1Select a value that the Case Carts system uses to automatically override the existing cost range for the burden. Cost (salary) ranges consist of a minimum and maximum salary amount. 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. You define the kind (minimum, mid-range, or maximum) of default salary range in CX01.1 (Healthcare Company).)
  • 1 Min
  • 2 Mid
  • 3 Max
  • 4 None
CX05.1, CX05.2, CX805
CTJ-ACTIVITY
ACTIVITY		Alpha 15This 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.CX05.1, CX05.2, CX805
CTJ-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.CX05.1, CX05.2, CX805
CTJ-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)
CX05.1, CX05.2, CX805
CTJ-STAFF-UTILIZ
STAFF_UTILIZ		Alpha 1—
  • 1 Surgery
  • 2 Pre-op
  • 3 Post-op
CX05.1, CX05.2, CX805
CTJ-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.CX05.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CTJSET1COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, JOB-CODE, SCHEDULE, PAY-GRADE, TMPJOB-SEQPrimaryCX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX207 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CxburdenCXBURDENNot RequiredCTJ-COMPANY → CXB-COMPANY, CTJ-REQ-LOCATION → CXB-REQ-LOCATION, CTJ-JOB-CODE → CXB-JOB-CODE, CTJ-SCHEDULE → CXB-SCHEDULE, CTJ-PAY-GRADE → CXB-PAY-GRADE
CxpreftempCXPREFTEMPRequiredCTJ-COMPANY → CPT-COMPANY, CTJ-REQ-LOCATION → CPT-REQ-LOCATION, CTJ-PREF-CODE → CPT-PREF-CODE, CTJ-PROC-TYPE → CPT-PROC-TYPE, CTJ-PROC-CODE → CPT-PROC-CODE, CTJ-PRACTNR-ID → CPT-PRACTNR-ID

Programs

Updated by (4)

Referenced by (37)