GPGB_EE_LOAN_VW(SQL View) |
Index Back |
|---|---|
GP UK - Employees Loan ViewGPUK Employee Loan - Combined View to search in GP Arrays |
| SELECT A.EMPLID , A.EMPL_RCD , A.GPGB_LOAN_ID , B.EFFDT , A.BGN_DT , A.END_DT , A.GPGB_LN_PRTY , B.GPGB_LOAN_RSN , B.GPGB_LOAN_AMT , B.GPGB_LOAN_RPY_AMT , C.GPGB_LEAVER_PRCS FROM PS_GPGB_EE_LOAN_HD A , PS_GPGB_EE_LOAN_DT B , PS_GPGB_LOAN_TYPE C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GPGB_LOAN_ID = B.GPGB_LOAN_ID AND A.GPGB_LOAN_TYPE = C.GPGB_LOAN_TYPE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_GPGB_LOAN_TYPE C2 WHERE C2.GPGB_LOAN_TYPE = C.GPGB_LOAN_TYPE AND C2.EFF_STATUS = C.EFF_STATUS AND C2.EFFDT<= A.BGN_DT) |
| # | 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 | GPGB_LOAN_ID |
Character(20) | VARCHAR2(20) NOT NULL | Unique ID for employee loans |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPGB_LN_PRTY | Number(3,0) | SMALLINT NOT NULL | Loan Processing Priority |
| 8 | GPGB_LOAN_RSN | Character(3) | VARCHAR2(3) NOT NULL |
Loan Reason
010=Loan Start 020=Holiday Suspend Recovery 030=Holiday Resume Recovery 040=Revised Repayment Plan 050=Interest/Amount Change 060=P11D Reporting 070=Stop Loan |
| 9 | GPGB_LOAN_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Initial Loan Amount |
| 10 | GPGB_LOAN_RPY_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Loan Repayment Amount. |
| 11 | GPGB_LEAVER_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
GP UK - Loans - Leaver Processing Option
A=Deduct Normal Amount B=Deduct Available Balance Z=Deduct Zero |