Search Results csf_md_lyr_metadata




Overview
Explore in AI Chat

Overview

The CSF_MD_LYR_METADATA table is a core data object within the Oracle E-Business Suite (EBS) Field Service (CSF) module. It functions as the central repository for defining the configuration and display properties of map layers used in the application's geographical interfaces. In the context of EBS 12.1.1 and 12.2.2, this table is essential for enabling the visual representation of service-related data—such as technician locations, service territories, and customer sites—on interactive maps. Its metadata drives how spatial information is rendered, categorized, and presented to users, directly supporting field service dispatch, routing, and resource management workflows.

Key Information Stored

The table's primary purpose is to store layer configuration attributes. While the full column list is not detailed in the provided metadata, the documented foreign key relationships indicate several critical data points. The primary key, LAYER_METADATA_ID, uniquely identifies each layer configuration record. The table stores references to visual style definitions via LAYER_STYLE_SHEET_ID and INST_STYLE_ID, which link to the CSF_MD_LYR_STYLE_SHTS and CSF_MD_INST_STYLE_SHTS tables, respectively. Furthermore, the THEME_METADATA_ID column establishes a relationship with the CSF_MD_THEME_METADATA table, indicating that layers can be associated with broader thematic groupings for data visualization, such as coloring regions by workload or priority.

Common Use Cases and Queries

This table is primarily accessed for configuring and troubleshooting the map display within Field Service. Administrators may query it to audit or modify layer definitions. A common reporting use case involves joining the table to its related style and theme tables to generate a comprehensive list of all configured map layers and their associated visual properties. A typical SQL pattern for such an audit would be:

  • SELECT lyr.layer_metadata_id, lyr.theme_metadata_id, theme.theme_name, style.style_sheet_name FROM csf_md_lyr_metadata lyr, csf_md_theme_metadata theme, csf_md_lyr_style_shts style WHERE lyr.theme_metadata_id = theme.theme_metadata_id AND lyr.layer_style_sheet_id = style.style_sheet_id;

This query helps ensure layer configurations are consistent and correctly linked to the intended visual themes and styles.

Related Objects

The CSF_MD_LYR_METADATA table is integral to the Field Service mapping subsystem, with documented relationships to several key metadata tables:

  • CSF_MD_LYR_STYLE_SHTS: Joined via CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID. This table likely contains the style sheet definitions (e.g., line colors, fill patterns, icons) applied to the map layer.
  • CSF_MD_INST_STYLE_SHTS: Joined via CSF_MD_LYR_METADATA.INST_STYLE_ID. This may store instance-specific style overrides or specialized rendering rules.
  • CSF_MD_THEME_METADATA: Joined via CSF_MD_LYR_METADATA.THEME_METADATA_ID. This table defines the overarching themes (logical groupings of layers or visualization rules) to which a display layer belongs.

These relationships form a hierarchy where a theme contains multiple layers, and each layer references specific style sheets for its visual presentation.