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

BSG Metso: - ADP Health Compliance Benefits file issue

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      ACA Data Audit
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      Metso Benefits
    • Module:
      ACA
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Description

      12/30/17 - There's no changes for non employee file. Only file with records is the active employee file. File was sent successfully:

      14:05:32 Status: Connecting to sdgcl.adp.com...
      14:05:34 Status: Connected to sdgcl.adp.com
      14:05:34 Status: Starting upload of C:\Users\angu\Desktop\EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171230_135805.txt
      14:05:34 Status: File transfer successful, transferred 2,428 bytes in 1 second
      14:05:35 Status: Retrieving directory listing of "/home/METS3psftpHC/INBOUND"...
      14:05:35 Status: Listing directory /home/METS3psftpHC/INBOUND
      14:05:35 Status: Directory listing of "/home/METS3psftpHC/INBOUND" successful

      Closing JIRA as this is the last ACA file of the year.

      12/29/17 - Last ACA change files will send tonight. ADP is aware the file will be coming and is the last they will receive for 2017.

      Hello Smita Pawar,

      New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in HIGHMARK PPO 90-Medical-Highmark but wasn't on the file. I have uploaded client's audit file Metso ACA file audit.xlsx and their comments Audit of January 2017 Metso ACA file.msg to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ .

      I've checked the template Metso ADP - ACA Employee but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates?

      Metso ADP - ACA Employee
      Metso ADP - ACA Non Employee
      Metso ADP - ACA Multiemployer

      I've tried deleting march run dates from template *Metso ADP - ACA Employee and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was.

      Thank you,

      Alex

      Carrier contact:
      James Camak
      Product Support III
      AVS - Health Care Reform
      706-731-2319

      Tim Fuller FPC, CHRS| Account Manager
      ADP Health Care Reform
      844.237.2221 ext 8172013 tollfree
      Tim.Fuller@adp.com
      HCRaccountmanager37@adp.com

        Attachments

          Issue Links

            Activity

            Hide
            alexn Alex Nguyen added a comment -

            Thank you Revansiddha Gaur. I already did a quick audit and posted the 11/30 file to ADP server. They will sweep up the file and set to the side before loading on 2nd Tuesday of this month (12/12/17).

            Thank you,

            Alex

            Show
            alexn Alex Nguyen added a comment - Thank you Revansiddha Gaur . I already did a quick audit and posted the 11/30 file to ADP server. They will sweep up the file and set to the side before loading on 2nd Tuesday of this month (12/12/17). Thank you, Alex
            Hide
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment - - edited

            Hi Alex Nguyen ,

            We have exported the file for Employee and Non- Employee from main company . Testing is in progress at our end , if you want you can refer the latest file from view exported files .
            We will provide the file by tomorrow.

            Environment - Production

            Thanks,
            Kanchan Jalgaonkar.

            CC-Prajakta Belhe Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari

            Show
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment - - edited Hi Alex Nguyen , We have exported the file for Employee and Non- Employee from main company . Testing is in progress at our end , if you want you can refer the latest file from view exported files . We will provide the file by tomorrow. Environment - Production Thanks, Kanchan Jalgaonkar. CC- Prajakta Belhe Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari
            Hide
            Prajakta.belhe Prajakta Belhe (Inactive) added a comment -

            Hi Alex Nguyen,

            You can post the latest file from view exported files to ADP server.

            Thanks,
            Prajakta

            CC-Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari

            Show
            Prajakta.belhe Prajakta Belhe (Inactive) added a comment - Hi Alex Nguyen , You can post the latest file from view exported files to ADP server. Thanks, Prajakta CC-Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Alex Nguyen,

            As discussed with Amit, Can you please further process the files on weekly basis for "Metso ADP - ACA Employee", "Metso ADP - ACA Non Employee"?
            Steps:
            1. Select the target Template.
            2. From & To Date should be blank.
            3. Export.

            Thanks,
            Revan
            CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Smita Pawar, Sachin Hingole.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Alex Nguyen , As discussed with Amit, Can you please further process the files on weekly basis for "Metso ADP - ACA Employee", "Metso ADP - ACA Non Employee"? Steps: 1. Select the target Template. 2. From & To Date should be blank. 3. Export. Thanks, Revan CC- Amit Thorve , Nandkumar Prabhakar Karlekar , Smita Pawar , Sachin Hingole .
            Hide
            alexn Alex Nguyen added a comment -

            Thank you Prajakta Belhe and Revansiddha Gaur. I have posted today's file to ADP and informed them that we will stop sending files after 12/29/17. I will pull the files weekly according to your 3 steps. Thank you for all the support with the ACA files.

            Alex

            Show
            alexn Alex Nguyen added a comment - Thank you Prajakta Belhe and Revansiddha Gaur . I have posted today's file to ADP and informed them that we will stop sending files after 12/29/17. I will pull the files weekly according to your 3 steps. Thank you for all the support with the ACA files. Alex

              People

              Assignee:
              alexn Alex Nguyen
              Reporter:
              alexn Alex Nguyen
              Account Executive:
              Michelle Parker (Inactive)
              EDI Analyst 1:
              Alex Nguyen
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1,294h 35m
                  1,294h 35m