RBBABUD RBRACMP RBRCOMP RBRGMSG RBRGTYP RBRMIXD RCRAIDY RTVAPRD RTVBGRP RTVBTYP RTVCOMP

Model Budgeting


Model Label : Banner Financial Aid Budgeting Module
Path : Default Folder/B70/finaid/Budgeting_ERD

List of Objects

Object Name Object Type Layer Name
RBBABUD TABLE Default
RBRACMP TABLE Default
RBRCOMP TABLE Default
RBRGMSG TABLE Default
RBRGTYP TABLE Default
RBRMIXD TABLE Default
RCRAIDY TABLE Default
RTVAPRD TABLE Default
RTVBGRP TABLE Default
RTVBTYP TABLE Default
RTVCOMP TABLE Default

Comments

Model View

''

Table RBBABUD

Schema Name FAISMGR
Label RBBABUD
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBBABUD_AIDY_CODE RBBABUD_AIDY_CODE VARCHAR2(4) No * *
RBBABUD_PIDM RBBABUD_PIDM NUMBER(8,0) No *
RBBABUD_TFC_IND RBBABUD_TFC_IND VARCHAR2(1) No *
RBBABUD_BTYP_CODE RBBABUD_BTYP_CODE VARCHAR2(4) No * *
RBBABUD_USER_ID RBBABUD_USER_ID VARCHAR2(30) No
RBBABUD_SYS_IND RBBABUD_SYS_IND VARCHAR2(1) No
RBBABUD_ACTIVITY_DATE RBBABUD_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RBBABUD_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBBABUD_BTYP_CODE RTVBTYP_CODE RTVBTYP

Index

Index Name Index Type Column Name
PK_RBBABUD Unique RBBABUD_AIDY_CODE
PK_RBBABUD Unique RBBABUD_PIDM
PK_RBBABUD Unique RBBABUD_BTYP_CODE
PK_RBBABUD Unique RBBABUD_TFC_IND

Comments

Source Code Comments

Applicant Budget Table

Columns Comments for RBBABUD_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 RBBABUD_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBBABUD_TFC_IND (3)

Source Code Comments

TFC INDICATOR: Indicator to show which Total Family Contribution is to be used for this student when calculating need. EXAMPLES: (F)ederal or (I)nstitutional Methodology

Columns Comments for RBBABUD_BTYP_CODE (4)

Source Code Comments

BUDGET TYPE CODE: Code indicating which budget types have been associated with the student applicant. EXAMPLES: (PELL = Pell Type) (CAMP = Campus-Based Type)

Columns Comments for RBBABUD_USER_ID (5)

Source Code Comments

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

Columns Comments for RBBABUD_SYS_IND (6)

Source Code Comments

SYSTEM/MANUAL INDICATOR: Indicator to show if the student's budget type was assigned (M)anually or by the (S)ystem.

Columns Comments for RBBABUD_ACTIVITY_DATE (7)

Source Code Comments

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

Table RBRACMP

Schema Name FAISMGR
Label RBRACMP
Server name S4B70
Creation Date 09/29/2003 12:14:16: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_BTYP_CODE RTVBTYP_CODE RTVBTYP
RBRACMP_COMP_CODE RTVCOMP_CODE RTVCOMP
RBRACMP_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBRACMP_AIDY_CODE RBBABUD_AIDY_CODE RBBABUD
RBRACMP_PIDM RBBABUD_PIDM RBBABUD
RBRACMP_BTYP_CODE RBBABUD_BTYP_CODE RBBABUD

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 RBRCOMP

Schema Name FAISMGR
Label RBRCOMP
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRCOMP_AIDY_CODE RBRCOMP_AIDY_CODE VARCHAR2(4) No *
RBRCOMP_APRD_CODE RBRCOMP_APRD_CODE VARCHAR2(6) No *
RBRCOMP_COMP_CODE RBRCOMP_COMP_CODE VARCHAR2(4) No *
RBRCOMP_AMT RBRCOMP_AMT NUMBER(11,2) No
RBRCOMP_ACTIVITY_DATE RBRCOMP_ACTIVITY_DATE DATE No
RBRCOMP_BTYP_CODE RBRCOMP_BTYP_CODE VARCHAR2(4) Yes *
RBRCOMP_BGRP_CODE RBRCOMP_BGRP_CODE VARCHAR2(6) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RBRCOMP_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBRCOMP_APRD_CODE RTVAPRD_CODE RTVAPRD
RBRCOMP_BTYP_CODE RTVBTYP_CODE RTVBTYP
RBRCOMP_COMP_CODE RTVCOMP_CODE RTVCOMP
RBRCOMP_BGRP_CODE RTVBGRP_CODE RTVBGRP
RBRCOMP_BGRP_CODE RBRMIXD_BGRP_CODE RBRMIXD
RBRCOMP_AIDY_CODE RBRMIXD_AIDY_CODE RBRMIXD

Index

Index Name Index Type Column Name
RBRCOMP_KEY_INDEX Unique RBRCOMP_AIDY_CODE
RBRCOMP_KEY_INDEX Unique RBRCOMP_BGRP_CODE
RBRCOMP_KEY_INDEX Unique RBRCOMP_BTYP_CODE
RBRCOMP_KEY_INDEX Unique RBRCOMP_APRD_CODE
RBRCOMP_KEY_INDEX Unique RBRCOMP_COMP_CODE

Comments

Source Code Comments

Budget Component Rules Table

Columns Comments for RBRCOMP_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 RBRCOMP_APRD_CODE (2)

Source Code Comments

AID PERIOD CODE: The aid period for the budget being defined.

Columns Comments for RBRCOMP_COMP_CODE (3)

Source Code Comments

BUDGET COMPONENT CODE: The code to identify the component in the budget that is being defined.

Columns Comments for RBRCOMP_AMT (4)

Source Code Comments

BUDGET COMPONENT DOLLAR AMOUNT: The amount of a specific budget component code included in the budget being defined.

Columns Comments for RBRCOMP_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 RBRCOMP_BTYP_CODE (6)

Source Code Comments

BUDGET TYPE CODE: The budget type code for the budget being defined.

Columns Comments for RBRCOMP_BGRP_CODE (7)

Source Code Comments

BUDGET GROUP CODE: The budget group code for the budget being defined.

Table RBRGMSG

Schema Name FAISMGR
Label RBRGMSG
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRGMSG_AIDY_CODE RBRGMSG_AIDY_CODE VARCHAR2(4) No * *
RBRGMSG_BGRP_CODE RBRGMSG_BGRP_CODE VARCHAR2(6) No * *
RBRGMSG_MESG_CODE RBRGMSG_MESG_CODE VARCHAR2(4) No * *
RBRGMSG_ACTIVITY_DATE RBRGMSG_ACTIVITY_DATE DATE No
RBRGMSG_LETR_CODE RBRGMSG_LETR_CODE VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RBRGMSG_MESG_CODE RTVMESG_CODE RTVMESG
RBRGMSG_BGRP_CODE RTVBGRP_CODE RTVBGRP
RBRGMSG_LETR_CODE GTVLETR_CODE GTVLETR
RBRGMSG_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
PK_RBRGMSG Unique RBRGMSG_AIDY_CODE
PK_RBRGMSG Unique RBRGMSG_BGRP_CODE
PK_RBRGMSG Unique RBRGMSG_MESG_CODE

Comments

Source Code Comments

Budget Group Message Rules Table

Columns Comments for RBRGMSG_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 RBRGMSG_BGRP_CODE (2)

Source Code Comments

BUDGET GROUP CODE: The budget group code that is associated with the message and letter codes.

Columns Comments for RBRGMSG_MESG_CODE (3)

Source Code Comments

MESSAGE CODE: The code for the message that is associated with the budget group and letter code.

Columns Comments for RBRGMSG_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 RBRGMSG_LETR_CODE (5)

Source Code Comments

LETTER CODE: The letter code that is associated with a particular budget group and message code.

Table RBRGTYP

Schema Name FAISMGR
Label RBRGTYP
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRGTYP_BGRP_CODE RBRGTYP_BGRP_CODE VARCHAR2(6) No * *
RBRGTYP_BTYP_CODE RBRGTYP_BTYP_CODE VARCHAR2(4) No * *
RBRGTYP_DEFAULT_IND RBRGTYP_DEFAULT_IND VARCHAR2(1) No
RBRGTYP_ACTIVITY_DATE RBRGTYP_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RBRGTYP_BTYP_CODE RTVBTYP_CODE RTVBTYP
RBRGTYP_BGRP_CODE RTVBGRP_CODE RTVBGRP

Index

Index Name Index Type Column Name
PK_RBRGTYP Unique RBRGTYP_BGRP_CODE
PK_RBRGTYP Unique RBRGTYP_BTYP_CODE

Comments

Source Code Comments

Budget Group/Budget Type Rules Table

Columns Comments for RBRGTYP_BGRP_CODE (1)

Source Code Comments

BUDGET GROUP CODE: The budget group code associated with the budget type code.

Columns Comments for RBRGTYP_BTYP_CODE (2)

Source Code Comments

BUDGET TYPE CODE: The budget type code that is associated with the budget group code.

Columns Comments for RBRGTYP_DEFAULT_IND (3)

Source Code Comments

DEFAULT INDICATOR: This indicates which of the eligible budget
types for this group should be created for the student. (In addition to the 'PELL' type if the 'PELL' type is an eligible type for the group.)

Columns Comments for RBRGTYP_ACTIVITY_DATE (4)

Source Code Comments

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

Table RBRMIXD

Schema Name FAISMGR
Label RBRMIXD
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRMIXD_AIDY_CODE RBRMIXD_AIDY_CODE VARCHAR2(4) No * *
RBRMIXD_PIDM RBRMIXD_PIDM NUMBER(8,0) No *
RBRMIXD_BGRP_CODE RBRMIXD_BGRP_CODE VARCHAR2(6) No * *
RBRMIXD_PCT RBRMIXD_PCT NUMBER(6,3) No
RBRMIXD_ACTIVITY_DATE RBRMIXD_ACTIVITY_DATE DATE No
RBRMIXD_USER_ID RBRMIXD_USER_ID VARCHAR2(30) No

Foreign Key information

Column name is Foreign Key For Column on Table
RBRMIXD_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RBRMIXD_BGRP_CODE RTVBGRP_CODE RTVBGRP

Index

Index Name Index Type Column Name
PK_RBRMIXD Unique RBRMIXD_AIDY_CODE
PK_RBRMIXD Unique RBRMIXD_PIDM
PK_RBRMIXD Unique RBRMIXD_BGRP_CODE

Comments

Source Code Comments

Applicant Mixed Enrollment Table

Columns Comments for RBRMIXD_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 RBRMIXD_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RBRMIXD_BGRP_CODE (3)

Source Code Comments

BUDGET GROUP CODE: The budget group code associated with the percent for the student's mixed budget definition.

Columns Comments for RBRMIXD_PCT (4)

Source Code Comments

PERCENT: The percent to be applied to each component in the student's budget for the associated group code when defining a mixed budget.

Columns Comments for RBRMIXD_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 RBRMIXD_USER_ID (6)

Source Code Comments

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

Table RCRAIDY

Schema Name FAISMGR
Label RCRAIDY
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RCRAIDY_PRIORITY RCRAIDY_PRIORITY NUMBER(4,0) No *
RCRAIDY_AIDY_YEAR RCRAIDY_AIDY_YEAR VARCHAR2(4) No *
RCRAIDY_MSG_ID_1 RCRAIDY_MSG_ID_1 NUMBER(6,0) No
RCRAIDY_MSG_ID_1_MENU RCRAIDY_MSG_ID_1_MENU NUMBER(6,0) No
RCRAIDY_YEAR_1 RCRAIDY_YEAR_1 VARCHAR2(4) No
RCRAIDY_START_DATE_1 RCRAIDY_START_DATE_1 DATE No
RCRAIDY_END_DATE_1 RCRAIDY_END_DATE_1 DATE No
RCRAIDY_MSG_ID_2 RCRAIDY_MSG_ID_2 NUMBER(6,0) Yes
RCRAIDY_YEAR_2 RCRAIDY_YEAR_2 VARCHAR2(4) Yes
RCRAIDY_START_DATE_2 RCRAIDY_START_DATE_2 DATE Yes
RCRAIDY_END_DATE_2 RCRAIDY_END_DATE_2 DATE Yes
RCRAIDY_SPK_DLN_START_DATE RCRAIDY_SPK_DLN_START_DATE DATE Yes
RCRAIDY_SPK_DLN_END_DATE RCRAIDY_SPK_DLN_END_DATE DATE Yes
RCRAIDY_APP_DLN_DATE RCRAIDY_APP_DLN_DATE DATE Yes
RCRAIDY_CRED_DLN_DATE RCRAIDY_CRED_DLN_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RCRAIDY_AIDY_YEAR ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
PK_RCRAIDY Unique RCRAIDY_PRIORITY

Comments

Source Code Comments

Telephone Financial Aid Award Year Table defines the award years that are available for telephone financial aid callers.

Columns Comments for RCRAIDY_PRIORITY (1)

Source Code Comments

Priority Sequence Number of Award Year in listing of years for financial aid award years available.

Columns Comments for RCRAIDY_AIDY_YEAR (2)

Source Code Comments

Host Award Year code to be used for host access during telephone Financial Aid.

Columns Comments for RCRAIDY_MSG_ID_1 (3)

Source Code Comments

VRU Message ID for the beginning term of the award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_MSG_ID_1_MENU (4)

Source Code Comments

VRU Message ID for the beginning term of the award year to be spoken in menus during telephone Financial Aid.

Columns Comments for RCRAIDY_YEAR_1 (5)

Source Code Comments

Year to be spoken in association with Message ID 1.

Columns Comments for RCRAIDY_START_DATE_1 (6)

Source Code Comments

Beginning Date of the first telephone financial aid period.

Columns Comments for RCRAIDY_END_DATE_1 (7)

Source Code Comments

Ending Date of the first telephone financial aid period.

Columns Comments for RCRAIDY_MSG_ID_2 (8)

Source Code Comments

VRU Message ID for the ending term of the award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_YEAR_2 (9)

Source Code Comments

Year to be spoken in association with Message ID 2.

Columns Comments for RCRAIDY_START_DATE_2 (10)

Source Code Comments

Beginning Date of the second telephone financial aid period.

Columns Comments for RCRAIDY_END_DATE_2 (11)

Source Code Comments

Ending Date of the second telephone financial aid period.

Columns Comments for RCRAIDY_SPK_DLN_START_DATE (12)

Source Code Comments

Ending date from which Financial Aid deadline information will be available.

Columns Comments for RCRAIDY_APP_DLN_DATE (14)

Source Code Comments

Deadline for financial aid applications for award year to be spoken during telephone Financial Aid.

Columns Comments for RCRAIDY_CRED_DLN_DATE (15)

Source Code Comments

Deadline for receiving credentials for Financial Applications to be spoken during telephone Financial Aid.

Table RTVAPRD

Schema Name FAISMGR
Label RTVAPRD
Server name S4B70
Creation Date 09/29/2003 12:14:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVAPRD_CODE RTVAPRD_CODE VARCHAR2(6) No *
RTVAPRD_DESC RTVAPRD_DESC VARCHAR2(30) No
RTVAPRD_FULL_YR_PCT RTVAPRD_FULL_YR_PCT NUMBER(6,3) No
RTVAPRD_TFC_PCT RTVAPRD_TFC_PCT NUMBER(6,3) No
RTVAPRD_ACTIVITY_DATE RTVAPRD_ACTIVITY_DATE DATE No
RTVAPRD_PELL_FULL_YR_PCT RTVAPRD_PELL_FULL_YR_PCT NUMBER(6,3) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVAPRD Unique RTVAPRD_CODE
RTVAPRD_FULL_INDEX RTVAPRD_FULL_YR_PCT

Comments

Source Code Comments

Aid Period Validation Table

Columns Comments for RTVAPRD_CODE (1)

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 RTVAPRD_DESC (2)

Source Code Comments

AID PERIOD DESCRIPTION: This describes the aid period code and identifies what it represents.

Columns Comments for RTVAPRD_FULL_YR_PCT (3)

Source Code Comments

FULL YEAR PERCENT: The percentage of a full academic year that this aid period code represents.

Columns Comments for RTVAPRD_TFC_PCT (4)

Source Code Comments

TFC PERCENT: The total family contribution adjustment percentage to be used by this aid period code.

Columns Comments for RTVAPRD_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 RTVAPRD_PELL_FULL_YR_PCT (6)

Source Code Comments

FULL YEAR PERCENT FOR PELL: The maximum percentage of the full aid year/full time Pell award that the student is eligible to receive for the aid period based on their EFC. Maximum value is 100%.

Table RTVBGRP

Schema Name FAISMGR
Label RTVBGRP
Server name S4B70
Creation Date 09/29/2003 12:14:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVBGRP_CODE RTVBGRP_CODE VARCHAR2(6) No *
RTVBGRP_DESC RTVBGRP_DESC VARCHAR2(30) No
RTVBGRP_PRIORITY RTVBGRP_PRIORITY NUMBER(3,0) No
RTVBGRP_ACTIVITY_DATE RTVBGRP_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVBGRP Unique RTVBGRP_CODE

Comments

Source Code Comments

Budget Group Validation Table

Columns Comments for RTVBGRP_CODE (1)

Source Code Comments

BUDGET GROUP CODE: The code used to identify a group of students with common characteristics for budget creation.

Columns Comments for RTVBGRP_DESC (2)

Source Code Comments

BUDGET GROUP DESCRIPTION: Describes the budget group code and identifies what it represents.

Columns Comments for RTVBGRP_PRIORITY (3)

Source Code Comments

BUDGET GROUP PRIORITY: A sequence number to identify the order of group codes to be tested for assignment to a student; low numbers tested first.

Columns Comments for RTVBGRP_ACTIVITY_DATE (4)

Source Code Comments

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

Table RTVBTYP

Schema Name FAISMGR
Label RTVBTYP
Server name S4B70
Creation Date 09/29/2003 12:14:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVBTYP_CODE RTVBTYP_CODE VARCHAR2(4) No *
RTVBTYP_DESC RTVBTYP_DESC VARCHAR2(30) No
RTVBTYP_DEFAULT_TFC_IND RTVBTYP_DEFAULT_TFC_IND VARCHAR2(1) No
RTVBTYP_CAMP_IND RTVBTYP_CAMP_IND VARCHAR2(1) No
RTVBTYP_PELL_IND RTVBTYP_PELL_IND VARCHAR2(1) No
RTVBTYP_INST_IND RTVBTYP_INST_IND VARCHAR2(1) No
RTVBTYP_STAT_IND RTVBTYP_STAT_IND VARCHAR2(1) No
RTVBTYP_OTHR_IND RTVBTYP_OTHR_IND VARCHAR2(1) No
RTVBTYP_ACTIVITY_DATE RTVBTYP_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVBTYP Unique RTVBTYP_CODE

Comments

Source Code Comments

Budget Type Validation Table

Columns Comments for RTVBTYP_CODE (1)

Source Code Comments

BUDGET TYPE CODE: A code to identify a particular type of budget. EXAMPLES: Campus-Based, Pell

Columns Comments for RTVBTYP_DESC (2)

Source Code Comments

BUDGET TYPE DESCRIPTION: Describes the budget type code and identifies what it represents.

Columns Comments for RTVBTYP_DEFAULT_TFC_IND (3)

Source Code Comments

DEFAULT TFC INDICATOR: Identifies which total family contribution (either (C)ongressional or (I)nstitutional methodology) is normally used for this budget type.

Columns Comments for RTVBTYP_CAMP_IND (4)

Source Code Comments

CAMPUS-BASED TYPE INDICATOR: Indicates whether or not the budget type being defined is a campus-based budget type.

Columns Comments for RTVBTYP_PELL_IND (5)

Source Code Comments

PELL BUDGET TYPE INDICATOR: Indicates whether or not the budget type being defined is a Pell budget type.

Columns Comments for RTVBTYP_INST_IND (6)

Source Code Comments

INSTITUTIONAL BUDGET TYPE INDICATOR: Indicates whether or not the budget type being defined is an institutional type.

Columns Comments for RTVBTYP_STAT_IND (7)

Source Code Comments

STATE BUDGET TYPE INDICATOR: Indicates whether or not the budget type being defined is a state type.

Columns Comments for RTVBTYP_OTHR_IND (8)

Source Code Comments

OTHER BUDGET TYPE INDICATOR: Indicates whether or not the budget type being defined is some other type; not Campus-Based, Pell, State or Institutional.

Columns Comments for RTVBTYP_ACTIVITY_DATE (9)

Source Code Comments

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

Table RTVCOMP

Schema Name FAISMGR
Label RTVCOMP
Server name S4B70
Creation Date 09/29/2003 12:14:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVCOMP_CODE RTVCOMP_CODE VARCHAR2(4) No *
RTVCOMP_DESC RTVCOMP_DESC VARCHAR2(30) No
RTVCOMP_DEFAULT_IND RTVCOMP_DEFAULT_IND VARCHAR2(1) No
RTVCOMP_ACTIVITY_DATE RTVCOMP_ACTIVITY_DATE DATE No
RTVCOMP_PRINT_SEQ_NO RTVCOMP_PRINT_SEQ_NO NUMBER(3,0) Yes
RTVCOMP_ALTERNATE_PELL_IND RTVCOMP_ALTERNATE_PELL_IND VARCHAR2(1) Yes
RTVCOMP_PELL_LT_HALF_IND RTVCOMP_PELL_LT_HALF_IND VARCHAR2(1) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVCOMP Unique RTVCOMP_CODE
RTVCOMP_DEFAULT_INDEX RTVCOMP_DEFAULT_IND

Comments

Source Code Comments

Budget Component Validation Table

Columns Comments for RTVCOMP_CODE (1)

Source Code Comments

BUDGET COMPONENT CODE: The code used to identify a particular cost of attendance in the student's budget.

Columns Comments for RTVCOMP_DESC (2)

Source Code Comments

BUDGET COMPONENT DESCRIPTION: Describes the budget component code and identifies what it represents.

Columns Comments for RTVCOMP_DEFAULT_IND (3)

Source Code Comments

DEFAULT INDICATOR: Indicates whether or not to automatically include this budget component code in all budget group definitions.

Columns Comments for RTVCOMP_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 RTVCOMP_PRINT_SEQ_NO (5)

Source Code Comments

PRINT SEQUENCE NUMBER: Identifies the order in which this budget component is to be printed on reports and letters; low numbers printed first.

Columns Comments for RTVCOMP_ALTERNATE_PELL_IND (6)

Source Code Comments

ALTERNATE PELL INDICATOR FLAG: Used to determine whether or not to use the amount associated with this flag in the calculation for eligibility for the Alternate Pell Schedule. Default value is Null. Valid values Y means yes, Null means No.

Columns Comments for RTVCOMP_PELL_LT_HALF_IND (7)

Source Code Comments

PELL LESS THAN HALF-TIME IND: A value of Y in this column indicates that the budget component will be used in the calculation of less than half time Pell budgets.

Link between RBRACMP and RBBABUD

Caller : RBRACMP
Called : RBBABUD

Join Information

Objects list
forms-module-trigger : BANNER7_FORMS.REAOR00.CALC_PELL_BUDGET
forms-module-trigger : BANNER7_FORMS.RNASU00.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAOV00.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAPR00.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.REAOR01.CALC_PELL_BUDGET
forms-module-trigger : BANNER7_FORMS.RNANA00.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNASU01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAOV01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAPR01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.REAPV98.CALC_PELL_BUDGET
forms-module-trigger : BANNER7_FORMS.RNANA01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNASU02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAOV02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.RNAPR02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS.REAPV99.CALC_PELL_BUDGET
forms-module-trigger : BANNER7_FORMS.RNANA02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNASU01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNAOV01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNAPR01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNANA01.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNASU02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNAOV02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNAPR02.SET_STATUS_LINE
forms-module-trigger : BANNER7_FORMS_10G.RNANA02.SET_STATUS_LINE

Link List

Link Type Link Project
Join Link Between RBRACMP and RBBABUD FAISMGR

Link Between RBRACMP and RBBABUD

Caller : RBRACMP
Called : RBBABUD
Link Type : Join
Link : Link Between RBRACMP and RBBABUD

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRACMP RBRACMP_AIDY_CODE RBBABUD_AIDY_CODE RBBABUD (0,1)-(0,1)
RBRACMP RBRACMP_PIDM RBBABUD_PIDM RBBABUD (0,1)-(0,1)
RBRACMP RBRACMP_BTYP_CODE RBBABUD_BTYP_CODE RBBABUD (0,1)-(0,1)

Comments

Link between RBRCOMP and RBRMIXD

Caller : RBRCOMP
Called : RBRMIXD

Join Information

Objects list
forms-module-trigger : BANNER7_FORMS.RBAABUD.COPY_DEFAULTS
forms-module-trigger : BANNER7_FORMS.RBAABUD.GET_RBRCOMP_AMT
forms-module-trigger : BANNER7_FORMS.ROARMAN.COPY_DEFAULTS
forms-module-trigger : BANNER7_FORMS.ROARMAN.GET_RBRCOMP_AMT
forms-module-trigger : BANNER7_FORMS_10G.RBAABUD.COPY_DEFAULTS
forms-module-trigger : BANNER7_FORMS_10G.RBAABUD.GET_RBRCOMP_AMT

Link List

Link Type Link Project
Join Link Between RBRCOMP and RBRMIXD FAISMGR

Link Between RBRCOMP and RBRMIXD

Caller : RBRCOMP
Called : RBRMIXD
Link Type : Join
Link : Link Between RBRCOMP and RBRMIXD

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRCOMP RBRCOMP_AIDY_CODE RBRMIXD_AIDY_CODE RBRMIXD (0,1)-(0,1)
RBRCOMP RBRCOMP_BGRP_CODE RBRMIXD_BGRP_CODE RBRMIXD (0,1)-(0,1)

Comments

Link between RBRACMP and RTVCOMP

Caller : RBRACMP
Called : RTVCOMP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRACMP and RTVCOMP FAISMGR

Link Foreign Key Between RBRACMP and RTVCOMP

Caller : RBRACMP
Called : RTVCOMP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRACMP and RTVCOMP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRACMP RBRACMP_COMP_CODE RTVCOMP_CODE RTVCOMP (1,1)-(0,n)

Comments

Link between RBRACMP and RTVBTYP

Caller : RBRACMP
Called : RTVBTYP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRACMP and RTVBTYP FAISMGR

Link Foreign Key Between RBRACMP and RTVBTYP

Caller : RBRACMP
Called : RTVBTYP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRACMP and RTVBTYP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRACMP RBRACMP_BTYP_CODE RTVBTYP_CODE RTVBTYP (1,1)-(0,n)

Comments

Link between RBRGTYP and RTVBTYP

Caller : RBRGTYP
Called : RTVBTYP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRGTYP and RTVBTYP FAISMGR

Link Foreign Key Between RBRGTYP and RTVBTYP

Caller : RBRGTYP
Called : RTVBTYP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRGTYP and RTVBTYP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRGTYP RBRGTYP_BTYP_CODE RTVBTYP_CODE RTVBTYP (1,1)-(0,n)

Comments

Link between RBBABUD and RTVBTYP

Caller : RBBABUD
Called : RTVBTYP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBBABUD and RTVBTYP FAISMGR

Link Foreign Key Between RBBABUD and RTVBTYP

Caller : RBBABUD
Called : RTVBTYP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBBABUD and RTVBTYP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBBABUD RBBABUD_BTYP_CODE RTVBTYP_CODE RTVBTYP (1,1)-(0,n)

Comments

Link between RBRCOMP and RTVAPRD

Caller : RBRCOMP
Called : RTVAPRD

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRCOMP and RTVAPRD FAISMGR

Link Foreign Key Between RBRCOMP and RTVAPRD

Caller : RBRCOMP
Called : RTVAPRD
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRCOMP and RTVAPRD

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRCOMP RBRCOMP_APRD_CODE RTVAPRD_CODE RTVAPRD (1,1)-(0,n)

Comments

Link between RBRCOMP and RTVBTYP

Caller : RBRCOMP
Called : RTVBTYP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRCOMP and RTVBTYP FAISMGR

Link Foreign Key Between RBRCOMP and RTVBTYP

Caller : RBRCOMP
Called : RTVBTYP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRCOMP and RTVBTYP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRCOMP RBRCOMP_BTYP_CODE RTVBTYP_CODE RTVBTYP (0,1)-(0,n)

Comments

Link between RBRCOMP and RTVCOMP

Caller : RBRCOMP
Called : RTVCOMP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRCOMP and RTVCOMP FAISMGR

Link Foreign Key Between RBRCOMP and RTVCOMP

Caller : RBRCOMP
Called : RTVCOMP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRCOMP and RTVCOMP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRCOMP RBRCOMP_COMP_CODE RTVCOMP_CODE RTVCOMP (1,1)-(0,n)

Comments

Link between RBRCOMP and RTVBGRP

Caller : RBRCOMP
Called : RTVBGRP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRCOMP and RTVBGRP FAISMGR

Link Foreign Key Between RBRCOMP and RTVBGRP

Caller : RBRCOMP
Called : RTVBGRP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRCOMP and RTVBGRP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRCOMP RBRCOMP_BGRP_CODE RTVBGRP_CODE RTVBGRP (0,1)-(0,n)

Comments

Link between RBRGMSG and RTVBGRP

Caller : RBRGMSG
Called : RTVBGRP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRGMSG and RTVBGRP FAISMGR

Link Foreign Key Between RBRGMSG and RTVBGRP

Caller : RBRGMSG
Called : RTVBGRP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRGMSG and RTVBGRP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRGMSG RBRGMSG_BGRP_CODE RTVBGRP_CODE RTVBGRP (1,1)-(0,n)

Comments

Link between RBRGTYP and RTVBGRP

Caller : RBRGTYP
Called : RTVBGRP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRGTYP and RTVBGRP FAISMGR

Link Foreign Key Between RBRGTYP and RTVBGRP

Caller : RBRGTYP
Called : RTVBGRP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRGTYP and RTVBGRP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRGTYP RBRGTYP_BGRP_CODE RTVBGRP_CODE RTVBGRP (1,1)-(0,n)

Comments

Link between RBRMIXD and RTVBGRP

Caller : RBRMIXD
Called : RTVBGRP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between RBRMIXD and RTVBGRP FAISMGR

Link Foreign Key Between RBRMIXD and RTVBGRP

Caller : RBRMIXD
Called : RTVBGRP
Link Type : Refer( No Action )
Link : Link Foreign Key Between RBRMIXD and RTVBGRP

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
RBRMIXD RBRMIXD_BGRP_CODE RTVBGRP_CODE RTVBGRP (1,1)-(0,n)

Comments