Plugin Change History: Base Plugin 1 - DB Extension plugin

As of January 1, 2023 plugin versions will now be in YY.MM.DD format to allow you to know when the plugin was completed.

The Base1 plugin contains only the DataBase Extensions (DBx). These are separate as the plugin enable process will fail if the PowerQuery attempts to reference a DBx that has not been installed yet. In the plugin enable process PQs are enabled prior to DBx so when they are in the same plugin they always fail.

Base Plugin 1 can be deleted and reinstalled OR you may use the update button to update to the latest version.

Base 2 Change History
Current Version for Download

V24.11.08 (future)

  • U_BA_Filters
    • Add balance_include_positive as BOOLEAN

V24.09.17

  • U_BA_Filters
    • Add data_source_pw_pdf_hint as STRING(4000)
    • Add data_source_lang_pp as INTEGER
    • Add data_source_lang_std_pp as INTEGER
    • Add custody_rm_da as BOOLEAN
    • Add alt_custody_rm_da as BOOLEAN
  • U_BA_MSGFIELDS
    • Add home_phone_v as BOOLEAN
    • Add home_phone_t as BOOLEAN
    • Add mother_home_phone_v as BOOLEAN
    • Add mother_home_phone_t as BOOLEAN
    • Add motherdayphone_v as BOOLEAN
    • Add motherdayphone_t as BOOLEAN
    • Add father_home_phone_v as BOOLEAN
    • Add father_home_phone_t as BOOLEAN
    • Add fatherdayphone_v as BOOLEAN
    • Add fatherdayphone_t as BOOLEAN
    • Add guardiandayphone_v as BOOLEAN
    • Add guardiandayphone_t as BOOLEAN
    • Add emerg_phone_1_v as BOOLEAN
    • Add emerg_phone_1_t as BOOLEAN
    • Add emerg_phone_2_v as BOOLEAN
    • Add emerg_phone_2_t as BOOLEAN
    • Add emerg_3_phone_v as BOOLEAN
    • Add emerg_3_phone_t as BOOLEAN
    • Add custom_phone1_v as BOOLEAN
    • Add custom_phone1_t as BOOLEAN
    • Add custom_phone2_v as BOOLEAN
    • Add custom_phone2_t as BOOLEAN
    • Add custom_phone3_v as BOOLEAN
    • Add custom_phone3_t as BOOLEAN
    • Add custom_student_phone1_v as BOOLEAN
    • Add custom_student_phone1_t as BOOLEAN

V24.08.13

  • U_BA_Filters
    • Add exclude_users_ba_addphone01 as BOOLEAN
  • U_BA_MSGFIELDS_USERS
    • Add additional_phone_01 as STRING(15)
    • Add additional_phone_01_v as BOOLEAN
    • Add additional_phone_01_t as BOOLEAN

V24.04.19

  • U_BA_Filters
    • Add trans_enabled as BOOLEAN
    • Add trans_hours_b4_midnight as INTEGER

V24.02.09

  • U_BA_Filters
    • Add include_cc_schools as BOOLEAN
    • Add include_transferred as BOOLEAN
    • Add include_graduated as BOOLEAN
    • Add fee_include_transferred as BOOLEAN
    • Add fee_include_graduated as BOOLEAN
  • U_BA_MSGFIELDS
    • Add exclude_fees as BOOLEAN

V24.01.18

  • U_BA_Filters
    • Add schoolpickup as BOOLEAN
    • Add caregiver as BOOLEAN
    • Add volunteer as BOOLEAN
    • Add classroom_participation as BOOLEAN
    • Add primary_contact as BOOLEAN
    • Add excludefromstatereporting as BOOLEAN
    • Add generalcomm as BOOLEAN
    • Add confidentialcomm as BOOLEAN
    • Add alt_schoolpickup as BOOLEAN
    • Add alt_caregiver as BOOLEAN
    • Add alt_volunteer as BOOLEAN
    • Add alt_classroom_participation as BOOLEAN
    • Add alt_primary_contact as BOOLEAN
    • Add alt_excludefromstatereporting as BOOLEAN
    • Add alt_generalcomm as BOOLEAN
    • Add alt_confidentialcomm as BOOLEAN
  • U_BA_MSGFIELDS
    • Add exclude_balance1 as BOOLEAN

V23.12.21

  • U_BA_Filters
    • Add exclude_guardiandayphone as BOOLEAN
    • Add exclude_emerg_phone1 as BOOLEAN
    • Add exclude_emerg_phone2 as BOOLEAN
    • Add exclude_emerg_phone3 as BOOLEAN
    • Add include_users_emergency as INTEGER
    • Add discipline_incidentMangement as BOOLEAN
  • U_BA_MSGFIELDS_DOR
    • Add topic as STRING(1000)
    • Add fname as STRING(50)
    • Add lname as STRING(50)
    • Add phone as STRING(15)
    • Add phone_v as BOOLEAN
    • Add phone_t as BOOLEAN
    • Add email as STRING(100)
    • Remove add_emails_dor

V23.11.07

  • U_BA_Filters
    • Add legal_guardian as BOOLEAN
    • Add custody_lg as BOOLEAN
    • Add lw_lg as BOOLEAN
    • Add rm_lg as BOOLEAN
    • Add e_lg as BOOLEAN
    • Add da_lg as BOOLEAN
    • Add custody_lw_lg as BOOLEAN
    • Add alt_llegal_guardian as BOOLEAN
    • Add alt_lcustody_lg as BOOLEAN
    • Add alt_llw_lg as BOOLEAN
    • Add alt_lrm_lg as BOOLEAN
    • Add alt_le_lg as BOOLEAN
    • Add alt_lda_lg as BOOLEAN
    • Add alt_lcustody_lw_lg as BOOLEAN
  • U_BA_MSGFIELDS
    • Add exclude_weather as BOOLEAN
    • Add exclude_emergency as BOOLEAN
  • U_BA_MSGFIELDS_SCHOOLS
    • Add add_emails_enroll_school as STRING(4000)
    • Add include_parents as BOOLEAN
    • Add include_students as BOOLEAN
    • Add include_staff as BOOLEAN
  • U_BA_MSGFIELDS_DOR
    • Add schoolid as INTEGER
    • Add dor as STRING(40)
    • Add add_emails_dor as STRING(4000)
    • Add include_parents as BOOLEAN
    • Add include_students as BOOLEAN
    • Add include_staff as BOOLEAN

V23.10.14

  • U_BA_Filters
    • Add att_tchr_exclude_cotchr as BOOLEAN

V23.09.14

  • U_BA_FILTERS
    • Add phone_types_voice as INTEGER
    • Add phone_types_text as INTEGER
    • Add alt_phone_types_voice as INTEGER
    • Add alt_phone_types_text as INTEGER
    • Add student_phone_types_voice as INTEGER
    • Add student_phone_types_text as INTEGER
    • Add att_tchr_enabled as BOOLEAN
    • Add att_cur_enabled as BOOLEAN
    • Add att_multiday_enabled as BOOLEAN
    • Add att_percent_enabled as BOOLEAN
    • Add grades_weekly_enabled as BOOLEAN
    • Add assignments_enabled as BOOLEAN
    • Add balance_enabled as BOOLEAN
    • Add fee_enabled as BOOLEAN
    • Add discipline_enabled as BOOLEAN
  • U_BA_MSGFIELDS_PHONENUMBER
    • Add voice as BOOLEAN

V23.03.10

  • U_BA_FILTERS
    • Add att_tchr_override as BOOLEAN
    • Add att_tchr_per_lbl as INTEGER
    • Add att_tchr_exclude_ada as BOOLEAN
    • Add att_cur_override as BOOLEAN
    • Add att_cur_exclude_ada as BOOLEAN
    • Add att_cur_abs_periods as STRING(500)
    • Add att_cur_abs_periods_ie as BOOLEAN
    • Add att_cur_abs_periods_type as INTEGER
    • Add att_cur_tar_periods as STRING(500)
    • Add att_cur_tar_periods_ie as BOOLEAN
    • Add att_cur_tar_periods_type as INTEGER
    • Add att_multiday_override as BOOLEAN
    • Add att_multiday_exclude_ada1 as BOOLEAN
    • Add att_multiday_exclude_ada2 as BOOLEAN
    • Add grades_weekly_override as BOOLEAN
    • Add assignments_override as BOOLEAN
    • Add roster_override as BOOLEAN

V23.01.31

  • U_BA_FILTERS
    • Add balance_std_exclude_f as BOOLEAN
    • Add balance_std_exclude_r as BOOLEAN

V23.01.25

  • U_BA_FILTERS
    • Add att_cur_per_lbl as INTEGER

V22.12.19

  • U_BA_FILTERS
    • Add att_cur_schooldays as INTEGER
    • Add att_cur_abs_codes as STRING(50)
    • Add att_cur_abs_freq as INTEGER
    • Add att_cur_tar_codes as STRING(50)
    • Add att_cur_tar_freq as INTEGER
    • Add att_multiday_triggers1 as STRING(50)
    • Add att_multiday_abs_codes1 as STRING(50)
    • Add att_multiday_triggers2 as STRING(50)
    • Add att_multiday_abs_codes2 as STRING(50)
    • Add grades_weekly_freq as INTEGER
    • Add balance_std_low_f as DOUBLE
    • Add balance_std_neg_f as DOUBLE
    • Add balance_std_low_r as DOUBLE
    • Add balance_std_neg_r as DOUBLE
    • Add balance_std_low_p as DOUBLE
    • Add balance_std_neg_p as DOUBLE
    • Add balance_user_low as DOUBLE
    • Add balance_user_neg as DOUBLE
    • Add user_list_population_method as INTEGER

V9.2.2

  • U_BA_FILTERS
    • Add data_source_pw_pdf as INTEGER
    • Add att_tchr_day as INTEGER
    • Add att_tchr_se as INTEGER

V9.2.1

  • U_BA_FILTERS
    • Add assignments_is_missing as BOOLEAN
    • Add assignments_letter_grade as STRING(20)
    • Add assignments_not_absent as BOOLEAN
    • Add assignments_not_collected as BOOLEAN
    • Add assignments_not_exempt as BOOLEAN
    • Add assignments_not_incomplete as BOOLEAN
    • Add assignments_not_late as BOOLEAN
    • Add assignments_not_scored as BOOLEAN

V9.2.0

  • Booleans have all had the appropriate default added. PowerSchool does not respect the default, but added in hopes a future PowerSchool update will obey them.
  • U_BA_FILTERS
    • Add exclude_users_homephone as BOOLEAN
    • Add exclude_users_schoolphone as BOOLEAN
    • Add exclude_users_email_addr as BOOLEAN
    • Add exclude_users_ba_cellphone as BOOLEAN
    • Add exclude_users_ba_email2 as BOOLEAN
    • Add user_autocreation_method as INTEGER
    • Add att_multiday_label1 as STRING(50)
    • Add att_multiday_code_category1 as STRING(200)
    • Add att_multiday_schooldays1 as INTEGER
    • Add att_multiday_portion1 as INTEGER
    • Add att_multiday_multiple1 as INTEGER
    • Add att_multiday_label2 as STRING(50)
    • Add att_multiday_code_category2 as STRING(200)
    • Add att_multiday_schooldays2 as INTEGER
    • Add att_multiday_portion2 as INTEGER
    • Add att_multiday_multiple2 as INTEGER
    • Add grades_weekly_padding_days1 as INTEGER
    • Add grades_weekly_padding_days2 as INTEGER
    • Add grades_weekly_sc as STRING(20)
    • Add grades_weekly_per1 as INTEGER
    • Add grades_weekly_per1 as INTEGER
    • Add grades_weekly_lg1 as STRING(20)
    • Add grades_weekly_lg2 as STRING(20)
    • Add grades_weekly_pointspossible as BOOLEAN
  • U_BA_MSGFIELDS
    • Add exclude_discipline as BOOLEAN
    • Add exclude_student_all as BOOLEAN
  • Instant Connect Only:
    • Updated Publisher Name to be LINQ, Inc. since the purchase from eSchoolView. You will need to delete the old plugin and install the new one fresh or PowerSchool will show an error.

V9.1.2

  • U_BA_FILTERS
    • Add include_ba_override as BOOLEAN
    • Add alt_include_ba_override as BOOLEAN

V9.1.1

  • U_BA_MSGFIELDS_PERSON
    • Add messagingLanguage as STRING(100)

V9.1.0

  • U_BA_FILTERS
    • Add fee_padding_days as INTEGER
    • Add att_userDCID as INTEGER
    • Add data_source_lang_codeset as STRING(100)
    • Add data_source_lang_std_codeset as STRING(100)
    • Add cur_select_field4 as STRING(200)
    • Add cur_select_field5 as STRING(200)
    • Add cur_select_field6 as STRING(200)
    • Add cur_select_field7 as STRING(200)
    • Add cur_select_field8 as STRING(200)
    • Add cur_select_field9 as STRING(200)
  • U_BA_MSGFIELDS
    • Add messagingLanguage as STRING(100)
    • Add messagingLanguageStd as STRING(100)
  • U_BA_MSGFIELDS_Contacts
    • Add useForMessaging as BOOLEAN
    • Add messagingLanguage as STRING(100)

V9.0.0

  • U_BA_FILTERS
    • Add use_custom_filter as BOOLEAN
    • Add custom_filter as STRING(1000)
    • Add alt_use_custom_filter as BOOLEAN
    • Add alt_custom_filter as STRING(1000)
    • Add data_source as INTEGER
    • Add data_source_std as INTEGER
    • Add data_source_lang as INTEGER
    • Add data_source_lang_q as STRING(4000)
    • Add data_source_lang_std as INTEGER
    • Add data_source_lang_std_q as STRING(4000)
    • Add exclude_home_phone as BOOLEAN
    • Add alt_exclude_home_phone as BOOLEAN
    • Add exclude_mother_home_phone as BOOLEAN
    • Add exclude_motherdayphone as BOOLEAN
    • Add exclude_father_home_phone as BOOLEAN
    • Add exclude_fatherdayphone as BOOLEAN
    • Add exclude_guardianemail as BOOLEAN
    • Add exclude_studentemail as BOOLEAN
    • Add exclude_ba_cellphone as BOOLEAN
    • Add student_phone_types as INTEGER
    • Add student_email_types as INTEGER

V8.1.3

  • U_BA_FILTERS
    • Add att_padding_days as INTEGER
  • U_BA_MSGFIELDS_USERS
    • Add tracer as INTEGER

V8.1.2

  • U_BA_FILTERS
    • Add tardies_per_abs as INTEGER
    • Add tardies_per_abs_val as INTEGER
  • U_BA_MSGFIELDS_USERS
    • Add group_override as INTEGER

V8.1.1

  • U_BA_FILTERS
    • Add fields for filters for Data Access + one other thing
      • data access or custody
      • data access or lives with
      • data access or receives mail 
      • data access or emergency

V8.1.0

  • U_BA_FILTERS
    • Add field assignments_days_back to move control into settings page instead of when calling the PQ
    • Add field label to add ability to put a label on the filter
    • Add fields to include/exclude phone and email types
    • Add field phone_types_include_hp to designate to use home_phone as phone 1 when a contact’s 1st phone doesn’t meet requirements, boolean
    • Added copies of all filter fields in U_BA_FILTERS with alt_ before the name for use with an alternate filter setup. Will allow filters to be used for regular situations and a 2nd version to be used in an alternate situation such as normal vs emergency
    • Add fields student_from_contacts and student_contact_relationship to determine when student cell/email should come from contacts rather than legacy
  • U_BA_MSGFIELDS_USERS
    • Add field home_phone_v and home_phone_t to allow for on/off toggles for built in home_phone field
    • Add field tracer to enable/disable Tracer by person
  • U_BA_MSGFIELDS
    • Add fields for cell phones for schools who don’t already have one. Including voice/text on/off toggles
    • Add fields to exclude a student from specific scheduled exports so it can be controlled without needing to hard code it into the DEM template
      • Exclude from single day attendance exports
      • Exclude from multi day attendance exports
      • Exclude from log exports
      • Exclude from missing assignment exports
      • Exclude from Search by Store Code exports

V8.0.1

  • Separated out the DB extensions from BrightArrow Base Plugin v7.4.2 into it’s own plugin. This plugin will now be the plugin responsible for DB extensions and changes.

Prior to v8.0 the base was 1 plugin. Update information prior to version 8 can be found here

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Related Articles