FND Design Data [Home] [Help]

Table: OTA_TRAINING_PLAN_COSTS

Product: OTA - Learning Management
Description: A plan cost is a recorded measure against the training plan.
Implementation/DBA Data: TableOTA.OTA_TRAINING_PLAN_COSTS
Primary Key: OTA_TRAINING_PLAN_COSTS_PK
  1. ColumnTRAINING_PLAN_COST_ID
Primary Key: OTA_TRAINING_PLAN_COSTS_UK2
  1. ColumnBOOKING_ID
  2. ColumnTRAINING_PLAN_ID
  3. ColumnTP_MEASUREMENT_TYPE_ID
  4. ColumnEVENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_TRAINING_PLAN_COSTS FK Joins to TableOTA_TP_MEASUREMENT_TYPES OTA_TRAINING_PLAN_COSTS.TP_MEASUREMENT_TYPE_ID
OTA_TRAINING_PLAN_COSTS FK Joins to TableOTA_TRAINING_PLANS OTA_TRAINING_PLAN_COSTS.TRAINING_PLAN_ID
OTA_TRAINING_PLAN_COSTS FK Joins to TableOTA_DELEGATE_BOOKINGS OTA_TRAINING_PLAN_COSTS.BOOKING_ID
OTA_TRAINING_PLAN_COSTS FK Joins to TableOTA_EVENTS OTA_TRAINING_PLAN_COSTS.EVENT_ID