eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_PE_DUP_MATCHES_PP_V

Product:	IGS - Student System (Obsolete)
Description:	IGS_PE_DUP_MATCHES_PP_V is used for the duplicate information about persons.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_LAST_NAME SURNAME
, NULL SURNAME_5_CHAR
, P.PERSON_FIRST_NAME GIVEN_NAMES
, SUBSTR(P.PERSON_FIRST_NAME
, 1
, 1) GIVEN_NAME_1_CHAR
, S.GENDER SEX
, S.DATE_OF_BIRTH BIRTH_DT
, PIT2.API_PERSON_ID PREF_ALTERNATE_ID
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, NULL
, S.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, P.STATUS
, API.START_DT API_START_DATE
, API.END_DT API_END_DATE
FROM HZ_PARTIES P
, IGS_PE_ALT_PERS_ID API
, HZ_PERSON_PROFILES S
, IGS_PE_PERSON_ID_TYPE_V PIT2
WHERE P.PARTY_ID = API.PE_PERSON_ID (+)
AND P.PARTY_ID = S.PARTY_ID
AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE
AND NVL(S.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PIT2.PE_PERSON_ID(+)

Columns

Name
PERSON_ID
PERSON_NUMBER
SURNAME
SURNAME_5_CHAR
GIVEN_NAMES
GIVEN_NAME_1_CHAR
SEX
BIRTH_DT
PREF_ALTERNATE_ID
API_PERSON_ID
PERSON_ID_TYPE
PREFERRED_IND
ETHNIC_ORIGIN
STATUS
API_START_DATE
API_END_DATE