| 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. |
SOFT_REC_COUNT
Indexed - No
Format - NUMBER
Nullable - Y | Count of soft credit rows for this gift (usually one). |
EMPLID_1
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding soft credit. |
REC_TYPE_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Type of soft credit (soft or challenge). |
REC_NAME_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding soft credit |
REC_AFFILIATION_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Affiliation of individual holding soft credit |
EMPLID_2
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding soft credit. |
REC_TYPE_2
Indexed - No
Format - VARCHAR2
Nullable - Y | Type of soft credit (soft or challenge). |
REC_NAME_2
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding soft credit |
REC_AFFILIATION_2
Indexed - No
Format - VARCHAR2
Nullable - Y | Affiliation of individual holding soft credit |
EMPLID_3
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of individual holding soft credit. |
REC_TYPE_3
Indexed - No
Format - VARCHAR2
Nullable - Y | Type of soft credit (soft or challenge). |
REC_NAME_3
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of individual holding soft credit |
REC_AFFILIATION_3
Indexed - No
Format - VARCHAR2
Nullable - Y | Affiliation of individual holding soft credit |
EXT_ORG_ID_1
Indexed - No
Format - VARCHAR2
Nullable - Y | ID of org holding soft credit. |
ORG_REC_TYPE_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Type of soft credit (soft or challenge). |
ORG_REC_NAME_1
Indexed - No
Format - VARCHAR2
Nullable - Y | Name of org holding soft 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). |
