Table: dbo.Staff
Columns
NameTypeConstraintsDescription
staff_idnvarchar (22)NOT NULLUser defined identifier (unique).
descriptionnvarchar (60)NOT NULLUser defined description.
user_namenvarchar (60)NOT NULLThe name used on the login screen.
first_namenvarchar (60)NOT NULLThe first name of this Staff.
middle_namenvarchar (60)NOT NULLThe middle name of this Staff.
last_namenvarchar (60)NOT NULLThe last name of this Staff.
social_security_numbernvarchar (22)NOT NULLSocial Security Number.
photographimage (16)The contents of a image file for the staff's photograph.
commentsnvarchar (-1)Any comments about the Staff.
date_hiredsmalldatetime (4)Date hired.
date_leftsmalldatetime (4)Date Staff no longer employed.
date_education_metsmalldatetime (4)Date education met.
date_exam_passedsmalldatetime (4)Date exam passed.
date_experience_metsmalldatetime (4)Date experience met.
date_certifiedsmalldatetime (4)Date certified.
certification_numbernvarchar (20)NOT NULLCertification number.
staff_status_KEYint (4)NOT NULLKey from one of the already set up Staff Status.
office_KEYint (4)Key from one of the already set up Offices.
supervisor__staff_KEYint (4)Key of the staff that is this Staff's supervisor.
contact_KEYint (4)NOT NULLKey to the primary Contact record for this Staff.
staff_id_sortablevarchar (48)NOT NULLA 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_preparerbit (1)NOT NULLA flag specifying whether or not the current staff member qualifies to prepare tax forms.
preparer_tax_information_numbernvarchar (18)NOT NULLThe 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_pinnvarchar (10)NOT NULLThe 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_suffixnvarchar (10)NOT NULLName suffix (Jr, Sr, MD, etc.)
titlenvarchar (40)NOT NULLStaff title
staff_type_KEYint (4)NOT NULLForeign key to the Staff_Type table. Each staff must have a type.
staff_KEYint (4)NOT NULLThe name of the primary key column.
Primary key
NameColumnsDescription
PK_Staffstaff_KEY
Unique constraints
NameColumnsDescription
UK_Staff$contact_KEYcontact_KEY
UK_Staff$staff_idstaff_id
UK_Staff$staff_id_sortablestaff_id_sortable
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Staff__Office__office_KEYoffice_KEYOffice (office_KEY)
FK_Staff__Staff__supervisor__staff_KEYsupervisor__staff_KEYStaff (staff_KEY)
FK_Staff__Staff_Status__staff_status_KEYstaff_status_KEYStaff_Status (staff_status_KEY)
FK_Staff__Staff_Type__staff_type_KEYstaff_type_KEYStaff_Type (staff_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff__Staff__supervisor__staff_KEYsupervisor__staff_KEYStaff
FK_Trial_Balance_Split_Screen_Grid_Option__Staff__staff_KEYstaff_KEYTrial_Balance_Split_Screen_Grid_Option
FK_Recorded_Event_Notification__Staff__staff_KEYstaff_KEYRecorded_Event_Notification
FK_Web_Services_Transmit_Queue__Staff__creation__staff_KEYcreation__staff_KEYWeb_Services_Transmit_Queue
FK_Csa_Staff_Map_To_Acs_Staff__Staff__staff_KEYstaff_KEYCsa_Staff_Map_To_Acs_Staff
FK_Workpaper_List_Column__Staff__staff_KEYstaff_KEYWorkpaper_List_Column
FK_User_Preference__Staff__staff_KEYstaff_KEYUser_Preference
FK_Complete_Payroll_Output_Session__Staff__staff_KEYstaff_KEYComplete_Payroll_Output_Session
FK_Staff_Security_Group__Staff__staff_KEYstaff_KEYStaff_Security_Group
FK_Client_Staff_Intercept_Credentials__Staff__staff_KEYstaff_KEYClient_Staff_Intercept_Credentials
FK_Staff_Shortcut__Staff__staff_KEYstaff_KEYStaff_Shortcut
FK_Staff_Locator__Staff__staff_KEYstaff_KEYStaff_Locator
FK_Print_Job__Staff__staff_KEYstaff_KEYPrint_Job
FK_Recorded_Event_Object_N_Staff__Staff__staff_KEYstaff_KEYRecorded_Event_Object_N_Staff
FK_Staff_Ems_User_Id__Staff__staff_KEYstaff_KEYStaff_Ems_User_Id
FK_Check_Print_Run__Staff__staff_KEYstaff_KEYCheck_Print_Run
FK_Filter_Selection__Staff__staff_KEYstaff_KEYFilter_Selection
FK_Magnetic_Media_File__Staff__staff_KEYstaff_KEYMagnetic_Media_File
FK_Client_N_Staff__Staff__staff_KEYstaff_KEYClient_N_Staff
FK_Staff_Create_Ems_User_Requested__Staff__staff_KEYstaff_KEYStaff_Create_Ems_User_Requested
FK_GL_Balancing_Entry__Staff__staff_KEYstaff_KEYGL_Balancing_Entry
FK_Active_Filter__Staff__staff_KEYstaff_KEYActive_Filter
FK_User_Session__Staff__staff_KEYstaff_KEYUser_Session
FK_Print_Report_Selection__Staff__staff_KEYstaff_KEYPrint_Report_Selection
FK_Staff_Default_Report_Option__Staff__staff_KEYstaff_KEYStaff_Default_Report_Option
FK_Custom_Portlet__Staff__private__staff_KEYprivate__staff_KEYCustom_Portlet
FK_Conversion_Wizard_Client_Payroll_Information__Staff__backup_processor__staff_KEYbackup_processor__staff_KEYConversion_Wizard_Client_Payroll_Information
FK_Conversion_Wizard_Client_Payroll_Information__Staff__primary_processor__staff_KEYprimary_processor__staff_KEYConversion_Wizard_Client_Payroll_Information
FK_Login_Ticket__Staff__staff_KEYstaff_KEYLogin_Ticket
FK_Apply_Customer_Payment_Option__Staff__staff_KEYstaff_KEYApply_Customer_Payment_Option
FK_Import_Template__Staff__staff_KEYstaff_KEYImport_Template
FK_Complete_Forms_Output_Session__Staff__staff_KEYstaff_KEYComplete_Forms_Output_Session
FK_Custom_Value_Staff__Staff__staff_KEYstaff_KEYCustom_Value_Staff
FK_Practice_User__Staff__staff_KEYstaff_KEYPractice_User
FK_Client_Access_Notification__Staff__assigned__staff_KEYassigned__staff_KEYClient_Access_Notification
FK_Client_Access_Notification__Staff__client__staff_KEYclient__staff_KEYClient_Access_Notification
FK_Ach_File_Header_Record__Staff__staff_KEYstaff_KEYAch_File_Header_Record
FK_Export_User_Preference__Staff__staff_KEYstaff_KEYExport_User_Preference
FK_Custom_Value_Client_Staff__Staff__staff_KEYstaff_KEYCustom_Value_Client_Staff
FK_Engagement_Binder_N_Staff__Staff__staff_KEYstaff_KEYEngagement_Binder_N_Staff
FK_Enter_Transaction_Data_Entry_Session_Element__Staff__staff_KEYstaff_KEYEnter_Transaction_Data_Entry_Session_Element
FK_Workpaper__Staff__assigned_to__staff_KEYassigned_to__staff_KEYWorkpaper
FK_Workpaper__Staff__locked_by__staff_KEYlocked_by__staff_KEYWorkpaper
FK_Engagement_Item_Note__Staff__assigned_to__staff_KEYassigned_to__staff_KEYEngagement_Item_Note
FK_Engagement_Item_Note__Staff__created_date__staff_KEYcreated_date__staff_KEYEngagement_Item_Note
FK_AR_Enter_Invoice_Option__Staff__staff_KEYstaff_KEYAR_Enter_Invoice_Option
FK_Journal_Entry_Event__Staff__staff_KEYstaff_KEYJournal_Entry_Event
FK_Processing_Note__Staff__created_date__staff_KEYcreated_date__staff_KEYProcessing_Note
FK_Processing_Note__Staff__edited_date__staff_KEYedited_date__staff_KEYProcessing_Note
FK_Netclient_File_Log__Staff__creation__staff_KEYcreation__staff_KEYNetclient_File_Log
FK_Client_Payroll_Information__Staff__backup_processor__staff_KEYbackup_processor__staff_KEYClient_Payroll_Information
FK_Client_Payroll_Information__Staff__primary_processor__staff_KEYprimary_processor__staff_KEYClient_Payroll_Information
FK_Client_Payroll_Information__Staff__reviewer__staff_KEYreviewer__staff_KEYClient_Payroll_Information
FK_AR_Customer_Payment_Option__Staff__staff_KEYstaff_KEYAR_Customer_Payment_Option
FK_Staff_With_Access_To_Checkbook__Staff__staff_KEYstaff_KEYStaff_With_Access_To_Checkbook
FK_Bank_Transaction_Event__Staff__staff_KEYstaff_KEYBank_Transaction_Event
FK_Manage_AP_Payment_Processable_Transaction__Staff__created__staff_KEYcreated__staff_KEYManage_AP_Payment_Processable_Transaction
FK_Scheduled_Payroll_Tracking_Detail__Staff__backup_processor__staff_KEYbackup_processor__staff_KEYScheduled_Payroll_Tracking_Detail
FK_Scheduled_Payroll_Tracking_Detail__Staff__primary_processor__staff_KEYprimary_processor__staff_KEYScheduled_Payroll_Tracking_Detail
FK_Payable_Transaction__Staff__created__staff_KEYcreated__staff_KEYPayable_Transaction

Schema diagram