eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OTA.OTA_LEARNING_OBJECTS

Object Details

Object Name:	OTA_LEARNING_OBJECTS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_LEARNING_OBJECTS
Subobject Name:
Status:	VALID

A learning object holds metadata relating to a piece of online content or test, and are created in the Content tree by administrators. Some metadata is displayed to learners to describe the content, such as description, audience, and keywords. Other metadata is used internally by Oracle iLearning, such as the content URL and unique identifiers. Learning objects can also contain other learning objects to establish a content hierarchy.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Unique Key: OTA_LEARNING_OBJECTS_UK1

IDENTIFIER

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_LEARNING_OBJECTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEARNING_OBJECT_ID
OTA_LEARNING_OBJECTS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IDENTIFIER
OTA_LEARNING_OBJECTS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_ID
OTA_LEARNING_OBJECTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_LEARNING_OBJECT_ID
OTA_LEARNING_OBJECTS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTENT_SERVER_ID
OTA_LEARNING_OBJECTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME
OTA_LEARNING_OBJECTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_SOURCE
OTA_LEARNING_OBJECTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_LEARNING_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEARNING_OBJECT_ID	NUMBER	(15)	Yes	The system generated surrogatekey for this entry.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
NAME	VARCHAR2	(240)	Yes	The name associated with this Learning Object.
FOLDER_ID	NUMBER	(15)		Foreign key to OTA_LO_FOLDERS
SOURCE_LEARNING_OBJECT_ID	NUMBER	(15)		Foreign Key to OTA_LEARNING_OBJECTS
PARENT_LEARNING_OBJECT_ID	NUMBER	(15)		Foreign key to OTA_LEARNING_OBJECTS
START_DATE_ACTIVE	DATE			Start Date when the Learning Object become active.
END_DATE_ACTIVE	DATE			Start Date when the Learning Object become inactive.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Version control parameter
DESCRIPTION	VARCHAR2	(4000)		Free text description for this Learning Object.
LANGUAGE_ID	NUMBER	(15)		Foreign Key to FND_LANGUAGES
PUBLISHED_FLAG	VARCHAR2	(1)	Yes	"Y" or "N" based on whether the Learning Object is published
CHILD_SEQ	NUMBER	(15)		Sequence number of the learning object in a hierarchy
TRACKING_TYPE	VARCHAR2	(30)	Yes	Distinguishes between Auto tracking and CMI tracking. 'D' -- Auto tracking, 'C' -- CMI
IDENTIFIER	VARCHAR2	(80)		Unique identifier of the learning object. By default, this is the same as the learning object.
AUTHOR	VARCHAR2	(240)		Author of the learning object
CATALOG	VARCHAR2	(240)		Catalog information for the learning object
CATALOG_NUMBER	VARCHAR2	(240)		Catalog number information for the learning object
KEYWORDS	VARCHAR2	(1000)		Keywords to search for the learning object
OBJECTIVES	VARCHAR2	(4000)		Objectives of learning for the learning object
AUDIENCE	VARCHAR2	(4000)		The intended audience of the learning object
DURATION	VARCHAR2	(240)		Duration of the Learning Object
VERSION	VARCHAR2	(16)		Version number of the Learning Object
COPYRIGHTED_FLAG	VARCHAR2	(1)		'Y' for Yes and 'N' for No
COPYRIGHT_TEXT	VARCHAR2	(2000)		Text for the copyright
SECURED_FLAG	VARCHAR2	(1)	Yes	'Y' for Yes and 'N' for No
STARTING_URL	VARCHAR2	(2000)		Starting URL of the Learning object
MASTERY_SCORE	NUMBER	(3)		Mastery score or passing score for the learning object
MIME_TYPE	VARCHAR2	(240)		MIME type information for the learning object
REQUIRED_HARDWARE_SOFTWARE	VARCHAR2	(2000)		Any hardware or software requirements to launch and play the content
TEST_ID	NUMBER	(15)		Foreign key to OTA_TESTS
LAUNCH_DATA	VARCHAR2	(4000)		Determine the location of the Learning Object.
EXTERNAL_IDENTIFIER	VARCHAR2	(1000)		Identifier of the data based on Learning Object import.
EXTERNAL_SOURCE	VARCHAR2	(255)		Source of the Learning Object import
DATA_SOURCE	VARCHAR2	(30)		The module that Learning Object originated in
CONTENT_SERVER_ID	NUMBER	(15)		Foreign key to OTA_CONTENT_SERVERS
CONTENT_DIRECTORY	VARCHAR2	(240)		Directory that will be created inside the physical directory of the content server. INITIAL_FILE will reside inside this directory
INITIAL_FILE	VARCHAR2	(2000)		Name of the file that will be shown when the learning object is played. The file should be inside CONTENT_DIRECTORY
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.
MEETING_ID	VARCHAR2	(240)		Meeting id of the conference
CONFERENCE_SERVER_ID	NUMBER	(15)		Foreign key to OTA_CONFERENCE_SERVERS_B
PLAYER_TIMEOUT_MINUTES	NUMBER	(15)		Determine the number of minutes from the launch of an Learning Object that the player will keep the session alive
LAUNCH_DATA2	VARCHAR2	(4000)		Determine the location of the Learning Object.
LAUNCH_OUTSIDE_PLAYER	VARCHAR2	(1)		The value 'Y' implies content will be launched in a new window, this is when the content cannot be launched within player frame
LANGUAGE_CODE	VARCHAR2	(30)		Stores language code to support natural languages

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEARNING_OBJECT_ID
,      BUSINESS_GROUP_ID
,      NAME
,      FOLDER_ID
,      SOURCE_LEARNING_OBJECT_ID
,      PARENT_LEARNING_OBJECT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OBJECT_VERSION_NUMBER
,      DESCRIPTION
,      LANGUAGE_ID
,      PUBLISHED_FLAG
,      CHILD_SEQ
,      TRACKING_TYPE
,      IDENTIFIER
,      AUTHOR
,      CATALOG
,      CATALOG_NUMBER
,      KEYWORDS
,      OBJECTIVES
,      AUDIENCE
,      DURATION
,      VERSION
,      COPYRIGHTED_FLAG
,      COPYRIGHT_TEXT
,      SECURED_FLAG
,      STARTING_URL
,      MASTERY_SCORE
,      MIME_TYPE
,      REQUIRED_HARDWARE_SOFTWARE
,      TEST_ID
,      LAUNCH_DATA
,      EXTERNAL_IDENTIFIER
,      EXTERNAL_SOURCE
,      DATA_SOURCE
,      CONTENT_SERVER_ID
,      CONTENT_DIRECTORY
,      INITIAL_FILE
,      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
,      MEETING_ID
,      CONFERENCE_SERVER_ID
,      PLAYER_TIMEOUT_MINUTES
,      LAUNCH_DATA2
,      LAUNCH_OUTSIDE_PLAYER
,      LANGUAGE_CODE
FROM OTA.OTA_LEARNING_OBJECTS;

Dependencies

[top of page]

OTA.OTA_LEARNING_OBJECTS does not reference any database object

OTA.OTA_LEARNING_OBJECTS is referenced by following:

APPS: OTA_LEARNING_OBJECTS; OTA_LEARNING_OBJECTS_WHO