Payroll: ACA Detail by Employee

ACA information by employee filtering to employees with activity for the selected year.

select 
EMP_ID,SSN,DISPLAY_NAME,FIRST_NAME,MIDDLE_NAME,LAST_NAME,NAME_SUFFIX,DATE_OF_BIRTH,
 ACA_FTE_FLAG,ACA_PLAN_START_MONTH,ACA_OFFER_CODE_YR,
 ACA_OFFER_CODE_1,ACA_OFFER_CODE_2,ACA_OFFER_CODE_3,ACA_OFFER_CODE_4,ACA_OFFER_CODE_5,ACA_OFFER_CODE_6,ACA_OFFER_CODE_7,ACA_OFFER_CODE_8,ACA_OFFER_CODE_9,ACA_OFFER_CODE_10,ACA_OFFER_CODE_11,ACA_OFFER_CODE_12,
 ACA_EMP_SHARE_YR,ACA_EMP_SHARE_1,ACA_EMP_SHARE_2,ACA_EMP_SHARE_3,ACA_EMP_SHARE_4,ACA_EMP_SHARE_5,ACA_EMP_SHARE_6,ACA_EMP_SHARE_7,ACA_EMP_SHARE_8,ACA_EMP_SHARE_9,ACA_EMP_SHARE_10,ACA_EMP_SHARE_11,ACA_EMP_SHARE_12,
 ACA_SAFE_HARBOR_YR,ACA_SAFE_HARBOR_1,ACA_SAFE_HARBOR_2,ACA_SAFE_HARBOR_3,ACA_SAFE_HARBOR_4,ACA_SAFE_HARBOR_5,ACA_SAFE_HARBOR_6,ACA_SAFE_HARBOR_7,ACA_SAFE_HARBOR_8,ACA_SAFE_HARBOR_9,ACA_SAFE_HARBOR_10,ACA_SAFE_HARBOR_11,ACA_SAFE_HARBOR_12,
 ACA_CONTROL_TEXT,ACA_CORR_RECORD_ID,ACA_CORR_SSN,ACA_CORR_FIRST_NAME,ACA_CORR_MIDDLE_NAME,ACA_CORR_LAST_NAME,ACA_CORR_NAME_SUFFIX,ACTIVE_FLAG
from prtemployee ee
where exists (select 1 from prtempdefhst eh where eh.emp_id=ee.emp_id and trx_date between :"Yr Begin Date" and :"Yr End Date")