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_PR_COHORT_INST_RANKS

Object Details

Object Name:	IGSFV_PR_COHORT_INST_RANKS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_PR_COHORT_INST_RANKS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Stores Cohort instance rank details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Id of student
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program Code of the student attempt
AS_OF_RANK_GPA	NUMBER	(22)	Yes	The as of GPA calculated at the time of ranking
COHORT_RANK	NUMBER	(15)	Yes	Rank in the given cohort
COHORT_OVERRIDE_RANK	NUMBER	(15)		Overridden rank in the given cohort
FORMATTED_FINAL_RANK	VARCHAR2	(4000)		The rank in the assigned format and taking override rank into consideration.
COMMENTS	VARCHAR2	(240)		Comments for overriding the cohort rank
PERSON_NUMBER	VARCHAR2	(30)	Yes	The person number of the student
PROGRAM_TITLE	VARCHAR2	(90)	Yes	The title of the program in the students program attempt
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_ID
,      PROGRAM_CODE
,      AS_OF_RANK_GPA
,      COHORT_RANK
,      COHORT_OVERRIDE_RANK
,      FORMATTED_FINAL_RANK
,      COMMENTS
,      PERSON_NUMBER
,      PROGRAM_TITLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PR_COHORT_INST_RANKS;

Dependencies

[top of page]

APPS.IGSFV_PR_COHORT_INST_RANKS references the following:

APPS: FND_MESSAGE - show dependent code; HZ_PARTIES; IGS_EN_STDNT_PS_ATT_ALL; IGS_PR_COHINST_RANK; IGS_PR_COHORT; IGS_PR_COHORT_INST; IGS_PS_VER_ALL
PUBLIC: DUAL

APPS.IGSFV_PR_COHORT_INST_RANKS is not referenced by any database object