Model Funds Management

Model Label : Banner Financial Aid Funds Management Module.
Path : BANNER DEV/Financial Aid/Finaid_ERD/FundsMgmt_ERD

List of Objects

Object Name	Object Type	Layer Name
RFRASCH	TABLE	Default
RFRASPC	TABLE	Default
RFRBASE	TABLE	Default
RFRBCMP	TABLE	Default
RFRCOMM	TABLE	Default
RFRDEFA	TABLE	Default
RFRDEFD	TABLE	Default
RFRDETC	TABLE	Default
RFRDLCK	TABLE	Default
RFRDSCH	TABLE	Default
RFRFFID	TABLE	Default
RFRMESG	TABLE	Default
RFRPROM	TABLE	Default
RFRSTCD	TABLE	Default
RFRTREQ	TABLE	Default
RFTASPC	TABLE	Default
RORTPRD	TABLE	Default

Comments

Model View

Table RFRASCH

Schema Name FAISMGR
Label RFRASCH
Server name MALDEV8_B60
Creation Date 10/29/2002 15:27:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_APRD_CODE	RFRASCH_APRD_CODE	VARCHAR2(6)	No	*	*
RFRASCH_APRD_CODE	RFRASCH_APRD_CODE	VARCHAR2(6)	No	*	*
RFRASCH_FUND_CODE	RFRASCH_FUND_CODE	VARCHAR2(6)	No	*	*
RFRASCH_TERM_CODE	RFRASCH_TERM_CODE	VARCHAR2(6)	No	*	*
RFRASCH_TERM_CODE	RFRASCH_TERM_CODE	VARCHAR2(6)	No	*	*
RFRASCH_AWARD_PCT	RFRASCH_AWARD_PCT	NUMBER(6,3)	No
RFRASCH_ACTIVITY_DATE	RFRASCH_ACTIVITY_DATE	DATE	No
RFRASCH_MEMO_EXP_DATE	RFRASCH_MEMO_EXP_DATE	DATE	Yes
RFRASCH_PELL_AWARD_PCT	RFRASCH_PELL_AWARD_PCT	NUMBER(6,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRASCH_FUND_CODE	RPRAWRD_FUND_CODE	RPRAWRD
RFRASCH_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
RFRASCH_AIDY_CODE	RFRDEFA_AIDY_CODE	RFRDEFA
RFRASCH_APRD_CODE	RFRDEFA_APRD_CODE	RFRDEFA
RFRASCH_TERM_CODE	RFRDEFA_TERM_CODE	RFRDEFA
RFRASCH_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRASCH_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRASCH_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRASCH	Unique	RFRASCH_AIDY_CODE
PK_RFRASCH	Unique	RFRASCH_APRD_CODE
PK_RFRASCH	Unique	RFRASCH_FUND_CODE
PK_RFRASCH	Unique	RFRASCH_TERM_CODE

Comments

Source Code Comments

Fund Award Schedule Rules Table

Columns Comments for RFRASCH_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record.

Columns Comments for RFRASCH_APRD_CODE (2)

Source Code Comments

AID PERIOD CODE: This code identifies the particular part of the year that students may be enrolled.

Columns Comments for RFRASCH_FUND_CODE (3)

Source Code Comments

FUND CODE: This code identifies the different funds which the institution has.

Columns Comments for RFRASCH_TERM_CODE (4)

Source Code Comments

TERM CODE: This field is used to identify the effective term for this record. Examples include: 199101 = Fall; 199102 = Spring

Columns Comments for RFRASCH_AWARD_PCT (5)

Source Code Comments

AWARD PERCENT: This percentage, as associated with a term code determines the amount of the packaged award that will be scheduled by term(s). The award percent cannot be negative and must equal 100% within aid periods.

Columns Comments for RFRASCH_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: This field maintains the date that thie record was entered or last updated.

Columns Comments for RFRASCH_MEMO_EXP_DATE (7)

Source Code Comments

MEMO EXPIRATION DATE: This optional field is used to identify the date that any memo'd item for that term will expire.

Columns Comments for RFRASCH_PELL_AWARD_PCT (8)

Source Code Comments

PELL AWARD PERCENT: Percentage to be used when calculating the Pell award for a term. This percentage, multiplied by the max Pell award for the year based on the student's enrollment, determines the maximum Pell award for the term. Max percent is 100%.

Table RFRASPC

Schema Name FAISMGR
Label RFRASPC
Server name MALDEV8_B60
Creation Date 01/23/2003 13:15:07:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRASPC_AIDY_CODE	RFRASPC_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASPC_AIDY_CODE	RFRASPC_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASPC_FUND_CODE	RFRASPC_FUND_CODE	VARCHAR2(6)	No	*	*
RFRASPC_FUND_CODE	RFRASPC_FUND_CODE	VARCHAR2(6)	No	*	*
RFRASPC_BUDG_ALLOC_AMT	RFRASPC_BUDG_ALLOC_AMT	NUMBER(11,2)	No
RFRASPC_AVAIL_OFFER_AMT	RFRASPC_AVAIL_OFFER_AMT	NUMBER(11,2)	No
RFRASPC_AVAIL_OFFER_PCT	RFRASPC_AVAIL_OFFER_PCT	NUMBER(6,3)	No
RFRASPC_AUTO_PACK_IND	RFRASPC_AUTO_PACK_IND	VARCHAR2(1)	No
RFRASPC_AUTO_SCHED_IND	RFRASPC_AUTO_SCHED_IND	VARCHAR2(1)	No
RFRASPC_AUTO_ACCEPT_IND	RFRASPC_AUTO_ACCEPT_IND	VARCHAR2(1)	No
RFRASPC_DISBURSE_IND	RFRASPC_DISBURSE_IND	VARCHAR2(1)	No
RFRASPC_APPL_MEMO_IND	RFRASPC_APPL_MEMO_IND	VARCHAR2(1)	No
RFRASPC_REPLACE_TFC_IND	RFRASPC_REPLACE_TFC_IND	VARCHAR2(1)	No
RFRASPC_REDUCE_NEED_IND	RFRASPC_REDUCE_NEED_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_IND	RFRASPC_OVERRIDE_IND	VARCHAR2(1)	No
RFRASPC_ROUND_AWARD_IND	RFRASPC_ROUND_AWARD_IND	VARCHAR2(3)	No
RFRASPC_ROUND_SCHED_IND	RFRASPC_ROUND_SCHED_IND	VARCHAR2(2)	No
RFRASPC_EQUITY_IND	RFRASPC_EQUITY_IND	VARCHAR2(1)	No
RFRASPC_OFFER_AWST_CODE	RFRASPC_OFFER_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_OFFER_AWST_CODE	RFRASPC_OFFER_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_OFFER_AWST_CODE	RFRASPC_OFFER_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_ACCEPT_AWST_CODE	RFRASPC_ACCEPT_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_ACCEPT_AWST_CODE	RFRASPC_ACCEPT_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_ACCEPT_AWST_CODE	RFRASPC_ACCEPT_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_DECLINE_AWST_CODE	RFRASPC_DECLINE_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_DECLINE_AWST_CODE	RFRASPC_DECLINE_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_DECLINE_AWST_CODE	RFRASPC_DECLINE_AWST_CODE	VARCHAR2(4)	No		*
RFRASPC_INEL_BEF_CUT_DATE_IND	RFRASPC_INEL_BEF_CUT_DATE_IND	VARCHAR2(1)	No
RFRASPC_INEL_AFT_CUT_DATE_IND	RFRASPC_INEL_AFT_CUT_DATE_IND	VARCHAR2(1)	No
RFRASPC_CHANGE_LOAD_IND	RFRASPC_CHANGE_LOAD_IND	VARCHAR2(1)	No
RFRASPC_RECOUP_IND	RFRASPC_RECOUP_IND	VARCHAR2(1)	No
RFRASPC_LOAN_PROCESS_IND	RFRASPC_LOAN_PROCESS_IND	VARCHAR2(1)	No
RFRASPC_NA_REQD_IND	RFRASPC_NA_REQD_IND	VARCHAR2(1)	No
RFRASPC_SEL_VER_INC_IND	RFRASPC_SEL_VER_INC_IND	VARCHAR2(1)	No
RFRASPC_ACTIVITY_DATE	RFRASPC_ACTIVITY_DATE	DATE	No
RFRASPC_TRANSFER_AMT	RFRASPC_TRANSFER_AMT	NUMBER(11,2)	Yes
RFRASPC_PRIOR_BAL_AMT	RFRASPC_PRIOR_BAL_AMT	NUMBER(11,2)	Yes
RFRASPC_TOTAL_ALLOC_AMT	RFRASPC_TOTAL_ALLOC_AMT	NUMBER(11,2)	Yes
RFRASPC_ORIG_OFFER_NO	RFRASPC_ORIG_OFFER_NO	NUMBER(9,0)	Yes
RFRASPC_ORIG_OFFER_AMT	RFRASPC_ORIG_OFFER_AMT	NUMBER(11,2)	Yes
RFRASPC_OFFER_NO	RFRASPC_OFFER_NO	NUMBER(9,0)	Yes
RFRASPC_OFFER_AMT	RFRASPC_OFFER_AMT	NUMBER(11,2)	Yes
RFRASPC_ACCEPT_NO	RFRASPC_ACCEPT_NO	NUMBER(9,0)	Yes
RFRASPC_ACCEPT_AMT	RFRASPC_ACCEPT_AMT	NUMBER(11,2)	Yes
RFRASPC_DECLINE_NO	RFRASPC_DECLINE_NO	NUMBER(9,0)	Yes
RFRASPC_DECLINE_AMT	RFRASPC_DECLINE_AMT	NUMBER(11,2)	Yes
RFRASPC_CANCEL_NO	RFRASPC_CANCEL_NO	NUMBER(9,0)	Yes
RFRASPC_CANCEL_AMT	RFRASPC_CANCEL_AMT	NUMBER(11,2)	Yes
RFRASPC_AUTHORIZE_NO	RFRASPC_AUTHORIZE_NO	NUMBER(9,0)	Yes
RFRASPC_AUTHORIZE_AMT	RFRASPC_AUTHORIZE_AMT	NUMBER(11,2)	Yes
RFRASPC_MEMO_NO	RFRASPC_MEMO_NO	NUMBER(9,0)	Yes
RFRASPC_MEMO_AMT	RFRASPC_MEMO_AMT	NUMBER(11,2)	Yes
RFRASPC_PAID_NO	RFRASPC_PAID_NO	NUMBER(9,0)	Yes
RFRASPC_PAID_AMT	RFRASPC_PAID_AMT	NUMBER(11,2)	Yes
RFRASPC_MAX_AWARD_AMT	RFRASPC_MAX_AWARD_AMT	NUMBER(11,2)	Yes
RFRASPC_MIN_AWARD_AMT	RFRASPC_MIN_AWARD_AMT	NUMBER(11,2)	Yes
RFRASPC_3QUARTER_LOAD_PCT	RFRASPC_3QUARTER_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_HALF_LOAD_PCT	RFRASPC_HALF_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_LESS_HALF_LOAD_PCT	RFRASPC_LESS_HALF_LOAD_PCT	NUMBER(6,3)	Yes
RFRASPC_SELF_HELP_RED_PCT	RFRASPC_SELF_HELP_RED_PCT	NUMBER(6,3)	Yes
RFRASPC_LOAN_FEE_PCT	RFRASPC_LOAN_FEE_PCT	NUMBER(6,3)	Yes
RFRASPC_PRORATION_IND	RFRASPC_PRORATION_IND	VARCHAR2(1)	No
RFRASPC_AWD_CHG_LTR_IND	RFRASPC_AWD_CHG_LTR_IND	VARCHAR2(1)	Yes
RFRASPC_PROM_REQ_IND	RFRASPC_PROM_REQ_IND	VARCHAR2(1)	Yes
RFRASPC_OVERRIDE_NEED_IND	RFRASPC_OVERRIDE_NEED_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_TREQ_IND	RFRASPC_OVERRIDE_TREQ_IND	VARCHAR2(1)	No
RFRASPC_OVERRIDE_SAPR_IND	RFRASPC_OVERRIDE_SAPR_IND	VARCHAR2(1)	Yes
RFRASPC_NCAA_IND	RFRASPC_NCAA_IND	VARCHAR2(1)	Yes
RFRASPC_LMS_FUND	RFRASPC_LMS_FUND	VARCHAR2(6)	Yes
RFRASPC_INTEREST_RATE	RFRASPC_INTEREST_RATE	NUMBER(6,3)	Yes
RFRASPC_DIRECT_LOAN_IND	RFRASPC_DIRECT_LOAN_IND	VARCHAR2(1)	Yes
RFRASPC_USE_DISB_ENRL_MEMO_IND	RFRASPC_USE_DISB_ENRL_MEMO_IND	VARCHAR2(1)	Yes
RFRASPC_ALT_LOAN_PROG_TYPE_CDE	RFRASPC_ALT_LOAN_PROG_TYPE_CDE	VARCHAR2(3)	Yes
RFRASPC_REBATE_PERCENT	RFRASPC_REBATE_PERCENT	NUMBER(6,3)	Yes
RFRASPC_WEB_ACCEPT_FLAG	RFRASPC_WEB_ACCEPT_FLAG	VARCHAR2(1)	No
RFRASPC_OVERRIDE_NEED_TO_COA	RFRASPC_OVERRIDE_NEED_TO_COA	VARCHAR2(1)	Yes
RFRASPC_ATTENDING_HR_IND	RFRASPC_ATTENDING_HR_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRASPC_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE
RFRASPC_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
RFRASPC_FUND_CODE	RPRAWRD_FUND_CODE	RPRAWRD
RFRASPC_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RFRASPC	Unique	RFRASPC_AIDY_CODE
PK_RFRASPC	Unique	RFRASPC_FUND_CODE
RFRASPC_FUND_INDEX		RFRASPC_FUND_CODE

Comments

Source Code Comments

Fund Aid Year Specific Data

Columns Comments for RFRASPC_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RFRASPC_FUND_CODE (2)

Source Code Comments

FUND CODE: This field identifies the fund associated with the information in this record.

Columns Comments for RFRASPC_BUDG_ALLOC_AMT (3)

Source Code Comments

BUDGET ALLOCATED AMOUNT: This field represents the actual allocated budget for a fund code within the given aid year. Optional field which defaults to 0.

Columns Comments for RFRASPC_AVAIL_OFFER_AMT (4)

Source Code Comments

AVAILABLE AMOUNT TO OFFER: This field represents the dollar amount of the fund that can be offered including any over-commitment amount. This field will be calculated if an Available to Offer Percent is entered.

Columns Comments for RFRASPC_AVAIL_OFFER_PCT (5)

Source Code Comments

PERCENTAGE AMOUNT AVAILABLE TO OFFER: This optional field represents the percentage of the total allocation that the institution wishes to offer including over-commitment.

Columns Comments for RFRASPC_AUTO_PACK_IND (6)

Source Code Comments

AUTOMATIC PACKAGE INDICATOR: This indicator is used to define whether this fund code should be included in automatic packaging.

Columns Comments for RFRASPC_AUTO_SCHED_IND (7)

Source Code Comments

AUTOMATIC SCHEDULING INDICATOR: This indicator is used to define if this fund code, once awarded should be automatically scheduled between terms.

Columns Comments for RFRASPC_AUTO_ACCEPT_IND (8)

Source Code Comments

AUTOMATIC ACCEPTANCE INDICATOR: This indicator is used to define if this fund should be automatically scheduled for disbursements.

Columns Comments for RFRASPC_DISBURSE_IND (9)

Source Code Comments

DISBURSE INDICATOR: This indicator defines how the disbursements can be made for each fund. Disbursements can be (S)ystem, (M)anual, or (N)either.

Columns Comments for RFRASPC_APPL_MEMO_IND (10)

Source Code Comments

APPLY FOR MEMO CREDIT: This field defines when and if the fund can be carried as a credit memo based on fund award status. Valid values include (N)one, (A)ccepted, (O)ffered.

Columns Comments for RFRASPC_REPLACE_TFC_IND (11)

Source Code Comments

REPLACE TOTAL FAMILY CONTRIBUTION INDICATOR: This indicator is used to define whether or not this fund should replace the total family contribution in the calculation of unmet need.

Columns Comments for RFRASPC_REDUCE_NEED_IND (12)

Source Code Comments

REDUCE NEED INDICATOR: This indicator is used to define whether or not this fund should reduce need in the calculation of unmet need. It is mutually exclusive from the Replace TFC indicator.

Columns Comments for RFRASPC_OVERRIDE_IND (13)

Source Code Comments

OVERRIDE INDICATOR: This field indicates whether general tracking requirements (those not associated with a fund) can be overridden for the particular fund in order for disbursements to be made.(See Field Usage Notes for all cases.)

Columns Comments for RFRASPC_ROUND_AWARD_IND (14)

Source Code Comments

ROUND TO NEAREST DOLLAR: This field defines the rounding rules which will apply when automatically packaging awards.

Columns Comments for RFRASPC_ROUND_SCHED_IND (15)

Source Code Comments

ROUND SCHEDULE: This field defines the rounding rules used in scheduling the award by terms and for use in fund disbursement.

Columns Comments for RFRASPC_EQUITY_IND (16)

Source Code Comments

EQUITY INDICATOR: This field is used to define whether the fund should be considered in Equity packaging.

Columns Comments for RFRASPC_OFFER_AWST_CODE (17)

Source Code Comments

OFFER AWARD STATUS: This field defines the award status which this fund will be offered in an automated packaging environment.

Columns Comments for RFRASPC_ACCEPT_AWST_CODE (18)

Source Code Comments

ACCEPT AWARD STATUS CODE: This code defines the award status with which this fund will be accepted.

Columns Comments for RFRASPC_DECLINE_AWST_CODE (19)

Source Code Comments

DECLINE AWARD STATUS CODE: This field identifies the decline status that should be used to decline awards for this fund code.

Columns Comments for RFRASPC_INEL_BEF_CUT_DATE_IND (20)

Source Code Comments

IF INELIGIBLE BEFORE CUT-OFF: This field determines what action will take place in the disbursement process if the student becomes ineligible for the fund prior to the financial aid cut-off date.

Columns Comments for RFRASPC_INEL_AFT_CUT_DATE_IND (21)

Source Code Comments

IF INELIGIBLE AFTER CUT-OFF: This field determines what action will take place in the disbursement process if the student becomes ineligible for the funds after the institutions cut-off date.

Columns Comments for RFRASPC_CHANGE_LOAD_IND (22)

Source Code Comments

CHANGE LOAD IND: Field indicates whether the award should be prorated or the scheduled disbursement prorated if the enrollment changes.

Columns Comments for RFRASPC_RECOUP_IND (23)

Source Code Comments

RECOUP INDICATOR: This field indicates whether dollars should be recouped after disbursements for this fund if something changes in the students record.

Columns Comments for RFRASPC_LOAN_PROCESS_IND (24)

Source Code Comments

LOAN PROCESS INDICATOR: This field is used to determine whether this fund is to be included in the loan processing function.

Columns Comments for RFRASPC_NA_REQD_IND (25)

Source Code Comments

NEED ANALYSIS INDICATOR: This indicator defines whether this fund requires that a need analysis record be on file for this fund to be awarded or for loan processing to occur.

Columns Comments for RFRASPC_SEL_VER_INC_IND (26)

Source Code Comments

SELECTED FOR VERIFICATION INDICATOR: This field indicates whether disbursements can be made on the fund if the verification has not been completed.

Columns Comments for RFRASPC_ACTIVITY_DATE (27)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRASPC_TRANSFER_AMT (28)

Source Code Comments

TRANSFER AMOUNT: This field represents any dollar amount which should transfer in or transfer out of a fund which will affect the total allocation for the Aid Year. Optional with a default value of 0. This field can be negative.

Columns Comments for RFRASPC_PRIOR_BAL_AMT (29)

Source Code Comments

PRIOR BALANCE AMOUNT: This field represents any prior balance for the fund code from a previous aid year. Optional field with a default value of 0.

Columns Comments for RFRASPC_TOTAL_ALLOC_AMT (30)

Source Code Comments

TOTAL ALLOCATED: This calculated field displays the total available dollars for the fund for the aid year. It is the sum of the prior balance the transferred amount plus the budget allocated amount. Not user-enterable.

Columns Comments for RFRASPC_ORIG_OFFER_NO (31)

Source Code Comments

ORIGINAL OFFER NUMBER: This field maintains the number of original awards for the fund in the specified aid year.

Columns Comments for RFRASPC_ORIG_OFFER_AMT (32)

Source Code Comments

ORIGINAL OFFER AMOUNT: This field maintains the dollar amount of all original awards for the fund in the specified aid year.

Columns Comments for RFRASPC_OFFER_NO (33)

Source Code Comments

OFFER NUMBER: This field maintains the number of awards that are currently offered for the fund in the specified aid year.

Columns Comments for RFRASPC_OFFER_AMT (34)

Source Code Comments

OFFER AMOUNT: This field maintains the dollar amount of awards that have been offered for the fund in the specified aid year.

Columns Comments for RFRASPC_ACCEPT_NO (35)

Source Code Comments

NUMBER OF ACCEPTED: This field maintains the number of awards that have been accepted for this fund in the specified aid year.

Columns Comments for RFRASPC_ACCEPT_AMT (36)

Source Code Comments

ACCEPTED AMOUNT: This field maintains the dollar amount of the fund that has been accepted for the indicated aid year.

Columns Comments for RFRASPC_DECLINE_NO (37)

Source Code Comments

DECLINE NUMBER: This field maintains the number of awards that have been declined for this fund code in the specified aid year.

Columns Comments for RFRASPC_DECLINE_AMT (38)

Source Code Comments

DECLINE AMOUNTS: This field maintains the dollar amount of declined awards for the fund code in the specified year.

Columns Comments for RFRASPC_CANCEL_NO (39)

Source Code Comments

CANCELLED AWARDS: This field maintains the number of cancelled awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_CANCEL_AMT (40)

Source Code Comments

CANCELLED AMOUNT: This field maintains the dollar amount of cancelled awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_AUTHORIZE_NO (41)

Source Code Comments

AUTHORIZED AWARDS: This field maintains the number of awards that have been authorized for the fund in the specified aid year.

Columns Comments for RFRASPC_AUTHORIZE_AMT (42)

Source Code Comments

AUTHORIZED AMOUNT: This field maintains the dollar amount of awards that are authorized.

Columns Comments for RFRASPC_MEMO_NO (43)

Source Code Comments

MEMO AWARDS: This field maintains the number of memo'd awards for the fund code in the specified aid year.

Columns Comments for RFRASPC_MEMO_AMT (44)

Source Code Comments

MEMO AMOUNT: This field maintains the dollar amount of memo'd awards for the f und code in the specified aid year.

Columns Comments for RFRASPC_PAID_NO (45)

Source Code Comments

PAID NUMBER: This field maintains the number of awards that have been paid for the fund in the specified aid year.

Columns Comments for RFRASPC_PAID_AMT (46)

Source Code Comments

PAID AMOUNT: This field maintains the dollar amount of awards that have been paid for the fund in the specified aid year.

Columns Comments for RFRASPC_MAX_AWARD_AMT (47)

Source Code Comments

MAXIMUM DOLLAR AMOUNT AWARDED TO A STUDENT: This field represents the maximum award the institution wishes to offer to any one student from a specific fund. Cannot be negative and cannot be less than the award minimum.

Columns Comments for RFRASPC_MIN_AWARD_AMT (48)

Source Code Comments

MINIMUM DOLLAR AMOUNT AWARDED TO A STUDENT: This field represents the minimum award the institution wishes to offer to any one student from each specific fund.

Columns Comments for RFRASPC_3QUARTER_LOAD_PCT (49)

Source Code Comments

THREE QUARTER LOAD PCT: Represents the percentage of the students award which will be disbursed if the student is enrolled on a three-quarter time basis.

Columns Comments for RFRASPC_HALF_LOAD_PCT (50)

Source Code Comments

HALF LOAD PCT: This field represents the percentage of the students award that will be disbursed if the student is enrolled on a half-time basis.

Columns Comments for RFRASPC_LESS_HALF_LOAD_PCT (51)

Source Code Comments

LESS THAN HALF LOAD PCT: This field represents the percentage of the students award that will be disbursed if the student is enrolled on a less than half- time basis.

Columns Comments for RFRASPC_SELF_HELP_RED_PCT (52)

Source Code Comments

SELF-HELP REDUCTION PERCENTAGE: This field defines the percentage of this fund that can be used toward satisfying self-help requirements.

Columns Comments for RFRASPC_LOAN_FEE_PCT (53)

Source Code Comments

LOAN FEE PERCENTAGE: This field represents the loan fee percent for this fund if a "Y" was indicated in the Loan Process field.

Columns Comments for RFRASPC_PRORATION_IND (54)

Source Code Comments

PRORATION INDICATOR: Used by the Disbursement process to decide how to process disbursement when a students disbursement load > packaging load. Values are P = Prorate disbursement amount, D = Do not prorate, N = No disbursement.

Columns Comments for RFRASPC_AWD_CHG_LTR_IND (55)

Source Code Comments

AWARD LETTER CHANGE INDICATOR: Indicates whether a change to this funds offered amount should set the RORSTAT_AWD_LTR_IND to 'Y'. Valid values are Y (set the RORSTAT_AWD_LTR_IND = Y, N or blank = no change to RORSTAT indicator.

Columns Comments for RFRASPC_PROM_REQ_IND (56)

Source Code Comments

PROMISSORY NOTE REQUIRED INDICATOR: Indicates whether this fund requires that the student sign a promissory note.

Columns Comments for RFRASPC_OVERRIDE_NEED_IND (57)

Source Code Comments

OVERRIDE UNMET NEED: Override the validation of unmet need if this indicator is set.

Columns Comments for RFRASPC_OVERRIDE_TREQ_IND (58)

Source Code Comments

OVERRIDE TRACKING REQUIREMENTS: Override the test for outstanding tracking requirements needed for packaging if indicator is set.

Columns Comments for RFRASPC_OVERRIDE_SAPR_IND (59)

Source Code Comments

Indicator used to override the verification of satisfactory academic progress in the Packaging and Disbursement processes.

Columns Comments for RFRASPC_NCAA_IND (60)

Source Code Comments

Indicator to allow users to track which funds are "countable" for NCAA purposes.

Columns Comments for RFRASPC_LMS_FUND (61)

Source Code Comments

LMS (IA Plus) fund designation that indicates the fund-loan rules associated with an institutional based loan. This designation is carried on LMS feed transactions.

Columns Comments for RFRASPC_INTEREST_RATE (62)

Source Code Comments

The interest rate on the direct loan for this student.

Columns Comments for RFRASPC_DIRECT_LOAN_IND (63)

Source Code Comments

Indicates whether the loan is of a direct loan type.

Columns Comments for RFRASPC_USE_DISB_ENRL_MEMO_IND (64)

Source Code Comments

USE DISBURSEMENT EDITS FOR MEMO: Allows the application of the Disbursement Enrollment Edits to be applied to funds in memo status.

Columns Comments for RFRASPC_ALT_LOAN_PROG_TYPE_CDE (65)

Source Code Comments

ATERNATIVE LOAN PROGRAM TYPE CODE: 3-character code to indicate if the fund is an alternative loan fund as defined by NCHELP.

Columns Comments for RFRASPC_REBATE_PERCENT (66)

Source Code Comments

REBATE FEE PERCENT: Rebate fee percentage.

Columns Comments for RFRASPC_WEB_ACCEPT_FLAG (67)

Source Code Comments

WEB ACCEPT FLAG: This controls which funds can be accepted/declined via the web. The valid values are 'Y' (Checked) and 'N' (unchecked).

Columns Comments for RFRASPC_OVERRIDE_NEED_TO_COA (68)

Source Code Comments

OVERRIDE NEED TO COA: Fund level override indicator to allow need to be overridden up to the cost of attendance (budget) amount.

Columns Comments for RFRASPC_ATTENDING_HR_IND (69)

Source Code Comments

ATTENDING HOURS INDICATOR: Indicator when checked to calculate the enrollment load for disbursement based on hours which the student is attending and the course has begun. Valid values are Y and null. Default value is null.

Table RFRBASE

Schema Name FAISMGR
Label RFRBASE
Server name MALDEV8_B60
Creation Date 07/30/2003 15:20:32:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRBASE_FUND_CODE	RFRBASE_FUND_CODE	VARCHAR2(6)	No	*
RFRBASE_FUND_TITLE	RFRBASE_FUND_TITLE	VARCHAR2(30)	No
RFRBASE_FSRC_CODE	RFRBASE_FSRC_CODE	VARCHAR2(4)	No		*
RFRBASE_FTYP_CODE	RFRBASE_FTYP_CODE	VARCHAR2(4)	No		*
RFRBASE_ACTIVITY_DATE	RFRBASE_ACTIVITY_DATE	DATE	No
RFRBASE_DETAIL_CODE	RFRBASE_DETAIL_CODE	VARCHAR2(4)	Yes		*
RFRBASE_DETAIL_CODE	RFRBASE_DETAIL_CODE	VARCHAR2(4)	Yes		*
RFRBASE_FED_FUND_ID	RFRBASE_FED_FUND_ID	VARCHAR2(4)	Yes
RFRBASE_PRINT_SEQ_NO	RFRBASE_PRINT_SEQ_NO	NUMBER(3,0)	Yes
RFRBASE_VR_MSG_NO	RFRBASE_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRBASE_FSRC_CODE	RTVFSRC_CODE	RTVFSRC
RFRBASE_FTYP_CODE	RTVFTYP_CODE	RTVFTYP
RFRBASE_DETAIL_CODE	TBRMEMO_DETAIL_CODE	TBRMEMO
RFRBASE_DETAIL_CODE	TBRACCD_DETAIL_CODE	TBRACCD

Index

Index Name	Index Type	Column Name
PK_RFRBASE	Unique	RFRBASE_FUND_CODE
RFRBASE_DETAIL_INDEX		RFRBASE_DETAIL_CODE
RFRBASE_FED_INDEX		RFRBASE_FED_FUND_ID
RFRBASE_FED_INDEX		RFRBASE_FUND_CODE

Comments

Source Code Comments

Fund Base Data Table

Columns Comments for RFRBASE_FUND_CODE (1)

Source Code Comments

FUND CODE: This field is used to establish and maintain valid fund codes used by the institution.

Columns Comments for RFRBASE_FUND_TITLE (2)

Source Code Comments

FUND TITLE: This field identifies the full title of the fund code.

Columns Comments for RFRBASE_FSRC_CODE (3)

Source Code Comments

FUND SOURCE CODE: This field identifies the fund source code to be associated with the fund code.

Columns Comments for RFRBASE_FTYP_CODE (4)

Source Code Comments

FUND TYPE CODE: This field links the fund code to a specific fund type code.

Columns Comments for RFRBASE_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRBASE_DETAIL_CODE (6)

Source Code Comments

ACCOUNTS RECEIVABLE DETAIL CODE: This code is used to link a Financial Aid Fund Code to an AR detail code for crediting funds to student accounts.

Columns Comments for RFRBASE_FED_FUND_ID (7)

Source Code Comments

FEDERAL FUND ID: This code specifies the federal fund if appropriate associated with the fund code.

Columns Comments for RFRBASE_VR_MSG_NO (9)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the fund code

Table RFRBCMP

Schema Name FAISMGR
Label RFRBCMP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:14:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRBCMP_AIDY_CODE	RFRBCMP_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRBCMP_AIDY_CODE	RFRBCMP_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRBCMP_FUND_CODE	RFRBCMP_FUND_CODE	VARCHAR2(6)	No	*	*
RFRBCMP_COMP_CODE	RFRBCMP_COMP_CODE	VARCHAR2(4)	No	*	*
RFRBCMP_ACTIVITY_DATE	RFRBCMP_ACTIVITY_DATE	DATE	No
RFRBCMP_COMP_PCT	RFRBCMP_COMP_PCT	NUMBER(8,5)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRBCMP_AIDY_CODE	RFRASPC_AIDY_CODE	RFRASPC
RFRBCMP_FUND_CODE	RFRASPC_FUND_CODE	RFRASPC
RFRBCMP_COMP_CODE	RTVCOMP_CODE	RTVCOMP
RFRBCMP_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RFRBCMP	Unique	RFRBCMP_AIDY_CODE
PK_RFRBCMP	Unique	RFRBCMP_FUND_CODE
PK_RFRBCMP	Unique	RFRBCMP_COMP_CODE

Comments

Source Code Comments

Fund / Budget Component Table

Columns Comments for RFRBCMP_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RFRBCMP_FUND_CODE (2)

Source Code Comments

FUND CODE: The fund code associated with the budget component rules for the aid year.

Columns Comments for RFRBCMP_COMP_CODE (3)

Source Code Comments

BUDGET COMPONENT CODE: This field defines the budget component code associated with this fund.

Columns Comments for RFRBCMP_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRBCMP_COMP_PCT (5)

Source Code Comments

BUDGET COMPONENT CODE PERCENT: This field defines the percentage of the fund which can be awarded for the identified budget component.

Table RFRCOMM

Schema Name FAISMGR
Label RFRCOMM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:14:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRCOMM_AIDY_CODE	RFRCOMM_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRCOMM_AIDY_CODE	RFRCOMM_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRCOMM_FUND_CODE	RFRCOMM_FUND_CODE	VARCHAR2(6)	No	*	*
RFRCOMM_SEQ_NO	RFRCOMM_SEQ_NO	NUMBER(6,3)	No	*
RFRCOMM_USER_ID	RFRCOMM_USER_ID	VARCHAR2(30)	No
RFRCOMM_ACTIVITY_DATE	RFRCOMM_ACTIVITY_DATE	DATE	No
RFRCOMM_COMMENT	RFRCOMM_COMMENT	VARCHAR2(50)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRCOMM_AIDY_CODE	RFRASPC_AIDY_CODE	RFRASPC
RFRCOMM_FUND_CODE	RFRASPC_FUND_CODE	RFRASPC
RFRCOMM_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RFRCOMM	Unique	RFRCOMM_AIDY_CODE
PK_RFRCOMM	Unique	RFRCOMM_FUND_CODE
PK_RFRCOMM	Unique	RFRCOMM_SEQ_NO

Comments

Source Code Comments

Fund Comments

Columns Comments for RFRCOMM_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RFRCOMM_FUND_CODE (2)

Source Code Comments

FUND CODE: The fund code associated with the comment.

Columns Comments for RFRCOMM_SEQ_NO (3)

Source Code Comments

SEQUENCE NUMBER: Internal system generated one-up sequence number.

Columns Comments for RFRCOMM_USER_ID (4)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for RFRCOMM_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RFRCOMM_COMMENT (6)

Source Code Comments

FUNDS COMMENTS: This field is used to enter comments associated with the fund for this specific aid year.

Table RFRDEFA

Schema Name FAISMGR
Label RFRDEFA
Server name MALDEV8_B60
Creation Date 10/29/2002 15:27:39:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDEFA_AIDY_CODE	RFRDEFA_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDEFA_AIDY_CODE	RFRDEFA_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDEFA_APRD_CODE	RFRDEFA_APRD_CODE	VARCHAR2(6)	No	*	*
RFRDEFA_TERM_CODE	RFRDEFA_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDEFA_AWARD_PCT	RFRDEFA_AWARD_PCT	NUMBER(6,3)	No
RFRDEFA_ACTIVITY_DATE	RFRDEFA_ACTIVITY_DATE	DATE	No
RFRDEFA_MEMO_EXP_DATE	RFRDEFA_MEMO_EXP_DATE	DATE	Yes
RFRDEFA_PELL_AWARD_PCT	RFRDEFA_PELL_AWARD_PCT	NUMBER(6,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDEFA_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
RFRDEFA_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFA_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRDEFA_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDEFA	Unique	RFRDEFA_AIDY_CODE
PK_RFRDEFA	Unique	RFRDEFA_APRD_CODE
PK_RFRDEFA	Unique	RFRDEFA_TERM_CODE

Comments

Source Code Comments

Default Fund Award Schedule Rules Table

Columns Comments for RFRDEFA_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this Fund Award Schedule Rules record.

Columns Comments for RFRDEFA_APRD_CODE (2)

Source Code Comments

AID PERIOD CODE: This code identifies particular parts of a year that students may be enrolled. Examples include: full year, academic year, summer only, etc.

Columns Comments for RFRDEFA_TERM_CODE (3)

Source Code Comments

TERM CODE: This field is used to identify the effective term for this record. Examples include: 199101 = Fall; 199102 = Spring, etc.

Columns Comments for RFRDEFA_AWARD_PCT (4)

Source Code Comments

AWARD PERCENT: This percentage as associated with a term code determines the amount of the packaged award that will be scheduled by term(s). The award percent cannot be negative and must equal 100% within aid periods.

Columns Comments for RFRDEFA_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the record was entered or last updated.

Columns Comments for RFRDEFA_MEMO_EXP_DATE (6)

Source Code Comments

MEMO EXPIRATION DATE: This optional field is used to identify the date that any memo'd items for that term will expire. (Default value).

Columns Comments for RFRDEFA_PELL_AWARD_PCT (7)

Source Code Comments

Table RFRDEFD

Schema Name FAISMGR
Label RFRDEFD
Server name MALDEV8_B60
Creation Date 01/22/2003 16:50:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDEFD_AIDY_CODE	RFRDEFD_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDEFD_APRD_CODE	RFRDEFD_APRD_CODE	VARCHAR2(6)	No	*	*
RFRDEFD_TERM_CODE	RFRDEFD_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDEFD_DISBURSE_DATE	RFRDEFD_DISBURSE_DATE	DATE	No	*
RFRDEFD_DISBURSE_PCT	RFRDEFD_DISBURSE_PCT	NUMBER(6,3)	No
RFRDEFD_ACTIVITY_DATE	RFRDEFD_ACTIVITY_DATE	DATE	No
RFRDEFD_DISB_SCHED_NO_DAYS	RFRDEFD_DISB_SCHED_NO_DAYS	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDEFD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFD_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRDEFD_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDEFD	Unique	RFRDEFD_AIDY_CODE
PK_RFRDEFD	Unique	RFRDEFD_APRD_CODE
PK_RFRDEFD	Unique	RFRDEFD_TERM_CODE
PK_RFRDEFD	Unique	RFRDEFD_DISBURSE_DATE

Comments

Source Code Comments

Default Fund Disbursement Schedule Rules Table

Columns Comments for RFRDEFD_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record.

Columns Comments for RFRDEFD_APRD_CODE (2)

Source Code Comments

AID PERIOD CODE: This field identifies the particular parts of the year that students may be enrolled. Examples include: full year, academic year, summer only, etc.

Columns Comments for RFRDEFD_TERM_CODE (3)

Source Code Comments

TERM CODE: This field identifies the term that the disbursement is scheduled for.

Columns Comments for RFRDEFD_DISBURSE_DATE (4)

Source Code Comments

DISBURSEMENT DATE: This field identifies the expected disbursement date for each fund by term.

Columns Comments for RFRDEFD_DISBURSE_PCT (5)

Source Code Comments

DISBURSEMENT PERCENT: This field indicates the percentage of the award to be disbursed for the specific term.

Columns Comments for RFRDEFD_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: This field maintains the date that record was last entered or updated.

Columns Comments for RFRDEFD_DISB_SCHED_NO_DAYS (7)

Source Code Comments

DISBURSEMENT DATE OFFSET: Number of days prior to or after the first class start date of the student to schedule the disbursement.

Table RFRDETC

Schema Name FAISMGR
Label RFRDETC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDETC_AIDY_CODE	RFRDETC_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDETC_AIDY_CODE	RFRDETC_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDETC_FUND_CODE	RFRDETC_FUND_CODE	VARCHAR2(6)	No	*	*