Search Results csf_map_access_hours_b




Overview
Explore in AI Chat

Overview

The CSF_MAP_ACCESS_HOURS_B table is a standard Oracle E-Business Suite table owned by the CSF schema, which supports the Field Service (TeleService) product family. In Oracle EBS 12.1.1 and 12.2.2, this table stores the definition of customer access hours — the time windows during which a field service technician is permitted to enter a customer site, and the associated requirement flag that governs whether such access windows are mandatory for scheduling. It functions as a configuration/reference table that scheduling and dispatch logic consults when validating service visit time slots against customer-specific constraints.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault model, meaning it is not identified as a hub, link, or satellite in a documented relationship graph. From a modeling perspective, the table behaves most like a satellite-style attribute container keyed by its own surrogate identifier, with the customer combination acting as a natural business key rather than a true foreign-key-driven link. Organizations adopting Data Vault patterns should treat it as an attribute-bearing entity anchored on the ACCESS_HOUR_MAP_ID surrogate.

Key Information Stored

The table defines 41 documented columns. The most significant are:

Common Use Cases and Queries

Typical usage centers on dispatch and scheduling validation. A reporting query to retrieve a customer's weekly access windows might be structured as:

  • SELECT CUSTOMER_ID, CUSTOMER_SITE_ID, ACCESSHOUR_REQUIRED, MONDAY_FIRST_START, MONDAY_FIRST_END FROM CSF.CSF_MAP_ACCESS_HOURS_B WHERE CUSTOMER_ID = :p_customer_id;
  • Join to FND_SECURITY_GROUPS to resolve the security group: SELECT a.*, s.SECURITY_GROUP_NAME FROM CSF_MAP_ACCESS_HOURS_B a, FND_SECURITY_GROUPS s WHERE a.SECURITY_GROUP_ID = s.SECURITY_GROUP_ID;
  • Identify sites requiring access-hour enforcement: WHERE ACCESSHOUR_REQUIRED = 'Y'.
  • Detect after-hours-permitted locations via AFTER_HOURS_FLAG.

These queries support technician dispatch planning, SLA compliance reporting, and interface extracts feeding mobile field service applications.

Related Objects

  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; enforces data security scoping.
  • CSF_MAP_ACCESS_HOURS_B_PK / _U1 — the primary unique index on ACCESS_HOUR_MAP_ID.
  • CSF_MAP_ACCESS_HOURS_B_U2 — the composite business-key unique index on CUSTOMER_ID, CUSTOMER_SITE_ID, CUSTOMER_LOCATION_ID.
  • Customer/site master entities (e.g., HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL) — logically related via CUSTOMER_ID and CUSTOMER_SITE_ID for reporting joins, though not listed as formal foreign keys.
  • Field Service scheduling and dispatch logic — consumes ACCESSHOUR_REQUIRED and the day/time columns when validating service visit windows.