User Tools

Site Tools


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:

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