...
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 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/1643903293022708717333
TUPS_FUNDING_SOURCE
TUPS_GRANT
TUPS_JOURNAL
Troubleshooting
When any error is encountered by the PS Sync SQL script, it will be recorded in the log file and an email notification will be sent to the RAS support email list with the subject "RAS/PS Integration Error Detected".
...