GPGB_PSLIP_M_ED

(SQL Table)
Index Back

Payslip Print - Earnings

UK Printed Payslip Record - Earnings

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
9 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
10 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code
11 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
12 PRD_BGN_DT Date(10) DATE Period Begin Date
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
15 GPGB_TAX_PERIOD Number(3,0) SMALLINT NOT NULL Tax Period
16 GPGB_PSLIP_D_TXT Character(25) VARCHAR2(25) NOT NULL Payslip Detail Text
17 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
18 GPGB_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment
19 GPGB_RSLT_VAL_YTD Signed Number(16,2) DECIMAL(14,2) NOT NULL Result Year To Date