GPNL_RED_WA_HST

(SQL Table)
Index Back

Reductions WA

This is the Archive (shadow) table used in Data Archiving for the record: GPNL_RED_WA.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 GPNL_TAX_RED_CD Character(1) VARCHAR2(1) NOT NULL Tax Reduction
1=Low Wages
2=Former Unemployement
3=Education
4=Starter Qualification
5=Parental Leave
11 GPNL_TAX_RED_KEY Character(1) VARCHAR2(1) NOT NULL Tax Reduction Key
1=Low Wages
2=Former Unemployement
3=Education
5=Parental Leave
12 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
13 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
15 GPNL_INCOME Signed Number(20,6) DECIMAL(18,6) NOT NULL Income
16 GPNL_NBR_HOURS Signed Number(8,0) DECIMAL(7) NOT NULL Number of Hours
17 GPNL_STD_HOURS Signed Number(8,0) DECIMAL(7) NOT NULL Standard Hours
18 GPNL_TAX_RED Signed Number(20,6) DECIMAL(18,6) NOT NULL Tax Reduction
19 END_DT Date(10) DATE end date