Assignment Level Custom Fields is powerful tool with the ability to execute complex calculations at all levels of the Variable Pay program, instead of just the summary level. It is often referred to by its acronym, ALCF.
Levels of Custom Fields
When using ALCF, it is important to know the levels on which you can create custom fields.
Lower levels can reference data at higher levels.
Higher levels can aggregate data from lower levels.

ALCF Use Case
To demonstrate, let us use a specific use case:
ABC company is using the job levels and PM rating as their guideline criteria, however, they consider job levels of employees for each assignment, and not just the end of year job level. ABC is using Overall Rating sourced from one Performance Management (PM) template.
Here is a list of ABC’s guidelines:
If the employee is at Director level:
PM rating of 5 = 200% payout
PM rating of 4 = 150% payout
PM rating of 3 = 100% payout
If the employee is at Manager level:
PM rating of 5 = 150% payout
PM rating of 4 = 125% payout
PM rating of 3 = 100% payout
If the employee is at Contributor level:
PM rating of 5 = 125% payout
PM rating of 4 = 110% payout
PM rating of 3 = 100% payout
Note
Anyone outside the guideline receives a 25% payout.To Enable ALCF
To enable ALCF, the process must start from the lowest level and then aggregate the calculated values to higher levels.
Business goal level
Pull Rating into business goal level.
Pull Job Level from the history file.
Pull the PM modifier from the lookup table.
Calculate the modified payout amount.
Business section
Aggregate all calculated goal values into an aggregate field.
Assignment level
Aggregate all calculated goal values into an aggregate field.
Entry
Aggregate all calculated goal values into an aggregate field.
Pull Rating into the Business Goal Level
To pull data from entry level, reference the column ID of the field into the new custom field.

Note
Just like creating any other custom field, make sure to indicate the correct column ID when using a formula.Pull Job Level from History File
When using Import Key, specify the source of the field.
Employee history record – use the data-field ID as Import Key.
User data file – use the user data file column header.


Pull Modifier from Lookup Table
ABC’s guidelines were translated into a lookup table with Job Level and Rating as input and Payout Modifier as output. Make sure to reference the correct column ID in the formula.


Calculate Modified Payout Amount
Calculate the required information using the previously created custom fields.
Note
Lookup outputs are always string. Convert it to a number to use in a calculation.
Business Section
Aggregate calculated goal values into the Business Section.

Note
ALCF aggregation is one level up at a time.Assignment Level
Aggregate calculated values from the Business Section to assignment level.

Entry-Level
Aggregate all calculated values from Assignment into Entry-Level.
