Screen Catalog — Funding Setup & Schedules

Configuration screens in library funding: the funding hierarchy, bank accounts, fund pages, funding schedules, and the vendor quick-add used by check-writing screens.

---

Funding Account Hierarchy — funding/w_fund_acct_hierarchy

• Purpose: One screen listing a group's funding hierarchy, bank accounts and fund pages (window comment).
• Field groups:
  • Hierarchy tree (d_fund_hierarchy): group tree walked by groups.funding_parent_group_id, showing per-group counts of bank accounts and fund pages.
  • Bank accounts (d_fund_hierarchy_bank_accts, d_fund_hierarchy_bank_acct_info): account number, routing/bank form (bank_forms via dddw_bank_forms), print name/address, check counters (last_check_no, last_worksheet_no, last_manual_check_no), multigroup indicator.
  • Fund pages (d_fund_hierarchy_fund_pages, d_fund_hierarchy_fund_page_list, d_fund_hierarchy_fund_page_info): page code (ACCTPAGE), description, balance, funding method (FUNDMTHD), minimum balance, register sort order, inactive date.
  • Coverages per fund page (d_fund_hierarchy_coverages / d_fund_fundpage_coverages over fund_page_covrs): benefit coverage type, payment method (PAYMETHOD), matching-FICA indicator.
• Actions (save logic): inserts/updates bank_acct_info + bank_acct_info_grps, fund_pages + fund_page_grps, fund_page_covrs; can create funding-only group nodes (groups insert with funding_parent_group_id) and move groups within the funding tree; deletes cascade to bank_acct_info_grps/bank_acct_info, fund_page_covrs, and funding-only groups rows (with audit_groups cleanup).
• Opens: funding/w_fund_acct_hierarchy_add_entity (add bank account or fund page), funding/w_fund_acct_hierarchy_add_group, funding/w_fund_acct_hierarchy_select_group.

Fund Page Maintenance — funding/w_fund_page_maint (with funding/w_fund_page_selection)

• Purpose: Maintain individual fund pages (window comment "Fund Page Maintenance"); selection sheet lists a group's pages (d_fund_group_fund_list).
• Field groups: group hierarchy and page/group cross reference (d_fund_group_hierarchy, d_fund_group_fund_info, d_fund_page_group_list, d_fund_fund_page_grps); page editor (d_fund_page_edit: page code, balance, funding method, minimum balance, description, last register balance/date, inactive date, register sort order, audit columns); coverages (d_fund_hierarchy_coverages).
• Rules: a fund page already used on claims cannot be deleted (pfc_deleterow comment).

Bank Account Maintenance — funding/w_fund_bank_acct_info_maint / selection funding/w_fund_bank_acct_info_selection

• Purpose: Maintain bank accounts independent of the hierarchy screen.
• Field groups (d_fund_bank_acct_info_maint): bank account number, bank form / routing transit code (bank_forms), print name and print address, last check / worksheet / manual check numbers, multigroup indicator. Selection window filters by bank (d_fund_bank_form_bank) and lists accounts (d_fund_bank_acct_info_select).
• Note: bank_forms also carries the signature text/font/size/x-y positions applied to checks at print time (reprint/w_reprint_maintenance).

Funding Schedules — funding/w_fund_tab_schedule

• Title: "Funding Schedules". Menu m_fund_schedule_components.
• Purpose: Maintain scheduled funding runs and their components.
• Tabs:
  • Runs (d_fund_schedule, d_fund_schedule_runs over schedule_runs): run description, active flag, activity-required flag, nightly code vs specific run date (radio "nightly"/"date").
  • Components (d_fund_component_list): component descriptions with run type.
  • Schedules: tree of runs and their components (sched_run_comps), drag-and-drop assembly; deleting a run deletes its sched_run_comps links; deleting a component deletes its grp_sched_funds, grp_sched_incls, and sched_run_comps rows.
  • Group report (d_fund_schedule_missing): groups with claims in RFF status that belong to no schedule (excluding parent 501-003), so nothing payable is silently unscheduled.
• Opens: funding/w_fund_schedule_component.

Create Schedule Components — funding/w_fund_schedule_component

• Title: "Create Schedule Components".
• Purpose: Define one schedule component (window comment).
• Field groups: component name and run type (d_fund_component over sched_comp, run type from dddw_fund_run_types = codes RUNTYPES); group tree pickers (d_fund_base_groups, d_fund_heirarchy_v2, bank-account groups d_fund_bank_acct_grps); included groups (d_fund_component_groups over grp_sched_incls); fund page codes (d_fund_component_fundpages over grp_sched_funds, codes via d_fp_codes); fund page/coverage context (d_fund_fundpage_list, d_fund_fundpage_coverages); global exclusions (d_fund_grp_excludes over funding_group_excludes); user-class check (d_fund_security_users).

Vendor Quick Add — funding/w_fund_vendor_quick_add

• Title: "Vendor Quick Add" (response window).
• Purpose: Add or edit a vendor inline from check-writing screens (window comment).
• Field groups: vendor info (d_fund_vendor_info_quick_add over vendors): name, lookup name, TIN, TIN type, client segment, "Produce 1099?" checkbox (irs_1099_flg, defaulted N for new funding vendors); address (d_fund_vendor_address_quick_add over pm_addresses): addr1/2, city, state, zip, country.
• Opens: funding/w_fund_vendor_select_quick_add when a name search matches multiple vendors (d_fund_vendor_select).

Selector response windows

Window	Purpose
funding/w_fund_group_select	Pick a group (d_fund_group_select) for u_fund_group_enter
funding/w_fund_bank_acct_select	Pick one of a group's bank accounts (d_fund_bank_acct_select)
funding/w_fund_check_select	Pick a logged incoming check when several qualify (d_fund_check_select over check_log)
funding/w_fund_deposit_locked_claims	Show claims locked by other users during funding; print list; continue or exit