Skip Tracing History Detail UML


Added On:  07/25/12 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  SkipTracingHistoryDetail 
Added On:  07/25/12
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:  07/25/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  07/25/12
SQL Column:  SKIP_TRACE_CL
Java Field:  skipTraceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the selected type of skip trace.
Added On:  07/25/12
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  MIDDLE_NAME
Java Field:  middleName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  SUFFIX
Java Field:  suffix
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  BIRTH_DATE
Java Field:  birthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of birth of the client.
Added On:  07/25/12
SQL Column:  SOCIAL_SECURITY_NUMBER
Java Field:  socialSecurityNumber
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  07/25/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP or postal code of the mailing address.
Added On:  07/25/12
SQL Column:  PHONE01
Java Field:  phone01
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE02
Java Field:  phone02
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE03
Java Field:  phone03
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE04
Java Field:  phone04
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE05
Java Field:  phone05
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE06
Java Field:  phone06
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE07
Java Field:  phone07
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE08
Java Field:  phone08
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE09
Java Field:  phone09
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  PHONE10
Java Field:  phone10
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_FIRST_NAME
Java Field:  responseAddressFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_LAST_NAME
Java Field:  responseAddressLastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_MIDDLE_NAME
Java Field:  responseAddressMiddleName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_SUFFIX
Java Field:  responseAddressSuffix
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_STREET
Java Field:  responseAddressStreet
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_CITY
Java Field:  responseAddressCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_STATE
Java Field:  responseAddressState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_ADDRESS_ZIP_CODE
Java Field:  responseAddressZipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1
Java Field:  responsePhone1
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1_FIRST_NAME
Java Field:  responsePhone1FirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1_LAST_NAME
Java Field:  responsePhone1LastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1_MIDDLE_NAME
Java Field:  responsePhone1MiddleName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1_SUFFIX
Java Field:  responsePhone1Suffix
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE1_DUAL_NAME
Java Field:  responsePhone1DualName
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2
Java Field:  responsePhone2
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2_FIRST_NAME
Java Field:  responsePhone2FirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2_LAST_NAME
Java Field:  responsePhone2LastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2_MIDDLE_NAME
Java Field:  responsePhone2MiddleName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2_SUFFIX
Java Field:  responsePhone2Suffix
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  RESPONSE_PHONE2_DUAL_NAME
Java Field:  responsePhone2DualName
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Added On:  07/25/12
SQL Column:  CUSTOMER_ACCOUNT_FK
Java Field:  customerAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer Account
Attributes:
Added On:  07/25/12
SQL Column:  SKIP_TRACING_HISTORY_FK
Java Field:  skipTracingHistory
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  07/25/12
SQL Column:  ADDRESS_FK
Java Field:  address
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Address
Attributes:
Reference to the entity that represents address information of the merchant.
Added On:  07/25/12
SQL Column:  PHONE1_FK
Java Field:  phone1
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Phone
Attributes:
Added On:  07/25/12
SQL Column:  PHONE2_FK
Java Field:  phone2
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Phone
Attributes:
Added On:  08/07/12
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  08/07/12
SQL Column:  REFERENCE_NUMBER
Java Field:  referenceNumber
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  08/07/12
SQL Column:  SOURCE_ADDRESS_FK
Java Field:  sourceAddress
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Address
Attributes:
Added On:  01/09/13
SQL Column:  RESPONSE_DECEASED_DATE
Java Field:  responseDeceasedDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes: