Record U_CC_PDATA_TBL is best for pulling addresses, except it updates nightly. Use this record or ADDRESSES4_VW to include changes made today, or when you need an address other than HOME and MAIL. |
Join to this table to pull addresses. |
Addresses are routinely marked as Inactive. To pull active addresses: EFF_STATUS = A |
International addresses use the 4 address lines, and DO NOT use City, St and Postal. |
To pull permanent: ADDRESS_TYPE = HOME |
To pull local: ADDRESS_TYPE = MAIL |
You will lose students in the pull if they do not have a current active address for the type queried. |