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_SS_ADMAPPL_SETUP_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This view is for Admission Applications Setup

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
ADMAPPL_SETUP_ID	NUMBER	(15)	Yes	This is an Identifier for Admission Application for the Self service setup
ALIAS_TYPE	VARCHAR2	(30)		This is an Alias type identifier
ALIAS_TYPE_DESC	VARCHAR2	(80)		This is an Alias type description field
PERSON_ID_TYPE	VARCHAR2	(10)		This is an Person type identifier
PERSON_ID_TYPE_DESC	VARCHAR2	(60)		This is a description Identifier for a person type
PERMANENT_ADDR_TYPE	VARCHAR2	(10)		Permanent Address Type
MAILING_ADDR_TYPE	VARCHAR2	(10)		Mailing Address Type field
PS_NOTE_TYPE_ID	NUMBER	(15)		Identifier for Person Notes type
PS_NOTE_TYPE	VARCHAR2	(30)		Person Note Type field
PS_NOTE_TYPE_DESC	VARCHAR2	(80)		This is a description for Person Note type
WE_NOTE_TYPE_ID	NUMBER	(15)		Work experience Type Identifier
WE_NOTE_TYPE	VARCHAR2	(30)		Work Experience Note Type
WE_NOTE_TYPE_DESC	VARCHAR2	(80)		Work Experience Note Type Description
ACT_NOTE_TYPE_ID	NUMBER	(15)		If not attending school activities since last enrolled
ACT_NOTE_TYPE	VARCHAR2	(30)		If not attending school activities since last enrolled
ACT_NOTE_TYPE_DESC	VARCHAR2	(80)		Description for If not attending school activities since last enrolled
DEPENDENT_OF_VETERAN	NUMBER	(15)		Dependent of veteran military service type
DEPENDENT_OF_VETEREN_TYPE	VARCHAR2	(30)		Dependent of veteran military service type
DEPENDENT_OF_VETEREN_DESC	VARCHAR2	(60)		Dependent of veteran military service type description
APP_SOURCE_ID	NUMBER	(15)		Application Source Identifier
APP_SOURCE_NAME	VARCHAR2	(10)		Application Source Name
APP_SOURCE_DESC	VARCHAR2	(30)		Application Source Description
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 ROW_ID
,      ADMAPPL_SETUP_ID
,      ALIAS_TYPE
,      ALIAS_TYPE_DESC
,      PERSON_ID_TYPE
,      PERSON_ID_TYPE_DESC
,      PERMANENT_ADDR_TYPE
,      MAILING_ADDR_TYPE
,      PS_NOTE_TYPE_ID
,      PS_NOTE_TYPE
,      PS_NOTE_TYPE_DESC
,      WE_NOTE_TYPE_ID
,      WE_NOTE_TYPE
,      WE_NOTE_TYPE_DESC
,      ACT_NOTE_TYPE_ID
,      ACT_NOTE_TYPE
,      ACT_NOTE_TYPE_DESC
,      DEPENDENT_OF_VETERAN
,      DEPENDENT_OF_VETEREN_TYPE
,      DEPENDENT_OF_VETEREN_DESC
,      APP_SOURCE_ID
,      APP_SOURCE_NAME
,      APP_SOURCE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_SS_ADMAPPL_SETUP_V;

Dependencies

[top of page]

APPS.IGS_SS_ADMAPPL_SETUP_V references the following:

APPS: IGS_AD_CODE_CLASSES; IGS_AD_NOTE_TYPES; IGS_LOOKUPS_VIEW; IGS_PE_CODE_CLASSES; IGS_PE_PERSON_ID_TYP; IGS_SS_ADMAPPL_SETUP

APPS.IGS_SS_ADMAPPL_SETUP_V is not referenced by any database object