Hi there . . . SQL Servier - ADP Enterprise
I am creating a Next Review Date report for our company scorecard and need to look at historical records.
Tables: PS_PERSONAL_DATA (ALIAS EE), PS_JOB (ALIAS JOB), AND PS_EMPLOYEE_REVIEW (ALIAS REVIEW)
I am looking for the REVIEW_DT and NEXT_REVIEW_DT that were active as of the JOB tables EFFECTIVE DATE (which is were I put in the historical date). If I dont put selection criteria on the review date I get all their records, and if I put the 'SELECT MAX' formula in the selection criteria I obviously am getting their MAXIMUM or current row. Does anyone know how to get the review date information as of the effective date I enter?
Thank you!!
I am creating a Next Review Date report for our company scorecard and need to look at historical records.
Tables: PS_PERSONAL_DATA (ALIAS EE), PS_JOB (ALIAS JOB), AND PS_EMPLOYEE_REVIEW (ALIAS REVIEW)
I am looking for the REVIEW_DT and NEXT_REVIEW_DT that were active as of the JOB tables EFFECTIVE DATE (which is were I put in the historical date). If I dont put selection criteria on the review date I get all their records, and if I put the 'SELECT MAX' formula in the selection criteria I obviously am getting their MAXIMUM or current row. Does anyone know how to get the review date information as of the effective date I enter?
Thank you!!