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_STDNT_PRG_INTERMISSIONS

Object Details

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

View Type

A Business Intelligence System view

This entity gives the intermission information of the student's program attempt.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	The sequence generated identification number of the student whose program has been intermitted.
PERSON_NUMBER	VARCHAR2	(30)	Yes	The user entered identification number of the student whose program has been intermitted.
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the Person.
PROGRAM_CODE	VARCHAR2	(6)	Yes	The code of the program attempted by the student which has been intermitted
PROGRAM_TITLE	VARCHAR2	(90)	Yes	The Program title attempted by the student which has been intermitted
INTERMISSION_TYPE	VARCHAR2	(25)		Type of Intermission
INTERMISSION_DESC	VARCHAR2	(90)		Description of Intermission
START_DATE	DATE		Yes	Commencement date of the intermission period for the student program attempt.
END_DATE	DATE		Yes	End date of the intermission period for the student program attempt. Values may be selected from a list of teaching periods.
VOLUNTARY_FLAG	VARCHAR2	(1)	Yes	Indicates whether the intermission of the student program attempt was initiated at the student's request.
_LA:VOLUNTARY_FLAG_DESC	CHAR	(50)		Description of Voluntary Flag.
COMMENTS	VARCHAR2	(2000)		Gives the additional information about the student program attempt intermission
APPROVED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the intermission imposed on the student program attempt has been approved by the institution
_LA:APPROVED_FLAG_DESC	CHAR	(45)		Indicates whether the intermission imposed on the student program attempt has been approved by the institution
INSTITUTION_NAME	VARCHAR2	(90)		Indicates the name of the other institution where student will pursue his study during the intermission period.
INSTITUTION_CODE	VARCHAR2	(30)		Indicates the code of another institution where student will pursue his studies during the intermission period.
MAXIMUM_CREDIT_POINTS	NUMBER	(15)		Indicates the maximum credit points accepted for advanced standing for the student program being intermitted
MAXIMUM_TERMS	NUMBER	(15)		Indicates the maximum terms accepted for advanced standing for the student program being intermitted
ANTICIPATED_CREDIT_POINTS	NUMBER	(15)		Indicates the credit points anticipated to be completed by the student at another institution while intermitting the program attempt at the current institution
_DF	CHAR	(34)
APPROVER_PERSON_IDENTIFIER	NUMBER	(15)		Indicates the sequence generated identification number of the faculty by whom the intermission on the student program will be approved.
APPROVER_PERSON_NUMBER	VARCHAR2	(30)		The user entered identification number of the faculty by whom the intermission will be on the student program attempt will be approved.
APPROVER_PERSON_NAME	VARCHAR2	(360)		Full Name of the Approver
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
LOGICAL_DELETE_DATE	DATE		Yes	Date on which the intermission is logically deleted.
COND_RETURN_FLAG	VARCHAR2	(1)	Yes	Conditional Return Flag

Query Text

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


SELECT PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      INTERMISSION_TYPE
,      INTERMISSION_DESC
,      START_DATE
,      END_DATE
,      VOLUNTARY_FLAG
,      _LA:VOLUNTARY_FLAG_DESC
,      COMMENTS
,      APPROVED_FLAG
,      _LA:APPROVED_FLAG_DESC
,      INSTITUTION_NAME
,      INSTITUTION_CODE
,      MAXIMUM_CREDIT_POINTS
,      MAXIMUM_TERMS
,      ANTICIPATED_CREDIT_POINTS
,      _DF
,      APPROVER_PERSON_IDENTIFIER
,      APPROVER_PERSON_NUMBER
,      APPROVER_PERSON_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LOGICAL_DELETE_DATE
,      COND_RETURN_FLAG
FROM APPS.IGSFV_STDNT_PRG_INTERMISSIONS;

Dependencies

[top of page]

APPS.IGSFV_STDNT_PRG_INTERMISSIONS references the following:

APPS: HZ_PARTIES; IGS_EN_INTM_TYPES; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_STDNT_PS_INTM; IGS_PS_VER_ALL

APPS.IGSFV_STDNT_PRG_INTERMISSIONS is not referenced by any database object