SIS Handbook | Database Table SchemaProfessional Development

Main Overview Data Submission Cycles Cycle Reports Data Sources Database Table Schema Previous Table Schema Appendices Handbook Changes Handbook Downloads

Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'staff_dev'

Professional Development (PD)

[staff_dev]

ID	Element	Name	Type	Size	Values	Cycle
	Key
PD0010	Fiscal Year - The fiscal year that this reporting represents: For the 2024-2025 reporting year fy must be = 35	fy	Num	2	Table	8
PD0020	Cycle - The reporting cycle for which the data is submitted: 8 = July 31^st	cycle	Num	2	Table	8
PD0030	LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example: 6001002 60 = Pulaski County 01 = Little Rock School District 002 = Hall High School	lea	Alpha	7	Appendix C	8
PD0040	Social Security Number - This is the social security number for the teacher or superintendent ADE assigned number designated to a course for identification purposes.	ssn	Alpha	9	#########	8
	General
PD0050	State Reporting ID, Staff - The unique 10-digit Triand identifier generated for the teacher by the state.	uniq_emp_id	Alpha	10	######## ##	8
PD0060	Job Type - The type of job performed by the employee. A = Full Time Administrator T =Teacher or Part Time Administrator	job_type	Alpha	1		8
PD0070	Professional Development Hours, Total - Has this person completed 60 or more hours of professional development inclusive of the required areas of professional development while employed as either a teacher or administrator?	profdev_hr	Dec	5,2	##.##	8

No change

Added

Modified

Deleted