Sometimes PGY training records will be listed with a status of "No Documents" although there are documents uploaded for the given PGY, and they cannot be approved in this status. The steps to fix this are as follows:
Run the following query to get the training IDs for the physician:
Select * from Training where Person_Key = @PersonKey
Note the training IDs and include them in the following query to determine which one matches the PGY sequence:
Select * from PostGraduateYear where TrainingId in (@TrainingIds)
Once you have identified the correct training ID to update, run the following query:
Update Training Set ReviewStatus = 6 (To Be Reviewed) Where TrainingId = @TrainingId