Table: dbo.Treasury_Tipped_Occupation_Code
This table holds the Treasury tipped occupation codes available.
Columns
Name	Type	Constraints	Description
treasury_tipped_occupation_code_KEY	tinyint (1)	NOT NULL	Primary Key for Treasury tipped occupation code table
description	nvarchar (120)	NOT NULL	Description for Treasury tipped occupation code
code	nvarchar (6)	NOT NULL	Code for Treasury tipped occupation code

Primary key
Name	Columns		Description
PK_Treasury_Tipped_Occupation_Code	treasury_tipped_occupation_code_KEY
Unique constraints
Name	Columns		Description
UK_Treasury_Tipped_Occupation_Code$code	code
UK_Treasury_Tipped_Occupation_Code$description	description

Incoming foreign keys
Name	Columns	Referencing table	Description
FK_Employee__Treasury_Tipped_Occupation_Code__first__treasury_tipped_occupation_code_KEY	first__treasury_tipped_occupation_code_KEY	Employee	Foreign key constraint linking Employee to Treasury_Tipped_Occupation_Code for the first W-2 tipped occupation code.
FK_Employee__Treasury_Tipped_Occupation_Code__second__treasury_tipped_occupation_code_KEY	second__treasury_tipped_occupation_code_KEY	Employee	Foreign key constraint linking Employee to Treasury_Tipped_Occupation_Code for the second W-2 tipped occupation code.
FK_Print_W2_Selection__Treasury_Tipped_Occupation_Code__box_14b_first__treasury_tipped_occupation_code_KEY	box_14b_first__treasury_tipped_occupation_code_KEY	Print_W2_Selection	Foreign key constraint linking Print_W2_Selection to Treasury_Tipped_Occupation_Code for the first W-2 box 14b tipped occupation code.
FK_Print_W2_Selection__Treasury_Tipped_Occupation_Code__box_14b_second__treasury_tipped_occupation_code_KEY	box_14b_second__treasury_tipped_occupation_code_KEY	Print_W2_Selection	Foreign key constraint linking Print_W2_Selection to Treasury_Tipped_Occupation_Code for the second W-2 box 14b tipped occupation code.
FK_Print_W2_Selection__Treasury_Tipped_Occupation_Code__original_box_14b_first__treasury_tipped_occupation_code_KEY	original_box_14b_first__treasury_tipped_occupation_code_KEY	Print_W2_Selection	Foreign key constraint linking Print_W2_Selection to Treasury_Tipped_Occupation_Code for the original first W-2c box 14b tipped occupation code.
FK_Print_W2_Selection__Treasury_Tipped_Occupation_Code__original_box_14b_second__treasury_tipped_occupation_code_KEY	original_box_14b_second__treasury_tipped_occupation_code_KEY	Print_W2_Selection	Foreign key constraint linking Print_W2_Selection to Treasury_Tipped_Occupation_Code for the original second W-2c box 14b tipped occupation code.
FK_Employee_W2_Override__Treasury_Tipped_Occupation_Code__first__treasury_tipped_occupation_code_KEY	first__treasury_tipped_occupation_code_KEY	Employee_W2_Override	Foreign key constraint linking Employee_W2_Override to Treasury_Tipped_Occupation_Code for the first W-2 tipped occupation code override.
FK_Employee_W2_Override__Treasury_Tipped_Occupation_Code__second__treasury_tipped_occupation_code_KEY	second__treasury_tipped_occupation_code_KEY	Employee_W2_Override	Foreign key constraint linking Employee_W2_Override to Treasury_Tipped_Occupation_Code for the second W-2 tipped occupation code override.