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