OIP_ADDRESS Table - Data Element Index . Tables and Data Elements . ISSS Data Home . Data Warehouse Home

OIP_ADDRESS Table

(dwoip.oip_address)

Explanation

This table contains the address for a given person, as provided to the Office of International Programs by the individual (foreign address is populated on this table).

Cautions

• A person can have more than one address; Oip_Id_Number will not be unique on this table.
• State_Province is free-form entry; values are not validated by source system.
• Use OIP_COUNTRY_CODE to decode the country in the OIP_ADDRESS table, as SRS country codes are not exactly the same as OIP country codes.

 OIP_ADDRESS Table - Data Element Index . Tables and Data Elements . ISSS Data Home . Data Warehouse Home