[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUAOA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUAOA_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Describes the most recent outcome of student unit attempt as grade or mark for different grading periods
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
PERSON_ID | NUMBER | (15) | Yes | Person Idenifier. |
COURSE_CD | VARCHAR2 | (6) | Yes | Course Code. |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar Type. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar Instance Sequence Number. |
CI_START_DT | DATE | Yes | Calendar Instance Start Date. | |
CI_END_DT | DATE | Yes | Calendar Instance end Date. | |
OUTCOME_DT | DATE | Yes | Outcome Date. | |
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | Grading Schema Code. |
VERSION_NUMBER | NUMBER | (3) | Yes | Grading Schema Version Number. |
GRADE | VARCHAR2 | (5) | Yes | Grade Recorded. |
S_GRADE_CREATION_METHOD_TYPE | VARCHAR2 | (30) | Yes | Grade Creation Method. |
FINALISED_OUTCOME_IND | VARCHAR2 | (1) | Yes | Finalised Outcome Indicator. |
MARK | NUMBER | (6) | Mark Recorded. | |
NUMBER_TIMES_KEYED | NUMBER | (2) | Number of times keyed. | |
TRANSLATED_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Translated Grading Schema Code. | |
TRANSLATED_VERSION_NUMBER | NUMBER | (3) | Translated version number. | |
TRANSLATED_GRADE | VARCHAR2 | (5) | Translated Grade. | |
TRANSLATED_DT | DATE | Translated Date. | ||
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. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
GRADING_PERIOD_CD | VARCHAR2 | (30) | Yes | Grading Period Code. |
INCOMP_DEADLINE_DATE | DATE | Deadline Date for completing Incomplete Grade. | ||
INCOMP_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading Schema for the Incomplete Grade. | |
INCOMP_VERSION_NUMBER | NUMBER | (3) | Grading Schema Version Number for the Incomplete Grade. | |
INCOMP_DEFAULT_GRADE | VARCHAR2 | (5) | Deafult Grade if Incomplete Grade is not completed. | |
INCOMP_DEFAULT_MARK | NUMBER | (6) | Deafult Mark if Incomplete Grade is not completed. | |
COMMENTS | VARCHAR2 | (240) | Comments. | |
UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
MARK_CAPPED_FLAG | VARCHAR2 | (1) | Allows user to indicate whether marks have been capped for a student unit attempt outcome | |
SHOW_ON_ACADEMIC_HISTRY_FLAG | VARCHAR2 | (1) | Allows user to define whether the changed grade be displayed on the Academic History self-service page. | |
RELEASE_DATE | DATE | Date on which the student unit attempt outcome will be released to the student for viewing | ||
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, OUTCOME_DT
, GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_IND
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, GRADING_PERIOD_CD
, INCOMP_DEADLINE_DATE
, INCOMP_GRADING_SCHEMA_CD
, INCOMP_VERSION_NUMBER
, INCOMP_DEFAULT_GRADE
, INCOMP_DEFAULT_MARK
, COMMENTS
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
, RELEASE_DATE
, MANUAL_OVERRIDE_FLAG
FROM APPS.IGS_AS_SUAOA_V;
|
|
|