[Home] [Help] [Dependency Information]
Object Name: | PSB_EMPLOYEE_ASSIGNMENTS_I |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_EMPLOYEE_ASSIGNMENTS_I |
Subobject Name: | |
Status: | VALID |
PSB_EMPLOYEE_ASSIGNMENTS_I is the interface table for
PSB_POSITION_ASSIGNMENTS, holding values of attributes
defined for a position. The attribute values are with respect
to the employee. The employee assignments extracted from
Human Resource Management Systems are transformed into position
assignments respectively, based on the position assigned to the
employee.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_EMP_ASSIGNMENTS_I_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | DATA_EXTRACT_ID |
PSB_EMP_ASSIGNMENTS_I_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HR_POSITION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HR_POSITION_ID | NUMBER | Yes | Position unique identifier in source Human Resource Management system | |
DATA_EXTRACT_ID | NUMBER | Yes | Data extract unique identifier | |
HR_EMPLOYEE_ID | NUMBER | (20) | Employee unique identifier in source Human Resource Management system | |
ATTRIBUTE_NAME | VARCHAR2 | (30) | Yes | Position attribute name |
ATTRIBUTE_VALUE | VARCHAR2 | (240) | Attribute value assigned to the employee | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date | |
EFFECTIVE_END_DATE | DATE | Effective end date | ||
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 HR_POSITION_ID
, DATA_EXTRACT_ID
, HR_EMPLOYEE_ID
, ATTRIBUTE_NAME
, ATTRIBUTE_VALUE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_EMPLOYEE_ASSIGNMENTS_I;
PSB.PSB_EMPLOYEE_ASSIGNMENTS_I does not reference any database object
PSB.PSB_EMPLOYEE_ASSIGNMENTS_I is referenced by following:
|
|
|