Search Results tds_nodes_pk

Overview

CSF_TDS_NODES is a Field Service (CSF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the individual node records belonging to a Field Service visualization tile. The object name and its companion table CSF_TDS_TILES indicate that it belongs to the CSF Technical Data Set (TDS) framework, which supports the graphical topology and network renderings used by Oracle Field Service and its related dispatch/visualization components. Each row represents a single node — a point, segment endpoint, or geometric element — positioned within a tile and rendered using a spatial GEOMETRY column.

From a Data Vault modeling perspective, the ETRM heuristic classifies this table as satellite-leaning. It carries descriptive, context-bearing attributes (geometry, bin index, tile membership) attached to a node identity rather than acting as a central hub or a pure associative link. The primary key TDS_NODES_PK on NODE_ID serves as the surrogate (hub-like) identity column, while the remaining attributes function as satellite payload describing that node.

Key Information Stored

The documented physical schema exposes five columns in the CSF schema. The most significant are:

• NODE_ID — The surrogate primary key, enforced by TDS_NODES_PK. It uniquely identifies each node and is the join key referenced by dependent tables.
• TILE_ID — Foreign key to CSF_TDS_TILES. Associates the node with its parent tile, establishing the containment hierarchy that drives which graphical canvas the node is rendered on.
• GEOMETRY — Stores the spatial/geometric representation of the node, enabling the Field Service visualization layer to plot points, lines, or segment endpoints. This is the descriptive payload that distinguishes one node from another within a tile.
• BIN_INDEX — A spatial indexing or binning attribute, typically used to accelerate geometric lookups and viewport-based queries by grouping nodes into spatial bins.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-tenant or organizational data access, consistent with standard EBS security partitioning.

The unique indexes SYS_IL0000083055C00010$$ and SYS_IL0000083055C00011$$ are internal LOB/intermedia indexes associated with the GEOMETRY storage and do not represent business-key candidates. The true business identity remains NODE_ID via the declared primary key.

Common Use Cases and Queries

Typical scenarios involve retrieving all nodes for a given tile, reconstructing network topology, or filtering nodes by security context. A representative query joins nodes to their tile and security group:

• List nodes within a tile: SELECT n.NODE_ID, n.BIN_INDEX, n.TILE_ID FROM CSF_TDS_NODES n WHERE n.TILE_ID = :tile_id;
• Join to tiles for context: SELECT t.*, n.* FROM CSF_TDS_NODES n, CSF_TDS_TILES t WHERE n.TILE_ID = t.TILE_ID;
• Retrieve spatial nodes for rendering: SELECT NODE_ID, GEOMETRY FROM CSF_TDS_NODES WHERE SECURITY_GROUP_ID = :sgid;
• Find segment nodes referencing a node: SELECT * FROM CSF_TDS_SEGM_NODES WHERE NODE_ID = :node_id;

Reporting use cases include node-count-per-tile analytics, spatial density analysis via BIN_INDEX, and security-scoped map extraction for Field Service dispatch dashboards.

Related Objects

The following objects are most significant, based on documented foreign key relationships:

• CSF_TDS_TILES — Parent table referenced via CSF_TDS_NODES.TILE_ID; defines the tile the node belongs to.
• CSF_TDS_SEGM_NODES — Child table referencing CSF_TDS_NODES.NODE_ID; links nodes into segment structures, forming the edge/connectivity layer of the topology.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs row-level security partitioning.
• CSF_TDS_NODES (self, TDS_NODES_PK) — The primary key that downstream segment and geometry relationships depend on.

Together, CSF_TDS_NODES, CSF_TDS_TILES, and CSF_TDS_SEGM_NODES form the core of the Field Service topology model, where tiles contain nodes and segment-node records connect them into navigable networks for visualization and dispatch.