" " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " "

Data element	Definition
SETID Indexed - Yes Format - VARCHAR2 Nullable - No	The Penn unit that owns the designation.
DESIGNATION Indexed - Yes Format - VARCHAR2 Nullable - No	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.
EFFDT Indexed - Yes Format - DATE Nullable - No	Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. Only the current effective date is available in this table.
AV_DES_NAME Indexed - Yes Format - VARCHAR2 Nullable - No	Designation name (shorter) - upper and lower case
EFF_STATUS Indexed - No Format - VARCHAR2 Nullable - No	Effective status of data row ("A" = active, "I" = inactive).
ACCOUNT_TYPE Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
ITEM_TYPE Indexed - No Format - VARCHAR2 Nullable - No	This is the link to the financial mapping for this designation which is stored in PS_UP_GL_INTERFACE.
ACAD_ORG Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
DEPTID Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
CAMPUS Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
DESCR60_SRCH Indexed - No Format - VARCHAR2 Nullable - No	All caps search name for designation
AV_CASE_TYPE Indexed - No Format - VARCHAR2 Nullable - No	CASE (Council for the Advancement and Support of Education) type code (see WHSE_AV_CASE_TYPE_LKUP for values: ex. 'C' = 'Current Unrestricted')
AV_CASE_PRPS Indexed - No Format - VARCHAR2 Nullable - No	CASE (Council for the Advancement and Support of Education) purpose code (see WHSE_AV_CASE_PRPS_LKUP for values: ex. 'A' = 'Financial Aid')
AV_FASB_TYPE Indexed - No Format - VARCHAR2 Nullable - No	FASB (Financial Accounting Standards Board) type code (see WHSE_AV_FASB_TYPE_LKUP for values: ex. '1' = 'Unrestricted')
AV_MTCH_GFT_TP Indexed - No Format - VARCHAR2 Nullable - No	Link to matching gift restrictions
AV_INST_TYPE Indexed - No Format - VARCHAR2 Nullable - No	Gift receipt restrictions for the designation.
STAFF_ID Indexed - No Format - VARCHAR2 Nullable - No	Unique id for Penn staff member responsible for designation. Currenlty not used.
PURPOSE_CD Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
PLDG_PURPOSE_CD Indexed - No Format - VARCHAR2 Nullable - No	Currenlty not used
INSTITUTION Indexed - No Format - VARCHAR2 Nullable - No	Always UPENN
DESCR254 Indexed - No Format - VARCHAR2 Nullable - No	Formal Designation name (longest) - upper and lower case. This is the preferred field to use for a complete designation name.
UP_SORT_NAME Indexed - No Format - VARCHAR2 Nullable - No	Sort name
UP_CGP Indexed - No Format - VARCHAR2 Nullable - No	Primary CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP1 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP10 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP2 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP3 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP4 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP5 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP6 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP7 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP8 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
UP_CGP9 Indexed - No Format - VARCHAR2 Nullable - No	Alternate CGP code for fund (old gifts system code, similar to business unit / benefiting unit)
COMMENTS Indexed - No Format - LONG Nullable - Yes	Comments about the designation
JOURNAL_SET Indexed - No Format - NUMBER Nullable - Yes	Currenlty not used
UP_CNAC Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL CNAC code: The 3-character center Net Asset Class (NAC) code. The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted).
UP_ORG Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL Org Code: The 4-character ORGANIZATION code. This is a subdivision of the University created for management purposes.  An org code belongs to only one responsibility center, and its org code is unique.
UP_BUDGET Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL Budget Code: The budgetary control character that represents the level at which funds availability checking occurs.
UP_FUND Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL Fund Code: The 6-character fund number. A fund is the unique identifier for a specific set of financial resources that needs tracking or management. In Atlas this is often (but not always) the designation code.
UP_OBJECT Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL Object Code: The 4-character OBJECT code identifies asset, liability, revenue, or expense.
UP_PROGRAM Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL Program Code: The 4-character PROGRAM code identifies an activity or work process commonly defined across the University for tracking the PROGRAM's activity across schools and centers (or across organizations within a school or center).
UP_CREF Indexed - No Format - VARCHAR2 Nullable - Yes	Penn's GL CREF Code: The 4-character Center Reference code. This is an identifier uniquely defined by each school or center. COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center.
HARD_PLEDGES Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of hard dollar pledges (unlike commitments, doesn't include outright gift amount).
HARD_GIFTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of hard dollar gift amount (unlike receipts, doesn't include pledge payment amount).
HARD_PP Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of hard dollar pledge payment amount.
HARD_COMMITMENTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of hard dollar commitment amount (pledges + outright gifts)
HARD_RECEIPTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of hard dollar receipt amount (outright gifts + pledge payments
SOFT_PLEDGES Indexed - No Format - NUMBER Nullable - Yes	Soft dollar pledge amount (unlike commitments, doesn't include outright gift amount).
SOFT_GIFTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of soft dollar gift amount (unlike receipts, doesn't include pledge payment amount).
SOFT_PP Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of soft dollar pledge payment amount.
SOFT_COMMITMENTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of soft dollar commitment amount (pledge + outright gift)
SOFT_RECEIPTS Indexed - No Format - NUMBER Nullable - Yes	Atlas balance of soft dollar receipt amount (outright gifts + pledge payments
WHSE_DT_UPDATED Indexed - No Format - DATE Nullable - No	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).