BUSINESS_UNIT
Indexed - No
Format - VARCHAR2
Nullable - N | Overall institution code (ex. '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 g"
|
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.
|
TRIBUTE_NO
Indexed - Yes
Format - VARCHAR2
Nullable - N |
Internal counter for the application. This value increases with each tribute added to a gift or pledge. |
TRIBUTE_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - N |
Indicates the type of tribute. Values include
H - in honor of, M - in memory of. and F - For |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
AV_NAME
Indexed - No
Format - VARCHAR2
Nullable - N |
Name of the entity receivng tribute |
OCCASION
Indexed - No
Format - VARCHAR2
Nullable - N |
Not used |
AV_AMOUNT
Indexed - No
Format - NUMBER
Nullable - N |
Not used (may default to gift amount) |
CURRENCY_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Country code for currency (most often USD) |
INSTITUTION
Indexed - No
Format - VARCHAR2
Nullable - N |
Always UPENN |