Penn Computing

Penn Computing

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

  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
   proposals
   sponproj
salary management
student
tuition distribution
cross-collection

PennERA Proposals 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.

PENNERA_CLUSTERS
Table   Elements

PENNERA_FUND_ADJ
Table   Elements

PENNERA_INCREMENT
Table   Elements

PENNERA_INCR_STAT_HIST
Table   Elements

PENNERA_PEOPLE
Table   Elements

PENNERA_PERIOD
Table   Elements

PENNERA_PERIOD_STAT_HIST
Table   Elements

PENNERA_PROPOSAL
Table   Elements

PENNERA_PROPOSAL_ACTIVITY
Table   Elements

Snapshot versions of some tables are also available.

General Ledger data included in one or more of the Business Objects Universes accessing the PennERA Proposals Collection:

BALANCES
Table   Elements

CENTER_REF_CODES
Table   Elements

CNAC_CODES
Table   Elements

FUND_BILLING_FORMAT_CODES
Table   Elements

FUND_BILLING_FREQ_CODES
Table   Elements

FUND_CODES
Table   Elements

FUND_FINAL_RPT_CODES
Table   Elements

FUND_INVESTMENT_CODES
Table   Elements

FUND_LOC_RPTG_CODES
Table   Elements

FUND_RECLASS_CODES
Table   Elements

FUND_RPT_FORMAT_CODES
Table   Elements

FUND_RPT_FREQ_CODES
Table   Elements

FUND_SFS_CATEGORY_CODES
Table   Elements

Salary Management data included in the Business Objects Universes accessing the PennERA Proposals Collection:

EMPLOYEE_GENERAL
Table   Elements

JOB_CLASS_GENERAL
Table   Elements



PENNERA_PROPOSAL_INVESTIGATOR
Table   Elements

PENNERA_PROPOSAL_PARENT
Table   Elements

PENNERA_PROP_REGULATORY_APPR
Table   Elements

PENNERA_PROP_STAT_HIST
Table   Elements

PENNERA_REQUEST
Table   Elements

PENNERA_REQ_STAT_HIST
Table   Elements

PENNERA_SPONSOR
Table   Elements

PENNERA_SUBCONTRACT
Table   Elements

 


 

 

FUND_SPONSORS*
Table   Elements
*Sponsor Code Conversion notes

GL_PERIODS
Table   Elements

OBJECT_CODES
Table   Elements

ORG_CODES
Table   Elements

PARENT_CNAC_CODES
Table   Elements

PARENT_FUND_CODES
Table   Elements

PARENT_ORG_CODES
Table   Elements

PARENT_PROGRAM_CODES
Table   Elements

PROGRAM_CODES
Table   Elements

PURPOSE_CODES
Table   Elements

RCM_OBJECT_TREE
Table   Elements


 


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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