Bitte für Wiki Eintrag formatieren:
# INTEGRATION_LAYER: Monthly Consolidation and Processing ## Overview The INTEGRATION_LAYER serves as the central consolidation point for all data processing within the system, performing monthly data aggregation, transformation, and validation before final output. ## Structure and Key Features The INTEGRATION_LAYER consolidates all data through the following mechanisms: **Unified Data Table**: All interface-specific data is merged into the IL_BASE table, providing a single source of truth for consolidated information. **SUPPLY_ID Consolidation**: Each combination of SST (Source System Type) and FISCAL_PERIOD maintains a unique SUPPLY_ID, with the exception of supplementary deliveries which receive separate identifiers. **Processing Prerequisites**: - Complete data availability for month-end processing - Currency exchange rates must be available for the completed month **Transaction Type Classification**: - BALANCE: Stock quantities (e.g., from FSCD_PREMIUM) - POSTING: Flow quantities (e.g., from FSCD_CA, MANDA) ## Monthly Processing Workflow The monthly processing cycle consists of three sequential critical process steps, each followed by status updates and reconciliation procedures: ### 1. UPR (Unearned Premium) Processing This step handles the processing of balance quantities (BALANCES). Upon completion, the system assigns status codes based on the outcome: - Successful processing: STATUS = 3200 - Reconciliation errors: STATUS = 3199 ### 2. DELTA (Movement Calculation) The DELTA process calculates changes by comparing current month values against previous month UPR values. Status assignments include: - Successful processing: STATUS = 3300 - Reconciliation errors: STATUS = 3299 ### 3. FX (Currency Effects) Currency effects are determined through Year-to-Date (YTD) analysis of cumulative amounts. The process concludes with: - Successful processing: STATUS = 4000 - Reconciliation errors: STATUS = 3999 ## Reconciliation and Quality Assurance Quality control is maintained through systematic reconciliation procedures: - Reconciliation occurs after each process step - Results are documented in a separate reconciliation table - The STATUS value of each SUPPLY_ID is updated accordingly - This approach ensures data integrity and traceability throughout the entire process ## Supplementary Deliveries: Special Processing Supplementary deliveries require specialized handling within the system: **New SUPPLY_ID Assignment**: Each supplementary delivery receives a new, separate SUPPLY_ID to maintain data lineage. **DELTA Process Integration**: The system identifies and integrates differences compared to the previous delivery. **FX Process Adjustment**: Currency effects are recalculated based on the new data provided. **Final Integration**: All calculated differences are integrated into the IL_BASE table. ## POSTING_LAYER: Final Output The processed data is ultimately distributed into two primary output tables: **PL_BALANCES**: Contains all records where TRANSACTION_TYPE = 'BALANCE' **PL_POSTINGS**: Contains all records where TRANSACTION_TYPE = 'POSTING' This systematic processing approach within the INTEGRATION_LAYER ensures that all data is correctly consolidated, transformed, and validated before being made available in the final output tables. The architecture supports both data integrity and operational transparency through comprehensive status tracking and reconciliation procedures.