WORKTERRAProject Type: software

WORKTERRA

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

Marquette 1094C

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Submission
    • Reported by:
      Support
    • Module:
      ACA
    • Issue Importance:
      Must Have

      Description

      Hi all -

      How is the 95% for line 23 calculated?

      For example, if I look at the Offshore 1095Cs, in the month of November I show six out of 115 employees with a 1H and either a 2B or 2D in line 16.

      I thought we didn't include 2B since they are not a full time employee so now I'm down to only four employees out of 115 which is less than 5%.

      January for the same group has 21 with the same scenarios yet #23 is checked yes or January.

      So I'm confused as to why they are checked as No for November.

      Could you please advise what is and what isn't counted?

      The client is questioning their Gulf population as well so need to be able to explain why they are Nos as well.

      Thanks,
      Jen

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          jennifer.leugers Jennifer Leugers added a comment -

          I'm having the same questions from US Shale as well so if you could tell me how to first get the numbers that are in (b) and (c) and then also what to choose when calculating the 95% per month (i.e. only 1H / 2D or whatever), I can do the calculations and provide them to the clients going forward.

          Show
          jennifer.leugers Jennifer Leugers added a comment - I'm having the same questions from US Shale as well so if you could tell me how to first get the numbers that are in (b) and (c) and then also what to choose when calculating the 95% per month (i.e. only 1H / 2D or whatever), I can do the calculations and provide them to the clients going forward.
          Hide
          Permalink
          satyap Satya added a comment -

          Vijay Siddhashyam sharmaRakesh RoyNandkumar Prabhakar Karlekar

          Show
          satyap Satya added a comment - Vijay Siddha shyam sharma Rakesh Roy Nandkumar Prabhakar Karlekar
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar Ramya Tantry shyam sharma Rakesh Roy

          Hi Jennifer Leugers,

          The counts for Part III column b and c can be calculated as explained below.
          Download data analysis report for Offshore 1095C report, apply filter for required month (in this case for November month)

          Part III column c
          Then apply filter on "Is Employed for whole Month" = YES, This will give the "(c) Total Employee Count for ALE Member" column. (Column c count for Offshore is 74)

          Part III Column b
          Now don't remove above two filters (Filter applied on month and for Is Employed for whole Month), and apply filter on "Line 16 Code not equal to 2D", This will give the "(b) Full-Time Employee Count for ALE Member". (column b count for offshore is 73)

          % Calculation for marking MEC
          Don't remove above applied filters, and apply filter on "Line 14 Code = 1A Or 1E Or 1C",
          It will give count of employees getting offer. (total employee getting offer are 69)

          Now % calculation will be as below

          Percentage = (% Calculation for marking MEC * 100)/Part III Column b
          Percentage = 69*100/73
          Percentage = 94.52

          Thanks,
          Sachin Hingole

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Nandkumar Prabhakar Karlekar Ramya Tantry shyam sharma Rakesh Roy Hi Jennifer Leugers , The counts for Part III column b and c can be calculated as explained below. Download data analysis report for Offshore 1095C report, apply filter for required month (in this case for November month) Part III column c Then apply filter on "Is Employed for whole Month" = YES, This will give the "(c) Total Employee Count for ALE Member" column. (Column c count for Offshore is 74) Part III Column b Now don't remove above two filters (Filter applied on month and for Is Employed for whole Month), and apply filter on "Line 16 Code not equal to 2D", This will give the "(b) Full-Time Employee Count for ALE Member". (column b count for offshore is 73) % Calculation for marking MEC Don't remove above applied filters, and apply filter on "Line 14 Code = 1A Or 1E Or 1C", It will give count of employees getting offer. (total employee getting offer are 69) Now % calculation will be as below Percentage = (% Calculation for marking MEC * 100)/Part III Column b Percentage = 69*100/73 Percentage = 94.52 Thanks, Sachin Hingole
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Jennifer Leugers

          We have completed the " 1094 C Marquette Transportation Co LLC – OFFSHORE" Part III issue. Please verify.
          Currently working on the "1094 C Marquette Transportation Co LLC – GULF"

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Jennifer Leugers We have completed the " 1094 C Marquette Transportation Co LLC – OFFSHORE" Part III issue. Please verify. Currently working on the "1094 C Marquette Transportation Co LLC – GULF"
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          We have done the data corrections for Marquette (JIRA ID is WT-3195).
          Please let us know if you need any action on this JIRA from our side.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - We have done the data corrections for Marquette (JIRA ID is WT-3195 ). Please let us know if you need any action on this JIRA from our side.
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Jennifer Leugers

          FYI Nandkumar Prabhakar Karlekar,Sachin Hingole

          This company had most of the corrections related to line 16 code to force code 2B.This caused the employee count to change and so MEC indicator was coming up as no.
          We have made changes to ignore 2B code in calculating Employee count.Now for all 12 months MEC indicator is coming up as Yes for all 3 1094C reports.
          Please download latest run (06/28/2016) and verify.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Jennifer Leugers FYI Nandkumar Prabhakar Karlekar , Sachin Hingole This company had most of the corrections related to line 16 code to force code 2B.This caused the employee count to change and so MEC indicator was coming up as no. We have made changes to ignore 2B code in calculating Employee count.Now for all 12 months MEC indicator is coming up as Yes for all 3 1094C reports. Please download latest run (06/28/2016) and verify.

            People

            Assignee:
            jennifer.leugers Jennifer Leugers
            Reporter:
            jennifer.leugers Jennifer Leugers
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: