Search Results csf_tds_conditions




Overview
Explore in AI Chat

Overview

CSF_TDS_CONDITIONS is a table owned by the CSF (Field Service) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. ETRM documents its status as VALID and describes it as storing the conditions associated with a TDS (Traffic/Dispatch Service or Territory Definition Structure record). In practice the table acts as the conditional or qualification detail for a parent interval record, allowing the application to describe the physical, environmental, and access circumstances that apply to a given interval of service or scheduling logic.

The physical schema records 18 columns, keyed by CONDITION_ID through the primary key constraint CSF_TDS_CONDITIONS_PK. Two outbound foreign keys are documented: INTERVAL_ID referencing CSF_TDS_INTERVALS, and SECURITY_GROUP_ID referencing FND_SECURITY_GROUPS. One inbound foreign key is documented: CSF_TDS_COND_SEGS.CONDITION_ID referencing this table, making CSF_TDS_CONDITIONS a parent of the segment detail table.

Applying a heuristic Data Vault classification to the documented foreign-key structure, this object is satellite-leaning. Its primary key is a system-generated surrogate, and the bulk of its columns are descriptive attributes describing access and traffic conditions rather than relationships between hubs. A formal Data Vault model would likely render CSF_TDS_CONDITIONS as a satellite hanging off a hub or link representing the interval, with SECURITY_GROUP_ID acting as a supporting reference.

Key Information Stored

The following columns are the most significant for understanding and querying the table:

  • CONDITION_ID — the surrogate primary key, generated by CSF_TDS_CONDITIONS_PK, uniquely identifying each condition record.
  • INTERVAL_ID — the foreign key to CSF_TDS_INTERVALS; it is the principal business linkage that ties a condition to its owning interval, and is the most common join key in reporting.
  • SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, controlling multi-org and security-group access to the condition row.
  • CONDITION_TYPE — classifies the nature of the condition, driving how downstream logic interprets the row.
  • NR_SEGMENT_INVOLVED — identifies the specific segment of the interval to which the condition applies.
  • CONSTRUCTION_STATUS — describes construction or work state associated with the condition.
  • DIRECTION_OF_TRAFFIC — records the traffic direction applicable to the condition.
  • BIN_INDEX — a supporting indexed attribute used for ordering or binning of condition rows.
  • ACCESS_BUS, ACCESS_BICYCLE, ACCESS_CARS, ACCESS_TAXI, ACCESS_CARPOOL, ACCESS_DELIVERY, ACCESS_TRUCK, ACCESS_EMERGENCY, ACCESS_PEDESTRIAN, ACCESS_THROUGH_TRAFFIC — a family of access-classification flags recording which transport modes or movement types are permitted or relevant for the condition.

No alternate unique business-key index is documented beyond the primary key; CONDITION_ID is therefore the only documented unique identifier, while INTERVAL_ID plus CONDITION_TYPE and NR_SEGMENT_INVOLVED form the practical candidate business key for interpretation.

Common Use Cases and Queries

Typical usage centres on retrieving the access and traffic characteristics that apply to a given interval, and on joining condition rows to their segment detail. A representative query joining the parent interval and the segment child is:

  • SELECT c.CONDITION_ID, c.INTERVAL_ID, c.CONDITION_TYPE, c.CONSTRUCTION_STATUS, c.DIRECTION_OF_TRAFFIC FROM CSF.CSF_TDS_CONDITIONS c WHERE c.INTERVAL_ID = :interval_id;
  • SELECT s.CONDITION_ID, c.CONDITION_TYPE FROM CSF.CSF_TDS_CONDITIONS c JOIN CSF.CSF_TDS_COND_SEGS s ON s.CONDITION_ID = c.CONDITION_ID;
  • SELECT c.* FROM CSF.CSF_TDS_CONDITIONS c WHERE c.SECURITY_GROUP_ID = :org_id; for security-group-scoped reporting.

Reporting scenarios include access-profile analysis across vehicle classes, construction and traffic-direction summaries by interval, and validation of orphaned conditions against CSF_TDS_INTERVALS.

Related Objects

  • CSF_TDS_INTERVALS — parent table joined on CONDITION_ID’s INTERVAL_ID foreign key.
  • CSF_TDS_COND_SEGS — child table referencing CSF_TDS_CONDITIONS.CONDITION_ID, holding segment detail.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for access control and multi-org filtering.

Both foreign-key parents and the single documented child comprise the immediate dependency footprint; no additional views or public APIs for this table are recorded in the ETRM metadata.