GPGB_PSLIP_P_ED

(SQL Table)
Index Back

Payslip Print - Earnings

UK Printed Payslip Record - Earnings

# 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 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 GPGB_PSLIP_SECTION Character(3) VARCHAR2(3) NOT NULL Printed Payslips Section identifier
8 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
11 GPGB_PSLIP_D_TXT Character(25) VARCHAR2(25) NOT NULL Payslip Detail Text
12 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
13 GPGB_VAL_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Current Value
14 GPGB_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment
15 GPGB_BASE_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Payslip Base Result Value
16 GPGB_RATE_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Earnings Rate Value
17 GPGB_UNIT_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Earnings Units Value
18 GPGB_PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percentage
19 GPGB_RSLT_VAL_YTD Signed Number(16,2) DECIMAL(14,2) NOT NULL Result Year To Date