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_STU_ACAD_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Id to identify the student
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of the student
COURSE_CD	VARCHAR2	(6)	Yes	Program Code of the program attempt of the student
COURSE_TYPE	VARCHAR2	(10)	Yes	Program type of the program attempt of the student
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	Academic Calendar Type
ACAD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Instance of the Academic Calendar
ACAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code of the Academic Calendar
ACAD_DESCRIPTION	VARCHAR2	(30)		Description of the Academic Calendar
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load Calendar Type
LOAD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Instance of the Load Calendar
LOAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code of the Load Calendar
LOAD_DESCRIPTION	VARCHAR2	(30)		Description of the Load Calendar
LOAD_START_DT	DATE		Yes	Start Date of the Load Calendar
LOAD_END_DT	DATE		Yes	End Date of the Load Calendar
STAT_TYPE	VARCHAR2	(50)	Yes	Statistic Type
STAT_TYPE_DESC	VARCHAR2	(90)	Yes	Description of the Statistic Type
TERM_GPA	NUMBER			GPA for the given term
TERM_GPA_CP	NUMBER			GPA Credit Point for the given term
TERM_GPA_QP	NUMBER			GPA Quality Point for the given term
TERM_EARNED_CP	NUMBER			Earned Credit Point for the given term
TERM_ATTEMPTED_CP	NUMBER			Attempted Point for the given term
CUM_GPA	NUMBER			Cumulative GPA
CUM_GPA_CP	NUMBER			Cumulative GPA Credit Point
CUM_GPA_QP	NUMBER			Cumulative GPA Quality Point
CUM_EARNED_CP	NUMBER			Cumulative Earned Credit Point
CUM_ATTEMPTED_CP	NUMBER			Cumulative Attempted Credit Point
CLASS_STANDING	VARCHAR2	(4000)		Class Standing
PREDICTIVE_CLASS_STANDING	VARCHAR2	(4000)		Predictive Class Standing
ATTENDANCE_TYPE	VARCHAR2	(4000)		Attendance Type
ENRL_ANTCP_COMPL_DT	DATE			Estimated Completion Date

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      COURSE_TYPE
,      ACAD_CAL_TYPE
,      ACAD_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      ACAD_DESCRIPTION
,      LOAD_CAL_TYPE
,      LOAD_SEQUENCE_NUMBER
,      LOAD_ALTERNATE_CODE
,      LOAD_DESCRIPTION
,      LOAD_START_DT
,      LOAD_END_DT
,      STAT_TYPE
,      STAT_TYPE_DESC
,      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
,      CLASS_STANDING
,      PREDICTIVE_CLASS_STANDING
,      ATTENDANCE_TYPE
,      ENRL_ANTCP_COMPL_DT
FROM APPS.IGS_PR_STU_ACAD_V;

Dependencies

[top of page]

APPS.IGS_PR_STU_ACAD_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_PRC_LOAD - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PR_GEN_006 - show dependent code; IGS_PR_GET_CLASS_STD - show dependent code; IGS_PR_INST_STAT; IGS_PR_ORG_STAT; IGS_PR_STAT_TYPE; IGS_PS_VER

APPS.IGS_PR_STU_ACAD_V is not referenced by any database object