GPGB_EE_LOAN_DT(SQL Table) |
Index Back |
|---|---|
GP UK - Employees Loan DETAILMaintain GP UK Employees Loan - Details record |
| # | 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
Default Value: %date |
| 5 | 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 Default Value: 010 |
| 6 | GPGB_LOAN_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Initial Loan Amount |
| 7 | GPGB_INT_AMT_TOT | Number(11,2) | DECIMAL(10,2) NOT NULL | GP UK - Loan - Total Interest amount included in Loan |
| 8 | GPGB_RT_OVRD | Number(16,8) | DECIMAL(15,8) NOT NULL | GP UK - Interest Rate Override |
| 9 | GPGB_LOAN_RPY_PDS | Number(4,0) | SMALLINT NOT NULL | Loan repayment Periods |
| 10 | GPGB_LOAN_RPY_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Loan Repayment Amount. |
| 11 | GPGB_P11D_REPORT | Character(1) | VARCHAR2(1) NOT NULL |
GP UK - P11D Reportable
Y/N Table Edit Default Value: GPGB_LOAN_TYPE.GPGB_P11D_REPORT |