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]

TABLE: HR.PER_SALARY_SURVEY_LINES

Object Details

Object Name:	PER_SALARY_SURVEY_LINES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_SALARY_SURVEY_LINES
Subobject Name:
Status:	VALID

PER_SALARY_SURVEY_LINES stores individual lines of salary survey information which comprise a salary survey indentified in PER_SALARY_SURVEYS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_SALARY_SURVEY_LINES_PK

SALARY_SURVEY_LINE_ID

Unique Key: PER_SALARY_SURVEY_LINES_UK1

START_DATE
INDUSTRY_CODE
COMPANY_SIZE_CODE
SURVEY_SENIORITY_CODE
SURVEY_REGION_CODE
SURVEY_JOB_NAME_CODE
SURVEY_AGE_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_SALARY_SURVEY_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SALARY_SURVEY_LINE_ID
PER_SALARY_SURVEY_LINES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	START_DATE INDUSTRY_CODE COMPANY_SIZE_CODE SURVEY_SENIORITY_CODE SURVEY_REGION_CODE SURVEY_JOB_NAME_CODE SURVEY_AGE_CODE
PER_SALARY_SURVEY_LINES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALARY_SURVEY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_SALARY_SURVEY_LINES		PER_SALARY_SURVEYS	PER_SALARY_SURVEY_LINES SALARY_SURVEY_ID
PER_SALARY_SURVEY_MAPPINGS		PER_SALARY_SURVEY_LINES	PER_SALARY_SURVEY_MAPPINGS SALARY_SURVEY_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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 PER_SALARY_SURVEYS.
SALARY_SURVEY_LINE_ID	NUMBER	(15)	Yes	System-generated primary key column.
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.
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 pay figures for the survey line are above or below the specified base region average .
CURRENCY_CODE	VARCHAR2	(15)		Foreign Key to FND_CURRENCIES
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			Minimum Salary Increase
MEAN_SALARY_INCREASE	NUMBER			Mean Salary Increase
MAXIMUM_SALARY_INCREASE	NUMBER			Maximum Salary Increase
MIN_VARIABLE_COMPENSATION	NUMBER			Minimum Variable compensation
MEAN_VARIABLE_COMPENSATION	NUMBER			Mean Variable Compensation
MAX_VARIABLE_COMPENSATION	NUMBER			Maximum Variable Compensation
MINIMUM_STOCK	NUMBER			Minimum Stock
MEAN_STOCK	NUMBER			Mean Stock
MAXIMUM_STOCK	NUMBER			Maximum Stock
STOCK_DISPLAY_TYPE	VARCHAR2	(30)		Stock Display Type

Query Text

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


SELECT OBJECT_VERSION_NUMBER
,      SALARY_SURVEY_ID
,      SALARY_SURVEY_LINE_ID
,      SURVEY_JOB_NAME_CODE
,      SURVEY_REGION_CODE
,      SURVEY_SENIORITY_CODE
,      COMPANY_SIZE_CODE
,      INDUSTRY_CODE
,      SURVEY_AGE_CODE
,      START_DATE
,      END_DATE
,      DIFFERENTIAL
,      CURRENCY_CODE
,      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
,      MINIMUM_STOCK
,      MEAN_STOCK
,      MAXIMUM_STOCK
,      STOCK_DISPLAY_TYPE
FROM HR.PER_SALARY_SURVEY_LINES;

Dependencies

[top of page]

HR.PER_SALARY_SURVEY_LINES does not reference any database object

HR.PER_SALARY_SURVEY_LINES is referenced by following:

HR: PER_SALARY_SURVEY_LINES#