PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/09/2015 3:52 PM by  Kat V
How to look up field name from field number.
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Janice
developer
Private
Basic Member
(11 points)
Basic Member
Posts:7


Send Message:

--
09/12/2014 9:50 PM
    I'm looking for the table (if one exists) that I can use to look up the field name by the field number of the Personnel Action.  I know table DBHRPAD (PADICT) contains the field number and item name which is the description of the field, but it doesn't have the actual name of the field. 

    For example, if I look up field number 2 in DBHRPAD, the item name is "Name - Last".  But I need the actual name of the field "DEMPLSTNM", not the description of the field. Is there a table that exists where I can query this information?

    We're on an old application version, 8.0.3.
    Janice
    developer
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:7


    Send Message:

    --
    09/25/2014 9:59 PM
    Does anybody know the answer to this?
    Jeff Wardzala
    Consultant
    Self Employed
    Basic Member
    (27 points)
    Basic Member
    Posts:9


    Send Message:

    --
    09/25/2015 9:55 AM
    Unfortunately, they are not in a table that I know of. They are stored in working storage libraries.
    The HR fields are in $LAWDIR\productline\hrsrc\hrwslib\HREMPWS

    They are under the sub-heading HREMPWS-GROUP-C. The fields with the name *-DN are defined with a value and that value is the FLD-NBR. Those working storage field names without the -DN correspond to their actual name on the database table.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2154 points)
    Veteran Member
    Posts:734


    Send Message:

    --
    10/09/2015 3:52 PM
    Ctrl+Shift+o should still work in 8.03. In Portal, position to the field and use the key stroke. Table abbreviation and field name should be in the status bar.
    You are not authorized to post a reply.