PKG_ADD_CMP_TBL

(SQL Table)
 Index Back

Additional Component Table

Satary Packaging - Additional Components

  • Related Language Record: PKG_ADD_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADD_COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal Package - Additional Component
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %DATE

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 ADD_CMP_TYPE Character(4) VARCHAR2(4) NOT NULL Sal Package - Additional Component Type
    FBT=Fringe Benefits Tax
    GST=Goods & Services Tax
    PRT=Payroll Tax
    7 PACKAGE_LEVEL Character(3) VARCHAR2(3) NOT NULL Sal Package - Package Level
    NIL=No Effect
    TEC=Total Empl Cost
    TPV=Total Pkg Value

    Default Value: TEC

    8 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: PKG_COMP_RCD_VW

    9 FBT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Sal Package - FBT Calculation Type
    1=Type 1 -Tax Credit Claimed
    2=Type 2 -No Input Tax Credit

    Default Value: 1