If an old CCBlock passes an audit then they will be exempt from fulfilling activity requirements. In this case they will need to be manually updated to Complete so that a more current CCBlock can be worked on by the physician. The steps to do so are as follows:
1. Identify the CCEnrollmentId for the physician
SELECT * FROM CCEnrollment WHERE person_key = 154542
2. Identify the CCBlocks for the given CCEnrollment
SELECT * FROM CCBlock WHERE CCEnrollmentId = 6651
3. Update the old CCBlock to Complete
--UPDATE CCBlock SET Complete = 1 WHERE CCBlockId = 16539 AND CCEnrollmentId = 6651
4. Update the CurrentCCBlockId in CCEnrollment to the next block and set the LastEvaluationDate to null
--UPDATE CCEnrollment SET CurrentCCBlockId = 115957, LastEvaluationDate = NULL WHERE CCEnrollmentId = 6651
5. Go into BC, scroll down to the Certificates component and verify that the CC Status is set to Meeting. If it is not, update Certificate.CCStatusId to 1.
6. Also in the BC CC section, verify that the current block is now the block years you set it to
7. In Portal, verify that the older block highlighted in red that you updated to complete is now gone, and that only the current block is displaying.