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


TABLE: HR.PQH_ROLES

Object Details
Object Name: PQH_ROLES
Object Type: TABLE
Owner: HR
FND Design Data: TablePQH.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_ROLES_PK
  1. ColumnROLE_ID
Unique Key: PQH_ROLES_UK
  1. ColumnROLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
PQH_ROLES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLE_ID
PQH_ROLES_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLE_NAME
PQH_ROLES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PQH_ROLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLE_TYPE_CD
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_ROLES PQH_ROLES_FK1 TableHR_ALL_ORGANIZATION_UNITS PQH_ROLES BUSINESS_GROUP_ID
TablePQH_ROLE_TEMPLATES PQH_ROLE_TEMPLATES_FK1 PQH_ROLES PQH_ROLE_TEMPLATES ROLE_ID
TablePQH_ROUTING_HISTORY PQH_ROUTING_HISTORY_FK8 PQH_ROLES PQH_ROUTING_HISTORY FORWARDED_TO_ROLE_ID
TablePQH_ROUTING_HISTORY PQH_ROUTING_HISTORY_FK9 PQH_ROLES PQH_ROUTING_HISTORY FORWARDED_BY_ROLE_ID
TablePQH_ROUTING_LIST_MEMBERS PQH_ROUTING_LIST_MEMBERS_FK1 PQH_ROLES PQH_ROUTING_LIST_MEMBERS ROLE_ID
Columns
Name Datatype Length Mandatory Comments
ROLE_ID NUMBER (15) Yes Primary Key
ROLE_NAME VARCHAR2 (30) Yes Description of the Role
ROLE_TYPE_CD VARCHAR2 (30)
Type of role.
ENABLE_FLAG VARCHAR2 (10) Yes Enabled / disabled
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) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version Number
BUSINESS_GROUP_ID NUMBER (15)
Business Group
INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION21 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION22 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION23 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION24 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION25 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION26 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION27 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION28 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION29 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION30 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield
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:

SchemaHR
ViewPQH_ROLES#