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

Object Details

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

View Type

A Business Intelligence System view

This view lists program attempt attributes based on Term Calendar.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TERM_RECORD_ID	NUMBER		Yes	System generated number to uniquely identify the Term Record
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Student Unique Identifier and foreign key to HZ_PARTIES. This is a sequence generated value
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program Code of the Student Program Attempt for which this Term Record applies to
PROGRAM_VERSION	NUMBER	(3)	Yes	Program Version
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Academic Calendar Type of the Student Program Attempt for this Term
TERM_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Term Calendar Type for which Student Program Attempt changes are being captured
TERM_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance for which Student Program Attempt changes are being captured
KEY_PROGRAM_FLAG	VARCHAR2	(1)	Yes	Indicates whether the Student Program Attempt is the Key Program for this Term. Can have values Y/N
_LA:KEY_PROGRAM_FLAG_DESC	CHAR	(53)		Key Program Description. Has values Yes/No
LOCATION_CODE	VARCHAR2	(10)	Yes	Location Code of the Student Program Attempt for this Term
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Nominated Attendance Mode of the Student Program Attempt for this Term
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Nominated Attendance Type of the Student Program Attempt for this Term
FEE_CATEGORY	VARCHAR2	(10)		Fee Category of the Student Program Attempt for this Term
COO_ID	NUMBER	(7)	Yes	Program Offering Option Identifier of the Student Program Attempt for this Term
CLASS_STANDING_IDENTIFIER	NUMBER	(15)		Class Standing Identifier of the Student Program Attempt for this Term
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 TERM_RECORD_ID
,      PERSON_IDENTIFIER
,      PROGRAM_CODE
,      PROGRAM_VERSION
,      ACADEMIC_CALENDAR_TYPE
,      TERM_CALENDAR_TYPE
,      TERM_CAL_SEQUENCE_NUMBER
,      KEY_PROGRAM_FLAG
,      _LA:KEY_PROGRAM_FLAG_DESC
,      LOCATION_CODE
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      FEE_CATEGORY
,      COO_ID
,      CLASS_STANDING_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_STUDENT_PROGRAM_TERMS;

Dependencies

[top of page]

APPS.IGSBV_STUDENT_PROGRAM_TERMS references the following:

APPS: IGS_EN_SPA_TERMS

APPS.IGSBV_STUDENT_PROGRAM_TERMS is not referenced by any database object