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

ACA - 2017 : El Camino Hospital 1095C Reports

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Reported by:
      Support
    • Company:
      El Camino Hospital
    • Module:
      ACA - 2017

      Attachments

      1. Data Transformation.PNG
        Data Transformation.PNG
        18 kB
      2. ECH.jpg
        ECH.jpg
        171 kB
      3. Sample File -Part II.xls
        8 kB
      4. Sample File -Part III.xls
        10 kB
      5. screenshot-1.png
        screenshot-1.png
        129 kB
      6. screenshot-2.png
        screenshot-2.png
        59 kB

        Activity

        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        All - I'm getting a server error when trying to upload the changes for ECH.

        I'm sending the files to Nandu / Sachin and the password is ECHACA_5934

        Show
        jennifer.leugers Jennifer Leugers added a comment - All - I'm getting a server error when trying to upload the changes for ECH. I'm sending the files to Nandu / Sachin and the password is ECHACA_5934
        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

        Hi Jennifer Leugers,

        Part II correction file -

        XXX58470 - Employee SSN doesn't exist in the workterra system.

        All other employees provided were imported successfully for Part II file.

        Part III Correction file issues found were -

        1) The Employee SSN and the Member SSN / DOB doesn't match.
        For example -
        Employee SSN = XXXX97511 and its given Spouse SSN i.e Member SSN = XXXX55142 which doesn't match.

        Also if you are providing Correction for Employee then its Member SSN and Employee SSN must be same
        Ex -
        Employee SSN - 123456789
        MemberType - EE
        Member SSN - 123456789

        2) Some of the Employee SSN are blank, it is mandatory to provide employee SSN.

        Due to above issues, we were unable to import Part III Correction file.
        Please provide correct Part III Correction file, so that we can import it and run then 1095C on the main company

        Note - We tested this on HSPL company.

        CC Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar Revansiddha Gaur

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited Hi Jennifer Leugers , Part II correction file - XXX58470 - Employee SSN doesn't exist in the workterra system. All other employees provided were imported successfully for Part II file. Part III Correction file issues found were - 1) The Employee SSN and the Member SSN / DOB doesn't match. For example - Employee SSN = XXXX97511 and its given Spouse SSN i.e Member SSN = XXXX55142 which doesn't match. Also if you are providing Correction for Employee then its Member SSN and Employee SSN must be same Ex - Employee SSN - 123456789 MemberType - EE Member SSN - 123456789 2) Some of the Employee SSN are blank, it is mandatory to provide employee SSN. Due to above issues, we were unable to import Part III Correction file. Please provide correct Part III Correction file, so that we can import it and run then 1095C on the main company Note - We tested this on HSPL company. CC Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar Revansiddha Gaur
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - the Part II file can go ahead and be loaded into our Production site. We don't need Part III to be loaded for now. I attempted to load the Part II again today and was unsuccessful. So far we haven't been able to import any bulk correction files. Are we doing something wrong?

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - the Part II file can go ahead and be loaded into our Production site. We don't need Part III to be loaded for now. I attempted to load the Part II again today and was unsuccessful. So far we haven't been able to import any bulk correction files. Are we doing something wrong?
        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have imported the Part II correction file and re-run the 1095C. Please refer latest run (2/22/2017 9:56:09 PM)

        The reason why you were unable to import the correction file is -

        Part II Correction File -
        1) The file must be in the format same as attached file Sample File -Part II.xls

        Part III Correction File -

        1) The file must be in the format same as attached file Sample File -Part III.xls
        2) There was discrepany from our side that if the Correction is for Employee then its Member type in Template is set to Employee it should not be EE. Same for Spouse and child it should not be SP & CH, it should be Spouse and chlid
        We have updated the Specification template

        Note - Before importing the files it will be good if you verfiy this -

        1. Navigate to Template Management >> Import
        2. Select the template which you are importing
        3. Navigate to Data Transformation tab and select sub-template
        4. You will see Fields ex - Part 2 EIN,
        5. Click on Map field and make sure that EIN value which you are importing is same as the Map Data Column.
          For ex - If Map data for one EIN is 123456789 then value of EIN in file must be 123456789, either it will go into bad file.
          Same in-case of Part 3 Member Type Refer

        Let us know if you have any query on this.

        CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers , We have imported the Part II correction file and re-run the 1095C. Please refer latest run (2/22/2017 9:56:09 PM) The reason why you were unable to import the correction file is - Part II Correction File - 1) The file must be in the format same as attached file Sample File -Part II.xls Part III Correction File - 1) The file must be in the format same as attached file Sample File -Part III.xls 2) There was discrepany from our side that if the Correction is for Employee then its Member type in Template is set to Employee it should not be EE. Same for Spouse and child it should not be SP & CH, it should be Spouse and chlid We have updated the Specification template Note - Before importing the files it will be good if you verfiy this - Navigate to Template Management >> Import Select the template which you are importing Navigate to Data Transformation tab and select sub-template You will see Fields ex - Part 2 EIN, Click on Map field and make sure that EIN value which you are importing is same as the Map Data Column. For ex - If Map data for one EIN is 123456789 then value of EIN in file must be 123456789, either it will go into bad file. Same in-case of Part 3 Member Type Refer Let us know if you have any query on this. CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
        Hide
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

        Hello,
        Feel free to reopen in case any further action required on this. Thank you.

        Show
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hello, Feel free to reopen in case any further action required on this. Thank you.

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          ramya.tantry Ramya Tantry (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          7 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Production Due Date:

              Time Tracking

              Estimated:
              Original Estimate - 4h Original Estimate - 4h
              4h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 26.75h
              26.75h