How to look up field name from field number.

Prev Go to previous topic

Go to next topic

Last Post 10/09/2015 3:52 PM by Kat V

3 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Janice
developer
Private

(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

(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

(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

(2285 points)
Veteran Member
Posts:779

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.