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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PER_SALARY_SURVEY_V

Object Details

Object Name:	PER_SALARY_SURVEY_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SURVEY_NAME	VARCHAR2	(255)	Yes	Survey Name
IDENTIFIER	VARCHAR2	(2)	Yes	Identifier
SURVEY_COMPANY	VARCHAR2	(80)		Survey Company which provided the data
SURVEY_TYPE	VARCHAR2	(80)		Type of Survey
BASE_REGION	VARCHAR2	(30)		Base Region
SALARY_SURVEY_LINE_ID	NUMBER	(15)	Yes	Line Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
SALARY_SURVEY_ID	NUMBER	(15)	Yes	Salary Survey Identifier
SURVEY_JOB_NAME_CODE	VARCHAR2	(30)	Yes	Job Code
SURVEY_REGION_CODE	VARCHAR2	(30)		Region Code
SURVEY_SENIORITY_CODE	VARCHAR2	(30)		Seniority Code
COMPANY_SIZE_CODE	VARCHAR2	(30)		Company Size
INDUSTRY_CODE	VARCHAR2	(30)		Industry Code
SURVEY_AGE_CODE	VARCHAR2	(30)		Survey Age Code
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
SURVEY_JOB_NAME	VARCHAR2	(80)		Job Name
SURVEY_REGION	VARCHAR2	(80)		Region Name
SURVEY_SENIORITY	VARCHAR2	(80)		Seniority
COMPANY_SIZE	VARCHAR2	(80)		Company Size
INDUSTRY	VARCHAR2	(80)		Industry
SURVEY_AGE	VARCHAR2	(80)		Survey Age
CURRENCY	VARCHAR2	(80)		Currency
START_DATE	DATE		Yes	Start Date
END_DATE	DATE			End Date
DIFFERENTIAL	NUMBER			Differential
MINIMUM_PAY	NUMBER			Min Pay
MEAN_PAY	NUMBER			Mean Pay
MAXIMUM_PAY	NUMBER			Max Pay
GRADUATE_PAY	NUMBER			Graduate Pay
STARTING_PAY	NUMBER			Starting Pay
PERCENTAGE_CHANGE	NUMBER			Percentage Change
JOB_FIRST_QUARTILE	NUMBER			Job First Quartile
JOB_MEDIAN_QUARTILE	NUMBER			Job Median Quartile
JOB_THIRD_QUARTILE	NUMBER			Job Third Quartile
JOB_FOURTH_QUARTILE	NUMBER			Job Fourth Quartile
MINIMUM_TOTAL_COMPENSATION	NUMBER			Min Total Compensation
MEAN_TOTAL_COMPENSATION	NUMBER			Mean Total Compensation
MAXIMUM_TOTAL_COMPENSATION	NUMBER			Max Total Compensation
COMPNSTN_FIRST_QUARTILE	NUMBER			Compensation First Quartile
COMPNSTN_MEDIAN_QUARTILE	NUMBER			Compensation Median Quartile
COMPNSTN_THIRD_QUARTILE	NUMBER			Compensation Third Quartile
COMPNSTN_FOURTH_QUARTILE	NUMBER			Compensation Fourth Quartile
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield
TENTH_PERCENTILE	NUMBER			Tenth Percentile
TWENTY_FIFTH_PERCENTILE	NUMBER			Twentyfifth Percentile
FIFTIETH_PERCENTILE	NUMBER			Fiftieth Percentile
SEVENTY_FIFTH_PERCENTILE	NUMBER			Seventy fifth Percentile
NINETIETH_PERCENTILE	NUMBER			Ninetieth Percentile
MINIMUM_BONUS	NUMBER			Min Bonus
MEAN_BONUS	NUMBER			Mean Bonus
MAXIMUM_BONUS	NUMBER			Max Bonus
MINIMUM_SALARY_INCREASE	NUMBER			Min Salary Increase
MEAN_SALARY_INCREASE	NUMBER			Mean Salary Increase
MAXIMUM_SALARY_INCREASE	NUMBER			Max Salary Increase
MIN_VARIABLE_COMPENSATION	NUMBER			Min Variable Compensation
MEAN_VARIABLE_COMPENSATION	NUMBER			Mean Variable Compensation
MAX_VARIABLE_COMPENSATION	NUMBER			Max Variable Compensation
STOCK_DISPLAY_TYPE	VARCHAR2	(80)		Stock Display Type
MINIMUM_STOCK	NUMBER			Min Stock
MEAN_STOCK	NUMBER			Mean Stock
MAXIMUM_STOCK	NUMBER			Maximum Stock
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
ROW_ID	ROWID	(10)		Row Identifier
STOCK_DISPLAY_TYPE_CODE	VARCHAR2	(30)		Stock display type Code

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SURVEY_NAME
,      IDENTIFIER
,      SURVEY_COMPANY
,      SURVEY_TYPE
,      BASE_REGION
,      SALARY_SURVEY_LINE_ID
,      OBJECT_VERSION_NUMBER
,      SALARY_SURVEY_ID
,      SURVEY_JOB_NAME_CODE
,      SURVEY_REGION_CODE
,      SURVEY_SENIORITY_CODE
,      COMPANY_SIZE_CODE
,      INDUSTRY_CODE
,      SURVEY_AGE_CODE
,      CURRENCY_CODE
,      SURVEY_JOB_NAME
,      SURVEY_REGION
,      SURVEY_SENIORITY
,      COMPANY_SIZE
,      INDUSTRY
,      SURVEY_AGE
,      CURRENCY
,      START_DATE
,      END_DATE
,      DIFFERENTIAL
,      MINIMUM_PAY
,      MEAN_PAY
,      MAXIMUM_PAY
,      GRADUATE_PAY
,      STARTING_PAY
,      PERCENTAGE_CHANGE
,      JOB_FIRST_QUARTILE
,      JOB_MEDIAN_QUARTILE
,      JOB_THIRD_QUARTILE
,      JOB_FOURTH_QUARTILE
,      MINIMUM_TOTAL_COMPENSATION
,      MEAN_TOTAL_COMPENSATION
,      MAXIMUM_TOTAL_COMPENSATION
,      COMPNSTN_FIRST_QUARTILE
,      COMPNSTN_MEDIAN_QUARTILE
,      COMPNSTN_THIRD_QUARTILE
,      COMPNSTN_FOURTH_QUARTILE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      TENTH_PERCENTILE
,      TWENTY_FIFTH_PERCENTILE
,      FIFTIETH_PERCENTILE
,      SEVENTY_FIFTH_PERCENTILE
,      NINETIETH_PERCENTILE
,      MINIMUM_BONUS
,      MEAN_BONUS
,      MAXIMUM_BONUS
,      MINIMUM_SALARY_INCREASE
,      MEAN_SALARY_INCREASE
,      MAXIMUM_SALARY_INCREASE
,      MIN_VARIABLE_COMPENSATION
,      MEAN_VARIABLE_COMPENSATION
,      MAX_VARIABLE_COMPENSATION
,      STOCK_DISPLAY_TYPE
,      MINIMUM_STOCK
,      MEAN_STOCK
,      MAXIMUM_STOCK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ROW_ID
,      STOCK_DISPLAY_TYPE_CODE
FROM APPS.PER_SALARY_SURVEY_V;

Dependencies

[top of page]

APPS.PER_SALARY_SURVEY_V references the following:

APPS: FND_CURRENCIES_TL; HR_API - show dependent code; HR_LOOKUPS; PER_SALARY_SURVEYS; PER_SALARY_SURVEY_LINES

APPS.PER_SALARY_SURVEY_V is not referenced by any database object