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_STDNT_PRG_INTERMISSIONS

Object Details

Object Name:	IGSBV_STDNT_PRG_INTERMISSIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_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
INTERMISSION_TYPE	VARCHAR2	(25)		Code of the institution defined intermission type used to intermit the student program attempt.
START_DATE	DATE		Yes	Describes the start date on which the intermission on the student program attempt becomes effective
END_DATE	DATE		Yes	Describes the end date on which the intermission on the student program attempt ends
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 another institution where student will pursue his study during the intermission period.
MAXIMUM_CREDIT_POINTS	NUMBER	(15)		Indicates the maximum credit points accepted for advanced standing 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
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.
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
,      INTERMISSION_TYPE
,      START_DATE
,      END_DATE
,      VOLUNTARY_FLAG
,      _LA:VOLUNTARY_FLAG_DESC
,      COMMENTS
,      APPROVED_FLAG
,      _LA:APPROVED_FLAG_DESC
,      INSTITUTION_NAME
,      MAXIMUM_CREDIT_POINTS
,      MAXIMUM_TERMS
,      ANTICIPATED_CREDIT_POINTS
,      APPROVER_PERSON_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LOGICAL_DELETE_DATE
,      COND_RETURN_FLAG
FROM APPS.IGSBV_STDNT_PRG_INTERMISSIONS;

Dependencies

[top of page]

APPS.IGSBV_STDNT_PRG_INTERMISSIONS references the following:

APPS: HZ_PARTIES; IGS_EN_STDNT_PS_INTM

APPS.IGSBV_STDNT_PRG_INTERMISSIONS is not referenced by any database object