FNSTG001 : This is a job for Finance Staging to get data from PeopleSoft (FNPRD). These data in staging will be later used for data integration. It currently pulls data from two tables, however, an additional table can be added on this job or completely new additional staging job will be created as needed. The following 4 jobs are contained in this job.
- FNS00_dbConnect : Job for connecting to the database (FNPRD). Screenshots are on this page.
- FNS01_Main_Loop : Initiate individual staging jobs. Create job success email.
- FNS02_UM_GLQ_REPRTING : Job to get the data from UM_GLQ_REPRTING table in FNPRD
- FNS03_UM_GLQ_ACCTA : Job to get the data from UM_GLQ_ACCTA table in FNPRD
(Google Drive for files (Restricted access))
Attachments:
image2019-8-30_10-12-35.png (image/png)
image2019-8-30_10-13-59.png (image/png)
image2019-11-18_15-38-56.png (image/png)
image2019-11-18_15-49-16.png (image/png)
