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_INSTITUTION_PARTY

Object Details

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

View Type

A Business Intelligence System view

IGS_PE_HZ_PARTIES describes the attribites of a person

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTITUTION_IDENTIFIER	NUMBER	(15)	Yes	Institution identifier
INSTITUTION_CODE	VARCHAR2	(30)		Product Recognized Institution Code
TCA_PARTY_NUMBER	VARCHAR2	(30)	Yes	Party Number of the Institution in HZ_PARTIES
INSTITUTION_NAME	VARCHAR2	(360)	Yes	Name of this institution
_LA:LOCAL_INSTITUTION_IND	CHAR	(65)		Flag indicates whether institution is local or not
_LA:OVERSEAS_INDICATOR	CHAR	(50)		Flag indicates whether institution is overseas or not
_LA:GOVT_INSTITUTION_CODE	CHAR	(71)		Government institution code
_LA:CONTROL_TYPE	CHAR	(71)		Organizational institute control type
INSTITUTION_TYPE	VARCHAR2	(20)		Institution type
INSTITUTION_STATUS	VARCHAR2	(10)		Institution status
EPS_CODE	VARCHAR2	(8)		Indicates the Institution Market Code
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Indicates the Institution Phone Country Code
PHONE_AREA_CODE	VARCHAR2	(10)		Indicates the Institution Phone Area Code
PHONE_NUMBER	VARCHAR2	(40)		Indicates the Institution Phone Number
ADV_STUDIES_CLASSES	NUMBER			Indicates the number of Advanced Studies Classes Offered
HONORS_CLASSES	NUMBER			Indicates the number of Honors classes offered
CLASS_SIZE	NUMBER			Indicates the class size
SEC_SCHOOL_LOCATION_IDENTIFIER	NUMBER	(15)		Indicates the secondary school location identifier
PERCENT_PLAN_HIGHER_EDU	NUMBER			Indicates the percentage of students planning to pursue higher education
_LA:PRIORITY_CODE	CHAR	(70)		Institution Priority Code
INSTITUTION_TYPE_DESC	VARCHAR2	(60)		Institution type description
INSTITUTION_STATUS_DESC	VARCHAR2	(60)		Institution status 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 INSTITUTION_IDENTIFIER
,      INSTITUTION_CODE
,      TCA_PARTY_NUMBER
,      INSTITUTION_NAME
,      _LA:LOCAL_INSTITUTION_IND
,      _LA:OVERSEAS_INDICATOR
,      _LA:GOVT_INSTITUTION_CODE
,      _LA:CONTROL_TYPE
,      INSTITUTION_TYPE
,      INSTITUTION_STATUS
,      EPS_CODE
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      ADV_STUDIES_CLASSES
,      HONORS_CLASSES
,      CLASS_SIZE
,      SEC_SCHOOL_LOCATION_IDENTIFIER
,      PERCENT_PLAN_HIGHER_EDU
,      _LA:PRIORITY_CODE
,      INSTITUTION_TYPE_DESC
,      INSTITUTION_STATUS_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGSFV_INSTITUTION_PARTY;

Dependencies

[top of page]

APPS.IGSFV_INSTITUTION_PARTY references the following:

APPS: HZ_PARTIES; IGS_OR_INST_STAT; IGS_OR_ORG_INST_TYPE_ALL; IGS_PE_HZ_PARTIES

APPS.IGSFV_INSTITUTION_PARTY is not referenced by any database object