eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_PAY_PLAN_INSTALLMENTS

Product:	IGS - Student System (Obsolete)
Description:	Holds information of Student Payment Plan Installments
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PP.INSTALLMENT_ID
, PP.STUDENT_PLAN_ID
, PP.INSTALLMENT_LINE_NUM
, PP.DUE_DAY
, '_LA:DUE_MONTH_CODE:IGS_LOOKUP_VALUES:VS_CA_MONTH:MEANING'
, PP.DUE_YEAR
, PP.DUE_DATE
, PP.INSTALLMENT_AMT
, PP.DUE_AMT
, PP.PENALTY_FLAG
, STD.PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, STD.PAYMENT_PLAN_NAME
, STD.PLAN_START_DATE
, STD.PLAN_END_DATE
, PP.CREATED_BY
, PP.CREATION_DATE
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
FROM IGS_FI_PP_INSTLMNTS PP
, IGS_FI_PP_STD_ATTRS STD
, HZ_PARTIES HZ
WHERE PP.STUDENT_PLAN_ID = STD.STUDENT_PLAN_ID
AND HZ.PARTY_ID = STD.PERSON_ID WITH READ ONLY

Columns

Name
INSTALLMENT_IDENTIFIER
STUDENT_PLAN_IDENTIFIER
INSTALLMENT_LINE_NUMBER
DUE_DAY
"_LA:DUE_MONTH"
DUE_YEAR
DUE_DATE
INSTALLMENT_AMOUNT
DUE_AMOUNT
PENALTY_FLAG
PERSON_IDENTIFIER
PERSON_NUMBER
PERSON_NAME
PAYMENT_PLAN_NAME
PAYMENT_PLAN_START_DATE
PAYMENT_PLAN_END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY