Page Comparison

...

The PeopleSoft Financial system monitors these tables for new transactions. When a transaction is found, PeopleSoft reads the data and creates or updates the Funding Source, Grant, and Journal according to the given data (step 5). PeopleSoft then updates the transaction in the shared tables with a success or error status (step 6) and sends email notifications to the user informing them of the success or failure of the operations (step 7).

Technical Components

The core of the RAS-PS integration is a SQL script which is run every five minutes via a cron job. (See the Automated Tasks section of the Operational Environment page.) This script contains all of the logic for pulling award/budget data from the RAS database tables and populating the shared PS tables with the appropriately. It also handles comparison of current budget data with the budget history so that the PeopleSoft totals can be adjusted by the correct amount. This is important because, for security reasons, RAS does not have direct visibility into the PeopleSoft transactions. Instead it uses the budget history within the Award Budget Tool to determine how much the account should be changed by. (Example: If budget 1.0 allocates $1000, and budget 2.0 increases that amount to $1500, RAS compares the two and sends PS the net change of $500.)

The primary database tables used in the integration are TUPS_FUNDING_SOURCE, TUPS_GRANT, and TUPS_JOURNAL. These are the tables which PeopleSoft reads to create or update the Funding Source, Grant, and Budget Journals.

The schemas for these tables are below. More detailed information on the fields and specifications for the integration can be found on Box at: https://tufts.app.box.com/folder/16439032930