[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_PEOPLE_GROUPS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
PEOPLE_GROUP_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PAY_PEOPLE_GROUPS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PEOPLE_GROUP_ID
|
| PAY_PEOPLE_GROUPS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ID_FLEX_NUM
|
| Table | |
Foreign Table | Foreign Key Column |
PAY_ELEMENT_LINKS_F
|
 |
PAY_PEOPLE_GROUPS | PAY_ELEMENT_LINKS_F PEOPLE_GROUP_ID |
PER_ALL_ASSIGNMENTS_F
|
|
PAY_PEOPLE_GROUPS | PER_ALL_ASSIGNMENTS_F PEOPLE_GROUP_ID |
PER_ALL_VACANCIES
|
|
PAY_PEOPLE_GROUPS | PER_ALL_VACANCIES PEOPLE_GROUP_ID |
|---|
| 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. |
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;
HR.PAY_PEOPLE_GROUPS does not reference any database object
HR.PAY_PEOPLE_GROUPS is referenced by following:
HR
PAY_PEOPLE_GROUPS#
|
|
|
|