GPGB_PSLIP_EWAD

(SQL Table)
Index Back

UK Printed Payslips Earns Work

UK printed payslips earnings work record. this is used within the app engien process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
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_PSLIP_SECTION Character(3) VARCHAR2(3) NOT NULL Printed Payslips Section identifier
9 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
10 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
11 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
12 GPGB_PIN_NUM_CUR Number(8,0) INTEGER NOT NULL Pin Number Current Value
13 GPGB_PSLIP_DETAIL Number(8,0) INTEGER NOT NULL Payslip detail Pin
14 GPGB_PSLIP_D_TXT Character(25) VARCHAR2(25) NOT NULL Payslip Detail Text
15 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
16 GPGB_VAL_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Current Value
17 GPGB_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment
18 GPGB_BASE_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Payslip Base Result Value
19 GPGB_RATE_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Earnings Rate Value
20 GPGB_UNIT_CUR Signed Number(20,6) DECIMAL(18,6) NOT NULL Earnings Units Value
21 GPGB_PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percentage
22 GPGB_PIN_NUM_YTD Number(8,0) INTEGER NOT NULL Pin Number Year to Date
23 GPGB_RSLT_VAL_YTD Signed Number(16,2) DECIMAL(14,2) NOT NULL Result Year To Date
24 USER_FLD1 Character(25) VARCHAR2(25) NOT NULL User Field 1
25 USER_FLD2 Character(25) VARCHAR2(25) NOT NULL User Field 2
26 USER_FLD3 Character(25) VARCHAR2(25) NOT NULL User Field 3
27 USER_FLD4 Character(25) VARCHAR2(25) NOT NULL User Field 4