[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_AWARD_DISBURSEMENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_AWARD_DISBURSEMENTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the information of each disbursement.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AWARD_ID | NUMBER | (15) | Yes | Identifier for awards |
| DISBURSEMENT_NUMBER | NUMBER | (15) | Yes | Identifier for disbursements |
| DISBURSEMENT_GROSS_AMOUNT | NUMBER | Yes | Gross amount of the disbursement | |
| DL_FFELP_ORIGINATION_FEE | NUMBER | Origination fees in case of Direct Loan lender fees or CommonLine | ||
| FFELP_GUARANTEE_FEE | NUMBER | Guarantor fees in case of CommonLine | ||
| DISBURSEMENT_NET_AMOUNT | NUMBER | Yes | Disbursement net amount( DISB_GROSS_AMT - FEE_1 - FEE_2 + FEE_PAID_1 + FEE_PAID_2) | |
| DISBURSEMENT_DATE | DATE | Yes | Disbursement date | |
| _LA:TRANSACTION_TYPE | CHAR | (61) | Indicates if transaction type is planned or actual | |
| _LA:ELIGIBILITY_STATUS | CHAR | (63) | Indicates student's eligibility status at time of disbursement | |
| ELIGIBILITY_STATUS_DATE | DATE | Indicates date on which eligibility check was done | ||
| _LA:AFFIRMATION_FLAG | CHAR | (58) | Indicates whether student has confirmed for disbursement | |
| _LA:HOLD_RELEASE_INDICATOR | CHAR | (71) | Indicates hold or release for disbursement | |
| _LA:MANUAL_HOLD_INDICATOR | CHAR | (62) | Used by disbursements to hold up disbursements | |
| DISBURSEMENT_STATUS | VARCHAR2 | (30) | Indicates disbursement status for CommonLine loans | |
| DISBURSEMENT_STATUS_DATE | DATE | Disbursement status date | ||
| _LA:LATE_DISBURSE_INDICATOR | CHAR | (60) | Indicates when disbursement is issued. Updated from CommonLine roster file | |
| _LA:FUND_DISBURSEMENT_METHOD | CHAR | (75) | Indicates method used to release funds. Updated from CommonLine roster file | |
| _LA:PREV_REPORTED_INDICATOR | CHAR | (64) | Indicates if disbursement was indicated on previous disbursement roster | |
| FUND_RELEASE_DATE | DATE | Indicates date on which funds are released to school | ||
| _LA:FUND_STATUS | CHAR | (69) | Indicates whether funds have been transferred for disbursement. Updated from CommonLine roster file. | |
| FUND_STATUS_DATE | DATE | Date on which disbursement roster was updated | ||
| ORIGINATION_FEE_PAID | NUMBER | Origination fees paid | ||
| GUARANTEE_FEE_PAID | NUMBER | Guarantee fees paid | ||
| CHECK_NUMBER | VARCHAR2 | (30) | Check number | |
| DISBURSEMENT_ACCEPTED_AMOUNT | NUMBER | (13) | Disbursement Accepted Amount | |
| DISBURSEMENT_PAID_AMOUNT | NUMBER | (13) | Disbursement Paid amount | |
| REVISION_CODE | NUMBER | (15) | Revision Code referenced from Revision Table | |
| INTEREST_REBATE_AMOUNT | NUMBER | (15) | Interest rebate amount as calculated for the loan amount | |
| _LA:FORCE_DISBURSEMENT_FLAG | CHAR | (57) | Indicates if the disbursement was forced. | |
| CUMULATIVE_CREDIT_POINTS | NUMBER | (7) | Indicates the minimum credit point requirement for the disbursement | |
| DISBURSEMENT_EXPIRATION_DATE | DATE | Indicates the date on which the disbursement will expire | ||
| VERIFICATION_ENFORCEMENT_DATE | DATE | Indicates the date on which the verification should be enforced | ||
| NOTIFICATION_SENT_FLAG | VARCHAR2 | (1) | Indicates whether a Notification was sent for the fund, in this term for the student. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund. | |
| NOTIFICATION_DATE | DATE | Date on which Notification was sent. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund | ||
| AUTHORIZATION_DATE | DATE | Date on which the Authorization was created or updated. | ||
| _LA:PAYS_ONLY_FEE_CLASS | CHAR | (53) | Pays only fee class | |
| _LA:INCLUD_AS_PLANNED_CREDIT | CHAR | (59) | Indicates if the notification should be shown on the bill. | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Unique identification number |
| PERSON_NAME | VARCHAR2 | (360) | Yes | Person's name |
| AWARD_YEAR | VARCHAR2 | (10) | Alternate short reference code for identifying a Load calendar instance | |
| AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
| LOAD_CALENDAR | VARCHAR2 | (10) | Alternate short reference code for identifying a Load calendar instance | |
| LOAD_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Load Calendar Instance | |
| LOAD_CALENDAR_START_DATE | DATE | Yes | Load Calendar Start Date | |
| LOAD_CALENDAR_END_DATE | DATE | Yes | Load Calendar End Date | |
| TEACHING_CALENDAR | VARCHAR2 | (10) | Alternate short reference code for identifying a Teaching calendar instance | |
| TEACHING_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Teaching Calendar Instance | |
| TEACHING_CALENDAR_START_DATE | DATE | Teaching Calendar Start Date | ||
| TEACHING_CALENDAR_END_DATE | DATE | Teaching Calendar End Date | ||
| REVISION_DESCRIPTION | VARCHAR2 | (80) | Description of the Revision Reason Code | |
| AUTHORIZATION_ID | NUMBER | (15) | Unique Authorization Identifier. Authorization is a set of information of the student sent in context of student work-study. There will be one authorization sent for a student, award of type FWS and Term. | |
| TEACH_PERD_CALENDAR_TYPE | VARCHAR2 | (10) | Indicates code for teaching period calendar type. Used within operating unit | |
| TEACH_PERD_SEQUENCE_NUMBER | NUMBER | (6) | Indicates unique identifier for teaching calendar instance | |
| LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar type for the Term |
| LOAD_CALENDAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Term / Load calendar sequence number |
| CREATED_BY | NUMBER | (15) | Yes | WHO column |
| CREATION_DATE | DATE | Yes | WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
| LAST_UPDATE_DATE | DATE | Yes | WHO column | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_ID
, DISBURSEMENT_NUMBER
, DISBURSEMENT_GROSS_AMOUNT
, DL_FFELP_ORIGINATION_FEE
, FFELP_GUARANTEE_FEE
, DISBURSEMENT_NET_AMOUNT
, DISBURSEMENT_DATE
, _LA:TRANSACTION_TYPE
, _LA:ELIGIBILITY_STATUS
, ELIGIBILITY_STATUS_DATE
, _LA:AFFIRMATION_FLAG
, _LA:HOLD_RELEASE_INDICATOR
, _LA:MANUAL_HOLD_INDICATOR
, DISBURSEMENT_STATUS
, DISBURSEMENT_STATUS_DATE
, _LA:LATE_DISBURSE_INDICATOR
, _LA:FUND_DISBURSEMENT_METHOD
, _LA:PREV_REPORTED_INDICATOR
, FUND_RELEASE_DATE
, _LA:FUND_STATUS
, FUND_STATUS_DATE
, ORIGINATION_FEE_PAID
, GUARANTEE_FEE_PAID
, CHECK_NUMBER
, DISBURSEMENT_ACCEPTED_AMOUNT
, DISBURSEMENT_PAID_AMOUNT
, REVISION_CODE
, INTEREST_REBATE_AMOUNT
, _LA:FORCE_DISBURSEMENT_FLAG
, CUMULATIVE_CREDIT_POINTS
, DISBURSEMENT_EXPIRATION_DATE
, VERIFICATION_ENFORCEMENT_DATE
, NOTIFICATION_SENT_FLAG
, NOTIFICATION_DATE
, AUTHORIZATION_DATE
, _LA:PAYS_ONLY_FEE_CLASS
, _LA:INCLUD_AS_PLANNED_CREDIT
, PERSON_NUMBER
, PERSON_NAME
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, LOAD_CALENDAR
, LOAD_CALENDAR_DESCRIPTION
, LOAD_CALENDAR_START_DATE
, LOAD_CALENDAR_END_DATE
, TEACHING_CALENDAR
, TEACHING_CALENDAR_DESCRIPTION
, TEACHING_CALENDAR_START_DATE
, TEACHING_CALENDAR_END_DATE
, REVISION_DESCRIPTION
, AUTHORIZATION_ID
, TEACH_PERD_CALENDAR_TYPE
, TEACH_PERD_SEQUENCE_NUMBER
, LOAD_CALENDAR_TYPE
, LOAD_CALENDAR_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFFV_AWARD_DISBURSEMENTS;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_AW_AWD_DISB_ALL
IGF_AW_AWD_RVSN_RSN_ALL
IGS_CA_INST_ALL
APPS.IGFFV_AWARD_DISBURSEMENTS is not referenced by any database object
|
|
|
|