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.