GPNL_EMPL_WA

(SQL Table)
 Index Back

Employer Report WA

This record stores all payroll information required by the employer report (AANGIFTE LOONBELASTING). A Writeable Array writes this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
9 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
11 EMPLR_TAX_NUM_NLD Number(9,0) DECIMAL(9) NOT NULL Federal Employer Tax ID
12 GPNL_COLUMN_2A Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2a
13 GPNL_COLUMN_2B Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2b
14 GPNL_COLUMN_2C Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2c
15 GPNL_COLUMN_2D Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2d
16 GPNL_COLUMN_2E Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2e
17 GPNL_COLUMN_2F Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2f
18 GPNL_COLUMN_2G Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2g
19 GPNL_COLUMN_2H Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2h
20 GPNL_COLUMN_2I Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 2i
21 GPNL_COLUMN_3A Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3a
22 GPNL_COLUMN_3B Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3b
23 GPNL_COLUMN_3C Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3c
24 GPNL_COLUMN_3D Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3d
25 GPNL_COLUMN_3E Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3e
26 GPNL_COLUMN_3F Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3f
27 GPNL_COLUMN_3G Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3g
28 GPNL_COLUMN_3H Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3h
29 GPNL_COLUMN_3I Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 3i
30 GPNL_COLUMN_4A Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Tax Report 4a
31 GPNL_LCA_PAYMENTS Signed Number(20,6) DECIMAL(18,6) NOT NULL Track the paid labor costs per period.