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_SEARCH_CRITERIA

Object Details

Object Name:	IRC_SEARCH_CRITERIA
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.IRC_SEARCH_CRITERIA
Subobject Name:
Status:	VALID

Contains job matching preferences and saved advanced search criteria

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_SEARCH_CRITERIA_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEARCH_CRITERIA_ID
SYS_IL0000202641C00026$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202641C00106$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000202641C00107$$	LOB	UNIQUE	APPS_TS_TX_DATA
IRC_SEARCH_CRITERIA_CTX	DOMAIN	NONUNIQUE		KEYWORDS
IRC_SEARCH_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEARCH_CRITERIA_ID	NUMBER	(15)	Yes	Primary Key
OBJECT_ID	NUMBER	(15)	Yes	ID of the parent object
OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of the parent object - PARTY or VACANCY
SEARCH_NAME	VARCHAR2	(240)		If saved search criteria, the name of the search
SEARCH_TYPE	VARCHAR2	(30)		A for Advanced, B for Basic
LOCATION	VARCHAR2	(240)		Location a person is interested in
DISTANCE_TO_LOCATION	VARCHAR2	(30)		The distance the user is willing to travel to work. Based upon lookup value.
EMPLOYEE	VARCHAR2	(30)		Y or N. Is the person interested in employee positions. Is the job suitable for employees?
CONTRACTOR	VARCHAR2	(30)		Y or N. Is the person interested in a contractor position / is the vacancy suitable for contractors?
EMPLOYMENT_CATEGORY	VARCHAR2	(30)		Style of employement (full time / part time) the user is interested in.
KEYWORDS	VARCHAR2	(240)		List of keywords that the user wishes to be included as part of the search criteria.
TRAVEL_PERCENTAGE	NUMBER			Percentage of time a person is willing to spend travelling.
MIN_SALARY	NUMBER			The minimum amount a user is willing to accept as a salary, or the minimum amount to be paid for a position.
MAX_SALARY	NUMBER			The maximum amount to be paid for a position.
SALARY_CURRENCY	VARCHAR2	(30)		The currency that the MAX_SALARY column is in.
SALARY_PERIOD	VARCHAR2	(30)		The period the salary applies for.
MATCH_COMPETENCE	VARCHAR2	(30)		Y or N. Depending on whether the user wishes to match jobs against the competencies they've entered.
MATCH_QUALIFICATION	VARCHAR2	(30)		Y or N. Depending on whether the user wishes to match jobs against their qualifications.
JOB_TITLE	VARCHAR2	(240)		Title of the job the user wishes to be included in their search.
DEPARTMENT	VARCHAR2	(240)		Department that the user wishes to search on.
PROFESSIONAL_AREA	VARCHAR2	(30)		Professional area that the user wishes to work in, or the vacancy is in.
WORK_AT_HOME	VARCHAR2	(30)		Lookup to determine how desirable working at home is.
MIN_QUAL_LEVEL	NUMBER	(9)		Minimum qualification level required by a vacancy.
MAX_QUAL_LEVEL	NUMBER	(9)		Maximum qualification level required by a vacancy.
USE_FOR_MATCHING	VARCHAR2	(30)		Indicates whether a saved search is to be used for job matching purposes.
DESCRIPTION	CLOB	(4000)		A description of the saved search.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield column.
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield column.
ISC_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer Descriptive flexfield structure defining column.
ISC_INFORMATION1	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION2	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION3	VARCHAR2	(150)
ISC_INFORMATION4	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION5	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION6	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION7	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION8	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION9	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION10	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION11	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION12	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION13	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION14	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION15	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION16	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION17	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION18	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION19	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION20	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION21	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION22	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION23	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION24	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION25	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION26	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION27	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION28	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION29	VARCHAR2	(150)		Developer Descriptive flexfield column.
ISC_INFORMATION30	VARCHAR2	(150)		Developer Descriptive flexfield column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
DATE_POSTED	VARCHAR2	(30)		Days since job got posted.
GEOCODE_LOCATION	VARCHAR2	(240)
GEOCODE_COUNTRY	VARCHAR2	(30)
DERIVED_LOCATION	VARCHAR2	(240)
LOCATION_ID	NUMBER	(15)
GEOMETRY	SDO_GEOMETRY	(1)

Query Text

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


SELECT SEARCH_CRITERIA_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      SEARCH_NAME
,      SEARCH_TYPE
,      LOCATION
,      DISTANCE_TO_LOCATION
,      EMPLOYEE
,      CONTRACTOR
,      EMPLOYMENT_CATEGORY
,      KEYWORDS
,      TRAVEL_PERCENTAGE
,      MIN_SALARY
,      MAX_SALARY
,      SALARY_CURRENCY
,      SALARY_PERIOD
,      MATCH_COMPETENCE
,      MATCH_QUALIFICATION
,      JOB_TITLE
,      DEPARTMENT
,      PROFESSIONAL_AREA
,      WORK_AT_HOME
,      MIN_QUAL_LEVEL
,      MAX_QUAL_LEVEL
,      USE_FOR_MATCHING
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ISC_INFORMATION_CATEGORY
,      ISC_INFORMATION1
,      ISC_INFORMATION2
,      ISC_INFORMATION3
,      ISC_INFORMATION4
,      ISC_INFORMATION5
,      ISC_INFORMATION6
,      ISC_INFORMATION7
,      ISC_INFORMATION8
,      ISC_INFORMATION9
,      ISC_INFORMATION10
,      ISC_INFORMATION11
,      ISC_INFORMATION12
,      ISC_INFORMATION13
,      ISC_INFORMATION14
,      ISC_INFORMATION15
,      ISC_INFORMATION16
,      ISC_INFORMATION17
,      ISC_INFORMATION18
,      ISC_INFORMATION19
,      ISC_INFORMATION20
,      ISC_INFORMATION21
,      ISC_INFORMATION22
,      ISC_INFORMATION23
,      ISC_INFORMATION24
,      ISC_INFORMATION25
,      ISC_INFORMATION26
,      ISC_INFORMATION27
,      ISC_INFORMATION28
,      ISC_INFORMATION29
,      ISC_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DATE_POSTED
,      GEOCODE_LOCATION
,      GEOCODE_COUNTRY
,      DERIVED_LOCATION
,      LOCATION_ID
,      GEOMETRY
FROM HR.IRC_SEARCH_CRITERIA;

Dependencies

[top of page]

HR.IRC_SEARCH_CRITERIA references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

HR.IRC_SEARCH_CRITERIA is referenced by following:

HR: DR$IRC_SEARCH_CRITERIA_CTXTC; IRC_SEARCH_CRITERIA#