Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-10372

Solomon Page - Payroll File No. auto generate

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Module:
      BenAdmin - EDS
    • Reported by:
      Client
    • Item State:
      Stage QA - On Hold
    • Sprint:
      WT Sprint 36 - Enhancement, WT Sprint 38 - Enhancement
    • Severity:
      Simple

      Description

      WORKTERRA will be auto generating the Payroll File No. the field that will have the auto generate set is "Payroll File No." on the Payroll page.

      Can we set the auto generation on stage now this way we can test out the auto generation process? The client has given us the highest number, based on last weeks adds, so we can start with 035393. The Payroll File No. always has to be 6 digits long.

      When the site moves up to production we can get the latest number from the client. We will mark the start number in the move to production ticket when the time comes.

      CC: Robyn AdkisonRochelle ThomasNathaniel Cornejo-Walker

        Attachments

        1. WT-10372_Analysis_Document.doc
          11 kB
          Jyotibala Pardeshi
        2. WT-10372 Test Cases.xls
          12 kB
          Meghana Joshi

          Activity

          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 03/Aug/17 02:14 PM
          • Time Spent:
            1h
             
            <No comment>
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 04/Aug/17 01:25 AM
          • Time Spent:
            20m
             

            internal discussion with satya and vinayak
            updated the comments

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 10/Aug/17 12:24 AM
          • Time Spent:
            10m
             

            updated the comments

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 18/Aug/17 12:25 AM
          • Time Spent:
            5.6h
             

            Analysis and debugging of code.
            Created new trigger to get the auto generated payroll file no for Employee_Payroll table.

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 18/Aug/17 12:45 AM
          • Time Spent:
            0.5h
             

            task explanation
            scenario discussion

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 28/Aug/17 07:20 PM - edited
          • Time Spent:
            0.2h
             

            Internal discussion with Rushikesh.

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 29/Aug/17 12:46 AM
          • Time Spent:
            20m
             

            internal discussion

          rushikesh.bane Rushikesh Dattatray Bane (Inactive) logged work - 29/Aug/17 09:46 AM
          • Time Spent:
            3h
             

            Analysis - Code review

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 30/Aug/17 04:40 AM - edited
          • Time Spent:
            1h
             

            Internal discussion with Satya and mailed regarding same to Rushikesh.
            Check in done for LB and Trunk.
            Updated comments.

          meghana.joshi Meghana Joshi (Inactive) logged work - 01/Sep/17 12:26 PM
          • Time Spent:
            3h
             

            LB Testing

          meghana.joshi Meghana Joshi (Inactive) logged work - 01/Sep/17 12:36 PM
          • Time Spent:
            3h
             

            Analysis
            Discussion with Sheetal
            Test Cases Writing

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 01/Sep/17 07:05 PM
          • Time Spent:
            0.5h
             

            discussion with meghana

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 02/Sep/17 04:18 AM
          • Time Spent:
            0.75h
             

            Discussion with Meghana. Prepared Analysis document.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 05/Sep/17 05:18 AM - edited
          • Time Spent:
            0.2h
             

            Stage script check in

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 14/Sep/17 11:23 PM
          • Time Spent:
            0.3h
             

            Discussion with Swapnil.
            Updated comments.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 27/Sep/17 11:53 PM
          • Time Spent:
            7h
             

            Created new trigger which will update the payroll file no only when class3 changes are appears.
            R&D on trigger with specific column change data.
            Internal discussion with Swapnil.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 29/Sep/17 01:09 AM
          • Time Spent:
            4h
             

            Modified the trigger and internal discussion with Swapnil.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 29/Sep/17 06:33 AM
          • Time Spent:
            0.2h
             

            Updated analysis document.

          meghana.joshi Meghana Joshi (Inactive) logged work - 29/Sep/17 11:17 AM
          • Time Spent:
            2.5h
             

            Analysis
            Test Cases Writing

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 29/Sep/17 09:01 PM
          • Time Spent:
            0.2h
             

            Lb and Trunk check in.

          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 04/Oct/17 11:26 AM
          • Time Spent:
            0.5h
             

            Discussion with Jyoti

          meghana.joshi Meghana Joshi (Inactive) logged work - 04/Oct/17 12:24 PM
          • Time Spent:
            5h
             

            LB Testing

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 05/Oct/17 05:18 AM
          • Time Spent:
            2h
             

            Discussion with Meghana on issue.
            Discussion with swapnil.
            Modified the stored procedure.

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 07/Oct/17 01:54 AM
          • Time Spent:
            20m
             

            Internal discussion with Jyotibala

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 07/Oct/17 06:58 AM
          • Time Spent:
            2.5h
             

            Internal discussion with Swapnil and Sheetal
            Unit testing.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 09/Oct/17 01:10 PM
          • Time Spent:
            0.2h
             

            Code review with sheetal

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 10/Oct/17 12:36 AM - edited
          • Time Spent:
            0.5h
             

            Code review and scenario discussion

          meghana.joshi Meghana Joshi (Inactive) logged work - 12/Oct/17 12:41 PM
          • Time Spent:
            5h
             

            LB Testing

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 12/Oct/17 09:38 PM - edited
          • Time Spent:
            0.5h
             

            Internal discussion with Meghana and Sudhir.

          jyotibala Jyotibala Pardeshi (Inactive) logged work - 16/Oct/17 08:51 AM - edited
          • Time Spent:
            0.8h
             

            Stage check in with the help of amit.
            Internal discussion with Sheetal and Meghana.

          meghana.joshi Meghana Joshi (Inactive) logged work - 16/Oct/17 12:19 PM
          • Time Spent:
            2h
             

            Analysis on Stage

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 16/Oct/17 11:38 PM - edited
          • Time Spent:
            1h
             

            Discussion with Jyotibala and Meghana
            verified Backend data on stage

            People

            Assignee:
            amjohnson Amannda Johnson
            Reporter:
            amjohnson Amannda Johnson
            Developer:
            Jyotibala Pardeshi (Inactive)
            QA:
            Meghana Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 16h Original Estimate - 16h
                16h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 54h 7m
                54h 7m