Employee number.

Employee'sHome Company

Employee's last name.

Employee's first name.

Employee's middle name.

Reserved for future use.

The employee's Social Security number.

First line of the employee's address.

Second line of the employee's address.

Third line of the employee's address.

Employee's city.

Employee's state; populated from the CFGStates Table.

Employee's zip code.

Employee's country.

The employee's home telephone number.

The employee's fax number.

The employee's e-mail address.

The employee's Time Administration level.

Variable indicating whether the employee can edit the timesheets of other users in the same Time group.

The employee's Expense Administration level.

Variable indicating whether this employee can edit the expense reports of other employees in the same Expense group.

Memo field for comments on the employee.

This column is obsolete.

The prefix to use with this employee's name.

The suffix to use with this employee's name.

The employee's job title.

Reserved for future use.

The employee's work telephone number.

The employee's work telephone number extension.

The employee's cell phone number.

Variable indicating whether the record is available to CRM users. The default value is Yes.

Variable indicating whether the record is available to Accounting users.

The employee's preferred name, as entered on the general tab of the Employee Info Center.

The number format to use for the HomePhone value.

The number format to use for the Fax value.

The number format to use for the WorkPhone value.

The number format to use for the MobilePhone value.

For internal use.

The percentage of the employee's hours they are expected to charge to a project.

The employee's Utilization Ratio, as entered on the Accounting tab.

Variable indicating whether the employee is a consultant.

Flag indicating whether the Client/Vendor option is selected.

The internal identifier for the client selected.

If ConsultantInd in this table is Yes, the name of the vendor/consultant.

TalentUser ID

Location

The internal ID for TrafficLIVE.

The professional title added at the end of the employee's name.

The field that tracks changes to the mapped fields in Talent Management.

The username of the user creating this record.

The date and time when this record was created.

The username of the user logged in when this record was modified.

The date and time when this record was modified.