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_P_V

Product:	IGS - Student System (Obsolete)
Description:	IGS_PE_DUP_MATCHES_P_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.PERSON_LAST_NAME SURNAME
, NULL SURNAME_5_CHAR
, P.PERSON_FIRST_NAME GIVEN_NAMES
, NULL GIVEN_NAME_1_CHAR
, PP.GENDER SEX
, PP.DATE_OF_BIRTH BIRTH_DT
, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, PIT.API_PERSON_ID PREF_ALTERNATE_ID
, P.STATUS
FROM HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_PERSON_ID_TYPE_V PIT
WHERE P.PARTY_ID = PP.PARTY_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PIT.PE_PERSON_ID(+)

Columns

Name
PERSON_ID
SURNAME
SURNAME_5_CHAR
GIVEN_NAMES
GIVEN_NAME_1_CHAR
SEX
BIRTH_DT
ETHNIC_ORIGIN
PREF_ALTERNATE_ID
STATUS