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.HRFV_SALARY_SURVEY_MAPPINGS

Object Details

Object Name:	HRFV_SALARY_SURVEY_MAPPINGS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_SALARY_SURVEY_MAPPINGS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows salary surveys that have been mapped to a job or position

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
JOB_NAME	VARCHAR2	(700)
POSITION_NAME	VARCHAR2	(240)
GRADE_NAME	VARCHAR2	(240)
LOCATION_NAME	VARCHAR2	(60)
COMPANY_AGE	VARCHAR2	(4000)
SURVEY_NAME	VARCHAR2	(255)	Yes
SURVEY_COMPANY	VARCHAR2	(4000)
SURVEY_IDENTIFIER	VARCHAR2	(2)	Yes
SURVEY_CURRENCY	VARCHAR2	(0)
SURVEY_TYPE	VARCHAR2	(4000)
BASE_REGION	VARCHAR2	(30)
SURVEY_JOB_NAME	VARCHAR2	(4000)
SURVEY_REGION	VARCHAR2	(4000)
SURVEY_SENIORITY	VARCHAR2	(4000)
COMPANY_SIZE	VARCHAR2	(4000)
INDUSTRY	VARCHAR2	(4000)
SURVEY_AGE	VARCHAR2	(4000)
LINE_START_DATE	DATE		Yes
LINE_END_DATE	DATE
DIFFERENTIAL	NUMBER
LINE_CURRENCY	VARCHAR2	(80)
MINIMUM_PAY	NUMBER
MEAN_PAY	NUMBER
MAXIMUM_PAY	NUMBER
GRADUATE_PAY	NUMBER
STARTING_PAY	NUMBER
PERCENTAGE_CHANGE	NUMBER
JOB_FIRST_QUARTILE	NUMBER
JOB_MEDIAN_QUARTILE	NUMBER
JOB_THIRD_QUARTILE	NUMBER
JOB_FOURTH_QUARTILE	NUMBER
MINIMUM_TOTAL_COMPENSATION	NUMBER
MEAN_TOTAL_COMPENSATION	NUMBER
MAXIMUM_TOTAL_COMPENSATION	NUMBER
COMPENSATION_FIRST_QUARTILE	NUMBER
COMPENSATION_MEDIAN_QUARTILE	NUMBER
COMPENSATION_THIRD_QUARTILE	NUMBER
COMPENSATION_FOURTH_QUARTILE	NUMBER
_DF:SURVEY	CHAR	(30)
_DF:LINE	CHAR	(35)
_DF:MAPPING	CHAR	(38)
SALARY_SURVEY_ID	NUMBER	(15)	Yes
SALARY_SURVEY_LINE_ID	NUMBER	(15)	Yes
SALARY_SURVEY_MAPPING_ID	NUMBER	(15)	Yes
JOB_ID	NUMBER
POSITION_ID	NUMBER
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
LOCATION_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      LOCATION_NAME
,      COMPANY_AGE
,      SURVEY_NAME
,      SURVEY_COMPANY
,      SURVEY_IDENTIFIER
,      SURVEY_CURRENCY
,      SURVEY_TYPE
,      BASE_REGION
,      SURVEY_JOB_NAME
,      SURVEY_REGION
,      SURVEY_SENIORITY
,      COMPANY_SIZE
,      INDUSTRY
,      SURVEY_AGE
,      LINE_START_DATE
,      LINE_END_DATE
,      DIFFERENTIAL
,      LINE_CURRENCY
,      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
,      COMPENSATION_FIRST_QUARTILE
,      COMPENSATION_MEDIAN_QUARTILE
,      COMPENSATION_THIRD_QUARTILE
,      COMPENSATION_FOURTH_QUARTILE
,      _DF:SURVEY
,      _DF:LINE
,      _DF:MAPPING
,      SALARY_SURVEY_ID
,      SALARY_SURVEY_LINE_ID
,      SALARY_SURVEY_MAPPING_ID
,      JOB_ID
,      POSITION_ID
,      BUSINESS_GROUP_ID
,      LOCATION_ID
,      GRADE_ID
,      ORGANIZATION_ID
FROM APPS.HRFV_SALARY_SURVEY_MAPPINGS;

Dependencies

[top of page]

APPS.HRFV_SALARY_SURVEY_MAPPINGS references the following:

APPS: FND_CURRENCIES_VL; HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_BIS - show dependent code; HR_LOCATIONS_ALL_TL; PER_GRADES_TL; PER_JOBS_TL; PER_SALARY_SURVEYS; PER_SALARY_SURVEY_LINES; PER_SALARY_SURVEY_MAPPINGS

APPS.HRFV_SALARY_SURVEY_MAPPINGS is referenced by following:

PUBLIC: HRFV_SALARY_SURVEY_MAPPINGS