Results for “csf_debrief_headers_u2”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSF.CSF_DEBRIEF_HEADERS is the header-level transaction table within the Oracle E-Business Suite Field Service (CSF) module that stores the Field Service Report — the structured record of what a field service engineer captures during a customer visit. In EBS 12.1.1 and 12.2.2 the table resides in the CSF schema, is designated VALID, and is registered under FND Design Data as CSF.CSF_DEBRIEF_HEADERS. Physically it is stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes are held in APPS_TS_TX_IDX, following standard transactional data conventions.

Functionally, the header records a single interaction with the customer. Each task assignment made to a resource produces a Field Service Report, and the header row is the parent of the detailed debrief lines. The primary key is CSF_DEBRIEF_HEADERS_PK on DEBRIEF_HEADER_ID, and this column is referenced as a foreign key from CSF_DEBRIEF_LINES. From a dimensional modeling perspective, the mined Data Vault heuristic classifies this object as satellite-leaning: it carries descriptive, mostly non-key attributes (dates, status, travel metrics, DFF attributes) that hang off the hub-like task assignment and debrief header keys rather than acting as an integrating hub itself. This classification is offered as a modeling suggestion only; Oracle does not publish Data Vault semantics for the table.

Key Information Stored

The table contains 33 documented columns. The most significant are the identifiers, the business-key candidates, the operational descriptors, and the standard auditing columns.

• DEBRIEF_HEADER_ID — the surrogate primary key, a NUMBER that uniquely identifies each Field Service Report header.
• DEBRIEF_NUMBER — a VARCHAR2(50) business identifier representing the unique number of the Field Service Report. It is enforced by the unique index CSF_DEBRIEF_HEADERS_U2, making it the primary business-key candidate users recognize and quote.
• TASK_ASSIGNMENT_ID — the unique identifier of the task assignment this report is associated with; it is indexed non-uniquely by CSF_DEBRIEF_HEADERS_N1 and carries a foreign key to JTF_TASK_ASSIGNMENTS.
• DEBRIEF_DATE — the date of the field service report.
• DEBRIEF_STATUS_ID — the status identifier of the Field Service Report, driving workflow and closure logic.
• TRAVEL_START_TIME, TRAVEL_END_TIME, TRAVEL_DISTANCE_IN_KM — travel metrics captured for the visit, supporting cost and utilization analysis.
• SECURITY_GROUP_ID — the row-level security grouping, with a foreign key to FND_SECURITY_GROUPS.
• PROCESSED_FLAG and STATISTICS_UPDATED — internal processing indicators.
• OBJECT_VERSION_NUMBER — optimistic locking control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the Descriptive Flexfield segments, each VARCHAR2(150).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Note that two unique indexes exist: CSF_DEBRIEF_HEADERS_U1 on DEBRIEF_HEADER_ID (matching the primary key) and CSF_DEBRIEF_HEADERS_U2 on DEBRIEF_NUMBER. The surrogate key DEBRIEF_HEADER_ID is technically redundant with U1 but remains the referential anchor for child rows.

Common Use Cases and Queries

Typical reporting includes field service engineer productivity, visit frequency per customer, travel cost analysis, and debrief completion tracking. Common SQL patterns retrieve headers by business number, join to lines for full detail, or aggregate travel metrics over a date range.

• Lookup by business key: SELECT * FROM CSF.CSF_DEBRIEF_HEADERS WHERE DEBRIEF_NUMBER = :p_number;
• Join to detail lines: SELECT h.DEBRIEF_NUMBER, h.DEBRIEF_DATE, l.* FROM CSF.CSF_DEBRIEF_HEADERS h, CSF.CSF_DEBRIEF_LINES l WHERE h.DEBRIEF_HEADER_ID = l.DEBRIEF_HEADER_ID;
• Join to the originating task assignment: SELECT h.DEBRIEF_NUMBER, t.* FROM CSF.CSF_DEBRIEF_HEADERS h, JTF.JTF_TASK_ASSIGNMENTS t WHERE h.TASK_ASSIGNMENT_ID = t.TASK_ASSIGNMENT_ID;
• Travel reporting: aggregate TRAVEL_DISTANCE_IN_KM grouped by TRUNC(DEBRIEF_DATE) or by engineer.
• Status monitoring: filter on DEBRIEF_STATUS_ID to find open or incomplete reports.

Related Objects

• CSF.CSF_DEBRIEF_LINES — the child detail table, joined via DEBRIEF_HEADER_ID. Also likely referenced through the U.S. key CSF_DEBRIEF_LINES referencing this header. This is the most important dependent object.
• JTF.JTF_TASK_ASSIGNMENTS — the parent task assignment, joined via TASK_ASSIGNMENT_ID; links the report to resource and scheduling data.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, enforcing Multi-Org / security group access.

Because CSF_DEBRIEF_HEADERS sits between task assignments and debrief lines, any API or concurrent program that creates or updates Field Service Reports will touch this table through its primary key or the unique index on DEBRIEF_NUMBER.