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_DLOR_INTS

Object Details

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

Legacy Direct Loans Origination Interface Table
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_DLOR_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	CI_ALTERNATE_CODE PERSON_NUMBER AWARD_NUMBER_TXT
IGF_SL_LI_DLOR_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	IMPORT_STATUS_TYPE
IGF_SL_LI_DLOR_INTS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NUM	NUMBER	(15)	Yes	Batch Number, used to identify the set of records included in the batch for processing
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
LOAN_NUMBER_TXT	VARCHAR2	(21)	Yes	Unique identifier for Direct Loan or Common Line loan
IMPORT_STATUS_TYPE	VARCHAR2	(1)	Yes	Record's Import status
LOAN_SEQ_NUM	NUMBER	(3)	Yes	Indicates number of loans of current system loan type for current processing year
LOAN_PER_BEGIN_DATE	DATE		Yes	Indicates loan period start date
LOAN_PER_END_DATE	DATE		Yes	Indicates loan period end date
LOAN_STATUS_CODE	VARCHAR2	(30)	Yes	Indicates loan status
LOAN_STATUS_DATE	DATE			Indicates date on which loan status changed
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Indicator that specifies whether loan is active.
ACTIVE_DATE	DATE		Yes	Indicates date on which loan was activated or inactivated
ANTICIP_COMPL_DATE	DATE			Obsolete
BORR_PERSON_NUMBER	VARCHAR2	(30)		Borrower Person Number.
GRADE_LEVEL_CODE	VARCHAR2	(30)		Indicates grade level code of the student at the time the loan was originated
ORIG_ACKNOWLEDGEMENT_DATE	DATE			Origination Response Batch Date
ORIG_BATCH_DATE	DATE			Origination Send Batch Sent Date
ORIG_SEND_BATCH_ID_TXT	VARCHAR2	(23)		Origination Send Batch ID
PNOTE_STATUS_CODE	VARCHAR2	(30)		Indicates promissory note status code
PNOTE_BATCH_SEQ_NUM_TXT	VARCHAR2	(23)		Batch ID of the Promissory Note Acknowledgment file
PNOTE_ID_TXT	VARCHAR2	(21)		Master Promissory Note Identifier
PNOTE_PRINT_IND_CODE	VARCHAR2	(30)		Indicates promissory note print indicator
PNOTE_ACCEPT_AMT	NUMBER	(5)		Indicates total anticipated disbursement gross amount
PNOTE_ACCEPT_DATE	DATE			Indicates date on which total anticipated disbursement gross amount was accepted
UNSUB_ELIG_FOR_DEPNT_CODE	VARCHAR2	(30)		Indicates student is eligible for additional unsubsidized funds
UNSUB_ELIG_FOR_HEAL_CODE	VARCHAR2	(30)		Indicates student is eligible for additional unsubsidized funds in case of health professions
LOAN_CHG_STATUS	VARCHAR2	(30)		Indicates whether loan changes are pending
LOAN_CHG_STATUS_DATE	DATE			Indicates date on which loan status changed
PNOTE_STATUS_TYPE	VARCHAR2	(1)		Indicates Master Promissory Note Type
PNOTE_INDICATOR_CODE	VARCHAR2	(30)		Master Promissory Note Indicator
MPN_ACKNOWLEDGEMENT_DATE	DATE			Date on which the LOC acknowledged the receipt of the paper promissory note or promissory note or application
MPN_REJECT_CODE	VARCHAR2	(30)		Reason(s) the paper Promissory Note was rejected
CHANGE_STATUS_TYPE	VARCHAR2	(30)		Obsolete
ORIG_FEE_PERCT_NUM	NUMBER	(5)		Indicates origination fee percentage
CREDIT_DECISION_DATE	DATE			Indicates last date on which credit decision was updated
CREDIT_OVERRIDE_CODE	VARCHAR2	(30)		Indicates credit decision returned by external processor
ENDORSER_AMOUNT	NUMBER	(5)		Indicates Endorser Amount
CR_DESC_BATCH_ID_TXT	VARCHAR2	(23)		Indicates Credit Decision Acknowledgement Batch ID
ORIG_REJECT_CODE	VARCHAR2	(30)		Indicates reasons for rejection of origination
DISCLOSURE_PRINT_IND_CODE	VARCHAR2	(30)		Indicates whether LOC should print disclosure
S_DEFAULT_STATUS_CODE	VARCHAR2	(30)		Indicates the Student Default Grant Overpayment Status
SCH_CERT_DATE	DATE			Stores the school certification date
P_DEFAULT_STATUS_CODE	VARCHAR2	(30)		Indicates the Borrower Default Grant Overpayment Status
LOAN_APPROVED_AMT	NUMBER	(5)		Loan Approved Amount
IMPORT_RECORD_TYPE	VARCHAR2	(1)		Indicates whether the imported record is for Insert or Update
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
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
TRANSACTION_NUM	NUMBER			Indicates ISIR transaction number
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates Reporting entity id
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates Attending entity id
CREDIT_STATUS	VARCHAR2	(1)		Credit Status
ACAD_BEGIN_DATE	DATE			Academic start date
ACAD_END_DATE	DATE			Academic end date

Query Text

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


SELECT BATCH_NUM
,      CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      LOAN_NUMBER_TXT
,      IMPORT_STATUS_TYPE
,      LOAN_SEQ_NUM
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      LOAN_STATUS_CODE
,      LOAN_STATUS_DATE
,      ACTIVE_FLAG
,      ACTIVE_DATE
,      ANTICIP_COMPL_DATE
,      BORR_PERSON_NUMBER
,      GRADE_LEVEL_CODE
,      ORIG_ACKNOWLEDGEMENT_DATE
,      ORIG_BATCH_DATE
,      ORIG_SEND_BATCH_ID_TXT
,      PNOTE_STATUS_CODE
,      PNOTE_BATCH_SEQ_NUM_TXT
,      PNOTE_ID_TXT
,      PNOTE_PRINT_IND_CODE
,      PNOTE_ACCEPT_AMT
,      PNOTE_ACCEPT_DATE
,      UNSUB_ELIG_FOR_DEPNT_CODE
,      UNSUB_ELIG_FOR_HEAL_CODE
,      LOAN_CHG_STATUS
,      LOAN_CHG_STATUS_DATE
,      PNOTE_STATUS_TYPE
,      PNOTE_INDICATOR_CODE
,      MPN_ACKNOWLEDGEMENT_DATE
,      MPN_REJECT_CODE
,      CHANGE_STATUS_TYPE
,      ORIG_FEE_PERCT_NUM
,      CREDIT_DECISION_DATE
,      CREDIT_OVERRIDE_CODE
,      ENDORSER_AMOUNT
,      CR_DESC_BATCH_ID_TXT
,      ORIG_REJECT_CODE
,      DISCLOSURE_PRINT_IND_CODE
,      S_DEFAULT_STATUS_CODE
,      SCH_CERT_DATE
,      P_DEFAULT_STATUS_CODE
,      LOAN_APPROVED_AMT
,      IMPORT_RECORD_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_NUM
,      REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
,      CREDIT_STATUS
,      ACAD_BEGIN_DATE
,      ACAD_END_DATE
FROM IGF.IGF_SL_LI_DLOR_INTS;

Dependencies

[top of page]

IGF.IGF_SL_LI_DLOR_INTS does not reference any database object

IGF.IGF_SL_LI_DLOR_INTS is referenced by following:

APPS: IGF_SL_LI_DLOR_INTS