GPFR_LOAN

(SQL Table)
 Index Back

Loan definition

Definitions of the loans

  • Parent Record Of GPFR_LOAN_SCHED

    • # 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 GPFR_LOAN_ID Character(25) VARCHAR2(25) NOT NULL Identification of the loan
    4 GPFR_LOAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of the loan
    A=Salary Advance
    L=Loan

    Default Value: L

    5 GPFR_BGN_DT Date(10) DATE NOT NULL Begin Date
    6 GPFR_INIT_AMOUNT Number(15,2) DECIMAL(14,2) NOT NULL Initial amount of the loan
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 GPFR_PB_AMOUNT Number(15,2) DECIMAL(14,2) NOT NULL Payback amount for the loan
    9 GPFR_PB_PERIOD Number(3,0) SMALLINT NOT NULL Number of payback periods for the loan
    10 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP

    11 GPFR_INSTANCE Number(1,0) SMALLINT NOT NULL Number of the deduction to be used (from the setup), for loan and garnishment
    12 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    13 GPFR_SKIP Character(1) VARCHAR2(1) NOT NULL Skip the row in the loan schedule

    Y/N Table Edit

    Default Value: N

    14 GPFR_PI_STATUS Character(2) VARCHAR2(2) NOT NULL Status of the positive inputs (created, processed, ...)
    CR=Created
    ER=Error
    PI=Awaiting
    PR=Processed
    RE=Removed
    UP=Updated