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 |
hrms-sfis-upgrade/task-portfolio.txt · Last modified: 2007/04/11 18:12 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
