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