Lawson Insight Technical Documentation |
|
CXPREFJOBS
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
BL92.1 CXCP.1 OE114 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 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPJ-COMPANY Numeric 4 BL92.1 CXCP.1
Element: Company This field contains the company number. OE114 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-REQ-LOCATION Alpha 5 BL92.1 CXCP.1
Element: To Location This field contains the location OE114 WH130
requisitioning items and to be charged WH132 WH190
for the items. This location can be an WH222 WH30.1
inventory or noninventory location. WH30.2 WH30.3
WH30.4 WH31.1
This value appears as the to location WH31.2 WH31.3
on pick lists printed when you run CX100 WH31.4 WH32.1
(Pick List Print) and WH130 (Pick List WH32.2 WH32.3
Print). WH32.4 WH33.5
WH34.1 WH34.2
Valid values are WH34.3 WH34.4
WH40.1 WH40.2
A requesting location defined in RQ01.1 WH520 WH830
(Requesting Location) for the specified
healthcare company.
CPJ-CASE Alpha 15 BL92.1 CXCP.1
Element: Case This field contains the unique OE114 WH130
identifier for the case. WH132 WH190
WH222 WH30.1
A case is a record of the WH30.2 WH30.3
practitioners, preference lists, and WH30.4 WH31.1
associated information assigned to a WH31.2 WH31.3
specific patient visit. WH31.4 WH32.1
WH32.2 WH32.3
The case number can be used to WH32.4 WH33.5
interface with an outside scheduling WH34.1 WH34.2
system. WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-PREF-CODE Alpha 8 BL92.1 CXCP.1
Element: Procedure CodeThis field contains the unique code to OE114 WH130
identify a template. 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-SEQ Numeric 3 BL92.1 CXCP.1
Element: Sequence NumbeThis field contains the record sequence OE114 WH130
number. 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-PROC-TYPE Alpha 8 BL92.1 CXCP.1
Element: Procedure CodeThe procedure type is the first of two OE114 WH130
fields that uniquely identify a WH132 WH190
procedure. The procedure type can WH222 WH30.1
identify the code set to which the WH30.2 WH30.3
procedure code belongs. WH30.4 WH31.1
WH31.2 WH31.3
For example, you can use one of the WH31.4 WH32.1
following codes: WH32.2 WH32.3
- CPT-4 for a code in the Current WH32.4 WH33.5
Procedural Terminology listing compiled WH34.1 WH34.2
by the American Medical Association WH34.3 WH34.4
-HCPCS for a code in HCFA's (Health WH40.1 WH40.2
Care Financing Administration's) Common WH520 WH830
Procedure Coding System, or
- A code defined for your
organization's own procedures listing.
CPJ-PROC-CODE Alpha 8 BL92.1 CXCP.1
Element: Procedure CodeThe procedure code is the second of two OE114 WH130
fields that uniquely identify a WH132 WH190
procedure. The procedure code is an WH222 WH30.1
identifier for a specific procedure WH30.2 WH30.3
within a procedure type. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-JOB-CODE Alpha 9 BL92.1 CXCP.1
Element: Job Code This field contains a user-assigned OE114 WH130
code that represents a type of job or WH132 WH190
burden. You cannot change a value in WH222 WH30.1
this file, but you can delete or add a WH30.2 WH30.3
value. WH30.4 WH31.1
WH31.2 WH31.3
A burden is a resource with a WH31.4 WH32.1
measurable cost assigned to a case. The WH32.2 WH32.3
measurable cost can be an indirect cost, WH32.4 WH33.5
assigned to but not directly related to WH34.1 WH34.2
a case. Examples of burden are salaries, WH34.3 WH34.4
equipment, services, and indirect costs WH40.1 WH40.2
such as costs for capital depreciation WH520 WH830
or building management.
CPJ-SCHEDULE Alpha 9 BL92.1 CXCP.1
Element: Schedule Schedule is the location information OE114 WH130
assigned to a burden (job) code. The WH132 WH190
data passes from the Human Resources WH222 WH30.1
interface record if the information is WH30.2 WH30.3
there, or the data can be entered on the WH30.4 WH31.1
form by the user. WH31.2 WH31.3
WH31.4 WH32.1
Schedule values can include employment WH32.2 WH32.3
locations for practitioners or for WH32.4 WH33.5
assistants or the inventory or WH34.1 WH34.2
noninventory locations of a piece of WH34.3 WH34.4
equipment. WH40.1 WH40.2
WH520 WH830
CPJ-PAY-GRADE Alpha 3 BL92.1 CXCP.1
Element: Grade This field contains the grade of a OE114 WH130
grade range schedule associated with the WH132 WH190
job code. A grade range schedule is used WH222 WH30.1
for wage analysis. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-PRFJOB-SEQ Numeric 3 BL92.1 CXCP.1
Element: Sequence NumbeThis field contains the record sequence OE114 WH130
number. 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-BURDEN-TYPES Alpha 1 BL92.1 CXCP.1
Element: Burden Types This field defines whether the burden OE114 WH130
rate is an hourly rate, annual rate, WH132 WH190
flat fee, units, rental (hourly), or WH222 WH30.1
daily rental. WH30.2 WH30.3
WH30.4 WH31.1
For job codes imported from the Human WH31.2 WH31.3
Resources system, this value is WH31.4 WH32.1
typically A for Annual. WH32.2 WH32.3
WH32.4 WH33.5
When you add a preference template to a WH34.1 WH34.2
case, this value typically defaults from WH34.3 WH34.4
the Preference Template file. For burden WH40.1 WH40.2
codes only assigned to the case, not to WH520 WH830
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) BL92.1 CXCP.1
Element: Description This field contains the description. OE114 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-RATE-AMT Signed 18.2 BL92.1 CXCP.1
Element: Intl Amt This field contains the rate assigned OE114 WH130
to the associated burden (job) code. WH132 WH190
WH222 WH30.1
This field contains a salary range WH30.2 WH30.3
amount for the job code. The Human WH30.4 WH31.1
Resources system uses steps in the HR206 WH31.2 WH31.3
(Job Code Listing) to calculate the WH31.4 WH32.1
minimum, mid-, and maximum ranges. This WH32.2 WH32.3
value, which can be blank, defaults from WH32.4 WH33.5
the Case Cart Burden file based on the WH34.1 WH34.2
Salary Range flag in CX01.1 (Healthcare WH34.3 WH34.4
Company). WH40.1 WH40.2
WH520 WH830
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 BL92.1 CXCP.1
Element: Quantity This field contains a units quantity OE114 WH130
used to price a burden. For example, the WH132 WH190
field can contain the number of units in WH222 WH30.1
a package. Use this field only for WH30.2 WH30.3
nonlabor burden types. The value is used WH30.4 WH31.1
by the Case Carts system to calculate WH31.2 WH31.3
the Rate for the Burdens tab in CX05.1 WH31.4 WH32.1
(Preference Template) or CX20.2 (Case WH32.2 WH32.3
Detail). WH32.4 WH33.5
WH34.1 WH34.2
The value must be greater than zero (0) WH34.3 WH34.4
if the burden type is Units. WH40.1 WH40.2
WH520 WH830
If not provided, defaults to zero (0).
CPJ-PERCENTAGE Percent 3.0 (Percent) BL92.1 CXCP.1
Element: Percentage This field can contain a factor OE114 WH130
assigned for additional costs such as WH132 WH190
benefits or hourly rate adjustments by WH222 WH30.1
shift. This value defaults from the WH30.2 WH30.3
Template Burdens file when you assign a WH30.4 WH31.1
valid preference template to the case or WH31.2 WH31.3
you can assign a unique burden code with WH31.4 WH32.1
this percentage for the case. When a WH32.2 WH32.3
template is assigned to the case, the WH32.4 WH33.5
Case Carts system uses this value to WH34.1 WH34.2
compute labor costs for the case. WH34.3 WH34.4
WH40.1 WH40.2
The value must equal any whole number WH520 WH830
from 1 through 100.
If not provided, default to zero (0).
CPJ-OVERRIDE-FL Alpha 1 BL92.1 CXCP.1
Element: Override Fl Select a cost range value that the Case OE114 WH130
Carts system uses to automatically WH132 WH190
override the existing cost range for the WH222 WH30.1
burden. (Cost (salary) ranges consist of WH30.2 WH30.3
minimum, mid-range, and maximum salary WH30.4 WH31.1
amounts. For example, at one company a WH31.2 WH31.3
minimum cost range might be $20,001 to WH31.4 WH32.1
$25,000. A mid-range cost range might be WH32.2 WH32.3
$25,001 to $30,000. A maximum cost range WH32.4 WH33.5
might be $30,001 to $35,000.) WH34.1 WH34.2
WH34.3 WH34.4
Defaults to 4 (None) if not provided. WH40.1 WH40.2
1 = Min WH520 WH830
2 = Mid
3 = Max
4 = None
CPJ-EFF-DATE Numeric 8 (yyyymmdd) BL92.1 CXCP.1
Element: Effective DateThis field defines the effective date OE114 WH130
for the burden. 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-ACTIVITY Alpha 15 BL92.1 CXCP.1
Element: Activity This field contains a valid activity OE114 WH130
code from the Activity Management WH132 WH190
system. WH222 WH30.1
Note: Use of the Activity Management WH30.2 WH30.3
system to track and report costs WH30.4 WH31.1
recorded in the Case Carts system is WH31.2 WH31.3
reserved for a future release. WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-ACCT-CATEGORY Alpha 5 BL92.1 CXCP.1
Element: Account CategoThis field contains a valid account OE114 WH130
category as defined in the Activity WH132 WH190
Management system. WH222 WH30.1
Note: Use of the Activity Management WH30.2 WH30.3
system to track and report costs WH30.4 WH31.1
recorded in the Case Carts system is WH31.2 WH31.3
reserved for a future release. WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-ORIGIN-ID Alpha 2 BL92.1 CXCP.1
Element: Origin Id This field contains a valid system OE114 WH130
identifier for the Case Carts system WH132 WH190
where the burden data originated. WH222 WH30.1
WH30.2 WH30.3
For example, HR would indicate that the WH30.4 WH31.1
data came from the Human Resources WH31.2 WH31.3
system. WH31.4 WH32.1
HR = Human Resources system WH32.2 WH32.3
CX = CX15.1 (Burden) WH32.4 WH33.5
TM = CX05.1 (Preference Template) WH34.1 WH34.2
CS = CX20.1 (Case Build) WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-STAFF-UTILIZ Alpha 1 BL92.1 CXCP.1
Element: Staff Utiliz 1 = Surgery OE114 WH130
2 = Pre-op WH132 WH190
3 = Post-op 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CPJ-ATN-OBJ-ID Numeric 12
Object The system-defined object id
Identification representing the Activity Management
commitment.
CXPREFJOBS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPJSET1 COMPANY BL92.1 CXCP.1
REQ-LOCATION OE114 WH130
CASE WH132 WH190
SEQ WH222 WH30.1
JOB-CODE WH30.2 WH30.3
SCHEDULE WH30.4 WH31.1
PAY-GRADE WH31.2 WH31.3
PRFJOB-SEQ WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CXPREFJOBS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxburden CXBURDEN Not Required
CPJ-COMPANY -> CXB-COMPANY
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
|