insert into canonicalmap(code,label,verbose_label,codetype_id) values('cs_student','CS Student','Enrolled CS student',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('csmajor','CS Major','CS undergraduate major',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('grad','CS Grad Student','CS Graduate Student',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('alum','CS Alum','CS Alum',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('faculty','CS Faculty','CS Faculty',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('vfaculty','Visiting Faculty','CS Visiting Faculty',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('lecturer','Instructor','CS Instructional Staff',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('staff','CS Staff','CS Staff',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('labstaff','CSL Staff','CSL staff',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('lte','LTE TA','LTE TA',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('secretary','Admin Staff','CS Administrative Staff',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('secondmasters','second masters','CS Second Masters (not used')','5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('upl','UPL','Undergraduate Projects Lab',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('special','Special','Special (see status codes')','5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('program','Program','Program (Application') user','5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('statperson','Stat Person','Statistics Department',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('ta','TA','CS TA',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('ra','RA','CS Research Assistant',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('pa','PA','CS Project Assistant',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('stat_student','Stat Student','enrolled in a statistics class',5);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('A','Adjunct','Adjunct Faculty/Instructor',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('E','Emerit','Emerit',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('F','Fellow','Fellowship Student',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('G','grader','CS Grader',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('J','Affiliate','CS Affiliated Faculty',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('L','CSL Alumni','Former CSL staff',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('M','PMP','CS Professional Masters Program',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('N','PCP','CS Professional Certificate Program',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('P','Project','Project User',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('X','CS Cert','CS Undergraduate Certificate',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('c','Courtesy','Courtesy user',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('o','Offsite Collaborator','Offsite Collaborator',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('S','Student Help','CS Student Staff',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('Z','status needs fix','status needs fix',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('B','BOV','CS Board of Visitors',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('b','BOV Emerit','BOV Emerit',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('C','CDIS Staff','CDIS Staff',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('I','iSchool','iSchool Person',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('D','DSI','Data Science Institute',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('T','Teaching Faculty','Teaching Faculty',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('p','Postdoc','Postdoc',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('s','Student Services','Student Services Staff',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('u','UA','Undergraduate Assistant',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('-','no status','no status remaining',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('d','DSM','Data Sciences Masters program',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('e','DEM','Data Engineering Masters program',6);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('2','minimal','Minimal Support',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('1','full','Full support',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('3','none','none',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('4','infrastructure','infrastructure',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('5','instructional','instructional',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('6','no bill','not billable',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('7','cluster','cluster nodes',7);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('scout','scout','Scout Project Staff',8);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('studenthelp','studenthelp','Student Help',8);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('courtesy','Courtesy','Courtesy user',8);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('offsite','offsite','Offsite Collaborator',8);
insert into canonicalmap(code,label,verbose_label,codetype_id) values('regular','regular','regular user',8);
