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_PAIRS_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DP.ROWID ROW_ID
, DP.DUPLICATE_PAIR_ID
, DP.BATCH_ID
, DP.ACTUAL_PERSON_ID
, P1.PERSON_NUMBER ACTUAL_PERSON_NUMBER
, DP.DUPLICATE_PERSON_ID
, P2.PERSON_NUMBER DUPLICATE_PERSON_NUMBER
, DP.OBSOLETE_ID
, DP.MATCH_CATEGORY
, DP.MATCH_SET_ID
, DP.DUP_STATUS
, DP.ADDRESS_TYPE ADDR_TYPE
, DP.LOCATION_ID LOCATION_ID
, DP.PERSON_ID_TYPE
, (P1.SURNAME || '
, ' || INITCAP(P1.TITLE) || ' ' || P1.GIVEN_NAMES) ACT_PERSON_NAME
, (P2.SURNAME || '
, ' || INITCAP(P2.TITLE) || ' ' || P2.GIVEN_NAMES) DUP_PERSON_NAME
, MS.MATCH_SET_NAME
, DP.CREATED_BY
, DP.CREATION_DATE
, DP.LAST_UPDATED_BY
, DP.LAST_UPDATE_DATE
, DP.LAST_UPDATE_LOGIN
FROM IGS_PE_DUP_PAIRS DP
, IGS_PE_PERSON P1
, IGS_PE_PERSON P2
, IGS_PE_MATCH_SETS MS
WHERE DP.ACTUAL_PERSON_ID = P1.PERSON_ID AND DP.DUPLICATE_PERSON_ID = P2.PERSON_ID AND DP.MATCH_SET_ID = MS.MATCH_SET_ID

Columns

Name
ROW_ID
DUPLICATE_PAIR_ID
BATCH_ID
ACTUAL_PERSON_ID
ACTUAL_PERSON_NUMBER
DUPLICATE_PERSON_ID
DUPLICATE_PERSON_NUMBER
OBSOLETE_ID
MATCH_CATEGORY
MATCH_SET_ID
DUP_STATUS
ADDR_TYPE
LOCATION_ID
PERSON_ID_TYPE
ACT_PERSON_NAME
DUP_PERSON_NAME
MATCH_SET_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN