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_POSITION_ASSIGNMENTS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_POSITION_ASSIGNMENTS displays all position element assignments.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_NAME	VARCHAR2	(30)		Element name
_KF:POSITION_NAME	CHAR	(20)		Position name. Concatenated position Key Flexfield segments.
OPTION_NAME	VARCHAR2	(80)		Element option name
GRADE_STEP	NUMBER			Grade step
_LA:PAY_BASIS	CHAR	(51)		Salary basis
_LA:ELEMENT_VALUE_TYPE	CHAR	(69)		Element value type
ELEMENT_VALUE	NUMBER			Element value
CURRENCY_CODE	VARCHAR2	(15)		Currency code
START_EFFECTIVE_DATE	DATE		Yes	Effective start date
END_EFFECTIVE_DATE	DATE			Effective end date
WORKSHEET_NAME	VARCHAR2	(80)		Worksheet name
ELEMENT_OR_SALARY	VARCHAR2	(7)		Indicates if salary element
SALARY_TYPE	VARCHAR2	(10)		Salary type
POSITION_ID	NUMBER		Yes	Position unique identifier
POSITION_ASSIGNMENT_ID	NUMBER	(15)	Yes	Position assignment unique identifier
WORKSHEET_ID	NUMBER	(20)		Worksheet unique identifier. Null for base assignments or worksheet identifier for worksheet specific assignment.
PAY_ELEMENT_ID	NUMBER	(20)		Pay element identifier
PAY_ELEMENT_OPTION_ID	NUMBER	(20)		Pay element option identifier

Query Text

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


SELECT ELEMENT_NAME
,      _KF:POSITION_NAME
,      OPTION_NAME
,      GRADE_STEP
,      _LA:PAY_BASIS
,      _LA:ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      CURRENCY_CODE
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      WORKSHEET_NAME
,      ELEMENT_OR_SALARY
,      SALARY_TYPE
,      POSITION_ID
,      POSITION_ASSIGNMENT_ID
,      WORKSHEET_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
FROM APPS.PSBFV_POSITION_ASSIGNMENTS;

Dependencies

[top of page]

APPS.PSBFV_POSITION_ASSIGNMENTS references the following:

APPS: PSB_PAY_ELEMENTS; PSB_PAY_ELEMENT_OPTIONS; PSB_POSITIONS; PSB_POSITION_ASSIGNMENTS; PSB_POSITION_DEFINITIONS_KFV; PSB_WORKSHEETS

APPS.PSBFV_POSITION_ASSIGNMENTS is not referenced by any database object