EMPLIDEMPL_RCDA=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
01=Net Pay Distribution
02=General Recipient Deduction
03=Individual Recipient Deduction
GPHK_PSLP_NP_VW(SQL View) |
Index Back |
|---|---|
GP HKG - Payslip BankingGP HKG - Payslip Banking view |
| SELECT B.EMPLID , B.EMPL_RCD , B.CAL_RUN_ID , B.GP_PAYGROUP , B.CAL_ID , B.RSLT_SEG_NUM , B.GP_PMT_AMT , B.CURRENCY_CD , B.PAYMENT_MTHD , D.BRANCH_EC_CD , D.ACCOUNT_EC_ID , E.BANK_NM , B.PMT_TYPE FROM PS_GP_PAYMENT B , PS_GP_NET_DIST_DTL C , PS_PYE_BANKACCT D , PS_BANK_EC_TBL E , PS_GP_PYE_PRC_STAT F WHERE B.EMPLID = C.EMPLID AND B.EMPL_RCD = C.EMPL_RCD AND B.INSTANCE = C.INSTANCE AND C.ACCOUNT_ID = D.ACCOUNT_ID AND C.EMPLID = D.EMPLID AND D.BANK_CD = E.BANK_CD AND D.COUNTRY_CD = E.COUNTRY_CD AND F.RUN_TYPE = C.RUN_TYPE AND F.EMPLID = B.EMPLID AND F.CAL_RUN_ID = B.CAL_RUN_ID AND F.EMPL_RCD = B.EMPL_RCD AND F.GP_PAYGROUP = B.GP_PAYGROUP AND F.CAL_ID = B.CAL_ID AND F.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND B.PMT_TYPE = '01' AND C.EFFDT =( SELECT MAX(C1.EFFDT) FROM PS_GP_NET_DIST_DTL C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.RUN_TYPE = C.RUN_TYPE AND C1.INSTANCE = C.INSTANCE ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 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 | GPHK_GP_PMT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Copy of GP_PMT_AMT. This is being done for the purpose of displaying amounts as 2 decimal positions in the payslip inquiry page |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 10 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 11 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 12 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 13 | PMT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type
01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction |