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 |