User UML


Added On:  03/16/12 
SQL Table:  IAPP_USER 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  User 
Human user that has access to the system.
Added On:  03/16/12
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
See Reference Code definition for additional information.
Added On:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  03/16/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the user account is active within the system.
The value is based on the userStatusCl field value.
Added On:  03/16/12
SQL Column:  USER_NAME
Java Field:  userName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes: Unique, Max Length:150
Username associated with this user account.
Added On:  03/16/12
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Max Length:255
Password associated with this user account.

'Note: 'The passwords are stored as SHA1 hash.''
Added On:  03/16/12
SQL Column:  ROLE
Java Field:  role
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Role Classifier
Attributes: Max Length:1
Role associated with this user account.
Added On:  03/16/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes: Max Length:150
Full name of the user represented by this user account.
Added On:  03/16/12
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Max Length:100
Email associated with this user account.
Added On:  03/16/12
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes: Max Length:15
Phone number associated with this user account.
Added On:  03/16/12
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes: Max Length:60
Unique identifier of the customer, when user is also a customer registered in the system. The value is used to associated the customer with his or her user account.
Added On:  03/16/12
SQL Column:  IS_AGENT_COMMISSION_ALLOWED
Java Field:  isAgentCommissionAllowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the user represented by this user account is allowed to collect commission on collections payments collected by the user.

Commission on collections is either a percentage of a collected payment or a fix fee paid for a payment collection.
Added On:  03/16/12
SQL Column:  DEFAULT_MERCHANT_CODE
Java Field:  defaultMerchantCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the merchant, which used as a default value when merchant selection for this user is required.

The value is often used on UI to initialize some of the forms with default merchant selection.
Added On:  03/16/12
SQL Column:  DEFAULT_MERCHANT_ACCOUNT_CODE
Java Field:  defaultMerchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the merchant account, which used as a default value when merchant account selection for this user is required.

The value is often used on UI to initialize some of the forms with default merchant account selection. The merchant account must belong to the default merchant associated with this user.
Added On:  04/21/12
SQL Column:  PASSWORD_PREVIOUS
Java Field:  passwordPrevious
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Encoded, Max Length:255
Password used by this user before the last password change.

'Note: 'The passwords are stored as SHA1 hash.''
Added On:  04/21/12
SQL Column:  PASSWORD_EXPIRATION_DATE
Java Field:  passwordExpirationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date after which the current password is no longer valid and must be changed. The field is used to enforce strong password policy that requires regular password reset.

Expiration period is controlled by a system property (unipay.system.user-password-expiration-period) and is equal to 90 days by default.
Added On:  08/21/12
SQL Column:  USER_ROLE_FK
Java Field:  userRole
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References User Role
Attributes:
Reference to the entity that indicates the current role of this user.
Added On:  09/18/12
SQL Column:  TITLE
Java Field:  title
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Employee title of the user, where applicable.
Added On:  09/18/12
SQL Column:  DEPARTMENT
Java Field:  department
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Max Length:50
Employee department of the user, where applicable.
Added On:  09/18/12
SQL Column:  EVENING_PHONE
Java Field:  eveningPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes: Max Length:15
Evening phone number associated with this user account.
Added On:  09/18/12
SQL Column:  CELL_PHONE
Java Field:  cellPhone
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes: Max Length:15
Cell phone number associated with this user.
Added On:  09/18/12
SQL Column:  SECURITY_QUESTION
Java Field:  securityQuestion
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Max Length:255
Security question selected by this user for the case when the password is lost.
Added On:  09/18/12
SQL Column:  SECURITY_ANSWER
Java Field:  securityAnswer
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Max Length:255
Security answer to the security question, selected by this user.
Added On:  09/18/12
SQL Column:  SECURITY_LEVEL
Java Field:  securityLevel
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Max Length:30, Default:1
Indicates security level for this user.
Added On:  09/18/12
SQL Column:  NOTES
Java Field:  notes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: Max Length:255
Possible notes concerning this user account.
Added On:  09/18/12
SQL Column:  LICENSE_AGREEMENT_ACCEPTANCE_DATE
Java Field:  licenseAgreementAcceptanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when user accepted the licence agreement.
Added On:  09/18/12
SQL Column:  IP_ADDRESS_ACCESS_LIST
Java Field:  ipAddressAccessList
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes: Max Length:1024
The list of IP addresses from which access to the system is either allowed or denied according to the appropriate value in the IP address access policy classifier.
Added On:  09/18/12
SQL Column:  COUNTRY_CODE_ACCESS_LIST
Java Field:  countryCodeAccessList
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes: Max Length:1024
The list of country codes from which the access to the system is either allowed or denied according to the appropriate value in the country code access policy classifier.
Added On:  09/18/12
SQL Column:  IP_ADDRESS_ACCESS_POLICY_CL
Java Field:  ipAddressAccessPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: Max Length:1
Enumeration of possible allowances of access to the IP address list.
Added On:  09/18/12
SQL Column:  COUNTRY_CODE_ACCESS_POLICY_CL
Java Field:  countryCodeAccessPolicyCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: Max Length:1
Enumeration of possible access allowances to the country codes list.
Added On:  09/18/12
SQL Column:  TIME_ZONE_CODE
Java Field:  timeZoneCode
Status:  Active
SQL Type:  varchar(33)
Java Type:  String
Attributes: Max Length:33
Represents the time zone associated with this user.
Added On:  09/18/12
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes: Max Length:128
Street line 1 of the user's mailing address.
Added On:  09/18/12
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes: Max Length:128
Street line 2 of the user's mailing address.
Added On:  09/18/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Max Length:50
City name of the user's mailing address.
Added On:  09/18/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes: Max Length:3
State of the user's mailing address.
Added On:  09/18/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes: Max Length:15
ZIP code of the user's mailing address.
Added On:  09/18/12
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes: Max Length:2
Country code of the user's mailing address.
Added On:  09/26/12
SQL Column:  FAX
Java Field:  fax
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes: Max Length:15
Fax number associated with this user.
Added On:  10/02/12
SQL Column:  FAILED_LOGIN_COUNT
Java Field:  failedLoginCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of failed login attempts.
Added On:  07/04/13
SQL Column:  FUNCTION_POLICY
Java Field:  functionPolicy
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes: Max Length:20
Regulates function abilities of the user within the system.
Added On:  01/19/14
SQL Column:  PORTFOLIOS_FK
Java Field:  portfolios
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Portfolio
Attributes:
Reference to the entity that represents the portfolio of the user defined for this reseller.
Added On:  01/19/14
SQL Column:  GROUP_FK
Java Field:  group
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References User
Attributes:
Reference to the entity that represents user account.
Added On:  06/05/14
SQL Column:  DEACTIVATION_REASON_CL
Java Field:  deactivationReasonCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: Max Length:1
Enumeration of possible reasons of account deactivation.

There can be 2 reasons:
1. Logon Limit Reached - the account was deactivated due to too many unsuccessful login attempts.
2. Service Terminated - Account was terminated because the service for the merchant, that the user was associated with, was terminated.
Added On:  08/19/14
SQL Column:  TIME_ZONE_SYSTEM_CODE
Java Field:  timeZoneSystemCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of time zone associated with the user.
Added On:  10/16/14
SQL Column:  PERMISSION_MASK
Java Field:  permissionMask
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Permission of the user being masked for secure storage within the system.
Added On:  10/16/14
SQL Column:  ROLE_CODE
Java Field:  roleCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes: Required, Default:C1
Internal identifier of the role associated with a particular user account.
Added On:  12/03/14
SQL Column:  LAST_LOGON_DATE
Java Field:  lastLogonDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the user last time logged in the system.
Added On:  12/09/14
SQL Column:  SECURITY_IMAGE
Java Field:  securityImage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The image that is used by the user to provide better security while logging in the system.
Added On:  01/09/15
SQL Column:  OWNER_CODE
Java Field:  ownerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Internal code of the user.
Added On:  01/09/15
SQL Column:  OWNER_CL
Java Field:  ownerCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References User Classifier
Attributes: Required
Reference to the entity that represents possible types of the owner.
Values can be the following:
S - System
P - Portfolio
R - Reseller
M - Merchant
C - Customer
U - User
F - Fulfillment Center
Added On:  04/28/15
SQL Column:  SECRET_KEY
Java Field:  secretKey
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Authorization key being masked for secure storage within the system used for generation of one-time password.
Added On:  07/13/15
SQL Column:  PRIVILEGES
Java Field:  privileges
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:1
Privileges assigned to the user.
Added On:  07/31/15
SQL Column:  ADDITIONAL_PASSWORD
Java Field:  additionalPassword
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Additional password for this user account.
Added On:  08/02/16
SQL Column:  PASSWORD_NEXT
Java Field:  passwordNext
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Password for this user that will be used after the current password is expired.
Added On:  08/02/16
SQL Column:  PASSWORD_NEXT_CREATE_DATE
Java Field:  passwordNextCreateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the next password was created.
Added On:  08/02/16
SQL Column:  ADDITIONAL_PASSWORD_NEXT
Java Field:  additionalPasswordNext
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Additional password for this user account that will be used after the current additional password is expired.
Added On:  08/31/16
SQL Column:  RESELLERS_FK
Java Field:  resellers
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Reseller
Attributes:
Reference to the entity that represents information about the reseller for this user account.
Added On:  08/31/16
SQL Column:  MERCHANTS_FK
Java Field:  merchants
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Merchant
Attributes:
Reference to the entity that represents information about merchant connected to this user account.
Added On:  06/12/17
SQL Column:  RAW_ACCOUNT_DATA_MODE_CL
Java Field:  rawAccountDataModeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates how the raw account data is handled by the user.
Added On:  02/27/18
SQL Column:  USER_STATUS_CL
Java Field:  userStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  10/04/17
SQL Column:  SETTINGS_CONTENT
Java Field:  settingsContent
Status:  Active
SQL Type:  varchar(4000)
Java Type:  String
Attributes:
Settings set for some user interface components, represented in json format.
Added On:  09/14/17
SQL Column:  AUTHENTICATION_CL
Java Field:  authenticationCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This parameter determine what password allow used "temporary" or "temporary and permanent" for gates and redirects requests
Added On:  12/26/17
SQL Column:  RESPONSE_MESSAGE_DISPLAY_POLICY
Java Field:  responseMessageDisplayPolicy
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/17/18
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Calculated, Default:true
Indicates whether the user account is active within the system.
The value is based on the userStatusCl field value.
Added On:  03/16/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:true
Indicates whether the user account is active within the system.
The value is based on the userStatusCl field value.
Added On:  02/27/18
SQL Column:  USER_STATUS_CL
Java Field:  userStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  USER_NAME
Java Field:  userName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes: Unique, Max Length:150
Username associated with this user account.