GPIT_PREST_EE

(SQL Table)
Index Back

Employee loans data

Emplid loans data

# 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 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GPIT_PRE_CODICE Character(18) VARCHAR2(18) NOT NULL Loan Code
5 GPIT_PRE_BENEF Character(8) VARCHAR2(8) NOT NULL Beneficiary

Prompt Table: GPIT_PRE_BENEF

6 GPIT_PRE_DATFIN Date(10) DATE NOT NULL Loan End Date
7 GPIT_PRE_IMPTOT Number(13,2) DECIMAL(12,2) NOT NULL Total amount of loan
8 GPIT_PRE_RATA Number(13,2) DECIMAL(12,2) NOT NULL Installment amount
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 GPIT_PRE_RATANN Number(2,0) SMALLINT NOT NULL Yearly installments nbr
11 GPIT_PRE_TRACES Character(1) VARCHAR2(1) NOT NULL Active recovery on termination

Y/N Table Edit

Default Value: Y

12 GPIT_PIN_PREST Number(8,0) INTEGER NOT NULL Payroll Element

Prompt Table: GPIT_PREST_VW