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_DB_DL_DISB_RESP_ALL

Object Details

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

IGF_DB_DL_DISB_RESP_ALL holds the records from the Direct Loan disbursements acknowledgment file or booking notification file.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_DB_DL_DISB_RESP_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DDRP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DDRP_ID	NUMBER	(15)	Yes	Identifier for Direct loan disbursement acknowledgment record
DBTH_ID	NUMBER	(15)	Yes	Identifier for Direct Loan batch
LOAN_NUMBER	VARCHAR2	(30)	Yes	Indicates unique Direct Loan identifier
DISB_NUM	NUMBER	(15)	Yes	Identifier for disbursement number
DISB_ACTIVITY	VARCHAR2	(30)		Indicates type of transaction received on disbursement records from LOC
TRANSACTION_DATE	DATE			Indicates date on which activity took place in school
DISB_SEQ_NUM	NUMBER	(15)		Indicates sequence number that determines order in which disbursement activity transaction is processed for specific disbursement
DISB_GROSS_AMT	NUMBER	(12)		Indicates disbursement gross amount
FEE_1	NUMBER	(12)		Indicates actual origination fee associated with disbursement
DISB_NET_AMT	NUMBER	(12)		Indicates actual net disbursement amount for disbursement
INT_REBATE_AMT	NUMBER	(12)		Indicates actual adjustment amount for disbursement
USER_IDENT	VARCHAR2	(30)		Identifies user who created record
DISB_BATCH_ID	VARCHAR2	(30)		Indicates batch identifier for particular disbursement batch
SCHOOL_ID	VARCHAR2	(30)		Indicates Direct Loan school code
SCH_CODE_STATUS	VARCHAR2	(30)		Indicates status of particular school code at LOC
LOAN_NUM_STATUS	VARCHAR2	(30)		Indicates status of loan identifier at LOC
DISB_NUM_STATUS	VARCHAR2	(30)		Indicates status of disbursement number sent from LOC
DISB_ACTIVITY_STATUS	VARCHAR2	(30)		Indicates status of disbursement activity at LOC
TRANS_DATE_STATUS	VARCHAR2	(30)		Indicates status of date of disbursement record at LOC
DISB_SEQ_NUM_STATUS	VARCHAR2	(30)		Indicates status of sequence number with LOC
LOC_DISB_GROSS_AMT	NUMBER	(12)		Indicates actual gross amount calculated at LOC
LOC_FEE_1	NUMBER	(12)		Indicates actual loan fee amount calculated at LOC
LOC_DISB_NET_AMT	NUMBER	(12)		Indicates actual disbursement amount calculated at LOC
SERVICER_REFUND_AMT	NUMBER	(12)		Indicates amount of payment refund sent to servicer
LOC_INT_REBATE_AMT	NUMBER	(12)		Indicates actual interest rebate calculated at LOC
LOC_NET_BOOKED_LOAN	NUMBER	(12)		Indicates net disbursements accepted and booked by LOC for loan
ACK_DATE	DATE			Indicates date when Loan Origination Center acknowledged receipt of disbursement record
AFFIRM_FLAG	VARCHAR2	(30)		Indicates whether disbursement has been affirmed by borrower at school
STATUS	VARCHAR2	(30)	Yes	Used internally to track which records have been processed and successfully updated
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
REQUEST_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard Who column for concurrent programs
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT DDRP_ID
,      DBTH_ID
,      LOAN_NUMBER
,      DISB_NUM
,      DISB_ACTIVITY
,      TRANSACTION_DATE
,      DISB_SEQ_NUM
,      DISB_GROSS_AMT
,      FEE_1
,      DISB_NET_AMT
,      INT_REBATE_AMT
,      USER_IDENT
,      DISB_BATCH_ID
,      SCHOOL_ID
,      SCH_CODE_STATUS
,      LOAN_NUM_STATUS
,      DISB_NUM_STATUS
,      DISB_ACTIVITY_STATUS
,      TRANS_DATE_STATUS
,      DISB_SEQ_NUM_STATUS
,      LOC_DISB_GROSS_AMT
,      LOC_FEE_1
,      LOC_DISB_NET_AMT
,      SERVICER_REFUND_AMT
,      LOC_INT_REBATE_AMT
,      LOC_NET_BOOKED_LOAN
,      ACK_DATE
,      AFFIRM_FLAG
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM IGF.IGF_DB_DL_DISB_RESP_ALL;

Dependencies

[top of page]

IGF.IGF_DB_DL_DISB_RESP_ALL does not reference any database object

IGF.IGF_DB_DL_DISB_RESP_ALL is referenced by following:

APPS: IGF_DB_DL_DISB_RESP_ALL