Incentive Compensation Descriptive Flexfields

You can define descriptive flexfields to store additional information not available in the standard fields in a table. The fields use attributes and attribute numbers. This topic provides a list of the available flexfields for Incentive Compensation.

Flexfield Name

Table

Use

Hints

Business Unit Context Sensitive

Base Transaction

CN_TP_BASETRANS_DFF

Base transaction table

CN_TP_TRANSACTIONS_ALL

Calculation or reporting

Usually this is done at the start of an implementation with some additions later when necessary.

Yes if needed

Participants

CN_PARTICIPANTS_DFF

Participant header table

CN_SRP_PARTICIPANTS_ALL

Storing more information about a participant

Generally to hold data which isn't date effective.

No

Participant Detail

CN_PARTICIPANT_DETAIL_DFF

Participant detail table

CN_SRP_PARTICIPANT_DETAILS_ALL

Storing more participant detail information

Generally to hold data which is date effective.

No

Incentive Compensation Plan

CN_COMP_PLANS_DFF

Compensation plan table

CN_COMP_PLANS_ALL_B

Storing more information about a compensation plan

Example: You want to use an attribute to group a bunch of compensation plans together or you want to identify the compensation plan by a tag for reporting irrespective of what the name or description is.

No

Incentive Compensation Plan Component

CN_PLAN_COMPONENTS_DFF

Plan component table

CN_PLAN_COMPONENTS_ALL_B

Storing more information about a plan component

Example: You want to use an attribute to group a bunch of plan components together or you want to identify the plan component by a tag for reporting irrespective of what the name or description is.

No

Incentive Compensation Performance Measure

CN_MEASURES_DFF

Performance measure table

CN_FORMULAS_ALL_B

Storing more information about a performance measure

Example: You want to use an attribute to group a bunch of performance measures together or you want to identify the performance measure by a tag for reporting irrespective of what the name or description is.

No

Participant Plan

CN_SRP_COMP_PLANS_ALL_DFF

Compensation plan assigned to the participant table

CN_SRP_COMP_PLANS_ALL

Storing more data specific to the participant-plan assignment record level

Only the attribute fields (not attribute number fields) can be used in a calculation expression. Also, these DFF segments aren't available for BI.

No