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.

[Home] [Help]

View: IGFFV_FUNDS

Product:	IGF - Financial Aid (Obsolete)
Description:	Full View for the Entity that holds the all the details and the properties for each fund
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FMAST.FUND_CODE
, FMAST.DESCRIPTION
, '_LA:FMAST.DISCONTINUE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ENTITLEMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.AUTO_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SELF_HELP:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ALLOW_MAN_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.UPDATE_NEED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISBURSE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.AVAILABLE_AMT
, FMAST.OFFERED_AMT
, FMAST.PENDING_AMT
, FMAST.ACCEPTED_AMT
, FMAST.DECLINED_AMT
, FMAST.CANCELLED_AMT
, FMAST.REMAINING_AMT
, FMAST.ENROLLMENT_STATUS
, '_LA:FMAST.PRN_AWARD_LETTER:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.OVER_AWARD_AMT
, FMAST.OVER_AWARD_PERCT
, FMAST.MIN_AWARD_AMT
, FMAST.MAX_AWARD_AMT
, FMAST.MAX_YEARLY_AMT
, FMAST.MAX_LIFE_AMT
, FMAST.MAX_LIFE_TERM
, '_LA:FMAST.FM_FC_METHD:IGF_LOOKUPS_VIEW:IGF_AW_NEED_METHOD:MEANING'
, '_LA:FMAST.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AW_ROUND_OFF:MEANING'
, '_LA:FMAST.REPLACE_FC:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ALLOW_OVERAWARD:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.PCKG_AWD_STAT:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ORG_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISB_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.PROM_NOTE_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_NUM_DISB
, FMAST.MAX_NUM_DISB
, FMAST.FEE_TYPE
, FMAST.TOTAL_OFFERED
, FMAST.TOTAL_ACCEPTED
, FMAST.TOTAL_DECLINED
, FMAST.TOTAL_REVOKED
, FMAST.TOTAL_CANCELLED
, FMAST.TOTAL_DISBURSED
, FMAST.TOTAL_COMMITTED
, FMAST.COMMITTED_AMT
, FMAST.DISBURSED_AMT
, FMAST.AWD_NOTICE_TXT
, FMAST.DISB_VERF_DA
, FMAST.FUND_EXP_DA
, FMAST.NSLDS_DISB_DA
, FMAST.DISB_EXP_DA
, '_LA:FMAST.FUND_RECV_REQD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.BILL_DESC
, FMAST.CREDIT_TYPE_ID
, FMAST.GOVT_SHARE_PERCT
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, FMAST.MAX_HR_RATE
, FMAST.MIN_HR_RATE
, '_LA:FMAST.SALARY_BASED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.SPNSR_REF_NUM
, FMAST.SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS
, FMAST.GROUP_ID GROUP_ID
, PIG.DESCRIPTION
, '_LA:FMAST.VER_APP_STAT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.GIFT_AID:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SEND_WITHOUT_DOC:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, FCAT.FUND_TYPE
, '_LA:FCAT.FUND_SOURCE:IGF_LOOKUPS_VIEW:IGF_AW_FUND_SOURCE:MEANING'
, '_LA:FCAT.FED_FUND_CODE:IGF_LOOKUPS_VIEW:IGF_AW_FED_FUND:MEANING'
, '_LA:FCAT.SYS_FUND_TYPE:IGF_LOOKUPS_VIEW:IGF_AW_SYS_FUND_TYPE:MEANING'
, '_DF:IGF:IGF_AW_FUND_MAST_ALL_FLEX:FMAST'
, '_DF:IGF:IGF_SP_FUND_MAST_SPNSR_FLEX:FMAST'
, '_LA:FMAST.VIEW_ONLY_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.ACCEPT_LESS_AMT_FLAG
, '_LA:FMAST.ALLOW_INC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_INCREASE_AMT
, '_LA:FMAST.ALLOW_DEC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_DECREASE_AMT
, '_LA:FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.STATUS_AFTER_DECLINE:IGF_LOOKUPS_VIEW:IGF_AW_AWD_STAT_POST_DECL:MEANING'
, FUND_INFORMATION_TXT
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, FMAST.PARTY_ID
, FMAST.FUND_ID
, FMAST.CREATED_BY
, FMAST.CREATION_DATE
, FMAST.LAST_UPDATED_BY
, FMAST.LAST_UPDATE_DATE
FROM IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL CI
, IGF_AW_FUND_CAT_ALL FCAT
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PIG
WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FMAST.FUND_CODE = FCAT.FUND_CODE (+)
AND FMAST.PARTY_ID = HZ.PARTY_ID (+)
AND FMAST.GROUP_ID = PIG.GROUP_ID (+) WITH READ ONLY

Columns

Name
FUND_CODE
FUND_DESCRIPTION
"_LA:DISCONTINUE_FUND_FLAG"
"_LA:ENTITLEMENT_FLAG"
"_LA:AUTO_PACKAGING_FLAG"
"_LA:SELF_HELP_FLAG"
"_LA:ALLOW_MANUAL_PACKAGING"
"_LA:UPDATE_NEED_FLAG"
"_LA:DISBURSEMENT_FUND_FLAG"
AVAILABLE_AMOUNT
OFFERED_AMOUNT
PENDING_AMOUNT
ACCEPTED_AMOUNT
DECLINED_AMOUNT
CANCELLED_AMOUNT
REMAINING_TO_DISBURSE_AMOUNT
ENROLLMENT_STATUS
"_LA:PRINT_AWARD_LETTER_FLAG"
OVER_AWARD_AMOUNT
OVER_AWARD_PERCENTAGE
MINIMUM_AWARD_AMOUNT
MAXIMUM_AWARD_AMOUNT
MAXIMUM_YEARLY_AMOUNT
LIFETIME_MAXIMUM_AMOUNT
LIFETIME_MAXIMUM_TERMS
"_LA:NEED_ANALYSIS_METHDOLOGY"
"_LA:ROUNDOFF_FACTOR"
"_LA:REPLACE_FAMILY_CONTRIBUT"
"_LA:ALLOW_OVERAWARD_FLAG"
"_LA:PACKAGE_AWARD_STATUS"
"_LA:ORIGINATION_RECORD_REQ"
"_LA:DISBURSEMENT_RECORD_REQ"
"_LA:PROMISSORY_NOTE_REQUIRED"
MINIMUM_DISBURSEMENTS
MAXIMUM_DISBURSEMENTS
FEE_TYPE
TOTAL_OFFERED_AMOUNT
TOTAL_ACCEPTED_AMOUNT
TOTAL_DECLINED_AMOUNT
TOTAL_REVOKED_AMOUNT
TOTAL_CANCELLED_AMOUNT
TOTAL_DISBURSED_AMOUNT
TOTAL_COMMITTED_AMOUNT
COMMITTED_AMOUNT_AMOUNT
DISBURSED_AMOUNT_AMOUNT
AWARD_NOTICE_TEXT_AMOUNT
VERIF_ENFORCEMENT_OFFSET_DATE
FUND_EXP_DA
NO_NSLDS_HIST_DISB_DATE_OFFSET
DISBURSEMENT_EXPIRATION_OFFSET
"_LA:RECEIPT_OF_FUND_REQ_FLAG"
"_LA:INCLUDE_AS_PLAN_CRE_FLAG"
CREDIT_DESCRIPTION
CREDIT_TYPE
SPONSORSHIP_REFERENCE_NUMBER
MIN_HR_RATE
MAX_HR_RATE
THRESHOLD_PERCENTAGE
THRESHOLD_VALUE
GOVT_SHARE_PERCENTAGE
"_LA:SALARY_BASED_FLAG"
SPONSORSHIP_FEE_TYPE
MINIMUM_CREDIT_POINTS
PERSONID_GROUP
PERSONID_GROUP_DESCRIPTION
"_LA:IGNORE_VERI_APPL_PROCESS"
"_LA:GIFT_AID_FLAG"
"_LA:DISB_TO_NON_VERI_STUDENT"
AWARD_YEAR
AWARD_YEAR_DESCRIPTION
PARTY_NUMBER
PARTY_NAME
FUND_TYPE
"_LA:FUND_SOURCE"
"_LA:FEDERAL_FUND_CODE"
"_LA:SYSTEM_FUND_TYPE"
"_DF:FMAST"
"_DF:SPNSR"
"_LA:VIEW_ONLY_FLAG"
ACCEPT_LESS_AMT_FLAG
"_LA:ALLW_INC_POST_ACCPT_FLG"
MIN_INCREASE_AMT
"_LA:ALLW_DEC_POST_ACCPT_FLG"
MIN_DECREASE_AMT
"_LA:ALLW_DCLN_POST_ACPT_FLG"
"_LA:STATUS_AFTER_DECLINE"
FUND_INFORMATION_TXT
AWARD_YEAR_CALENDAR_TYPE
AWARD_YEAR_CAL_SEQ_NUMBER
PARTY_ID
FUND_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE