IF all of client’s SEX_ID are then set to ‘@’ ‘@’ ELSE IF all of client’s SEX_ID is the same (ignoring then set to SEX_ID ‘@’s) ELSE set to ‘@’ Age Group IF all of client’s AGE is 0 then set to ‘UNKNOWN’ ELSE set to MODE(AGE_group) (ignoring ‘0’s) State ID (client residential) If all of client’s STATE_ID are then set to ‘@@’ ‘@@’ ELSE IF all of the client’s STATE_ID is the same (ignoring @s) then set to STATE_ID ELSE set to ‘@@’ Indigenous Flag IF all of client’s INDIGENOUS_ID are in then set indigenous_fg to ‘@’s ‘@’ ELSE IF all of client’s INDIGENOUS _ID are in (‘1’,’2’,’3’) (ignoring then set indigenous_fg to ‘@’s) ‘Y’ ELSE IF all of client’s INDIGENOUS _ID are in (ignoring then set indigenous_fg to ‘4’ ‘@’s) ‘N’ ELSE set indigenous_fg to ‘@’ Disability Flag IF all of client’s DISABILITY_FG are then set to ‘@’ ‘@’ ELSE IF all of client’s DISABILITY_FG is the same (ignoring then set to DISABILITY_FG ‘@’s) ELSE set to ‘@’ At School Flag IF all of client’s AT_SCHL_FG are then set to ‘@’ ‘@’ ELSE IF all of client’s AT_SCHL_FG is the same (ignoring then set to AT_SCHL_FG ‘@’s) ELSE set to ‘@’ Prior education achievement flag IF at least one of client’s PRIOR_ED_ACHIEVE_FG = then set to ‘Y’ ‘Y’ ELSE set to ‘N’ Highest Education Level Set to MANDATORY’ where the client is associated with prior_education_achievement_flag or ‘NOT ‘N’ AND client is associated with a derived_highest_school_level of all ‘@’ ‘@@’ ELSE set to highest of HIGHEST_ED_LVL_ST English Flag (using language ID) IF all of client’s LANGUAGE_ID are then set to ‘@@@@’ ‘@@@@’
IF all of client’s SEX_ID are ‘@’ then set to ‘@’ ELSE IF all of client’s SEX_ID is the same (ignoring ‘@’s) then set to SEX_ID ELSE set to ‘@’ Age Group IF all of client’s AGE is 0 then set to ‘UNKNOWN’ ELSE set to MODE(AGE_group) (ignoring ‘0’s) State ID (client residential) If all of client’s STATE_ID are ‘@@’ then set to ‘@@’ ELSE IF all of the client’s STATE_ID is the same (ignoring @s) then set to STATE_ID ELSE set to ‘@@’ Indigenous Flag IF all of client’s INDIGENOUS_ID are in ‘@’s then set indigenous_fg to ‘@’ ELSE IF all of client’s INDIGENOUS _ID are in (‘1’,’2’,’3’) (ignoring ‘@’s) then set indigenous_fg to ‘Y’ ELSE IF all of client’s INDIGENOUS _ID are in ‘4’ (ignoring ‘@’s) then set indigenous_fg to ‘N’ ELSE set indigenous_fg to ‘@’ Disability Flag IF all of client’s DISABILITY_FG are ‘@’ then set to ‘@’ ELSE IF all of client’s DISABILITY_FG is the same (ignoring ‘@’s) then set to DISABILITY_FG ELSE set to ‘@’ At School Flag IF all of client’s AT_SCHL_FG are ‘@’ then set to ‘@’ ELSE IF all of client’s AT_SCHL_FG is the same (ignoring ‘@’s) then set to AT_SCHL_FG ELSE set to ‘@’ Prior education achievement flag IF at least one of client’s PRIOR_ED_ACHIEVE_FG = ‘Y’ then set to ‘Y’ ELSE set to ‘N’ Highest Education Level Set to ‘NOT MANDATORY’ where the client is associated with prior_education_achievement_flag ‘N’ or ‘@’ AND client is associated with a derived_highest_school_level of all ‘@@’ ELSE set to highest of HIGHEST_ED_LVL_ST English Flag (using language ID) IF all of client’s LANGUAGE_ID are ‘@@@@’ then set to ‘@@@@’
Technical-paper-Counting-students-in-Total-VET-students-and-courses.docx