DBA Data[Home] [Help] [Dependency Information]


TABLE: IGF.IGF_SL_LI_DLDB_INTS

Object Details
Object Name: IGF_SL_LI_DLDB_INTS
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_SL_LI_DLDB_INTS
Subobject Name:
Status: VALID


Stores Direct Loan Disbursements Interface Data
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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_LI_DLDB_INTS_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCI_ALTERNATE_CODE
ColumnPERSON_NUMBER
ColumnAWARD_NUMBER_TXT
ColumnDISBURSEMENT_NUM
ColumnDISBURSEMENT_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
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
DISBURSEMENT_NUM NUMBER (2) Yes Disbursement Number.
DISBURSEMENT_SEQ_NUM NUMBER (2) Yes Disbursement Sequence Number. 1 to 99.
LOAN_NUMBER_TXT VARCHAR2 (23) Yes Unique identifier for Direct Loan or Common Line loan
DISBURSEMENT_DATE DATE
Yes Disbursement Date
GROSS_DISBURSEMENT_AMT NUMBER (5)
Indicates gross disbursement amount for disbursement
BOOKING_BATCH_ID_TXT VARCHAR2 (23)
Indicates batch identifier of disbursement file, which reports booking notification
BOOKED_DATE DATE

Indicates booking notification date of adjustment record.
DISBURSEMENT_BATCH_ID_TXT VARCHAR2 (23)
Indicates batch identifier of disbursement file, which reported adjustment record
DISBURSEMENT_ACTIVITY_CODE VARCHAR2 (30)
Disbursement Activity code at LOC
DISBURSEMENT_ACTIVITY_ST_TXT VARCHAR2 (10)
Indicates status of disbursement activity status at LOC
LOC_DISBURSEMENT_GROSS_AMT NUMBER (5)
Indicates actual gross amount calculated at LOC
LOC_FEE_1_AMT NUMBER (5)
Indicates actual loan fee amount calculated at LOC
ORIGINATION_FEES_PAID_AMT NUMBER (5)
Obsolete
LOC_DISBURSEMENT_NET_AMT NUMBER (5) Yes Indicates actual disbursement amount calculated at LOC
SERVICER_REFUND_AMT NUMBER (5)
Indicates amount of payment refund sent to servicer
LOC_INT_REBATE_AMT NUMBER (5)
Indicates actual interest rebate calculated at LOC
LOC_NET_BOOKED_LOAN_AMT NUMBER (5)
Indicates net disbursements accepted and booked by LOC for loan
ACKNOWLEDGEMENT_DATE DATE

Indicates date when Loan Origination Center acknowledged receipt of disbursement record
SCHOOL_CODE_TXT VARCHAR2 (6)
School Code
CONFIRMATION_FLAG VARCHAR2 (1)
Indicates whether disbursement has been affirmed by borrower at school
INTEREST_REBATE_AMT NUMBER (5)
Interest Rebate amount
USER_IDENTIFIER_TXT VARCHAR2 (8)
Identifies the User who created the record
DISBURSEMENT_ACTIVITY_DATE DATE

Disbursement Activity Date
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
Query Text

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


SELECT CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      DISBURSEMENT_NUM
,      DISBURSEMENT_SEQ_NUM
,      LOAN_NUMBER_TXT
,      DISBURSEMENT_DATE
,      GROSS_DISBURSEMENT_AMT
,      BOOKING_BATCH_ID_TXT
,      BOOKED_DATE
,      DISBURSEMENT_BATCH_ID_TXT
,      DISBURSEMENT_ACTIVITY_CODE
,      DISBURSEMENT_ACTIVITY_ST_TXT
,      LOC_DISBURSEMENT_GROSS_AMT
,      LOC_FEE_1_AMT
,      ORIGINATION_FEES_PAID_AMT
,      LOC_DISBURSEMENT_NET_AMT
,      SERVICER_REFUND_AMT
,      LOC_INT_REBATE_AMT
,      LOC_NET_BOOKED_LOAN_AMT
,      ACKNOWLEDGEMENT_DATE
,      SCHOOL_CODE_TXT
,      CONFIRMATION_FLAG
,      INTEREST_REBATE_AMT
,      USER_IDENTIFIER_TXT
,      DISBURSEMENT_ACTIVITY_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_LI_DLDB_INTS;

Dependencies

[top of page]

IGF.IGF_SL_LI_DLDB_INTS does not reference any database object

IGF.IGF_SL_LI_DLDB_INTS is referenced by following:

SchemaAPPS
SynonymIGF_SL_LI_DLDB_INTS