[Home] [Help] [Dependency Information]

TABLE: HR.PQH_ROLES

Object Details

Object Name:	PQH_ROLES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_ROLES
Subobject Name:
Status:	VALID

There are two types of role - HR and BUDGET. It also keeps overriding or universal approver. Users having universal approver role can approve any transaction of their type.
Each template has their own pre-defined approvers, to approve a transaction each template needs to be approved or highest level role need to approve all templates associated with a given transaction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_ROLES_PK

1. ROLE_ID

Unique Key: PQH_ROLES_UK

1. ROLE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_ROLES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ROLE_ID
PQH_ROLES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ROLE_NAME
PQH_ROLES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PQH_ROLES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROLE_TYPE_CD

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_ROLES		HR_ALL_ORGANIZATION_UNITS	PQH_ROLES BUSINESS_GROUP_ID
PQH_ROLE_TEMPLATES		PQH_ROLES	PQH_ROLE_TEMPLATES ROLE_ID
PQH_ROUTING_HISTORY		PQH_ROLES	PQH_ROUTING_HISTORY FORWARDED_TO_ROLE_ID
PQH_ROUTING_HISTORY		PQH_ROLES	PQH_ROUTING_HISTORY FORWARDED_BY_ROLE_ID
PQH_ROUTING_LIST_MEMBERS		PQH_ROLES	PQH_ROUTING_LIST_MEMBERS ROLE_ID

Columns

Query Text

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

SELECT ROLE_ID
,      ROLE_NAME
,      ROLE_TYPE_CD
,      ENABLE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
,      INFORMATION1
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION2
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION3
,      INFORMATION30
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION_CATEGORY
FROM HR.PQH_ROLES;

Dependencies

[top of page]

HR.PQH_ROLES does not reference any database object

HR.PQH_ROLES is referenced by following:

HR

PQH_ROLES#