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_DL_BATCH_ALL

Object Details

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

IGF_SL_DL_BATCH_ALL maintains the Direct Loan batch information sent or received.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_DL_BATCH_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DBTH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DBTH_ID	NUMBER	(15)	Yes	Identifier for Direct Loan batch data
BATCH_ID	VARCHAR2	(40)	Yes	Batch identifier for file created or loaded
MESSAGE_CLASS	VARCHAR2	(30)	Yes	Indicates message class file name as recognized by LOC
BTH_CREATION_DATE	DATE		Yes	Indicates date on which file was created
BATCH_REJ_CODE	VARCHAR2	(30)		Indicates reason for Loan Origination Center rejecting entire batch. Values are duplicate batch identifier number, school code indicates non-direct loan participant, file contains non-ASCII keyboard printable characters, batch not processed, invalid message class, or not in use.
END_DATE	DATE			Not currently used
BATCH_TYPE	VARCHAR2	(30)		Indicates batch type, which was sent to Loan Origination Center or received from Loan Origination Center. Values are Stafford full origination, PLUS full origination, import PLUS credit decision, origination change, disbursement details, or booking notification from Loan Origination Center.
SEND_RESP	VARCHAR2	(30)		Indicate send file or response file
STATUS	VARCHAR2	(30)	Yes	Indicates all batches processed and successfully updated for internal tracking. Values are successfully updated, not updated loan origination record, or error response file not uploaded.
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 DBTH_ID
,      BATCH_ID
,      MESSAGE_CLASS
,      BTH_CREATION_DATE
,      BATCH_REJ_CODE
,      END_DATE
,      BATCH_TYPE
,      SEND_RESP
,      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_SL_DL_BATCH_ALL;

Dependencies

[top of page]

IGF.IGF_SL_DL_BATCH_ALL does not reference any database object

IGF.IGF_SL_DL_BATCH_ALL is referenced by following:

APPS: IGF_SL_DL_BATCH_ALL