PAPPRSQL.cbl

Periodic Process – Data Retrieval – Program

Overview

PAPPRSQL.cbl is used by the Periodic Process to select and update data during the process.  All database interactions required by the main Periodic Process module (PAPPRCTL.cbl) are handled by this module.  This includes connecting to the database,  loading the Run Control and Application Trace settings, resolving the requested population and group definitions, retrieving Periodic Process input data from HR, Benefits, and Pension tables, writing results, and updating process scheduler statuses.