• Week 1, 5/3 - 5/9.
  Goals: Review project requirements, getting up to speed with shop standards, administrative tasks i.e. ID's, badge, weekly status reports & time reporting.
  Weekly Status: Logon Id's established(TSO & Network), printers connected ID acquired, Lotus connected.
  Classes Attended: Java Arch(internal), Arch Standards(internal)
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Assigned 04/05/2004; IP
  Product Change Request ID TSM01384-11, Assigned 04/05/2004; IP
  Problems: Lotus Notes, SPOC called.

• Week 2, 5/10 - 5/16.
  Goals: Complete Assigned tasks, Master Duke Power tools ie, PCCodeWizard, DB2 Explorer, , Work with CBIS DB2 tables.
  Weekly Status: Lotus Notes Running, various tools loaded & used.
  Classes Attended: PCR Procedures/internal, VB Class.
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Assigned 04/05/2004; Waiting on user feedback.
  Product Change Request ID TSM01384-11, Assigned 04/05/2004; Waiting on user feedback.
  Problems: None.

• Week 3, 5/17 - 5/23.
  Goals: Attain greater understanding of CBIS DB2 tables & shop SQL's, gain proficiency with JAVA 2.
  Weekly Status: Classes attended, managed to piss off instructor, gaining proficiency with DB2 Explorer, PCR TSM01384-11 essentially resolved, currently in users court, PCR EQW08066-1 resolved step to FTP report ready to implement (6/1/04), PCR AMB08655-54 unresolved, performing oddly May 1 - May 6, EQW08410-27 Code changes sent to team lead, unsure of how to test.
  Classes Attended: Java
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Complete Prod move 6/1/04.
  Product Change Request ID TSM01384-11.
  Product Change Request ID EQW08410-27.
  Product Change Request ID AMB08655-54.
  Problems: Unresolved PCR's, how to test EQW08410-27, Can not explain AMB08655-54.

• Week 4, 5/24 - 5/30.
  Goals: Complete Assigned tasks, Master Duke Power tools ie, PXCodeWizard, DB2 Explorer, Work with CBIS DB2 tables and use WSAD for Java class. Submit signed time sheet to CCC, complete WATTS entries for May.
  Weekly Status: PCR EQW08410-27 tested & ready for 6/18 move. Note when XPED task hosed (suspended) resource (program) will be tied up, in order to release task do following; CECI REL Prog(Program name) in CICS region. Admin tasks completed.
  Classes Attended: Java Intermediate Classes
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Complete Prod move 6/18/04.
  Product Change Request ID TSM01384-11, Cancelled.
  Product Change Request ID EQW08410-27, Complete Prod move 6/18/04.
  Product Change Request ID AMB08655-54.
  Problems: None.

• Week 5, 5/31 - 6/06.
  Goals: Complete Assigned tasks, Master Duke Power tools ie, PXCodeWizard, DB2 Explorer, Work with CBIS DB2 tables Attend Java class.
  Weekly Status: PCR AMB08655-54 resolved, waiting user reply, PCR EQW08327-21 API created, program mods approved/coded/tested.
  Classes Attended: Java Intermediate Classes
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Complete Prod move 6/18/04.
  Product Change Request ID EQW08410-27, Complete Prod move 6/18/04.
  Product Change Request ID AMB08655-54, PCR updated back in users court.
  Product Change Request ID EQW08327-21, Design specs Approved by tech lead, modifications made & tested.
  Problems: None.

• Week 6, 6/07 - 6/13.
  Goals: Complete Assigned tasks(resolve two PCR's), Master Duke Energy tools ie, PXCodeWizard, DB2 Explorer, Work with CBIS DB2 tables (using in-house utilities). Attend Java & DB2 classes, create local server, run simple servlet on local server. Create & run JSP/HTML files on local server.
  Weekly Status: Package EQW08327-21 ready for 06/09 move. Solidified WSAD environment, extracted data from DB2 tables via Java Class, create simple servlets.
  Classes Attended: Java Intermediate Classes
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Complete Prod move 6/18/04.
  Product Change Request ID EQW08410-27, Complete Prod move 6/18/04.
  Product Change Request ID AMB08655-54, Ready for Prod move, off load.
  Product Change Request ID EQW08327-21, Complete Prod move 6/09/04.
  Product Change Request ID RDT08757-31, Under Analysis.
  Problems: None.

• Week 7, 6/14 - 6/20.
  Goals: Complete Assigned tasks, review CPR's for 6/18 move, attend Java class, (solidify JAVA training with actual experience ie. Servlets), create new project & environment for class project. Review Dump Reading ,review WSAD tutorial.
  Weekly Status: Updated PCR EQW08327-21, resubmitted package for 6/18 move, created new project/stabilized its environment for class project, DASH BOARD REPORT (meter reader) dscrep under analysis.
  Classes Attended: Java Advanced Classes
  Assigned Tasks:
  Product Change Request ID EQW08066-1, Complete Prod move 6/18/04.
  Product Change Request ID EQW08410-27, Complete Prod move 6/18/04.
  Product Change Request ID AMB08655-54, Ready for Prod move, off load.
  Product Change Request ID RDT08757-31, Under Analysis.
  Product Change Request ID EQW08327-21, Added changes, complete prod move 6/18/04.
  Problems: None.

• Week 8, 6/21 - 6/27.
  Goals: Complete Assigned tasks, Master following Java topics; Servlets, Cookies, JSP & Sessions, Work with CBIS DB2 tables Attend Java class & team meeting. Complete class project.
  Weekly Status: Servlets/Session Passing techs mastered, off load request submitted.
  Classes Attended: Java Advanced Classes
  Assigned Tasks:
  Product Change Request ID AMB08655-54, Ready for Prod move, off load 6/30.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested. Waiting on owner OK.
  Product Change Request ID DMR07628-22, Under Analysis.
  Product Change Request ID RDT08484-27, Under Analysis.
  Product Change Request ID RDT08958-50, Under Analysis.
  Problems: None.

• Week 9, 6/28 - 7/04.
  Goals: Complete Assigned tasks (PCR's RDT08484-27, RDT08958-50 & DMR07628-22), Work with CBIS DB2 tables Attend Java class (introduction to C# and the web services layer), solidify JAVA training with actual experience. Get .NET & WebSphere up & running on PC. Submit Time Sheet.
  Weekly Status: PCR AMB08655-54 moved into Production, QC'ed package reports. Time sheet signed & submitted, PCR AMB08655-54 resurrected (1st day bug). Installed source safe & Microsoft Visual Studio.NET 2003.
  Classes Attended: Java Advanced Classes
  Assigned Tasks:
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested. Waiting on owner OK.
  Product Change Request ID AMB08655-54, Ready for Prod move, off load 6/30. PCR AMB08655-54 resurrected (1st day bug).
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Under Analysis.
  Product Change Request ID RDT08484-27, Under Analysis(verifying if problem still exist).
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Lessons Learned: Adding new SQL to access program.
  Problems: None.

• Week 10, 7/05 - 7/11.
  Goals: Complete Assigned tasks, Work with CBIS DB2 tables Attend Java class, solidify JAVA training with actual experience. Design modifications for PCR AMB08655-54, work with source safe & Microsoft Visual Studio.NET 2003.
  Weekly Status: Created new solution for PCR AMB08655-54, created new CNTL DSN for parm(package YCPS011391). ChangeMan package YCPS011359 ready for 7/14 offload. ChangeMan package YCPS011393 built for PCR MBS06904-32.
  Classes Attended: Java Advanced Classes & CBIS Database Training
  Assigned Tasks:
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested.
  Product Change Request ID AMB08655-54, changes made, package ready for 7/14 offload.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Under Analysis.
  Product Change Request ID RDT08484-27, Under Analysis(verifying if problem still exist).
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, Changes in progress.
  Problems: None.

• Week 11, 7/12 - 7/18.
  Goals: Complete Assigned tasks, monitor PCR AMB08655-54 off load(7/14). Work with CBIS DB2 tables Attend Java class, solidify JAVA training with actual experience. Complete PCR MBS06904-32, start PCR DMR07628-22. Start C# training & solidify SafeSource.
  Weekly Status:Configured new TestServer seems to have alleviated 500-Server error. ChangeMan package YCPS011402 for PCR MBS06904-32 created, SQL cursor mods made & tested, package frozen. Table change request for PCR EQW01626-48 submitted 7/15.
  Classes Attended: Java Advanced Classes
  Assigned Tasks:
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested. Table change request ready for submission.
  Product Change Request ID AMB08655-54, changes made, package ready for 7/14 offload.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Under Analysis.
  Product Change Request ID RDT08484-27, Under Analysis(verifying if problem still exist).
  Prioritizing PCR RDT08484-27 - No other reports of this problem since Nov 2002 , think that previous PCR's may have fixed this problem? Can we reject? ***PCR has been rejected****
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, Ready for 8/20 move.
  Problems: Unable to log into PcCode Wizar, problem ticket 1831159. Problem resolved 1100.

• Week 12, 7/19 - 7/25.
  Goals: Complete Assigned tasks, Master Duke Power tools ie, SafeSource, Visual C#.NET, WSAD. Start PCR DMR07628-22, get user feedback for test data on PCR MBS06904-32. Initiate SOP for CA7 changes(updating FTP jobs) & implement changes.
  Weekly Status: Files set up for Visual C#.NET. Gaining familiarity with SafeSource & Java PCR's. CBIS Support request for PCR EQW01626-48 submitted & completed, required XML update submitted (7/30 implementation). Started PCR DMR07628-22, touch base with system owner to obtain OK. Completed chapters 1 - 5 of Visual C#.NET pub.
  Classes Attended: Architecture presentation by Jarrett Wyant.
  Assigned Tasks:
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested. CBIS Table change request completed 7/22, XML update request submitted Implementation date 7/30.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change. waiting on System Owners approval of changes.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, Prod move 8/20.
  Product Change Request ID EQW08327-21, under analysis.
  Problems: None.

• Week 13, 7/26 - 8/01.
  Goals: Complete Assigned tasks, work on FTP job modifications, work with CBIS DB2 tables. Complete Java PCR(DMR07628-22), follow-up on PCR MBS06904-32 and complete analysis of PCR EQW08327-21.
  Weekly Status: System architecture reengineered, WSAD reloaded. Completed chapters 6 - 11 of Visual C#.NET pub. Design Document created for SleeperWrapper, coding for SleeperWrapper started. Components for PCR DMR07628-22 Checked out & modified, next step import/create TestDrivers.
  Classes Attended: N/A
  Assigned Tasks:
  Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL.
  Product Change Request ID EQW01626-48, Analysis Completed, unit tested. CBIS Table change request completed 7/22, XML update request submitted Implementation date 7/30.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file addition (blam.xml). Components checked out & modified 7/30.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, Test data sent to BU for approval of changes.
  Product Change Request ID EQW08327-21, under analysis.
  Problems: None.

• Week 14, 8/02 - 8/08.
  Goals: Complete Assigned tasks, FTP job modifications, work with CBIS DB2 tables, complete PCRs DMR07628-22 & MBS06904-32. Complete on-line tutorial for SafeSource.
  Weekly Status: User OK'ed PCR MBS06904-32, Documentation/Coding/Testing for FTP return codes completed, ChangeMan Package CPS011449. PCR DMR07628-22 test driver initiates logon but unable to connect to DataBase, resolved(incorrect config files). Code Freeze 080604.
  Classes Attended: N/A
  Assigned Tasks:
  Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file addition (blam.xml). Components checked out & modified 7/30.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, prod move 8/20.
  Product Change Request ID EQW08327-21, under analysis.
  Problems: None.

• Week 15, 8/09 - 8/15.
  Goals: Complete Assigned tasks, FTP job modifications, work with CBIS DB2 tables. Complete PCRs DMR07628-22 & EQW08327-21. Submit signed time sheet.
  Weekly Status: PXSUA310 converted from SRC to CID, PXSUA310 tested, modified proc to run upto ten step resubmitals(dependent on JCL Parm). Completed chapters 12 - 13 of Visual C#.NET pub. Tested PCR DMR07628-22 using TestDrivers. Time Sheet submitted. FTP section added to JCL standards document.
  Classes Attended: N/A
  Assigned Tasks:
  Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new PROC & new CNTL members) YCPS011449.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, prod move 8/20.
  Product Change Request ID EQW08327-21, under analysis, for entries with same cusacc_idn, bill_no, bill_yr & adj_cat write only highest root cause.
  Problems: None.

• Week 16, 8/16 - 8/22.
  Goals: Complete Assigned tasks, FTP job modifications. Complete PCRs DMR07628-22 & EQW08327-21.
  Weekly Status: PCR MBS06904-32 defrosted packed fields converted to strings, user OK changes (package frozen & ready for 8/20 move). FTP Procs modified & retested, JCL Documentation updated & submitted for approval. PXSAU310 reviewed by in-house staff & software, ready for move.
  Classes Attended: N/A
  Assigned Tasks:
  Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new PROC & new CNTL members) YCPS011449.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS06904-32, prod move 8/20.
  Product Change Request ID EQW08327-21, waiting for user OK. Prod Move 10/15 or Off Load move.
  Product Change Request ID EQW08973-29, under analysis, Job SQL needs to be modified.
  Problems: None.

• Week 17, 8/23 - 8/29.
  Goals: Complete Assigned tasks ie. FTP job modifications, Completion of PCR DMR07628-22, completion of PCR EQW08973-29. Submit Procs & JCL for approval.
  Weekly Status: Tested PCR DHU09286-12, PCR ready production move 9/9. Modified EQW08973-29 to read user generate Table & write out to flat file.
  Classes Attended: DB2 Utilities, in-house.
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new CNTL members & Proc PXFTPSTp-YCPS011449/Proc PXFTPSTP-YCPS011490/Proc/JCL Mods YCPS011491) move date 9/9. PCR MBS09366-35 corrected user OKed output.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW08327-21, under analysis, for entries with same cusacc_idn, bill_no, bill_yr & adj_cat write only highest root cause. Prod Move 10/15 or Off Load move.
  Product Change Request ID EQW08973-29, under analysis, Job SQL needs to be modified.
  Product Change Request ID MBS09366-35, Correction of previous PCR, extracted voltage from installation table. 9/9 production move, CM package YCPS011507.
  Problems: Running modified prod program with prod data in test environment, resulting in premature cursor closure excessive -530 SQLCodes. Resolved, cursor problem due to commit, Ref constraints removed from test table.

• Week 18, 8/30 - 9/05.
  Goals: Monitor FTP job modifications, complete PCRs DMR07628-22, EQW08327-21 & MBS09366-35. Submit signed time sheet
  Weekly Status: Rectified all but one report number for PCR EQW08327-21. Verified components for PCR DHU09286-12. Started Hourly Pricing Project.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retry apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new CNTL members & Procs PXFTP/PXFTPSTP-YCPS011449) move date 9/9. Package YCPS011499 for JCL, move 9/17.
  Product Change Request ID RDT08757-31, Under Analysis, put on hold by user. Reassigned to Leslie.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW08327-21, ready for move. Off Sched Load.
  Product Change Request ID EQW08973-29, under analysis, Job SQL needs to be modified. reassigned to CM
  Product Change Request ID MBS09366-35, Correction of previous PCR, extracted voltage from installation table. 9/17 production move, CM package YCPS011507.
  Problems: None.

• Week 19, 9/05 - 9/11.
  Goals: Complete Assigned tasks, FTP job modifications, hourly project, implement off sced load for PCR EQW08327-21. Complete PCRs DMR07628-22.
  Weekly Status: Completed testing of PCR EQW08327-21, off sched move 9/10. Reviewing hourly rate change project (PCR KWW09456-48). Code project mods for PXPSA110.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retries apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new CNTL members & Procs PXFTP/PXFTPSTP-YCPS011449) move date 9/9. Package YCPS011499 for JCL, move 9/17.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW08327-21, Off Scced Load 9/10/2004.
  Product Change Request ID MBS09366-35, Correction of previous PCR, extracted voltage from installation table. 9/17 production move, CM package YCPS011507.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516.
  Problems: None.

• Week 20, 9/12 - 9/18.
  Goals: Complete Assigned tasks, review prod run for modified FTP job. Complete PCR DMR07628-22. Attend project weekly status meeting, start proj mods for PXPSA120. Submit signed time sheet
  Weekly Status: Resolved Production Problem (Off Sched Load 9/17), Created baseline CM package (YCPS011556) for HP-Flex project (30% Completion)/following mods successfully compiled; PXPSA110, PXPSA120, PXPXA130, PXPSA160 & PXPSA200. Initiated analysis of AWK09480-19, corrected typos in FTP Procs.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retries apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new CNTL members & Procs PXFTP/PXFTPSTP-YCPS011449) move date 9/9. Package YCPS011499 for JCL, move 9/17.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID MBS09366-35, Correction of previous PCR, extracted voltage from installation table. 9/17 production move, CM package YCPS011507.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011999. Under analysis.
  Problems: Production Problem, EQW08327-21 & RACF problems with PrdB.

• Week 21, 9/19 - 9/25.
  Goals: Complete Assigned tasks, FTP job modifications (monitor U037FTEC), complete PCR AWK09480-19. Complete AsBuilt Document for remaining FTP jobs.
  Weekly Status: HP-Flex Rate project 74% complete. Completed AsBuilt Document for remaining FTP jobs. Package 11499 loaded 9/22, Clean run for U037FTEC.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retries apply to selective FTP jobs, create Design Documentation, Create SleeperWrapper, modify JCL. ChangeMan package for Phase1A (Cobol wrapper, new CNTL members & Procs PXFTP/PXFTPSTP-YCPS011449) move date 9/9. Package YCPS011499 for JCL, move 9/17.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516. Initial testing for PXPSA110, PXPSA130, PXPSA160, PXPSA200 & PXPSAVALUE completed.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011999. Under analysis.
  Problems: Planned release for September was postponed due to high call volumes generated by hurricane Ivan. CM package YCPS011499 will be moved by 9/22/04.

• Week 22, 9/26 - 10/03.
  Goals: Complete Assigned tasks, FTP job modifications, continue to evaluate U037FTEC job stats. Complete PCRs DMR07628-22 Complete initial testing of HP-Flex project. Submit signed time sheet
  Weekly Status: HP-Flex Rate project 85% complete. PXPSA121 Recursive program added to package, all HP-Flex mods in place, reviewing & testing. FTP proc mods added to six existing jobs, off sched load scheduled for 9/29.
  Classes Attended: DB2 Tools Training with following tools; Apptune, BMC, Mainview and Visual Explain
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retries apply to selective FTP jobs, create Design Documentation, Phase II move remaining six jobs into production (in mean time evaluate U037FTEC run stats).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516. Initial testing for PXPSA110, PXPSA130, PXPSA160, PXPSA200 & PXPSAVALUE completed.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011999. Under analysis.
  Product Change Request ID EQW09348-21, Under Construction, Dashboard Report for Rereads Completed On Time - YEARLY is missing the Total line. Table insert required, waiting for user approval.
  Problems: N/A.

• Week 23, 10/04 - 10/10.
  Goals: Complete Assigned tasks, Monitor FTP job modified jobs, Complete HP-Flex testing/Put on hold until next week. Complete PCR DMR07628-22, get user OK & implement mods for PCR EQW08327-21.
  Weekly Status: Modified FTP Retries procs & JCL (added steplib & 3 new parms), table updates for PCR EQW09348-21 completed10/06.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09286-12, Auto retries apply to selective FTP jobs. Modified procs & JCL.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516. Initial testing for PXPSA110, PXPSA130, PXPSA160, PXPSA200 & PXPSAVALUE completed. On hold until 10/12/2004.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011999. Under analysis.
  Product Change Request ID EQW09348-21, Under Construction, Dashboard Report for Rereads Completed On Time - YEARLY is missing the Total line. Table updates for PCR completed 10/06.
  Problems: None.

• Week 24, 10/11 - 10/17.
  Goals: Complete Assigned tasks, FTP job modifications-monitor production moves, resume work on Flex-HP project. Complete PCR AWK09480-19.
  Weekly Status: Working on Production Problem OC7(U037PM08) & finished testing PCR AWK09480-19. Submitted Off Sced Load requests for 10132004PXFTP.doc & 10132004PXCAR860.doc. Created asbuilt doc for FTP RETRies Nov moves.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU09631-32, Auto retries apply to selective FTP jobs. Modified procs & JCL.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID KWW09456-48, Tracking PCR for HP-Flex Rate. CM package YCPS011516. Initial testing for PXPSA110, PXPSA130, PXPSA160, PXPSA200 & PXPSAVALUE completed. Off project per Scotty.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607. Code in place testing complete preparing to move data 11/12/04.
  Product Change Request ID LRV09744-20, Correct display of restart information in PXCAR860. PCR complete scheduled for 11/12/04 prod move.
  Problems: Production Problem OC7(U037PM08), Correction ChangeMan Package YCPS011624 Off sched move 10/13. Reran Job with mod, ran cleanly no data extracted. Problem was incorrect restart card, job never successfully completed Septembers run & job card never updated (learning experience).

• Week 25, 10/18 - 10/24.
  Goals: Complete Assigned tasks, FTP job modifications-monitor modified JCL, Complete & submit AsBuilt document for FTP project, check out production copy of PXCAP150 for CM pack YCPS011607 & move changes for PCR AWK09480-19 back into program. Complete PCR DMR07628-22.
  Weekly Status: Prepared PCR's AWK09480-19, LRV09744-20 & DHU09580-2 for production move 11/12/04.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking PCR DHU09580-2, modify production FTP jobs to use new FTP proc. Ready for 11/12/04 Production Move.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607. Code in place testing complete, package ready for production move 11/12/04.
  Product Change Request ID LRV09744-20, Correct display of restart information in PXCAR860. Package ready for production move 11/12/04.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). Under Analysis.
  Problems: None.

• Week 26, 10/25 - 10/31.
  Goals: Complete Assigned tasks, FTP job modifications-monitor modified JCL, Review DB2 Queries & DB2 tools. Complete PCR DMR07628-22.
  Weekly Status: Analyzed U037FTEX production run 10/23 (2nd FTP step failed to XMT data & proc did not properly cycle through steps. FTP failure unknown, improper cycling explained below. Tracking PCR DHU09734-25 prepared for 11/12 production move.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking PCR DHU09734-25, modify production FTP jobs to use new FTP proc. Ready for 11/12/04 Production Move. Removed jobs from package YCPS11648 with multiple FTP steps.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607. Code in place testing complete, package ready for production move 11/12/04.
  Product Change Request ID LRV09744-20, Correct display of restart information in PXCAR860. Package ready for production move 11/12/04.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). Waiting on added data, Job & program names.
  Problems: Job U037FTEX 2nd FTP step failed due to 550 (NEW_CHGOFFS: Access is denied), proc failed to properly execute proc steps. Problems two fold a) for reassons unknown authority problem for either new charge DSN or the server. b) It looks like the current FTP step is referenceing the RC from the previous FTP steps. For example if I run the first job & it fails in steps run020 & run030 but succeeds at run050 RUN020 RC = 4 RUN030 RC = 4 RUN050 RC = 0 Then the 2nd FTP step execute as follows RUN020 RC = 4 RUN030 RC = 4 RUN050 RC = 4 Remaining steps flushed. Clearly the 2nd FTP IF RC step statements are referencing the 1st steps return codes.

• Week 27, 11/01 - 11/07.
  Goals: Complete Assigned tasks, FTP job modifications-monitor modified JCL, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & CCJ09434-35.
  Weekly Status: Attempted to resolve FTP retries problem same outcome, namely ignoring the 0 return codes of the immed preceding step & instead using the return code of 4 from a much earlier step. This makes sence when you review Cond code checking which compares the current step with the max step code unless directed to a specific step.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking DHU09734-25, modify production FTP jobs to use new FTP proc. Ready for 11/12/04 Production Move. Removed jobs from package YCPS11648 with multiple FTP steps.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607. Code in place testing complete, package ready for production move 11/12/04.
  Product Change Request ID LRV09744-20, Correct display of restart information in PXCAR860. Package ready for production move 11/12/04.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). Adding code logic to PXCAP460, new SQL added to access program DXMSAGDG. Report created, next convert report into B.O. Production move date 12/10/04 (ChangeMan Package YCPS11668).
  Problems: None.

• Week 28, 11/08 - 11/14.
  Goals: Complete Assigned tasks, monitor 11/12 production moves, complete new AsBuilt doc & tracking PCR for FTP project, Review WSAD/SS on-line tutorials. Complete PCRs DMR07628-22 & CCJ09434-35.
  Weekly Status: New tracking PCR & AsBuilt Document built for FTP Retries Project, my part of PCR CCJ09434-35 completed. WSAD tutorial reestablished on machine & reviewed. PCR's for 11/12/04 move ready for production move.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking DHU09734-25 for 11/12 prod move, modify production FTP jobs to use new FTP proc. Ready for 11/12/04 Production Move. Removed jobs from package YCPS11648 with multiple FTP steps.
  Product Change Request ID Tracking DHU09947-8 for 12/10 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID AWK09480-19, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607. Code in place testing complete, package ready for production move 11/12/04.
  Product Change Request ID LRV09744-20, Correct display of restart information in PXCAR860. Package ready for production move 11/12/04.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). Adding code logic to PXCAP460, new SQL added to access program DXMSAGDG. Report created, next create new DB2 table(repository for new report) & DB2 access program. Production move date 12/10/04 (ChangeMan Package YCPS11668).
  Problems: None.

• Week 29, 11/15 - 11/21.
  Goals: Complete Assigned tasks, FTP job modifications-monitor modified JCL, Monitor following jobs; U037AMPY & U037PM08 (11/12/04 prod move). Review DB2 Queries & DB2 tools. Complete PCR DMR07628-22.
  Weekly Status: November production moves reviewed, PCR CCJ09434-35 tested & ready for 12/10/2004 prod move. Commenced new project LBC Bill Accuracy - Project. Per user request loaded selective production data to CBISCMPT (nailed down rtn).
  Lessons Learned: Loading Production data from CBIS to selected test DataBase.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720.
  Product Change Request ID Tracking DHU09947-8 for 12/10 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). ChangeMan Package YCPS11668 containing pre business changes coded & tested. Package ready for 12/10/2004 production move.
  Problems: None.

• Week 30, 11/22 - 11/28.
  Goals: Complete Assigned tasks, FTP job modifications project Complete package, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & NBS10028-49.
  Weekly Status: PCR DHU09947-8 production move, moved back to January-2005, new AsBuilt document created for January move created. PCR CCJ09434-35 updated & retested, user OK'ed. Off loaded production fixes for U673* jobs.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). ChangeMan Package YCPS11668 containing pre business changes coded & tested. Package ready for 12/10/2004 production move.
  Problems: In the past we only got one page from these jobs. Now it looks like the U673xxxx jobs are a problem. We have a step to page if job succeeds and a step to page if the job fails. Looks like they are both being executed. Condition code incorrectly coded, corrections Loaded (Off Schedule) 11/23/04.

• Week 31, 11/29 - 12/05.
  Goals: Complete Assigned tasks, FTP job modifications project Complete package, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & NBS10028-49. Maximize experience with Princeton Softech's Relational Tools. Review production run for U673* jobs.
  Weekly Status: PCR NBS10028-49 coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, looks OK, up to user to verify. Submitted offLoad request for YCPS011743, correction of production problem.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, looks OK, up to user to verify.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). ChangeMan Package YCPS11668 containing pre business changes coded & tested. Package ready for 12/10/2004 production move.
  Problems: We got a page saying that U673NBIL ran today did not send page to Nantahala. Checked JHS and found the job completed with RC=0 in step RUN020 however Step02, Step03, and Step04 did not run. Step03 is the one used to send the page to Nantahala. Solution, replace Step Cond Code Check with JCL-IF/ElSE logic. W037FTER - Equipfax not being retrieved. Solution; Modified SYSIN2='DUMMY' to SYSIN2='DSN=&&FTPCMD', to pull in FTP GET command ChangeMan Package YCPS011743.

• Week 32, 12/06 - 12/12.
  Goals: Complete Assigned tasks, FTP job modifications project Complete package, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & LSF10091-47.
  Weekly Status: Resolved MGK10128-40(FTP Prod Problem), reran CCJ09434-35 PCR with Decembers data. Prepared Off Load for production problems; MGK10128-40 & LSF10091-47 completed for 12/08/2004. Populated tables BPM_ACCUR_DETAIL & COLLECTED_MEASURE to facilitate user testing for PCR NBS10028-49.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, looks OK, up to user to verify. Slated for January production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID CCJ09434-35, Create a monthly report which will display sum totals by agreement type code from the monthly sync up file: DK037.U037AMSU.STEP020.SYNC.FILE(+1). ChangeMan Package YCPS11668 containing pre business changes coded & tested. Package ready for 12/10/2004 production move.
  Product Change Request ID Problem-Resolution LSF10091-47 for 12/2004 prod move, Production Problem, invalid Condition Code Check on U673NBIL and U673NFNL. ChangeMan package YCPS11741.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750.
  Problems: We received a remedy ticket( 1981776) this morning for job W037DCLM: W037DCLM SYSI FAILED: JOB CC 0037; Problem occurred on system SYSI at 2004-12-06 09. Original FTP sysin had no EXIT parameter, without EXIT job ignores any & all FTP errors, solution remove FTP mode option.

• Week 33, 12/13 - 12/19.
  Goals: Complete Assigned tasks, FTP job modifications project Complete package, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22, SSC10013-32 & NBS10028-49. Monitor jobs from Dec's production move, YCPS011741 (U37TRCE-13, U673FRHT ??, U673NBIL-12/15, U673NFNL-12/15 & WCPSLOB-OnDemand) & package YCPS011668 (U037AMPY-12/30). Contingent on user testing, audit, freeze & prepare ChangeMan package NBS10028-49 for code Freeze production move 1/21/04.
  Weekly Status: Reviewed via JHS U037TRCE, U673FRHT, U673NBIL & WCPSLOB, jobs ran OK. Ran programs to populate the CBISMSRM.COLLECTED_MEASURE table for RootCause & Bill Accuracy Measure DashBoard reports for Sept thru Nov 2003 data acquisition compared data with queries (original & modified) run in QMF, all looks OK. User testing completed for package NBS10028-49, package audited/frozen, V10 documentation completed.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, looks OK, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750.
  Problems: None.

• Week 34, 12/20 - 12/26.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCR DMR07628-22. Monitor jobs from Dec's production move, YCPS011741 (U673NFNL-12/15) & package YCPS011668 (U037AMPY-12/30).
  Weekly Status: Reviewed via JHS U673NFNL job ran OK. Reviewed PCR SSC10013-32, IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package SSC10013-32 tested & prepared for 01/21/04 production move. Created OffSchedLoad package for IDed problem, waiting on PCR prioritization.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705. Proc & JCL mods replaced with Pearl Script.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750. IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package ready for 1/21/04 move.
  Problems: Looks like the problem in U673IEOD is the same as the one we had in other U673* jobs, isn't it? Problem due to JCL Cond Code Checking.
  

• Week 35, 12/27 - 01/02.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22. Monitor job/s from Dec's production move, package YCPS011668 (U037AMPY-12/30).
  Weekly Status: N/A
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705. Proc & JCL mods replaced with Pearl Script.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750. IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package ready for 1/21/04 move.
  Problems: N/A.
  

• Week 36, 01/03 - 01/09.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & SSC10013-32. Monitor job/s from Dec's production move, package YCPS011668(U037AMPY-12/30). Monitor job U673TOHT OffSchedLoad 1/5/05.
  Weekly Status: Reviewed via JHS U037AMPY job ran OK. Production Fix OffScedLoad completed for PCR LSF10230-52, JCL monitored JHS (ran OK). Completed AsBuilt for January prod load of FTP retries components.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move, remaining FTP jobs with multiple FTP steps. ChangeMan package YCPS11705. Proc & JCL mods replaced with Pearl Script. Used by PearlScript programmer.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750. IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package ready for 1/21/04 move.
  Product Change Request ID PPJ09963-6, Code: Phone table getting updated with zeros. Data PCR PPJ09845-52. Under Analysis. ChangeMan Package # YCPS011796.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect Under Analysis. ChangeMan Package # YCPS011800.
  Problems: None.
  

• Week 37, 01/10 - 01/16.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & PPJ09845-52. Monitor SSC10013-32 for user approval of program modifications. Monitor job/s from Dec's production move, package YCPS011668 (U037AMPY-12/30). Monitor job/s from Jan's production move, package YCPS011750 (W037BPM2-01/09, 2nd Sunday of the month). Play with VisualExplain, gain some proficiency with product.
  Monthly(January) PCR Production Loads: PCR's SSC10013-32 & NBS10028-49
  Weekly Status: Installed on C drive Visual Explain, reviewing monster queries via Visual Explain. Prepared PCR EQW09823-21 for testing, create test plan. Created Tracking PCR(DHU10322-30) for February's FTP retries prod move. Created ChangeMan Package (YCPS11817) for January's FTP retries prod move.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU09947-8 for 01/2005 prod move. ChangeMan package YCPS11817. Proc replaced with Pearl Script which wraps the Sleep Step & FTP Step. Waiting on programmer to create Pearl Script that I can test with.
  Product Change Request ID Tracking DHU10322-30 for 02/2005 prod move. ChangeMan package YCPS11705. Replacing FTP steps in jobs containing multiple FTP steps.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750. IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package ready for 1/21/04 move.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800.
  Problems:-1/12 RACF problem TSOTEST, SPOC Ticket/Request Number: 2019226. Resolved 1/12-930.
  

• Week 38, 01/17 - 01/23.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22 & EQW09823-21. Reviewing monster queries via Visual Explain.
  Monthly(January) PCR Production Loads: PCR's SSC10013-32 & NBS10028-49
  Weekly Status: Code Mods in place for PCR SSC10013-32, code not broken test completed. Functional test in progress.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking NBS10028-49 for LBC Bill Accuracy - Project. ChangeMan package YCPS011720. coded & tested with CBISCMPT, promoted to CBISSSA. Ran job in XP reviewed DashBoard report, tested & OKed by users. Package components ready for 1/21/04 production move.
  Product Change Request ID Tracking DHU10322-30 for 02/2005 prod move. ChangeMan package YCPS11705. Replacing FTP steps in jobs containing multiple FTP steps. ChangeMan package YCPS11817. Proc replaced with Pearl Script which wraps the Sleep Step & FTP Step. Waiting on programmer to create Pearl Script that I can test with.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID SSC10013-32 Dashboard -Cycle Bills Rendered On Time measure is incorrect. ChangeMan package YCPS011750. IDN's 1110827072, 1149934077, 1405697474 were not designated on the CBIS.BPM_LATE_BILL & per program logic (PXCAR760) they should not have been designated as Late Bills. IDN 1865372601 was inserted into the CBIS.BPM_LATE_BILL correctly. Problem appears to be with Rerouted Accounts, resolution extract cycle number from Bill History table vice CusAcc table. Package ready for 1/21/04 move.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800.
  Problems: PC Code Wizard unavailable 1/18, unable to generate modifications to access query, corrected 1/19 AM.
  

• Week 39, 01/24 - 01/30.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22. & EQW09823-21. Monitor production move jobs, attend team meeting.
  Monthly(January) PCR Production Loads: PCR's SSC10013-32 & NBS10028-49
  Weekly Status: Prepared PCR EQW09823-21 for Feb's production move, package tested, audited & frozen. Analyzed newly assigned PCRs(LRV09652-19, ATP10246-4).
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID Tracking DHU10322-30 for 02/2005 prod move. ChangeMan package YCPS11705. Replacing FTP steps in jobs containing multiple FTP steps. ChangeMan package YCPS11817. Proc replaced with Pearl Script which wraps the Sleep Step & FTP Step. Waiting on programmer to create Pearl Script that I can test with.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800. Package tested & waiting for User OK - Feb Prod Move.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841.
  Problems: None.
  

• Week 40, 01/31 - 02/06.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22, LRV09652-19 & ATP10246-4.
  Monthly(February) PCR Production Loads: PCR's EQW09823-21.
  Weekly Status:PCR RKR08352-25 Code Changes in place, testing in progress, PCR on hold working on numerous ad hoc Queries for Reid. Commence testing with FTP Retries project, submitted request for UNIX access. Reestablished XPediter environment, new version.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan package YCPS11705. Replacing FTP steps in jobs containing multiple FTP steps. ChangeMan package YCPS11817. Proc replaced with Pearl Script which wraps the Sleep Step & FTP Step. Waiting on programmer to create Pearl Script that I can test with.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800. Package tested & waiting for User OK - Feb Prod Move.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March.
  Problems: Job WCPSLOB Abended return code of 37, problem due to failure to login. EZA1735I FTP Return Code = 26530, Error Code = 00011.
  

• Week 41, 02/07 - 02/13.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22, RKR08352-25, LRV09652-19 & ATP10246-4. Run XPediter, new version.
  Monthly(February) PCR Production Loads: PCR's EQW09823-21.
  Weekly Status: PCR RKR08352-25 Code Changes in place, testing in progress, PCR on hold working on numerous ad hoc Queries for Reid. Commence testing with FTP Retries project, submitted request for UNIX access. Main Frame XPeditor set up for test. Testing FTP Pearl Scripts in progress, preparing ChangeMan Package for March move. Moved designated accounts from CBIS to CBISUNIT.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification.
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800. Package tested & waiting for User OK - Feb Prod Move. Reviewed testing for this PCR.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March.
  Classes Attended: N/A
  Assigned Tasks:
  Problems: Profile not set up on UNIX system, required to test FTP/Pearl modifications. Profile set up 2/7/05.
  

• Week 42, 02/14 - 02/20.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete PCRs DMR07628-22, LRV09652-19 & ATP10246-4. Monitor production move job(s); U037BPM1(2/13/05 run date).
  Monthly(February) PCR Production Loads: PCR's EQW09823-21.
  Weekly Status: Reviewed testing results for PCR EQW09823-21. Retested PCR AWK09480-19, new name SSD10406-29 & ChangeMan Package YCPS011833. Extracted & loaded designated accounts from PRDB to UNIT. Applied bandaid to PCR ATP10246-4, PCR Tested against CBISSSA Tables, successful test.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc). .
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID EQW09823-21, Bill Format - Last Year's Avg Cost Per Day calculation is incorrect. Modifing SQL in Access method DXJRCVGC. ChangeMan Package # YCPS011800. Package tested & waiting for User OK - Feb Prod Move.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835.
  02/15/05- SOP4258 During Usage Recharge, DAYPROR determinant is set to "YES" because it's failing the Initial-Final test. Need to adjust logic when setting DAYPROR determinant. On temp hold until CICS trans problem cleared(see week 42 problem).
  02/17/2005- Applied bandaid to PCR ATP10246-4, PCR Tested against CBISSSA Tables, successful test.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Problems: CICS Translation parm changed, as a result members copied vice called bring in duplicate copybooks This results in a "was not a uniquely defined name" ERROR. Job U037BPM1 blew out with a SYSTEM=222 ERROR, opening primary cursor. Tables & SQL's tweaked by DBA's, job successfully rerun 2/15.
  

• Week 43, 02/21 - 02/27.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Follow up on PCRs DMR07628-22, RKR08352-25, NBS10028-49 & ATP10246-4. Complete analysis of PCR LRV09652-19. Complete testing for PCR DHU10322-30.
  Monthly(March) PCR Production Loads: PCR's EQW09823-21, NBS10028-49 & DHU10322-30/ATP10246-4.
  Weekly Status: PCR ATP10246-4 completed & ready for tested, problem from last week IDed & corrected. Production move date March.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835. On temp hold until CICS trans problem cleared(see week 42 problem).
  02/15/05- SOP4258 During Usage Recharge, DAYPROR determinant is set to "YES" because it's failing the Initial-Final test. Need to adjust logic when setting DAYPROR determinant. On temp hold until CICS trans problem cleared(see week 42 problem).
  02/17/2005- Applied bandaid to PCR ATP10246-4, PCR Tested against CBISSSA Tables, successful test.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR.
  Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days. ChangeMan Package # YCPS011900, package components(s);PXCAR750.
  Product Change Request ID DHU10678-1, Currently code contained in INCLUDE copy books referenceing DFHEIBLK & DFHCOMMAREA data areas are failing to compile due to following; not a uniquely defined name. Solution.. CM package YCPS011835.
  02/24/2005- Copy Book components ID & modified.
  Product Change Request ID NBS10028-49, racking PCR for LBC Bill Accuracy Project (DPCO040478)Solution. CM package YCPS011913.
  02/25/2005 - Reopening PCR per T. Beatty: Making minor mods to Driving SQL's for sake of Job Efficiency. Modify cursors DXJBPMAB-CURSOR3 & DXJBPMAB-CURSOR4 in Access mod DXJBPMAB. Delete cursors DXJBPMAB-CURSOR1 & DXJBPMAB-CURSOR2 in Access mod DXJBPMAB since these two are no longer used in CBIS.
  Problems: None.
  

• Week 44, 02/28 - 03/06.
  Goals: Complete all assigned tasks, Review DB2 Queries & DB2 tools. Complete assigned PCRs.
  Monthly(March) PCR Production Loads: PCR's EQW09823-21, NBS10028-49 & DHU10322-30/ATP10246-4.
  Weekly Status: Prepared packages DHU10322-30/ATP10246-4, NBS10028-49 for March prod move, assisted PYC with ABS. Continued testing of Pearl Script/FTP Retries. Update/move documentation for PXPYT500 to SS & Implemented required changes for PCR RKR08352-25.
  Classes Attended: None
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835. On temp hold until CICS trans problem cleared(see week 42 problem).
  Product Change Request ID DHU10678-1, Currently code contained in INCLUDE copy books referenceing DFHEIBLK & DFHCOMMAREA data areas are failing to compile due to following; not a uniquely defined name. Solution. CM package YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Product Change Request ID NBS10028-49, racking PCR for LBC Bill Accuracy Project (DPCO040478)Solution. CM package YCPS011913.
  Reopening PCR per T. Beatty: Making minor mods to Driving SQL's for sake of Job Efficiency. Modify cursors DXJBPMAB-CURSOR3 & DXJBPMAB-CURSOR4 in Access mod DXJBPMAB. Delete cursors DXJBPMAB-CURSOR1 & DXJBPMAB-CURSOR2 in Access mod DXJBPMAB since these two are no longer used in CBIS.
  Problems: None.
  

• Week 45, 03/07 - 03/13.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25.
  Weekly Status: Off Schedule Load request completed for PCR NBS10028-49, Documentation for PXPYT500.doc updated & moved to SourceSafe. Commenced testing for PCR RKR08352-25.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835. On temp hold until CICS trans problem cleared(see week 42 problem).
  Product Change Request ID DHU10678-1, Currently code contained in INCLUDE copy books referenceing DFHEIBLK & DFHCOMMAREA data areas are failing to compile due to following; not a uniquely defined name. Solution. CM package YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Product Change Request ID NBS10028-49, racking PCR for LBC Bill Accuracy Project (DPCO040478)Solution. CM package YCPS011913. Off Load Sched 03/09/2005.
  Reopening PCR per T. Beatty: Making minor mods to Driving SQL's for sake of Job Efficiency. Modify cursors DXJBPMAB-CURSOR3 & DXJBPMAB-CURSOR4 in Access mod DXJBPMAB. Delete cursors DXJBPMAB-CURSOR1 & DXJBPMAB-CURSOR2 in Access mod DXJBPMAB since these two are no longer used in CBIS.
  Problems: None.
  

• Week 46, 03/14 - 03/20.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's. Monitor job U037BPM1, tied to PCR NBS10028-49.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25.
  Weekly Status: Job U037BPM1 CPU Time 01:19:07.27 ClocTime: Start 10:00 End 14:30 4.5 clock time Prev Run Time 01:22:16.82 Clock Time: Start 10:04 End 18:24 8.5 clock time. Not as damatic a reduction as I hoped, but in the right direction none the less. Completed tesing for PCR RKR08352-25, PCR ready for April's Production move.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID ATP10246-4, Usage Recharge Prorated incorrectly on initial/final billing same month. Under Analysis, ChangeMan Package # YCPS011835. On temp hold until CICS trans problem cleared(see week 42 problem).
  Product Change Request ID DHU10678-1, Currently code contained in INCLUDE copy books referencing DFHEIBLK & DFHCOMMAREA data areas are failing to compile due to following; not a uniquely defined name. Solution. CM package YCPS011835.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Problems: None.
  

• Week 47, 03/21 - 03/27.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Weekly Status: Completed coding for PCR SSC10013-32, testing completed 3/25/05. Join SQL modified, unresolved problems SP working to resolve (Code Wizard Side). Assist RR with PCR AMB10776-8.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Production move 4/22/05.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis. CM package YCPS011941.
  Problems: None.
  

• Week 48, 03/28 - 04/03.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Weekly Status: Aprils production moves prepared, not much else productively.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Production move 4/22/05.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis. CM package YCPS011941.
  Problems: None.
  

• Week 49, 04/04 - 04/10.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Weekly Status: Reviewed Aging report from 3/3 run, no discrepancies found. Started Standards for Visio to EA project, ave reviewed aprox 10% of 914 jobs per RM. All PCR's put on hold.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Production move 4/22/05.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis, Data from following sources reviewed & compared, RMDS report, Primary cursor, programmer created cursor, only discrep found was with the January RMDS report & the two other cursors using January's data. CM package YCPS011941.
  Problems: None.
  

• Week 50, 04/11 - 04/17.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Weekly Status: PCR User approval granted, working on JCL control project. Assisted BU in testing PCR RKR08352-25, PCR subsequently OKed by user. First sweep completed for 226 jobs IDed y RM.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Production move 4/22/05.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis, Data from following sources reviewed & compared, RMDS report, Primary cursor, programmer created cursor, only discrep found was with the January RMDS report & the two other cursors using January's data. CM package YCPS011941.
  Problems: None.
  

• Week 51, 04/18 - 04/24.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Weekly Status: Reviewed Production package moves, working on JCL control project.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID RKR08352-25, Inactive review not closing accounts. ID those accounts that fall under the above criteria. ChangeMan Package # YCPS011841. Will ID(Buss Object) all non closed accounts six months or older, production move March. Research following for PCR; DO NOT POST A PAYMENT TO A CLOSED CBIS ACCOUNT IF THE ACCOUNT HAS BEEN CLOSED FOR MORE THAN 6 MONTHS.
  Product Change Request ID SSC10013-32, Reactivation of PCR. Partially fixed and the % of bills rendered on time itself does seem to be correct now. It is no longer counting rerouted bills as "late" when they were actually rendered on time.
  However, there is still a problem with this report associated with realigned accounts. It is counting the # days late incorrectly on the RMDS report and the dashboard itself and placing some in the wrong column for the # of days. I wonder if it is still using the old "from" bill cycle that was on the account before it was rerouted in order to calculate the # days late, rather than using the new bill cycle. Here are some examples of errors in # of days.
  ChangeMan Package # YCPS011900, package component(s);PXCAR750.
  Production move 4/22/05.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis, Data from following sources reviewed & compared, RMDS report, Primary cursor, programmer created cursor, only discrep found was with the January RMDS report & the two other cursors using January's data. CM package YCPS011941.
  Weekly Status: Completed Control Listing Project, working on Aging discrepancy problem.
  Classes Attended: N/A
  Assigned Tasks:
  Problems: None.
  

• Week 52, 04/25 - 05/01.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(April) PCR Production Loads: PCR's RKR08352-25 & SSC10013-32.
  Detailed Task List
  Weekly Status: Completed job analysis for Control Interface Project. PCR AMB10776-8 cancelled. Assigned some fill in work for non-pay disconnect project (modifing programs PXCAT206/207). Specs received 4-28-2005.11:49. Programs PXCAT206/207 modified & promoted, changes remain to be tested.
  Classes Attended: N/A
  Assigned Tasks:
  Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job-PS parms passing DSN to proc).
  Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
  Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs.
  Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
  Product Change Request ID AMB10776-8, Aging of Agreements report does not seem to be correct for GreenPower for February. Under Analysis, Data from following sources reviewed & compared, RMDS report, Primary cursor, programmer created cursor, only discrep found was with the January RMDS report & the two other cursors using January's data. CM package YCPS011941. Canceled 4/28.
  Problems: I've gotten reports from xxxxxx stating that the Manage Payment GUI has increased quite a bit since the 04/22/05 release. Reason being I assume is the implemented PCR below. Scenarios are occuring where the closed account may be > 6 months old but the closed account has been transferred (meaning XFER_TO_CUSACC_IDN is populated on CBIS.Customer_account table). - and payment is falling to the GUI instead of following the correct payment routine and posting to the new transferred account. PCR RKR08352-25 subsequently resurrected.
  

Overall Active PCR Status (Blue Slated for Prod Move):

Product Change Request ID DHU10322-30 for 03/2005 prod move. ChangeMan packages YCPS11705(JCL Modification) & YCPS11817(Proc Modification). Replacing Proc PXFTP with Pearl Script Steps. Testing Pearl Scripts, need to prepare ChangeMan Package with proc modification(creation of Temp DSN containing job - PS parms passing DSN to proc).
Product Change Request ID DMR07628-22, Java PCR, literal change & Config file modifications (blam.xml, config.xml & admin.xml). Components checked out & returned, unmodified 7/30. Verify with RM then check out of SS.
Product Change Request ID RDT08958-50, Under Analysis, waiting on TB for specs, last update 8/11.
Product Change Request ID LRV09652-19, Investigate why duplicate rows are being set up in PXCAA388. Under Analysis, ChangeMan Package # YCPS011839. Need to know why we are getting the -803.
Product Change Request ID AWK09480-19, Resurrected retesting required, U037BS jobs not reporting -913 error. Verify step showed there was no accounts to process but the error was not reported. CM package YCPS011607.