Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CXTMPJOBS


                             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    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

CTJ-COMPANY            Numeric 4
Element: Company       This field contains the company number.

CTJ-REQ-LOCATION       Alpha 5
Element: 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
Element: Procedure CodePreference List Code.

CTJ-PRACTNR-ID         Alpha 15
Element: Practitioner IThis field contains the practitioner ID.

CTJ-PROC-TYPE          Alpha 8
Element: Procedure CodeThe 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
Element: Procedure CodeThe 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
Element: 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
Element: 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
Element: 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
Element: Sequence NumbeThis field contains the record sequence
                       number.

CTJ-BURDEN-TYPES       Alpha 1
Element: 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)
Element: Description   This field contains the description.

CTJ-RATE-AMT           Signed 18.2
Element: Intl 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
Element: 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)
Element: 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
Element: 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
Element: 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
Element: Account CategoThis 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
Element: 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
Element: Staff Utiliz  1 = Surgery
                       2 = Pre-op
                       3 = Post-op

CTJ-ATN-OBJ-ID         Numeric 12
Object                 The system-defined object id
Identification         representing the Activity Management
                       commitment.

                         CXTMPJOBS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CTJSET1   COMPANY                                                BL92.1  CXCP.1
          REQ-LOCATION                                           OE114   WH130
          PREF-CODE                                              WH132   WH190
          PROC-TYPE                                              WH222   WH30.1
          PROC-CODE                                              WH30.2  WH30.3
          PRACTNR-ID                                             WH30.4  WH31.1
          JOB-CODE                                               WH31.2  WH31.3
          SCHEDULE                                               WH31.4  WH32.1
          PAY-GRADE                                              WH32.2  WH32.3
          TMPJOB-SEQ                                             WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

                         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