VIEW: HR.IRC_SEARCH_CRITERIA#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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