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
NameTypeConstraintsDescription
form_7200_payment_requested_KEYint (4)NOT NULLPrimary surrogate key from cdal.Allocate_Unique_Identifier. Since entry order is to be display order, this also is the display sort.
client_KEYint (4)NOT NULLForeign 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_yearsmallint (2)NOT NULLThe year for which the advance payment was requested
quarter_KEYtinyint (1)NOT NULLThe quarter for which the advance payment was requested
amountdecimal (9, 2)NOT NULLThe nonnegative amount of the requested advance payment
notesnvarchar (400)NOT NULLUser entered notes. Empty string if none available.
Primary key
NameColumnsDescription
PK_Form_7200_Payment_Requestedform_7200_payment_requested_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_7200_Payment_Requested__Client_Payroll_Information__client_KEYclient_KEYClient_Payroll_Information (client_KEY)
FK_Form_7200_Payment_Requested__Valid_7200_Period__claim_year__quarter_KEYclaim_year, quarter_KEYValid_7200_Period (claim_year, quarter_KEY)

Schema diagram