GPGB_EYUXNI_TBL

(SQL Table)
Index Back

EYU XML NI Table

EYU XML NI Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
5 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code
6 GPGB_AT_LEL_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - GPGB_AT_LEL_EYU
7 GPGB_LEL_TO_PT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - LEL-to-PT-EYU
8 GPGB_PT_TO_UAP_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - PT-to-UAP-EYU
9 GPGB_UAP_TO_UEL_EY Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - UAP-to-UEL-EYU
10 GPGB_PT_TO_UEL_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions -PT-to-UEL-EYU
11 GPGB_ER_NI_CNT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - Total of Employer NI Contributions - EYU
12 GPGB_EE_NI_CNT_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL RTI Adjustment Submissions - Employees Contributions on all earnings - EYU
13 GPGB_NIABLE_EYU Signed Number(20,6) DECIMAL(18,6) NOT NULL Niable YTD used for RTI
14 GPGB_NIC_REFUND Character(1) VARCHAR2(1) NOT NULL RTI Adjustment Submissions - NIC Refund
N=No
Y=Yes
15 GPGB_PT_TO_UAP_C Character(10) VARCHAR2(10) NOT NULL RTI Adjustment Submissions - PT-to-UAP-EYU
16 GPGB_UAP_TO_UEL_C Character(10) VARCHAR2(10) NOT NULL RTI Adjustment Submissions - UAP-to-UEL-EYU
17 GPGB_PT_TO_UEL_C Character(10) VARCHAR2(10) NOT NULL RTI Adjustment Submissions -PT-to-UEL-EYU
18 GPGB_SCON Character(9) VARCHAR2(9) NOT NULL SCON - Scheme Contracted Out Number