RPR and AAR comparison, Friday before 05/15/2007 vs. census 061. FOR AU B1 ONLY.
UCB PBA. l:\datalib\map\censustbls\RPRAARCompare.sas
 
RPR additions and deletions
RPR = SIS academic program table = screen 1A3
controls valid college-degree-major combinations for enrollment and degrees

difftype=Added

Inst AU College Degree Degtype Major Degree
flag
Start term End term Dept Career1 CIP6 CIPSeq Discipline
college
CCHE deg
level
Majname Deptname
BD B1 GR DOC DOC ATLS N 20067   ATLS GS 301501   AS 51 TECH, MEDIA & SOCIETY (ATLAS) ATLAS
BD B1 GR PHD DOC ATLS Y 20067   ATLS GS 301501   AS 51 TECH, MEDIA & SOCIETY (ATLAS) ATLAS
BD B1 GR DOC DOC ATOC N 20061   ATOC GS 400202   AS 51 ATMOSPHERIC & OCEANIC SCIENCES ATMOSPHERIC AND OCEANIC SCIENCE
BD B1 GR MAS MAST ATOC N 20061   ATOC GS 400202   AS 31 ATMOSPHERIC & OCEANIC SCIENCES ATMOSPHERIC AND OCEANIC SCIENCE
BD B1 GR MS MAST ATOC Y 20061   ATOC GS 400202   AS 31 ATMOSPHERIC & OCEANIC SCIENCES ATMOSPHERIC AND OCEANIC SCIENCE
BD B1 GR PHD DOC ATOC Y 20061   ATOC GS 400202   AS 51 ATMOSPHERIC & OCEANIC SCIENCES ATMOSPHERIC AND OCEANIC SCIENCE
BD B1 GR D AUD DOC AUDD Y 20061   SLHS GS 510202   AS 51 AUDIOLOGY SLHS SPEECH, LANGUAGE, AND HEARING SCIENCES
BD B1 GR DOC DOC AUDD N 20061   SLHS GS 510202   AS 51 AUDIOLOGY SLHS SPEECH, LANGUAGE, AND HEARING SCIENCES
BD B1 EN BAC BACH CBEN N 20064   CHEN US 140701 02 EN 21 CHEMICAL & BIOLOGICAL ENGIN CH E CHEMICAL ENGINEERING
BD B1 EN BS CB BACH CBEN Y 20064   CHEN US 140701 02 EN 21 CHEMICAL & BIOLOGICAL ENGIN CH E CHEMICAL ENGINEERING
BD B1 GR MFA MAST CRWR Y 20064   ENGL GS 230501   AS 31 ENGLISH LIT-CREATIVE WRITING E LT ENGLISH
BD B1 JR BS JR BACH JRGS Y 20071   JOUR US 090401   JR 21 JOURNALISM - GENERAL STUDIES JOUR JOURNALISM
BD B1 UN NDEG NDEG NHPJ N 20064   CONT US     UN   NON-DEGREE HS JUNIOR PARTICIPAT CONTINUING EDUCATION STAFF
BD B1 UN NDEG NDEG NHPS N 20064   CONT US     UN   NON-DEGREE HS SENIOR PARTICIPAT CONTINUING EDUCATION STAFF
BD B1 BG MBA MAST OPNO Y 19801 20027 ARSP GS 520201   BU 31 OPEN OPTION *OPN ARTS & SCIENCES SPECIAL PROGRAMS

difftype=Dropped, some left in B1 for major, none left in major and degree

Inst AU College Degree Degtype Major Degree
flag
Start term End term Dept Career1 CIP6 CIPSeq Discipline
college
CCHE deg
level
Majname Deptname
BD B1 GR MS MAST EVC2 Y 20021   EVEN GS 140801   EN 31 ENVIR/CIV ENGINEERING CONC DEG ENGR ENVIRONMENTAL ENGINEERING

RPR and AAR comparison, Friday before 05/15/2007 vs. census 061. FOR AU B1 ONLY.
UCB PBA. l:\datalib\map\censustbls\RPRAARCompare.sas
 
RPR differences for rows in both time points
RPR = SIS academic program table = screen 1A3
controls valid college-degree-major combinations for enrollment and degrees
 
NOT SHOWING DIFFERENCES ON THE FOLLOWING VARS: 'MAJNAME' 'DEPT' 'DEPTNAME'

Major Degree College AU Time point Degree flag Start term End term Career1 CIP6 CIPSeq Discipline college CCHE deg level
ARTE BAC AS B1 Census 061 N 19801   US 131302   AS 21
        Now N 19801 19901 US 131302   AS 21
BFAE BAC AS B1 Census 061 N 19801   US 500702   AS 21
        Now N 19801 19951 US 500702   AS 21
BFAE BFA AS B1 Census 061 Y 19801   US 500702   AS 21
        Now Y 19801 19951 US 500702   AS 21
BFAH BAC AS B1 Census 061 N 19801   US 500702   AS 21
        Now N 19801 20004 US 500702   AS 21
BFAH BFA AS B1 Census 061 Y 19801   US 500702   AS 21
        Now Y 19801 20004 US 500702   AS 21
CRWR DOC GR B1 Census 061 N 19801 19881 GS 230101   AS 51
        Now N 19801 19881 GS 230501   AS 51
CRWR MA GR B1 Census 061 Y 19801   GS 230101   AS 31
        Now Y 19801 20121 GS 230501   AS 31
CRWR MAS GR B1 Census 061 N 19801   GS 230101   AS 31
        Now N 19801   GS 230501   AS 31
EEBU BS EE EN B1 Census 061 Y 19934   US 520201   EN 21
        Now Y 19934 19934 US 520201   EN 21
ENLT DOC GR B1 Census 061 N 19801   GS 230101   AS 51
        Now N 19801 19944 GS 230101   AS 51
ENLT PHD GR B1 Census 061 Y 19801   GS 230101   AS 51
        Now Y 19801 19944 GS 230101   AS 51
ENUD BAC EN B1 Census 061 N 19801   US 149999   EN 21
        Now N 19801 20007 US 149999   EN 21
EPBU BAC EN B1 Census 061 N 19801 19934 US 520201   EN 21
        Now N 19801 19934 US 400801   EN 21
EPBU BSEPH EN B1 Census 061 Y 19801 19934 US 520201   EN 21
        Now Y 19801 19934 US 400801   EN 21
INBU BAC BU B1 Census 061 N 19801   US 520201   BU 21
        Now N 19801 19987 US 520201   BU 21
INBU BS BU BU B1 Census 061 Y 19801   US 520201   BU 21
        Now Y 19801 19987 US 520201   BU 21
MUBU BAC MB B1 Census 061 N 19801   US 520201   MB 21
        Now N 19801 19901 US 520201   MB 21