Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  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
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Sponsored Projects 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.

Please note that the links below for CNAC, ORG, FUND, PROGRAM CREF, and old-to-new tables, as well as employee and job class general, reference pages in other data collections. To return to the SPONPROJ Data collection, click your browser "Back" button.

AGENCY
Table   Elements

AWARD
Table   Elements

AWARD_CARRYOVER
Table   Elements

CENTER_REF_CODES
Table   Elements

CNAC_CODES
Table   Elements

EMPLOYEE_GENERAL
Table   Elements

FINANCIAL_DEPARTMENT
Table   Elements

FINANCIAL_SCHOOL
Table   Elements

FUND_CODES
Table   Elements

GL_PART_OLD_TO_NEW
Table   Elements

JOB_CLASS_GENERAL
Table   Elements

LEGACY_FUND_SPONSORS
Table   Elements

MONTHLY_EXPENDITURE
Table   Elements

ORA_PURPOSE
Table   Elements

ORG_CODES
Table   Elements

ORG_OLD_TO_NEW
Table   Elements

PROGRAM_CODES
Table   Elements

PROJECT_EXPENDITURE
Table   Elements

PROPOSAL
Table   Elements

SPON_PROJ_INVESTIGATOR
Table   Elements

SPON_PROJ_SUBCONTRACTOR
Table   Elements

SPONSOR_OLD_TO_NEW
Table   Elements

SUB_CONTRACTOR
Table   Elements


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania