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