eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGF_SP_FUND_MAST_V

Object Details

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

View Type

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.

[View Source]

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPS.IGF_SP_FUND_MAST_V references the following:

APPS: IGF_AP_BATCH_AW_MAP; IGF_AW_FUND_CAT; IGF_AW_FUND_MAST; IGF_AW_GEN - show dependent code; IGS_CA_INST; IGS_EN_ATD_TYPE; IGS_EN_GEN_003 - show dependent code; IGS_FI_CR_TYPES; IGS_FI_PARTIES_V; IGS_PE_PERSID_GROUP

APPS.IGF_SP_FUND_MAST_V is not referenced by any database object