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_AD_ADM_APPL

Object Details

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

View Type

A Business Intelligence System view

Describes Admission of Application to Institution

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the ID of the person that the admission application is for
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
PERSON_NAME	VARCHAR2	(450)		Person Name
ADMISSION_APPLICATION_NUMBER	NUMBER	(2)	Yes	Identifies uniquely an admission application for a person
APPLICATION_DATE	DATE		Yes	Describes the date the admission application was made
ACADEMIC_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code for Academic Calendar
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Describes the academic calendar type to which the admission application relates
ACADEMIC_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the academic calendar sequence number that the admission application is for
ADMISSION_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code for Admission Calendar
ADMISSION_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Describes the admission calendar type to which the admission application applies
ADMISSION_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the admission calendar sequence number that the admission application is for
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Describes the institution-defined admission category of the admission application
ADMISSION_CATEGORY_DESCRIPTION	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	(81)		Lookup tag for Admission Process Type
ADMISSION_APPL_STATUS	VARCHAR2	(10)	Yes	Admission Application Status
APPLICATION_STATUS_DESCRIPTION	VARCHAR2	(60)	Yes	Admission Application Status Description
ADMISSION_FEE_STATUS	VARCHAR2	(10)	Yes	Admission Fee Status
FEE_STATUS_DESCRIPTION	VARCHAR2	(60)	Yes	Admission Fee Status Description
_LA:TAC_APPL_IND_FLAG	CHAR	(53)		Lookup Tag for Citizenship Type
SPECIAL_GROUP_1	NUMBER			Special Group 1
SPECIAL_GROUP1_NAME	VARCHAR2	(10)		Special Group 1 Name
SPECIAL_GROUP1_DESCRIPTION	VARCHAR2	(30)		Special Group 1 Description
SPECIAL_GROUP_2	NUMBER			Special Group 2
SPECIAL_GROUP2_NAME	VARCHAR2	(10)		Special Group 2 Name
SPECIAL_GROUP2_DESCRIPTION	VARCHAR2	(30)		Special Group 2 Description
_LA:COMMON_APP_IND_FLAG	CHAR	(51)		Common Application Indicator Flag
APPLICATION_TYPE	VARCHAR2	(30)		Admission Application Type
APPLICATION_TYPE_DESCRIPTION	VARCHAR2	(60)		Admission Application Type Description
CHOICE_NUMBER	NUMBER	(3)		Choice Number
ROUTEB_PREF	VARCHAR2	(30)		Route B Preference
APPLICATION_ID	NUMBER	(15)		Application Id
ALTERNATE_APPLICATION_ID	VARCHAR2	(30)		Alternate Application Identifier
CREATED_BY	NUMBER	(15)	Yes	WHO Column
CREATION_DATE	DATE		Yes	WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO Column
LAST_UPDATE_DATE	DATE		Yes	WHO Column

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      ADMISSION_APPLICATION_NUMBER
,      APPLICATION_DATE
,      ACADEMIC_ALTERNATE_CODE
,      ACADEMIC_CALENDAR_TYPE
,      ACADEMIC_CAL_SEQUENCE_NUMBER
,      ADMISSION_ALTERNATE_CODE
,      ADMISSION_CALENDAR_TYPE
,      ADMISSION_CAL_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESCRIPTION
,      _LA:PROCESS_TYPE_MEANING
,      ADMISSION_APPL_STATUS
,      APPLICATION_STATUS_DESCRIPTION
,      ADMISSION_FEE_STATUS
,      FEE_STATUS_DESCRIPTION
,      _LA:TAC_APPL_IND_FLAG
,      SPECIAL_GROUP_1
,      SPECIAL_GROUP1_NAME
,      SPECIAL_GROUP1_DESCRIPTION
,      SPECIAL_GROUP_2
,      SPECIAL_GROUP2_NAME
,      SPECIAL_GROUP2_DESCRIPTION
,      _LA:COMMON_APP_IND_FLAG
,      APPLICATION_TYPE
,      APPLICATION_TYPE_DESCRIPTION
,      CHOICE_NUMBER
,      ROUTEB_PREF
,      APPLICATION_ID
,      ALTERNATE_APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AD_ADM_APPL;

Dependencies

[top of page]

APPS.IGSFV_AD_ADM_APPL references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_AD_APPL_ALL; IGS_AD_APPL_STAT; IGS_AD_CAT_ALL; IGS_AD_CODE_CLASSES; IGS_AD_FEE_STAT; IGS_AD_SS_APPL_TYP; IGS_CA_INST_ALL

APPS.IGSFV_AD_ADM_APPL is not referenced by any database object