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_LI_ORG_DISB_INTS

Object Details

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

Legacy Common line Origination Disbursement Interface Table
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - FFELP Origination and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_FFELP

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_LI_ORG_DISB_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	CI_ALTERNATE_CODE PERSON_NUMBER AWARD_NUMBER_TXT DISBURSEMENT_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
CI_ALTERNATE_CODE	VARCHAR2	(10)	Yes	Alternate Code of the Batch Year.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
AWARD_NUMBER_TXT	VARCHAR2	(15)	Yes	Award Number
DISBURSEMENT_NUM	NUMBER	(2)	Yes	Disbursement Number. 1 to 99.
LOAN_NUMBER_TXT	VARCHAR2	(30)	Yes	Unique identifier for Direct Loan or Common Line loan
DISBURSEMENT_DATE	DATE		Yes	Disbursement Date
RECORD_TYPE	VARCHAR2	(1)		Record Type Code
SCHOOL_USE_TXT	VARCHAR2	(23)		For School Use Only
LENDER_USE_TXT	VARCHAR2	(20)		For lender use only
SCH_DISBURSEMENT_NUM	NUMBER	(2)		Indicates the scheduled number of disbursements.
FUND_RELEASE_DATE	DATE			Indicates date on which funds are released to school or disbursing agency
GUARANTOR_USE_TXT	VARCHAR2	(23)		For Guarantor Use Only
GUARANTEE_DATE	DATE			Indicates date on which loan was guaranteed
GUARANTEE_AMT	NUMBER	(7)		Indicates guarantee amount for loan
GROSS_DISBURSEMENT_AMT	NUMBER	(7)		Indicates gross disbursement amount for disbursement
ORIGINATION_FEE_AMT	NUMBER	(7)		Indicates origination fee for disbursement
GUARANTEE_FEE_AMT	NUMBER	(7)		Indicates guarantee fees for disbursement
FUND_DIST_MTHD_TYPE	VARCHAR2	(1)		Indicates the Fund Distribution Method
CHECK_NUMBER_TXT	VARCHAR2	(15)		Identities identification number assigned to check for disbursement
LATE_DISBURSEMENT_FLAG	VARCHAR2	(1)		Late Disbursement Indicator
PREV_REPORTED_FLAG	VARCHAR2	(1)		Disbursement adjustment previously reported Indicator
ERR_MESG_1_CD	VARCHAR2	(3)		Indicates error occurred while processing file
ERR_MESG_2_CD	VARCHAR2	(3)		Indicates error occurred while processing file
ERR_MESG_3_CD	VARCHAR2	(3)		Indicates error occurred while processing file
ERR_MESG_4_CD	VARCHAR2	(3)		Indicates error occurred while processing file
ERR_MESG_5_CD	VARCHAR2	(3)		Indicates error occurred while processing file
GUARANTEE_FEES_PAID_AMT	NUMBER	(7)		Indicates total amount of guarantee fees subsidized by guarantor on behalf of borrower for disbursement
NET_CANCEL_AMT	NUMBER	(7)		Indicates amount of previously reported disbursement cancelled or reduced
DISBURSEMENT_HLD_RELEASE_FLAG	VARCHAR2	(1)		Disbursement Hold Release Indicator
PNOTE_CODE	VARCHAR2	(30)		Indicates the Promissory Note Code
PNOTE_STATUS_DATE	DATE			Indicates date on which promissory note status was set
ORIGINATION_FEES_PAID_AMT	NUMBER	(7)		Indicates total amount of origination fees subsidized by lender on behalf of borrower for disbursement
NETTED_CANCEL_AMT	NUMBER	(7)		Indicates portion of net cancellation amount that will be deducted from disbursement roster
OUTSTD_CANCEL_AMT	NUMBER	(7)		Indicates portion of net cancellation amount still outstanding
DISBURSEMENT_STATUS_CODE	VARCHAR2	(30)		Indicates the disbursement status
DISBURSEMENT_STATUS_DATE	DATE			Disbursement Status Date
FUND_STATUS_CODE	VARCHAR2	(30)		Fund Status Code
FUND_STATUS_DATE	DATE			Fund Status Date
LENDER_NAME	VARCHAR2	(15)		Lender Name
ROSTER_BATCH_ID_TXT	VARCHAR2	(12)		Disbursement Roster Batch ID
FILE_CREATION_DATE	DATE			File Creation Date
FILE_TRANS_DATE	DATE			File Transmitted Date
RECIPIENT_ID_TXT	VARCHAR2	(8)		Recipient ID
RECIPIENT_NON_ED_BRC_ID_TXT	VARCHAR2	(4)		Recipient Non-ED Branch ID
SOURCE_ID_TXT	VARCHAR2	(8)		Source Identifier
SOURCE_NON_ED_BRC_ID_TXT	VARCHAR2	(4)		Source Non ED Identifier
SEND_RESP_CODE	VARCHAR2	(30)		File Identifier Codes i.e. send record, response record.
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
DIRECT_TO_BORR_FLAG	VARCHAR2	(1)		Direct Disbursement to Borrower Indicator

Query Text

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


SELECT CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      DISBURSEMENT_NUM
,      LOAN_NUMBER_TXT
,      DISBURSEMENT_DATE
,      RECORD_TYPE
,      SCHOOL_USE_TXT
,      LENDER_USE_TXT
,      SCH_DISBURSEMENT_NUM
,      FUND_RELEASE_DATE
,      GUARANTOR_USE_TXT
,      GUARANTEE_DATE
,      GUARANTEE_AMT
,      GROSS_DISBURSEMENT_AMT
,      ORIGINATION_FEE_AMT
,      GUARANTEE_FEE_AMT
,      FUND_DIST_MTHD_TYPE
,      CHECK_NUMBER_TXT
,      LATE_DISBURSEMENT_FLAG
,      PREV_REPORTED_FLAG
,      ERR_MESG_1_CD
,      ERR_MESG_2_CD
,      ERR_MESG_3_CD
,      ERR_MESG_4_CD
,      ERR_MESG_5_CD
,      GUARANTEE_FEES_PAID_AMT
,      NET_CANCEL_AMT
,      DISBURSEMENT_HLD_RELEASE_FLAG
,      PNOTE_CODE
,      PNOTE_STATUS_DATE
,      ORIGINATION_FEES_PAID_AMT
,      NETTED_CANCEL_AMT
,      OUTSTD_CANCEL_AMT
,      DISBURSEMENT_STATUS_CODE
,      DISBURSEMENT_STATUS_DATE
,      FUND_STATUS_CODE
,      FUND_STATUS_DATE
,      LENDER_NAME
,      ROSTER_BATCH_ID_TXT
,      FILE_CREATION_DATE
,      FILE_TRANS_DATE
,      RECIPIENT_ID_TXT
,      RECIPIENT_NON_ED_BRC_ID_TXT
,      SOURCE_ID_TXT
,      SOURCE_NON_ED_BRC_ID_TXT
,      SEND_RESP_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DIRECT_TO_BORR_FLAG
FROM IGF.IGF_SL_LI_ORG_DISB_INTS;

Dependencies

[top of page]

IGF.IGF_SL_LI_ORG_DISB_INTS does not reference any database object

IGF.IGF_SL_LI_ORG_DISB_INTS is referenced by following:

APPS: IGF_SL_LI_ORG_DISB_INTS