PKG_BSE_CMP_TBL

(SQL Table)
Index Back

Packaging Component Table

Salary Packaging - Component Table

  • Related Language Record: PKG_BSE_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal package - Package 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 COMPONENT_TYPE Character(4) VARCHAR2(4) NOT NULL Sal Package - Component Type
    AMT=Flat Amount
    FAIR=Airline
    FBRD=Board
    FENT=Tax-exempt Body Entertainment
    FEXP=Expenses
    FHSG=Housing
    FLAA=Living Away From Home Allowanc
    FLOA=Loan
    FPRK=Car Parking
    FPTY=Property
    FRSD=Residual
    FVEH=Motor Vehicle
    FWVR=Debt Waiver
    HOM=Home Office Lease
    PCT=Pct of Contributing Components
    PCTB=Percentage of Benefits Base

    Default Value: AMT

    7 CALC_STARTING_PT Character(1) VARCHAR2(1) NOT NULL Sal package
    N=None
    T=Total Package Value

    Default Value: N

    8 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: TPV

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

    Prompt Table: PKG_COMP_RCD_VW

    10 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 PROJECTION_TYPE Character(1) VARCHAR2(1) NOT NULL Sal Package - Projection Calculation Type
    A=Ad Hoc
    B=Budget
    R=Regular

    Default Value: R

    12 ENROL_BENEF_BASE Character(1) VARCHAR2(1) NOT NULL Sal Package - Enrol Benefits Base

    Y/N Table Edit

    13 BEN_BSE_COMPRATECD Character(6) VARCHAR2(6) NOT NULL Benefit Base Comp Rate Code

    Prompt Table: PKG_COMP_RCD_VW