Docstoc

EIAS Reports List - FAMIS Online

Document Sample
EIAS Reports List - FAMIS Online Powered By Docstoc
					      1                                                                                                        EIAS Student Data Canned Reports

   Job or WO            Job
    Number             Name       Job Description
                                  Attendance          No Aggregate File
                                  ADA - STUDENT ATTENDANCE: Includes 180 day % Present, ADA & ADM, and summer ADA and ADM
           70488 gqle             (DPS.GQ.F70488.Yyyyys.MCTEMP)

                                  Attendance by Grades PK-12; DPS.GQ.ATTEND.Yyyyy.MCTEMP

                                  Attendance for EOY includes Truancy #'s. Datafile. DPS.GQ.F70890*.Yyyyy (*=D for district totals; *=S for school
           70890 GQPY             totals)

                                  Career and Professional Academies

           71074 GQSE             Career and Professional Academies counts of Enrollment Datafile: DPS.GQ.F71074.YyyyyS.MCTEMP (duplicated)
                                   Career and Professional Academies counts of Membership Datafile: DPS.GQ.F71075.YyyyyS.MCTEMP
           71075   GQSE           (unduplicated)
           71015   GQSO           CAPE Enrollment by District, School and Academy
           71016   GQSP           Industry Certification Results by District, School, Industry Certification, and Grade Level
           71017   GQSQ           CAPE Funding Eligibility by District, School and Industry Certification
           71018   GQSR           CAPE Enrollment by District
           71081   GQSS           CAPE Enrollment by District, School, Grade Level
           71082   GQST           CAPE Eligible Industry Certification Results by District, School, Industry Certification and Grade Level
F71166             GQTE           Perkins Eligible Industry Certification Results by District, School, Industry Certification, and Grade Level
F71177             GOTH           List of Students of CAPE Eligible Industry Certification Results
                                  Choice Report by District by School with choice codes (Datafile = DPS.GQ.F70555.Yyyyys.D00) S. 5 only, the
           70555 GQLO             program deletes the PT VIRT (formerly FLVS/FRNCHS) column, as well as District 71.

                                  Educational Choice = F by grade, race, gender, lunch; Datafile: DPS.GQ.Yyyyy2.DOUBLEF (Request the 4
                   GQQU           separate files GR, R, Gen, FRL)

                                  Educational Choice = C datafile and detail info Datafile: DPS.GQ.F70825.Yyyyys.MCTEMP--DATAFILE;(Stu File)
70825/ 70799       GQSG           DPS.GQ.F70799.Yyyyy2.MCTEMP-- COUNTS

                                  SINI Counts by District by FRPL by Ed Choice = C Datefile: DPS.GQ.F71029.Yyyyys.MCTEMP (Has a parameter of
           71029 GQRS             either 1+ or 2+ SINI schools)


70698/ 70705/                     Choice Controlled Open Enrollment Demographics by District and School DPS.GQ.F70698.Yyyyy5.MCTEMP,
70706              GQNR           DPS.GQ.F70705.Yyyyy5.MCTEMP, DPS.GQ.F70706.Yyyyy5.MCTEMP

                                  Completers/Diplomas                  Aggregate File



Note: Completers build program collects information from the database, using tables STUDENT and END Year STATUS, and creates the completers aggregate
file. The build program counts every diploma and certificate type that represents completion of school into one of 7 categories: 1)standard high school diploma,
grades 9-12; 2)certificate of completion, grades 9-12; 3)special diploma, grades 9-12; 4)special certificate, grades 9-12; 5)adult diplomas of certificates, grades
30 & 31; 6)GED, grades 9-12; or 7)GED, adult under 20. This program collects grades 9-12, 30 & 31. It excludes districts 70, 71, 76, and 77. It also excludes
schools 3518, 3818, 9996, 9997, 9998, and 9999. GEAO, GEAP, GEBD, & GECJ select counts from the completers aggregate file. Exceptions/restrictions are
noted by each job.

                                  Diploma/certificate report by grade/race/gender by school (Counts all types of diplomas and certificates, but not GEDs, for 9-12.
           62268 geao             Excludes all adult types.)


                                  Diploma/certificate report by grade/race/gender by district (Counts all types of diplomas and certifictes, but not
           62269 geap             GEDs, for 9-12. Excludes all adult types.) Datafile = DPS.GE.F62269O.Yyyyy.D00.MCTEMP


           62308 gebd             Graduates of standard diplomas by race/gender by district (Use for Brief) (Counts standard high school diplomas for 9-12.)
     Updated 5-10-11
     K:\Limited4\EIAS_Data_Requests\Report List                                                                                   1
    2                                                                                                        EIAS Student Data Canned Reports

  Job or WO        Job
   Number         Name      Job Description

                            Graduates (Secondary & Adult) of Standard diplomas by race/gender by district--Use for Brief (Creates datafile
                            DPS.GE.F70688.Y7085) (All districts 1-79. Excludes schools 3518, 3818, 9996, 9997, 9998, 9999. Collects grades 9-12, 30 & 31.
        70688 gehu          Uses Student and EOY & MSID Tables.)


                            Diploma/certificate report including W45 by district (Creates Data File: DPS.GQ.F70666.Yyyyys)-- Request
        70666               DPS.WORKORDER.LIB(F70666)


                            Diploma/certificate/ged totals by grade/race/gender by school ( All types of diplomas, certificates, and GEDS for 9-12 excluding
                            all adult types such as W45) (Use for Brief) Note: Also creates a data file: DPS.GE.F62488.Yxxxx5.D00.MCTEMP Also known as School
        62488 gecj          District Data.



                            Diploma/certificate/ged totals grade/race (Use for Brief) Creates DPS.GE.F70687.YYYYYs (selects all districts from 1-76.
        70687 geht          Excludes 3518, 3818, 9996, 9997, 9998, 9999. All diploma, certificate, and GED types for 9-12 only. Uses Student, School and EOY tables.)


                          Post-secondary plans by district (Use for Brief) Note: grades 9-12 report--9-12 diploma and 9-12 certificate Datafile:
70584/62316     gehp/gebl DPS.GE.F62316d.Yyyyy.MCTEMP

                            GRADUATION OPTION by Schl by Gr: In TSO, select the following: Z--Dialog Requests; 8) GQ; 1)Student
                            Database Edit Status Reports; 9) GQKW--Download Dataset--Graduation Option Count. Data set name:
        70482 gqkw          DPS.GQ.F70482

                            Graduation Source Data--Use for Brief. Datafiles DPS.GE.F70762.Yyyyy.Www.MCTEMP. Has each dip-cert file by
                            district by race and gender and by 9-12 and 30-31. DPS.GE.WOECBS.Yyyyy.GP has all diploma/cert with state
        70762 WOECBS        totals.

        70754 EOYGRAD GED Exit Option by Race and Gender--(Job Number EOYGRADYyyyy5D or Yyyyy5R)

                            Course Enrollment              No Aggregate File
                            Dual Enrollment by Codes (Creates Data file DPS.GQ.F70677.YyyyyS.MCTEMP) Number of Dual Enrollment
        70677 GQMM          courses taken by school/district.

                            Number/Percent of students taking IB and AP courses by grade, by race, by gender. Rarely Used


                            Number/Percent students participating in Dual Enrollment (codes A, B, C, or E), by race, by gender. Rarely Used

        70689 gqmu          AP High School Course Enroll, DPS.GQ.F70689.Yyyyy.Data.Mctemp

                            Adv Crs Enrollment by School for Programs: AICE, AP, DE, IB (Unduplicated Counts by Dist, by Schl, by Student)
                            Surveys 2 and 3 totals.

                            PE Course by school, by grade with % (Report: DPS.GQ.F70685.Yyyyys - Datafiles: DPS.GQ.F70686.Yyyyys--
                            Grades vertical; (Seldom used:Datafile: DPS.GQ.F70856.Yyyyys--Grades horizontal) (convert % col, divide by
        70686 GQMS          100) (Available for district request -CICC - F70685)

        71095 GQSK          PE #Students w/ PE Waivers - Datafile: DPS.GQ.F71095.Yyyyy5

        70844 GQQL          Reading Intervention Count of Students (available to districts through CICS) DPS.GQ.F70844.Yyyyys

        70989 GQRG          Math Remediation Count of Students (available to districts through CICS) DPS.GQ.F70989.Yyyyys

        62412               Student Course Transcript Enrollment by Dist (Datafile: DPS.G6.F62412.Yyyyys.File5.MCTEMP)

        70814 GQMY          Course Enrollments by District by Course (Creates datafile DPS.GQ.F70814.Yyyyys)
    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                                                    2
  3                                                                                                         EIAS Student Data Canned Reports

Job or WO        Job
 Number         Name    Job Description

                        Course Enrollment, Grades 9-12

      70726 gqmz        Course Enrollment Grades 6-9 (Datafile: DPS.GQ.F70726.Yyyyys)

                        Course Enrollment Grades 6-9, Unduplicated list of students Grades 9-12. Stored as
              gqpr      DPS.WORKORDR.LIB(GQPR); Datafile DPS.GQPR.Yyyyys.DATA.MCTEMP

      70923 gqqj        Courses Meeting Algebra I Requirements for Gr 6-8 (Creates datafile DPS.GQ.F70923.Yyyyys)

                        PE Classes by school by Grade Groupings (R:\Tsung\Program\Program\PE\PE_teacher course.sas) This has been
                        used for a Senate report on PE.

              GQMV      FACTS Middle and High School Course List


                        Current Year Data                 Aggregate File
                        Current year survey data by district (this includes membership by race, by grade; lunch status information; ESE
                        membership; ELL status) DPS.GE.F62260.D99.Yyyyys.MCTEMP; Datafile =
      62260 geau        DPS.GE.F62260D.D00.Yyyyys.MCTEMP ELL report selects students with courses.

                        Current year survey data by school (same as geau but by school) Do not put into Excel
      62261 geav        DPS.GE.F62261.Yyyyys.Ddd.MCTEMP (Save Report)

                        Current year survey data by CHARTER school only (same as geau but by school) (Charter00) put state totals in
                        excel. Submit parts 1 & 2 both @ the same time for over the weekend. Datafiles:
                        DPS.GE.F62261D1.CHAR.Yyyyys.D00.MCTEMP (holds districts 1-18)
      62261 char        DPS.GE.F62261D2.CHAR.Yyyyys.D00.MCTEMP (holds districts 39 up including state totals).

                        Discipline (See Safe Schools)            Aggregate File
                        Discipline by grade/race/gender by school (Also creates 2 data files:
                        DPS.GE.F62270.DATA1.Yxxxx5.D00.MCTEMP & DPS.GE.F62270.DATA2.Yxxxx5.D00.MCTEMP) Note: If you
                        experience any problems in retrieving this data file, you may need to remind EDS that because this data file is so large we have asked to have
                        it divided into two parts. For example, DATA 1 will contain Alachua--Levy; Data2 Will contain Liberty--UF Lab School with State Totals at the
      62270 geaq        end.


                        Discipline by grade/race/gender by district (data file: DPS.GE.F62271.DATA1.Yyyyys.D00.MCTEMP) GEAR is a
                        report produced from the discipline aggregate file. The aggregate counts all students by disciplinary action, so a
                        student with different types of actions will be counted more than once per school; that is the duplicated factor of the
                        report. However, it only counts the student once for each type of action; that is the unduplicated factor of the report.
                        There is no way for GEAR to sort out the aggregates and get a count of just the students involved. This is also
      62271 gear        calculated the same for GEAQ (by school).
                        Number of expelled by race and sex by district - GEBK reads the discipline aggregate file, which uses the
      62315 gebk        Disciplinary/Referral Action Code from the Discipline Format to aggregate counts by code, then grade, and then

      62673 gecv        Suspended out-of-school by race/gender by district

      62674 gecw        Suspended in-school by race/gender by district

      71111             Total Occurrences of OSS and ISS by Sch (requested by Title 1 ofc annually for Tier 1&II schs)

                        Dropouts                          Aggregate File

      62264 GEAK        Dropouts by grade/race/gender by school (Also creates a data file: DPS.GE.F62264.Yxxxx5.D00.MCTEMP)



 Updated 5-10-11
 K:\Limited4\EIAS_Data_Requests\Report List                                                                                      3
     4                                                                                            EIAS Student Data Canned Reports

  Job or WO          Job
   Number           Name      Job Description
                              Dropouts by grade/race/gender by district (See GEAK datafile. Compare totals on two reports.) (Use GEAK
          62265 GEAL          District pg)

          62309 GEBE          Dropouts by race/gender by district

          62490 GECL          Dropout by grade by school (Datafile: DPS.GE.F62490D.Yyyyy.D00.MCTEMP)

          62671 GECT          Dropouts grade 9-12 by race/gender by district (Becky uses). Add district numbers to report.

          62310 GEBF          Dropouts by grade by district

          62487 GECI          Dropouts by race and gender by school--See GEAK

                              Teen Parent Program Number/Percent of students participating.

 70995, 70996,
 70997, 71165 GQRJ            Dropout Exit Survey information - reasons (70995 & 70996), influences (70997), actions taken (71165).

                              ELL (Contact ELL Office) formerly LEP



GE jobs are aggregated. GQ jobs are not. GEBN and GEAU should have matching totals. GQMW will be different. GEBN and GEAU (Current
Year Data) both use the membership aggregate. GQMW reads the database. The membership aggregate only selects students that have
courses where the district of enrollment matches the district of instruction. GQMW selects students but does not check courses at all. Reports
based on Student Course records are not available for Survey 5.


                              ELL Codes by Race/Gender/School (Produces 4 data files: LF, LP, LY, LY&LP) DPS.GQ.F71152.Yyyyy.McTemp
          71152 GQTC          (District requestable report F71153/71154)

                              English Language Learners Students by Grade by District, (DPS.GQ.F70691.YyyyyS.MCTEMP) Report selects all
          70691 gqmw          students with ELL codes. Does not match on course.

                              ELL by Code (Datafile: DPS.GQ.F70803.D00.Yyyyys.mctemp ) (Formerly GEBP) (Also on CICC for district online
          70803 GQRB          request) Combined GQQE with GQRB. 70803D=Data 70803R=Report

          70899 GQQA          Language Codes of ELL Students by District. Data file: DPS.GQ.F70899.YyyyyS. MCTEMP

          70900 GQQB          County of Birth of ELL Students by District. Data file: DPS.GQ.F70900.YyyyyS.MCTEMP



                              End of Year               Aggregate File

          62262 geae          EOY survey data by school: includes discipline data, graduate data, non-promotions data, dropout data

          62263 geaj          EOY survey data by district: includes discipline data, graduate data, non-promotion data, dropout data

                              For Withdrawal Codes See Withdrawal Codes Section

                              Home Economics/Industrial Technology By District (Creates Data File:
                 gqmn         DPS.K9.SNGL.SEX.HMEC.DIST.Yyyyys.MCTEMP)

                              Home Economics/Industrial Technology By School (Creates Data File:
                 gqmo         DPS.K9.SNGL.SEX.HMEC.SCHL.Yyyyys.MCTEMP)
     Updated 5-10-11
     K:\Limited4\EIAS_Data_Requests\Report List                                                                    4
    5                                                                                              EIAS Student Data Canned Reports

  Job or WO         Job
   Number          Name    Job Description

                 gqmp      Physical Education By District (Creates Data File: DPS.K9.SNGL.SEX.PE.DIST.Yyyyys.MCTEMP)

                 gqmq      Physical Education BySchool (Creates Data File: DPS.K9.SNGL.SEX.PE.SCHL.Yyyyys.MCTEMP)

         70664 gqmf        Alg I Enroll, DPS.GQ.F70664.Yyyyys

                           AP, IB, AICE, DE, Level III, Honors Datafile: DPS.GQ.F70667.Yyyyys.MCTEMP--Includes file for Race totals--use
         70667 gqmx        with GQNT, GQNU, GQNV, & GQNW (rpts easier to use)

70709, 70710     gqnt      AP, IB, AICE Enrollment Only--Report & Datafile Available--Use Race numbers from GQMX

70711, 70712     gqnu      Dual Enrollment Only--Report & Datafile Available--Use Race numbers from GQMX

70713, 70714     gqnv      Honors Only--Report & Datafile Available--Use Race numbers from GQMX

70715, 70716     gqnw      Level 3 Only--Report & Datafile Available--Use Race numbers from GQMX

                           Exceptional Student                Aggregate File

                           ESE membership by program by race/gender by district--includes LEP count (Datafile created for Becky-
         63360 gexd        DPS.GE.F63360D.Yyyyys.Ddd.mctemp) Save in Text form

         63361 gexs        ESE membership by program by race/gender by school--includes LEP count. Save in Text form

         70164 geep        ESE membership by primary exceptionality by district by race

         63495             Students birth thru three by primary exceptionality with state totals

         61135 G6KA        ESE students exiting system by exceptionality, exit reason, age 14+

         61767 G6KB        ESE membership by age/all exceptionalities by district - Duplicated

         61768 G6KC        ESE students exiting the system by district, exceptionality & basis of exit, age 14+

         61134             ESE students by placement setting

         70001 G6JB        ESE students by placement setting, ages 6-21

        7001A G6JC         ESE students by placement setting & gender (Unduplicated)

         70004 G6JF        ESE students by placement setting, ages 3-5

         70006 G6JE        ESE students by placement setting & race (Unduplicated)

         70008 G6KF        ESE students exiting by Exceptionality, Reason & Race

         62982             ESE dismissals by district by age by exceptionality

                           Withdrawal codes for ESE students (excluding gifted)

         63497             Section 504 eligibility by district/race/grade

         63355 G6LD        ESE membership by age/all exceptionalities by school/district - Unduplicated

         63075 G6LB        ESE membership by race and ethnicity, Primary Exceptionality (Unduplicated)
    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                                    5
    6                                                                                            EIAS Student Data Canned Reports

  Job or WO         Job
   Number          Name    Job Description

         63076             Child Count by Race, Primary Exceptionality (Duplicated)

         62894 G6LE        ESE membership by age/all exceptionalities by district - Duplicated

         62987             Membership by Primary Exceptionality, School (Unduplicated)

         62581 G6LA        ESE membership by age 3 and above

62581B                     Child Count by Primary Exceptionality (including gifted)

         62975 g6lf        Child Count by Grade and PE, Incl. Gifted (Undup.) (Data file: DPS.G6.F62975D.Yyyyys.MCTEMP )

         63308             Child Count by Grade and Primary Exceptionality (Duplicated)

                 G6LJ,
                 G6LK,
                 G6LL,
                 G6MA      ESE FTE -- See FTE Section

         63150             ESE membership by R/S/G by District

         71003 g6nk        Number & percent of gifted students by LEP. Formerly WOD747A

         71004 g6nl        Number & percent of PK-12 students by LEP. Formerly WOD747B .

         71005 g6nm        Number & percent of gifted student by race/ethnic category. Formerly WOD837A.

         71006 g6nn        Number & percent of PK-12 students by free/reduced lunch. Formerly WOD837B.

         71007 g6no        Number & percent of PK-12 students by race/ethnic category. Formerly WOD837C .


         71008 g6np        Number & percent of gifted students by free/reduced lunch. Formerly WOD837D .

                           Number and Percent of students in Free and Reduced Lunch Programs by School.
         70981 g6rb        (DPS.GQ.F70981.YyyyyS.mctemp )

                           ESE Membership by School with Percentages. (Job=DPS.GQ.EDS.WORKORDR(GQQT); DATA
                           FILE=DPS.GQ.F70858.Yyyyys; DATA FILE LAYOUT = DPS.DISTRICT.FORMAT.Yyyyy(F70858); Report=
         70858 gqqt        DPS.GQ.F70859.Yyyyy.) Ron Burton (Teacher Recruitment) request once a yr

                           IDEA Educational Environments by Age by District DPS.WORKORDR.LIB(GQRR). DPS.GQ.F71013.Yyyyy2 – ages
                           3-5
71013, 71014     gqrr      DPS.GQ.F71014.Yyyyy2 – ages 6-21

                           ESE Students by Special Diploma by Age DPS.WORKORDR.LIB(EDR 40108) Datafile--
                           DPS.GQ.EDR401.MCTEMP. Slight modifications needed each year.

                           ESE Students by Standard Diploma by Age DPS.WORKORDR.LIB(EDR 40208) Datafile--
                           DPS.GQ.EDR402.MCTEMP Slight Modifications needed each year.

                           ESE Students by Standard Diploma by Exceptionality DPS.WORKORDR.LIB(EDR 40308) Datafile--
                           DPS.GQ.EDR403.MCTEMP Slight modifications needed each year.


    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                                  6
    7                                                                                           EIAS Student Data Canned Reports

  Job or WO         Job
   Number          Name     Job Description
WO# H453                    Number of graduates and graduation rate by district and ESE program. Includes the number in the adjusted cohort,
(H453D, H453E,              the number graduating and the graduation rate.
H453H)

WO# H453                    Gifted Only: Number of graduates and graduation rate by district. Includes the number in the adjusted cohort, the
(H453D, H453E,              number graduating and the graduation rate.
H453H)


WO# H453                    Gifted Only: The number of dropouts by district. Includes the 9-12 membership, the number of dropouts and the
(H453D, H453E,              dropout rate.
H453H)

                            ESE Audit Report, Job = exg6byag; File = DPS.G6.F62718.AG.Yyyyy2
                            Free/Reduced Lunch see Lunch--Free/Reduced

                            FTE
                                        G6 programs run against the data base, not an aggregate file.


          70988 GQRF        Bonus FTE Earned, EOY Dataset: End of Year Status APIBAICE FTE YYYY (DPS.GQ.F70988.Yyyyys.MCTEMP)

                            Dual Enrollment FTE. This job runs only after FTE has been nulled. It is an EA job set up for the Funding Office.
F71036            EADT      Uses OFFR district numbers.

                            Dual Enrollment FTE by district [DPS.WORKORDR.LIB(DUALABCE)] Dataset:
DUALABCE          GQTF      DPS.GQ.DUALABCE.FTE.Yyyyys.MCTEMP. Must divide by 100 to get proper amount.


                GQTN
                (formerly   District membership and fte by grade and program; (This report used by ESE Office.) Save as Text file . Usually
          62258 GEAS)       not stored on Z drive.


                            ESE FTE for FEFP 111-255 by Exceptionality including Gifted (includes students through age 19)--See G6LJ,
WOF435                      G6LK, & G6LL for data files

                            ESE FTE: Gifted by grade (Gr 9-12) for FEFP 113 (QMF Report) Reference for Requesting:
                  GQQC      DPS.WORKORDR.LIB(GQQC)



                            UFTE Generated by Students in Cost Factor Programs 111-113 and 254-255 by District and Primary Exceptionality
          71030 G6LJ        DPS.G6.F71030.Yyyyys.Ddd.MCTEMP



                            ESE Students in Cost Factor Programs 111-113 and 254-255 by District and Exceptionality (Duplicated)
          71031 G6LK        DPS.G6.F71031.Yyyyys.Ddd.MCTEMP

                            ESE Students in Cost Factor Programs 111-113 and 254-255 by District and Exceptionality (Unduplicated)
          71032 G6LL        DPS.G6.F71032.Yyyyys.Ddd.MCTEMP

71103R,
71104R,                     ESE FTE PK Ages 0-2 by FEFP Category. Courtesy verification report (71103R), formatted report with headings
71105D            G6MA      (71104R), formatted data file (7115D). Runs directly against the database.

          70847             Grades 6-8, FTE Earned, taking Algebra courses Datafile: DPS.GQ.F70847.Yyyyys (EDR241A)
    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                                    7
     8                                                                                            EIAS Student Data Canned Reports

  Job or WO          Job
   Number           Name      Job Description

          70833 GQQN          Grades 6-8, FTE Earned, taking 9-12 grade courses Datafile: DPS.GQ.F70833.Yyyyys (EDR#241)

F71090           GQNK         Null and Pending FTE. DPS.GQ.F71090.Yyyyys.MCTEMP. Stored on K drive.

                              Scholarship FTE Counts

                              Teen Parent Program FTE by FEFP Category and Grade Level.

                              Virtual FTE Counts

          70852 GQQQ          Virtual FTE: Florida Virtual School PE Courses Datafile: DPS.GQ.F70852.YyyyyS (EDR241B)

          70853 GQQR          Virtual FTE: Florida Virtual Schools all 9-12 courses Datafile: DPS.GQ.F70853.YYYYYs (edr241c)

                              Vocational FTE: 3 sets of data are generated (FEFP 300-Gr 9-12 {DPS.GQ.EDS.WORKORDR(FTE#274F} , 7-8
                              {DPS.GQ.EDS.WORKORDR(FTE#274D}, ESE {DPS.GQ.EDS.WORKORDR(FTE#274E)})
                              DPS.GQ.EDR274?.FTE.EARNED.Yyyyy--Tara Goodman requests these once a year.

                              Homeless

                              Number of Homeless Students by district for current & previous years. DPS.GQ.F71025.TEMP = Report;
          71025 GQRC          DPS.GQ.F71025D.TEMP = datafile

                              Hurricane Counts by District--Data set DPS.GQ.HURICNT.Y05062

                              Immunization            No Aggregate File



                               KG Annual Rpt of Non-Compliance Compulsory Immunization by School or District (Reports: 1 = GQHH School or
                 gqhh &       2 GQHHD District) Note-online school level report available F61994 and F71064 Datafile:
61994/71064      gqhhD        DPS.GQ.F61994.YyyyyS = Dist; )
                              7th Gr Annual Rpt of Non-Compliance Compulsory Immunization by School or District (Reports 3= GQHI School or
                 gqhi &       4 GQHID District) Note-online school level report available F63359 and F71058 Datafile:
63359/71058      gqhiD        DPS.GQ.F63359.YyyyyS = Dist; )

                              LEP see ELL

                              Lunch--Free/Reduced              Aggregate File

These reports are based on the survey 2,3 aggregate files which cannot easily or readily be modified to support survey 5 without undermining the
presumptive logic of the existence of a student course record being in existence, as a basis of a “membership” count. (GEFE, GEFF, GEXT,
GEXW)

          62801 gefe          free/reduced lunches by school (Also creates a data file: DPS. GE. GEFE.Yyyyys.D00.MCTEMP)

          62802 geff          free/reduced lunches by district (cut at the bottom - textcol)


71085 (formerly-              free/reduced lunch by district and grade (datafile: DPS.GE.F71085.Yyyyys.D00.DATA.MCTEMP); select "B" for
70029)           gext         Both Print & Data file ! (Note: This report cannot run for years prior to 0001. Use GEAU for 9900 and prior years.)

                              Free/Reduced lunch by grade KG-5 by school--Request data file from EDS:
                              DPS.GQ.WRK.FREE.REDUC.NEW.Y0405 [K. White has been running this. Created in
                              DPS.WORKORDR.LIB(FREEREDL)]



     Updated 5-10-11
     K:\Limited4\EIAS_Data_Requests\Report List                                                                     8
   9                                                                                            EIAS Student Data Canned Reports

 Job or WO        Job
  Number         Name     Job Description
                          free/reduced lunch by school by grade by race and gender (GE3206) (Datafile
       70796 GEXW         DPS.GE.F70796D.Yyyyy.DATA.MCTEMP)


                          Membership           Aggregate File
                          Membership by grade by school (Does not include 3518,3818, 9998, 9999) Datafile:
       62257 geaf         DPS.GE.D62257.D00yyyys.MCTEMP

       62255 geag         Membership by grade by district (Does not include 3518, 3818, 9998, 9999)


       62256 geah         Membership by grade/race/sex by school (Also creates a data file: DPS.GE.F62256.Yyyyys.D00.MCTEMP)

                          District membership by grade, race, sex (Also creates data file DPS.GE.D62254.D00yyyys.MCTEMP) This datafile
                          must be manipulated to use. Save Flatfile in Notepad: Go directly to EXCEL, click "Open", select file, change to Fixed
       62254 geai         Width . (Save As excel file)

       62291 geax         Number and percent of membership by race by district. Datafile: DPS.GE.F62291D.Yyyyys.MCTEMP

       62303 gebm         Membership by race by school (Get data from GEAH)

       62486 gech         School membership by race and sex DPS.GE.D62486.Dddyyyys.mctemp (Get data from GEAH)

       62803 gefg         Membership and percentage by race and sex by school. Datafile: DPS.GE.F62803D.Yyyyys.MCTEMP

             GQNM
             (formerly    Charter Schools Membership by grade (Note: Membership for PK = PK ESE only; all other grades = total
       70353 gehn)        membership - this was created for Janet Burns.) (Dataset DPS.GQ.F70353.YyyyyS)

                          Membership by school by grade--COUNT based on records, not on student course; Datafile =
       70883 GQRE         DPS.GQ.F70883.Yyyyys.MCTEMP Must make special request to run overnight.

                          Comparison of Race-Ethnicity between years DPS.GQ.F71072.Y09101.DATAFILE
       71072 GQSD         DPS.GQ.EDS.WORKORDR(GQSD) Note: check the year and survey running

                          Migrant

                          Migrant Data Count File: DPS.GQ.MIGRANT.COUNT.Yyyyys (aggregate count, by district, with state total. Have 2-
                          3 districts verify Category 1 and Category 2 migrants to verify software program selection criteria)

                          Military Students
F71140/F71141 GQSZ        Military Family Students DSP.GQ.F71140 (data file) F71141 (report file) CICC and TSO requestable

                          Military Students count (Sean ran this report in the past)

                          MSID
              g4au        Number of public schools by type

                          Postsecondary (See Completers)

                          Prekindergarten                 No Aggregate File
                          Program Participation Prior to Kindergarten by code. DATA FILE: DPS.GE.F70634.Yyyyys Obsolete beginning
       70634 gehr         0910.

                          Promotion Status              Aggregate File

   Updated 5-10-11
   K:\Limited4\EIAS_Data_Requests\Report List                                                                     9
  10                                                                                                     EIAS Student Data Canned Reports

Job or WO        Job
 Number         Name      Job Description
                          non-promotions by grade/race/gender by school (Also creates a data file: DPS.GE.F62266.Yxxxx5.D00.MCTEMP)
                          (GEAM uses the Non-Promotions aggregate based on District of Instruction. Uses Student Table and EOY Table.
       62266 geam         Numbers will never match GQNL (previously GEXV).)

       62267 gean         Non-promotions by grade/race/gender by district (See GEAM datafile. Compare totals on two reports.)


                          Not promoted/next higher grade by district. The non-promotions aggregate file collects all students from the Student
       62306 gebb         End of Year Status table with a Promotion Status of R (Retained in same grade at the end of the school year).

       62307 gebc         Not promoted/next higher grade by race by district

       62489 geck         Non-promotions by race and gender--Use GEAM/GEAN

                          Promotion codes by district by grade with state totals (Creates Data File: DPS.GQ.F70645.Y####S.MCTEMP )
                          (Logic: matches Student Table and EOY Status Table based on District of Enrollment. Gets information directly from the
                          database. ) File Layout DPS.DISTRICT.FORMAT.Y0809(F70645). This is not an aggregate. It is pulled from the EOY Status
             GQNL
             (previously table.
       70645 GEXV)


                          Promotion codes by school by grade with state totals In TSO select: Z; 4, 1(Creates Data File:
       70719 gehv         DPS.GE.F70719.YyyyyS ) (Logic is different. Data Uses EOY Status Table only. Totals may not equal those on other reports.)

                          3rd Grade Promotions: Good Cause Exemptions by District and Type (creates data file
                          DPS.GQ.F70670.Yyyyy5.GR03.MCTEMP) Run before Survey closes. This is not an aggregate. It is pulled from
       70663 gqme         the EOY Status table

             GQNN
             (previously Promotion/Retention Counts for GR KG students by District & Race/Ethnic (creates Data File:
       70659 gehs)       DPS.GQ.F70660.Yyyyy5.GRKG) Run before Survey closes

                          NCLB SPARs-- Z:\Publications & Reports\Reports\NCLB\YYYY-YY NCLB SPAR\District and State Spreadsheets
                          (School and District-level)

                          Safe Schools              No Aggregate File
                          SESIR incidents with Incident Descriptions (Creates Report File DPS.GQ.F62865.Yyyyys.MCTEMP; Datafile =
       62865 GQLQ         DPS.GQ.F62865d.YyyyyS.MCTEMP) Only SESIR incidents.
                          SESIR incidents by Discipline/Referral Action (TSO) (To download Flatfile use ud command: ex. 7ud) Based on
       70553 GQLP         students who have matching entries in SESIR and SDRA and have a discipline action code of A,C,I,O,E,U,S,H,OR F.


             (gehk
             renamed)
       70802 GQQY         SESIR Incidents by Weapon Descriptions by School Datafile: DPS.GQ.F70802.Yyyyys


       70824 GQQZ         Incidents of Crime and Violence by type by school, by district. (DATAFILE = DPS.GQ.F70824.YyyyyS.MCTEMP)

                          Weapon Description (F, H, R) by School (Datafile: DPS.GQ.F71071.Yyyyys) Available for Districts to request
       71071 GQSC         F71070.

       71177 GQTG         Number of Incidents of Bullying & Harassment. DPS.GQ.F71177.Yyyyys. Also avail. CICC menu.

                          Unsubstantiated Bullying & Unsubstantiated Harassment Incident Basis Categories. DPS.GQ.F71174.Yyyyys. Also
       71174 GQTI         avail CICC menu.

 Updated 5-10-11
 K:\Limited4\EIAS_Data_Requests\Report List                                                                                  10
    11                                                                                         EIAS Student Data Canned Reports

  Job or WO          Job
   Number           Name   Job Description

          71181 GQTJ       Bullying & Harassment Incident Basis Categories. DPS.GQ.F71181.Yyyyys. Also avail. CICC menu.

                           Bully Related Only- Incidents that are Bullying-Related by Disciplinary/Referral Action (modeled after GQLP)
B70553            GQLPB    DPS.GQ.B70553D.Yyyyys B70553D for data file, B70553 for report.

                           Teacher Data from Teacher Course
                           Highly Qualified Teachers

                           Number/Percent of Teachers Teaching In-Field

                           Number/Percent of Teachers Teaching Out-of-Field

          70717            # Teachers by Certification/Licensure by Dist

                           Title I SES
          70924 GQQK       Title I SES Datafile=DPS.GQ.F70924? ?=D (DATA); =R (Report).Yyyyys

                  gqnq     Title I SES Demographic Report by Dist & School

                           Transportation
F70092            EDABD    SINGLE DISTRICT DETAIL REPORT (DYNAMIC)

                           SINGLE DISTRICT SUMMARY OF TRANS W/F70054 (DYNAMIC). Note: F70054 is the data file
F63499            EDADD    (DPS.ED.F70054.Y0910.ALL)

F70092            EDAB     ALL DISTRICTS DETAIL & STATE REPORT (DYNAMIC)

F63499            EDAD     ALL DISTRICTS & STATE SUMMARY OF TRANS W/F70054 (DYNAMIC)

F63498            EDACD    DISTRICT FEFP PRIOR YEAR AMENDMENTS (DYNAMIC)

F63498            EDAC     STATE FEFP PRIOR YEAR AMENDMENTS (DYNAMIC)

F60533            EDAE     SUMMARY OF TRANSPORTED LESS THAN 2 MILES

F63504            EDAF     HAZARDOUS WALKING REPORT (DYNAMIC)

                           TRANSPORTATION FTE COMPARISON (F70695-96, F70755-56)
FXXXXX            EDAH     (OPTION 9 IS DEPENDENT ON AGGREGATE TABLES) (DYNAMIC)

F70092F           EDABDF   INGLE DISTRICT DETAIL REPORT (STATIC/FROZEN)

F63499F           EDADDF   SINGLE DISTRICT SUMMARY OF TRANS W/F70054 (STATIC/FROZEN)

F70092F           EDABF    ALL DISTRICTS DETAIL & STATE REPORT (STATIC/FROZEN)

F63499F           EDADF    ALL DISTRICTS & STATE SUMMARY OF TRANS W/F70054 (STATIC/FROZEN)

F60533F           EDAEF    SUMMARY OF TRANSPORTED LESS THAN 2 MILES (STATIC/FROZEN SUPPLEMENTAL REPORTING)

F63504F           EDAFF    HAZARDOUS WALKING REPORT (STATIC/FROZEN SUPPLEMENTAL REPORTING)

                           MEMBERSHIP CATEGORY CODE 'A' BUS AND STUDENT
F70805-06                  DATA DPS.ED.F70805.YYEARSURVEY.MCTEMP (DYNAMIC REPORTS)

    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                                  11
    12                                                                              EIAS Student Data Canned Reports

  Job or WO         Job
   Number          Name    Job Description
                           VEHICLE CATEGORY 'B' STUDENT COUNTS
F70807-08                  DATA DPS.ED.F70807.YYEARSURVEY.MCTEMP (DYNAMIC REPORTS)

                           STUDENTS ASSIGNED TO BUS BY DISTRICT
F70809-10                  DATA DPS.ED.F70809.YYEARSURVEY.MCTEMP (DYNAMIC REPORTS)

                           Virtual Education
F71149 &
F71150          GQTB       Virtual Instruction Program Information by Provider

F71097 &
F71098          GQSL       Student Eligibility. DPS.GQ.F71097.Yyyyys.MCTEMP and DPS.GQ.F71098.Yyyyys.MCTEMP

                           Withdrawal Codes
           70676 gqml      Withdrawal Codes, DPS.GQ.F70676.Yyyyys.GRPK12.mctemp




    Updated 5-10-11
    K:\Limited4\EIAS_Data_Requests\Report List                                                     12
STAFF DATA REPORTS FOR REQUEST (updated October 2009)
NWRDC TSO ACCOUNT MENU
Staff Assigned - Teresa R. Sancho


Job    Job                                                                                                                      Data             Date         Report      Data
Number Name       Job Description                                                                                              Source          Available       Type      Status

                  Reports specific to "Staff Counts":
                  Full-time and part-time staff by race and gender [EEO-5 Report] (Also report is requestable at district
 07269    GABC*   level.)                                                                                                   Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 07340    GABD*   New hires by race and gender                                                                              Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 07272    GABF    Staff by race and gender - by major job category                                                          Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 60682    GABQ*   Staff terminations by category by reason                                                                  Staff Demo File      Surv 5       Canned   Point-in-time

 61299    GABX*   Instructional staff by category by race and gender (Used to create the Staff Brief)                       Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 61298    GACA    Administrative staff by category by race and gender (Used to create the Staff Brief)                      Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 61302    GACB    Full time staff by category by race and gender (Used to create the Staff Brief)                           Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 61303    GACC    Support staff by category by race and gender (Used to create the Staff Brief)                             Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62130    GACH    Staff by Race and Gender per EEO Line Number                                                              Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62200    GACI    Total FT and PT personnel by district and school                                                          Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63007    GACJ*   Total FT teachers and instructional staff by district and school                                          Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63011    GACN    FT staff by category - teachers/administrators/instructional/support staff                                Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63013    GACP    Full-time staff (admin, instruc, support) with percents                                                   Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63014    GACR    Staff by Race and Gender per Job Code                                                                     Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63019    GACX    Staff by Degree Earned Levels, number and percent                                                         Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62749    GADJ    Average age by job category (admin, instruc, classroom tchrs, support)                                    Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62753    GADL    Staff by age and job category (admin, instruc, classroom tchrs, support)                                  Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62754    GADM    Staff by age, race and job category (admin, instruc, classroom tchrs, support)                            Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62755    GADN    Staff by age, gender and job category (admin, instruc, classroom tchrs, support)                          Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62757    GADO    Full-time and part-time staff by job category [admin/instruc/teachers/support]                            Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 62758    GADP    Full-time staff by race, gender and job category [admin/instruc/teachers/support]                         Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 63021    GADY    Staff terminations by reason by job category [DB Admin/SB Admin/Cls Teachers/Other Instruc]               Staff Demo File      Surv 5       Canned   Point-in-time

63117A    GAEA    Full-time (teacher aides) paraprofessionals by grade level                                                Staff Demo File    Surv 2 & 3     Canned   Point-in-time

 70532    GUSZ    Number and percent of highly qualified paraprofessionals - district report                                Staff Demo File   Surv 2, 3 & 5   Canned   Point-in-time

 70533    GUTA    Number and percent of highly qualified paraprofessionals - by school report                               Staff Demo File   Surv 2, 3 & 5   Canned   Point-in-time

 70827    GUTE    Reading Endorsement Competencies data report for "Teachers"                                               Staff Demo File   Surv 2, 3 & 5   Canned   Point-in-time
Job    Job                                                                                                                       Data               Date         Report       Data
Number Name         Job Description                                                                                             Source            Available       Type       Status

 70828    GUTF      Reading Endorsement Competencies data report for "Reading Coaches"                                      Staff Demo File      Surv 2, 3 & 5   Canned    Point-in-time

          Special   Number of instructional staff and classroom teachers (Data compared to that reported in the GABX                                             Access
  -----    Run*     report for verification.)                                                                               Staff Demo File       Surv 2 & 3      query    Point-in-time


                    Reports specific to "Staff Salaries":
 62759    GADQ      Average salary and length of employment by job category [admin/instruc/teachers/support]                Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

                    Number of teachers, average and total salaries by salary step and employment length (a requestable
 60634     GIAC     district report as well )                                                                               Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

                    Average salary and number and percent of instructional staff by degree (salary schedule pay lane
  -----   GIAP*     degree levels) (Used to create the Staff Brief)                                                         Staff Payroll File    Surv 2 & 3     Canned    Point-in-time


  -----    GIAR     Median salary by degree (salary schedule pay lane degree levels) (Used to create the Staff Brief)       Staff Payroll File    Surv 2 & 3     Canned    Point-in-time


  -----   GIAS*     Average salary and number of staff for select staff positions (Used to create the Staff Brief)          Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

                    Number of staff per job code showing average length of employment and average salary (Request is
 62188    GUDN*     per job code; however EDS can print entire report of all job codes.)                                    Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

          Special   Number and average salary of instructional staff and classroom teachers (Data compared to that                                               Access
  -----    Run      reported in the GIAP and GIAS reports for verification.)                                                Staff Payroll File    Surv 2 & 3      query    Point-in-time

          Special                                                                                                                                                Access
  -----    Run*     Number and average salary of beginning teachers (instructional staff)                                   Staff Payroll File    Surv 2 & 3      query    Point-in-time


          Special                                                                                                             Staff Salary                       Access
  -----    Run*     Number and total amount in salary supplements for instructional staff and classroom teachers             Supplements          Surv 2 & 3      query    Point-in-time

          Special                                                                                                                                                  EDS
  -----    Run*     Number and total amount in benefits for instructional staff and classroom teachers                       Staff Benefits       Surv 2 & 3     Program   Point-in-time


                    Reports specific to "Staff Experience":
                                                                                                                            Staff Experience
 62929    GADT*     Teachers by race and gender and years of teaching experience                                             & Demo Files         Surv 2 & 3     Canned    Point-in-time

                                                                                                                            Staff Experience
 62930    GADU      Teachers by race and gender and by highest degree earned                                                 & Demo Files         Surv 2 & 3     Canned    Point-in-time

                    Number of instructional staff at each experience year (salary schedule step) by "each" degree (salary
 61331     GIBC     schedule pay Lane)                                                                                      Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

                    Number of instructional staff at each experience year (salary schedule step) by "combined" degree
 61332     GIBD     (salary schedule pay Lane)                                                                              Staff Payroll File    Surv 2 & 3     Canned    Point-in-time

                    Number of teachers and average years experience by "combined" degree level (salary schedule pay         Staff Experience
 61334     GIBF     lane)                                                                                                    & Payroll Files      Surv 2 & 3     Canned    Point-in-time

                                                                                                                            Staff Experience
  -----    GIBQ     Average years experience by degree level (salary schedule pay lane) (Used to create the Staff Brief)     & Payroll Files      Surv 2 & 3     Canned    Point-in-time
Job    Job                                                                                                                     Data          Date      Report      Data
Number Name          Job Description                                                                                          Source       Available    Type      Status
                     Reports specific to "Fiscal Year Reports (Survey 5)":
                                                                                                                            Fiscal Year
  -----    GUOL      Fiscal year salaries per staff categories                                                               Salaries       Surv 5     Canned   Point-in-time

                                                                                                                            Fiscal Year
 70093     GUOM      Fiscal year benefits per staff categories                                                               Benefits       Surv 5     Canned   Point-in-time

                                                                                                                            Teacher Exit
 70888     GUGD      Teacher Exit Interview Report - number of teachers per reason for leaving                               Interview      Surv 5     Canned   Point-in-time

                                                                                                                            Fiscal Year
 70094     GUON      Fiscal year salary supplements per staff categories                                                     Salaries       Surv 5     Canned   Point-in-time

           Special   Number and total amount in salary supplements for instructional staff and classroom teachers (Data     Fiscal Year                Access
  -----     Run      compared to that reported in the GUON report for verification.)                                         Salaries       Surv 5      query   Point-in-time

           Special   Number and total amount in benefits for instructional staff and classroom teachers (Data compared to   Fiscal Year                Access
  -----     Run      that reported in the GUOM report for verification.)                                                     Benefits       Surv 5      query   Point-in-time



*Highly requested report

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:22
posted:9/3/2011
language:English
pages:15