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_PGM_OFR_ADM_PAT_RESTRCTN

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds the information about the restriction for which program are being offered for a specific admission category during specific admission period. It is based on the entity Program Offering Admission Pattern Restriction

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_CALENDAR_DESC	VARCHAR2	(30)		Description for the Calendar Instance
ADMISSION_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Describes the calendar type relating to the admission period.
ADMISSION_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Describes the admission category that the admission period is restricted to.
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.
_LA:PROCESS_TYPE_MEANING	CHAR	(82)
NOMINATED_PROGRAM_CODE	VARCHAR2	(6)	Yes
NOMINATED_PROGRAM_TITLE	VARCHAR2	(90)	Yes
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)	Yes
SEQUENCE_NUMBER	NUMBER	(6)	Yes
LOCATION_CODE	VARCHAR2	(10)
LOCATION_DESC	VARCHAR2	(60)
ATTENDANCE_MODE	VARCHAR2	(2)
ATTENDANCE_MODE_DESC	VARCHAR2	(60)
ATTENDANCE_TYPE	VARCHAR2	(2)
ATTENDANCE_TYPE_DESC	VARCHAR2	(60)
_LA:ROLLOVER_INCL_IND_FLAG	CHAR	(63)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT ADMISSION_CALENDAR_DESC
,      ADMISSION_CALENDAR_TYPE
,      ADMISSION_CI_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESC
,      _LA:PROCESS_TYPE_MEANING
,      NOMINATED_PROGRAM_CODE
,      NOMINATED_PROGRAM_TITLE
,      PROGRAM_VERSION_NUMBER
,      ACADEMIC_CALENDAR_TYPE
,      SEQUENCE_NUMBER
,      LOCATION_CODE
,      LOCATION_DESC
,      ATTENDANCE_MODE
,      ATTENDANCE_MODE_DESC
,      ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESC
,      _LA:ROLLOVER_INCL_IND_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PGM_OFR_ADM_PAT_RESTRCTN;

Dependencies

[top of page]

APPS.IGSFV_PGM_OFR_ADM_PAT_RESTRCTN references the following:

APPS: IGS_AD_CAT_ALL; IGS_AD_LOCATION_ALL; IGS_AD_PRD_PS_OF_OPT; IGS_CA_INST_ALL; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_VER_ALL

APPS.IGSFV_PGM_OFR_ADM_PAT_RESTRCTN is not referenced by any database object