User Maintenance Employee Field

If I wanted to run a query to get the Employee tied to a SysUserFile record how can I get it?

Where in the database is this information?

Have you already tried UserComp.EmpID?
That is what shows up in !0.1.6… field help.

Hmmmn… I wonder if it’s really different/changed on later versions or just an issue with your field help ?


This is 10.2.600

That’s the table it looks like. Our Help pane is messed up somehow we’re on 10.2.700.
Thank you.

Thank you kindly Clint! This helped a lot.

We have the same help issue and are on 2024.1.14.
Our Pilot Instance is on 2024.2.7 and shows the same thing - no DB field value.

It does not show the DB field in either classic or kinetic.