Address records in Core+ are split between two tables:
DT_COMMON_ADDRESS
DT_COMMON_ADDRESS_HISTORY
The common field between these two tables and a young person is the Common_Address Ref.
The fields for a young person are held in the following tables:
Current address | DT_COMMON_ADDRESS |
Historical address | DT_COMMON_ADDRESS_HISTORY |
To ease reporting on addresses, a materialised view, which is essentially a dynamic table, called uv_Common_Address, is available.
If you are in CVDBView, you can query this directly. If you’re using Crystal Reports, you may need to do the following to make the view available:
Click File.
Click Options.
Click the Database tab.
Under Data Explorer, select the View checkbox.