Document Management System( Lab MDL)

Steps:
1. For an employee - add different position so that all the different types of L.C.A 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.competency_assessments where employee_id = 151

ER:
1. Initial - The expected upload_limit_date is 3 months from position start date
2. Advanced - The expected upload_limit_date is 6 months from initial
3. Annual - The expected upload_limit_date is one year from advanced

As per the above, eg: for 151, the Job Position start date is 08-Aug-2019
So, initial expected upload_limit_date is 08-Nov-2019
Advanced - expected upload_limit_date is 08-May-2020
Annual - expected upload_limit_date is 08-May-2021

AR:
The dates shown are as below:
Initial: 25-May-2020
Advanced: 25-May-2020
Annual: 17-Aug-2021