When setting up costing information you can use item types set up in the Generic Summary Process window to generate cost values dynamically. For example, you could set up an item type that enables you to retrieve the actual salary cost of a delegate on a certain date by querying the Backfeed or payroll tables. These calculations are similar to those used by the Bilan Social.

   To set up a dynamic cost calculation:

1. Create a name for the item type you are about to create in the GSP_ITEM_TYPE Lookup type.

2. Create a name for the restriction type you are about to create in the GSP_RESTRICTION_TYPE Lookup type.

   Create the restriction and item type in the Setup window. The item type can use a number of parameters. These variables that may be embedded in an item type's Where Clause that will be substituted based on the values entered into the system. The following parameters are currently supported:

   • P_BUSINESS_GROUP_ID

     Replaced with the value of the BUSINESS_GROUP_ID

   • P_TRAINING_PLAN_ID

     Replaced with the value of the TRAINING_PLAN_ID

   • P_ORGANIZATION_ID

     Replaced with the value of the ORGANIZATION_ID of the organization linked to the training plan.

   • P_ PERIOD_START_DATE

     Replaced with the start date of the training plan.

   • P_ PERIOD_END_DATE

     Replaced with the end date of the training plan.

   • P_PLAN_STATUS

     Replaced with the status of the training plan.

   • P_MEASUREMENT_TYPE_ID

     Replaced with the value of the MEASUREMENT_ID for the measure in the highlighted cost line.

   • P_COST_LEVEL

     Replaced with the value of the cost level for the measure in the highlighted cost line.

   • P_EVENT_ID

     Replaced with the value of the EVENT_ID for the highlighted cost line if you are costing at event (class) or student level.

   • P_DELEGATE_BOOKING_ID

     Replaced with the value of the DELEGATE_BOOKING_ID for the highlighted cost line if you are costing at student level.

   • P_TO_CURRENCY

     Replaced with the currency of the training plan. This is the currency into which all other monetary values will be converted.

   • P_PAYROLL_ID

     Replaced with the payroll defined in the HR:Default Payroll for Currency Conversions profile option.

3. . Create a new template in the Generic Summary Process window and include the item type you have set up. Set the required restriction criteria.

   The item type can now be referenced in the Training Plan Measurement Types window.

   For more information on completing these steps see: Creating the Bilan Social Template