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

Object Details

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

View Type

A Business Intelligence System view

Obsolete

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INST_ORG_CODE	VARCHAR2	(30)	Yes	The Institution or Organizational Unit Code
INST_ORG_INDICATOR	VARCHAR2	(1)		Flag indicates whether it is an organization or institution. 'O' - Organization, 'I' - Institution
INSTITUTION_CODE	VARCHAR2	(30)		Identifier code of the institution in which the Organizational Unit is associated.
ORG_START_DATE	DATE			Start date of the org unit
ORG_END_DATE	DATE			End date of the org unit
_LA:ORG_MEMBER_TYPE	CHAR	(63)		Member Type of Organizational Unit
ORG_STATUS	VARCHAR2	(10)		Status of Organizational Unit
_LA:ORG_TYPE	CHAR	(57)		Type of Organizational Unit
LOCAL_INSTITUTION_INDICATOR	VARCHAR2	(1)		Flag indicates whether institution is local.
OVERSEAS_INDICATOR	VARCHAR2	(1)		Indicator to show whether the institution is overseas.
_LA:GOVT_INSTITUTION_CODE	CHAR	(72)		Government institution code
_LA:INST_CONTROL_TYPE	CHAR	(71)		Control Type of Institution.
_LA:INST_PRIORITY	CHAR	(70)		Institution Priority
INSTITUTION_TYPE	VARCHAR2	(20)		Type of Institution.
INSTITUTION_STATUS	VARCHAR2	(10)		Status of Institution.
INST_MARKET_CODE	VARCHAR2	(8)		Market code indicator for an institution.
INST_PHONE_COUNTRY_CODE	VARCHAR2	(10)		Country code telephone number for the institution.
INST_PHONE_AREA_CODE	VARCHAR2	(10)		Area Code telephone number for the institution.
INST_PHONE_NUMBER	VARCHAR2	(40)		Telephone number for the institution.
ADV_STUDIES_CLASSES	NUMBER			The number of Advanced Studies Classes Offered
HONORS_CLASSES	NUMBER			The number of Honours classes offered
CLASS_SIZE	NUMBER			Size of the class
PERCENT_PLAN_HIGHER_EDU	NUMBER			The percentage of students planning to pursue higher education
PARTY_ID	NUMBER	(15)	Yes	Unique identifier of the party
SEC_SCHOOL_LOCATION_ID	NUMBER	(15)		Secondary school location identifier
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 INST_ORG_CODE
,      INST_ORG_INDICATOR
,      INSTITUTION_CODE
,      ORG_START_DATE
,      ORG_END_DATE
,      _LA:ORG_MEMBER_TYPE
,      ORG_STATUS
,      _LA:ORG_TYPE
,      LOCAL_INSTITUTION_INDICATOR
,      OVERSEAS_INDICATOR
,      _LA:GOVT_INSTITUTION_CODE
,      _LA:INST_CONTROL_TYPE
,      _LA:INST_PRIORITY
,      INSTITUTION_TYPE
,      INSTITUTION_STATUS
,      INST_MARKET_CODE
,      INST_PHONE_COUNTRY_CODE
,      INST_PHONE_AREA_CODE
,      INST_PHONE_NUMBER
,      ADV_STUDIES_CLASSES
,      HONORS_CLASSES
,      CLASS_SIZE
,      PERCENT_PLAN_HIGHER_EDU
,      PARTY_ID
,      SEC_SCHOOL_LOCATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_ORG_EXTENSIONS;

Dependencies

[top of page]

APPS.IGSBV_ORG_EXTENSIONS references the following:

APPS: HZ_PARTIES; IGS_PE_HZ_PARTIES

APPS.IGSBV_ORG_EXTENSIONS is not referenced by any database object