[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_PAY_ELEMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_PAY_ELEMENTS
|
| Subobject Name: | |
| Status: | VALID |
PSB_PAY_ELEMENTS stores information about the various pay related cost
elements that can be assigned to positions. Some examples of pay
elements are salary, medical benefits, and bonus.
Pay elements can have a single value or a table of values.
If an element has a single value, then the rates are defined in the
PAY_ELEMENT_RATES table for different date ranges. If an element has a
table of values, then the options are defined in the
PAY_ELEMENT_OPTIONS table and, for each option, rates are defined in
the PAY_ELEMENT_RATES table for different date ranges. Pay elements
rates can be defined as a flat amount, percentage of salary, or
derived using a formula. Formulas are not supported in the current
release, but will be supported in a future release.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_PAY_ELEMENTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PAY_ELEMENT_ID
|
| PSB_PAY_ELEMENTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NAME
DATA_EXTRACT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PAY_ELEMENT_ID | NUMBER | (20) | Yes | Pay element unique identifier |
| BUSINESS_GROUP_ID | NUMBER | (20) | Yes | Business group identifier |
| DATA_EXTRACT_ID | NUMBER | (20) | Yes | Data extract identifier used to identify data for pay elements |
| NAME | VARCHAR2 | (30) | Yes | Pay element name |
| DESCRIPTION | VARCHAR2 | (240) | Description for the pay element | |
| ELEMENT_VALUE_TYPE | VARCHAR2 | (2) | Element value type is A (Amount), P (Percent), PI (Percent Increase), or PS (Percent of Salary) | |
| FORMULA_ID | NUMBER | (15) | For future use | |
| OVERWRITE_FLAG | VARCHAR2 | (1) | Indicates if the standard value for the element can be overwritten from the assignment | |
| REQUIRED_FLAG | VARCHAR2 | (1) | Indicates if this element is required | |
| FOLLOW_SALARY | VARCHAR2 | (1) | Indicates if this element follows the salary account distribution | |
| PAY_BASIS | VARCHAR2 | (10) | No longer used | |
| START_DATE | DATE | Yes | Effective start date for the element | |
| END_DATE | DATE | Effective end date for the element | ||
| PROCESSING_TYPE | VARCHAR2 | (1) | Processing type for the element is N (Non Recurring) or R (Recurring) | |
| PERIOD_TYPE | VARCHAR2 | (10) | Period type for the element in source Human Resource Management system | |
| PROCESS_PERIOD_TYPE | VARCHAR2 | (10) | Calculation period the cost must be charged to if the element period is larger than the calculation period. Valid Values are FIRST or LAST. | |
| MAX_ELEMENT_VALUE_TYPE | VARCHAR2 | (10) | Maximum element value type is A (Amount) or P (Percent) | |
| MAX_ELEMENT_VALUE | NUMBER | (20) | Maximum element value for the element | |
| SALARY_FLAG | VARCHAR2 | (1) | Yes | Indicates if this is a salary element |
| SALARY_TYPE | VARCHAR2 | (10) | Salary type for the element is RATE, STEP or VALUE | |
| OPTION_FLAG | VARCHAR2 | (1) | Indicates if the element has options | |
| HR_ELEMENT_TYPE_ID | NUMBER | (20) | Element type identifier in source Human Resources Management system | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context | |
| 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 | |
| BUDGET_SET_ID | NUMBER | (15) | HRMS budget set identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT PAY_ELEMENT_ID
, BUSINESS_GROUP_ID
, DATA_EXTRACT_ID
, NAME
, DESCRIPTION
, ELEMENT_VALUE_TYPE
, FORMULA_ID
, OVERWRITE_FLAG
, REQUIRED_FLAG
, FOLLOW_SALARY
, PAY_BASIS
, START_DATE
, END_DATE
, PROCESSING_TYPE
, PERIOD_TYPE
, PROCESS_PERIOD_TYPE
, MAX_ELEMENT_VALUE_TYPE
, MAX_ELEMENT_VALUE
, SALARY_FLAG
, SALARY_TYPE
, OPTION_FLAG
, HR_ELEMENT_TYPE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, BUDGET_SET_ID
FROM PSB.PSB_PAY_ELEMENTS;
PSB.PSB_PAY_ELEMENTS does not reference any database object
PSB.PSB_PAY_ELEMENTS is referenced by following:
APPS
PSB_PAY_ELEMENTS
|
|
|
|