Home > EmpBonH

EmpBonH

  • DataSet name: BonusHist
  • Description: Employee Bonus History
  • Last altered in the 1.5 project.

    • EmpUID Employee Unique ID BigID 12
    BonusDate Date of Bonus Award SmallDate 32
    CompanyID Company Identifier SmallID 12
    BonusTypCd Bonus Type Code BigID 12
    AmtPctFlg Amount/Percentage Flag Enum 1
    ENUM
    AAmount
    PPercent
    BonusAmt Bonus Amount Number 22
    BonusFreq Bonus Frequency Enum 1
    ENUM
    YYears'
    QQuarters'
    MMonths'
    PPaycheck(s)
    WWeeks'
    HHours'
    EffectDate Enrollment Effective Date Date 32
    Notes Comments Text 16000
    PctOfPay1 Percentage of Pay Number 22
    Period Period Long 12
    ReviewDate Date of Review SmallDate 32
    LstModDate Last Modified Date Date 32
    LstModBy Last Modified By Name Varchar 40
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12