[Home] [Help] [Dependency Information]
Object Name: | PSB_POSITION_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_POSITION_ASSIGNMENTS |
Subobject Name: | |
Status: | VALID |
PSB_POSITION_ASSIGNMENTS holds information about position assignments.
Each position can have multiple assignments. The
ASSIGNMENT_TYPE is ATTRIBUTE for Attributes, ELEMENT for
Element, and EMPLOYEE for employee assignments. A position can have
mandatory attributes and user-defined attributes. A position can also
have salary or non-salary elements.
Each position has base assignments which are available to all
worksheets using that position. The worksheet process can choose to
use the base assignments or create new assignments to support a
what-if scenario, in which case the Worksheet ID is stored.
Attribute values and element values are stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_POSITION_ASSIGNMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | POSITION_ASSIGNMENT_ID |
PSB_POSITION_ASSIGNMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POSITION_ID |
PSB_POSITION_ASSIGNMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WORKSHEET_ID |
PSB_POSITION_ASSIGNMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAY_ELEMENT_ID |
PSB_POSITION_ASSIGNMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EMPLOYEE_ID |
PSB_POSITION_ASSIGNMENTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DATA_EXTRACT_ID |
PSB_POSITION_ASSIGNMENTS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_ID
DATA_EXTRACT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_ASSIGNMENT_ID | NUMBER | (15) | Yes | Position assignment unique identifier |
DATA_EXTRACT_ID | NUMBER | (20) | Yes | Data extract unique identifier |
WORKSHEET_ID | NUMBER | (20) | Unique identifier for worksheet or budget revision. Null value indicates base assignment for the data extract and worksheet identifier indicates assignment specific to worksheet or budget revision. | |
POSITION_ID | NUMBER | Yes | Position unique identifier | |
ASSIGNMENT_TYPE | VARCHAR2 | (10) | Yes | Assignment type is ATTRIBUTE, ELEMENT, or EMPLOYEE |
ATTRIBUTE_ID | NUMBER | (20) | Attribute unique identifier | |
ATTRIBUTE_VALUE_ID | NUMBER | (20) | Attribute value unique identifier | |
ATTRIBUTE_VALUE | VARCHAR2 | (240) | Attribute value | |
PAY_ELEMENT_ID | NUMBER | (20) | Pay element unique identifier | |
PAY_ELEMENT_OPTION_ID | NUMBER | (20) | Pay element option unique identifier | |
PAY_ELEMENT_RATE_ID | NUMBER | (15) | No longer used | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date | |
EFFECTIVE_END_DATE | DATE | Effective end date | ||
ELEMENT_VALUE_TYPE | VARCHAR2 | (2) | Element value type | |
ELEMENT_VALUE | NUMBER | Element value. Null if using default value for element rate. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
PAY_BASIS | VARCHAR2 | (10) | Time basis for recording salary values is ANNUAL, HOURLY, MONTHLY or PERIOD | |
EMPLOYEE_ID | NUMBER | (20) | Employee unique identifier | |
PRIMARY_EMPLOYEE_FLAG | VARCHAR2 | (1) | Indicates if this is the primary employee assigned to the position | |
GLOBAL_DEFAULT_FLAG | VARCHAR2 | (1) | Indicates if the assignment is through global default rule | |
ASSIGNMENT_DEFAULT_RULE_ID | NUMBER | (15) | Default rule unique identifier for populating the default assignments | |
MODIFY_FLAG | VARCHAR2 | (1) | Indicates if this assignment can be modified during budget planning or budget revision | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_ASSIGNMENT_ID
, DATA_EXTRACT_ID
, WORKSHEET_ID
, POSITION_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE_ID
, ATTRIBUTE_VALUE_ID
, ATTRIBUTE_VALUE
, PAY_ELEMENT_ID
, PAY_ELEMENT_OPTION_ID
, PAY_ELEMENT_RATE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELEMENT_VALUE_TYPE
, ELEMENT_VALUE
, CURRENCY_CODE
, PAY_BASIS
, EMPLOYEE_ID
, PRIMARY_EMPLOYEE_FLAG
, GLOBAL_DEFAULT_FLAG
, ASSIGNMENT_DEFAULT_RULE_ID
, MODIFY_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_POSITION_ASSIGNMENTS;
PSB.PSB_POSITION_ASSIGNMENTS does not reference any database object
PSB.PSB_POSITION_ASSIGNMENTS is referenced by following:
|
|
|