OIP Address table elements


			<< go back

Oip_Address_Id	Each address’ unique identifier.
Oip_Id_Number	The unique identifier for a record (use this value to map records in this data collection).
Address_Type	Represents the address type. For example: F – Foreign
Street	Street address
Street2	Continuation of street address
City	City
State_Province	State or Province
Postal_Code	Postal code
Country	Country code of address (use OIP_COUNTRY_CODE to map country description).
Last_Activity_Date	Date the record was last modified by source system.
Last_Extract_Date	Date the record was last imported into the data warehouse.

Questions about this page? Email us at da-staff@isc.upenn.edu