accountId

EMPLID 

Required. 

ACTION

ACTION 

An action code of up to 3 characters 

ACTION_REASON

ACTION_REASON 

A reason code of up to 3 characters 

AUDIT_ACTN

AUDIT_ACTN 

The type of action the system audited (A=add, C=change, D=delete). 

AUDIT_OPRID

AUDIT_OPRID 

The operator who caused the system to trigger the audit. 

AUDIT_STAMP

AUDIT_STAMP 

Date and time stamp 

AUDIT_RECNAME

AUDIT_RECNAME 

The name of the record the system audited. 

EFFSEQ

EFFSEQ 

Effective sequence 

EFFDT

EFFDT 

Effective date 

Employee ID

EMPL_ID 

The key field used to uniquely identify users. 

fullname

NAME 

The user’s full name. 

firstname

FIRST_NAME 

The user’s first name. 

lastname

LAST_NAME 

The user’s last name. 

Middle Name

MIDDLE_NAME 

The user’s middle name 

PS_PER_STATUS

PER_STATUS 

Personnel status, such as employee or non-employee. 

PS_EMPL_STATUS (Status on the AS adapter)

EMPL_STATUS 

The status of the employee, such as Active, Suspended, or Terminated. 

Home Address

ADDRESS1 

The user’s home address 

Department

DEPTID 

The user’s department 

Manager

REPORTS_TO 

The user’s manager 

Job Title

JOBCODE 

A code that identifies the user’s job title. 

Initials

NAME_INITIALS 

The user’s initials 

Country

COUNTRY 

3-letter country code 

Company

COMPANY 

Company name 

Home Phone

PHONE 

The user’s home phone number 

Home City

CITY 

The city in which the user resides 

Home State

STATE 

The state in which the user resides 

Home Zip

POSTAL 

The user’s home Zip or postal code.