Data Warehouse: Faculty Data Collection


	Query the warehouse
	What you need
	Access request forms
	Password change
	Query tool software
	Training options
	Tips

	Related information
	About the warehouse
	Data Administration
	Security
	Support services
	Warehouse updates

	Data collections
	advancement
	assets
	brim
	brs
	express mail
	facilities
	faculty
	general ledger
	infrastructure
	learning management
	position inventory
	research
	salary management
	student
	tuition distribution
	cross-collection

Faculty Collection Refresh Schedule

All Faculty tables are refreshed on a daily basis, Monday through Friday. Biographical and job data from the Payroll is refreshed daily.

Source of the Data
The data in the data warehouse that is accessible via the Business Objects Faculty Information System universe comes from the Faculty Information system and the Payroll and Salary Management systems. The data in this Universe includes biographical information about faculty and academic support staff, information on their appointments, leaves of absence, and graduate group and committee memberships. The sources of the data is the Facutly Infomation System (FIS) application, as well as the EMPLOYEE_GENERAL and EMPLOYEE tables from the Salary Management System data collection.

Time Span Covered
The Faculty data collection stores data on all current faculty appointments, as well as terminations and resignations which have taken place in 2006 and forward. FIS also includes current appointments for academic support staff, and current graduate group and committee memberships.



Information Systems and Computing University of Pennsylvania Comments & Questions