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

VIEW: APPS.IGF_AW_FUND_MAST

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FUND_ID NUMBER (15) Yes Unique identifier for each fund that gets created
FUND_CODE VARCHAR2 (30) Yes Identifier of the fund that was defined in the fund category table
DESCRIPTION VARCHAR2 (80)
Identifies long name for the current fund
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER NUMBER (6) Yes Indicates a unique identifier for the award year calender instance
DISCONTINUE_FUND VARCHAR2 (30) Yes An indicator which is used if the fund is discontinued , where in a Y value indicates that the current fund will not be used in future for packaging
ENTITLEMENT VARCHAR2 (30)
Indicator which specifies if the current fund is an entitlement or not . A checked value denotes and entitlement
AUTO_PKG VARCHAR2 (30) Yes A checked value indicates that this fund can be used for auto packaging .
SELF_HELP VARCHAR2 (30)
A checked value indicates that the current fund is part of self help
ALLOW_MAN_PKG VARCHAR2 (30) Yes A checked value allows the fund to be individually packaged
UPDATE_NEED VARCHAR2 (30) Yes A checked value here indicates that the students need has to be updated once its awarded
DISBURSE_FUND VARCHAR2 (30) Yes Disbursement of the award takes place only after this field is checked
AVAILABLE_AMT NUMBER (12)
Stores the net amount available under the current fund
OFFERED_AMT NUMBER (12)
Stores the amount offered under each fund , it keeps 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 students
DECLINED_AMT NUMBER

Stores the amount declined by students
CANCELLED_AMT NUMBER

Stores the amount cancelled by the institution
REMAINING_AMT NUMBER

Stores the amount remaining under current fund
ENROLLMENT_STATUS VARCHAR2 (30)
Stores the minimum enrollment status that is required for a student to get awarded this fund
PRN_AWARD_LETTER VARCHAR2 (30)
A checked indicator which when checked indicates that an award letter has to be printed for the current fund
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 value that can be set if the fund is an overaward 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)
Stores the maximum amount that can be awarded to the student under the current fund
MAX_YEARLY_AMT NUMBER (12)
Stores the maximum amount that can be awarded to the student in a year under the current fund
MAX_LIFE_AMT NUMBER (12)
Stores the maximum amount that can be awarded to a 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
FM_FC_METHD VARCHAR2 (30)
Indicates if the current fund is going to follow federal methodolog or institutional methodology
ROUNDOFF_FACT VARCHAR2 (30)
Stores the round off factor that is going to be used for the current fund
REPLACE_FC VARCHAR2 (30)
A indicator with a y or n value which indicates if the fund can replace family contribution or not
ALLOW_OVERAWARD VARCHAR2 (30)
A checked value here indicates that the current fund can be over awarded
PCKG_AWD_STAT VARCHAR2 (30)
Indicates Award Status for packaging
ORG_RECORD_REQ VARCHAR2 (30)
A checked value indicates that an origination record is required withour which 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 disbrusement without a promisory 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 maximm number of disbursements that this fund can have
FEE_TYPE VARCHAR2 (10)
Specifies the fee type that has to be used by disbursements
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 whome 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
SAP_TYPE VARCHAR2 (0)
Obsolete
DISB_VERF_DA VARCHAR2 (10)
FUND_EXP_DA VARCHAR2 (10)
NSLDS_DISB_DA VARCHAR2 (10)
DISB_EXP_DA VARCHAR2 (10)
FUND_RECV_REQD VARCHAR2 (30)
SHOW_ON_BILL VARCHAR2 (30)
BILL_DESC VARCHAR2 (240)
CREDIT_TYPE_ID NUMBER (15)
ELIG_CRITERIA VARCHAR2 (0)
FA125_3160568_CS_DP1.doc - Obsolete
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flex field segment
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flex field segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flex field segment
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
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
REQUEST_ID NUMBER (15)
Standard who column for concurrent programs
ORG_ID NUMBER (15)
GOVT_SHARE_PERCT VARCHAR2 (0)
No longer used.
THRESHOLD_PERCT NUMBER (5)
THRESHOLD_VALUE NUMBER (12)
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
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)
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)
Yes No 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.
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
Query Text

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


SELECT ROW_ID
,      FUND_ID
,      FUND_CODE
,      DESCRIPTION
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      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
,      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
,      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_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
,      GOVT_SHARE_PERCT
,      THRESHOLD_PERCT
,      THRESHOLD_VALUE
,      MAX_HR_RATE
,      MIN_HR_RATE
,      SALARY_BASED
,      SPNSR_REF_NUM
,      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
,      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 APPS.IGF_AW_FUND_MAST;

Dependencies

[top of page]

APPS.IGF_AW_FUND_MAST references the following:

SchemaAPPS
SynonymIGF_AW_FUND_MAST_ALL
APPS.IGF_AW_FUND_MAST is referenced by following:

SchemaAPPS
Package BodyIGF_AP_LI_AWARDS_PKG - show dependent code
ViewIGF_AW_AWARD_V
Package BodyIGF_AW_AWD_DISB_PKG - show dependent code
ViewIGF_AW_AWD_FRML_DET_V
Package BodyIGF_AW_CANCEL_AWD - show dependent code
ViewIGF_AW_CORRESP_LD_V
ViewIGF_AW_FSEOG_MATCH_V
ViewIGF_AW_FUND_DET_GRP_V
Package BodyIGF_AW_FUND_MAST_PKG - show dependent code
ViewIGF_AW_FUND_MAST_V
ViewIGF_AW_FUND_TP_V
Package BodyIGF_AW_GEN - show dependent code
Package BodyIGF_AW_GEN_003 - show dependent code
Package BodyIGF_AW_GEN_004 - show dependent code
ViewIGF_AW_NEED_ANLY_V
Package BodyIGF_AW_PACKAGING - show dependent code
PL/SQL PackageIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_PACKNG_SUBFNS - show dependent code
Package BodyIGF_AW_SS_GEN_PKG - show dependent code
Package BodyIGF_DB_DISB - show dependent code
ViewIGF_DB_DL_DISB_DTL_V
Package BodyIGF_DB_DL_DISB_ORIG - show dependent code
PL/SQL PackageIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_GR_PELL - show dependent code
Package BodyIGF_GR_PELL_CALC - show dependent code
ViewIGF_SE_AUTH_V
PL/SQL PackageIGF_SE_GEN_001 - show dependent code
Package BodyIGF_SE_GEN_001 - show dependent code
Package BodyIGF_SL_AWARD - show dependent code
Package BodyIGF_SL_CL_ORIG - show dependent code
Package BodyIGF_SL_CL_VALIDATION - show dependent code
Package BodyIGF_SL_DL_CHG_ORIG - show dependent code
Package BodyIGF_SL_DL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_DL_ORIG - show dependent code
Package BodyIGF_SL_DL_ORIG_ACK - show dependent code
Package BodyIGF_SL_DL_RECORD - show dependent code
ViewIGF_SL_LOANS_V
ViewIGF_SL_LOR_V
ViewIGF_SL_PLUS_LOAN_DETAILS_V
ViewIGF_SL_PRK_LOAN_V
Package BodyIGF_SL_REL_DISB - show dependent code
Package BodyIGF_SP_ASSIGN_PUB - show dependent code
Package BodyIGF_SP_AWARD - show dependent code
ViewIGF_SP_AWARD_V
ViewIGF_SP_FC_V
ViewIGF_SP_FUND_MAST_V
Package BodyIGF_SP_ROLLOVER - show dependent code
ViewIGF_SP_STDNT_REL_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
ViewIGS_FI_BILL_PLN_CRD_V
Package BodyIGS_FI_GEN_001 - show dependent code
ViewIGS_FI_PLN_CREDITS_V
Package BodyIGS_FI_PRC_REFUNDS - show dependent code
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code