[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_ASSITEM_ADI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_ASSITEM_ADI_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Assessment Item WebADI View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_NAME | VARCHAR2 | (363) | Person Name | |
PARTY_NUMBER | VARCHAR2 | (30) | Person Number | |
ANONYMOUS_ID | VARCHAR2 | (4000) | Anonymous Identifier | |
ASSESSMENT_TYPE | VARCHAR2 | (10) | Assessment Type | |
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading Schema Code | |
GS_VERSION_NUMBER | NUMBER | (3) | Version Number | |
OUTCOME_DT | DATE | Outcome Date | ||
MARK | NUMBER | (6) | Mark | |
GRADE | VARCHAR2 | (5) | Grade | |
COMMENTS | VARCHAR2 | (4000) | Outcome Comment | |
EXAM_LOCATION_CD | VARCHAR2 | (10) | Examination Location Code | |
PERSON_ID | NUMBER | (15) | Person Identifier | |
COURSE_CD | VARCHAR2 | (6) | Course COde | |
UNIT_CD | VARCHAR2 | (10) | Unit Code | |
TITLE | VARCHAR2 | (90) | Title | |
CAL_TYPE | VARCHAR2 | (10) | Calendar Type | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Calendar Sequence Number | |
ASSESSMENT_ID | NUMBER | (10) | Assessment Identifier | |
LOCATION_CD | VARCHAR2 | (10) | Location Code | |
UOO_ID | NUMBER | (7) | Unit Offering Option Identifier | |
CHK_ANON_GRADED | VARCHAR2 | (4000) | Checks whether Anonymously Graded or not | |
REFERENCE | VARCHAR2 | (30) | Reference for the unit assessment item. References are typically used to indicate the number of a unit assignment or examination such as assignment 1 or assignment 2. Reference is used to enable easy identification of an assessment item when more than one of the same type exists for a unit. It is also passed to the exam timetabling facility to assist in the identification of each examination when multiple examinations exist for a unit. | |
DUE_DT | DATE | Due date for completion or submission of the unit assessment item. Due dates are typically entered for non-examinable assessment items. Assignment due dates are used in the assignment tracking facility as the default action date for the Received from Student step. | ||
WAIVED_FLAG | VARCHAR2 | (1) | Determines whether or not assessment item is waived. For Ex. Y-Waived, N-Not Waived | |
OVERRIDE_DUE_DT | DATE | A user-defined date which overrides the default due date of the assessment item. | ||
SUBMITTED_DATE | DATE | Date on which the student submitted the assessment item. | ||
PENALTY_APPLIED_FLAG | VARCHAR2 | (1) | Determines whether or not penalty is applied. For Ex. Y-Penalty Applied, N-Penalty Not Applied | |
UNIT_CLASS | VARCHAR2 | (10) | Unit Level |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_NAME
, PARTY_NUMBER
, ANONYMOUS_ID
, ASSESSMENT_TYPE
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, OUTCOME_DT
, MARK
, GRADE
, COMMENTS
, EXAM_LOCATION_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, TITLE
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ASSESSMENT_ID
, LOCATION_CD
, UOO_ID
, CHK_ANON_GRADED
, REFERENCE
, DUE_DT
, WAIVED_FLAG
, OVERRIDE_DUE_DT
, SUBMITTED_DATE
, PENALTY_APPLIED_FLAG
, UNIT_CLASS
FROM APPS.IGS_AS_ASSITEM_ADI_V;
APPS.IGS_AS_ASSITEM_ADI_V is not referenced by any database object
|
|
|