Table: dbo.Form_W2G_Option
Table to set various options on the W-2G form.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key into the Form_1099 table
date_wonsmalldatetime (4)Date the gambling winnings were won
date_won_overridesmalldatetime (4)Override for the date the gambling winnings were won
form_W2G_wager_type_KEYint (4)Type of wager made
override__form_W2G_wager_type_KEYint (4)Override to the type of wager made
transaction_descriptionnvarchar (128)Ticket number, card number, machine serial number, or any other information to identify the winning transaction.
transaction_description_overridenvarchar (128)Override for the ticket number, card number, machine serial number, or any other information to identify the winning transaction.
other_type_of_wagernvarchar (128)Description of the other type of wager
other_type_of_wager_overridenvarchar (128)Override for the description of the other type of wager
cashiernvarchar (128)Cashier that paid out the winnings
cashier_overridenvarchar (128)Override for the cashier that paid out the winnings
racenvarchar (128)Race
race_overridenvarchar (128)Override for the race
first_idnvarchar (128)First form of ID
first_id_overridenvarchar (128)Override for the first form of ID
windownvarchar (128)Location of the person paying out the winnings.
window_overridenvarchar (128)Override for the location of the person paying out the winnings.
second_idnvarchar (128)Second form of ID
second_id_overridenvarchar (128)Override for the second form of ID
date_won_original_overridesmalldatetime (4)Original override date won.
original_override__form_W2G_wager_type_KEYint (4)Original override form w2g wager type.
transaction_description_original_overridenvarchar (128)Original override transaction description.
other_type_of_wager_original_overridenvarchar (128)Original override other type of wager.
cashier_original_overridenvarchar (128)Original override cashier.
race_original_overridenvarchar (128)Original override race.
first_id_original_overridenvarchar (128)Original override first id.
window_original_overridenvarchar (128)Original override window.
second_id_original_overridenvarchar (128)Original override second id.
date_won_corrected_overridesmalldatetime (4)Corrected override date won.
corrected_override__form_W2G_wager_type_KEYint (4)Corrected override form w2g wager type.
transaction_description_corrected_overridenvarchar (128)Corrected override transaction description.
other_type_of_wager_corrected_overridenvarchar (128)Corrected override other type of wager.
cashier_corrected_overridenvarchar (128)Corrected override cashier.
race_corrected_overridenvarchar (128)Corrected override race.
first_id_corrected_overridenvarchar (128)Corrected override first id.
window_corrected_overridenvarchar (128)Corrected override window.
second_id_corrected_overridenvarchar (128)Corrected override second id.
Primary key
NameColumnsDescription
PK_Form_W2G_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_W2G_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_W2G_Option__Form_W2G_Wager_Type__corrected_override__form_W2G_wager_type_KEYcorrected_override__form_W2G_wager_type_KEYForm_W2G_Wager_Type (form_W2G_wager_type_KEY)
FK_Form_W2G_Option__Form_W2G_Wager_Type__form_W2G_wager_type_KEYform_W2G_wager_type_KEYForm_W2G_Wager_Type (form_W2G_wager_type_KEY)
FK_Form_W2G_Option__Form_W2G_Wager_Type__original_override__form_W2G_wager_type_KEYoriginal_override__form_W2G_wager_type_KEYForm_W2G_Wager_Type (form_W2G_wager_type_KEY)
FK_Form_W2G_Option__Form_W2G_Wager_Type__override__form_W2G_wager_type_KEYoverride__form_W2G_wager_type_KEYForm_W2G_Wager_Type (form_W2G_wager_type_KEY)

Schema diagram