[Home] [Help] [Dependency Information]
Object Name: | IGFFV_DL_AWARD_DISBURSEMENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_DL_AWARD_DISBURSEMENTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Direct Loan Award Disbursements
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISBURSEMENT_GROSS_AMT | NUMBER | (12) | Yes | Indicates disbursement gross amount |
ORIGINATION_FEE | NUMBER | (12) | Indicates origination fees in case of Direct Loans and CommonLine loans | |
DISBURSEMENT_DATE | DATE | Yes | Indicates anticipated or actual disbursement date depending upon transaction type | |
DISBURSEMENT_NET_AMT | NUMBER | (12) | Yes | Indicates disbursement net amount |
DISBURSEMENT_ADJUSTMENT_AMT | NUMBER | (12) | Identifies difference in new and previous disbursement net amounts at time of adjustment | |
_LA:DISBURSEMENT_STATUS | CHAR | (67) | Indicates status of adjustment for particular student availing Direct Loan | |
DISBURSEMENT_STATUS_DATE | DATE | Indicates the date on which the disbursement status was changed | ||
_LA:DISBURSEMENT_ACTIVITY | CHAR | (67) | Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date | |
DISBURSEMENT_BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier of disbursement file, which reported adjustment record. Updated by Direct Loan origination process | |
DISBURSEMENT_ACK_DATE | DATE | Indicates adjustment record's acknowledgment by LOC in case of Direct Loans. Updated by Direct Loan acknowledgment process | ||
BOOKING_BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier of disbursement file, which reports booking notification. Updated by Direct Loan acknowledgment process | |
BOOKED_DATE | DATE | Indicates booking notification date of adjustment record. Updated by Direct Loan acknowledgment process | ||
LOAN_NUMBER | VARCHAR2 | (30) | Unique identifier for the loan | |
AWARD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar Type for Award Calendar |
AWARD_YEAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique Sequence Number for Award Calendar |
AWARD_YEAR | VARCHAR2 | (10) | Awarding Year | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
FIRST_NAME | VARCHAR2 | (150) | Person First Name | |
LAST_NAME | VARCHAR2 | (150) | Person Last Name | |
MIDDLE_NAME | VARCHAR2 | (60) | Person Middle Name | |
FUND_CODE | VARCHAR2 | (30) | Yes | Fund Code |
DESCRIPTION | VARCHAR2 | (80) | Fund Code Description | |
_LA:TRANSACTION_TYPE | CHAR | (62) | Indicates if transaction type is planned or actual | |
INTEREST_REBATE_AMT | NUMBER | (15) | Interest rebate amount as calculated for the loan amount | |
_LA:AFFIRMATION_FLAG | CHAR | (59) | Indicates whether student has confirmed for disbursement | |
INTERNAL_LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
BASE_ID | NUMBER | (10) | Yes | Unique identifier for student in financial aid |
PERSON_ID | NUMBER | (15) | Yes | Unique Person Identifier |
AWARD_ID | NUMBER | (15) | Yes | Identifier for awards |
DISBURSEMENT_NUMBER | NUMBER | (15) | Yes | Indicates disbursement number |
DISBURSEMENT_SEQUENCE_NUMBER | NUMBER | (15) | Yes | Identifies sequence of change to disbursement amount or disbursement date |
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 DISBURSEMENT_GROSS_AMT
, ORIGINATION_FEE
, DISBURSEMENT_DATE
, DISBURSEMENT_NET_AMT
, DISBURSEMENT_ADJUSTMENT_AMT
, _LA:DISBURSEMENT_STATUS
, DISBURSEMENT_STATUS_DATE
, _LA:DISBURSEMENT_ACTIVITY
, DISBURSEMENT_BATCH_ID
, DISBURSEMENT_ACK_DATE
, BOOKING_BATCH_ID
, BOOKED_DATE
, LOAN_NUMBER
, AWARD_CALENDAR_TYPE
, AWARD_YEAR_SEQUENCE_NUMBER
, AWARD_YEAR
, PERSON_NUMBER
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, FUND_CODE
, DESCRIPTION
, _LA:TRANSACTION_TYPE
, INTEREST_REBATE_AMT
, _LA:AFFIRMATION_FLAG
, INTERNAL_LOAN_ID
, BASE_ID
, PERSON_ID
, AWARD_ID
, DISBURSEMENT_NUMBER
, DISBURSEMENT_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_DL_AWARD_DISBURSEMENTS;
APPS.IGFFV_DL_AWARD_DISBURSEMENTS is not referenced by any database object
|
|
|