[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_PAY_ELEMENT_DISTRIBUTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_PAY_ELEMENT_DISTRIBUTIONS
|
| Subobject Name: | |
| Status: | VALID |
PSB_PAY_ELEMENT_DISTRIBUTIONS stores the cost distribution rules for
a PAY_ELEMENT. Different distribution rules can be defined for
groups of position sets for a given element. For example,
medical benefits can be distributed differently for full-time
employees and part-time employees.
For all salary elements, cost distributions must be defined. For
non-salary elements, independent distribution rules can be defined or
they can be defined to follow the salary distribution rules. If it is
set to follow salary, then only the override segment values are stored
for the given element. The costs calculated for these dependent
elements are distributed to accounts derived by substituting the
override segment values in the same proportion as salary.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_PAY_ELEMENT_DIST_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 POSITION_SET_GROUP_ID
EFFECTIVE_START_DATE
|
| PSB_PAY_ELEMENT_DIST_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DISTRIBUTION_SET_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | (15) | Yes | Distribution unique identifier |
| POSITION_SET_GROUP_ID | NUMBER | (15) | Yes | Position set group identifier |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | Chart of Accounts identifier for the distribution |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date for the distribution | |
| EFFECTIVE_END_DATE | DATE | Effective end date for the distribution | ||
| DISTRIBUTION_PERCENT | NUMBER | Distribution percentage | ||
| CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | Concatenated accounting segment values entered. Used only for display purposes in the form. | |
| CODE_COMBINATION_ID | NUMBER | (15) | General Ledger code combination identifier for the distribution | |
| DISTRIBUTION_SET_ID | NUMBER | (15) | Yes | Groups account distribution lines for a date range for an element that does not follow salary |
| SEGMENT1 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT2 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT3 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT4 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT5 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT6 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT7 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT8 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT9 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT10 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT11 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT12 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT13 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT14 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT15 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT16 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT17 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT18 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT19 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT20 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT21 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT22 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT23 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT24 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT25 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT26 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT27 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT28 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT29 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT30 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_ID
, POSITION_SET_GROUP_ID
, CHART_OF_ACCOUNTS_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DISTRIBUTION_PERCENT
, CONCATENATED_SEGMENTS
, CODE_COMBINATION_ID
, DISTRIBUTION_SET_ID
, 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 PSB.PSB_PAY_ELEMENT_DISTRIBUTIONS;
PSB.PSB_PAY_ELEMENT_DISTRIBUTIONS does not reference any database object
PSB.PSB_PAY_ELEMENT_DISTRIBUTIONS is referenced by following:
APPS
PSB_PAY_ELEMENT_DISTRIBUTIONS
|
|
|
|