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_ADM_PERD_ADM_CAT

Object Details

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

View Type

A Business Intelligence System view

[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 admission 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	The 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.
ADMISSION_START_DATE	DATE		Yes	Describes the start date of the admission period.
ADMISSION_END_DATE	DATE		Yes	Describes the end date of the admission period
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_CALENDAR_DESC
,      ADMISSION_CALENDAR_TYPE
,      ADMISSION_CI_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESC
,      ADMISSION_START_DATE
,      ADMISSION_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ADM_PERD_ADM_CAT;

Dependencies

[top of page]

APPS.IGSFV_ADM_PERD_ADM_CAT references the following:

APPS: IGS_AD_CAT_ALL; IGS_AD_PERD_AD_CAT; IGS_CA_INST_ALL

APPS.IGSFV_ADM_PERD_ADM_CAT is not referenced by any database object