Get documents about "Student Activity Participation Certificate - Excel
Description
Student Activity Participation Certificate document sample
Document Sample
Extract Specifications for Student Template V7.0
8/17/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 identify
2 6 Required LOCATION CODE building in which a student is enrolled, typically Three digit 'Local" Building code the building where the student is counted for enrolment - Local
used by the local student management system. 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,
this may be the identifier assigned by the regional The unique identifier assigned to the student by the LEA (district) in
4 12 Required STUDENT ID XXXXXXXXX
warehouse. This ID will be used to map the which the student is enrolled. There are a max of 9 significant 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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/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
student's home. May or may not be the students
32 16 NATIVE LANGUAGE CURRENTLY NOT USED 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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/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
102 102 = Local Certificate
Prepared by LHRIC DW Team b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/2011
Page 4 of 10
Extract Specifications for STUDENT TEMPLATE V-7.0
Length
Field # Description Code/Format Definition Comments
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 for
of the scdhool (containing NO Grade 3 or above) Enter Bed's code for feeder school - Review the list of
106 20 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 immigrants DATE OF INITIAL ENTRY TO US YYYY-MM-DD Only if student is an immigrant
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
121 3 STUDENT IS PREGNANT CURRENTLY NOT USED
Prepared by LHRIC DW Team b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/2011
Page 5 of 10
Extract Specifications for STUDENT TEMPLATE V-7.0
Length
Field # Description Code/Format Definition Comments
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
student's home. May or may not be the students
123 16 Required HOME LANGUAGE CODE 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 For immigrants only, record the number of years in
125 4 immigrants 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
only and 25 years.
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 immigrants COUNTRY OF ORIGIN Only if student is an immigrant
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
168 60 NEIGHBORHOOD CURRENTLY NOT USED CURRENTLY NOT USED
169 12 GRADE K SCHOOL CODE CURRENTLY NOT USED CURRENTLY NOT USED
Prepared by LHRIC DW Team b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/2011
Page 6 of 10
Extract Specifications for STUDENT TEMPLATE V-7.0
Length
Field # Description Code/Format Definition Comments
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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Student
Extract Specifications for Student Template V7.0
8/17/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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 District Codes
Extract Specifications for Student Template V7.0
8/17/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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Home Language List
Extract Specifications for Student Template V7.0
8/17/2011
Page 9 of 10
Grade Level Lookup Template
District Grade NYS RIC Standard
District Code NYS RIC Standard Grade Code Effective Date Discontinue Date
Level Code Grade 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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Lookup Templates
Extract Specifications for Student Template V7.0
8/17/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 b3bcf2d7-9fdc-4a0a-87fa-ad6abba6d3df.xls
44 Executive Blvd Elmsford, NY 10523 (914) 592-4203 Lookup Templates
Related docs
Other docs by tdz14391
Department of Computer IT Engineering Second Year Students Mini Project Dear Students This week span s
Views: 115 | Downloads: 0
ANALYSIS OF THE STUDENT LOAN TRUST FUND FOR THE 2001 03 AND 2003 05 BIENNIUMS 2001 03 Biennium
Views: 11 | Downloads: 0
