Employee


Added On:  06/01/12 
SQL Table:  EMPLOYEE 
Module:  UniRun 
Type:  Entity  Status:  Active 
Java Class:  Employee 
Represents an employee of the company
Added On:  06/01/12
SQL Column:  BIRTH_DATE
Java Field:  birthDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Employee's date of birth
Added On:  06/01/12
SQL Column:  CELL_PHONE
Java Field:  cellPhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Cell phone of the employee
Added On:  06/01/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
City of employee's mailing address
Added On:  06/01/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:  06/01/12
SQL Column:  DRIVER_LICENSE_NUMBER
Java Field:  driverLicenseNumber
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Encoded
Employee driver's license
Added On:  06/01/12
SQL Column:  DRIVER_LICENSE_NUMBER_MASKED
Java Field:  driverLicenseNumberMasked
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Masked employee's driver's license for display purposes. Shows last 4 digits only, for example: ****0874
Added On:  06/01/12
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email of the employee
Added On:  06/04/12
SQL Column:  EMPLOYEE_RECORD_FK
Java Field:  employeeRecord
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Employee Record
Attributes:
Reference to the currently active or last active record of this employee.
Added On:  06/01/12
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Required
First name of the employee
Added On:  06/01/12
SQL Column:  GENDER_CL
Java Field:  genderCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Gender Classifier
Attributes:
Represents gender of the employee.
Added On:  06/01/12
SQL Column:  HOME_PHONE
Java Field:  homePhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Home phone of the employee
Added On:  06/01/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.
Added On:  06/01/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:1
Indicates whether the record is currently active.
Added On:  06/01/12
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Required, Default:1
Last name of the employee
Added On:  06/01/12
SQL Column:  MAIDEN_NAME
Java Field:  maidenName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Maiden name of the employee
Added On:  06/01/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
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:  06/27/12
SQL Column:  MERCHANT_ACCOUNT_EXTERNAL_CODE
Java Field:  merchantAccountExternalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  06/01/12
SQL Column:  MIDDLE_NAME
Java Field:  middleName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Middle name (or middle initial) of the employee
Added On:  06/02/12
SQL Column:  NOTES
Java Field:  notes
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Notes related to this employee's record
Added On:  06/04/12
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Encoded
Password used for the employee when the access is initially setup.
Added On:  06/04/12
SQL Column:  RACE_CL
Java Field:  raceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Race Classifier
Attributes:
Race of the employee
Added On:  06/02/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
See Reference Code definition for additional information.
Added On:  06/01/12
SQL Column:  SOCIAL_SECURITY
Java Field:  socialSecurity
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Encoded
Social security of the employee
Added On:  06/01/12
SQL Column:  SOCIAL_SECURITY_MASKED
Java Field:  socialSecurityMasked
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes: Encoded
Masked version of the social security for display purposes. Only last 4 digits are visible - XXX-XX-0034
Added On:  06/01/12
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Street1 of employee's mailing address
Added On:  06/01/12
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Street2 of employee's mailing address.
Added On:  06/01/12
SQL Column:  SUFFIX
Java Field:  suffix
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Suffix of the employee
Added On:  06/01/12
SQL Column:  TITLE
Java Field:  title
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Title of the employee
Added On:  06/27/12
SQL Column:  USERNAME
Java Field:  username
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  06/01/12
SQL Column:  WORK_PHONE
Java Field:  workPhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Work phone of the employee
Added On:  06/01/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Zip code of employee's mailing address