Table: dbo.Employee_Independent_Contractor_Reported
The table used to store when an employee has been reported to be an independent contractor.
Columns
NameTypeConstraintsDescription
employee_independent_contractor_reported_KEYint (4)NOT NULLPrimary key for this table.
employee_KEYint (4)NOT NULLThe foreign key into the Employee table for the employee being reported as an independent contractor.
date_reportedsmalldatetime (4)NOT NULLThe date the employee was reported as an independent contractor for the year.
contract_yearint (4)NOT NULLThe year the contract is for. This may differ from the year the contract was reported.
Primary key
NameColumnsDescription
PK_Employee_Independent_Contractor_Reportedemployee_independent_contractor_reported_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Independent_Contractor_Reported$contract_year$employee_KEYcontract_year, employee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Independent_Contractor_Reported__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram