Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

How to look up field name from field number.

3 Replies

0 Subscribed to this topic

19 Subscribed to this forum

Sort:

Author

Messages

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

New Poster

Engaged Reader

Avid Reader

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.