ROBINST RPBSTAB RPRASTC RPRASTD RPRAUTH RPRCASH RPRSTAC RTVRPSR

Model Short Term Credit


Model Label :
Path : BANNER DEV/Financial Aid/Finaid_ERD/ShortTermCredit_ERD

List of Objects

Object Name Object Type Layer Name
ROBINST TABLE Default
RPBSTAB TABLE Default
RPRASTC TABLE Default
RPRASTD TABLE Default
RPRAUTH TABLE Default
RPRCASH TABLE Default
RPRSTAC TABLE Default
RTVRPSR TABLE Default

Comments

Model View

''

Table ROBINST

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROBINST_AIDY_CODE ROBINST_AIDY_CODE VARCHAR2(4) No *
ROBINST_AIDY_DESC ROBINST_AIDY_DESC VARCHAR2(30) No
ROBINST_AIDY_START_DATE ROBINST_AIDY_START_DATE DATE No
ROBINST_AIDY_END_DATE ROBINST_AIDY_END_DATE DATE No
ROBINST_AIDY_START_YEAR ROBINST_AIDY_START_YEAR NUMBER(4,0) No
ROBINST_AIDY_END_YEAR ROBINST_AIDY_END_YEAR NUMBER(4,0) No
ROBINST_STATUS_IND ROBINST_STATUS_IND VARCHAR2(1) No
ROBINST_BUDG_AUDIT_IND ROBINST_BUDG_AUDIT_IND VARCHAR2(1) No
ROBINST_NEED_AUDIT_IND ROBINST_NEED_AUDIT_IND VARCHAR2(1) No
ROBINST_PCKG_AUDIT_IND ROBINST_PCKG_AUDIT_IND VARCHAR2(1) No
ROBINST_PELL_AUDIT_IND ROBINST_PELL_AUDIT_IND VARCHAR2(1) No
ROBINST_APPL_DATE_IND ROBINST_APPL_DATE_IND VARCHAR2(1) No
ROBINST_TFC_PRO_IND ROBINST_TFC_PRO_IND VARCHAR2(1) No
ROBINST_PAYVOCH_REQ_IND ROBINST_PAYVOCH_REQ_IND VARCHAR2(1) No
ROBINST_METHOD_IND ROBINST_METHOD_IND VARCHAR2(1) No
ROBINST_INFC_CODE ROBINST_INFC_CODE VARCHAR2(7) No *
ROBINST_INAS_OPTION ROBINST_INAS_OPTION VARCHAR2(1) No
ROBINST_ACTIVITY_DATE ROBINST_ACTIVITY_DATE DATE No
ROBINST_TRST_CODE_EST ROBINST_TRST_CODE_EST VARCHAR2(1) Yes *
ROBINST_TRST_CODE_EST ROBINST_TRST_CODE_EST VARCHAR2(1) Yes *
ROBINST_TRST_CODE_EST ROBINST_TRST_CODE_EST VARCHAR2(1) Yes *
ROBINST_BGRP_CODE ROBINST_BGRP_CODE VARCHAR2(6) Yes *
ROBINST_TGRP_CODE ROBINST_TGRP_CODE VARCHAR2(6) Yes *
ROBINST_PGRP_CODE ROBINST_PGRP_CODE VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_APPL ROBINST_TREQ_CODE_APPL VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_APPL ROBINST_TREQ_CODE_APPL VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_APPL ROBINST_TREQ_CODE_APPL VARCHAR2(6) Yes *
ROBINST_APRD_CODE_DEF ROBINST_APRD_CODE_DEF VARCHAR2(6) Yes *
ROBINST_SAPR_CODE ROBINST_SAPR_CODE VARCHAR2(6) Yes *
ROBINST_SAPR_CODE ROBINST_SAPR_CODE VARCHAR2(6) Yes *
ROBINST_SAPR_CODE ROBINST_SAPR_CODE VARCHAR2(6) Yes *
ROBINST_FINAID_DIR_NAME ROBINST_FINAID_DIR_NAME VARCHAR2(30) Yes
ROBINST_TREQ_CODE_SAR ROBINST_TREQ_CODE_SAR VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_SAR ROBINST_TREQ_CODE_SAR VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_SAR ROBINST_TREQ_CODE_SAR VARCHAR2(6) Yes *
ROBINST_CURRENT_TERM_CODE ROBINST_CURRENT_TERM_CODE VARCHAR2(6) Yes *
ROBINST_TRST_CODE_SAR ROBINST_TRST_CODE_SAR VARCHAR2(1) Yes *
ROBINST_TRST_CODE_SAR ROBINST_TRST_CODE_SAR VARCHAR2(1) Yes *
ROBINST_TRST_CODE_SAR ROBINST_TRST_CODE_SAR VARCHAR2(1) Yes *
ROBINST_FINAID_DIR_PHONE_AREA ROBINST_FINAID_DIR_PHONE_AREA VARCHAR2(3) Yes
ROBINST_FINAID_DIR_PHONE_NO ROBINST_FINAID_DIR_PHONE_NO VARCHAR2(7) Yes
ROBINST_PELL_ID ROBINST_PELL_ID VARCHAR2(6) Yes
ROBINST_ENTITY_ID ROBINST_ENTITY_ID VARCHAR2(12) Yes
ROBINST_SERV_AGENT_CDE ROBINST_SERV_AGENT_CDE VARCHAR2(2) Yes
ROBINST_SBGI_CONV_IND ROBINST_SBGI_CONV_IND VARCHAR2(1) Yes
ROBINST_INST_SBGI_CODE ROBINST_INST_SBGI_CODE VARCHAR2(6) Yes *
ROBINST_ELO_IND ROBINST_ELO_IND VARCHAR2(1) Yes
ROBINST_DL_SCHOOL_CODE ROBINST_DL_SCHOOL_CODE VARCHAR2(6) Yes
ROBINST_DEST_NUMBER ROBINST_DEST_NUMBER VARCHAR2(5) Yes
ROBINST_INFO_ACCESS_IND ROBINST_INFO_ACCESS_IND VARCHAR2(1) Yes
ROBINST_DFLT_MSG_EXP_DAYS ROBINST_DFLT_MSG_EXP_DAYS NUMBER(4,0) Yes
ROBINST_INAS_NON_CUST ROBINST_INAS_NON_CUST VARCHAR2(1) Yes
ROBINST_UPD_TRAN_IND ROBINST_UPD_TRAN_IND VARCHAR2(1) Yes
ROBINST_LOAN_PROCESS_TYPE ROBINST_LOAN_PROCESS_TYPE VARCHAR2(1) Yes
ROBINST_SAPR_CODE_EXCEPT ROBINST_SAPR_CODE_EXCEPT VARCHAR2(6) Yes *
ROBINST_SAPR_CODE_EXCEPT ROBINST_SAPR_CODE_EXCEPT VARCHAR2(6) Yes *
ROBINST_SAPR_CODE_EXCEPT ROBINST_SAPR_CODE_EXCEPT VARCHAR2(6) Yes *
ROBINST_PIVOT_DATE ROBINST_PIVOT_DATE DATE Yes
ROBINST_DL_AFFIRM_IND ROBINST_DL_AFFIRM_IND VARCHAR2(1) Yes
ROBINST_FORMER_HEAL_IND ROBINST_FORMER_HEAL_IND VARCHAR2(1) Yes
ROBINST_CASH_MONITOR_IND ROBINST_CASH_MONITOR_IND VARCHAR2(1) Yes
ROBINST_JUST_IN_TIME_IND ROBINST_JUST_IN_TIME_IND VARCHAR2(1) Yes
ROBINST_PELL_RED_ELIG_IND ROBINST_PELL_RED_ELIG_IND VARCHAR2(1) Yes
ROBINST_TREQ_CODE_ENTER_INTV ROBINST_TREQ_CODE_ENTER_INTV VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_ENTER_INTV ROBINST_TREQ_CODE_ENTER_INTV VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_ENTER_INTV ROBINST_TREQ_CODE_ENTER_INTV VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_EXIT_INTV ROBINST_TREQ_CODE_EXIT_INTV VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_EXIT_INTV ROBINST_TREQ_CODE_EXIT_INTV VARCHAR2(6) Yes *
ROBINST_TREQ_CODE_EXIT_INTV ROBINST_TREQ_CODE_EXIT_INTV VARCHAR2(6) Yes *
ROBINST_JIT_NO_DAYS ROBINST_JIT_NO_DAYS NUMBER(2,0) Yes
ROBINST_EL_SCHOOL_CDE ROBINST_EL_SCHOOL_CDE VARCHAR2(6) Yes
ROBINST_MYN_ELIGIBLE ROBINST_MYN_ELIGIBLE VARCHAR2(1) Yes
ROBINST_TITLE_IV_RET_IND ROBINST_TITLE_IV_RET_IND VARCHAR2(1) Yes
ROBINST_TITLE_IV_ROUND_IND ROBINST_TITLE_IV_ROUND_IND VARCHAR2(1) Yes
ROBINST_EL_BRANCH_CDE ROBINST_EL_BRANCH_CDE VARCHAR2(2) Yes
ROBINST_APPL_DATE_SOURCE ROBINST_APPL_DATE_SOURCE VARCHAR2(7) Yes
ROBINST_ALTERNATE_PELL_IND ROBINST_ALTERNATE_PELL_IND VARCHAR2(1) Yes
ROBINST_EL_AUDIT_IND ROBINST_EL_AUDIT_IND VARCHAR2(1) Yes
ROBINST_EL_AUDIT_NO_DAYS ROBINST_EL_AUDIT_NO_DAYS NUMBER(2,0) Yes
ROBINST_TRST_CODE_ENTER_INTV ROBINST_TRST_CODE_ENTER_INTV VARCHAR2(1) Yes
ROBINST_TRST_CODE_EXIT_INTV ROBINST_TRST_CODE_EXIT_INTV VARCHAR2(1) Yes
ROBINST_NEW_PELL_CALC_IND ROBINST_NEW_PELL_CALC_IND VARCHAR2(1) No
ROBINST_FULL_PARTICIPANT_IND ROBINST_FULL_PARTICIPANT_IND VARCHAR2(1) Yes
ROBINST_COMMON_SCHOOL_ID ROBINST_COMMON_SCHOOL_ID VARCHAR2(8) Yes
ROBINST_TURN_OFF_PELL_IND ROBINST_TURN_OFF_PELL_IND VARCHAR2(1) Yes
ROBINST_PELL_FUND_CODE ROBINST_PELL_FUND_CODE VARCHAR2(6) Yes
ROBINST_RESCHED_DISB_DATE_IND ROBINST_RESCHED_DISB_DATE_IND VARCHAR2(1) Yes
ROBINST_DL_COD_FP_IND ROBINST_DL_COD_FP_IND VARCHAR2(1) Yes
ROBINST_PELL_COD_FP_IND ROBINST_PELL_COD_FP_IND VARCHAR2(1) Yes
ROBINST_PELL_LT_HALF_IND ROBINST_PELL_LT_HALF_IND VARCHAR2(1) Yes
ROBINST_MULTI_YR_PERK_MPN_FLAG ROBINST_MULTI_YR_PERK_MPN_FLAG VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
ROBINST_PGRP_CODE RTVPGRP_CODE RTVPGRP
ROBINST_INFC_CODE RTVINFC_CODE RTVINFC
ROBINST_APRD_CODE_DEF RTVAPRD_CODE RTVAPRD
ROBINST_TGRP_CODE RTVTGRP_CODE RTVTGRP
ROBINST_BGRP_CODE RTVBGRP_CODE RTVBGRP
ROBINST_CURRENT_TERM_CODE STVTERM_CODE STVTERM
ROBINST_INST_SBGI_CODE STVSBGI_CODE STVSBGI

Index

Index Name Index Type Column Name
PK_ROBINST Unique ROBINST_AIDY_CODE

Comments

Source Code Comments

Financial Aid Institution Table

Columns Comments for ROBINST_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 ROBINST_AIDY_DESC (2)

Source Code Comments

AID YEAR DESCRIPTION: The description of the valid aid year.

Columns Comments for ROBINST_AIDY_START_DATE (3)

Source Code Comments

AID YEAR START DATE: This is the official start date of the aid year.

Columns Comments for ROBINST_AIDY_END_DATE (4)

Source Code Comments

AID YEAR END DATE: This is the official end date of the aid year.

Columns Comments for ROBINST_AIDY_START_YEAR (5)

Source Code Comments

AID YEAR START YEAR: The year and century of the Aid Year Start date. Example: If the Aid Year Start Date = 01-JUL-1990, then Aid Year Start Year = 1990.

Columns Comments for ROBINST_AIDY_END_YEAR (6)

Source Code Comments

AID YEAR END YEAR: The year and century of the Aid Year End date. Example: If the Aid Year End Date = 30-JUN-1991, then Aid Year End Year = 1991.

Columns Comments for ROBINST_STATUS_IND (7)

Source Code Comments

AID YEAR STATUS CODE: This code defines if this Aid Year is an active year.

Columns Comments for ROBINST_BUDG_AUDIT_IND (8)

Source Code Comments

BUDGET AUDIT TRAIL INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the budgeting module.

Columns Comments for ROBINST_NEED_AUDIT_IND (9)

Source Code Comments

NEED ANALYSIS AUDIT TRAIL INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the Need Analysis module.

Columns Comments for ROBINST_PCKG_AUDIT_IND (10)

Source Code Comments

PACKAGING AUDIT INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the Packaging Module.

Columns Comments for ROBINST_PELL_AUDIT_IND (11)

Source Code Comments

PELL CORRECTION AUDIT INDICATOR: This indicator is used to define if the institution wishes to log changes for electronic pell corrections.

Columns Comments for ROBINST_APPL_DATE_IND (12)

Source Code Comments

APPLICATION RECEIVE DATE INDICATOR: This field identifies which date the institution wishes to use as the application receipt date.

Columns Comments for ROBINST_TFC_PRO_IND (13)

Source Code Comments

TOTAL FAMILY CONTRIBUTION PRORATION: This code indicates whether the institution wishes to use TFC proration based on the percentage of year identified by the aid period in budgeting.

Columns Comments for ROBINST_PAYVOCH_REQ_IND (14)

Source Code Comments

CREATE PAYMENT VOUCHER PRIOR TO PAYMENT: This field indicates whether the institution can create a Pell payment voucher prior to payment.

Columns Comments for ROBINST_METHOD_IND (15)

Source Code Comments

METHODOLOGY INDICATOR: This code specifies the primary methodology that the institution uses in the processing of applications. Examples: Federal Methodology or Institutional Methodology.

Columns Comments for ROBINST_INFC_CODE (16)

Source Code Comments

INTERFACE CODE: The code of the originating source of records from outside agencies.

Columns Comments for ROBINST_INAS_OPTION (17)

Source Code Comments

INAS OPTION: The default INAS calculation option that will be used when INAS is performed. Valid values are (S)hort and (L)ong.

Columns Comments for ROBINST_ACTIVITY_DATE (18)

Source Code Comments

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

Columns Comments for ROBINST_TRST_CODE_EST (19)

Source Code Comments

REQUIREMENT TRACKING ESTABLISHED STATUS CODE: This field maintains the tracking status code which means the requirement has been established.

Columns Comments for ROBINST_BGRP_CODE (20)

Source Code Comments

DEFAULT BUDGET GROUP: This field identifies the default budget group.

Columns Comments for ROBINST_TGRP_CODE (21)

Source Code Comments

DEFAULT TRACKING GROUP CODE: This code identifies the default tracking group.

Columns Comments for ROBINST_PGRP_CODE (22)

Source Code Comments

DEFAULT PACKAGING GROUP: This field identifies the default packaging group.

Columns Comments for ROBINST_TREQ_CODE_APPL (23)

Source Code Comments

APPLICATION REQUIREMENT CODE: This code is the institution's defined tracking requirement code for an institutional application.

Columns Comments for ROBINST_APRD_CODE_DEF (24)

Source Code Comments

DEFAULT AID PERIOD: This field defines the default aid period.

Columns Comments for ROBINST_SAPR_CODE (25)

Source Code Comments

INITIAL SAP CODE: This field is defined as the SAP Status Code assigned to a student when that student's first RORSAPR record is created.

Columns Comments for ROBINST_FINAID_DIR_NAME (26)

Source Code Comments

FINANCIAL AID DIRECTOR: The financial aid director's name.

Columns Comments for ROBINST_TREQ_CODE_SAR (27)

Source Code Comments

SAR REQUIREMENT CODE: This code identifies the requirement tracking code for the Student Aid Report in RTVTREQ.

Columns Comments for ROBINST_CURRENT_TERM_CODE (28)

Source Code Comments

CURRENT TERM CODE: This code identifies which term the institution is currently in.

Columns Comments for ROBINST_TRST_CODE_SAR (29)

Source Code Comments

SAR SATISFIED STATUS: This is the Requirement Tracking Status code which the institution wishes to be associated with the SAR tracking requirement code upon certification of the SAR.

Columns Comments for ROBINST_FINAID_DIR_PHONE_AREA (30)

Source Code Comments

AREA CODE: This field carries the area code of the financial aid director's phone number.

Columns Comments for ROBINST_FINAID_DIR_PHONE_NO (31)

Source Code Comments

PHONE NUMBER: This field is the Financial Aid Director's phone number.

Columns Comments for ROBINST_PELL_ID (32)

Source Code Comments

MAIN CAMPUS PELL ID: This field identifies the Pell ID number for the main campus.

Columns Comments for ROBINST_ENTITY_ID (33)

Source Code Comments

MAIN CAMPUS ENTITY ID: This field carries the institution's Pell Entity ID number for the main campus.

Columns Comments for ROBINST_SERV_AGENT_CDE (34)

Source Code Comments

SERVICE AGENT CODE: An optional field used to identify the Service Agent chosen by the institution to process its Electronic Data Exchange data. The code is assigned by the U.S. Dept. of Ed.

Columns Comments for ROBINST_INST_SBGI_CODE (36)

Source Code Comments

This field identifies the source background associated with the Institution.

Columns Comments for ROBINST_ELO_IND (37)

Source Code Comments

ELO PARTICIPATION INDICATOR: Field identifies whether or not the Institution is participating in the ELO program.

Columns Comments for ROBINST_DL_SCHOOL_CODE (38)

Source Code Comments

This is the school code assigned by the Department of Education to schools participating in Direct Lending.

Columns Comments for ROBINST_DEST_NUMBER (39)

Source Code Comments

GES DESTINATION NUMBER: This is the 5 digit GES destination code assigned to each institution. Prior to 9899 aid year, only required to supply 4 position code as the TG5 was automatically assumed. Effective 9899 and beyond, only TG is assumed.

Columns Comments for ROBINST_INFO_ACCESS_IND (40)

Source Code Comments

INFORMATION ACCESS INDICATOR: A Y in this field indicates that the information for this aid year may be accessed via Voice Response, Banner Web and similar methods.

Columns Comments for ROBINST_DFLT_MSG_EXP_DAYS (41)

Source Code Comments

DEFAULT MESSAGE EXPIRATION DAYS: The number of days until a message expires, to be used as a default value when messages are created.

Columns Comments for ROBINST_INAS_NON_CUST (42)

Source Code Comments

WHICH NON-CUSTODIAL PARENTAL CONTRIBUTION: Indicates which (reported or calculated/override) non-custodial PC should be passed to INAS.

Columns Comments for ROBINST_UPD_TRAN_IND (43)

Source Code Comments

UPDATE TRANSACTION NUMBER INDICATOR: Indicates when data load process should update the Pell Transaction Number and EFC. A or blank - Always, N - Never, L - Update unless locked.

Columns Comments for ROBINST_LOAN_PROCESS_TYPE (44)

Source Code Comments

LOAN PROCESS TYPE: Indicates which types of loans the institution processes: (D)irect, (E)lectronic, (B)oth, or (N)either.

Columns Comments for ROBINST_SAPR_CODE_EXCEPT (45)

Source Code Comments

EXCEPTION SAP CODE: This field is defined as the SAP Status Code assigned to a student if that student fails to meet all existing SAP Status Code Rules.

Columns Comments for ROBINST_PIVOT_DATE (46)

Source Code Comments

PIVOT DATE: The date on which Banner should start using the aid year code of this record as the global aid year.

Columns Comments for ROBINST_DL_AFFIRM_IND (47)

Source Code Comments

DL AFFIRMATION PILOT INDICATOR: This field indicates whether the school participates in the DL Affirmation Pilot Program and chooses to prevent disbursements of Direct Loans to borrowers who do not authorize the disbursement of funds under the MPN.

Columns Comments for ROBINST_FORMER_HEAL_IND (48)

Source Code Comments

FORMER HEAL INDICATOR: When this indicator is set, HEAL loan limits will be used to determine annual eligibility for Stafford Loans for those students whose Former HEAL Indicator is set on RORSTAT.

Columns Comments for ROBINST_CASH_MONITOR_IND (49)

Source Code Comments

CASH MONITORING OR REIMBURSEMENT CLASSIFICATION INDICATOR: Indicates whether the institution must follow cash monitoring rules established by the Department of Education. Valid values Y, blank.

Columns Comments for ROBINST_JUST_IN_TIME_IND (50)

Source Code Comments

JUST IN TIME PAYMENT METHOD INDICATOR: Indicates whether the institution wants Just In Time disbursement edits applied to Pell disbursements. Valid Values Y, blank.

Columns Comments for ROBINST_PELL_RED_ELIG_IND (51)

Source Code Comments

PELL REDUCED ELIGIBILITY INDICATOR: Indicator to be used by the RPEPELL process to determine whether or not to set the Pell Origination Indicator if Pell eligibility is reduced. Valid values are Y and blank.

Columns Comments for ROBINST_TREQ_CODE_ENTER_INTV (52)

Source Code Comments

ENTRANCE INTERVIEW REQUIREMENT CODE: The requirement code that will be used for Entrance Interviews.

Columns Comments for ROBINST_TREQ_CODE_EXIT_INTV (53)

Source Code Comments

EXIT INTERVIEW REQUIREMENT CODE: The requirement code that will be used for Exit Interviews.

Columns Comments for ROBINST_JIT_NO_DAYS (54)

Source Code Comments

JUST IN TIME NO. OF DAYS PRIOR TO SCHEDULED DISBURSEMENT DATE TO REQUEST FUNDING: The number of days prior to the sched. Disb. date that a Disb. will be allowed to be extracted. For JIT students, only authorized aid will be reported to RFMS.

Columns Comments for ROBINST_EL_SCHOOL_CDE (55)

Source Code Comments

EL SCHOOL CODE: This is the Dept of Ed school code to be used for Electronic Loan processing for this specific campus.

Columns Comments for ROBINST_MYN_ELIGIBLE (56)

Source Code Comments

MULTI-YEAR NOTE ELIGIBILITY INDICATOR: This field indicates whether the school is eligible to use the multi-year functionality for the MPN. This field should be unchecked if the school has elected not to use or is not eligible for the multi-year functionality.

Columns Comments for ROBINST_TITLE_IV_RET_IND (57)

Source Code Comments

INSTITUTIONAL DEFAULT RETURN OF TITLE IV FUNDS RETURN INDICATOR: Indicates whether the institution has optionally decided to return funds on the student's behalf to the Title IV programs. Valid values are Y and Null.

Columns Comments for ROBINST_TITLE_IV_ROUND_IND (58)

Source Code Comments

INSTITUTIONAL DEFAULT RETURN OF TITLE IV FUNDS ROUNDING INDICATOR: Indicates whether or not the final repayment amounts that the institution and the student are each responsible to return are rounded to the nearest dollar. Valid values are Y and Null.

Columns Comments for ROBINST_EL_BRANCH_CDE (59)

Source Code Comments

EL BRANCH ID: The 2-digit campus ID associated with the 6-digit school code assigned by the Dept of Ed.

Columns Comments for ROBINST_APPL_DATE_SOURCE (60)

Source Code Comments

MDE SOURCE OF APPLICATION RECEIVED DATE: The source of the data that will be used to update the Application Received date.

Columns Comments for ROBINST_ALTERNATE_PELL_IND (61)

Source Code Comments

ALTERNATE PELL SCHEDULE INDICATOR: Flags whether or not the school has students who qualify for the Alternate Pell Schedule for the aid year. Default value is Null. Valid values Y means yes, Null means No.

Columns Comments for ROBINST_EL_AUDIT_IND (62)

Source Code Comments

CHANGE TRANSACTION INDICATOR: Flags whether or not the school will use CommonLine Change Transaction processing. Default value is Null. Valid values: Y yes, Null means No.

Columns Comments for ROBINST_EL_AUDIT_NO_DAYS (63)

Source Code Comments

CHANGE TRANSACTION UPDATE DEFAULT NUMBER OF DAYS: Minimum number of days allowed prior to a scheduled disbursement to send Change Transaction record. This number will be used as the default number of days.

Columns Comments for ROBINST_TRST_CODE_ENTER_INTV (64)

Source Code Comments

ENTRANCE INTERVIEW SATISFIED STATUS CODE: The status code that will indicate that the Entrance Interview requirement has been satisfied.

Columns Comments for ROBINST_TRST_CODE_EXIT_INTV (65)

Source Code Comments

EXIT INTERVIEW SATISFIED STATUS CODE: The status code that will indicate that the Exit Interview requirement has been satisfied.

Columns Comments for ROBINST_NEW_PELL_CALC_IND (66)

Source Code Comments

TURN ON NEW PELL CALCULATION: Turns on the new Pell calculation for an aid year. Set to Y to use new Pell calculation. Set to N to use the old Pell calculation.

Columns Comments for ROBINST_FULL_PARTICIPANT_IND (67)

Source Code Comments

FULL PARTICIPANT INDICATOR: Identifies schools that are participating in the COD program as Full Participants.

Columns Comments for ROBINST_COMMON_SCHOOL_ID (68)

Source Code Comments

ROUTING NUMBER: The entity ID unique to this institution. Formerly Common School ID.

Columns Comments for ROBINST_TURN_OFF_PELL_IND (69)

Source Code Comments

INDICATOR TO TURN OFF PELL PROCESS: Indicator used to prevent Pell process from automatically running from forms for any students at this institution. Set to Y to prevent.

Columns Comments for ROBINST_PELL_FUND_CODE (70)

Source Code Comments

DEFAULT PELL FUND CODE: The primary Pell fund code to use when there are more than one Pell fund defined on RFRBASE, and the applicant is not assigned to a campus that has a unique Pell fund associated with it.

Columns Comments for ROBINST_RESCHED_DISB_DATE_IND (71)

Source Code Comments

RESCHEDULE DISBURSEMENT DATE: Indicator to reschedule the disbursement dates for non-loan funds based on the Disbursement Date Offset rules when one of the Award Forms is entered and as part of the Disbursement process. Valid values Y and null. Default = null.

Columns Comments for ROBINST_DL_COD_FP_IND (72)

Source Code Comments

DIRECT LOAN FULL PARTICIPANT INDICATOR: Identifies schools that are participating in the COD program as Full Participants for Direct Loans.

Columns Comments for ROBINST_PELL_COD_FP_IND (73)

Source Code Comments

PELL FULL PARTICIPANT INDICATOR: Identifies schools that are participating in the COD program as Full Participants for Pell.

Columns Comments for ROBINST_PELL_LT_HALF_IND (74)

Source Code Comments

PELL LESS THAN HALF INDICATOR: Indicator to turn on the new Pell less than half-time budget calculation. Set to Y to calculate Pell less than half-time budgets using RTVCOMP budget components designated as eligible for Pell less than half-time.

Columns Comments for ROBINST_MULTI_YR_PERK_MPN_FLAG (75)

Source Code Comments

USING MULTI-AWARD YEARS PERKINS MPN FLAG: Checking this flag indicates the institution is using the option for multi-award years Perkins MPN.

Table RPBSTAB

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPBSTAB_CREDIT_ACCT RPBSTAB_CREDIT_ACCT VARCHAR2(6) No *
RPBSTAB_DESC RPBSTAB_DESC VARCHAR2(30) No
RPBSTAB_BUDG_AMT RPBSTAB_BUDG_AMT NUMBER(11,2) No
RPBSTAB_AVAIL_LOAN_AMT RPBSTAB_AVAIL_LOAN_AMT NUMBER(11,2) No
RPBSTAB_MIN_LOAN_AMT RPBSTAB_MIN_LOAN_AMT NUMBER(11,2) No
RPBSTAB_MAX_LOAN_AMT RPBSTAB_MAX_LOAN_AMT NUMBER(11,2) No
RPBSTAB_ACTIVITY_DATE RPBSTAB_ACTIVITY_DATE DATE No
RPBSTAB_REQUEST_AMT RPBSTAB_REQUEST_AMT NUMBER(11,2) Yes
RPBSTAB_APPROVE_AMT RPBSTAB_APPROVE_AMT NUMBER(11,2) Yes
RPBSTAB_REPAID_AMT RPBSTAB_REPAID_AMT NUMBER(11,2) Yes
RPBSTAB_DURATION RPBSTAB_DURATION VARCHAR2(3) Yes
RPBSTAB_RECEIVE_AMT RPBSTAB_RECEIVE_AMT NUMBER(11,2) Yes
RPBSTAB_COLLECT_AMT RPBSTAB_COLLECT_AMT NUMBER(11,2) Yes
RPBSTAB_BALANCE_DUE RPBSTAB_BALANCE_DUE NUMBER(11,2) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RPBSTAB Unique RPBSTAB_CREDIT_ACCT

Comments

Source Code Comments

Short-Term Credit Account Base Table

Columns Comments for RPBSTAB_CREDIT_ACCT (1)

Source Code Comments

CREDIT ACCOUNT: This key field identifies the short term credit accounts that will be included within the Short Term Loan Module. If the short term credit account does not exist, it will be added.

Columns Comments for RPBSTAB_DESC (2)

Source Code Comments

SHORT TERM CREDIT ACCOUNT DESCRIPTION: This field provides a description of the short term credit accounts. The field is required but is free-form with no validation.

Columns Comments for RPBSTAB_BUDG_AMT (3)

Source Code Comments

BUDGET AMOUNT: This field identifies the amount of funds in the budget for the specific credit account.

Columns Comments for RPBSTAB_AVAIL_LOAN_AMT (4)

Source Code Comments

AVAILABLE TO LOAN AMOUNT: This field identifies the dollar amount that is available to be lent from the credit account.

Columns Comments for RPBSTAB_MIN_LOAN_AMT (5)

Source Code Comments

MINIMUM LOAN AMOUNT: This field specifies the minimum amount to be loaned to a single student from the credit account identified in the key block.

Columns Comments for RPBSTAB_MAX_LOAN_AMT (6)

Source Code Comments

MAXIMUM LOAN AMOUNT: This field maintains the maximum amount to be loaned to a single student from the credit account specified in the key block.

Columns Comments for RPBSTAB_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for RPBSTAB_REQUEST_AMT (8)

Source Code Comments

REQUEST AMOUNT: This system maintained field indicates the dollar amount of requests from the credit account identified in the key block.

Columns Comments for RPBSTAB_APPROVE_AMT (9)

Source Code Comments

APPROVE AMOUNT: This system maintained field indicates the dollar amount of approved short term loans associated with the credit account in the key block.

Columns Comments for RPBSTAB_REPAID_AMT (10)

Source Code Comments

REPAID AMOUNT: This system maintained field indicates the dollar amount of loans repaid to the credit account identified in the key block.

Columns Comments for RPBSTAB_DURATION (11)

Source Code Comments

CREDIT DURATION: This optional field indicates the duration of the grace period associated with the credit account. The due date is calculated using this.

Columns Comments for RPBSTAB_RECEIVE_AMT (12)

Source Code Comments

RECEIVED AMOUNT: This system maintained amount represents the sum of all amounts actually received by students from a particular account.

Columns Comments for RPBSTAB_COLLECT_AMT (13)

Source Code Comments

COLLECTION FEE: This system maintained amount represents the sum of all the collection, penalty, interest and processing charges for all students for a particular account.

Columns Comments for RPBSTAB_BALANCE_DUE (14)

Source Code Comments

BALANCE DUE: This system maintained amount represents the sum of all the balances due from students for a particular account.

Table RPRASTC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRASTC_PIDM RPRASTC_PIDM NUMBER(8,0) No *
RPRASTC_ASTD_SEQ_NO RPRASTC_ASTD_SEQ_NO NUMBER(3,0) No *
RPRASTC_SEQ_NO RPRASTC_SEQ_NO NUMBER(6,3) No *
RPRASTC_USER_ID RPRASTC_USER_ID VARCHAR2(30) No
RPRASTC_ACTIVITY_DATE RPRASTC_ACTIVITY_DATE DATE No
RPRASTC_COMMENT RPRASTC_COMMENT VARCHAR2(50) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RPRASTC Unique RPRASTC_PIDM
PK_RPRASTC Unique RPRASTC_ASTD_SEQ_NO
PK_RPRASTC Unique RPRASTC_SEQ_NO

Comments

Source Code Comments

Applicant Short-Term Credit Comments

Columns Comments for RPRASTC_PIDM (1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRASTC_ASTD_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: This field maintains a unique sequence number to identify the short term credit record.

Columns Comments for RPRASTC_SEQ_NO (3)

Source Code Comments

COMMENT SEQUENCE NUMBER: This field maintains the sequence number of the comment associated with the credit record.

Columns Comments for RPRASTC_USER_ID (4)

Source Code Comments

USER ID: This field maintains the user id of the person entering or updating the record.

Columns Comments for RPRASTC_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for RPRASTC_COMMENT (6)

Source Code Comments

COMMENT: This field maintains a comment regarding the short-term credit account record.

Table RPRASTD

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRASTD_PIDM RPRASTD_PIDM NUMBER(8,0) No *
RPRASTD_SEQ_NO RPRASTD_SEQ_NO NUMBER(3,0) No *
RPRASTD_CREDIT_ACCT RPRASTD_CREDIT_ACCT VARCHAR2(6) No *
RPRASTD_APPLIED_DATE RPRASTD_APPLIED_DATE DATE No
RPRASTD_REQUEST_AMT RPRASTD_REQUEST_AMT NUMBER(11,2) No
RPRASTD_DUE_DATE RPRASTD_DUE_DATE DATE No
RPRASTD_ACTIVITY_DATE RPRASTD_ACTIVITY_DATE DATE No
RPRASTD_APPROVE_DATE RPRASTD_APPROVE_DATE DATE Yes
RPRASTD_APPROVE_AMT RPRASTD_APPROVE_AMT NUMBER(11,2) Yes
RPRASTD_CINT_CODE RPRASTD_CINT_CODE VARCHAR2(4) Yes *
RPRASTD_RPSR_CODE RPRASTD_RPSR_CODE VARCHAR2(4) Yes *
RPRASTD_RECEIVE_DATE RPRASTD_RECEIVE_DATE DATE Yes
RPRASTD_REPAID_DATE RPRASTD_REPAID_DATE DATE Yes
RPRASTD_REPAID_AMT RPRASTD_REPAID_AMT NUMBER(11,2) Yes
RPRASTD_RECEIVE_AMT RPRASTD_RECEIVE_AMT NUMBER(11,2) Yes
RPRASTD_COLLECT_AMT RPRASTD_COLLECT_AMT NUMBER(11,2) Yes
RPRASTD_BALANCE_DUE RPRASTD_BALANCE_DUE NUMBER(11,2) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RPRASTD_RPSR_CODE RTVRPSR_CODE RTVRPSR
RPRASTD_CINT_CODE RTVCINT_CODE RTVCINT

Index

Index Name Index Type Column Name
PK_RPRASTD Unique RPRASTD_PIDM
PK_RPRASTD Unique RPRASTD_SEQ_NO
PK_RPRASTD Unique RPRASTD_CREDIT_ACCT

Comments

Source Code Comments

Applicant Short-Term Credit Table

Columns Comments for RPRASTD_PIDM (1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRASTD_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: This field maintains the sequence number of the short-term credit application.

Columns Comments for RPRASTD_CREDIT_ACCT (3)

Source Code Comments

CREDIT ACCOUNT: This field identifies the funding source of the loan. Example: Emergency Loan Fund.

Columns Comments for RPRASTD_APPLIED_DATE (4)

Source Code Comments

APPLIED DATE: This field maintains the application date of the short-term loan.

Columns Comments for RPRASTD_REQUEST_AMT (5)

Source Code Comments

REQUESTED AMOUNT: This field maintains the amount of the short-term loan that was requested.

Columns Comments for RPRASTD_DUE_DATE (6)

Source Code Comments

DUE DATE: This field maintains the due date of the short-term loan.

Columns Comments for RPRASTD_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for RPRASTD_APPROVE_DATE (8)

Source Code Comments

APPROVED DATE: This field maintains the date that the short-term credit application was approved.

Columns Comments for RPRASTD_APPROVE_AMT (9)

Source Code Comments

APPROVED AMOUNT: This field maintains the approved amount of the short-term loan.

Columns Comments for RPRASTD_CINT_CODE (10)

Source Code Comments

CERTIFICATION INITIALS: This field maintains the initials of the person who approved the short-term credit application.

Columns Comments for RPRASTD_RPSR_CODE (11)

Source Code Comments

REPAYMENT SOURCE: This field maintains the source of repayment.

Columns Comments for RPRASTD_RECEIVE_DATE (12)

Source Code Comments

RECEIVED DATE: This field maintains the date that the student received the short-term loan.

Columns Comments for RPRASTD_REPAID_DATE (13)

Source Code Comments

REPAID DATE: This field maintains the most recent date that repayment was made.

Columns Comments for RPRASTD_REPAID_AMT (14)

Source Code Comments

REPAID AMOUNT: This field maintains the amount of the actual repayment.

Columns Comments for RPRASTD_RECEIVE_AMT (15)

Source Code Comments

AMOUNT RECEIVED: This is the amount of the short-term loan that was actually paid to the student.

Columns Comments for RPRASTD_COLLECT_AMT (16)

Source Code Comments

COLLECTION FEE: This is the amount of collection, penalty or interest charges on the short-term credit loan application of the student.

Columns Comments for RPRASTD_BALANCE_DUE (17)

Source Code Comments

BALANCE DUE: This is the current balance due on the loan record accounting for the amount actually paid, partial repayments, and extra fees charged for collection, interest, penalties, or processing fees.

Table RPRAUTH

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRAUTH_AIDY_CODE RPRAUTH_AIDY_CODE VARCHAR2(4) No * *
RPRAUTH_PIDM RPRAUTH_PIDM NUMBER(8,0) No *
RPRAUTH_FUND_CODE RPRAUTH_FUND_CODE VARCHAR2(6) No *
RPRAUTH_TERM_CODE RPRAUTH_TERM_CODE VARCHAR2(6) No * *
RPRAUTH_AMOUNT RPRAUTH_AMOUNT NUMBER(11,2) No
RPRAUTH_ACTIVITY_DATE RPRAUTH_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RPRAUTH_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RPRAUTH_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_RPRAUTH Unique RPRAUTH_AIDY_CODE
PK_RPRAUTH Unique RPRAUTH_PIDM
PK_RPRAUTH Unique RPRAUTH_FUND_CODE
PK_RPRAUTH Unique RPRAUTH_TERM_CODE
RPRAUTH_PIDM_INDEX RPRAUTH_PIDM
RPRAUTH_PIDM_INDEX RPRAUTH_TERM_CODE

Comments

Source Code Comments

Financial Aid Authorization Table

Columns Comments for RPRAUTH_AIDY_CODE (1)

Source Code Comments

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

Columns Comments for RPRAUTH_PIDM (2)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RPRAUTH_FUND_CODE (3)

Source Code Comments

FUND CODE: This field represents the fund code with which the authorized amount is associated.

Columns Comments for RPRAUTH_TERM_CODE (4)

Source Code Comments

TERM CODE: The term associated with the authorized award amount.

Columns Comments for RPRAUTH_AMOUNT (5)

Source Code Comments

AUTHORIZED AMOUNT: This field represents the authorized amount of the award.

Columns Comments for RPRAUTH_ACTIVITY_DATE (6)

Source Code Comments

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

Table RPRCASH

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRCASH_SEQ_NO RPRCASH_SEQ_NO NUMBER(5,0) No
RPRCASH_DRAW_DATE RPRCASH_DRAW_DATE DATE No
RPRCASH_DRAW_AMT RPRCASH_DRAW_AMT NUMBER(11,0) No
RPRCASH_USER_ID RPRCASH_USER_ID VARCHAR2(30) No
RPRCASH_ACTIVITY_DATE RPRCASH_ACTIVITY_DATE DATE No
RPRCASH_ACTION RPRCASH_ACTION VARCHAR2(1) No
RPRCASH_CONF_CODE RPRCASH_CONF_CODE VARCHAR2(13) Yes
RPRCASH_BATCH_NO RPRCASH_BATCH_NO VARCHAR2(23) Yes
RPRCASH_BATCH_DATE RPRCASH_BATCH_DATE DATE Yes
RPRCASH_RECON_STATUS RPRCASH_RECON_STATUS VARCHAR2(1) Yes
RPRCASH_SERVICER_AMT RPRCASH_SERVICER_AMT NUMBER(11,0) Yes
RPRCASH_DL_REJECT_CODE_1 RPRCASH_DL_REJECT_CODE_1 VARCHAR2(1) Yes
RPRCASH_DL_REJECT_CODE_2 RPRCASH_DL_REJECT_CODE_2 VARCHAR2(1) Yes
RPRCASH_DL_REJECT_CODE_3 RPRCASH_DL_REJECT_CODE_3 VARCHAR2(1) Yes
RPRCASH_PROCESS_DATE RPRCASH_PROCESS_DATE DATE Yes
RPRCASH_AIDY_CODE RPRCASH_AIDY_CODE VARCHAR2(4) Yes
RPRCASH_SCHOOL_CODE RPRCASH_SCHOOL_CODE VARCHAR2(6) Yes
RPRCASH_SAS_RECORD_COUNT_SEQ RPRCASH_SAS_RECORD_COUNT_SEQ NUMBER(6,0) Yes
RPRCASH_CHECK_NO RPRCASH_CHECK_NO NUMBER(12,0) Yes
RPRCASH_REGION_CD RPRCASH_REGION_CD VARCHAR2(2) Yes
RPRCASH_SCHOOL_STAT_CODE RPRCASH_SCHOOL_STAT_CODE VARCHAR2(2) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
RPRCASH_KEY_INDEX Unique RPRCASH_DRAW_DATE
RPRCASH_KEY_INDEX Unique RPRCASH_SEQ_NO

Comments

Source Code Comments

Direct Lending Cash Detail

Columns Comments for RPRCASH_SEQ_NO (1)

Source Code Comments