| Data element |
Definition |
Expr1 Expr3
"INSTITUTION
Indexed - No
Format - VARCHAR2
Nullable - N | Always UPENN |
"EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
"UP_AFFIL_REC_LVL
Indexed - Yes
Format - VARCHAR2
Nullable - N | Code specifying both the graduation degree type (A = undergrad, G = grad) and the sequence number of the degree (A1 is first undergrad degree, A2 is second ug degree, etc.). |
"EFFDT
Indexed - Yes
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. |
"UP_PREF_CLASS_YEAR
Indexed - Yes
Format - VARCHAR2
Nullable - N | The graduation year of the specific degree row in the table. |
"UP_AFFILIATION
Indexed - Yes
Format - VARCHAR2
Nullable - N | The school affiliation of the specific degree row in the table. There are multiple possible affiliations within a specific "School" bucket. For example, 'WH' (Wharton) has affiliation 'W' (Wharton Undergrad), 'WG' (Wharton Graduate), etc. |
"UP_TERM_ID
Indexed - No
Format - VARCHAR2
Nullable - N | Used to determine the semester term in which the student graduated (Summer, Fall, Winter). |
"UP_ACAD_PROGRAM_ID
Indexed - No
Format - NUMBER
Nullable - N |
Sequence number |
"UP_MATRICULATN_DT
Indexed - No
Format - DATE
Nullable - Y | Date student enrolled in the program (matriculated). |
"GRADUATION_DT
Indexed - No
Format - DATE
Nullable - Y | Date student graduated. |
"UP_SCHOOL
Indexed - Yes
Format - VARCHAR2
Nullable - N | Penn school - larger, 'umbrella' grouping (multiple affiliations within school). Ex. 'WH' = Wharton. |
"UP_DIVISION
Indexed - No
Format - VARCHAR2
Nullable - N | Academic division |
"UP_COHORT
Indexed - No
Format - VARCHAR2
Nullable - N | |
"UP_SCHOOL_LVL
Indexed - Yes
Format - VARCHAR2
Nullable - N | Level of degree ('M' = Masters, 'D' = Doctoral, 'P' = Professional, 'U' = Undergraduate). |
"UP_ORIG_SCHOOL
Indexed - No
Format - VARCHAR2
Nullable - N | |
"DEGREE
Indexed - Yes
Format - VARCHAR2
Nullable - N | Penn degree. |
"UP_DEGREE_HONORS1
Indexed - No
Format - VARCHAR2
Nullable - N | Penn degree honors code (ex. 'M' = Magna Cum Laude). |
"UP_DEGREE_HONORS2
Indexed - No
Format - VARCHAR2
Nullable - N | Penn degree honors code (ex. 'M' = Magna Cum Laude). |
"UP_SPECIAL_PROGRMS
Indexed - No
Format - VARCHAR2
Nullable - N | Special programs (ex. 'ARM' = Classical Studies - Rome). See PS_UP_SPCL_PGM_TBL_MV for lookup values. |
"UP_JT_DEGREE_FLAG
Indexed - No
Format - VARCHAR2
Nullable - N | |
"UP_GRAD_STATUS
Indexed - Yes
Format - VARCHAR2
Nullable - N | Penn degree graduation status (ex. 'C' = Complete, 'I' = Incomplete, 'A' = 'Attending, etc.). |
"UP_EXIT_ACTION
Indexed - No
Format - VARCHAR2
Nullable - N | Code describing exit from degree (ex. 'GD' = Graduated). |
"UP_EXIT_REASON
Indexed - No
Format - VARCHAR2
Nullable - N | Code describing reason for exiting Penn degree (ex. 'MB' = Misbehavior). Seldom populated. |
"UP_FINANCIAL_AID
Indexed - No
Format - VARCHAR2
Nullable - N | If = 'Y', then the student received financial aid |
"OPRID
Indexed - No
Format - VARCHAR2
Nullable - N | |
"OPRID2
Indexed - No
Format - VARCHAR2
Nullable - N | |
"DATETIME_UPDATED
Indexed - No
Format - DATE
Nullable - Y | |
"
