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 that have no following placement or placements that have no future trainee, 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
Activity Diagram
Sequence Diagram
20:00 APC Import
Activity Diagram
Sequence Diagram
0 Comments