Penn Computing

University of Pennsylvania
Penn Computing << go backback

WHSE_LIFE_GIFT_SUMMARY_MV Table    Tables and Data Elements   ATLAS Documentation Home   Data Warehouse Home

WHSE_LIFE_GIFT_SUMMARY_MV Table - Data Element Index

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

  • EMPLID
  • EXT_ORG_ID
  • COMMON_ID
  • AV_DES_BU
  • DESIGNATION
  • HARD_PLEDGES
  • HARD_GIFTS
  • HARD_PP
    		•
  • HARD_COMMITMENTS
  • HARD_RECEIPTS
  • SOFT_PLEDGES
  • SOFT_GIFTS
  • SOFT_PP
  • SOFT_COMMITMENTS
  • SOFT_RECEIPTS
  • SOFT_COMMITMENTS_RFDT
    		•


    Data element Definition
    EMPLID


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


    Indexed - yes
    Format - VARCHAR2
    Nullable - Y    		Unique identifier for org (non-individual) records
    COMMON_ID


    Indexed - yes
    Format - VARCHAR2
    Nullable - Y    		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.
    AV_DES_BU


    Indexed - no
    Format - VARCHAR2
    Nullable - N    		Equivalent to SETID - primary business unit (not necessarily a benefiting unit).
    DESIGNATION


    Indexed - yes
    Format - VARCHAR2
    Nullable - N    		This is the identifier of the project, area, or fund receiving gifts. This is often the 6-digit fund segment from the GL, but there are may cases where it is not.
    HARD_PLEDGES


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Hard dollar pledge amount (unlike commitments, doesn't include outright gift amount).
    HARD_GIFTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Hard dollar gift amount (unlike receipts, doesn't include pledge payment amount).
    HARD_PP


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Hard dollar pledge payment amount.
    HARD_COMMITMENTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Hard dollar commitment amount (pledge + outright gift)
    HARD_RECEIPTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Hard dollar receipt amount (outright gifts + pledge payments
    SOFT_PLEDGES


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Soft dollar pledge amount (unlike commitments, doesn't include outright gift amount).
    SOFT_GIFTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Soft dollar gift amount (unlike receipts, doesn't include pledge payment amount).
    SOFT_PP


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Soft dollar pledge payment amount.
    SOFT_COMMITMENTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Soft dollar commitment amount (pledge + outright gift)
    SOFT_RECEIPTS


    Indexed - no
    Format - NUMBER
    Nullable - Y    		Soft dollar receipt amount (outright gifts + pledge payments

    WHSE_LIFE_GIFT_SUMMARY_MV 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