DBA Data[Home] [Help]

VIEW: HR.PER_SALADMIN_ANALYTICS#

Source

View Text - Preformatted

select EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, JOB_ID JOB_ID, COUNTRY COUNTRY, PAY_BASIS_ID PAY_BASIS_ID, TOTAL_HEADCOUNT TOTAL_HEADCOUNT, MED_ANL_SLRY MED_ANL_SLRY, ANL_SLRY_CURRENCY ANL_SLRY_CURRENCY, COMPARATIO COMPARATIO, RANGE_POSITION RANGE_POSITION, QUARTILE QUARTILE from "HR"."PER_SALADMIN_ANALYTICS"
View Text - HTML Formatted

SELECT EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, JOB_ID JOB_ID
, COUNTRY COUNTRY
, PAY_BASIS_ID PAY_BASIS_ID
, TOTAL_HEADCOUNT TOTAL_HEADCOUNT
, MED_ANL_SLRY MED_ANL_SLRY
, ANL_SLRY_CURRENCY ANL_SLRY_CURRENCY
, COMPARATIO COMPARATIO
, RANGE_POSITION RANGE_POSITION
, QUARTILE QUARTILE
FROM "HR"."PER_SALADMIN_ANALYTICS"