DBA Data[Home] [Help] [Dependency Information]

TABLE: MTH.MTH_PERSONNEL_D

Object Details
Object Name: MTH_PERSONNEL_D
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_PERSONNEL_D
Subobject Name:
Status: VALID


This table stores information about personnel. It holds information like First name, Last name, Resource and Organization.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_PERSONNEL_D_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSONNEL_PK
Columns
Name Datatype Length Mandatory Comments
PERSONNEL_PK_KEY NUMBER
Yes System generated surrogate key for personnel
PERSONNEL_PK VARCHAR2 (120) Yes Personnel identifier
EBS_PERSONNEL_ID NUMBER

Oracle E-business suite personnel identifier
EBS_ORGANIZATION_ID NUMBER

Oracle E-business suite organization identifier
FIRST_NAME VARCHAR2 (100) Yes First name
LAST_NAME VARCHAR2 (100) Yes Last name
PLANT_FK_KEY NUMBER
Yes Reference to plant
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in source system.
USER_ATTR1 VARCHAR2 (150)
User-defined attribute
USER_ATTR2 VARCHAR2 (150)
User-defined attribute
USER_ATTR3 VARCHAR2 (150)
User-defined attribute
USER_ATTR4 VARCHAR2 (150)
User-defined attribute
USER_ATTR5 VARCHAR2 (150)
User-defined attribute
USER_MEASURE1 NUMBER

User-defined measure
USER_MEASURE2 NUMBER

User-defined measure
USER_MEASURE3 NUMBER

User-defined measure
USER_MEASURE4 NUMBER

User-defined measure
USER_MEASURE5 NUMBER

User-defined measure
SYSTEM_FK_KEY NUMBER
Yes Reference to system
RESOURCE_FK_KEY NUMBER

Reference to resource
PERSONNEL_DESCRIPTION VARCHAR2 (240)
Personnel description
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_SYSTEM_ID NUMBER
Yes Standard who column
LAST_UPDATE_SYSTEM_ID NUMBER
Yes Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
MIDDLE_NAME VARCHAR2 (60)
Middle Name
KNOWN_AS VARCHAR2 (80)
Preferred name, if different from first name
FULL_NAME VARCHAR2 (240)
Full name - concatenation of last name, title, first name, middle names and the name the person is known by.
TITLE VARCHAR2 (30)
Title e.g. Mr, Mrs, Dr.
SEX VARCHAR2 (30)
Legal gender
EMAIL_ADDRESS VARCHAR2 (240)
Holds actual email identifier
WORK_TELEPHONE VARCHAR2 (60)
Work Telephone
MOBILE_PHONE_NUMBER VARCHAR2 (60)
Mobile phone number
EFFECTIVE_START_DATE DATE

Effective start date
EFFECTIVE_END_DATE DATE

Effective end date
Query Text

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


SELECT PERSONNEL_PK_KEY
,      PERSONNEL_PK
,      EBS_PERSONNEL_ID
,      EBS_ORGANIZATION_ID
,      FIRST_NAME
,      LAST_NAME
,      PLANT_FK_KEY
,      SOURCE_ORG_CODE
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      SYSTEM_FK_KEY
,      RESOURCE_FK_KEY
,      PERSONNEL_DESCRIPTION
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      MIDDLE_NAME
,      KNOWN_AS
,      FULL_NAME
,      TITLE
,      SEX
,      EMAIL_ADDRESS
,      WORK_TELEPHONE
,      MOBILE_PHONE_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM MTH.MTH_PERSONNEL_D;

Dependencies

[top of page]

MTH.MTH_PERSONNEL_D does not reference any database object

MTH.MTH_PERSONNEL_D is referenced by following:

SchemaMTH
ViewMTH_PERSONNEL_D#