FND Design Data [Home] [Help]

View: IGS_OR_INSTITUTION_V

Product: IGS - Student System (Obsolete)
Description: Describes the Institution Details
Implementation/DBA Data: Not implemented in this database
View Text

SELECT ROW_ID
, PARTY_ID
, INSTITUTION_CD
, NAME
, INSTITUTION_STATUS
, LOCAL_INSTITUTION_IND
, OS_IND
, GOVT_INSTITUTION_CD
, INSTITUTION_TYPE
, DESCRIPTION
, INST_CONTROL_TYPE
, CTRL_DESCRIPTION
, PREF_INST_ID_TYPE
, PREF_INST_ALT_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, EPS_CODE
, INSTITUTION_PRIORITY
, PRIORITY_DESCRIPTION
, INST_PHONE_COUNTRY_CODE
, INST_PHONE_AREA_CODE
, INST_PHONE_NUMBER
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, SEC_SCHOOL_LOCATION_ID
, SEC_SCHOOL_LOCATION_CODE
, SEC_SCHOOL_LOCATION_DESC
, PERCENT_PLAN_HIGHER_EDU
FROM IGS_OR_INSTITUTION

Columns

Name
ROW_ID
PARTY_ID
INSTITUTION_CD
NAME
INSTITUTION_STATUS
LOCAL_INSTITUTION_IND
OS_IND
GOVT_INSTITUTION_CD
INSTITUTION_TYPE
DESCRIPTION
INST_CONTROL_TYPE
CTRL_DESCRIPTION
PREF_INST_ID_TYPE
PREF_INST_ALT_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
EPS_CODE
INSTITUTION_PRIORITY
PRIORITY_DESCRIPTION
INST_PHONE_COUNTRY_CODE
INST_PHONE_AREA_CODE
INST_PHONE_NUMBER
ADV_STUDIES_CLASSES
HONORS_CLASSES
CLASS_SIZE
SEC_SCHOOL_LOCATION_ID
SEC_SCHOOL_LOCATION_CODE
SEC_SCHOOL_LOCATION_DESC
PERCENT_PLAN_HIGHER_EDU