EMPLIDEMPL_RCDINSTANCEGPDE_LN_SCHED_V(SQL View) |
Index Back |
|---|---|
Ger Loans Schedule search viewLoans Schedule search view |
| SELECT A.EMPLID , A.EMPL_RCD , A.INSTANCE , A.GPDE_LN_YEAR , A.GPDE_LN_MONTH , A.CURRENCY_CD , B.GPDE_LN_DED_BEG_DT , B.GPDE_LN_AMT , B.GPDE_LN_INTEREST , B.GPDE_LN_ACTIVE , B.ENTERED_DT , A.GPDE_LN_DED_AMT , A.GPDE_LN_DED_AMTINT , B.GPDE_LN_SALIK_INTR FROM PS_GPDE_LN_SCHED A , PS_GPDE_LN_SETUP B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.INSTANCE = B.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 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 4 | GPDE_LN_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 5 | GPDE_LN_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | GPDE_LN_DED_BEG_DT | Date(10) | DATE | Loan deduction begin date |
| 8 | GPDE_LN_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Loan amount |
| 9 | GPDE_LN_INTEREST | Number(6,2) | DECIMAL(5,2) NOT NULL | Loan company interest rate |
| 10 | GPDE_LN_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL | yes/no, defines whether a loan is active or not active. Will be use by Payroll processing to determine whether a monthly payment has to be deducted |
| 11 | ENTERED_DT | Date(10) | DATE | Entered on |
| 12 | GPDE_LN_DED_AMT | Number(10,2) | DECIMAL(9,2) NOT NULL | Loan repayment deduction amount |
| 13 | GPDE_LN_DED_AMTINT | Number(9,2) | DECIMAL(8,2) NOT NULL | Loan interest deduction amount |
| 14 | GPDE_LN_SALIK_INTR | Number(6,2) | DECIMAL(5,2) NOT NULL | Loan company interest rate |