Data Warehouse: OIP Tables and Data Elements



	UPDATES
	Current Load Status
	Regular Availability

	INFORMATION
	FAQs & Tips
	Password Changer
	Support services
	Security
	About the Data Warehouse
	Data Administration

	DATA COLLECTIONS
	Advancement
	Assets
	BRIM
	Express Mail
	Facilities
	Faculty
	GAR
	General Ledger
	Infrastructure
	Learning Management
	OIP
	Position Inventory
	Research-PennERA Proposals
	Salary Management
	Student
	Tuition Distribution
	Cross-Collection

Office of International Programs Collection
Tables & Data Elements

Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table.
Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table.
A description of table and data element terminology is in the document What the Warehouse Contains.

Data Tables

OIP_PERSON_EMPLOYEE
Table    Elements

OIP_IMMIGRATION_STATUS_HISTORY
Table    Elements

OIP_ADDRESS
Table    Elements

Lookup Tables

OIP_COUNTRY_CODE
Table    Elements

OIP_COUNTRY_CODE_SRS
Table    Elements

OIP_IMMIGRATION_STATUS_CODE
Table    Elements

OIP_IMMIGRATION_STATUS_CD_SRS
Table    Elements

Uploads to Other systems

SRS_UPLOAD_V
Table Elements

Collection Information:



Information Systems and Computing University of Pennsylvania Comments & Questions

Office of International Programs Collection Tables & Data Elements

Office of International Programs Collection
Tables & Data Elements