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_RECORD_MATCH_ALL

Object Details

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

Holds the person attributes which are to be used for matching new ISIR or Profile record with the existing person

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_RECORD_MATCH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARM_ID
IGF_AP_RECORD_MATCH_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	MATCH_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ARM_ID	NUMBER	(15)	Yes	Holds a Sequence Generated value
ORG_ID	NUMBER	(15)		Is a Generic Org ID Column
SSN	NUMBER	(15)	Yes	Contains the Weight of Social Security Number
GIVEN_NAME	NUMBER	(15)	Yes	Contains the Weight of Given Name
SURNAME	NUMBER	(15)	Yes	Contains the Weight of Surname
BIRTH_DT	NUMBER	(15)	Yes	Contains the Weight of Birth_date
ADDRESS	NUMBER	(15)	Yes	Contains the Weight of Address
CITY	NUMBER	(15)	Yes	Contains the Weight of City
ZIP	NUMBER	(15)	Yes	Contains the Weight of Zip Code
MIN_SCORE_AUTO_FA	NUMBER	(15)	Yes	Holds the Minimum Score for automatic creation of FA Base Record
MIN_SCORE_RVW_FA	NUMBER	(15)	Yes	Holds the minimum score for manual review to create FA Base Record
ADMN_TERM	VARCHAR2	(30)		Indicates the Admission Term
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)	Yes	Standard WHO column
MATCH_CODE	VARCHAR2	(30)		Match Criteria Code
MATCH_DESC	VARCHAR2	(80)		Match criteria description
GENDER_NUM	NUMBER			Contains the score weight of Gender
EMAIL_NUM	NUMBER			Contains the score weight of Email
ENABLED_FLAG	VARCHAR2	(1)		Active Indicator
GIVEN_NAME_MT_TXT	VARCHAR2	(30)		Match Type to be used for given Name
SURNAME_MT_TXT	VARCHAR2	(30)		Match Type to be used for surname
BIRTH_DT_MT_TXT	VARCHAR2	(30)		Match Type to be used for birth date
ADDRESS_MT_TXT	VARCHAR2	(30)		Match Type to be used for address
CITY_MT_TXT	VARCHAR2	(30)		Match Type to be used for city
ZIP_MT_TXT	VARCHAR2	(30)		Match Type to be used for zip
GENDER_MT_TXT	VARCHAR2	(30)		Match Type to be used for gender
EMAIL_MT_TXT	VARCHAR2	(30)		Match Type to be used for email

Query Text

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


SELECT ARM_ID
,      ORG_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.IGF_AP_RECORD_MATCH_ALL;

Dependencies

[top of page]

IGF.IGF_AP_RECORD_MATCH_ALL does not reference any database object

IGF.IGF_AP_RECORD_MATCH_ALL is referenced by following:

APPS: IGF_AP_RECORD_MATCH_ALL