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_AWD_DISB_DTL_ALL

Object Details

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

IGF_DB_AWD_DISB_DTL_ALL stores all actual disbursement transactions and adjustments made to these after they have been posted to the student finance interface table. This table will not have any records for planned disbursements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_DB_AWD_DISB_DTL_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_ID DISB_NUM DISB_SEQ_NUM
IGF_DB_AWD_DISB_DTL_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SF_CREDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISB_NUM	NUMBER	(15)	Yes	Identifier for disbursements. Number of disbursement.
DISB_SEQ_NUM	NUMBER	(15)	Yes	Identifies sequence of change to disbursement amount or disbursement date
DISB_GROSS_AMT	NUMBER	(12)	Yes	Indicates new gross disbursement amount after adjustment
FEE_1	NUMBER	(12)		Indicates new origination fees in case of Direct Loan or CommonLine loans at time of adjustment
FEE_2	NUMBER	(12)		Indicates new guarantee fees in case of CommonLine loans at time of adjustment
DISB_NET_AMT	NUMBER	(12)	Yes	Indicates new disbursement net amount at time of adjustment
DISB_ADJ_AMT	NUMBER	(12)		Identifies difference in new and previous disbursement net amounts at time of adjustment
DISB_DATE	DATE		Yes	Identifies new disbursement date after disbursement date change or existing value of disbursement date at time of adjustment
FEE_PAID_1	NUMBER	(12)		Identifies origination fees paid in case of CommonLine loans at time of adjustment
FEE_PAID_2	NUMBER	(12)		Identifies guarantee fees paid in case of CommonLine loans at time of adjustment
DISB_ACTIVITY	VARCHAR2	(30)		Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date
DISB_BATCH_ID	VARCHAR2	(40)		No longer used.
DISB_ACK_DATE	DATE			No longer used.
BOOKING_BATCH_ID	VARCHAR2	(40)		No longer used.
BOOKED_DATE	DATE			No longer used.
DISB_STATUS	VARCHAR2	(30)		No longer used.
DISB_STATUS_DATE	DATE			No longer used.
SF_STATUS	VARCHAR2	(30)		Indicates student finance status of adjustment
SF_STATUS_DATE	DATE			Indicates student finance adjustment status date
SF_INVOICE_NUM	NUMBER	(15)		Indicates invoice number for adjustment, as in Oracle Accounts Receivables, when disbursement or adjustment is posted to student's account
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
SPNSR_CREDIT_ID	NUMBER	(15)		Indicates the Sponsor's Credit Identifier
SPNSR_CHARGE_ID	NUMBER	(15)		Indicates the Sponsor's Charge Identifier
SF_CREDIT_ID	NUMBER	(15)		Indicates the Student Finance Credit Identifier
ERROR_DESC	VARCHAR2	(2000)		Indicates the Error occurred when the adjustment record is posted to the Student Finance Interface Table.
NOTIFICATION_DATE	DATE			This is Correspondence Process Date, Updated by post process once the Loan Disbursement Letter has been sent to the student
INTEREST_REBATE_AMT	NUMBER			Indicates interest rebate amount.
LD_CAL_TYPE	VARCHAR2	(10)		Load calendar Type
LD_SEQUENCE_NUMBER	NUMBER	(6)		Load Sequence Number

Query Text

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


SELECT AWARD_ID
,      DISB_NUM
,      DISB_SEQ_NUM
,      DISB_GROSS_AMT
,      FEE_1
,      FEE_2
,      DISB_NET_AMT
,      DISB_ADJ_AMT
,      DISB_DATE
,      FEE_PAID_1
,      FEE_PAID_2
,      DISB_ACTIVITY
,      DISB_BATCH_ID
,      DISB_ACK_DATE
,      BOOKING_BATCH_ID
,      BOOKED_DATE
,      DISB_STATUS
,      DISB_STATUS_DATE
,      SF_STATUS
,      SF_STATUS_DATE
,      SF_INVOICE_NUM
,      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
,      SPNSR_CREDIT_ID
,      SPNSR_CHARGE_ID
,      SF_CREDIT_ID
,      ERROR_DESC
,      NOTIFICATION_DATE
,      INTEREST_REBATE_AMT
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
FROM IGF.IGF_DB_AWD_DISB_DTL_ALL;

Dependencies

[top of page]

IGF.IGF_DB_AWD_DISB_DTL_ALL does not reference any database object

IGF.IGF_DB_AWD_DISB_DTL_ALL is referenced by following:

APPS: IGF_DB_AWD_DISB_DTL_ALL