def from_csv(cls, row):
     return cls(
         alternate_bell_code             = row[0],
         course_code                     = row[1],
         course_section                  = row[2],
         created_by_portal_oid           = row[3],
         created_by_task_oid             = row[4],
         created_by_user_oid             = row[5],
         created_ip                      = row[6],
         created_on                      = utils.genesis_to_datetime(row[7]),
         exclued_njsmart                 = utils.genesis_to_boolean(row[8]),
         from_period                     = row[9],
         include_teacher_in_printing     = utils.genesis_to_boolean(row[10]),
         last_updated_by_portal_oid      = row[11],
         last_updated_by_task_oid        = row[12],
         last_updated_by_user_oid        = row[13],
         last_updated_ip                 = row[14],
         last_updated                    = utils.genesis_to_datetime(row[15]),
         meets_cycles                    = row[16],
         print_period                    = row[17],
         report_card_teacher_id          = row[18],
         room_number                     = row[19],
         school_code                     = row[20],
         school_year                     = row[21],
         semester                        = row[22],
         subsection                      = row[23],
         subsection_description          = row[24],
         teacher_id                      = row[25],
         thru_period                     = row[26]
     )
Пример #2
0
 def from_csv(cls, row):
     return cls(course_code=row[0],
                course_section=row[1],
                course_status=row[2],
                course_status_date=utils.genesis_to_date(row[3]),
                created_by_portal_oid=row[4],
                created_by_task_oid=row[5],
                created_by_user_oid=row[6],
                created_ip=row[7],
                created_on=utils.genesis_to_datetime(row[8]),
                last_updated=utils.genesis_to_datetime(row[9]),
                last_updated_by_portal_oid=row[10],
                last_updated_by_task_oid=row[11],
                last_updated_by_user_oid=row[12],
                last_updated_ip=row[13],
                not_dual_credit=utils.genesis_to_boolean(row[14]),
                scheduling_run_code=row[15],
                scheme_code=row[16],
                scheme_locked=utils.genesis_to_boolean(row[17]),
                school_code=row[18],
                school_year=row[19],
                sifid=row[20],
                student_exit_date=utils.genesis_to_date(row[21]),
                student_id=row[22],
                student_start_date=utils.genesis_to_date(row[23]),
                use_in_student_sel_gpa=utils.genesis_to_boolean(row[24]),
                userid=row[25])
 def from_csv(cls, row):
     return cls(age_group_taught=row[0],
                county_code_assigned=row[1],
                created_by_portal_oid=row[2],
                created_by_task_oid=row[3],
                created_by_user_oid=row[4],
                created_ip=row[5],
                created_on=utils.genesis_to_datetime(row[6]),
                credential_type=row[7],
                district_code_assigned=row[8],
                dont_send_to_njsmart=utils.genesis_to_boolean(row[9]),
                full_time_equivalency=row[10],
                hqt_qualification_status=row[11],
                job_code=row[12],
                job_code_subcategory=row[13],
                last_updated_by_portal_oid=row[14],
                last_updated_by_task_oid=row[15],
                last_updated_by_user_oid=row[16],
                last_updated_ip=row[17],
                last_updated=utils.genesis_to_datetime(row[18]),
                number_of_classes_taught=row[19],
                reason_for_not_being_hq=row[20],
                role_seq=row[21],
                school_code_assigned=row[22],
                school_year=row[23],
                support_to_being_hq=row[24],
                teacher_id=row[25],
                teacher_prep=row[26])
Пример #4
0
 def from_csv(cls, row):
     return cls(
         counselor_id=row[0],
         created_by_portal_oid=row[1],
         created_by_task_oid=row[2],
         created_by_user_oid=row[3],
         created_ip=row[4],
         created_on=utils.genesis_to_datetime(row[5]),
         drop_from_scheduling=utils.genesis_to_boolean(row[6]),
         entry_code=row[7],
         gradeLevel=row[8],
         homeroom=row[9],
         last_updated_by_portal_oid=row[10],
         last_updated_by_task_oid=row[11],
         last_updated_by_user_oid=row[12],
         last_updated_ip=row[13],
         last_updated=utils.genesis_to_datetime(row[14]),
         note=row[15],
         pre_instruction_day1_withdraw_code=row[16],
         pre_instruction_day1_withdraw_school=row[17],
         pre_instruction_day2_entry_code=row[18],
         program_type_code=row[19],
         promote=utils.genesis_to_boolean(row[20]),
         schedule_locked=utils.genesis_to_boolean(row[21]),
         scheduling_group=row[22],
         scheduling_priority=row[23],
         school_code=row[24],
         school_code_set_by_school_mint=utils.genesis_to_boolean(row[25]),
         school_year=row[26],
         session=row[27],
         student_id=row[28],
         team_code=row[29],
         transferred_to_county=row[30],
         transferred_to_district=row[31],
         transferred_to_first_day_attendance=utils.genesis_to_date(row[32]),
         transferred_to_school=row[33],
         withdrawal_reason_code=row[34],
     )
Пример #5
0
 def from_csv(cls, row):
     return cls(attendance_homeroom=row[0],
                basic_skills_teacher=utils.genesis_to_boolean(row[1]),
                created_by_portal_oid=row[2],
                created_by_task_oid=row[3],
                created_by_user_oid=row[4],
                created_ip=row[5],
                created_on=utils.genesis_to_datetime(row[6]),
                current_homeroom=row[7],
                department_code=row[8],
                department_head=utils.genesis_to_boolean(row[9]),
                elem_comment_seq=row[10],
                builder_does_not_req_lunch=utils.genesis_to_boolean(
                    row[11]),
                grade_level=row[12],
                last_updated_by_portal_oid=row[13],
                last_updated_by_task_oid=row[14],
                last_updated_by_user_oid=row[15],
                last_updated_ip=row[16],
                last_updated=utils.genesis_to_datetime(row[17]),
                mail_location_code=row[18],
                max_periods_day=row[19],
                max_seq_periods=row[20],
                max_students_in_class=row[21],
                max_students_per_day=row[22],
                min_periods_day=row[23],
                next_homeroom=row[24],
                percent_of_time_in_school=row[25],
                preferred_room=row[26],
                primary_school_assignment=utils.genesis_to_boolean(row[27]),
                school_code=row[28],
                school_year=row[29],
                teacher_seq=row[30],
                sif_id=row[31],
                special_subject_teacher=utils.genesis_to_boolean(row[32]),
                teacher_id=row[33],
                team_code=row[34])
 def from_csv(cls, row):
     return cls(active=utils.genesis_to_boolean(row[0]),
                course_code=row[1],
                course_id=row[2],
                course_section=row[3],
                created_by_portal_oid=row[4],
                created_by_task_oid=row[5],
                created_by_user_oid=row[6],
                created_ip=row[7],
                created_on=utils.genesis_to_datetime(row[8]),
                default_set_code=row[9],
                default_subject_code=row[10],
                department_code=row[11],
                description=row[12],
                gb_description=row[13],
                hide_gradebook=utils.genesis_to_boolean(row[14]),
                last_accessed=utils.genesis_to_datetime(row[15]),
                last_accessed_by=row[16],
                last_updated_by_portal_oid=row[17],
                last_updated_by_task_oid=row[18],
                last_updated_by_user_oid=row[19],
                last_updated_ip=row[20],
                last_updated=utils.genesis_to_datetime(row[21]),
                locked_mp_grades=row[22],
                meets_cycles=row[23],
                merged=utils.genesis_to_boolean(row[24]),
                merged_by=row[25],
                merged_date=utils.genesis_to_datetime(row[26]),
                print_periods=row[27],
                profile_code=row[28],
                rooms=row[29],
                school_code=row[30],
                school_year=row[31],
                semester=row[32],
                seq=row[33],
                teacher_id=row[34])
Пример #7
0
 def from_csv(cls, row):
     return cls(assigned_seats=row[0],
                attendance_taken=utils.genesis_to_boolean(row[1]),
                available_seats=row[2],
                beginning_seats=row[3],
                course_code=row[4],
                course_section=row[5],
                created_by_portal_oid=row[6],
                created_by_task_oid=row[7],
                created_by_user_oid=row[8],
                created_ip=row[9],
                created_on=utils.genesis_to_datetime(row[10]),
                cycle_code=row[11],
                cycle_set=row[12],
                fg_collected_in=row[13],
                gpa_weight=row[14],
                gpa_weight_code=row[15],
                graded_course=utils.genesis_to_boolean(row[16]),
                homeroom=row[17],
                include_in_gpa=utils.genesis_to_boolean(row[18]),
                include_in_honor_roll=utils.genesis_to_boolean(row[19]),
                include_on_transcript=utils.genesis_to_boolean(row[20]),
                instruction_type_code=row[21],
                last_updated_by_portal_oid=row[22],
                last_updated_by_task_oid=row[23],
                last_updated_by_user_oid=row[24],
                last_updated_ip=row[25],
                last_updated=utils.genesis_to_datetime(row[26]),
                legacy_course_code=row[27],
                legacy_course_section=row[28],
                mp_credits=utils.genesis_to_nullable_float(row[29]),
                next_gen_class=row[30],
                override_seats=row[31],
                parcc_test_code=row[32],
                receiving_school=row[33],
                sced_course_code=row[34],
                sced_course_level=row[35],
                sced_grade_span=row[36],
                sced_sequence=row[37],
                schedule_description=row[38],
                scheduling_shift=row[39],
                school_code=row[40],
                school_year=row[41],
                shared_class=row[42],
                skill_group=row[43],
                suppress_from_report_card=utils.genesis_to_boolean(row[44]),
                team_code=row[45],
                total_mp_grades_collected=row[46],
                transcript_description=row[47],
                use_in_parcc=utils.genesis_to_boolean(row[48]))
 def from_csv(cls, row):
     return cls(
         carry_over_record=utils.genesis_to_boolean(row[0]),
         created_by_portal_oid=row[1],
         created_by_task_oid=row[2],
         created_by_user_oid=row[3],
         created_ip=row[4],
         created_on=utils.genesis_to_datetime(row[5]),
         elig_letter_printed=utils.genesis_to_date(row[6]),
         end_date=utils.genesis_to_date(row[7]),
         last_updated_by_portal_oid=row[8],
         last_updated_by_task_oid=row[9],
         last_updated_by_user_oid=row[10],
         last_updated_ip=row[11],
         last_updated=utils.genesis_to_datetime(row[12]),
         lunch_code=row[13],
         objectid=row[14],
         school_year=row[15],
         start_date=utils.genesis_to_date(row[16]),
         student_id=row[17],
     )
 def from_csv(cls, row):
     return cls(
         school_year                = row[0],
         school_code                = row[1],
         code                       = row[2],
         description                = row[3],
         end_date                   = utils.genesis_to_date(row[4]),
         gb_description             = row[5],
         read_only                  = utils.genesis_to_boolean(row[6]),
         seq                        = row[7],
         sifid                      = row[8],
         start_date                 = utils.genesis_to_date(row[9]),
         cycle_type                 = row[10],
         created_by_portal_OID      = row[11],
         created_by_task_OID        = row[12],
         created_by_user_OID        = row[13],
         created_ip                 = row[14],
         created_on                 = utils.genesis_to_datetime(row[15]),
         last_updated_by_portal_OID = row[16],
         last_updated_by_task_OID   = row[17],
         last_updated_by_user_OID   = row[18],
         last_updated_ip            = row[19],
         last_updated_on            = utils.genesis_to_datetime(row[20]),
     )
 def from_csv(cls, row):
     return cls(teacher_address1=row[0],
                teacher_address2=row[1],
                is_admin=utils.genesis_to_boolean(row[2]),
                alt_route_program=row[3],
                teacher_area_code=row[4],
                is_athletic_trainer=utils.genesis_to_boolean(row[5]),
                case_manager=utils.genesis_to_boolean(row[6]),
                teacher_cell_phone=row[7],
                certification_status=utils.genesis_to_boolean(row[8]),
                teacher_city=row[9],
                coordinator_504=utils.genesis_to_boolean(row[10]),
                counselor_id=row[11],
                counselor_name=row[12],
                country_code=row[13],
                county_code=row[14],
                created_by_portal_oid=row[15],
                created_by_task_oid=row[16],
                created_by_user_oid=row[17],
                created_ip=row[18],
                created_on=utils.genesis_to_datetime(row[19]),
                data_1=row[20],
                date_of_birth=utils.genesis_to_date(row[21]),
                is_disciplinarian=utils.genesis_to_boolean(row[22]),
                do_not_export_schoolfi=utils.genesis_to_boolean(row[23]),
                do_not_import_lastname=utils.genesis_to_boolean(row[24]),
                teacher_email=row[25],
                employment_status=row[26],
                ethnicity=utils.genesis_to_boolean(row[27]),
                evaluation_of_staff=row[28],
                exceptional_salary=row[29],
                exclude_from_auto_dialer=utils.genesis_to_boolean(row[30]),
                teacher_first_name=row[31],
                former_name=row[32],
                gender_code=row[33],
                highest_ed_completed=row[34],
                home_phone_listed=utils.genesis_to_boolean(row[35]),
                teacher_homework_url=row[36],
                include_in_njsmart=utils.genesis_to_boolean(row[37]),
                spoken_language=row[38],
                teacher_last_name=row[39],
                last_updated_by_portal_oid=row[40],
                last_updated_by_task_oid=row[41],
                last_updated_by_user_oid=row[42],
                last_updated_ip=row[43],
                last_updated=utils.genesis_to_datetime(row[44]),
                lep_instructor_cred_type=row[45],
                is_library=utils.genesis_to_boolean(row[46]),
                is_long_term_substitute=utils.genesis_to_boolean(row[47]),
                mep_session_type=row[48],
                teacher_middle_name=row[49],
                migrant_ed_prg_staff_cat=row[50],
                teacher_name=row[51],
                national_board_award=utils.genesis_to_date(row[52]),
                njsmart_sub_teacher_id=row[53],
                notes=row[54],
                is_nurse=utils.genesis_to_boolean(row[55]),
                other_id_number=row[56],
                other_staff_member=utils.genesis_to_boolean(row[57]),
                prefix_code=row[58],
                is_principal=utils.genesis_to_boolean(row[59]),
                race_american_indian=utils.genesis_to_boolean(row[60]),
                race_asian=utils.genesis_to_boolean(row[61]),
                race_black=utils.genesis_to_boolean(row[62]),
                race_pacific=utils.genesis_to_boolean(row[63]),
                race_white=utils.genesis_to_boolean(row[64]),
                related_service_provider=utils.genesis_to_boolean(row[65]),
                resource_teacher=utils.genesis_to_boolean(row[66]),
                salary=row[67],
                school_year=row[68],
                sep_prg_contr_service_cat=row[69],
                shared_teacher=utils.genesis_to_boolean(row[70]),
                shared_teacher_id_1=row[71],
                shared_teacher_id_2=row[72],
                shared_teacher_id_3=row[73],
                shared_teacher_id_4=row[74],
                shared_teacher_id_5=row[75],
                shared_teacher_id_6=row[76],
                sif_id=row[77],
                signature=row[78],
                signature_title=row[79],
                spec_ed_team=row[80],
                teacher_soc_sec_number=row[81],
                state_code=row[82],
                state_id_number=row[83],
                suffix_code=row[84],
                teacher=utils.genesis_to_boolean(row[85]),
                teacher_code=row[86],
                teacher_id=row[87],
                teacher_url=row[88],
                teacher_telephone_exchange=row[89],
                teacher_telephone_number=row[90],
                title_i_prg_staff_cat=row[91],
                prep_program=row[92],
                is_viceprincipal=utils.genesis_to_boolean(row[93]),
                teacher_voice_mail=row[94],
                years_in_lea=row[95],
                years_in_nj=row[96],
                years_of_prior_exp=row[97],
                teacher_zipcode=row[98])
Пример #11
0
 def from_csv(cls, row):
     return cls(
         categorical=utils.genesis_to_boolean(row[0]),
         code=row[1],
         created_by_portal_oid=row[2],
         created_by_task_oid=row[3],
         created_by_user_oid=row[4],
         created_ip=row[5],
         created_on=utils.genesis_to_datetime(row[6]),
         dc_foster=utils.genesis_to_boolean(row[7]),
         dc_SNAP=utils.genesis_to_boolean(row[8]),
         dc_TANF=utils.genesis_to_boolean(row[9]),
         denied=utils.genesis_to_boolean(row[10]),
         description=row[11],
         direct_certification=utils.genesis_to_boolean(row[12]),
         foster_letter=utils.genesis_to_boolean(row[13]),
         free=utils.genesis_to_boolean(row[14]),
         free_foster=utils.genesis_to_boolean(row[15]),
         free_income=utils.genesis_to_boolean(row[16]),
         free_tanf=utils.genesis_to_boolean(row[17]),
         head_start_or_local_official=utils.genesis_to_boolean(row[18]),
         hide_on_application=utils.genesis_to_boolean(row[19]),
         ignore=utils.genesis_to_boolean(row[20]),
         incomplete=utils.genesis_to_boolean(row[21]),
         last_updated_by_portal_oid=row[22],
         last_updated_by_task_oid=row[23],
         last_updated_by_user_oid=row[24],
         last_updated_ip=row[25],
         last_updated=utils.genesis_to_datetime(row[26]),
         reduced=utils.genesis_to_boolean(row[27]),
         school_year=row[28],
         seq=row[29],
     )
 def from_csv(cls, row):
     return cls(
         is_academic=utils.genesis_to_boolean(row[0]),
         accelerated=utils.genesis_to_boolean(row[1]),
         advanced_level=utils.genesis_to_boolean(row[2]),
         advanced_placement_course=utils.genesis_to_boolean(row[3]),
         assign_room=utils.genesis_to_boolean(row[4]),
         assign_teacher=utils.genesis_to_boolean(row[5]),
         attendance_taken=utils.genesis_to_boolean(row[6]),
         biology_type=row[7],
         cip_code=row[8],
         collects_comments=utils.genesis_to_boolean(row[9]),
         collects_overall_grade=utils.genesis_to_boolean(row[10]),
         college_prep_course=utils.genesis_to_boolean(row[11]),
         core_course_flag=row[12],
         core_subject=row[13],
         course_active=utils.genesis_to_boolean(row[14]),
         course_adoption_date=utils.genesis_to_date(row[15]),
         course_catalog_description=row[16],
         course_code=row[17],
         course_credits=row[18],
         course_curriculum=row[19],
         course_description=row[20],
         course_length=row[21],
         course_level=row[22],
         course_level_code=row[23],
         course_req_subject_area_code=row[24],
         course_type=row[25],
         crdc_classification=row[26],
         created_by_portal_oid=row[27],
         created_by_task_oid=row[28],
         created_by_user_oid=row[29],
         created_ip=row[30],
         created_on=utils.genesis_to_datetime(row[31]),
         curriculum_adoption_date=utils.genesis_to_date(row[32]),
         custom_data_1=row[33],
         cycle_set=row[34],
         default_seats=row[35],
         department_code=row[36],
         display_in_parents_as_gb=utils.genesis_to_boolean(row[37]),
         display_in_parents_schedgrade=utils.genesis_to_boolean(row[38]),
         is_elective=utils.genesis_to_boolean(row[39]),
         elementary_course=utils.genesis_to_boolean(row[40]),
         elem_fg_skill_code=row[41],
         exclude_from_njsmart=utils.genesis_to_boolean(row[42]),
         course_flag1=utils.genesis_to_boolean(row[43]),
         course_flag2=utils.genesis_to_boolean(row[44]),
         course_flag3=utils.genesis_to_boolean(row[45]),
         course_flag4=utils.genesis_to_boolean(row[46]),
         global_course_alternate=row[47],
         gpa_level=row[48],
         gpa_weight=row[49],
         gpa_weight_alpha=row[50],
         gpa_weight_code=row[51],
         gpa_weight_code_alpha=row[52],
         gpa_weight_code_numeric=row[53],
         gpa_weight_numeric=row[54],
         graded_course=utils.genesis_to_boolean(row[55]),
         health_course_code=row[56],
         honors_course=utils.genesis_to_boolean(row[57]),
         ignore_sced_for_parcc=utils.genesis_to_boolean(row[58]),
         ignore_restrictions=utils.genesis_to_boolean(row[59]),
         include_in_gpa=utils.genesis_to_boolean(row[60]),
         include_in_honor_roll=utils.genesis_to_boolean(row[61]),
         include_on_transcript=utils.genesis_to_boolean(row[62]),
         inclusion_course_code_link=row[63],
         inclusion_course_option=row[64],
         instruction_type_code=row[65],
         lab_before_or_after=utils.genesis_to_boolean(row[66]),
         last_updated_by_portal_oid=row[67],
         last_updated_by_task_oid=row[68],
         last_updated_by_user_oid=row[69],
         last_updated_ip=row[70],
         last_updated=utils.genesis_to_datetime(row[71]),
         legacy_course_code=row[72],
         linked_sem_course_sections=utils.genesis_to_boolean(row[73]),
         linked_sem_courses=row[74],
         lunch_flag=utils.genesis_to_boolean(row[75]),
         max_requests=row[76],
         maximum_seats=row[77],
         minutes_per_week=row[78],
         ncaa_core_course=utils.genesis_to_boolean(row[79]),
         next_course_code=row[80],
         next_school_code=row[81],
         num_days_for_course=row[82],
         num_days_for_lab=row[83],
         num_sections=row[84],
         parents_can_request=utils.genesis_to_boolean(row[85]),
         periods_per_day=row[86],
         phys_ed_course=utils.genesis_to_boolean(row[87]),
         planned_eval_date=utils.genesis_to_date(row[88]),
         pre_requisites=utils.genesis_to_boolean(row[89]),
         pre_sec_sced_course_code=row[90],
         primary_subject_area_code=row[91],
         readoption_date=utils.genesis_to_date(row[92]),
         sced_course_code=row[93],
         sced_course_level=row[94],
         sced_grade_span=row[95],
         sced_sequence=row[96],
         scheduling_priority=row[97],
         school_code=row[98],
         school_year=row[99],
         secondary_subject_area_code=row[100],
         sem_avail=row[101],
         short_description=row[102],
         sif_id=row[103],
         sif_subject_area=row[104],
         sif_subject_area2=row[105],
         skill_group=row[106],
         special_ed_course=utils.genesis_to_boolean(row[107]),
         special_program_desc=row[108],
         state_course_code=row[109],
         state_test_1=row[110],
         state_test_2=row[111],
         study_hall_flag=utils.genesis_to_boolean(row[112]),
         team_code=row[113],
         tech_prep=utils.genesis_to_boolean(row[114]))
Пример #13
0
 def from_csv(cls, row):
     return cls(
         daily_to_post_class=utils.genesis_to_boolean(row[0]),
         hr_to_post_daily=utils.genesis_to_boolean(row[1]),
         allow_hr_prop_emails=utils.genesis_to_boolean(row[2]),
         allow_hr_update=utils.genesis_to_boolean(row[3]),
         period_to_overwrite_section=utils.genesis_to_boolean(row[4]),
         prior_date_hr_to_post_daily=utils.genesis_to_boolean(row[5]),
         allow_gb_update_all_grades=utils.genesis_to_boolean(row[6]),
         allow_gb_update_fg=utils.genesis_to_boolean(row[7]),
         alternate_code=row[8],
         is_alternate_program=utils.genesis_to_boolean(row[9]),
         building_code=row[10],
         ceeb_code=row[11],
         is_charter_school=utils.genesis_to_boolean(row[12]),
         is_choice=utils.genesis_to_boolean(row[13]),
         collect_ood_nj_smart_students=utils.genesis_to_boolean(row[14]),
         school_count_students=utils.genesis_to_boolean(row[15]),
         created_by_portal_oid=row[16],
         created_by_task_oid=row[17],
         created_by_user_oid=row[18],
         created_ip=row[19],
         created_on=utils.genesis_to_datetime(row[20]),
         default_schedule_view=row[21],
         is_esy_school=utils.genesis_to_boolean(row[22]),
         exclude_prek_njsmart_state=utils.genesis_to_boolean(row[23]),
         exclude_reged_prek_njsmart=utils.genesis_to_boolean(row[24]),
         excluded_school_from_njassa=utils.genesis_to_boolean(row[25]),
         excluded_school_from_njsmart=utils.genesis_to_boolean(row[26]),
         excluded_from_state_sped=utils.genesis_to_boolean(row[27]),
         fall_eligibility_credits=row[28],
         fall_eligibility_cred2014=row[29],
         federal_school_code=row[30],
         for_parents_module=utils.genesis_to_boolean(row[31]),
         gen_pins_on_registration=utils.genesis_to_boolean(row[32]),
         schedule_print_hide_bus=utils.genesis_to_boolean(row[33]),
         highlight_dup_requests=utils.genesis_to_boolean(row[34]),
         honor_rolls=row[35],
         hr_assignment_type=row[36],
         hr_period=row[37],
         hr_period2=row[38],
         hr_period3=row[39],
         is_inact=utils.genesis_to_boolean(row[40]),
         in_district=utils.genesis_to_boolean(row[41]),
         word_day_in_bell=utils.genesis_to_boolean(row[42]),
         keep_x_ny_sched_runs=row[43],
         last_updated_by_portal_oid=row[44],
         last_updated_by_task_oid=row[45],
         last_updated_by_user_oid=row[46],
         last_updated_ip=row[47],
         last_updated=utils.genesis_to_datetime(row[48]),
         locker_combination_cycle=row[49],
         lock_hr_class_from_daily_prop=utils.genesis_to_boolean(row[50]),
         non_public_school=utils.genesis_to_boolean(row[51]),
         override_password=row[52],
         pre_eval_school=utils.genesis_to_boolean(row[53]),
         is_prereg=utils.genesis_to_boolean(row[54]),
         prereg_school_code=row[55],
         school_primary_color=row[56],
         is_private_school_disabled=utils.genesis_to_boolean(row[57]),
         regional_hs=utils.genesis_to_boolean(row[58]),
         rollover_ny_couns=utils.genesis_to_boolean(row[59]),
         rollover_ny_hr=utils.genesis_to_boolean(row[60]),
         rollover_home_school=utils.genesis_to_boolean(row[61]),
         rollover_res_school=utils.genesis_to_boolean(row[62]),
         rollover_set_grad_date=utils.genesis_to_boolean(row[63]),
         schedule_cycle_days=row[64],
         schedule_cycle_days2=row[65],
         schedule_cycle_naming=row[66],
         schedule_cycle_naming2=row[67],
         school_address1=row[68],
         school_address2=row[69],
         school_city=row[70],
         state_code=row[71],
         school_zipcode=row[72],
         school_category=row[73],
         school_code=row[74],
         school_contact_name=row[75],
         school_description=row[76],
         school_email=row[77],
         school_end_date=utils.genesis_to_date(row[78]),
         school_is_copy_of=row[79],
         school_name=row[80],
         school_number=row[81],
         school_office_ext=row[82],
         school_office_fax=row[83],
         school_office_phone=row[84],
         school_principal=row[85],
         school_principal_email=row[86],
         school_principal_ext=row[87],
         school_principal_fax=row[88],
         school_principal_phone=row[89],
         school_special_designation=row[90],
         school_start_date=utils.genesis_to_date(row[91]),
         school_sys_admin=row[92],
         school_sys_admin_email=row[93],
         school_sys_admin_ext=row[94],
         school_sys_admin_fax=row[95],
         school_sys_admin_phone=row[96],
         school_type_code=row[97],
         school_url=row[98],
         school_year=row[99],
         school_secondary_color=row[100],
         school_seq=row[101],
         all_schools_on_bell=utils.genesis_to_boolean(row[102]),
         show_gb_district_proj_fg=utils.genesis_to_boolean(row[103]),
         show_gb_projected_fg=utils.genesis_to_boolean(row[104]),
         sif_id=row[105],
         speced_readonly=utils.genesis_to_boolean(row[106]),
         spring_eligibility_credits=row[107],
         spring_eligibility_cred2014=row[108],
         state_county_code=row[109],
         state_district_code=row[110],
         state_school_code=row[111],
         student_id_counter=row[112],
         student_pass_distribution=row[113],
         att_checkin_pass_location=row[114],
         att_checkin_pass=utils.genesis_to_boolean(row[115]),
         student_pass_sort=row[116],
         att_checkin_pass_reason=row[117],
         student_sched_by_sem=utils.genesis_to_boolean(row[118]),
         is_summer_school=utils.genesis_to_boolean(row[119]),
         title_1_school=utils.genesis_to_boolean(row[120]),
         transcript_school_code=row[121],
         random_bell_times=utils.genesis_to_boolean(row[122]),
         update_hr_from_sched_screen=utils.genesis_to_boolean(row[123]),
         use_gb_grade_for_auto_calc=utils.genesis_to_boolean(row[124]),
         use_homeschool_assa=utils.genesis_to_boolean(row[125]),
         att_checkin_use_minipass=utils.genesis_to_boolean(row[126]),
         use_subsection_descriptions=utils.genesis_to_boolean(row[127]),
         is_vocational=utils.genesis_to_boolean(row[128]))