| 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 | ||