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