[Home] [Help] [Dependency Information]
Object Name: | PSB_EMPLOYEES_I |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_EMPLOYEES_I |
Subobject Name: | |
Status: | VALID |
PSB_EMPLOYEES_I stores employee-related demographic details, position assignment details,
and salary information for employees as obtained from the Human Resource Management
Systems setup. Table details are used to populate PSB_EMPLOYEES and
PSB_POSITION_ASSIGNMENTS. The employee information is used to populate
the PSB_EMPLOYEES table and the employees are linked to Positions in
the PSB_POSITION_ASSIGNMENTS table. The salary information is used to
create the salary assignment in the PSB_POSITION_ASSIGNMENTS table.
Salary assigned to an employee can be a Grade Rate structure, Grade
Step structure, or Non-Grade structure.
For the Grade Rate structure RATE_OR_PAYSCALE_ID, GRADE_ID,
MAXIMUM_VALUE, MINIMUM_VALUE, MID_VALUE, ELEMENT_VALUE, and
RATE_ID columns are required. The RATE_ID must have the same
value as RATE_OR_PAYSCALE_ID. The RATE_OR_PAYSCALE_ID and GRADE_ID
are mapped to the PSB_SALARY_I table to determine the appropriate salary
for the position.
For Grade Step structure RATE_OR_PAYSCALE_ID, GRADE_ID, GRADE_STEP,
SEQUENCE_NUMBER, and ELEMENT_VALUE are required. RATE_ID is NULL. The
RATE_OR_PAYSCALE_ID, GRADE_ID, GRADE_STEP, and SEQUENCE_NUMBER are
mapped to the PSB_SALARY_I table to determine the appropriate salary for
the position.
For Non-Grade structure ELEMENT_VALUE is the only required column.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_EMPLOYEES_I_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HR_POSITION_ID |
PSB_EMPLOYEES_I_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HR_EMPLOYEE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HR_EMPLOYEE_ID | NUMBER | (20) | Yes | Employee unique identifier in source Human Resource Management system |
DATA_EXTRACT_ID | NUMBER | Yes | Data extract unique identifier | |
HR_POSITION_ID | NUMBER | (15) | Position unique identifier in source Human Resource Management system. Identifies the position assigned to the employee. Column value null implies that employee is yet to be assigned a valid position. | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number in source Human Resource Management system | |
ASSIGNMENT_ID | NUMBER | (15) | Assignment unique identifier. For non-Oracle source Human Resource Management system, assign EMPLOYEE_ID as the value for the ASSIGNMENT_ID. | |
GRADE_ID | NUMBER | (20) | Unique identifier of grade assigned to employee | |
GRADE_STEP | NUMBER | (15) | Grade step assigned to employee | |
SEQUENCE_NUMBER | NUMBER | (15) | Incremental order of the grade step | |
PAY_BASIS | VARCHAR2 | (30) | Time basis on which the salary is recorded | |
RATE_ID | NUMBER | Rate unique identifier used to validate salary values | ||
FIRST_NAME | VARCHAR2 | (150) | First name of the employee | |
FULL_NAME | VARCHAR2 | (240) | Full name of the employee | |
KNOWN_AS | VARCHAR2 | (80) | Preferred name, if different from first name | |
LAST_NAME | VARCHAR2 | (150) | Last name of the employee | |
MIDDLE_NAMES | VARCHAR2 | (60) | Middle name of the employee | |
TITLE | VARCHAR2 | (30) | Title, if any, for the employee | |
DATE_OF_BIRTH | DATE | Date of birth | ||
MARITAL_STATUS | VARCHAR2 | (30) | Marital status | |
SEX | VARCHAR2 | (30) | Legal gender | |
EMAIL_ADDRESS | VARCHAR2 | (240) | Employee email address | |
BUSINESS_GROUP_ID | NUMBER | Yes | Business group unique identifier | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date | |
SET_OF_BOOKS_ID | NUMBER | (15) | General Ledger Set of Books unique identifier | |
SALARY_TYPE | VARCHAR2 | (10) | Salary type. Valid values are STEP (grade scale), RATE (grade rate) and VALUE (Non grade salary). | |
RATE_OR_PAYSCALE_ID | NUMBER | (15) | Rate or pay scale unique identifier | |
ELEMENT_VALUE | NUMBER | Value for both types of salary | ||
PROPOSED_SALARY | NUMBER | Proposed salary for the employee. For non-Oracle source Human Resouce Management system, if there is no significant value, default it to the element_value. | ||
CHANGE_DATE | DATE | Date on which the PROPOSED_SALARY becomes effective. Default value is employee's effective_start_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_EMPLOYEE_ID
, DATA_EXTRACT_ID
, HR_POSITION_ID
, EMPLOYEE_NUMBER
, ASSIGNMENT_ID
, GRADE_ID
, GRADE_STEP
, SEQUENCE_NUMBER
, PAY_BASIS
, RATE_ID
, FIRST_NAME
, FULL_NAME
, KNOWN_AS
, LAST_NAME
, MIDDLE_NAMES
, TITLE
, DATE_OF_BIRTH
, MARITAL_STATUS
, SEX
, EMAIL_ADDRESS
, BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, SET_OF_BOOKS_ID
, SALARY_TYPE
, RATE_OR_PAYSCALE_ID
, ELEMENT_VALUE
, PROPOSED_SALARY
, CHANGE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_EMPLOYEES_I;
PSB.PSB_EMPLOYEES_I does not reference any database object
PSB.PSB_EMPLOYEES_I is referenced by following:
|
|
|