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

VIEW: OTA.OTA_SCORM_OBJ_ATTEMPTS#

Object Details
Object Name: OTA_SCORM_OBJ_ATTEMPTS#
Object Type: VIEW
Owner: OTA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECTIVE_ATTEMPT_ID NUMBER (15) Yes
ATTEMPT_ID NUMBER (15) Yes
OBJECTIVE_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
USER_ID NUMBER (15) Yes
INTERNAL_STATE VARCHAR2 (30) Yes
RAW_STATUS VARCHAR2 (30)
RAW_SCORE VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
RAW_IDENTIFIER VARCHAR2 (512)
USER_TYPE VARCHAR2 (30) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
SUCCESS_STATUS VARCHAR2 (1)
COMPLETION_STATUS VARCHAR2 (1)
SCALED_SCORE NUMBER

MIN_SCORE NUMBER

MAX_SCORE NUMBER

PROGRESS_MEASURE NUMBER

DESCRIPTION VARCHAR2 (4000)
SCORM_LEARNER_ATTEMPT_ID NUMBER (15)
Query Text

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


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

Dependencies

[top of page]

OTA.OTA_SCORM_OBJ_ATTEMPTS# references the following:

SchemaOTA
TableOTA_SCORM_OBJ_ATTEMPTS
OTA.OTA_SCORM_OBJ_ATTEMPTS# is referenced by following:

SchemaAPPS
SynonymOTA_SCORM_OBJ_ATTEMPTS
TriggerOTA_SCORM_OBJ_ATTEMPTS_WHO