You can use custom columns to group data for view on worksheets or for reporting purposes.
Write your PL/SQL code to retrieve the values for a custom column and add this code to a custom column hook. This procedure is predefined blank and is called ben_cwb_custom_person_pkg. There are twenty separate functions in this for each corresponding custom column. These are called get_custom_segment1, get_custom_segment2, and so on.
Compile the package on the database. The application executes this logic when you run the Participation Process: Compensation Workbench or the Compensation Workbench Refresh process.
Configure the worksheet through Personalization to rename the column heading appropriately and include the column on any worksheet.
Optionally, configure the Compensation Detail report columns to include the custom column.
Configure the Downloads to have provide valid column heading names.
Configure the correct grouping name for use in the Allocation Wizard Matrix, Summary By Directs Report, and the Stock Option History Report. To do this, access Lookup Type BEN_CWB_MATRIX_ROW_CRITERIA and BEN_CWB_MATRIX_COLUMN_CRITERIA and rename the Custom Column.