Portal Field Descriptions

The field that you are looking for is on the EMPLOYEE table and it's called FICA-NBR. Exists in DOCFLD

If you are looking for the actual text "Social Number", I beleive that comes from the 4GL code: HR11.scr

Last Name:[ ][ ][ ]; ;
| First Name:[ ]| Preferred Name:[ ]
| Middle Name:[ ]
| Name Title:[ ] ; ;

| Social Number:[ ]
| Status:[ ] ; ;
| Hire Date:& ]| Adjusted Hire:& ]
| Reported as New Hire:& ]
| Anniversary:& ]
| Seniority:& ] [ ]
| First Day Worked:& ]| Last Day Paid:&

What I am seeing is that not all field descriptions are in DOCFLD, for some reason. Using HR11.1 once again, if you sample some of those screen names, they don't all appear in that table, which is confusing to me.

I ran a query on GEN.DOCSCRFLD and was able to find the Social Number within the DOCFLDNAME field. The query I ran was as follows:

Select * from LAWGEN.DOCSCRFLD WHERE PRODUCTLINE= 'PROD' AND SYSTEMCODE= 'HR' AND PROGRAMCODE = 'HR11'

The value PROD is your application productline. This query should return all of the screen field names, and you can just search for Social Number. You could also add the DOCFLDNAME to your SQL statement where it is equal to social number, just remember it will be case sensitive and must contain the spaces, that is why it is easier just to pull back all of the fields.

Not really sure why you are running query on this table, if it is just to get the application table name-field name, you can find that out in portal by positioning your cursor on the desired field and then selection <control shift o> This should display the application table info of prefix-field name and it lists field number for that corresponds to field number in Excel Upload wizard.