...
Please see the ticket in Kace system for reference: https://kbox.baruch.cuny.edu/userui/ticket?ID=36296
...
Query Development
Query:
Three additional tables have been added:
- ADDRESSES4_VW - Addresses View for Curr EffDT
- RESIDENCY_OFF - Official Residency Data
- SCC_VISA_P_QVW - Visa Data Query View
Sub-query:
EFFECTIVE_TERM - Effective Term: To find students with most updated address information in the current term by using this field Through RESIDENCY_OFF - Official Residency Data record.
Image of CU_BAR_SR_00054_5:
...