GPBR_PYRAI_PARM

(SQL Table)
Index Back

Payee Parameters RAIS

Payee Parameters RAIS

  • Parent record: EMPLMT_SRCH_GBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: EMPLMT_SRCH_GBL

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 TERMINATION_DT Date(10) DATE NOT NULL Termination Date
    4 GPBR_VAC_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Vacations Amount
    5 GPBR_OVRT_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Overtime Amount
    6 GPBR_OVRT_MONTH Number(2,0) SMALLINT NOT NULL Months of Overtime
    7 GPBR_RAISE_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Raise Salary Amount
    8 GPBR_RAISE_MONTH Number(2,0) SMALLINT NOT NULL Months of Salary Raise
    9 GPBR_OTHER_AMOUNT Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Compensations amount
    10 GPBR_OTHER_MONTH Number(2,0) SMALLINT NOT NULL Months of Other Compensations
    11 GPBR_FGTS_FINE Signed Number(12,2) DECIMAL(10,2) NOT NULL FGTS Fine Amount