[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_UG_ADI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_UG_ADI_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Person Identifier | |
PERSON_NUMBER | VARCHAR2 | (30) | Person Number | |
PERSON_NAME | VARCHAR2 | (363) | Person Name | |
COURSE_CD | VARCHAR2 | (6) | Course Code | |
UNIT_CD | VARCHAR2 | (10) | Unit Code | |
SUA_VERSION_NUMBER | NUMBER | (3) | Student Unit Attempt Version Number | |
CAL_TYPE | VARCHAR2 | (10) | Calendar Type | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Calendar Sequence Number | |
CI_START_DT | DATE | Start Date | ||
CI_END_DT | DATE | End Date | ||
UOO_ID | NUMBER | (7) | Unit Offering Option Identifier | |
OUTCOME_DT | DATE | Outcome Date | ||
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading Schema Code | |
SUAO_VERSION_NUMBER | NUMBER | Student Unit Attempt Outcome Version Number | ||
GRADE | VARCHAR2 | (4000) | Grade | |
S_GRADE_CREATION_METHOD_TYPE | VARCHAR2 | (30) | Grade Creation Method | |
FINALISED_OUTCOME_INDICATOR | VARCHAR2 | (1) | Finalised Outcome Indicator | |
MARK | NUMBER | Mark | ||
NUMBER_TIMES_KEYED | NUMBER | Number Times Keyed | ||
TRANSLATED_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Translated Grading Schema Code | |
TRANSLATED_VERSION_NUMBER | NUMBER | Translated Version Number | ||
TRANSLATED_GRADE | VARCHAR2 | (5) | Translated Grade | |
TRANSLATED_DT | DATE | Translated Date | ||
ORG_ID | NUMBER | (15) | Organisation Identifier | |
INCOMP_DEADLINE_DATE | DATE | Incomplete Deadline Date | ||
INCOMP_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Incomplete Grading Schema Code | |
INCOMP_VERSION_NUMBER | NUMBER | Incomplete Version Number | ||
INCOMP_DEFAULT_MARK | NUMBER | Incomplete Default Mark | ||
INCOMP_DEFAULT_GRADE | VARCHAR2 | (5) | Incomplete Default Grade | |
COMMENTS | VARCHAR2 | (240) | Comments | |
GRADING_PERIOD_CD | VARCHAR2 | (30) | Grading Period Code | |
ANONYMOUS_ID | VARCHAR2 | (4000) | Anonymous ID for the student | |
MANUAL_OVERRIDE_FLAG | VARCHAR2 | (1) | The user should select this checkbox to keep the system from replacing the manually assigned marks with the system calculated ones. | |
MARK_CAPPED_FLAG | VARCHAR2 | (1) | Allows user to indicate whether marks have been capped for a student unit attempt outcome | |
RELEASE_DATE | DATE | Date on which the student unit attempt outcome will be released to the student for viewing | ||
SUBMITTED_DATE | DATE | Date on which the student unit attempt outcome was submitted. | ||
LOCATION_CD | VARCHAR2 | (10) | Location Code | |
UNIT_CLASS | VARCHAR2 | (10) | Unit Class |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, PERSON_NAME
, COURSE_CD
, UNIT_CD
, SUA_VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, UOO_ID
, OUTCOME_DT
, GRADING_SCHEMA_CD
, SUAO_VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_INDICATOR
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, ORG_ID
, INCOMP_DEADLINE_DATE
, INCOMP_GRADING_SCHEMA_CD
, INCOMP_VERSION_NUMBER
, INCOMP_DEFAULT_MARK
, INCOMP_DEFAULT_GRADE
, COMMENTS
, GRADING_PERIOD_CD
, ANONYMOUS_ID
, MANUAL_OVERRIDE_FLAG
, MARK_CAPPED_FLAG
, RELEASE_DATE
, SUBMITTED_DATE
, LOCATION_CD
, UNIT_CLASS
FROM APPS.IGS_AS_UG_ADI_V;
APPS.IGS_AS_UG_ADI_V is not referenced by any database object
|
|
|