RBBABUD RBRACMP RBRCOMP RBRGMSG RBRGTYP RBRMIXD RTVAPRD RTVBGRP RTVBTYP RTVCOMP

Model Budgeting


Model Label : Banner Financial Aid Budgeting Module

List of Objects

Object Name Object Type Layer Name
RBBABUD SQL Table Default
RBRACMP SQL Table Default
RBRCOMP SQL Table Default
RBRGMSG SQL Table Default
RBRGTYP SQL Table Default
RBRMIXD SQL Table Default
RTVAPRD SQL Table Default
RTVBGRP SQL Table Default
RTVBTYP SQL Table Default
RTVCOMP SQL Table Default

Model View

Table RBBABUD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

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
RBBABUD_BTYP_CODE RBRACMP_BTYP_CODE RBRACMP

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RORSTAT SQL Table S10B80.FAISMGR Join
RBVBUD2 SQL View S10B80.BANINST1 Use (select)
RCVAPL2 SQL View S10B80.BANINST1 Use (select)
F_GET_RBBABUD_ROWID SQL Function S10B80.BANINST1 Use (select)
F_SEM_CSED_FNC SQL Function S10B80.BANINST1 Use (select)
P_GET_UNMET_NEED Oracle Package Procedure S10B80.BANINST1.RPKAWRD Rely On
P_VALIDATE_AWARD Oracle Package Procedure S10B80.BANINST1.RPK_AWARD_VALIDATION Rely On
F_CALC_NEED_DATA Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_NON_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
F_CALC_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
F_FIND_EFC_IND Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_FIND_EFC_IND Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
RBBABUD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RBBABUD SQL Index S10B80.FAISMGR Rely On
RBRACMP SQL Table S10B80.FAISMGR Join
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RTVBTYP SQL Table S10B80.FAISMGR Refer (no action)
RT_RBBABUD_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBBABUD_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBBABUD

Object Dates

Creation Date Analysis Date
04/02/2008 10:31:23:000 04/02/2008 10:35:23:000

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

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBBABUD SQL Table S10B80.FAISMGR Join
RBVBUD1 SQL View S10B80.BANINST1 Use (select)
RBVBUD2 SQL View S10B80.BANINST1 Join
RCVAPL1 SQL View S10B80.BANINST1 Use (select)
F_CALC_TOTAL_BUDGET SQL Function S10B80.BANINST1 Use (select)
F_GET_RBRACMP_ROWID SQL Function S10B80.BANINST1 Use (select)
F_MORE_BUDGET_COMPONENTS SQL Function S10B80.BANINST1 Use (select)
F_SEM_CSED_FNC SQL Function S10B80.BANINST1 Use (select)
BTYP_REC Oracle Package Type S10B80.BANINST1.ROKLIBS Rely On
BTYP_TYPE Oracle Package Type S10B80.BANINST1.BWRKBUDG Rely On
GETBUDGTYPEC Oracle Package Cursor S10B80.BANINST1.ROKLIBS Use (select)
GETBUDGTYPEC Oracle Package Cursor S10B80.BANINST1.BWRKBUDG Use (select)
GETBUDGTYPEPELLC Oracle Package Cursor S10B80.BANINST1.BWRKBUDG Use (select)
F_CALC_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_GROSS_NEED Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_IM_GROSS_NEED Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_IM_UNMET_NEED Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_NEED_DATA Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_NON_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_NON_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
F_CALC_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Rely On
F_CALC_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
RBRACMP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RBRACMP SQL Index S10B80.FAISMGR Rely On
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RTVBTYP SQL Table S10B80.FAISMGR Refer (no action)
RTVCOMP SQL Table S10B80.FAISMGR Refer (no action)
RT_RBRACMP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBRACMP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBRACMP

Object Dates

Creation Date Analysis Date
04/02/2008 10:28:20:000 04/02/2008 10:35:21:000

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

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RBRCOMP_AIDY_CODE   VARCHAR2(4) No   *
RBRCOMP_APRD_CODE   VARCHAR2(6) No   *
RBRCOMP_COMP_CODE   VARCHAR2(4) No   *
RBRCOMP_AMT   NUMBER(11,2) No    
RBRCOMP_ACTIVITY_DATE   DATE Yes    
RBRCOMP_BTYP_CODE   VARCHAR2(4) Yes   *
RBRCOMP_BGRP_CODE   VARCHAR2(6) Yes   *
RBRCOMP_USER_ID   VARCHAR2(30) 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

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBVCOMP SQL View S10B80.BANINST1 Use (select)
RBRCOMP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
RBRCOMP_KEY_INDEX SQL Index S10B80.FAISMGR Rely On
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RTVAPRD SQL Table S10B80.FAISMGR Refer (no action)
RTVBGRP SQL Table S10B80.FAISMGR Refer (no action)
RTVBTYP SQL Table S10B80.FAISMGR Refer (no action)
RTVCOMP SQL Table S10B80.FAISMGR Refer (no action)
RT_RBRCOMP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBRCOMP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBRCOMP

Object Dates

Creation Date Analysis Date
04/02/2008 10:31:29:000 04/02/2008 10:35:23:000

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.

Columns Comments for RBRCOMP_USER_ID (# 8)

Source Code Comments

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

Table RBRGMSG

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RBRGMSG SQL Index S10B80.FAISMGR Rely On
GTVLETR SQL Table S10B80.GENERAL Refer (no action)
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RTVBGRP SQL Table S10B80.FAISMGR Refer (no action)
RTVMESG SQL Table S10B80.FAISMGR Refer (no action)
RT_RBRGMSG_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBRGMSG_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBRGMSG

Object Dates

Creation Date Analysis Date
04/02/2008 10:25:52:000 04/02/2008 10:35:19:000

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.

Columns Comments for RBRGMSG_USER_ID (# 6)

Source Code Comments

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

Table RBRGTYP

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RBRGTYP SQL Index S10B80.FAISMGR Rely On
RTVBGRP SQL Table S10B80.FAISMGR Refer (no action)
RTVBTYP SQL Table S10B80.FAISMGR Refer (no action)
RT_RBRGTYP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBRGTYP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBRGTYP

Object Dates

Creation Date Analysis Date
04/02/2008 10:25:39:000 04/02/2008 10:35:18:000

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

Columns Comments for RBRGTYP_USER_ID (# 5)

Source Code Comments

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

Table RBRMIXD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_RBRMIXD_DATA SQL Function S10B80.BANINST1 Use (select)
RBRMIXD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RBRMIXD SQL Index S10B80.FAISMGR Rely On
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RTVBGRP SQL Table S10B80.FAISMGR Refer (no action)
RT_RBRMIXD_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RBRMIXD_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RBRMIXD

Object Dates

Creation Date Analysis Date
04/02/2008 10:32:22:000 04/02/2008 10:35:24:000

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 RTVAPRD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVAPRD_CODE   VARCHAR2(6) No *  
RTVAPRD_DESC   VARCHAR2(30) No    
RTVAPRD_FULL_YR_PCT   NUMBER(6,3) No    
RTVAPRD_TFC_PCT   NUMBER(6,3) No    
RTVAPRD_ACTIVITY_DATE   DATE No    
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBRCOMP SQL Table S10B80.FAISMGR Refer (no action)
RFRASCH SQL Table S10B80.FAISMGR Refer (no action)
RFRDEFA SQL Table S10B80.FAISMGR Refer (no action)
RFRDEFD SQL Table S10B80.FAISMGR Refer (no action)
RFRDSCH SQL Table S10B80.FAISMGR Refer (no action)
RLRSTAT SQL Table S10B80.FAISMGR Refer (no action)
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RORSTAT SQL Table S10B80.FAISMGR Refer (no action)
RORTPRD SQL Table S10B80.FAISMGR Refer (no action)
RPRLPAP SQL Table S10B80.FAISMGR Refer (no action)
F_FINAID_GET_DESC SQL Function S10B80.BANINST1 Use (select)
RTVAPRDC Oracle Package Cursor S10B80.BANINST1.RTKAPRD Use (select)Rely On
RTVAPRD_C Oracle Package Cursor S10B80.BANINST1.RB_RTVAPRD Rely On
RTVAPRD_C Oracle Package Cursor S10B80.BANINST1.RB_RTVAPRD Use (select)Rely On
P_CREATE_AID_PERIOD Oracle Package Procedure S10B80.BANINST1.RPK_DEBS_DISPLAYS Rely On
P_CREATE_AID_PERIOD_2 Oracle Package Procedure S10B80.BANINST1.RPK_DEBS_DISPLAYS Rely On
P_CREATE_AID_PERIOD_3 Oracle Package Procedure S10B80.BANINST1.RPK_DEBS_DISPLAYS Rely On
P_DISPBUDG Oracle Package Procedure S10B80.BANINST1.BWRKBUDG Rely On
P_DISPSUMM Oracle Package Procedure S10B80.BANINST1.BWRKSUMM Rely On
P_INSERT_RTVAPRD Oracle Package Procedure S10B80.BANINST1.RPK_DEBS_DISPLAYS Rely On
P_INSERT_RTVAPRD Oracle Package Procedure S10B80.BANINST1.RPK_DEBS_DISPLAYS Use (Insert)
P_PA_RTVAPRD_EQUAL Oracle Package Procedure S10B80.BANINST1.ROKPVAL Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_TEMP_APPL_STATUS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_REQUIREMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_APPLICANT_STATUS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_PGRP_CATEGORY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_SIM_APPL_STATUS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_PELL_ORIGINATIONS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_AWARD_SCHEDULE Use (Insert,select)
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.RB_RTVAPRD Rely On
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.RB_RTVAPRD Rely On
RTVAPRD Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RTVAPRD SQL Index S10B80.FAISMGR Rely On
RTVAPRD_FULL_INDEX SQL Index S10B80.FAISMGR Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVAPRD

Object Dates

Creation Date Analysis Date
04/02/2008 10:29:47:000 04/02/2008 10:35:22:000

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

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVBGRP Unique RTVBGRP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBRCOMP SQL Table S10B80.FAISMGR Refer (no action)
RBRGMSG SQL Table S10B80.FAISMGR Refer (no action)
RBRGTYP SQL Table S10B80.FAISMGR Refer (no action)
RBRMIXD SQL Table S10B80.FAISMGR Refer (no action)
RLRSTAT SQL Table S10B80.FAISMGR Refer (no action)
ROBINST SQL Table S10B80.FAISMGR Refer (no action)
RORSTAT SQL Table S10B80.FAISMGR Refer (no action)
F_FINAID_GET_DESC SQL Function S10B80.BANINST1 Use (select)
RTVBGRPC Oracle Package Cursor S10B80.BANINST1.RTKBGRP Use (select)Rely On
RTVBGRP_C Oracle Package Cursor S10B80.BANINST1.RB_RTVBGRP Rely On
RTVBGRP_C Oracle Package Cursor S10B80.BANINST1.RB_RTVBGRP Use (select)Rely On
P_PA_RTVBGRP_EQUAL Oracle Package Procedure S10B80.BANINST1.ROKPVAL Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_TEMP_APPL_STATUS Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_APPLICANT_STATUS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_PGRP_CATEGORY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_RB_SIM_APPL_STATUS Use (select)
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.RB_RTVBGRP Rely On
F_CODE_IS_ACTIVE Oracle Package Function S10B80.BANINST1.RB_RTVBGRP Rely On
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.RB_RTVBGRP Rely On
RTVBGRP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RTVBGRP SQL Index S10B80.FAISMGR Rely On
RT_RTVBGRP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RTVBGRP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVBGRP

Object Dates

Creation Date Analysis Date
04/02/2008 10:31:53:000 04/02/2008 10:35:24:000

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: The priority order in which budget group codes are assigned to students; lowest priority numbers are assigned 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

Columns Comments for RTVBGRP_USER_ID (# 5)

Source Code Comments

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

Columns Comments for RTVBGRP_ACTIVE_IND (# 6)

Source Code Comments

ACTIVE INDICATOR: Indicates whether the budgeting group code is active.

Table RTVBTYP

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVBTYP Unique RTVBTYP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBBABUD SQL Table S10B80.FAISMGR Refer (no action)
RBRACMP SQL Table S10B80.FAISMGR Refer (no action)
RBRCOMP SQL Table S10B80.FAISMGR Refer (no action)
RBRGTYP SQL Table S10B80.FAISMGR Refer (no action)
RBVBUD2 SQL View S10B80.BANINST1 Use (select)
F_FINAID_GET_DESC SQL Function S10B80.BANINST1 Use (select)
F_GET_RBBABUD_ROWID SQL Function S10B80.BANINST1 Use (select)
F_SEM_CSED_FNC SQL Function S10B80.BANINST1 Use (select)
BTYP_REC Oracle Package Type S10B80.BANINST1.ROKLIBS Rely On
GETBUDGTYPEC Oracle Package Cursor S10B80.BANINST1.ROKLIBS Use (select)
GETBUDGTYPEC Oracle Package Cursor S10B80.BANINST1.BWRKBUDG Use (select)
GETBUDGTYPEPELLC Oracle Package Cursor S10B80.BANINST1.BWRKBUDG Use (select)
RTVBTYPC Oracle Package Cursor S10B80.BANINST1.RTKBTYP Use (select)Rely On
P_DISPBUDG Oracle Package Procedure S10B80.BANINST1.BWRKBUDG Rely On
P_DISPPAYSCHED Oracle Package Procedure S10B80.BANINST1.BWRKPAYS Rely On
P_DISPSUMM Oracle Package Procedure S10B80.BANINST1.BWRKSUMM Rely On
P_PA_RTVBTYP_EQUAL Oracle Package Procedure S10B80.BANINST1.ROKPVAL Use (select)
F_CALC_NON_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
F_CALC_PELL_BUDGET_AMT Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
F_FIND_EFC_IND Oracle Package Function S10B80.BANINST1.RNKNEED Use (select)
RTVBTYP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RTVBTYP SQL Index S10B80.FAISMGR Rely On
RT_RTVBTYP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RTVBTYP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVBTYP

Object Dates

Creation Date Analysis Date
04/02/2008 10:29:26:000 04/02/2008 10:35:22:000

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

Columns Comments for RTVBTYP_USER_ID (# 10)

Source Code Comments

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

Table RTVCOMP

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVCOMP_CODE   VARCHAR2(4) No *  
RTVCOMP_DESC   VARCHAR2(30) No    
RTVCOMP_DEFAULT_IND   VARCHAR2(1) No    
RTVCOMP_ACTIVITY_DATE   DATE Yes    
RTVCOMP_PRINT_SEQ_NO   NUMBER(3,0) Yes    
RTVCOMP_ALTERNATE_PELL_IND   VARCHAR2(1) Yes    
RTVCOMP_PELL_LT_HALF_IND   VARCHAR2(1) Yes    
RTVCOMP_USER_ID   VARCHAR2(30) 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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
RBRACMP SQL Table S10B80.FAISMGR Refer (no action)
RBRCOMP SQL Table S10B80.FAISMGR Refer (no action)
RFRBCMP SQL Table S10B80.FAISMGR Refer (no action)
F_FINAID_GET_DESC SQL Function S10B80.BANINST1 Use (select)
RTVCOMPC Oracle Package Cursor S10B80.BANINST1.RTKCOMP Use (select)Rely On
RTVCOMP Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RTVCOMP SQL Index S10B80.FAISMGR Rely On
RTVCOMP_DEFAULT_INDEX SQL Index S10B80.FAISMGR Rely On
RT_RTVCOMP_LOG_INSUPDDTL SQL Trigger S10B80.FAISMGR Fire (Insert,update,delete,after,each row)
RT_RTVCOMP_USERACTIVIT_INSUPD SQL Trigger S10B80.FAISMGR Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVCOMP

Object Dates

Creation Date Analysis Date
04/02/2008 10:26:50:000 04/02/2008 10:35:20:000

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.

Columns Comments for RTVCOMP_USER_ID (# 8)

Source Code Comments

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

Link between RBRACMP and RTVCOMP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRACMP and RTVCOMP (FK1_RBRACMP_INV_RTVCOMP_CODE) FAISMGR

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)

Link between RBRACMP and RTVBTYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRACMP and RTVBTYP (FK1_RBRACMP_INV_RTVBTYP_CODE) FAISMGR

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)

Link between RBRGTYP and RTVBTYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRGTYP and RTVBTYP (FK1_RBRGTYP_INV_RTVBTYP_CODE) FAISMGR

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)

Link between RBBABUD and RTVBTYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBBABUD and RTVBTYP (FK1_RBBABUD_INV_RTVBTYP_CODE) FAISMGR

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)

Link between RBRCOMP and RTVAPRD


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRCOMP and RTVAPRD (FK1_RBRCOMP_INV_RTVAPRD_CODE) FAISMGR

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)

Link between RBRCOMP and RTVBTYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRCOMP and RTVBTYP (FK1_RBRCOMP_INV_RTVBTYP_CODE) FAISMGR

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)

Link between RBRCOMP and RTVCOMP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRCOMP and RTVCOMP (FK1_RBRCOMP_INV_RTVCOMP_CODE) FAISMGR

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)

Link between RBRCOMP and RTVBGRP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRCOMP and RTVBGRP (FK1_RBRCOMP_INV_RTVBGRP_CODE) FAISMGR

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)

Link between RBRGMSG and RTVBGRP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRGMSG and RTVBGRP (FK1_RBRGMSG_INV_RTVBGRP_CODE) FAISMGR

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)

Link between RBRGTYP and RTVBGRP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRGTYP and RTVBGRP (FK1_RBRGTYP_INV_RTVBGRP_CODE) FAISMGR

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)

Link between RBBABUD and RBRACMP


Join Information

Objects list
schema-function : S10B80.BANINST1.F_SEM_CSED_FNC
scope-function : S10B80.BANINST1.RNKNEED.F_CALC_PELL_BUDGET_AMT
scope-function : S10B80.BANINST1.RNKNEED.F_CALC_NON_PELL_BUDGET_AMT

Link List

Link Type Link Project
Join Link Between RBBABUD and RBRACMP FAISMGR

List of Real links

Link type Between And
Join RBBABUD RBRACMP

Link between RBRMIXD and RTVBGRP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between RBRMIXD and RTVBGRP (FK1_RBRMIXD_INV_RTVBGRP_CODE) FAISMGR

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)