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

VIEW: APPS.IGF_AW_FUND_MAST_V

Object Details
Object Name: IGF_AW_FUND_MAST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AW_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)
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
FUND_TYPE VARCHAR2 (30) Yes Unique code which identifies the Type under which the fund falls
FUND_SOURCE VARCHAR2 (30) Yes Unique code for each fund source
FED_FUND_CODE VARCHAR2 (30) Yes Unique code for each federal fund
SYS_FUND_TYPE VARCHAR2 (30) Yes Unique code for each system fund type
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
CI_ALTERNATE_CODE VARCHAR2 (10)
Indicates the alternate short reference code for identifying a award year calendar instance
CI_START_DT DATE
Yes Indicates the award year start date
CI_END_DT DATE
Yes Indicates the award year end date
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
ENROLLMENT_STATUS_DESC VARCHAR2 (60)
Describes 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
METHOD_DESC VARCHAR2 (4000)
ROUNDOFF_FACT VARCHAR2 (30)
Stores the round off factor that is going to be used for the current fund
ROUNDOFF_FACT_DESC VARCHAR2 (4000)
Describes 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
PCKG_AWD_STAT_DESCRIPTION VARCHAR2 (4000)
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
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
CREDIT_TYPE_NAME VARCHAR2 (60)
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
SAP_TYPE VARCHAR2 (0)
Obsolete
SAP_DESC VARCHAR2 (0)
Obsolete
GOVT_SHARE_PERCT VARCHAR2 (0)
No longer used.
EMP_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.
SUBACCOUNT_ID NUMBER (15)
OBSOLETE. Subaccount id of credit type
SPNSR_REF_NUM VARCHAR2 (50)
Sponsor reference number
PARTY_ID NUMBER (15)
Party id for sponsor account
PARTY_NUMBER VARCHAR2 (30)
Party number
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
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 Pell Disbursements should be reported or not in case student's 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.
DONOT_REPKG_DESC VARCHAR2 (4000)
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
DISB_ROUNDING_DESC VARCHAR2 (4000)
Disbursement Rounding Description
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
FUND_SOURCE_DESC VARCHAR2 (4000)
Fund Source
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_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      SAP_TYPE
,      SAP_DESC
,      GOVT_SHARE_PERCT
,      EMP_SHARE_PERCT
,      THRESHOLD_PERCT
,      THRESHOLD_VALUE
,      MAX_HR_RATE
,      MIN_HR_RATE
,      SALARY_BASED
,      SUBACCOUNT_ID
,      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
,      RE_PKG_VERIF_FLAG
,      DONOT_REPKG_IF_CODE
,      DONOT_REPKG_DESC
,      LOCK_AWARD_FLAG
,      DISB_ROUNDING_CODE
,      DISB_ROUNDING_DESC
,      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
,      FUND_SOURCE_DESC
FROM APPS.IGF_AW_FUND_MAST_V;

Dependencies

[top of page]

APPS.IGF_AW_FUND_MAST_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGF_AW_FUND_CAT
ViewIGF_AW_FUND_MAST
PL/SQL PackageIGF_AW_GEN - show dependent code
ViewIGS_CA_INST
ViewIGS_EN_ATD_TYPE
ViewIGS_FI_CR_TYPES
ViewIGS_PE_PERSID_GROUP
APPS.IGF_AW_FUND_MAST_V is referenced by following:

SchemaAPPS
ViewIGF_AW_FN_RPKG_PRTY_V
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code