Template Burdens

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.

REFERENCED BY

CX100	CX20.1	CX20.2	CX20.4	CX20.5	CX207
CX220	CX30.1	CX300	CX506	CXCP.1	WH130
WH132	WH190	WH222	WH30.1	WH30.2	WH30.3
WH30.4	WH31.1	WH31.2	WH31.3	WH31.4	WH32.1
WH32.2	WH32.3	WH32.4	WH32.5	WH33.5	WH34.1
WH34.2	WH34.3	WH34.4	WH40.1	WH40.2	WH520
WH830

UPDATED BY

CX05.1

CX05.2

CX805

CXMC.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CTJ-COMPANY Element: Company	Numeric 4 This field contains the company number.	CX05.1 CX05.2 CX805 CXMC.1
CTJ-REQ-LOCATION Element: 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.	CX05.1 CX05.2 CX805 CXMC.1
CTJ-PREF-CODE Element: Proc Code	Alpha 8 The 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 Element: Practnr Id	Alpha 15 This field contains the practitioner ID.	CX05.1 CX05.2 CX805 CXMC.1
CTJ-PROC-TYPE Element: Proc Code	Alpha 8 The 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 Element: Proc Code	Alpha 8 The 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 Element: 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.	CX05.1 CX05.2 CX805
CTJ-SCHEDULE Element: Schedule	Alpha 9 Schedule 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 Element: Pay Grade	Alpha 3 This 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 Element: Seq	Numeric 3 This field contains the record sequence number.	CX05.1 CX05.2 CX805
CTJ-BURDEN-TYPES Element: Burden Types	Alpha 1 This 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 Element: Description	Alpha 30 (Lower Case) This field contains the description.	CX05.1 CX05.2 CX805
CTJ-RATE-AMT Element: Intl Amt	Signed 18.2 This 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 Element: Quantity	Signed 13.4 This 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 Element: 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 Element: Override Fl	Alpha 1 Select 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 Element: 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.	CX05.1 CX05.2 CX805
CTJ-ACCT-CATEGORY Element: 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.	CX05.1 CX05.2 CX805
CTJ-ORIGIN-ID Element: Origin Id	Alpha 2 This 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 Element: Staff Utiliz	Alpha 1 1 = Surgery 2 = Pre-op 3 = Post-op	CX05.1 CX05.2 CX805
CTJ-ATN-OBJ-ID Element: Obj Id	Numeric 12 This 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

CXTMPJOBS FILE INDEX

CXTMPJOBS FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.