[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | The view returns the valid person details in OSS. Only the basic data is returned |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, PP. DATE_OF_BIRTH BIRTH_DATE
, PP. GENDER
, '_LA:HP.VALIDATED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_FIRST_NAME
, HP.PERSON_MIDDLE_NAME
, HP.PERSON_LAST_NAME
, HP.PERSON_NAME_SUFFIX
, HP.PERSON_TITLE
, HP.PERSON_ACADEMIC_TITLE
, HP.PERSON_IDEN_TYPE
, HP.PERSON_IDENTIFIER
, HP.EMAIL_ADDRESS
, HP.SALUTATION
, '_LA:PHP.DECEASED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.ARCHIVE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.ARCHIVE_DT
, '_LA:PHP.PURGE_EXCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.PURGE_DT
, PHP.ORACLE_USERNAME
, '_LA:PHP.PROOF_OF_INS:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.PROOF_OF_IMMU:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.LEVEL_OF_QUAL
, '_LA:PHP.MILITARY_SERVICE_REG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:PHP.VETERAN:IGS_LOOKUP_VALUES:VETERAN_STATUS:MEANING'
, '_LA:PHP.FUND_AUTHORIZATION:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PHP.BIRTH_CITY
, PHP.BIRTH_COUNTRY
, 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
, HZ_PERSON_PROFILES PP
WHERE HP.PARTY_ID = PHP.PARTY_ID
AND PP.PARTY_ID = HP.PARTY_ID WITH READ ONLY