Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The ITS Admin Application has a database link to pull data from the HR Datamart.

  • There is a daily sync (need to verify if M-F only) nightly sync that copies the data from a PeopleSoft backup to the HR Datamart.

    • ex. the backup of PeopleSoft is created on 9/22 and is loaded into the HR Datamart on the morning of 09/23.

    This

    • [From PeopleSoft Team] The process runs nightly, 7 days a week:

      • From 6pm to midnight:

        • Batch programs take extracts from PeopleSoft in the evening between 6pm to midnight.  

      • @ 1:45AM

        • A loader program runs on HR Datamart to import the extract files into the datamart tables

  • If the nightly sync fails, this could affect attempts to use the “Add New Staff (HRDW)” link

    • if the New Hire’s record is not NOT found in the HR Datamart, the process will throw an error message: “Search Found No Records Matching Your Query.  Please Check Your Search Criteria and Try Again.”

...