VIEW: OTA.OTA_PERFORMANCES#

Source

View Text - Preformatted

select PERFORMANCE_ID PERFORMANCE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, USER_ID USER_ID, LEARNING_OBJECT_ID LEARNING_OBJECT_ID, LESSON_STATUS LESSON_STATUS, SCORE SCORE, TIME TIME, LOCATION LOCATION, COMPLETED_DATE COMPLETED_DATE, SOURCE SOURCE, OVERRIDDEN_BY OVERRIDDEN_BY, OVERRIDDEN_DATE OVERRIDDEN_DATE, ATTEMPT_ID ATTEMPT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, USER_TYPE USER_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CERT_PRD_ENROLLMENT_ID CERT_PRD_ENROLLMENT_ID, AVAILABLE_CHILDREN AVAILABLE_CHILDREN, SUCCESS_STATUS SUCCESS_STATUS, COMPLETION_STATUS COMPLETION_STATUS, SCORM_TIMESTAMP SCORM_TIMESTAMP, SCORM_LEARNER_ATTEMPT_ID SCORM_LEARNER_ATTEMPT_ID from "OTA"."OTA_PERFORMANCES"

View Text - HTML Formatted

SELECT PERFORMANCE_ID PERFORMANCE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, USER_ID USER_ID
, LEARNING_OBJECT_ID LEARNING_OBJECT_ID
, LESSON_STATUS LESSON_STATUS
, SCORE SCORE
, TIME TIME
, LOCATION LOCATION
, COMPLETED_DATE COMPLETED_DATE
, SOURCE SOURCE
, OVERRIDDEN_BY OVERRIDDEN_BY
, OVERRIDDEN_DATE OVERRIDDEN_DATE
, ATTEMPT_ID ATTEMPT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, USER_TYPE USER_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CERT_PRD_ENROLLMENT_ID CERT_PRD_ENROLLMENT_ID
, AVAILABLE_CHILDREN AVAILABLE_CHILDREN
, SUCCESS_STATUS SUCCESS_STATUS
, COMPLETION_STATUS COMPLETION_STATUS
, SCORM_TIMESTAMP SCORM_TIMESTAMP
, SCORM_LEARNER_ATTEMPT_ID SCORM_LEARNER_ATTEMPT_ID
FROM "OTA"."OTA_PERFORMANCES"