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.

[Home] [Help]

VIEW: OTA.OTA_SCORM_OBJ_ATTEMPTS#

Source

View Text - Preformatted


select OBJECTIVE_ATTEMPT_ID OBJECTIVE_ATTEMPT_ID, ATTEMPT_ID ATTEMPT_ID, OBJECTIVE_ID OBJECTIVE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, USER_ID USER_ID, INTERNAL_STATE INTERNAL_STATE, RAW_STATUS RAW_STATUS, RAW_SCORE RAW_SCORE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RAW_IDENTIFIER RAW_IDENTIFIER, USER_TYPE USER_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SUCCESS_STATUS SUCCESS_STATUS, COMPLETION_STATUS COMPLETION_STATUS, SCALED_SCORE SCALED_SCORE, MIN_SCORE MIN_SCORE, MAX_SCORE MAX_SCORE, PROGRESS_MEASURE PROGRESS_MEASURE, DESCRIPTION DESCRIPTION, SCORM_LEARNER_ATTEMPT_ID SCORM_LEARNER_ATTEMPT_ID from "OTA"."OTA_SCORM_OBJ_ATTEMPTS"

View Text - HTML Formatted

SELECT OBJECTIVE_ATTEMPT_ID OBJECTIVE_ATTEMPT_ID
, ATTEMPT_ID ATTEMPT_ID
, OBJECTIVE_ID OBJECTIVE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, USER_ID USER_ID
, INTERNAL_STATE INTERNAL_STATE
, RAW_STATUS RAW_STATUS
, RAW_SCORE RAW_SCORE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RAW_IDENTIFIER RAW_IDENTIFIER
, USER_TYPE USER_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SUCCESS_STATUS SUCCESS_STATUS
, COMPLETION_STATUS COMPLETION_STATUS
, SCALED_SCORE SCALED_SCORE
, MIN_SCORE MIN_SCORE
, MAX_SCORE MAX_SCORE
, PROGRESS_MEASURE PROGRESS_MEASURE
, DESCRIPTION DESCRIPTION
, SCORM_LEARNER_ATTEMPT_ID SCORM_LEARNER_ATTEMPT_ID
FROM "OTA"."OTA_SCORM_OBJ_ATTEMPTS"