Search Results sys_il0000083055c00011

Overview

CSF.CSF_TDS_NODES is a table in the CSR (Customer Support and Returns) / CSF schema of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. It defines the nodes of a Transportation Data Standard (TDS) road network, where each TDS node represents a junction or intersection point within that network. By definition, a node is always the start or end point of a segment, which makes this table a structural cornerstone of TDS road geometry used by EBS logistics and territory-related functionality.

Its registered design data is CSF.CSF_TDS_NODES, and it is stored in the APPS_TS_MEDIA tablespace, a location consistent with the geospatial (SDO_GEOMETRY) nature of the data. In heuristic Data Vault terms, this table is classified as satellite-leaning: the modeled NODE_ID behaves as a durable business key candidate, while the descriptive attributes (BIN_INDEX, TILE_ID, GEOMETRY, SECURITY_GROUP_ID) are context that effectively sits around the node identity. This classification should be treated as a modeling suggestion rather than a documented architectural fact.

Key Information Stored

The table contains five documented columns. The primary key, TDS_NODES_PK, is the surrogate identifier NODE_ID (NUMBER(30)), described as the unique identifier of the entity. TILE_ID (NUMBER(30)) is also defined as a unique entity identifier and is the column carrying the foreign key to CSF_TDS_TILES, meaning node identity is scoped within a tile. The remaining columns are descriptive and operational:

• NODE_ID — primary key; uniquely identifies a TDS node (junction/segment endpoint).
• BIN_INDEX (NUMBER(10)) — value used to generate the segment index in the binary TDS file.
• TILE_ID (NUMBER(30)) — unique tile identifier to which the node belongs; FK to CSF_TDS_TILES.
• GEOMETRY (SDO_GEOMETRY) — Oracle Spatial geometry for the node location.
• SECURITY_GROUP_ID (NUMBER) — identifier used when running in hosted (Multi-Org) mode; FK to FND_SECURITY_GROUPS.

The metadata also reports two unique LOB indexes, SYS_IL0000083055C00010$$ and SYS_IL0000083055C00011$$, both in APPS_TS_MEDIA. These are internal indexes supporting LOB segments (the user search string, sys_il0000083055c00011, resolves to the second of these). They are physical LOB index names, not true business-key candidates; the business key is NODE_ID (and functionally, TILE_ID within its parent tile).

Common Use Cases and Queries

The table is typically queried for spatial joins, network traversal, and tile-level processing of TDS files. A straightforward retrieval follows the documented query text:

• Resolve node attributes for a tile: SELECT NODE_ID, BIN_INDEX, TILE_ID, GEOMETRY, SECURITY_GROUP_ID FROM CSF.CSF_TDS_NODES WHERE TILE_ID = :tile_id;
• Spatial proximity / within-distance reporting using SDO_GEOMETRY and the node geometry column.
• Hosted-mode reporting that filters by SECURITY_GROUP_ID to respect multi-tenant visibility.
• Identifying segment endpoints by joining nodes to CSF_TDS_SEGM_NODES to reconstruct road segments.
• Generating or validating binary TDS files by mapping BIN_INDEX to segment indices.

Related Objects

The relationship metadata shows the following significant dependencies:

• CSF.CSF_TDS_TILES — referenced by CSF_TDS_NODES.TILE_ID; the parent grouping of nodes.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; enforces hosted-mode data security.
• CSF.CSF_TDS_SEGM_NODES — references CSF_TDS_NODES.NODE_ID; links nodes to road segments, forming the primary traversal join path.
• APPS.CSF_TDS_NODES — the APPS-layer synonym/view exposing the same data to the application.
• MDSYS.SDO_GEOMETRY and SYS.STANDARD — declared type/standard dependencies supporting the GEOMETRY column.

Together these objects position CSF_TDS_NODES as the junction layer between tiles, spatial geometry, and segment definitions in the EBS TDS network model.