Table: dbo.Print_Filing_Instruction
Stores the filing instruction for a particular federal/state/local collation item for a particular processing period.
Columns
Name | Type | Constraints | Description
print_filing_instruction_KEY | int (4) | NOT NULL | Unique value for this filing instruction for a given federal/state/local collation item for a given processing period.
user_session_guid | uniqueidentifier (16) | NOT NULL | The user session for the person printing the forms. We note user session (as opposed to user) because the application allows a user to log in more than once. In turn, this permits a user to print from more than one session at the same time.
client_KEY | int (4) | NOT NULL | Foreign key to client table to indicate which client this filing instruction is for.
tax_form_KEY | int (4) | NOT NULL | Foreign key to tax form table to indicate which collation item this filing instruction is for.
period_end_date | smalldatetime (4) | NOT NULL | Period end date that these filing instruction are for.
penalty_and_interest_due | decimal (9, 2) | NOT NULL | Penalty and interest total for this period for this collation item.
amount_due | decimal (9, 2) | NOT NULL | Amount due for this collation item.
due_date | smalldatetime (4) | NOT NULL | Due date of this collation item.
tax_agent_KEY | int (4) | NOT NULL | Tax agent for this collation item.
tax_agent_form_filing_address_scenario_KEY | int (4) | NOT NULL | Which filing address should be used for this filing instruction
signature_required | bit (1) | NOT NULL | Is a signature required for this collation item?
tax_form_filing_method_KEY | int (4) | NOT NULL | The tax form filing method type of the filing instruction being printed

Primary key
Name | Columns | Description
PK_Print_Filing_Instruction | print_filing_instruction_KEY |
Unique constraints
Name | Columns | Description
UK_Print_Filing_Instruction$client_KEY$tax_form_KEY$user_session_guid$tax_agent_form_filing_address_scenario_KEY | client_KEY, tax_form_KEY, user_session_guid, tax_agent_form_filing_address_scenario_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_Filing_Instruction__Tax_Form_Filing_Method__tax_form_filing_method_KEY | tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK_Print_Filing_Instruction__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Print_Filing_Instruction__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) |
FK_Print_Filing_Instruction__Tax_Agent_Form_Filing_Address_Scenario__tax_agent_form_filing_address_scenario_KEY | tax_agent_form_filing_address_scenario_KEY | Tax_Agent_Form_Filing_Address_Scenario (tax_agent_form_filing_address_scenario_KEY) |
FK_Print_Filing_Instruction__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |