Job

Jobs are general groupings used to create specific positions. From one job, one or more positions can be created. 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 as it is described in this table:

Job property Annual and monthly job Hourly job Table base annual and monthly job Table base hourly job
Job Code* x x x x
Name* x x x x
Description x x x x
Pay Basis* x x x x
Active (if empty, defaults to active) x x x x
Salary* x x
Salary x x
SalaryTable* x x
SalaryGrade x x
SalaryStep x x
BaseSalaryAccount* x x x x
ProgressionRule x x
Work Location x x x x
Annual Hours (if empty, defaults from WB config) x x
Maximum Salary x x
Phasing Method* x x x x
Pay Periods (if empty, defaults from WB config) x x

*Required property

The table is WF_Job.

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

  • Dimensions
    • Workforce Job (WBDJOB)
    • Job Dynamic Attributes (ATDATTRIBUTE_JOB)
  • Cubes
    • Dynamic Attributes Job (ATCDATA_JOB)
    • WFB Calculation (WBCCALCULATION)
    • WFB Calculation Order Configuration (WBCCONFIG_ACTION_ORDER)
    • WFB Main (WBCMAIN)

Job elements are created during the import process by the application in the Workforce Job dimension (WBDJOB) 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 Required 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 based 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
Salary [float] (53)

NULL

 N Salary amount.

Optional 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 hourly jobs or T for table based jobs that are hourly.

If empty, the default values from the Set Periodicity tab in the Workforce Budgeting Configuration Wizard are used.
MaximumSalary [float] (53)

NULL

 N Maximum salary paid for job.

Only for annual or monthly PayBasis.

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

NULL

 Y Cost spread over time.

Valid phasing method name in the Phasing Methods business object.

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

NULL

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

Required for hourly jobs. PayBasis is H hourly jobs or T for table based jobs that are hourly.

If empty, the default values from the Set Periodicity tab in the Workforce Budgeting Configuration Wizard are used.