Document Management System( Lab MDL)

Steps:
1. For an employee - add different position so that all the different types of Tranings are added to the employee automatically
2. Note down the serial number of the employee say 151
3. Open DB And note down the upload_limit_date for the employee using the query:
SELECT upload_limit_date FROM docs_crm.training where employee_id = 151

ER:

DOC TYPE                              EXPECTED UPLOAD_LIMIT_DATE
Safety Initial                        3 months from position start date
Safety Annual                         One year from initial
Training Logs                         Last day of the current month
HIPAA                                 Mid year - end of june
Thin Prep Pap Morphology Certificate  Last day of current year

As per the above, eg: for 151, the Job Position start date is 08-Aug-2019
So, the expected Dates are below:

DOC TYPE                              EXPECTED UPLOAD_LIMIT_DATE
Safety Initial                        08-Nov-2019
Safety Annual                         08-Nov-2020
Training Logs                         31-Mar-2020
HIPAA                                 30-Jun-2020
Thin Prep Pap Morphology Certificate  31-Dec-2020

AR:
The dates shown are as below:

DOC TYPE                              ACTUAL UPLOAD_LIMIT_DATE
Safety Initial                        25-Apr-2020
Safety Annual                         26-Mar-2021
Training Logs                         02-Apr-2020
HIPAA                                 09-Apr-2020
Thin Prep Pap Morphology Certificate  09-Apr-2020