VIEW: HR.PER_SALARY_SURVEY_LINES#

Source

View Text - Preformatted

select OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SALARY_SURVEY_ID SALARY_SURVEY_ID, SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID, SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE, SURVEY_REGION_CODE SURVEY_REGION_CODE, SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE, COMPANY_SIZE_CODE COMPANY_SIZE_CODE, INDUSTRY_CODE INDUSTRY_CODE, SURVEY_AGE_CODE SURVEY_AGE_CODE, START_DATE START_DATE, END_DATE END_DATE, DIFFERENTIAL DIFFERENTIAL, CURRENCY_CODE CURRENCY_CODE, MINIMUM_PAY MINIMUM_PAY, MEAN_PAY MEAN_PAY, MAXIMUM_PAY MAXIMUM_PAY, GRADUATE_PAY GRADUATE_PAY, STARTING_PAY STARTING_PAY, PERCENTAGE_CHANGE PERCENTAGE_CHANGE, 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, 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, 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, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, 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, STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE from "HR"."PER_SALARY_SURVEY_LINES"

View Text - HTML Formatted

SELECT OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SALARY_SURVEY_ID SALARY_SURVEY_ID
, SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, SURVEY_JOB_NAME_CODE SURVEY_JOB_NAME_CODE
, SURVEY_REGION_CODE SURVEY_REGION_CODE
, SURVEY_SENIORITY_CODE SURVEY_SENIORITY_CODE
, COMPANY_SIZE_CODE COMPANY_SIZE_CODE
, INDUSTRY_CODE INDUSTRY_CODE
, SURVEY_AGE_CODE SURVEY_AGE_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, DIFFERENTIAL DIFFERENTIAL
, CURRENCY_CODE CURRENCY_CODE
, MINIMUM_PAY MINIMUM_PAY
, MEAN_PAY MEAN_PAY
, MAXIMUM_PAY MAXIMUM_PAY
, GRADUATE_PAY GRADUATE_PAY
, STARTING_PAY STARTING_PAY
, PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, 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
, 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
, 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
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, 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
, STOCK_DISPLAY_TYPE STOCK_DISPLAY_TYPE
FROM "HR"."PER_SALARY_SURVEY_LINES"