Table: dbo.Bank
Data about banks is stored here. Bank_View exists and, as of 3004.75.120 limits the columns returned, so columns which should surface on the entity should be added there.
Columns
NameTypeConstraintsDescription
bank_KEYint (4)NOT NULLPrimary key for this table.
bank_namenvarchar (100)NOT NULLName of bank.
routing_numbernvarchar (18)NOT NULLBank routing number
fractional_routing_numbernvarchar (24)NOT NULLBank fractional routing number
commentsnvarchar (-1)Comments about bank.
contact_KEYint (4)NOT NULLKey of contact record associated with the bank.
record_status_KEYint (4)NOT NULLThe status of the Bank record.
is_international_bankbit (1)NOT NULLFlag indicating this is an international bank.
existing_bad_databit (1)NOT NULLExisting bad data for the routing number based on the latest check constraint for the routing number
restrict_bank_client_accessbit (1)NOT NULLThe default value 0 indicates that client access program users can interact with this bank normally 1 means that client access program users will be unable to view details of this bank or select it
Primary key
NameColumnsDescription
PK_Bankbank_KEY
Unique constraints
NameColumnsDescription
UK_Bank$contact_KEYcontact_KEY
UK_Bank$routing_numberrouting_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Bank__Record_Status__record_status_KEYrecord_status_KEYRecord_Status (record_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYTax_Agent_Direct_Deposit_Allocation
FK_Tax_Agent_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYTax_Agent_Direct_Deposit_Allocation
FK_Spreadsheet_Import_Bank_Routing_Number__Bank__bank_KEYbank_KEYSpreadsheet_Import_Bank_Routing_Number
FK_Recorded_Event_Object_N_Bank__Bank__bank_KEYbank_KEYRecorded_Event_Object_N_Bank
FK_Checkbook__Bank__bank_KEYbank_KEYCheckbook
FK_Client_Direct_Deposit__Bank__immediate_destination__bank_KEYimmediate_destination__bank_KEYClient_Direct_Deposit
FK_Client_Direct_Deposit__Bank__originator__bank_KEYoriginator__bank_KEYClient_Direct_Deposit
FK_Vendor_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYVendor_Direct_Deposit_Allocation
FK_Vendor_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYVendor_Direct_Deposit_Allocation
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__bank_KEYbank_KEYDirect_Deposit_Bank_Transaction_Allocation
FK_Direct_Deposit_Bank_Transaction_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYDirect_Deposit_Bank_Transaction_Allocation
FK_Employee_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYEmployee_Direct_Deposit_Allocation
FK_Employee_Direct_Deposit_Allocation__Bank__us_gateway_operator__bank_KEYus_gateway_operator__bank_KEYEmployee_Direct_Deposit_Allocation
FK_Employee_Payroll_Item_Direct_Deposit_Allocation__Bank__bank_KEYbank_KEYEmployee_Payroll_Item_Direct_Deposit_Allocation

Schema diagram