GPNL_5PCT_TMP

(SQL Table)
 Index Back

Soc Sec Year-End EE Report

This is a temporary table used for the Social Security 5% Report.

# 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 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
11 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
12 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
14 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
15 GPNL_SOC_NUM Character(20) VARCHAR2(20) NOT NULL Social Security Number
16 GPNL_SV_DAYS_1E Signed Number(7,2) DECIMAL(5,2) NOT NULL Social Insurance Days 1e
17 GPNL_SV_DAYS_2E Signed Number(7,2) DECIMAL(5,2) NOT NULL Social Insurance Day 2e
18 GPNL_SV_DAYS_YTD1E Signed Number(7,2) DECIMAL(5,2) NOT NULL Social Insurance Day 1e
19 GPNL_SV_DAYS_YTD2E Signed Number(7,2) DECIMAL(5,2) NOT NULL Social Insurance Day 1e
20 GPNL_SV_INCOME_1E Signed Number(16,2) DECIMAL(14,2) NOT NULL Income 1e
21 GPNL_SV_INCOME_2E Signed Number(16,2) DECIMAL(14,2) NOT NULL Income 2e
22 GPNL_WAO_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (disabillity) Base 1e
23 GPNL_WAO_BS_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Base 2e
24 GPNL_WAO_BS_YTD_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Base YTD 1e
25 GPNL_WAO_BS_YTD_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Base YTD 2e
26 GPNL_WAO_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) EE Contributn 1e
27 GPNL_WAO_CT_EE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) EE Contributn 2e
28 GPNL_WAO_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Total Contributn 1e
29 GPNL_WAO_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) Total Contributn 2e
30 GPNL_WAO_CT_YEE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO (Disabillity) EE Contributn YTD 1e
31 GPNL_WAO_CT_YEE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO EE Contributn YTD 2e
32 GPNL_WAO_CT_YTT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO Total Contributn YTD 1e
33 GPNL_WAO_CT_YTT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WAO Total Contributn YTD 2e
34 GPNL_WAO_PCT_EE_1E Number(6,2) DECIMAL(5,2) NOT NULL WAO Percent EE 1e
35 GPNL_WAO_PCT_EE_2E Number(6,2) DECIMAL(5,2) NOT NULL WAO Percent EE 2e
36 GPNL_WAO_PCT_TT_1E Number(6,2) DECIMAL(5,2) NOT NULL WAO Percent Total 1e
37 GPNL_WAO_PCT_TT_2E Number(6,2) DECIMAL(5,2) NOT NULL WAO Percent Total 2e
38 GPNL_WW_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Base 1e
39 GPNL_WW_BS_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Base 2e
40 GPNL_WW_BS_YTD_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Base YTD 1e
41 GPNL_WW_BS_YTD_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Base YTD 2e
42 GPNL_WW_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW EE Contributn 1e
43 GPNL_WW_CT_EE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW EE Contributn 2e
44 GPNL_WW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Total Contributn 1e
45 GPNL_WW_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL WW Total Contributn 2e
46 GPNL_WW_CT_YEE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL wW EE Contributn YTD 1e
47 GPNL_WW_CT_YEE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL wW EE Contributn YTD 2e
48 GPNL_WW_CT_YTT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL wW Total Contributn YTD 1e
49 GPNL_WW_CT_YTT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL Ww Total Contributn YTD 2e
50 GPNL_WW_PCT_EE_1E Number(6,2) DECIMAL(5,2) NOT NULL WW Percent EE 1e
51 GPNL_WW_PCT_EE_2E Number(6,2) DECIMAL(5,2) NOT NULL WW Percent EE 2e
52 GPNL_WW_PCT_TT_1E Number(6,2) DECIMAL(5,2) NOT NULL GPNL_WW_PCT_TT_1E
53 GPNL_WW_PCT_TT_2E Number(6,2) DECIMAL(5,2) NOT NULL WW Percent Total 2e
54 GPNL_ZFW_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base 1e
55 GPNL_ZFW_BS_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base 2e
56 GPNL_ZFW_BS_YTD_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base YTD 1e
57 GPNL_ZFW_BS_YTD_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base YTD 2e
58 GPNL_ZFW_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW EE Contributn 1e
59 GPNL_ZFW_CT_EE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW EE Contributn 2e
60 GPNL_ZFW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Total Contributn 1e
61 GPNL_ZFW_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Total Contributn 2e
62 GPNL_ZFW_CT_YEE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW EE Contributn YTD 1e
63 GPNL_ZFW_CT_YEE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW EE Contributn YTD 2e
64 GPNL_ZFW_CT_YTT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Total Contributn YTD 1e
65 GPNL_ZFW_CT_YTT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Total Contributn YTD 2e
66 GPNL_ZFW_PCT_EE_1E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent EE 1e
67 GPNL_ZFW_PCT_EE_2E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent EE 2e
68 GPNL_ZFW_PCT_TT_1E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent Total 1e
69 GPNL_ZFW_PCT_TT_2E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent Total 2e
70 GPNL_ZW_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Base 1e
71 GPNL_ZW_BS_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Base 2e
72 GPNL_ZW_BS_YTD_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Base YTD 1e
73 GPNL_ZW_BS_YTD_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base YTD 2e
74 GPNL_ZW_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW EE Contributn 1e
75 GPNL_ZW_CT_EE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW EE Contributn 2e
76 GPNL_ZW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Total Contributn 1e
77 GPNL_ZW_CT_TT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Total Contributn 2e
78 GPNL_ZW_CT_YEE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW EE Contributn YTD 1e
79 GPNL_ZW_CT_YEE_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW EE Contributn YTD 2e
80 GPNL_ZW_CT_YTT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Total Contributn YTD 1e
81 GPNL_ZW_CT_YTT_2E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZW Total Contributn YTD 2e
82 GPNL_ZW_PCT_EE_1E Number(6,2) DECIMAL(5,2) NOT NULL ZW Percent EE 1e
83 GPNL_ZW_PCT_EE_2E Number(6,2) DECIMAL(5,2) NOT NULL ZW Percent EE 2e
84 GPNL_ZW_PCT_TT_1E Number(6,2) DECIMAL(5,2) NOT NULL ZW Percent Total 1e
85 GPNL_ZW_PCT_TT_2E Number(6,2) DECIMAL(5,2) NOT NULL ZW Percent Total 2e
86 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
87 GPNL_ZVW_BS_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZVW Base
88 GPNL_ZVW_CT_EE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WALVIS
89 GPNL_ZVW_CT_TT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL WALVIS
90 GPNL_ZVW_BS_YTD_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Base YTD 1e
91 GPNL_ZVW_CT_YEE_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW EE Contributn YTD 1e
92 GPNL_ZVW_CT_YTT_1E Signed Number(12,2) DECIMAL(10,2) NOT NULL ZFW Total Contributn YTD 1e
93 GPNL_ZVW_PCT_EE_1E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent EE 1e
94 GPNL_ZVW_PCT_TT_1E Number(6,2) DECIMAL(5,2) NOT NULL ZFW Percent Total 1e
95 GPNL_SECTOR Number(3,0) SMALLINT NOT NULL WALVIS
96 GPNL_RISKGRP Number(2,0) SMALLINT NOT NULL WALVIS
97 EMPLR_TAX_NUM_NLD Number(9,0) DECIMAL(9) NOT NULL Federal Employer Tax ID
98 GPNL_HANDICAP_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Handicap discount for employers on Social Security contributions
99 GPNL_ELDR_EMP_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Premium Discount Employment Elderly Employee
100 GPNL_ELDR_HIR_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Premium Discount Hire Elderly Employment