GPMX_R_LOANS

(SQL Table)
Index Back

GP Mexico Loans Rpt Temp Table

GP Mexico Loans Report Temporal Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
4 GPMX_LOAN_NUM Character(18) VARCHAR2(18) NOT NULL Loan Number
5 GPMX_DATE Date(10) DATE Date - Mexico
6 GPMX_TOT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Amount
7 PAYMENT_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount of payment.
8 BAL_ADJ Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Adjustment
9 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
10 PYMT_DT Date(10) DATE Payment Date