[Home] [Help] [Dependency Information]
Object Name: | OTA_SCORM_OBJECTIVES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_SCORM_OBJECTIVES |
Subobject Name: | |
Status: | VALID |
Holds one record for each objective. Objectives are used in both AICC
and SCORM, but they are used differently. In AICC, objectives are
created and associated with learning objects via content import. Every
learner sees all the objectives that have been associated with the
learning object. In SCORM, objectives are created at content runtime
via the SCORM API. Therefore, there is no set list of objectives for
each learning object; they are created for each learner as that learner
progresses through the content.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_SCORM_OBJECTIVES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | OBJECTIVE_ID |
OTA_SCORM_OBJECTIVES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FOLDER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECTIVE_ID | NUMBER | (15) | Yes | The system generated surrogate key for this SCORM Objective. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS |
FOLDER_ID | NUMBER | (15) | Foreign Key to OTA_LO_FOLDERS. | |
NAME | VARCHAR2 | (512) | Yes | Determine the name of the objective. |
IDENTIFIER | VARCHAR2 | (512) | Determine the identifitcation of the objective. | |
DESCRIPTION | VARCHAR2 | (4000) | Determin the Description of the objective. | |
USER_ID | NUMBER | (15) | Determine ID of the learner who created this SCORM objective, or NULL in the case of an AICC objective. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter. |
USER_TYPE | VARCHAR2 | (30) | Determine whether the user is external or internal. 'C' if USER_ID is a PARTY_ID, 'E' if it is a PERSON_ID, and NULL if USER_ID is NULL. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECTIVE_ID
, BUSINESS_GROUP_ID
, FOLDER_ID
, NAME
, IDENTIFIER
, DESCRIPTION
, USER_ID
, OBJECT_VERSION_NUMBER
, USER_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OTA.OTA_SCORM_OBJECTIVES;
OTA.OTA_SCORM_OBJECTIVES does not reference any database object
OTA.OTA_SCORM_OBJECTIVES is referenced by following:
|
|
|