GPJP_IT_WH_REG2

(SQL Table)
Index Back

Detail WithholdingTax Register

Contains Detail Withholding Tax Register data for each employee. There can be many rows per employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 GPJP_IT_WH_TYPE Character(2) VARCHAR2(2) NOT NULL Tracks whether a row of data in GPJP_IT_WH_REG2 is for a salary or bonus run
10=Salary Detail
20=Bonus Detail
6 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
7 PYMT_DT Date(10) DATE Payment Date
8 GPJP_IT_EARNS Number(19,6) DECIMAL(18,6) NOT NULL Amount Of Earnings.
9 GPJP_IT_TXBLE Number(19,6) DECIMAL(18,6) NOT NULL Tracks taxable income
10 GPJP_SC_PREM Number(19,6) DECIMAL(18,6) NOT NULL SI by Reporting + Mutual Aid
11 GPJP_IT_INCTAX Number(19,6) DECIMAL(18,6) NOT NULL Amount Of Withholding Tax.
12 GPJP_IT_TAXDIFF Number(19,6) DECIMAL(18,6) NOT NULL Income Tax Difference
13 GPJP_IT_WRKDAYS Number(5,1) DECIMAL(4,1) NOT NULL Fixed number of workdays.
14 GPJP_IT_HOLHRS Number(5,1) DECIMAL(4,1) NOT NULL Holiday Hours
15 GPJP_IT_HRSERN Number(7,2) DECIMAL(6,2) NOT NULL Fixed Working Hours
16 OT_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Overtime Hours
17 GPJP_IT_LTOTHRS Number(7,2) DECIMAL(6,2) NOT NULL Tracks Late Night Over Time Hours
18 GPJP_IT_HOLWRK Number(7,2) DECIMAL(6,2) NOT NULL Holiday Working Hours
19 GPJP_IT_PTODAYS Number(5,1) DECIMAL(4,1) NOT NULL Tracks days of PTO
20 GPJP_IT_SPCDAYS Number(5,1) DECIMAL(4,1) NOT NULL Tracks days of Special Leave
21 GPJP_IT_ABSDAYS Number(5,1) DECIMAL(4,1) NOT NULL Days of Absense