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_PRIM_PA_V

Product:	IGS - Student System (Obsolete)
Description:	Contains data of a person and his primary address.This view is used in duplicate matching of person.
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
, PP.GENDER SEX
, PP.DATE_OF_BIRTH BIRTH_DT
, PIT.API_PERSON_ID PREF_ALTERNATE_ID
, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, REPLACE (P.ADDRESS1
, ' '
, '')|| REPLACE (P.ADDRESS2
, ' '
, '')|| REPLACE (P.ADDRESS3
, ' '
, '')|| REPLACE (P.ADDRESS4
, ' '
, '') CONCT_ADDRESS_LINES
, REPLACE (P.ADDRESS1
, ' '
, '') ADDR_LINE_1
, REPLACE (P.ADDRESS2
, ' '
, '') ADDR_LINE_2
, REPLACE (P.ADDRESS3
, ' '
, '') ADDR_LINE_3
, REPLACE (P.ADDRESS4
, ' '
, '') ADDR_LINE_4
, P.CITY
, P.STATE
, P.PROVINCE
, P.COUNTY
, P.COUNTRY
, P.POSTAL_CODE POSTCODE
, P.STATUS
FROM HZ_PARTIES P
, IGS_PE_PERSON_ID_TYPE_V PIT
, HZ_PERSON_PROFILES PP
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
PERSON_NUMBER
SURNAME
SURNAME_5_CHAR
GIVEN_NAMES
GIVEN_NAME_1_CHAR
SEX
BIRTH_DT
PREF_ALTERNATE_ID
ETHNIC_ORIGIN
CONCT_ADDRESS_LINES
ADDR_LINE_1
ADDR_LINE_2
ADDR_LINE_3
ADDR_LINE_4
CITY
STATE
PROVINCE
COUNTY
COUNTRY
POSTCODE
STATUS