Attachment_C_-_ABARRS_Data_Tables.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- ABARRS Data Subscription Federal contract opportunity
- Solicitation number
- RFQA14065
About this file
Attachment C - ABARRS Data Tables
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| ABARRS_Database_RFQ_Questions_5_29.pdf | ||
| Attachment_B_-_Database_Files__-__ABARRS_Subscription.pdf | ||
| Attachment_A_-_RFQ_A14065.pdf | ||
| Combined_Synopsis_Solicitation_BA_A14065.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
institution
| Attachment C - ABARRS Data Tables | |||
| Column Name | Date_TYPE | Nullable | Comments |
| FIN_ID | NUMBER(8,0) | No | Unique Identifier of the Financial Institution |
| BRANCH_ID | NUMBER(8,0) | No | Unique Identifier of the Branch |
| BANK_NAME | VARCHAR2(600 BYTE) | Yes | Name of the Bank |
| ADDRESS1 | VARCHAR2(150 BYTE) | Yes | Address line 1 |
| ADDRESS2 | VARCHAR2(150 BYTE) | Yes | Address line 2 |
| ADDRESS3 | VARCHAR2(150 BYTE) | Yes | Address line 3 |
| ADDRESS4 | VARCHAR2(150 BYTE) | Yes | Address line 4 |
| ADDRESS5 | VARCHAR2(150 BYTE) | Yes | Address line 5 |
| TOWN | VARCHAR2(70 BYTE) | Yes | City or Town |
| SUB_AREA | VARCHAR2(70 BYTE) | Yes | Sub area name |
| AREA | VARCHAR2(100 BYTE) | Yes | Area/State name |
| ABBR_AREA | VARCHAR2(50 BYTE) | Yes | Abbreviated Area/State name |
| COUNTRY | VARCHAR2(100 BYTE) | Yes | Country |
| POSTAL_CODE | VARCHAR2(40 BYTE) | Yes | Postal Code |
| COUNTRY_ISO_CODE | VARCHAR2(3 BYTE) | Yes | Codes for the names of countries, dependent territories, and special areas of geographical interest based on the ISO 3166 standard |
| TELEPHONE | VARCHAR2(60 BYTE) | Yes | Telephone |
| FAX | VARCHAR2(60 BYTE) | Yes | Fax |
| TELEX | VARCHAR2(50 BYTE) | Yes | Telex Number |
| DATE_LAST_CHANGED | DATE | Yes | Used for auditing purposes on the vendor's side |
| DATE_LAST_INSERTED | DATE | Yes | Used for auditing purposes on the vendor's side |
| HEAD_OFFICE_FLAG | VARCHAR2(1 BYTE) | No | Is this entry the Head Office |
| CODE | VARCHAR2(4000 BYTE) | Yes | Branch Type Code |
| DESCRIPTION | VARCHAR2(4000 BYTE) | Yes | Description of Branch Type Code |
code
| Column Name | Date_TYPE | Nullable | Comments |
| FIN_ID | NUMBER(8,0) | Yes | Unique Identifier of the Financial Institution |
| BRANCH_ID | NUMBER(8,0) | Yes | Unique Identifier of the Branch |
| DEPT_DESC | VARCHAR2(100 BYTE) | Yes | Department Description |
| ABBR_DEPT_DESC | VARCHAR2(30 BYTE) | Yes | Abbreviated Department Description |
| DESCRIPTION | VARCHAR2(100 BYTE) | Yes | Code Description |
| CODE | VARCHAR2(20 BYTE) | Yes | SWIFT/BIC or CHIPS UID Code |
| TEXT_AFTER | VARCHAR2(100 BYTE) | Yes | Text After Code |
| DATE_LAST_CHANGED | DATE | Yes | Date Record Last Changed |
| DATE_LAST_INSERTED | DATE | Yes | Date Record Inserted |
| ABBR_DESCRIPTION | VARCHAR2(30 BYTE) | Yes | Abbreviated Code Description |
| TEXT_BEFORE | VARCHAR2(50 BYTE) | Yes | Text Before Code |
| CODE_TYPE_NAME | VARCHAR2(100 BYTE) | Yes | Identifies Code Type (SWIFT, CHIPS UID) |
branch_type
| Column Name | Date_TYPE | Nullable | Comments |
| RECORD_TYPE | NUMBER(2,0) | Yes | Vendor's identifier code not required or used |
| CODE | VARCHAR2(30 BYTE) | Yes | Provided by the vendor |
| DESCRIPTION | VARCHAR2(100 BYTE) | Yes | Description of Code |
| This is a lookup table based on codes referenced in the other tables. These codes are provided by the vendor. |
File details come from the government source that posted it. Updated .