...
Margo has had CU_BAR_SR_00077_2 the query which doesn't pick up the currently enrolled students. Therefore, The the existed just have modified to pick up the current enrolled students. After modification the query has been delivered to Margo and Patrick. Please see the Kace ticket for detail reference: https://helpdesk.baruch.cuny.edu/admin 37529.
Criteria:
The In the sub-query the Residency record has been picking up the latest student residency information but effective _term should be less than prompted term. Otherwise, it will not picking pick up the current student.
| FROM PS_RESIDENCY_OFF O WHERE ( O.EMPLID = F.EMPLID AND O.ACAD_CAREER = F.ACAD_CAREER AND O.INSTITUTION = F.INSTITUTION AND O.EFFECTIVE_TERM <= :2 ) |
|---|
...