Most Recommended ASRs, Most Deferred ASRs, Most Sold ASRs

ASRs:

1. In case of Most Recommended ASRs IDMS_ASR_LOG CreateDate in between now and start of the year before today (01/01/2021).
2. In case of Most Deferred ASRs, we also filter by DeferredStatus == Declined.
3. In case of Most Sold ASRs, we also filter by DeferredStatus == Approved.

• ASRsCurrent: from the ASRs above we keep the entries with CreateDate in the selected time frame (YTD, QTD, MTD).
• ASRCCs: IDMS_ASR_CC where codes exist in the ASRsCurrent above distinct by jcCode and then by asr_cccode.

Calculations

We return an ordered list ASRCCs by the count of CCCodes existing in the ASRCCs above.