Skip Tracing Transaction UML

Added On: 07/25/12

SQL Table: SKIP_TRACING_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: SkipTracingTransaction

Available Fields:

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

Phone08
Phone09
Phone10
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 Death 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
Social Security Number
State
Street
Suffix
Transaction Code

ZIP Code

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:

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:

Phone10

Added On: 07/25/12

SQL Column: PHONE10

Java Field: phone10

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Response Address City

Added On: 07/29/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/29/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/29/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/29/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/29/12

SQL Column: RESPONSE_ADDRESS_STATE

Java Field: responseAddressState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Address Street

Added On: 07/29/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/29/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/29/12

SQL Column: RESPONSE_ADDRESS_ZIP_CODE

Java Field: responseAddressZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Response Death Date

Added On: 01/09/13

SQL Column: RESPONSE_DEATH_DATE

Java Field: responseDeathDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Response Phone1

Added On: 07/29/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/29/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/29/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/29/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/29/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/29/12

SQL Column: RESPONSE_PHONE1_SUFFIX

Java Field: responsePhone1Suffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Response Phone2

Added On: 07/29/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/29/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/29/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/29/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/29/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/29/12

SQL Column: RESPONSE_PHONE2_SUFFIX

Java Field: responsePhone2Suffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Skip Trace Cl

Added On: 07/29/12

SQL Column: SKIP_TRACE_CL

Java Field: skipTraceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Skip Trace Classifier

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

State

Added On: 07/25/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(2)

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:

Transaction Code

Added On: 07/25/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the initial transaction.

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.