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

VIEW: APPS.IGFBV_FUNDS

Object Details
Object Name: IGFBV_FUNDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGFBV_FUNDS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base View for the Entity that holds the all the details and the properties for each fund


[View Source]

Columns
Name Datatype Length Mandatory Comments
FUND_CODE VARCHAR2 (30) Yes Identifier of fund defined in fund category table
AWARD_YEAR_CALENDAR_TYPE VARCHAR2 (10) Yes Indicates code for award year calender type. Used within operating unit.
AWARD_YEAR_CAL_SEQ_NUMBER NUMBER (6) Yes Indicates unique identifier for award year calender instance
FUND_DESCRIPTION VARCHAR2 (80)
Long name for current fund
_LA:DISCONTINUE_FUND_FLAG CHAR (65)
Indicator used if fund is discontinued. Y indicates that current fund will not be used in future for packaging
_LA:ENTITLEMENT_FLAG CHAR (60)
Indicator specifying whether current fund is entitlement. Checked value denotes entitlement
_LA:AUTO_PACKAGING_FLAG CHAR (57)
Checked value indicates fund can be used for auto packaging
_LA:SELF_HELP_FLAG CHAR (58)
Checked value indicates current fund is part of self help
_LA:ALLOW_MANUAL_PACKAGING CHAR (62)
Checked value allows fund to be individually packaged
_LA:UPDATE_NEED_FLAG CHAR (60)
Checked value indicates student's need has to be updated once awarded
_LA:DISBURSEMENT_FUND_FLAG CHAR (62)
Disbursement of award takes place only after field is checked
AVAILABLE_AMOUNT NUMBER (12)
Stores net amount available under current fund
OFFERED_AMOUNT NUMBER (12)
Stores amount offered under each fund. Increases each time fund is awarded
PENDING_AMOUNT NUMBER (12)
Stores amount pending to be awarded
ACCEPTED_AMOUNT NUMBER

Stores amount accepted by students
DECLINED_AMOUNT NUMBER

Stores amount declined by students
CANCELLED_AMOUNT NUMBER

Stores amount cancelled by institution
REMAINING_TO_DISBURSE_AMOUNT NUMBER

Stores amount remaining under current fund
ENROLLMENT_STATUS VARCHAR2 (30)
Stores minimum enrollment status required for student to be awarded fund
_LA:PRINT_AWARD_LETTER_FLAG CHAR (65)
Checked indicator indicates award letter has to be printed for current fund
OVER_AWARD_AMOUNT NUMBER (12)
Stores over award amount that can be given to student under current fund
OVER_AWARD_PERCENTAGE NUMBER (12)
Stores over award percentage value that can be set if fund is over award fund
MINIMUM_AWARD_AMOUNT NUMBER (12)
Specifies minimum amount that can be awarded under current fund per student
MAXIMUM_AWARD_AMOUNT NUMBER (12)
Stores maximum amount that can be awarded to student under current fund
MAXIMUM_YEARLY_AMOUNT NUMBER (12)
Stores maximum amount that can be awarded to student during year under current fund
LIFETIME_MAXIMUM_AMOUNT NUMBER (12)
Stores maximum amount that can be awarded to student for lifetime under current fund
LIFETIME_MAXIMUM_TERMS NUMBER (12)
Stores maximum number of times fund can be awarded to student during lifetime
_LA:NEED_ANALYSIS_METHDOLOGY CHAR (65)
Indicates if current fund follows federal or institutional methodology
_LA:ROUNDOFF_FACTOR CHAR (65)
Stores round off factor used for current fund
_LA:REPLACE_FAMILY_CONTRIBUT CHAR (62)
Indicator with Y or N value. Indicates if fund can replace family contribution
_LA:ALLOW_OVERAWARD_FLAG CHAR (67)
Checked value indicates current fund can be over awarded
_LA:PACKAGE_AWARD_STATUS CHAR (65)
Indicates the Award Status for packaging
_LA:ORIGINATION_RECORD_REQ CHAR (63)
Checked value indicates origination record is required without which disbursements are not made for current fund
_LA:DISBURSEMENT_RECORD_REQ CHAR (64)
Checked indicator indicates disbursement cannot be made until disbursement record is received from external agency
_LA:PROMISSORY_NOTE_REQUIRED CHAR (62)
Checked value indicates fund cannot be disbursement without promissory note
MINIMUM_DISBURSEMENTS NUMBER (10)
Specifies minimum number of disbursements fund must have
MAXIMUM_DISBURSEMENTS NUMBER (10)
Specifies maximum number of disbursements fund can have
FEE_TYPE VARCHAR2 (10)
Specifies fee type that must be used by disbursements
TOTAL_OFFERED_AMOUNT NUMBER (10)
Stores total count of number of students offered fund
TOTAL_ACCEPTED_AMOUNT NUMBER (10)
Stores total count of number of students who accepted fund
TOTAL_DECLINED_AMOUNT NUMBER (10)
Stores total count of number of students who declined fund
TOTAL_REVOKED_AMOUNT NUMBER (10)
Stores total count of number of students offered fund but are now revoked
TOTAL_CANCELLED_AMOUNT NUMBER (10)
Stores count of number of students who cancelled fund
TOTAL_DISBURSED_AMOUNT NUMBER (10)
Stores count of total number of students to whom at least one disbursement was made
TOTAL_COMMITTED_AMOUNT NUMBER (10)
Total count of students who accepted fund but are not yet paid
COMMITTED_AMOUNT NUMBER

Total Committed Amount
DISBURSED_AMOUNT NUMBER

Total Disbursed Amount
AWARD_NOTICE_TEXT VARCHAR2 (2000)
Fund specific text that should be included in the body of the Award Notice
VERIF_ENFORCEMENT_OFFSET_DATE VARCHAR2 (10)
Disbursement Verification Date Alias
FUND_EXP_DA VARCHAR2 (10)
Award expiry date alias
NO_NSLDS_HIST_DISB_DATE_OFFSET VARCHAR2 (10)
NSLDS first disbursement delay date alias
DISBURSEMENT_EXPIRATION_OFFSET VARCHAR2 (10)
Disbursement Expiry Date alias
_LA:RECEIPT_OF_FUND_REQ_FLAG CHAR (63)
Indicator which identifies whether receipt of funds is required for disbursement
_LA:INCLUDE_AS_PLAN_CRE_FLAG CHAR (61)
Indicates whether the fund can be shown on bill
CREDIT_DESCRIPTION VARCHAR2 (240)
Bill description
CREDIT_TYPE NUMBER (15)
Credit Type Id. References the credit type id credit types table
GOVT_SHARE_PERCENTAGE VARCHAR2 (0)
No longer used.
THRESHOLD_PERCENTAGE NUMBER (5)
Threshold Percentage of the paid amount with respect to the accepted amount for the term, beyond which a notification should be sent
THRESHOLD_VALUE NUMBER (12)
Threshold Value of the paid amount for the term, beyond which a notification should be sent
MIN_HR_RATE VARCHAR2 (0)
No longer used.
MAX_HR_RATE VARCHAR2 (0)
No longer used.
SALARY_BASED_FLAG VARCHAR2 (0)
No longer used.
SPONSORSHIP_REFERENCE_NUMBER VARCHAR2 (50)
Sponsor reference number
SPONSORSHIP_FEE_TYPE VARCHAR2 (10)
Fee type for creation of charge on sponsors account
MINIMUM_CREDIT_POINTS NUMBER (6)
The minimum number of enrolled credit points the student must have prior to eligibility for sponsor fund disbursement.
SPONSORSHIP_PERSON_GROUP_ID NUMBER (6)
Person id group for sponsor funding
_LA:IGNORE_VERI_APPL_PROCESS CHAR (70)
Indicates whether the fund has the override verification and application process status checked or not
_LA:GIFT_AID_FLAG CHAR (57)
Indicates if a fund can be marked as gift
_LA:DISB_TO_NON_VERI_STUDENT CHAR (65)
Indicates if first disbursement can be made actual in case verification status is without documentation
_DF:FMAST CHAR (39)
Descriptive Flex Field Identifier
_DF:SPNSR CHAR (41)
Descriptive Flex Field Identifier
_LA:VIEW_ONLY_FLAG CHAR (63)
Indicates whether the awards from this fund are view only in Student Self-Service or not
ACCEPT_LESS_AMT_FLAG VARCHAR2 (1)
Indicates whether a student can accept an amount less than the award offered amount from Student Self-Service or not
_LA:ALLW_INC_POST_ACCPT_FLG CHAR (75)
Indicates whether a student can increase his/her accepted amount from Student Self-Service, after acceptance
MIN_INCREASE_AMT NUMBER

Amount by which the student has to increase his award accepted amount, after initial acceptance.
_LA:ALLW_DEC_POST_ACCPT_FLG CHAR (75)
Indicates whether a student can decrease his/her accepted amount from Student Self-Service, after acceptance
MIN_DECREASE_AMT NUMBER

Amount by which the student has to decrease his award accepted amount, after initial acceptance.
_LA:ALLW_DCLN_POST_ACPT_FLG CHAR (77)
Indicates whether a student can decline an award from this fund, after initial acceptance
_LA:STATUS_AFTER_DECLINE CHAR (81)
Status of an award after student declines it
FUND_INFORMATION_TXT VARCHAR2 (240)
Fund specific information text that would be included in Student Self-Service
PARTY_ID NUMBER (15)
Party id for sponsor account
FUND_ID NUMBER (15) Yes Unique identifier for each fund created
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
Query Text

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


SELECT FUND_CODE
,      AWARD_YEAR_CALENDAR_TYPE
,      AWARD_YEAR_CAL_SEQ_NUMBER
,      FUND_DESCRIPTION
,      _LA:DISCONTINUE_FUND_FLAG
,      _LA:ENTITLEMENT_FLAG
,      _LA:AUTO_PACKAGING_FLAG
,      _LA:SELF_HELP_FLAG
,      _LA:ALLOW_MANUAL_PACKAGING
,      _LA:UPDATE_NEED_FLAG
,      _LA:DISBURSEMENT_FUND_FLAG
,      AVAILABLE_AMOUNT
,      OFFERED_AMOUNT
,      PENDING_AMOUNT
,      ACCEPTED_AMOUNT
,      DECLINED_AMOUNT
,      CANCELLED_AMOUNT
,      REMAINING_TO_DISBURSE_AMOUNT
,      ENROLLMENT_STATUS
,      _LA:PRINT_AWARD_LETTER_FLAG
,      OVER_AWARD_AMOUNT
,      OVER_AWARD_PERCENTAGE
,      MINIMUM_AWARD_AMOUNT
,      MAXIMUM_AWARD_AMOUNT
,      MAXIMUM_YEARLY_AMOUNT
,      LIFETIME_MAXIMUM_AMOUNT
,      LIFETIME_MAXIMUM_TERMS
,      _LA:NEED_ANALYSIS_METHDOLOGY
,      _LA:ROUNDOFF_FACTOR
,      _LA:REPLACE_FAMILY_CONTRIBUT
,      _LA:ALLOW_OVERAWARD_FLAG
,      _LA:PACKAGE_AWARD_STATUS
,      _LA:ORIGINATION_RECORD_REQ
,      _LA:DISBURSEMENT_RECORD_REQ
,      _LA:PROMISSORY_NOTE_REQUIRED
,      MINIMUM_DISBURSEMENTS
,      MAXIMUM_DISBURSEMENTS
,      FEE_TYPE
,      TOTAL_OFFERED_AMOUNT
,      TOTAL_ACCEPTED_AMOUNT
,      TOTAL_DECLINED_AMOUNT
,      TOTAL_REVOKED_AMOUNT
,      TOTAL_CANCELLED_AMOUNT
,      TOTAL_DISBURSED_AMOUNT
,      TOTAL_COMMITTED_AMOUNT
,      COMMITTED_AMOUNT
,      DISBURSED_AMOUNT
,      AWARD_NOTICE_TEXT
,      VERIF_ENFORCEMENT_OFFSET_DATE
,      FUND_EXP_DA
,      NO_NSLDS_HIST_DISB_DATE_OFFSET
,      DISBURSEMENT_EXPIRATION_OFFSET
,      _LA:RECEIPT_OF_FUND_REQ_FLAG
,      _LA:INCLUDE_AS_PLAN_CRE_FLAG
,      CREDIT_DESCRIPTION
,      CREDIT_TYPE
,      GOVT_SHARE_PERCENTAGE
,      THRESHOLD_PERCENTAGE
,      THRESHOLD_VALUE
,      MIN_HR_RATE
,      MAX_HR_RATE
,      SALARY_BASED_FLAG
,      SPONSORSHIP_REFERENCE_NUMBER
,      SPONSORSHIP_FEE_TYPE
,      MINIMUM_CREDIT_POINTS
,      SPONSORSHIP_PERSON_GROUP_ID
,      _LA:IGNORE_VERI_APPL_PROCESS
,      _LA:GIFT_AID_FLAG
,      _LA:DISB_TO_NON_VERI_STUDENT
,      _DF:FMAST
,      _DF:SPNSR
,      _LA:VIEW_ONLY_FLAG
,      ACCEPT_LESS_AMT_FLAG
,      _LA:ALLW_INC_POST_ACCPT_FLG
,      MIN_INCREASE_AMT
,      _LA:ALLW_DEC_POST_ACCPT_FLG
,      MIN_DECREASE_AMT
,      _LA:ALLW_DCLN_POST_ACPT_FLG
,      _LA:STATUS_AFTER_DECLINE
,      FUND_INFORMATION_TXT
,      PARTY_ID
,      FUND_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_FUNDS;

Dependencies

[top of page]

APPS.IGFBV_FUNDS references the following:

SchemaAPPS
SynonymIGF_AW_FUND_MAST_ALL

APPS.IGFBV_FUNDS is not referenced by any database object