Excel Sheet Download 6555 | Ibatemplates20131106

Partial file snippet.

Sheet 1: INDEX

	
	
	
		ESCHOLAR CDW-PK12 v15.0 DATA INTEGRATION TEMPLATES
		
	
		

		

		

		

	
	
		

		

		

		

	
	
		Description
		

		

		

	
	
		       These template(s) provide layouts and business rules for extracting source data in the eScholar-required format
		
	
		

		

		

		

	
	
		Template Name
		Table Name
		EDM File ID
		Changed/New
	
	
		ASSESSMENT ITEM
		ASSESSMENT_ITEM
		ASSESSMENT_ITEM
		

	
	
		ASSESSMENT ACHIEVED DETAIL
		ASSESSMENT_ACHDET
		ASSESSMENT_ACHDET
		 
	
	
		ASSESSMENT ITEM RESPONSE
		ASSESSMENT_ITEMR
		ASSESSMENT_ITEMR
		 
	
	
		ASSMNT ITEMR ACADEMIC STDS
		ASSMNT_ITEMR_ACADEMIC_STDS
		ASSMNT_ITEMR_ACADEMIC_STDS
		 
	
	
		ASSMNT SUBTEST ACADEMIC STDS
		ASSMNT_SUBTEST_ACADEMIC_STDS
		ASSMNT_SUBTEST_ACADEMIC_STDS
		 
	
	
		ASSESSMENT FACT
		ASSESSMENT_FACT
		ASSESSMENT_FACT
		 
	
	
		ASSESSMENT RESPONSE
		ASSESSMENT_RESP
		ASSESSMENT_RESP
		

	
	
		ASSESSMENT ACC MOD FACT
		ASSMNT_ACCMOD_FACT
		ASSMNT_ACCMOD_FACT
		

	



Sheet 2: ASSESSMENT ACC MOD FACT

	
	
	
	
	
	
	
	
	
	
		ASSESSMENT ACC MOD FACT
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Field Number
		FIELD NAME
		Max Length
		Key field
		Required (Y/N)
		Instructions or Rules
		Format
		Recommended Codes
		Examples
	
	
		1
		DISTRICT CODE
		20
		K,M
		Y
		Public school districts: NYnnnnnn        
(NY followed by the first 6 digits of the BEDS code) 

Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn
(8 followed by the last 7 digits of their Institution code)
		alphanumeric
		For NYSED BEDS codes: www.nysed.gov/admin/bedsdata.html 
For NYSED BEDS and Institution codes:  http://portal.nysed.gov 
Click on “SEDREF Query”
For schools/agencies other than public districts and charters that are required to report these data: http://www.p12.nysed.gov/irs/sirs/
		NY140600
	
	
		2
		TEST DESCRIPTION
		60
		K,M
		Y
		

		

		From Test Description table
		Acuity
	
	
		3
		ASSESSMENT SCHOOL YEAR DATE
		10
		K,M
		Y
		Use June 30 of the reporting school year. Ex: For 2013–14, use 2014-06-30
		date
yyyy-06-30
		

		2013-06-30
	
	
		4
		*SUBTEST IDENTIFIER                            (ASSESSMENT MEASURE STANDARD DESCRIPTION)
		200
		K,M
		Y
		 
		

		See Assessment Item template
		ELA 04 B Spring
	
	
		5
		TEST DATE
		10
		K,M
		Y
		Valid date during school year in which test is administered.
		date
yyyy-mm-dd
		

		2014-04-01
	
	
		6
		STUDENT ID
		12
		K,M
		Y
		Unique identifier assigned by the Local Education Agency (LEA) in which the student is enrolled. Use 9 numeric characters, left padded with zeros.
Ex. For 51972, use 000051972 
		alphanumeric
nnnnnnnnn
		

		123456789
	
	
		7
		SCHOOL YEAR DATE
		10
		

		

		Leave Blank
		

		

		

	
	
		8
		ACCOMMODATION MODIFICATION CODE
		10
		K,M
		Y
		

		

		See Accomodations Table
		01
	
	
		9
		ACC MOD TYPE CODE
		20
		K,M
		Y
		Use ACC
		

		

		ACC
	
	
		10
		ACC OR MOD USED INDICATOR
		3
		

		

		

		

		

		

	
	
		11
		ACC OR MOD IN IEP INDICATOR
		3
		

		

		

		

		

		

	
	
		12
		STUDENT SNAPSHOT DATE
		10
		

		

		

		

		

		

	



Sheet 3: ASSESSMENT ACHIEVED DETAIL

	
	
	
	
	
	
	
	
	
	
		ASSESSMENT ACHIEVED DETAIL
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Field Number
		FIELD NAME
		Max Length
		Key field
		Y=Required 
		Instructions or Rules
		Format
		Recommended Codes
		Example
	
	
		1
		DISTRICT CODE
		20
		K
		Y
		Public school districts: NYnnnnnn        
(NY followed by the first 6 digits of the BEDS code) 

Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn
(8 followed by the last 7 digits of their Institution code)
		alphanumeric
		For NYSED BEDS codes: www.nysed.gov/admin/bedsdata.html 
For NYSED BEDS and Institution codes:  http://portal.nysed.gov 
Click on “SEDREF Query”
For schools/agencies other than public districts and charters that are required to report these data: http://www.p12.nysed.gov/irs/sirs/
		NY140600
	
	
		2
		TEST DESCRIPTION
		60
		K
		Y
		Choose a Test Description from the table provided.
		alphanumeric
		From Test Description table
		Acuity
	
	
		3
		ASSESSMENT SCHOOL YEAR DATE
		10
		K
		Y
		Use June 30 of the reporting school year. Ex: For 2013–14, use 2014-06-30
		date
yyyy-06-30
		

		2013-06-30
	
	
		4
		*SUBTEST IDENTIFIER                            (ASSESSMENT MEASURE STANDARD DESCRIPTION)
		200
		K
		Y
		 
		alphanumeric
		See Assessment Item template
		ELA 04 B Spring
	
	
		5
		STANDARD ACHIEVED CODE
		30
		K
		Y
		 
		alphanumeric
		 
		01
	
	
		6
		STANDARD ACHIEVED
		1024
		

		Y
		

		alphanumeric
		 
		Level 1
	
	
		7
		STANDARD ACHIEVED GROUP
		100
		

		

		

		

		

		

	
	
		8
		START OF RANGE
		12,4
		

		Y
		Start of score range associated with standard achieved.
		numeric
		

		0
	
	
		9
		END OF RANGE
		12,4
		

		Y
		End of score range associated with standard achieved.
		numeric
		

		55
	
	
		10
		STATE PERCENT STUDENTS
		7,2
		

		

		

		

		

		

	
	
		11
		REGION PERCENT STUDENTS
		7,2
		

		

		

		

		

		

	
	
		12
		DISTRICT PERCENT STUDENTS
		7,2
		

		

		

		

		

		

	
	
		13
		STATE BENCHMARK
		7,2
		

		

		

		

		

		

	
	
		14
		REGION BENCHMARK
		7,2
		

		

		

		

		

		

	
	
		15
		DISTRICT BENCHMARK
		7,2
		

		

		

		

		

		

	
	
		16
		SORT SEQUENCE 1
		4,0
		

		

		

		

		

		

	
	
		17
		SORT SEQUENCE 2
		4,0
		

		

		

		

		

		

	
	
		18
		DEFAULT VALUE INDICATOR
		1
		

		

		

		

		

		

	
	
		19
		REPORTING STANDARD ACHIEVED GROUP
		20
		

		

		

		

		

		

	
	
		20
		STANDARD ACHIEVED CODE ASCENDING RANK
		4,0
		

		

		

		

		

		

	
	
		21
		STANDARD ACHIEVED TYPE
		20
		

		Y
		

		alphanumeric
		 
		PRIMARY
	
	
		22
		MET STANDARD INDICATOR
		3

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet index escholar cdwpk v data integration templates description these template s provide layouts and business rules for extracting source in the escholarrequired format name table edm file id changednew assessment item achieved detail achdet response itemr assmnt academic stds subtest fact resp acc mod accmod field number max length key required yn instructions or recommended codes examples district code k m y public school districts nynnnnnn ny followed by first digits of beds charter nonpublic schools state agencies stateoperated child care institutions with nnnnnnn last their institution alphanumeric nysed wwwnysedgovadminbedsdatahtml httpportalnysedgov click on ldquo sedref query rdquo schoolsagencies other than charters that are to report httpwwwpnysedgovirssirs test from acuity year date use june reporting ex ndash dateyyyy identifier measure standard see ela b spring valid during which is administered dateyyyymmdd student unique assigned local education agency lea enrolled n...

Related files

Share

Help

ESCHOLAR CDW-PK12 v15.0 DATA INTEGRATION TEMPLATES


Description
These template(s) provide layouts and business rules for extracting source data in the eScholar-required format

Template Name	Table Name	EDM File ID	Changed/New
ASSESSMENT ITEM	ASSESSMENT_ITEM	ASSESSMENT_ITEM
ASSESSMENT ACHIEVED DETAIL	ASSESSMENT_ACHDET	ASSESSMENT_ACHDET
ASSESSMENT ITEM RESPONSE	ASSESSMENT_ITEMR	ASSESSMENT_ITEMR
ASSMNT ITEMR ACADEMIC STDS	ASSMNT_ITEMR_ACADEMIC_STDS	ASSMNT_ITEMR_ACADEMIC_STDS
ASSMNT SUBTEST ACADEMIC STDS	ASSMNT_SUBTEST_ACADEMIC_STDS	ASSMNT_SUBTEST_ACADEMIC_STDS
ASSESSMENT FACT	ASSESSMENT_FACT	ASSESSMENT_FACT
ASSESSMENT RESPONSE	ASSESSMENT_RESP	ASSESSMENT_RESP
ASSESSMENT ACC MOD FACT	ASSMNT_ACCMOD_FACT	ASSMNT_ACCMOD_FACT

ASSESSMENT ACC MOD FACT

Field Number	FIELD NAME	Max Length	Key field	Required (Y/N)	Instructions or Rules	Format	Recommended Codes	Examples
1	DISTRICT CODE	20	K,M	Y	Public school districts: NYnnnnnn (NY followed by the first 6 digits of the BEDS code) Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn (8 followed by the last 7 digits of their Institution code)	alphanumeric	For NYSED BEDS codes: www.nysed.gov/admin/bedsdata.html For NYSED BEDS and Institution codes: http://portal.nysed.gov Click on “SEDREF Query” For schools/agencies other than public districts and charters that are required to report these data: http://www.p12.nysed.gov/irs/sirs/	NY140600
2	TEST DESCRIPTION	60	K,M	Y			From Test Description table	Acuity
3	ASSESSMENT SCHOOL YEAR DATE	10	K,M	Y	Use June 30 of the reporting school year. Ex: For 2013–14, use 2014-06-30	date yyyy-06-30		2013-06-30
4	*SUBTEST IDENTIFIER (ASSESSMENT MEASURE STANDARD DESCRIPTION)	200	K,M	Y			See Assessment Item template	ELA 04 B Spring
5	TEST DATE	10	K,M	Y	Valid date during school year in which test is administered.	date yyyy-mm-dd		2014-04-01
6	STUDENT ID	12	K,M	Y	Unique identifier assigned by the Local Education Agency (LEA) in which the student is enrolled. Use 9 numeric characters, left padded with zeros. Ex. For 51972, use 000051972	alphanumeric nnnnnnnnn		123456789
7	SCHOOL YEAR DATE	10			Leave Blank
8	ACCOMMODATION MODIFICATION CODE	10	K,M	Y			See Accomodations Table	01
9	ACC MOD TYPE CODE	20	K,M	Y	Use ACC			ACC
10	ACC OR MOD USED INDICATOR	3
11	ACC OR MOD IN IEP INDICATOR	3
12	STUDENT SNAPSHOT DATE	10

ASSESSMENT ACHIEVED DETAIL

Field Number	FIELD NAME	Max Length	Key field	Y=Required	Instructions or Rules	Format	Recommended Codes	Example
1	DISTRICT CODE	20	K	Y	Public school districts: NYnnnnnn (NY followed by the first 6 digits of the BEDS code) Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn (8 followed by the last 7 digits of their Institution code)	alphanumeric	For NYSED BEDS codes: www.nysed.gov/admin/bedsdata.html For NYSED BEDS and Institution codes: http://portal.nysed.gov Click on “SEDREF Query” For schools/agencies other than public districts and charters that are required to report these data: http://www.p12.nysed.gov/irs/sirs/	NY140600
2	TEST DESCRIPTION	60	K	Y	Choose a Test Description from the table provided.	alphanumeric	From Test Description table	Acuity
3	ASSESSMENT SCHOOL YEAR DATE	10	K	Y	Use June 30 of the reporting school year. Ex: For 2013–14, use 2014-06-30	date yyyy-06-30		2013-06-30
4	*SUBTEST IDENTIFIER (ASSESSMENT MEASURE STANDARD DESCRIPTION)	200	K	Y		alphanumeric	See Assessment Item template	ELA 04 B Spring
5	STANDARD ACHIEVED CODE	30	K	Y		alphanumeric		01
6	STANDARD ACHIEVED	1024		Y		alphanumeric		Level 1
7	STANDARD ACHIEVED GROUP	100
8	START OF RANGE	12,4		Y	Start of score range associated with standard achieved.	numeric		0
9	END OF RANGE	12,4		Y	End of score range associated with standard achieved.	numeric		55
10	STATE PERCENT STUDENTS	7,2
11	REGION PERCENT STUDENTS	7,2
12	DISTRICT PERCENT STUDENTS	7,2
13	STATE BENCHMARK	7,2
14	REGION BENCHMARK	7,2
15	DISTRICT BENCHMARK	7,2
16	SORT SEQUENCE 1	4,0
17	SORT SEQUENCE 2	4,0
18	DEFAULT VALUE INDICATOR	1
19	REPORTING STANDARD ACHIEVED GROUP	20
20	STANDARD ACHIEVED CODE ASCENDING RANK	4,0
21	STANDARD ACHIEVED TYPE	20		Y		alphanumeric		PRIMARY
22	MET STANDARD INDICATOR	3

Related files

Share

Share to social media

Help

Login Area