GPNL_SOC_WA_HST

(SQL Table)
Index Back

Social Security Sub Records

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