Position assignment

The position linked to an employee.

The staging table is WFB_Assignment.

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

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

The Position Assignment business object is related to these business objects:

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

This table describes the Position Assignment business object:

Field Type Mandatory Description
PositionID [nvarchar] (200)

NOT NULL

 Y Unique position ID in the Position business object.

The related table is Position, the field is PositionID.
EmployeeID [nvarchar] (200)

NOT NULL

 Y Unique employee ID in the Employee business object.

The related table is Employee, the field is EmployeeID.
EffectiveStart [datetime]

Not NULL

 Y Effective start date for the assignment.

If the position and employee start day are different, then the position assignment start date must be set to the earlier date. For example, if the position start date is 1st June 2020 and the employee start date is 1st April 2020, then the start date of the position assignment must be 1st April 2020.
EffectiveEnd [datetime]

NULL

 Y Effective end date for the assignment.

The date must be equal to or later than the Effective Start assignment.
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 employee is inheriting, it must be the same as the position 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 an employee is inheriting, it must be the same as the position value.

If employee is not inheriting, can be different than the position value. The salary table on the assignment must have the same pay type as the salary table on the position.
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 an employee is inheriting, must be the same as the position 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 an employee is inheriting, must be the same as the position 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 jobs using salary table.

PayBasis is T.

If an employee is inheriting, must be the same as the position value.
MaximumSalary [float] (53)

NULL

 N Maximum salary paid for job.

Only for PayBasis of annual or monthly. Includes assignments to annual and monthly salary table positions.

If an employee is not inheriting this is optional and can be any value which is greater than 0.

If an employee is inheriting, must be the same as the position value.
PhasingMethod [nvarchar] (252)

NULL

 Y Cost spread over time.

Valid phasing method name in the Phasing Methods business object.

FTE [float] (53)

NULL

 N Full time equivalent (FTE).

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

The default value is 1.
Primary [bit]

NULL

 Y Indicates the primary assigned position for the employee.

These values are valid:

  • 1 indicates a primary assignment.
  • 0 indicates an assignment that is not primary.

One assignment must be primary.

There is no default value.