[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AS_CHNG_GRD_REQUESTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_AS_CHNG_GRD_REQUESTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Request details for grade changes
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NAME | VARCHAR2 | (360) | Yes | Student name |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Student number |
PROGRAM_CODE | VARCHAR2 | (6) | Yes | Program code |
UNIT_CODE | VARCHAR2 | (10) | Yes | Unit Code |
UNIT_TITLE | VARCHAR2 | (90) | Yes | Unit title |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Section |
UNIT_CLASS_DESCRIPTION | VARCHAR2 | (60) | Yes | Section description |
LOCATION_CODE | VARCHAR2 | (10) | Yes | Location code |
LOCATION_DESCRIPTION | VARCHAR2 | (60) | Yes | Location description |
TEACH_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Teaching calendar type |
TEACH_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Teaching calendar sequence number |
TEACH_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Teaching calendar description | |
REQUEST_DATE | DATE | Yes | Date Of Request | |
LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Load calendar type |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Load calendar sequence number |
LOAD_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Load calendar description | |
CURRENT_MARK | NUMBER | (6) | Current marks of the student | |
CURRENT_GRADING_SCHEMA_CODE | 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 |
CURRENT_FULL_GRADE_NAME | VARCHAR2 | (60) | Yes | Full name of the current grade |
CHANGE_MARK | NUMBER | (6) | Requested Marks to replace current marks | |
CHANGE_GRADING_SCHEMA_CODE | 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 Grade to replace current Grade |
CHANGE_FULL_GRADE_NAME | VARCHAR2 | (60) | Yes | Full name of the change grade |
REQUESTER_COMMENTS | VARCHAR2 | (360) | Yes | Justification for change of grade request |
APPROVER_DATE | DATE | Date of approval | ||
APPROVER_COMMENTS | VARCHAR2 | (360) | Approver Comments | |
CURRENT_STATUS | VARCHAR2 | (15) | Yes | The current status of the request |
REQUESTOR_NAME | VARCHAR2 | (360) | Person name, requesting for change of grade | |
REQUESTOR_NUMBER | VARCHAR2 | (30) | Person number, requesting for change of grade | |
APPROVER_NAME | VARCHAR2 | (360) | Yes | Person name, approving requested change of grade |
APPROVER_NUMBER | VARCHAR2 | (30) | Yes | Person number, approving requested change of grade |
_LA:MARK_CAPPED_FLAG | CHAR | (57) | Indicates whether marks have been capped | |
_LA:SHOW_ON_ACAD_HIST_FLAG | CHAR | (69) | Indicates whether the changed grade be displayed on the Academic History self-service page | |
UNIT_SECTION_ID | NUMBER | (7) | Yes | Unit Section Id |
PERSON_ID | NUMBER | (15) | Yes | Student Id |
REQUESTER_ID | NUMBER | (15) | Yes | Person Id, requesting for change of grade |
APPROVER_ID | NUMBER | (15) | Person Id, approving requested change of grade | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NAME
, PERSON_NUMBER
, PROGRAM_CODE
, UNIT_CODE
, UNIT_TITLE
, UNIT_CLASS
, UNIT_CLASS_DESCRIPTION
, LOCATION_CODE
, LOCATION_DESCRIPTION
, TEACH_CALENDAR_TYPE
, TEACH_CI_SEQUENCE_NUMBER
, TEACH_CALENDAR_DESCRIPTION
, REQUEST_DATE
, LOAD_CALENDAR_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, LOAD_CALENDAR_DESCRIPTION
, CURRENT_MARK
, CURRENT_GRADING_SCHEMA_CODE
, CURRENT_GS_VERSION_NUMBER
, CURRENT_GRADE
, CURRENT_FULL_GRADE_NAME
, CHANGE_MARK
, CHANGE_GRADING_SCHEMA_CODE
, CHANGE_GS_VERSION_NUMBER
, CHANGE_GRADE
, CHANGE_FULL_GRADE_NAME
, REQUESTER_COMMENTS
, APPROVER_DATE
, APPROVER_COMMENTS
, CURRENT_STATUS
, REQUESTOR_NAME
, REQUESTOR_NUMBER
, APPROVER_NAME
, APPROVER_NUMBER
, _LA:MARK_CAPPED_FLAG
, _LA:SHOW_ON_ACAD_HIST_FLAG
, UNIT_SECTION_ID
, PERSON_ID
, REQUESTER_ID
, APPROVER_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_CHNG_GRD_REQUESTS;
APPS.IGSFV_AS_CHNG_GRD_REQUESTS is not referenced by any database object
|
|
|