| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | unique identifier for org (non-individual) records |
SEQNUM*
Indexed - Yes
Format - VARCHAR2
Nullable - N |
*Not available until August 2008.
One up counter of involvement records. |
INVLV_TYPE_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Indicates the type of involvement, such as a constituent's interest, activities, awards, or affiliations. Its description appears to the right. |
INVLV_CTGY_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Indicates the category of involvement, such as professional, charitable, academic, social, religious, and so on. |
INVLV_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | The involvement code specifies the individual or org's involvement with Penn. |
INSTITUTION
Indexed - Yes
Format - VARCHAR2
Nullable - N | Always UPENN |
START_DT
Indexed - No
Format - DATE
Nullable - Y | Start date |
END_DT
Indexed - No
Format - DATE
Nullable - Y | End date |
RCVD_DT
Indexed - No
Format - DATE
Nullable - Y | If the involvement type is Award and Honor or another type that requires a received date rather than a date range, enter the date in the Rcvd Date field. This determination is made when you define involvement types. |
LAST_MOD_DT
Indexed - No
Format - DATE
Nullable - Y | The date on which this information was most recently updated. |
SRC_DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Free text description of the person or publication that alerted you to the constituent's involvement. |
