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_SALARIES

Object Details

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

View Type

A Business Intelligence System view

This view shows the salary history for current and ex-employees, both approved and unapproved are shown. Use CURRENT EMPLOYEE FLAG to restrict between current or ex-employees.

[View Source]

Columns

Name	Datatype	Length
BUSINESS_GROUP_NAME	VARCHAR2	(240)
PERSON_NAME	VARCHAR2	(240)
ASSIGNMENT_NUMBER	VARCHAR2	(30)
ANNUAL_SALARY	NUMBER
EMPLOYEE_NUMBER	VARCHAR2	(30)
SALARY_CHANGE_DATE	DATE
SALARY_AMOUNT	NUMBER
ABSOLUTE_INCREMENT	NUMBER
PERCENTAGE_INCREMENT	NUMBER
SALARY_CHANGE_REASON	VARCHAR2	(4000)
APPROVED_FLAG	VARCHAR2	(4000)
PERFORMANCE_REVIEW_DATE	DATE
PERFORMANCE_RATING	VARCHAR2	(4000)
WORKING_HOURS_AMOUNT	NUMBER	(22)
WORKING_HOURS_FREQUENCY	VARCHAR2	(30)
ORGANIZATION_WORKING_HOURS	NUMBER
POSITION_WORKING_HOURS	NUMBER	(22)
ORG_WORKING_HOURS_FREQUENCY	VARCHAR2	(150)
POS_WORKING_HOURS_FREQUENCY	VARCHAR2	(30)
NUMBER_PER_FISCAL_YEAR	NUMBER	(15)
PAY_BASIS	VARCHAR2	(4000)
PREV_PAY_BASIS	VARCHAR2	(4000)
GRADE_RATE_BASIS	VARCHAR2	(30)
RANKING	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
SALARY_AMOUNT_UNIT_OF_MEASURE	VARCHAR2	(4000)
GRADE_COMPARATIO	NUMBER
HIRE_DATE	DATE
YEARS_SERVICE	NUMBER
MULTIPLE_COMPONENTS	VARCHAR2	(4000)
ORGANIZATION_NAME	VARCHAR2	(240)
JOB_NAME	VARCHAR2	(700)
POSITION_NAME	VARCHAR2	(240)
GRADE_NAME	VARCHAR2	(240)
LOCATION_NAME	VARCHAR2	(60)
NEXT_SALARY_REVIEW_DATE	DATE
SALARY_BASIS	VARCHAR2	(30)
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(4000)
OUTPUT_CURRENCY_CODE	VARCHAR2	(15)
_DF:PAYPRO	CHAR	(29)
_DF:ELENTR	CHAR	(31)
ASSIGNMENT_ID	NUMBER	(10)
BUSINESS_GROUP_ID	NUMBER	(15)
ELEMENT_ENTRY_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
PAY_PROPOSAL_ID	NUMBER	(15)
PERFORMANCE_REVIEW_ID	NUMBER	(15)
PERSON_ID	NUMBER	(10)
RATE_ID	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      ASSIGNMENT_NUMBER
,      ANNUAL_SALARY
,      EMPLOYEE_NUMBER
,      SALARY_CHANGE_DATE
,      SALARY_AMOUNT
,      ABSOLUTE_INCREMENT
,      PERCENTAGE_INCREMENT
,      SALARY_CHANGE_REASON
,      APPROVED_FLAG
,      PERFORMANCE_REVIEW_DATE
,      PERFORMANCE_RATING
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      ORGANIZATION_WORKING_HOURS
,      POSITION_WORKING_HOURS
,      ORG_WORKING_HOURS_FREQUENCY
,      POS_WORKING_HOURS_FREQUENCY
,      NUMBER_PER_FISCAL_YEAR
,      PAY_BASIS
,      PREV_PAY_BASIS
,      GRADE_RATE_BASIS
,      RANKING
,      CURRENCY_CODE
,      SALARY_AMOUNT_UNIT_OF_MEASURE
,      GRADE_COMPARATIO
,      HIRE_DATE
,      YEARS_SERVICE
,      MULTIPLE_COMPONENTS
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      LOCATION_NAME
,      NEXT_SALARY_REVIEW_DATE
,      SALARY_BASIS
,      CURRENT_EMPLOYEE_FLAG
,      OUTPUT_CURRENCY_CODE
,      _DF:PAYPRO
,      _DF:ELENTR
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      ELEMENT_ENTRY_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      LOCATION_ID
,      PAY_PROPOSAL_ID
,      PERFORMANCE_REVIEW_ID
,      PERSON_ID
,      RATE_ID
FROM APPS.HRFV_SALARIES;

Dependencies

[top of page]

APPS.HRFV_SALARIES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_ORGANIZATION_INFORMATION; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PAY_ALL_PAYROLLS_F; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_ELEMENT_TYPES_F; PAY_INPUT_VALUES_F; PER_ALL_POSITIONS; PER_ASSIGNMENTS_F; PER_EVENTS; PER_GRADES_TL; PER_JOBS_TL; PER_PAY_BASES; PER_PAY_PROPOSALS; PER_PEOPLE_F; PER_PERFORMANCE_REVIEWS; PER_PERIODS_OF_SERVICE; PER_PERSON_TYPES; PER_TIME_PERIOD_TYPES; PER_VIEWS_PKG - show dependent code

APPS.HRFV_SALARIES is not referenced by any database object