Results for “srs_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAYBV_RUN_TYPES_F_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PAY (Payroll) product family. It presents payroll run type definitions in a user-facing, business-group-aware format. The view is a business view (the "BV" prefix indicates a Business View naming convention used in Oracle HRMS/Payroll) that sits directly on top of the payroll run types base table and its translation table.
The view exists primarily to support Oracle Forms, concurrent program LOVs, and reporting integrations that need to display run type information with descriptive lookup values rather than raw lookup codes. It presents translated run type names, decimal run method descriptions, effective dating, and the complete set of thirty run information columns that carry legislative and customer-defined attributes.
The view is defined with the WITH READ ONLY clause, so it cannot be used as a DML target. Attempts to insert, update, or delete through this view will raise ORA-01733 or a similar read-only error.
Underlying Base Objects
The view is defined over the following documented base objects:
- PAY_RUN_TYPES_F (synonym to the base table) — the core run type definition table providing effective-dated rows, SRS flag, run method, legislation, and run information attributes.
- PAY_RUN_TYPES_F_TL (synonym to the translation table) — supplies the run type name and short name in the session language.
- HR_BIS (package) — a business intelligence/security package used to decode lookup values and to evaluate business group and legislation security for the current session.
The two tables are joined on RUN_TYPE_ID, with the translation table filtered on T.LANGUAGE = USERENV('LANG') so that only the current session language rows are returned. This prevents duplicate rows that would otherwise appear from the multiple language rows present in the translation table.
Key Columns
- RUN_TYPE_ID — Primary key and foreign key to the base run type definition; the primary join key.
- RUN_TYPE_NAME and SHORTNAME — Translated display name and short name from the TL table.
- SRS_FLAG — The column referenced in the user's search. Indicates whether the run type is a "Standard Run Set" (SRS) type, controlling whether the associated concurrent program is submitted as a run set. Values are typically Y/N.
- RUN_METHOD_M — Decoded description of RUN_METHOD, produced via
HR_BIS.BIS_DECODE_LOOKUP('RUN_METHOD', B.RUN_METHOD). Provides the human-readable run method text. - RUN_METHOD — The raw lookup code for the run method.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date range during which the run type definition is valid.
- BUSINESS_GROUP_ID and LEGISLATION_CODE — Identify the business group and legislative context of the run type.
- RUN_INFORMATION1 … RUN_INFORMATION30 — Thirty generic descriptive columns carrying legislation-specific attributes. These are addressed contextually by the application rather than by fixed semantics.
- RUN_INFORMATION_CATEGORY — Indicates which descriptive flexfield context governs the RUN_INFORMATION columns.
- BG_SECURITY_FLAG_CODE — Derived flag computed in the view's WHERE clause using HR_BIS security functions. Returns 'Y' when the row is accessible under the current session's business group and legislation security, and 'N' otherwise. This provides row-level security emulation.
- OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard Oracle audit/versioning columns.
Common Use Cases and Queries
This view is commonly used to populate LOVs for payroll run type selection, to build reports listing valid run types for a business group, and to drive integrations that need readable run type metadata including the SRS flag.
To retrieve all SRS-enabled run types available in the current session's security context:
SELECT run_type_id, run_type_name, shortname, srs_flag, run_method_m FROM apps.paybv_run_types_f_v WHERE srs_flag = 'Y' AND bg_security_flag_code = 'Y' ORDER BY run_type_name;
To inspect a specific run type across its effective dates:
SELECT run_type_name, effective_start_date, effective_end_date,
run_method_m, legislation_code, srs_flag
FROM apps.paybv_run_types_f_v
WHERE run_type_id = :p_run_type_id
ORDER BY effective_start_date DESC;
Because the view enforces read-only access and applies business group/legislation security via the BG_SECURITY_FLAG_CODE column, it is suitable for secure reporting purposes. Note, however, that since the security logic is expressed as a computed column rather than a filter, queries that do not explicitly restrict on BG_SECURITY_FLAG_CODE will return rows from other business groups with the flag set to 'N'; all production queries should therefore include the appropriate filter.
-
View: PAYBV_RUN_TYPES_F_V 12.2.2
APPS.PAYBV_RUN_TYPES_F_V·↳ HR_BIS·↳ PAY_RUN_TYPES_F·↳ PAY_RUN_TYPES_F_TL·Explore PAY module →
-
View: PAY_RUN_TYPES_F_VL 12.2.2
APPS.PAY_RUN_TYPES_F_VL·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
View: FND_REQ_SET_RUN_FORM_V 12.2.2
- Retrofitted
APPS.FND_REQ_SET_RUN_FORM_V·↳ FND_APPLICATION_VL·↳ FND_CONCURRENT_PROGRAMS_VL·↳ FND_LANGUAGES·Explore FND module →
-
The different types of Payroll Run processing
-
APPS.FND_CONC_REQUESTS_FORM_V·↳ FND_APPLICATION·↳ FND_APPLICATION_TL·↳ FND_CONCURRENT_PROGRAMS·Explore FND module →
-
View: FND_REQ_SET_RUN_FORM_V 12.1.1
- Retrofitted
APPS.FND_REQ_SET_RUN_FORM_V·↳ FND_APPLICATION_VL·↳ FND_CONCURRENT_PROGRAMS_VL·↳ FND_LANGUAGES·Explore FND module →
-
Concurrent programs
-
Concurrent programs
-
The different types of Payroll Run processing
-
View: PAY_RUN_TYPES_F_VL 12.1.1
APPS.PAY_RUN_TYPES_F_VL·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
View: PAYBV_RUN_TYPES_F_V 12.1.1
APPS.PAYBV_RUN_TYPES_F_V·↳ HR_BIS·↳ PAY_RUN_TYPES_F·↳ PAY_RUN_TYPES_F_TL·Explore PAY module →
-
APPS.FND_CONCURRENT_PROGRAMS_VL·↳ FND_CONCURRENT_PROGRAMS·↳ FND_CONCURRENT_PROGRAMS_TL·Explore FND module →
-
APPS.FND_CONCURRENT_PROGRAMS_VL·↳ FND_CONCURRENT_PROGRAMS·↳ FND_CONCURRENT_PROGRAMS_TL·Explore FND module →
-
APPS.FND_CONC_REQUESTS_FORM_V·↳ FND_APPLICATION·↳ FND_APPLICATION_TL·↳ FND_CONCURRENT_PROGRAMS·Explore FND module →
-
VIEW: HR.PAY_RUN_TYPES_F# 12.2.2
-
VIEW: HR.PAY_RUN_TYPES_F# 12.2.2
-
TABLE: HR.PAY_RUN_TYPES_F 12.2.2
-
TABLE: HR.PAY_RUN_TYPES_F 12.1.1
-
PACKAGE: APPS.PAY_PRT_INS 12.1.1
-
PACKAGE: APPS.PAY_PRT_INS 12.2.2
-
PACKAGE: APPS.PAY_ITERATE 12.1.1