[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Person View |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PE.ROW_ID
, PE.PERSON_ID
, PE.PERSON_NUMBER
, PE.STAFF_MEMBER_IND
, PE.STUDENT_IND
, PE.ENCUMBERED_IND
, PE.DECEASED_IND
, PE.SURNAME
, PE.MIDDLE_NAME
, PE.SUFFIX
, PE.PRE_NAME_ADJUNCT
, PE.PRE_NAME_ADJUNCT_MEANING
, PE.DECEASED_DATE
, PE.GIVEN_NAMES
, PE.SEX
, PE.SEX_MEANING
, PE.TITLE
, PE.BIRTH_DT
, PE.SALUTATION
, PE.ORACLE_USERNAME
, PE.EMAIL_ADDR
, PE.ARCHIVE_EXCLUSION_IND
, PE.ARCHIVE_DT
, PE.PURGE_EXCLUSION_IND
, PE.PURGE_DT
, PE.FULL_NAME
, PE. PREFERRED_NAME
, PE.TITLE_NAME
, PE.INITIAL_NAME
, PE.INITIAL_LAST_NAME
, PE.CONTEXT_BLOCK_NAME
, PE.PREFERRED_GIVEN_NAME
, PE.VETERAN
, PE.MILITARY_SERVICE_REG
, PE.LEVEL_OF_QUAL_ID
, PE.LEVEL_OF_QUAL
, PE.PROOF_OF_INS
, PE.PROOF_OF_IMMU
, PE.PERSON_ID_TYPE
, PE.API_PERSON_ID
, P.FUNNEL_STATUS
, P.FUNNEL_STATUS_MEANING
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.ATTRIBUTE21
, PE.ATTRIBUTE22
, PE.ATTRIBUTE23
, PE.ATTRIBUTE24
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATE_LOGIN
, PE.OBJECT_VERSION_NUMBER
FROM IGS_PE_PERSON_V PE
, IGS_AD_PROSPECT_V P
WHERE PE.PERSON_ID = P.PERSON_ID (+)