Search Results csf_map_access_hours_tl




Overview
Explore in AI Chat

Overview

CSF_MAP_ACCESS_HOURS_TL is a translation (TL) table in the CSF schema, belonging to the Oracle Field Service product family. In Oracle EBS 12.1.1 and 12.2.2, the _TL suffix denotes a language-dependent translation table, meaning it stores the multilingual, user-facing text associated with a base entity. Here, the base entity is the Access Hours mapping record, and this table supplies translated descriptions keyed by LANGUAGE. The table is registered as VALID and is composed of 10 documented columns.

From a data modeling perspective, the mined Data Vault classification is "standalone," meaning the ETRM heuristic did not detect strong hub, link, or satellite dependency chains through foreign keys alone. This should be treated as a modeling suggestion rather than a definitive statement: in practice, a translation table typically behaves as a satellite attached to a parent hub (the base access-hours map), with LANGUAGE and the parent surrogate key forming the composite identity.

Key Information Stored

The table's content centers on a small set of identity and descriptive columns:

  • ACCESS_HOUR_MAP_ID – The surrogate identifier inherited from the base access-hours mapping record; part of the primary key.
  • LANGUAGE – The NLS language code for the translated row; the second component of the primary key. Language is the dominant driver of how a consumer selects a row.
  • SOURCE_LANG – Indicates the language in which the source description was originally authored, used to support the translation seeding and comparison process.
  • DESCRIPTION – The translated, displayable text describing the access hours map for the given language. This is the primary business payload of the translation row.
  • SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enforcing row-level security and multi-tenant partitioning of the translated data.
  • CREATED_BY, CREATION_DATE – Standard WHO columns recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns capturing the last modifying user, timestamp, and login session.

The composite primary key CSF_MAP_ACCESS_HOURS_TL_PK (ACCESS_HOUR_MAP_ID, LANGUAGE) is the definitive uniqueness constraint. No separate single-column business key is documented, so ACCESS_HOUR_MAP_ID should be regarded as the link to the base entity and LANGUAGE as the translation discriminator; together they behave as the effective business key.

Common Use Cases and Queries

Typical consumption involves joining the translation row back to its base record and presenting the language-appropriate DESCRIPTION. A common pattern is to resolve the description for a specific access-hours map and session language:

  • Retrieve translated text for a known map: SELECT DESCRIPTION FROM CSF_MAP_ACCESS_HOURS_TL WHERE ACCESS_HOUR_MAP_ID = :map_id AND LANGUAGE = USERENV('LANG');
  • Extract all available translations for audit or gap analysis: SELECT LANGUAGE, DESCRIPTION FROM CSF_MAP_ACCESS_HOURS_TL WHERE ACCESS_HOUR_MAP_ID = :map_id ORDER BY LANGUAGE;
  • Detect untranslated entries by comparing SOURCE_LANG against LANGUAGE.
  • Reporting on configuration coverage across security groups using SECURITY_GROUP_ID in the predicate.

Reporting and integration layers should filter by LANGUAGE and, where multi-tenant security applies, by SECURITY_GROUP_ID to avoid cross-tenant leakage.

Related Objects

The most significant relationship documented is the foreign key from CSF_MAP_ACCESS_HOURS_TL.SECURITY_GROUP_ID to FND_SECURITY_GROUPS. The natural parent of the translation rows is the base access-hours mapping table keyed by ACCESS_HOUR_MAP_ID, which supplies the entity being translated. Consumers of the translated DESCRIPTION commonly traverse these objects together, and standard WHO auditing columns align the table with the broader EBS audit framework. Administrators and integrators should treat FND_SECURITY_GROUPS, the base access-hours map table, and the language/NLS access layer as the primary related objects when querying or extending this table.