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


TABLE: HR.PAY_PEOPLE_GROUPS

Object Details
Object Name: PAY_PEOPLE_GROUPS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_PEOPLE_GROUPS
Subobject Name:
Status: VALID


PAY_PEOPLE_GROUPS contains the people group flexfield segment values
for individual employee assignments. The segments of the group
flexfield are user-defined and are used to identify specific groups of
employees for element link rules, for analysis and reporting. Groups
are also used to determine the sorting of pay advice and
checks/cheques. GROUP_NAME contains the concatenation of SEGMENT1 to
SEGMENT30. Oracle Applications do not support code combination IDs
that exceed 2,000,000,000.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_PEOPLE_GROUPS_PK
  1. ColumnPEOPLE_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_PEOPLE_GROUPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPEOPLE_GROUP_ID
PAY_PEOPLE_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK4 PAY_PEOPLE_GROUPS PAY_ELEMENT_LINKS_F PEOPLE_GROUP_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK16 PAY_PEOPLE_GROUPS PER_ALL_ASSIGNMENTS_F PEOPLE_GROUP_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK7 PAY_PEOPLE_GROUPS PER_ALL_VACANCIES PEOPLE_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PEOPLE_GROUP_ID NUMBER (15) Yes System-generated primary key column.
GROUP_NAME VARCHAR2 (240)
Concatenation of key flexfield segments.
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure foreign key.
SUMMARY_FLAG VARCHAR2 (1) Yes Key flexfield summary flag.
ENABLED_FLAG VARCHAR2 (1) Yes Key flexfield enabled flag.
START_DATE_ACTIVE DATE

Date the key flexfield combination becomes active or valid.
END_DATE_ACTIVE DATE

Date the key flexfield combination becomes inactive or invalid.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment
SEGMENT2 VARCHAR2 (60)
Key flexfield segment
SEGMENT3 VARCHAR2 (60)
Key flexfield segment
SEGMENT4 VARCHAR2 (60)
Key flexfield segment
SEGMENT5 VARCHAR2 (60)
Key flexfield segment
SEGMENT6 VARCHAR2 (60)
Key flexfield segment
SEGMENT7 VARCHAR2 (60)
Key flexfield segment
SEGMENT8 VARCHAR2 (60)
Key flexfield segment
SEGMENT9 VARCHAR2 (60)
Key flexfield segment
SEGMENT10 VARCHAR2 (60)
Key flexfield segment
SEGMENT11 VARCHAR2 (60)
Key flexfield segment
SEGMENT12 VARCHAR2 (60)
Key flexfield segment
SEGMENT13 VARCHAR2 (60)
Key flexfield segment
SEGMENT14 VARCHAR2 (60)
Key flexfield segment
SEGMENT15 VARCHAR2 (60)
Key flexfield segment
SEGMENT16 VARCHAR2 (60)
Key flexfield segment
SEGMENT17 VARCHAR2 (60)
Key flexfield segment
SEGMENT18 VARCHAR2 (60)
Key flexfield segment
SEGMENT19 VARCHAR2 (60)
Key flexfield segment
SEGMENT20 VARCHAR2 (60)
Key flexfield segment
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT PEOPLE_GROUP_ID
,      GROUP_NAME
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_PEOPLE_GROUPS;

Dependencies

[top of page]

HR.PAY_PEOPLE_GROUPS does not reference any database object

HR.PAY_PEOPLE_GROUPS is referenced by following:

SchemaHR
ViewPAY_PEOPLE_GROUPS#