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_OR_INST_HIST_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
INSTITUTION_CD	VARCHAR2	(30)	The unique code for an institution. These institutions normally relate directly to the DETYA (Government) set of institutions, however other institutions relevant to the business of the organisation may also be created. An institution is optionally mapped to a government institution code.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
NAME	VARCHAR2	(360)	The name of a user-defined institution. Optionally mapped to a government or DETYA-defined institution. The name may or may not be identical to the name of the government institution to which it is mapped.
INST_PHONE_COUNTRY_CODE	VARCHAR2	(10)	Country code in which the institution is located
INST_PHONE_AREA_CODE	VARCHAR2	(10)	Area code in which the institution is located
INST_PHONE_NUMBER	VARCHAR2	(40)	Phone number of the institution
INSTITUTION_PRIORITY	VARCHAR2	(30)	It indicates the priority of the institution
PRIORITY_DESCRIPTION	VARCHAR2	(80)	Describes the priority of the institution
EPS_CODE	VARCHAR2	(8)	Indiactes the market code of the institution
INSTITUTION_STATUS	VARCHAR2	(10)	A status which indicates the level of activity of the institution. Statuses are institution-defined, and each maps to a system recognised status (ACTIVE or INACTIVE).
INST_STATUS_DESC	VARCHAR2	(60)	Describes the status of the institution.
LOCAL_INSTITUTION_IND	VARCHAR2	(1)	An indicator which specifies whether or not the current institution is designated as the 'home' institution for the purposes of reporting related organisational unit, course and student data to DETYA. Setting the checkbox (ticked) identifies the institution as the 'home' institution. Only one institution may be identified as the 'home' institution.
OS_IND	VARCHAR2	(1)	Setting this indicator shows that the institution is based overseas.
GOVT_INSTITUTION_CD	VARCHAR2	(30)	The code for the DETYA-defined institution to which the current institution is mapped. The mapping of an institution to a government institution code is optional, but is recommended if a DETYA equivalent institution exists.
DESCRIPTION	VARCHAR2	(80)	The name of a DETYA-specified tertiary institution matching the DETYA institution code (element 306). Institution names usually match the names listed in Appendix A of the DETYA Higher Education Student Collection documentation.
INSTITUTION_TYPE	VARCHAR2	(20)	Indiactes the type of the institution
INST_TYPE_DESC	VARCHAR2	(60)
INST_CONTROL_TYPE	VARCHAR2	(30)	Indiactes the control type of the institution
INST_CTL_TYPE_DESC	VARCHAR2	(80)
CREATED_BY	NUMBER	(15)	Standard WHO Column
CREATION_DATE	DATE		Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO Column
LAST_UPDATE_DATE	DATE		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_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      NAME
,      INST_PHONE_COUNTRY_CODE
,      INST_PHONE_AREA_CODE
,      INST_PHONE_NUMBER
,      INSTITUTION_PRIORITY
,      PRIORITY_DESCRIPTION
,      EPS_CODE
,      INSTITUTION_STATUS
,      INST_STATUS_DESC
,      LOCAL_INSTITUTION_IND
,      OS_IND
,      GOVT_INSTITUTION_CD
,      DESCRIPTION
,      INSTITUTION_TYPE
,      INST_TYPE_DESC
,      INST_CONTROL_TYPE
,      INST_CTL_TYPE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_OR_INST_HIST_V;

Dependencies

[top of page]

APPS.IGS_OR_INST_HIST_V references the following:

APPS: HZ_PARTIES; IGS_LOOKUP_VALUES; IGS_OR_INST_HIST_ALL; IGS_OR_INST_STAT; IGS_OR_ORG_INST_TYPE; IGS_PE_HZ_PARTIES

APPS.IGS_OR_INST_HIST_V is not referenced by any database object