Search Results cug_sr_type_attr_maps_b




Overview
Explore in AI Chat

Overview

The CUG_SR_TYPE_ATTR_MAPS_B table is a core data structure within the Oracle E-Business Suite Citizen Interaction Center (CUG) module. It functions as a configuration and mapping table, central to defining the relationship between Service Request Types and the specific attributes that can be associated with them. In the context of citizen or customer service management, this table enables administrators to control which additional data fields (attributes) are applicable and required for different categories of service requests. This ensures data integrity and guides users through context-specific data entry, tailoring the service request process to the incident type.

Key Information Stored

The table stores the essential linkage between a Service Request Type and its configurable attributes. The primary columns include SR_TYPE_ATTR_MAP_ID, which is the unique system-generated identifier (surrogate primary key) for each mapping record. The INCIDENT_TYPE_ID column holds a foreign key reference to the CS_INCIDENT_TYPES_B table, identifying the specific Service Request Type. The SR_ATTRIBUTE_CODE column stores the code for the service request attribute being mapped. Together, INCIDENT_TYPE_ID and SR_ATTRIBUTE_CODE form a unique constraint (CUG_SR_TYPE_ATTR_MAP_B_UK1), preventing duplicate attribute assignments for a given request type.

Common Use Cases and Queries

A primary use case is the administrative setup and auditing of attribute assignments across service request types. For instance, an administrator may need to report on all attributes enabled for a specific incident type or identify which types use a particular attribute. Common SQL queries include retrieving a list of mapped attributes for a given type or finding unassigned attributes. A typical reporting query would join this table to CS_INCIDENT_TYPES_B for the type name and to a lookup for attribute descriptions.

  • List all attributes for a Service Request Type: SELECT sr_attribute_code FROM cug_sr_type_attr_maps_b WHERE incident_type_id = <TYPE_ID>;
  • Find Service Request Types using a specific attribute: SELECT incident_type_id FROM cug_sr_type_attr_maps_b WHERE sr_attribute_code = '<ATTR_CODE>';

Related Objects

The table maintains defined relationships with several other EBS objects, primarily through foreign key constraints. It is a parent table to CUG_SR_TYPE_ATTR_MAPS_TL, which holds the translated, user-facing names for these mappings (joined on SR_TYPE_ATTR_MAP_ID). Crucially, it is a child table to CS_INCIDENT_TYPES_B, the master table for Service Request Types, via the INCIDENT_TYPE_ID column. This relationship ensures that a mapping can only be created for a valid, existing incident type. These relationships are fundamental for any data integrity checks, joins in reports, or understanding the complete configuration flow from type definition to attribute assignment.