[MyQuery] 14165 "NPSIMG9408" "EEO Survey" "EEO Survey" [END] [MyQueryTables] 14165 14200 1 "EACH" "TeacherStatus" no 0 14165 14177 2 "EACH" "Teacher" no 0 14165 14179 3 "EACH" "TeacherJobTypeX" no 0 14165 14166 4 "FIRST" "HRSBio" no 0 14165 14167 5 "EACH" "HRSCareer" no 0 14165 14172 6 "FIRST" "Person" no 0 14165 14174 7 "EACH" "PersonEthnicX" no 0 14165 14168 8 "EACH" "EthnicRaceCodes" no 0 14165 14169 9 "EACH" "JobTypes" no 0 14165 14208 10 "EACH" "SchoolProfile" no 0 [END] [MyQueryWhere] 14165 "WHERE" "" "JobTypes" "JobTypesCodeSeq" "=" "HRSCareer" "EmpTypeSeq" "" "" 14170 "" 14169 1 14165 "WHERE" "" "TeacherJobTypeX" "teacherSeq" "=" "Teacher" "teacherSeq" "" "" 14180 "" 14179 1 14165 "WHERE" "" "SchoolProfile" "SchoolProfileSeq" "=" "HRSCareer" "SchoolProfileSeq" "" "" 14209 "" 14208 1 14165 "WHERE" "" "Teacher" "TeacherStatusSeq" "=" "TeacherStatus" "TeacherStatusSeq" "" "" 14178 "" 14177 1 14165 "WHERE" "" "EthnicRaceCodes" "EthnicRaceCodesSeq" "=" "PersonEthnicX" "EthnicRaceCodesSeq" "" "" 14176 "" 14168 1 14165 "WHERE" "" "HRSCareer" "EmpID" "=" "HRSBio" "EmpID" "" "" 14171 "" 14167 1 14165 "Where" "" "Person" "PersonSeq" "=" "HRSBio" "PersonSeq" "" "" 14173 "" 14172 1 14165 "Where" "" "PersonEthnicX" "PersonSeq" "=" "HRSBio" "PersonSeq" "" "" 14175 "" 14174 1 14165 "WHERE" "" "TeacherStatus" "StateCode" "=" "" "" "01" "" 14201 "" 14200 1 14165 "WHERE" "" "HRSBio" "PersonSeq" "=" "Teacher" "PersonSeq" "" "" 14202 "" 14166 1 14165 "AND" "" "HRSCareer" "DateEnd" "=" "" "" "?" "" 14204 "" 14167 2 14165 "AND" "" "TeacherJobTypeX" "mainjob" "=" "" "" "Yes" "" 14212 "" 14179 2 14165 "AND" "" "HRSCareer" "FET" "<>" "" "" "0" "" 14216 "" 14167 3 14165 "AND" "" "HRSCareer" "EmpTypeSeq" "=" "TeacherJobTypeX" "JobTypesCodeSeq" "" "" 14219 "" 14167 4 [END] [MyQueryFields] 14165 14192 "Person" "Gender" "" "Male/Female" "Gender" no 11 0 14165 14193 "EthnicRaceCodes" "EthnicCode" "" "X(6)" "Race Code" no 12 0 14165 14194 "EthnicRaceCodes" "StateCode" "" "X(3)" "Race State Code" no 13 0 14165 14195 "EthnicRaceCodes" "Description" "" "X(50)" "Race Description" no 14 0 14165 14196 "JobTypes" "Description" "" "X(20)" "Job Type Description" no 16 0 14165 14197 "JobTypes" "StateCode" "" "X(4)" "Job Type StateCode" no 17 0 14165 14185 "HRSBio" "EmpID" "" ">,>>>,>>9" "EMP ID" no 2 0 14165 14186 "HRSBio" "StateID" "" "99999999" "State ID" no 3 0 14165 14187 "HRSCareer" "DateStart" "" "99/99/99" "Start Date" no 4 0 14165 14210 "SchoolProfile" "SchoolCode" "" "X(3)" "School!Code" no 1 0 14165 14211 "SchoolProfile" "SchoolName" "" "X(50)" "School Name" no 15 0 14165 14188 "HRSCareer" "DateEnd" "" "99/99/99" "End Date" no 5 0 14165 14190 "Person" "FirstName" "" "x(15)" "First Name" no 9 0 14165 14191 "Person" "LastName" "" "x(15)" "Last Name" no 10 0 14165 14205 "Teacher" "FullTime" "" "Full/Part" "Full!Time" no 6 0 14165 14214 "TeacherJobTypeX" "mainjob" "" "yes/no" "Is main Job" no 8 0 14165 14215 "HRSCareer" "FET" "" "->>,>>9.99" "FTE" no 7 0 [END] [MyQuerySort] 14165 14308 "Person" "LastName" no "" 1 "" "" no 14165 14309 "Teacher" "teacherSeq" yes "Count" 2 "Teacher" "teacherSeq" no [END] [MyQueryDocs] 14165 14183 1 "Portrait" 0 "" "" 14165 14184 4 "" 0 "" "" 14165 14181 2 "Portrait" 0 "" "" 14165 14182 6 "Portrait" 0 "" "" [END]