RFRASCH RFRASPC RFRBASE RFRDEFA RFRMESG RFRTREQ RHRCOMM RORAPEL RORCAMP RORCRHR RORPELL RORSECT RORSTAT ROTSTTS RPBOPTS RPRADSB RPRARSC RPRATRM RPRAWRD RPRBAKO RPRCASH RPRCLSS RPRCLVL RPRCNCL RPRCOLR RPRCONT RPRDATE RPRDEFE RPRDEFG RPRDEFS RPREXPT RPRFEDR RPRFSRC RPRGEQY RPRGFND RPRGGAP RPRGSHP RPRLARF RPRRSLT RPRSADS RPRSTAC RPRTIIV RPRVRST RPTAWRD RPTCONT RTVARSC RTVAWST RTVFSRC RTVFTYP RTVHOLD RTVPGRP

Model Packaging and Disbursements


Model Label : Banner Financial Aid Packaging and Disbursement Module.
Path : BANNER DEV/Financial Aid/Finaid_ERD/PackDisb_ERD

List of Objects

Object Name Object Type Layer Name
RFRASCH TABLE Default
RFRASPC TABLE Default
RFRBASE TABLE Default
RFRDEFA TABLE Default
RFRMESG TABLE Default
RFRTREQ TABLE Default
RHRCOMM TABLE Default
RORAPEL TABLE Default
RORCAMP TABLE Default
RORCRHR TABLE Default
RORPELL TABLE Default
RORSECT TABLE Default
RORSTAT TABLE Default
ROTSTTS TABLE Default
RPBOPTS TABLE Default
RPRADSB TABLE Default
RPRARSC TABLE Default
RPRATRM TABLE Default
RPRAWRD TABLE Default
RPRBAKO TABLE Default
RPRCASH TABLE Default
RPRCLSS TABLE Default
RPRCLVL TABLE Default
RPRCNCL TABLE Default
RPRCOLR TABLE Default
RPRCONT TABLE Default
RPRDATE TABLE Default
RPRDEFE TABLE Default
RPRDEFG TABLE Default
RPRDEFS TABLE Default
RPREXPT TABLE Default
RPRFEDR TABLE Default
RPRFSRC TABLE Default
RPRGEQY TABLE Default
RPRGFND TABLE Default
RPRGGAP TABLE Default
RPRGSHP TABLE Default
RPRLARF TABLE Default
RPRRSLT TABLE Default
RPRSADS TABLE Default
RPRSTAC TABLE Default
RPRTIIV TABLE Default
RPRVRST TABLE Default
RPTAWRD TABLE Default
RPTCONT TABLE Default
RTVARSC TABLE Default
RTVAWST TABLE Default
RTVFSRC TABLE Default
RTVFTYP TABLE Default
RTVHOLD TABLE Default
RTVPGRP 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 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

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 RFRMESG

Schema Name FAISMGR
Label RFRMESG
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
RFRMESG_AIDY_CODE RFRMESG_AIDY_CODE VARCHAR2(4) No *
RFRMESG_AIDY_CODE RFRMESG_AIDY_CODE VARCHAR2(4) No *
RFRMESG_AIDY_CODE RFRMESG_AIDY_CODE VARCHAR2(4) No *
RFRMESG_FUND_CODE RFRMESG_FUND_CODE VARCHAR2(6) No *
RFRMESG_FUND_CODE RFRMESG_FUND_CODE VARCHAR2(6) No *
RFRMESG_MESG_CODE RFRMESG_MESG_CODE VARCHAR2(4) No *
RFRMESG_ACTIVITY_DATE RFRMESG_ACTIVITY_DATE DATE No
RFRMESG_LETR_CODE RFRMESG_LETR_CODE VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RFRMESG_AIDY_CODE RFRASPC_AIDY_CODE RFRASPC
RFRMESG_FUND_CODE RFRASPC_FUND_CODE RFRASPC
RFRMESG_FUND_CODE RPRAWRD_FUND_CODE RPRAWRD
RFRMESG_AIDY_CODE RPRAWRD_AIDY_CODE RPRAWRD
RFRMESG_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RFRMESG_MESG_CODE RTVMESG_CODE RTVMESG
RFRMESG_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
RFRMESG_KEY_INDEX Unique RFRMESG_AIDY_CODE
RFRMESG_KEY_INDEX Unique RFRMESG_FUND_CODE
RFRMESG_KEY_INDEX Unique RFRMESG_MESG_CODE
RFRMESG_KEY_INDEX Unique RFRMESG_LETR_CODE

Comments

Source Code Comments

Fund / Message Assignment Rules Table

Columns Comments for RFRMESG_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 RFRMESG_FUND_CODE (2)

Source Code Comments

FUND CODE: The fund code associated with the messages.

Columns Comments for RFRMESG_MESG_CODE (3)

Source Code Comments

MESSAGE CODE: This code is used to identify certain fund specific messages to appear on selected letters.

Columns Comments for RFRMESG_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 RFRMESG_LETR_CODE (5)

Source Code Comments

LETTER CODE: The valid letter code identifying the letter where the specific fund message should appear.

Table RFRTREQ

Schema Name FAISMGR
Label RFRTREQ
Server name MALDEV8_B60
Creation Date 11/11/2003 15:18:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RFRTREQ_AIDY_CODE RFRTREQ_AIDY_CODE VARCHAR2(4) No * *
RFRTREQ_AIDY_CODE RFRTREQ_AIDY_CODE VARCHAR2(4) No * *
RFRTREQ_FUND_CODE RFRTREQ_FUND_CODE VARCHAR2(6) No * *
RFRTREQ_TREQ_CODE RFRTREQ_TREQ_CODE VARCHAR2(6) No * *
RFRTREQ_ACTIVITY_DATE RFRTREQ_ACTIVITY_DATE DATE No
RFRTREQ_CREATE_ON_ACCEPT_FLAG RFRTREQ_CREATE_ON_ACCEPT_FLAG VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RFRTREQ_AIDY_CODE RFRASPC_AIDY_CODE RFRASPC
RFRTREQ_FUND_CODE RFRASPC_FUND_CODE RFRASPC
RFRTREQ_TREQ_CODE RTVTREQ_CODE RTVTREQ
RFRTREQ_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name