[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_LEARNING_PATHS |
|---|---|
| Object Type: | TABLE |
| Owner: | OTA |
| FND Design Data: |  OTA.OTA_LEARNING_PATHS
|
| Subobject Name: | |
| Status: | VALID |
This table only stores learning paths created by administrators.
A learning path consists of one or more courses.
A learning path can subscibe to a learner from within the learner interface.
The learner can then enroll in the associated classes for each course.
A learning path can also have assigned competencies that a learner will obtain upon completion of the learning path.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OTA_LEARNING_PATHS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LEARNING_PATH_ID
|
| OTA_LEARNING_PATHS_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUSINESS_GROUP_ID
|
| OTA_LEARNING_PATHS_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
|
| OTA_LEARNING_PATHS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTACT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LEARNING_PATH_ID | NUMBER | (9) | Yes | The system generated surrogatekey for this entry. |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS. |
| DURATION | NUMBER | The Estimated length of the learning path | ||
| DURATION_UNITS | VARCHAR2 | (30) | The duration in unit for the learning path | |
| START_DATE_ACTIVE | DATE | Active Start Date of the Learning Path | ||
| END_DATE_ACTIVE | DATE | Active End Date of the Learning Path | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| PATH_SOURCE_CODE | VARCHAR2 | (30) | Determine the source of the learning path | |
| SOURCE_FUNCTION_CODE | VARCHAR2 | (30) | Determine the source function code for the learning path | |
| ASSIGNMENT_ID | NUMBER | (10) | foreign key to PER_ALL_ASSIGNMENTS_F | |
| SOURCE_ID | NUMBER | (10) | Primary key of the source of the learning path | |
| NOTIFY_DAYS_BEFORE_TARGET | NUMBER | (10) | Indicate number of day to send reminder to learner before the target date | |
| PERSON_ID | NUMBER | (10) | Foreign key to PER_ALL_PEOPLE_F | |
| CONTACT_ID | NUMBER | (10) | Foreign key to HZ_CUST_ACCOUNT_ROLES | |
| DISPLAY_TO_LEARNER_FLAG | VARCHAR2 | (1) | Indicate whether to display the learning path to learner. This column is only used for The integration with Talent Management and Suitability Matching. | |
| PUBLIC_FLAG | VARCHAR2 | (1) | Determine whether the learning path is a public or restricted. | |
| COMPETENCY_UPDATE_LEVEL | VARCHAR2 | (30) | Determine the procedure of updating competencies when learner complete the Learning Path |
Cut, paste (and edit) the following text to query this object:
SELECT LEARNING_PATH_ID
, BUSINESS_GROUP_ID
, DURATION
, DURATION_UNITS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, PATH_SOURCE_CODE
, SOURCE_FUNCTION_CODE
, ASSIGNMENT_ID
, SOURCE_ID
, NOTIFY_DAYS_BEFORE_TARGET
, PERSON_ID
, CONTACT_ID
, DISPLAY_TO_LEARNER_FLAG
, PUBLIC_FLAG
, COMPETENCY_UPDATE_LEVEL
FROM OTA.OTA_LEARNING_PATHS;
OTA.OTA_LEARNING_PATHS does not reference any database object
OTA.OTA_LEARNING_PATHS is referenced by following:
OTA
OTA_LEARNING_PATHS#
|
|
|
|