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. |
bank_KEY | int (4) | NOT NULL | Primary key for this table. |
bank_name | nvarchar (100) | NOT NULL | Name of bank. |
routing_number | nvarchar (18) | NOT NULL | Bank routing number |
fractional_routing_number | nvarchar (24) | NOT NULL | Bank fractional routing number |
comments | nvarchar (-1) | | Comments about bank. |
contact_KEY | int (4) | NOT NULL | Key of contact record associated with the bank. |
record_status_KEY | int (4) | NOT NULL | The status of the Bank record. |
is_international_bank | bit (1) | NOT NULL | Flag indicating this is an international bank. |
existing_bad_data | bit (1) | NOT NULL | Existing bad data for the routing number based on the latest check constraint for the routing number |
restrict_bank_client_access | bit (1) | NOT NULL | The 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 |