[Home] [Help] [Dependency Information]
Object Name: | PSBBV_POSITION_ASSIGNMENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_POSITION_ASSIGNMENTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBBV_POSITION_ASSIGNMENTS displays all position element assignments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELEMENT_VALUE | NUMBER | Element value | ||
_LA:ELEMENT_VALUE_TYPE | CHAR | (65) | Type of element value | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
_LA:PAY_BASIS | CHAR | (47) | Salary basis | |
START_EFFECTIVE_DATE | DATE | Yes | Effective start date | |
END_EFFECTIVE_DATE | DATE | Effective end date | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_VALUE
, _LA:ELEMENT_VALUE_TYPE
, CURRENCY_CODE
, _LA:PAY_BASIS
, START_EFFECTIVE_DATE
, END_EFFECTIVE_DATE
, POSITION_ID
, POSITION_ASSIGNMENT_ID
, WORKSHEET_ID
, PAY_ELEMENT_ID
, PAY_ELEMENT_OPTION_ID
FROM APPS.PSBBV_POSITION_ASSIGNMENTS;
APPS.PSBBV_POSITION_ASSIGNMENTS is not referenced by any database object
|
|
|