| Data element |
Definition |
BUSINESS_UNIT
Indexed - No
Format - VARCHAR2
Nullable - N | This is the business unit code of the department that entrered the gift -- most often UPENN. |
SESSION_NO
Indexed - Yes
Format - VARCHAR2
Nullable - N | Number that identifies gift batch entering session. Uses as part of unique key to identify a specific gift transaction. |
GIFT_NO
Indexed - Yes
Format - VARCHAR2
Nullable - N | 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. |
EXPECT_DT
Indexed - No
Format - DATE
Nullable - N | Due date of the expected payment. |
EXPECT_AMT
Indexed - No
Format - NUMBER
Nullable - N | Amount of the expected payment. |
CURRENCY_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Country code for currency (most often USD) |
FISCAL_YEAR
Indexed - Yes
Format - NUMBER
Nullable - N | Fiscal year of the date of the expected payment. |
RCVD_DT
Indexed - No
Format - DATE
Nullable - Y | Date Penn received the pledge payment. Since this date defaults to the data entry date of the payment, it is best to check the gift detail for the true date. |
RCVD_AMT
Indexed - No
Format - NUMBER
Nullable - N | Amount of the pledge payment actually received. |
NTFY_FLG
Indexed - No
Format - VARCHAR2
Nullable - N | Not currently used by Penn |
GIFT_REF_NO
Indexed - Yes
Format - VARCHAR2
Nullable - N | GIFT_NO of the pledge payment |
