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.IGS_PR_ACAD_PROGRAM_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains the details Student Program Attempts, containing statistics information including GPA and Credit Point figures.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
FULL_NAME	VARCHAR2	(450)		Person full name
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Program version number
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Program title
PROGRAM_TYPE	VARCHAR2	(10)	Yes	Program type
PROGRAM_TYPE_DESCRIPTION	VARCHAR2	(60)	Yes	Description for program
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Responsible organization Unit code
RESPONSIBLE_ORG_UNIT_DESC	VARCHAR2	(360)	Yes	Responsible organization Unit code description
PRIMARY_PROGRAM_TYPE	VARCHAR2	(10)		Primary Program Type
START_DT	DATE			Start date
PROGRAM_ATTEMPT_STATUS	VARCHAR2	(30)		Program attempt status
DISCONTINUED_DT	DATE			Discontinued Date
DISCONTINUATION_REASON_CD	VARCHAR2	(10)		Reason for discontinuation
DISCONTINUATION_DESCRIPTION	VARCHAR2	(60)		Description for discontinuation reason
COURSE_RQRMNTS_COMPLETE_DT	DATE			Course completion date
CUMULATIVE_ATTEMPTED_CREDIT	NUMBER			Cumulative attempted credit points
CUMULATIVE_EARNED_CREDIT	NUMBER			Cumulative earned credit points
CUMULATIVE_GRADE_POINTS	NUMBER			Cumulative grade points
CUMULATIVE_GPA	NUMBER			Cumulative Grade point average
AWARD_CD	VARCHAR2	(10)		Award code
AWARD_TITLE	VARCHAR2	(90)		Award Title
CONFERRAL_DT	DATE			Conferral Date
HONOURS_LEVEL	VARCHAR2	(3)		No longer in use
HONOURS_LEVEL_DESCRIPTION	VARCHAR2	(60)		No longer in use

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_NUMBER
,      PERSON_ID
,      FULL_NAME
,      PROGRAM_CD
,      PROGRAM_VERSION_NUMBER
,      PROGRAM_TITLE
,      PROGRAM_TYPE
,      PROGRAM_TYPE_DESCRIPTION
,      RESPONSIBLE_ORG_UNIT_CD
,      RESPONSIBLE_ORG_UNIT_DESC
,      PRIMARY_PROGRAM_TYPE
,      START_DT
,      PROGRAM_ATTEMPT_STATUS
,      DISCONTINUED_DT
,      DISCONTINUATION_REASON_CD
,      DISCONTINUATION_DESCRIPTION
,      COURSE_RQRMNTS_COMPLETE_DT
,      CUMULATIVE_ATTEMPTED_CREDIT
,      CUMULATIVE_EARNED_CREDIT
,      CUMULATIVE_GRADE_POINTS
,      CUMULATIVE_GPA
,      AWARD_CD
,      AWARD_TITLE
,      CONFERRAL_DT
,      HONOURS_LEVEL
,      HONOURS_LEVEL_DESCRIPTION
FROM APPS.IGS_PR_ACAD_PROGRAM_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_PROGRAM_V references the following:

APPS: IGS_CA_TEACH_TO_LOAD_V; IGS_EN_DCNT_REASONCD_ALL; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_GR_GRADUAND; IGS_GR_HONOURS_LEVEL_ALL; IGS_OR_UNIT; IGS_PE_PERSON; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PS_AWD; IGS_PS_TYPE; IGS_PS_VER_ALL

APPS.IGS_PR_ACAD_PROGRAM_V is not referenced by any database object