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_LOAD_V

Object Details

Object Name:	IGS_PR_ACAD_LOAD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PR_ACAD_LOAD_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 of a Student Program Attempt within a Load Calendar with cumulative and period statistics.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
COURSE_TYPE	VARCHAR2	(10)	Yes	Program type
ACAD_DESCRIPTION	VARCHAR2	(30)		Academic calendar description
ACAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate code for academic calendar
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load calendar type
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for load calendar
LOAD_DESCRIPTION	VARCHAR2	(30)		Description for load calendar
LOAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate code for load calendar
LOAD_START_DT	DATE		Yes	Start date of load calendar
LOAD_END_DT	DATE		Yes	End date of load calendar
TERM_GPA	NUMBER			Grade point average
TERM_GPA_CP	NUMBER			Grade point average credit points
TERM_GPA_QP	NUMBER			Term grade point average
TERM_EARNED_CP	NUMBER			Earned credit points
TERM_ATTEMPTED_CP	NUMBER			Attempted credit points
CUM_GPA	NUMBER			Cumulative Grade point average
CUM_GPA_CP	NUMBER			Cumulative Grade point average credit point
CUM_GPA_QP	NUMBER			Cumulative Grade point average
CUM_EARNED_CP	NUMBER			Cumulative earned credit points
CUM_ATTEMPTED_CP	NUMBER			Cumulative attempted credit points

Query Text

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


SELECT PERSON_NUMBER
,      PERSON_ID
,      COURSE_CD
,      COURSE_TYPE
,      ACAD_DESCRIPTION
,      ACAD_ALTERNATE_CODE
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      LOAD_DESCRIPTION
,      LOAD_ALTERNATE_CODE
,      LOAD_START_DT
,      LOAD_END_DT
,      TERM_GPA
,      TERM_GPA_CP
,      TERM_GPA_QP
,      TERM_EARNED_CP
,      TERM_ATTEMPTED_CP
,      CUM_GPA
,      CUM_GPA_CP
,      CUM_GPA_QP
,      CUM_EARNED_CP
,      CUM_ATTEMPTED_CP
FROM APPS.IGS_PR_ACAD_LOAD_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_LOAD_V references the following:

APPS: HZ_PARTIES; IGS_CA_INST; IGS_CA_INST_REL; IGS_CA_STAT; IGS_CA_TEACH_TO_LOAD_V; IGS_CA_TYPE; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PS_PRG_UNIT_REL; IGS_PS_UNIT_VER; IGS_PS_VER

APPS.IGS_PR_ACAD_LOAD_V is referenced by following:

APPS: IGS_AS_TRNCMT_LGCY_PUB - show dependent code