Bank Identification Number

Added On:  03/16/12 

SQL Table:  IAPP_BANK_IDENTIFICATION_NUMBER 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  BankIdentificationNumber 

Available Fields:

• Account Fund Source
• Account Level Processing Indicator
• Address
• Bank Name
• BIN High
• BIN Low
• BIN Update Date
• Card Category
• Card Class

• Card Indicator
• Card Type
• Code
• Country Code
• Create Date
• EBT State
• Is Commercial
• Is FSA
• Is Large Ticket

• Is Out Dated
• Is Prepaid
• Last Update Date
• Network Ids
• PAN Length Max
• PAN Length Min
• Payment Option CL
• Phone Number
• Product Code

• Regulator Indicator
• Visa Product Sub Type

Account Fund Source

Added On:  01/06/15

SQL Column:  ACCOUNT_FUND_SOURCE

Java Field:  accountFundSource

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Source of the funds associated with the primary account for the card.

Account Level Processing Indicator

Added On:  01/06/15

SQL Column:  ACCOUNT_LEVEL_PROCESSING_INDICATOR

Java Field:  accountLevelProcessingIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Indicator that provides information whether account level processing is available for the BIN.

Address

Added On:  03/16/12

SQL Column:  ADDRESS

Java Field:  address

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Address of the issuing bank.

Bank Name

Added On:  03/16/12

SQL Column:  BANK_NAME

Java Field:  bankName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Name of the issuing bank.

BIN High

Added On:  03/16/12

SQL Column:  BIN_HIGH

Java Field:  binHigh

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

The highest BIN value of the BIN range.

BIN Low

Added On:  03/16/12

SQL Column:  BIN_LOW

Java Field:  binLow

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

The lowest BIN value of the BIN range.

BIN Update Date

Added On:  03/16/12

SQL Column:  BIN_UPDATE_DATE

Java Field:  binUpdateDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Update date of the bank identification number.

Card Category

Added On:  03/16/12

SQL Column:  CARD_CATEGORY

Java Field:  cardCategory

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Category of the credit card.

Card Class

Added On:  01/06/15

SQL Column:  CARD_CLASS

Java Field:  cardClass

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Information about card usage (Business, Consumer, Purchase, Corporate).

Card Indicator

Added On:  03/16/12

SQL Column:  CARD_INDICATOR

Java Field:  cardIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Identificator of the card type (credit, debit, prepaid) and its usage (pin, signature etc).

Card Type

Added On:  03/16/12

SQL Column:  CARD_TYPE

Java Field:  cardType

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Type of a credit card.

Code

Added On:  03/16/12

SQL Column:  CODE

Java Field:  code

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Identifier / Primary Key

Attributes: Required

Internal identifier associated with a BIN range that this bank belongs to.

Country Code

Added On:  03/16/12

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Code of the issuing bank's country.

Create Date

Added On:  08/29/16

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the record was created.

EBT State

Added On:  10/22/15

SQL Column:  EBT_STATE

Java Field:  ebtState

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

State that issued the EBT card. Required if card is EBT capable. Information originates from the debit network.

Is Commercial

Added On:  03/16/12

SQL Column:  IS_COMMERCIAL

Java Field:  isCommercial

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether used card is a commercial card.

Is FSA

Added On:  03/16/12

SQL Column:  IS_FSA

Java Field:  isFsa

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether a used card is accociated with a flexible spending account or health spending account.

Is Large Ticket

Added On:  01/06/15

SQL Column:  IS_LARGE_TICKET

Java Field:  isLargeTicket

Status:  Active

SQL Type:  tinyint(1)(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether used card is a large ticket.

Is Out Dated

Added On:  08/29/16

SQL Column:  IS_OUT_DATED

Java Field:  isOutDated

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether BIN is out dated.

Is Prepaid

Added On:  03/16/12

SQL Column:  IS_PREPAID

Java Field:  isPrepaid

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether used card is prepaid.

Last Update Date

Added On:  08/29/16

SQL Column:  LAST_UPDATE_DATE

Java Field:  lastUpdateDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when BIN was updated the last time.

Network Ids

Added On:  03/16/12

SQL Column:  NETWORK_IDS

Java Field:  networkIds

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

List of debit network identifiers that can be used to process PINless debit transactions.

PAN Length Max

Added On:  10/22/15

SQL Column:  PAN_LENGTH_MAX

Java Field:  panLengthMax

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Maximum length of the account number (PAN).

PAN Length Min

Added On:  10/22/15

SQL Column:  PAN_LENGTH_MIN

Java Field:  panLengthMin

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Minimum length of the account number (PAN).

Payment Option CL

Added On:  03/16/12

SQL Column:  PAYMENT_OPTION_CL

Java Field:  paymentOptionCl

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

References Payment Option Classifier

Attributes:

Represents the type of selected payment option.

Phone Number

Added On:  03/16/12

SQL Column:  PHONE_NUMBER

Java Field:  phoneNumber

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Phone number of the issuing bank.

Product Code

Added On:  01/06/15

SQL Column:  PRODUCT_CODE

Java Field:  productCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Code that indicates a sub-category of Visa, MasterCard, Discover and American Express card (Purchase Card, Business Card, etc).

Regulator Indicator

Added On:  01/06/15

SQL Column:  REGULATOR_INDICATOR

Java Field:  regulatorIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Indicates whether the card is regulated by Durbin Amendment.
Applied to the US issued cards only.

Visa Product Sub Type

Added On:  01/06/15

SQL Column:  VISA_PRODUCT_SUB_TYPE

Java Field:  visaProductSubType

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Product sub-types, i.e. further classification of product.