| Data element |
Definition |
PLEDGE_NO
Indexed - Yes
Format - VARCHAR2
Nullable - N | Atlas gift_no for the pledge. |
SEQ_NUMBER
Indexed - Yes
Format - NUMBER
Nullable - N | Sequence number of the schedule data. Highest sequence is the most recent and valid data. |
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 - No
Format - VARCHAR2
Nullable - N | This is the unique identifier of a batch of gifts or pledges -- used as part of unique key to identify a specific gift transaction. |
FISCAL_YEAR
Indexed - No
Format - NUMBER
Nullable - N | Fiscal year of the pledge's gift date. |
UP_NPV_RATE
Indexed - No
Format - NUMBER
Nullable - N | Discount rate |
GL_POST_DT
Indexed - No
Format - DATE
Nullable - Y | Date the gift/pledge transaction posted to the General Ledger. Used as selection criteria in daily gifts reports. |
OPRID
Indexed - No
Format - VARCHAR2
Nullable - N | ID of the gift entry operator who modified the record |
DATETIME_CREATED
Indexed - No
Format - DATE
Nullable - Y | Date and time of the data update. |
