Added On: 06/04/12
Module: UniRun
Type: Entity
Status: Active
Java Class: EmployeeRecord
Groups employee related information associated with his or her current employment in the company. If an employee is hired more than once, he or she will have multiple employment records associated with him or her.
Added On: 06/04/12
SQL Column: ADDITIONAL_WITHHOLDING_AMOUNT
Java Field: additionalWithholdingAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Additional amount of tax to withhold in federal income taxes
Added On: 06/04/12
SQL Column: ADDITIONAL_WITHHOLDING_AMOUNT_KS
Java Field: additionalWithholdingAmountKS
Status: Active
SQL Type: int(11)
Java Type: Integer
Additional amount of tax to withhold in Kansas state income taxes
Added On: 06/04/12
SQL Column: ALIEN_NUMBER
Java Field: alienNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
Alient Number (if any) assigned to the employee
Added On: 06/04/12
SQL Column: ALIENT_STATUS_EXPIRATION_DATE
Java Field: alientStatusExpirationDate
Status: Active
SQL Type: date
Java Type: Date
Date when the currently assign alien status of the employee expires
Added On: 06/04/12
SQL Column: ALLOWANCE_RATE_CL
Java Field: allowanceRateCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Allowance rate to this on federal income tax return
Added On: 06/04/12
SQL Column: ALLOWANCE_RATE_CL_KS
Java Field: allowanceRateClKS
Status: Active
SQL Type: varchar(1)
Java Type: String
Allowance rate to use for Kansas income tax
Added On: 06/04/12
SQL Column: ALLOWANCES_COUNT
Java Field: allowancesCount
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of allowance to claim for federal income tax
Added On: 06/04/12
SQL Column: ALLOWANCES_COUNT_KS
Java Field: allowancesCountKS
Status: Active
SQL Type: int(11)
Java Type: Integer
Number of allowance to claim for Kansas state income tax
Added On: 06/27/12
SQL Column: BENEFITS_POLICY_CL
Java Field:
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 06/04/12
SQL Column: CREATE_DATE
Java Field: createDate
Status: Active
SQL Type: datetime
Java Type: Date
Date when the record was created
Added On: 06/27/12
SQL Column: CREATOR_CODE
Java Field: creatorCode
Status: Active
SQL Type: varchar(60)
Java Type: String
Added On: 06/27/12
SQL Column: CREATOR_EXTERNAL_CODE
Java Field: creatorExternalCode
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 06/04/12
SQL Column: DOCUMENT_EXPIRATION_DATE_A
Java Field: documentExpirationDateA
Status: Active
SQL Type: date
Java Type: Date
Expiration Date of the Group A document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_EXPIRATION_DATE_AS
Java Field: documentExpirationDateAS
Status: Active
SQL Type: date
Java Type: Date
Expiration Date of the Group A supplementary (visa) document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_EXPIRATION_DATE_B
Java Field: documentExpirationDateB
Status: Active
SQL Type: date
Java Type: Date
Expiration Date of the Group B document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_EXPIRATION_DATE_C
Java Field: documentExpirationDateC
Status: Active
SQL Type: date
Java Type: Date
Expiration Date of the Group C document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_NUMBER_A
Java Field: documentNumberA
Status: Active
SQL Type: varchar(40)
Java Type: String
Number of the Group A document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_NUMBER_AS
Java Field: documentNumberAs
Status: Active
SQL Type: varchar(40)
Java Type: String
Number of the Group A supplementary (visa) document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_NUMBER_B
Java Field: documentNumberB
Status: Active
SQL Type: varchar(40)
Java Type: String
Number of the Group B document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: DOCUMENT_NUMBER_C
Java Field: documentNumberC
Status: Active
SQL Type: varchar(40)
Java Type: String
Number of the Group C document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: EMPLOYEE_FK
Java Field: employeeFk
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to an employee, who is the owner of this account.
Added On: 06/04/12
SQL Column: EMPLOYMENT_STATE
Java Field: employmentState
Status: Active
SQL Type: varchar(2)
Java Type: String
State of the employee's employment (place where the employee works)
Added On: 06/01/12
SQL Column: HIRE_DATE
Java Field: hireDate
Status: Active
SQL Type: date
Java Type: Date
Date when the employee began to work
Added On: 06/04/12
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On: 05/07/13
SQL Column: INTEGRATION_ACTION_CL
Java Field: integrationActionCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 06/04/12
SQL Column: IS_ACTIVE
Java Field: isActive
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Indicates whether the record is currently active.
Added On: 06/04/12
SQL Column: IS_LAST_NAME_DIFFERENT_ON_SOCIAL_SECURITY
Java Field: isLastNameDifferentOnSocialSecurity
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Indicates whether current last name of the employee is different from the one he or she has on the social security card (e.g. because of the name change)
Added On: 06/04/12
SQL Column: IS_WITHHOLDING_EXEMPT
Java Field: isWithholdingExempt
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Indicates whether the employee is exempt from the federal income tax
Added On: 06/04/12
SQL Column: IS_WITHHOLDING_EXEMPT_KS
Java Field: isWithholdingExemptKS
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Indicates whether the employee is exempt from the Kansas state income tax
Added On: 06/04/12
SQL Column: ISSUING_AUTHORITY_A
Java Field: issuingAuthorityA
Status: Active
SQL Type: varchar(255)
Java Type: String
Name of the issuing authority for Group A document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: ISSUING_AUTHORITY_B
Java Field: issuingAuthorityB
Status: Active
SQL Type: varchar(255)
Java Type: String
Name of the issuing authority for Group B document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: ISSUING_AUTHORITY_C
Java Field: issuingAuthorityC
Status: Active
SQL Type: varchar(255)
Java Type: String
Name of the issuing authority for Group C document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: LEGAL_DOCUMENT_CL_A
Java Field: legalDocumentClA
Status: Active
SQL Type: varchar(3)
Java Type: String
Type of Group A legal document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: LEGAL_DOCUMENT_CL_B
Java Field: legalDocumentClB
Status: Active
SQL Type: varchar(3)
Java Type: String
Type of Group B legal document used for employment eligibility verification (I-9)
Added On: 06/04/12
SQL Column: LEGAL_DOCUMENT_CL_C
Java Field: legalDocumentClC
Status: Active
SQL Type: varchar(3)
Java Type: String
Type of Group C legal document used for employment eligibility verification (I-9)
Added On: 06/02/12
SQL Column: LEGAL_STATUS_CL
Java Field: legalStatusCl
Status: Active
SQL Type: varchar(2)
Java Type: String
Legal status of the employee in the country of employment.
Added On: 06/04/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: 03/30/14
SQL Column: PAYMENT_CL
Java Field: paymentCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 03/30/14
SQL Column: PAYMENT_RATE
Java Field: paymentRate
Status: Active
SQL Type: int(11)
Java Type: Integer
The rate of the payment given to the employee for the work.
Added On: 06/27/12
SQL Column: POSITION
Java Field: position
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 06/04/12
SQL Column: STATUS_CL
Java Field: statusCl
Status: Active
SQL Type: varchar(1)
Java Type: String
Attributes:
Required, Default:I
Current status of the account
Added On: 06/04/12
SQL Column: TERMINATION_DATE
Java Field: terminationDate
Status: Active
SQL Type: date
Java Type: Date
Date when an employee is terminated
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_A
Java Field: worksheetK4PersonalAllowancesA
Status: Active
SQL Type: varchar(6)
Java Type: String
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_B
Java Field: worksheetK4PersonalAllowancesB
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_C
Java Field: worksheetK4PersonalAllowancesC
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_D
Java Field: worksheetK4PersonalAllowancesD
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_E
Java Field: worksheetK4PersonalAllowancesE
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_F
Java Field: worksheetK4PersonalAllowancesF
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_K4_PERSONAL_ALLOWANCES_G
Java Field: worksheetK4PersonalAllowancesG
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS01
Java Field: worksheetW4DeductionsAndAdjustments01
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS02
Java Field: worksheetW4DeductionsAndAdjustments02
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS03
Java Field: worksheetW4DeductionsAndAdjustments03
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS04
Java Field: worksheetW4DeductionsAndAdjustments04
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS05
Java Field: worksheetW4DeductionsAndAdjustments05
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS06
Java Field: worksheetW4DeductionsAndAdjustments06
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS07
Java Field: worksheetW4DeductionsAndAdjustments07
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS08
Java Field: worksheetW4DeductionsAndAdjustments08
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS09
Java Field: worksheetW4DeductionsAndAdjustments09
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_DEDUCTIONS_AND_ADJUSTMENTS10
Java Field: worksheetW4DeductionsAndAdjustments10
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_A
Java Field: worksheetW4PersonalAllowancesA
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_B
Java Field: worksheetW4PersonalAllowancesB
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_C
Java Field: worksheetW4PersonalAllowancesC
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_D
Java Field: worksheetW4PersonalAllowancesD
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_E
Java Field: worksheetW4PersonalAllowancesE
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_F
Java Field: worksheetW4PersonalAllowancesF
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_G
Java Field: worksheetW4PersonalAllowancesG
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_H
Java Field: worksheetW4PersonalAllowancesH
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 07/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_H1
Java Field: worksheetW4PersonalAllowancesH1
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Added On: 07/27/12
SQL Column: WORKSHEET_W4_PERSONAL_ALLOWANCES_H2
Java Field: worksheetW4PersonalAllowancesH2
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS00
Java Field: worksheetW4TwoEarnersMultipleJobs00
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS01
Java Field: worksheetW4TwoEarnersMultipleJobs01
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS02
Java Field: worksheetW4TwoEarnersMultipleJobs02
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS03
Java Field: worksheetW4TwoEarnersMultipleJobs03
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS04
Java Field: worksheetW4TwoEarnersMultipleJobs04
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS05
Java Field: worksheetW4TwoEarnersMultipleJobs05
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS06
Java Field: worksheetW4TwoEarnersMultipleJobs06
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS07
Java Field: worksheetW4TwoEarnersMultipleJobs07
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS08
Java Field: worksheetW4TwoEarnersMultipleJobs08
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09
Java Field: worksheetW4TwoEarnersMultipleJobs09
Status: Active
SQL Type: int(11)
Java Type: Integer
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09_A
Java Field: worksheetW4TwoEarnersMultipleJobs09_A
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 06/27/12
SQL Column: WORKSHEET_W4_TWO_EARNERS_MULTIPLE_JOBS09_B
Java Field: worksheetW4TwoEarnersMultipleJobs09_B
Status: Active
SQL Type: int(11)
Java Type: Integer