GPGB_PSLIP_BWAD

(SQL Table)
Index Back

UK Printed Payslips Bal Work

UK Online Payslip work record for Balances

# 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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
10 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
11 GPGB_ELE_ORDER Number(6,0) INTEGER NOT NULL Payslip Element Order
12 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
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_PIN_NUM_CUR Number(8,0) INTEGER NOT NULL Pin Number Current Value
16 GPGB_PSLIP_DESCR Character(15) VARCHAR2(15) NOT NULL Payslip Description
17 GPGB_RSLT_VAL_CUR Signed Number(16,2) DECIMAL(14,2) NOT NULL Result Current
18 GPGB_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment
19 GPGB_PIN_NUM_YTD Number(8,0) INTEGER NOT NULL Pin Number Year to Date
20 GPGB_RSLT_VAL_YTD Signed Number(16,2) DECIMAL(14,2) NOT NULL Result Year To Date
21 GPGB_ADJ_VAL_YTD Signed Number(16,2) DECIMAL(14,2) NOT NULL Adjustment YTD
22 GPGB_PSLIP_UK2_ALL Character(1) VARCHAR2(1) NOT NULL Display All Occurences User K2
23 GPGB_PSLIP_UK2_DIS Character(1) VARCHAR2(1) NOT NULL Display User Key2

Y/N Table Edit

Default Value: N