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_DLDB_INTS

Object Details

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

Stores Direct Loan Disbursements Interface Data
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Direct Loan Origination and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_DL

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_LI_DLDB_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	CI_ALTERNATE_CODE PERSON_NUMBER AWARD_NUMBER_TXT DISBURSEMENT_NUM DISBURSEMENT_SEQ_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.
DISBURSEMENT_SEQ_NUM	NUMBER	(2)	Yes	Disbursement Sequence Number. 1 to 99.
LOAN_NUMBER_TXT	VARCHAR2	(23)	Yes	Unique identifier for Direct Loan or Common Line loan
DISBURSEMENT_DATE	DATE		Yes	Disbursement Date
GROSS_DISBURSEMENT_AMT	NUMBER	(5)		Indicates gross disbursement amount for disbursement
BOOKING_BATCH_ID_TXT	VARCHAR2	(23)		Indicates batch identifier of disbursement file, which reports booking notification
BOOKED_DATE	DATE			Indicates booking notification date of adjustment record.
DISBURSEMENT_BATCH_ID_TXT	VARCHAR2	(23)		Indicates batch identifier of disbursement file, which reported adjustment record
DISBURSEMENT_ACTIVITY_CODE	VARCHAR2	(30)		Disbursement Activity code at LOC
DISBURSEMENT_ACTIVITY_ST_TXT	VARCHAR2	(10)		Indicates status of disbursement activity status at LOC
LOC_DISBURSEMENT_GROSS_AMT	NUMBER	(5)		Indicates actual gross amount calculated at LOC
LOC_FEE_1_AMT	NUMBER	(5)		Indicates actual loan fee amount calculated at LOC
ORIGINATION_FEES_PAID_AMT	NUMBER	(5)		Obsolete
LOC_DISBURSEMENT_NET_AMT	NUMBER	(5)	Yes	Indicates actual disbursement amount calculated at LOC
SERVICER_REFUND_AMT	NUMBER	(5)		Indicates amount of payment refund sent to servicer
LOC_INT_REBATE_AMT	NUMBER	(5)		Indicates actual interest rebate calculated at LOC
LOC_NET_BOOKED_LOAN_AMT	NUMBER	(5)		Indicates net disbursements accepted and booked by LOC for loan
ACKNOWLEDGEMENT_DATE	DATE			Indicates date when Loan Origination Center acknowledged receipt of disbursement record
SCHOOL_CODE_TXT	VARCHAR2	(6)		School Code
CONFIRMATION_FLAG	VARCHAR2	(1)		Indicates whether disbursement has been affirmed by borrower at school
INTEREST_REBATE_AMT	NUMBER	(5)		Interest Rebate amount
USER_IDENTIFIER_TXT	VARCHAR2	(8)		Identifies the User who created the record
DISBURSEMENT_ACTIVITY_DATE	DATE			Disbursement Activity Date
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

Query Text

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


SELECT CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      DISBURSEMENT_NUM
,      DISBURSEMENT_SEQ_NUM
,      LOAN_NUMBER_TXT
,      DISBURSEMENT_DATE
,      GROSS_DISBURSEMENT_AMT
,      BOOKING_BATCH_ID_TXT
,      BOOKED_DATE
,      DISBURSEMENT_BATCH_ID_TXT
,      DISBURSEMENT_ACTIVITY_CODE
,      DISBURSEMENT_ACTIVITY_ST_TXT
,      LOC_DISBURSEMENT_GROSS_AMT
,      LOC_FEE_1_AMT
,      ORIGINATION_FEES_PAID_AMT
,      LOC_DISBURSEMENT_NET_AMT
,      SERVICER_REFUND_AMT
,      LOC_INT_REBATE_AMT
,      LOC_NET_BOOKED_LOAN_AMT
,      ACKNOWLEDGEMENT_DATE
,      SCHOOL_CODE_TXT
,      CONFIRMATION_FLAG
,      INTEREST_REBATE_AMT
,      USER_IDENTIFIER_TXT
,      DISBURSEMENT_ACTIVITY_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_LI_DLDB_INTS;

Dependencies

[top of page]

IGF.IGF_SL_LI_DLDB_INTS does not reference any database object

IGF.IGF_SL_LI_DLDB_INTS is referenced by following:

APPS: IGF_SL_LI_DLDB_INTS