Fair Student Funding Budget Detail 2
City of New York
@usgov.city_of_new_york_fair_student_funding_budget_detail_2
City of New York
@usgov.city_of_new_york_fair_student_funding_budget_detail_2
Fair Student Funding Budget Detail FY 2015 - Part II This detail data contains one row for each school's data and calculations displayed on the Details screen starting from the "TOTAL FAIR STUDENT FUNDING WEIGHTED REGISTER AND FORMULA" to the bottom of the page.
Click Here for further information- http://schools.nyc.gov/offices/d_chanc_oper/budget/dbor/allocationmemo/fy14_15/Fair_School_Funding_FY2015.html
Organization: City of New York
Last updated: 2020-11-10T17:04:22.702876
CREATE TABLE table_1 (
"fiscal_year" BIGINT,
"location" VARCHAR,
"total_column_n_fy14_actual_registers" DOUBLE -- Total Column N: FY14 Actual Registers,
"total_column_o_projected_register" DOUBLE -- Total Column O: Projected Register,
"total_column_p_projected_formula" DOUBLE -- Total Column P: Projected Formula,
"total_column_q_register_change" DOUBLE -- Total Column Q: Register Change,
"total_column_r_register_dollar_change" DOUBLE -- Total Column R: Register Dollar Change,
"weighted_register" DOUBLE,
"system_wide_teacher_salary_growth" DOUBLE,
"label_g_teacher_salary_growth" DOUBLE -- Label G: Teacher Salary Growth,
"foundation" DOUBLE,
"label_j_fy15_fair_student_formula_at_100" DOUBLE -- Label J: FY15 Fair Student Formula At 100%,
"label_a_fy14_revised_based_allocations" DOUBLE -- Label A: FY14 Revised Based Allocations,
"label_s_fair_student_funding_register_formula" DOUBLE -- Label S: Fair Student Funding Register Formula,
"label_t_change_to_preliminary_fair_student_funding_per_8625096c" DOUBLE -- Label T: Change To Preliminary Fair Student Funding Percentage Capped At 100%,
"label_f_register_change_allocation_based_on_school_s_p_7342a06f" DOUBLE -- Label F: Register Change Allocation Based On School's Percent Of Formula,
"label_g_teacher_salary_growth_2" DOUBLE -- Label G: Teacher Salary Growth 2,
"label_h_foundation_for_new_schools" DOUBLE -- Label H: Foundation For New Schools,
"label_d_initial_fair_student_funding_allocations_total" DOUBLE -- Label D: Initial Fair Student Funding Allocations Total,
"calculation_j_initial_fair_student_funding_allocations_total" DOUBLE -- Calculation J: Initial Fair Student Funding Allocations Total,
"calculation_j_foundation" DOUBLE -- Calculation J: Foundation,
"label_w_final_school_fsf_percent" DOUBLE -- Label W: Final School FSF Percent,
"calculation_j_fsf_formula_at_100" DOUBLE -- Calculation J: FSF Formula At 100%,
"as_of_date" VARCHAR
);
Anyone who has the link will be able to view this.