| 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. |
GIFT_DT_FISCAL_YEAR
Indexed - yes
Format - NUMBER
Nullable - Y | The fiscal year of the transaction, based upon the GIFT_DT field. For example, if the GIFT_DT = 06/30/2007 then the GIFT_DT_FISCAL_YEAR = 2007. |
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 |
SOFT_COMMITMENTS_RFDT
Indexed - no
Format - NUMBER
Nullable - Y | Soft dollar commitment amount (pledge + outright gift) based upon reference date (used to create giving frequency totals). |
SOFT_RECEIPTS_RFDT
Indexed - no
Format - NUMBER
Nullable - Y | Soft dollar receipt amount (pledge payment + outright gift) based upon reference date (used to create giving frequency totals - see WHSE_TRANSACTION_DETAIL). |
WHSE_DT_UPDATED
Indexed - no
Format - DATE
Nullable - N | 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). |
