Table: dbo.Valid_7200_Period
This table records the valid year/quarter combinations for form 7200, allowing future legislative changes to be handled via a simple insert.
Columns
Name | Type | Constraints | Description
claim_year | smallint (2) | NOT NULL | The year corresponding to a valid period. Stored as a 16-byte signed integer ( C# Short; SQL SMALLINT ). The preferred name "year" is reserved and instances of Form 7200 are filed to claim a credit advance.
quarter_KEY | tinyint (1) | NOT NULL | Foreign key into Quarter table for the valid period

Primary key
Name | Columns | Description
PK_Valid_7200_Period$claim_year$quarter_KEY | claim_year, quarter_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Valid_7200_Period__Quarter__quarter_KEY | quarter_KEY | Quarter (quarter_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Form_7200_Payment_Requested__Valid_7200_Period__claim_year__quarter_KEY | claim_year, quarter_KEY | Form_7200_Payment_Requested |