[MyQuery] 851 "hopkimg9408" "Naviance Export" "Naviance Export" [END] [MyQueryTables] 851 852 1 "EACH" "Student" no 851 853 2 "FIRST" "Person" no 851 855 3 "FIRST" "EntryWithdrawl" no 851 857 4 "FIRST" "EntryWithdrawlCodes" no 851 859 5 "FIRST" "EnrollStatus" no 851 861 6 "FIRST" "Scale" no 851 862 7 "FIRST" "StuPriSchoolYear" no 851 864 8 "FIRST" "GPACalc" no 851 866 9 "FIRST" "StuCreditGPA" no 851 868 10 "FIRST" "addressPerson" no 851 870 11 "FIRST" "Address" no 851 872 12 "FIRST" "PhonePerson" no 851 874 13 "FIRST" "Phone" no 851 876 14 "FIRST" "bPhonePerson" yes 851 878 15 "FIRST" "bPhone" yes 851 880 16 "FIRST" "StuEthnicX" no 851 882 17 "FIRST" "EthnicRaceCodes" no 851 884 18 "FIRST" "CountryCodes" no [END] [MyQueryWhere] 851 "AND" "" "GPACalc" "DeletedFlag" "=" "" "" "False" "" 928 "" 864 2 851 "AND" "" "GPACalc" "TestRun" "=" "" "" "False" "" 929 "" 864 3 851 "AND" "" "GPACalc" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 930 "" 864 4 851 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 854 "" 853 1 851 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 856 "" 855 1 851 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 858 "" 857 1 851 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 860 "" 859 1 851 "WHERE" "" "StuPriSchoolYear" "StudentID" "=" "Student" "StudentID" "" "" 863 "" 862 1 851 "WHERE" "" "GPACalc" "ScaleSeq" "=" "Scale" "ScaleSeq" "" "" 865 "" 864 1 851 "WHERE" "" "StuCreditGPA" "StudentID" "=" "Student" "StudentID" "" "" 867 "" 866 1 851 "Where" "" "addressPerson" "PersonSeq" "=" "Student" "personSeq" "" "" 869 "" 868 1 851 "Where" "" "Address" "AddressSeq" "=" "addressPerson" "AddressSeq" "" "" 871 "" 870 1 851 "OUTER-JOIN WHERE" "" "PhonePerson" "PersonSeq" "=" "Student" "personSeq" "" "" 873 "" 872 1 851 "OUTER-JOIN WHERE" "" "Phone" "PhoneSeq" "=" "PhonePerson" "PhoneSeq" "" "" 875 "" 874 1 851 "OUTER-JOIN WHERE" "" "bPhonePerson" "PersonSeq" "=" "Student" "personSeq" "" "" 877 "" 876 1 851 "OUTER-JOIN WHERE" "" "bPhone" "PhoneSeq" "=" "bPhonePerson" "PhoneSeq" "" "" 879 "" 878 1 851 "Where" "" "StuEthnicX" "StudentID" "=" "Student" "StudentID" "" "" 881 "" 880 1 851 "Where" "" "EthnicRaceCodes" "EthnicRaceCodesSeq" "=" "StuEthnicX" "EthnicRaceCodesSeq" "" "" 883 "" 882 1 851 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "False" "" 885 "" 852 1 851 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/06/2006" "" 886 "" 855 2 851 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2007" "" 887 "" 855 3 851 "AND" "" "EntryWithdrawl" "SchoolProfileSeq" "=" "" "" "2" "" 888 "" 855 4 851 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 889 "" 859 2 851 "WHERE" "" "Scale" "ScaleCode" "=" "" "" "4.0" "" 890 "" 861 1 851 "AND" "" "StuPriSchoolYear" "SchoolProfileSeq" "=" "EntryWithdrawl" "SchoolProfileSeq" "" "" 891 "" 862 2 851 "AND" "" "StuPriSchoolYear" "CalendarYearSeq" "=" "" "" "13" "" 892 "" 862 3 851 "AND" "" "StuCreditGPA" "GPACalcSeq" "=" "GPACalc" "GPACalcSeq" "" "" 893 "" 866 2 851 "AND" "" "StuCreditGPA" "DeletedFlag" "=" "" "" "False" "" 894 "" 866 3 851 "AND" "" "StuCreditGPA" "CalendarYearSeq" "=" "StuPriSchoolYear" "CalendarYearSeq" "" "" 895 "" 866 4 851 "AND" "" "PhonePerson" "PhoneTypeSeq" "=" "" "" "13" "" 896 "" 872 2 851 "AND" "" "bPhonePerson" "PhoneTypeSeq" "=" "" "" "19" "" 897 "" 876 2 851 "WHERE" "" "CountryCodes" "CountryCodesSeq" "=" "Student" "CountryOfOrigin" "" "" 898 "" 884 1 851 "AND" "" "GPACalc" "SchoolProfileSeq" "=" "StuPriSchoolYear" "SchoolProfileSeq" "" "" 931 "" 864 5 851 "AND" "" "GPACalc" "GradeLevelSeq" "=" "StuPriSchoolYear" "gradeLevelSeq" "" "" 932 "" 864 6 [END] [MyQueryFields] 851 903 "Person" "FirstName" "" "x(15)" "First Name" no 1 851 904 "Person" "MiddleInitial" "" "X(1)" "MI" no 2 851 912 "Student" "DateOfBirth" "" "99/99/9999" "D.O.B." no 10 851 905 "Person" "LastName" "" "x(15)" "Last Name" no 3 851 906 "Student" "PreferredName" "" "X(20)" "Nickname" no 4 851 907 "Student" "YOG" "" "9999" "YOG" no 5 851 908 "Student" "Gender" "" "Male/Female" "Gender" no 6 851 909 "Student" "StudentID" "" "ZZZZZZZ9" "Student ID" no 7 851 910 "Student" "Counselor" "" ">>>>>>9" "Counselor ID" no 8 851 911 "EthnicRaceCodes" "Description" "" "X(50)" "Race" no 9 851 913 "Address" "StreetNo" "" "x(8)" "Street No" no 11 851 914 "Address" "Address1" "" "X(25)" "Address1" no 12 851 915 "Address" "Address2" "" "X(25)" "Address" no 13 851 916 "Address" "City" "" "X(25)" "City" no 14 851 917 "Address" "State" "" "X(2)" "State" no 15 851 918 "Address" "ZipCode" "" "X(10)" "Zip Code" no 16 851 919 "CountryCodes" "Description" "" "X(50)" "Description" no 17 851 920 "StuCreditGPA" "CareerGPA" "" "->>,>>9.999" "Career GPA" no 18 851 921 "StuCreditGPA" "CareerRank" "" "->,>>>,>>9" "Career Rank" no 19 851 922 "Student" "SSN" "" "999-99-9999" "SSN" no 20 851 923 "Person" "email" "" "x(30)" "Email" no 21 851 924 "Phone" "PhoneNo" "" "X(15)" "Home Phone" no 22 851 925 "bPhone" "PhoneNo" "" "X(15)" "Cell Phone" no 23 [END] [MyQuerySort] 851 927 "Person" "FirstName" no "" 2 "" "" no 851 926 "Person" "LastName" no "" 1 "" "" no [END] [MyQueryDocs] 851 899 2 "Portrait" 0 "" "" 851 900 6 "Portrait" 0 "" "" 851 901 1 "Portrait" 0 "" "" 851 902 4 "" 0 "" "" [END]