Penn Computing

University of Pennsylvania
Penn Computing << go backback

WHSE_GIVING_FREQUENCY Table
   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

WHSE_GIVING_FREQUENCY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

  • COMMON_ID
  • EMPLID
  • FREQ_GROUP
  • FREQ_GROUP_DESCR
  • CURRENT_PAID
  • CURRENT_PLEDGE
  • LYBUNT_PAID
  • LYBUNT_PLEDGES
  • SYBUNT1_PAID
  • SYBUNT2_PAID
  • SYBUNT3_PAID
  • SYBUNT4_PAID
  • HYBUNT1_PAID
  • HYBUNT2_PAID
  • HYBUNT3_PAID
  • HYBUNT4_PAID
  • HIGH_AMOUNT
  • HIGH_AMOUNT_YEAR
  • GIVING_FREQUENCY
  • WHSE_DT_UPDATED

  • Data element Definition
    COMMON_ID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Created by Penn for data warehouse reporting, this is the unique identifier for both individuals and organizations. It is the concatenation of the EMPLID and EXT_ORG_ID fields. For individuals, it comes from EMPLID and for orgs, it comes from EXT_ORG_ID.
    EMPLID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - Y
    Unique identifier for individual (non-org) records.
    FREQ_GROUP


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Code identifying a constituent group.
    FREQ_GROUP_DESCR


    Indexed - Yes
    Format - VARCHAR2
    Nullable - Y
    Description of the constituent group.
    CURRENT_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of gifts or payments during the current fiscal year.
    CURRENT_PLEDGE


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of pledges during the current fiscal year.
    LYBUNT_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the previous fiscal year.
    LYBUNT_PLEDGES


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of pledges for the previous fiscal year.
    SYBUNT1_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 2.
    SYBUNT2_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 3.
    SYBUNT3_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 4.
    SYBUNT4_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 5.
    HYBUNT1_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 6.
    HYBUNT2_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 7.
    HYBUNT3_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 8.
    HYBUNT4_PAID


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Sum of payments for the fiscal year minus 9.
    HIGH_AMOUNT


    Indexed - No
    Format - NUMBER
    Nullable - Y
    Highest annual payment amount.
    HIGH_AMOUNT_YEAR


    Indexed - No
    Format - CHAR
    Nullable - Y
    Year of highest payment amount.
    GIVING_FREQUENCY


    Indexed - No
    Format - VARCHAR2
    Nullable - Y
    Values are: currentpl if current_pledge > 0 and current_paid = 0, 'current' if current_paid > 0 , lybunt if lybunt_paid > 0, sybunt if sybunt(1-4_paid) > 0, hybunt if hybunt(1-4)_paid > 0, else never.
    WHSE_DT_UPDATED


    Indexed - No
    Format - DATE
    Nullable - Y
    Date that the database table row was updated in the data warehouse. Not to be confused with entry date (the date the gift was entered into ATLAS).

    WHSE_GIVING_FREQUENCY Table
       Tables and Data Elements   General Ledger Home   Data Warehouse Home

    Questions about this page? Email us at da-staff@isc.upenn.edu

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