Home > CompPlan

CompPlan

  • DataSet name: CompPlan
  • Description: Compensation Plan, which contains Pay Grades
  • Last altered in the RedBluff project.

    • CompPlanID Unique identifier for a compensation plan. BigID 12
    CompanyID Company Identifier SmallID 12
    Name Varchar 80
    Notes Comments Text 16000
    StartDate Starting Date SmallDate 32
    StopDate Ending Date Date 32
    SalUnitType Hourly, Daily, Annualizable Enum 1
    ENUM
    AAnnualizable
    DDaily
    HHourly
    ActiveFlag A-Active, I-Inactive Varchar 1
    LstModDate Last Modified Date Date 32
    LstModBy Last Modified By Name Varchar 40
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12