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

Object Details

Object Name:	PSB_EMPLOYEES
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_EMPLOYEES
Subobject Name:
Status:	VALID

PSB_EMPLOYEES stores basic demographic information about employees. This information is extracted from Oracle Human Resource
Management Systems and cannot be modified from within Oracle Public
Sector Budgeting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_EMPLOYEES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID
PSB_EMPLOYEES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HR_EMPLOYEE_ID DATA_EXTRACT_ID
PSB_EMPLOYEES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_EXTRACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYEE_ID	NUMBER	(20)	Yes	Employee unique identifier
DATA_EXTRACT_ID	NUMBER	(20)	Yes	Data extract unique identifier to which the employee belongs
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group unique identifier to which the employee belongs
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee number in source Human Resource Management System
HR_EMPLOYEE_ID	NUMBER			Employee unique identifier in source Human Resource Management System
FIRST_NAME	VARCHAR2	(150)		Employee first name
FULL_NAME	VARCHAR2	(240)		Employee full name
KNOWN_AS	VARCHAR2	(80)		Preferred name, if different from first name
LAST_NAME	VARCHAR2	(150)		Employee last name
MIDDLE_NAMES	VARCHAR2	(60)		Employee middle name
TITLE	VARCHAR2	(30)		Title, if any, for the employee
DATE_OF_BIRTH	DATE			Employee date of birth
MARITAL_STATUS	VARCHAR2	(30)		Employee marital status
EMAIL_ADDRESS	VARCHAR2	(240)		Employee email address
SEX	VARCHAR2	(30)		Legal gender
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EMPLOYEE_ID
,      DATA_EXTRACT_ID
,      BUSINESS_GROUP_ID
,      EMPLOYEE_NUMBER
,      HR_EMPLOYEE_ID
,      FIRST_NAME
,      FULL_NAME
,      KNOWN_AS
,      LAST_NAME
,      MIDDLE_NAMES
,      TITLE
,      DATE_OF_BIRTH
,      MARITAL_STATUS
,      EMAIL_ADDRESS
,      SEX
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PSB.PSB_EMPLOYEES;

Dependencies

[top of page]

PSB.PSB_EMPLOYEES does not reference any database object

PSB.PSB_EMPLOYEES is referenced by following:

APPS: PSB_EMPLOYEES