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_H_EDU_PGM_TYP_RESTRCTN

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds the information about the Program Type Restriction i.e. the mapping of user-defined Program Types and Admission Categories. When the user maps the program types to an admission category, this restricts the program types that the admission category is available.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
ADMISSION_CATEGORY_DESC	VARCHAR2	(60)	Yes	Description of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
PROGRAM_TYPE	VARCHAR2	(10)	Yes	Institution-defined program type. Program type indicates the type of higher education program. Each program type must map to a Government program type DETYA element reference number 310- For example, 1 higher doctorate, 21 diploma, 50 non-award program.
PROGRAM_TYPE_DESC	VARCHAR2	(60)	Yes	Description of the institution-defined program type. A program type indicates the type of higher education program. For example, Bachelor's Pass, Graduate Certificate, Higher Degree by Research.
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 ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESC
,      PROGRAM_TYPE
,      PROGRAM_TYPE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_H_EDU_PGM_TYP_RESTRCTN;

Dependencies

[top of page]

APPS.IGSFV_H_EDU_PGM_TYP_RESTRCTN references the following:

APPS: IGS_AD_CAT_ALL; IGS_AD_CAT_PS_TYPE; IGS_PS_TYPE_ALL

APPS.IGSFV_H_EDU_PGM_TYP_RESTRCTN is not referenced by any database object