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.

[Home] [Help]

View: IGS_OR_INST_HIST

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.INSTITUTION_CD INSTITUTION_CD
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.NAME NAME
, TAB.INST_PHONE_COUNTRY_CODE INST_PHONE_COUNTRY_CODE
, TAB.INST_PHONE_AREA_CODE INST_PHONE_AREA_CODE
, TAB.INST_PHONE_NUMBER INST_PHONE_NUMBER
, TAB.INST_PRIORITY_CD INST_PRIORITY_CD
, TAB.EPS_CODE EPS_CODE
, TAB.INSTITUTION_STATUS INSTITUTION_STATUS
, TAB.LOCAL_INSTITUTION_IND LOCAL_INSTITUTION_IND
, TAB.OS_IND OS_IND
, TAB.GOVT_INSTITUTION_CD GOVT_INSTITUTION_CD
, TAB.INSTITUTION_TYPE INSTITUTION_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.INST_CONTROL_TYPE INST_CONTROL_TYPE
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_OR_INST_HIST_ALL TAB

Columns

Name
ROW_ID
ORG_ID
INSTITUTION_CD
HIST_START_DT
HIST_END_DT
HIST_WHO
NAME
INST_PHONE_COUNTRY_CODE
INST_PHONE_AREA_CODE
INST_PHONE_NUMBER
INST_PRIORITY_CD
EPS_CODE
INSTITUTION_STATUS
LOCAL_INSTITUTION_IND
OS_IND
GOVT_INSTITUTION_CD
INSTITUTION_TYPE
DESCRIPTION
INST_CONTROL_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN