The International Student and Scholar Services (ISSS) Collection is a subset of the University Data Warehouse containing data from the ISSS data maintenance system named iOffice. The collection includes address and visa information for both employees and students of the University of Pennsylvania whose entry point into the University is via ISSS.
Tables are listed in alphabetical order. 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.
Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).
| 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 |
||
The International Student and Scholar Services information is loaded to the Data Warehouse in batch on weeknights (Monday through Friday) at 7:00 pm.
Source of the Data
The data are collected by the ISSS operational system, iOffice.
Time Span Covered
The ISSS data collection was first made available in the Data Warehouse in the Fall of 2009. Some historical data are available in this collection for terms prior to Fall 2009, but the data from earlier terms may not be complete, as they came from a different source.
The International Student and Scholar Services Data Collection is described in the following diagrams. Each diagram illustrates the architecture of a specific segment of the data collection and identifies the join criteria between tables.
The OIPiOffice diagram provides access to the "OIP iOffice" BusinessObjects universe.
Data training for this collection is offered on an ad hoc basis -- please contact Enterprise Information & Analytics for assistance with specific training questions. You can also refer to the table and element documentation for information and cautions about specific data.
Those who wish to access the International Student and Scholar Services data collection must submit the OIP Data Warehouse Access Request eForm.
Releasing Data Outside the University
The only two offices that may disclose employee, job, or salary data outside the University are the Division of Human Resources and Institutional Research & Analysis. If you do not work for those offices and you receive a request for data to be sent outside the University, refer the requester to the Division of Human Resources.
Releasing Data Within the University
Within the University, employee, job, or salary data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for employee, job, or salary data, call the Division of Human Resources.
Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).
For more information on security and privacy, contact the Office of Information Security.
Help is available through OIP-WH@LISTS.UPENN.EDU. When you are granted access to the data collection in the warehouse, you are automatically subscribed to participate in an email listserv named OIP-WH@LISTS.UPENN.EDU. (Those with subscriptions to the list are called list members.) If any member sends an E-mail to the list, every member of the list receives a copy.
When you have a question. If you have a question about the ISSS data, please send E-mail to the list -- and if you have the answer to a list members question, please E-mail your reply to the list so all the members can benefit from the discussion.
If you notice that some documentation needs updating. The list is also the place to send E-mail if you notice that some documentation needs updating. For documentation published on the Web, please specify the URL for the documentation that needs to be updated. For BusinessObjects documentation (help for Objects), please specify the Universe, Class, and Object.