| Data element |
Definition |
SETID
Indexed - Yes
Format - VARCHAR2
Nullable - N | This is the Atlas five character code representing the Penn unit that owns a designation. SETIDs map to BEN accounting centers with a few exceptions. UPENN is the default SETID for PENN. Student Financial Services and the President's general university |
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. |
EFFDT
Indexed - No
Format - DATE
Nullable - N | Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row. |
INTV_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N |
Type of initiative code. |
INTV_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Initiative codes tied to specific fund designations (ex. 'UNI-PENN31' for Penn Fund designations) |
START_DT
Indexed - No
Format - DATE
Nullable - Y |
Start date of initiative. |
END_DT
Indexed - No
Format - DATE
Nullable - Y |
End date of initiative. |
