Position

Positions are specific roles employees hold in a company. They are more detailed than jobs and always created from a job. Positions can inherit pay and cost details from the associated job. A position is unique to a combination of a single configuration set, budget version, entity, and organization.

For PayBasis position definitions, there are position groups that use different sets of properties as it is described in this table:

Position property Annual and monthly job Hourly job Table base annual and monthly job Table base hourly job
Name* x x x x
Description x x x x
Active (defaults to active) x x x x
PositionID* x x x x
Position Effective Start (defaults from set) x x x x
Position Effective End (defaults from set) x x x x
Salary* x x
SalaryTable* x x
SalaryGrade x x
SalaryStep x x
BaseSalaryAccount* x x x x
ProgressionRule x x
ReportID x x x x
MaximumSalary x x
Headcount (if empty, default to 1) x x x x
FTE (if empty, default to 1) x x x x
JobID* x x x x
ExcludeFromDefaults (if empty, defaults to inherit) x x x x
ReportFTE x x x x
PhasingMethod* x x x x
FundingAvailable x x x x
Entity* x x x x
Organization* x x x x

*Required property

The table is WF_POSITION.

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

  • Dimensions:
    • Workforce Position (WBDPOSITION)
    • Position Dynamic Attributes (ATDATTRIBUTE_POSITION)
  • Cubes:
    • Dynamic Attributes Position (ATCDATA_POSITION)
    • WFB Allocation Configuration (WBDCONFIG_ALLOCATION)
    • WFB Calculation (WBCCALCULATION)
    • WFB Calculation Order Configuration (WBCCONFIG_ACTION_ORDER)
    • WFB Main (WBCMAIN)

Position elements are created during the import process by the application in the Workforce Position dimension (WBDPOSITION) which is in the WBDPOSITION hierarchy under TOTAL_POSITION.

The Position business object is related to these business objects:

  • Entity
  • Organization
  • Account
  • Job
  • Phasing Methods
  • Salary Table
  • Progression Rules

This table describes the Position business object:

Field Type Required Description
Name [nvarchar] (252)

NOT NULL

Y Position name.
Description [nvarchar] (252)

NULL

N Description of the position.
Active [bit]

NULL

N Indicates if the position is active or inactive.

These values are valid:

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

If the job is inactive, the position must be inactive.

The default is 0.

If the job is active, the position can be active or inactive.

The default to 1.

PositionID [nvarchar] (200)

NOT NULL

Y Unique position ID in the Position business object.
EffectiveStart [datetime]

NULL

N Effective start date for the position.

The default is the planning start date.

EffectiveEnd [datetime]

NULL

N Effective end date for the position.

Must be greater than or equal to EffectiveStart.

The default is the planning end date.

Salary [float] (53)

NULL

Y/N Salary amount.

Required for positions that do not use the salary table. PayBasis is one of these values:

  • S
  • M
  • H

If the position is inheriting, it must be the same as the job value.

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 positions using salary table. PayBasis is T.

If position is inheriting, it must be the same as the job value.

The default is the job value.

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 positions using the salary table.

PayBasis is T.

If position is inheriting, it must be the same as the job value.

The default is the job value.

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 positions using the salary table.

PayBasis is T.

If the position is inheriting, it must be the same as the job value.

The default is the job value.

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

Y/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 positions using salary table.

If the position is inheriting, it must be the same as the job value.

The default is the job progression rule.

MaximumSalary [float] (53)

NULL

Y/N Maximum salary paid for the position.

Only for annual or monthly PayBasis.

Includes annual and monthly salary table based position.

If the position is not inheriting, then it is optional. Can be any value which is greater than 0.

If the position is inheriting, it must be the same as the job value.

ReportID [nvarchar] (200)

NULL

N Tag for reporting.
Headcount [float] (53)

NULL

N Authorized number of employees that can be assigned to the position used for initial action on the position.

Must be a value greater than 0.

The default value is 1.

FTE [float] (53)

NULL

N Full Time Equivalent.

Used to set the initial FTE for an annual or monthly position and the initial hours for an hourly position. The specified FTE is converted to hours.

The default value is 1.

JobID [nvarchar] (200)

NOT NULL

Y Unique job ID in the Job business object.

The related table is Job, the field is JobID.

ExcludeFromDefaults [bit]

NULL

N Exclude the position from any changes that are made to the default values that are specified in the job.

These values are valid:

  • 1 for not inheriting changes.
  • 0 for inheriting changes.

These are the properties that can be inherited per Pay Basis:

  • Annual and monthly
    • Salary
    • Maximum salary
  • Hourly rate
  • Table base annual and monthly
    • Salary table
    • Salary grade
    • Salary step
    • Progression rule
    • Maximum salary
  • Table base hourly
    • Salary table
    • Salary grade
    • Salary step
    • Progression rule

The default value is 0.

ReportFTE [float] (53)

NULL

N Full time equivalent value for reporting.
PhasingMethod [nvarchar] (252)

NULL

Y Cost spread over time.

Valid phasing method name in the Phasing Methods business objects.

If empty, the default values from Job are used.

FundingAvailable [datetime]

NULL

N Date when funding is available.

There is no default.

Entity [nvarchar] (200)

NOT NULL

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

NOT NULL

Y Unique organization ID in the Organization business object.
WorkingHours [float] (53)

NULL

N Working hours that can be assigned to the position assignment.

Working hours are used only by hourly position and assignment.

The related table is Job, the field is PayBasis, the value is H or T.

The field can be empty.

There is no default value.