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: HR.PER_PERSON_TYPES

Object Details

Object Name:	PER_PERSON_TYPES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_PERSON_TYPES
Subobject Name:
Status:	VALID

PER_PERSON_TYPES holds the list of names that may be used when
entering or changing person types. Valid person types for a specific
function are selected by joining to PER_FORM_FUNCTIONS. At any time,
only one active USER_PERSON_TYPE can be the default for a
SYSTEM_PERSON_TYPE.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_PERSON_TYPES_PK

PERSON_TYPE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PERSON_TYPES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_TYPE_ID
PER_PERSON_TYPES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_PERSON_TYPES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEEDED_PERSON_TYPE_KEY
PER_PERSON_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_PERSON_TYPE BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_PERSON_TYPES		HR_ALL_ORGANIZATION_UNITS	PER_PERSON_TYPES BUSINESS_GROUP_ID
PER_ALL_PEOPLE_F		PER_PERSON_TYPES	PER_ALL_PEOPLE_F PERSON_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_TYPE_ID	NUMBER	(15)	Yes	Unique key generated from sequence PER_PERSON_TYPES_S.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
ACTIVE_FLAG	VARCHAR2	(30)	Yes	Indicates whether the type is active[Y/N].
DEFAULT_FLAG	VARCHAR2	(30)	Yes	Indicates whether this USER_PERSON_TYPE is the default for the current SYSTEM_PERSON_TYPE [Y/N].
SYSTEM_PERSON_TYPE	VARCHAR2	(30)	Yes	System name for the person type.
USER_PERSON_TYPE	VARCHAR2	(80)	Yes	User name for the person type. You can have multiple user names for each system name.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
SEEDED_PERSON_TYPE_KEY	VARCHAR2	(30)		Seeded person type key

Query Text

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


SELECT PERSON_TYPE_ID
,      BUSINESS_GROUP_ID
,      ACTIVE_FLAG
,      DEFAULT_FLAG
,      SYSTEM_PERSON_TYPE
,      USER_PERSON_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SEEDED_PERSON_TYPE_KEY
FROM HR.PER_PERSON_TYPES;

Dependencies

[top of page]

HR.PER_PERSON_TYPES does not reference any database object

HR.PER_PERSON_TYPES is referenced by following:

APPS: PER_PERSON_TYPES; PER_PERSON_TYPES_WHO
PUBLIC: PER_PERSON_TYPES