Table: dbo.Employee | |||
Columns | |||
Name | Type | Constraints | Description |
employee_KEY | int (4) | NOT NULL | Primary key for this table |
client_KEY | int (4) | NOT NULL | Key of company employee works for |
employee_id | nvarchar (22) | NOT NULL | Clients employee identifier |
social_security_number | nvarchar (22) | NOT NULL | Social Security Number |
first_name | nvarchar (60) | NOT NULL | First name |
middle_name | nvarchar (60) | NOT NULL | Middle name |
last_name | nvarchar (60) | NOT NULL | Last name |
name_suffix | nvarchar (10) | NOT NULL | Name suffix (Jr, Sr, MD, etc.) |
contact_KEY | int (4) | NOT NULL | Key of parent contact record. |
date_of_birth | smalldatetime (4) | Date of birth | |
marital_status_type_KEY | int (4) | Marital status type | |
gender_type_KEY | int (4) | Gender type | |
race_type_KEY | int (4) | Race type | |
is_officer | bit (1) | NOT NULL | Indicates if the employee is an officer of the company |
is_probationary | bit (1) | NOT NULL | Indicates if this employee is probationary |
is_seasonal | bit (1) | NOT NULL | Indicates if this employee is seasonal |
is_family_of_owner | bit (1) | NOT NULL | Indicates if this employee is a member of the family that owns the company |
w2_statutory_employee | bit (1) | NOT NULL | Indicates if this is a W2 statutory employee |
ste_location_code | nvarchar (70) | NOT NULL | Symmetry Tax Engine generated code which links the employee taxing address to its related jurisdiction-related tax items |
primary__client_pay_schedule_KEY | int (4) | Primary pay schedule | |
alternate__client_pay_schedule_KEY | int (4) | Alternate payschedule | |
is_paycard_recipient | bit (1) | NOT NULL | Indicates if this employee is paid via deposits to a bankcard account |
direct_deposit_method_KEY | nvarchar (50) | NOT NULL | Method used for Direct Deposit |
direct_deposit_amount_percent | decimal (5, 2) | NOT NULL | Percentage of pay to be distrubted using direct deposit |
direct_deposit_distribution_method_KEY | int (4) | NOT NULL | Indicates if this employee direct deposit allocation method is Total Distribution (1) or Remainder of Distribution (2) |
use_alternate_direct_deposit_distribution | bit (1) | NOT NULL | Enables the use of an alternate set of direct deposit allocation distributions |
distribute_pay_by_percentage | bit (1) | NOT NULL | Enables an employee so that pay can be distributed among different work locations/departments |
employee_id_sortable | nvarchar (96) | NOT NULL | A representation of the employee_id column that sorts in natural order. A trigger keeps this field synchronized with the content of employee_id. |
date_ssn_verified | smalldatetime (4) | The date the ssn for this employee was verified. | |
date_new_hire_reported | smalldatetime (4) | The date this employee was included in a new hire report. | |
record_status_KEY | int (4) | NOT NULL | The current status for the employee record. |
employee_type_KEY | int (4) | NOT NULL | The current type of the employee record. |
use_backup_withholding_rate | bit (1) | NOT NULL | If true, then the employee uses the appropriate rate from the Backup_Withholding_Rate table. |
current__employee_earning_type_KEY | int (4) | NOT NULL | Foreign key to the employee earning type table. |
is_webemployee_portal_disabled | bit (1) | NOT NULL | Flag to disable the employee WebEmployee portal. |
is_webemployee_portal_activated | bit (1) | NOT NULL | Flag to indicate the employee WebEmployee portal has been activated. The portal is activated when the user logs in for the first time. |
resend_employee_self_service_welcome_email | bit (1) | NOT NULL | Flag to indicate if ESS needs to re-send a welcome email to the employee email address. |
transmit_is_webemployee_portal_disabled | bit (1) | NOT NULL | Flag to indicate that we need to push the portal disabled flag to ESS. |
has_health_care | bit (1) | NOT NULL | Ture if this employee has health care which is provided by employer or from somewhere else. |
export__quick_books_payee_KEY | int (4) | A Foreign key to the Quick_Books_Payee table, this is the quickbooks side of the mapping during the Acs to Quickbooks export data mapping process. This will be used to map Accounting CS employees to QuickBooks payees of type employee. This key will be null if no export mapping has been done. | |
employee_multi_state_income_tax_calculation_method_KEY | int (4) | NOT NULL | The selected method for determining how to calculate multi-state income tax withholding for the employee. |
is_w2_retirement_plan | bit (1) | NOT NULL | Is this employee marked as having a retirement plan. |
is_part_time | bit (1) | NOT NULL | Indicates that the employee has part time employment status. |
affordable_care_act_employee_status_KEY | tinyint (1) | NOT NULL | |
employee_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row. |
employee_force_new_version_toggle | bit (1) | NOT NULL | A bit to toggle that causes the employee_version to update. Flip this bit when a subordinate tables are changed. |
forced_webemployee_push_version | tinyint (1) | NOT NULL | Allows for us to create employee update pushes to web employee based on a version. Starts at zero and is incremented for each push we run. See DevWiki documentation for details on ini toggle ForcedEmployeeEssPushVersion. |
covid_19_defer_employee_social_security | bit (1) | NOT NULL | Bit field that indicates whether or not the Employee Social Security tax will be deferred. False means that the tax will not be deferred, true means that the tax will be deferred. |
covid_19_exempt_employee_from_employee_retention_credit | bit (1) | NOT NULL | Bit field that indicates whether or not the Employee Rentention Credit will be excluded. True means that the credit will be excluded. False means that the credit will be included. |
Primary key | |||
Name | Columns | Description | |
PK_Employee | employee_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employee$client_KEY$employee_id | client_KEY, employee_id | ||
UK_Employee$client_KEY$employee_id_sortable | client_KEY, employee_id_sortable | ||
UK_Employee$contact_KEY | contact_KEY |