GPGB_RSLT_BANK

(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_CAL_RUN_DTL B , PS_GP_NET_DIST_DTL C , PS_PYE_BANKACCT D 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 (B.RUN_TYPE = C.RUN_TYPE OR (C.RUN_TYPE = ( SELECT E.RUN_TYPE FROM PS_GP_NET_DIST E WHERE C.EMPLID = E.EMPLID AND C.EMPL_RCD = E.EMPL_RCD AND E.DEFAULT_IND = 'Y') AND NOT EXISTS ( SELECT 'X' FROM PS_GP_NET_DIST_DTL WHERE EMPLID = C.EMPLID AND EMPL_RCD = C.EMPL_RCD AND RUN_TYPE = B.RUN_TYPE AND INSTANCE = C.INSTANCE)))

# 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