Table: dbo.Form_W2G_Option
Table to set various options on the W-2G form.
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key into the Form_1099 table
date_won | smalldatetime (4) |  | Date the gambling winnings were won
date_won_override | smalldatetime (4) |  | Override for the date the gambling winnings were won
form_W2G_wager_type_KEY | int (4) |  | Type of wager made
override__form_W2G_wager_type_KEY | int (4) |  | Override to the type of wager made
transaction_description | nvarchar (128) |  | Ticket number, card number, machine serial number, or any other information to identify the winning transaction.
transaction_description_override | nvarchar (128) |  | Override for the ticket number, card number, machine serial number, or any other information to identify the winning transaction.
other_type_of_wager | nvarchar (128) |  | Description of the other type of wager
other_type_of_wager_override | nvarchar (128) |  | Override for the description of the other type of wager
cashier | nvarchar (128) |  | Cashier that paid out the winnings
cashier_override | nvarchar (128) |  | Override for the cashier that paid out the winnings
race | nvarchar (128) |  | Race
race_override | nvarchar (128) |  | Override for the race
first_id | nvarchar (128) |  | First form of ID
first_id_override | nvarchar (128) |  | Override for the first form of ID
window | nvarchar (128) |  | Location of the person paying out the winnings.
window_override | nvarchar (128) |  | Override for the location of the person paying out the winnings.
second_id | nvarchar (128) |  | Second form of ID
second_id_override | nvarchar (128) |  | Override for the second form of ID
date_won_original_override | smalldatetime (4) |  | Original override date won.
original_override__form_W2G_wager_type_KEY | int (4) |  | Original override form w2g wager type.
transaction_description_original_override | nvarchar (128) |  | Original override transaction description.
other_type_of_wager_original_override | nvarchar (128) |  | Original override other type of wager.
cashier_original_override | nvarchar (128) |  | Original override cashier.
race_original_override | nvarchar (128) |  | Original override race.
first_id_original_override | nvarchar (128) |  | Original override first id.
window_original_override | nvarchar (128) |  | Original override window.
second_id_original_override | nvarchar (128) |  | Original override second id.
date_won_corrected_override | smalldatetime (4) |  | Corrected override date won.
corrected_override__form_W2G_wager_type_KEY | int (4) |  | Corrected override form w2g wager type.
transaction_description_corrected_override | nvarchar (128) |  | Corrected override transaction description.
other_type_of_wager_corrected_override | nvarchar (128) |  | Corrected override other type of wager.
cashier_corrected_override | nvarchar (128) |  | Corrected override cashier.
race_corrected_override | nvarchar (128) |  | Corrected override race.
first_id_corrected_override | nvarchar (128) |  | Corrected override first id.
window_corrected_override | nvarchar (128) |  | Corrected override window.
second_id_corrected_override | nvarchar (128) |  | Corrected override second id.

Primary key
Name | Columns | Description
PK_Form_W2G_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_W2G_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Form_W2G_Option__Form_W2G_Wager_Type__corrected_override__form_W2G_wager_type_KEY | corrected_override__form_W2G_wager_type_KEY | Form_W2G_Wager_Type (form_W2G_wager_type_KEY) |
FK_Form_W2G_Option__Form_W2G_Wager_Type__form_W2G_wager_type_KEY | form_W2G_wager_type_KEY | Form_W2G_Wager_Type (form_W2G_wager_type_KEY) |
FK_Form_W2G_Option__Form_W2G_Wager_Type__original_override__form_W2G_wager_type_KEY | original_override__form_W2G_wager_type_KEY | Form_W2G_Wager_Type (form_W2G_wager_type_KEY) |
FK_Form_W2G_Option__Form_W2G_Wager_Type__override__form_W2G_wager_type_KEY | override__form_W2G_wager_type_KEY | Form_W2G_Wager_Type (form_W2G_wager_type_KEY) |