[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_CHN_GRD_REQ |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_CHN_GRD_REQ |
Subobject Name: | |
Status: | VALID |
Stores the Change Grade Requests History of a student .
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_CHN_GRD_REQ_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD UOO_ID REQUEST_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Student Id |
COURSE_CD | VARCHAR2 | (6) | Yes | Course Code |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Section |
LOCATION_CD | VARCHAR2 | (10) | Yes | Location Of Section |
LOAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Load Calender Type |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | LoadCalendar Sequence Number |
TEACH_CAL_TYPE | VARCHAR2 | (10) | Yes | Teaching Calendar Type |
TEACH_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Teaching Calendar Sequence Number |
REQUEST_DATE | DATE | Yes | Date Of Request | |
REQUESTER_ID | NUMBER | (15) | Yes | Person Id, requesting for change of grade |
CURRENT_MARK | NUMBER | (6) | Current Marks of the Student | |
CURRENT_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | Grading Schema Code |
CURRENT_GS_VERSION_NUMBER | NUMBER | (6) | Yes | Grading Schema Version Number |
CURRENT_GRADE | VARCHAR2 | (5) | Yes | Current Grades of the Student |
CHANGE_MARK | NUMBER | (6) | Requested Marks to replace current marks | |
CHANGE_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | Change Grading Schema Code |
CHANGE_GS_VERSION_NUMBER | NUMBER | (6) | Yes | Change Grading Schema Version Number |
CHANGE_GRADE | VARCHAR2 | (5) | Yes | Requested Grades to replace current Grades |
REQUESTER_COMMENTS | VARCHAR2 | (360) | Yes | Justification for change of grade request |
APPROVER_ID | NUMBER | (15) | Person Id, approving requested change of grade | |
APPROVER_DATE | DATE | Date of approval | ||
APPROVER_COMMENTS | VARCHAR2 | (360) | Approver Comments | |
CURRENT_STATUS | VARCHAR2 | (15) | Yes | The status are 'IN PROGRESS''REJECTED''APPROVED' |
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 | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, UNIT_CD
, UNIT_CLASS
, LOCATION_CD
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
, REQUEST_DATE
, REQUESTER_ID
, CURRENT_MARK
, CURRENT_GRADING_SCHEMA_CD
, CURRENT_GS_VERSION_NUMBER
, CURRENT_GRADE
, CHANGE_MARK
, CHANGE_GRADING_SCHEMA_CD
, CHANGE_GS_VERSION_NUMBER
, CHANGE_GRADE
, REQUESTER_COMMENTS
, APPROVER_ID
, APPROVER_DATE
, APPROVER_COMMENTS
, CURRENT_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
FROM IGS.IGS_AS_CHN_GRD_REQ;
IGS.IGS_AS_CHN_GRD_REQ does not reference any database object
IGS.IGS_AS_CHN_GRD_REQ is referenced by following:
|
|
|