GPAU_SPT_REBATE

(SQL Table)
Index Back

State Payroll Tax Rebate table

This table holds the rebate amount for any Payee eligable.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPAU_SPT_REBATE Number(9,3) DECIMAL(8,3) NOT NULL State Payroll Tax trainee rebate
5 GPAU_SPT_RBT_SW Character(1) VARCHAR2(1) NOT NULL State Payroll Tax full rebate flag.

Y/N Table Edit

Default Value: N