The Position Inventory collection allows University management to track changes in employees, organizational affilitiation, job classification, or funding, either through a monthly snapshot or through monthly tracking of changes to specific positions. This data gives University management a common language to discuss the status of positions, whether open or filled, and provides a mechanism for understanding changes in the number and the organizational location of positions.
Following the retirement of PennWorks and the mainframe Personnel/Payroll and Position Inventory management system in June 2019, the legacy Position Inventory data collection remains available for historical analysis.
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).
| EMPLOYEE_GENERAL Table Elements |
POSITION_COMPARISON_SUMMARY Table Elements |
| ORG_CODES Table Elements |
POSITION_SUMMARY Table Elements |
| PARENT_ORG_CODES Table Elements |
Following the retirement of PennWorks and the mainframe Personnel/Payroll and Position Inventory management system in June 2019, the legacy Position Inventory data collection remains available for historical analysis.
The following details explain the refresh schedule of the Position Inventory collection before the implementation of Workday in July 2019:
This collection is updated on a monthly basis, usually the last day of the month after the last Payroll job.
Source of the Data
The data in the data warehouse that is accessible via the Business Objects POSINVEN universe comes from the Payroll system. The data in this Universe includes information about staff positions and their funding, with general biographical information those employees.
Time Span Covered
The Data Warehouse stores Position Inventory snapshots back as far as July 1997 (the JUL-97 accounting period, in fiscal year 1998), and continues from that point, through June 2019 (the JUN-19 accounting period, in fiscal year 2019).
The Position Inventory collection is described in the POSINVEN diagram, which illustrates the architiecture of the BusinessObjects universe and identifies the join criteria between tables.
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.
Access to the Position Inventory collection is granted automatically to users of the Salary Management data collection in the Warehouse.
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.
Overview. Position Inventory data is complex, and a listserv and adhoc meetings are available to help you query the Warehouse and retrieve data from this collection efficiently and effectively.
Subscription to the listserv. Users of Position Inventory data in the Data Warehouse support one another when questions arise through the use of listservs. When you are granted access to the data, you will automatically be given a subscription to the listserv POSINVEN-WH@LISTS.UPENN.EDU. (Those with subscriptions to the list are called list members. If any member sends an E-mail note to the list, every member of the list receives a copy.)
When you have a question. If you have a question about the Position Inventory data, please send E-mail to the list -- and if you have the answer to a list member's question, please E-mail your reply to the list so all the members can benefit from the discussion.
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.
Notification about general and special meetings. From time to time, notes are sent to the list to invite list members to general meetings to discuss the Position Inventory data in the Warehouse, or to special interest group meetings to discuss specific issues.