Search Results qrm_time_intervals_pk

Overview

QRM_TIME_INTERVALS is a configuration table in the Oracle EBS Risk Management (QRM) module that defines the individual time intervals comprising each time bucket used in risk analytics, cash flow laddering, and interest rate gap reporting. Time buckets in QRM provide the horizontal axis against which market risk exposures, repricing gaps, and liquidity positions are aggregated; this table supplies the granular segment definitions — the constituent intervals — that make up those buckets.

The table resides in the QRM schema and is delivered with a VALID status in both EBS 12.1.1 and 12.2.2. Its primary key, QRM_TIME_INTERVALS_PK, is a composite of SEQUENCE_NUMBER and TB_NAME, which ties each interval row to a parent bucket identified by TB_NAME. A foreign key on TB_NAME references QRM_TIME_BUCKETS, establishing a clear parent-child hierarchy. Heuristic Data Vault classification mined from the foreign key structure suggests this table is satellite-leaning: it describes attributes of a parent business entity (the time bucket) rather than acting as a hub or link in its own right. Modelers may treat QRM_TIME_BUCKETS as the hub and QRM_TIME_INTERVALS as a dependent satellite carrying descriptive interval attributes.

Key Information Stored

The documented physical schema contains eleven columns. The most significant are:

• TB_NAME — Identifier of the parent time bucket; part of the primary key and the foreign key to QRM_TIME_BUCKETS.
• SEQUENCE_NUMBER — Ordinal position of the interval within the bucket; part of the primary key and determines ordering of intervals along the bucket timeline.
• INTERVAL_LENGTH — Numeric length of the interval, typically expressed in the units dictated by INTERVAL_TYPE.
• INTERVAL_TYPE — Unit or category of the interval length (for example, days, months, or years), defining how INTERVAL_LENGTH is interpreted.
• LABEL — Display label for the interval, used in reports and user interfaces.
• ZD_EDITION_NAME — Edition identifier supporting Oracle's Edition-Based Redefinition (EBR), enabling online patching and versioned configuration.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking insert and update activity.

The primary key (SEQUENCE_NUMBER, TB_NAME) is the surrogate identifier for each row. Two unique indexes act as business-key candidates: QRM_TIME_INTERVALS_U1 (SEQUENCE_NUMBER, TB_NAME, ZD_EDITION_NAME) and QRM_TIME_INTERVALS_N1 (TB_NAME, SEQUENCE_NUMBER, ZD_EDITION_NAME). The inclusion of ZD_EDITION_NAME in both indexes reflects the EBR-aware design, ensuring uniqueness is scoped by edition.

Common Use Cases and Queries

Typical scenarios include retrieving all intervals for a given bucket, ordering them for reporting, and validating bucket configuration prior to running risk calculations. A representative query:

• SELECT tb_name, sequence_number, interval_length, interval_type, label FROM qrm_time_intervals WHERE tb_name = :bucket ORDER BY sequence_number;
• Reporting gap analyses join intervals to their parent bucket to present a complete bucket-to-interval hierarchy.
• Audit queries filter on LAST_UPDATE_DATE or CREATED_BY to track configuration changes across editions using ZD_EDITION_NAME.

Related Objects

The most significant related object is the parent table referenced by the foreign key:

• QRM_TIME_BUCKETS — Joined via QRM_TIME_INTERVALS.TB_NAME = QRM_TIME_BUCKETS.TB_NAME; defines the bucket that each interval belongs to.

Downstream risk views and concurrent programs within the QRM module consume the combined bucket-and-interval configuration to construct risk aggregation grids and cash flow time ladders.