UNKNOWN The time they appear in the UW’s census • day registration snapshot as a student, they do so at And the GR level AND ([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE]<"1" Or There is no information on their last school IsNull([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE])) • type upon entry into the GR level (Last School Type = 0 And [OIS_ST_FIRST_MAJOR]![CLASS]="08","UNK" or is null) PREV_UW The first time they appear at the GR level is • NOT the first time they appear in the UW’s census And (previously day registration snapshot as a student (i.e. they were at UW) here before) OTHER The first time they appear in the UW’s census • day registration snapshot as a student, they do so at And the PROF level [OIS_ST_FIRST_MAJOR]![CLASS]>"08","OTHER", UNKNOWN The first time they appear in the UW’s census IIf([MinTermperLevel]![ • day registration snapshot as a student, they do so at PROF]=[FindMinTerm]![FirstUWTerm] And the PROF level AND ([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE]="0" Or There is no information on their last school IsNull([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE])) • type upon entry into the PROF level (Last School Type And [OIS_ST_FIRST_MAJOR]![CLASS]>"08","UNK", = 0 or is null) PREV_UW The first time they appear at the PROF level • (previously is NOT the first time they appear in the UW’s census And at UW) day registration snapshot as a student (i.e. they were [OIS_ST_FIRST_MAJOR]![CLASS]>"08","PREV_UW", here before) Professional
UNKNOWN • The time they appear in the UW’s census day registration snapshot as a student, they do so at the GR level AND • There is no information on their last school type upon entry into the GR level (Last School Type = 0 or is null) And ([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE]<"1" Or IsNull([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE])) And [OIS_ST_FIRST_MAJOR]![CLASS]="08","UNK" PREV_UW (previously at UW) • The first time they appear at the GR level is NOT the first time they appear in the UW’s census day registration snapshot as a student (i.e. they were here before) And Professional OTHER • The first time they appear in the UW’s census day registration snapshot as a student, they do so at the PROF level And [OIS_ST_FIRST_MAJOR]![CLASS]>"08","OTHER", UNKNOWN • The first time they appear in the UW’s census day registration snapshot as a student, they do so at the PROF level AND • There is no information on their last school type upon entry into the PROF level (Last School Type = 0 or is null) IIf([MinTermperLevel]![ PROF]=[FindMinTerm]![FirstUWTerm] And ([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE]="0" Or IsNull([OIS_ST_FIRST_MAJOR]![LAST_SCHOOL_TYPE])) And [OIS_ST_FIRST_MAJOR]![CLASS]>"08","UNK", PREV_UW (previously at UW) • The first time they appear at the PROF level is NOT the first time they appear in the UW’s census day registration snapshot as a student (i.e. they were here before) And [OIS_ST_FIRST_MAJOR]![CLASS]>"08","PREV_UW",
Documentation_STUDENT_ORIGINS.docx