LUCT Botswana — triggers from CMS_Botswana_Triggers_24_09_2026.sql Database: cmsbotswana Count: 157 acc_changeroom_aft_ins_tr acc_checkout_aft_ins_tr acc_checkout_bfr_ins_tr acc_ectendoccupancy_aft_ins_tr acc_freeoccupant_aft_ins_tr acc_freeoccupant_aft_upd_tr acc_freeoccupant_bfr_ins_tr acc_occupant_aft_ins_tr acc_occupant_aft_upd_tr acc_occupant_bfr_ins_tr acc_room_aft_upd_tr app_applicationform_after_ins_tr app_applicationform_after_upd_tr1 app_applicationform_before_ins_tr1 app_applicationform_before_upd_tr1 app_applicationformonline_after_ins_tr1 app_arrivalform_after_ins_tr1 app_arrivalform_after_upd_tr1 app_docfile_after_ins_tr1 app_document_after_upd_tr1 app_eligibility_bef_ins_tr b_assistbillingbots_after_ins_tr1 b_assistbillingbots_before_ins_tr1 b_assistbillingdetail_after_upd_tr b_assistbillingdetail_before_upd_tr b_assistbillingdetailbots_after_upd_tr1 b_invoicedetail_before_ins_tr1 b_invoicedetail_before_upd_tr1 b_paymentdetail_after_ins_tr1 b_paymentdetail_after_upd_tr1 b_receipt_after_upd_tr1 b_receipt_before_upd_tr1 b_receiptdetail_after_ins_tr b_receiptdetail_after_upd_tr b_stdinstaldetail_after_ins_tr1 b_stdinstaldetail_after_upd_tr1 b_stdinstaldetail_before_ins_tr1 b_stdinstalment_after_ins_tr1 b_stdinstalment_before_ins_tr1 b_stdinstalment_before_upd_tr1 b_stdpaymentoption_after_insert bfreinaet f_attenddatemod_before_ins_tr f_attenddatemod_before_upd_tr f_lecturer_after_ins_tr1 f_lecturer_after_ins_tr1_copy1 f_lecturer_after_upd_tr1 f_lecturer_after_upd_tr1_copy1 f_lecturer_before_ins_tr f_lecturer_before_ins_tr_copy1 f_lecturer_before_upd_tr f_lecturer_before_upd_tr_copy1 f_module_before_ins_tr f_module_before_upd_tr f_program_before_ins_tr f_program_before_ins_tr_copy f_program_before_upd_tr f_program_before_upd_tr_copy f_programaccreditation_after_ins_tr_new f_programaccreditation_after_upd_tr_new f_programaccreditationext_after_ins_tr_new f_programaccreditationext_after_upd_tr_new f_programapproval_after_ins_tr_new f_programapproval_after_upd_tr_new f_programapprovalext_after_ins_tr_new f_programapprovalext_after_upd_tr_new f_programsummary_after_ins_tr_new f_programsummary_after_upd_tr_new f_programsummary_before_ins_tr_new f_programsummary_before_upd_tr_new f_releaseresult_after_ins_tr1 f_releaseresult_after_upd_tr1 f_releaseresultdetail_before_upd_tr1 f_semester_after_upd_tr1 f_semester_before_ins_tr f_semester_before_upd_tr f_semmodule_before_ins_tr f_semmodule_before_upd_tr f_structure_after_ins_tr f_term_after_upd_tr1 f_termdetail_after_ins_tr1 f_termdetail_after_upd_tr1 f_termnew_before_ins_tr1 ih_attenddatemod_before_upd_tr ih_stdattendance_before_upd_tr1 ih_student_after_ins_tr ih_student_after_upd_tr m_agent_before_ins_tr m_commision_after_ins_tr1 m_commision_after_upd_tr1 r_cancelcredtransfer_AFTER_INSERT r_cancelcredtransfer_BEFORE_INSERT r_form_after_ins_tr1 r_form_after_upd_tr1 r_form_before_ins_tr1 r_form_before_upd_tr1 r_ptptn_before_upd_tr1 r_starter_after_upd_tr1 r_stdattendancerequest_after_ins_tr_new r_stdattendancerequest_after_upd_tr_new r_stdattendancerequest_before_ins_tr r_stdimmigration_after_ins_tr1 r_stdimmigration_after_upd_tr1 r_stdmodule_before_ins_tr2 r_stdmodule_before_upd_tr1 r_stdnotes_before_ins_tr1 r_stdofferletter_after_ins_tr r_stdofferletter_after_upd_tr1 r_stdofferletter_before_ins_tr r_stdofferletter_before_upd_tr1 r_stdpersonal_after_ins_tr r_stdpersonal_after_upd_tr1 r_stdpersonal_before_ins_tr r_stdpersonal_before_upd_tr1 r_stdprogram_after_ins_tr r_stdprogram_after_ins_tr_copy r_stdprogram_after_upd_tr r_stdprogram_after_upd_tr_copy r_stdprogram_before_ins_tr r_stdprogram_before_ins_tr_copy r_stdprogram_before_upd_tr r_stdprogram_before_upd_tr_copy r_stdrelation_before_ins_tr r_stdrelation_before_upd_tr r_stdsemester_after_ins_tr1 r_stdsemester_before_ins_tr r_stdsemester_before_upd_tr r_stdsurvey_after_ins_tr r_student_after_ins_tr r_student_after_upd_tr1 r_student_before_ins_tr r_student_before_upd_tr r_visaletter_bfr_update s_billing_before_ins_tr s_staff_after_ins_tr1 s_staff_after_ins_tr1_copy1 s_staff_after_upd_tr1 s_staff_after_upd_tr1_copy1 s_staff_before_ins_tr s_staff_before_ins_tr_copy1 s_update_before_ins_tr s_upload_after_ins_tr1 s_upload_after_upd_tr1 s_upload_before_ins_tr tr_aftrupd8 w_application_before_upd_tr w_extracurricular_after_update w_occupant_after_ins_tr w_occupant_after_upd_tr w_receipt_before_ins_tr1 w_receipt_before_upd_tr1 w_receiptdetailacco_after_ins_tr w_receiptdetailacco_after_upd_tr w_visa_after_ins_tr1 w_visa_after_upd_tr1 w_visa_before_ins_tr1 w_visa_before_upd_tr1