SAS® Solution for LDTI

Comprehensive LDTI solution

  • Templates for data quality controls, contract grouping and calculation for direct insurance and re-insurance contract groups (LFPB, DAC and MRB).
  • High-performance and in-memory calculations.
  • Calculation transparency and auditability.

LDTI reporting

  • Provides detailed historical financial reports down to the unit of measurement, applied in calculations and postings.
  • Let you drill down into reports to the details of the measures (movements) that affected a given item in the structure of accounts
  • Provides reports on data completeness (delivery of all required data packages and all needed cross-sections), accuracy of data (invalid values, confidence in data) and appropriateness of data.
  • Provides process quality reports on the advancement of all processes by entities (and whether the steps were finished in the required time and which users are falling behind).
  • Provides internal reports, including controlling and management reports. Additional reports may be added during the implementation project based on your requirements.
  • Enables you to drill back to data sources.
  • Provides reports in multiple formats (XLS, XML and CSV files).
  • Enables possible integration with regulator infrastructure (i.e., e-filing).
  • Provides database security, audit trails and versioning.

Phased implementation

  • Enables a gradual implementation based on industry best practices.
  • Provides a definition template of the process (i.e., preparing data, validations, calculations, allocations and reporting) and the ability to run calculations as instances of this template.

Process orchestration

  • Provides an integrated environment for managing risk and finance data including:
    • Data collection, aggregation and allocation.
    • Calculation of LDTI measures.
    • Creation of accounting entries and disclosures.
  • Integrates all external sources – actuarial, finance, risk – and the solution components.
  • Coordinates and performs all activities between IT, actuaries and finance.
  • A dashboard monitors end-to-end process execution and enables fast identification of problematic areas.
  • Includes the following activities:
    • Data management.
    • Calculation executions.
    • Worksheets that provide data views.
    • Planning and reporting, including management of file packages for regulatory submissions, process orchestration and auditing.
  • Data collection capabilities include data extraction, data quality checks, data enrichment and final validations.
  • Enables you to review input data and make needed adjustments.
  • Let you calculate LDTI measures with discounted or undiscounted cash flows.
  • Enables viewing of the calculation results. Additional validation rules may be involved at this stage.
  • Generates postings based on predefined account hierarchy. Manual adjustments and a direct feed of calculated LDTI measurements are possible at this stage.
  • Let you prepare a trial balance sheet report for additional analysis of results before they are pushed down to the general ledger.
  • Data packages are sent to other systems (i.e., the general ledger and reporting area).
  • Provides milestone project points where decision making is required (approve/reject results, sign-off).
  • Let you define collaboration and workflow.

Subledger function

  • Provides a dedicated data model for storing collecting, storing and combining key data at a granular level.
  • Periodically records a summary-level entry in the general ledger. If information in a general ledger account contains this summarized information, you can access the SAS subledger to review transaction-specific information.
  • Stores and manages accounting events.
  • Store and manages a ledger with a chart of accounts.
  • Let you define mapping rules.
  • Let you generate, reverse, repeat and manually update postings.
  • Provides administration of accounting definitions, account details, mapping rules and postings (review, update, revert or redo).
  • Supports multiple accounting standards.
  • Supports multiple currencies.
  • Defines the structure of accounts for LDTI
  • Defines of LDTI-specific posting rules.
  • Calculates and stores LDTI measures and its movement analysis.

Data management

  • Includes a predefined, extensible data model.
  • Provides comprehensive data management capabilities, including: connectivity and centralized metadata; data cleansing; ETL; data migration and synchronization; data federation; and master data management. Also provides:
    • Landing area with configuration, mapping and fact tables.
    • Results data area with measurement and posting tables.
    • Data archive.
    • Data quality rules to check volume, completeness and accuracy of the inputs.
    • Data governance business glossary and metadata manager, lineage visualizer and reference data manager.
  • For data access and delivery:
    • SAS® Federation Server provides dynamic data masking of secure, cached data from multiple traditional and big data sources on demand through integrated virtual views without physically moving the data.
    • SAS/ACCESS® software provides seamless and transparent read, write and update access to more than 60 data sources, including relational databases, big data technologies such as Hadoop and Impala, nonrelational databases, PC files and data warehouse appliances.
    • SAS® Data Surveyor for SAP provides access to SAP B/W metadata, which increases productivity and decreases time and costs for SAP integration.
  • For integrating and transforming data:
    • SAS Data Loader for Hadoop enables self-service big data access to profile, transform and prepare Hadoop data for visualization or analytics.
    • SAS Data Management enables you to join, transform, cleanse and govern your data for the purposes of creating reports, populating a data warehouse via ETL, modernizing legacy applications and databases, or performing analytics.
  • For data quality and governance:
    • SAS Data Quality enables you to cleanse, standardize and transform your data, driving more accurate reporting and analytics and better business decisions.
    • SAS Data Governance puts the policies, processes and rules in place to manage data with consistency and transparency and better align business and IT.

Accounting process

  • Translates calculation results into journal entries that will be fed to the general ledger.
  • Provides a definition of accounting events that drive the postings.