[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view displays the attributes of Student Payment Plans |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PPSA.ROWID
, PPSA.STUDENT_PLAN_ID
, PPSA.PERSON_ID
, PPSA.PAYMENT_PLAN_NAME
, PPT.PAYMENT_PLAN_DESC
, PPSA.PLAN_START_DATE
, PPSA.PLAN_END_DATE
, PPSA.PLAN_STATUS_CODE
, LKP. MEANING
, PPSA.PROCESSING_FEE_AMT
, PPSA.PROCESSING_FEE_TYPE
, PPSA.FEE_CAL_TYPE
, PPSA.FEE_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, PPSA.NOTES
, PPT.INSTALLMENT_PERIOD_CODE
, PPT.DUE_DAY_OF_MONTH
, PPT.DUE_END_OF_MONTH_FLAG
, PPT.DUE_CUTOFF_DAY
, PPT.INSTALLMENT_METHOD_FLAG
, PPT.BASE_AMT
, PPSA.INVOICE_ID
, PPSA.ATTRIBUTE_CATEGORY
, PPSA.ATTRIBUTE1
, PPSA.ATTRIBUTE2
, PPSA.ATTRIBUTE3
, PPSA.ATTRIBUTE4
, PPSA.ATTRIBUTE5
, PPSA.ATTRIBUTE6
, PPSA.ATTRIBUTE7
, PPSA.ATTRIBUTE8
, PPSA.ATTRIBUTE9
, PPSA.ATTRIBUTE10
, PPSA.ATTRIBUTE11
, PPSA.ATTRIBUTE12
, PPSA.ATTRIBUTE13
, PPSA.ATTRIBUTE14
, PPSA.ATTRIBUTE15
, PPSA.ATTRIBUTE16
, PPSA.ATTRIBUTE17
, PPSA.ATTRIBUTE18
, PPSA.ATTRIBUTE19
, PPSA.ATTRIBUTE20
, PPSA.CREATED_BY
, PPSA.CREATION_DATE
, PPSA.LAST_UPDATE_DATE
, PPSA.LAST_UPDATED_BY
, PPSA.LAST_UPDATE_LOGIN
, PPSA.REQUEST_ID
, PPSA.PROGRAM_ID
, PPSA.PROGRAM_APPLICATION_ID
, PPSA.PROGRAM_UPDATE_DATE
FROM IGS_FI_PP_STD_ATTRS PPSA
, IGS_FI_PP_TEMPLATES PPT
, IGS_LOOKUP_VALUES LKP
, IGS_CA_INST CI
WHERE PPSA.PAYMENT_PLAN_NAME = PPT.PAYMENT_PLAN_NAME
AND PPSA.PLAN_STATUS_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'IGS_FI_PLAN_STATUS'
AND PPSA.FEE_CAL_TYPE = CI.CAL_TYPE (+)
AND PPSA.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER (+)