Results for “gb_process”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_NI_ELEMENT_ENTRIES_V is a supplementary view in the Oracle E-Business Suite APPS schema that supports Oracle Payroll National Insurance (NI) processing within the Oracle HRMS/Payroll module. In ETRM, the view is classified as a "supplementary view used to simplify forms coding" rather than a public reporting interface. The documented metadata carries an explicit warning stating that Oracle does not recommend querying or altering data through this view, since its definition may change dramatically in subsequent minor or major releases. This warning is significant: consumers should treat the object as an internal forms-support construct rather than a stable, supported integration surface. Its primary role is to denormalize element entry input values—particularly for NI-related elements—into a form-friendly shape, exposing paired columns where a coded value is accompanied by its human-readable meaning.
Underlying Base Objects
The view is defined in APPS and depends on several base objects. Payroll element data is sourced from PAY_ELEMENT_ENTRIES_F, which stores element entry assignments at the assignment level, and PAY_ELEMENT_ENTRY_VALUES_F, which holds the individual input value records attached to each entry. The element structure is resolved through PAY_ELEMENT_TYPES_F (element definitions) and PAY_INPUT_VALUES_F (input value definitions), while PAY_ELEMENT_LINKS_F ties elements to payroll and linkage criteria. Session context is provided by FND_SESSIONS, and general HR utilities by the HR_GENERAL package. These dependencies are consistent with the view's documented purpose: assembling entry-level data, input values, and their meanings into a single row per element entry for use by the National Insurance element-entry form. The ETRM metadata lists no downstream objects referencing this view, reinforcing its narrow, form-specific scope.
Key Columns
The view exposes a row identifier (ROW_ID, ROWID) and the element entry key ELEMENT_ENTRY_ID, alongside a series of paired input value identifiers and descriptive columns. INPUT_VALUE_ID1 through INPUT_VALUE_ID8 correspond to specific NI input values, each with a companion descriptive attribute: CATEGORY / CATEGORY_MEANING, CERTIFICATE / CERTIFICATE_MEANING, DATE_OF_RENEWAL, PENSION / PENSION_MEANING, PROCESS_TYPE / PROCESS_TYPE_MEANING, PERIODS, PERIOD_TYPE, and SCON. The PROCESS_TYPE and PROCESS_TYPE_MEANING columns are directly relevant to the user's search term: PROCESS_TYPE_MEANING holds the translated or lookup-derived description of the code stored in PROCESS_TYPE, allowing the form to display a readable label for the NI process category. The SCON column carries the Scottish Certificate of National Insurance number. EFFECTIVE_START_DATE and EFFECTIVE_END_DATE identify the date-tracked validity range of the entry, ASSIGNMENT_ID links the row to a specific assignment, and DISPLAY_PERIOD_TYPE provides a form-displayable period type label.
Common Use Cases and Queries
Because the view is forms-oriented and explicitly unsupported for direct querying, production use should be limited to diagnostics, reconciliation against the underlying base tables, and investigations of NI element entry data where the denormalized meanings are useful. Analysts who need meaning values rather than codes may find the view convenient, provided they accept that its column set is not guaranteed across releases. A basic query follows:
SELECT ELEMENT_ENTRY_ID, CATEGORY_MEANING, CERTIFICATE_MEANING, PENSION_MEANING, PROCESS_TYPE, PROCESS_TYPE_MEANING, SCON, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ASSIGNMENT_ID FROM APPS.PAY_NI_ELEMENT_ENTRIES_V;- To inspect NI process types for a specific assignment, filter by ASSIGNMENT_ID and list PROCESS_TYPE_MEANING values within the relevant effective date range.
- For authoritative reporting, prefer querying the base element entry and input value tables directly, since those objects represent the supported data model.
-
Lookup Type: GB_PROCESS 12.1.1
-
Lookup Type: GB_PROCESS 12.2.2
-
View based on PAY_ELEMENT_ENTRY_VALUES_F used by the PAYGBTAX form to display NI details.
APPS.PAY_NI_ELEMENT_ENTRIES_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ PAY_ELEMENT_ENTRIES_F·Explore PAY module →
-
View based on PAY_ELEMENT_ENTRY_VALUES_F used by the PAYGBTAX form to display NI details.
APPS.PAY_NI_ELEMENT_ENTRIES_V·↳ FND_SESSIONS·↳ HR_GENERAL·↳ PAY_ELEMENT_ENTRIES_F·Explore PAY module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2