Birth Certificate in Portuguese - Excel

Document Sample
Birth Certificate in Portuguese - Excel Powered By Docstoc
					                                                            Extract Specifications for Student Template V7.0
                                                                                                                                                                                                                                            1/6/2011
                                                                                                                                                                                                                                         Page 1 of 10



                                                     Extract Specifications for STUDENT TEMPLATE V-7.0
               Length
     Field #                       Description                  Code/Format        Definition      Comments

                                                                                                                   "NY" followed by the first six digits of the district   This is the LEA (District) that has responsibility for reporting on the
                                                              Public Schools - NYXXXXXX                            BED's code.Charter and non-Public schools:              status of the student for accountability purposes under No Child
      1         8       Required   DISTRICT CODE
                                                                               Non-Public - - - - 8XXXXXXX         "8nnnnnnn" (8 followed by the last 7 digits of their    Left Behind (NCLB). (See - District Codes - worksheet in this
                                                                                                                   Institution code)                                       Excel file)
                                                                                                                                                                           3 position number for local school/buildings. Up to 6 for out of
                                                              Local Building code that uniquely identifies the                                                             District school/buildings. - A number that the district uses to
      2         6       Required   LOCATION CODE              building in which a student is enrolled, typically   Three digit 'Local" Building code                       identify the building where the student is counted for enrolment -
                                                              used by the local student management system.                                                                 Local Building Code. (Contact the LHRIC staff to review and
                                                                                                                                                                           complete the Lookup templates)
                                                                                                                                                                           Last day of fiscal year school year 2005-06 = 2006-06-30
      3        10       Required   SCHOOL YEAR                YYYY-MM-DD                                           June 30th of the School Year (2006-06-30)
                                                                                                                                                                           (must be June 30, YYYY)

                                                                                                                   Local Identifier assigned by the local student
                                                                                                                   information system for this student. Alternatively,
                                                                                                                                                                           The unique identifier assigned to the student by the LEA (district)
                                                                                                                   this may be the identifier assigned by the regional
      4        12       Required   STUDENT ID                 XXXXXXXXX                                                                                                    in which the student is enrolled. There are a max of 9 significant
                                                                                                                   warehouse. This ID will be used to map the
                                                                                                                                                                           digits
                                                                                                                   NYSSIS statewide ID back to the record in the
                                                                                                                   warehouse or local system. Field is nine digits
                                                                                                                   long with leading zeros where needed.
      5        11                  SOCIAL SECURITY NUMBER                CURRENTLY NOT USED
      6        9                   FAMILY NUMBER                         CURRENTLY NOT USED
                                                                                                                   Student's last name, including any hyphenated
      7        25       Required   LAST NAME SHORT            Student's last name                                                                                          Student's legal last name
                                                                                                                   portion.
     8         15       Required   FIRST NAME SHORT           Student's first name                                 Student's first name                                    Student's legal first name No nick names
     9         1        Optional   MIDDLE INITIAL             Student's middle initial                             Student's middle initial                                First letter of middle name if applicable
     10        2        Required   CURRENT GRADE LEVEL        1                                                    Grade 1                                                 Two (2) position text field representing Students Grade
                                                              2                                                    Grade 2                                                 (See - Grade Codes - worksheet in this Excel file)
                                                              3                                                    Grade 3
                                                              4                                                    Grade 4
                                                              5                                                    Grade 5
                                                              6                                                    Grade 6
                                                              7                                                    Grade 7
                                                              8                                                    Grade 8
                                                              9                                                    Grade 9
                                                              10                                                   Grade 10
                                                              11                                                   Grade 11
                                                              12                                                   Grade 12
                                                              13                                                   Ungraded Elementary , K-6
                                                              14                                                   Ungraded Secondary, 7-12
                                                              PK                                                   Pre Kindergarten
                                                              K                                                    Kindergarten
                                                              KA                                                   Kindergarten
                                                              KP                                                   Kindergarten
                                                              PS                                                   Pre School
                                                              GD                                                   GED
     11         2                  CURRENT GRADE GROUP                    CURRENTLY NOT USED
     12         4                  CURRENT GRADE ORDINAL                  CURRENTLY NOT USED
                                                                                                                                                                           Used by Test Scoring for sort purposes in Elementary schools - *
     13         6       Required   HOME ROOM                  Alpha-Numeric                                        Student Homeroom
                                                                                                                                                                           FOR MIDDLE & HIGH SCHOOL CONTACT TEST SCORING *
                                                                                                                                                                           The date of the student’s birth derived from a certificate of birth
                                                                                                                                                                           issued by an appropriate government authority. If a birth certificate
     14        10       Required   BIRTHDATE                  YYYY-MM-DD                                           Student's Date of Birth
                                                                                                                                                                           does not exist, use an official source as directed by district policy
                                                                                                                                                                           Format yyyy-mm-dd
                                                                                                                                                                           Gender code of the student being reported (Contact the LHRIC
     15         6       Required   GENDER CODE                M                                                    Male
                                                                                                                                                                           staff to review and complete the Lookup templates)
                                                              F                                                    Female
                                                                                                                                                                           The first line of the address of the student’s principal residence.
     16        30       Required   ADDRESS 1                                                                       Home Address Line 1                                     Provide number, street, and apartment number. Do not include
                                                                                                                                                                           PO Box.

Prepared by LHRIC DW Team                                                                                                                                                                            bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                                    (914) 592-4203                                                                                                               Student
                                                             Extract Specifications for Student Template V7.0
                                                                                                                                                                                                                               1/6/2011
                                                                                                                                                                                                                            Page 2 of 10



                                                       Extract Specifications for STUDENT TEMPLATE V-7.0
               Length
     Field #                       Description                    Code/Format        Definition      Comments

                                                                                                                                                                  The second address line of the student's principal residence, if
     17        30       Optional   ADDRESS 2                                                            Home Address Line 2 - Only when needed.
                                                                                                                                                                  needed, after using the first line. Do not include PO Box.
     18        25       Required   CITY                                                                                                                           The city of the student’s principal residence.
                                                                                                                                                                  The two-character United States Postal Service (USPS) code for
     19         2       Required   STATE                         NY
                                                                                                                                                                  the state of the student’s principal residence.
     20        10       Required   ZIP CODE                      XXXXX OR XXXXX-XXXX                    Use 5 digits , or 9 digits with a dash after the first 5. The USPS or other assigned zip code of the student’s
                                                                                                                                                                   principal residence. The zip code can be either five digits with no
                                                                                                                                                                  dash or nine digits with a dash. Canadian zip codes do not require
                                                                                                                                                                  a dash. FormatT "NNNNN" OR "NNNNN-NNNN"
                                                                                                        Record the area code and phone number. If there
                                                                                                        is no phone at the primary residence, record the          The telephone number at the students principal residence. Format
     21        14       Required   HOME PHONE                    NNN-NNN-NNNN
                                                                                                        number most frequently used to contact the                as "NNN-NNN-NNNN"
                                                                                                        students's primary guardian.
                                                                                                                                                                  The full name of the student’s parent or primary guardian. Format
     22        40       Required   PRIMARY GUARDIAN NAME         FirstName LastName                     The full name of the primary guardian.
                                                                                                                                                                  is "FIRSTNAME LASTNAME"
     23        15                  GUARDIAN RELATIONSHIP                  CURRENTLY NOT USED
     24        14                  GUARDIAN DAYTIME PHONE                 CURRENTLY NOT USED
     25        15                  STUDENT LIVES WITH                     CURRENTLY NOT USED
     26        1                   SINGLE PARENT HOUSEHOLD                CURRENTLY NOT USED
     27        2        Required   ETHNIC CODE SHORT             I                                      American Indian or Alaska Native                       For reporting purposes, a student should be reported using
                                                                 A                                      Asian                                                  the race/ethnicity designation for the group to which he or
                                                                 B                                      Black or African American                              she appears to belong, identifies with, or is regarded in the
                                                                 H                                      Hispanic or Latino                                     community as belonging. Race/ethnicity is identified by the
                                                                 W                                      White                                                  student or by their parent/guardian.
                                                                                                                                                               (Contact the LHRIC staff to review and complete the Lookup
                                                                 P                                      Native Hawaiian/Other Pacific Islander
                                                                                                                                                               templates)
     28        40                  ETHNIC DESCRIPTION                     CURRENTLY NOT USED
                                   GEOGRAPHIC CODE PICKUP (BUS
     29        24                                                         CURRENTLY NOT USED
                                   ROUTE)
                                   GEOGRAPHIC CODE DROPOFF
     30        24                                                         CURRENTLY NOT USED
                                   (BUS ROUTE)
     31        10                  LOCALE (NEIGHBORHOOD)                  CURRENTLY NOT USED

                                                                                                        The language or dialect routinely spoken in the        The language or dialect routinely spoken in the student's home. If
     32        16                  NATIVE LANGUAGE               CURRENTLY NOT USED                     student's home. May or may not be the students         home language is left blank, it will be considered to be English.
                                                                                                        native language If Home Language List is left          (See - Home Language Codes- worksheet in this Excel file)
                                                                                                        blank, it will be considered to be English.
                                   ECONOMIC STATUS (FOOD PGM
     33        12                                                         CURRENTLY NOT USED
                                   PARTICIPATION)
     34        30                  CHALLENGE TYPE                Collected from PROGRAM-FACT Template                                                          This is a student's "Disability Code"
     35        10                  TESTING MODIFICATION 1                    CURRENTLY NOT USED
     36        10                  TESTING MODIFICATION 2                    CURRENTLY NOT USED
     37        10                  TESTING MODIFICATION 3                    CURRENTLY NOT USED
     38        3                   SPECIAL EDUCATION                         CURRENTLY NOT USED
     39        3                   RELATED LEARNING                          CURRENTLY NOT USED
     40        15                  LEVEL OF INTEGRATION          Collected from PROGRAM-FACT Template                                                          As related to Disability
     41         3                  LEP PARTICIPATION             Collected from PROGRAM-FACT Template                                                          Receives ELL Services
     42         2       Required   DURATION OF LEP               DURATION OF LEP - 0 through 6 years    Number of consecutive years in LEP - Refer             Years of ELL Service
                        For LEP                                                                         to page 14 of New York State DICTIONARY
                        Students                                                                        of REPORTING DATA ELEMENTS
     43        2                   STUDENT MOVES                          CURRENTLY NOT USED
     44        3                   TARGETED ASSISTANCE                    CURRENTLY NOT USED
     45        6                   SPECIAL PROGRAM CODE                   CURRENTLY NOT USED
     46        3                   REPEATING LAST YEAR                    CURRENTLY NOT USED
     47        3                   MERIT PROGRAM                          CURRENTLY NOT USED
     48        3                   MAGNET PROGRAM                         CURRENTLY NOT USED
     49        2                   LAST GRADE LEVEL                       CURRENTLY NOT USED
     50        6                   LAST LOCATION CODE                     CURRENTLY NOT USED
     51        8                   LAST DISTRICT CODE                     CURRENTLY NOT USED
     52        12                  LAST STUDENT ID                        CURRENTLY NOT USED
Prepared by LHRIC DW Team                                                                                                                                                                 bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                           (914) 592-4203                                                                                                             Student
                                                                  Extract Specifications for Student Template V7.0
                                                                                                                                                                                                                                 1/6/2011
                                                                                                                                                                                                                              Page 3 of 10



                                                         Extract Specifications for STUDENT TEMPLATE V-7.0
               Length
     Field #                        Description                     Code/Format        Definition      Comments

                                    EXPECTED GRADUATION
     53         4                                                           CURRENTLY NOT USED
                                    TIMEFRAME
     54         9                   UNWEIGHTED GPA                          CURRENTLY NOT USED
     55         9                   WEIGHTED GPA                            CURRENTLY NOT USED
     56         7                   CUMULATIVE CREDIT ATTEMPTED             CURRENTLY NOT USED
     57         7                   CUMULATIVE CREDIT EARNED                CURRENTLY NOT USED
     58         5                   CLASS RANKING                           CURRENTLY NOT USED
                                    PROHIBIT INTERNET ACCESS
     59         1                                                           CURRENTLY NOT USED
                                    INDICATOR
     60        1                    MINIMUM GPA INDICATOR                   CURRENTLY NOT USED
     61        9                    MINIMUM GPA REQUIRED                    CURRENTLY NOT USED
     62        1                    IMPACT PROGRAM                          CURRENTLY NOT USED
     63        1                    NCAA ELIGIBILITY                        CURRENTLY NOT USED
     64        1                    STATE SCHOLARSHIP ELIGIBILITY           CURRENTLY NOT USED
     65        1                    GRADUATION STATUS CODE                  CURRENTLY NOT USED
     66        30       Required    POST GRADUATE ACTIVITY        1                                                 Required for graduated students only.                  1 = 4-year college in NYS
                           for                                    2                                                 Record the code for the student's planned              2 = 2-year college in NYS
                        Graduates                                 3                                                 activity after graduation.                             3 = Other postsecondary school in NYS
                                                                  4                                                                                                        4 = 4-year college outside NYS
                                                                  5                                                 For more information see                               5 = 2-year college outside NYS
                                                                  6                                                 "Data Elements Dictionary"                             6 = Other postsecondary school outside NYS
                                                                  7                                                                                                        7 = Seek employment
                                                                  8                                                                                                        8 = Enlist in the military
                                                                  9                                                                                                        9 = Other plan
                                                                  10                                                                                                       10 = Adult Services (disabled only)
                                                                  11                                                                                                       11 = Unknown
     67         1       Required    STUDENT STATUS                Not Used for Unique Student ID (Local Use Only)   Student is Active or Inactive                          A = Active I = Inactive
                                                                                                                    -Active Students - Date extracted for loading to
                                                                                                                    Level0 or Last Day of School Year
     68        10       Required    LAST STATUS DATE                  YYYY-MM-DD                                                                               -Inactive
                                                                                                                    Students - date they were inactivated on
                                                                                                                    enrollment record.
     69        4                    CLASS SIZE                                    CURRENTLY NOT USED
     70        1                    PLAN 504 INDICATOR                            CURRENTLY NOT USED
     71        12                   FREE BOOK CODE                                CURRENTLY NOT USED
     72        5                    WEIGHTED CLASS RANK                           CURRENTLY NOT USED
     73        3                    FOREIGN EXCHANGE STUDENT                      CURRENTLY NOT USED
     74        10                   DATE OF RANK                                  CURRENTLY NOT USED
     75        7                    POINTS ACCUMULATED                            CURRENTLY NOT USED
     76        7                    POINTS WEIGHTED                               CURRENTLY NOT USED
     77        3                    STANDARD PROGRAM                              CURRENTLY NOT USED
     78        3                    COLLEGE PROGRAM                               CURRENTLY NOT USED
     79        3                    HONORS PROGRAM                                CURRENTLY NOT USED
     80        3                    GIFTED AND TALENTED                           CURRENTLY NOT USED
     81        3                    PHYSICAL HEALTH CODE                          CURRENTLY NOT USED
     82        7                    POINTS ADD-ON                                 CURRENTLY NOT USED
     83        10                   SNAPSHOT DATE                                 CURRENTLY NOT USED
     84        20                   GROUP NAME                                    CURRENTLY NOT USED
     85        10                   GROUP REMOVAL DATE                            CURRENTLY NOT USED
     86        24                   STUDENT CITIZENSHIP                           CURRENTLY NOT USED
     87        7                    GRAD REQUIREMENT                              CURRENTLY NOT USED
     88        1                    POVERTY CODE                      Collected from PROGRAM-FACT Template
     89         1                   POPULATION CODE                   Collected from PROGRAM-FACT Template
     90         1                   MOBILITY CODE                     Collected from SCHOOL ENROLLENT Template
     91         3       Required    DIPLOMA TYPE CODE                                                               Required for graduated students                        List, as of November 1, 2005
                           for                                        017                                           For more information see                               017 = For more information see
                        Graduates                                     034                                              "Data Elements Dictionary"                          034 = Regents pre July 1 2001
                                                                      051                                             or                                                   051 = Regents with CTE pre July 1 2001
                                                                      068                                               www.emsc.nysed.gov/osa                             068 = Local Diploma
                                                                      085                                                                                                  085 = IEP Diploma

Prepared by LHRIC DW Team                                                                                                                                                                         bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                                     (914) 592-4203                                                                                                           Student
                                                                   Extract Specifications for Student Template V7.0
                                                                                                                                                                                                                                1/6/2011
                                                                                                                                                                                                                             Page 4 of 10



                                                        Extract Specifications for STUDENT TEMPLATE V-7.0
               Length
     Field #                         Description                   Code/Format        Definition      Comments

                                                                     102                                                                                          102 = Local Certificate
                                                                     595                                                                                          595 = Regents with Honors&CTE pre July 1 2001
                                                                     612                                                                                          612 = Local Diploma with Career Ed
                                                                     680                                                                                          680 = Regents Diploma with Adv Designation
                                                                     697                                                                                          697 = Regents Diploma with Adv Des & Career Ed
                                                                     714                                                                                          714 = Regents Diploma with Adv Des & Honors
                                                                     731                                                                                          731 = Regents Diploma with AD&Honors&Career Ed
                                                                     738                                                                                          738 = GED
                                                                     762                                                                                          762 = Regents with Honors post July 1 2001
                                                                     779                                                                                          779 = Regents post July 1 2001
                                                                     796                                                                                          796 = Regents with CTE post July 1 2001
                                                                     813                                                                                          813 = Regents with Honors&CTE post July 1 2001
     92        3                     SAFETY NET CODE                             CURRENTLY NOT USED
     93        25                    ALTERNATE STUDENT ID                        CURRENTLY NOT USED
     94        3                     EXCLUDE FROM RANK                           CURRENTLY NOT USED
     95        3                     LEP/ELL ELIGIBILITY                         CURRENTLY NOT USED
     96        1                     PROGRAM SERVICES CODE           Collected from PROGRAM-FACT Template
                         Required                                                                           The actual date that the student entered Grade 9.     The date of the student’s first entry into grade 9. Month, day and
     97        10       for grades   DATE OF ENTRY GRADE 9           YYYY-MM-DD                             Not necessary to project this date and should be      year on which the student first entered grade 9 anywhere. Do not
                         9 & above                                                                          blank for students in Pre-K thru 8.                   enter this information until the student first enrolls in grade 9.
     98        10                    DATE OF ENTRY DISTRICT                   CURRENTLY NOT USED
     99        10                    DATE OF ENTRY SCHOOL                     CURRENTLY NOT USED
    100        20                    MEMBERSHIP ID                            CURRENTLY NOT USED
    101        2                     INITIAL GRADE IN DISTRICT                CURRENTLY NOT USED
    102        15                    EDUCATION LEVEL OF PARENT                CURRENTLY NOT USED
    103        12                    FAMILY IDENTIFIER                        CURRENTLY NOT USED
    104        14                    CONTACT PHONE                            CURRENTLY NOT USED
                                                                                                                                                                  This is the date that the student was first immunized against
                                                                                                            Date of first polio vaccination OPV or IPV. Use the   poliomyelitis. Use the data of the first immunization, regardless of
    105        10        Optional    INOCULATION DATE                YYYY-MM-DD
                                                                                                            first day of the month if the day is not indicated.   whether the immunization was provided via OPV or IPV. Use the
                                                                                                                                                                  first day of the month of immunization if day is not indicated
                                                                                                            Used for BACKMAPPING - this is the BED's code
                        Required
                                                                                                            of the scdhool (containing NO Grade 3 or above)       Enter Bed's code for feeder school - Review the list of
    106        20       for some     SERVICE PROVIDER                NNNNNNNNNNNN
                                                                                                            that the student was enrolled in during a previous    District/Schools in the "Dicitionary of Data Elements"
                         districts
                                                                                                            year in the district.
                                                                                                            The full name of the alternate guardian. Do NOT       The full name of a second guardian for the student. Format is
    107        40       Required     ALTERNATE GUARDIAN NAME         FirstName LastName
                                                                                                            use a salutation.                                     "FIRSTNAME LASTNAME"

                                                                                                            Location where the student was born. Best             The City, State/Province/Region and Country in which the student
                                                                                                            possible data is City State Country for non-US born   was born. If the student was born in the United States, country is
    108        50       Required     PLACE OF BIRTH
                                                                                                            students or City State for US born citizens. Any      optional, however if included, use USA. If all of these data is not
                                                                                                            data is acceptable, but should follow the space       available, record as much data as possible.
                                                                                                            delimited format of City State Country.
    109        10                    DATE OF ENTRY TO STATE                   CURRENTLY NOT USED
                         Required
                           for                                                                              For immigrants only, record the date when the
    110        10                    DATE OF INITIAL ENTRY TO US     YYYY-MM-DD                                                                                   Only if student is an immigrant
                        immigrants                                                                          student entered the U.S. For the first time.
                           only
    111        3                     HOMELESS
    112        8                     MIGRANT STATUS
    113        8                     ENGLISH PROFICIENCY                      CURRENTLY NOT USED
    114        4                     SECOND OR SUB ETHNIC CODE                CURRENTLY NOT USED
    115        6                     NEXT LOCATION CODE                       CURRENTLY NOT USED
    116        2                     NEXT GRADE LEVEL                         CURRENTLY NOT USED
    117        8                     DISTRICT CODE OF RESIDENCE               CURRENTLY NOT USED
    118        40                    COUNTY OF RESIDENCE                      CURRENTLY NOT USED
    119        3                     AT RISK STUDENT                          CURRENTLY NOT USED
    120        3                     STUDENT IS A SINGLE PARENT               CURRENTLY NOT USED

Prepared by LHRIC DW Team                                                                                                                                                                  bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                               (914) 592-4203                                                                                                          Student
                                                                         Extract Specifications for Student Template V7.0
                                                                                                                                                                                                                                     1/6/2011
                                                                                                                                                                                                                                  Page 5 of 10



                                                                  Extract Specifications for STUDENT TEMPLATE V-7.0
                    Length
     Field #                                Description                      Code/Format        Definition      Comments

    121              3                      STUDENT IS PREGNANT                        CURRENTLY NOT USED
                                            EDUCATIONALLY
    122              3                                                                 CURRENTLY NOT USED
                                            DISADVANTAGED

                                                                                                                    The language or dialect routinely spoken in the     The language or dialect routinely spoken in the student's home. If
    123             16       Required       HOME LANGUAGE CODE                                                      student's home. May or may not be the students      home language is left blank, it will be considered to be English.
                                                                                                                    native language If Home Language List is left       (See - Home Language Codes- worksheet in this Excel file)
                                                                                                                    blank, it will be considered to be English.
    124              3                      NEGLECTED OR DELINQUENT
                              Required
                                                                                                                    For immigrants only, record the number of years in
                                for
    125              4                      YEARS IN US SCHOOLS                                                     a school anywhere in the U.S. Must be between 0 Only if student is an immigrant - # of years anywhere in US
                             immigrants
                                                                                                                    and 25 years.
                                only
    126             10                      NAME SUFFIX                                CURRENTLY NOT USED
    127             60                      FIRST NAME ALIAS                           CURRENTLY NOT USED
    128             3                       SPECIAL EDUCATION TRANSITION               CURRENTLY NOT USED
    129             6                       GIFTED ELIGIBILITY CODE                    CURRENTLY NOT USED
    130             3                       REPORT PERIOD ATTENDANCE                   CURRENTLY NOT USED
    131             3                       FOOD PROGRAM ELIGIBILITY                   CURRENTLY NOT USED
    132             3                       PRE-K PROGRAM CODE                         CURRENTLY NOT USED
    133             60                      LAST NAME LONG                             CURRENTLY NOT USED
    134             60                      FIRST NAME LONG                            CURRENTLY NOT USED
                              Required
                                for                                                                                 For immigrants only, record the country from which
    135              4                      COUNTRY OF ORIGIN                                                                                                          Only if student is an immigrant
                             immigrants                                                                             the student emigrated.
                                only
    136             4                       COUNTRY OF BIRTH                           CURRENTLY NOT USED
    137             3                       FTE PERCENT                                CURRENTLY NOT USED
    138             10                      NAME SUFFIX ALIAS                          CURRENTLY NOT USED
    139             60                      LAST NAME ALIAS                            CURRENTLY NOT USED
    140             60                      MIDDLE NAME ALIAS                          CURRENTLY NOT USED
                                            MOST RECENT ENTRY TO US
    141             10                                                                 CURRENTLY NOT USED
                                            DATE
    142             60                      MIDDLE NAME                                CURRENTLY NOT USED
    143             4                       CREDENTIAL TYPE CODE                       CURRENTLY NOT USED
  144          3                          HISPANIC ETHNICITY INDICATOR     Not used until 2007-2008                 Not used until 2007-2008
  145          3                          PRIMARY RACE INDICATOR           Not used until 2007-2008                 Not used until 2007-2008
  146          2                          RACE 2 CODE                      Not used until 2007-2008                 Not used until 2007-2008
  147          2                          RACE 3 CODE                      Not used until 2007-2008                 Not used until 2007-2008
  148          2                          RACE 4 CODE                      Not used until 2007-2008                 Not used until 2007-2008
  149          2                          RACE 5 CODE                      Not used until 2007-2008                 Not used until 2007-2008
  150          3                          FEDERAL FORM 506 INDICATOR                   CURRENTLY NOT USED                         CURRENTLY NOT USED
  151          4                          BIRTH DATE VERIFICATION CODE                 CURRENTLY NOT USED                         CURRENTLY NOT USED
  152          3                          IMMIGRANT INDICATOR
  153          16                         PRIMARY LANGUAGE CODE                        CURRENTLY NOT USED                         CURRENTLY NOT USED
  154          30                         ADDRESS 3                                    CURRENTLY NOT USED                         CURRENTLY NOT USED
  155          5                          BASE ZIP CODE                                CURRENTLY NOT USED                         CURRENTLY NOT USED
  156          4                          ZIP CODE +4                                  CURRENTLY NOT USED                         CURRENTLY NOT USED

  157          40                         MAILING ADDRESS 1
                                                                                       CURRENTLY NOT USED                         CURRENTLY NOT USED
  158          40                         MAILING ADDRESS 2                            CURRENTLY NOT USED                         CURRENTLY NOT USED
  159          30                         MAILING ADDRESS 3                            CURRENTLY NOT USED                         CURRENTLY NOT USED

  160          30                         MAILING ADDRESS CITY                         CURRENTLY NOT USED                         CURRENTLY NOT USED
  161          2                          MAILING ADDRESS STATE CODE                   CURRENTLY NOT USED                         CURRENTLY NOT USED
  162          5                          MAILING ADDRESS ZIP CODE                     CURRENTLY NOT USED                         CURRENTLY NOT USED
  163          4                          MAILING ADDRESS ZIP CODE +4                  CURRENTLY NOT USED                         CURRENTLY NOT USED
  164          8                          PLAN 504 PRIMARY DISABILITY                  CURRENTLY NOT USED                         CURRENTLY NOT USED
  165          12                         LOCATION CODE OF RESIDENCE                   CURRENTLY NOT USED                         CURRENTLY NOT USED
  166          3                          DISPLACED HOMEMAKER                          CURRENTLY NOT USED                         CURRENTLY NOT USED
  167          4                          SPED REFERRAL CODE                           CURRENTLY NOT USED                         CURRENTLY NOT USED
Prepared by LHRIC DW Team                                                                                                                                                                        bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                                        (914) 592-4203                                                                                                       Student
                                                                     Extract Specifications for Student Template V7.0
                                                                                                                                                                                 1/6/2011
                                                                                                                                                                              Page 6 of 10



                                                             Extract Specifications for STUDENT TEMPLATE V-7.0
                    Length
     Field #                            Description                     Code/Format        Definition      Comments

  168          60                     NEIGHBORHOOD                                CURRENTLY NOT USED                         CURRENTLY NOT USED
  169          12                     GRADE K SCHOOL CODE                         CURRENTLY NOT USED                         CURRENTLY NOT USED
  170          12                     GRADE 01 SCHOOL CODE                        CURRENTLY NOT USED                         CURRENTLY NOT USED
  171          12                     GRADE 02 SCHOOL CODE                        CURRENTLY NOT USED                         CURRENTLY NOT USED

                         Description This table describes the demographic details, one record for each student.

                                      LEA = Local Education Agency (District)
                                      SMS = Student Management System
                                      File Format = CSV (Comma Delimited, Text in double quotes i.e.                       ,"Name", )




Prepared by LHRIC DW Team                                                                                                                         bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523                                                                      (914) 592-4203                                                          Student
             Extract Specifications for Student Template V7.0
                                                                                                        1/6/2011
                                                                                                     Page 7 of 10

                  Beds Code                            Updated 03-17-05
                                 District   BED's
                                                       District Short Name
                                 Code       Code
                                 NY660413   660413      ABBOTT
                                 NY660405   660405      ARDSLEY
                                 NY660102   660102      BEDFORD UFSD
                                 NY661905   661905      BLIND BROOK-RYE
                                 NY480601   480601      BREWSTER
                                 NY661402   661402      BRIARCLIFF MANOR
                                 NY660303   660303      BRONXVILLE
                                 NY661201   661201      BYRAM HILLS
                                 NY480102   480102      CARMEL
                                 NY661004   661004      CHAPPAQUA
                                 NY500101   500101      CLARKSTOWN
                                 NY660202   660202      CROTON HARMON
                                 NY660403   660403      DOBBS FERRY
                                 NY500402   500402      EAST RAMAPO
                                 NY660301   660301      EASTCHESTER
                                 NY660406   660406      EDGEMONT
                                 NY500414   500414      EDWIN GOULD
                                 NY660409   660409      ELMSFORD
                                 NY480404   480404      GARRISON
                                 NY660407   660407      GREENBURGH 7
                                 NY660411   660411      GREENBURGH ELEVEN
                                 NY660410   660410      GREENBURGH GRAHAM
                                 NY660412   660412      GREENBURGH NORTH-CASTLE
                                 NY480401   480401      HALDANE
                                 NY660501   660501      HARRISON
                                 NY660404   660404      HASTINGS ON HUDSON
                                 NY500201   500201      HAVERSTRAW
                                 NY660803   660803      HAWTHORNE CEDAR-KNOLLS
                                 NY660203   660203      HENDRICK HUDSON
                                 NY660402   660402      IRVINGTON
                                 NY660101   660101      KATONAH
                                 NY662401   662401      LAKELAND
                                 NY480101   480101      MAHOPAC
                                 NY660701   660701      MAMARONECK
                                 NY660900   660900      MOUNT VERNON
                                 NY660806   660806      MT PLEASANT BLYTHEDALE
                                 NY660801   660801      MT PLEASANT CENTRAL
                                 NY660804   660804      MT PLEASANT COTTAGE
                                 NY500108   500108      NANUET
                                 NY661100   661100      NEW ROCHELLE
                                 NY661301   661301      NORTH SALEM
                                 NY500304   500304      NYACK
                                 NY661401   661401      OSSINING
                                 NY500308   500308      PEARL RIVER
                                 NY661500   661500      PEEKSKILL
                                 NY661601   661601      PELHAM
                                 NY660809   660809      PLEASANTVILLE
                                 NY660802   660802      POCANTICO HILLS
                                 NY661904   661904      PORT CHESTER-RYE
                                 NY480503   480503      PUTNAM VALLEY
                                 NY500401   500401      RAMAPO
                                 NY661800   661800      RYE CITY
                                 NY661901   661901      RYE NECK
                                 NY662001   662001      SCARSDALE
                                 NY500301   500301      SO ORANGETOWN
                                 NY662101   662101      SOMERS
                                 NY660401   660401      TARRYTOWNS
                                 NY660302   660302      TUCKAHOE
                                 NY660805   660805      VALHALLA
                                 NY662200   662200      WHITE PLAINS
                                 NY662402   662402      YORKTOWN
Prepared by LHRIC DW Team                                               bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523            (914) 592-4203                                    District Codes
         Extract Specifications for Student Template V7.0
                                                                                                          1/6/2011
                                                                                                       Page 8 of 10

                               Home Language List
    Adan                        Flemish                  Lithuanian                  Shluh
    Adangme                     Fon                      Luba                        Sidamo
    Afrikaans                   French                   Luo                         Signed English
    Albanian                    Fulani                   Macedonian                  Sindhi
    American Sign Language      Ga                       Malagasy                    Sinhalese
    Amharic                     Galician                 Malay                       Slovak
    Amoy                        Galla                    Malayalam                   Somali
    Arabic                      German                   Malinke                     Sotho-Northern
    Araucanian                  Gokana                   Maltese                     South Arabic
    Arawak                      Greek                    Marathi                     Spanish
    Armenian                    Guarani                  Mari                        Sukuma
    Aymara                      Gujarati                 Mohawk                      Sundanese
    Azerbaijani                 Gurma                    Moldavian                   Swahili
    Balante                     Haitian Creole           Mossi                       Swazi
    Baluchi                     Hausa                    Nahuatl                     Swedish
    Bambara                     Hebrew                   Napali                      Tadzhik
    Basque                      Hindi                    Niger/Congo                 Tagalog
    Belorussian                 Hungarian                Norwegian                   Tamazight
    Bemba                       Ibo                      Nyanja                      Tamil
    Bengali                     Icelandic                Oneida                      Telugu
    Bhili                       Ilocano                  Oriya                       Teme
    Bihari                      Indonesian               Oromo                       Thai
    Birhundi                    Irish                    Ossetian                    Tibetan
    Bosnian                     Italian                  Papiamento                  Tigre
    Brahui                      Jamaican Creole          Pashto                      Tigrinya
    Breton                      Japanese                 Persian                     Tonga
    Bulgarian                   Jonkhan                  Pilipiono                   Tuareg
    Burmese                     Kabre                    Polish                      Turkish
    Cambodian                   Kabyle                   Portuguese                  Turkmen
    Catalan                     Kafiri                   Provencal                   Twi
    Cham                        Kamba                    Punjabi                     Ukranian
    Chinese                     Kanarese                 Quechua                     Urdu
    Creole                      Kanuri                   Quiche                      Uzbeck
    Croatian                    Karen                    Rajasthani                  Vietnamese
    Czech                       Kashmiri                 Romanian                    Welsh
    Dagomba                     Khmer                    Romansch                    Wolof
    Danish                      Khowan                   Rundi                       Yapose
    Dari                        Kibuyu                   Russian                     Yiddish
    Dejula                      Kirundi                  Rwanda                      Yonba
    Dinka                       Korean                   Samoan                      Yoruba
    Dutch                       Kpelle                   Sanskrit
    English                     Krio                     Scottish Gaelic
    Ewe                         Kurdish                  Serbo Croatian
    Fanti                       Lao                      Seri
    Farsi                       Latvian                  Shan
    Finnish                     Lingala                  Shina




Prepared by LHRIC DW Team                                                  bc4d5387-46d5-4a95-9525-d227751f86f9.xls
44 Executive Blvd Elmsford, NY 10523              (914) 592-4203                                Home Language List
                              Extract Specifications for Student Template V7.0
                                                                                                                                                                               1/6/2011
                                                                                                                                                                            Page 9 of 10

                                  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
  NY000000                        5                                   5th                      2006-06-30




                                                                                                                                       <------ Please continue with form.
  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 2005-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
District Code                                                           Effective Date      Discontinue Date
                 GenderCode                Description
  NY000000                        Male                                    2005-06-30
  NY000000                        Female                                  2005-06-30



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
All dates must be in YYYY-MM-DD format
                                                                                                                                       <------ Please continue with form.




Effective Date is the date where the code came into effect in the district.
                 The default should be the current year 2005-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                                                            Effective Date     Discontinue Date
                     Code                     Description
  NY000000                        American Indian or Alaskan Native       2005-06-30
  NY000000                        Black or African American               2005-06-30
  NY000000                        Asian                                   2005-06-30
  NY000000                        Hispanic or Latino                      2005-06-30
  NY000000                        White                                   2005-06-30
  NY000000                        Native Hawaiian/ Other Pacific Islander 2005-06-30

Rules for this template
District Ethnic Codes must map to NYS RIC Standard descriptions.
   Prepared by LHRIC DW Team                                                                                      bc4d5387-46d5-4a95-9525-d227751f86f9.xls
   44 Executive Blvd Elmsford, NY 10523                                    (914) 592-4203                                               Lookup Templates
                               Extract Specifications for Student Template V7.0
                                                                                                                                                                 1/6/2011
                                                                                                                                                             Page 10 of 10

                                    Grade Level Lookup Template
                 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 2005-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                      Discontinue
                            Location Name                              Building Code                        Effective Date
                                                                                               bedscode                           Date
                                                                          /Number
Enter Building Name Here                                                    000           000000000000        2005-06-30




                                                                                                                                                                      <------ Please continue with form.
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-06-30
                                                                                                              2005-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 2005-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
 District Code                                                      Language Region       Effective Date   Discontinue Date
                   Language Code        Language Description
   NY000000                         *English                                               2005-06-30
   NY000000                         *Chinese                                               2005-06-30
   NY000000                         *French                                                2005-06-30
   NY000000                         *Italian                                               2005-06-30
                                                                                           2005-06-30



Rules for this template
                                                                                                                                   End of Form - Thank you




*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 2005-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                                                                                 bc4d5387-46d5-4a95-9525-d227751f86f9.xls
    44 Executive Blvd Elmsford, NY 10523                                 (914) 592-4203                                             Lookup Templates

				
DOCUMENT INFO
Description: Birth Certificate in Portuguese document sample