Onboarding Application UML


Added On:  05/16/16 
SQL Table:  ONBOARDING_APPLICATION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  OnboardingApplication 
Entity that represents main information about onboarding application.
Available Fields:
Added On:  05/16/16
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:  05/16/16
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:  05/16/16
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  05/16/16
SQL Column:  BIRTH_DATE
Java Field:  birthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of birth of the merchant.
Added On:  05/16/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the mailing address.
Added On:  05/16/16
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the mailing address.
Added On:  05/16/16
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the portfolio that this record belongs to.
Added On:  05/16/16
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents current status of the application.
Added On:  05/16/16
SQL Column:  ONBOARDING_AGREEMENT_FK
Java Field:  onboardingAgreement
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents onboard agreement document.
Added On:  05/16/16
SQL Column:  APPLICATION_CODE
Java Field:  applicationCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Secondary identifier which can be used to cross-reference records between UniPay and integrated systems.
Added On:  05/16/16
SQL Column:  SOCIAL_SECURITY
Java Field:  socialSecurity
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Social security number of the merchant.
Added On:  05/16/16
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address used to send any notifications or discuss any processing issues.
Added On:  05/16/16
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP (or postal code) of the mailing address.
Added On:  05/16/16
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the merchant.
Added On:  05/16/16
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 2) of the mailing address.
Added On:  05/16/16
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Phone number used to discuss any occured processing issues.
Added On:  05/16/16
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street (line 1) of the mailing address.
Added On:  05/16/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  05/16/16
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the merchant.
Added On:  05/16/16
SQL Column:  ONBOARDING_BUSINESS_INFO_FK
Java Field:  onboardingBusinessInfo
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents information about business.
Added On:  06/02/16
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the reseller that is referred to the selected account.
Added On:  10/21/16
SQL Column:  TIME_ZONE
Java Field:  timeZone
Status:  Active
SQL Type:  varchar(33)
Java Type:  String
Attributes:
Time zone set for application.
Added On:  10/21/16
SQL Column:  MERCHANT_PROFILE
Java Field:  merchantProfile
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Profile of the merchant that an application is assigned to.
Added On:  10/21/16
SQL Column:  CHANNEL_CODE
Java Field:  channelCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Code of the assigned channel.
Added On:  10/21/16
SQL Column:  MERCHANT_CREATION_POLICY_CL
Java Field:  merchantCreationPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of merchant creation policy values.
Added On:  10/21/16
SQL Column:  PROCESSING_CONFIGURATION_SCRIPT
Java Field:  processingConfigurationScript
Status:  Active
SQL Type:  varchar(63)
Java Type:  String
Attributes:
Code of the processing application configuration.
Added On:  10/21/16
SQL Column:  BILLING_CONFIGURATION_SCRIPT
Java Field:  billingConfigurationScript
Status:  Active
SQL Type:  varchar(63)
Java Type:  String
Attributes:
Code of the billing configuration assigned to the merchant.
Added On:  10/21/16
SQL Column:  NOTIFY_URL
Java Field:  notifyUrl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL used for notifications.
Added On:  10/21/16
SQL Column:  RETURN_URL
Java Field:  returnUrl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL used for returns.
Added On:  10/21/16
SQL Column:  CANCEL_URL
Java Field:  cancelUrl
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
URL used for cancellation.
Added On:  10/27/16
SQL Column:  PROFILE_TYPE
Java Field:  profileType
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Type of the associated merchant's profile.
Added On:  10/27/16
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the associated merchant.
Added On:  10/31/16
SQL Column:  MID_REQUEST_STATUS_CL
Java Field:  midRequestStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible statuses of the request assigned to the merchant identifier.
Added On:  10/31/16
SQL Column:  MID_REQUEST_DATE
Java Field:  midRequestDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Request date assigned to the merchant identifier.
Added On:  10/31/16
SQL Column:  MID_RESPONSE_STATUS_CL
Java Field:  midResponseStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible statuses of the response assigned to the merchant's identifier.
Added On:  10/31/16
SQL Column:  MID_RESPONSE_DATE
Java Field:  midResponseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Response date assigned to the merchant identifier.
Added On:  10/31/16
SQL Column:  MERCHANT_CREATION_STATUS_CL
Java Field:  merchantCreationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of statuses assigned to the merchant creation.
Added On:  10/31/16
SQL Column:  MERCHANT_CREATION_DATE
Java Field:  merchantCreationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the merchant was created.
Added On:  10/31/16
SQL Column:  PROVIDER_PROFILE_CONFIGURATION_STATUS_CL
Java Field:  providerProfileConfigurationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of statuses that provider profile configuration can obtain.
Added On:  10/31/16
SQL Column:  PROVIDER_PROFILE_CONFIGURATION_DATE
Java Field:  providerProfileConfigurationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the provider's profile configuration.
Added On:  10/31/16
SQL Column:  MERCHANT_FEE_CONFIGURATION_STATUS_CL
Java Field:  merchantFeeConfigurationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible statuses of the merchant fee configuration.
Added On:  10/31/16
SQL Column:  MERCHANT_FEE_CONFIGURATION_DATE
Java Field:  merchantFeeConfigurationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when merchant fee profile was configured.
Added On:  10/31/16
SQL Column:  BILLING_CONFIGURATION_STATUS_CL
Java Field:  billingConfigurationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible billing configuration statuses.
Added On:  10/31/16
SQL Column:  BILLING_CONFIGURATION_DATE
Java Field:  billingConfigurationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when billing configuration is done.
Added On:  11/01/16
SQL Column:  MERCHANT_REF_CODE
Java Field:  merchantRefCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Secondary identifier of the merchant/merchant account which can be used for cross-referencing records between the gateway and integrated systems.
Added On:  11/01/16
SQL Column:  MERCHANT_CODE
Java Field:  merchantCode
Status:  Active
SQL Type:  varchar(61)
Java Type:  String
Attributes:
Code of the associated merchant.
Added On:  02/03/17
SQL Column:  DISTRIBUTION_SCHEMA_CODE
Java Field:  distributionSchemaCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Code of the distribution schema associated with the merchant.
Added On:  02/07/17
SQL Column:  NOTIFICATION_POLICY
Java Field:  notificationPolicy
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Policy of how notifications about onboarding process results are delivered to the merchant.
Added On:  03/11/17
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Identifier of the merchant within the gateway.
Added On:  04/21/17
SQL Column:  PROFILE_ID
Java Field:  profileId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Code of the onboarding profile assigned within the system.
Added On:  04/21/17
SQL Column:  ONBOARDING_PROFILE_CODE
Java Field:  onboardingProfileCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Identifier of the processor used for onboarding of the merchants associated with a particular reseller. Assigned to the reseller.
Added On:  05/31/17
SQL Column:  CLIENT_HOST
Java Field:  clientHost
Status:  Active
SQL Type:  varchar(63)
Java Type:  String
Attributes:
IP address associated with API call sent by the merchant.
Added On:  07/17/17
SQL Column:  MERCHANT_TYPE
Java Field:  merchantType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Type of the merchant (Affiliate, Merchant, etc.).
Added On:  08/09/17
SQL Column:  USER_NAME
Java Field:  userName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Name of the user that had submitted the onboarding application.
Added On:  10/05/17
SQL Column:  FTP_ACCESS_CREATION_STATUS_CL
Java Field:  ftpAccessCreationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  Object
Attributes:
Reference to the entity that represents possible creation statuses of the onboarding application.
Added On:  10/05/17
SQL Column:  FTP_ACCESS_CREATION_DATE
Java Field:  ftpAccessCreationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the folder for onboarding had been set up.
Added On:  08/21/17
SQL Column:  LAST_STATUS_UPDATE_DATE
Java Field:  lastStatusUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the onboarding application status was updated the last time.
Added On:  11/22/17
SQL Column:  TERMINALS
Java Field:  terminals
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  11/22/17
SQL Column:  TERMINAL_SETUP
Java Field:  terminalSetup
Status:  Active
SQL Type:  varchar(63)
Java Type:  String
Attributes:
Added On:  05/10/18
SQL Column:  STAKE_PERCENTAGE
Java Field:  stakePercentage
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/30/18
SQL Column:  REQUEST_HOST
Java Field:  requestHost
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  OPERATION_CL
Java Field:  operationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  IS_EMBEDDED
Java Field:  isEmbedded
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  01/30/18
SQL Column:  PAGE_FORMAT
Java Field:  pageFormat
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  RETURN_URL_POLICY
Java Field:  returnUrlPolicy
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  FIELD_LIST_READONLY
Java Field:  fieldListReadonly
Status:  Active
SQL Type:  varchar(1500)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  FIELD_LIST_HIDDEN
Java Field:  fieldListHidden
Status:  Active
SQL Type:  varchar(1500)
Java Type:  String
Attributes:
Added On:  01/30/18
SQL Column:  MERCHANT_FK
Java Field:  merchant
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Merchant
Attributes:
Added On:  01/30/18
SQL Column:  PROCESSING_PROFILE_FK
Java Field:  processingProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/30/18
SQL Column:  PORTFOLIO_FK
Java Field:  portfolio
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Portfolio
Attributes:
Added On:  01/30/18
SQL Column:  RESELLER_FK
Java Field:  reseller
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Reseller
Attributes:
Added On:  03/28/18
SQL Column:  VERIFICATION_PROFILE_FK
Java Field:  verificationProfile
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/23/18
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  10/23/18
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(421)
Java Type:  String
Attributes:
Added On:  10/24/18
SQL Column:  PROVIDER_RESPONSE_CODE
Java Field:  providerResponseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  10/24/18
SQL Column:  PROVIDER_RESPONSE_MESSAGE
Java Field:  providerResponseMessage
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes:
Added On:  10/24/18
SQL Column:  PROVIDER_REFERENCE_NUMBER
Java Field:  providerReferenceNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  12/13/18
SQL Column:  TITLE
Java Field:  title
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  01/10/19
SQL Column:  VERIFICATION_REQUEST_STATUS_CL
Java Field:  verificationRequestStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  01/10/19
SQL Column:  VERIFICATION_REQUEST_DATE
Java Field:  verificationRequestStatusDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  02/21/19
SQL Column:  VERIFICATION_STATUS_CL
Java Field:  verificationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  03/12/19
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(61)
Java Type:  String
Attributes: Transient
Added On:  05/28/19
SQL Column:  ANNUAL_FEE_POLICY
Java Field:  annualFeePolicy
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/10/19
SQL Column:  IS_LEGACY_APPLICATION
Java Field:  isLegacyApplication
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  10/16/18
SQL Column:  ACTION_CL
Java Field:  actionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  10/16/18
SQL Column:  PREV_ONBOARDING_APPLICATION_FK
Java Field:  prevOnboardingApplication
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/16/18
SQL Column:  NEXT_ONBOARDING_APPLICATION_FK
Java Field:  nextOnboardingApplication
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/16/18
SQL Column:  OFFICER_CODE
Java Field:  officerCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  10/16/18
SQL Column:  PROVIDER_OPERATION_CL
Java Field:  providerOperationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  10/16/18
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes: Transient
Added On:  10/16/18
SQL Column:  OWNER_ID
Java Field:  ownerId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes: Transient
Added On:  10/23/18
SQL Column:  VERIFICATION_RESPONSE_STATUS_CL
Java Field:  verificationResponseStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  Object
Attributes:
Added On:  10/23/18
SQL Column:  VERIFICATION_RESPONSE_STATUS_DATE
Java Field:  verificationResponseStatusDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/28/18
SQL Column:  IS_FIELD_UPDATED
Java Field:  isFieldUpdated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Transient
Added On:  11/28/18
SQL Column:  TERMINAL_CONFIGURATION_STATUS_CL
Java Field:  terminalConfigurationStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/28/18
SQL Column:  TERMINAL_CONFIGURATION_DATE
Java Field:  terminalConfigurationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes: