How can I see the list of fields stored in sys_user?

[scottn]

Hi everyone,

I have one catalog client script that works perfectly:

function onChange(control, oldValue, newValue, isLoading) {

var caller= g_form.getReference('Employee');

var gr = new GlideRecord('cmn_department');

gr.get(caller.department);

g_form.setValue('EmployeeOUC',gr.id);

}

I use this to grab the department of an employee.

Now I also want to grab the EmployeeID of the employee, but I'm not sure of the exact field name and I can't figure out how to look that up.

How do I view the field names in the sys_user table (which is where I assume the employee ID will be stored?)

Thanks for any help you can offer!

Scott

[scottn]

Yes, all employee data has been imported by campus administrators. I know the EmployeeID field is stored because on my record producer, when I select someone's name, it shows their EmployeeID off to the side. But I'm just not sure of what the field is called so I can reference it. I have a call in to our campus HelpDesk but I've noticed questions typically get answered on here much faster than from the HelpDesk.   🙂