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: HR.IRC_REFERRAL_INFO

Object Details

Object Name:	IRC_REFERRAL_INFO
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

This table stores the referral source information for applicants/candidates. It identifies the source type and the source details. If the source type is 'employee referral', five different criteria can be stored to identify employee who has referred the candidate. It also stores comments updated by Candidate and Employee.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_REFERRAL_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERRAL_INFO_ID
IRC_REFERRAL_INFO_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REFERRAL_INFO_ID	NUMBER	(15)	Yes	Primary key
OBJECT_ID	NUMBER	(15)	Yes	ID of object defined in OBJECT_TYPE
OBJECT_TYPE	VARCHAR2	(30)	Yes	Identifies if source information is for profile or application
START_DATE	DATE		Yes	Start Date
END_DATE	DATE		Yes	End Date
SOURCE_TYPE	VARCHAR2	(30)		Type of source information
SOURCE_NAME	VARCHAR2	(240)		Source name other than employee referral
SOURCE_CRITERIA1	VARCHAR2	(30)		Criteria to fetch employee information
SOURCE_VALUE1	VARCHAR2	(320)		Criteria to fetch employee information
SOURCE_CRITERIA2	VARCHAR2	(30)		Criteria to fetch employee information
SOURCE_VALUE2	VARCHAR2	(320)		Criteria to fetch employee information
SOURCE_CRITERIA3	VARCHAR2	(30)		Criteria to fetch employee information
SOURCE_VALUE3	VARCHAR2	(320)		Criteria to fetch employee information
SOURCE_CRITERIA4	VARCHAR2	(30)		Criteria to fetch employee information
SOURCE_VALUE4	VARCHAR2	(320)		Criteria to fetch employee information
SOURCE_CRITERIA5	VARCHAR2	(30)		Criteria to fetch employee information
SOURCE_VALUE5	VARCHAR2	(320)		Criteria to fetch employee information
SOURCE_PERSON_ID	NUMBER	(15)		Employee's person id
CANDIDATE_COMMENT	VARCHAR2	(4000)		Comments provided by candidate
EMPLOYEE_COMMENT	VARCHAR2	(4000)		Comments provided by employee
IRF_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure defining column
IRF_ATTRIBUTE1	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE2	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE3	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE4	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE5	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE6	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE7	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE8	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE9	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_ATTRIBUTE10	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure defining column
IRF_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column
IRF_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column
OBJECT_CREATED_BY	VARCHAR2	(30)		Indicates who created the profile or application
CREATED_BY	NUMBER	(15)		Standard WHO Column
CREATION_DATE	DATE			Standard WHO Column
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update

Query Text

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


SELECT REFERRAL_INFO_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      START_DATE
,      END_DATE
,      SOURCE_TYPE
,      SOURCE_NAME
,      SOURCE_CRITERIA1
,      SOURCE_VALUE1
,      SOURCE_CRITERIA2
,      SOURCE_VALUE2
,      SOURCE_CRITERIA3
,      SOURCE_VALUE3
,      SOURCE_CRITERIA4
,      SOURCE_VALUE4
,      SOURCE_CRITERIA5
,      SOURCE_VALUE5
,      SOURCE_PERSON_ID
,      CANDIDATE_COMMENT
,      EMPLOYEE_COMMENT
,      IRF_ATTRIBUTE_CATEGORY
,      IRF_ATTRIBUTE1
,      IRF_ATTRIBUTE2
,      IRF_ATTRIBUTE3
,      IRF_ATTRIBUTE4
,      IRF_ATTRIBUTE5
,      IRF_ATTRIBUTE6
,      IRF_ATTRIBUTE7
,      IRF_ATTRIBUTE8
,      IRF_ATTRIBUTE9
,      IRF_ATTRIBUTE10
,      IRF_INFORMATION_CATEGORY
,      IRF_INFORMATION1
,      IRF_INFORMATION2
,      IRF_INFORMATION3
,      IRF_INFORMATION4
,      IRF_INFORMATION5
,      IRF_INFORMATION6
,      IRF_INFORMATION7
,      IRF_INFORMATION8
,      IRF_INFORMATION9
,      IRF_INFORMATION10
,      OBJECT_CREATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM HR.IRC_REFERRAL_INFO;

Dependencies

[top of page]

HR.IRC_REFERRAL_INFO does not reference any database object

HR.IRC_REFERRAL_INFO is referenced by following:

APPS: IRC_REFERRAL_INFO; IRC_REFERRAL_INFO_WHO