Job

Jobs are general groupings used to create specific positions. Jobs provide default values as well as default pay and cost information for positions.

For PayBasis job definitions, there are job groups that use different sets of properties:

  • Annual/Monthly Job

    Property: Salary, MaximumSalary

  • Hourly Job

    Properties: Salary, AnnualHours, PayPeriods

  • Annual/Monthly Table Base Job

    Properties: SalaryTable, SalaryGrade, SalaryStep, ProgressionRule, MaximumSalary

  • Hourly Table Base Job

    Properties: SalaryTable, SalaryGrade, SalaryStep, ProgressionRule, AnnualHours, PayPeriods

The common properties for both groups are: JobID, Name, Description, Active, Entity, PayBasis, BaseSalaryAccount, WorkLocation, and PhasingMethod.

The staging table is WF_Job.

The Job business object is used in these dimensions and cubes:

  • Dimensions
    • WBDJOB
    • ATDATTRIBUTE_JOB
  • Cubes
    • ATCDATA_JOB
    • WBCCALCULATION
    • WBCCONFIG_ACTION_ORDER
    • WBCMAIN

Job elements are created during the import process by the application in the WBDJOB dimension which is in the WBDJOB hierarchy under TOTAL_JOB.

The Job business object is related to these business objects:

  • Entity
  • Account
  • Phasing Methods
  • Salary Table (used only by table based jobs)
  • Progression Rules (used only by table based jobs)

This table describes the Job business object:

Field Type Mandatory Description
JobID [nvarchar] (200)

NOT NULL

 Y Unique job ID per entity.
Name [nvarchar] (252)

NOT NULL

 Y Job name.
Description [nvarchar] (252)

NULL

 N Description of the job.
Active [bit]

NULL

 N Indicates if the job is active or inactive.

These values are valid:

  • 1 for an active job.
  • 0 for an inactive job.

The default is 1.
Entity [nvarchar] (200)

NOT NULL

 Y Unique entity ID in the Entity business object that is activated in the configuration set.
PayBasis [nvarchar] (1)

NOT NULL

 Y One character code for pay basis.

These values are valid:

  • S for annual salary.
  • M for monthly salary.
  • T for table base salary.
  • H for hourly salary.

There is no default value.
Salary [float] (53)

NULL

 Y/N Salary amount.

Required for jobs that do not use the salary table.

PayBasis is one of these values:

  • S
  • M
  • H
SalaryTable [nvarchar] (252)

NULL

 Y/N Valid salary table name in the Salary Table business object.

The related table is SalaryTable, the field is SalaryTableID.

Required for jobs using the salary table.

PayBasis is T.
SalaryGrade [nvarchar] (252)

NULL

 Y/N Valid salary table grade in the Salary Table business object.

The related table is SalaryTableGrade, the field is Name.

Required for jobs using the salary table.

PayBasis is T.
SalaryStep [nvarchar] (252)

NULL

 Y/N Valid salary table step in the Salary Table business object.

The related table is SalaryTableStep, the field is Step.

Required for jobs using salary table.

PayBasis is T.
BaseSalaryAccount [nvarchar] (252)

NOT NULL

 Y Valid base salary account ID in the Account business object that has been activated for the configuration set in which data will be loaded.
ProgressionRule [nvarchar] (252)

NULL

 N Automatic progression between salary steps in grades, and between salary grades. Valid progression rule in the Progression Rules business object.

The related table is ProgresionRule, the field is Name.

Optional for jobs using salary table.

PayBasis is T.
WorkLocation [nvarchar] (252)

NULL

 N Specify where the job is based.

Free text.
AnnualHours [float] (53)

NULL

 Y/N Positive number of hours in a year for a job.

Required for hourly jobs. PayBasis is H or T.
MaximumSalary [float] (53)

NULL

 N Maximum salary paid for job.

Only for annual or monthly PayBasis.

Includes annual and monthly salary table jobs.
PhasingMethod [nvarchar] (252)

NULL

 Y Cost spread over time.

Valid phasing method name in the Phasing Methods business object.
PayPeriods [float] (53)

NULL

 Y/N Positive number of periods in a year for job.

Required for hourly jobs. Pay basis is H or T.