CXTMPJOBS FILE
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
CXCP.1 WH130 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTJ-COMPANY Numeric 4
Company This field contains the company number.
CTJ-REQ-LOCATION Alpha 5
To Location 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.
CTJ-PREF-CODE Alpha 8
Preference Code Preference List Code.
CTJ-PRACTNR-ID Alpha 15
Practitioner ID This field contains the practitioner ID.
CTJ-PROC-TYPE Alpha 8
Proc Type 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.
CTJ-PROC-CODE Alpha 8
Procedure Code 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.
CTJ-JOB-CODE Alpha 9
Job Code 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.
CTJ-SCHEDULE Alpha 9
Schedule 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.
CTJ-PAY-GRADE Alpha 3
Grade This field contains the grade of a
grade range schedule associated with the
job code. A grade range schedule is used
for wage analysis.
CTJ-TMPJOB-SEQ Numeric 3
Tmpjob Seq This field contains the record sequence
number.
CTJ-BURDEN-TYPES Alpha 1
Burden Types 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
CTJ-DESCRIPTION Alpha 30 (Lower Case)
Description This field contains the description.
CTJ-RATE-AMT Signed 15.2
Rate Amt 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.
CTJ-QTY Signed 13.4
Quantity 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.
CTJ-PERCENTAGE Percent 3.0 (Percent)
Percentage 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.
CTJ-OVERRIDE-FL Alpha 1
Override Fl 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
CTJ-ACTIVITY Alpha 15
Activity 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.
CTJ-ACCT-CATEGORY Alpha 5
Account Category 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.
CTJ-ORIGIN-ID Alpha 2
Origin Id 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)
CTJ-STAFF-UTILIZ Alpha 1
Staff Utiliz 1 = Surgery
2 = Pre-op
3 = Post-op
CTJ-ATN-OBJ-ID Numeric 12
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
CXTMPJOBS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTJSET1 COMPANY CXCP.1 WH130
REQ-LOCATION WH33.5 WH34.1
PREF-CODE WH34.2 WH34.3
PROC-TYPE WH34.4
PROC-CODE
PRACTNR-ID
JOB-CODE
SCHEDULE
PAY-GRADE
TMPJOB-SEQ
CTJSET2 ATN-OBJ-ID KeyChange, Duplicates, Subset
Where ATN-OBJ-ID != Zeroes
CXTMPJOBS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxburden CXBURDEN Not Required
CTJ-COMPANY -> CXB-COMPANY (CXBSET1)
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
|
