Prev
Next
Forums Integration / Customization IPA/ProcessFlow

BN32 update specific line?

 8 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Lance Jurgensen
Advanced Member
Posts: 36
Advanced Member
11/5/2018 3:15 PM

    I am trying to update BN32.1 lines but it always wants to update line 1. The query brings back the DC plans that do not have a stop date for terminated employees. Is there a way to determine what line a record is on?  In my example I have Benefit Type = DC and in the form the inquire brings back 3 lines, a DC04, DC02 and a DC05.

    My transaction string is as follows and I'm guessing I need to do something on the highlighted entry below?

    _PDL=&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=&BEN-EMPLOYEE=&LINE-FCr0=&BEN-STOP-DATEr0=&BEN-PLAN-CODE=&BEN-START-DATE=&_DELIM=%09&_OUT=XML&_EOT=TRUE

    We are on IPA 10.1

    Thanks, 

    -Lance

    Lance Jurgensen
    Advanced Member
    Posts: 36
    Advanced Member
    11/5/2018 3:39 PM
      I see the variables where stripped, this is more like what I currently have:
      _PDL=HRDEV&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=15&BEN-EMPLOYEE=123456&LINE-FCr0=S&BEN-STOP-DATEr0=20181031&BEN-PLAN-CODE=DC02&BEN-START-DATE=20180101&_DELIM=%09&_OUT=XML&_EOT=TRUE
      Ragu Raghavan
      Veteran Member
      Posts: 475
      Veteran Member
      11/5/2018 3:48 PM
        There are hidden fields PT-COMPANY, PT-EMPLOYEE etc. that the logic uses to position the records. Maybe you can use those, so the first line will be the record you want to update?
        Lance Jurgensen
        Advanced Member
        Posts: 36
        Advanced Member
        11/5/2018 4:10 PM
          I believe they are COMPANY, EMPLOYEE and START-DATE but that does not help in my case when 2 of the 3 plans have the same start date...
          Bob Canham
          Veteran Member
          Posts: 217
          Veteran Member
          11/5/2018 4:16 PM
            I stay away from BN32 for changes since it doesn't have a position-to field. Instead, I use BS32 for doing stops and BN31.1 for adding new records.
            Lance Jurgensen
            Advanced Member
            Posts: 36
            Advanced Member
            11/5/2018 4:31 PM
              I will take a look at BS32, thanks!
              Lance Jurgensen
              Advanced Member
              Posts: 36
              Advanced Member
              11/5/2018 4:39 PM
                Would you happen to have an example of a BS32.1 stop transaction string? Wondering how to find/use the position-to?
                Bob Canham
                Veteran Member
                Posts: 217
                Veteran Member
                11/5/2018 4:44 PM
                  Here is my BS32.1 update. You don't need a position to on that form as it doesn't come pre-populated, so you just fill in record 0. 

                  

                  _PDL=PROD&_TKN=BS32.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&BEN-COMPANY=1&BEN-EMPLOYEE=EMPLOYEE&LINE-FCr0=S&BEN-PLAN-TYPEr0=DC&BEN-PLAN-CODEr0=PlanCode&BEN-START-DATEr0=20180101&BEN-STOP-DATEr0=20181105&_DELIM=%09&_OUT=XML&_EOT=TRUE
                  Lance Jurgensen
                  Advanced Member
                  Posts: 36
                  Advanced Member
                  11/5/2018 8:31 PM
                    Thank you for the push in the right direction, using BS32 is exactly what I needed. Working great and scheduled to run.