Search Results csf_tds_binary_tiles




Overview
Explore in AI Chat

Overview

CSF_TDS_BINARY_TILES is a Field Service (CSF) application table in the Oracle E-Business Suite that defines the spatial index used to render digital maps. Within the Oracle EBS 12.1.1 and 12.2.2 data models, the table stores the individual binary tile records that subdivide a digital map into manageable, addressable segments for spatial lookup and display. Its documented description — "Defines a spatial index to a digital map" — places it firmly in the mapping and geographic visualization layer of Field Service, supporting dispatching, territory visualization, and location-aware scheduling where map imagery must be tiled and delivered efficiently rather than loaded as a single monolithic image.

From a modeling perspective, the Data Vault classification mined from its foreign key structure is satellite-leaning. This suggests that CSF_TDS_BINARY_TILES functions primarily as a descriptive satellite attached to a parent map entity, holding attributes and payload associated with a specific map. It is not itself a hub of independent business identities, but rather a dependent detail table whose rows exist only in the context of a parent map.

Key Information Stored

The documented physical schema for release 12.2.2 shows the table owned by the CSF schema with five columns. The principal columns are:

  • BINARY_TILE_ID — the surrogate primary key, enforced by the constraint CSF_TDS_BINARY_TILES_PK. Each row represents one tile in the spatial index.
  • BINARY_MAP_ID — a foreign key to CSF_TDS_BINARY_MAPS, establishing the parent map to which the tile belongs. This is the defining relationship of the table and the basis for its satellite-leaning classification.
  • SEGMENTS — a large object (LOB) column holding the binary tile segment data. The presence of the system-managed LOB indexes SYS_IL0000083075C00003$$ and SYS_IL0000083075C00004$$ in the documented unique index list confirms that SEGMENTS is LOB-backed.
  • NODES — the second LOB-backed column associated with the tile structure, storing node data that complements the segment payload. The SYS_IL indexes correspond to these two LOB columns.
  • SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, providing multi-tenant and operating-unit level data isolation in the standard EBS security model.

The primary key BINARY_TILE_ID is a system-generated surrogate; no separate business-key unique index on natural columns is documented. The only unique indexes listed are the two LOB indexes, which are infrastructure artifacts rather than genuine business-key candidates.

Common Use Cases and Queries

Typical usage centers on retrieving tiles for a given map. A common pattern joins tiles to their parent map:

  • SELECT t.binary_tile_id, t.binary_map_id, t.security_group_id FROM csf.csf_tds_binary_tiles t WHERE t.binary_map_id = :map_id;
  • Counting tiles per map: SELECT binary_map_id, COUNT(*) FROM csf.csf_tds_binary_tiles GROUP BY binary_map_id;
  • Joining to the parent map for descriptive context: SELECT t.binary_tile_id, m.* FROM csf.csf_tds_binary_tiles t, csf.csf_tds_binary_maps m WHERE t.binary_map_id = m.binary_map_id;
  • Security-scoped reporting: SELECT * FROM csf.csf_tds_binary_tiles WHERE security_group_id = :sg_id;

Because SEGMENTS and NODES are LOB columns, extraction queries should avoid selecting them in bulk; reporting should target identifiers and the map relationship instead. Bulk LOB reads are best performed by the map rendering components rather than ad hoc SQL.

Related Objects

The most significant related objects, based on the documented foreign key structure, are:

  • CSF_TDS_BINARY_MAPS — the parent table, joined on BINARY_MAP_ID. This is the primary dependency.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control and data partitioning.
  • CSF_TDS_BINARY_TILES_PK — the primary key constraint on BINARY_TILE_ID.
  • SYS_IL0000083075C00003$$ and SYS_IL0000083075C00004$$ — system-managed LOB indexes for the SEGMENTS and NODES columns.

Together these objects form the tile-to-map chain through which Field Service renders and secures digital map imagery in Oracle EBS 12.1.1 and 12.2.2.