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.

[Home] [Help]

VIEW: HR.PER_SALARY_SURVEY_LINES_EFC#

Source

View Text - Preformatted


select SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID, EFC_ACTION_ID EFC_ACTION_ID, MINIMUM_PAY MINIMUM_PAY, MAXIMUM_PAY MAXIMUM_PAY, MEAN_PAY MEAN_PAY, GRADUATE_PAY GRADUATE_PAY, STARTING_PAY STARTING_PAY, JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE, JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE, JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE, JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE, MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION, MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION, MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION, COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE, COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE, COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE, COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE, CURRENCY_CODE CURRENCY_CODE, TENTH_PERCENTILE TENTH_PERCENTILE, TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE, FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE, SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE, NINETIETH_PERCENTILE NINETIETH_PERCENTILE, MINIMUM_BONUS MINIMUM_BONUS, MEAN_BONUS MEAN_BONUS, MAXIMUM_BONUS MAXIMUM_BONUS, MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE, MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE, MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE, MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION, MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION, MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION, MINIMUM_STOCK MINIMUM_STOCK, MEAN_STOCK MEAN_STOCK, MAXIMUM_STOCK MAXIMUM_STOCK from "HR"."PER_SALARY_SURVEY_LINES_EFC"

View Text - HTML Formatted

SELECT SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, EFC_ACTION_ID EFC_ACTION_ID
, MINIMUM_PAY MINIMUM_PAY
, MAXIMUM_PAY MAXIMUM_PAY
, MEAN_PAY MEAN_PAY
, GRADUATE_PAY GRADUATE_PAY
, STARTING_PAY STARTING_PAY
, JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE
, JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE
, JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE
, JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE
, MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION
, MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION
, MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION
, COMPNSTN_FIRST_QUARTILE COMPNSTN_FIRST_QUARTILE
, COMPNSTN_MEDIAN_QUARTILE COMPNSTN_MEDIAN_QUARTILE
, COMPNSTN_THIRD_QUARTILE COMPNSTN_THIRD_QUARTILE
, COMPNSTN_FOURTH_QUARTILE COMPNSTN_FOURTH_QUARTILE
, CURRENCY_CODE CURRENCY_CODE
, TENTH_PERCENTILE TENTH_PERCENTILE
, TWENTY_FIFTH_PERCENTILE TWENTY_FIFTH_PERCENTILE
, FIFTIETH_PERCENTILE FIFTIETH_PERCENTILE
, SEVENTY_FIFTH_PERCENTILE SEVENTY_FIFTH_PERCENTILE
, NINETIETH_PERCENTILE NINETIETH_PERCENTILE
, MINIMUM_BONUS MINIMUM_BONUS
, MEAN_BONUS MEAN_BONUS
, MAXIMUM_BONUS MAXIMUM_BONUS
, MINIMUM_SALARY_INCREASE MINIMUM_SALARY_INCREASE
, MEAN_SALARY_INCREASE MEAN_SALARY_INCREASE
, MAXIMUM_SALARY_INCREASE MAXIMUM_SALARY_INCREASE
, MIN_VARIABLE_COMPENSATION MIN_VARIABLE_COMPENSATION
, MEAN_VARIABLE_COMPENSATION MEAN_VARIABLE_COMPENSATION
, MAX_VARIABLE_COMPENSATION MAX_VARIABLE_COMPENSATION
, MINIMUM_STOCK MINIMUM_STOCK
, MEAN_STOCK MEAN_STOCK
, MAXIMUM_STOCK MAXIMUM_STOCK
FROM "HR"."PER_SALARY_SURVEY_LINES_EFC"