EMPLIDEMPL_RCDGPGB_LOAN_IDGPGB_CB_LOAN_VW(SQL View) |
Index Back |
|---|---|
GPUK Chatbot Loan ViewGPUK Chatbot Loan View |
| SELECT a.emplid ,a.empl_rcd ,a.gpgb_loan_id , d.descr ,a.bgn_dt ,a.end_dt ,b.gpgb_loan_amt ,b.gpgb_int_amt_tot ,b.gpgb_loan_rpy_amt ,( SELECT c.name FROM ps_gpgb_ee_loan_bn c WHERE c.emplid=a.emplid AND c.empl_rcd=a.empl_rcd AND c.gpgb_loan_id =a.gpgb_loan_id AND c.gpgb_benef_id = ( SELECT MAX(gpgb_benef_id) FROM ps_gpgb_ee_loan_bn WHERE emplid= c.emplid AND empl_Rcd=c.empl_rcd AND gpgb_loan_id=c.gpgb_loan_id)) ,b.gpgb_loan_rpy_pds ,E1.jobcode_descr FROM ps_gpgb_ee_loan_hd a , ps_gpgb_ee_loan_dt b ,ps_GPGB_LOAN_TYPE d ,PS_JOB_CURR_VW1 E1 WHERE a.emplid =b.emplid AND a.empl_Rcd=b.empl_rcd AND a.gpgb_loan_id=b.gpgb_loan_id AND b.effdt=( SELECT MAX(effdt) FROM ps_gpgb_ee_loan_Dt WHERE emplid=a.emplid AND empl_Rcd=a.empl_rcd AND gpgb_loan_id=a.gpgb_loan_id ) AND d.gpgb_loan_type=a.gpgb_loan_type AND d.effdt=( SELECT MAX(effdt) FROM ps_gpgb_loan_type WHERE gpgb_loan_type=a.gpgb_loan_type) AND E1.emplid=a.emplid AND E1.empl_Rcd = a.empl_Rcd |
| # | 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 | GPGB_LOAN_ID |
Character(20) | VARCHAR2(20) NOT NULL | Unique ID for employee loans |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPGB_LOAN_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Initial Loan Amount |
| 8 | GPGB_INT_AMT_TOT | Number(11,2) | DECIMAL(10,2) NOT NULL | GP UK - Loan - Total Interest amount included in Loan |
| 9 | GPGB_LOAN_RPY_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Loan Repayment Amount. |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | GPGB_LOAN_RPY_PDS | Number(4,0) | SMALLINT NOT NULL | Loan repayment Periods |
| 12 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |