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_ATTEMPTS

Object Details

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

This table is only used for online learning against learning objects and tests.
It contains status, score, time, and other system information that describes what a learner achieved when playing a particular learning object or test.
There is one row created for each leraning object/test a learner plays from within the Oracle iLearning player.
The last attempt is sometimes used to calculate the most recent status for the performance record.
It is also used to determine when a learner can take a test (after their last failed attempt) when an administrator has defined maximum number of attempts against a test.
An internal_state of 'A' indicates not all information was written to the attempt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_ATTEMPTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTEMPT_ID
SYS_IL0000329902C00048$$	LOB	UNIQUE	APPS_TS_TX_DATA
OTA_ATTEMPTS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
OTA_ATTEMPTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEARNING_OBJECT_ID
OTA_ATTEMPTS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
OTA_ATTEMPTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEARNING_OBJECT_ID TEST_ID USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTEMPT_ID	NUMBER	(15)	Yes	System generated surrogate key for each distinct module version.
USER_ID	NUMBER	(15)	Yes	User who took the attempt. Can be internal or external user.
LEARNING_OBJECT_ID	NUMBER	(15)	Yes	Foreign key to OTA_LEARNING_OBJECTS.
TARGET_LEARNING_OBJECT_ID	VARCHAR2	(240)	Yes	Foreign key to OTA_LEARNING_OBJECTS.
EVENT_ID	NUMBER	(9)		Foreign key to OTA_EVENTS.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	foreign key to HR_ALL_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Version control parameter.
TIMESTAMP	DATE		Yes	Date when attempt is last executed.
PERFORMANCE_SOURCE	VARCHAR2	(30)	Yes	Source for performance.
ATTEMPT_STATUS	VARCHAR2	(30)	Yes	Status of the attempt.
PREVIOUS_STATUS	VARCHAR2	(30)	Yes	Determine the value of attempt status based on last attempt.
RAW_STATUS	VARCHAR2	(30)	Yes	Status for the attempt before determining the actual attempt status.
SCORE	NUMBER		Yes	Score for the attempt.
PREVIOUS_SCORE	NUMBER		Yes	Determine the value of score based on last attempt.
RAW_SCORE	NUMBER		Yes	Score for the attempt before determining the actual attempt score.
TIME	NUMBER		Yes	Time spent in the attempt.
ATTEMPT_ORDER	NUMBER		Yes	Sequence of when attempt is taken.
ATTEMPT_TYPE	VARCHAR2	(240)		Type of Attempt.
TEST_ID	NUMBER	(15)		Foreign Key to OTA_TESTS.
REVIEW_FLAG	VARCHAR2	(1)	Yes	Whether test detail can be reviewed.
INTERNAL_STATE	VARCHAR2	(30)		Whether the attempt is valid or not.
FINISHED_DATE	DATE			Date when the attempt is done.
INITIALIZED_FLAG	VARCHAR2	(1)	Yes	Determine whether the attempt is initialized for CMI and HACP call.
AUTO_COMMIT_FLAG	VARCHAR2	(1)	Yes	Determine auto commit for the attempt for CMI call.
LOCATION	VARCHAR2	(1000)		Location used for HACP course
EXIT_FLAG	VARCHAR2	(1)		Determine exit for the attempt for CMI and HACP call.
SUSPEND_DATA	VARCHAR2	(4000)		Determine any suspended data for the attempt for CMI and HACP call.
GRADE_FLAG	VARCHAR2	(1)		Determine Grade type as existed at the time the attempt is created.
MASTERY_SCORE	NUMBER			The assigned passing score for a test.
TIME_EXTENDED	NUMBER	(10)		The amount of time the test attempt was attended.
USER_TYPE	VARCHAR2	(30)	Yes	Type of user, external or internal.
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.
CERT_PRD_ENROLLMENT_ID	NUMBER	(15)		Foreign key to OTA_CERT_PRD_ENROLLMENTS.
LAUNCH_TYPE	VARCHAR2	(30)		Type of Launch.
SUSPEND_DATA2	VARCHAR2	(4000)		Determine any suspended data for the attempt for CMI and HACP call.
ACT_EVAL_ID	NUMBER	(15)		This stores the Evaluation ID. This is foriegn key to OTA_Evaluations table.
SUCCESS_STATUS	VARCHAR2	(1)
COMPLETION_STATUS	VARCHAR2	(1)
SCALED_SCORE	NUMBER
MIN_SCORE	NUMBER
MAX_SCORE	NUMBER
PROGRESS_MEASURE	NUMBER
SCORM_LEARNER_ATTEMPT_ID	NUMBER	(15)
SCORM_SUSPEND_DATA	CLOB	(4000)

Query Text

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


SELECT ATTEMPT_ID
,      USER_ID
,      LEARNING_OBJECT_ID
,      TARGET_LEARNING_OBJECT_ID
,      EVENT_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      TIMESTAMP
,      PERFORMANCE_SOURCE
,      ATTEMPT_STATUS
,      PREVIOUS_STATUS
,      RAW_STATUS
,      SCORE
,      PREVIOUS_SCORE
,      RAW_SCORE
,      TIME
,      ATTEMPT_ORDER
,      ATTEMPT_TYPE
,      TEST_ID
,      REVIEW_FLAG
,      INTERNAL_STATE
,      FINISHED_DATE
,      INITIALIZED_FLAG
,      AUTO_COMMIT_FLAG
,      LOCATION
,      EXIT_FLAG
,      SUSPEND_DATA
,      GRADE_FLAG
,      MASTERY_SCORE
,      TIME_EXTENDED
,      USER_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CERT_PRD_ENROLLMENT_ID
,      LAUNCH_TYPE
,      SUSPEND_DATA2
,      ACT_EVAL_ID
,      SUCCESS_STATUS
,      COMPLETION_STATUS
,      SCALED_SCORE
,      MIN_SCORE
,      MAX_SCORE
,      PROGRESS_MEASURE
,      SCORM_LEARNER_ATTEMPT_ID
,      SCORM_SUSPEND_DATA
FROM OTA.OTA_ATTEMPTS;

Dependencies

[top of page]

OTA.OTA_ATTEMPTS does not reference any database object

OTA.OTA_ATTEMPTS is referenced by following:

OTA: OTA_ATTEMPTS#