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: IGS_FI_PP_INSTLMNTS_V

Product:	IGS - Student System (Obsolete)
Description:	This view displays the Student Payment Plan Installment information.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPIN.ROWID
, PPIN.INSTALLMENT_ID
, PPIN.STUDENT_PLAN_ID
, PPIN.INSTALLMENT_LINE_NUM
, PPIN.DUE_DAY
, PPIN.DUE_MONTH_CODE
, LKP.MEANING
, PPIN.DUE_YEAR
, PPIN.DUE_DATE
, PPIN.INSTALLMENT_AMT
, PPIN.DUE_AMT
, PPIN.PENALTY_FLAG
, PPIN.CREATED_BY
, PPIN.CREATION_DATE
, PPIN.LAST_UPDATE_DATE
, PPIN.LAST_UPDATED_BY
, PPIN.LAST_UPDATE_LOGIN
, PPIN.REQUEST_ID
, PPIN.PROGRAM_APPLICATION_ID
, PPIN.PROGRAM_ID
, PPIN.PROGRAM_UPDATE_DATE
FROM IGS_FI_PP_INSTLMNTS PPIN
, IGS_LOOKUP_VALUES LKP
WHERE PPIN.DUE_MONTH_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'VS_CA_MONTH'

Columns

Name
ROW_ID
INSTALLMENT_ID
STUDENT_PLAN_ID
INSTALLMENT_LINE_NUM
DUE_DAY
DUE_MONTH_CODE
DUE_MONTH_MEANING
DUE_YEAR
DUE_DATE
INSTALLMENT_AMT
DUE_AMT
PENALTY_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE