1. Implementing Compensation
  2. User-Defined Column Lookups

User-Defined Column Lookups

To let managers select from relevant choice lists on task worksheets, you can enable a column and configure the associated user-defined lookup type.

For example, you create a user-defined column called Up For Promotion. Then you configure the related user-defined lookup type with these meanings: Yes and No. Managers can use the user-defined column to indicate if people are up for promotion.

These are the bundled user-defined column lookup types.

  • CMP_CWB_CUST_COL_46_LIST
  • CMP_CWB_CUST_COL_47_LIST
  • CMP_CWB_CUST_COL_48_LIST
  • CMP_CWB_CUST_COL_49_LIST
  • CMP_CWB_CUST_COL_50_LIST

While the bundled lookup code Meaning is DEFAULT, any lookup codes you add need to be only numeric. The meanings can be characters, numbers, or a combination of both. You configure lookups in the Compensation work area using the Lookups task.

Related Topics