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_AW_LI_DACT_INTS

Object Details

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

Award Disbursement Activity Interface Table for Legacy Data Import
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Award and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_AWARD

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	Mandatory	Comments
CI_ALTERNATE_CODE	VARCHAR2	(10)	Yes	Award Year Calendar Instance Alternate Code (Award Year) of the Financial Aid Award.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of the Financial Aid Award.
AWARD_NUMBER_TXT	VARCHAR2	(15)	Yes	Unique Award Number of the Financial Aid Award for the student in context.
DISBURSEMENT_NUM	NUMBER	(15)	Yes	Disbursement Number of the award.
DISB_ACTIVITY_NUM	NUMBER	(15)	Yes	Identifies sequence of change to disbursement amount or disbursement date
DISB_ACTIVITY_TYPE	VARCHAR2	(30)		Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date
DISB_NET_AMT	NUMBER	(12)		Indicates new disbursement net amount 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
SF_STATUS_CODE	VARCHAR2	(30)		Indicates student finance status of adjustment
SF_STATUS_DATE	DATE			Indicates student finance adjustment status date
SF_INVOICE_NUM_TXT	VARCHAR2	(60)		Indicates invoice number for adjustment, as in Oracle Accounts Receivables, when disbursement or adjustment is posted to student's account
SF_CREDIT_NUM_TXT	VARCHAR2	(60)		Indicates the Student Finance Credit Identifier
DISB_STATUS_CODE	VARCHAR2	(30)		Indicates status of adjustment for particular student availing Direct Loan
NOTIFICATION_DATE	DATE			This is Correspondence Process Date, Updated by post process once the Loan Disbursement Letter has been sent to the student
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
SPNSR_CREDIT_NUM_TXT	VARCHAR2	(60)		Indicates the sponsor's credit identifier.
SPNSR_CHARGE_NUM_TXT	VARCHAR2	(60)		Indicates the sponsor's charge identifier.
DISBURSEMENT_ACCEPTED_AMT	NUMBER			Indicates disbursement accepted amount
INTEREST_REBATE_AMT	NUMBER			Indicates interest rebate amount
ORIGINATION_FEE_AMT	NUMBER			Indicates origination fee amount
GUARNTEE_FEE_AMT	NUMBER			Indicates guarantee fee amount
ORIGINATION_FEE_PAID_AMT	NUMBER			Indicates origination fee paid amount
GUARNTEE_FEE_PAID_AMT	NUMBER			Indicates guarantee fee paid amount

Query Text

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


SELECT CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      DISBURSEMENT_NUM
,      DISB_ACTIVITY_NUM
,      DISB_ACTIVITY_TYPE
,      DISB_NET_AMT
,      DISB_DATE
,      SF_STATUS_CODE
,      SF_STATUS_DATE
,      SF_INVOICE_NUM_TXT
,      SF_CREDIT_NUM_TXT
,      DISB_STATUS_CODE
,      NOTIFICATION_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SPNSR_CREDIT_NUM_TXT
,      SPNSR_CHARGE_NUM_TXT
,      DISBURSEMENT_ACCEPTED_AMT
,      INTEREST_REBATE_AMT
,      ORIGINATION_FEE_AMT
,      GUARNTEE_FEE_AMT
,      ORIGINATION_FEE_PAID_AMT
,      GUARNTEE_FEE_PAID_AMT
FROM IGF.IGF_AW_LI_DACT_INTS;

Dependencies

[top of page]

IGF.IGF_AW_LI_DACT_INTS does not reference any database object

IGF.IGF_AW_LI_DACT_INTS is referenced by following:

APPS: IGF_AW_LI_DACT_INTS