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.IGS_AD_PRCS_CAT_ADMPRCS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of admission_process_cat. Incorporates descriptions for both the
Admission Category and System Admission Process Type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_CAT	VARCHAR2	(10)	Yes	The code of an institution-defined admission category. An admissioncategory is used to group a set of applicants whose applications will be processed through a common set of admission procedure steps.
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)	Yes	Describes the system-defined processes available for direct admission. For example, program admission, program transfer, re-admission, short admission, admission to non-award units of study.
AC_DESCRIPTION	VARCHAR2	(60)	Yes	Describes an institution-defined admission category. Anadmission category is used to group a set of applicants whoseapplications will be processed through a common set of admission proceduresteps.
SAPT_DESCRIPTION	VARCHAR2	(80)	Yes	Provides an explanation of the admission process type
S_CITIZENSHIP_TYPE	VARCHAR2	(10)	Yes	Describes the citizenship type of the admission category. The citizenship type can be international, domestic or all. For example, an admission category 'UG-INTER', intended for international student admissions, would be restricted to citizenship type 'International'.
CLOSED_IND	VARCHAR2	(1)	Yes	An indicator that specifies whether the admission category is closed. Selecting the indicator, ticked closes the admission category.
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      AC_DESCRIPTION
,      SAPT_DESCRIPTION
,      S_CITIZENSHIP_TYPE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_PRCS_CAT_ADMPRCS_V;

Dependencies

[top of page]

APPS.IGS_AD_PRCS_CAT_ADMPRCS_V references the following:

APPS: IGS_AD_CAT; IGS_AD_PRCS_CAT; IGS_LOOKUPS_VIEW

APPS.IGS_AD_PRCS_CAT_ADMPRCS_V is referenced by following:

APPS: IGS_AD_SESSION_DTL_V