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_FIN_LT_PLAN_V

Product:	IGS - Student System (Obsolete)
Description:	This a FORM VIEW and is created by joining IGS_FI_FIN_LT_PLAN table, IGS_FI_SUBACCTS MO view, IGS_FI_FEE_TYPE MO view and IGS_LOOKUPS View. This view holds details of Finance and late charges plan information.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FLP.ROWID
, FLP.PLAN_NAME
, FLP.PLAN_TYPE
, LKP1.MEANING
, FLP.DESCRIPTION
, FLP.CLOSED_IND
, FLP.SUBACCOUNT_ID
, NULL
, FLP.BALANCE_TYPE
, LKP2.MEANING
, FLP.FEE_TYPE
, FT.DESCRIPTION
, FLP.ACCRUAL_TYPE
, LKP3.MEANING
, FLP.OFFSET_DAYS
, FLP.CHG_RATE
, FLP.FLAT_AMOUNT
, FLP.MAX_CHARGE_AMOUNT
, FLP.MIN_CHARGE_AMOUNT
, FLP.MIN_CHARGE_AMOUNT_NO_CHARGE
, FLP.MIN_BALANCE_AMOUNT
, FLP.ATTRIBUTE_CATEGORY
, FLP.ATTRIBUTE1
, FLP.ATTRIBUTE2
, FLP.ATTRIBUTE3
, FLP.ATTRIBUTE4
, FLP.ATTRIBUTE5
, FLP.ATTRIBUTE6
, FLP.ATTRIBUTE7
, FLP.ATTRIBUTE8
, FLP.ATTRIBUTE9
, FLP.ATTRIBUTE10
, FLP.ATTRIBUTE11
, FLP.ATTRIBUTE12
, FLP.ATTRIBUTE13
, FLP.ATTRIBUTE14
, FLP.ATTRIBUTE15
, FLP.ATTRIBUTE16
, FLP.ATTRIBUTE17
, FLP.ATTRIBUTE18
, FLP.ATTRIBUTE19
, FLP.ATTRIBUTE20
, FLP.CREATED_BY
, FLP.CREATION_DATE
, FLP.LAST_UPDATED_BY
, FLP.LAST_UPDATE_DATE
, FLP.LAST_UPDATE_LOGIN
, FLP.PAYMENT_PLAN_ACCRL_TYPE_CODE
, LKP4.MEANING
, FLP.PAYMENT_PLAN_CHG_RATE
, FLP.PAYMENT_PLAN_FLAT_AMT
, FLP.PAYMENT_PLAN_MAX_CHARGE_AMT
, FLP.PAYMENT_PLAN_MIN_CHARGE_AMT
, FLP.PAYMENT_PLAN_MINCHGAMT_NOCHG
, FLP.PAYMENT_PLAN_MIN_BALANCE_AMT
FROM IGS_FI_FIN_LT_PLAN FLP
, IGS_LOOKUPS_VIEW LKP1
, IGS_LOOKUPS_VIEW LKP2
, IGS_FI_FEE_TYPE FT
, IGS_LOOKUPS_VIEW LKP3
, IGS_LOOKUPS_VIEW LKP4
WHERE (LKP1.LOOKUP_TYPE = 'IGS_FI_PLAN_TYPE'
AND LKP1.LOOKUP_CODE = FLP.PLAN_TYPE)
AND (LKP2.LOOKUP_TYPE = 'IGS_FI_BALANCE_TYPE'
AND LKP2.LOOKUP_CODE = FLP.BALANCE_TYPE)
AND FLP.FEE_TYPE = FT.FEE_TYPE
AND (LKP3.LOOKUP_TYPE = 'IGS_FI_ACCRUAL_TYPE'
AND LKP3.LOOKUP_CODE = FLP.ACCRUAL_TYPE)
AND (LKP4.LOOKUP_TYPE (+) = 'IGS_FI_ACCRUAL_TYPE'
AND LKP4.LOOKUP_CODE (+) = FLP.PAYMENT_PLAN_ACCRL_TYPE_CODE )

Columns

Name
ROW_ID
PLAN_NAME
PLAN_TYPE
PLAN_TYPE_MEANING
DESCRIPTION
CLOSED_IND
SUBACCOUNT_ID
SUBACCOUNT_NAME
BALANCE_TYPE
BALANCE_TYPE_MEANING
FEE_TYPE
FEE_TYPE_DESC
ACCRUAL_TYPE
ACCRUAL_TYPE_MEANING
OFFSET_DAYS
CHG_RATE
FLAT_AMOUNT
MAX_CHARGE_AMOUNT
MIN_CHARGE_AMOUNT
MIN_CHARGE_AMOUNT_NO_CHARGE
MIN_BALANCE_AMOUNT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PAYMENT_PLAN_ACCRL_TYPE_CODE
PAYMENT_PLAN_ACCRL_MEANING
PAYMENT_PLAN_CHG_RATE
PAYMENT_PLAN_FLAT_AMT
PAYMENT_PLAN_MAX_CHARGE_AMT
PAYMENT_PLAN_MIN_CHARGE_AMT
PAYMENT_PLAN_MINCHGAMT_NOCHG
PAYMENT_PLAN_MIN_BALANCE_AMT