SELECT PTP.END_DATE , PER.FULL_NAME , PER.EMPLOYEE_NUMBER , PER.BUSINESS_GROUP_ID , TIM.ID TIM_ID , TIM.BATCH_ID FROM PER_PEOPLE_F PER , PER_TIME_PERIODS PTP , HXT_TIMECARDS TIM WHERE TIM.FOR_PERSON_ID = PER.PERSON_ID AND TIM.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID AND PTP.END_DATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE