GPFR_LPR_PAYEE

(SQL Table)
Index Back

Last Payment Receipt Info.

Informations for Last Payment Receipt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 LAST_DATE_WORKED Date(10) DATE NOT NULL Last Date Worked
5 GPFR_LAST_PAYMENT Number(9,2) DECIMAL(8,2) NOT NULL Last payment amount for last payment receipt
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL