[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AW_FUND_MAST_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AW_FUND_MAST_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_AW_FUND_MAST_ALL stores all the details and the properties for each fund.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AW_FUND_MAST_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FUND_ID
|
| IGF_AW_FUND_MAST_ALL_U2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUND_CODE
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
ORG_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FUND_ID | NUMBER | (15) | Yes | Unique identifier for each fund created |
| FUND_CODE | VARCHAR2 | (30) | Yes | Identifier of fund defined in fund category table |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calender type. Used within operating unit. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calender instance |
| DESCRIPTION | VARCHAR2 | (80) | Long name for current fund | |
| DISCONTINUE_FUND | VARCHAR2 | (30) | Yes | Indicator used if fund is discontinued. Y indicates that current fund will not be used in future for packaging. |
| ENTITLEMENT | VARCHAR2 | (30) | Indicator specifying whether current fund is entitlement. Checked value denotes entitlement. | |
| AUTO_PKG | VARCHAR2 | (30) | Yes | Checked value indicates fund can be used for auto packaging. |
| SELF_HELP | VARCHAR2 | (30) | Checked value indicates current fund is part of self help. | |
| ALLOW_MAN_PKG | VARCHAR2 | (30) | Yes | Checked value allows fund to be individually packaged. |
| UPDATE_NEED | VARCHAR2 | (30) | Yes | Checked value indicates student's need has to be updated once awarded. |
| DISBURSE_FUND | VARCHAR2 | (30) | Yes | Disbursement of award takes place only after field is checked. |
| AVAILABLE_AMT | NUMBER | (12) | Stores net amount available under current fund | |
| OFFERED_AMT | NUMBER | (12) | Stores amount offered under each fund. Increases each time fund is awarded. | |
| PENDING_AMT | NUMBER | (12) | Stores amount pending to be awarded | |
| ACCEPTED_AMT | NUMBER | Stores amount accepted by students | ||
| DECLINED_AMT | NUMBER | Stores amount declined by students | ||
| CANCELLED_AMT | NUMBER | Stores amount cancelled by institution | ||
| REMAINING_AMT | NUMBER | Stores amount remaining under current fund | ||
| ENROLLMENT_STATUS | VARCHAR2 | (30) | Stores minimum enrollment status required for student to be awarded fund | |
| PRN_AWARD_LETTER | VARCHAR2 | (30) | Checked indicator indicates award letter has to be printed for current fund. | |
| OVER_AWARD_AMT | NUMBER | (12) | Stores over award amount that can be given to student under current fund | |
| OVER_AWARD_PERCT | NUMBER | (12) | Stores over award percentage value that can be set if fund is over award fund | |
| MIN_AWARD_AMT | NUMBER | (12) | Specifies minimum amount that can be awarded under current fund per student | |
| MAX_AWARD_AMT | NUMBER | (12) | Stores maximum amount that can be awarded to student under current fund | |
| MAX_YEARLY_AMT | NUMBER | (12) | Stores maximum amount that can be awarded to student during year under current fund | |
| MAX_LIFE_AMT | NUMBER | (12) | Stores maximum amount that can be awarded to student for lifetime under current fund | |
| MAX_LIFE_TERM | NUMBER | (12) | Stores maximum number of times fund can be awarded to student during lifetime | |
| FM_FC_METHD | VARCHAR2 | (30) | Indicates if current fund follows federal or institutional methodology | |
| ROUNDOFF_FACT | VARCHAR2 | (30) | Stores round off factor used for current fund | |
| REPLACE_FC | VARCHAR2 | (30) | Indicator with Y or N value. Indicates if fund can replace family contribution. | |
| ALLOW_OVERAWARD | VARCHAR2 | (30) | Checked value indicates current fund can be over awarded | |
| PCKG_AWD_STAT | VARCHAR2 | (30) | Indicates the Award Status for packaging | |
| ORG_RECORD_REQ | VARCHAR2 | (30) | Checked value indicates origination record is required without which disbursements are not made for current fund | |
| DISB_RECORD_REQ | VARCHAR2 | (30) | Checked indicator indicates disbursement cannot be made until disbursement record is received from external agency | |
| PROM_NOTE_REQ | VARCHAR2 | (30) | Checked value indicates fund cannot be disbursement without promissory note | |
| MIN_NUM_DISB | NUMBER | (10) | Specifies minimum number of disbursements fund must have | |
| MAX_NUM_DISB | 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 | NUMBER | (10) | Stores total count of number of students offered fund | |
| TOTAL_ACCEPTED | NUMBER | (10) | Stores total count of number of students who accepted fund | |
| TOTAL_DECLINED | NUMBER | (10) | Stores total count of number of students who declined fund | |
| TOTAL_REVOKED | NUMBER | (10) | Stores total count of number of students offered fund but are now revoked | |
| TOTAL_CANCELLED | NUMBER | (10) | Stores count of number of students who cancelled fund | |
| TOTAL_DISBURSED | NUMBER | (10) | Stores count of total number of students to whom at least one disbursement was made | |
| TOTAL_COMMITTED | NUMBER | (10) | Total count of students who accepted fund but are not yet paid | |
| COMMITTED_AMT | NUMBER | Total Committed Amount | ||
| DISBURSED_AMT | NUMBER | Total Disbursed Amount | ||
| AWD_NOTICE_TXT | VARCHAR2 | (2000) | Fund specific text that should be included in the body of the Award Notice | |
| SAP_TYPE | VARCHAR2 | (30) | Obsolete | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| 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 | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| DISB_VERF_DA | VARCHAR2 | (10) | Disbursement Verification Date Alias | |
| FUND_EXP_DA | VARCHAR2 | (10) | Award expiry date alias | |
| NSLDS_DISB_DA | VARCHAR2 | (10) | NSLDS first disbursement delay date alias. | |
| DISB_EXP_DA | VARCHAR2 | (10) | Disbursement Expiry Date alias | |
| FUND_RECV_REQD | VARCHAR2 | (30) | Indicator which identifies whether receipt of funds is required for disbursement. | |
| SHOW_ON_BILL | VARCHAR2 | (30) | Indicates whether the fund can be shown on bill | |
| BILL_DESC | VARCHAR2 | (240) | Bill description | |
| CREDIT_TYPE_ID | NUMBER | (15) | Credit Type Id. References the credit type id credit types table | |
| ELIG_CRITERIA | VARCHAR2 | (30) | FA125_3160568_CS_DP1.doc - Obsolete | |
| SPNSR_REF_NUM | VARCHAR2 | (50) | Sponsor reference number | |
| MIN_HR_RATE | NUMBER | (12) | No longer used. | |
| MAX_HR_RATE | NUMBER | (12) | No longer used. | |
| THRESHOLD_PERCT | NUMBER | (5) | Threshold Percentage of the paid amount with resect 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. | |
| GOVT_SHARE_PERCT | NUMBER | (5) | No longer used. | |
| SALARY_BASED | VARCHAR2 | (1) | No longer used. | |
| PARTY_ID | NUMBER | (15) | Party id for sponsor account | |
| SPNSR_FEE_TYPE | VARCHAR2 | (10) | Fee type for creation of charge on sponsors account | |
| MIN_CREDIT_POINTS | NUMBER | (6) | The minimum number of enrolled credit points the student must have prior to eligibility for sponsor fund disbursement. | |
| GROUP_ID | NUMBER | (6) | Person id group for sponsor funding | |
| SPNSR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column for sponsor fund | |
| SPNSR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| SPNSR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment column for sponsor fund | |
| VER_APP_STAT_OVERRIDE | VARCHAR2 | (1) | Indicates whether the fund has the override verification and application process status checked or not | |
| GIFT_AID | VARCHAR2 | (30) | Indicates if a fund can be marked as gift | |
| SEND_WITHOUT_DOC | VARCHAR2 | (1) | Indicates if first disbursement can be made actual in case verification status is without documentation | |
| RE_PKG_VERIF_FLAG | VARCHAR2 | (1) | Indicator that allows re-packaging even if the students verification status is 'Verified' | |
| DONOT_REPKG_IF_CODE | VARCHAR2 | (30) | Setting that determines up to what stage can a person be selected for re-packaging. | |
| LOCK_AWARD_FLAG | VARCHAR2 | (1) | Indicator that decides if the award will be auto locked after being awarded. | |
| LOCK_FLAG | VARCHAR2 | (1) | Fund Lock Indicator | |
| DISB_ROUNDING_CODE | VARCHAR2 | (10) | Disbursement Rounding | |
| VIEW_ONLY_FLAG | VARCHAR2 | (1) | 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 | |
| ALLOW_INC_POST_ACCEPT_FLAG | VARCHAR2 | (1) | 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. | ||
| ALLOW_DEC_POST_ACCEPT_FLAG | VARCHAR2 | (1) | 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. | ||
| ALLOW_DECLN_POST_ACCEPT_FLAG | VARCHAR2 | (1) | Indicates whether a student can decline an award from this fund, after initial acceptance | |
| STATUS_AFTER_DECLINE | VARCHAR2 | (30) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT FUND_ID
, FUND_CODE
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, DESCRIPTION
, DISCONTINUE_FUND
, ENTITLEMENT
, AUTO_PKG
, SELF_HELP
, ALLOW_MAN_PKG
, UPDATE_NEED
, DISBURSE_FUND
, AVAILABLE_AMT
, OFFERED_AMT
, PENDING_AMT
, ACCEPTED_AMT
, DECLINED_AMT
, CANCELLED_AMT
, REMAINING_AMT
, ENROLLMENT_STATUS
, PRN_AWARD_LETTER
, OVER_AWARD_AMT
, OVER_AWARD_PERCT
, MIN_AWARD_AMT
, MAX_AWARD_AMT
, MAX_YEARLY_AMT
, MAX_LIFE_AMT
, MAX_LIFE_TERM
, FM_FC_METHD
, ROUNDOFF_FACT
, REPLACE_FC
, ALLOW_OVERAWARD
, PCKG_AWD_STAT
, ORG_RECORD_REQ
, DISB_RECORD_REQ
, PROM_NOTE_REQ
, MIN_NUM_DISB
, MAX_NUM_DISB
, FEE_TYPE
, TOTAL_OFFERED
, TOTAL_ACCEPTED
, TOTAL_DECLINED
, TOTAL_REVOKED
, TOTAL_CANCELLED
, TOTAL_DISBURSED
, TOTAL_COMMITTED
, COMMITTED_AMT
, DISBURSED_AMT
, AWD_NOTICE_TXT
, SAP_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, DISB_VERF_DA
, FUND_EXP_DA
, NSLDS_DISB_DA
, DISB_EXP_DA
, FUND_RECV_REQD
, SHOW_ON_BILL
, BILL_DESC
, CREDIT_TYPE_ID
, ELIG_CRITERIA
, SPNSR_REF_NUM
, MIN_HR_RATE
, MAX_HR_RATE
, THRESHOLD_PERCT
, THRESHOLD_VALUE
, GOVT_SHARE_PERCT
, SALARY_BASED
, PARTY_ID
, SPNSR_FEE_TYPE
, MIN_CREDIT_POINTS
, GROUP_ID
, SPNSR_ATTRIBUTE_CATEGORY
, SPNSR_ATTRIBUTE1
, SPNSR_ATTRIBUTE2
, SPNSR_ATTRIBUTE3
, SPNSR_ATTRIBUTE4
, SPNSR_ATTRIBUTE5
, SPNSR_ATTRIBUTE6
, SPNSR_ATTRIBUTE7
, SPNSR_ATTRIBUTE8
, SPNSR_ATTRIBUTE9
, SPNSR_ATTRIBUTE10
, SPNSR_ATTRIBUTE11
, SPNSR_ATTRIBUTE12
, SPNSR_ATTRIBUTE13
, SPNSR_ATTRIBUTE14
, SPNSR_ATTRIBUTE15
, SPNSR_ATTRIBUTE16
, SPNSR_ATTRIBUTE17
, SPNSR_ATTRIBUTE18
, SPNSR_ATTRIBUTE19
, SPNSR_ATTRIBUTE20
, VER_APP_STAT_OVERRIDE
, GIFT_AID
, SEND_WITHOUT_DOC
, RE_PKG_VERIF_FLAG
, DONOT_REPKG_IF_CODE
, LOCK_AWARD_FLAG
, LOCK_FLAG
, DISB_ROUNDING_CODE
, VIEW_ONLY_FLAG
, ACCEPT_LESS_AMT_FLAG
, ALLOW_INC_POST_ACCEPT_FLAG
, MIN_INCREASE_AMT
, ALLOW_DEC_POST_ACCEPT_FLAG
, MIN_DECREASE_AMT
, ALLOW_DECLN_POST_ACCEPT_FLAG
, STATUS_AFTER_DECLINE
, FUND_INFORMATION_TXT
FROM IGF.IGF_AW_FUND_MAST_ALL;
IGF.IGF_AW_FUND_MAST_ALL does not reference any database object
IGF.IGF_AW_FUND_MAST_ALL is referenced by following:
APPS
IGF_AW_FUND_MAST_ALL
|
|
|
|