GPNL_EMPL_TMP

(SQL Table)
Index Back

Employer Report

This record is used as temporary table for the employer report writeable array.

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