GPNL_SOC_TMP

(SQL Table)
Index Back

Temporary Table for SS Reports

This is a temporary table used to capture payroll results to feed several Social Security related reports.

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