WHSE_PLEDGE_DISCOUNT_MV Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
BUSINESS_UNIT Indexed - Yes Format - VARCHAR2 Nullable - N	This is the business unit code of the department that entrered the gift -- most often UPENN.
SESSION_NO Indexed - Yes Format - VARCHAR2 Nullable - N	Number that identifies gift batch entering session. Used as part of unique key to identify a specific gift transaction.
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.
DESIGNATION Indexed - Yes Format - VARCHAR2 Nullable - N	This is the identifier of the project, area, or fund receiving gifts. This is often the 6-digit fund segment from the GL, but there are may cases where it is not.
DISCOUNT Indexed - No Format - NUMBER Nullable - Y	Current dollar value discounted from the pledge's receivable amount.

Questions about this page? Email us at da-staff@isc.upenn.edu