Results for “je_fr_das2_etb_headers_t”

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

Overview

The JE_FR_DAS2_ETB_HEADERS_T table is a localized reference table belonging to the JE – European Localizations product family, owned by the AP schema and marked VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store header-level information for a French établissement (establishment) — the statutory reporting unit used for DAS2 (Déclaration Annuelle des Salaires) declarations and related French fiscal and social reporting obligations. The table captures the identifying, address, activity, and registration attributes that describe a declared establishment within a legal entity.

The record is scoped to a specific legal entity, establishment, and set of books, making it a configuration and statutory-attribute store rather than a transactional table. Because its keys are foreign references to FV_LEGAL_ENTITIES and PER_ESTABLISHMENTS, the ETRM metadata classifies it heuristically as standalone — meaning it is not documented as a dependant (satellite) of a business hub within the vault model. A modeling suggestion would be to treat it as a descriptive reference/dimension table keyed on the combination of legal entity and establishment rather than as a pure satellite.

Key Information Stored

The table contains 35 documented columns. The most significant are:

• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES; identifies the legal entity owning the establishment.
• ESTABLISHMENT_ID — foreign key to PER_ESTABLISHMENTS; identifies the establishment record.
• SET_OF_BOOKS_ID — the ledger (set of books) context for the declaration data.
• SIREN_ETAB and NIC_ETAB — the French SIREN (legal entity) and NIC (establishment) registration numbers.
• SIRET_01_JAN and NIC_01_JAN — statutory SIRET/NIC values as of 1 January of the declaration year.
• SECTION_DAS, VALIDITE, TYPE_DAS, TYPE_ENREG — DAS2 section, validity, type, and registration indicators.
• RAISON_SOCIALE — the corporate/legal name reported on the declaration.
• ADR_COMPL, ADR_CONCAT, ADR_INSEE, ADR_COMMUNE, ADR_CPOSTAL, ADR_BUR_DIST — address components (complement, concatenated address, INSEE code, town, postal code, business district).
• CODE_APE — the APE/NACE activity classification code.
• PROFESSION and CODE_TAXE_SAL — professional category and salary tax code.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

No primary key or unique index is explicitly documented in the available metadata; the natural business key is the combination of LEGAL_ENTITY_ID, ESTABLISHMENT_ID, and SET_OF_BOOKS_ID, which should be treated as the candidate unique key.

Common Use Cases and Queries

The table is primarily consumed by French DAS2 declaration generation and by statutory reporting extracts. Typical usage includes retrieving establishment headers for a legal entity and period, validating address and SIRET data before submission, and joining to establishment master data for reconciliation.

Example query pattern:

• Select establishment headers for a legal entity: SELECT h.ESTABLISHMENT_ID, h.SIREN_ETAB, h.NIC_ETAB, h.RAISON_SOCIALE, h.ADR_CPOSTAL, h.ADR_COMMUNE FROM AP.JE_FR_DAS2_ETB_HEADERS_T h WHERE h.LEGAL_ENTITY_ID = :p_legal_entity_id;
• Join to establishment master: SELECT h.*, p.NAME FROM AP.JE_FR_DAS2_ETB_HEADERS_T h, PER_ESTABLISHMENTS p WHERE h.ESTABLISHMENT_ID = p.ESTABLISHMENT_ID;
• Validate against legal entity: SELECT h.* FROM AP.JE_FR_DAS2_ETB_HEADERS_T h, FV_LEGAL_ENTITIES le WHERE h.LEGAL_ENTITY_ID = le.LEGAL_ENTITY_ID;

Reports commonly filter by SET_OF_BOOKS_ID and audit timestamps to extract the current establishment header set per declaration year.

Related Objects

The most significant related objects, based on the documented foreign-key relationships, are:

• FV_LEGAL_ENTITIES — joined via LEGAL_ENTITY_ID; the legal entity master.
• PER_ESTABLISHMENTS — joined via ESTABLISHMENT_ID; the establishment master.
• JE_FR_DAS2_ETB_LINES_T (likely companion) — line-level DAS2 establishment details that depend on this header.
• GL_SETS_OF_BOOKS / GL_LEDGERS — joined via SET_OF_BOOKS_ID for ledger context.
• DAS2 reporting concurrent programs and localization views in the JE product that consume these headers for statutory file generation.

These relationships confirm that JE_FR_DAS2_ETB_HEADERS_T functions as a descriptive, entity-scoped reference for French establishment reporting within Oracle EBS European Localizations.