GPGB_RSLT_BANK2

(SQL View)
 Index Back

Payslip View - Banking

UK Online Payslip View - Banking Data

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.RSLT_SEG_NUM , D.BANK_CD , D.ACCOUNT_EC_ID , D.ROLL_NUMBER FROM PS_GP_PYE_SEG_STAT A , PS_GP_CALENDAR B , PS_GP_NET_DIST_DTL C , PS_PYE_BANKACCT D , PS_GPGB_PAYMENT E WHERE A.EMPLID = D.EMPLID AND D.EFF_STATUS = 'A' AND D.ACCOUNT_ID = C.ACCOUNT_ID AND C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.EMPLID = C.EMPLID AND C.PRIMARY_ACCT_IND = 'Y' AND A.EMPL_RCD = C.EMPL_RCD AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_GP_NET_DIST_DTL C_ED WHERE C.EMPLID = C_ED.EMPLID AND C.EMPL_RCD = C_ED.EMPL_RCD AND C.RUN_TYPE = C_ED.RUN_TYPE AND C_ED.EFFDT <= B.PYMT_DT) AND E.CAL_RUN_ID = A.CAL_RUN_ID AND E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.CAL_ID = A.CAL_ID AND E.INSTANCE = C.INSTANCE AND E.RECIPIENT_ID = ' '

# 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 Record
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 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
8 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
9 ROLL_NUMBER Character(20) VARCHAR2(20) NOT NULL Roll Number