Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PE.PERSON_ID
, PE.STAFF_MEMBER_IND
, SUBSTR(IGS_EN_GEN_007.ENRP_GET_STUDENT_IND(PE.PERSON_ID)
, 1
, 1)
, SUBSTR(IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(PE.PERSON_ID)
, 1
, 1)
, PE.DECEASED_IND
, PE.SURNAME
, PE.GIVEN_NAMES
, PE.PREFERRED_GIVEN_NAME
, PE.SEX
, 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.GIVEN_NAMES || ' ' || PE.SURNAME
, NVL(PE.PREFERRED_GIVEN_NAME
, SUBSTR (PE.GIVEN_NAMES
, 1
, DECODE(INSTR(PE.GIVEN_NAMES
, ' ')
, 0
, LENGTH(PE.GIVEN_NAMES)
, (INSTR(PE.GIVEN_NAMES
, ' ')-1)))) || ' ' || PE.SURNAME
, PE.TITLE || ' ' || PE.GIVEN_NAMES || ' ' || PE.SURNAME
, SUBSTR(IGS_GE_GEN_002.GENP_GET_INITIALS(PE.GIVEN_NAMES)
, 1
, 10) || ' ' || PE.SURNAME
, PE.SURNAME || '
, ' || SUBSTR(IGS_GE_GEN_002.GENP_GET_INITIALS(PE.GIVEN_NAMES)
, 1
, 10)
, PE.SURNAME || '
, ' || PE.TITLE || ' ' || NVL(PE.PREFERRED_GIVEN_NAME
, PE.GIVEN_NAMES) FROM IGS_PE_PERSON PE