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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGF.IGF_SL_CL_SETUP_ALL

Object Details

Object Name:	IGF_SL_CL_SETUP_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_CL_SETUP_ALL
Subobject Name:
Status:	VALID

IGF_SL_CL_SETUP_ALL maintains the setup or default information for CommonLine, or FFELP, loans.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_CL_SETUP_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLSET_ID
IGF_SL_CL_SETUP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_CAL_TYPE CI_SEQUENCE_NUMBER RELATIONSHIP_CD PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLSET_ID	NUMBER	(15)	Yes	Identfier for CommonLine Setup
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calender type. Used within operating unit.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates unique identifier for award year calender instance
BORW_INTEREST_IND	VARCHAR2	(30)		Indicates whether borrower intends to pay interest on loan while in school, grace, or deferment
SCH_NON_ED_BRC_ID	VARCHAR2	(30)		FA126_3102439_CS_DP2.doc - Obsolete
LENDER_ID	VARCHAR2	(30)		Obsolete
DUNS_LENDER_ID	VARCHAR2	(30)		Obsolete
LEND_NON_ED_BRC_ID	VARCHAR2	(30)		Obsolete
GUARANTOR_ID	VARCHAR2	(30)		Obsolete
DUNS_GUARNT_ID	VARCHAR2	(30)		Obsolete
RECIPIENT_ID	VARCHAR2	(30)		Obsolete
RECIPIENT_TYPE	VARCHAR2	(30)		Obsolete
DUNS_RECIP_ID	VARCHAR2	(30)		Obsolete
RECIP_NON_ED_BRC_ID	VARCHAR2	(30)		Obsolete
EST_ORIG_FEE_PERCT	NUMBER	(12)		Indicates estimated origination fees
EST_GUARNT_FEE_PERCT	NUMBER	(12)		Indicates estimated guarantee fees
HOLD_REL_IND	VARCHAR2	(30)	Yes	Indicates default for hold or release indicator when submitting origination records
REQ_SERIAL_LOAN_CODE	VARCHAR2	(30)	Yes	Indicates how school intends to use master promissory note. Can be new, use MPN or serial, or renew existing MPN.
LOAN_AWARD_METHOD	VARCHAR2	(30)		Obsolete
PRC_TYPE_CODE	VARCHAR2	(30)	Yes	FFELP Processing Type code for FFELP Stafford Loans.
PNOTE_DELIVERY_CODE	VARCHAR2	(30)	Yes	Indicates preferred method of delivering promissory note to borrower. Values are e-mail, paper, or web.
MEDIA_TYPE	VARCHAR2	(30)		Obsolete
EFT_AUTHORIZATION	VARCHAR2	(30)		Indicates whether student is required to authorize for transfer of loan proceeds. Values are Y or N.
AUTO_LATE_DISB_IND	VARCHAR2	(30)		Indicates whether fund late disbursements reported in disbursement roster are automatically set to funded or are set manually by user
CL_VERSION	VARCHAR2	(30)		CommonLine Processing Version
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ORG_ID	NUMBER	(15)		Operating unit identifier
EST_ALT_ORIG_FEE_PERCT	NUMBER	(12)		Indicates the Estimated Origination Fee Percentage for Alternative Loans
EST_ALT_GUARNT_FEE_PERCT	NUMBER	(12)		Indicates the Estimated Guarantee Fee Percentage for Alternative Loans
RELATIONSHIP_CD	VARCHAR2	(30)		Relationship code
PARTY_ID	NUMBER	(15)		Party ID
DEFAULT_FLAG	VARCHAR2	(1)		Default relationship
PLUS_PROCESSING_TYPE_CODE	VARCHAR2	(30)		FFELP Processing Type code for FFELP PLUS and Alternative Loans
FUND_RETURN_METHOD_CODE	VARCHAR2	(30)		Default Fund Return Method code for a Lender Relationship.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLSET_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      BORW_INTEREST_IND
,      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
,      HOLD_REL_IND
,      REQ_SERIAL_LOAN_CODE
,      LOAN_AWARD_METHOD
,      PRC_TYPE_CODE
,      PNOTE_DELIVERY_CODE
,      MEDIA_TYPE
,      EFT_AUTHORIZATION
,      AUTO_LATE_DISB_IND
,      CL_VERSION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      EST_ALT_ORIG_FEE_PERCT
,      EST_ALT_GUARNT_FEE_PERCT
,      RELATIONSHIP_CD
,      PARTY_ID
,      DEFAULT_FLAG
,      PLUS_PROCESSING_TYPE_CODE
,      FUND_RETURN_METHOD_CODE
FROM IGF.IGF_SL_CL_SETUP_ALL;

Dependencies

[top of page]

IGF.IGF_SL_CL_SETUP_ALL does not reference any database object

IGF.IGF_SL_CL_SETUP_ALL is referenced by following:

APPS: IGF_SL_CL_SETUP_ALL