Background Verification Result UML

Added On:  04/02/13 

SQL Table:  IAPP_BACKGROUND_VERIFICATION_RESULT 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  BackgroundVerificationResult 

Available Fields:

• Association Score
• Association Score Description
• Background Check Decision Notes
• Bankruptcy City
• Bankruptcy Company Name
• Bankruptcy Count
• Bankruptcy Filing Date
• Bankruptcy State
• Bankruptcy Street 1
• Bankruptcy Street 2
• Bankruptcy Type
• Bankruptcy ZIP Code
• Business Verification Result FK
• Id
• Is City Verified
• Is DOB Verified
• Is Name Verified
• Is Phone Verified

• Is SSN Verified
• Is State Verified
• Is Street Verified
• Is Tax ID Verified
• Is ZIP Verified
• Last Update Date
• Lien City
• Lien Company Name
• Lien Filing Date
• Lien Released Count
• Lien State
• Lien Street 1
• Lien Street 2
• Lien Type
• Lien Unreleased Count
• Lien Zip Code
• Name Address Phone Association Code
• Name Address Phone Association Description

• Name Address SSN Association Code
• Name Address SSN Association Description
• Name Address Tax ID Association Code
• Name Address Tax ID Association Description
• Risk Indicator 1 Code
• Risk Indicator 1 Description
• Risk Indicator 2 Code
• Risk Indicator 2 Description
• Risk Indicator 3 Code
• Risk Indicator 3 Description
• Risk Indicator 4 Code
• Risk Indicator 4 Description
• Risk Indicator 5 Code
• Risk Indicator 5 Description
• Risk Indicator 6 Code
• Risk Indicator 6 Description
• Score
• Score Description

• Status Code
• Status Description

Association Score

Added On:  04/02/13

SQL Column:  ASSOCIATION_SCORE

Java Field:  associationScore

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

The score characterizing the relationship\association between the principal owner and the company.

Association Score Description

Added On:  04/02/13

SQL Column:  ASSOCIATION_SCORE_DESCRIPTION

Java Field:  associationScoreDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Description of the score characterizing the relationship\association between the principal owner and the company.

Background Check Decision Notes

Added On:  05/07/13

SQL Column:  BACKGROUND_CHECK_DECISION_NOTES

Java Field:  backgroundCheckDecisionNotes

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Bankruptcy City

Added On:  05/07/13

SQL Column:  BANKRUPTCY_CITY

Java Field:  bankruptcyCity

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

City of the bankrupt company's mailing address.

Bankruptcy Company Name

Added On:  05/07/13

SQL Column:  BANKRUPTCY_COMPANY_NAME

Java Field:  bankruptcyCompanyName

Status:  Active

SQL Type:  varchar(120)

Java Type:  String

Attributes:

Name of bankrupt company.

Bankruptcy Count

Added On:  05/07/13

SQL Column:  BANKRUPTCY_COUNT

Java Field:  bankruptcyCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Bankruptcy count for a company.

Bankruptcy Filing Date

Added On:  05/07/13

SQL Column:  BANKRUPTCY_FILING_DATE

Java Field:  bankruptcyFilingDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

The date when the bankruptcy was filed.

Bankruptcy State

Added On:  05/07/13

SQL Column:  BANKRUPTCY_STATE

Java Field:  bankruptcyState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

State code of the bankrupt company's mailing address.

Bankruptcy Street 1

Added On:  05/07/13

SQL Column:  BANKRUPTCY_STREET1

Java Field:  bankruptcyStreet1

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Street1 of the bankrupt company's mailing address.

Bankruptcy Street 2

Added On:  05/07/13

SQL Column:  BANKRUPTCY_STREET2

Java Field:  bankruptcyStreet2

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Street2 of the bankrupt company's mailing address.

Bankruptcy Type

Added On:  05/07/13

SQL Column:  BANKRUPTCY_TYPE

Java Field:  bankruptcyType

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Bankruptcy type.

Bankruptcy ZIP Code

Added On:  05/07/13

SQL Column:  BANKRUPTCY_ZIP_CODE

Java Field:  bankruptcyZipCode

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

ZIP/postal code of the bankrupt company's mailing address.

Business Verification Result FK

Added On:  04/02/13

SQL Column:  BUSINESS_VERIFICATION_RESULT_FK

Java Field:  businessVerificationResult

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Background Verification Result

Attributes:

Reference to the entity that represents business verification results.

Id

Added On:  04/02/13

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Is City Verified

Added On:  04/02/13

SQL Column:  IS_CITY_VERIFIED

Java Field:  isCityVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified city name is really where the person resides (or where the company is located).

Is DOB Verified

Added On:  05/07/13

SQL Column:  IS_DOB_VERIFIED

Java Field:  isDobVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified date of birth is really the date of birth of the person.

Is Name Verified

Added On:  04/02/13

SQL Column:  IS_NAME_VERIFIED

Java Field:  isNameVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified name really belongs to the person under consideration.

Is Phone Verified

Added On:  04/02/13

SQL Column:  IS_PHONE_VERIFIED

Java Field:  isPhoneVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified phone number is really the phone number of the person or company.

Is SSN Verified

Added On:  04/02/13

SQL Column:  IS_SSN_VERIFIED

Java Field:  isSsnVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified social security number is the real social security number of the person.

Is State Verified

Added On:  04/02/13

SQL Column:  IS_STATE_VERIFIED

Java Field:  isStateVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified state name is really where the person resides (or where the company is located).

Is Street Verified

Added On:  04/02/13

SQL Column:  IS_STREET_VERIFIED

Java Field:  isStreetVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified street name is really where the person resides (or where the company is located).

Is Tax ID Verified

Added On:  04/02/13

SQL Column:  IS_TAX_ID_VERIFIED

Java Field:  isTaxIdVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified tax ID is the real tax ID of the company.

Is ZIP Verified

Added On:  04/02/13

SQL Column:  IS_ZIP_VERIFIED

Java Field:  isZipVerified

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Indicates whether it has been possible to verify that the specified ZIP/postal code is the real actual ZIP/postal code of the place where the person resides (or the company is located).

Last Update Date

Added On:  05/10/13

SQL Column:  LAST_UPDATE_DATE

Java Field:  lastUpdateDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

The date when profile was updated the last time.

Lien City

Added On:  05/07/13

SQL Column:  LIEN_CITY

Java Field:  lienCity

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

City in the mailing address of the company with a lien.

Lien Company Name

Added On:  05/07/13

SQL Column:  LIEN_COMPANY_NAME

Java Field:  lienCompanyName

Status:  Active

SQL Type:  varchar(120)

Java Type:  String

Attributes:

Name of the company with a lien.

Lien Filing Date

Added On:  05/07/13

SQL Column:  LIEN_FILING_DATE

Java Field:  lienFilingDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

The date when the lien was filed.

Lien Released Count

Added On:  05/07/13

SQL Column:  LIEN_RELEASED_COUNT

Java Field:  lienReleasedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

The count of property items released to the owner for this lien.

Lien State

Added On:  05/07/13

SQL Column:  LIEN_STATE

Java Field:  lienState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

State code in the mailing address of the company with a lien.

Lien Street 1

Added On:  05/07/13

SQL Column:  LIEN_STREET1

Java Field:  lienStreet1

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Street1 in the mailing address of the company with a lien.

Lien Street 2

Added On:  05/07/13

SQL Column:  LIEN_STREET2

Java Field:  lienStreet2

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Street2 in the mailing address of the company with a lien.

Lien Type

Added On:  05/07/13

SQL Column:  LIEN_TYPE

Java Field:  lienType

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Lien type.

Lien Unreleased Count

Added On:  05/07/13

SQL Column:  LIEN_UNRELEASED_COUNT

Java Field:  lienUnreleasedCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

The count of unreleased property items for this lien.

Lien Zip Code

Added On:  05/07/13

SQL Column:  LIEN_ZIP_CODE

Java Field:  lienZipCode

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Zip code in the mailing address of the company with a lien.

Name Address Phone Association Code

Added On:  04/02/13

SQL Column:  NAME_ADDRESS_PHONE_ASSOCIATION_CODE

Java Field:  nameAddressPhoneAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

A value indicating whether the phone number matches the address that has been indicated for this company.

Name Address Phone Association Description

Added On:  04/29/13

SQL Column:  NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION

Java Field:  nameAddressPhoneAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

A value indicating whether the phone number matches the address that has been indicated for this company.

Name Address SSN Association Code

Added On:  04/02/13

SQL Column:  NAME_ADDRESS_SSN_ASSOCIATION_CODE

Java Field:  nameAddressSsnAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

The value indicating whether the social security number matches the address that has been indicated for this person.

Name Address SSN Association Description

Added On:  04/29/13

SQL Column:  NAME_ADDRESS_SSN_ASSOCIATION_DESCRIPTION

Java Field:  nameAddressSsnAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

The value indicating whether the social security number matches the address that has been indicated for this person.

Name Address Tax ID Association Code

Added On:  04/02/13

SQL Column:  NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE

Java Field:  nameAddressTaxIdAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

A value indicating whether the tax ID matches the address that has been indicated for this company.

Name Address Tax ID Association Description

Added On:  04/29/13

SQL Column:  NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION

Java Field:  nameAddressTaxIdAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

A value indicating whether the tax ID matches the address that has been indicated for this company.

Risk Indicator 1 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR1_CODE

Java Field:  riskIndicator1Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

The code of the risk indicator.

Risk Indicator 1 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR1_DESCRIPTION

Java Field:  riskIndicator1Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Risk indicator description.

Risk Indicator 2 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR2_CODE

Java Field:  riskIndicator2Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Risk Indicator 2 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR2_DESCRIPTION

Java Field:  riskIndicator2Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Risk Indicator 3 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR3_CODE

Java Field:  riskIndicator3Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Risk Indicator 3 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR3_DESCRIPTION

Java Field:  riskIndicator3Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Risk Indicator 4 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR4_CODE

Java Field:  riskIndicator4Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Risk Indicator 4 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR4_DESCRIPTION

Java Field:  riskIndicator4Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Risk Indicator 5 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR5_CODE

Java Field:  riskIndicator5Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Risk Indicator 5 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR5_DESCRIPTION

Java Field:  riskIndicator5Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Risk Indicator 6 Code

Added On:  05/10/13

SQL Column:  RISK_INDICATOR6_CODE

Java Field:  riskIndicator6Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Risk Indicator 6 Description

Added On:  05/10/13

SQL Column:  RISK_INDICATOR6_DESCRIPTION

Java Field:  riskIndicator6Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Score

Added On:  04/02/13

SQL Column:  SCORE

Java Field:  score

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Overall background verification score (10X, where X is an integer value from 0 to 5, and 50 is the highest score with the lowest risk involved).

Score Description

Added On:  04/02/13

SQL Column:  SCORE_DESCRIPTION

Java Field:  scoreDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Description of the overall background verification score.

Status Code

Added On:  07/23/13

SQL Column:  STATUS_CODE

Java Field:  statusCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Status Description

Added On:  07/23/13

SQL Column:  STATUS_DESCRIPTION

Java Field:  statusDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes: