Driver and Cross-Reference Tables

The driver and cross reference tables record and control all events to be submitted to the eSocial environment. Every XML file generated for an eSocial event is based on a record from the driver table, and the cross-reference table for the record’s event. These two records contain the same two keys (driver sequence and driver split sequence) that uniquely identify a transaction in PeopleSoft.

The set of driver tables consist of:

  • The driver table

    The driver table stores general information about the identified event, such as driver sequence, action, status, timestamps, different IDs (Protocol, Batch, Receipt and Event) and so on.

  • Cross reference tables

    A cross reference table is present for each supported event layout. Cross reference tables store key information about the data being added, changed or deleted on components. Each table has at least the same key structure as its base HCM table.

Driver and cross-reference tables contain only references to retrieve all the information needed to generate XML files for eSocial events that occurred. Their records can be added, updated, or deleted as a result of:

  • Online transactions - when a transaction is saved in an eSocial-mapped component, a subscription message is fired, containing the transaction information needed for eSocial reporting. Records are added to the driver and corresponding cross-reference tables based on the component and subscription message content.

  • Batch processing, which are:

    • Initial data loading, which inserts driver and cross-reference records.

    • Mapping process and staging table loading, which update record statuses.

    • XML file generation, which update record statuses.

  • Status update from web service

    PeopleSoft receives status updates regarding file submissions from eSocial environment through a web service. Status information is updated in driver records as a result.

The driver table is the key element in driving the eSocial process flow; it is also the basic table that is used for the monitoring tool.