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


TABLE: HR.PER_ROLES

Object Details
Object Name: PER_ROLES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_ROLES
Subobject Name:
Status: VALID


PER_ROLES contains the different Roles that each person performs. A Role can be any Job that is not contained with the default HR Job Group. Each person can take as many roles as they wish. A role can be held within a Representative Body (held on the system as an organization) but this is not mandatory. Each Representative Body must be linked to a Job Group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ROLES_PK
  1. ColumnROLE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ROLES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLE_ID
PER_ROLES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_ROLES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ROLES PER_ROLES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_ROLES ORGANIZATION_ID
PER_ROLES PER_ROLES_FK4 TablePER_JOBS PER_ROLES JOB_ID
PER_ROLES PER_ROLES_FK3 TablePER_JOB_GROUPS PER_ROLES JOB_GROUP_ID
TablePER_ELECTION_CANDIDATES PER_ELECTION_CANDIDATES_FK3 PER_ROLES PER_ELECTION_CANDIDATES ROLE_ID
Columns
Name Datatype Length Mandatory Comments
ROLE_ID NUMBER (15) Yes System generated primary key
JOB_GROUP_ID NUMBER (15) Yes Foreign key to PER_JOB_GROUPS
PERSON_ID NUMBER (10) Yes Foreign Key to PER_PEOPLE_F
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS
JOB_ID NUMBER (15) Yes Foreign key to PER_JOBS
START_DATE DATE
Yes The date on which the role is effective for this person
END_DATE DATE

The date on which this person will finish the role
CONFIDENTIAL_DATE DATE

The date on which a Confidentiality Agreement was signed
EMP_RIGHTS_FLAG VARCHAR2 (30)
Additional employee rights.
END_OF_RIGHTS_DATE DATE

The date on which the employee's additional rights terminate
PRIMARY_CONTACT_FLAG VARCHAR2 (30)
Signifies whether this person is the primary contact for the role
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield column
ROLE_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive flexfield column
ROLE_INFORMATION1 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION2 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION3 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION4 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION5 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION6 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION7 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION8 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION9 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION10 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION11 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION12 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION13 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION14 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION15 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION16 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION17 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION18 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION19 VARCHAR2 (150)
Developer Descriptive flexfield column
ROLE_INFORMATION20 VARCHAR2 (150)
Developer Descriptive flexfield column
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
OBJECT_VERSION_NUMBER NUMBER (9)
System generated version number for each row. Increments by one on each update.
OLD_END_DATE DATE

This column is used to hold the original END_DATE value once a person is terminated. If the termination is reversed, the end date of the role is restored from the value held in this columm
Query Text

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


SELECT ROLE_ID
,      JOB_GROUP_ID
,      PERSON_ID
,      ORGANIZATION_ID
,      JOB_ID
,      START_DATE
,      END_DATE
,      CONFIDENTIAL_DATE
,      EMP_RIGHTS_FLAG
,      END_OF_RIGHTS_DATE
,      PRIMARY_CONTACT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ROLE_INFORMATION_CATEGORY
,      ROLE_INFORMATION1
,      ROLE_INFORMATION2
,      ROLE_INFORMATION3
,      ROLE_INFORMATION4
,      ROLE_INFORMATION5
,      ROLE_INFORMATION6
,      ROLE_INFORMATION7
,      ROLE_INFORMATION8
,      ROLE_INFORMATION9
,      ROLE_INFORMATION10
,      ROLE_INFORMATION11
,      ROLE_INFORMATION12
,      ROLE_INFORMATION13
,      ROLE_INFORMATION14
,      ROLE_INFORMATION15
,      ROLE_INFORMATION16
,      ROLE_INFORMATION17
,      ROLE_INFORMATION18
,      ROLE_INFORMATION19
,      ROLE_INFORMATION20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      OLD_END_DATE
FROM HR.PER_ROLES;

Dependencies

[top of page]

HR.PER_ROLES does not reference any database object

HR.PER_ROLES is referenced by following:

SchemaHR
ViewPER_ROLES#