DBA Data[Home] [Help]

VIEW: HR.GHR_RIF_CRITERIA#

Source

View Text - Preformatted

select RIF_CRITERIA_ID RIF_CRITERIA_ID, NAME NAME, COMP_AREA COMP_AREA, COMP_LEVEL COMP_LEVEL, EFFECTIVE_DATE EFFECTIVE_DATE, ORGANIZATION_ID ORGANIZATION_ID, ORG_STRUCTURE_ID ORG_STRUCTURE_ID, OFFICE_SYMBOL OFFICE_SYMBOL, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."GHR_RIF_CRITERIA"
View Text - HTML Formatted

SELECT RIF_CRITERIA_ID RIF_CRITERIA_ID
, NAME NAME
, COMP_AREA COMP_AREA
, COMP_LEVEL COMP_LEVEL
, EFFECTIVE_DATE EFFECTIVE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, OFFICE_SYMBOL OFFICE_SYMBOL
, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."GHR_RIF_CRITERIA"