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.

The staging table is WF_POSITION.

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

  • Dimensions:
    • WBDPOSITION
    • ATDATTRIBUTE_POSITION
  • Cubes:
    • ATCDATA_POSITION
    • WBDCONFIG_ALLOCATION
    • WBCCALCULATION
    • WBCCONFIG_ACTION_ORDER
    • WBCMAIN

Position elements are created during the import process by the application in the WBDPOSITION dimension 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 Mandatory 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 jobs.

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.

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.

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.