Traceability: Screen → DataWindows → Tables

Each window (screen), the DataWindows it hosts, and the tables those touch. Use this to confirm nothing is missed when migrating a screen.

app_sec — 12 windows

Window	Title	DataWindows	Tables
`w_cust_group_sec`	Window to maintain Customer Group security for application users	`d_class_groups` `d_get_parent_group`
`w_maint_security`	Main Security maintenance window - used to Create and Maintain user security for Homer	`d_user_group`	`security_user_group`
`w_new_user`	Response window for entering new user information	`d_new_user`	`security_users`
`w_sec_report1`		`d_rpt_function_by_user`
`w_system_menu_security`		`d_security_menu_options` `d_security_menu_users` `d_user_ini`	`security_menu_options` `security_users` `user_ini`
`w_user_assignment`	Window used to assign users to groups	`d_user_asgwiz_coveragetype` `d_user_assignment_selection` `d_user_group_criteria` `d_user_group_selection`	`codes` `groups` `user_assignments`
`w_user_assignment_error`	List of conflicting user group assignments	`d_user_assignment_selection`	`user_assignments`
`w_user_dept_group`	Windwo to to catagorize departments	`d_available_departments_selection` `d_deptgroup_criteria` `d_deptgroup_edit`	`security_users` `user_dept_group`
`w_user_info_edit`	User profile edit window	`d_user_assignment_selection` `d_user_info_edit` `d_user_supervisor_selection`	`security_groupings` `user_assignments` `user_dept_group` `user_info` `user_supervisor`
`w_user_info_maint_selection`	User profile list window	`d_deptgroup_criteria` `d_user_info_selection`	`security_users` `user_dept_group` `user_info`
`w_user_maint`	User Maintenance	`d_all_user_classes` `d_db_roles` `d_new_user` `d_user_classes` `d_user_roles`	`security_user_class_user` `security_users` `security_users_db_role`
`w_user_supervisor_edit`	User supervisor assignment window	`d_user_supervisor_edit` `d_user_supervisor_selection`	`security_groupings` `user_dept_group` `user_info` `user_supervisor`

base — 1 windows

Window	Title	DataWindows	Tables
`w_provider_consolidate_vendors`	Consolidate Vendors	`d_provider_consolidate_vendors`	`pm_addresses` `vendors`

benplans — 9 windows

Window	Title	DataWindows	Tables
`w_benefit_def_maint`	Main benefit definition maintenance window	`d_benefit_def_diags` `d_benefit_def_header1` `d_benefit_def_picklist` `d_benefit_def_procs` `d_benefit_def_rpt1` `d_benefit_def_summary` `d_benefit_def_usage` `d_compound_ben_def` `d_def_list` `d_diag_cd_and_groups_list` `d_diag_cd_and_groups_selected` `d_diag_code_type` `d_diagnosis_groups_rpt` `d_modifier_list` `d_pos_list` `d_proc_cd_and_groups_list` `d_proc_cd_and_groups_selected` `d_proc_code_type` `d_revenue_list` `d_specialty_list`	`benefit_def_diags` `benefit_def_procs` `benefit_defs` `benefit_rules` `compound_ben_defs` `diagnosis_codes` `modifiers` `place_of_service_codes` `procedure_codes` `rule_defs` `specialties`
`w_benefit_def_response`	Response window to select/return benefit def	`d_benefit_def_selection`	`benefit_defs`
`w_benefit_def_selection`	main selection window for benefit definitions	`d_benefit_def_selection` `d_modifier_list` `d_pos_list` `d_revenue_list` `d_specialty_list`	`benefit_defs` `modifiers` `place_of_service_codes` `procedure_codes` `specialties`
`w_benefit_pkg_maint`	Main window for benefit package maintenance	`d_benefit_pkg_header1` `d_benefit_pkg_header2` `d_benefit_rule_picklist` `d_pkg_rider_maint` `d_pkg_rule_dep` `d_pkg_rule_ful` `d_pkg_rule_maint` `d_pkg_rule_req` `d_pkg_rule_row` `d_pkg_summary` `d_print_ben_pkg` `d_rider_rule`	`benefit_defs` `benefit_pkgs` `benefit_rules` `pkg_riders` `pkg_rule_dependencies` `pkg_rule_fulfillments` `pkg_rule_requirements` `pkg_rules` `reason_codes` `rider_rules` `riders`
`w_benefit_pkg_selection`	Selection window for benefit packages	`d_benefit_coverage` `d_benefit_pkg_selection`	`benefit_pkgs`
`w_benefit_plan_selection`	Mainselection window for benefit plans	`d_benefit_coverage_type` `d_benefit_plan_select`	`benefit_plans`
`w_benefit_rule_select`	Main selection DW for benefit rule editing	`d_benefit_rule_list` `d_rule_type_cd`	`benefit_rules`
`w_create_benefit_plan`	Window for creating benefit rules	`d_benefit_packages` `d_benefit_plan_edit` `d_plan_packages` `d_print_benefit_plan`	`benefit_pkgs` `benefit_plans` `plan_pkgs`
`w_create_benefit_rule`	Window for creating benefit rules	`d_ben_rule_ded` `d_ben_rules` `d_benefit_def_list` `d_pkg_rules` `d_print_rule_def_pkg` `d_rule_contingency` `d_rule_def_link` `d_rule_tooth_types` `d_tooth_types`	`benefit_defs` `benefit_pkgs` `benefit_rule_tooth_types` `benefit_rules` `pkg_rules` `rule_contingency_defs` `rule_defs` `tooth_types`

bensupport — 28 windows

Window	Title	DataWindows	Tables
`w_carryover_rule_maint`	Main window for maintenance of carryover rules	`d_carryover_rules_maint`	`carryover_rules`
`w_code_selection`		`d_code_key_selection`	`code_keys`
`w_codes_maint`		`d_code_key_maint` `d_codes_maint`	`code_keys` `codes`
`w_convert_plan`		`d_benefit_coverage_type` `d_benefit_plans_dddw` `d_group_coverage_list`	`group_coverages`
`w_create_diag_group`	Window to creating/editing diagnosis groups	`d_cd_type` `d_diag_cd_groups` `d_diag_groups_edit` `d_diagnosis` `d_print_diag_groups`	`diagnosis_code_groups` `diagnosis_codes` `diagnosis_groups`
`w_create_proc_group`	Window for creating/editing procedure groups	`d_cd_type` `d_print_proc_groups` `d_proc_cd_groups` `d_proc_groups_edit` `d_procedures`	`procedure_code_groups` `procedure_codes` `procedure_groups`
`w_create_second_opinion`	Window for editing/creating second opinion groups	`d_cd_type` `d_print_so_groups` `d_procedures` `d_sec_opinion_edit` `d_so_cd_groups`	`procedure_codes` `second_opinion_lists` `second_opinion_procs`
`w_create_tooth_group`	Window for creating teeth groups	`d_tooth_numbers` `d_tooth_type_edit` `d_tooth_types`	`tooth_code_numbers` `tooth_types`
`w_diag_code_display`	Diagnosis Code Display	`d_diag_code`	`diagnosis_codes` `sfpidba.diagnosis_codes`
`w_diag_group_selection`	Window for listing diagnosis groups	`d_diag_groups` `d_print_d_groups`	`diagnosis_groups`
`w_diagnosis_code_maint`		`d_diagnosis_codes`	`diagnosis_codes`
`w_level_sched_maint`	Main window for maintenance of coverage level schedules	`d_level_scheds` `d_level_scheds_items`	`level_sched_items` `level_scheds`
`w_level_sched_selection`	main window for selecting coverage level schedules	`d_level_sched_selection`	`level_scheds`
`w_load_proc_diag_codes`	Load Proc / Diag Codes	`d_load_diagnosis_codes` `d_load_procedure_codes`	`diagnosis_codes` `procedure_codes`
`w_plan_analysis_by_group`		`d_plan_rpt_group_acm_analysis` `d_plan_rpt_group_rule_analysis`	`benefit_pkgs` `benefit_plans` `benefit_rules` `groups` `plan_pkgs` `reason_codes`
`w_plan_find_pkgs`		`d_find_packages`	`benefit_pkgs` `group_coverages` `plan_pkgs`
`w_plan_required_surfaces`	This window maintains the procedure codes that indicate required surfaces	`d_plan_required_surfaces`	`ada_surfaces_required`
`w_plan_required_teeth`	This window maintains the procedure codes that indicate required teeth	`d_plan_required_teeth`	`ada_teeth_required`
`w_proc_code_display`	window to allow user to enter a procedure code and get the description	`d_proc_code`	`procedure_codes` `sfpidba.procedure_codes`
`w_proc_group_selection`	Window for listing procedure groups	`d_print_p_groups` `d_proc_groups`	`procedure_groups`
`w_procedure_code_maint`		`d_procedure_codes`	`procedure_codes`
`w_reason_code_maint`	Main reason code maintenance window	`d_reason_code_maint`	`reason_codes`
`w_rounding_rule_maint`	Main window for maintaining rounding rules	`d_rounding_rule_maint`	`rounding_rules`
`w_second_opinion_selection`	Window for editing or creating 2nd opinion groups	`d_print_so_list` `d_second_opinion`	`second_opinion_lists`
`w_step_rate_maint`	Main step rate schedule maintenance window	`d_step_rate_items` `d_step_rate_scheds`	`step_rate_items` `step_rate_scheds`
`w_step_rate_selection`	main selection window for step rate schedules	`d_step_rate_find`	`step_rate_scheds`
`w_um_cm_serv_proc_cd_maint`		`d_um_cm_serv_proc_cd_maint`	`um_cm_serv_excl_proc_cd`
`w_wang_map`		`d_updt_wang_group_rule_map` `d_updt_wang_rule_map` `d_wang_group_list`	`benefit_rules` `groups` `reason_codes` `sfpidba.wang_group_rule_map` `sfpidba.wang_rule_map` `wang_group_rule_map` `wang_rule_map`

billing — 17 windows

Window	Title	DataWindows	Tables
`w_bill_adj_maint`	Billing Definition Charge and Manual Adjustment Maintenance.	`d_bill_adj_bill_charges` `d_bill_adj_def_charge_members` `d_bill_adj_header` `d_bill_adj_rule_charges`	`bill_charges` `bill_defs` `bill_rules` `bill_runs` `member_eligibilities` `members`
`w_bill_adj_selection`	Billing Definition Selection for Charge Adjustments.	`d_bill_adj_select`	`bill_defs` `bill_run_defs`
`w_bill_bill_def_maint`	Billing Definition Maintenance.	`d_bill_bill_def_groups` `d_bill_bill_def_header` `d_bill_bill_def_maint` `d_bill_bill_def_option_vals` `d_bill_bill_def_rule_maint` `d_bill_bill_rule_list` `d_bill_group_hierarchy`	`bill_def_groups` `bill_def_option_vals` `bill_def_options` `bill_def_rules` `bill_defs` `bill_rules` `groups`
`w_bill_bill_def_selection`	Billing Definition Selection.	`d_bill_bill_def_selection`	`bill_defs`
`w_bill_bill_range_maint`	Bill Ranges Maintenance	`d_bill_bill_range_item_maint` `d_bill_bill_range_maint`	`bill_range_items` `bill_ranges`
`w_bill_bill_range_selection`	Bill Ranges Selection	`d_bill_bill_range_selection`	`bill_ranges`
`w_bill_bill_rule_maint`	Billing Rule Maintenance	`d_benefit_coverage_type` `d_bill_benefit_plans` `d_bill_bill_rate_alloc_maint` `d_bill_bill_rate_amt_maint` `d_bill_bill_rate_table_maint` `d_bill_bill_rate_vars` `d_bill_bill_rule_maint` `d_bill_bill_rule_parm_detail_maint` `d_bill_bill_rule_parm_maint` `d_bill_bill_rule_usage` `d_bill_election_cobra_flg` `d_bill_group_select` `d_bill_hcn_selection` `d_bill_member_cat_options` `d_bill_member_select` `d_bill_rate_alloc_n_up` `d_bill_rule_group_options` `d_bill_var_rate_table` `d_coverages_checkbox`	`benefit_plans` `bill_def_rules` `bill_defs` `bill_rate_allocs` `bill_rate_amts` `bill_rate_tables` `bill_rate_vars` `bill_rule_parm_details` `bill_rule_parms` `bill_rules` `coverages` `group_member_cat` `group_options` `groups` `health_care_networks` `members`
`w_bill_bill_rule_selection`	Billing Rule Selection	`d_bill_bill_rule_selection`	`bill_rate_types` `bill_rules`
`w_bill_queue`	Bill Report Queue	`d_bill_bill_reports_list` `d_bill_def_dropdown_list`	`bill_defs` `bill_reports` `bill_runs` `report_data`
`w_bill_receipt_maint`	Window to allow maintenance of receipts for selected billing definition. Opens w_bill_receipt_response for receipt editting.	`d_bill_adj_header` `d_bill_receipt_charge_groups` `d_bill_receipt_charge_members` `d_bill_receipt_maint` `d_bill_receipt_view` `d_bill_run_def_maint`	`bill_charges` `bill_def_option_vals` `bill_defs` `bill_receipts` `bill_run_defs` `bill_runs` `groups` `members`
`w_bill_receipt_response`	Used by w_bill_receipt_maint. Popup (response) window to allow editting of receipts.	`d_bill_receipt_maint`	`bill_receipts` `bill_runs` `members`
`w_bill_receipt_selection`	Window to allow selection of billing definition for which receipts can be maintained. Opens w_bill_receipt_maint window.	`d_bill_receipt_select`	`bill_defs` `bill_run_defs`
`w_bill_reports`	Billing Exception Report	`d_bill_def_dropdown_list` `d_bill_err_report` `d_bill_rpt_bill_def_rates`	`bill_def_rules` `bill_defs` `bill_rate_amts` `bill_rate_tables` `bill_rules`
`w_bill_run_def_maint`	Billing Run Maintenance. Submit/Maintain billing runs and definitions.	`d_bill_bill_reports_maint` `d_bill_bill_run_maint` `d_bill_report_data` `d_bill_report_objects` `d_bill_run_def_maint`	`bill_defs` `bill_reports` `bill_run_defs` `bill_runs` `report_data` `report_objects`
`w_billing`		`d_group_general` `d_group_periods` `d_group_select`	`groups` `sfpidba.groups`
`w_billprt_disbursement_division_summary`		`d_bill_def_dropdown_list` `d_billprt_disbursement_division_summary` `d_billprt_mailing_letter_header`	`bill_charges` `groups` `letter_headers` `vendors`
`w_billrpt_flex_charges`	This window does the Flex Charge Billing report	`d_billrpt_flex_charges`	`elections` `groups` `member_eligibilities` `members`

claims — 45 windows

Window	Title	DataWindows	Tables
`w_accident_claims_selection`	List of claims that might apply to an accident.	`d_accident_claims_selection`	`claim_entries` `claims` `members`
`w_accident_edit`	Accident edit window. Goes with w_accident_selection	`d_accident_claim` `d_accident_edit` `d_accident_members_diag` `d_accident_members_selection`	`accident_claims` `accident_diagnoses` `accident_members` `accidents` `diagnosis_codes` `members`
`w_accident_member_edit`	Assign Member to Accident	`d_accident_members_edit`	`accident_members` `members`
`w_accident_selection`	Select/Create Accident Report	`d_accident_selection` `d_accident_selection_criteria`	`accidents` `members`
`w_add_claim_to_internal_cm`	Add Claim To Internal CM Case	`d_adj_open_service` `d_adj_similar_services`	`claim_lines` `claims` `um_cases` `um_diagnosis_codes` `um_procedure_codes` `um_rules` `um_services`
`w_assoc_list`		`d_assoc_letters_list`	`claim_letters_hist_claims`
`w_audit_diag_codes_selection`	Edit/Search window for Diag Codes Auditing	`d_audit_diagnosis_codes` `d_audit_diagnosis_codes_criteria`	`audit_diagnosis_codes`
`w_audit_examiners_selection`	Edit/Search window for Examiner Auditing	`d_audit_examiners` `d_claims_examiner_criteria`	`audit_examiners` `claim_persons` `user_info`
`w_audit_groups_selection`	Edit/Search window for Group Auditing	`d_audit_groups` `d_group_search_criteria`	`audit_groups`
`w_audit_members_selection`	Edit/Search window for member Auditing	`d_audit_members`	`audit_members` `members`
`w_audit_procedure_codes`	Edit/Search window for Proc Codes Auditing	`d_audit_procedure_codes` `d_audit_procedure_codes_criteria`	`audit_procedure_codes`
`w_audit_providers_selection`	Edit/Search window for Provider Auditing	`d_audit_providers` `d_providers_search_criteria`	`audit_providers` `providers`
`w_before_claim_lines`	Windwo used to display current claim lines and claim lines before code review	`d_before_claim_lines` `d_claim_lines_current`	`claim_eob_info_details` `claim_lines` `claim_lines_before` `claims_anesthesia` `reason_codes`
`w_claim_correction`	Claims Corrections window	`d_claims_selection`	`claim_entries` `claim_entry_diag_codes` `claim_letters_hist` `claim_letters_hist_claims` `claim_messages` `claim_status_order` `claim_statuses` `claims` `health_care_networks` `members` `providers`
`w_claim_editor`	Open Claim	`d_claim_entries_original_values` `d_claim_letters_hist_claims_details` `d_claimid` `d_claims_messages_action` `d_claims_messages_entry` `d_claims_selection`	`claim_entries` `claim_entry_diag_codes` `claim_letters_hist` `claim_letters_hist_claims` `claim_messages` `claim_status_order` `claim_statuses` `claims` `global_messages` `health_care_networks` `members` `providers`
`w_claim_line_pricing_rules`	Pop up Window used in the Claims editor to record manually entered pricing data	`d_claim_line_pricing_rules_edit`	`claim_line_pricing_rules`
`w_claim_lines_benefit_definition`	window to display benifit definition applied to a claim line	`d_claim_lines_benefit_definition`	`benefit_defs` `benefit_pkgs` `claim_lines`
`w_claim_lines_remove_modifiers`	Change/Remove Claim Modifiers	`d_claim_lines_remove_modifiers`	`claim_lines`
`w_claim_message_claim_line_hold`	Window used to close message 124	`d_claim_message_claim_line_hold`	`reason_codes` `sfpidba.reason_codes`
`w_claim_message_cm_hold`		`d_claim_message_cm_hold`	`reason_codes`
`w_claim_message_select_package`	Used in claims correction for correcting error #109	`d_claims_message_package_selection`	`plan_pkgs`
`w_claim_search`	Claims search window	`d_claims_selection`	`claim_entries` `claim_entry_diag_codes` `claim_letters_hist` `claim_letters_hist_claims` `claim_messages` `claim_status_order` `claim_statuses` `claims` `health_care_networks` `members` `providers`
`w_claims_accum_display_claims`	window to display claims for accumulators	`d_claims_accum_display_claims`	`claim_line_accums` `claims`
`w_claims_disp_status_history`	Window for display status history for a claim	`d_claims_disp_status_history`	`claim_status_order` `claim_statuses_history`
`w_claims_family_accum`	window to display family accumulators	`d_claims_accum_display_family`	`member_accums` `members` `reason_codes`
`w_claims_family_members`		`d_submem_family`	`family` `members`
`w_claims_hcn_list`	This window allows the user to choose an HCN	`d_claim_hcn_list`	`health_care_networks`
`w_claims_letters`	Claim letters window	`d_claim_letters_hist_claims` `d_claims_messages_entry` `d_letter_message_hist` `d_letters_by_member` `d_report_info_list`	`claim_letters_hist` `claim_letters_hist_claims` `claim_messages` `global_messages` `report_info`
`w_claims_mem_accum_credits`		`d_claims_member_accum_credits` `d_member_acc_cr_security`	`member_accum_credits` `members` `user_dept_group`
`w_claims_member_accum`	Member Accumulators	`d_claims_accum_display` `d_claims_accum_filter_accum` `d_claims_accum_filter_member` `d_clmrpt_period_find`	`benefit_rules` `member_accums` `members` `pkg_rules` `reason_codes`
`w_claims_member_accum_claims`		`d_claims_accum_display_claims`	`claim_line_accums` `claims`
`w_claims_message_edit`	Claims message edit window	`d_claims_messages_edit` `d_user_defined_global_messages`	`claim_messages` `global_messages`
`w_claims_partners_select`	allows users to select claims for outbound EDI from the claims editor	`d_claims_partner_select`	`outbound_edi_trading_partners`
`w_claims_select_reason_code`	REason code selection window	`d_claims_reason_codes`	`reason_codes`
`w_comment_prompt`		`d_set_claims_status` `d_user_defined_global_messages`	`claim_messages` `global_messages`
`w_daterange`	Simple date range selection window - used in claims letters	`d_daterange`
`w_delete_letter`	Delete letter used in w_claims_correction	`d_claims_frm_delete`	`claim_entries`
`w_eob_attach`	Displays a list of unassigned EOB records for an SSN	`d_claims_eob_detail_ssn`	`claim_eob_info_details` `claim_eob_infos`
`w_eob_edit`	EOB Edit window	`d_claims_eob_detail_syskey` `d_claims_eob_info_edit_syskey`	`claim_eob_info_details` `claim_eob_infos`
`w_eob_edit_claim_lines`	Pop up EOB edit window. Used from Claim lines	`d_claims_eob_detail_clmline` `d_claims_eob_info_edit_clmline`	`claim_eob_info_details` `claim_eob_infos`
`w_eob_selection`	EOB list for SSN	`d_claims_eob_infos_selection`	`claim_eob_infos`
`w_ext_adjustment`	none	`d_ext_adjustments`	`claims` `ext_adjust`
`w_select_benefit_definition`	Allows user to select benefit defintion for a claim line	`d_claim_lines_adjudication` `d_select_bendefs` `dddw_claim_line_bendefs`	`benefit_defs` `claim_eob_info_details` `claim_lines` `claims_anesthesia` `plan_pkgs` `reason_codes` `v_pkg_rules`
`w_setclaimsstatus`	Pop up that appears when user attempts change claim status	`d_set_claims_status` `d_user_defined_global_messages`	`claim_messages` `global_messages`
`w_view_claim_letters`	Print Queue Manager	`d_claim_letters_archive` `d_claim_letters_criteria` `d_view_claims_letters`	`claim_letters_hist` `report_archive` `user_info`

client — 12 windows

Window	Title	DataWindows	Tables
`w_carrier_maint`	Stoploss Carrier Maintenance Screen	`d_new_carrier` `d_std_address`	`addresses` `carriers`
`w_carrier_select`	Window for listing all stoploss carriers	`d_carrier_list` `d_print_carriers`	`addresses` `carriers`
`w_client_census_rpt_args_sheet`		`d_client_census_rpt_select` `dddw_client_census_cat_cds`	`codes`
`w_client_copy_group_info`	HOMER - Copy Group Info	`d_client_copy_group_info`
`w_client_enrollment`	Screen to Identify a Client Group for Add/Modify/View. Also displays Basic Client information view only.	`d_client_group_contacts_rpt` `d_client_group_info_display` `d_client_sub_group_ids`	`addresses` `group_contacts` `groups`
`w_client_group_select`	Window used to select a group from a list of groups.	`d_client_group_select`
`w_client_group_select_by_contact`	Window used to select a group from a list of groups that includes contact information for the group.	`d_client_group_select_by_contact`
`w_client_grp_chg_prop_hist`	Window used to select which children groups should receive the changes made to the parent group.	`d_client_grp_chg_prop_hist`
`w_client_maintenance`	HOMER - Group Maintenance	`d_client_category_values` `d_client_client_segment` `d_client_group_contacts_edit` `d_client_group_contacts_rpt_print` `d_client_group_coverage_display` `d_client_group_coverage_info` `d_client_group_enroll_opts` `d_client_group_info_new` `d_client_group_info_new_ext` `d_client_group_info_summary` `d_client_group_mbr_categories` `d_client_group_mbr_new_categories` `d_client_group_options` `d_client_grp_coverage_eligibility_rules` `d_client_sub_group_ids` `d_enrollment_periods` `d_enrollment_periods_open` `d_std_address`	`addresses` `client_segment_groups` `codes` `group_contacts` `group_coverages` `group_enroll_opts` `group_member_cat` `group_option_vals` `group_options` `group_periods` `groups` `grp_covr_elig_rules` `grp_mbr_cat_val`
`w_client_term_group`	Term Groups	`d_benefit_coverage_type` `d_client_term_group_report` `dddw_enroll_eligibility_exp_codes`	`addresses` `codes` `election_coverages` `elections` `family` `groups` `member_eligibilities` `members`
`w_member_waivers`	Window for inputing member waivers	`d_member_list` `d_member_waivers`	`family` `members` `stoploss_waivers`
`w_stoploss_period_select`	Response window for selecting a particular stoploss period	`d_contract_picklist` `d_elig_groups` `d_heirarchy` `d_sl_periods`	`carriers` `group_periods` `group_stoploss_parms` `groups` `member_eligibilities`

clmentry — 1 windows

Window	Title	DataWindows	Tables
`w_anesthesia_popup`	Anesthesia popup used n_cst_claims	`d_anesthesia_popup`	`claims_anesthesia`

clmforms — 1 windows

Window	Title	DataWindows	Tables
`w_claim_status_listing`		`d_rpt_claim_listing`	`benefit_defs` `benefit_pkgs` `claim_entries` `claim_line_diag_codes` `claim_lines` `claims` `diagnosis_groups` `members` `procedure_groups` `reason_codes`

clmprint — 1 windows

Window	Title	DataWindows	Tables
`w_claim_print_eob`	This window prints an EOB for a claim	`d_checkrun_eob`

clmrpt — 23 windows

Window	Title	DataWindows	Tables
`w_bank_acct_select`	This window allows the user to select a bank account for a group	`d_bank_acct_select`	`bank_acct_info` `bank_acct_info_grps`
`w_cigna_p4p`	Cigna Pay for Performance Reporting	`d_cigna_p4p_dateselect` `d_cigna_report_groups` `d_clmrpt_cigna_p4p_out`	`cigna_report_groups` `claim_entries` `claim_lines` `claims` `claims_ub92_info` `groups` `health_care_networks` `members`
`w_claimrpt_large_claim_report`		`d_claimrpt_large_claim_report`	`claim_statuses` `claims`
`w_clm_claimed_amt_morethan`		`d_clmrpt_claimed_amt_morethan`	`claim_messages` `claim_status_order` `claim_statuses` `claims` `global_messages`
`w_clm_message_status_summary`		`d_clm_message_status_summary`	`claim_messages` `claim_status_order` `claim_statuses` `global_messages`
`w_clmrpt_accum_rpt`	Member Accumulator Listing	`d_clmrpt_accum_pending` `d_clmrpt_accum_rpt_external` `d_clmrpt_accum_rpt_jhp` `d_clmrpt_credits_rpt` `d_clmrpt_lifetime_rpt` `d_clmrpt_period_find`	`benefit_rules` `claim_line_accums` `claim_lines` `claim_statuses` `member_accum_credits` `member_accums` `member_eligibilities` `members` `pkg_rules` `reason_codes`
`w_clmrpt_claims_older_than_90_days`	Find all claims that are older than 90 days from a specified group (or from a parent group and all children groups)	`d_clmrpt_claims_older_than_90_days`	`claim_statuses` `groups`
`w_clmrpt_member_accum_search`	This is the window that the user enters the member criteria and display the accumulators results of the search.	`d_clmrpt_member_accum_search_results`	`benefit_rules` `claim_entry_diag_codes` `claims`
`w_clmrpt_no_sub_or_pat`	This is the window used to view the d_clmrpt_no_sub_or_pat datawindow's data.	`d_clmrpt_no_sub_or_pat`	`claim_messages` `global_messages`
`w_clmrpt_open_messages`	This window shows all claims with open messages.	`d_clmrpt_claim_status` `d_clmrpt_message_type` `d_clmrpt_open_messages`	`claim_messages` `claim_status_order` `claims` `global_messages`
`w_clmrpt_outbound_aging_tv`	Claims - Outbound Aging	`d_clmrpt_outbound_aging_tv`	`claims` `ext_output_transactions`
`w_clmrpt_outbound_edi_older_than_10_days`	Report of which claims in outbound_edi_transactions have not come back and are older than 10 days and were created after 06/15/2005	`d_clmrpt_outbound_edi_older_than_10_days`	`outbound_edi_transactions`
`w_clmrpt_outstanding_adjustments`	Report to find claims with outstanding adjustments	`d_clmrpt_outstanding_adjustments`	`claims` `fund_register` `groups` `members`
`w_clmrpt_outstanding_refunds`	This window shows outstanding refunds for a group (or all groups)	`d_clmrpt_outstanding_refunds`	`fund_register`
`w_clmrpt_status_count`	Status Count	`d_annlstmt_group_ids` `d_clmrpt_status_count` `d_clmrpt_status_count_all`	`claim_status_order` `groups`
`w_group_select`	This window allows the user to select a group	`d_clmrpt_group_select`	`groups` `sfpidba.groups`
`w_no_group_id_fix`	Claims with NO Group ID assigned	`d_no_groupid_by_claim_prefix`	`claims`
`w_nobs_group_rpt`		`d_nobs_group_rpt`	`claim_messages` `claim_status_order` `claims`
`w_ppaca_letters`	PPACA Letters	`d_claims_frm_aes_ppaca` `d_claims_frm_irs_ppaca`	`claims` `groups` `letter_headers` `user_info`
`w_rpt_group_claim_bendefs`	Detailed Claims Listing By Benefit Definition	`d_rpt_group_bendef_selection` `d_rpt_group_claim_bendefs`	`benefit_defs` `benefit_rules` `claim_entries` `claim_line_rules` `claim_lines` `claims` `fund_register` `fundtrans` `groups` `members` `vendors`
`w_rpt_group_claim_benrules`	Report: Detailed Claims Listing by Benefit Rule Type	`d_rpt_group_claimlist_byrule` `dddw_cd_type`	`benefit_rules` `claim_line_rules` `claim_lines` `claims` `codes` `groups` `members`
`w_rpt_group_selected_accums`	Report: Accumulators By Member	`d_group_accums_memselect` `d_rpt_group_accums_bymember` `dddw_reason_accum_picklist`	`groups` `member_accums` `member_eligibilities` `members` `reason_codes`
`w_rpt_member_accum_rulemax`	Report: Member Accumulators By Benefit Rule	`d_rpt_member_accum_byrule`	`benefit_rules` `groups` `member_accums` `member_eligibilities` `members` `reason_codes`

clmshare — 1 windows

Window	Title	DataWindows	Tables
`w_cm_select`		`d_cm_select`

clmutils — 9 windows

Window	Title	DataWindows	Tables
`w_adjd_rule_utils`		`d_acm_group_members` `d_acm_plan_members`	`elections` `member_eligibilities` `members`
`w_benefit_def_response_selection`		`d_benefit_def_selection`	`benefit_defs`
`w_benefit_plan_response_selection`		`d_benefit_coverage_type` `d_benefit_plan_select`	`benefit_plans`
`w_benefit_rule_response_selection`		`d_benefit_rule_list` `d_rule_type_cd`	`benefit_rules`
`w_bkgd_monitor`		`d_bkgd_current_locks` `d_bkgd_last_claim` `d_bkgd_status_counts` `d_claim_status_history_throughput`	`claim_status_order` `claims`
`w_caremark_non_claim_record`	Caremark Non Claim Records	`d_caremark_non_claim_record_report` `d_claim_status_order`	`caremark_edi_table` `claim_status_order`
`w_edi_outbound_edi_processor`	Outbound edi main window	`d_claims_in_edi_repricing` `d_edi_inbound_claims` `d_edi_outbound_claims_to_file` `d_edi_outbound_claims_to_process` `d_edi_tables` `d_edi_transaction_table`	`claims` `edi_in_repricing` `outbound_edi_patient_table` `outbound_edi_provider_table` `outbound_edi_subscriber_table` `outbound_edi_transactions`
`w_group_response_selection`		`d_group_response_selection`	`groups`
`w_reason_response_selection`		`d_accum_response_selection` `d_codes_dd`

cob — 2 windows

Window	Title	DataWindows	Tables
`w_cob_maintenance`	COB Edit	`d_cob_address` `d_cob_detail` `d_cob_detail_for_ds`	`addresses` `coord_of_bens`
`w_cob_select`		`d_cob_header`	`coord_of_bens` `family` `members`

cobra — 8 windows

Window	Title	DataWindows	Tables
`w_cobra_administration`	COBRA Administration	`d_cobra_benficiaries` `d_cobra_event` `d_cobra_letters` `d_cobra_payments` `d_cobra_persons`	`cobra_elect_persons` `cobra_event` `cobra_letters` `cobra_qb` `cobra_stub` `groups` `member_eligibilities` `members`
`w_cobra_event_select`	Cobra Administration Select	`d_cobra_event_select` `d_event_cd_select`	`cobra_event` `codes` `member_eligibilities` `members`
`w_cobra_letter_errors`		`d_cobradw_letter_errors`	`cobra_errors` `cobra_event` `members`
`w_cobra_printqueue`	COBRA Print Queue	`d_cobra_letter_types` `d_cobra_notification_rpt` `d_cobra_printqueue_all` `d_cobra_printqueue_letters` `d_cobra_printqueue_notify` `d_cobra_termed_rpt` `d_cobra_unavailability_rpt` `d_cobradw_cert_mailing` `d_cobradw_election_frm_comp_prior`	`cobra_event` `cobra_letters` `cobra_notification_requests` `member_eligibilities` `members`
`w_cobra_rate_maint`		`d_cobra_rates_dtl` `d_cobra_rates_hdr`	`cobra_rate_coverages` `cobra_rates_master`
`w_cobra_rate_select`	COBRA Billing Rate Selection	`d_cobra_rate_select` `d_cobra_rate_select_group` `d_cobra_rates_dtl` `dddw_cobra_coverage_levels`	`cobra_rate_coverages` `cobra_rates_master` `codes`
`w_cobra_receive_premium`	Receive COBRA Premiums	`d_cobra_payments`	`cobra_stub`
`w_select_family_members`		`d_select_family_members`	`family` `members`

cobrarpt — 1 windows

Window	Title	DataWindows	Tables
`w_cobrarpt_select_criteria`	COBRA Reports	`d_cobrarpt_arra` `dddw_cobrarpt_types`	`batch_reports` `cobra_event` `cobra_qb` `cobra_rates_master` `cobra_stub` `elections` `groups` `member_cat_val` `member_eligibilities` `members`

drugplan — 6 windows

Window	Title	DataWindows	Tables
`w_drugplan_member_maint`	HOMER - Prescription Plan Member Maintenance	`d_drugplan_exp_member_edit` `d_drugplan_exp_retrieve` `d_drugplan_exp_trans_members` `d_drugplan_pcs_member_edit` `d_drugplan_pcs_retrieve` `d_drugplan_pcs_rxb_member_edit` `d_drugplan_pcs_rxb_retrieve` `d_drugplan_pcs_rxb_trans_members` `d_drugplan_pcs_std_member_edit` `d_drugplan_pcs_std_retrieve` `d_drugplan_pcs_std_trans_members` `d_drugplan_pcs_trans_members` `d_drugplan_restat_member_edit` `d_drugplan_restat_retrieve` `d_drugplan_restat_trans_members`	`addresses` `drug_covr_exp_trans` `drug_covr_pcs_rxb_trans` `drug_covr_pcs_std_trans` `drug_covr_pcs_trans` `drug_covr_restat_trans` `election_coverages` `members`
`w_drugplan_other_add`	window used to add lines to w_drugplan_other_maint	`d_drugplan_other_add` `d_drugplan_other_select`	`group_coverages` `groups`
`w_drugplan_other_maint`	Window to maintain drug plan information for non-pcs/express scripts drug plans	`d_drugplan_other_maint` `d_drugplan_other_pass` `d_drugplan_other_select`	`codes` `drug_plan_exts`
`w_drugplan_other_save`	window for generating and saving drug plan exports for non-pcs/express scripts drug plans	`d_drugplan_other_members` `d_drugplan_other_select`
`w_drugplan_plan_maint`	HOMER - Prescription Plan Maintenance	`d_drugplan_coverage_codes` `d_drugplan_groups_by_coverage` `d_drugplan_plan_maint`	`drug_plan_exts`
`w_drugplan_report_transfer`	HOMER- Prescription Plan Reports and Tranfers	`d_cvs_elig_partials_by_memsyskey_re` `d_drugplan_exp_report` `d_drugplan_list` `d_drugplan_pcs_report` `d_drugplan_pcs_rxb_report` `d_drugplan_pcs_std_report` `d_drugplan_restat_report` `d_exp_trans_to_text` `d_pcs_rxb_std_trans_to_text_for_partials` `d_pcs_rxb_trans_to_text_for_partials_rxb` `d_pcs_std_trans_to_text` `d_pcs_std_trans_to_text_for_partials` `d_pcs_trans_to_text` `d_restat_trans_to_text` `d_rxb_elig_partials_by_memsyskey_re` `d_rxb_elig_partials_full` `d_rxb_mater_key_list_fullfile`	`drug_covr_exp_trans` `drug_covr_pcs_rxb_trans` `drug_covr_pcs_std_trans` `drug_covr_pcs_trans` `drug_covr_restat_trans` `drug_plan_exts` `election_coverages` `elections` `members`

enrolaud — 1 windows

Window	Title	DataWindows	Tables
`w_enrollment_log`	Enrollment Audit Log	`d_audit_trail_addresses` `d_audit_trail_cob` `d_audit_trail_dep` `d_audit_trail_election` `d_audit_trail_election_coverages` `d_audit_trail_enrollment` `d_audit_trail_member_cat_val` `d_audit_trail_member_eligibilites` `d_audit_trail_members` `d_audit_trail_student` `d_audit_trail_waiting_pd`	`addresses` `aud_trail_mbr` `coord_of_bens` `election_coverages` `elections` `family` `member_cat_val` `member_eligibilities` `member_waiting_periods` `members` `students`

enroll — 38 windows

Window	Title	DataWindows	Tables
`w_enroll_cobra_dependent_address_sync`		`d_enroll_cobra_dependent_address_sync`	`addresses` `members`
`w_enroll_custom_term_add_members`	window to add members to the custom term transaction table	`d_family_members`	`family` `members`
`w_enroll_custom_term_generate`	window to generate letter hist entries from the custom term transaction table	`d_custom_term_form` `d_enroll_custom_term_dependents` `d_enroll_custom_term_members_elig` `d_enroll_custom_term_subscriber_info` `d_usfhp_term_form`	`addresses` `custom_term_transactions` `groups` `member_eligibilities` `members`
`w_enroll_custom_term_print`	Termination Letters Print Maintenance	`d_custom_term_form` `d_custom_term_maintenance` `d_usfhp_term_form`	`report_hist`
`w_enroll_group_export`	Export Group Eligibility	`d_export_eligibility`
`w_enroll_hipaa_add_members`	window is used to add members to the hipaa transactions table	`d_family_members`	`family` `members`
`w_enroll_hipaa_generate`	Generate HIPAA Form	`d_enroll_hipaa_dependents` `d_enroll_hipaa_members_elig` `d_enroll_hipaa_subscriber_info` `d_hipaa_form`	`addresses` `election_coverages` `groups` `hipaa_transactions` `member_eligibilities` `members`
`w_enroll_hipaa_member_coverage_search`		`d_hipaa_member_coverage_search`	`election_coverages` `members`
`w_enroll_hipaa_print`	HIPAA Print Maintenance	`d_hipaa_form` `d_hipaa_maintenance`	`report_hist`
`w_enroll_member_select`	Window used to select a member.	`d_enroll_choose_member`
`w_enroll_member_selection`	Member selection screen for w_enrollment_maintenance. Alternate version.	`d_enroll_member_selection`	`family` `member_eligibilities` `members`
`w_enroll_pcp_search`	Used by n_enroll_member_pcp. Response window to select PCP provider.	`d_enroll_pcp_prov_criteria` `d_enroll_pcp_search`	`contracts` `health_care_networks` `pm_addresses` `provider_tins` `providers`
`w_enroll_qmcso_maint`	Main QMCSO Entry Window	`d_qmcso_custodian_info` `d_qmcso_maint_select_info`	`members` `pm_addresses` `qmcso_custodians` `vendor_addresses` `vendors`
`w_enroll_qmcso_select`	Selection Window for QMCSO	`d_enroll_qmcso_select`	`member_eligibilities` `members`
`w_enroll_trans_div`	Response window to enter a Division to receive an existing eligibility period.	`d_enroll_groups`
`w_enroll_view_wait_period`	Response window to view and edit multiple HIPAA waiting period start dates	`d_enroll_wait_pd_display`
`w_enrollment_cob_maint`	Coordination of Benefits	`d_cob_address` `d_qe_cob_detail`	`addresses` `coord_of_bens`
`w_enrollment_maintenance`	HOMER - Member Enrollment Maintenance	`d_cobra_non_qual_events` `d_enroll_address` `d_enroll_cobra_dependent_address_sync` `d_enroll_dependent_address` `d_enroll_dependent_coverage_elections` `d_enroll_dependent_eligibility_period` `d_enroll_dependent_student_info` `d_enroll_dependent_wait` `d_enroll_family_member_select` `d_enroll_group_cat_parms` `d_enroll_group_option_vals` `d_enroll_member_demographics` `d_enroll_member_dependent_categories` `d_enroll_member_dependents` `d_enroll_member_phone` `d_enroll_member_subscriber_categories` `d_enroll_member_summary_info` `d_enroll_sub_elig_pd_display` `d_enroll_subscriber_coverage_riders` `d_enroll_subscriber_eligibility_period` `d_enroll_subscriber_member_coverage` `d_enroll_wait_pd` `d_qe_cob_detail` `dddw_group_categories`	`addresses` `cobra_non_qual` `coord_of_bens` `coverages` `election_coverages` `election_riders` `elections` `group_member_cat` `group_option_vals` `groups` `member_cat_val` `member_eligibilities` `member_waiting_periods` `members` `students`
`w_family_member_select`	Window used to select family member to display notes.	`d_enroll_family_member_select`
`w_group_hb1_member_select`	HOMER - HB1 Member Select	`d_enroll_dependents_for_subscriber`	`members`
`w_group_member_select`	HOMER - Member Select	`d_enroll_dependents_for_subscriber`	`members`
`w_hb1_maintenance`	HOMER - HB1 Member Maintenance	`d_hb1_member_detail` `d_hb1_member_summary_info` `d_hb1_payment_detail`	`groups` `hb1_members` `hb1_payments` `members`
`w_hipaa_cert_report`	window for running and printing the hipaa certificate_report	`d_hipaa_cert_background` `d_hipaa_cert_report`	`groups` `members` `note_key_codes` `notes`
`w_hipaa_dead_file`	window for logging undeliverable HIPAA certificates	`d_hipaa_history`	`note_key_codes`
`w_master_group_select`	Window used to select a master group from a list of groups that matches search criteria.	`d_enroll_master_group_select`
`w_member_select`	Window used to select a member.	`d_enroll_member_select`
`w_member_select_by_group_id`	Select member from list retrieved from group ID only	`d_enroll_member_select_by_group_id`	`members`
`w_member_select_by_last_name`	Window used to select a member from a list of members that match last name criteria.	`d_enroll_member_select_by_last_name`
`w_member_select_by_last_name_no_group`	Copy of w_member_select...last_name but configured to not need a group_id	`d_enroll_member_select_by_last_name_ng`	`members`
`w_member_select_by_mbr_id`	Window used to select a member from a list of members that match member ID criteria.	`d_enroll_member_select_by_mbr_id`
`w_notes_hipaa_report_view`	window for hipaa notes report.	`d_notes_hipaa_report_get_all` `d_notes_hipaa_report_get_group` `d_notes_hipaa_report_get_member` `d_notes_hipaa_report_select_entity`	`groups` `members` `notes`
`w_qmcso_member_detail`		`d_enroll_qmcso_select_detail`	`pm_addresses` `qmcso_custodians` `vendors`
`w_quick_enroll_cob`	OLD Window for Quick Enrollment dependent Coordination of Benefits	`d_quick_enroll_dep_coord`	`coord_of_bens`
`w_quick_enroll_dep_addr`	Dependent Address	`d_enroll_address`	`addresses`
`w_quick_enroll_dep_cat`	Window to assign Dependent Categories	`d_enroll_dep_category`	`member_cat_val`
`w_quick_enroll_dep_student`	Window to edit Dependent Student information in Quick Enrollment	`d_quick_enroll_dep_student`	`addresses` `students`
`w_quick_enroll_main`	Homer - Quick Enrollment	`d_enroll_address` `d_enroll_category` `d_enroll_dep_category` `d_enroll_dependent_wait` `d_qe_cob_detail` `d_quick_enroll_all_cat` `d_quick_enroll_covg_elect` `d_quick_enroll_dep` `d_quick_enroll_dep_elig_pd` `d_quick_enroll_dep_student` `d_quick_enroll_family` `d_quick_enroll_group` `d_quick_enroll_mem_covg` `d_quick_enroll_sub_cov_elect` `d_quick_enroll_sub_eligible_pd` `d_quick_enroll_sub_wait_pd` `d_quick_enroll_subscriber`	`addresses` `coord_of_bens` `coverages` `election_coverages` `elections` `family` `member_cat_val` `member_eligibilities` `member_waiting_periods` `members` `students`
`w_subscriber_select`	Window used to select a subscriber for a member.	`d_enroll_subscriber_select`

enrollutils — 4 windows

Window	Title	DataWindows	Tables
`w_fsa_depcare_tax_statements`		`d_fsa_depcare_eoy_listing` `d_fsa_depcare_tax_rpt1` `d_fsa_depcare_tax_rpt2`	`groups` `members`
`w_fsa_notices`	Flexible Spending Account Notices	`d_fsa_filing_period` `d_fsa_notice`	`benefit_plans` `coverages` `elections` `member_eligibilities` `members`
`w_reenroll`		`d_group_covr` `d_reenroll_coverages` `d_term_codes` `d_term_groups`	`group_coverages` `groups`
`w_term_errors`	window to display errors for u_terminate	`d_term_errors` `d_term_groups`	`groups` `members`

enrolrpt — 11 windows

Window	Title	DataWindows	Tables
`w_annlstmt`	Annual Statement	`d_annlstmt_back_page` `d_annlstmt_beneficiary_name` `d_annlstmt_coverages` `d_annlstmt_dependents` `d_annlstmt_employees` `d_annlstmt_front_page` `d_annlstmt_group_ids` `d_annlstmt_member_coverages` `d_annlstmt_select_comp` `d_annlstmt_select_comp_with`	`addresses` `dual` `elections` `group_coverages` `groups` `member_cat_val` `member_eligibilities` `members`
`w_annlstmt_group_select`	This window selects a group	`d_annlstmt_group_select`	`groups`
`w_annlstmt_member_select`	window for selecting a member when multiple members exist with the same ssn.	`d_annlstmt_member_select`	`members`
`w_annlstmt_option_maintenance`	Window to maintain the annual statement options.	`d_annlstmt_option_maintenance` `d_annlstmt_option_maintenance_with`	`annual_statement_options` `groups`
`w_annlstmt_report_date`	Receive Annual Statements	`d_annlstmt_report_date_members`	`members`
`w_census_rpt_args_sheet`	Window for selecting parameters of census reports	`d_coverage_levels` `d_rpt_select`	`codes`
`w_dep_audit`	Dependent Eligibility Audit	`d_cobradw_cert_mailing` `d_dep_audit_final_report_detail` `d_dep_audit_final_report_summary` `d_dep_audit_first_letter_dependents` `d_dep_audit_first_letter_main` `d_dep_audit_first_letter_subscriber_list` `d_dep_audit_group_list` `d_dep_audit_print_rpt` `d_dep_audit_second_letter_dependents` `d_dep_audit_second_letter_main` `d_dep_audit_second_letter_subscriber_list`	`addresses` `group_option_vals` `groups` `members`
`w_enrollrpt_deps_over_age`	window to run the dependents over age xx report	`d_enrollrpt_deps_age`	`groups` `members`
`w_enrollrpt_error_rpts`	Winodw to display enrollment error reports (Single member multi-person coverages, members without coverages)	`d_enrollrpt_nocov` `d_enrollrpt_single_in_multi`	`elections` `members`
`w_hb1_report`	HB1 Member Report	`d_rpt_hb1_payment`	`hb1_payments` `members`
`w_mmo_audit`		`d_mmo_audit`	`claim_messages` `claims` `fund_register` `members` `vendors`

funding — 51 windows

Window	Title	DataWindows	Tables
`w_bill_ome_b_and_r`	Ome-Resa Billing and Remittance Process	`d_bill_ome_b_and_r_current_month` `d_bill_ome_b_and_r_prior_month`	`elections` `groups` `members`
`w_bill_ome_wire_transfer`	OME-RESA Wire Transfer	`d_bill_ome_wire_transfer` `d_bill_ome_wire_transfer_aetna_only` `d_bill_ome_wire_transfer_non_aetna`	`fund_register` `group_option_vals`
`w_bill_ome_wire_transfer_adj`		`d_bill_ome_wire_transfer_adj`	`ome_resa_wire_xfer_adj`
`w_burns_claim_dump`	Burns Claims Transfer	`d_burns_claims_dump`	`claim_lines` `claims` `members`
`w_burns_enrollment_dump`	Burns EnrollmentTransfer	`d_burns_coverage` `d_burns_enrollment_count` `d_burns_enrollment_dump` `d_burns_enrollment_dump_all_emps_w_syskey` `d_burns_single_add` `d_burns_single_dental` `d_burns_single_deplife` `d_burns_single_drugs` `d_burns_single_life` `d_burns_single_medical` `d_burns_single_suppadd` `d_burns_single_supplife` `d_burns_single_vision` `d_burns_single_vsp`	`election_coverages` `elections` `member_eligibilities` `members`
`w_clm_payments_on_waiver`		`d_rpt_payments_on_waiver`	`claims` `fund_register` `groups` `members` `vendors`
`w_fund_acct_hierarchy`	window listing hierarchy, bank accounts and fund pages for a group	`d_fund_hierarchy` `d_fund_hierarchy_bank_acct_info` `d_fund_hierarchy_bank_accts` `d_fund_hierarchy_coverages` `d_fund_hierarchy_fund_page_info` `d_fund_hierarchy_fund_page_list` `d_fund_hierarchy_fund_pages`	`bank_acct_info` `bank_acct_info_grps` `bank_forms` `codes` `coverages` `fund_page_covrs` `fund_page_grps` `fund_pages` `groups`
`w_fund_acct_hierarchy_add_entity`	response window to add a bank account or fund page for the hierarchy window	`d_fund_hierarchy_add_bank_account`	`groups` `sfpidba.groups`
`w_fund_acct_hierarchy_select_group`	response window for hierarchy window to allow user to pick a group	`d_fund_hierarchy_select_group`	`groups`
`w_fund_adjust_claim`	Adjust Claim	`d_fund_adjust_claim`	`fund_register`
`w_fund_adjust_expected_refund`	window for adjusting/adding expected refund amounts on claims in payment allocation	`d_fund_add_expected_refund` `d_fund_adjust_expected_refund` `d_fund_adjust_refund`	`claim_messages` `claims` `fund_register`
`w_fund_bank_acct_info_maint`	Bank Account Maintenance	`d_fund_bank_acct_info_maint`	`bank_acct_info` `bank_forms`
`w_fund_bank_acct_info_selection`	Bank Account Selection	`d_fund_bank_acct_info_select` `d_fund_bank_form_bank`	`bank_acct_info` `bank_forms`
`w_fund_bank_acct_select`	This window allows the user to select a bank account for a group	`d_fund_bank_acct_select`	`bank_acct_info` `bank_acct_info_grps`
`w_fund_bank_reconciliation_file`	Bank Reconciliation File	`d_fund_bank_reconciliation_file_errors` `d_fund_bank_reconciliation_file_print`
`w_fund_check_detail`	This window shows what has been paid by a check (or worksheet)	`d_fund_check_detail` `d_fund_manual_check`	`fund_register` `fundtrans` `pm_addresses` `sfpidba.fundtrans` `vendors`
`w_fund_check_inquiry`	Outgoing Check Inquiry For Group	`d_fund_check_inquiry`	`fundtrans` `sfpidba.fundtrans`
`w_fund_check_maintenance`	Incoming Check Maintenance For Group	`d_fund_check_maintenance` `d_fund_check_status_search`	`check_log`
`w_fund_check_process_err_rpt`	This Window is for the Fund Check processing error report that pulls back all register statuses that are not NULL.	`d_fund_check_process_err_rpt` `d_fund_check_process_err_rpt_print`	`fund_register`
`w_fund_check_select`	This window allows the user to select a check for a group	`d_fund_check_select`	`check_log` `sfpidba.check_log`
`w_fund_delinquent_claims_detail`	This is the window for the delinquent claims detail.	`d_fund_delinquent_claims_detail` `d_fund_delinquent_claims_detail_print`	`fund_register` `groups` `members`
`w_fund_delinquent_claims_summary`	This is the window that summarizes the delinquent claims by giving a count and dollar amount of the total delinquent claims and then the total amount of those claims on waiver or on hold.	`d_fund_delinquent_claims_summary`	`fund_register` `groups`
`w_fund_deposit`	This window allows the user to make deposits and fund registers/claims	`d_fund_check_select` `d_fund_deposit_locked_claims` `d_fund_fund_claims` `d_fund_fund_source` `d_fund_page_deposit`	`check_log` `fund_page_grps` `fund_pages` `sfpidba.check_log` `sfpidba.fund_pages` `sfpidba.fund_register`
`w_fund_drug_card_groups_maintenance`	maintenance window maintain groups for a drug plan	`d_fund_drug_card_groups` `d_fund_drug_card_plans`	`drug_card_groups` `fund_pages` `sfpidba.drug_card_groups`
`w_fund_drug_card_payment`	Drug Card Payments	`d_fund_drug_card_payment` `d_fund_drug_card_payment_print` `d_fund_drug_card_plans` `d_fund_manual_check_print`	`bank_acct_info` `bank_forms` `drug_card_groups` `groups` `sfpidba.drug_card_groups`
`w_fund_drug_card_plan_maintenance`	maintenance window to maintain vendors who have drug plans	`d_fund_drug_card_plan_select`	`codes` `drug_cards` `sfpidba.drug_cards` `vendors`
`w_fund_fund_page_listing`	Fund Page Listing Report	`d_fund_fund_page_listing` `d_fund_fund_page_listing_print`	`fund_page_covrs` `fund_page_grps` `fund_pages`
`w_fund_funding_status`	Funding Status Report	`d_fund_funding_status` `d_fund_funding_status_for_all_grps` `d_fund_funding_status_for_all_grps_print` `d_fund_funding_status_print`	`codes` `fund_pages`
`w_fund_group_select`	This window allows the user to select a group	`d_fund_group_select`	`groups` `sfpidba.groups`
`w_fund_group_transaction_history`	Window to view the transactions of an entire group or divisions of a group by transaction type and time period.	`d_fund_group_transaction_results` `d_fund_group_transaction_results_print` `d_fund_group_transaction_results_summary` `d_fund_group_transaction_select_criteria` `d_fund_group_transaction_trans_type` `d_fund_transaction_summary_print`	`check_log` `codes` `fund_page_grps` `fund_pages` `fund_register` `fundtrans`
`w_fund_manual_check`	Write Manual Check	`d_fund_manual_check` `d_fund_manual_check_print` `d_fund_page_transfer_list`	`bank_acct_info` `bank_forms` `fund_page_grps` `fund_pages` `fundtrans` `pm_addresses` `sfpidba.fund_pages` `sfpidba.fundtrans` `vendors`
`w_fund_negative_balance`	This is the screen version of the negative balance report	`d_fund_negative_balance` `d_fund_negative_balance_print`	`bank_acct_info` `bank_acct_info_grps` `codes` `fund_page_grps` `fund_pages` `groups`
`w_fund_omeresa_monthly_claims_data`	OMERESA Monthly Claims Data	`d_fund_omeresa_monthly_claims_data`	`fund_register` `fundtrans` `v_claim_members` `vendors`
`w_fund_outstanding_checks`	This is the window for showing all the outstanding checks.	`d_fund_outstanding_checks` `d_fund_outstanding_checks_print`	`bank_acct_info` `bank_acct_info_grps` `fundtrans`
`w_fund_page_maint`	Fund Page Maintenance	`d_fund_fund_page_grps` `d_fund_group_fund_info` `d_fund_group_hierarchy` `d_fund_hierarchy_coverages` `d_fund_page_edit` `d_fund_page_group_list`	`bank_acct_info` `codes` `coverages` `fund_page_covrs` `fund_page_grps` `fund_pages` `groups`
`w_fund_page_selection`	Fund Page Selection	`d_fund_group_fund_list`	`groups`
`w_fund_receive_refund`	Receive Refund	`d_fund_receive_refund`	`fund_register`
`w_fund_receive_refund_vendor_list`	response window to pick a vendor	`d_fund_receive_refund_vendor_list`	`fund_register` `members` `vendors`
`w_fund_reconcile`	Reconciliation	`d_fund_reconcile_check` `d_fund_reconcile_deposit`	`codes` `fundtrans`
`w_fund_reconcile_report`	Bank Reconciliation	`d_fund_reconcile_report` `d_fund_reconcile_report_check` `d_fund_reconcile_report_print`	`fundtrans`
`w_fund_reissue_check`	This window allows the user to reissue or void a check	`d_fund_check_detail`	`fund_register` `fundtrans` `sfpidba.fundtrans`
`w_fund_schedule_component`	Window for creating a component for scheduling	`d_fp_codes` `d_fund_bank_acct_grps` `d_fund_base_groups` `d_fund_component` `d_fund_component_fundpages` `d_fund_component_groups` `d_fund_fundpage_coverages` `d_fund_fundpage_list` `d_fund_grp_excludes` `d_fund_heirarchy_v2` `d_fund_security_users`	`bank_acct_info` `bank_acct_info_grps` `bank_forms` `codes` `coverages` `fund_page_covrs` `fund_page_grps` `fund_pages` `funding_group_excludes` `groups` `grp_sched_funds` `grp_sched_incls` `sched_comp` `security_user_class_user`
`w_fund_split_payments`	This is the window for splitting benefit payments.	`d_fund_split_payments`	`fund_register` `members`
`w_fund_tab_schedule`	Funding Schedules	`d_fund_component_list` `d_fund_schedule` `d_fund_schedule_missing` `d_fund_schedule_run_components` `d_fund_schedule_runs`	`claim_statuses` `groups` `sched_comp` `sched_run_comps` `schedule_runs`
`w_fund_transfer`	This window allows the user to transfer funds between fundpages	`d_fund_page_transfer_list`	`fund_page_grps` `fund_pages` `sfpidba.fund_pages`
`w_fund_vendor_quick_add`	Vendor Quick Add	`d_fund_vendor_address_quick_add` `d_fund_vendor_info_quick_add` `d_fund_vendor_select`	`pm_addresses` `sfpidba.vendors` `vendors`
`w_fund_vendor_select_quick_add`	This window is for choosing the vendor when a vendor search retrieved multiple vendors.	`d_fund_vendor_select`	`sfpidba.vendors` `vendors`
`w_fund_wdi_period_as_modified_rpt`	window for WDI as modified report	`d_fund_wdi_period_as_modified_rpt`	`fund_register` `fundtrans` `groups` `members`
`w_fund_wdi_period_rpt`	This is the window for the WDI Period Rpt.	`d_fund_wdi_period_rpt` `d_fund_wdi_period_rpt_print` `d_fund_wdi_period_rpt_print_short_ssn` `d_fund_wdi_period_rpt_short_ssn`	`fund_register` `groups` `members`
`w_pospay`	Positive Pay Check Outbound File	`d_pospay_output` `d_pospay_output_125` `d_pospay_output_citz` `d_pospay_unsent` `d_pospay_unsent_125` `d_pospay_unsent_citz`	`bank_acct_info` `fund_pages` `fund_register` `fundtrans`
`w_withholding_reports`		`d_withholding_reports_base_data` `d_withholding_reports_census` `d_withholding_reports_claims` `d_withholding_reports_printed` `dddw_states`	`addresses` `claims` `elections` `fund_register` `pm_addresses`

homersys — 22 windows

Window	Title	DataWindows	Tables
`w_accident_type`	Accident type edit window	`d_accident_types`	`accident_types`
`w_addr_link`	User interface to select which persons/groups addresses should be updated for u_mailers	`d_addrno_link`	`group_contacts`
`w_addr_search`	Search interface window for u_mailers	`d_addr_search` `d_address`	`addresses`
`w_batch_reports`		`d_batch_reports`	`batch_reports`
`w_code_key_maint`	Window to maintain code keys.	`d_code_key_update`	`code_keys`
`w_code_maint`	Window to maintain code values.	`d_code_keys` `d_codes_grid` `d_codes_rpt`	`codes`
`w_edi_report`	Report window showing EDI submitted by group	`dw_edi_sub_by_group`	`edi_submitter_table`
`w_examiner_select`	Examiner list selection window	`d_examiner_selection`	`sfpidba.user_info` `user_info`
`w_general_member_cat_maintenance`	window to maintain the possible list of group options	`d_general_member_cat_maintenance`	`general_cat`
`w_group_options_maintenance`	window to maintain group options	`d_group_options_maintenance`	`group_options`
`w_header`	maintanance window for letter headers	`d_letter_headers_groups` `d_letter_headers_maint`	`groups` `letter_headers` `sfpidba.letter_headers`
`w_homer_social_search`	This window will allow the user to chose a member who is active in multiple groups.	`d_homer_social_parms` `d_member_listing` `d_member_listing_dates`
`w_member_search`	Select Subscriber	`d_member_search`	`addresses` `groups` `members`
`w_pridecare`	Pridecare Monthly Billing Extract	`d_dep_info` `d_pridecare_coverages` `d_pridecare_select` `d_pridecare_subscribers`	`addresses` `elections` `groups` `member_cat_val` `member_eligibilities` `members`
`w_pridecare_bill_data`	mod of the pridecare report	`d_pridecare_coverages` `d_pridecare_select` `d_pridecare_subscribers_bill_data`	`elections` `groups` `member_eligibilities` `members`
`w_provider_search`	Provider list selection window	`d_provider_search`	`contracts` `health_care_networks` `pm_addresses` `provider_addresses` `provider_tins` `providers`
`w_release_notes`		`d_release_notes`
`w_state_report`	WIndow to show members and claims for specified states over time	`d_state_report` `d_states`	`groups` `member_eligibilities` `state`
`w_system_menu`	Window providing navigator 'buttons' for all the functions for Homer	`d_system_menu_datawindow` `d_sytem_menu_tabular_new`	`system_menu`
`w_system_tree_menu`	Menu	`d_user_ini` `d_user_ini_sysnotes`	`user_ini`
`w_test_log`	Window used to record bugs during testing	`d_test_log`	`test_log`
`w_user_detail`	Popup window to display system information about the current user	`d_user_detail`

idcard — 2 windows

Window	Title	DataWindows	Tables
`w_enroll_idcard_usfhp`	Window to process USFHP idcard requests, as well as generate request listing and accompanying letter.	`d_enroll_idcard_usfhp` `d_enroll_idcard_usfhp_letter` `d_enroll_idcard_usfhp_rpt`	`addresses` `id_card_req` `members`
`w_homer_id_req`	Window used to submit id card request for individuals or groups.	`d_group_id_req_parms` `d_group_subs` `d_indiv_id_req_parms` `d_individual_subs`	`addresses` `elections` `groups` `member_eligibilities` `members`

moon — 5 windows

Window	Title	DataWindows	Tables
`w_moon_claims`		`d_claim_status_order` `d_moon_keys` `d_moon_negs` `d_moon_negs_rpt`	`claim_status_order` `codes` `moon_negotiations`
`w_moon_in_repricing`	EDI reprice maintenance	`d_claim_status_order` `d_edi_trading_partner_search` `d_moon_in_repricing`	`claim_status_order` `edi_in_repricing`
`w_moon_oon_product_maintenance`	OON Product Maintenance	`d_moon_oon_product_groups` `d_moon_oon_product_hcn_exclusions` `d_moon_oon_products` `d_moon_product_claim_types`	`groups` `health_care_networks` `oon_product_claim_types` `oon_product_groups` `oon_product_hcn_exclusions` `oon_products`
`w_moon_oon_product_select`	Selection window when more than one possible Moon product has been retrieved.	`d_moon_oon_product_select`	`oon_products`
`w_moon_provider_list`		`d_moon_neg_providers`	`moon_negotiations`

pfcapsrv — 2 windows

Window	Title	DataWindows	Tables
`pfc_w_debuglog`	PFC Display log utility window	`d_debuglog`
`pfc_w_message`	PFC Message Box window	`d_messageprint`

pfcdwsrv — 5 windows

Window	Title	DataWindows
`pfc_w_dwdebugger`	PFC DataWindow Debugger dialog	`d_dwdebuggerattributes` `d_dwdebuggerstatus`
`pfc_w_filterextended`	PFC Extended Filter dialog window	`d_columnnames` `d_dwfunction` `d_dwfunctioncategory`
`pfc_w_filtersimple`	PFC Simple Filter dialog window	`d_filtersimple`
`pfc_w_sortdragdrop`	PFC Drag/Drop Style Sort dialog window	`d_sortdragdrop`
`pfc_w_sortmulti`	PFC DDLB-style Sort dialog window	`d_sortmulti`

pfcwnsrv — 1 windows

Window	Title	DataWindows	Tables
`pfc_w_toolbars`	PFC Customizable Toolbars window	`d_toolbars`

preex — 2 windows

Window	Title	DataWindows	Tables
`w_preex_maint`	This is the principle pre-existing conditions maintenance window	`d_enroll_wait_pd` `d_preex_conditions` `d_preex_count` `d_preex_eligibility_periods` `d_preex_member_select`	`diagnosis_codes` `member_eligibilities` `member_waiting_periods` `members` `pre_existing_conditions`
`w_preex_member_select`	This window selects a member to view preexisting conditions for	`d_preex_member_select`	`members`

pricing — 14 windows

Window	Title	DataWindows	Tables
`w_pricing_conversion_schedule`	Conversion Factor Schedule Maintenance	`d_pricing_conversion_schedule` `d_pricing_conversion_unit`	`conversion_factor_details` `sfpidba.conversion_factor_details`
`w_pricing_conversion_schedule_select`	This window allows the user to select a conversion schedule	`d_pricing_conversion_schedule_select`	`conversion_factors`
`w_pricing_drg_schedule`	DRG Weight Maintenance	`d_pricing_drg_schedule`	`drg_weight_details` `sfpidba.drg_weight_details`
`w_pricing_drg_schedule_select`	This window allows the user to select a drg schedule	`d_pricing_drg_schedule_select`	`drg_weights` `sfpidba.drg_weights`
`w_pricing_fee_schedule`	Fee Schedule Maintenance	`d_pricing_fee_schedule`	`fee_schedule_details` `sfpidba.fee_schedule_details`
`w_pricing_fee_schedule_select`	This window allows the user to select a fee schedule	`d_pricing_fee_schedule_select`	`fee_schedules` `sfpidba.fee_schedules`
`w_pricing_per_diem_schedule`	Tiered Per Diem Schedule Maintenance	`d_pricing_per_diem_schedule`	`sfpidba.tiered_per_diem_details` `tiered_per_diem_details`
`w_pricing_per_diem_schedule_select`	This window allows the user to select a per diem schedule	`d_pricing_per_diem_schedule_select`	`sfpidba.tiered_per_diem_schedules` `tiered_per_diem_schedules`
`w_pricing_plan_maintenance`	Pricing Plan Maintenance	`d_pricing_plan_diag` `d_pricing_plan_diag_cd` `d_pricing_plan_diag_cd_type` `d_pricing_plan_drg_cd` `d_pricing_plan_methods` `d_pricing_plan_pos_cd` `d_pricing_plan_proc` `d_pricing_plan_proc_cd` `d_pricing_plan_proc_cd_type` `d_pricing_plan_rev_cd` `d_pricing_plan_rule_edit` `d_pricing_plan_rules` `d_pricing_plan_specialties`	`diagnosis_codes` `drg_codes` `place_of_service_codes` `pricing_methods` `pricing_rule_diags` `pricing_rule_procs` `pricing_rules` `procedure_codes` `sfpidba.diagnosis_codes` `sfpidba.drg_codes` `sfpidba.pricing_methods` `sfpidba.pricing_rule_diags` `sfpidba.pricing_rule_procs` `sfpidba.pricing_rules` `sfpidba.procedure_codes` `sfpidba.specialties` `specialties` `valid_methods`
`w_pricing_plan_maintenance_select`	This window selects a pricing plans	`d_pricing_plan_maintenance_select`	`pricing_plans`
`w_pricing_rbrvs`	This window maintains the rbrvs multipliers	`d_pricing_rbrvs`	`master_multipliers` `sfpidba.master_multipliers`
`w_pricing_schedule_select`	This window allows the user to select a pricing schedule to attach to a rule.	`d_pricing_conversion_schedule_select` `d_pricing_drg_schedule_select` `d_pricing_fee_schedule_select` `d_pricing_per_diem_schedule_select`	`conversion_factors` `drg_weights` `fee_schedules` `sfpidba.drg_weights` `sfpidba.fee_schedules` `sfpidba.tiered_per_diem_schedules` `tiered_per_diem_schedules`
`w_pricing_unit_schedule`	Unit Schedule Maintenance	`d_pricing_unit_schedule` `d_pricing_unit_schedule_type`	`sfpidba.unit_schedule_details` `unit_schedule_details`
`w_pricing_unit_schedule_select`	This window allows the user to select a unit schedule	`d_pricing_unit_schedule_select`	`sfpidba.unit_schedules` `unit_schedules`

provider — 31 windows

Window	Title	DataWindows	Tables
`w_1099_print`	Print 1099 Forms	`d_1099_filter` `d_1099_form` `d_1099_print_select` `d_1099nec_form`	`print_1099s`
`w_edi_clearinghouse`	EDI Clearinghouse Maintenance	`d_edi_clearinghouse_contacts` `d_edi_clearinghouses` `d_edi_pm_contacts`	`outb_edi_clearhouse_contacts` `outbound_edi_clearinghouses` `pm_addresses` `pm_contacts`
`w_edi_clearinghouse_select`	Select a single outbound EDI clearinghouse	`d_edi_clearinghouse_select`	`outbound_edi_clearinghouses`
`w_edi_partners`	EDI Trading Partners	`d_edi_pm_contacts` `d_edi_trading_partner_contacts` `d_edi_trading_partners`	`outb_edi_tradingpart_contacts` `outbound_edi_trading_partners` `pm_addresses` `pm_contacts`
`w_edi_partners_select`	Select a single outbound EDI trading partner	`d_edi_trading_partner_select`	`outbound_edi_trading_partners`
`w_hcn_enrollment_dump`	Health Care Network Enrollment Dump	`d_aetna_group_list` `d_hcn_aetna` `d_hcn_cigna` `d_hcn_dump_select` `d_mmo_enrollment_selected` `d_ppo_census` `d_ppo_enrollment_selected` `d_ppo_group_selected`	`aetna_report_groups` `aetna_tmp` `health_care_networks` `mmo_enrollment_work` `ppo_census_ids` `ppo_enrollment_work` `ppo_group_work` `sfpidba.mmo_enrollment_work` `sfpidba.ppo_census_ids` `sfpidba.ppo_enrollment_work` `sfpidba.ppo_group_work`
`w_hms2`	HMS REPORTING	`d_hms_export_worksheet` `d_output`	`addresses` `election_coverages` `groups` `health_care_networks` `member_eligibilities` `members` `plan_pkgs`
`w_hms_report`	HMS REPORTING	`d_hms_dateselect` `d_hms_export_worksheet_s_and_e_dates` `d_output`	`addresses` `election_coverages` `groups` `health_care_networks` `member_eligibilities` `members` `plan_pkgs`
`w_hms_reporting`	HMS REPORTING	`d_hms_dateselect` `d_hms_export_worksheet` `d_output`	`addresses` `election_coverages` `groups` `health_care_networks` `member_eligibilities` `members` `plan_pkgs`
`w_provider_caremark_flag_transfer`	Caremark Flag File Transfer	`d_caremark_flag_divisions_ded_combined_w_oop_as_oop` `d_caremark_flag_divisions_ded_only_sep_dup` `d_caremark_flag_divisions_oop_duplicate` `d_caremark_flag_divisions_oop_only_and_separate` `d_caremark_flag_file` `d_caremark_flag_file_ded_combined_w_oop` `d_caremark_flag_file_oop` `d_caremark_flag_file_oop_dup_of_ded` `d_caremark_report_audit`	`caremark_report_audit` `groups` `sfpidba.caremark_report_audit`
`w_provider_change_segment`	This response window allows the user to change client segments	`d_select_client_segment`	`client_segment_users` `client_segments`
`w_provider_consolidate_vendors`	This window consolidates vendors	`d_provider_consolidate_vendors`	`pm_addresses` `vendors`
`w_provider_contract_maintenance`	Provider Contract Maintenance for Segment:	`d_city_state_search` `d_contract_holds` `d_contract_pricing` `d_contract_withhold` `d_contracts` `d_provider_type_search` `d_specialty_search`	`contract_holds` `contract_pricing` `contract_withholds` `contracts` `sfpidba.contract_holds`
`w_provider_group_select`	A window that allows the user to choose a group	`d_groups_for_user`	`groups`
`w_provider_hcn_maintenance`	HCN Maintenance	`d_hcn` `d_hcn_contact` `d_hcn_pricing` `d_hcn_withhold` `d_provider_contacts`	`hcn_contacts` `hcn_pricing` `hcn_withholds` `health_care_networks` `pm_addresses` `pm_contacts`
`w_provider_hcn_select`	This response window allows the user to select an HCN	`d_select_hcn` `d_select_hcn_with_panels`	`health_care_networks`
`w_provider_maintenance`	Provider Maintenance	`d_city_state_search` `d_medicaid` `d_provider` `d_provider_address` `d_provider_address_vendor` `d_provider_contacts` `d_provider_group_holds` `d_provider_hcn` `d_provider_holds` `d_provider_npi` `d_provider_panel` `d_provider_type_search` `d_specialty` `d_specialty_search` `d_tin`	`health_care_networks` `panels` `pm_addresses` `pm_contacts` `provider_address_vendors` `provider_addresses` `provider_group_holds` `provider_holds` `provider_medicaid_ids` `provider_npis` `provider_panels` `provider_specialties` `provider_tins` `providers` `sfpidba.provider_panels` `vendors`
`w_provider_open_cant_find_provider_msgs`	window to show open cannot find provider messages	`d_provider_open_cant_find_provider_msgs`	`claim_messages` `claim_status_order` `claims` `global_messages`
`w_provider_optum_flag_transfer`	Optum Flag File Transfer	`d_optum_flag_divisions_ded_combined_w_oop_as_oop` `d_optum_flag_divisions_ded_only_sep_dup` `d_optum_flag_divisions_oop_duplicate` `d_optum_flag_divisions_oop_only_and_separate` `d_optum_flag_file` `d_optum_flag_file_ded_combined_w_oop` `d_optum_flag_file_oop` `d_optum_flag_file_oop_dup_of_ded` `d_optum_report_audit`	`groups` `optum_report_audit`
`w_provider_panel_maintenance`	Provider Panel Maintenance for Segment:	`d_panel_pricing` `d_panel_withhold` `d_panels`	`panel_pricing` `panel_withholds` `panels`
`w_provider_rpt_hcn_pricing_methods`	HCN pricing methods report	`d_provider_rpt_hcn_pricing_methods`	`groups` `health_care_networks` `plan_pkgs`
`w_provider_segment_group`	A window that displays the client segment for a selected group	`d_client_segment`	`client_segments`
`w_provider_segment_user_maintenance`	This window maintains which client segments a user is in	`d_provider_segment_user_maintenance` `d_provider_users`	`client_segment_users` `sfpidba.client_segment_users`
`w_provider_select`	A window that allows the user to select a provider based on TIN or company name or last name	`d_provider_select`	`pm_addresses` `provider_addresses` `provider_tins` `providers`
`w_provider_select_urcm`	A window that allows the user to select a provider using the URCM selection criteria	`d_city_state_search` `d_provider_select_urcm` `d_provider_type_search` `d_specialty_search`	`pm_addresses` `provider_addresses` `provider_tins` `providers`
`w_provider_specialties`	Maintenance window for provider specialties	`d_specialties_maintenance`	`specialties`
`w_provider_tin_select`	This response window allows the user to select a vendor TIN	`d_provider_tin_select`	`provider_tins`
`w_provider_types_maintenance`	Maintenance window for provider types	`d_provider_types_maintenance`	`provider_types`
`w_provider_vendor_maintenance`	Vendor Maintenance	`d_147c_request` `d_provider_contacts` `d_provider_vendor` `d_provider_vendor_address` `d_provider_vendor_contact` `d_provider_vendor_holds` `d_provider_vendor_status` `d_w9_request` `d_w9_request_2`	`pm_addresses` `pm_contacts` `user_info` `vendor_addresses` `vendor_contacts` `vendor_holds` `vendors`
`w_provider_vendor_select`	This response window allows the user to select a vendor	`d_provider_vendor_select` `d_provider_vendor_status`	`pm_addresses` `vendors`
`w_unsearchable_tins`	Unsearchable Tins	`d_find_tins` `d_unsearchable_tins`	`provider_tins` `unsearchable_tins`

reprint — 7 windows

Window	Title	DataWindows	Tables
`w_claim_letters_setup`		`d_claim_letters_setup`	`report_info` `sfpidba.report_info`
`w_group_print_distribution`	Window used to set up print and check options for groups	`d_check_and_letter_setup` `d_group_print_distribution` `d_group_search_criteria` `dddw_grpprndist_selections`	`codes` `group_print_distribution` `groups`
`w_reprint`	print queue manager	`d_reprint`	`report_hist` `user_info`
`w_reprint_check_recon`		`d_reprint_check_recon`	`report_hist`
`w_reprint_claim_letters`	Print Claim Letters	`d_claims_frm_mailing_page` `d_claims_frm_register` `d_reprint_maintenance_claim_letters` `d_reprint_print_group`	`addresses` `claim_letters_hist` `claims` `group_print_distribution` `groups` `members`
`w_reprint_claim_reprice_letters`	Window used to print claims letters for requests for repricing sheets	`d_reprint_claim_reprice_letters`	`claim_letters_hist`
`w_reprint_maintenance`	Reprint Maintenance	`d_checkrun_eob` `d_checkrun_eob_comp` `d_checkrun_eob_dedsupp` `d_checkrun_eob_depcare` `d_checkrun_eob_ee_copy` `d_checkrun_eob_er_copy` `d_checkrun_eob_mdv` `d_checkrun_eob_medreim` `d_checkrun_eob_wdi` `d_checkrun_ra` `d_checkrun_ra_comp` `d_checkrun_ra_dedsupp` `d_checkrun_ra_hdr_copy` `d_checkrun_ra_mdv` `d_client_group_enroll_opts` `d_enroll_family_member_select` `d_fund_manual_check_print` `d_qmcso_dependent_names` `d_register_address_page` `d_register_address_page_landscape` `d_register_data_comp` `d_register_summary_comp` `d_reprint_maintenance` `d_reprint_maintenance_report_types` `d_system_group_contact_min_cat`	`addresses` `bank_acct_info` `bank_forms` `benefit_defs` `claim_entries` `claim_lines` `claims` `claims_wdi_info` `codes` `fund_register` `group_contacts` `group_enroll_opts` `groups` `members` `qmcso_custodians` `reason_codes` `report_hist` `vendors`

sales — 3 windows

Window	Title	DataWindows	Tables
`w_sales_ben_cat_maint_category_select`	response window to select categories	`d_sales_ben_cat_maintenance_select`	`rpt_svc_cats`
`w_sales_benefit_category_maintenance`	Benefit Category Maintenance for Segment:	`d_sales_ben_cat_maintenance_available` `d_sales_ben_cat_maintenance_chosen` `d_sales_ben_cat_maintenance_rpt_types` `d_sales_ben_cat_maintenance_select`	`benefit_defs` `code_keys` `rpt_svc_cats` `sfpidba.code_keys`
`w_sales_rpt_group_claim_detail`	Detailed Claims Listing	`d_benefit_coverage` `d_sales_rpt_grop_claim_data_confidential` `d_sales_rpt_group_claim_data` `d_sales_rpt_group_claim_detail` `d_sales_rpt_group_claim_detail_discount` `d_sales_rpt_group_claim_line_data` `d_sales_rpt_group_claim_line_data_dis` `d_sales_rpt_group_claim_payment_data` `d_sales_rpt_group_claim_rule_data`	`benefit_defs` `benefit_rules` `claim_entries` `claim_line_rules` `claim_lines` `claims` `claims_ub92_info` `fund_register` `fundtrans` `groups` `members` `providers` `vendors`

stoploss — 9 windows

Window	Title	DataWindows	Tables
`w_sl_contract_maint`		`d_sl_contract_coverage_maint` `d_sl_contract_coverages_checkbox` `d_sl_contract_domestic_tin_maint` `d_sl_contract_excl_plan_checklist` `d_sl_contract_excl_plan_maint` `d_sl_contract_factor_grid` `d_sl_contract_factor_maint` `d_sl_contract_group_maint` `d_sl_contract_header` `d_sl_contract_laser_maint` `d_sl_contract_maint` `d_sl_contract_option_val_list` `d_sl_group_select`	`codes` `coverages` `group_coverages` `groups` `members` `sl_contract_coverages` `sl_contract_domestic_tins` `sl_contract_excl_plans` `sl_contract_factors` `sl_contract_groups` `sl_contract_lasers` `sl_contract_option_vals` `sl_contract_options` `sl_contracts`
`w_sl_contract_selection`		`d_sl_contract_select` `d_sl_contract_select_ddw`	`carriers` `codes` `sl_contracts`
`w_sl_member_selection`		`d_sl_member_selection`
`w_sl_spec_clm_listing`	Specific Stoploss Claims Listing	`d_group_hierarchy_bottom_up` `d_sl_member_stoploss_parms` `d_sl_spec_clm_listing`	`claim_entries` `claims` `fundtrans` `group_stoploss_parms` `groups` `members` `v_fund_register_rpt` `vendors`
`w_sl_spec_summary`	Specific Stoploss Summary	`d_sl_specific_stoploss_family_summary` `d_sl_specific_stoploss_summary` `d_sl_specific_stoploss_summary_excel`	`family` `group_stoploss_parms` `groups` `member_eligibilities` `members`
`w_sl_specific_summary`		`d_sl_spec_2` `d_sl_spec_summary` `d_sl_stoploss_groups`	`claims` `group_stoploss_parms` `groups` `member_eligibilities` `members`
`w_sl_summary`	Modified by Austin Zellner	`d_sl_spec_2` `d_sl_spec_summary` `d_sl_specific_summary` `d_sl_stoploss_groups`	`claims` `group_stoploss_parms` `groups` `member_eligibilities` `members`
`w_sl_variable_clm_listing`	Variable Stoploss Claims Listing	`d_group_hierarchy_bottom_up` `d_sl_export_maz` `d_sl_variable_clm_listing`	`claim_entries` `claim_lines` `claims` `fundtrans` `groups` `members` `v_fund_register_rpt` `vendors`
`w_wang_idcard_response`		`d_wang_idcard_data` `d_wang_idcard_req` `d_wang_idcard_req_completed`	`addresses` `elections` `group_contacts` `groups` `id_card_req` `member_eligibilities`

svclog — 10 windows

Window	Title	DataWindows	Tables
`w_notes_display`	Simplified dw for displaying member notes	`d_notes_display`	`members` `note_entities` `notes`
`w_notes_entity_select`	This window selects which entity to view notes for	`d_notes_entity_select`
`w_notes_group_select`	This window selects a member to view notes for	`d_notes_group_select`	`groups` `sfpidba.groups`
`w_notes_hcn_select`	This window selects a HCN to view notes for	`d_notes_hcn_select`	`health_care_networks` `sfpidba.health_care_networks`
`w_notes_key_maintenance`	This window maintains key values	`d_notes_key_maintenance`	`note_key_codes` `sfpidba.note_key_codes`
`w_notes_key_select`	This window allows the user to modify a note's keys	`d_notes_key`	`note_key_codes` `sfpidba.note_key_codes`
`w_notes_member_select`	This window selects a member to view notes for	`d_notes_member_select`	`members`
`w_notes_provider_select`	This window selects a provider to view notes for	`d_notes_provider_select`	`pm_addresses` `provider_tins` `providers`
`w_notes_vendor_select`	This window selects a vendor to view notes for	`d_notes_vendor_select`	`sfpidba.vendors` `vendors`
`w_notes_view`	This is the principle note window where the note's text is stored and where searches are done	`d_notes_body` `d_notes_key` `d_notes_select_entity` `d_notes_system_keys`	`note_key_codes` `notes` `sfpidba.note_key_codes` `sfpidba.notes`

um_cm — 6 windows

Window	Title	DataWindows	Tables
`w_cm_billing`	cm billing reports and mainetance window	`d_cm_billing_composite` `d_cm_billing_composite_internal` `d_cm_billing_records` `d_cm_billing_status_cd` `d_cm_billing_type_cd`	`cm_billing` `members` `um_cases`
`w_cm_potential_resolution`		`d_um_cm_potentials_resolution`	`cm_potentials` `diagnosis_codes` `groups` `members` `um_cases` `um_entities`
`w_um_case_management`	Case Management	`d_um_cm_benefit_def_holds` `d_um_cm_case` `d_um_cm_case_involvements` `d_um_cm_diag_code_holds` `d_um_cm_diag_codes` `d_um_cm_hold_rules` `d_um_cm_hospital_contacts` `d_um_cm_proc_code_holds` `d_um_cm_proc_code_no_resolution` `d_um_cm_provider_holds` `d_um_cm_rule` `d_um_cm_service` `d_um_cm_service_benefit_defs` `d_um_cm_service_provider` `d_um_medical_director_review` `d_um_member_list` `d_um_physicians` `d_um_stoploss_carrier`	`benefit_defs` `cm_case_involvements` `cm_involvements` `diagnosis_codes` `members` `pm_addresses` `pm_contacts` `procedure_codes` `provider_tins` `providers` `um_benefit_definitions` `um_benefit_holds` `um_cases` `um_diagnosis_code_holds` `um_diagnosis_codes` `um_hold_rules` `um_medical_reviews` `um_physicians` `um_procedure_code_holds` `um_procedure_codes` `um_provider_contacts` `um_provider_holds` `um_rules` `um_services`
`w_um_cm_potential_create`	window to create cm potential records	`d_um_cm_potential_create`	`cm_potentials`
`w_um_cm_potentials_report`	CM Potentials Report	`d_cm_um_entities` `d_um_cm_potentials_report` `d_um_cm_potentials_report_print` `d_um_member_list` `d_um_stoploss_carrier`	`cm_potentials` `diagnosis_codes` `groups` `members` `um_cases` `um_entities`
`w_um_management_cases`	This window produces the UM management cases report	`d_um_an_rules` `d_um_cm_rule` `d_um_management_cases` `d_um_master_groups`	`diagnosis_codes` `groups` `um_cases` `um_diagnosis_codes` `um_rules` `um_services`

um_main — 14 windows

Window	Title	DataWindows	Tables
`w_cm_possible_rpt`	Possible CM claim report	`d_cm_possible_rpt`	`claim_line_diag_codes` `claims` `diagnosis_codes` `members` `um_cm_possible_case_claim`
`w_medical_director_review`	window for medical director reviews	`d_um_medical_director_review`	`um_medical_reviews` `um_rules`
`w_um_benefit_def_select`	window to select benefit definitions	`d_um_benefit_def_select`	`benefit_defs`
`w_um_case_patient_select`	window to select patient from members of current family	`d_um_member_list`	`members`
`w_um_diag_group_cd_select`	window to select diagnosis group code	`d_um_diag_group_cd_select`	`diagnosis_groups`
`w_um_diagnosis_cd_select`	Display the list of diagnosis codes and description	`d_um_diag_cd_select`	`diagnosis_codes`
`w_um_entities_report`	Entity report window	`d_um_entities_report`	`um_entities` `um_warnings`
`w_um_follow_up`	UM Follow-Ups	`d_um_follow_up` `d_um_member_list` `d_um_stoploss_carrier`	`members` `providers` `um_cases` `um_services`
`w_um_hold_rule_child`	Hold Rule:	`d_um_cm_provider_holds`	`providers` `um_provider_holds`
`w_um_member_select`	UM Member Select window	`d_um_members_select`	`member_eligibilities` `members`
`w_um_proc_group_cd_select`	Display the list of proc group codes	`d_um_proc_group_cd_select`	`procedure_groups`
`w_um_procedure_cd_select`	Display the list of proc codes	`d_um_proc_cd_select`	`procedure_codes`
`w_um_search`	UM Search	`d_um_demographics` `d_um_member_address` `d_um_member_list` `d_um_member_phone` `d_um_members_select` `d_um_record_list` `d_um_stoploss_carrier`	`addresses` `election_coverages` `member_eligibilities` `members` `um_cases`
`w_um_warning_display`	UM Warning display window	`d_warning_detail` `d_warning_master`	`plan_pkgs` `um_warnings`

um_maint — 14 windows

Window	Title	DataWindows	Tables
`w_cm_trigger_maintenance`	CM Trigger Maintenance window	`d_cm_trigger` `d_cm_trigger_codes_report` `d_cm_trigger_diag_codes` `d_cm_trigger_proc_codes`	`cm_trigger_diag_codes` `cm_trigger_proc_codes` `cm_triggers`
`w_cm_trigger_select`	CM Trigger Select window	`d_cm_trigger_select`	`cm_triggers`
`w_dm_enrollment_dump`	Disease Management	`d_dm_claim_dump_generic` `d_dm_enrollment_dump_generic` `d_dmentities` `d_dmentities_dump_select`	`claim_entries` `claim_lines` `claims` `claims_ub92_info` `groups`
`w_hcrm_claims_transfer`	HCRM_claims_transfer	`d_hcrm_claims_transfer`
`w_hcrm_enrollment_transfer`	HCRM Enrollment Transfer	`d_hcrm_enrollment_transfer`
`w_matria_claim_dump`	Matria Claims Transfer	`d_matria_claims_control_file` `d_matria_claims_dump`	`claim_lines` `claims` `members`
`w_matria_enrollment_dump`	Matria EnrollmentTransfer	`d_matria_enrollment_control_file` `d_matria_enrollment_dump`	`members`
`w_medical_director_maintenance`	Medical Director Maintenance	`d_medical_director`	`addresses` `medical_directors`
`w_medical_director_select`	For popup window to pick medical director for um_entity_medical_directors	`d_medical_director_select`	`addresses` `medical_directors`
`w_springbuk_claims_transfer`	Springbuk_claims_transfer	`d_springbuk_claims_transfer`	`claim_lines` `claims`
`w_springbuk_enrollment_transfer`	Springbuk Enrollment Transfer	`d_springbuk_enrollment_transfer`
`w_um_entity_maintenance`	UM Entity Maintenance	`d_medical_director` `d_um_entity_directors` `d_um_entity_maintenance` `d_um_entity_name` `d_um_entity_warnings`	`addresses` `cm_triggers` `medical_directors` `um_entities` `um_entity_medical_directors` `um_entity_warnings` `um_warnings`
`w_um_warning_select`	UM Warning Select window	`d_um_warning_select`	`um_warnings`
`w_warning_maintenance`	UM Warnings maintenance window	`d_warning_maintenance`	`um_warnings`

um_ur — 4 windows

Window	Title	DataWindows	Tables
`w_um_admission_notification`	Admission Notification	`d_qe_cob_detail` `d_um_an_case` `d_um_an_rules` `d_um_an_service` `d_um_cm_potential_create` `d_um_diag_codes` `d_um_hospital_contacts` `d_um_medical_director_review` `d_um_member_list` `d_um_physicians` `d_um_proc_code_no_resolution` `d_um_service_provider` `d_um_stoploss_carrier`	`cm_potentials` `coord_of_bens` `diagnosis_codes` `members` `pm_addresses` `pm_contacts` `procedure_codes` `provider_tins` `providers` `um_cases` `um_diagnosis_codes` `um_medical_reviews` `um_physicians` `um_procedure_codes` `um_provider_contacts` `um_rules` `um_services`
`w_um_authorization`	Authorization	`d_qe_cob_detail` `d_um_auth_benefit_def_holds` `d_um_auth_case` `d_um_auth_diag_code_holds` `d_um_auth_diag_codes` `d_um_auth_diag_groups` `d_um_auth_hold_rules` `d_um_auth_hospital_contacts` `d_um_auth_proc_code` `d_um_auth_proc_code_holds` `d_um_auth_proc_groups` `d_um_auth_provider_holds` `d_um_auth_rules` `d_um_auth_service` `d_um_auth_service_benefit_defs` `d_um_auth_service_provider` `d_um_auth_specialty_holds` `d_um_cm_potential_create` `d_um_medical_director_review` `d_um_member_list` `d_um_physicians` `d_um_stoploss_carrier`	`benefit_defs` `cm_potentials` `coord_of_bens` `diagnosis_codes` `diagnosis_groups` `members` `pm_addresses` `pm_contacts` `procedure_codes` `procedure_groups` `provider_tins` `providers` `um_benefit_definitions` `um_benefit_holds` `um_cases` `um_diagnosis_code_holds` `um_diagnosis_codes` `um_diagnosis_groups` `um_hold_rules` `um_medical_reviews` `um_physicians` `um_procedure_code_holds` `um_procedure_codes` `um_procedure_groups` `um_provider_contacts` `um_provider_holds` `um_rules` `um_services` `um_specialty_holds`
`w_um_pre_certification`	Pre-Certification	`d_qe_cob_detail` `d_um_cm_potential_create` `d_um_diag_codes` `d_um_hospital_contacts` `d_um_medical_director_review` `d_um_member_list` `d_um_pc_case` `d_um_pc_rules` `d_um_pc_service` `d_um_pc_service_provider` `d_um_physicians` `d_um_proc_code_no_resolution` `d_um_stoploss_carrier`	`cm_potentials` `coord_of_bens` `diagnosis_codes` `members` `pm_addresses` `pm_contacts` `procedure_codes` `provider_tins` `providers` `um_cases` `um_diagnosis_codes` `um_medical_reviews` `um_physicians` `um_procedure_codes` `um_provider_contacts` `um_rules` `um_services`
`w_um_referral`	Referral	`d_qe_cob_detail` `d_um_cm_potential_create` `d_um_diag_codes` `d_um_hospital_contacts` `d_um_member_list` `d_um_physicians` `d_um_ref_case` `d_um_ref_diag_groups` `d_um_ref_rules` `d_um_ref_service` `d_um_ref_service_provider` `d_um_stoploss_carrier`	`cm_potentials` `coord_of_bens` `diagnosis_codes` `diagnosis_groups` `members` `pm_addresses` `pm_contacts` `provider_tins` `providers` `um_cases` `um_diagnosis_codes` `um_diagnosis_groups` `um_physicians` `um_provider_contacts` `um_rules` `um_services`