Background Verification Result UML


Added On:  04/02/13 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  BackgroundVerificationResult 
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.
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).
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.
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.
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.
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.
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.
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).
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).
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).
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).
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.
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.
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.
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.
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.
Added On:  04/02/13
SQL Column:  BUSINESS_VERIFICATION_RESULT_FK
Java Field:  businessVerificationResult
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents business verification results.
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.
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.
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.
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.
Added On:  05/07/13
SQL Column:  BACKGROUND_CHECK_DECISION_NOTES
Java Field:  backgroundCheckDecisionNotes
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/07/13
SQL Column:  BANKRUPTCY_TYPE
Java Field:  bankruptcyType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Bankruptcy type.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  05/07/13
SQL Column:  LIEN_TYPE
Java Field:  lienType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Lien type.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  05/10/13
SQL Column:  RISK_INDICATOR2_CODE
Java Field:  riskIndicator2Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR2_DESCRIPTION
Java Field:  riskIndicator2Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR3_CODE
Java Field:  riskIndicator3Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR3_DESCRIPTION
Java Field:  riskIndicator3Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR4_CODE
Java Field:  riskIndicator4Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR4_DESCRIPTION
Java Field:  riskIndicator4Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR5_CODE
Java Field:  riskIndicator5Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR5_DESCRIPTION
Java Field:  riskIndicator5Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR6_CODE
Java Field:  riskIndicator6Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  RISK_INDICATOR6_DESCRIPTION
Java Field:  riskIndicator6Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
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.
Added On:  07/23/13
SQL Column:  STATUS_CODE
Java Field:  statusCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  STATUS_DESCRIPTION
Java Field:  statusDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes: