staff_id | nvarchar (22) | NOT NULL | User defined identifier (unique). |
description | nvarchar (60) | NOT NULL | User defined description. |
user_name | nvarchar (60) | NOT NULL | The name used on the login screen. |
first_name | nvarchar (60) | NOT NULL | The first name of this Staff. |
middle_name | nvarchar (60) | NOT NULL | The middle name of this Staff. |
last_name | nvarchar (60) | NOT NULL | The last name of this Staff. |
social_security_number | nvarchar (22) | NOT NULL | Social Security Number. |
photograph | image (16) | | The contents of a image file for the staff's photograph. |
comments | nvarchar (-1) | | Any comments about the Staff. |
date_hired | smalldatetime (4) | | Date hired. |
date_left | smalldatetime (4) | | Date Staff no longer employed. |
date_education_met | smalldatetime (4) | | Date education met. |
date_exam_passed | smalldatetime (4) | | Date exam passed. |
date_experience_met | smalldatetime (4) | | Date experience met. |
date_certified | smalldatetime (4) | | Date certified. |
certification_number | nvarchar (20) | NOT NULL | Certification number. |
staff_status_KEY | int (4) | NOT NULL | Key from one of the already set up Staff Status. |
office_KEY | int (4) | | Key from one of the already set up Offices. |
supervisor__staff_KEY | int (4) | | Key of the staff that is this Staff's supervisor. |
contact_KEY | int (4) | NOT NULL | Key to the primary Contact record for this Staff. |
staff_id_sortable | varchar (48) | NOT NULL | A representation of the staff_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of staff_id. |
is_tax_form_preparer | bit (1) | NOT NULL | A flag specifying whether or not the current staff member qualifies to prepare tax forms. |
preparer_tax_information_number | nvarchar (18) | NOT NULL | The staff member's preparer tax information number used in place of an SSN on tax forms. A value in this field is optional and does not qualify a staff member to be a tax form preparer. is_tax_form_preparer is used as a qualification as a preparer |
third_party_designee_pin | nvarchar (10) | NOT NULL | The staff member's third party designee pin that the staff member selects to sign tax forms. A value in this field designates the staff member as being available as a third party designee. |
name_suffix | nvarchar (10) | NOT NULL | Name suffix (Jr, Sr, MD, etc.) |
title | nvarchar (40) | NOT NULL | Staff title |
staff_type_KEY | int (4) | NOT NULL | Foreign key to the Staff_Type table. Each staff must have a type. |
staff_KEY | int (4) | NOT NULL | The name of the primary key column. |