| Data element |
Definition |
SESSION_NO
Indexed - Yes
Format - VARCHAR2
Nullable - Y | Number that identifies gift batch entering session. Uses as part of unique key to identify a specific gift transaction. |
BUSINESS_UNIT
Indexed - Yes
Format - VARCHAR2
Nullable - Y | This is the business unit code of the department that entrered the gift -- most often UPENN. |
GIFT_NO
Indexed - Yes
Format - VARCHAR2
Nullable - Y | This value is used to identify a specific gift or pledge. Although not unique, it is part of the key. Gift_no's starting with 'X','G', or '3' came from the legacy gifts system, while those starting with '4' are from Atlas. |
DESIGNATION
Indexed - Yes
Format - VARCHAR2
Nullable - Y | 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. |
AV_DES_BU
Indexed - Yes
Format - VARCHAR2
Nullable - Y | Equivalent to SETID - primary business unit (not necessarily a benefiting unit). |
INTV_CD
Indexed - Yes
Format - VARCHAR2
Nullable - Y | Campaign initiatives (campaign code) |
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. |
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 |
STATUS
Indexed - No
Format - VARCHAR2
Nullable - Y | Status of the pledges: A-Active or R-Reserved |
GIFT_DT
Indexed - No
Format - DATE
Nullable - Y | Date of the gift/pledge. Unlike the entry date, the GIFT_DT is determined by Development staff in conjunction with the donor's wishes. For ex., a gift which actually was entered in the system on July 10th may be given a GIFT_DT of June 30th to recognize |
EFFDT
Indexed - No
Format - DATE
Nullable - Y | Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row. |
FISCAL_YEAR
Indexed - No
Format - NUMBER
Nullable - Y | Fiscal year of the pledge |
FULF_DT
Indexed - No
Format - DATE
Nullable - Y | Expected fulfillment date |
FIRST_PAYMENT_DT
Indexed - No
Format - DATE
Nullable - Y | Date of first expected payment |
TOTAL_PLEDGE_AMT
Indexed - No
Format - NUMBER
Nullable - Y | Full pledge amount - sum of all designation pledge amounts |
DES_PLEDGE_AMT
Indexed - No
Format - NUMBER
Nullable - Y | Amount of pledge allocated to the specific designation |
TOTAL_PAID_AMT
Indexed - No
Format - NUMBER
Nullable - Y | Sum of all payments on the pledge |
DES_PAID_AMT
Indexed - No
Format - NUMBER
Nullable - Y | Sum of payments on the particular designation of the pledge |
TOTAL_BALANCE
Indexed - No
Format - NUMBER
Nullable - Y | Full pledge balance - sum of all designation balances |
DES_BALANCE
Indexed - No
Format - NUMBER
Nullable - Y | Pledge balance to the particular designation |
DES_LAST_PAID_DT
Indexed - No
Format - DATE
Nullable - Y | Date of last payment to the designation |
FEED_FLG
Indexed - No
Format - VARCHAR2
Nullable - Y | Yes or No field indicating whether a pledge feeds the general ledger. |
LAST_PMT_DT
Indexed - No
Format - DATE
Nullable - Y | Date of last pledge payment |
LAST_PMT_AMT
Indexed - No
Format - NUMBER
Nullable - Y | Amount of last payment |
DESIGNATION_PCT
Indexed - No
Format - NUMBER
Nullable - Y | The percentage of a gift that is attributed to the benefiting unit. When the designation pct is less than 100, that means that gifts given to the particular designation will be split amongst multiple benefiting units. |
NEXT_EXPECTED_PMT_DATE
Indexed - No
Format - DATE
Nullable - Y | From the pledge schedule, the date of the next expected payment |
NEXT_EXPECTED_PMT_AMT
Indexed - No
Format - NUMBER
Nullable - Y | From the pledge schedule, the amount of the next expected payment |
AMT_DUE_CUR_MONTH
Indexed - No
Format - NUMBER
Nullable - Y | Amount due this month |
AMT_DUE_NEXT_MONTH
Indexed - No
Format - NUMBER
Nullable - Y | Amount due next month |
AMT_DUE_MONTHSAGO_1
Indexed - No
Format - NUMBER
Nullable - Y | Amount past due one month |
AMT_DUE_MONTHSAGO_2
Indexed - No
Format - NUMBER
Nullable - Y | Amount past due two months |
AMT_DUE_MONTHSAGO_3
Indexed - No
Format - NUMBER
Nullable - Y | Amount past due three months |
AMT_DUE_MONTHSAGO_4PLUS
Indexed - No
Format - NUMBER
Nullable - Y | Amount past due four plus months |
AMT_DUE_FY_CURRENT
Indexed - No
Format - NUMBER
Nullable - Y | Amount due this fiscal year |
AMT_PAST_DUE_FY1
Indexed - No
Format - NUMBER
Nullable - Y | Amount past due from the previous fiscal year |
AMT_PAST_DUE_FY2
Indexed - No
Format - NUMBER
Nullable - Y |
Amount past
due from two fiscal years ago |
AMT_PAST_DUE_FY3
Indexed - No
Format - NUMBER
Nullable - Y |
Amount past
due from three fiscal years ago |
AMT_PAST_DUE_FY4
Indexed - No
Format - NUMBER
Nullable - Y |
Amount past
due from four fiscal years ago |
AMT_PAST_DUE_FY5
Indexed - No
Format - NUMBER
Nullable - Y |
Amount past
due from five fiscal years ago |
AMT_PAST_DUE_FY5PLUS
Indexed - No
Format - NUMBER
Nullable - Y |
Amount past due from six plus fiscal years ago |
AMT_DUE_FY1
Indexed - No
Format - NUMBER
Nullable - Y | Amount due current fiscal year plus one |
AMT_DUE_FY2
Indexed - No
Format - NUMBER
Nullable - Y | Amount due current fiscal year plus two |
AMT_DUE_FY3
Indexed - No
Format - NUMBER
Nullable - Y | Amount due current fiscal year plus three |
AMT_DUE_FY4
Indexed - No
Format - NUMBER
Nullable - Y | Amount due current fiscal year plus four |
AMT_DUE_FY5
Indexed - No
Format - NUMBER
Nullable - Y | Amount due current fiscal year plus five |
AMT_DUE_FY5PLUS
Indexed - No
Format - NUMBER
Nullable - Y | Amount due beyond five fiscal years (six or more years from the current fiscal year) |
