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


VIEW: APPS.IGSFV_AS_ASSESSMENT_TYPES

Object Details
Object Name: IGSFV_AS_ASSESSMENT_TYPES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_AS_ASSESSMENT_TYPES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Describes a student unit attempt outcome


[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSESSMENT_TYPE VARCHAR2 (10) Yes Displays the name of the assessment type.
ASSESSMENT_TYPE_DESCRIPTION VARCHAR2 (60) Yes Describes the assessment type.
SYSTEM_ASSESSMENT_TYPE VARCHAR2 (10)
Displays the system assessment type to that the institution-defined assessment type is optionally mapped.
SYSTEM_ASSESSMENT_TYPE_DESC VARCHAR2 (60) Yes Describes the system-defined assessment type.
_LA:EXAMINABLE_INDICATOR CHAR (56)
Indicates and specifies that the assessment type is examinable or non-examinable.
_LA:CLOSED_INDICATOR CHAR (52)
Indicates and specifies if the assessment type is open or closed.
_LA:ANONYMOUS_GRADING_IND CHAR (58)
Anonymous Grading Y / N
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT ASSESSMENT_TYPE
,      ASSESSMENT_TYPE_DESCRIPTION
,      SYSTEM_ASSESSMENT_TYPE
,      SYSTEM_ASSESSMENT_TYPE_DESC
,      _LA:EXAMINABLE_INDICATOR
,      _LA:CLOSED_INDICATOR
,      _LA:ANONYMOUS_GRADING_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_ASSESSMENT_TYPES;

Dependencies

[top of page]

APPS.IGSFV_AS_ASSESSMENT_TYPES references the following:

SchemaAPPS
SynonymIGS_AS_ASSESSMNT_TYP
SynonymIGS_AS_SASSESS_TYPE

APPS.IGSFV_AS_ASSESSMENT_TYPES is not referenced by any database object