eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_AS_CHNG_GRD_REQUESTS

Object Details

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

View Type

A Business Intelligence System view

Request details for grade changes

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.IGSFV_AS_CHNG_GRD_REQUESTS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION; IGS_AS_CHN_GRD_REQ; IGS_AS_GRD_SCH_GRADE; IGS_AS_UNIT_CLASS_ALL; IGS_CA_INST_ALL; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL

APPS.IGSFV_AS_CHNG_GRD_REQUESTS is not referenced by any database object