| Data element |
Definition |
SESSION_NO
Indexed - Yes
Format - VARCHAR2
Nullable - Y |
Number that identifies gift batch entering session-- used 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. |
HARD_REC_COUNT
Indexed - No
Format - NUMBER
Nullable - Y | Count of hard credit rows for this gift (usually one) |
EMPLID_1
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding hard credit |
REC_NAME_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding hard credit |
REC_AFFILIATION_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Affiliation of individual holding hard credit |
EMPLID_2
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding hard credit |
REC_NAME_2
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding hard credit |
REC_AFFILIATION_2
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding hard credit |
EMPLID_3
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding hard credit |
REC_NAME_3
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding hard credit |
REC_AFFILIATION_3
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding hard credit |
EXT_ORG_ID_1
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of organization holding hard credit |
ORG_REC_NAME_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of organization holding hard credit |
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). |
