Employee

Internal ID: employee

Supports Custom Fields

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountnumber	text	true	Account	false	If you, your payroll service, or other benefits provider assigns account numbers to your employees, enter that account number here. This field is required for the Online Bill Pay feature.
aliennumber	text	true	Alien Number	false	Enter the employee's alien number. This is required only if the employee's work status is Alien authorized to work. The alien number is located in Section 1 of the completed I-9 form.
approvallimit	currency	true	Expense Approval Limit	false	In the Expense Approval Limit field, enter the maximum amount this employee is allowed to approve on an expense report when specified as an approver for another employee. Expenses that exceed this amount must be approved by another supervisor or approver with a sufficient approval limit.
approver	select	true	Expense Approver	false	In the Expense Approver field, select the person that approves the employee’s expense reports. If no approver is selected, the employee's supervisor approves expense reports. If an expense approver is selected, the supervisor is no longer part of the approval hierarchy.
authworkdate	date	true	Authorized to work until	false	Enter the date through which the employee is authorized to work until. This is required only if the employee's work status is Alien authorized to work. This date is located in Section 1 of the completed I-9 form.
autoname	checkbox	false	Auto	false	Clear this box to manually enter an ID for this record. If you leave this box checked, NetSuite assigns an ID for this record based on your settings at Setup > Company > Auto-Generated Numbers.
billingclass	select	true	Billing Class	false	Select a billing class to associate with this employee. The billing class you choose determines default pricing when you enter billable time and select a service item associated with this billing class. For information on existing billing classes or to create a new one, go to <_TABNAME=EDIT_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=EDIT_ACCOUNTINGOTHERLIST_> > Accounting Lists.
billpay	checkbox	false	Enable Online Bill Pay	false	Check this box in order to send this employee payments online. You cannot use this feature for paychecks. You must follow the set up procedures at <_TABNAME=ADMI_XML_PAYTRUST_SETUP_> > <_TASKCATEGORY=ADMI_XML_PAYTRUST_SETUP_> > Online Bill Pay before you can use this feature.
birthdate	date	true	Birth Date	false	Enter the employee's date of birth. You can type or pick another date.
btemplate	text	false	Employee is Template	false
class	select	true	Class	false	If you wish, select the class that applies to this employee. Click —New— to set up a new class.
comments	textarea	true	Notes	false	Enter other information you want to track for this employee.
commissionpaymentpreference	select	false	Pay Commissions Using	false	Select in the dropdown whether the payor for this employee's commissions always should be Payroll, always should be Accounts Payable, or should vary according to preferences set in the NetSuite system.
currency	select	false	Currency	false	The currency for an employee automatically defaults to the base currency of the associated subsidiary or company. This currency must be used for transactions with this employee.
customform	select	false	Custom Form	true	If you use a custom form for employee records, select the name of the form here. To create a custom form for employee records, click Customize Form. You can add or take away fields and change field names when you customize forms.
datecreated	datetime	false	Date Created	false
defaultacctcorpcardexp	select	false	Default Account for Corporate Card Expenses	false	Select the default credit card account to use for corporate card expenses on expense reports.
defaultaddress	address	false	Address	false	This field displays in text format the employee's address, as entered in fields on the Address subtab.
defaultexpensereportcurrency	select	false	Default Currency for Expense Reports	true	Select the default currency for this employee’s expense reports.
department	select	true	Department	false	If you like, select a department. Click New to enter a new department.
directdeposit	checkbox	false	Use Direct Deposit	false	Check this box to use Direct Deposit for transferring funds to an employee's bank account. Direct Deposit transactions take place over the Internet and in real time. These transactions have immediate accounting impact on your books. Payments you transmit are withdrawn from your company's bank account.
eligibleforcommission	checkbox	false	Eligible for Commission	false	Check the box to indicate this employee can be paid commission.
email	email	false	Email	false	Enter your employee's email address. If you allow your employees to track time or enter expense reports online, this will become part of their access codes.
empcenterqty	text	false	EmpCenter current	false
empcenterqtymax	text	false	EmpCenter max	false
employeestatus	select	true	Employee Status	false	Select an employee status. You can create a new employee status at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
employeetype	select	true	Type	false	Choose the type of employee for tax reporting purposes.
entityid	text	true	Employee ID	true	If the Auto box is not checked, manually enter an ID for this record. If the Auto box is checked, NetSuite assigns an ID for this record based on your settings at <_TABNAME=ADMI_NUMBERING_> > <_TASKCATEGORY=ADMI_NUMBERING_> > Auto-Generated Numbers.
ethnicity	select	true	Ethnicity	false	Select the employee's ethnicity. You can create a new ethnicity category at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
expenselimit	currency	true	Expense Limit	false	In the Expense Limit field, enter the amount this employee can expense without approval from a supervisor or approver.
externalid	text	false	ExternalId	false
fax	phone	true	Fax	false	Enter a fax number for this record. You should enter the fax number exactly as it must be dialed. If a '1' is required to fax to this number, be sure to include it at the beginning of the number. The number you enter here automatically appears in the To Be Faxed field of transactions when you select this customer. To fax NetSuite forms, an administrator must first set up fax service at <_TABNAME=ADMI_PRINTING_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax & Email Preferences.
firstname	text	true	Name	false	Enter the employee's first name here. What you enter here automatically appears first in the Employee field. The first letter of what you enter here appears in the Initials field. This field is required for the Online Bill Pay feature.
fulluserqty	text	false	FullUser current	false
fulluserqtymax	text	false	FullUser max	false
gender	select	true	Gender	false	Select the employee's gender.
giveaccess	checkbox	false	Give Access	false	Check this box to give your employee access to NetSuite. Then, assign a role to customize the level of access. You can assign multiple roles. To let your employee track time and enter expense reports, select the Employee Center role.
globalsubscriptionstatus	select	false	Global Subscription Status	false	Email recipients can have one of four subscription statuses: * Confirmed Opt-In - When an email recipient has indicated that they want to receive your campaign messages, they are assigned this subscription status. Only a recipient can set his or her subscription status to Confirmed Opt-In. * Soft Opt-In - Recipients with this status can receive opt-in messages that enable them to confirm whether or not they want to receive your email campaigns as well as email marketing campaigns. You can set a recipient’s status to Soft Opt-In manually or through a mass update. * Soft Opt-Out - Recipients with this status cannot receive campaign email messages but can receive opt-in messages. You can change this subscription status to Soft Opt-In manually or through a mass update. * Confirmed Opt-Out - Only the recipient can set their subscription status to Confirmed Opt-Out. Recipients with this status cannot receive email campaigns or opt-in messages. Recipients with this status can only opt in again through the Employee Center or by clicking the link in a campaign message they have received prior to opting out.
hasofflineaccess	checkbox	false	Offline Client Access	false	Check this box to give this employee the ability to download the Offline Client for NetSuite. Employees must have a sales role in order to have access to the Offline Client. Default sales roles include Sales Person, Sales Manager and Sales Administrator. Custom roles must have the Sales Role box checked on the role record. An employee with access to the Offline Client can go to <_TABNAME=TRAN_USERPREFS_> > <_TASKCATEGORY=TRAN_USERPREFS_> > Set Preferences to download the client to a laptop or other wireless device.
hiredate	date	true	Hire Date	true	Enter the date this employee was hired. You can type or pick another date.
homephone	phone	true	Home Phone	false	Enter this employee's home phone number here.
i9verified	checkbox	true	I-9 Verified	false	Check this box if the employee has completed an I-9 form.
image	select	false	Image	false	Select an image from your file cabinet to attach to this employee record. Select -New- to upload a new image from your hard drive to your file cabinet in a new window.
inheritiprules	checkbox	false	Inherit IP Rules from Company	true	Check this box to allow this employee NetSuite login access at the IP addresses listed at Setup > Company Information. If you check this box, this employee has access to NetSuite at every company computer with access unless you specify IP address(es) in the IP Address Restriction field. If you do not check this box, you must enter an IP Address where this employee can log in in the field below, or this employee will not be able to log in to NetSuite.
initials	text	false	Initials	false	NetSuite automatically completes this field as you enter first, middle and last names. If you want to make changes to an employee's initials, enter up to three letters in this field.
ipaddressrule	textarea	false	IP Address Restriction	true	Enter the IP address(es) where you want this employee to have access in the following formats: 1. A dotted decimal IP address such as 123.456.78.90 2. A range of IP addresses entered in dotted decimal with a dash and no spaces between such as 123.45.567.8-123.45.568.9 3. A list of IP address separated by spaces or commas such as 123.456.78.90, 123.546.768.97, . . . 4. An IP address and mask, such as 209.209.48.32/255.255.0.0. 5. The text "ALL" -- allows all IP addresses You can enter up to 1024 characters. If you do not enter an IP Address here, you must check the Inherit IP Rules from Company box, or this employee will no longer be able to log in to NetSuite.
isempcenterqtyenforced	text	false	EmpCenter enforce	false
isfulluserqtyenforced	text	false	FullUser enforce	false
isinactive	checkbox	true	Inactive	false	Check this box to inactivate this employee record. Inactivated records no longer appear in lists or as choices anywhere in your account. To view inactivated employee records or reactivate them, go to <_TABNAME=LIST_EMPLOYEE_> > <_TASKCATEGORY=LIST_EMPLOYEE_> > Employees, and check the Show Inactives box.
isjobresource	checkbox	true	Project Resource	false	Check this box to enable this employee to be added as a resource on projects and tasks.
isretailuserqtyenforced	text	false	RetailUser enforce	false
issalesrep	checkbox	true	Sales Rep	false	Check this box to mark this employee as a sales representative. Sales representatives are listed in the sales rep dropdown list for sales order forms and for sales territory assignments.
issupportrep	checkbox	true	Support Rep	false	Check this box to mark this employee as a support representative. Support representatives are listed in the assigned to dropdown list for case forms and in the support rep dropdown list for support territory assignments.
job	select	false	Job	false	Select a job to assign to this employee.
jobdescription	textarea	false	Job Description	false	Enter a description of the duties related to the job this person currently performs.
jurisdiction1display	text	false	Federal:	false
jurisdiction2display	text	false	State:	false
jurisdiction3display	text	false	County:	false
jurisdiction4display	text	false	Local:	false
jurisdiction5display	text	false	School District:	false
laborcost	currency	true	Labor Cost	false	Enter the employee's hourly overhead labor rate. This rate is used to calculate the estimated cost of jobs this employee works on.
lastmodifieddate	datetime	false	Last Modified Date	false
lastname	text	true		false	Enter the employee's last name here. What you enter here automatically appears last in the Employee field. The first letter of what you enter here appears in the Initials field. This field is required for the Online Bill Pay feature.
lastpaiddate	date	true	Last Paid Date	false	Enter the last paid date for this employee. The last paid date is the date of the actual pay run which usually take place before the checks are issued. For example, the date on your most recent paycheck is October 13. This check includes payment for hours worked September 24 - October 7. The pay run is processed on October 7 but the check is issued on October 13. However, since the last paid date is the date of the pay run, you shoud enter October 7 as the last paid date. Note: You only have to enter this date once for each employee. This field is auto-updated with the most recent last paid date each time you run payroll.
lastreviewdate	date	true	Last Review Date	false	Enter the date of this person's last salary evaluation. You can type or pick another date.
location	select	true	Location	false	Select the location where this employee works. Note: If you use the Payroll feature, you must select a location for each employee you wish to pay using NetSuite Payroll. If the employee’s location is not listed, you must create a new staffed location. Create new locations to select here by selecting –New–.
maritalstatus	select	true	Marital Status	false	Select the employee's marital status. You can create a new marital status at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
middlename	text	true		false	Enter a middle name or initial here. What you enter here automatically appears second in the Employee field. The first letter of what you enter here appears in the Initials field. Enter up to 25 characters in this field.
mobilephone	phone	true	Mobile Phone	false	Enter this employee's mobile or cell phone number here.
nextreviewdate	date	true	Next Review Date	false	Enter the date of this person's next salary evaluation. You can type or pick another date.
officephone	phone	false	Office Phone	false	Enter this employee's office phone number here.
payfrequency	select	true	Pay Frequency	true	Select the pattern of frequency for paying this employee.
phone	phone	true	Phone	false	Enter a phone number for your employee. This field is required for Online Bill Pay enabled employees.
phoneticname	text	false	Furigana	false	Enter the furigana character you want to use to sort this record.
purchaseorderapprovallimit	currency	true	Purchase Approval Limit	false	In the Purchase Approval Limit field, enter the maximum amount an employee is allowed to approve on a purchase request when specified as an approver for an employee.
purchaseorderapprover	select	true	Purchase Approver	false	In the Purchase Approver field, select the person that approves the employee’s purchase requests. If no approver is selected, the supervisor approves purchase requests. If a purchase approver is selected, the supervisor is no longer part of the approval hierarchy.
purchaseorderlimit	currency	true	Purchase Limit	false	In the Purchase Limit field, enter the amount this employee can purchase without approval from a supervisor or approver.
releasedate	date	true	Termination Date	false	Enter this person's last date of employment. You can type or pick another date.
requirepwdchange	checkbox	false	Require Password Change On Next Login	false	Check this box to require this user to change their password on their next login to NetSuite. When the user next logs in, they see the Change Password page and cannot access other NetSuite pages until a new password is created and saved. Requiring this action protects your account from unauthorized access using generic passwords and prepares your account for an audit. The Require Password Change on Next Login box never displays as checked. When you check this box and save the record, an internal flag is set. When the password change occurs, the flag is cleared. If you later check the box again and save the record, the internal flag is reset to require another password change.
residentstatus	select	true	Resident Status	false	Select the employee's resident status. The employee's status is located in Section 1 of the completed I-9 form.
retailuserqty	text	false	RetailUser current	false
retailuserqtymax	text	false	RetailUser max	false
salesrole	select	true	Sales Role	false	Select the this employee's role in the selling process. You can create new sales roles at <_TABNAME=LIST_CRMOTHERLIST_> > <_TASKCATEGORY=LIST_CRMOTHERLIST_> > CRM Lists > New > Sales Role.
salutation	text	true	Mr./Ms...	false	Enter an appropriate salutation for this employee.
sendemail	checkbox	false	Send Notification Email	false	Check this box to send an automatic email notifying this employee of access privileges to NetSuite. The standard NetSuite email message also contains a link to let the user create a password. If you do not check this box, you must check the Manually Assign or Change Password box. You must create the password, and tell the user the password, and when and how to log in. For security reasons, do not send the password by email.
socialsecuritynumber	ssnumber	true	Social Security	false	Enter the social security number of this employee.
startdatetimeoffcalc	date	false	Start Date for Time-Off Calculations	false	Enter the start date for the purpose of time-off calculations. The date entered here is used to calculate the number of days this employee is entitled to time-off, based on the minimum and maximum tenures set in the time-off plan. If there is no value specified in this field, this employee cannot be assigned a time-off plan.
strength	text	false	Password Strength	false
subsidiary	select	false	Subsidiary	true	Select the subsidiary to associate with this employee. You cannot enter transactions for this employee unless a subsidiary is assigned. If you select this employee on time transactions, the transaction is associated with this subsidiary. The employee is able to access only information associated with this subsidiary. Note: Once a transaction has posted for the employee, you are not able to change the subsidiary selected on the employee record.
supervisor	select	true	Supervisor	false	Select the name of your employee's supervisor. This person approves expense reports and purchase requests. If the employee doesn't have a supervisor, use the Approver field to select the person who approves this employee's expense reports and purchase requests.
terminationbydeath	checkbox	false	Termination Due To Death	false
timeapprover	select	true	Time Approver	false	In the Time Approver field, select the person who approves the employee’s time transactions. If no time approver is selected, the employee’s supervisor approves time entries. If both a supervisor and a time approver are selected, then only the time approver can approve time entries using their Employee Center role.
timeoffplan	select	false	Time-off plan	false	Select the time-off plan to assign to this employee.
title	text	true	Job Title	false	Enter this employee's official job title here.
unsubscribe	select	false	Unsubscribe from Campaigns	false	This box is checked if this employee has unsubscribed from e-mail campaigns. Unsubscribed employees receive no campaign e-mail. Employees can unsubscribe to e-mail campaigns by clicking a link in any campaign e-mail they receive.
useperquest	checkbox	true	Include in Payroll	false	Check this box if you want to include this employee in your pay runs. This employee will also be included in the Employee list on payroll forms and reports.
usetimedata	select	true	Compensation Type	false	Select Wage if this employee's pay is based on hours entered via the weekly time sheet or by manual entry while processing the payroll. Select Salary if this employee's pay is based on a set amount and does not vary according to hours worked.
visaexpdate	date	true	Visa Expiration Date	false	Enter the expiration date of the employee's visa. This information can be obtained from the employee's passport.
visatype	select	true	Visa Type	false	Select the employee's visa type. This information can be obtained from the employee's passport. For information on visa type records, go to <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
wasempcenterhasaccess	text	false	EmpCenter hasaccess	false
wasfulluserhasaccess	text	false	FullUser hasaccess	false
wasinactive	text	false	wasinactive	false
wasretailuserhasaccess	text	false	RetailUser hasaccess	false
workassignment	radio	false	Job	false	Select whether to assign a job or a position to this employee.
workcalendar	select	true	Work Calendar	true	Select the work calendar for this employee.
workplace	select	true	Workplace	false	Select the workplace where this employee works. The address of this workplace will be used to define the taxes you are required to withhold and pay for this employee.

Sublists

accruedtime - Accrued Time

Internal ID	Type	Label	Required	Help
accrualmethod	select	Accrue As	false
accrualrate	float	Accrual Rate	false
accruedhours	float	Accrued Hours	false
inactive	checkbox	Inactive	false
maximumaccruedhours	float	Maximum Hours	false
monetaryrate	currency	Monetary Rate	false
payrollitem	select	Sick/Vacation Time	true
resetaccruedhoursatyearend	checkbox	Reset at Year End	false

addressbook - Address

Internal ID	Type	Label	Required	Help
addressbookaddress	summary	Edit	false
addressid	text		false
addrtext	address	Address	false
attention	text	Attention	false
city	text	City	false
country	select	Country	false
defaultbilling	checkbox	Home	false
defaultshipping	checkbox	Default Shipping	false
displaystate	text	State/Province	false
id	integer	ID	false
internalid	integer		false
label	text	Label	false
override	checkbox	Override	false
phone	phone	Phone	false	Enter a phone number for your employee. It will appear on the Employee List report. This field is required for Online Bill Pay enabled employees. Phone numbers can be entered in the following formats:999-999-9999, 1-999-999-9999, (999) 999-9999, 1(999) 999-9999 or 999-999-9999 ext 9999 .
state	text	State/Province	false
zip	text	Zip	false

companycontribution - Company Contributions

Internal ID	Type	Label	Required	Help
inactive	checkbox	Inactive	false
limit	currency	Limit	false
payrollitem	select	Company Contribution	true
rate	rate	Rate	false

currency - Currencies

Internal ID	Type	Label	Required	Help
currency	select	Currency	true

deduction - Deductions

Internal ID	Type	Label	Required	Help
inactive	checkbox	Inactive	false
limit	currency	Limit	false
payrollitem	select	Deduction	true
rate	rate	Rate	false

directdeposit - Accounts

Internal ID	Type	Label	Required	Help
accountprenoted	checkbox	Prenoted	false
amount	currency	Amount	false
bankaccountnumber	text	Account Number	true
bankname	text	Bank Name	true
bankroutingnumber	text	Routing Number	true
id	text	ID	false
inactive	checkbox	Inactive	false
netaccount	checkbox	Net Account	false
savingsaccount	checkbox	Savings Account	false

earning - Earnings

Internal ID	Type	Label	Required	Help
defaultearning	checkbox	Default	false
defaulthours	float	Default Hours	false
inactive	checkbox	Inactive	false
payrate	rate	Rate	false
payrollitem	select	Earning	true
primaryearning	checkbox	Primary	false

hcmposition - Positions

Internal ID	Type	Label	Required	Help
employmentcategory	select	Employment Category	false
fulltimeequivalent	float	Full Time Equivalent	false
location	select	Location	false
position	select	Position	true
positionallocation	float	Allocated Position FTE	false
positionid	text	Position ID	false
primaryposition	checkbox	Primary	true
reportsto	select	Reports To	false
subsidiary	select	Subsidiary	true

rates - Rates

Internal ID	Type	Label	Required	Help
entitycurrency	select	Currency	true
rate	currency	Hourly Rate	true

Tabs

Name	Label
access	Access
address	Address
commission	Commission
curjurisdictions	Current
custom	Custom
dd	ACH/Direct Deposit
education	Education
general	General
hr	Human Resources
hrpersonal	Personal
hrworkstatus	Work Status
info	Info
jurisdictions	Jurisdictions
marketing	Marketing
payfed	Federal Withholdings
payroll	Payroll
support	Support
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
campaignresponse	Campaign Response	Campaign
department	Department	Department
location	Location	Location
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message
subsidiary	Subsidiary	Subsidiary

Search Filters

Internal ID	Type	Label
address	textarea	Address
addressee	text	Addressee
addresslabel	text	Address Label
addressphone	phone	Address Phone
aliennumber	text	Alien Number
allocation	percent	Allocation
anniversary	date	Anniversary
approvallimit	currency	Expense Approval Limit
approver	select	Expense Approver
attention	text	Attention
authworkdate	date	Authorized to work until date
basewage	currency	Base Wage
basewagetype	select	Base Wage Type
billingclass	select	Billing Class
birthdate	date	Birth Date
birthday	date	Birthday
ccontribution	select	Company Contribution
city	text	City
class	select	Class
comments	textarea	Comments
commissionplan	select	Commission Plan
compensationcurrency	select	Currency
concurrentwebservicesuser	checkbox	Concurrent Web Services User
country	select	Country
county	text	County/State
datecreated	datetime	Date Created
deduction	select	Deduction
defaultacctcorpcardexp	select	Default Account for Corporate Card Expenses
defaultexpensereportcurrency	select	Default Currency for Expense Reports
department	select	Department
earning	select	Earning
education	select	Education
eligibleforcommission	checkbox	Eligible For Commission
email	text	Email
employeestatus	select	Employee Status
employeetype	select	Type
employeetypekpi	checkbox	Include in KPI
entityid	text	Name/ID
ethnicity	select	Ethnicity
expenselimit	currency	Expense Limit
expensereportcurrency	select	Expense Report Currency
externalid	select	External ID
externalidstring	text	External ID (Text)
fax	phone	Fax
firstname	text	First Name
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
gender	checkbox	Gender
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
group	multiselect	Group
hiredate	date	Hire Date
i9verified	checkbox	I9 Verified
image	image	Image
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresource	checkbox	Is Job Resource
istemplate	checkbox	Is Template
job	select	Job
jobdescription	text	Job Description
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
lastpaiddate	date	Last Paid Date
lastreviewdate	date	Last Review Date
level	select	Level
location	select	Location
maritalstatus	select	Marital Status
middlename	text	Middle Name
nextreviewdate	date	Next Review Date
offlineaccess	checkbox	Offline Access
payfrequency	select	Pay Frequency
permchangedate	datetime	Permission Change Date
permission	select	Permission
permissionchange	select	Permission Change
phone	phone	Phone
phoneticname	text	Phonetic Name
positiontitle	select	Position Title
primaryearningamount	currency	Primary Earning Amount
primaryearningitem	text	Primary Earning Item
primaryearningtype	text	Primary Earning Type
purchaseorderapprovallimit	currency	Purchase Approval Limit
purchaseorderapprover	select	Purchase Approver
purchaseorderlimit	currency	Purchase Limit
releasedate	date	Release Date
representingsubsidiary	select	Represents Subsidiary
residentstatus	select	Resident Status
role	select	Role
rolechange	select	Role Change
rolechangedate	datetime	Role Change Date
salesrep	checkbox	Is Sales Rep
salesrole	select	Sales Role
salutation	text	Mr./Mrs...
socialsecuritynumber	ssnumber	Social Security Number
startdatetimeoffcalc	date	Start Date for Time-Off Calculations
state	select	State/Province
subsidiary	select	Subsidiary
supervisor	select	Supervisor
supportrep	checkbox	Is Support Rep
terminationcategory	select	Termination Category
terminationdetails	text	Termination Details
terminationreason	select	Termination Reason
terminationregretted	select	Termination Regretted
timeapprover	select	Time Approver
timeoffplan	select	Time-Off Plan
title	text	Job Title
useperquest	checkbox	Include In US Payroll
usetimedata	checkbox	Use Time Data
visaexpdate	date	Visa Expiration Date
visatype	select	Visa Type
withholding	select	Withholding
workcalendar	select	Work Calendar
workplace	select	Workplace
zipcode	text	Zip

Search Columns

Internal ID	Type	Label
accountnumber	text	Account
address	text	Address
addressee	text	Addressee
addressinternalid	integer	Address Internal ID
addresslabel	text	Address Label
addressphone	text	Address Phone
aliennumber	text	Alien #
allocation	float	Allocated Position FTE
altemail	email	Alt. Email
altname	text	Name
altphone	phone	Office Phone
approvallimit	currency	Expense Approval Limit
approver	select	Expense Approver
attention	text	Attention
authworkdate	date	Authorized to work until date
basewage	currency	Base Wage
basewagetype	select	Base Wage Type
billcountrycode	text	Billing Country Code
billingclass	select	Billing Class
billzipcode	text	Billing Zip
birthdate	date	Birth Date
birthday	date	Birth Day
city	text	City
class	select	Class
classnohierarchy	select	Class (no hierarchy)
comments	text	Comments
compensationcurrency	select	Compensation Currency
concurrentwebservicesuser	checkbox	Concurrent Web Services User
country	select	Country
countrycode	text	Country Code
datecreated	datetime	Date Created
defaultacctcorpcardexp	select	Default Account for Corporate Card Expenses
defaultexpensereportcurrency	select	Default Currency for Expense Reports
department	select	Department
departmentnohierarchy	select	Department (no hierarchy)
eligibleforcommission	checkbox	Eligible for Commission
email	email	Email
employeestatus	select	Employee Status
employeetype	select	Type
entityid	text	Name
entitynumber	integer	Number
ethnicity	select	Ethnicity
expenselimit	currency	Expense Limit
expensereportcurrency	select	Expense Report Currency
externalid	select	External ID
fax	text	Fax
firstname	text	First Name
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
gender	select	Gender
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
hiredate	date	Hire Date
homephone	phone	Home Phone
i9verified	checkbox	I9 Verified
image	select	Image
internalid	select	Internal ID
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresource	checkbox	Job Resource
issalesrep	checkbox	Sales Rep
issupportrep	checkbox	Support Rep
istemplate	checkbox	Is Template
job	select	Job
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
lastpaiddate	date	Last Paid Date
lastreviewdate	date	Last Review
lastviewed	datetime	Last Viewed
level	select	Level
location	select	Location
locationnohierarchy	select	Location (no hierarchy)
maritalstatus	select	Marital Status
middlename	text	Middle Name
mobilephone	phone	Mobile Phone
nextreviewdate	date	Next Review
offlineaccess	checkbox	Offline Access
payfrequency	select	Pay Frequency
permchangedate	datetime	Permission Change Date
permchangelevel	text	Permission Change Level
permission	select	Permission
permissionchange	text	Permission Change
phone	phone	Phone
phoneticname	text	Phonetic Name
positiontitle	text	Position Title
primaryearningamount	currency	Primary Earning Amount
primaryearningitem	text	Primary Earning Item
primaryearningtype	text	Primary Earning Type
purchaseorderapprovallimit	currency	Purchase Approval Limit
purchaseorderapprover	select	Purchase Approver
purchaseorderlimit	currency	Purchase Limit
releasedate	date	Release Date
representingsubsidiary	select	Represents Subsidiary
residentstatus	select	Resident Status
role	select	Role
rolechange	text	Role Change
rolechangeaction	text	Role Change Action
rolechangedate	datetime	Role Change Date
salesrole	select	Sales Role
salutation	text	Mr./Mrs...
shipcountrycode	text	Shipping Country Code
socialsecuritynumber	ssnumber	Social Security #
startdatetimeoffcalc	date	Start Date for Time-Off Calculations
state	select	State/Province
statedisplayname	select	State/Province Display Name
subscription	select	Subscription
subscriptiondate	datetime	Subscription Date
subscriptionstatus	checkbox	Subscription Status
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
supervisor	select	Supervisor
terminationcategory	select	Termination Category
terminationdetails	text	Termination Details
terminationreason	select	Termination Reason
terminationregretted	select	Termination Regretted
timeapprover	select	Time Approver
timeoffplan	text	Time-Off Plan
title	text	Job Title
useperquest	checkbox	Include In US Payroll
usetimedata	checkbox	Use Time Data
visaexpdate	date	Visa Expiration Date
visatype	select	Visa Type
workcalendar	select	Work Calendar
workplace	select	Workplace
zipcode	text	Zip Code

Transform Types

Target Record Type	Field Defaults
expensereport	customform
timebill	customform