Enable Attributes to Pass as Input Parameters for Predefined Functions

Enable a column to be the attribute the input parameter passes to the predefined function. Use the Configure Tables and Columns task in the Setup and Maintenance to enable the columns for calculation.

Here are the predefined functions:

• Credit Category Name

• Date Difference

• Prorated Plan Component Participation and YTD Target Incentive

• Prorated Measure Participation, Previous Interval Attainment, and Rolling Average Attainment

Each function section contains:

• The columns that you must enable for each function

• A suggested user name for each column as these columns don't have standard user names

Each column that you enable for calculation must have a corresponding user name, because the user name appears in the expression builder choice lists. You use the choice lists to select the attribute that each input parameter passes to the function. On the Tables and Columns toolbar View menus, select Query By Example to more quickly isolate the relevant table or columns.

Additional Information:

• For descriptions and use case examples of each predefined function, see the Incentive Compensation Predefined Functions topic.

• For details about creating predefined expressions with these attributes, see the Create Incentive Expressions with Predefined Functions topic.

Enable the Credit Category Name Attribute

Select the CN_TP_CREDITS_ALL table to enable this column and enter the suggested user name, if one isn't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
ELIGIBLE_CAT_ID	Credit category ID

Enable Date Difference Attributes

Select the CN_TP_CREDITS_ALL table to enable these columns and enter the suggested user names, if they aren't already present.

Tip: Enable for calculation only the date columns that you want users to select.

Column to Enable for Calculation	Suggested User or Attribute Name
CREDIT_DATE	Credit date
ROLLUP_DATE	Rollup date

Enable Prorated Plan Component Participation and YTD Target Incentive Attributes

These two predefined functions use the same attributes.

Select the CN_SRP_PER_FORM_METRICS_ALL table to enable these columns and enter the suggested user names, if they aren't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
SRP_COMP_PLAN_ID	Participant plan ID
PLAN_COMPONENT_ID	Plan component ID
PERIOD_ID	Period ID

Enable Prorated Measure Participation, Previous Interval Attainment, and Rolling Average Attainment Attributes

These three predefined functions use the same attributes.

Select the CN_SRP_PER_FORM_METRICS_ALL table to enable these columns and enter the suggested user names, if they aren't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
SRP_COMP_PLAN_ID	Participant plan ID
PLAN_COMPONENT_ID	Plan component ID
PERIOD_ID	Period ID
FORMULA_ID	Measure ID

Enable the Product Name Attribute

Select the CN_TP_TRANSACTIONS_ALL table to enable this column and enter the suggested user name, if one isn't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
INVENTORY_ITEM_ID	Product ID

Enable Accumulate by Any Interval Attributes

Select the CN_SRP_PER_FORM_METRICS_ALL table to enable these columns and enter the suggested user names if they aren't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
SRP_COMP_PLAN_ID	Participant plan ID
PLAN_COMPONENT_ID	Plan component ID
PERIOD_ID	Period ID
FORMULA_ID	Formula ID

Enable Rank Participant Metrics Attributes

Select the CN_SRP_PER_FORM_METRICS_ALL table to enable these columns and enter the suggested user names if they aren't already present.

Column to Enable for Calculation	Suggested User or Attribute Name
SRP_COMP_PLAN_ID	Participant plan ID
PLAN_COMPONENT_ID	Plan component ID
PERIOD_ID	Period ID
FORMULA_ID	Formula ID
PARTICIPANT_ID	Participant ID