Informed Consent

Added On: 08/15/12

SQL Table: INFORMED_CONSENT

Module: UniSell

Type: Entity Status: Active

Java Class: InformedConsent

Available Fields:

Birth Date
Cell Phone
City
Comment
Create Date
Customer Account Code
Driver License Number
Driver License Number Encoded
Email
First Name

Gender CL
Home Phone
Id
Is Existing Customer
Last Name
Lead Source Code
Merchant Account Code
Middle Name
Poster Code
Sales Person Code

Sales Person Number1
Social Security
Social Security Encoded
State
Status CL
Store Number
Street1
Street2
Work Phone
ZIP Code

Birth Date

Added On: 08/15/12

SQL Column: BIRTH_DATE

Java Field: birthDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date of birth of the client.

Cell Phone

Added On: 08/15/12

SQL Column: CELL_PHONE

Java Field: cellPhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Cell phone used to discuss any processing issues.

City

Added On: 08/15/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

City of the mailing address.

Comment

Added On: 08/15/12

SQL Column: COMMENT

Java Field: comment

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Create Date

Added On: 08/15/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Customer Account Code

Added On: 08/15/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Driver License Number

Added On: 08/15/12

SQL Column: DRIVER_LICENSE_NUMBER

Java Field: driverLicenseNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Driver License Number Encoded

Added On: 08/15/12

SQL Column: DRIVER_LICENSE_NUMBER_ENCODED

Java Field: driverLicenseNumberEncoded

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Encoded

Added On: 08/15/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

First Name

Added On: 08/15/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Gender CL

Added On: 08/15/12

SQL Column: GENDER_CL

Java Field: genderCl

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Home Phone

Added On: 08/15/12

SQL Column: HOME_PHONE

Java Field: homePhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 08/15/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Is Existing Customer

Added On: 08/15/12

SQL Column: IS_EXISTING_CUSTOMER

Java Field: isExistingCustomer

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Last Name

Added On: 08/15/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Lead Source Code

Added On: 08/15/12

SQL Column: LEAD_SOURCE_CODE

Java Field: leadSourceCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Merchant Account Code

Added On: 08/15/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: 08/15/12

SQL Column: MIDDLE_NAME

Java Field: middleName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Poster Code

Added On: 08/15/12

SQL Column: POSTER_CODE

Java Field: posterCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Sales Person Code

Added On: 08/15/12

SQL Column: SALES_PERSON_CODE

Java Field: salesPersonCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Sales Person Number1

Added On: 08/15/12

SQL Column: SALES_PERSON_NUMBER1

Java Field: salesPersonNumber1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Social Security

Added On: 08/15/12

SQL Column: SOCIAL_SECURITY

Java Field: socialSecurity

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Social Security Encoded

Added On: 08/15/12

SQL Column: SOCIAL_SECURITY_ENCODED

Java Field: socialSecurityEncoded

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes: Encoded

State

Added On: 08/15/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Status CL

Added On: 08/15/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Store Number

Added On: 08/15/12

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Street1

Added On: 08/15/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Street2

Added On: 08/15/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Work Phone

Added On: 08/15/12

SQL Column: WORK_PHONE

Java Field: workPhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP Code

Added On: 08/15/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP or postal code of the mailing address.