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]

TABLE: PSB.PSB_DEFAULT_ASSIGNMENTS

Object Details

Object Name:	PSB_DEFAULT_ASSIGNMENTS
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_DEFAULT_ASSIGNMENTS
Subobject Name:
Status:	VALID

PSB_DEFAULT_ASSIGNMENTS stores information about default attributes
and element assignments for a position. ASSIGNMENT_TYPE
indicates if this is an attribute or element assignment. If it is an
element assignment, an element and the corresponding element
option or element value are specified. If it is an attribute
assignment, an attribute and a corresponding attribute value are
specified.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_DEFAULT_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEFAULT_ASSIGNMENT_ID
PSB_DEFAULT_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFAULT_RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEFAULT_ASSIGNMENT_ID	NUMBER	(20)	Yes	Default assignment unique identifier
DEFAULT_RULE_ID	NUMBER	(20)	Yes	Default rule unique identifier. Default rule this assignment belongs to.
ASSIGNMENT_TYPE	VARCHAR2	(10)	Yes	Indicates if this is an ATTRIBUTE or ELEMENT assignment
ATTRIBUTE_ID	NUMBER	(15)		Identifies the attribute for which this attribute assignment is made
ATTRIBUTE_VALUE_ID	NUMBER	(15)		Attribute value unique identifier. Identifier of the value assigned to this default assignment if the attribute has a value set table.
ATTRIBUTE_VALUE	VARCHAR2	(240)		Value assigned for the attribute in this default assignment when the attribute does not have a value set table
PAY_ELEMENT_ID	NUMBER	(20)		Pay element unique identifier. Element for which an assignment is made if it is an element assignment.
PAY_ELEMENT_OPTION_ID	NUMBER	(20)		Pay element option unique identifier. Identifier of the option assigned to this default rule if the element has an option table.
PAY_BASIS	VARCHAR2	(15)		Pay basis for the salary element
ELEMENT_VALUE_TYPE	VARCHAR2	(2)		Element value type. Valid values are A (Amount), F (Formula), or PS (Percent of Salary).
ELEMENT_VALUE	NUMBER			Override value assigned for the element in this default assignment
CURRENCY_CODE	VARCHAR2	(10)		Currency code for the element value
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		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 DEFAULT_ASSIGNMENT_ID
,      DEFAULT_RULE_ID
,      ASSIGNMENT_TYPE
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE_ID
,      ATTRIBUTE_VALUE
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
,      PAY_BASIS
,      ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE
,      CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_DEFAULT_ASSIGNMENTS;

Dependencies

[top of page]

PSB.PSB_DEFAULT_ASSIGNMENTS does not reference any database object

PSB.PSB_DEFAULT_ASSIGNMENTS is referenced by following:

APPS: PSB_DEFAULT_ASSIGNMENTS