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

Advancement 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.


PS_ADDRESSES_MV
Table    Elements

PS_AV_CNST_TYP_TBL
Table    Elements

PS_AV_INVLV_TBL
Table    Elements

PS_AV_PLDG_SCHD
Table    Elements

PS_AV_RELATE_E
Table    Elements

PS_AV_RELATE_PE
Table    Elements

PS_AV_SRVC_IND_ORG
Table    Elements

PS_EMAIL_ADDRESSES
Table    Elements

PS_EXT_DEGREE
Table    Elements

PS_EXT_ORG_TBL
Table    Elements

PS_EXT_ORG_TBL_MV
Table    Elements

PS_NAMES_MV
Table    Elements

PS_ORG_CONTACT
Table    Elements

PS_ORG_LOC_PHONES
Table    Elements

PS_ORG_LOCATION
Table    Elements

PS_PERSONAL_PHONE
Table    Elements

PS_PRIORWORK_EXPER
Table    Elements

PS_RELATIONSHIPS_MV
Table    Elements

PS_SRVC_IND_CD_TBL_MV
Table    Elements

PS_SRVC_IND_DATA
Table    Elements

PS_UP_ACADEMIC_DTA_MV
Table    Elements

PS_UP_ACADEMIC_MAJ_MV
Table    Elements

PS_UP_ACCOUNT_INTV_MV
Table    Elements

PS_UP_CONTACT_EXCL
Table    Elements

PS_UP_DECEDENT_DTA
Table    Elements

PS_UP_DONR_RECOG
Table    Elements

PS_UP_PLG_SCHD_DTL
Table    Elements

PS_UP_PLG_SCHD_HDR
Table    Elements

PS_UP_SALUTATIONS_MV
Table    Elements

PS_URL_ADDRESSES
Table    Elements

WHSE_ADDRESSES_MV
Table    Elements

WHSE_CAMP_DETAIL_MV
Table    Elements

WHSE_CAMPAIGN_INTV_MV
Table    Elements

WHSE_CONSTITUENTS
Table    Elements

WHSE_DESIGNATION
Table    Elements

WHSE_DONOR_SUMMARY_MV
Table    Elements

WHSE_GIFT_DETAIL
Table    Elements

WHSE_GIFT_DETAIL_BEN_MV
Table    Elements

WHSE_GIFT_DETAIL_BEN_YTD_MV
Table    Elements

WHSE_GIFT_DETAIL_YTD_MV
Table    Elements

WHSE_GIFT_SUMMARY
Table    Elements

WHSE_GIVING_FREQUENCY
Table    Elements

WHSE_HARD_CREDIT
Table    Elements

WHSE_LIFE_GIFT_SUMMARY_MV
Table    Elements

WHSE_OPEN_PLEDGES_SUMMARY
Table    Elements

WHSE_PLEDGE_DISCOUNT_MV
Table    Elements

WHSE_REGIONS
Table    Elements

WHSE_SOFT_CREDIT
Table    Elements

WHSE_TRANSACTION_DETAIL
Table    Elements

WHSE_TRIBUTE_ALL
Table    Elements

WHSE_TRIBUTE_MV
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