Ln Skip Tracing Transaction UML

Added On: 07/29/12

SQL Table: LN_SKIP_TRACING_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: LnSkipTracingTransaction

Available Fields:

Account Number
Address
Best Address1
Best City1
Best Date First1
Best Date Last1
Best DOD
Best First1
Best Last1
Best Middle1
Best State1
Best Suffix1
Best Zipcode1
City
Dob
First Name
Id
Last Name

Match Type
Merchant Account Code
Middle Name
Phone1
Phone10
Phone2
Phone3
Phone4
Phone5
Phone6
Phone7
Phone8
Phone9
Process Code
Skip Tracing Transaction FK
SSN
State
Subj Date First1

Subj Date First2
Subj Date Last1
Subj Date Last2
Subj First1
Subj First2
Subj Last1
Subj Last2
Subj Middle1
Subj Middle2
Subj Name Dual1
Subj Name Dual2
Subj Phone Type1
Subj Phone Type2
Subj Phone10_1
Subj Phone10_2
Subj Suffix1
Subj Suffix2
Suffix

Account Number

Added On: 07/29/12

SQL Column: ACCOUNT_NUMBER

Java Field: accountNumber

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

When Tokenization is not available and encryption is allowed on the server, the field contains encrypted credit card number or bank account number.
Note: if encryption is not allowed on the server and tokenization is not properly configured, transactions will fail and will not be either processed or persisted.

Address

Added On: 07/29/12

SQL Column: ADDRESS

Java Field: address

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Best Address1

Added On: 07/29/12

SQL Column: BEST_ADDRESS1

Java Field: bestAddress1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Best City1

Added On: 07/29/12

SQL Column: BEST_CITY1

Java Field: bestCity1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Best Date First1

Added On: 07/29/12

SQL Column: BEST_DATE_FIRST1

Java Field: bestDateFirst1

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Best Date Last1

Added On: 07/29/12

SQL Column: BEST_DATE_LAST1

Java Field: bestDateLast1

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Best DOD

Added On: 01/09/13

SQL Column: BEST_DOD

Java Field: bestDod

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Best First1

Added On: 07/29/12

SQL Column: BEST_FIRST1

Java Field: bestFirst1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Best Last1

Added On: 07/29/12

SQL Column: BEST_LAST1

Java Field: bestLast1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Best Middle1

Added On: 07/29/12

SQL Column: BEST_MIDDLE1

Java Field: bestMiddle1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Best State1

Added On: 07/29/12

SQL Column: BEST_STATE1

Java Field: bestState1

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Best Suffix1

Added On: 07/29/12

SQL Column: BEST_SUFFIX1

Java Field: bestSuffix1

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Best Zipcode1

Added On: 07/29/12

SQL Column: BEST_ZIPCODE1

Java Field: bestZipcode1

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

City

Added On: 07/29/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City of the mailing address.

Dob

Added On: 07/29/12

SQL Column: DOB

Java Field: dob

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

First Name

Added On: 07/29/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

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

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Match Type

Added On: 07/29/12

SQL Column: MATCH_TYPE

Java Field: matchType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Merchant Account Code

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

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Phone1

Added On: 07/29/12

SQL Column: PHONE1

Java Field: phone1

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone10

Added On: 07/29/12

SQL Column: PHONE10

Java Field: phone10

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone2

Added On: 07/29/12

SQL Column: PHONE2

Java Field: phone2

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone3

Added On: 07/29/12

SQL Column: PHONE3

Java Field: phone3

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone4

Added On: 07/29/12

SQL Column: PHONE4

Java Field: phone4

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone5

Added On: 07/29/12

SQL Column: PHONE5

Java Field: phone5

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone6

Added On: 07/29/12

SQL Column: PHONE6

Java Field: phone6

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone7

Added On: 07/29/12

SQL Column: PHONE7

Java Field: phone7

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone8

Added On: 07/29/12

SQL Column: PHONE8

Java Field: phone8

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone9

Added On: 07/29/12

SQL Column: PHONE9

Java Field: phone9

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Process Code

Added On: 07/29/12

SQL Column: PROCESS_CODE

Java Field: processCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Skip Tracing Transaction FK

Added On: 07/29/12

SQL Column: SKIP_TRACING_TRANSACTION_FK

Java Field: skipTracingTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Skip Tracing Transaction

Attributes:

SSN

Added On: 06/14/16

SQL Column:

Java Field: ssn

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

State

Added On: 07/29/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Subj Date First1

Added On: 07/29/12

SQL Column: SUBJ_DATE_FIRST1

Java Field: subjDateFirst1

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Subj Date First2

Added On: 07/29/12

SQL Column: SUBJ_DATE_FIRST2

Java Field: subjDateFirst2

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Subj Date Last1

Added On: 07/29/12

SQL Column: SUBJ_DATE_LAST1

Java Field: subjDateLast1

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Subj Date Last2

Added On: 07/29/12

SQL Column: SUBJ_DATE_LAST2

Java Field: subjDateLast2

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Subj First1

Added On: 07/29/12

SQL Column: SUBJ_FIRST1

Java Field: subjFirst1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Subj First2

Added On: 07/29/12

SQL Column: SUBJ_FIRST2

Java Field: subjFirst2

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Subj Last1

Added On: 07/29/12

SQL Column: SUBJ_LAST1

Java Field: subjLast1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Subj Last2

Added On: 07/29/12

SQL Column: SUBJ_LAST2

Java Field: subjLast2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Subj Middle1

Added On: 07/29/12

SQL Column: SUBJ_MIDDLE1

Java Field: subjMiddle1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Subj Middle2

Added On: 07/29/12

SQL Column: SUBJ_MIDDLE2

Java Field: subjMiddle2

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Subj Name Dual1

Added On: 07/29/12

SQL Column: SUBJ_NAME_DUAL1

Java Field: subjNameDual1

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Subj Name Dual2

Added On: 07/29/12

SQL Column: SUBJ_NAME_DUAL2

Java Field: subjNameDual2

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Subj Phone Type1

Added On: 07/29/12

SQL Column: SUBJ_PHONE_TYPE1

Java Field: subjPhoneType1

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Subj Phone Type2

Added On: 07/29/12

SQL Column: SUBJ_PHONE_TYPE2

Java Field: subjPhoneType2

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Subj Phone10_1

Added On: 07/29/12

SQL Column: SUBJ_PHONE10_1

Java Field: subjPhone10_1

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Subj Phone10_2

Added On: 07/29/12

SQL Column: SUBJ_PHONE10_2

Java Field: subjPhone10_2

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Subj Suffix1

Added On: 07/29/12

SQL Column: SUBJ_SUFFIX1

Java Field: subjSuffix1

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Subj Suffix2

Added On: 07/29/12

SQL Column: SUBJ_SUFFIX2

Java Field: subjSuffix2

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Suffix

Added On: 07/29/12

SQL Column: SUFFIX

Java Field: suffix

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP

Added On: 07/29/12

SQL Column: ZIP

Java Field: zip

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP or postal code of the mailing address.