Prev
Next
Forums Integration / Customization S3 Customization/Development

How to look up field name from field number.

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Janice
Basic Member Send Private Message
Posts: 7
Basic Member
9/13/2014 1:50 AM
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
Basic Member Send Private Message
Posts: 7
Basic Member
9/26/2014 1:59 AM
Does anybody know the answer to this?
Jeff Wardzala
Basic Member Send Private Message
Posts: 9
Basic Member
9/25/2015 1:55 PM
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
Veteran Member Send Private Message
Posts: 1020
Veteran Member
10/9/2015 7: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.