Product: | IGS - Student System (Obsolete) |
---|---|
Description: | New View for securing select privileges on IGS_PE_HZ_PARTIES table. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PD.PARTY_ID
, PD.DECEASED_IND
, PD.ARCHIVE_EXCLUSION_IND
, PD.ARCHIVE_DT
, PD.PURGE_EXCLUSION_IND
, PD.PURGE_DT
, PD.ORACLE_USERNAME
, PD.PROOF_OF_INS
, PD.PROOF_OF_IMMU
, PD.LEVEL_OF_QUAL
, PD.MILITARY_SERVICE_REG
, PD.VETERAN
, PD.INSTITUTION_CD
, PD.OI_LOCAL_INSTITUTION_IND
, PD.OI_OS_IND
, PD.OI_GOVT_INSTITUTION_CD
, PD.OI_INST_CONTROL_TYPE
, PD.OI_INSTITUTION_TYPE
, PD.OI_INSTITUTION_STATUS
, PD.OU_START_DT
, PD.OU_END_DT
, PD.OU_MEMBER_TYPE
, PD.OU_ORG_STATUS
, PD.OU_ORG_TYPE
, PD.INST_ORG_IND
, PD.INST_PRIORITY_CD
, PD.INST_EPS_CODE
, PD.INST_PHONE_COUNTRY_CODE
, PD.INST_PHONE_AREA_CODE
, PD.INST_PHONE_NUMBER
, PD.ADV_STUDIES_CLASSES
, PD.HONORS_CLASSES
, PD.CLASS_SIZE
, PD.SEC_SCHOOL_LOCATION_ID
, PD.PERCENT_PLAN_HIGHER_EDU
, PD.FUND_AUTHORIZATION
, PD.PE_INFO_VERIFY_TIME
, PD.CREATED_BY
, PD.CREATION_DATE
, PD.LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN
, PD.REQUEST_ID
, PD.PROGRAM_APPLICATION_ID
, PD.PROGRAM_ID
, PD.PROGRAM_UPDATE_DATE
, PD.BIRTH_CITY
, PD.BIRTH_COUNTRY
, PD.OSS_ORG_UNIT_CD
, PD.FELONY_CONVICTED_FLAG
FROM IGS_PE_HZ_PARTIES PD