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]

Table: IGF_SL_CL_RECIPIENT

Product:	IGF - Financial Aid (Obsolete)
Description:	Maintains the relationships between the lenders, guarantors, and recipients
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGF_SL_CL_RECIPIENT_PK

RCPT_ID

Primary Key: IGF_SL_CL_RECIPIENT_U1

LENDER_ID
LEND_NON_ED_BRC_ID
GUARANTOR_ID
RECIPIENT_ID
RECIP_NON_ED_BRC_ID
RELATIONSHIP_CD

Primary Key: IGF_SL_CL_RECIPIENT_U2

RELATIONSHIP_CD

Primary Key: RCPT_UK

LENDER_ID
LEND_NON_ED_BRC_ID
GUARANTOR_ID
RECIPIENT_ID
RECIP_NON_ED_BRC_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGF_SL_CL_RECIPIENT	IGF_SL_GUARANTOR	IGF_SL_CL_RECIPIENT.GUARANTOR_ID
IGF_SL_CL_RECIPIENT	IGF_SL_LENDER_BRC	IGF_SL_CL_RECIPIENT.LENDER_ID IGF_SL_CL_RECIPIENT.LEND_NON_ED_BRC_ID
IGF_SL_CL_RECIPIENT	IGF_SL_LENDER	IGF_SL_CL_RECIPIENT.LENDER_ID
IGF_AW_FUND_CAT_ALL	IGF_SL_CL_RECIPIENT	IGF_AW_FUND_CAT_ALL.ALT_REL_CODE
IGF_SL_CL_PREF_LENDERS	IGF_SL_CL_RECIPIENT	IGF_SL_CL_PREF_LENDERS.RELATIONSHIP_CD
IGF_SL_CL_SETUP_ALL	IGF_SL_CL_RECIPIENT	IGF_SL_CL_SETUP_ALL.RELATIONSHIP_CD
IGF_SL_LOR_ALL	IGF_SL_CL_RECIPIENT	IGF_SL_LOR_ALL.RELATIONSHIP_CD