CXPREFJOBS FILE
Preference Burdens
The Preference Burdens file contains all preference list burden codes and
related information. The Case Carts system uses this file to store burden code
data for burden codes assigned to case preferences.
Burden codes originate either in the Human Resources system or the Case Carts
system. You can run the Human Resources interface programs, HR206 (Job Code
Listing) and CX504 (HR Labor Import) to import job codes, or define them in
CX15.1 (Burden). Burden is a generic term for chargeable resources other than
items, such as jobs (labor), fixed costs, depreciation of capital equipment,
and so on.
You use CX20.2 (Case Detail) to assign new burden codes or to change or
delete burden codes for a case in this file. You cannot change a record in
this file once the case is finished (status is 4 Charges Passed or 5 No
Charges). Records are added to this file by assigning a preference template to
a case using CX20.1 (Case Build) or using CX506 (HL7 Schedules Import
Interface). CX506 system logic uses each imported procedure code to determine
which template (with associated burden codes) to assign to a case.
UPDATED BY
CXCP.1 WH130 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPJ-COMPANY Numeric 4 CXCP.1 WH130
Company This field contains the company number. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
CPJ-REQ-LOCATION Alpha 5 CXCP.1 WH130
To Location This field contains the location WH33.5 WH34.1
requisitioning items and to be charged WH34.2 WH34.3
for the items. This location can be an WH34.4
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.
CPJ-CASE Alpha 15 CXCP.1 WH130
Case This field contains the unique WH33.5 WH34.1
identifier for the case. WH34.2 WH34.3
WH34.4
A case is a record of the
practitioners, preference lists, and
associated information assigned to a
specific patient visit.
The case number can be used to
interface with an outside scheduling
system.
CPJ-PREF-CODE Alpha 8 CXCP.1 WH130
Preference Code This field contains the unique code to WH33.5 WH34.1
identify a template. WH34.2 WH34.3
WH34.4
CPJ-SEQ Numeric 3 CXCP.1 WH130
Sequence Number This field contains the record sequence WH33.5 WH34.1
number. WH34.2 WH34.3
WH34.4
CPJ-PROC-TYPE Alpha 8 CXCP.1 WH130
Proc Type The procedure type is the first of two WH33.5 WH34.1
fields that uniquely identify a WH34.2 WH34.3
procedure. The procedure type can WH34.4
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.
CPJ-PROC-CODE Alpha 8 CXCP.1 WH130
Procedure Code The procedure code is the second of two WH33.5 WH34.1
fields that uniquely identify a WH34.2 WH34.3
procedure. The procedure code is an WH34.4
identifier for a specific procedure
within a procedure type.
CPJ-JOB-CODE Alpha 9 CXCP.1 WH130
Job Code This field contains a user-assigned WH33.5 WH34.1
code that represents a type of job or WH34.2 WH34.3
burden. You cannot change a value in WH34.4
this file, but you can delete or add a
value.
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.
CPJ-SCHEDULE Alpha 9 CXCP.1 WH130
Schedule Schedule is the location information WH33.5 WH34.1
assigned to a burden (job) code. The WH34.2 WH34.3
data passes from the Human Resources WH34.4
interface record if the information is
there, or the data 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.
CPJ-PAY-GRADE Alpha 3 CXCP.1 WH130
Grade This field contains the grade of a WH33.5 WH34.1
grade range schedule associated with the WH34.2 WH34.3
job code. A grade range schedule is used WH34.4
for wage analysis.
CPJ-PRFJOB-SEQ Numeric 3 CXCP.1 WH130
Prfjob Seq This field contains the record sequence WH33.5 WH34.1
number. WH34.2 WH34.3
WH34.4
CPJ-BURDEN-TYPES Alpha 1 CXCP.1 WH130
Burden Types This field defines whether the burden WH33.5 WH34.1
rate is an hourly rate, annual rate, WH34.2 WH34.3
flat fee, units, rental (hourly), or WH34.4
daily rental.
For job codes imported from the Human
Resources system, this value is
typically A for Annual.
When you add a preference template to a
case, this value typically defaults from
the Preference Template file. For burden
codes only assigned to the case, not to
the preference template, add this value
from CX20.2 (Case Detail) after you
build the case using CX20.1 (Case
Build).
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
U = Units
R = Rental Hourly
D = Daily Rental
CPJ-DESCRIPTION Alpha 30 (Lower Case) CXCP.1 WH130
Description This field contains the description. WH33.5 WH34.1
WH34.2 WH34.3
WH34.4
CPJ-RATE-AMT Signed 15.2 CXCP.1 WH130
Rate Amt This field contains the rate assigned WH33.5 WH34.1
to the associated burden (job) code. WH34.2 WH34.3
WH34.4
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 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. The value defaults
from the Burden file to this case Rate
field when a burden code is assigned to
the case.
The Case Carts system logic uses this
value to calculate 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.
CPJ-QTY Signed 13.4 CXCP.1 WH130
Quantity This field contains a units quantity WH33.5 WH34.1
used to price a burden. For example, the WH34.2 WH34.3
field can contain the number of units in WH34.4
a package. Use this field only for
nonlabor burden types. The value is used
by the Case Carts system to calculate
the Rate for the Burdens tab in CX05.1
(Preference Template) or CX20.2 (Case
Detail).
The value must be greater than zero (0)
if the burden type is Units.
If not provided, defaults to zero (0).
CPJ-PERCENTAGE Percent 3.0 (Percent) CXCP.1 WH130
Percentage This field can contain a factor WH33.5 WH34.1
assigned for additional costs such as WH34.2 WH34.3
benefits or hourly rate adjustments by WH34.4
shift. This value defaults from the
Template Burdens file when you assign a
valid preference template to the case or
you can assign a unique burden code with
this percentage for the case. When a
template is assigned to the case, the
Case Carts system uses this value to
compute labor costs for the case.
The value must equal any whole number
from 1 through 100.
If not provided, default to zero (0).
CPJ-OVERRIDE-FL Alpha 1 CXCP.1 WH130
Override Fl Select a cost range value that the Case WH33.5 WH34.1
Carts system uses to automatically WH34.2 WH34.3
override the existing cost range for the WH34.4
burden. (Cost (salary) ranges consist of
minimum, mid-range, and maximum salary
amounts. 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.)
Defaults to 4 (None) if not provided.
1 = Min
2 = Mid
3 = Max
4 = None
CPJ-EFF-DATE Numeric 8 (yyyymmdd) CXCP.1 WH130
Effective Date This field defines the effective date WH33.5 WH34.1
for the burden. WH34.2 WH34.3
WH34.4
CPJ-ACTIVITY Alpha 15 CXCP.1 WH130
Activity This field contains a valid activity WH33.5 WH34.1
code from the Activity Management WH34.2 WH34.3
system. WH34.4
Note: Use of the Activity Management
system to track and report costs
recorded in the Case Carts system is
reserved for a future release.
CPJ-ACCT-CATEGORY Alpha 5 CXCP.1 WH130
Account Category This field contains a valid account WH33.5 WH34.1
category as defined in the Activity WH34.2 WH34.3
Management system. WH34.4
Note: Use of the Activity Management
system to track and report costs
recorded in the Case Carts system is
reserved for a future release.
CPJ-ORIGIN-ID Alpha 2 CXCP.1 WH130
Origin Id This field contains a valid system WH33.5 WH34.1
identifier for the Case Carts system WH34.2 WH34.3
where the burden data originated. WH34.4
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)
CPJ-STAFF-UTILIZ Alpha 1 CXCP.1 WH130
Staff Utiliz 1 = Surgery WH33.5 WH34.1
2 = Pre-op WH34.2 WH34.3
3 = Post-op WH34.4
CPJ-ATN-OBJ-ID Numeric 12
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
CXPREFJOBS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPJSET1 COMPANY CXCP.1 WH130
REQ-LOCATION WH33.5 WH34.1
CASE WH34.2 WH34.3
SEQ WH34.4
JOB-CODE
SCHEDULE
PAY-GRADE
PRFJOB-SEQ
CPJSET2 ATN-OBJ-ID KeyChange, Duplicates, Subset
Where ATN-OBJ-ID != Zeroes
CXPREFJOBS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxburden CXBURDEN Not Required
CPJ-COMPANY -> CXB-COMPANY (CXBSET1)
CPJ-REQ-LOCATION -> CXB-REQ-LOCATION
CPJ-JOB-CODE -> CXB-JOB-CODE
CPJ-SCHEDULE -> CXB-SCHEDULE
CPJ-PAY-GRADE -> CXB-PAY-GRADE
Cxcasepref CXCASEPREF Required
CPJ-COMPANY -> CXP-COMPANY
CPJ-REQ-LOCATION -> CXP-REQ-LOCATION
CPJ-CASE -> CXP-CASE
CPJ-SEQ -> CXP-SEQ
|
