• Week 1, 04/30 - 05/06.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR DHU13385-16.
  Weekly Status: PCR/ChangeMan Package AMB12589-51/YCPS012376 moved into production. Moved remainder of AFP mod for merger project into production. Assigned to new group), completed J2EE web project (reading XML order file disseminating JSP page , displaying orders).
  Classes Attended: N/A
  Problems: None.
  

• Week 2, 05/07 - 05/13.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR's DHU13385-16, PPJ13356-45 & MBS11117-8.
  Weekly Status: Modified/tested PCR's PPJ13356-45 & MBS11117-8 program changes (MBS11117-8/waiting for added user mods).
  Classes Attended: N/A
  Problems: None.
  

• Week 3, 05/14 - 05/20.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR's DHU13385-16, PPJ13356-45 & MBS11117-8.
  Weekly Status: PCR MBS11117-8 frozen & ready for 6/9 prod move, completed Client Server project to display DB2 table data on JSP page. Reviewed PCR's PPJ13356-45 & MBS11117-8 for code lock.
  Classes Attended: N/A
  Problems: None.
  

• Week 4, 05/21 - 05/27.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR's DHU13385-16, PPJ13356-45 & MBS11117-8.
  Weekly Status: Completed PCR RDT12319-5 (7/21 Prod Move). Migration from LOTU Notes to MicroSoft OutLook.
  Classes Attended: N/A
  Problems: None.
  

• Week 5, 05/28 - 06/03.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR's DHU13385-16, PPJ13356-45 & MBS11117-8.
  Weekly Status: Completed Client Server project to read XML file (extracting acct IDN's) & use extracted IDN's to update DB2 account tables, displaying update results on via JSP.
  Classes Attended: N/A
  Problems: None.
  

• Week 6, 06/04 - 06/10.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jun/09) Project/PCR Production Loads: PCR's DHU13385-16, PPJ13356-45 & MBS11117-8.
  Weekly Status: N/A
  Classes Attended: N/A
  Problems: None.
  

• Week 7, 06/11 - 06/17.
  Goals: Monitor PCR/Prod Moves, complete PCR's KJB13771-59 & SSC10013-32. Complete Assigned tasks, Review DB2 Queries & DB2 tools.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13771-59 & SSC10013-32.
  Weekly Status: Completed mods for KJB13771-59 & SSC10013-32, testing for KJB13771-59 & SSC10013-32 completed.
  Classes Attended: N/A
  Problems: None.
  

• Week 8, 06/18 - 06/24.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13771-59, KJB13373-22 & SSC10013-32.
  Weekly Status: Completed mods & testing for PCR KJB13373-22. Modifications from PCR KJB13373-22 moved to PCR SSC10013-32.
  Classes Attended: N/A
  Problems: None.
  

• Week 9, 06/25 - 07/01.
  Goals: Code Lock, review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13771-59, KJB13373-22 & SSC10013-32.
  Weekly Status: Made last miniute mods to PCR's KJB13373-22 & SSC10013-32, PCR's for July's production move reviewed & verified (prior to Code Lock). Client Server Screens completed DB2 Attribute tables updated, GUI Components involved; Java Classes, Servlet & JSP's.
  Classes Attended: N/A
  Problems: None.
  

• Week 10, 07/02 - 07/08.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13771-59, KJB13373-22, SSC10013-32 & RAC14073-27. Weekly Status: Modified GUI Attribute Table updates, moving SQL Try/Catch from Java action class to servlet additionally added new JSP Error screen. Reviewed FromHost file for June 20 hand held meter processing, prod mods moved June 9 (PCR MBS11117-8). Completed PCR RAC14073-27.
  Classes Attended: N/A
  Problems: None.
  

• Week 11, 07/09 - 07/15.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13373-22, SSC10013-32 & RAC14073-27.
  Weekly Status: PCR KJB13771-59 pulled from July's production move. Documented processing flow for payments/Checkfree file processing. Created Rate Calculation Report given CUSACC IDN & Zip Code (J2EE Application).
  Classes Attended: N/A
  Problems: None.
  

• Week 12, 07/16 - 07/22.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Jul/21) Project/PCR Production Loads: PCR's RDT12319-5, KJB13373-22, SSC10013-32 & RAC14073-27.
  Weekly Status: Bug in Rate Calculation Report-J2EE Report, external classes not found & data incorrectly passed from JSP to Servlet. Corrected both bugs (using variable vice external jar & moving tag past data aquisition). Provided analysis for current print projects, analysis completed for PCR RDT13292-54 (Requested work for PCR complete waiting on BU/PJ for new directives), initiated analysis of PCR EQW10703-10 (BU/RR contacted waiting for feedbak).
  Classes Attended: N/A
  Problems: None.
  

• Week 13, 07/23 - 07/29.
  Goals: Start & complete PCR KJB13771-59, touch base with BU's about PCR's; RDT13292-54 & EQW10703-10, Review July's modified production jobs. PCR TDG06444-24 mods do not work review why & get back to BU. Complete Assigned tasks, Review DB2 Queries & DB2 tools. Work on non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's KJB13771-59 & TDG06444-24.
  Weekly Status:
  

  SSC10013-32
  PXCAR750 - W037BPM2
  Runs 2nd Sunday - review 8/13
  
  RDT12319-5
  PXCAT230 - U037AMEX
  Runs Daily 0600 - review 7/24
  Reviewed job output, looks OK. 
  
  RAC14073-27
  PXDSP110 - U037RUDL
  Last Run 7/22 DK037.RDGUSG.PXDSP110.FROMHOST.G1609V00 
  Manufacturer/Model Codes reviewed, all OK.
  
  PPJ13356-45 
  Pxcap290 - U037GR48
  Reviewed output DSN's DK037.PRFACCT.U037GR48.REPT01/2/3
  Number of Accounts < 500.00 looks OK
  
  KJB13373-22
  PXCAT690 - No Job to Review
  Review DB2 table entry for CBIS.TRANSACTION_LOG, TRANSACTION_CODE = 'P02' :
  Unable to run SQL Resource Restraints. 
  

  Completed PCR KJB13771-59. Modified primary cursor for PCR TDG06444-24 (in process of testing Left Outer Join/ discrepancies noted process of data or SQL mods?).
  Classes Attended: N/A
  Problems: None.
  

• Week 14, 07/30 - 08/05.
  Goals: Complete Assigned tasks, Review DB2 Queries & DB2 tools. Work on non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59 & TDG06444-24.
  Weekly Status: PCRs RAC14233-46 & TDG06444-24 completed & tested. Tesing in progress for PCR KJB13771-59.
  Classes Attended: N/A
  Problems: None.
  

• Week 15, 08/07 - 08/12.
  Goals: Complete testing of PCR KJB13771-59 (VB service classes, if created test CBIS for CUSACC Label else no damage). Start PCR EQW10703-10, complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59, TDG06444-24 & PPJ14172-1.
  Weekly Status: Completed mods & testing of PCR's KJB13771-59 & TDG06444-24.
  Classes Attended: N/A
  Problems: None.
  

• Week 16, 08/13 - 08/19.
  Goals: Review production run job stats for W037BPM2 (Sat AM). Complete Assigned tasks, Review DB2 Queries & DB2 tools. Complete non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59, TDG06444-24 & PPJ14172-1.
  Weekly Status: Completed Off Schedule Load Request for PCR SSC10013-32 (8/16/06), SQL created/tested & reviewed by higher authority for PCR PPJ14172-1. Completed FERC Affiliate Rules (Standards of Conduct) training.
  Classes Attended: N/A
  Problems: None.
  

• Week 17, 08/20 - 08/26.
  Goals: Code Lock 8/23/06 - review PCR's slated for prod move, complete assigned tasks. Complete non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59 & TDG06444-24.
  Weekly Status: Reviewed job W037BPM2, job ran OK, 0 return code. 3rd Party IT Access Request & Service Account Request (Vendor contact data required/Tecnical & Application) initiated. Requested resources from RB, given JK, initiated LAN Share & Access Request for access to EBill Server (waiting iss ADM approval). Assigned to CC.23 project.
  Classes Attended: N/A
  Problems: None.
  

• Week 18, 08/27 - 09/02.
  Goals: Assist Testing team with mods slated for 9/15 prod move, complete PGP encryption/decryption requirements for PCR PPJ14172-1. Work on project analysis phase.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59 & TDG06444-24.
  Weekly Status: LAN Share & Access Request has been rejected, Help Desk contacted Ticket # 2760896. Glitch with PCR KJB13771-59, new version # for PXDST130 not accepted by PXDST135, demoted modpackage code, testing. PGP Keys exchanged.
  Classes Attended: N/A
  Problems: None.
  

• Week 19, 09/03 - 09/09.
  Goals: Assist Testing team with mods slated for 9/15 prod move, test PGP encryption/decryption scripts (Duke key address matter - Resolve)/FTP steps for PCR PPJ14172-1. Work on project analysis phase.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59 & TDG06444-24.
  Weekly Status: Duke key address matter - Resolved, all three PCRs scheduled for 9/15 move approved by Buss Testers.
  Classes Attended: N/A
  Problems: None.
  

• Week 20, 09/10 - 09/16.
  Goals: Production move, Friday/On Call. Complete assigned tasks. Complete non completed PCR's.
  Monthly(Sep/15) Project/PCR Production Loads: PCR's RAC14233-46, KJB13771-59 & TDG06444-24.
  Weekly Status: All Sept Prod/PCR completed Business Acceptence (9), DB2 Load Utility (temp DB2 table) completed (untested to date).
  Classes Attended: N/A
  Problems: Problems with PCR TDG06444-24, moved it to 10/20 prod move.
  

• Week 21, 09/17 - 09/23.
  Goals: Monitor jobs that went into production:
  PCR's/Jobs RAC14233-46/U037RUDL(WD), KJB13771-59/NA & TDG06444-24/U037BMCI(WD).
  Complete assigned tasks. Complete non completed PCR's.
  Monthly(Oct/27) Project/PCR Production Loads: PCR PPJ14172-1, TLG14550-45 & TDG06444-24.
  Weekly Status: PCR TDG06444-24 regenerated/tested Package reset for Oct prod move. Merge program created for PCR PPJ14172-1.
  Classes Attended: N/A
  Problems: Problem with RAC14233-46/U037RUDL, code looks correct. Will review Input DSN as soon as user sends. Problem Compiling PXRGRPCA, Changed compiler options - under review.
  

• Week 22, 09/24 - 09/30.
  Goals: Complete & test PCRs TLG14550-45 & TDG06444-24. Complete all assigned tasks.
  Monthly(Oct/27) Project/PCR Production Loads: PCR PPJ14172-1, TLG14550-45 & TDG06444-24.
  Weekly Status: PCR TLG14550-45 mods made, package YCPS012767 promoted to CBISCMPT.
  Classes Attended: N/A
  Problems: Problem with PCR TLG14550-45 Static Link not working (only able to Dynamic Link Programs), resolved wrong compile/link parms - reviewed PXDST529.
  

• Week 23, 09/31 - 10/07.
  Goals: Prepare for Code Lock (10/06). Complete assigned tasks. Complete PCR TLG14550-45, mods & testing.
  Monthly(Oct/27) Project/PCR Production Loads: PCR TLG14550-45 & TDG06444-24.
  Weekly Status: New DSN request submitted for FTP step (RACF Security Request). Per security reopened RACF Security Request adding EBill Server & created new Service Account Request for new FTP ID.
  Classes Attended: N/A
  Problems: Still unable to pass viable file to external vendor, hex X'09' delimiters not passed. Pushing PCR PPJ14172-1's implementation back to November, barring a minor miracle. Converted delimiters from Hex X'09' to X'05', resolved validation problem.
  

• Week 24, 10/08 - 10/14.
  Goals: Continue testing programs in code lock. Renew project analysis & complete all assigned tasks.
  Monthly(Oct/27) Project/PCR Production Loads: PCR TDG06444-24.
  Weekly Status: Created Program PXCAT073 (creates FTP CNTL Card for job W037TCFS) for ChangMan package YCPS012741. Created new package(YCPS012788) for CINQ addition to PXRGRPCA. PCR TLG14550-45 Off Sched Load vice Oct's production load(10/11/06, backed out same day). Problems corrected for PCR TLG14550-45 Off Sched Load 10/13/06/1330. Additional Security forms submitted for new FTP ID. Sample extract file created/transmitted & processed by vendor, EBill FTP/Decryptions script to be tested 10/16/06.
  Classes Attended: N/A
  Problems: Off Sched Load 10/11 backed out (one of the included queries not performing as expected).
  

• Week 25, 10/15 - 10/21.
  Goals: Test EBill FTP/Decryptions script 10/16/06. Complete PCR PPJ14172-1.
  Monthly(Oct/27) Project/PCR Production Loads: PCR TDG06444-24.
  Weekly Status: Started PCR JSL14710-59, Tested Decryption/FTP Scripts executed, successfully tested 10/17/2006. Extracted from CBIS & loaded into CBISCMPT following CUSACC IDN’s 232, 425, 590, 835, 837, 996, 1023, 1032, 1054, 1336, 1447, 1491, 2107, 2161, 2421. Reorg Time, new group.
  Classes Attended: N/A
  Problems: None.
  

• Week 26, 10/22 - 10/28.
  Goals: Complete PCR PPJ14172-1, probably load PCR via Off Schedule move. Monitor Fridays prod move. Review non completed PCR's.
  Monthly(Oct/27) Project/PCR Production Loads: PCR TDG06444-24 & PPJ14172-1.
  Weekly Status: Modified programs PXCAT070 & PXCAT073 (new user requirements). All Components for PCR PPJ14172-1 successfully tested. Completed all prerequisits for PCR PPJ14172-1, adding it to Oct's Prod Move.
  Classes Attended: N/A
  Problems: None.
  

• Week 27, 10/29 - 11/04.
  Goals: Monitor Fridays prod move. work on profect, review non completed PCR's.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: Mapping problem with PXRGRPCA resolved, PCR ready for Dec PROD move.
  Classes Attended: N/A
  Problems: How to pass CEBR error structure from REGROUP to PXSUT390?
  

  New CEBR 01 Structure, 01 name changed due to compile restrictions.  
  
         WORKING-STORAGE SECTION.
  
         01  WS-START                        PIC X(31)
             VALUE 'WORKING-STORAGE STARTS HERE===>'.
  
         01  WS-STATIC-AREA.
             05  WS-PXWHOAMI           PIC X(8)         VALUE 'PXWHOAMI'.
             05  WS-PXSUT690-PGM       PIC X(8)         VALUE 'PXSUT690'.
             05  WS-PXTMSTMP-PGM       PIC X(8)         VALUE 'PXTMSTMP'.
             05  WS-PUTCBIS-PGM        PIC X(8)         VALUE 'PUTCBIS '.
             05  WS-PXSUT390-PGM       PIC X(8)         VALUE 'PXSUT390'.
             05  WS-LPROGRAM-PGM       PIC X(8).
  
  *deh       REPLACE ==:TAG:== BY ==WK==.
         01  WK-ERROR-STRUCTURE.
             COPY CBERRSTR.
  *15*       REPLACE OFF. 
  
  ...
  ...
  
  *15*  ******************************************************************
  
         01  WS-VIEW-ADDR                            POINTER.
  
  *15*   01  WS-PREGROUP-ERROR-STRUC-ADDR            POINTER.
  
         01  WS-STOP                                 PIC X(30)
             VALUE '<===WORKING-STORAGE STOPS HERE'.
  
  ...
  ...
  
  No mod to Linkage Section & Procedure.
  
  Data Structure Allocation
  
         ALLOCATE-DATA-STRUCTURES.
  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -   140 Line(s) not Displayed
  
  *deh       CALL 'PXGETADR' USING DFHEIBL1, DFHCOMMARE1,
                WK-ERROR-STRUCTURE,
                LK-PREGROUP-ERROR-STRUC-ADDR
             END-CALL
  
  *deh       SET WS-PXSUT390-ERROR-STRUC-ADDR TO
                 LK-PREGROUP-ERROR-STRUC-ADDR
  ...
  ...
  
  
  

• Week 28, 11/05 - 11/11.
  Goals: Review non completed PCR's.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: Program/PCR PXRGRPCA/JSL14710-59 tested CINQ record generated, all thqt remains is to establish the requested Printer Destination (i.e. how to find CICS printer ID associated with requested Lan Printer ID?).
  Classes Attended: N/A
  Problems: None.
  

• Week 29, 11/12 - 11/18.
  Goals: Review non completed PCR's.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: SPOC request initiated to find CICS printer ID associated with requested Lan Printer ID. 11/22/06 Code Lock, with the exception of cosmetic changes, i.e. CINQ literals & production printer designation PCR JSL14710-59 tested & read for Business Testing. Set following after package Tested by bussiness; Printer ID set to '!P01', Switch WS-PXSUT390-PRINT-YES set to true. KIOS Project nixed back to PCR hell. Cleanup December PCR's/ChangeMan Packages.
  Classes Attended: N/A
  Problems: None.
  

• Week 30, 11/19 - 11/25.
  Goals: None - Vacation.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: Cruise to Hell Description
  Classes Attended: N/A
  Problems: None.
  

• Week 31, 11/26 - 12/02.
  Goals: Back at work, work with TG to complete Business Testing of PCR JSL14710-59. Monitor production run of PCR PPJ14172-1 (contingent on business acceptance), review non completed PCR's.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: Project TAH14402-30 cancelled. Ran extraction query for PCR PPJ14172-1 to obtain number of records to send to vendor (390,977), program PXCAT070 OK as long as extraction number under 400,000. PCR LRV09652-19 , possibly its an initialization problem. Business testing for PCR PPJ14172-1 completed, package brought down & production mods made.
  Classes Attended: N/A
  Problems: None.
  

• Week 32, 12/03 - 12/09.
  Goals: Monitor Jobs W037TCFS & W037TCFR(12/05/2006), complete all required mods to PCR JSL14710-59, review non completed PCR's.
  Monthly(Dec/08) Project/PCR Production Loads: PCR JSL14710-59.
  Weekly Status: Job W037TCFS ran, several JCL snags (ie pointing at DB2Test vice DB2PrdB, typo in inbedded SQL & incorrect Return Code check), OffSchedule load created (PCR/ChangeMan DHU14984-6/YCPS012858) to implement corrections. Job W037TCFS completed, data encrypted & sent to vendor site, 12/06/2006. Adding to own knowledge of CSS/HTML.
  Classes Attended: N/A
  Problems: 80+ % records received in error, see following:
  You sent 300,000 plus records. We were only able to process 43,383 records because when the file was decrypted the other 257,000 records contained "odd" characters that couldn't be processed. Vendor problem, waiting for resolution.
  Problem resolved file will be resent to vendor 12/11/06.
  

• Week 33, 12/10 - 12/16.
  Goals: Complete Off Schedule Load DHU14984-6 (12/15/2006), resend vendor data process returned data. Concentrate on PCR EQW10703-10, complete all assigned tasks and review other non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: None
  Weekly Status: Completed 21st Century Vendor Phone project, triggered ob W037@L47(return code 8). Complete Off Schedule Load DHU14984-6 (12/15/2006).
  Classes Attended: N/A
  Problems: None.
  

• Week 34, 12/17 - 12/23.
  Goals: Complete all assigned tasks, review non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47
  Weekly Status: Corrected bug in Stored Procedure/21st Century Vendor Phone project, Off Sced Load (12/20/2006) DHU15050-2/YCPS012861. DB2 utility DB2 load job W037@L47 successfully rerun 12/21. Completed PCR TLA15056-47.
  Classes Attended: N/A
  Problems: None.
  

• Week 35, 12/24 - 12/30.
  Projected Tasks: CleanUp Stored Procedure SQL506666, explain why 934 records failed to insert. Work on PCR RDT12319-5, touch base with BU. Complete all assigned tasks, review all non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47
  Weekly Status: Able to explain aproximatly 70% of 934 failed inserts (70%, valid rejects #s existed with non null last eff dates), remaining 30% unexplained. Created technical PCR(DHU15082-12) to correct problem with Stored Procedure (SQL50666), pCR must be prioritized.
  Classes Attended: N/A
  Problems: None.
  

• Week 36, 12/31 - 01/07.
  Projected Tasks: Get PCR DHU15082-12 priotized, Prepare for Code Lock, complete testing of package YCPS012868. Complete all assigned tasks, review non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47 & DHU15082-12
  Weekly Status: PCR DHU15082-12 prioritized & completed for code lock(1/04). Currently analysing 934 non table inserts.
  Classes Attended: N/A
  Problems: None.
  

• Week 37, 01/08 - 01/14.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47 & DHU15082-12
  Weekly Status: Analysed & resolved PCR EQW09828-27, created new SQL view for PCR EQW09828-27.
  Classes Attended: N/A
  Problems: None.
  

• Week 38, 01/15 - 01/21.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47 & DHU15082-12
  Weekly Status: Searching R Drive for documentation for PCR RDT08958-50. Creating test cases for PCR EQW09828-27(Identifing ADAPT or AMS-read TOU meters in CBISCMPT, to step through with XP/RNDSA370). View (JINSRA) created & program (PXDSA145) modified accordingly/No Damage Testing successfully completed. PCR LRV09652-19 rejected by user.
  Classes Attended: N/A
  Problems: None.
  

• Week 39, 01/22 - 01/28.
  Projected Tasks: Monitor PCR's going into production. Complete all assigned tasks, review non completed PCR's.
  Monthly(Jan/26) Project/PCR Production Loads: TLA15056-47 & DHU15082-12
  Weekly Status: PCR EQW09828-27 completed & tested, ready for 3/9 move. Data, List & SQL Extract objects created for Aging Report (J2EE Platform)
  Classes Attended: N/A
  Problems: None.
  

• Week 40, 01/29 - 02/04.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Created Servlet (ServletAgingRpt) JSP's (JSPAgeRpt & JSPRptDisplay) & Driver for SQL Action Class(DrJoinAgingSQL) for Aging Report (J2EE Platform), modified Aging Report Application to either display or print requested data on a Excel Spread Sheet.
  Classes Attended: N/A
  Problems: None.
  

• Week 41, 02/05 - 02/11.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Off Sched load of PCR TLG15301-28 2/9 completed (Vendor Table Data backed out). PCR JLH13622-53 Rejected.
  Classes Attended: N/A
  Problems: Phone #'s supplied by vendor quality in question.
  

• Week 42, 02/12 - 02/18.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Reviewed Prod table clean-up PCR (TLG15301-28), table clean-up OK. Reviewed PCR EQW09828-27 in prep for Code Lock (2/16), Cleaned up problems with Aging Report J2EE-GUI.
  Classes Attended: N/A
  Problems: None.
  

• Week 43, 02/19 - 02/25.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Assigned PCR ATP15059-37, fishing for added info. Coded & promoted PCR SEP15407-37/mod to existing Stored Procedure (currently unable to test mods).
  Classes Attended: N/A
  Problems: None.
  

• Week 44, 02/26 - 03/04.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Assigned PCR's SEP15407-37 & JMM15420-33. Analysis of PCR RDT12319-5 completed, coding & testing currently under way. Scheduled required training course SDLC 2&3 / SDLC 4. Reviewing 21st Century File Transfer job for best ways to QC vendor returned data.
  Classes Attended: N/A
  Problems: None.
  

• Week 45, 03/05 - 03/11.
  Projected Tasks: March Prod Move(on call 3/9 for MVS side), extract prod data for PCR RDT12319-5. Complete all assigned tasks, review non completed PCR's.
  Monthly(Mar/09) Project/PCR Production Loads: EQW09828-27
  Weekly Status: Vendor phone data recieved/request to run job W037TCFR, job ended with 37 Return code(vendor removed carriage controls, how under investigation). Mods to PCR SEP15407-37 completed, unable to test. Analysing PCR JMM15420-33. On call for this Production Move (MVS Side). Assigned PCR EQW15348-6, Coding & testing currently completed. Assigned & completed PCR LDT15416-47(ChangeMan package Audited/Promoted/Frozen & CA7 entry created).
  Classes Attended: N/A
  Problems: None.
  

• Week 46, 03/12 - 03/18.
  Projected Tasks: Implement Off Schedule Load for PCR SEP15407-37, concentrate on testing PCR's scheduled for 4/27 move, initate analysis of PCR JMM15420-33. Complete all assigned tasks, review non completed PCR's.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6 & LDT15416-47
  Weekly Status: Vendor Phone Data corrected & sent to Duke(FTPed from client server to E-Bill Server), required job(W037TCFR) subitted. PCR SEP15407-37 successfully off schedule loaded 3/14. Off Schedule Load for SP SQL15114 completed 3/16, assigned PCR MLP15424-3.
  Classes Attended: N/A
  Problems: StoreProcedure SQL50666 -805, DBRM not included in last SP mod. In addition similar flaw found in SQL15114.
  

• Week 47, 03/19 - 03/25.
  Projected Tasks: Complete Off sched Load for PCR DHU15471-6(Modify SP SQL50666). Complete all assigned tasks, review non completed PCR's.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6 & LDT15416-47
  Weekly Status: Assigned PCR JLH09951-22, DBA tested mods for PCR DHU15471-6, PCR OffShcedLoad 3/21. Accounts Targeted by BU removed from vendor flat file (via EasyTrieve), will add EasyTrieve step to job W037TCFR (removing non populated & duplicate phone numbers) in OffSchedLoad request after BU approval will then rerun W037TCFR which will trigger W037@L47 (work table load). OffSchedLoad requests (DHU15508-14/JCL & DHU15502-17/P037PHE2) completed for W037TCFR modification
  Classes Attended: N/A
  Problems: None.
  

• Week 48, 03/26 - 04/01.
  Projected Tasks: Submit request to run job W037TCFR(without triggers), submit IM load request & prepare for code lock(4/4/07). Complete all assigned tasks, review non completed PCR's (emphasis on PCR's; JLH09951-22 & JMM15420-33).
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6, LDT15416-47 & DHU15522-33
  Weekly Status: Reran Job W037TCFR (From STEP040), due JCL errors job rerun three times, PCR/ChangeMan Package DHU15522-33/YCPS012938 created to correct discrepancies. Production move 4/27. BU reviewed vendor data, Job W037@L47 executed, CBIS work & phone tables loaded. Reviewed production bound jobs prior to code lock(4/02/07).
  Classes Attended: N/A
  Problems: JCL syntax error not tagged by JOBSCAN resulting in a EC141I 013-34,IGG0191A,W037TCFR,STEP060,IN1FILE,VIO error during production run(3/26).
  ANSWER: not a SYNTAX error that causes the job to fail. It will run with the space after the DSN=, therefore JOBSCAN woud not flag that as an error.
  

• Week 49, 04/02 - 04/08.
  Projected Tasks: Final Preps for Code Lock(04/02). Complete all assigned tasks, review non completed PCR's.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6, LDT15416-47 & DHU15522-33
  Weekly Status: N/A
  Classes Attended: N/A
  Problems: None.
  

• Week 50, 04/09 - 04/15.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6, LDT15416-47 & DHU15522-33
  Weekly Status: N/A
  Classes Attended: N/A
  Problems: None.
  

• Week 51, 04/16 - 04/22.
  Projected Tasks: Complete all assigned tasks, review non completed PCR's.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6, LDT15416-47 & DHU15522-33
  Weekly Status: N/A
  Classes Attended: N/A
  Problems: None.
  

• Week 52, 04/23 - 04/29.
  Projected Tasks: Clean up all loose ends, end of contract.
  Monthly(Apr/27) Project/PCR Production Loads: RDT12319-5, EQW15348-6, LDT15416-47 & DHU15522-33
  Weekly Status: N/A
  Classes Attended: N/A
  Problems: None.
  

Sample Survey :

Overall Active PCR Status
Blue Currently Working on, Red complete & ready for Prod move:

Task PCR's:

Product Change Request ID BDK10851-6, When existing agreement is changed to "Fixed Annual", the next billing shows as Annual Minimum Month 12 as if it is the settle up billing, ChangeMan Package # YCPS012643.
01/31/2007 - Analysis
Product Change Request ID EQW10703-10, Billing exceptions were closed in error and no bill generated. Under Analysis, PCR Requirements: A. Create SQL to ID accounts that meet following criteria: find accounts where this exception has been closed automaticall the bill will be MAILED to the customer, rather than sit in limbo. ID Bills that must be corrected, Manual Correction more then likely.
B. It is fine to close these exceptions for OL, EF, agreements, etc., however, when we do so, we must change the bill disposition so that the bill will be MAILED to the customer, rather than sit in limbo.
Correct the process itself. ChangeMan Package # YCPS099999.
06/29/2006 - PCR assigned.
07/20/2006 - Consulted with BU/RR about Bill Processing & PCR, feed back expected 07/24.
12/01/2006 - Analysis restarted
01/30/2007 - Ran SQL to ID accounts with the required condition (current date).
02/21/2007 - PCR & Workup given to RR for review.
02/23/2007 - DEH - Possible resolution to problem Create job & job stream to reopen closed Exceptions or to create new Exceptions, this & other questions waiting answer from Reid & Beth.
Product Change Request ID RDT08958-50, Duplicate meter change lines on bill image causing Z sorts....II. ChangeMan Package # YCPS099999.
12/01/2006 - Analysis started
01/15/2007 - Searching R Drive for PCR Documentation. None Found.
02/23/2007 - ID procedure & DSN's involved in assignment of 'Z' code.
Product Change Request ID ATP15059-37, MP accts are not showing correct amount for Total Electric Usage Line on page 1 of a 2 page bill when there have been adjustments, ChangeMan Package # YCPS012907.
02/21/2007 - PCR assigned, given to RR for preliminary review.
02/23/2007 - Pin point procedure to Adjust Multiple Premise accts.
02/28/2007 - PCR under active review of BC/RR.
02/29/2007 - Meeting set with RR & DW to review PCR & multi premises.
03/29/2007 - Meeting with RR & DW:
Total Amounts in question were out of sync by the LPC amount. The LPC amount is tallied by Program PXCAA480 in the "TELECCHG" section of code. The Code in question was modified last year for a similar problem with NonMulti Premis Accounts (worked for Non MP Accounts). Step through code either LPC is added twice & removed once or its added once & not removed. Evaluate PXCAA480, desk check section of code that reviews charges & dumps amount in buckets.
Product Change Request ID JMM15420-33, Correct Job U037RUUS (ADAPT Readings), ChangeMan Package # YCPS012911.
03/02/2007 - PCR assigned, changeMan Package created.
03/29/2007 - Attacking restart bug & modification to processing flow(continue processing untill EOF nless catestrophic error occurs).
Product Change Request ID AGC11685-59, PXCAA240 is reducing eligible delq action amount with deferred EPP credit in error. ChangeMan Package # YCPS012939.
03/27/2007 - PCR assigned.
Product Change Request ID JLH09951-22, NC Accounts received disconnect date of Friday 11/12/2004 from the stand alone Delinquent Letter Process and the Delinquent Letter on the bill process. ChangeMan Package # YCPS0129##.

Tracking PCR's, PROJECTS:

None Assigned