Student Indicators
Student Indicators
IndicatorName |
|---|
when S_SC_STU_CATE_C.cert_admin IS NOT NULL then indicator = the value of S_SC_STU_CATE_C.cert_admin and IndicatorName ='CTE Certification' |
when S_SC_STU_CATE_X.CATE_YrCompleted is Not Null the IndicatorName='CTE Completion Year 1' |
when S_SC_STU_CATE_X.CATE_YrCompleted2 is Not Null the IndicatorName='CTE Completion Year 2' |
when S_SC_STU_CATE_X.CATE_YrConcntrYr is Not Null the IndicatorName='CTE Concentrator Year 1' |
when S_SC_STU_CATE_X.CATE_YrConcntrYr2 is Not Null the IndicatorName='CTE Concentrator Year 2' |
when S_SC_STU_CATE_X.PlaceLevelCode is NOT NULL then IndicatorName='CTE Placement Code'; else do not publish |
When S_SC_STU_CATE_X.PlaceEmployer is NOT NULL then IndicatorName='CTEPlaceEmployer' |
When S_SC_STU_CATE_X.PlaceHigherEdName is NOT NULL then IndicatorName='CTEPlaceHigherEdName' |
When S_SC_STU_CATE_X.PlaceJobTitle is NOT NULL then IndicatorName='CTEPlaceJobTitle' |
When S_SC_STU_CATE_X.PlaceLevelCode is NOT NULL then IndicatorName='CTEPlaceLevelCode' |
When S_SC_STU_CATE_X.PlaceMilitaryBranch is NOT NULL then IndicatorName='CTEPlaceMilitaryBranch' |
When S_SC_STU_CATE_X.PlaceMilitaryTrain is NOT NULL then IndicatorName='CTEPlaceMilitaryTrain' |
When S_SC_STU_CATE_X.PlacePhone is NOT NULL then IndicatorName='CTEPlacePhone' |
When S_SC_STU_CATE_X.PlaceStartDate is NOT NULL then IndicatorName='CTEPlaceStartDate' |
When S_SC_STU_CATE_X.PlaceSupervisorName is NOT NULL then IndicatorName='CTEPlaceSupervisorName' |
When S_SC_STU_CATE_X.CATE_SingleParentInd is NOT NULL then indicatorName="Single Parent Ind"; |
When S_SC_STU_CATE_X.CATE_DisplHomeMakerInd is NOT NULL then indicatorName="Out-of-Workforce Individual"; |
When S_SC_STU_CATE_X.CATE_ExceptionsCode is NOT NULL then indicatorName="CTE Exceptions"; |
When S_SC_STU_CATE_X.CATE_Units is NOT NULL then indicatorName="3-Unit Completer 1"; |
When S_SC_STU_CATE_X.CATE_Units2 is NOT NULL then indicatorName="3-Unit Completer 2"; |
When S_SC_STU_WBL.WBL_EmpNameCCR is NOT NULL then IndicatorName='WBL CCR Worksite Name'; |
When S_SC_STU_WBL.WBL_EmpName1 is NOT NULL then IndicatorName='WBL Worksite Name 1'; |
When S_SC_STU_WBL.WBL_EmpName2 is NOT NULL then IndicatorName='WBL Worksite Name 2'; |
When S_SC_STU_WBL.WBL_EmpName3 is NOT NULL then IndicatorName='WBL Worksite Name 3'; |
When S_SC_STU_WBL.WBL_EmpName4 is NOT NULL then IndicatorName='WBL Worksite Name 4'; |
When S_SC_STU_WBL.WBL_EmpName5 is NOT NULL then IndicatorName='WBL Worksite Name 5'; |
When S_SC_STU_WBL.WBL_EmpName6 is NOT NULL then IndicatorName='WBL Worksite Name 6'; |
When S_SC_STU_WBL.WBL_EmpName7 is NOT NULL then IndicatorName='WBL Worksite Name 7'; |
When S_SC_STU_WBL.WBL_EmpName8 is NOT NULL then IndicatorName='WBL Worksite Name 8'; |
When S_SC_STU_WBL.WBL_EmpName9 is NOT NULL then IndicatorName='WBL Worksite Name 9'; |
When S_SC_STU_WBL.WBL_EmpName10 is NOT NULL then IndicatorName='WBL Worksite Name 10'; |
When S_SC_STU_WBL.WBL_AgreementCCR is NOT NULL then indicatorName="WBL CCR Training Agreement"; |
When S_SC_STU_WBL.WBL_CreditIndCCR is NOT NULL then indicatorName="WBL CCR Course Credit"; |
When S_SC_STU_WBL.WBL_CreditInd1 is NOT NULL then indicatorName="WBL Course Credit 1"; |
When S_SC_STU_WBL.WBL_CreditInd2 is NOT NULL then indicatorName="WBL Course Credit 2"; |
When S_SC_STU_WBL.WBL_CreditInd3 is NOT NULL then indicatorName="WBL Course Credit 3"; |
When S_SC_STU_WBL.WBL_CreditInd4 is NOT NULL then indicatorName="WBL Course Credit 4"; |
When S_SC_STU_WBL.WBL_CreditInd5 is NOT NULL then indicatorName="WBL Course Credit 5"; |
When S_SC_STU_WBL.WBL_CreditInd6 is NOT NULL then indicatorName="WBL Course Credit 6"; |
When S_SC_STU_WBL.WBL_CreditInd7 is NOT NULL then indicatorName="WBL Course Credit 7"; |
When S_SC_STU_WBL.WBL_CreditInd8 is NOT NULL then indicatorName="WBL Course Credit 8"; |
When S_SC_STU_WBL.WBL_CreditInd9 is NOT NULL then indicatorName="WBL Course Credit 9"; |
When S_SC_STU_WBL.WBL_CreditInd10 is NOT NULL then indicatorName="WBL Course Credit 10"; |
when S_SC_STU_WBL.WBL_HoursMetCCR is NOT NULL then indicatorName="WBL CCR 40-Hour Minimum Met"; |
when S_SC_STU_WBL.WBL_PaidInCCR is NOT NULL then indicatorName="WBL CCR Paid"; |
when S_SC_STU_WBL.WBL_PaidInd1 is NOT NULL then indicatorName="WBL Paid 1"; |
when S_SC_STU_WBL.WBL_PaidInd2 is NOT NULL then indicatorName="WBL Paid 2"; |
when S_SC_STU_WBL.WBL_PaidInd3 is NOT NULL then indicatorName="WBL Paid 3"; |
when S_SC_STU_WBL.WBL_PaidInd4 is NOT NULL then indicatorName="WBL Paid 4"; |
when S_SC_STU_WBL.WBL_PaidInd5 is NOT NULL then indicatorName="WBL Paid 5"; |
when S_SC_STU_WBL.WBL_PaidInd6 is NOT NULL then indicatorName="WBL Paid 6"; |
when S_SC_STU_WBL.WBL_PaidInd7 is NOT NULL then indicatorName="WBL Paid 7"; |
when S_SC_STU_WBL.WBL_PaidInd8 is NOT NULL then indicatorName="WBL Paid 8"; |
when S_SC_STU_WBL.WBL_PaidInd9 is NOT NULL then indicatorName="WBL Paid 9"; |
when S_SC_STU_WBL.WBL_PaidInd10 is NOT NULL then indicatorName="WBL Paid 10"; |
when S_SC_STU_WBL.WBL_RelateInCCR is NOT NULL then indicatorName="WBL CCR Related to Career Plan"; |
When S_SC_STU_WBL.WBL_CarCod1 is NOT NULL then indicatorName="WBL Career Assessment 1"; |
When S_SC_STU_WBL.WBL_CarCod2 is NOT NULL then indicatorName="WBL Career Assessment 2"; |
When S_SC_STU_WBL.WBL_CarCod3 is NOT NULL then indicatorName="WBL Career Assessment 3"; |
When S_SC_STU_WBL.WBL_CarCod4 is NOT NULL then indicatorName="WBL Career Assessment 4"; |
When S_SC_STU_WBL.WBL_CarCod5 is NOT NULL then indicatorName="WBL Career Assessment 5"; |
When S_SC_STU_WBL.WBL_CarCod6 is NOT NULL then indicatorName="WBL Career Assessment 6"; |
When S_SC_STU_WBL.WBL_EvalScoreCCR is NOT NULL then indicatorName="WBL CCR Evaluation Score"; |
When S_SC_STU_WBL.WBL_TypeCCR is NOT NULL then indicatorName="WBL CCR Career Cluster Type"; |
When S_SC_STU_X.WBL_ExpOwner1 is NOT NUll then indicatorName="WBL Exp1 Owner"; |
When S_SC_STU_X.WBL_ExpOwner2 is NOT NUll then indicatorName="WBL Exp2 Owner"; |
When S_SC_STU_X.WBL_ExpOwner3 is NOT NUll then indicatorName="WBL Exp3 Owner"; |
When S_SC_STU_X.WBL_ExpOwner4 is NOT NUll then indicatorName="WBL Exp4 Owner"; |
When S_SC_STU_X.WBL_ExpOwner5 is NOT NUll then indicatorName="WBL Exp5 Owner"; |
When S_SC_STU_X.WBL_ExpOwner6 is NOT NUll then indicatorName="WBL Exp6 Owner"; |
When S_SC_STU_X.WBL_ExpOwner7 is NOT NUll then indicatorName="WBL Exp7 Owner"; |
When S_SC_STU_X.WBL_ExpOwner8 is NOT NUll then indicatorName="WBL Exp8 Owner"; |
When S_SC_STU_X.WBL_ExpOwner9 is NOT NUll then indicatorName="WBL Exp9 Owner"; |
When S_SC_STU_X.WBL_ExpOwner10 is NOT NUll then indicatorName="WBL Exp10 Owner"; |
When S_SC_STU_X.WBL_ExpOwnerCCR is NOT NUll then indicatorName="WBL ExpCCR Owner"; |
When S_SC_STU_EC_X.DaysServed_PerWeek is NOT NULL then indicatorName="Day per Week Served"; |
When S_SC_STU_EC_X.EC_PriorClassType is NOT NULL then indicatorName="Prior Class Type"; |
When S_SC_STU_EC_X.EC_PriorProvider is NOT NULL then indicatorName="Prior Provider"; |
When S_SC_STU_EC_X.EC_CarePriorToSchCode is NOT NULL then indicatorName="Prior Child Care"; |
When S_SC_STU_EC_X.EC_ClassCurrCode is NOT NULL then indicatorName="Class Curriculum"; |
When S_SC_STU_EC_X.EC_CountDownToKinderInd is NOT NULL then indicatorName="Countdown to Kindergarten" |
When S_SC_STU_EC_X.EC_EarlyChildPlaceCode is NOT NULL then indicatorName="Early Childhood Placement"; |
When S_SC_STU_EC_X.EC_FamilyIncRangeCode is NOT NULL then indicatorName="Income Range"; |
When S_SC_STU_EC_X.EC_FamilyLiteracySrvcs is NOT NULL then indicatorName="Family Literacy Services"; |
When S_SC_STU_EC_X.EC_yrsfamilylitsrvcs is NOT NULL then indicatorName="Family Literacy Years"; |
When S_SC_STU_EC_X.EC_HeadStartInd is NOT NULL then indicatorName="Head Start Indicator"; |
When S_SC_STU_EC_X.EC_LowBirthWeightInd is NOT NULL then indicatorName="Low Birth Weight Ind"; |
When S_SC_STU_EC_X.EC_MedCareSrcCode is NOT NULL then indicator = value of S_SC_STU_EC_X.EC_MedCareSrcCode and indicatorName="Medical Care Source"; |
When S_SC_STU_EC_X.EC_TuitionPayer is NOT NULL then indicatorName="Tuition Payer"; |
When S_SC_STU_EC_X.EdLevel_MomFG is NOT NULL then indicatorName="Education Level of Mom"; |
When S_SC_STU_EC_X.YearsED_MomFG is NOT NULL then inidcatorName="Years of Education Mom"; |
When S_SC_STU_ReadToSucceed_X.GCE_504 is NOT NULL then IndicatorName="GCE 504 Plan"; |
When S_SC_STU_ReadToSucceed_X.AltAssessed_GCE is NOT NULL then IndicatorName="GCE Alt Assess"; |
When S_SC_STU_ReadToSucceed_X.Determination_Factor is NOT NULL then IndicatorName="Determination Factor" |
When S_SC_STU_ReadToSucceed_X.English_Learner_GCE is NOT NULL then IndicatorName="GCE English Learner" |
When S_SC_STU_ReadToSucceed_X.IEP_GCE is NOT NULL then IndicatorName="GCE IEP"; |
When S_SC_STU_ReadToSucceed_X.Invited is NOT NULL then IndicatorName="Invited Indicator" |
When S_SC_STU_ReadToSucceed_X.PostAssessment is NOT NULL then IndicatorName="Post-Assessment Tool"; |
When S_SC_STU_ReadToSucceed_X.PostAssessment_Score is NOT NULL then IndicatorName="Post-Assessment Score"; |
When S_SC_STU_ReadToSucceed_X.PreAssessment is NOT NULL then IndicatorName="Pre-Assessment Tool"; |
When S_SC_STU_ReadToSucceed_X.PreAssessment_Score is NOT NULL then IndicatorName="Pre-Assessment Score"; |
When S_SC_STU_ReadToSucceed_X.PreviouslyRetained_GCE is NOT NULL then IndicatorName="GCE Previously Retained"; |
When S_SC_STU_ReadToSucceed_X.Proficiency_Level is NOT NULL then IndicatorName="Progress Proficiency Level"; |
When S_SC_STU_ReadToSucceed_X.Promotion_Status is NOT NULL then IndicatorName="Promotion Status"; |
When S_SC_STU_ReadToSucceed_X.ReadingPortfolio_GCE is NOT NULL then IndicatorName="GCE Reading Portfolio"; |
When S_SC_STU_ReadToSucceed_X.SummerReading_GCE is NOT NULL then IndicatorName="GCE Summer Reading"; |
When S_SC_STU_ReadToSucceed_X.Superintendent_GCE is NOT NULL then IndicatorName=" GCE Superintendent"; |
When S_SC_STU_X.Precode1 is NOT NULL then IndicatorName="Precode 1"; |
When S_SC_STU_X.Precode2 is NOT NULL then IndicatorName="Precode 2"; |
When S_SC_STU_X.Precode3 is NOT NULL then IndicatorName="Precode 3"; |
When S_SC_STU_X.Precode4 is NOT NULL then IndicatorName="Precode 4"; |
When S_SC_STU_X.Precode5 is NOT NULL then IndicatorName="Precode 5"; |
When S_SC_STU_X.Precode6 is NOT NULL then IndicatorName="Precode 6"; |
When S_SC_STU_X.Precode7 is NOT NULL then IndicatorName="Precode 7"; |
When S_SC_STU_X.Precode8 is NOT NULL then IndicatorName="Precode 8"; |
when S_SC_STU_X.AdultEd_EntryDate IS NOT NULL then IndicatorName='Adult Ed Entry Date'; |
when S_SC_STU_X.AdultEd_ExitDate IS NOT NULL then IndicatorName='Adult Ed Exit Date'; |
when S_SC_STU_X.AdultEd_GradDate IS NOT NULL then IndicatorName='Adult Ed Grad Date'; |
when S_SC_STU_X.YRGEDEarned IS NOT NULL then IndicatorName='GED Earned'; |
when S_SC_STU_X.G38PaperEla is NOT NULL then inidicatorName="Elem/Middle Paper ELA Indicator"; |
when S_SC_STU_X.G38PaperMath is NOT NULL then inidicatorName="Elem/Middle Paper Math Indicator"; |
when S_SC_STU_X.G38PaperScience is NOT NULL then inidicatorName="Elem/Middle Paper Science Indicator"; |
when S_SC_STU_X.G38PaperSocStu is NOT NULL then inidicatorName="Elem/Middle Paper Social Studies Indicator"; |
when S_SC_STU_X.EOCEPPaperEla is NOT NULL then inidicatorName="Middle/High Paper English Indicator"; |
when S_SC_STU_X.EOCEPPaperMath is NOT NULL then inidicatorName="Middle/High Paper Algebra Indicator"; |
when S_SC_STU_X.EOCEPPaperScience is NOT NULL then inidicatorName="Middle/High Paper Science Indicator"; |
when S_SC_STU_X.EOCEPPaperSocStu is NOT NULL then inidicatorName="Middle/High Paper Social Studies Indicator"; |
When S_SC_STU_X.CustomELACde is NOT NULL then indicatorName="ELA Custom Materials"; |
When S_SC_STU_X.CustomMathCde is NOT NULL then indicatorName="Math Custom Materials"; |
When S_SC_STU_X.CustomSciCde is NOT NULL then indicatorName="Science Custom Materials"; |
When S_SC_STU_X.CustomSocStuCde is NOT NULL then indicatorName="Social Studies Custom Materials'; |
When S_SC_STU_X.Elig504_NoPlanInd is NOT NUll the IndicatorName="504_Eligible"; |
when S_SC_STU_X.MedicaidEligible_Date is NOT NULL then IndicatorName="MedicaidEligibleDate"; |
When S_SC_STU_X.medicaidID is NOT NULL then IndicatorName="MedicaidID"; |
When S_SC_STU_X.MultiDisabInd is NOT NULL then IndicatorName="MultipleDisabilitesInd"; |
When S_SC_STU_X.NeedsBrailleInd = "1" then indicator = "1" and indicatorName = "NeedsBrailleInd" |
When S_SC_STU_X.deafblindind is NOT NULL then indicatorName="Deaf-Blindness"; |
When S_SC_STU_X.CR_Accommodations is NOT NULL then indicatorName="Careeer Readiness Accommodations"; |
When S_SC_STU_X.CR_Oral_Accomodation is NOT NULL then indicatorName="Career Readiness Oral Accommodation"; |
When S_SC_STU_X.OralELA is NOT NULL then indicatorName="ELA Oral"; |
When S_SC_STU_X.OralMath is NOT NULL then indicatorName="Math Oral"; |
When S_SC_STU_X.OralScience is NOT NULL then indicatorName="Science Oral"; |
When S_SC_STU_X.OralSocStudies is NOT NULL then indicatorName="Social Studies Oral"; |
when S_SC_STU_ADDONWTGS_C.ACAS_ELIGIBILITY_IND='Y' then IndicatorName='AcademicAssistance' and indicator = 'Y' |
when S_SC_STU_ESOL_X.Parent_30_Notification IS NOT NULL then IndicatorName='Parent Notification Letter' |
when STUDENTCOREFIELDS.graduation_year IS NOT NULL then IndicatorName='Expected Graduation Year' |
when STUDENTS.Sched_YearOfGraduation IS NOT NULL then IndicatorName='Sched_YearOfGraduation' |
when S_SC_STU_X.TrueGrade is not NULL then indicator = value of S_SC_STU_X.TrueGrade and IndicatorName='TrueGrade'; |
When S_SC_STU_X.DiplomaOrdCode is NOT NULL then IndicatorName="Diploma Order Code"; |
When S_SC_STU_X.Dropout_Date is NOT NULL then IndicatorName="Dropout Date"; |
When S_SC_STU_X.Dropout_Reason is NOT NULL the IndicatorName="Dropout Reason"; |
When S_SC_STU_X.Migrant is NOT NULL then IndicatorName="MigrantIndicator"; |
When S_SC_STU_X.Moved_To_District is NOT NULL then indicatorName="Moved to District"; |
When S_SC_STU_X.Moved_To_School is NOT NULL then indicatorName="Moved to School"; |
When S_SC_STU_X.Other_AltAssessTest_SchoolID is NOT NULL then indicatorName="Other Alternate Assessment School ID"; |
When S_SC_STU_X.SchoolRes is NOT NULL then IndicatorName="School of Residence"; |
When S_SC_STU_X.ScienceSortID is NOT NULL then indicatorName="ScienceSortID"; |
When S_SC_STU_X.SocStudiesSortID is NOT NULL then indicatorName="SocStudiesSortID"; |
When S_SC_STU_X.SEI_Create_Date is NOT NULL then indicatorName="SEI Create Date"; |
When S_SC_STU_X.Trans_Mode_AM is NOT NULL then indicatorName="Transportation Mode AM"; |
When S_SC_STU_X.Trans_Mode_PM is NOT NULL then indicatorName="Transportation Mode PM"; |
When students.Home_Room is NOT NULL then inidicatorName="Home Room"; |
When S_SC_STU_X.Qualifying_Move is NOT NULL then indicatorName="Qualifying Move"; |
When S_SC_STU_X.Qualifying_Occupation is NOT NULL then indicatorName="Qualifying Occupation"; |
When S_SC_STU_X.House_Status is NOT NULL then IndicatorName="House Status"; |
When S_SC_STU_X.SEI_Status is NOT NULL then indicatorName="SEI Status"; |
When S_SC_STU_X.IncludeInReporting is NOT NULL then indicatorName="Include in State Reporting"; |
When S_SC_STU_X.InstrSetting is NOT NULL then indicatorName="Instructional Setting"; |
When S_SC_STU_X.KndrgrtnPrevPgm is NOT NULL then indicatorName="Kindergarten - Previous Program"; |
When S_SC_STU_X.NoShow_Reason is NOT NULL then indicatorName="No Show Reason"; |
When S_SC_STU_X.ParentsMilitaryStatus is NOT NULL then indicatorName="Parent Military Status"; |
When S_SC_STU_X.Tier is NOT NULL then indicatorName="ELP Paper Tier"; |
When S_SC_STU_X.Universal_Screener is NOT NULL then indicatorName="Universal Screener"; |
When S_SC_STU_X.ARP_HCY is NOT NULL then IndicatorName="ARP HCY"; |
When S_SC_STU_X.AltAssessCde is NOT NULL then IndicatorName="SC_Assess_Rster_AltCde"; |
When S_SC_STU_X.AltAssessTA_FirstName is NOT NULL then indicatorName="SC_Assess_Rster_FirstName"; |
When S_SC_STU_X.AltAssessTA_LastName is NOT NULL then indicatorName="SC_Assess_Rster_LastName"; |
When S_SC_STU_X.CR_Grade12 = 1, then IndicatorName="SC_Assess_Rster_CReady_Grade12"; else, do not publish |
When S_SC_STU_X.ELASortID is NOT NULL then IndicatorName="SC_ASSESS_Rster_ELASortID"; |
When S_SC_STU_X.AP_Participant_Nbr is NOT NULL then IndicatorName="AP Participant Number"; |
When S_SC_STU_X.BusInfo1 is NOT NULL then IndicatorName="Bus Info 1"; |
When S_SC_STU_X.BusInfo2 is NOT NULL then IndicatorName="Bus Info 2"; |
When S_SC_STU_X.Foster_Home is NOT NULL then indicatorName="Foster_Home"; |
When S_SC_STU_X.GridCode is NOT NULL then IndicatorName="Grid_Code"; |
When S_SC_STU_X.IB_Candidate_Nbr is NOT NULL then IndicatorName="IB_Candidate_Nbr"; |
When S_SC_STU_X.Init_TestDate is NOT NULL then IndicatorName="ENG_Initial Assessment Date"; |
When S_SC_STU_X.Init_TestScore is NOT NULL then IndicatorName="ENG_TestScore"; |
When S_SC_STU_X.Init_TestScore_dec_select is NOT NULL then IndicatorName="ENG_TestScore_Decimal"; |
When S_SC_STU_X.Init_TestType is NOT NULL then IndicatorName="ENG_Assessment"; |
When S_SC_STU_X.MathSortID is NOT NULL then IndicatorName="SC_Assess_Rster_MathSortID"; |
When S_SC_STU_X.GT_Paper is NOT NULL then indicatorName="SC_Assess_Rster_GT_Paper"; |
When S_SC_STU_X.CR_Paper is NOT NULL then IndicatorName="SC_Assess_Rster_CR_Paper"; |
When S_SC_STU_X.ELP_Paper is NOT NULL then IndicatorName="SC_Assess_Rster_ELP_Paper"; |
when efa.efa_primary is not Null then IndicatorName='EFA' |
when eie.eia_1 is not Null then IndicatorName='EIA' |
when ha.highach_1 is not Null then IndicatorName='High_Achieving_GTA' OR 'High_Achieving_GTR' OR 'High_Achieving_AP' OR 'High_Achieving_IB' as applies |
when S_SC_STU_X.PIP_Status is not Null then IndicatorName='PIP'; |
When S_SC_STU_X.ctso.membership1 is NOT NULL then indicatorName="CTSO Membership 1"; |
When S_SC_STU_X.ctso.membership2 is NOT NULL then indicatorName="CTSO Membership 2"; |
When S_SC_STU_X.NinthGradeCode is NOT NULL then indicatorName="Ninth Grade Code"; |
When S_SC_STU_PRV_X.Directory_OptOut is NOT NULL then indicatorName="Directory Information Opt-Out"; |
When S_SC_STU_PRV_X.Military_OptOut is NOT NULL then indicatorName="Military Recruting Information Opt-Out"; |
When STUDENTS.Next_School is NOT NULL then indicatorName="Next School Indicator"; |
When S_SC_STU_X.USSchEntryDate is NOT NULL then indicatorName="Date Entered US"; |
indicatorName="Enroll Status" when students.enroll_status is populated |
When S_SC_STU_ESOL_X.Exception_3Years = '1' then IndicatorName = "Immigrant Funding Exception" |
When Students.ExitComment is not NULL then IndicatorName = "Exit Comment" |
When Certification_Owner has a value, then indicatorName = "Certification Administration Location"; else, do not publish |
Use the studentAssessmentIdentifier value associated with the S_SC_STU_CATE_C.Certification_Owner value. |
S_SC_STU_ESOL_X.Exception_3Years |
STUDENTS.ExitComment |
students.enroll_status |
S_SC_STU_X.USSchEntryDate |
efa.efa_primary; |
eie.eia_1; |
ha.highach_1; |
S_SC_STU_X.PIP_Status |
stu.TrueGrade; |
S_SC_STU_X.AdultEd_EntryDate; |
S_SC_STU_X.AdultEd_ExitDate; |
S_SC_STU_X.AdultEd_GradDate; |
S_SC_STU_X.YRGEDEarned; |
S_SC_STU_ESOL_X.Parent_30_Notification; |
STUDENTCOREFIELDS.graduation_year; |
STUDENTS.Sched_YearOfGraduation |
S_SC_STU_CATE_X.CATE_YrCompleted, |
S_SC_STU_CATE_X.CATE_YrCompleted2, |
S_SC_STU_CATE_X.CTE_ConcntrYr, |
S_SC_STU_CATE_X.CTE_ConcntrYr2, |
S_SC_STU_CATE_X.PlaceEmployer |
S_SC_STU_CATE_X.PlaceHigherEdName |
S_SC_STU_CATE_X.PlaceHigherEdProg |
IndicatorName = 'CTEPlaceHigherEdProg' when S_SC_STU_CATE_X.PlaceHigherEdProg is not NULL |
S_SC_STU_CATE_X.PlaceJobTitle |
S_SC_STU_CATE_X.PlaceLevelCode |
S_SC_STU_CATE_X.PlaceMilitaryBranch |
S_SC_STU_CATE_X.PlaceMilitaryTrain |
S_SC_STU_CATE_X.PlacePhone |
S_SC_STU_CATE_X.PlaceStartDate |
S_SC_STU_CATE_X.PlaceSupervisorName |
S_SC_STU_WBL.WBL_EmpNameCCR; |
S_SC_STU_WBL.WBL_EmpName1; |
S_SC_STU_WBL.WBL_EmpName2; |
S_SC_STU_WBL.WBL_EmpName3; |
S_SC_STU_WBL.WBL_EmpName4; |
S_SC_STU_WBL.WBL_EmpName5; |
S_SC_STU_WBL.WBL_EmpName6; |
S_SC_STU_WBL.WBL_EmpName7; |
S_SC_STU_WBL.WBL_EmpName8; |
S_SC_STU_WBL.WBL_EmpName9; |
S_SC_STU_WBL.WBL_EmpName10; |
S_SC_STU_X.AltAssessCde; |
S_SC_STU_X.AltAssessTA_FirstName; |
S_SC_STU_X.AltAssessTA_LastName; |
When S_SC_STU_X.CR_Grade12_Fall = 1, then indicator = 1; else, do not publish |
When S_SC_STU_X.CR_Grade12_Fall = 1, then indicator = 1; else, do not publish |
S_SC_STU_X.ELASortID; |
S_SC_STU_X.AP_Participant_Nbr; |
S_SC_STU_X.BusInfo1; |
S_SC_STU_X.BusInfo2; |
S_SC_STU_X.DiplomaOrdCode; |
S_SC_STU_X.Dropout_Date; |
S_SC_STU_X.Dropout_Reason; |
S_SC_STU_X.Elig504_NoPlanInd; |
S_SC_STU_X.Foster_Home; |
S_SC_STU_X.GridCode; |
S_SC_STU_X.IB_Candidate_Nbr; |
S_SC_STU_X.Init_TestDate; |
S_SC_STU_X.Init_TestScore; |
S_SC_STU_X.Init_TestScore_dec_select; |
S_SC_STU_X.Init_TestType; |
S_SC_STU_X.MathSortID; |
S_SC_STU_X.GT_Paper; |
S_SC_STU_X.CR_Paper; |
S_SC_STU_X.ELP_Paper; |
S_SC_STU_X.MedicaidEligible_Date; |
S_SC_STU_X.medicaidID; |
When S_SC_STU_X.Migrant = 1, publish Migrant Indicator = 1; when S_SC_STU_X.Migrant = 0 or null or blank, do not publish |
S_SC_STU_X.Moved_To_District; |
S_SC_STU_X.Moved_To_School; |
S_SC_STU_X.MultiDisabInd; |
S_SC_STU_X.NeedsBrailleInd; |
S_SC_STU_X.Other_AltAssessTest_SchoolID; |
S_SC_STU_X.SchoolRes; |
S_SC_STU_X.ScienceSortID; |
S_SC_STU_X.SocStudiesSortID; |
S_SC_STU_X.SEI_Create_Date; |
S_SC_STU_X.Trans_Mode_AM; |
S_SC_STU_X.Trans_Mode_PM; |
students.Home_Room; |
S_SC_STU_X.Qualifying_Move; |
S_SC_STU_X.Qualifying_Occupation; |
When S_SC_STU_X.House_Status="DIS" then || S_SC_STU_X.Disaster; |
S_SC_STU_WBL.WBL_AgreementCCR; |
S_SC_STU_WBL.WBL_CreditIndCCR; |
S_SC_STU_WBL.WBL_CreditInd1; |
S_SC_STU_WBL.WBL_CreditInd2; |
S_SC_STU_WBL.WBL_CreditInd3; |
S_SC_STU_WBL.WBL_CreditInd4; |
S_SC_STU_WBL.WBL_CreditInd5; |
S_SC_STU_WBL.WBL_CreditInd6; |
S_SC_STU_WBL.WBL_CreditInd7; |
S_SC_STU_WBL.WBL_CreditInd8; |
S_SC_STU_WBL.WBL_CreditInd9; |
S_SC_STU_WBL.WBL_CreditInd10; |
S_SC_STU_WBL.WBL_HoursMetCCR; |
S_SC_STU_WBL.WBL_PaidInCCR; |
S_SC_STU_WBL.WBL_PaidInd1; |
S_SC_STU_WBL.WBL_PaidInd2; |
S_SC_STU_WBL.WBL_PaidInd3; |
S_SC_STU_WBL.WBL_PaidInd4; |
S_SC_STU_WBL.WBL_PaidInd5; |
S_SC_STU_WBL.WBL_PaidInd6; |
S_SC_STU_WBL.WBL_PaidInd7; |
S_SC_STU_WBL.WBL_PaidInd8; |
S_SC_STU_WBL.WBL_PaidInd9; |
S_SC_STU_WBL.WBL_PaidInd10; |
S_SC_STU_WBL.WBL_RelateInCCR; |
S_SC_STU_X.SEI_Status; |
S_SC_STU_CATE_X.CATE_SingleParentInd; |
S_SC_STU_CATE_X.CATE_DisplHomeMakerInd; |
S_SC_STU_CATE_X.CATE_ExceptionsCode; |
S_SC_STU_CATE_X.CATE_Units; |
S_SC_STU_CATE_X.CATE_Units2; |
S_SC_STU_WBL.WBL_CarCod1; |
S_SC_STU_WBL.WBL_CarCod2; |
S_SC_STU_WBL.WBL_CarCod3; |
S_SC_STU_WBL.WBL_CarCod4; |
S_SC_STU_WBL.WBL_CarCod5; |
S_SC_STU_WBL.WBL_CarCod6; |
S_SC_STU_X.IncludeInReporting; |
S_SC_STU_X.InstrSetting; |
S_SC_STU_X.KndrgrtnPrevPgm; |
S_SC_STU_X.NoShow_Reason; |
S_SC_STU_X.OralELA; |
S_SC_STU_X.OralMath; |
S_SC_STU_X.OralScience; |
S_SC_STU_X.OralSocStudies; |
S_SC_STU_X.ParentsMilitaryStatus; |
S_SC_STU_X.Tier; |
S_SC_STU_X.Universal_Screener; |
S_SC_STU_WBL.WBL_EvalScoreCCR; |
S_SC_STU_WBL.WBL_TypeCCR; |
S_SC_STU_EC_X.DaysServed_PerWeek; |
S_SC_STU_EC_X.EC_PriorClassType; |
S_SC_STU_EC_X.EC_PriorProvider; |
S_SC_STU_EC_X.EC_CarePriorToSchCode; |
S_SC_STU_EC_X.EC_ClassCurrCode; |
S_SC_STU_EC_X.EC_CountDownToKinderInd |
S_SC_STU_EC_X.EC_EarlyChildPlaceCode; |
S_SC_STU_EC_X.EC_FamilyIncRangeCode; |
S_SC_STU_EC_X.EC_FamilyLiteracySrvcs; |
S_SC_STU_EC_X.EC_yrsfamilylitsrvcs; |
S_SC_STU_EC_X.EC_HeadStartInd; |
S_SC_STU_EC_X.EC_LowBirthWeightInd; |
S_SC_STU_EC_X.EC_TuitionPayer; |
S_SC_STU_EC_X.EdLevel_MomFG; |
S_SC_STU_EC_X.YearsED_MomFG; |
S_SC_STU_ReadToSucceed_X.GCE_504; |
S_SC_STU_ReadToSucceed_X.AltAssessed_GCE; |
S_SC_STU_ReadToSucceed_X.Determination_Factor; |
S_SC_STU_ReadToSucceed_X.English_Learner_GCE; |
S_SC_STU_ReadToSucceed_X.IEP_GCE; |
S_SC_STU_ReadToSucceed_X.Invited; |
S_SC_STU_ReadToSucceed_X.PostAssessment; |
S_SC_STU_ReadToSucceed_X.PostAssessment_Score; |
S_SC_STU_ReadToSucceed_X.PreAssessment; |
S_SC_STU_ReadToSucceed_X.PreAssessment_Score; |
S_SC_STU_ReadToSucceed_X.PreviouslyRetained_GCE; |
S_SC_STU_ReadToSucceed_X.Proficiency_Level; |
S_SC_STU_ReadToSucceed_X.Promotion_Status; |
S_SC_STU_ReadToSucceed_X.ReadingPortfolio_GCE; |
S_SC_STU_ReadToSucceed_X.SummerReading_GCE; |
S_SC_STU_ReadToSucceed_X.Superintendent_GCE; |
S_SC_STU_X.ARP_HCY; |
S_SC_STU_X.Precode1; |
S_SC_STU_X.Precode2; |
S_SC_STU_X.Precode3; |
S_SC_STU_X.Precode4; |
S_SC_STU_X.Precode5; |
S_SC_STU_X.Precode6; |
S_SC_STU_X.Precode7; |
S_SC_STU_X.Precode8; |
S_SC_STU_X.G38PaperEla |
S_SC_STU_X.G38PaperMath |
S_SC_STU_X.G38PaperScience |
S_SC_STU_X.G38PaperSocStu |
S_SC_STU_X.EOCEPPaperEla |
S_SC_STU_X.EOCEPPaperMath |
S_SC_STU_X.EOCEPPaperScience |
S_SC_STU_X.EOCEPPaperSocStu; |
S_SC_STU_X.deafblindind; |
S_SC_STU_X.CustomELACde; |
S_SC_STU_X.CustomMathCde; |
S_SC_STU_X.CustomSciCde; |
S_SC_STU_X.CustomSocStuCde; |
S_SC_STU_X.CR_Accommodations; |
S_SC_STU_X.CR_Oral_Accomodation; |
S_SC_STU_X.dial_motr_subscalenum; |
S_SC_STU_X.dial_motr_subscaleper; |
S_SC_STU_X.dial_conc_subscalenum; |
S_SC_STU_X.dial_conc_subscaleper; |
S_SC_STU_X.dial_lang_subscalenum; |
S_SC_STU_X.dial_lang_subscaleper; |
S_SC_STU_X.dial_self_subscalenum; |
S_SC_STU_X.dial_self_subscaleper; |
S_SC_STU_X.dial_semot_subscalenum; |
S_SC_STU_X.dial_semot_subscaleper; |
S_SC_STU_X.ctso.membership1; |
S_SC_STU_X.ctso.membership2; |
S_SC_STU_X.NinthGradeCode; |
S_SC_STU_X.WBL_ExpOwner1; |
S_SC_STU_X.WBL_ExpOwner2; |
S_SC_STU_X.WBL_ExpOwner3; |
S_SC_STU_X.WBL_ExpOwner4; |
S_SC_STU_X.WBL_ExpOwner5; |
S_SC_STU_X.WBL_ExpOwner6; |
S_SC_STU_X.WBL_ExpOwner7; |
S_SC_STU_X.WBL_ExpOwner8; |
S_SC_STU_X.WBL_ExpOwner9; |
S_SC_STU_X.WBL_ExpOwner10; |
S_SC_STU_X.WBL_ExpOwnerCCR; |
S_SC_STU_PRV_X.Directory_OptOut; |
S_SC_STU_PRV_X.Military_OptOut; |
STUDENTS.Next_School; |
S_SC_STU_GRAD_WRKSHEET_X.Student_In_Denominator (indicatorName = 'Grad Rate Denominator') |
Take the value indicated. |
Take the value indicated |
When indicatorName = 'Certification Administration Location', then take the associated value from Cert_AdminYear. Assume 11/1/schoolyearvalue for 'FA' and 03/01/schoolyearvalue for 'SP'. |
efa.start_dt, eia.start_dt, ha.start_dt |
efa.stop_dt, eia.stop_dt, ha.stop_dt |
Home' AND 'Emergency 1' AND 'Emergency 2' |