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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGF.IGF_AP_MATCH_DETAILS

Object Details

Object Name:	IGF_AP_MATCH_DETAILS
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_AP_MATCH_DETAILS
Subobject Name:
Status:	VALID

Holds the match details in case the student has a partial match with the incoming ISIR or Profile record

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_MATCH_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APM_ID PERSON_ID
IGF_AP_MATCH_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECORD_STATUS
IGF_AP_MATCH_DETAILS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AMD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AMD_ID	NUMBER	(15)	Yes	Holds the primary key
APM_ID	NUMBER	(15)	Yes	Holds the foreign key to the igf_ap_person_match table
PERSON_ID	NUMBER	(15)		Holds Person ID
SSN_MATCH	NUMBER	(15)		Indicates if there was a match between the profile record and the person record of system
GIVEN_NAME_MATCH	NUMBER	(15)		Indicates if there was a first name match between the profile and system records
SURNAME_MATCH	NUMBER	(15)		Indicates if there was a surname match between the profile and system person records
DOB_MATCH	NUMBER	(15)		Indicates if there was a date of birth match between the ISIR and OSS person records .
ADDRESS_MATCH	NUMBER	(15)		Indicates if the address first line of the profile matches with the system person records
CITY_MATCH	NUMBER	(15)		Indicates if the city from student profile matches with the record present in system
ZIP_MATCH	NUMBER	(15)		Indicates if the postal code from the person record in system matches with the student profile data
MATCH_SCORE	NUMBER		Yes	Holds the total score for all the defined attributes for a particular system and Profile record matching.
RECORD_STATUS	VARCHAR2	(30)	Yes	Holds the matching status of the profile or ISIR record.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
EMAIL_ID_MATCH	NUMBER	(15)		Holds the match score for Email Address
GENDER_MATCH	NUMBER	(15)		Holds the match score for Gender
SSN_TXT	VARCHAR2	(30)		Social security number of the matched person in OSS
GIVEN_NAME_TXT	VARCHAR2	(150)		Given name of the matched person in OSS
SUR_NAME_TXT	VARCHAR2	(150)		Sur name of the matched person in OSS
BIRTH_DATE	DATE			Date of birth of the matched person in OSS
ADDRESS_TXT	VARCHAR2	(240)		Address of the matched person in OSS
CITY_TXT	VARCHAR2	(60)		City of the matched person in OSS
ZIP_TXT	VARCHAR2	(60)		Postal code of the matched person in OSS
GENDER_TXT	VARCHAR2	(30)		Gender of the matched person in OSS
EMAIL_ID_TXT	VARCHAR2	(2000)		Email ID of the matched person in OSS

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AMD_ID
,      APM_ID
,      PERSON_ID
,      SSN_MATCH
,      GIVEN_NAME_MATCH
,      SURNAME_MATCH
,      DOB_MATCH
,      ADDRESS_MATCH
,      CITY_MATCH
,      ZIP_MATCH
,      MATCH_SCORE
,      RECORD_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EMAIL_ID_MATCH
,      GENDER_MATCH
,      SSN_TXT
,      GIVEN_NAME_TXT
,      SUR_NAME_TXT
,      BIRTH_DATE
,      ADDRESS_TXT
,      CITY_TXT
,      ZIP_TXT
,      GENDER_TXT
,      EMAIL_ID_TXT
FROM IGF.IGF_AP_MATCH_DETAILS;

Dependencies

[top of page]

IGF.IGF_AP_MATCH_DETAILS does not reference any database object

IGF.IGF_AP_MATCH_DETAILS is referenced by following:

APPS: IGF_AP_MATCH_DETAILS