[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | The entity is used in Self Service to query for a Person |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PE.PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.SURNAME
, PE.MIDDLE_NAME
, PE.GIVEN_NAMES
, PE.PREFERRED_NAME
, PE.PREFERRED_GIVEN_NAME
, PE.SEX_MEANING SEX
, PE.BIRTH_DT
, PE.EMAIL_ADDR
, PE.TITLE
, PE.SUFFIX
, PE.PRE_NAME_ADJUNCT PREFIX
, PE.SALUTATION
, PE.DECEASED_IND
, API.START_DT
, API.END_DT
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, PID.DESCRIPTION
, PID.PREFERRED_IND
, IGS_PE_VAL_PIGM.MERGED_IND (PE.PERSON_ID) DISPLAY_OB_IND
, ADDR.ADDR_TYPE
, ADDR.ADDR_LINE_1
, ADDR.ADDR_LINE_2
, ADDR.ADDR_LINE_3
, ADDR.ADDR_LINE_4
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.COUNTRY
, ADDR.POSTAL_CODE
, ADDR.START_DT
, ADDR.END_DT
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON PE
, IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PID
, IGS_PE_PERSON_ADDR ADDR
WHERE PE.PERSON_ID = API.PE_PERSON_ID(+)
AND PE.PERSON_ID = ADDR.PERSON_ID(+)
AND API.PERSON_ID_TYPE = PID.PERSON_ID_TYPE(+)