Data Warehouse: Space@Penn Data Collection



	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

Space@Penn Collection Tables & Data Elements

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.

BUILDINGS
Table   Elements

BUILDINGS_HISTORY
Table   Elements

CHARGE_ORG
Table   Elements

CHARGE_ORG_HISTORY
Table   Elements

CREF_PI_MAPPING
Table   Elements

FLOORS
Table   Elements

FLOORS_HISTORY
Table   Elements

FUNCTIONS
Table   Elements

OCCUPANT
Table   Elements

OCCUPANT_HISTORY
Table   Elements

ORGANIZATIONS
Table   Elements

PRINCIPAL_INVESTIGATORS
Table   Elements

PROGRAMS
Table   Elements

PROPERTIES
Table   Elements

ROOM_CLASS_TYPES
Table   Elements

ROOM_CLASSES
Table   Elements

ROOM_UTILIZATION
Table   Elements

ROOM_UTILIZATION_HISTORY
Table   Elements

ROOMS
Table   Elements

ROOMS_HISTORY
Table Elements

UPHS_ACCOUNTING_UNIT
Table Elements

Collection Information:



Information Systems and Computing University of Pennsylvania Comments & Questions