PS_UP_ACADEMIC_DTA_MV Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_UP_ACADEMIC_DTA_MV Table

Explanation
This is the main Atlas academic data table. It contains effective dated school, class year, affiliation, degree, graduation status, etc. Note that major data is found in the PU_UP_ACADEMIC_MAJ_MV table.

Common Uses

Identifying alumni of a particular school.

EMPLID
UP_AFFIL_REC_LVL

      

DEGREE
EFFDT
EMPLID
UP_AFFIL_REC_LVL
UP_AFFILIATION
UP_GRAD_STATUS
UP_PREF_CLASS_YEAR
UP_SCHOOL
UP_SCHOOL_LVL

WHSE_CONSTITUENTS
PS_UP_ACADEMIC_MAJ_MV

PS_UP_ACADEMIC_DTA_MV Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home