CXTMPJOBS

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
CX207


UPDATED BY
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CX805
CXCP.1 CXMC.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 ZW130

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTJSET1 COMPANY
REQ-LOCATION
PREF-CODE
PROC-TYPE
PROC-CODE
PRACTNR-ID
JOB-CODE
SCHEDULE
PAY-GRADE
TMPJOB-SEQ
...
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX207
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
CXMC.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


CXTMPJOBS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cxburden CXBURDEN Not Required
CTJ-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
Cxpreftemp CXPREFTEMP Required
CTJ-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


File created: Thu Jun 09 11:12:31 2016

Home
Contact Us



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