Position assignment

The position linked to an employee.

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

Position assignment property Annual and monthly job Hourly job Table base annual and monthly job Table base hourly job
PositionID* x x x x
EmployeeID* x x x x
Effective Start* (if empty, defaults from position or employee date) x x x x
Effective End* (if empty, defaults from position or employee date) x x x x
Salary* x x
Salary x x
Salary Table* x x
Salary Table Grade x x
Salary Table Step x x
Base Salary Account* (defaults from job) x x x x
Progression Rule x x
Maximum Salary x x
Base Salary Account* (defaults from job) x x x x
Phasing Method* (defaults from job) x x x x
FTE (if empty, defaults to 1) x x x x
Primary x x x x

*Required property

The table is WFB_Assignment.

The Position Assignment 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)

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 Required 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 that are specified in the Job table:

  • S
  • M
  • H

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

Salary [float] (53)

NULL

N Salary amount.

Optional for position assignments that do not use the salary table. PayBasis is one of these values that are specified in the Job table:

  • 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 which 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 the position assignment.

Only for PayBasis of annual or monthly. Includes annual and monthly salary table based position assignments.

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.

WorkingHours [float] (53)

NULL

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

Working hours are used only by hourly position 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.