Search Results csf_access_hours_tl_pk

Overview

CSF_ACCESS_HOURS_TL is the translation (TL) table for access hour definitions within the Oracle E-Business Suite Field Service (CSF) module. In the EBS multilanguage architecture, a base table such as CSF_ACCESS_HOURS stores language-independent attributes, while its companion _TL table stores the language-dependent descriptive text keyed by LANGUAGE. Access hours describe the service windows during which a field service organization is available to perform work, and they are referenced by scheduling, dispatch, and coverage logic in the Field Service application.

The table resides in the CSF schema and is documented as VALID in both release 12.1.1 and 12.2.2. In the documented 12.2.2 physical schema it carries ten columns. A heuristic Data Vault classification mined from the foreign key structure labels this object "standalone," meaning it exhibits no strong parent-child dependency chain and is best modeled as a standalone reference table or, alternatively, as a satellite attached to the CSF_ACCESS_HOURS hub if a Data Vault model were constructed. This is a modeling suggestion only, not a mandated design.

Key Information Stored

The primary key, CSF_ACCESS_HOURS_TL_PK, is a composite surrogate key defined on (LANGUAGE, ACCESS_HOUR_ID). ACCESS_HOUR_ID links each translation row back to the base access-hour record, and LANGUAGE identifies the translated locale. Together they guarantee a single description per access hour per language.

• ACCESS_HOUR_ID — surrogate identifier joining to the base CSF_ACCESS_HOURS table.
• LANGUAGE — the NLS language code of the translated text.
• SOURCE_LANG — the language from which the translation was derived, used by the translation maintenance utilities.
• DESCRIPTION — the translated, user-visible name of the access hour definition; the primary business-facing attribute of this table.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enabling row-level security partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns captured by the WHO columns convention.

No unique business-key index beyond the composite primary key is documented. DESCRIPTION functions as the main business-key candidate for reporting purposes, although it is not guaranteed unique across languages.

Common Use Cases and Queries

Reporting on access hours typically joins the translation table to the base table to present language-appropriate descriptions. A common pattern restricts the join to the session language:

• List all access hours for a coverage report: SELECT a.access_hour_id, t.description FROM csf_access_hours a, csf_access_hours_tl t WHERE a.access_hour_id = t.access_hour_id AND t.language = USERENV('LANG');
• Detect missing translations by comparing base rows against translation rows for a target language.
• Audit changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance or troubleshooting.
• Filter by SECURITY_GROUP_ID when the environment uses security group partitioning across operating units.

Because the table is small and reference-oriented, queries are inexpensive and are usually embedded in scheduling or dispatch views rather than executed ad hoc.

Related Objects

The most significant relationships derive from the documented foreign key and primary key structure, supplemented by the standard EBS TL pairing convention:

• CSF_ACCESS_HOURS — the base table that CSF_ACCESS_HOURS_TL translates; joined on ACCESS_HOUR_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for row-level security.
• FND_LANGUAGES — the source of valid LANGUAGE and SOURCE_LANG codes.
• FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — context for the CSF application installation.
• CSF_ACCESS_HOURS_TL_PK — the primary key constraint enforcing uniqueness on (LANGUAGE, ACCESS_HOUR_ID).

Because the heuristic classification is standalone, no other dependent child tables are documented as referencing this object directly; its role is purely to supply translated descriptive text to consumers of the base access-hour table.