Results for “adr_concat”

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

Overview

The AP.JE_FR_DAS_010_NEW table is the revised repository for French DAS (Déclaration Annuelle des Salaires) declaration data within the Oracle E-Business Suite European Localizations module (product code JE). Maintained in the AP schema, it is documented as the new version of the legacy JE_FR_DAS_010 table and is flagged VALID in ETRM 12.2.2. The table operates as a French statutory reporting structure that consolidates employer establishment identities, address attributes, and reporting classifications used to produce the annual salary declaration for French tax authorities.

Following metadata-driven heuristic analysis, the object is classified as standalone within the Data Vault model. Where a Data Vault pattern were applied, the table would function as a modeled satellite clustered around the composite key of SET_OF_BOOKS_ID and TYPE_ENREG. It maintains no mined foreign-key dependencies, reinforcing the standalone classification, though its SET_OF_BOOKS_ID column establishes a logical association with the General Ledger set of books.

Key Information Stored

The table contains 36 documented columns, of which the most significant are summarized below.

• SET_OF_BOOKS_ID — Part of the primary key JE_FR_DAS_010_NEW_PK and of the unique index JE_FR_DAS_010_NEW_U1; identifies the accounting set of books to which the declaration belongs.
• TYPE_ENREG — Part of both the composite primary key and the unique business index; the registration/record type (the French "type d'enregistrement") that distinguishes declaration categories. This is the column referenced by the user's search term "type_enreg".
• SIRET_ENTR and SIRET_ETAB — SIRET numbers for the legal enterprise and the establishment respectively, the statutory identifiers required for the declaration.
• RAISON_SOCIALE — Registered company name of the declaring entity.
• CODE_APE — French APE (Activité Principale Exercée) activity code.
• ADR_* group (ADR_COMPL, ADR_CONCAT, ADR_INSEE, ADR_COMMUNE, ADR_CPOSTAL, ADR_BUR_DIST) — Structured address attributes for the enterprise: complement, concatenated address, INSEE commune code, commune name, postal code, and postal distribution office.
• ADR_*_ET group — The establishment-level equivalents of the enterprise address attributes above.
• TYPE_FICHIER — File/record type indicator governing declaration formatting.
• Z01, Z0_94_1, Z0_94_2, Z1, Z3 through Z11 — Reserved and functional DAS declaration fields (notably the historical Z0.94 series) carried for fixed-position reporting.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN provide standard who-did-what auditing.

Common Use Cases and Queries

The table is primarily consumed by French DAS declaration processes, which extract per-set-of-books records filtered by TYPE_ENREG to build the annual statutory file. A typical lookup pattern is:

• Retrieve all declarations for a set of books: SELECT * FROM AP.JE_FR_DAS_010_NEW WHERE SET_OF_BOOKS_ID = :p_sob_id;
• Isolate a specific declaration type using the user's search term: SELECT * FROM AP.JE_FR_DAS_010_NEW WHERE SET_OF_BOOKS_ID = :p_sob_id AND TYPE_ENREG = :p_type_enreg;
• Report employer identity: SELECT SIRET_ENTR, RAISON_SOCIALE, CODE_APE, ADR_CPOSTAL, ADR_COMMUNE FROM AP.JE_FR_DAS_010_NEW WHERE TYPE_ENREG = :p_type_enreg;
• Establishment address reporting: SELECT SIRET_ETAB, ADR_CPOSTAL_ET, ADR_COMMUNE_ET, ADR_INSEE_ET FROM AP.JE_FR_DAS_010_NEW;
• Audit change tracking: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE FROM AP.JE_FR_DAS_010_NEW;

Because SET_OF_BOOKS_ID and TYPE_ENREG together form the unique business key, queries constrained on those two columns benefit from the JE_FR_DAS_010_NEW_U1 index.

Related Objects

The table documents no mined foreign-key relationships, so dependencies are largely logical rather than enforced. The most significant related objects are:

• AP.JE_FR_DAS_010 — The predecessor table that JE_FR_DAS_010_NEW supersedes.
• GL_SETS_OF_BOOKS — Joined via SET_OF_BOOKS_ID to resolve the accounting set of books.
• GL_LEDGERS — Joined via SET_OF_BOOKS_ID for ledger-level reporting in 12.2.2.
• Other JE_FR_DAS_* tables — Companion French DAS localization tables keyed by SET_OF_BOOKS_ID and TYPE_ENREG.
• AP.JE_FR_DAS_010_NEW_PK / JE_FR_DAS_010_NEW_U1 — Primary key and unique index objects that enforce record uniqueness.
• French DAS concurrent programs — Report and extraction programs consuming this table to generate the annual declaration file.