Date range (ACHV_DAT Where dates are specified in months this where the 1 month) refers to one calendar month. As the – date is a Achievement Date is usually the last day fixed date at of a month, this example would calculate the end of a the last day of the previous calendar month. month. e.g. 1) if Achievement Date was 30th April, this example would return 31st March. e.g. 2) if Achievement Date was 31st March, this example would return 28th February (or 29th February in a leap year). Activity VACCINE_DAT > This example look for activity within within date (ACHV_DAT 1 or after the 1 month period leading up to – range where month) the Achievement Date. e.g. if the date is a Achievement Date was 30th April, this example would return activity after fixed date at the end of a 23:59:59 on 31st March (i.e. activity from month. 00:00:00 on 1st April). This type of calculation could be treated the same as >= “VACCINE_DAT ((ACHV_DAT + 1 day) 1 month)” where – the result would also be activity from 00:00:00 on 1st April. Date range (PAT_DOB + 1 This example would calculate the date 1 where month) calendar month after the PAT_DOB. As reference the PAT_DOB could be at any point date is not a during the month, this example would fixed date at calculate the same day of the next month. the end of e.g. if PAT_DOB was 10th April, this the month. example would return 10th May. If the PAT_DOB does fall on the last day of a month or on a day where there is no corresponding date for the next month (e.g. 29th, 30th and 31st January) then this example would calculate the ‘closest’ valid date (29th, 30th or 31st January + 1 calendar month = 28th Feb or 29th Feb in a leap year).
Date range where the date is a fixed date at the end of a month. (ACHV_DAT – 1 month) Where dates are specified in months this refers to one calendar month. As the Achievement Date is usually the last day of a month, this example would calculate the last day of the previous calendar month. e.g. 1) if Achievement Date was 30th April, this example would return 31st March. e.g. 2) if Achievement Date was 31st March, this example would return 28th February (or 29th February in a leap year). Activity within date range where the date is a fixed date at the end of a month. VACCINE_DAT > (ACHV_DAT – 1 month) This example look for activity within or after the 1 month period leading up to the Achievement Date. e.g. if Achievement Date was 30th April, this example would return activity after 23:59:59 on 31st March (i.e. activity from 00:00:00 on 1st April). This type of calculation could be treated the same as “VACCINE_DAT >= ((ACHV_DAT + 1 day) – 1 month)” where the result would also be activity from 00:00:00 on 1st April. Date range where reference date is not a fixed date at the end of the month. (PAT_DOB + 1 month) This example would calculate the date 1 calendar month after the PAT_DOB. As the PAT_DOB could be at any point during the month, this example would calculate the same day of the next month. e.g. if PAT_DOB was 10th April, this example would return 10th May. If the PAT_DOB does fall on the last day of a month or on a day where there is no corresponding date for the next month (e.g. 29th, 30th and 31st January) then this example would calculate the ‘closest’ valid date (29th, 30th or 31st January + 1 calendar month = 28th Feb or 29th Feb in a leap year).
business_rules_supporting_information_v1.2.docx