RBRACMP RFRASPC RFRBASE ROBALOG ROBINST RORATND RORAUDT RORCAMP RORCRHR RORDATA RPBLNDA RPBLNDR RPBLOPT RPBLPRD RPRASTD RPRCLSS RPRDLAS RPRDSAS RPREFTD RPREPMT RPRLADB RPRLAPP RPRLATR RPRLCRT RPRLDSB RPRLECS RPRLPAP RPRLTRM RPRRECN RPRRFND RTVCDNT RTVCDST RTVCINT RTVDLBT RTVINFC RTVLNST RTVPHAS RTVPRCD RTVRJCT RTVRPSR RTVYICD

Model Loans


Model Label : Banner Financial Aid Electronic Loans Module.
Path : BANNER DEV/Financial Aid/Finaid_ERD/ElectronicLoans_ERD

List of Objects

Object Name Object Type Layer Name
RBRACMP TABLE Default
RFRASPC TABLE Default
RFRBASE TABLE Default
ROBALOG TABLE Default
ROBINST TABLE Default
RORATND TABLE Default
RORAUDT TABLE Default
RORCAMP TABLE Default
RORCRHR TABLE Default
RORDATA TABLE Default
RPBLNDA TABLE Default
RPBLNDR TABLE Default
RPBLOPT TABLE Default
RPBLPRD TABLE Default
RPRASTD TABLE Default
RPRCLSS TABLE Default
RPRDLAS TABLE Default
RPRDSAS TABLE Default
RPREFTD TABLE Default
RPREPMT TABLE Default
RPRLADB TABLE Default
RPRLAPP TABLE Default
RPRLATR TABLE Default
RPRLCRT TABLE Default
RPRLDSB TABLE Default
RPRLECS TABLE Default
RPRLPAP TABLE Default
RPRLTRM TABLE Default
RPRRECN TABLE Default
RPRRFND TABLE Default
RTVCDNT TABLE Default
RTVCDST TABLE Default
RTVCINT TABLE Default
RTVDLBT TABLE Default
RTVINFC TABLE Default
RTVLNST TABLE Default
RTVPHAS TABLE Default
RTVPRCD TABLE Default
RTVRJCT TABLE Default
RTVRPSR TABLE Default
RTVYICD TABLE Default

Comments

Model View

''

Table RBRACMP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRACMP_AIDY_CODE RBRACMP_AIDY_CODE VARCHAR2(4) No * *
RBRACMP_PIDM RBRACMP_PIDM NUMBER(8,0) No *
RBRACMP_BTYP_CODE RBRACMP_BTYP_CODE VARCHAR2(4) No * *
RBRACMP_COMP_CODE RBRACMP_COMP_CODE VARCHAR2(4) No * *
RBRACMP_AMT RBRACMP_AMT NUMBER(11,2) No
RBRACMP_USER_ID RBRACMP_USER_ID VARCHAR2(30) No
RBRACMP_SYS_IND RBRACMP_SYS_IND VARCHAR2(1) No
RBRACMP_ACTIVITY_DATE RBRACMP_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RBRACMP_COMP_CODE RTVCOMP_CODE RTVCOMP
RBRACMP_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBRACMP_BTYP_CODE RTVBTYP_CODE RTVBTYP

Index

Index Name Index Type Column Name
PK_RBRACMP Unique RBRACMP_AIDY_CODE
PK_RBRACMP Unique RBRACMP_PIDM
PK_RBRACMP Unique RBRACMP_BTYP_CODE
PK_RBRACMP Unique RBRACMP_COMP_CODE

Comments

Source Code Comments

Applicant Budget Component Table

Columns Comments for RBRACMP_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 RBRACMP_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBRACMP_BTYP_CODE (3)

Source Code Comments

BUDGET TYPE CODE: The budget type code associated with this particular budget component.

Columns Comments for RBRACMP_COMP_CODE (4)

Source Code Comments

BUDGET COMPONENT CODE: The code used to identify the source of the expense in the student's budget.

Columns Comments for RBRACMP_AMT (5)

Source Code Comments

BUDGET COMPONENT AMOUNT: The amount of this particular budget component.

Columns Comments for RBRACMP_USER_ID (6)

Source Code Comments

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

Columns Comments for RBRACMP_SYS_IND (7)

Source Code Comments

SYSTEM/MANUAL INDICATOR: The indicator which shows whether the component was created or updated (M)anually by the user , by the (S)ystem through a batch or automatic process, or by use of a mi(X)ed (averaged) budget definition.

Columns Comments for RBRACMP_ACTIVITY_DATE (8)

Source Code Comments

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

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 ROBALOG

Schema Name FAISMGR
Label ROBALOG
Server name MALDEV8_B60
Creation Date 03/27/2003 14:53:11:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROBALOG_EDE_DEL_IND ROBALOG_EDE_DEL_IND VARCHAR2(1) No
ROBALOG_USER_ID ROBALOG_USER_ID VARCHAR2(30) No
ROBALOG_ACTIVITY_DATE ROBALOG_ACTIVITY_DATE DATE No
ROBALOG_AIDY_CODE ROBALOG_AIDY_CODE VARCHAR2(4) Yes *
ROBALOG_PIDM ROBALOG_PIDM NUMBER(8,0) Yes *
ROBALOG_BATCH_PROC_IND ROBALOG_BATCH_PROC_IND VARCHAR2(1) Yes
ROBALOG_DATA_CDE ROBALOG_DATA_CDE VARCHAR2(30) Yes
ROBALOG_FROM ROBALOG_FROM VARCHAR2(50) Yes
ROBALOG_TO ROBALOG_TO VARCHAR2(50) Yes
ROBALOG_EDE_DATE_SENT ROBALOG_EDE_DATE_SENT DATE Yes
ROBALOG_SAR_ID ROBALOG_SAR_ID VARCHAR2(13) Yes
ROBALOG_PIN ROBALOG_PIN VARCHAR2(4) Yes
ROBALOG_COLL_CHOICE ROBALOG_COLL_CHOICE NUMBER(1,0) Yes
ROBALOG_DL_LOAN_ID ROBALOG_DL_LOAN_ID VARCHAR2(21) Yes
ROBALOG_BATCH_NO ROBALOG_BATCH_NO VARCHAR2(23) Yes
ROBALOG_DL_IND ROBALOG_DL_IND VARCHAR2(1) Yes
ROBALOG_INFC_CODE ROBALOG_INFC_CODE VARCHAR2(7) Yes
ROBALOG_SEQ_NO ROBALOG_SEQ_NO NUMBER(3,0) Yes
ROBALOG_DL_DISB_NO ROBALOG_DL_DISB_NO NUMBER(2,0) Yes
ROBALOG_REJECT_CODE ROBALOG_REJECT_CODE VARCHAR2(3) Yes
ROBALOG_CHANGE_STATUS ROBALOG_CHANGE_STATUS VARCHAR2(1) Yes
ROBALOG_EL_LOAN_ID ROBALOG_EL_LOAN_ID VARCHAR2(17) Yes
ROBALOG_EL_SEQ_NO ROBALOG_EL_SEQ_NO NUMBER(2,0) Yes
ROBALOG_EL_FUND_TYPE ROBALOG_EL_FUND_TYPE VARCHAR2(2) Yes
ROBALOG_EL_RECIP_PIDM ROBALOG_EL_RECIP_PIDM NUMBER(8,0) Yes *
ROBALOG_EL_CHANGE_TYPE ROBALOG_EL_CHANGE_TYPE NUMBER(2,0) Yes
ROBALOG_EL_IND ROBALOG_EL_IND VARCHAR2(1) Yes
ROBALOG_EL_ERROR_CODE_1 ROBALOG_EL_ERROR_CODE_1 VARCHAR2(3) Yes
ROBALOG_EL_ERROR_CODE_2 ROBALOG_EL_ERROR_CODE_2 VARCHAR2(3) Yes
ROBALOG_EL_ERROR_CODE_3 ROBALOG_EL_ERROR_CODE_3 VARCHAR2(3) Yes
ROBALOG_EL_ERROR_CODE_4 ROBALOG_EL_ERROR_CODE_4 VARCHAR2(3) Yes
ROBALOG_EL_ERROR_CODE_5 ROBALOG_EL_ERROR_CODE_5 VARCHAR2(3) Yes
ROBALOG_EL_DISB_NO ROBALOG_EL_DISB_NO NUMBER(2,0) Yes
ROBALOG_EL_BOR_SSN ROBALOG_EL_BOR_SSN VARCHAR2(9) Yes
ROBALOG_DOCUMENT_ID ROBALOG_DOCUMENT_ID VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
ROBALOG_AIDY_CODE ROBINST_AIDY_CODE ROBINST
ROBALOG_PIDM SPRIDEN_PIDM SPRIDEN
ROBALOG_EL_RECIP_PIDM SPRIDEN_PIDM SPRIDEN

Index

Index Name Index Type Column Name
ROBALOG_KEY_INDEX ROBALOG_AIDY_CODE
ROBALOG_PIDM_INDEX ROBALOG_PIDM
ROBALOG_PIDM_INDEX ROBALOG_AIDY_CODE

Comments

Source Code Comments

Audit Log Table

Columns Comments for ROBALOG_EDE_DEL_IND (1)

Source Code Comments

PELL CORRECTION INDICATOR: This field indicates whether the logged record should be included in the Pell Correction process.

Columns Comments for ROBALOG_USER_ID (2)

Source Code Comments

USER ID: This field identifies the User ID of the person who made the change which caused the log record.

Columns Comments for ROBALOG_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for ROBALOG_AIDY_CODE (4)

Source Code Comments

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

Columns Comments for ROBALOG_PIDM (5)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for ROBALOG_BATCH_PROC_IND (6)

Source Code Comments

BATCH PROCESS INDICATOR: A 'Y' in this field indicates that this log record was created by a batch process.

Columns Comments for ROBALOG_DATA_CDE (7)

Source Code Comments

DATA ELEMENT CODE: The primary data element that was logged associated with the aid year and ID in the key block.

Columns Comments for ROBALOG_FROM (8)

Source Code Comments

CHANGED FROM: This field identifies the value that the data element in this record was changed from.

Columns Comments for ROBALOG_TO (9)

Source Code Comments

CHANGED TO INDICATOR: This field identifies the value that the data element was changed to for the aid year and ID associated with the record.

Columns Comments for ROBALOG_EDE_DATE_SENT (10)

Source Code Comments

EDE DATE SENT: This field indicates whether the Pell Correction has been sent. The presence of a date indicates the date that the correction has been sent.

Columns Comments for ROBALOG_SAR_ID (11)

Source Code Comments

SAR ID: The SAR ID number of the Pell in which corrections are being sent.

Columns Comments for ROBALOG_PIN (12)

Source Code Comments

PERSONAL IDENTIFICATION NUMBER: The security number provided by the student to access their financial aid application data.

Columns Comments for ROBALOG_COLL_CHOICE (13)

Source Code Comments

COLLEGE CHOICE: The number of the institution which the student wishes to change.

Columns Comments for ROBALOG_DL_LOAN_ID (14)

Source Code Comments

The loan id, one for each logging record, is made up of the social security number of the student, the loan type and the loan year.

Columns Comments for ROBALOG_BATCH_NO (15)

Source Code Comments

Indicates the batch number that this logging record is associated with.

Columns Comments for ROBALOG_DL_IND (16)

Source Code Comments

Indicates whether the logging record is a direct loan record. Valid values are Y or blank.

Columns Comments for ROBALOG_INFC_CODE (17)

Source Code Comments

SOURCE CODE: The financial aid tape source (CSS, EDE, MANUAL, etc.) of the application being logged, if logging record applies to a financial aid application.

Columns Comments for ROBALOG_SEQ_NO (18)

Source Code Comments

SEQUENCE NUMBER: The sequence number of the application being logged, if logging record applies to a financial aid application.

Columns Comments for ROBALOG_DL_DISB_NO (19)

Source Code Comments

DL DISBURSEMENT NUMBER: Identifies which disbursement the record is associated with.

Columns Comments for ROBALOG_REJECT_CODE (20)

Source Code Comments

REJECT CODE: The reject code returned by the processing agency explaining the reason why the change could not be processed.

Columns Comments for ROBALOG_CHANGE_STATUS (21)

Source Code Comments

CHANGE STATUS: Indicates the status of the processing of the change record.

Columns Comments for ROBALOG_EL_LOAN_ID (22)

Source Code Comments

ELECTRONIC LOAN ID: The CommonLine Unique Identifier assigned to this loan application record.

Columns Comments for ROBALOG_EL_SEQ_NO (23)

Source Code Comments

ELECTRONIC LOAN SEQUENCE NUMBER: The sequence number assigned at the time of guarantee for this loan application record which becomes part of the CommonLine Unique Identifier.

Columns Comments for ROBALOG_EL_FUND_TYPE (24)

Source Code Comments

FUND TYPE: The fund type of the loan application record which is being changed based on CommonLine specifications. Default value is null. Valid values: SF = Federal Subsidized Stafford, SU = Federal Unsubsidized Stafford, PL = Federal PLUS, AL = Alternat
ive.

Columns Comments for ROBALOG_EL_RECIP_PIDM (25)

Source Code Comments

RECIPIENT PIDM: The pidm associated with the Recipient ID who will be receiving this Change Transaction Record.

Columns Comments for ROBALOG_EL_CHANGE_TYPE (26)

Source Code Comments

CHANGE TRANSACTION DETAIL RECORD TYPE: The Detail Record type for this Electronic loan data element.

Columns Comments for ROBALOG_EL_IND (27)

Source Code Comments

ELECTRONIC LOAN INDICATOR: Indicates the record is for Electronic Loan Change Transaction processing. Default value is null. Valid values: Y = yes, null = no.

Columns Comments for ROBALOG_EL_ERROR_CODE_1 (28)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 1: The first error code for this Electronic loan change record.

Columns Comments for ROBALOG_EL_ERROR_CODE_2 (29)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 2: The second error code for this Electronic loan change record.

Columns Comments for ROBALOG_EL_ERROR_CODE_3 (30)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 3: The third error code for this Electronic loan change record.

Columns Comments for ROBALOG_EL_ERROR_CODE_4 (31)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 4: The fourth error code for this Electronic loan change record.

Columns Comments for ROBALOG_EL_ERROR_CODE_5 (32)

Source Code Comments

ELECTRONIC LOAN ERROR CODE 5: The fifth error code for this Electronic loan change record.

Columns Comments for ROBALOG_EL_DISB_NO (33)

Source Code Comments

ELECTRONIC LOAN DISBURSEMENT NUMBER: The disbursement number assigned for this Electronic loan change record.

Columns Comments for ROBALOG_EL_BOR_SSN (34)

Source Code Comments

EL BORROWER SOCIAL SECURITY NUMBER: The Social Security Number of the Borrower for this Loan ID/Seq No.

Columns Comments for ROBALOG_DOCUMENT_ID (35)

Source Code Comments

DOCUMENT ID FOR THE COD FILE: The document ID sent with a set of records.