Results for “run_type_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_RUN_TYPES_F_TL is a translation (TL) table in the Oracle EBS Payroll (PAY) module, owned by the HR schema. It stores the language-dependent, translated descriptive attributes for payroll run types — specifically the display name and short name used in the user interface and reports. It is the translated counterpart to the base run types table, PAY_RUN_TYPES_F, and follows the standard Oracle Applications multilingual (MLS) design pattern, where a language-independent base row is paired with one or more language-specific TL rows. In the documented ETRM 12.2.2 physical schema, the table contains 11 columns and is classified as VALID.
The heuristic Data Vault classification mined from the FK structure is standalone. In modeling terms, this reflects that the table does not carry the foreign-key dependency footprint typical of a hub or link; it is best treated as a language-specific descriptive component (analogous to a satellite) attached to the run type business key. Rather than describing a business event, it enriches the run type with locale-specific text.
Key Information Stored
The table’s core identity and content columns are:
- RUN_TYPE_ID — Surrogate identifier of the parent run type; part of the primary key.
- LANGUAGE — Language/locale code of the translated row; part of the primary key.
- SOURCE_LANG — The source language from which the translation was derived, used internally by the MLS framework.
- RUN_TYPE_NAME — The translated, user-facing name of the payroll run type.
- SHORTNAME — The translated short name or abbreviation displayed in list-of-values and compact UI contexts.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording who last modified the row and when.
- CREATED_BY, CREATION_DATE — Standard audit columns recording row creation.
- ZD_EDITION_NAME — Editioning column supporting Oracle EBS online patching (ADOP), enabling edition-based redefinition.
The primary key is PAY_RUN_TYPES_TL_PK on (RUN_TYPE_ID, LANGUAGE). The documented unique index additionally includes ZD_EDITION_NAME, giving the business-key candidate (RUN_TYPE_ID, LANGUAGE, ZD_EDITION_NAME). RUN_TYPE_ID links each translated row to its base run type definition; LANGUAGE determines which localized row is returned.
Common Use Cases and Queries
Typical scenarios include building multilingual payroll run type picklists, retrieving locale-specific names for concurrent process reporting, and validating translation coverage across installed languages. A representative query joins the TL table to the base table and filters to the session language:
- Retrieve translated names:
SELECT b.run_type_id, t.run_type_name, t.shortname FROM pay_run_types_f b, pay_run_types_f_tl t WHERE b.run_type_id = t.run_type_id AND t.language = USERENV('LANG'). - Audit translations: select all rows for a given RUN_TYPE_ID across LANGUAGES to confirm coverage.
- Reporting: join to PAY_RUN_TYPES_F and payroll process/run results to present user-friendly run type descriptions in BI Publisher or Discoverer reports.
- Data migration or patching: verify SOURCE_LANG and ZD_EDITION_NAME values when moving configuration between environments.
Related Objects
The most significant related objects are the base run type tables and their dependent payroll structures:
- PAY_RUN_TYPES_F — Base (language-independent) run type definition; joined on RUN_TYPE_ID.
- PAY_RUN_TYPES_TL — Synonymous translation view/table exposing translated names.
- Payroll process and run tables (for example payroll run/action results) that reference RUN_TYPE_ID.
- Concurrent program and process definitions in PAY that consume run type identifiers.
- Lookup and MLS framework views supporting the _F / _TL pattern.
Because the classification is standalone, dependencies are primarily driven by the shared RUN_TYPE_ID business key rather than by strict foreign-key constraints.
-
Translated run type descriptions
-
This view returns Result for Previous Employer of Separation Pay Tax based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_TAX_PREV_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
View: PAYLV_RUN_TYPES_V 12.2.2
APPS.PAYLV_RUN_TYPES_V·↳ HR_BIS·↳ PAY_RUN_TYPES_F·↳ PAY_RUN_TYPES_F_TL·Explore PAY module →
-
View: PAYLV_RUN_TYPES_V 12.1.1
APPS.PAYLV_RUN_TYPES_V·↳ HR_BIS·↳ PAY_RUN_TYPES_F·↳ PAY_RUN_TYPES_F_TL·Explore PAY module →
-
This view returns Result Value for Subjected Yearly Bonus of Separation Pay Slip based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_SLIP_YB_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·↳ PAY_BALANCE_TYPES·Explore PAY module →
-
View: PAY_RUN_TYPES_X 12.2.2
Date-effective view.
-
Used to store elements included or excluded from a defined run type.
-
APPS.PAY_ELEMENT_CLASS_USAGES_X·↳ PAY_ELEMENT_CLASS_USAGES_F·Explore PAY module →
-
APPS.PAY_MX_TAXABLE_BENEFITS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
Date-effective view.
APPS.PAY_RUN_TYPE_ORG_METHODS_X·↳ PAY_RUN_TYPE_ORG_METHODS_F·Explore PAY module →
-
View: PAY_MX_DEDUCTIONS_V 12.1.1
APPS.PAY_MX_DEDUCTIONS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
APPS.PAY_MX_TAX_CALC_DETAILS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
View: PAY_KR_SEP_ARCHIVE_V 12.2.2
This view returns Result Value of Separation Pay Archive Process based on assignment_action_id.
APPS.PAY_KR_SEP_ARCHIVE_V·↳ FF_ARCHIVE_ITEMS·↳ FF_DATABASE_ITEMS·↳ FF_USER_ENTITIES·Explore PAY module →
-
This view returns Balance of Separation Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_BAL_V·↳ HR_GENERAL·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
This view returns Balance of Separation Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_BAL_V·↳ HR_GENERAL·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
This view returns Result Value of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_KR_REPORT_PKG·Explore PAY module →
-
This view returns Result for Previous Employer of Separation Pay Tax based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_TAX_PREV_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
Date-effective view.
APPS.PAY_RUN_TYPE_ORG_METHODS_X·↳ PAY_RUN_TYPE_ORG_METHODS_F·Explore PAY module →
-
APPS.PAY_RUN_TYPE_ORG_METHODS·↳ FND_SESSIONS·↳ PAY_RUN_TYPE_ORG_METHODS_F·Explore PAY module →
-
Organisation level payment methods associated with a particular run type.
-
View: PAY_KR_SEP_RESULT_RR_V 12.1.1
This view returns Result of Separation Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_RR_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_CLASSIFICATIONS·Explore PAY module →
-
APPS.PAY_RUN_TYPE_ORG_METHODS·↳ FND_SESSIONS·↳ PAY_RUN_TYPE_ORG_METHODS_F·Explore PAY module →
-
APPS.PAY_ELEMENT_CLASS_USAGES_V·↳ FND_SESSIONS·↳ PAY_ELEMENT_CLASSIFICATIONS·↳ PAY_ELEMENT_CLASS_USAGES_F·Explore PAY module →
-
Action or process results, showing which assignments have been processed by a specific payroll action, or process.
-
Holds temporary data used by the balance initialization process.
-
APPS.PAY_MX_EMPLOYEE_EARNINGS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
This view returns Result Value of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_KR_REPORT_PKG·Explore PAY module →
-
APPS.PAYBV_ASSIGNMENT_ACTION·↳ HR_BIS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
This view returns Balance Value of Separation Pay Process based on balance_type_id and assignment_action_id.
APPS.PAY_KR_SEP_RESULT_BALV_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_PKG·Explore PAY module →
-
APPS.PAY_ELEMENT_CLASS_USAGES·↳ FND_SESSIONS·↳ PAY_ELEMENT_CLASS_USAGES_F·Explore PAY module →
-
View: PAY_KR_SEP_HISTORY_V 12.1.1
This view returns Separation Pay Process history based on assignment_id.
APPS.PAY_KR_SEP_HISTORY_V·↳ HR_GENERAL·↳ HR_PAYROLLS·↳ HR_PERSON_NAME·Explore PAY module →
-
APPS.PAY_ELEMENT_CLASS_USAGES·↳ FND_SESSIONS·↳ PAY_ELEMENT_CLASS_USAGES_F·Explore PAY module →
-
This view returns Balance Value of Separation Pay Process based on balance_type_id and assignment_action_id.
APPS.PAY_KR_SEP_RESULT_BALV_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_DIMENSIONS·↳ PAY_BALANCE_PKG·Explore PAY module →
-
APPS.PAY_ELEMENT_CLASS_USAGES_X·↳ PAY_ELEMENT_CLASS_USAGES_F·Explore PAY module →
-
View: PAY_RUN_TYPES_X 12.1.1
Date-effective view.
-
This view returns Result Value of Separation Pay Process based on both assignment_action_id and run_result_id.
APPS.PAY_KR_SEP_RESULT_RRV_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_INPUT_VALUES_F·↳ PAY_INPUT_VALUES_F_TL·Explore PAY module →
-
This view returns Entry Value of Separation Pay Process based on both assignment_action_id and element_entry_id.
APPS.PAY_KR_SEP_RESULT_EEV_V·↳ HR_CHKFMT·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
Used to store element classifications included in a defined run type.
-
View: PAY_KR_SEP_ARCHIVE_V 12.1.1
This view returns Result Value of Separation Pay Archive Process based on assignment_action_id.
APPS.PAY_KR_SEP_ARCHIVE_V·↳ FF_ARCHIVE_ITEMS·↳ FF_DATABASE_ITEMS·↳ FF_USER_ENTITIES·Explore PAY module →
-
View: PAY_RUN_TYPES 12.2.2
Date-effective view.
APPS.PAY_RUN_TYPES·↳ FND_SESSIONS·↳ PAY_RUN_TYPES_F·Explore PAY module →
-
This view returns Balance Feed of Separation Pay Process based on assignment_action_id and balance_type_id.
APPS.PAY_KR_SEP_RESULT_BALF_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
View: PAY_MX_DEDUCTIONS_V 12.2.2
APPS.PAY_MX_DEDUCTIONS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
View: PAY_MX_TAX_BALANCES_V 12.2.2
APPS.PAY_MX_TAX_BALANCES_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
Used to store elements included or excluded from a defined run type.
-
View: PAY_KR_SEP_RESULT_RR_V 12.2.2
This view returns Result of Separation Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_RR_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_CLASSIFICATIONS·Explore PAY module →
-
APPS.PAY_MX_TAXABLE_BENEFITS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
APPS.PAY_MX_EMPLOYEE_TAXES_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
APPS.PAY_MX_TAX_CALC_DETAILS_V·↳ PAY_AC_UTILITY·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_ATTRIBUTES·Explore PAY module →
-
Holds temporary data used by the balance initialization process.
-
Organisation level payment methods associated with a particular run type.