Indian Court Templates - Excel

Document Sample
Indian Court Templates - Excel Powered By Docstoc
					                                                                                                                                                                            4/18/2011
                                          f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                                        Page 1 of 9


                                 Grade Level Lookup Template
                                                                       NYS RIC
                District Grade
District Code                     NYS RIC Standard Grade Code      Standard Grade          Effective Date   Discontinue Date
                 Level Code
                                                                        Ordinal
  NY000000                       K                                KDG                       2006-06-30
  NY000000                       1                                1st                       2006-06-30
  NY000000                       2                                2nd                       2006-06-30
  NY000000                       3                                3rd                       2006-06-30
  NY000000                       4                                4th                       2006-06-30




                                                                                                                                      <------ Please continue with form.
  NY000000                       5                                5th                       2006-06-30
  NY000000                       6                                6th                       2006-06-30
  NY000000                       7                                7th                       2006-06-30
  NY000000                       8                                8th                       2006-06-30
  NY000000                       9                                9th                       2006-06-30
  NY000000                       10                               10th                      2006-06-30
  NY000000                       11                               11th                      2006-06-30
  NY000000                       12                               12th                      2006-06-30
  NY000000                       13                               K-6                       2006-06-30
  NY000000                       14                               7-12                      2006-06-30
  NY000000                       PS                               PRES                      2006-06-30
  NY000000                       PK                               PREK                      2006-06-30
  NY000000                       GD                               GED                       2006-06-30




Rules for this template
District Grade Level Codes must map to NYS RIC Standard descriptions.
                Enter your local grade levels in the "District Grade Level Code"column .
More than one of your local codes can map to a NYS RIC Standard Code
                All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank




                                 Gender Code Lookup Template

                   District         NYS RIC Standard Gender
 DistrictCode                                                        EffectiveDate      DiscontinueDate
                 GenderCode               Description
  NY000000                       Male                                  6/30/2006
  NY000000                       Female                                6/30/2006



   Prepared by LHRIC DW Team                                                                                            f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                            (914) 592-4203                                            Lookup Templates - Sheet name
                                                                                                                                                                                                          4/18/2011
                                              f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                                                                  Page 2 of 9


Rules for this template
District Gender Codes must map to NYS RIC Standard descriptions.
                 Enter your local gender codes in the "District Gender Code"column .
More than one of your local codes can map to a NYS RIC Standard Code




                                                                                                                                            <------ Please continue with form.
All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank.




                                     Ethnic Code Lookup Template

                   District Ethnic       NYS RIC Standard Ethnic
 District Code                                                              EffectiveDate       DiscontinueDate
                        Code                     Description
   NY000000                          American Indian or Alaskan Native       2006-06-30
   NY000000                          Black or African American               2006-06-30
   NY000000                          Asian                                   2006-06-30
   NY000000                          Hispanic or Latino                      2006-06-30
   NY000000                          White                                   2006-06-30
   NY000000                          Native Hawaiian/ Other Pacific Islander 2006-06-30

Rules for this template
District Ethnic Codes must map to NYS RIC Standard descriptions.
                 Enter your local ethnic codes in the "District Ethnic Code"column .
More than one of your local codes can map to a NYS RIC Standard Code
All dates must be in YYYY-MM-DD format
Effective Date is the date where the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The default is blank.


                  Location Code Lookup Template


                                                                                Local
                                                                                                     Building
                              Location Name                                Building Code                          Effective Date    Discontinue Date
                                                                                                    bedscode
                                                                              /Number
Enter Building Name Here                                                        000               000000000000     2006-06-30
                                                                                                                   2006-06-30




                                                                                                                                                                                 e continue with form.
                                                                                                                   2006-06-30
                                                                                                                   2006-06-30
                                                                                                                   2006-06-30
                                                                                                                   2006-06-30


    Prepared by LHRIC DW Team                                                                                                 f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
    44 Executive Blvd Elmsford, NY 10523                                                   (914) 592-4203                                          Lookup Templates - Sheet name
                                                                                                                                                                      <------ Please continue with form.
                                                                                                                                                                                                            4/18/2011
                                            f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                                                                      Page 3 of 9

                                                                                                         2006-06-30
                                                                                                         2006-06-30
                                                                                                         2006-06-30
                                                                                                         2006-06-30




Rules for this template
*District Location Codes must map to NYS BED's code numbers.
                 Enter your local building codes in the "Local Building Code/Number"column .
Contact the LHRIC to review your loacal school/building numbers
More than one of your local building codes can map to a NYS BED's Code
All dates must be in YYYY-MM-DD format
Effective Date is the date when the code came into effect in the district.
                 The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                 The Default is blank.




                Home Language Code Lookup Template


                 District Home      NYS RIC Standard Home
 DistrictCode                                                     Language Region      EffectiveDate   DiscontinueDate
                Language Code        Language Description
  NY000000                       *English                                                2006-06-30
  NY000000                       *Chinese                                                2006-06-30
  NY000000                       *French                                                 2006-06-30
  NY000000                       *Italian                                                2006-06-30
                                                                                         2006-06-30



Rules for this template




                                                                                                                                 <------ Please continue with form.
*District Home Language Codes must map to NYS RIC Standard descriptions.
                Enter your local home language codes in the "District Home Language Code"column .
See Home Language Appendix for NYS standard descriptions
More than one of your local codes can map to a NYS RIC Standard Code
All dates must be in YYYY-MM-DD format
Language Region is not used. Leave spaceholder.
Effective Date is the date when the code came into effect in the district.
                The default should be the current year 2006-06-30
Discontinue date is the date when the code is no longer valid in your district.
                The Default is blank.



   Prepared by LHRIC DW Team                                                                                       f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                          Lookup Templates - Sheet name
                                                                                                                                                                                                 4/18/2011
                                          f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                                                             Page 4 of 9



                                                                  ENROLLMENT CODE MAPPING
Rules for this spreadsheet:
                Column A, District Code, should be "NY" followed by the first six digits of your district BEDs code.
                Column B, Local SMS Entry/Withdrawal Code, should be your local SMS entry/withdrawal codes.
                Note: If you have more than one local code mapped to a State Code, insert a new row into the spreadsheet for each local code.

                 Local SMS                                                                                                            STATE
  DISTRICT                                                                                                    ENROLLMENT
               Entry/Withdrawa     ENROLLMENT CATEGORY                ENROLLMENT_DESCRIPTION                                       ENROLLMENT
    CODE                                                                                                     CATEGORY LONG
                    l Code                                                                                                            CODE
  NY000000                                    Entry              Enrollment in building or grade under
                                                                 Entry under public school choice            Entry Enrollment          0011
  NY000000                                    Entry              NCLB exchange student enrollment in
                                                                 Foreign                                     Entry Enrollment          5544
  NY000000                                    Entry              building or grade for the purpose of
                                                                 Student enrolled                            Entry Enrollment          0022
  NY000000                                    Entry              recording a test score (walk-in)
                                                                 Enrollment in a AHSEP or HSEP               Entry Enrollment          5555
  NY000000                                    Entry              Program                                     Entry Enrollment          5654
                                                                 Graduated (earned a Regents or local        High School
  NY000000                           Completers (Exit Code)                                                  Graduates                   799
                                                                 diploma)
                                                                                                             High School
  NY000000                           Completers (Exit Code)                                                  Completers                  085
                                                                 Earned an IEP diploma
                                                                 Earned a Local Certificate (cannot be       High School
  NY000000                           Completers (Exit Code)                                                  Completers                  102
                                                                 used after January 31, 2005)
                                                                                                             High School
  NY000000                           Completers (Exit Code)                                                  Completers                  629
                                                                 Previously earned an IEP diploma
                                                                 Earned a High School Equivalency
  NY000000                            GED        (Exit Code)     Diploma (GED)                               GED                         816
                                                                 Transferred to Public school choice         Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                    5797
                                                                 under NCLB
                                                                 Transferred to another school in this       Transfers to Other
  NY000000                           Transfers   (Exit Code)
                                                                 Transferred    an out-of-district placement Schools
                                                                 district or to to another NYS public                                    153
                                                                 school outside this district with           Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     170
                                                                 documentation




                                                                                                                                                           <------ Please continue with form.
                                                                 Transferred to a NYS non-public school Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     204
                                                                 with documentation
                                                                 Transferred to homebound instruction        Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     238
                                                                 provided by this district
                                                                 Transferred to a school outside NYS         Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     221
                                                                 with documentation
                                                                 Transferred to home-schooling by parent Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     255
                                                                 or guardian
                                                                 Transferred to a postsecondary school       Transfers to Other
  NY000000                           Transfers   (Exit Code)                                                 Schools                     272
                                                                 prior to earning a diplomaage and has
                                                                 Reached maximum legal
  NY000000                            Dropouts   (Exit Code)     not earned a diploma or certificate         Dropouts                    136
  NY000000                            Dropouts   (Exit Code)     Left school: first-time dropout
                                                                 Long-term absence (20 consecutive           Dropouts                    340
  NY000000                            Dropouts   (Exit Code)     unexcused days)
                                                                 Permanent expulsion (student must be        Dropouts                    391
  NY000000                            Dropouts   (Exit Code)     over compulsory attendance age)             Dropouts                    408
  NY000000                            Dropouts   (Exit Code)     Left school, no other high school transfer Dropouts
                                                                 Transferred to    documentation of                                      425
  NY000000                            Dropouts   (Exit Code)     equivalency (GED) preparation program Dropouts                          306

   Prepared by LHRIC DW Team                                                                                                f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
   44 Executive Blvd Elmsford, NY 10523                                          (914) 592-4203                                                  Lookup Templates - Sheet name
                                                                                                                                                                  4/18/2011
                                        f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                                Page 5 of 9

                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Entry into a different grade in the same    for Ending
NY000000                                                    school building                             Enrollment                 782
                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Transferred to an AHSEP or HSEP             for Ending
NY000000                                                    program                                     Enrollment                 289
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Transferred outside district by court order Enrollment                 323
                                                                                                        Other Circumstance
                                   Other      (Exit Code)   Left school: previously counted as a        for Ending
NY000000                                                    dropout                                     Enrollment                 357
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Left the U.S.                               Enrollment                 442
                                                                                                        Other Circumstance
                                   Other      (Exit Code)                                               for Ending
NY000000                                                    Deceased                                    Enrollment                 459




                                                            PROGRAM FACTS LOOKUP TEMPLATE
              LOCAL SIS
DISTRICT                                                                                                                     DISTRICT OR
              PROGRAM                   SCHOOL YEAR         PROGRAM TYPE           PROGRAM CODE          DESCRIPTION
  CODE                                                                                                                         SCHOOL LEVEL
                CODE

                                                                                                                                                 Identifies
NY000000                                 2006-06-30         LEP Eligibility              0231          LEP Eligible               District          LEP
                                                                                                                                                 Elligability




NY000000                                 2006-06-30         LEP Programs                 5676          Bilingual Program          District




                                                                                                                                                Identifies LEP
                                                                                                       Two-way Bilingual
NY000000                                 2006-06-30         LEP Programs                 5687                                     District      Services being
                                                                                                       Education Program                         administered.




                                                                                                       LEP - Other
NY000000                                 2006-06-30         LEP Programs                 5698                                     District
                                                                                                       Programs




 Prepared by LHRIC DW Team                                                                                            f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                         (914) 592-4203                                               Lookup Templates - Sheet name
                                                                                                                                                   4/18/2011
                                        f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                 Page 6 of 9



                                                                                        English as a
NY000000                                 2006-06-30    LEP Programs              5709                               District
                                                                                        Second Language


                                                                                        Title I - Part D:
                                                                                        Prevention &
NY000000                                 2006-06-30    NCLB                      0187   Intervention                District
                                                                                        Programs for
                                                                                        Children and Youth
                                                                                        who are Neglected,
                                                                                        Title I - Part A:
                                                                                        Improving Basic
NY000000                                 2006-06-30    NCLB                      0286                               School
                                                                                        Programs (other
                                                                                        than 5533)


                                                                                        Title I - Part C:
NY000000                                 2006-06-30    NCLB                      0330   Education of                District
                                                                                        Migratory Children

                                                                                        Supplemental
                                                                                        Services for
NY000000                                 2006-06-30    NCLB                      5533   Schools in                  School
                                                                                        Improvement Status
                                                                                        under Title I
                                                                                                                                    Identifies
                                                                                        Title X - Part C:
                                                                                                                                      Funds
                                                                                        Homeless
NY000000                                 2006-06-30    NCLB                      5566                               District         Student
                                                                                        Education/McKinney
                                                                                                                                     receives
                                                                                        -Vento
                                                                                                                                    benefit of.

                                                                                        Title III: Services to
NY000000                                 2006-06-30    NCLB                      5720   Non-Immigrant LEP           School
                                                                                        Students


                                                                                        Title III: Language
                                                                                        Instruction
NY000000                                 2006-06-30    NCLB                      5731                               School
                                                                                        Immigrant LEP
                                                                                        Students
                                                                                        Title III - Part B,
                                                                                        subpart 4:
NY000000                                 2006-06-30    NCLB                      5742   Emergency                   School
                                                                                        Immigration
                                                                                        Education Program

                                                                                        Title I - Part B,
NY000000                                 2006-06-30    NCLB                      5764   subpart 1: Reading          School
                                                                                        First


 Prepared by LHRIC DW Team                                                                               f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                 (914) 592-4203                                          Lookup Templates - Sheet name
                                                                                                                                                    4/18/2011
                                        f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                  Page 7 of 9



NY000000                                 2006-06-30    Type of Disability         0352   Autism                     District




                                                                                                                                                       <------ Please continue with form.
                                                                                         Emotional
NY000000                                 2006-06-30    Type of Disability         0363                              District
                                                                                         Disturbance




NY000000                                 2006-06-30    Type of Disability         0385   Learning Disability        District




NY000000                                 2006-06-30    Type of Disability         0396   Mental Retardation         District




                                                                                                                                   Disability of
NY000000                                 2006-06-30    Type of Disability         0407   Deafness                   District
                                                                                                                                   the Student




NY000000                                 2006-06-30    Type of Disability         0418   Hearing Impairment         District




                                                                                         Speech or
NY000000                                 2006-06-30    Type of Disability         0429   Language                   District
                                                                                         Impairment



                                                                                         Visual Impairment
NY000000                                 2006-06-30    Type of Disability         0440                              District
                                                                                         (includes Blindness)




                                                                                         Orthopedic
NY000000                                 2006-06-30    Type of Disability         0451                              District
                                                                                         Impairment




                                                                                         Other Health
NY000000                                 2006-06-30    Type of Disability         0462                              District
                                                                                         Impairment



 Prepared by LHRIC DW Team                                                                               f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                  (914) 592-4203                                         Lookup Templates - Sheet name
                                                                                                                                                       4/18/2011
                                        f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                     Page 8 of 9



NY000000                                 2006-06-30    Type of Disability         0473   Multiple Disabilities        District




NY000000                                 2006-06-30    Type of Disability         0484   Deaf-Blindness               District




                                                                                         Traumatic Brain
NY000000                                 2006-06-30    Type of Disability         0495                                District
                                                                                         Injury




                                                                                         Pre-School Student
NY000000                                 2006-06-30    Type of Disability         5786                                District
                                                                                         with a Disability


                                                                                         Removed from
                                                                                         general education
NY000000                                 2006-06-30    Level of Integration       0506                                District
                                                                                         classes for 20% or
                                                                                         less


                                                                                         Removed from
NY000000                                 2006-06-30    Level of Integration       0517   general education            District       Required for
                                                                                         classes for 21-60%                           a Disabled
                                                                                                                                        student
                                                                                                                                       Level of
                                                                                         Removed from
                                                                                                                                    integration for
                                                                                         general education
NY000000                                 2006-06-30    Level of Integration       0528                                District        a Disabled
                                                                                         classes for more
                                                                                                                                        student
                                                                                         than 60%



NY000000                                 2006-06-30    Level of Integration       0539   All separate setting         District




                                                       504 Plan - Safety                 Eligible for safety
NY000000                                 2006-06-30                               0550                                District
                                                       Net                               net in English




                                                       504 Plan - Safety                 Eligible for safety
NY000000                                 2006-06-30                               0572                                District
                                                       Net                               net in Mathematics



 Prepared by LHRIC DW Team                                                                                 f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                  (914) 592-4203                                           Lookup Templates - Sheet name
                                                                                                                                                      4/18/2011
                                        f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls Lookup Templates                                                    Page 9 of 9


                                                                                        Eligible for safety
                                                       504 Plan - Safety
NY000000                                 2006-06-30                              0583   net in Global History       District
                                                       Net
                                                                                        & Geography


                                                                                        Eligible for safety                        Regents -
                                                       504 Plan - Safety
NY000000                                 2006-06-30                              0594   net in U.S. History &       District       Safety Net
                                                       Net
                                                                                        Government                                 Exemptions



                                                       504 Plan - Safety                Eligible for safety
NY000000                                 2006-06-30                              0605                               District
                                                       Net                              net in Science




                                                       504 Plan - Safety                Eligible for safety
NY000000                                 2006-06-30                              5775                               District
                                                       Net                              net in All Subjects


                                                                                                                                     May be
                                                                                                                                   determined
                                                                                        Poverty - from low-
NY000000                                 2006-06-30    Other                     0198                               District        based on
                                                                                        income family
                                                                                                                                  Free/Reduced
                                                                                                                                      Lunch
                                                                                                                                    Report all
                                                                                        Academic
                                                                                                                                   AIS services
NY000000                                 2006-06-30    Other                     0209   Intervention                School
                                                                                                                                   (required or
                                                                                        Services - AIS
                                                                                                                                       not)
                                                                                                                                  Must be used
                                                                                                                                  to identify AA
                                                                                        Eligible for Alternate
NY000000                                 2006-06-30    Other                     0220                               District      student even
                                                                                        Assessment
                                                                                                                                   if not eligible
                                                                                                                                      for testing
                                                                                                                                          this
                                                                                                                                  Students who
                                                                                                                                        have a
NY000000                                 2006-06-30    Other                     0264   Section 504 Plan            District      subject safety
                                                                                                                                       net must
                                                                                                                                        have a
                                                                                                                                    Section 504
                                                                                                                                  Report for all
                                                                                        Summer School
                                                                                                                                  students who
                                                                                        Participation
NY000000                                 2006-06-30    Other                     0275                               School          participated
                                                                                        (beginning summer
                                                                                                                                     in summer
                                                                                        2006)
                                                                                                                                         school




                                                                                                                                                         End of forms.
                                                                                                                                        Federal
                                                                                        Early Intervening                         Funding code
NY000000                                 2006-06-30    Other                     5753   Services supported          District           use when
                                                                                        with IDEA funds                            applicable to
                                                                                                                                        student

 Prepared by LHRIC DW Team                                                                               f3e0c43e-dc1f-4b1d-9487-ad94f693a260.xls - File name
 44 Executive Blvd Elmsford, NY 10523                                 (914) 592-4203                                          Lookup Templates - Sheet name

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:4/18/2011
language:English
pages:9
Description: Indian Court Templates document sample