GPDE_RP_EL_DBZD

(SQL Table)
Index Back

DataTransfer Pension Fund

Record to store necessary data for contribution data transfer to pension fund for specific professions.

# 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_END_DT Date(10) DATE Payee Process Segment's End Date
9 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 PRD_END_DT Date(10) DATE Pay Period End Date
11 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
12 HIRE_DT Date(10) DATE First Start Date
13 GPDE_EL_ZD_FIKTGRS Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
14 GPDE_EL_ZD_LMPG37B Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
15 GPDE_EL_ZD_LMPG40A Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
16 GPDE_EL_ZD_LMPG40B Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
17 GPDE_EL_ZD_FRWKVAG Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
18 GPDE_EL_ZD_FRWPVAG Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
19 GPDE_EL_ZD_FRWKV Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
20 GPDE_EL_ZD_FRWPV Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
21 GPDE_EL_ZD_CONTRPF Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
22 GPDE_EL_ZD_LMPTXEE Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
23 GPDE_EL_ZD_LMPSLEE Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
24 GPDE_EL_ZD_LMPCTEE Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result
25 GPDE_EL_ZD_RSNAZCH Number(1,0) SMALLINT NOT NULL Calculation Numeric Result
26 GPDE_EL_ZD_REGAZ Signed Number(8,2) DECIMAL(6,2) NOT NULL Calculation Numeric Result