Read Employee

ID

The ID of the employee.

Account

The account number for the employee's benefits provider.

Accrued Times

Accrual Method

The method by which the payroll item accrues.

ID

The ID of the accrual method.

Reference Name

Accrual Rate

The rate at which the payroll item accrues.

Accrued Hours

The total number of accrued hours.

Effective Date

The date on which this payroll item became effective.

Expiration Date

The date on which this payroll item is set to expire.

Is Inactive

Indicates whether the payroll item is active.

Max Accrued Hours

The maximum number of accrued hours.

Monetary Rate

The monetary rate that is used as a basis for this payroll item.

Pay Type

The payment type of the payroll item.

ID

Reference Name

Payroll Item

The payroll item associated with the employee record.

ID

Reference Name

External ID

The external ID of the payroll item.

ID

The ID of the accrued time.

Name

The name of the accrued time.

Reference Name

The display name of the accrued time.

Reset At Year End

Indicates whether the system should zero the total Accrued Hours and restart calculations each calendar year.

Addresses

Address

The address record for the employee.

Address 1

The first line of the address.

Address 2

The second line of the address.

Addressee

The addressee name for this address record.

Phone

The phone number of the addressee.

Text Address

The value of any included free-form address text.

Attention

The name of the person to whom any shipment is addressed, as it should appear on shipping labels.

City

The city for the address record.

Country ID

The country ID for the address.

Country Reference Name

The display name of the country for the address.

Has Custom Text Address

Identifies whether the free-form address text field contains a custom address.

State/Province

The state or province for the address record.

Zip Code

The ZIP code for the address record.

Text Address

The value of the free-form address text field.

Address ID

The ID of the address record, returned as a text string.

ID

The ID of the address record, returned as a number.

Is Default Billing

Identifies whether the address record is the default for billing purposes.

Is Default Shipping

Identifies whether the address record is the default for shipping purposes.

Internal ID

The internal ID of the address record.

Label

A label for the address record.

ADP ID

The ADP ID of the employee.

Alien Number

The alien number of the employee.

Expense Approval Limit

The maximum amount that the employee can approve for an expense report if they're specified as an approver for another employee.

Expense Approver

ID

The ID of the person that approves the employee's expense reports.

Reference Name

The name of the person that approves the employee's expense reports.

External ID

The external ID of the person that approves the employee's expense reports.

Authorized To Work Until

The last date that the employee is authorized to work.

Base Wage

The base wage of the employee.

Base Wage Type

ID

The ID of the employee's base wage type.

Reference Name

The display name of the employee's base wage type.

Billing Class

ID

The ID of the billing class used to determine the default pricing for the service item.

Reference Name

The display name of the billing class used to determine the default pricing for the service item.

External ID

The external ID of the billing class used to determine the default pricing for the service item.

Birth Date

The employee's birth date.

Bonus Target

The target bonus amount for the employee, as either a percentage of the employee's base wage or a specific amount.

Bonus Target Comments

An additional relevant information about the employee's bonus target.

Bonus Target Pay Frequency

ID

The ID to determine how often this bonus could be awarded to the employee.

Reference Name

The display name of the bonus target frequency.

Bonus Target Type

ID

The ID that represents the bonus award type.

Reference Name

The display name of the bonus award type.

Employee is Template

Defines whether the employee is a template record.

Campaigns Reference Name

The display name of the campaigns associated with the employee.

Change Reason Details

Any details that describe an effective-dated change.

Class

ID

The ID of the employee's class.

External ID

The external ID of the employee's class.

Reference Name

The display name of the employee's class.

Notes

Any comments included on the employee's record.

Is Concurrent Web Services User

Indicates whether the user is allowed concurrent web services access.

Currency

ID

The ID of the currency used for transactions with this employee.

Reference Name

The display name of the currency used for transactions with this employee.

External ID

The external ID of the currency used for transactions with this employee.

Available Currencies

ID

The ID of a currency available to the employee.

Reference Name

The display name of a currency available to the employee.

External ID

The external ID of a currency available to the employee.

Custom Form

ID

The ID of an existing custom form for this record type.

Reference Name

The display name of an existing custom form for this record type.

Date Created

The date and time when the employee record was created.

Default Address

The text format of the employee's address.

Default Billing Address

The default billing address of the employee.

Default Job Resource Role

External ID

The external ID of the employee's default job resource role.

ID

The ID of the employee's default job resource role.

Reference Name

The display name of the employee's default job resource role.

Default Shipping Address

The default shipping address of the employee.

Default Expense Report Currency

ID

The ID of the default currency for the employee's expense reports.

Reference Name

The display name of the default currency for the employee's expense reports.

External ID

The external ID of the default currency for the employee's expense reports.

Department

ID

The ID of the employee's department.

External ID

The external ID of the employee's department.

Reference Name

The display name of the employee's department.

Driver License Number

The number of the employee's driver license.

Email

The email of the employee.

Employee Status

External ID

The external ID of the employee's status.

ID

The ID of the employee's status.

Reference Name

The display name of the employee's status.

Employee Type

External ID

The external ID of the employee's type.

ID

The ID of the employee's type.

Reference Name

The display name of the employee's type.

Employee Permissions

Permission

The permission that is assigned to the employee.

Permission Level

The level of the permission assigned to the employee.

The display name of the permission level.

Enable Deduction Limits

Indicates whether the deduction credit memos and charge back invoices will be created.

Entity ID

Unique identifier for the employee record.

This is shown as the Employee ID in the NetSuite interface.

Ethnicity

External ID

The external ID of the employee's ethnicity.

ID

The ID of the employee's ethnicity.

Reference Name

The display name of the employee's ethnicity.

Expense Limit

The amount this employee can expense without approval from a supervisor or approver.

External ID

The external ID of the employee.

Fax

The fax number for the employee.

First Name

The first name of the employee.

Gender

ID

The ID of the employee's gender.

Reference Name

The display name of the employee's gender.

Has Login Access

Identifies whether the employee has access to NetSuite.

Global Subscription Status

ID

The ID of the subscription status for campaign messages.

Reference Name

The display name of the subscription status for campaign messages.

Hire Date

The date this employee was hired.

Home Phone

The home phone number of the employee.

Is I-9 Verified

Identifies whether the employee has completed an I-9 form.

Image

External ID

The external ID of the image file uploaded to the employee's account.

ID

The ID of the image file uploaded to the employee's account.

Reference Name

The display name of the image file uploaded to the employee's account.

Is Inherit IP Addresses from Company

Indicates whether to allow this employee NetSuite access at the IP addresses listed on the Company Information page.

Initials

The initials of the employee.

Extra Allowed IP Addresses

The IP addresses where this employee has access.

Is Inactive

Specifies whether the employee is inactive.

Is Job Manager

Indicates whether the employee is a project manager.

Is Project Resource

Indicates whether the employee is to be added as a resource on projects and tasks.

Is Sales Representative

Identifies whether the employee is a sales representative or not.

Is Support Representative

Identifies whether the employee is a support representative or not.

Job

External ID

The external ID of the project (or job) record associated with the employee.

ID

The ID of the project (or job) record associated with the employee.

Reference Name

The display name of the project (or job) record associated with the employee.

Job Description

The description of the duties this person currently performs.

Labor Cost

The employee's hourly overhead labor rate.

Last Modified Date

The date when the employee record was last changed.

Last Name

The last name of the employee.

Last Review Date

The date of the employee's last salary evaluation.

Location

ID

The ID of the employee's location.

External ID

The external ID of the employee's location.

Reference Name

The display name of the employee's location.

Marital Status

External ID

The external ID of the employee's marital status.

ID

The ID of the employee's marital status.

Reference Name

The display name of the employee's marital status.

Middle Name

The middle name of the employee.

Mobile Phone

The mobile phone number of the employee.

Next Review Date

The date of the employee's next salary evaluation.

Office Phone

The office phone number of the employee.

Passport Number

The passport number of the employee.

Phone

The phone number for the employee.

Purchase Approval Limit

The maximum amount that an employee is allowed to approve on a purchase request when specified as an approver for an employee.

Purchase Approver

ID

The ID of the person that approves the employee's purchase requests.

External ID

The external ID of the person that approves the employee's purchase requests.

Reference Name

The display name of the person that approves the employee's purchase requests.

Purchase Limit

The amount this employee can purchase without approval from a supervisor or approver.

Hourly Rate

The hourly cost rate, in dollars.

Reference Name

The display name of the employee record.

Termination Date

The employee's final date of employment.

Resident Status

External ID

The external ID of the employee's resident status.

ID

The ID of the employee's resident status.

Reference Name

The display name of the employee's resident status.

Roles

Center Type

The role's center type that determines how tasks are organized on tabs.

Device ID Only

Indicates whether to restrict users assigned to this role by a device ID.

ID

The ID of the role.

External ID

The external ID of the role.

Reference Name

The display name of the role.

SSO Only

Indicates whether to validate if the user signed in through an inbound single sign-on (SSO) mechanism.

Web Services Only

Indicates whether the programmatic access to NetSuite is enabled.

Mr/Ms

The employee's salutation, such as Mr. or Ms.

Social Security Number

The social security number of the employee, in the following format: 123-45-6789

Time-Off Calculations Start Date

The employee's start date, for time-off calculations.

Subscriptions

Last Modified

The date and time of the last change in the employee record.

Is Subscribed

Indicates whether the employee is subscribed to a subscription.

ID

The ID of the subscription.

External ID

The external ID of the subscription.

Reference Name

The display name of the subscription.

Subsidiary

ID

The ID of the employee's subsidiary.

Reference Name

The display name of the employee's subsidiary.

External ID

The external ID of the employee's subsidiary.

Supervisor

ID

The ID of the employee's supervisor.

Reference Name

The display name of the employee's supervisor.

External ID

The external ID of the employee's supervisor.

Target Utilization

The required utilization for this resource.

Is Terminated Due To Death

Indicates if the employee termination was due to death.

Termination Details

Other details regarding the employee's termination.

Time Approver

ID

The ID of the person who approves the employee's time transactions.

Reference Name

The display name of the person who approves the employee's time transactions.

External ID

The external ID of the person who approves the employee's time transactions.

Job Title

The employee's official job title.

Visa Expiration Date

The expiration date of the employee's visa.

Visa Type

ID

The ID of the employee's visa type.

Reference Name

The display name of the employee's visa type.

External ID

The external ID of the employee's visa type.

Was Inactive

Indicates whether the employee's record was marked as inactive.

Work Calendar

ID

The ID of the employee's work calendar.

Reference Name

The display name of the employee's work calendar.

External ID

The external ID of the employee's work calendar.