How to look up field name from field number.

Janice

Basic Member

Posts: 7

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

Posts: 7

9/26/2014 1:59 AM

Does anybody know the answer to this?

Jeff Wardzala

Basic Member

Posts: 9

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

Posts: 1020

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.