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_DEFAULT_ASSIGNMENTS

Object Details

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

View Type

A Business Intelligence System view

PSBFV_DEFAULT_ASSIGNMENTS displays information about default attributes and element assignments for a position. The assignment type indicates if this is an attribute or element assignment. If it is an element assignment, then an element and the corresponding element
option or element value are specified. If it is an attribute assignment, then an attribute and a corresponding attribute value are specified.

[View Source]

Columns

Name	Datatype	Length	Comments
DEFAULT_RULE_NAME	VARCHAR2	(30)	Default rule name to which an attribute or element is associated
_LA:ASSIGNMENT_TYPE	CHAR	(63)	Indicates if Attribute or Element assignment
ATTRIBUTE_NAME	VARCHAR2	(30)	Attribute name for which assignment is made
ATTRIBUTE_VALUE	VARCHAR2	(240)	Value assigned for the attribute in this default assignment
PAY_ELEMENT_NAME	VARCHAR2	(30)	Element name for which assignment is made
_LA:PAY_BASIS	CHAR	(51)	Pay basis for salary element
_LA:ELEMENT_VALUE_TYPE	CHAR	(68)	Element value type. Values are Amount, Formula, or Percent of Salary.
ELEMENT_VALUE	NUMBER		Value assigned for the element in this default assignment
CURRENCY_CODE	VARCHAR2	(10)	Currency code for the element value
GRADE_STEP	NUMBER		Grade step for salary element
DEFAULT_ASSIGNMENT_ID	NUMBER	(20)	Default assignment unique identifier
DEFAULT_RULE_ID	NUMBER	(20)	Default rule unique identifier. Default rule to which assignment belongs.
ATTRIBUTE_ID	NUMBER	(15)	Attribute for which assignment is made
ATTRIBUTE_VALUE_ID	NUMBER	(15)	Identifier of attribute value assigned to default assignment
PAY_ELEMENT_ID	NUMBER	(20)	Element for which assignment is made if it is an element assignment
PAY_ELEMENT_OPTION_ID	NUMBER	(20)	Element option identifier assigned to the default rule if the element has an option table
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column

Query Text

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


SELECT DEFAULT_RULE_NAME
,      _LA:ASSIGNMENT_TYPE
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE
,      PAY_ELEMENT_NAME
,      _LA:PAY_BASIS
,      _LA:ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      CURRENCY_CODE
,      GRADE_STEP
,      DEFAULT_ASSIGNMENT_ID
,      DEFAULT_RULE_ID
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSBFV_DEFAULT_ASSIGNMENTS;

Dependencies

[top of page]

APPS.PSBFV_DEFAULT_ASSIGNMENTS references the following:

APPS: PSB_ATTRIBUTES; PSB_DEFAULTS; PSB_DEFAULT_ASSIGNMENTS; PSB_PAY_ELEMENTS; PSB_PAY_ELEMENT_OPTIONS

APPS.PSBFV_DEFAULT_ASSIGNMENTS is not referenced by any database object