==== 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|