GPBR_NRP_LNP_VW

(SQL View)
Index Back

Loan Payments

Store de Payments Calendar

SELECT EMPLID ,EMPL_RCD ,PIN_NUM + 50000000 ,INSTANCE ,GPBR_LOAN_NUM ,BGN_DT ,END_DT ,PAYMENT_AMOUNT FROM PS_GPBR_LOAN_PAY

# 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
4 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
5 GPBR_LOAN_NUM Character(10) VARCHAR2(10) NOT NULL Loan Number
6 BGN_DT Date(10) DATE NOT NULL Begin Date
7 END_DT Date(10) DATE end date
8 PAYMENT_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount of payment.