Results for “z0_94_1”

20 results




Overview
Explore in AI Chat

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.