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

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_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

PENNERA_PROPOSAL_INTL_LOCATION
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





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


 

 

 

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

EMPLOYEE_GENERAL
Table   Elements

JOB_CLASS_GENERAL
Table   Elements

PAYROLL_ACTION_CODE
Table   Elements

Human Subjects Protocols data included in one or more of the Business Objects Universes accessing the PennERA Proposals Collection:

HS_PROTOCOL_IRB_V
Table   Elements

  Collection Information:


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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