[Home] [Help] [Dependency Information]
Object Name: | IGF_SP_FUND_MAST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_SP_FUND_MAST_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
FUND_ID | NUMBER | (15) | Yes | Sequence generated Id for a fund |
FUND_CODE | VARCHAR2 | (30) | Yes | Fund code |
DESCRIPTION | VARCHAR2 | (80) | Description of the fund | |
FUND_TYPE | VARCHAR2 | (30) | Yes | Fund Type |
FUND_SOURCE | VARCHAR2 | (30) | Yes | Fund source |
FED_FUND_CODE | VARCHAR2 | (30) | Yes | Federal fund code |
SYS_FUND_TYPE | VARCHAR2 | (30) | Yes | System fund type |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type of the award calendar |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence number of the award calendar |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate code of the award calendar | |
CI_START_DT | DATE | Yes | Effective Start date of the award calendar | |
CI_END_DT | DATE | Yes | Effective End date of the award calendar | |
DISCONTINUE_FUND | VARCHAR2 | (30) | Yes | Closed Indicator to specify whether fund is authorized for use or not |
ENTITLEMENT | VARCHAR2 | (30) | Indicator to specify whether the current fund is entitled or not. | |
AUTO_PKG | VARCHAR2 | (30) | Yes | Indicator to specify whether the current fund can be used for auto packaging or not. |
SELF_HELP | VARCHAR2 | (30) | Indicator to specify whether the current fund is part of self-help or not. | |
ALLOW_MAN_PKG | VARCHAR2 | (30) | Yes | Indicator to specify whether the current fund is allowed to individually packed. |
UPDATE_NEED | VARCHAR2 | (30) | Yes | Indicator to specify that the students need to be updated once the fund is awarded. |
DISBURSE_FUND | VARCHAR2 | (30) | Yes | Disbursement of the award takes place only after this field has been fixed. |
AVAILABLE_AMT | NUMBER | (12) | Stores net amount available under the current fund | |
OFFERED_AMT | NUMBER | (12) | Stores the amount offered under each fund. It keep increasing each time a fund is awarded. | |
PENDING_AMT | NUMBER | (12) | Stores the amount pending to be awarded. | |
ACCEPTED_AMT | NUMBER | Stores the amount accepted by the Students. | ||
DECLINED_AMT | NUMBER | Stores the amount declined by the Students. | ||
CANCELLED_AMT | NUMBER | Stores the amount cancelled by the Institution. | ||
REMAINING_AMT | NUMBER | Stores the amount remaining under the current fund. | ||
ENROLLMENT_STATUS | VARCHAR2 | (30) | Attendance type the student must have prior to eligibility for fund disbursement. | |
ENROLLMENT_STATUS_DESC | VARCHAR2 | (60) | Description of the attendance type, the student must have prior to eligibility for fund disbursement. | |
PRN_AWARD_LETTER | VARCHAR2 | (30) | Indicator to specify whether an award has to be printed for the current fund or not. | |
OVER_AWARD_AMT | NUMBER | (12) | Stores the over award amount that can be given to a student under the current fund. | |
OVER_AWARD_PERCT | NUMBER | (12) | Stores the over award percentage that can be set if the fund is an over award fund. | |
MIN_AWARD_AMT | NUMBER | (12) | Specifies the minimum amount that can be awarded under the current fund per student. | |
MAX_AWARD_AMT | NUMBER | (12) | Specifies the maximum amount that can be awarded to the student under the current fund. | |
MAX_YEARLY_AMT | NUMBER | (12) | Maximum Amount awarded to the student during the year. | |
MAX_LIFE_AMT | NUMBER | (12) | Specifies the maximum amount that can be awarded to the student for a lifetime under the current fund. | |
MAX_LIFE_TERM | NUMBER | (12) | Stores the maximum number of times this fund can be awarded to a student during life term. | |
FM_FC_METHD | VARCHAR2 | (30) | Indicates if the current fund is going to follow federal methodology or institutional methodology. | |
METHOD_DESC | VARCHAR2 | (4000) | Description | |
ROUNDOFF_FACT | VARCHAR2 | (30) | Stores the round off factor that is going to be used for the current fund. | |
ROUNDOFF_FACT_DESC | VARCHAR2 | (4000) | Description of the round off factor that is going to be used for the current fund. | |
REPLACE_FC | VARCHAR2 | (30) | Indicator with y or n value which indicates if the fund can replace family contribution or not | |
ALLOW_OVERAWARD | VARCHAR2 | (30) | Indicator to specify whether fund can be over awarded or not. | |
PCKG_AWD_STAT | VARCHAR2 | (30) | Indicates award status for packaging | |
PCKG_AWD_STAT_DESCRIPTION | VARCHAR2 | (4000) | Description of award status for packaging | |
ORG_RECORD_REQ | VARCHAR2 | (30) | A checked value indicates that origination record is required without which the disbursements won't be made for the current fund | |
DISB_RECORD_REQ | VARCHAR2 | (30) | A checked indicator means that a disbursement can't be made till a disbursement record is received from an external agency | |
PROM_NOTE_REQ | VARCHAR2 | (30) | A checked value here indicates that the fund cannot be disbursed without a promissory note. | |
MIN_NUM_DISB | NUMBER | (10) | Specifies the minimum number of disbursements that this fund has to have. | |
MAX_NUM_DISB | NUMBER | (10) | Specifies the maximum number of disbursements that this fund can have. | |
FEE_TYPE | VARCHAR2 | (10) | Fee type for negative adjustments for a fund disbursement on the student account. | |
TOTAL_OFFERED | NUMBER | (10) | Stores the total count of the number of students who were offered this fund. | |
TOTAL_ACCEPTED | NUMBER | (10) | Stores the total count of the number of students who have accepted this fund. | |
TOTAL_DECLINED | NUMBER | (10) | Stores the total count of the number of students who have declined this fund. | |
TOTAL_REVOKED | NUMBER | (10) | Stores the total count of the number of students who were offered this fund but now have been revoked. | |
TOTAL_CANCELLED | NUMBER | (10) | Stores the count of the number of students who cancelled this fund. | |
TOTAL_DISBURSED | NUMBER | (10) | Stores the count of the total number of students to whom at least one disbursement has been made. | |
TOTAL_COMMITTED | NUMBER | (10) | Total count of students who have accepted this 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. | |
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. | |
ELIG_CRITERIA | VARCHAR2 | (0) | Eligibility criteria. | |
CREDIT_TYPE_NAME | VARCHAR2 | (60) | Credit type name associated with credit class. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield | |
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 Concurrent Program Column | |
PROGRAM_ID | NUMBER | (15) | Standard Concurrent Program Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Concurrent Program Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Concurrent Program Column | ||
GOVT_SHARE_PERCT | VARCHAR2 | (0) | No longer used. | |
EMP_SHARE_PERCT | VARCHAR2 | (0) | No longer used. | |
THRESHOLD_PERCT | 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. | |
MAX_HR_RATE | VARCHAR2 | (0) | No longer used. | |
MIN_HR_RATE | VARCHAR2 | (0) | No longer used. | |
SALARY_BASED | VARCHAR2 | (0) | No longer used. | |
SPNSR_REF_NUM | VARCHAR2 | (50) | Sponsor reference number. | |
PARTY_ID | NUMBER | (15) | Party id for sponsor account. | |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party number 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. | |
PERSID_GROUP_DESCRIPTION | VARCHAR2 | (60) | Person id group description for sponsor funding. | |
SPNSR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield | |
SPNSR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield | |
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 Pell Disbursements should be reported or not in case student's verification status is without documentation. | |
AWARD_YEAR_STATUS_CODE | VARCHAR2 | (30) | Field to differentiate award years that are open to Financial Aid processing from those that are closed to processing. In addition, it depicts which years contain historical legacy data. | |
DISB_ROUNDING_CODE | VARCHAR2 | (10) | Disbursement Rounding | |
DISB_ROUNDING_DESC | VARCHAR2 | (4000) | Disbursement Rounding Description | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FUND_ID
, FUND_CODE
, DESCRIPTION
, FUND_TYPE
, FUND_SOURCE
, FED_FUND_CODE
, SYS_FUND_TYPE
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_ALTERNATE_CODE
, CI_START_DT
, CI_END_DT
, 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
, ENROLLMENT_STATUS_DESC
, 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
, METHOD_DESC
, ROUNDOFF_FACT
, ROUNDOFF_FACT_DESC
, REPLACE_FC
, ALLOW_OVERAWARD
, PCKG_AWD_STAT
, PCKG_AWD_STAT_DESCRIPTION
, 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
, 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
, CREDIT_TYPE_NAME
, 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_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, GOVT_SHARE_PERCT
, EMP_SHARE_PERCT
, THRESHOLD_PERCT
, THRESHOLD_VALUE
, MAX_HR_RATE
, MIN_HR_RATE
, SALARY_BASED
, SPNSR_REF_NUM
, PARTY_ID
, PARTY_NUMBER
, SPNSR_FEE_TYPE
, MIN_CREDIT_POINTS
, GROUP_ID
, PERSID_GROUP_DESCRIPTION
, 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
, AWARD_YEAR_STATUS_CODE
, DISB_ROUNDING_CODE
, DISB_ROUNDING_DESC
, RE_PKG_VERIF_FLAG
, DONOT_REPKG_IF_CODE
, LOCK_AWARD_FLAG
FROM APPS.IGF_SP_FUND_MAST_V;
APPS.IGF_SP_FUND_MAST_V is not referenced by any database object
|
|
|