Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

Status Name on PA02

Sort:
You are not authorized to post a reply.
Author
Messages
barb
Advanced Member
Posts: 33
Advanced Member
1/5/2009 8:02 PM

    I am doing a query for PA02 and need the status and status name or description.  I can get the status but I can't find where the description is located.  It is a lawson field.  Does anyone know how to retrieve it when doing a PA02 Query?

    Thanks,

    Barbara

    John Henley
    Posts: 3352
    1/5/2009 9:55 PM
      When you say "query" are you referring to the Excel Addins? Fields that have drop-down "value lists" show up twice in the addins, first for the field itself, and second for the description associated with the chosen value. So, assuming you are using to query wizard against PA02 forms, you will see that field (POS-POSIT-STATUS) listed twice--first for the code, and second for the description. I'm looking at one now, and _f17OS-POSIT-STATUS is '1' and _f18OS-POSIT-STATUS is 'Active'.
      Thanks for using the LawsonGuru.com forums!
      John
      Sam Simpson
      Veteran Member
      Posts: 239
      Veteran Member
      1/5/2009 10:33 PM
        Barb,
        Is this the one you're looking for?

        1=Active
        2=Temporary
        3=Frozen
        4=Proposed
        5=Inactive

        They are translate values which is coming from the PA02.scr file
        barb
        Advanced Member
        Posts: 33
        Advanced Member
        1/6/2009 6:29 PM

          I am in the query but it is for the table PAPOSITION.  I can upload for PA02 but the Query only shows the tables.  I am doing a query from PAPOSITION and the field numbers don't show on the query.

          see attachement.  Yes, what I am trying to get is the description for position status 1, 2, 3, 4, and 5.  Active, inactive, frozen, etc. 

          I am on office 2.0.5.0 and I notice the field numbers don't come down on the query anymore.  Is that for you as well.

           

          bzuber
          Advanced Member
          Posts: 33
          Advanced Member
          1/6/2009 6:32 PM
            I just attached an attachement but I don't see it in the messages, how do you open an attachment?
            John Henley
            Posts: 3352
            1/6/2009 7:30 PM
              Barb, I'm not sure why your attachment doesn't show up.

              When you query, you can either query against tables or against forms. Field numbers don't show when you query against tables--just when you query against forms.

              In cases where the drop-down "value lists" are hard-coded in the form (as is the case for this field/form), they are not stored anywhere in a table, just internally within the form. So if you want to include them in an Excel download, you would either have to:
              1) add them to a separate sheet in Excel and perhaps do a vlookup() against them, or
              2) query against the form instead of the table

              As Sam pointed out, you can look at the underlying form (PA02.scr) definition to find the lookup descriptions...
              Thanks for using the LawsonGuru.com forums!
              John
              bzuber
              Advanced Member
              Posts: 33
              Advanced Member
              1/6/2009 8:19 PM
                Thanks John and Sam,

                I never queried from forms before. I just looked at the first page of the query and saw you can choose either table or forms. Thanks for your help- found the field. THANKS!
                Pramod Chandra
                Basic Member
                Posts: 12
                Basic Member
                1/19/2009 6:46 AM
                  Put the Position Number and Hit Next
                  You are not authorized to post a reply.