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

Precision Workforce - Historical Data Load

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Environment:
      Production
    • Reported by:
      White Label
    • Company:
      Precision Workforce
    • Module:
      BenAdmin
    • Severity:
      Simple

      Description

      I have uploaded the historical data to Samir's folder on the FTP site. Please do the initial analysis on the data and provide feedback tomorrow.

        Attachments

        1. image-2017-11-30-15-59-57-127.png
          image-2017-11-30-15-59-57-127.png
          5 kB
        2. screenshot-1.png
          screenshot-1.png
          10 kB
        3. Jan_Badfiles.zip
          4 kB
        4. screenshot-2.png
          screenshot-2.png
          11 kB
        5. screenshot-3.png
          screenshot-3.png
          19 kB
        6. Bad_Beneficiary12_20_2017 05_16_04 AM.zip
          1 kB

          Activity

          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Prasad Pise,

          We have loaded the Beneficiary file which will require QA verification. can you please look into the same?

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Prasad Pise , We have loaded the Beneficiary file which will require QA verification. can you please look into the same?
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Suraj Sokasane,

          Verified Beneficiary data on Precision for hspl on production
          Minimum beneficiary are imported on Production.
          Assuming that there are too many bad records.
          Could not cross verify as bad file is not shared with me.

          Thanks,
          Jayshree

          cc : Prasad Pise Rakesh Roy Jaideep Vinchurkar

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Suraj Sokasane , Verified Beneficiary data on Precision for hspl on production Minimum beneficiary are imported on Production. Assuming that there are too many bad records. Could not cross verify as bad file is not shared with me. Thanks, Jayshree cc : Prasad Pise Rakesh Roy Jaideep Vinchurkar
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Jayshree Nagpure,

          All records were successful and so I did not provide bad file as there wasn't any. Did you find any records that are not present in system? Can you please mention some as examples.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Jayshree Nagpure , All records were successful and so I did not provide bad file as there wasn't any. Did you find any records that are not present in system? Can you please mention some as examples.
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Example :

          633546851- Blife
          637482562 - Blife
          633546851-BADD
          460610399 - BADD
          645122914- EVL
          231399717 - EVL

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Example : 633546851- Blife 637482562 - Blife 633546851-BADD 460610399 - BADD 645122914- EVL 231399717 - EVL
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Debbie Kulling,

          We have completed the Historic load for beneficiaries. Here's cad file : Bad_Beneficiary12_20_2017 05_16_04 AM.zip
          40 out of 409 Records were kicked out with error : Employee not enrolled in Plan. Others were successful.

          Please verify and let us know if you have any queries.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Debbie Kulling , We have completed the Historic load for beneficiaries. Here's cad file : Bad_Beneficiary12_20_2017 05_16_04 AM.zip 40 out of 409 Records were kicked out with error : Employee not enrolled in Plan . Others were successful. Please verify and let us know if you have any queries.

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            dkulling Debbie Kulling
            Account Executive:
            Debbie Kulling
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 51.5h
                51.5h