The following is a collection of diagrams of the current ESR interface in TIS (Pre Bi directional work).
6am Notification Daily Load
This job executes the ESR ETL and triggers 2 endpoints in the TCS service that then using Placements Posts that have no following placement or placements that have no future trainee, Next Trainee will become Current Trainee on a Post in 13 weeks) where 13 weeks from today is their earliest eligible date to send to ESR.creates EsrNotification records. These records are then picked up by two other job that run later (17:00 Application export & 17:30 Notification daily)
Activity Diagram
Sequence Diagram
15:30 Applicant Load
This job kicks off the ESR ETL, it downloads a file from Azure and generates PositionInformation, PositionReconciliation and ApplicantDetail records from these files. If there are issues creating these records, then a confirmation file is created and uploaded to Azure for ESR to pick up.
It then updates the records with information from Posts from TCS and pushes these records to the ESR service. Once thats done, another confirmation file is uploaded as well as RMT exceptions files are created for Position and Reconciliation. Finally the report is created for any mismatched positions.
The PositionInformation, PositionReconciliation and ApplicantDetail Records are then used by the 17:00 Applicant Export and the 17:30 Notification Daily Jobs
Activity Diagram
Sequence Diagram
17:00 Applicant Export
This job triggers the ESR-ETL, this job uses the previous data extensively to create ApplicantDetailRecords from PositionInformation and PositionReconciliation Records. To ensure that the same records are not picked up again from the ESR Service, they are updated and saved before the ApplicantDetail file is generated and uploaded to Azure
Activity Diagram
Sequence Diagram
17:30 Notification Daily Export
Triggered at 17:30, Use all the notifications, PositionInformation and PositionReconciliation records to create a NotificationRecords for both type 1 and the rest. With the NotificationRecords generate a notifications file, upload to Azure then save them in the ESR service,
Activity Diagram
Sequence Diagram
20:00 APC Import
This job downloads the APC (Applicant Confirmation) file from Azure, creates ApplicantConfirmation records and saves them in the ESR service. This file contains the results from ESR's processing of the APP file that we upload
Activity Diagram
Sequence Diagram
Add Comment