| Data element |
Definition |
BUSINESS_UNIT
Indexed - Yes
Format - VARCHAR2
Nullable - Y | This is the business unit code of the department that entrered the gift -- most often UPENN. |
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. |
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. |
TRIBUTE_COUNT
Indexed - No
Format - NUMBER
Nullable - Y | List the number of tributes on the gift/pledge. This table only display the first 5 individuals |
EMPLID1
Indexed - No
Format - VARCHAR2
Nullable - Y | Id of individual for whom the gift/pledge is in tribute. |
TRIBUTE_TYPE1
Indexed - No
Format - VARCHAR2
Nullable - Y | Tribute code |
AV_NAME1
Indexed - No
Format - VARCHAR2
Nullable - Y | Name/description of the tribute recipient. |
AV_AMOUNT1
Indexed - No
Format - NUMBER
Nullable - Y | Gift amount of tribute. |
EMPLID2
Indexed - No
Format - VARCHAR2
Nullable - Y | Id of individual for whom the gift/pledge is in tribute. |
TRIBUTE_TYPE2
Indexed - No
Format - VARCHAR2
Nullable - Y | Tribute code |
AV_NAME2
Indexed - No
Format - VARCHAR2
Nullable - Y | Name/description of the tribute recipient. |
AV_AMOUNT2
Indexed - No
Format - NUMBER
Nullable - Y | Gift amount of tribute. |
EMPLID3
Indexed - No
Format - VARCHAR2
Nullable - Y | Id of individual for whom the gift/pledge is in tribute. |
TRIBUTE_TYPE3
Indexed - No
Format - VARCHAR2
Nullable - Y | Tribute code |
AV_NAME3
Indexed - No
Format - VARCHAR2
Nullable - Y | Name/description of the tribute recipient. |
AV_AMOUNT3
Indexed - No
Format - NUMBER
Nullable - Y | Gift amount of tribute. |
EMPLID4
Indexed - No
Format - VARCHAR2
Nullable - Y | Id of individual for whom the gift/pledge is in tribute. |
TRIBUTE_TYPE4
Indexed - No
Format - VARCHAR2
Nullable - Y | Tribute code |
AV_NAME4
Indexed - No
Format - VARCHAR2
Nullable - Y | Name/description of the tribute recipient. |
AV_AMOUNT4
Indexed - No
Format - NUMBER
Nullable - Y | Gift amount of tribute. |
EMPLID5
Indexed - No
Format - VARCHAR2
Nullable - Y | Id of individual for whom the gift/pledge is in tribute. |
TRIBUTE_TYPE5
Indexed - No
Format - VARCHAR2
Nullable - Y | Tribute code |
AV_NAME5
Indexed - No
Format - VARCHAR2
Nullable - Y | Name/description of the tribute recipient. |
AV_AMOUNT5
Indexed - No
Format - NUMBER
Nullable - Y | Gift amount of tribute. |
