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

Object Details

Object Name:	PSBBV_PAY_ELEMENT_RATES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSBBV_PAY_ELEMENT_RATES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PSBBV_PAY_ELEMENT_RATES displays the rates for a pay element or an option of the pay element depending on the definition of the pay element. The rates defined here can be flat amount or percent of salary depending on the element definition. Rates are stored by effective date ranges. A given element or element option can have a different rate for different time periods. Pay element rates can be modified for a specific worksheet using parameters. WORKSHEET_ID is not null for Worksheet specific element rates and is null for all base element rates.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
_LA:ELEMENT_VALUE_TYPE	CHAR	(69)		Type of pay element value. Values are Percent of Salary, Amount, and Percent Increase.
ELEMENT_VALUE	NUMBER			Element value
_LA:PAY_BASIS	CHAR	(51)		Salary pay basis. Values are Hourly, Monthly, Period, or Annual.
MAXIMUM_VALUE	NUMBER			Maximum amount for a Grade Rate element
MID_VALUE	NUMBER			Mid value for a Grade Rate element
MINIMUM_VALUE	NUMBER			Minimum amount for a Grade Rate element
CURRENCY_CODE	VARCHAR2	(15)		Currency code for the rate
PAY_ELEMENT_RATE_ID	NUMBER	(15)	Yes	Pay element rate unique identifier
PAY_ELEMENT_OPTION_ID	NUMBER	(20)		Pay element option unique identifier
WORKSHEET_ID	NUMBER	(20)		Worksheet unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _LA:ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      _LA:PAY_BASIS
,      MAXIMUM_VALUE
,      MID_VALUE
,      MINIMUM_VALUE
,      CURRENCY_CODE
,      PAY_ELEMENT_RATE_ID
,      PAY_ELEMENT_OPTION_ID
,      WORKSHEET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBBV_PAY_ELEMENT_RATES;

Dependencies

[top of page]

APPS.PSBBV_PAY_ELEMENT_RATES references the following:

APPS: PSB_PAY_ELEMENT_RATES

APPS.PSBBV_PAY_ELEMENT_RATES is not referenced by any database object