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_EMPLOYEES_I

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

PSB.PSB_EMPLOYEES_I does not reference any database object

PSB.PSB_EMPLOYEES_I is referenced by following:

APPS: PSB_EMPLOYEES_I