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: IGF_AP_RECORD_MATCH

Product:	IGF - Financial Aid (Obsolete)
Description:	Retrieves the person attributes which are to be used for matching new ISIR or Profile record with existing person
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ROWID ROW_ID
, ARM_ID
, SSN
, GIVEN_NAME
, SURNAME
, BIRTH_DT
, ADDRESS
, CITY
, ZIP
, MIN_SCORE_AUTO_FA
, MIN_SCORE_RVW_FA
, ADMN_TERM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MATCH_CODE
, MATCH_DESC
, GENDER_NUM
, EMAIL_NUM
, ENABLED_FLAG
, GIVEN_NAME_MT_TXT
, SURNAME_MT_TXT
, BIRTH_DT_MT_TXT
, ADDRESS_MT_TXT
, CITY_MT_TXT
, ZIP_MT_TXT
, GENDER_MT_TXT
, EMAIL_MT_TXT
FROM IGF_AP_RECORD_MATCH_ALL
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
ARM_ID
SSN
GIVEN_NAME
SURNAME
BIRTH_DT
ADDRESS
CITY
ZIP
MIN_SCORE_AUTO_FA
MIN_SCORE_RVW_FA
ADMN_TERM
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MATCH_CODE
MATCH_DESC
GENDER_NUM
EMAIL_NUM
ENABLED_FLAG
GIVEN_NAME_MT_TXT
SURNAME_MT_TXT
BIRTH_DT_MT_TXT
ADDRESS_MT_TXT
CITY_MT_TXT
ZIP_MT_TXT
GENDER_MT_TXT
EMAIL_MT_TXT