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
NameTypeConstraintsDescription
claim_yearsmallint (2)NOT NULLThe 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_KEYtinyint (1)NOT NULLForeign key into Quarter table for the valid period
Primary key
NameColumnsDescription
PK_Valid_7200_Period$claim_year$quarter_KEYclaim_year, quarter_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Valid_7200_Period__Quarter__quarter_KEYquarter_KEYQuarter (quarter_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_7200_Payment_Requested__Valid_7200_Period__claim_year__quarter_KEYclaim_year, quarter_KEYForm_7200_Payment_Requested

Schema diagram