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_EN_SS_STUD_CONTEXT_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

Stores the student program attempt context information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Student Identifier
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code in which the student is enrolled
VERSION_NUMBER	NUMBER	(3)	Yes	Program version in which the student is enrolled
PROGRAM_TYPE	VARCHAR2	(10)	Yes	Program type of the program code
ATTENDANCE_TYPE	VARCHAR2	(4000)		Attendance type of the program offering
ATTENDANCE_TYPE_DESC	VARCHAR2	(4000)		Attendance type description
ATTENDANCE_MODE	VARCHAR2	(4000)		Attendance mode of the program offering
ATTENDANCE_MODE_DESC	VARCHAR2	(4000)		Attendance mode description
LOCATION_CD	VARCHAR2	(4000)		Location code of the program offering
LOCATION_CD_DESC	VARCHAR2	(4000)		Location code description
TERM_CAL_TYPE	VARCHAR2	(10)	Yes	Load calendar type
TERM_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Load calendar sequence number
TERM_DESCRIPTION	VARCHAR2	(30)		Load calendar instance description
TERM_START_DT	DATE		Yes	Load calendar start date
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	Academic calendar type
ACAD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Academic calendar sequence number
ACADEMIC_DESCRIPTION	VARCHAR2	(30)		Academic calendar instance description
APPLIED_MIN_CP	NUMBER			Minimum credit points setup applicable in the given term
APPLIED_MAX_CP	NUMBER			Maximum credit points setup applicable in the given term
INST_ATTENDANCE	VARCHAR2	(4000)		Institutional attendance type for the given student and term
INST_CP	VARCHAR2	(4000)		Institutional credit points for the given student and term
PRIMARY_PRG_TITLE	VARCHAR2	(4000)		Program or primary program title
SECONDARY_PRG_TITLE	VARCHAR2	(4000)		Concatenated titles of all the secondary programs in the given career
YEAR_OF_PROGRAM	VARCHAR2	(4000)		Current unit set for the given student program attempt
PRIMARY_PROGRAM_TYP	VARCHAR2	(4000)		Primary program type for the given program attempt
PROGRAM_CP	VARCHAR2	(4000)		Credit points for the context student program attempt in a given term

Query Text

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


SELECT PERSON_ID
,      PROGRAM_CD
,      VERSION_NUMBER
,      PROGRAM_TYPE
,      ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESC
,      ATTENDANCE_MODE
,      ATTENDANCE_MODE_DESC
,      LOCATION_CD
,      LOCATION_CD_DESC
,      TERM_CAL_TYPE
,      TERM_SEQUENCE_NUMBER
,      TERM_DESCRIPTION
,      TERM_START_DT
,      ACAD_CAL_TYPE
,      ACAD_SEQUENCE_NUMBER
,      ACADEMIC_DESCRIPTION
,      APPLIED_MIN_CP
,      APPLIED_MAX_CP
,      INST_ATTENDANCE
,      INST_CP
,      PRIMARY_PRG_TITLE
,      SECONDARY_PRG_TITLE
,      YEAR_OF_PROGRAM
,      PRIMARY_PROGRAM_TYP
,      PROGRAM_CP
FROM APPS.IGS_EN_SS_STUD_CONTEXT_V;

Dependencies

[top of page]

APPS.IGS_EN_SS_STUD_CONTEXT_V references the following:

APPS: IGS_CA_INST; IGS_CA_INST_REL; IGS_CA_TYPE; IGS_EN_ELGBL_PROGRAM - show dependent code; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_SPA_TERMS_API - show dependent code; IGS_EN_STDNT_PS_ATT; IGS_PS_VER; IGS_SS_ENR_DETAILS - show dependent code

APPS.IGS_EN_SS_STUD_CONTEXT_V is not referenced by any database object