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_LINES_V

Object Details

Object Name:	PER_SALARY_SURVEY_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_SALARY_SURVEY_LINES_V
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
ROW_ID	ROWID	(10)		Row Identifier
SALARY_SURVEY_LINE_ID	NUMBER	(15)	Yes	System-generated primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
SALARY_SURVEY_ID	NUMBER	(15)	Yes	Foreign key to enable join to PER_SALARY_SURVEYS.
SURVEY_JOB_NAME_CODE	VARCHAR2	(30)	Yes	Code representing the Job type that this survey line applies to. User Defined Lookup.
SURVEY_REGION_CODE	VARCHAR2	(30)		Code representing the Region that this survey line applies to. User Defined Lookup.
SURVEY_SENIORITY_CODE	VARCHAR2	(30)		Code representing the Seniority that this survey line applies to. User Defined Lookup.
COMPANY_SIZE_CODE	VARCHAR2	(30)		Code representing the size of the company that the survey line applies to. User Defined Lookup.
INDUSTRY_CODE	VARCHAR2	(30)		Code representing the industry associated with the survey line. User Defined Lookup.
SURVEY_AGE_CODE	VARCHAR2	(30)		Code representing the Survey Age for the survey line.
CURRENCY_CODE	VARCHAR2	(15)
SURVEY_JOB_NAME	VARCHAR2	(80)		The Job type that this survey line applies to. User Defined Lookup.
SURVEY_REGION	VARCHAR2	(80)		The Region that this survey line applies to. User Defined Lookup.
SURVEY_SENIORITY	VARCHAR2	(80)		The Seniority that this survey line applies to. User Defined Lookup.
COMPANY_SIZE	VARCHAR2	(80)		The size of the company that the survey line applies to. User Defined Lookup.
INDUSTRY	VARCHAR2	(80)		The industry associated with the survey line. User Defined Lookup.
SURVEY_AGE	VARCHAR2	(80)		Survey Age for the survey line.
CURRENCY	VARCHAR2	(80)
START_DATE	DATE		Yes	The date from which the the data in the survey line applies.
END_DATE	DATE			The date after which the data in the survey line no longer applies.
DIFFERENTIAL	NUMBER			A percentage representing the amount by which the pay figures for the survey line are above or below the specified base region average .
MINIMUM_PAY	NUMBER			The Minimum Pay for this job.
MEAN_PAY	NUMBER			The Mean Pay for this job.
MAXIMUM_PAY	NUMBER			The Maximum Pay for this job.
GRADUATE_PAY	NUMBER			The graduate Pay for this job.
STARTING_PAY	NUMBER			The Minimum Pay for this job.
PERCENTAGE_CHANGE	NUMBER			The Percentage change in pay for this job.
JOB_FIRST_QUARTILE	NUMBER			The First Quartile for this job.
JOB_MEDIAN_QUARTILE	NUMBER			The Median Quartile for this job.
JOB_THIRD_QUARTILE	NUMBER			The Third Quartile for this job.
JOB_FOURTH_QUARTILE	NUMBER			The Fourth Quartile for this job.
MINIMUM_TOTAL_COMPENSATION	NUMBER			The Minimum Total Compensation for this job.
MEAN_TOTAL_COMPENSATION	NUMBER			The Mean Total Compensation for this job.
MAXIMUM_TOTAL_COMPENSATION	NUMBER			The maximum total compensation for this job.
COMPNSTN_FIRST_QUARTILE	NUMBER			First Quartile for the compensation in the survey line.
COMPNSTN_MEDIAN_QUARTILE	NUMBER			Median Quartile for the compensation in the survey line.
COMPNSTN_THIRD_QUARTILE	NUMBER			Third Quartile for the compensation in the survey line.
COMPNSTN_FOURTH_QUARTILE	NUMBER			Fourth Quartile for the compensation in the survey line.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
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.
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			Twenty Fifth Percentile
FIFTIETH_PERCENTILE	NUMBER			Fiftieth Percentile
SEVENTY_FIFTH_PERCENTILE	NUMBER			Seventy fifth Percentile
NINETIETH_PERCENTILE	NUMBER			Ninetieth Percentile
MINIMUM_BONUS	NUMBER			Minimum Bonus
MEAN_BONUS	NUMBER			Mean Bonus
MAXIMUM_BONUS	NUMBER			Maximum Bonus
MINIMUM_SALARY_INCREASE	NUMBER			Minumum Salary Increase
MEAN_SALARY_INCREASE	NUMBER			Mean Salary Increase
MAXIMUM_SALARY_INCREASE	NUMBER			Maximum Salry Increase
MIN_VARIABLE_COMPENSATION	NUMBER			Minimum Variable Compensation
MEAN_VARIABLE_COMPENSATION	NUMBER			Mean Variable Compensation
MAX_VARIABLE_COMPENSATION	NUMBER			Maximum Variable Compensation
STOCK_DISPLAY_TYPE	VARCHAR2	(80)		Stock Display Type
MINIMUM_STOCK	NUMBER			Minimum Stock
MEAN_STOCK	NUMBER			Mean Stock
MAXIMUM_STOCK	NUMBER			Maximum Stock
STOCK_DISPLAY_TYPE_CODE	VARCHAR2	(30)		Stock Display Type Code

Query Text

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


SELECT ROW_ID
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      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
,      STOCK_DISPLAY_TYPE_CODE
FROM APPS.PER_SALARY_SURVEY_LINES_V;

Dependencies

[top of page]

APPS.PER_SALARY_SURVEY_LINES_V references the following:

APPS: FND_CURRENCIES_VL; HR_API - show dependent code; HR_LOOKUPS; PER_SALARY_SURVEY_LINES

APPS.PER_SALARY_SURVEY_LINES_V is not referenced by any database object