hrms-sfis-upgrade:task-portfolio

Portfolio Testing Meeting Notes 4/2/2007

I believe this is what we agreed to:

Mike Loegering (with Henk's help) will retrieve a list of “representative” sequel statements as executed in the perlly bowels of the portfolio (4/9/2007).
Mike will write a program to execute and review the results of the “representative” sequel statements (4/14/2007).
Tom DiMauro will be the lead PS programmer working with Mike and Henk. He will call in other programmers when needed.
Heather is creating a list of all portfolio applications, functional and technical owners.
Steve Windsor will create a test curl database (4/14/2007).
Steve, Annette, Barbara and Mary will set-up the materialized views working between the new PS8.9 and test curl.
Mike is added to the PS Upgrade meetings.
James Taft and Mike will put up a test portfolio box which will access PS8.9 and test curl.

Corrections welcome.

— Michael Loegering 2007/04/11 14:06

Here is a rough count of the tables that were hit in the past week with Portfolio queries:

1235	curl	ravishan.chairaas_roles	(sfis)
277	curl	sysadm.majors_advisees	(sfis)
109	curl	sysadm.ps_names	(sfis)
38802	curl	sysadm.ps_stdnt_enrl_appt	(sfis)
4537	curl	sysadm.ps_wep_supvr_hier	(sfis)
958	curl	sysadm.ps_wes_facorg_clas	(sfis)
958	curl	sysadm.ps_wes_facorg_plan	(sfis)
857	curl	sysadm.ps_wes_stdnt_advr	(sfis)
1212	psprod	sysadm.ps_wes_email_tbl
24	sfis	attrack07.act_det_vu
477	sfis	attrack07.leave_bal_vu
23	sfis	attrack07.leave_typ_tbl
66	sfis	attrack07.reason_typ_tbl
1098	sfis	attrack07.sap_leave_typ_tbl
409	sfis	attrack07.schedule_vw
611	sfis	attrack07.spa_act_vu
1679	sfis	attrack07.spa_holiday_vu
54	sfis	attrack07.spc_ts_select_vu
165	sfis	attrack07.supervisor_vac_vw
54	sfis	attrack07.ts_act_typ_vu
136143	sfis	dual
1	sfis	open_enroll.benefit_table
1	sfis	open_enroll.coverage_codes
1	sfis	open_enroll.dep_benef_vw
1	sfis	open_enroll.employee_sra_ded_count
1	sfis	open_enroll.new_plan_elections
1	sfis	open_enroll.open_close
1	sfis	open_enroll.plan_descr_table
1	sfis	open_enroll.sra
1	sfis	open_enroll.sra_maximums
1514	sfis	ravishan.adviser_auth
5641	sfis	ravishan.chairaas_roles
6495	sfis	sysadm.majors_advisees
1	sfis	sysadm.ps_ac
9691	sfis	sysadm.ps_acad_plan
1	sfis	sysadm.ps_acad_plan_owner
1	sfis	sysadm.ps_acad_plan_tbl
678	sfis	sysadm.ps_acad_prog
51396	sfis	sysadm.ps_accomplishments
216	sfis	sysadm.ps_addresses
634	sfis	sysadm.ps_bi_bill_hdr_vw
243	sfis	sysadm.ps_bi_bill_header
231	sfis	sysadm.ps_country_tbl
82989	sfis	sysadm.ps_names
215	sfis	sysadm.ps_personal_phone
211	sfis	sysadm.ps_sess_time_perod
230	sfis	sysadm.ps_state_names_tbl
9086	sfis	sysadm.ps_stdnt_advr_hist
257	sfis	sysadm.ps_stdnt_car_term
6	sfis	sysadm.ps_stdnt_enrl_appt
1	sfis	sysadm.ps_stdnt_test_co
92226	sfis	sysadm.ps_stdnt_test_comp
981	sfis	sysadm.ps_wep_supvr_hier
74	sfis	sysadm.ps_wep_supvr_hier2
117	sfis	sysadm.ps_wes_acad_hist
1013	sfis	sysadm.ps_wes_acct_bal_vw
366	sfis	sysadm.ps_wes_antc_aid_vw
1	sfis	sysadm.ps_wes_bbcmbnd
3	sfis	sysadm.ps_wes_bbcmbnd_tbl
367	sfis	sysadm.ps_wes_bill_dtl_vw
242	sfis	sysadm.ps_wes_bill_hst_vw
367	sfis	sysadm.ps_wes_cur_item_vw
43	sfis	sysadm.ps_wes_emergency
158	sfis	sysadm.ps_wes_enrlday_adr
46	sfis	sysadm.ps_wes_enrlday_emr
90	sfis	sysadm.ps_wes_enrlday_hld
62	sfis	sysadm.ps_wes_enrlday_prs
230	sfis	sysadm.ps_wes_enrlday_rel
5	sfis	sysadm.ps_wes_enrlhld_gls
66	sfis	sysadm.ps_wes_facorg_clas
5525	sfis	sysadm.ps_wes_facorg_plan
18	sfis	sysadm.ps_wes_gened_stat
24716	sfis	sysadm.ps_wes_instr_class
25	sfis	sysadm.ps_wes_sched_all
122	sfis	sysadm.ps_wes_schedule
188	sfis	sysadm.ps_wes_stdnt_advr
122	sfis	sysadm.ps_wes_student
28	sfis	sysadm.ps_wes_ug_gr_subj
81	sfis	sysadm.ps_whr_dir_sup_vw
9226	sfis	sysadm.ps_wrl_rs_eligible
1	sfis	sysadm.wes_enrl_request
2	sfis	sysadm.wes_mill_addresses
177	sfis	sysadm.wes_pfaids_webid
1030	sfis	wes_eval.vw_eval_incomplete
57	sfis	wu_data.peopleadmin_user