Assignment Funding Manage Data Requirements
Assignment Funding Data Overview
Assignment funding is similar to Position funding. Allovue assumes that assignment funding is always accurate – meaning that assignment funding, where present, will override the funding that exists on a position. In the absence of assignment funding, the position funding will be assumed for assignments to that position.
Assignment Funding Data Elements
Ellement | Description | Example |
|---|---|---|
Position Code | Unique identifier for a position, often a position control number or position number. | |
Account Code | The full account string for this position’s funding. | |
Employee Code | Unique identifier for an employee, typically the employee number. Should be a displayed value. | |
Percentage | The allocation percentage of this position’s cost to this account code. | |
Start Date | The first date this funding relationship is valid for. | |
End Date | The last date this funding relationship is valid for. |
Assignment Funding Data Validations:
position_code, account_code, employee_code, percentage, and start_date are not null.
position_code, employee_code, account_code, and start_date are unique.
percentage is between 0 and 100.
start_date less than end_date OR end_date is NULL.
position_code matches an existing position.
employee_code matches an existing employee.
account_code matches an existing account.