Skip Tracing History Detail UML

Added On: 07/25/12

SQL Table: SKIP_TRACING_HISTORY_DETAIL

Module: UniBill

Type: Entity Status: Active

Java Class: SkipTracingHistoryDetail

Available Fields:

Address FK
Birth Date
City
Customer Account Code
Customer Account FK
First Name
Id
Last Name
Merchant Account Code
Middle Name
Phone01
Phone02
Phone03
Phone04
Phone05
Phone06
Phone07

Phone08
Phone09
Phone1 FK
Phone10
Phone2 FK
Reference Number
Response Address City
Response Address First Name
Response Address Last Name
Response Address Middle Name
Response Address State
Response Address Street
Response Address Suffix
Response Address Zip Code
Response Deceased Date
Response Phone1
Response Phone1 Dual Name

Response Phone1 First Name
Response Phone1 Last Name
Response Phone1 Middle Name
Response Phone1 Suffix
Response Phone2
Response Phone2 Dual Name
Response Phone2 First Name
Response Phone2 Last Name
Response Phone2 Middle Name
Response Phone2 Suffix
Skip Trace CL
Skip Tracing History FK
Social Security Number
Source Address FK
State
Street
Suffix

ZIP Code

Address FK

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.

Birth Date

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.

City

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.

Customer Account Code

Added On: 08/07/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Customer Account FK

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:

First Name

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: 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.

Last Name

Added On: 07/25/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Merchant Account Code

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.

Middle Name

Added On: 07/25/12

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Phone01

Added On: 07/25/12

SQL Column: PHONE01

Java Field: phone01

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone02

Added On: 07/25/12

SQL Column: PHONE02

Java Field: phone02

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone03

Added On: 07/25/12

SQL Column: PHONE03

Java Field: phone03

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone04

Added On: 07/25/12

SQL Column: PHONE04

Java Field: phone04

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone05

Added On: 07/25/12

SQL Column: PHONE05

Java Field: phone05

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone06

Added On: 07/25/12

SQL Column: PHONE06

Java Field: phone06

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone07

Added On: 07/25/12

SQL Column: PHONE07

Java Field: phone07

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone08

Added On: 07/25/12

SQL Column: PHONE08

Java Field: phone08

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone09

Added On: 07/25/12

SQL Column: PHONE09

Java Field: phone09

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone1 FK

Added On: 07/25/12

SQL Column: PHONE1_FK

Java Field: phone1

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Phone

Attributes:

Phone10

Added On: 07/25/12

SQL Column: PHONE10

Java Field: phone10

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone2 FK

Added On: 07/25/12

SQL Column: PHONE2_FK

Java Field: phone2

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Phone

Attributes:

Reference Number

Added On: 08/07/12

SQL Column: REFERENCE_NUMBER

Java Field: referenceNumber

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Response Address City

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_CITY

Java Field: responseAddressCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Address First Name

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_FIRST_NAME

Java Field: responseAddressFirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Address Last Name

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_LAST_NAME

Java Field: responseAddressLastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response Address Middle Name

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_MIDDLE_NAME

Java Field: responseAddressMiddleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Address State

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_STATE

Java Field: responseAddressState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Response Address Street

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_STREET

Java Field: responseAddressStreet

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Response Address Suffix

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_SUFFIX

Java Field: responseAddressSuffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Response Address Zip Code

Added On: 07/25/12

SQL Column: RESPONSE_ADDRESS_ZIP_CODE

Java Field: responseAddressZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Response Deceased Date

Added On: 01/09/13

SQL Column: RESPONSE_DECEASED_DATE

Java Field: responseDeceasedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Response Phone1

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1

Java Field: responsePhone1

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Response Phone1 Dual Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1_DUAL_NAME

Java Field: responsePhone1DualName

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Response Phone1 First Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1_FIRST_NAME

Java Field: responsePhone1FirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Phone1 Last Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1_LAST_NAME

Java Field: responsePhone1LastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response Phone1 Middle Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1_MIDDLE_NAME

Java Field: responsePhone1MiddleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Phone1 Suffix

Added On: 07/25/12

SQL Column: RESPONSE_PHONE1_SUFFIX

Java Field: responsePhone1Suffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Response Phone2

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2

Java Field: responsePhone2

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Response Phone2 Dual Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2_DUAL_NAME

Java Field: responsePhone2DualName

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Response Phone2 First Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2_FIRST_NAME

Java Field: responsePhone2FirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Phone2 Last Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2_LAST_NAME

Java Field: responsePhone2LastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response Phone2 Middle Name

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2_MIDDLE_NAME

Java Field: responsePhone2MiddleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Phone2 Suffix

Added On: 07/25/12

SQL Column: RESPONSE_PHONE2_SUFFIX

Java Field: responsePhone2Suffix

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Skip Trace CL

Added On: 07/25/12

SQL Column: SKIP_TRACE_CL

Java Field: skipTraceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Skip Trace Classifier

Attributes:

Represents the selected type of skip trace.

Skip Tracing History FK

Added On: 07/25/12

SQL Column: SKIP_TRACING_HISTORY_FK

Java Field: skipTracingHistory

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Skip Tracing History

Attributes:

Social Security Number

Added On: 07/25/12

SQL Column: SOCIAL_SECURITY_NUMBER

Java Field: socialSecurityNumber

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Source Address FK

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:

State

Added On: 07/25/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Street

Added On: 07/25/12

SQL Column: STREET

Java Field: street

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Suffix

Added On: 07/25/12

SQL Column: SUFFIX

Java Field: suffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP Code

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.