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

Object Details

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

View Type

A Business Intelligence System view

[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
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the Person Number for the Person Identifier
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the Person
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 of the Student Program Attempt for this Term
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the Program attempted by the Student
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Academic Calendar Type of the Student Program Attempt for this Term
ACADEMIC_CALENDAR_TYPE_DESC	VARCHAR2	(60)	Yes	Description of the Academic Calendar Type
TERM_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Term Calendar Type for which Student Program Attempt changes are being captured
TERM_CALENDAR_TYPE_DESC	VARCHAR2	(60)	Yes	Description of Term Calendar Type
TERM_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the Term Calendar instance for which Student Program Attempt changes are being captured
TEM_CALENDAR_START_DATE	DATE		Yes	Date from which the Term Calendar Instance becomes effective
TERM_CALENDAR_END_DATE	DATE		Yes	Date from which the Term Calendar Instance becomes ineffective
TERM_CALENDAR_INSTANCE_DESC	VARCHAR2	(30)		Description of the Term Calendar Instance
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
LOCATION_CODE_DESC	VARCHAR2	(60)	Yes	Description of Location Code
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Nominated Attendance Mode of the Student Program Attempt for this Term
ATTENDANCE_MODE_DESC	VARCHAR2	(60)	Yes	Description of Attendance Mode
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Nominated Attendance Type
ATTENDANCE_TYPE_DESC	VARCHAR2	(60)	Yes	Description of Attendance Type
FEE_CATEGORY	VARCHAR2	(10)		Fee Category of the Student Program Attempt for this Term
FEE_CATEGORY_DESC	VARCHAR2	(60)		Description of the Fee Category
COO_ID	NUMBER	(7)	Yes	Course 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
CLASS_STANDING_DESC	VARCHAR2	(50)		Description of the Class Standing
_DF	CHAR	(34)
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
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_VERSION
,      PROGRAM_TITLE
,      ACADEMIC_CALENDAR_TYPE
,      ACADEMIC_CALENDAR_TYPE_DESC
,      TERM_CALENDAR_TYPE
,      TERM_CALENDAR_TYPE_DESC
,      TERM_CAL_SEQUENCE_NUMBER
,      TEM_CALENDAR_START_DATE
,      TERM_CALENDAR_END_DATE
,      TERM_CALENDAR_INSTANCE_DESC
,      KEY_PROGRAM_FLAG
,      _LA:KEY_PROGRAM_FLAG_DESC
,      LOCATION_CODE
,      LOCATION_CODE_DESC
,      ATTENDANCE_MODE
,      ATTENDANCE_MODE_DESC
,      ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESC
,      FEE_CATEGORY
,      FEE_CATEGORY_DESC
,      COO_ID
,      CLASS_STANDING_IDENTIFIER
,      CLASS_STANDING_DESC
,      _DF
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_STUDENT_PROGRAM_TERMS;

Dependencies

[top of page]

APPS.IGSFV_STUDENT_PROGRAM_TERMS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_CA_INST_ALL; IGS_CA_TYPE; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_EN_SPA_TERMS; IGS_FI_FEE_CAT_ALL; IGS_PR_CLASS_STD; IGS_PS_VER_ALL

APPS.IGSFV_STUDENT_PROGRAM_TERMS is not referenced by any database object