Table: dbo.Form_1099_C_Event_Code | |||
Table for identifiable event code options for the 1099-C | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_c_event_code_KEY | tinyint (1) | NOT NULL | Primary Key column |
event_code | nvarchar (2) | NOT NULL | Form 1099-C Identifiable Event Code |
description | nvarchar (120) | NOT NULL | Form 1099-C Identifiable Event Code Description |
starting_year | smallint (2) | NOT NULL | Form 1099-C starting year as CCYY |
ending_year | smallint (2) | Form 1099-C ending year as CCYY. NULL indicates still active code |
Primary key | |||
Name | Columns | Description | |
PK_Form_1099_C_Event_Code | form_1099_c_event_code_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Form_1099_C_Event_Code$description | description |