|
|
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
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX207 CX220 CX30.1 CX300 CX506 CXCP.1
OE114 WH130 WH132 WH190 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 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 Numeric 4 CX05.1 CX05.2
Company This field contains the company number. CX805 CXMC.1
CTJ-REQ-LOCATION Alpha 5 CX05.1 CX05.2
To Location This field contains the location CX805 CXMC.1
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 CX05.1 CX05.2
Preference Code Preference List Code. CX805 CXMC.1
CTJ-PRACTNR-ID Alpha 15 CX05.1 CX05.2
Practitioner ID This field contains the practitioner ID. CX805 CXMC.1
CTJ-PROC-TYPE Alpha 8 CX05.1 CX05.2
Procedure Type The procedure type is the first of two CX805 CXMC.1
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 CX05.1 CX05.2
Procedure Code The procedure code is the second of two CX805 CXMC.1
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 CX05.1 CX05.2
Job Code This field contains a user-defined code CX805
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 CX05.1 CX05.2
Schedule Schedule is the location information CX805
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 CX05.1 CX05.2
Grade This field contains the grade of a CX805
grade range schedule associated with the
job code. A grade range schedule is used
for wage analysis.
CTJ-TMPJOB-SEQ Numeric 3 CX05.1 CX05.2
Template Job This field contains the record sequence CX805
Sequence number.
CTJ-BURDEN-TYPES Alpha 1 CX05.1 CX05.2
Burden Types This field defines whether the burden CX805
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) CX05.1 CX05.2
Description This field contains the description. CX805
CTJ-RATE-AMT Signed 15.2 CX05.1 CX05.2
Rate Amount This field contains the rate assigned CX805
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 CX05.1 CX05.2
Quantity This field contains a units quantity CX805
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) CX05.1 CX05.2
Percentage This field can contain a factor CX805
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 CX05.1 CX05.2
Override Flag Select a value that the Case Carts CX805
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 CX05.1 CX05.2
Activity This field contains a valid activity CX805
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 CX05.1 CX05.2
Account Category This field contains a valid account CX805
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 CX05.1 CX05.2
Origin Identifier This field contains a valid system CX805
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)
IN = CX508 Import Load
CXTMPJOBS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTJSET1 COMPANY BL92.1 CX05.1
REQ-LOCATION CX05.2 CX100
PREF-CODE CX20.1 CX20.2
PROC-TYPE CX20.4 CX20.5
PROC-CODE CX207 CX220
PRACTNR-ID CX30.1 CX300
JOB-CODE CX506 CX805
SCHEDULE CXCP.1 CXMC.1
PAY-GRADE OE114 WH130
TMPJOB-SEQ WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
...
CXTMPJOBS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|