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

Export > City of Claremont-Sunlife 834 Enrollment and Demographic change type

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 1.0
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Support
    • Company:
      City of Claremont
    • Item State:
      Production Complete
    • Sprint:
      WT Sprint 1

      Description

      City of Claremont-Sunlife 834 Enrollment and Demographic change type.

      This enhancement is related to EDI-22

      After moving to change file testing, the only remaining issue we have is INS03 and INS04. They want a code based on the type of change. Please see below.
      This is absolute requirement for Sun Life and we cannot pass testing without coding for this. How quickly can this achieved?
      I have a call on Friday, 4/1 with the Broker and Carrier and need to have some indication of what how long this will take.
      INS04:
      INS04 maintenance code '25' should ONLY be used for a member SSN change.
      You are sending member change INS03 ='001' with an INS04 value '25'.
      For member demographic change, NON SSN, INS03 = '001' please use INS04 = '33'.
      If INS04 = '25' is received for an existing client the transactions reject because we are trying to update an existing SSN with the same SSN.
      General Guidelines:
      Initial Enrollment - INS03 = '021'
      USE: INS04 ='28' (initial enrollment)
      Termination - INS03 = '024'
      USE INS04 = '07' (benefit termination) or '08' (EE termination)
      SSN Change - INS03 = '001'
      USE: INS04 ='25'
      Any Other Demographic Change: Address, Salary, Name etc. - INS03 = '001'
      Use: INS04 = '33'
      Rehire - INS03 = '021'
      USE: INS04 = '41' (re-enrollment)
      Unknown/Unidentified Change: INS03 ='001'
      Use: INS04 = 'AI'
      Thanks,
      Chris

        Attachments

        1. 426201695307AM_1601_2.txt
          3 kB
        2. INS 03.JPG
          INS 03.JPG
          46 kB
        3. New field DTS.JPG
          New field DTS.JPG
          47 kB

          Activity

          aniruddha.dev Aniruddha Dev (Inactive) created issue -
          rakeshr Rakesh Roy (Inactive) made changes -
          Field Original Value New Value
          Account Executive Kiyo Takahashi [ ktak ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Developer Ganesh Sadawarte [ ganesh.sadawarte ]
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Dev Due Date 22/Apr/2016
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Dev Estimates 80
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Stage Due Date 27/Apr/16 [ 2016-04-27 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Production Due Date 03/May/2016
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Description City of Claremont-Sunlife 834 Enrollment and Demographic change type.

          This enhancement is related to EDI-22
          City of Claremont-Sunlife 834 Enrollment and Demographic change type.

          This enhancement is related to EDI-22

          After moving to change file testing, the only remaining issue we have is INS03 and INS04. They want a code based on the type of change. Please see below.
          This is absolute requirement for Sun Life and we cannot pass testing without coding for this. How quickly can this achieved?
          I have a call on Friday, 4/1 with the Broker and Carrier and need to have some indication of what how long this will take.
          INS04:
          INS04 maintenance code '25' should ONLY be used for a member SSN change.
          You are sending member change INS03 ='001' with an INS04 value '25'.
          For member demographic change, NON SSN, INS03 = '001' please use INS04 = '33'.
          If INS04 = '25' is received for an existing client the transactions reject because we are trying to update an existing SSN with the same SSN.
          General Guidelines:
          Initial Enrollment - INS03 = '021'
          USE: INS04 ='28' (initial enrollment)
          Termination - INS03 = '024'
          USE INS04 = '07' (benefit termination) or '08' (EE termination)
          SSN Change - INS03 = '001'
          USE: INS04 ='25'
          Any Other Demographic Change: Address, Salary, Name etc. - INS03 = '001'
          Use: INS04 = '33'
          Rehire - INS03 = '021'
          USE: INS04 = '41' (re-enrollment)
          Unknown/Unidentified Change: INS03 ='001'
          Use: INS04 = 'AI'
          Thanks,
          Chris
          satyap Satya made changes -
          Fix Version/s 1.0 [ 10000 ]
          satyap Satya made changes -
          Sprint WT Sprint 1 [ 6 ]
          satyap Satya made changes -
          Rank Ranked higher
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Aniruddha Dev [ aniruddha.dev ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment 426201695307AM_1601_2.txt [ 16221 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment New field DTS.JPG [ 16491 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Aniruddha Dev [ aniruddha.dev ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment INS 03.JPG [ 17010 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Kiyo Takahashi [ ktak ]
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
          Chris.ellenberger Chris Ellenberger made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]

            People

            Assignee:
            ktak Kiyo Takahashi
            Reporter:
            aniruddha.dev Aniruddha Dev (Inactive)
            Account Executive:
            Kiyo Takahashi
            Developer:
            Ganesh Sadawarte (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

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