Jump to content

ERP Internals/Data Tables/Employee

From Wikibooks, open books for an open world

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