ERP Internals/Data Tables/Employee

This table contains one record for every employee.

Used by: Human Resources, Payroll

Key: Employee Number

Fields:
 * Employee Number (a unique identifier assigned by the user)
 * Type
 * Active (Yes/No)
 * Last Name
 * First Name
 * Middle Name
 * Suffix
 * Title (Mr/Ms/Mrs/etc.)
 * Job Title
 * Department (this is selected from a table unlike all the other department fields)
 * Address 1
 * Address 2
 * City
 * State/Province
 * Country
 * Zip/Postal Code
 * Business Telephone
 * Telephone Extension
 * Home Telephone
 * Mobile
 * Pager
 * E-mail
 * Pay Rate
 * Pay Frequency
 * Vacation Accrual Rate
 * Accrued Vacation
 * Sick Day Accrual Rate
 * Accrued Sick Days
 * Picture
 * Ethnic Origin (used for US government reporting)
 * Military Status
 * Country-Specific Tax Fields
 * Hire Date
 * Next Review Date
 * Termination Date
 * Termination Reason (ROE Code)
 * Birthdate
 * Gender
 * Marital Status
 * Number of Dependents
 * Emergency Contact Name
 * Emergency Telephone Number
 * SSN/SIN
 * Bank Name (for Direct Deposit)
 * Bank Account Number (for Direct Deposit)
 * Manager Employee Number
 * Union
 * Union Number
 * GL Distribution Group (contains all the postable account numbers)
 * Language
 * Notes