GPDE_LN_SETUP_V

(SQL View)
 Index Back

Loans set up

Loan definition data.

SELECT A.EMPLID ,A.EMPL_RCD ,A.INSTANCE ,A.DESCR50 ,A.CURRENCY_CD ,B.GPDE_LN_REM_BAL ,A.GPDE_LN_INTEREST ,A.GPDE_LN_PAYOUT_DT ,A.GPDE_LN_CALC_TYPE ,%CurrentDateIn ,A.GPDE_LN_ACCT ,A.GPDE_LN_INVEST FROM PS_GPDE_LN_SETUP A , PS_GPDE_LN_BAL_VW B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.INSTANCE = B.INSTANCE AND A.GPDE_LN_ACTIVE = 'N' AND A.ENTERED_DT <= %CurrentDateIn AND A.GPDE_LN_PAYOUT_DT <= %CurrentDateIn

  • Related Language Record: GPDE_LN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

    Default Value: 1

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    6 GPDE_LN_REM_BAL Number(11,2) DECIMAL(10,2) NOT NULL Loans Remaining Balance. Used to keep track of loan balances for reporting and/or to figure out whether income tax/si has to be/was deducted for this loan instance
    7 GPDE_LN_INTEREST Number(6,2) DECIMAL(5,2) NOT NULL Loan company interest rate

    Default Value: 0

    8 GPDE_LN_PAYOUT_DT Date(10) DATE NOT NULL Loan pay-out date. Date Loan was payed out to employee
    9 GPDE_LN_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL /Loan calculation type option
    1=Flat Amount Repayment
    2=Flat Amount Capital
    4=End Date
    7=By Periods

    Default Value: 4

    10 GPDE_LN_DED_BEG_DT Date(10) DATE NOT NULL Loan deduction begin date
    11 GPDE_LN_ACCT Character(50) VARCHAR2(50) NOT NULL Ger Loans - Account
    12 GPDE_LN_INVEST Character(50) VARCHAR2(50) NOT NULL Loans - Investment number