GPIT_FPC_WA

(SQL Table)
Index Back

FPC Reports Data

FPC Reports Data

# 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 SLICE_END_DT Date(10) DATE Element Slice End Date
9 GPIT_FPC_COD Character(2) VARCHAR2(2) NOT NULL Complementary Fund Code
10 GPIT_FPC_REG Character(2) VARCHAR2(2) NOT NULL Complementary Regime Code
11 GPIT_FPC_ENR_DT Date(10) DATE Fund Enrollment Date
12 GPIT_FPC_CODISCR Character(15) VARCHAR2(15) NOT NULL Enrollment Code
13 GPIT_FPC_IMP Number(12,2) DECIMAL(11,2) NOT NULL Monthly Assessable Amount
14 GPIT_FPC_CTRDF1 Number(12,2) DECIMAL(11,2) NOT NULL Level 1 EE Contribution
15 GPIT_FPC_CTRAF1 Number(12,2) DECIMAL(11,2) NOT NULL Level 1 ER Contribution
16 GPIT_FPC_CTRDF2 Number(12,2) DECIMAL(11,2) NOT NULL Level 2 EE Contribution
17 GPIT_FPC_CTRAF2 Number(12,2) DECIMAL(11,2) NOT NULL Level 2 ER Contribution
18 GPIT_FPC_IMPTFR Number(12,2) DECIMAL(11,2) NOT NULL Monthly TFR Assessable Amount
19 GPIT_FPC_CTRTFR Number(12,2) DECIMAL(11,2) NOT NULL TFR Contribution
20 GPIT_FPC_VOL_AMT Number(12,2) DECIMAL(11,2) NOT NULL Amount Voluntary contribution