GPAU_PSLP_ND_VW(SQL View) |
Index Back |
|---|---|
GP AUS - Payslip ND VwGP AUS - Payslip net distribution view |
| SELECT B.EMPLID , B.EMPL_RCD , B.DISTRIB_AMT FROM PS_GP_NET_DIST_DTL B , PS_PYE_BANKACCT A WHERE A.EMPLID = B.EMPLID AND A.ACCOUNT_ID = B.ACCOUNT_ID AND B.EFFDT =( SELECT MAX(B1.EFFDT) FROM PS_GP_NET_DIST_DTL B1 WHERE B1.EMPLID = B.EMPLID AND B1.EMPL_RCD = B.EMPL_RCD AND B1.RUN_TYPE = B.RUN_TYPE AND B1.INSTANCE = B.INSTANCE) AND B.ACCOUNT_ID = 0 |
| # | 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 Record |
| 3 | DISTRIB_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Distribution Amount |