Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Portal Field Descriptions

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Layne
Basic Member
Posts: 24
Basic Member
1/31/2012 2:29 PM
    In the Portal on say Screen HR11.1, there is a field desciption called "Social Number." Does anyone know where this field description can be found in the GEN database. I was looking at Docfld and DocScrFld, but they do not seem to contain of them.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    1/31/2012 2:58 PM
      The field that you are looking for is on the EMPLOYEE table and it's called FICA-NBR. Exists in DOCFLD
      Ragu Raghavan
      Veteran Member
      Posts: 476
      Veteran Member
      1/31/2012 3:06 PM
        If you are looking for the actual text "Social Number", I beleive that comes from the 4GL code: HR11.scr

        Last Name:[ ][ ][ ]; ;
        | First Name:[ ]| Preferred Name:[ ]
        | Middle Name:[ ]
        | Name Title:[ ] ; ;

        | Social Number:[ ]
        | Status:[ ] ; ;
        | Hire Date:& ]| Adjusted Hire:& ]
        | Reported as New Hire:& ]
        | Anniversary:& ]
        | Seniority:& ] [ ]
        | First Day Worked:& ]| Last Day Paid:&
        Layne
        Basic Member
        Posts: 24
        Basic Member
        1/31/2012 3:14 PM
          What I am seeing is that not all field descriptions are in DOCFLD, for some reason. Using HR11.1 once again, if you sample some of those screen names, they don't all appear in that table, which is confusing to me.
          Jim Van Zummeren
          New Member
          Posts: 2
          New Member
          2/1/2012 1:03 PM
            I ran a query on GEN.DOCSCRFLD and was able to find the Social Number within the DOCFLDNAME field. The query I ran was as follows:

            Select * from LAWGEN.DOCSCRFLD WHERE PRODUCTLINE= 'PROD' AND SYSTEMCODE= 'HR' AND PROGRAMCODE = 'HR11'

            The value PROD is your application productline. This query should return all of the screen field names, and you can just search for Social Number. You could also add the DOCFLDNAME to your SQL statement where it is equal to social number, just remember it will be case sensitive and must contain the spaces, that is why it is easier just to pull back all of the fields.

            Not really sure why you are running query on this table, if it is just to get the application table name-field name, you can find that out in portal by positioning your cursor on the desired field and then selection This should display the application table info of prefix-field name and it lists field number for that corresponds to field number in Excel Upload wizard.