[Home] [Help] [Dependency Information]
Object Name: | IGFBV_DIRECT_LOAN_ORIGINATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_DIRECT_LOAN_ORIGINATIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Financial Aid Direct Loan Originations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHOOL_CERTIFICATION_DATE | DATE | Indicates date on which school certified loan | ||
ORIGINATION_FEES_PERCENT | NUMBER | (6) | Indicates origination fee percentage | |
_LA:LOAN_ORIGIANTION_STATUS | CHAR | (73) | Indicates loan origination status | |
LOAN_ORIGINATION_BATCH_ID | VARCHAR2 | (40) | Batch identifier for loan originated | |
LOAN_ORIGINATION_BATCH_DATE | DATE | Indicates date on which loan originated | ||
PROMISSORY_NOTE_ID | VARCHAR2 | (30) | Identifier for promissory note status | |
PROMISSORY_NOTE_BATCH_ID | VARCHAR2 | (40) | Batch ID of the Promissory Note Acknowledgment file | |
PROMISSORY_NOTE_ACK_DATE | DATE | Date on which the LOC acknowledged the receipt of the paper promissory note or promissory note or application | ||
PROMISSORY_NOTE_STATUS_DATE | DATE | Indicates date on which promissory note status changed by service provider | ||
_LA:GRADE_LEVEL | CHAR | (68) | Indicates grade level code of student at time loan originated | |
_LA:PROMISSORY_NOTE_STATUS | CHAR | (65) | Indicates promissory note status | |
_LA:PROMISSORY_NOTE_PRINT | CHAR | (71) | Indicates promissory note print indicator | |
_LA:HEAL_ELIGIBILITY | CHAR | (76) | Indicates student is eligible for additional unsubsidized funds in case of health professions | |
_LA:DEPENDENT_ELIGIBILITY | CHAR | (78) | Indicates student is eligible for additional unsubsidized funds | |
_LA:STUDENT_DEFAULT_STATUS | CHAR | (73) | Indicates student borrower's default status for loan | |
_LA:BORROWER_DEFAULT_STATUS | CHAR | (73) | Indicates parent borrower's default or refund status on Title IV loans | |
_LA:PROMISSORY_NOTE_TYPE | CHAR | (63) | Master Promissory Note Type | |
_LA:PROMISSORY_NOTE_LINK | CHAR | (64) | Master Promissory Note Indicator. Y - Linked and N - Not Linked | |
_LA:CREDIT_OVERRIDE_IND | CHAR | (71) | Indicates credit decision returned by external processor | |
CREDIT_DECISION_DATE | DATE | Indicates last date on which credit decision was updated | ||
ENDORSER_AMOUNT | NUMBER | (12) | Indicates total anticipated disbursement gross amount | |
LOAN_NUMBER | VARCHAR2 | (30) | Identifier for loans | |
LOAN_PERIOD_BEGIN_DATE | DATE | Yes | Indicates loan period start date | |
LOAN_PERIOD_END_DATE | DATE | Yes | Indicates loan period end date | |
_LA:LOAN_RECORD_STATUS | CHAR | (65) | Indicates loan status | |
LOAN_ORIGINATION_STATUS_DATE | DATE | Indicates date on which loan status changed | ||
LOAN_IS_ACTIVE | VARCHAR2 | (1) | Yes | Indicator that specifies whether loan is active. Setting check box to inactive prevents use of loan in new or modified records |
LOAN_IS_ACTIVE_DATE | DATE | Yes | Indicates date on which loan was activated or inactivated | |
AWARD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar Type for Award Calendar |
AWARD_YEAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique Sequence Number for Award Calendar |
LOAN_AMOUNT | NUMBER | (12) | Total award amount accepted | |
PLUS_BORROW_PERSON_ID | NUMBER | (15) | Identifier for parent or alternate borrower from TCA | |
BASE_ID | NUMBER | (10) | Yes | Unique identifier for student in financial aid |
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
INETRNAL_ORIGINATION_ID | NUMBER | (15) | Yes | Identifier for loan origination |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SCHOOL_CERTIFICATION_DATE
, ORIGINATION_FEES_PERCENT
, _LA:LOAN_ORIGIANTION_STATUS
, LOAN_ORIGINATION_BATCH_ID
, LOAN_ORIGINATION_BATCH_DATE
, PROMISSORY_NOTE_ID
, PROMISSORY_NOTE_BATCH_ID
, PROMISSORY_NOTE_ACK_DATE
, PROMISSORY_NOTE_STATUS_DATE
, _LA:GRADE_LEVEL
, _LA:PROMISSORY_NOTE_STATUS
, _LA:PROMISSORY_NOTE_PRINT
, _LA:HEAL_ELIGIBILITY
, _LA:DEPENDENT_ELIGIBILITY
, _LA:STUDENT_DEFAULT_STATUS
, _LA:BORROWER_DEFAULT_STATUS
, _LA:PROMISSORY_NOTE_TYPE
, _LA:PROMISSORY_NOTE_LINK
, _LA:CREDIT_OVERRIDE_IND
, CREDIT_DECISION_DATE
, ENDORSER_AMOUNT
, LOAN_NUMBER
, LOAN_PERIOD_BEGIN_DATE
, LOAN_PERIOD_END_DATE
, _LA:LOAN_RECORD_STATUS
, LOAN_ORIGINATION_STATUS_DATE
, LOAN_IS_ACTIVE
, LOAN_IS_ACTIVE_DATE
, AWARD_CALENDAR_TYPE
, AWARD_YEAR_SEQUENCE_NUMBER
, LOAN_AMOUNT
, PLUS_BORROW_PERSON_ID
, BASE_ID
, PERSON_ID
, INETRNAL_ORIGINATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_DIRECT_LOAN_ORIGINATIONS;
APPS.IGFBV_DIRECT_LOAN_ORIGINATIONS is not referenced by any database object
|
|
|