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

Object Details

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

View Type

A Business Intelligence System view

PSBFV_PAY_ELEMENTS displays information about the pay elements.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(30)	Yes	Pay element name
DATA_EXTRACT_NAME	VARCHAR2	(30)	Yes	Data extract name
DESCRIPTION	VARCHAR2	(240)		Description for the pay element
_LA:ELEMENT_VALUE_TYPE	CHAR	(68)		Type of element value. A indicates Amount, P indicates Percent, PI indicates Percent Increase, or PS indicates Percent of Salary.
OVERWRITE_FLAG	VARCHAR2	(1)		Indicates if this element can be overwritten
REQUIRED_FLAG	VARCHAR2	(1)		Indicates if this element is required
FOLLOW_SALARY	VARCHAR2	(1)		Indicates if this element follows salary distribution
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
_LA:PROCESSING_TYPE	CHAR	(62)		Processing type for the element. N indicates Non-Recurring or R indicates Recurring.
_LA:PERIOD_TYPE	CHAR	(54)		HRMS period type
_LA:PROCESS_PERIOD_TYPE	CHAR	(70)		Calculation period the cost must be charged to if the element period is larger than the calculation period. Values are First or Last.
_LA:MAX_ELEMENT_VALUE_TYPE	CHAR	(76)		Value type for the maximum element value. A indicates Amount or P indicates Percent.
MAX_ELEMENT_VALUE	NUMBER	(20)		Maximum element value associated with element
SALARY_FLAG	VARCHAR2	(1)	Yes	Indicates if the element is a salary element
_LA:SALARY_TYPE	CHAR	(54)		Indicates salary type for element. Values are Rate or Step.
OPTION_FLAG	VARCHAR2	(1)		Indicates if the element has options
PAY_ELEMENT_ID	NUMBER	(20)	Yes	Pay element unique identifier
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group identifier
DATA_EXTRACT_ID	NUMBER	(20)	Yes	Data extract identifier used to identify data for pay elements
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		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 NAME
,      DATA_EXTRACT_NAME
,      DESCRIPTION
,      _LA:ELEMENT_VALUE_TYPE
,      OVERWRITE_FLAG
,      REQUIRED_FLAG
,      FOLLOW_SALARY
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _LA:PROCESSING_TYPE
,      _LA:PERIOD_TYPE
,      _LA:PROCESS_PERIOD_TYPE
,      _LA:MAX_ELEMENT_VALUE_TYPE
,      MAX_ELEMENT_VALUE
,      SALARY_FLAG
,      _LA:SALARY_TYPE
,      OPTION_FLAG
,      PAY_ELEMENT_ID
,      BUSINESS_GROUP_ID
,      DATA_EXTRACT_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_PAY_ELEMENTS;

Dependencies

[top of page]

APPS.PSBFV_PAY_ELEMENTS references the following:

APPS: PSB_DATA_EXTRACTS; PSB_PAY_ELEMENTS

APPS.PSBFV_PAY_ELEMENTS is not referenced by any database object