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

Product:	IGF - Financial Aid (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CLSET.ROW_ID
, CLSET.CLSET_ID
, CLSET.CI_CAL_TYPE
, CLSET.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CLSET.BORW_INTEREST_IND
, NULL
, NULL
, NULL
, NULL
, RCPTV.LENDER_ID
, NULL
, RCPTV.LEND_NON_ED_BRC_ID
, RCPTV.GUARANTOR_ID
, NULL
, RCPTV.RECIPIENT_ID
, RCPTV.RECIPIENT_TYPE
, NULL
, RCPTV.RECIP_NON_ED_BRC_ID
, CLSET.EST_ORIG_FEE_PERCT
, CLSET.EST_GUARNT_FEE_PERCT
, CLSET.EST_ALT_ORIG_FEE_PERCT
, CLSET.EST_ALT_GUARNT_FEE_PERCT
, CLSET.HOLD_REL_IND
, CLSET.REQ_SERIAL_LOAN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE'
, CLSET.REQ_SERIAL_LOAN_CODE)
, NULL
, NULL
, CLSET.PRC_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PRC_TYPE_CODE)
, CLSET.PNOTE_DELIVERY_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY'
, CLSET.PNOTE_DELIVERY_CODE)
, NULL
, NULL
, CLSET.EFT_AUTHORIZATION EFT_AUTHORIZATION
, CLSET.AUTO_LATE_DISB_IND AUTO_LATE_DISB_IND
, CLSET.CL_VERSION
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_VERSION'
, CLSET.CL_VERSION)
, CLSET.CREATED_BY
, CLSET.CREATION_DATE
, CLSET.LAST_UPDATED_BY
, CLSET.LAST_UPDATE_DATE
, CLSET.LAST_UPDATE_LOGIN
, CLSET.RELATIONSHIP_CD
, RCPTV.RELATIONSHIP_CD_DESC
, CLSET.DEFAULT_FLAG
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND'
, CLSET.HOLD_REL_IND)
, CLSET.PLUS_PROCESSING_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PLUS_PROCESSING_TYPE_CODE)
, CLSET.FUND_RETURN_METHOD_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH'
, CLSET.FUND_RETURN_METHOD_CODE)
FROM IGF_SL_CL_SETUP CLSET
, IGS_CA_INST CI
, IGF_SL_CL_RECIPIENT RCPTV
WHERE CLSET.CI_CAL_TYPE = CI.CAL_TYPE
AND CLSET.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CLSET.RELATIONSHIP_CD = RCPTV.RELATIONSHIP_CD

Columns

Name
ROW_ID
CLSET_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CI_START_DT
CI_END_DT
CI_ALTERNATE_CODE
BORW_INTEREST_IND
OPE_ID
FAO_NAME
FAO_DUNS_ID
SCH_NON_ED_BRC_ID
LENDER_ID
DUNS_LENDER_ID
LEND_NON_ED_BRC_ID
GUARANTOR_ID
DUNS_GUARNT_ID
RECIPIENT_ID
RECIPIENT_TYPE
DUNS_RECIP_ID
RECIP_NON_ED_BRC_ID
EST_ORIG_FEE_PERCT
EST_GUARNT_FEE_PERCT
EST_ALT_ORIG_FEE_PERCT
EST_ALT_GUARNT_FEE_PERCT
HOLD_REL_IND
REQ_SERIAL_LOAN_CODE
REQ_SERIAL_LOAN_DESC
LOAN_AWARD_METHOD
LOAN_AWARD_METHOD_DESC
PRC_TYPE_CODE
PRC_TYPE_DESC
PNOTE_DELIVERY_CODE
PNOTE_DELIVERY_DESC
MEDIA_TYPE
MEDIA_TYPE_DESC
EFT_AUTHORIZATION
AUTO_LATE_DISB_IND
CL_VERSION
CL_VERSION_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
RELATIONSHIP_CD
RELATIONSHIP_CD_DESC
DEFAULT_FLAG
HOLD_CODE_DESC
PLUS_PROCESSING_TYPE_CODE
PLUS_PROCESSING_TYPE_DESC
FUND_RETURN_METHOD_CODE
FUND_RETURN_METHOD_DESC