Search Results csf_tds_intervals_pk

Overview

CSF_TDS_INTERVALS is a Field Service (CSF) module table that defines time interval definitions used by the Oracle EBS Time and Date Scheduler (TDS) framework. The object resides in the CSF schema and is classified as VALID in the ETRM repository. Its role is to store discrete interval boundaries — start and end descriptors decomposed into calendar, week, day, hour, and minute attributes — that condition records, recurring blackout windows, and employee or resource segments can reference.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this table behaves as a hub-leaning entity. The single-column primary key CSF_TDS_INTERVALS_PK (INTERVAL_ID) provides a stable surrogate identifier, while the majority of dependent objects (CSF_TDS_CONDITIONS, CSF_TDS_RDBLCK_INTVLS, CSF_TDS_SEGMENTS) reference it through INTERVAL_ID, reinforcing its role as a shared dimension-like anchor rather than a transactional link. The presence of SECURITY_GROUP_ID also ties it to Multi-Org / data-security partitioning via FND_SECURITY_GROUPS.

Key Information Stored

The table contains 24 documented columns. The most significant are summarized below.

• INTERVAL_ID — surrogate primary key (CSF_TDS_INTERVALS_PK). Business keys are not exposed as a separate unique index; interval definitions are typically distinguished by their start/end attribute combinations.
• S_INTERVAL_TYPE / E_INTERVAL_TYPE — code the interval classification for the start and end boundaries (for example absolute vs. relative/derived definitions).
• S_YEAR, S_MONTH_OF_YEAR, S_WEEK_OF_YEAR, S_WEEK_OF_MONTH, S_DAY_OF_YEAR, S_DAY_OF_MONTH, S_DAY_OF_WEEK, S_HOUR_OF_DAY, S_MINUTE_OF_HOUR — the full decomposition of the start boundary across calendar, week-of-year, week-of-month, day, hour, and minute components.
• E_YEAR, E_MONTH_OF_YEAR, E_WEEK_OF_YEAR, E_WEEK_OF_MONTH, E_DAY_OF_YEAR, E_DAY_OF_MONTH, E_DAY_OF_WEEK, E_HOUR_OF_DAY, E_MINUTE_OF_HOUR — the symmetric decomposition of the end boundary.
• BIN_INDEX — a hashing/bucketing field used to accelerate lookups of interval rows during schedule evaluation.
• GDF_TIME_DOMAIN_STRING — a Global Descriptive Flexfield string column (GDF) that carries descriptive flexfield payload associated with the interval/time domain.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing data-security group partitioning.

Common Use Cases and Queries

Typical use cases revolve around schedule resolution: retrieving the concrete start and end bounds for a given INTERVAL_ID, populating recurrence overlays used by Scheduler Admin forms, and joining interval definitions to the subordinate condition, blackout, and segment records that consume them.

Example — resolve an interval by primary key:

• SELECT INTERVAL_ID, S_INTERVAL_TYPE, S_YEAR, S_MONTH_OF_YEAR, S_DAY_OF_MONTH, S_HOUR_OF_DAY, E_YEAR, E_MONTH_OF_YEAR, E_DAY_OF_MONTH, E_HOUR_OF_DAY FROM CSF.CSF_TDS_INTERVALS WHERE INTERVAL_ID = :p_interval_id;

Example — join to dependent objects that reference an interval:

• SELECT i.INTERVAL_ID, c.CONDITION_ID, s.SEGMENT_ID, r.RDBLCK_INTVL_ID FROM CSF.CSF_TDS_INTERVALS i LEFT JOIN CSF.CSF_TDS_CONDITIONS c ON c.INTERVAL_ID = i.INTERVAL_ID LEFT JOIN CSF.CSF_TDS_SEGMENTS s ON s.INTERVAL_ID = i.INTERVAL_ID LEFT JOIN CSF.CSF_TDS_RDBLCK_INTVLS r ON r.INTERVAL_ID = i.INTERVAL_ID WHERE i.SECURITY_GROUP_ID = :p_security_group_id;

Reporting scenarios include auditing which intervals are referenced by active conditions, validating blackout windows against resource schedules, and reconciling interval rows against their GDF descriptive flexfield attributes.

Related Objects

• CSF_TDS_CONDITIONS — references CSF_TDS_INTERVALS via CSF_TDS_CONDITIONS.INTERVAL_ID; conditions qualify which intervals apply to a scheduling rule.
• CSF_TDS_RDBLCK_INTVLS — references CSF_TDS_INTERVALS via RDBLCK_INTVLS.INTERVAL_ID; represents recurring blackout interval overlays.
• CSF_TDS_SEGMENTS — references CSF_TDS_INTERVALS via SEGMENTS.INTERVAL_ID; links interval definitions to resource or employee segments.
• FND_SECURITY_GROUPS — referenced through CSF_TDS_INTERVALS.SECURITY_GROUP_ID; drives Multi-Org / data-security scoping.

Together these objects form the lookup backbone of the CSF Time and Date Scheduler, in which CSF_TDS_INTERVALS acts as the interval hub supplying boundary definitions to conditions, blackouts, and segments.