[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_ELEMENT_TYPES_F |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_ELEMENT_TYPES_F
|
| Subobject Name: | |
| Status: | VALID |
PAY_ELEMENT_TYPES_F is the DateTracked table that holds the
definitions of elements in Oracle HRMS. Elements are the units
used to build all the earnings, deductions and benefits that users
can give to employees. Localization teams define primary
classifications for the payroll processing of elements according to
the requirements of their legislation, for example, Pre-Tax Deduction
or Tax Deduction. Elements are also used to hold non-payment types of
information linked to employee assignments, for example, information
about assets and other equipment issued to employees for their work.
NOTE: Users must not enter information into the Developer
Descriptive Flexfield columns of this table. These are reserved for
the use of localization and verticalization teams, for entry and
maintenance of legislative or industry-specific data.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
ELEMENT_TYPE_IDEFFECTIVE_START_DATEEFFECTIVE_END_DATEELEMENT_NAMEBUSINESS_GROUP_IDLEGISLATION_CODEEFFECTIVE_START_DATEEFFECTIVE_END_DATE| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PAY_ELEMENT_TYPES_F_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_TYPE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PAY_ELEMENT_TYPES_F_UK2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ELEMENT_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PAY_ELEMENT_TYPES_F_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLASSIFICATION_ID
|
| PAY_ELEMENT_TYPES_F_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BENEFIT_CLASSIFICATION_ID
|
| PAY_ELEMENT_TYPES_F_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FORMULA_ID
|
| Table | |
Foreign Table | Foreign Key Column | PAY_ELEMENT_TYPES_F |  |
BEN_BENEFIT_CLASSIFICATIONS
|
PAY_ELEMENT_TYPES_F BENEFIT_CLASSIFICATION_ID | PAY_ELEMENT_TYPES_F | |
PAY_ELEMENT_CLASSIFICATIONS
|
PAY_ELEMENT_TYPES_F CLASSIFICATION_ID | PAY_ELEMENT_TYPES_F | |
PAY_EVENT_GROUPS
|
PAY_ELEMENT_TYPES_F PRORATION_GROUP_ID |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ELEMENT_TYPE_ID | NUMBER | (9) | Yes | System-generated primary key column. |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
| LEGISLATION_CODE | VARCHAR2 | (30) | Foreign Key to FND_TERRITORIES | |
| FORMULA_ID | NUMBER | (9) | Foreign key to PAY_FORMULAS_F. | |
| INPUT_CURRENCY_CODE | VARCHAR2 | (15) | Foreign key to FND_CURRENCIES. | |
| OUTPUT_CURRENCY_CODE | VARCHAR2 | (15) | Foreign key to FND_CURRENCIES. | |
| CLASSIFICATION_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_CLASSIFICATIONS. |
| BENEFIT_CLASSIFICATION_ID | NUMBER | (15) | Foreign key to BEN_BENEFIT_CLASSIFICATIONS. | |
| ADDITIONAL_ENTRY_ALLOWED_FLAG | VARCHAR2 | (30) | Yes | Indicates whether a recurring element can also have an additional nonrecurring entry of this type in any payroll period. |
| ADJUSTMENT_ONLY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element is used only for adjusting balances. Not used in US legislations. |
| CLOSED_FOR_ENTRY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether entries can be currently entered or updated. |
| ELEMENT_NAME | VARCHAR2 | (80) | Yes | User name for the element type. This is the name used to generate database item names. |
| REPORTING_NAME | VARCHAR2 | (80) | Short name for the element, used in reports. | |
| DESCRIPTION | VARCHAR2 | (240) | Brief description of the element type. | |
| INDIRECT_ONLY_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element can be given to an assignment only as an indirect result from a formula. |
| MULTIPLE_ENTRIES_ALLOWED_FLAG | VARCHAR2 | (30) | Yes | Indicates whether an assignment can have multiple normal entries for this element at any one time. |
| MULTIPLY_VALUE_FLAG | VARCHAR2 | (30) | Yes | Indicates whether entries can be multiplied, for example, holiday pay. |
| POST_TERMINATION_RULE | VARCHAR2 | (30) | Yes | Rule for element processing when a person is terminated. |
| PROCESS_IN_RUN_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the element can be processed in a payroll run. |
| PROCESSING_PRIORITY | NUMBER | (9) | Yes | Processing priority order for any entries of this element in a payroll run. |
| PROCESSING_TYPE | VARCHAR2 | (30) | Yes | Indicates whether the element is recurring or nonrecurring. |
| STANDARD_LINK_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the default element link type is standard (Y) or non-standard (N). |
| COMMENT_ID | NUMBER | (15) | Foreign key to HR_COMMENTS. | |
| LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Identifies the legislation of the predefined data for the element. | |
| QUALIFYING_AGE | NUMBER | (2) | Age at which a person qualifies for this element. | |
| QUALIFYING_LENGTH_OF_SERVICE | NUMBER | (6) | Length of service required for the person to qualify for this element. | |
| QUALIFYING_UNITS | VARCHAR2 | (30) | Units of measurement for qualifying length of service. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| 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. | |
| 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. | ||
| ELEMENT_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| ELEMENT_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| THIRD_PARTY_PAY_ONLY_FLAG | VARCHAR2 | (30) | Indicates whether the element is paid by third party payments only. | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. | |
| ITERATIVE_FLAG | VARCHAR2 | (30) | Indicates whether the element can be adjusted as a result of iterative rules. | |
| ITERATIVE_FORMULA_ID | NUMBER | (9) | Foreign Key to FF_FORMULAS_F to indicate the formula that defaults and changes the iterative element's input values. | |
| ITERATIVE_PRIORITY | NUMBER | (9) | The order of the iterative adjustment processing for iterative elements | |
| CREATOR_TYPE | VARCHAR2 | (30) | Sub-system responsible for creating the element definition. | |
| RETRO_SUMM_ELE_ID | NUMBER | (9) | Element type id of the RetroPay summary element. | |
| GROSSUP_FLAG | VARCHAR2 | (30) | Indicates if this element can be processed in a Net to Gross calculation. | |
| PROCESS_MODE | VARCHAR2 | (30) | Denotes the type of processing which may be applied to this element e.g. separate check,separate payment or process separately. | |
| ADVANCE_INDICATOR | VARCHAR2 | (1) | Advance Indicator for element type | |
| ADVANCE_PAYABLE | VARCHAR2 | (1) | Advance Payable flag | |
| ADVANCE_DEDUCTION | VARCHAR2 | (1) | Advance Deduction flag | |
| PROCESS_ADVANCE_ENTRY | VARCHAR2 | (1) | Process Advance Entry flag | |
| PRORATION_GROUP_ID | NUMBER | (15) | Foreign key to PAY_EVENT_GROUPS for elements to prorate. | |
| PRORATION_FORMULA_ID | NUMBER | (9) | Foreign key to FF_FORMULAS_F to identify proration formula | |
| RECALC_EVENT_GROUP_ID | NUMBER | (15) | Foreign key to PAY_EVENT_GROUPS for Recalculation. | |
| ONCE_EACH_PERIOD_FLAG | VARCHAR2 | (1) | Indicates if element should only be processed once per period. | |
| TIME_DEFINITION_TYPE | VARCHAR2 | (1) | Indicates the type of time definition used with this Element | |
| TIME_DEFINITION_ID | NUMBER | (9) | Foreign Key to PAY_TIME_DEFINITIONS. | |
| ADVANCE_ELEMENT_TYPE_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_TYPES_F table | |
| DEDUCTION_ELEMENT_TYPE_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_TYPES_F table |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_TYPE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, FORMULA_ID
, INPUT_CURRENCY_CODE
, OUTPUT_CURRENCY_CODE
, CLASSIFICATION_ID
, BENEFIT_CLASSIFICATION_ID
, ADDITIONAL_ENTRY_ALLOWED_FLAG
, ADJUSTMENT_ONLY_FLAG
, CLOSED_FOR_ENTRY_FLAG
, ELEMENT_NAME
, REPORTING_NAME
, DESCRIPTION
, INDIRECT_ONLY_FLAG
, MULTIPLE_ENTRIES_ALLOWED_FLAG
, MULTIPLY_VALUE_FLAG
, POST_TERMINATION_RULE
, PROCESS_IN_RUN_FLAG
, PROCESSING_PRIORITY
, PROCESSING_TYPE
, STANDARD_LINK_FLAG
, COMMENT_ID
, LEGISLATION_SUBGROUP
, QUALIFYING_AGE
, QUALIFYING_LENGTH_OF_SERVICE
, QUALIFYING_UNITS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ELEMENT_INFORMATION_CATEGORY
, ELEMENT_INFORMATION1
, ELEMENT_INFORMATION2
, ELEMENT_INFORMATION3
, ELEMENT_INFORMATION4
, ELEMENT_INFORMATION5
, ELEMENT_INFORMATION6
, ELEMENT_INFORMATION7
, ELEMENT_INFORMATION8
, ELEMENT_INFORMATION9
, ELEMENT_INFORMATION10
, ELEMENT_INFORMATION11
, ELEMENT_INFORMATION12
, ELEMENT_INFORMATION13
, ELEMENT_INFORMATION14
, ELEMENT_INFORMATION15
, ELEMENT_INFORMATION16
, ELEMENT_INFORMATION17
, ELEMENT_INFORMATION18
, ELEMENT_INFORMATION19
, ELEMENT_INFORMATION20
, THIRD_PARTY_PAY_ONLY_FLAG
, OBJECT_VERSION_NUMBER
, ITERATIVE_FLAG
, ITERATIVE_FORMULA_ID
, ITERATIVE_PRIORITY
, CREATOR_TYPE
, RETRO_SUMM_ELE_ID
, GROSSUP_FLAG
, PROCESS_MODE
, ADVANCE_INDICATOR
, ADVANCE_PAYABLE
, ADVANCE_DEDUCTION
, PROCESS_ADVANCE_ENTRY
, PRORATION_GROUP_ID
, PRORATION_FORMULA_ID
, RECALC_EVENT_GROUP_ID
, ONCE_EACH_PERIOD_FLAG
, TIME_DEFINITION_TYPE
, TIME_DEFINITION_ID
, ADVANCE_ELEMENT_TYPE_ID
, DEDUCTION_ELEMENT_TYPE_ID
FROM HR.PAY_ELEMENT_TYPES_F;
HR.PAY_ELEMENT_TYPES_F does not reference any database object
HR.PAY_ELEMENT_TYPES_F is referenced by following:
APPS
HRI_MDP_SUP_WRKFC_JX_MV
HR_MBS_WRKFC_JCX_MV
HR_MBS_WRKFC_JCX_SUPH_MV
HR_PAY_IF_REP_NAME_UNIQUE_ASIU
HR_PAY_IF_REP_NAME_UNIQUE_BRIU
PAYELEMENTTYPESF_44U_DYT
PAY_ELEMENT_TYPES_F
PAY_ELEMENT_TYPES_F_OVN
PAY_ELEMENT_TYPES_F_WHO
PAY_ELEMENT_TYPES_T1
PUBLIC
PAY_ELEMENT_TYPES_F
|
|
|
|