Product: | IGS - Student System (Obsolete) |
---|---|
Description: | IGS_PE_HZ_PARTIES describes the attribites of a person |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_ID
, PHP.OSS_ORG_UNIT_CD INSTITUTION_CODE
, HP.PARTY_NUMBER TCA_PARTY_NUMBER
, HP.PARTY_NAME
, '_LA:PHP.OI_LOCAL_INSTITUTION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.OI_OS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.OI_GOVT_INSTITUTION_CD:IGS_LOOKUP_VALUES:OR_INST_GOV_CD:MEANING'
, '_LA:PHP.OI_INST_CONTROL_TYPE:IGS_LOOKUP_VALUES:OR_INST_CTL_TYPE:MEANING'
, PHP.OI_INSTITUTION_TYPE
, PHP.OI_INSTITUTION_STATUS
, PHP.INST_EPS_CODE
, PHP.INST_PHONE_COUNTRY_CODE
, PHP.INST_PHONE_AREA_CODE
, PHP.INST_PHONE_NUMBER
, PHP.ADV_STUDIES_CLASSES
, PHP.HONORS_CLASSES
, PHP.CLASS_SIZE
, PHP.SEC_SCHOOL_LOCATION_ID
, PHP.PERCENT_PLAN_HIGHER_EDU
, '_LA:PHP.INST_PRIORITY_CD:IGS_LOOKUP_VALUES:OR_INST_PRIORITY_CD:MEANING'
, PHP.CREATED_BY
, PHP.CREATION_DATE
, PHP.LAST_UPDATED_BY
, PHP.LAST_UPDATE_DATE
, PHP.LAST_UPDATE_LOGIN
FROM IGS_PE_HZ_PARTIES PHP
, HZ_PARTIES HP
WHERE HP.PARTY_ID = PHP.PARTY_ID
AND HP.PARTY_TYPE = 'ORGANIZATION'
AND PHP.INST_ORG_IND = 'I' WITH READ ONLY