[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFBV_DISBURSEMENT_ADJUSTMENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFBV_DISBURSEMENT_ADJUSTMENTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base View for the Entity that Stores all the actual disbursement transactions and adjustments made to these, after they have been posted to the student finance interface table. For planned disbursements, this view will not have any records.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AWARD_ID | NUMBER | (15) | Yes | Identifier for awards |
| DISBURSEMENT_NUMBER | NUMBER | (15) | Yes | Identifier for disbursements. Number of disbursement |
| DISBURSEMET_SEQUENCE_NUMBER | NUMBER | (15) | Yes | Identifies sequence of change to disbursement amount or disbursement date |
| DISBURSEMET_GROSS_AMOUNT | NUMBER | (12) | Yes | Indicates new gross disbursement amount after adjustment |
| DL_FFELP_ORIGINATION_FEE | NUMBER | (12) | Indicates new origination fees in case of Direct Loan or CommonLine loans at time of adjustment | |
| FFELP_GUARANTEE_FEE | NUMBER | (12) | Indicates new guarantee fees in case of CommonLine loans at time of adjustment | |
| NET_ACCEPTED_AMOUNT | NUMBER | (12) | Yes | Indicates new disbursement net amount at time of adjustment |
| ADJUSTMENT_AMOUNT | NUMBER | (12) | Identifies difference in new and previous disbursement net amounts at time of adjustment | |
| DISBURSEMET_DATE | DATE | Yes | Identifies new disbursement date after disbursement date change or existing value of disbursement date at time of adjustment | |
| DL_FFELP_ORIGINATION_FEE_PAID | NUMBER | (12) | Identifies origination fees paid in case of CommonLine loans at time of adjustment | |
| FFELP_GUARANTEE_FEE_PAID | NUMBER | (12) | Identifies guarantee fees paid in case of CommonLine loans at time of adjustment | |
| _LA:DISBURSEMET_ACTIVTY_TYPE | CHAR | (68) | Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date | |
| DISBURSEMET_BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier of disbursement file, which reported adjustment record. Updated by Direct Loan origination process | |
| DISB_ACKNOWLEDGEMENT_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 | ||
| _LA:DISBURSEMET_STATUS | CHAR | (68) | Indicates status of adjustment for particular student availing Direct Loan | |
| DISBURSEMET_STATUS_DATE | DATE | Indicates the date on which the disbursement status was changed | ||
| _LA:STUDENT_FINANCE_STATUS | CHAR | (61) | Indicates student finance status of adjustment | |
| STUDENT_FINANCE_STATUS_DATE | DATE | Indicates student finance adjustment status date | ||
| STUDENT_FINANCE_INVOICE_NUM | NUMBER | (15) | Indicates invoice number for adjustment, as in Oracle Accounts Receivables, when disbursement or adjustment is posted to student's account | |
| ERROR_DESCRIPTION | VARCHAR2 | (2000) | Indicates the Error occurred when the adjustment record is posted to the Student Finance Interface Table. | |
| LETTER_NOTIFICATION_DATE | DATE | This is Correspondence Process Date, Updated by post process once the Loan Disbursement Letter has been sent to the student | ||
| AWARD_YEAR | VARCHAR2 | (10) | Indicates unique identifier for award year calendar instance | |
| AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
| PERSON_NUMBER | VARCHAR2 | (30) | Person Unique identification number | |
| PERSON_NAME | VARCHAR2 | (360) | Person Name | |
| TERM_CALENDAR | VARCHAR2 | (10) | Indicates unique identifier for term calendar instance | |
| TERM_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description for the term Calendar Instance | |
| TEACHING_CALENDAR | VARCHAR2 | (10) | Indicates unique identifier for teaching period calendar instance | |
| TEACHING_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description for the teaching calendar Instance | |
| SPONSORSHIP_CREDIT_ID | NUMBER | (15) | Indicates the Sponsor's Credit Identifier | |
| SPONSORSHIP_CHARGE_ID | NUMBER | (15) | Indicates the Sponsor's Charge Identifier | |
| CREDIT_NUMBER | NUMBER | (15) | Indicates the Student Finance Credit Identifier | |
| 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) | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_ID
, DISBURSEMENT_NUMBER
, DISBURSEMET_SEQUENCE_NUMBER
, DISBURSEMET_GROSS_AMOUNT
, DL_FFELP_ORIGINATION_FEE
, FFELP_GUARANTEE_FEE
, NET_ACCEPTED_AMOUNT
, ADJUSTMENT_AMOUNT
, DISBURSEMET_DATE
, DL_FFELP_ORIGINATION_FEE_PAID
, FFELP_GUARANTEE_FEE_PAID
, _LA:DISBURSEMET_ACTIVTY_TYPE
, DISBURSEMET_BATCH_ID
, DISB_ACKNOWLEDGEMENT_DATE
, BOOKING_BATCH_ID
, BOOKED_DATE
, _LA:DISBURSEMET_STATUS
, DISBURSEMET_STATUS_DATE
, _LA:STUDENT_FINANCE_STATUS
, STUDENT_FINANCE_STATUS_DATE
, STUDENT_FINANCE_INVOICE_NUM
, ERROR_DESCRIPTION
, LETTER_NOTIFICATION_DATE
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, PERSON_NUMBER
, PERSON_NAME
, TERM_CALENDAR
, TERM_CALENDAR_DESCRIPTION
, TEACHING_CALENDAR
, TEACHING_CALENDAR_DESCRIPTION
, SPONSORSHIP_CREDIT_ID
, SPONSORSHIP_CHARGE_ID
, CREDIT_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFBV_DISBURSEMENT_ADJUSTMENTS;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_AW_AWD_DISB_ALL
IGF_DB_AWD_DISB_DTL_ALL
IGS_CA_INST_ALL
APPS.IGFBV_DISBURSEMENT_ADJUSTMENTS is not referenced by any database object
|
|
|
|