Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn
[an error occurred while processing this directive]

 
  UPDATES
Current Load Status
Regular Availability
 
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
 
  DATA COLLECTIONS
Advancement
Assets
BBR
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
World Travel
Cross-Collection

Notes on the PennERA Proposals Diagram

If the diagram is printed, landscape orientation and letter-sized paper (8.5 by 11 inches) are recommended.

The PennERA Proposals Universe combines tables from the PennERA Proposals data collection with reference tables from the Salary Management, General Ledger, Space@Penn, and Human Subjects Protocols data collections. The diagram illustrates the architecture of the Universe, displaying the tables that are included and the joins between the tables.

A table or view is shown in the diagram as a black-bordered box. The background color of the box indicates the source data collection. White is used for the PennERA Proposals tables, grey for Salary Management tables, green for General Ledger tables, and pink for Human Subjects Protocols tables. While viewing the diagram, click on the box for a table to see the documentation for that table.

A join is shown as a line between the boxes for the joined tables. Labels next to the lines indicate the join criteria.

In the Universe, a Business Objects Class folder roughly corresponds to a table. However, some folders include Objects from reference tables that are joined to the Class's table, but are not necessarily shown in the diagram. (If the Class's table includes a coded data element, the Class usually retrieves just the corresponding name or description from the relevant reference table, rather than including all of that reference table's data elements. For example, a Class that includes the proposal responsible org. code also includes the description for that org., retrieved from the ORG_CODES table.) While viewing the diagram, click on the blue label next to a box to see the list of the reference tables and data elements included in that Class, with links to the data documentation. Note: if the diagram shows the Class's table joined to another table, and that other table is also used as a reference table within the Class, that other table does not appear in the list of the reference tables and data elements included in that Class.

(LABEL)
Class
Schema.ReferenceTableName.ReferencedDataElement
(ACT)
Pennera Proposal Activity
DWADMIN.PENNERA_PEOPLE.NAME
(EG)
Employee General

DWADMIN.CNAC_CODES.CENTER_NAME
DWADMIN.JOB_CLASS_GENERAL_V.ACADEMIC_CATEGORY
DWADMIN.JOB_CLASS_GENERAL_V.FACULTY_CLASS
DWADMIN.JOB_CLASS_GENERAL_V.JOB_TITLE
DWADMIN.JOB_CLASS_GENERAL_V.STANDING_FACULTY_RANK
DWADMIN.ORG_CODES.CENTER_CODE
DWADMIN.ORG_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
DWADMIN.ORG_CODES.PARENT_ORG_CODE
DWPAY.PAYROLL_ACTION_CODE.ACTION_CODE_DESCRIPTION

(FUND INCR)
Fund Codes INCR
DWADMIN.CNAC_CODES.CENTER_NAME
DWADMIN.FUND_BILLING_FORMAT_CODES.BILLING_FORMAT_DESC
DWADMIN.FUND_BILLING_FREQ_CODES.BILLING_FREQ_DESC
DWADMIN.FUND_FINAL_RPT_CODES.DAYS_TO_SUBMIT_FINAL_RPT_DESC
DWADMIN.FUND_INVESTMENT_CODES.INVESTMENT_REV_TREATMENT_DESC
DWADMIN.FUND_LOC_RPTG_CODES.LOC_REPORTING_DESC
DWADMIN.FUND_RECLASS_CODES.RESTRICT_RECLASS_DESC
DWADMIN.FUND_RPT_FORMAT_CODES.REPORT_FORMAT_DESC
DWADMIN.FUND_RPT_FREQ_CODES.REQUIRED_FIN_RPT_FREQ_DESC
DWADMIN.FUND_SFS_CATEGORY_CODES.SFS_CATEGORY_DESC
DWADMIN.FUND_SPONSORS.FUND_SPONSOR_DESC
DWADMIN.FUND_SPONSORS.LEGACY_FUND_SPONSOR_CODE
DWADMIN.ORG_CODES.DESCRIPTION
DWADMIN.ORG_CODES.LEDGER_ALIAS_CODE
DWADMIN.PARENT_ORG_CODES.PARENT_ORG
DWADMIN.PARENT_ORG_CODES.PARENT_ORG_DESC
DWADMIN.PURPOSE_CODES.PURPOSE_DESC
(FUND PRIME)
Fund Codes Current Prime Fund
(INCR)
Pennera Increment
(INV)
Pennera Proposal Investigator
DWADMIN.CNAC_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
(PER)
Pennera Period
(PPL)
Pennera People
DWADMIN.CNAC_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
(PROP)
Pennera Proposal
(REQ)
Pennera Request
(SEC)
Pennera Security
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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