Table: dbo.Form_7200_Payment_Requested
This table stores the payments requested (possibly multiple payments per quarter) by means of filing form 7200 during any valid period. Form 7200 was introduced related to the advance payment for COVID-19 relief.
Columns
Name | Type | Constraints | Description
form_7200_payment_requested_KEY | int (4) | NOT NULL | Primary surrogate key from cdal.Allocate_Unique_Identifier. Since entry order is to be display order, this also is the display sort.
client_KEY | int (4) | NOT NULL | Foreign key onto the owning client. Goes to Client_Payroll_Information to ensure we do not have such entries for clients without the payroll service.
claim_year | smallint (2) | NOT NULL | The year for which the advance payment was requested
quarter_KEY | tinyint (1) | NOT NULL | The quarter for which the advance payment was requested
amount | decimal (9, 2) | NOT NULL | The nonnegative amount of the requested advance payment
notes | nvarchar (400) | NOT NULL | User entered notes. Empty string if none available.

Primary key
Name | Columns | Description
PK_Form_7200_Payment_Requested | form_7200_payment_requested_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_7200_Payment_Requested__Client_Payroll_Information__client_KEY | client_KEY | Client_Payroll_Information (client_KEY) |
FK_Form_7200_Payment_Requested__Valid_7200_Period__claim_year__quarter_KEY | claim_year, quarter_KEY | Valid_7200_Period (claim_year, quarter_KEY) |