Table: OTA_ACTIVITY_VERSIONS

Product:	OTA - Learning Management
Description:	A course is the highest level of learning that can be prescribed to a learner.It also contains the objectives and competencies a learner will achieve by completing any class that belongs underneath. It is an object in the catalog, and resid
Implementation/DBA Data:	OTA.OTA_ACTIVITY_VERSIONS

Primary Key: OTA_ACTIVITY_VERSIONS_PK

1. ACTIVITY_VERSION_ID

Primary Key: OTA_ACTIVITY_VERSIONS_UK2

1. ACTIVITY_ID
2. VERSION_NAME

Primary Key: OTA_ACTIVITY_VERSIONS_UK5

1. RCO_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_ACTIVITY_VERSIONS		OTA_ACTIVITY_DEFINITIONS	OTA_ACTIVITY_VERSIONS.ACTIVITY_ID
OTA_ACT_CAT_INCLUSIONS		OTA_ACTIVITY_VERSIONS	OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID
OTA_BOOKING_DEALS		OTA_ACTIVITY_VERSIONS	OTA_BOOKING_DEALS.ACTIVITY_VERSION_ID
OTA_COURSE_PREREQUISITES		OTA_ACTIVITY_VERSIONS	OTA_COURSE_PREREQUISITES.ACTIVITY_VERSION_ID
OTA_COURSE_PREREQUISITES		OTA_ACTIVITY_VERSIONS	OTA_COURSE_PREREQUISITES.PREREQUISITE_COURSE_ID
OTA_EVENTS		OTA_ACTIVITY_VERSIONS	OTA_EVENTS.ACTIVITY_VERSION_ID
OTA_LEARNING_PATH_MEMBERS		OTA_ACTIVITY_VERSIONS	OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID
OTA_NOTRNG_HISTORIES		OTA_ACTIVITY_VERSIONS	OTA_NOTRNG_HISTORIES.ACTIVITY_VERSION_ID
OTA_OFFERINGS		OTA_ACTIVITY_VERSIONS	OTA_OFFERINGS.ACTIVITY_VERSION_ID
OTA_PRICE_LIST_ENTRIES		OTA_ACTIVITY_VERSIONS	OTA_PRICE_LIST_ENTRIES.ACTIVITY_VERSION_ID
OTA_RESOURCE_USAGES		OTA_ACTIVITY_VERSIONS	OTA_RESOURCE_USAGES.ACTIVITY_VERSION_ID
OTA_SKILL_PROVISIONS		OTA_ACTIVITY_VERSIONS	OTA_SKILL_PROVISIONS.ACTIVITY_VERSION_ID
OTA_TRAINING_PLAN_MEMBERS		OTA_ACTIVITY_VERSIONS	OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID
OTA_VENDOR_SUPPLIES		OTA_ACTIVITY_VERSIONS	OTA_VENDOR_SUPPLIES.ACTIVITY_VERSION_ID