Model Student Employment

Model Label : Banner Financial Aid Student Employment Module

List of Objects

Object Name	Object Type	Layer Name
GTVLETR	SQL Table	Default
RFRBASE	SQL Table	Default
RJBJOBT	SQL Table	Default
RJBPLBD	SQL Table	Default
RJBSEDR	SQL Table	Default
RJRPAYL	SQL Table	Default
RJRPLRL	SQL Table	Default
RJRSEAR	SQL Table	Default
RJRSERF	SQL Table	Default
RJRSEWH	SQL Table	Default
RORENRL	SQL Table	Default
RORSAPR	SQL Table	Default
RORSTRF	SQL Table	Default
RPRATRM	SQL Table	Default
RTVAUST	SQL Table	Default
RTVRFST	SQL Table	Default
RTVSAPR	SQL Table	Default
STVNATN	SQL Table	Default
STVSTAT	SQL Table	Default

Model View

Table GTVLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GTVLETR_CODE	VARCHAR2(15)	No	*
GTVLETR_ACTIVITY_DATE	DATE	No
GTVLETR_DUPL_IND	VARCHAR2(1)	No
GTVLETR_DESC	VARCHAR2(30)	Yes
GTVLETR_PRINT_COMMAND	VARCHAR2(10)	Yes
GTVLETR_LETR_CODE_ALT	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_GTVLETR	Unique	GTVLETR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVLETR	Oracle Synonym	S10B80.FAISMGR	Rely On
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AABMSHP	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARRLET	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKPC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRALET	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
GEBFUNC	SQL Table	S10B80.GENERAL	Refer (no action)
GERFCOR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCALC	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCOLR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRORDR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GURMAIL	SQL Table	S10B80.GENERAL	Refer (no action)
RBRGMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRMESG	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSTRF	SQL Table	S10B80.FAISMGR	Refer (no action)
RRRTMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWALT	SQL Table	S10B80.SATURN	Refer (no action)
SFREPRT	SQL Table	S10B80.SATURN	Refer (no action)
SHBGADR	SQL Table	S10B80.SATURN	Refer (no action)
SHRTPRT	SQL Table	S10B80.SATURN	Refer (no action)
SOBMATL	SQL Table	S10B80.SATURN	Refer (no action)
SORELTL	SQL Table	S10B80.SATURN	Refer (no action)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_DUPS_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
GTVLETRC	Oracle Package Cursor	S10B80.BANINST1.GTKLETR	Use (select)Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_PA_GTVLETR_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_REORDERING	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_DISPLAYRULE	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GTVLETR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GTVLETR	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_GTVLETR	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVLETR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:09:000	04/02/2008 21:17:50:000

Source Code Comments

Letter Process Letter Validation Table

Columns Comments for GTVLETR_CODE (# 1)

Source Code Comments

This field identifies the letter code referenced on the Recruiting Material Control Form (SRAMATL) and the Letter Process Form (GUALETR).

Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for GTVLETR_DUPL_IND (# 3)

Source Code Comments

Y = Duplicates may be printed for this letter code, N = no dups.

Columns Comments for GTVLETR_DESC (# 4)

Source Code Comments

This field specifies the recruiting letter/material associated with the letter code.

Columns Comments for GTVLETR_PRINT_COMMAND (# 5)

Source Code Comments

This field identifies alternate print command code (e.g. PL - Print Landscape) for associated letter/material.

Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)

Source Code Comments

Alternate Letter code for letter codes that do not allow duplicates.

Table RFRBASE

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RFRBASE_FUND_CODE	VARCHAR2(6)	No	*	*
RFRBASE_FUND_TITLE	VARCHAR2(30)	No
RFRBASE_FSRC_CODE	VARCHAR2(4)	No		*
RFRBASE_FTYP_CODE	VARCHAR2(4)	No		*
RFRBASE_ACTIVITY_DATE	DATE	No
RFRBASE_DETAIL_CODE	VARCHAR2(4)	Yes		*
RFRBASE_FED_FUND_ID	VARCHAR2(4)	Yes		*
RFRBASE_PRINT_SEQ_NO	NUMBER(6,0)	Yes
RFRBASE_VR_MSG_NO	NUMBER(6,0)	Yes
RFRBASE_ACTIVE_IND	VARCHAR2(1)	No
RFRBASE_XREF_VALUE	VARCHAR2(10)	Yes
RFRBASE_FUND_TITLE_LONG	VARCHAR2(200)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRBASE_FSRC_CODE	RTVFSRC_CODE	RTVFSRC
RFRBASE_FTYP_CODE	RTVFTYP_CODE	RTVFTYP
RFRBASE_FUND_CODE	RJRSEAR_FUND_CODE	RJRSEAR
RFRBASE_DETAIL_CODE	TBRMEMO_DETAIL_CODE	TBRMEMO
RFRBASE_DETAIL_CODE	TBRACCD_DETAIL_CODE	TBRACCD
RFRBASE_FED_FUND_ID	RFRFFID_FED_FUND_ID	RFRFFID
RFRBASE_FUND_CODE	RPTAWRD_FUND_CODE	RPTAWRD

Index

Index Name	Index Type	Column Name
PK_RFRBASE	Unique	RFRBASE_FUND_CODE
RFRBASE_DETAIL_INDEX		RFRBASE_DETAIL_CODE
RFRBASE_FED_INDEX		RFRBASE_FED_FUND_ID
RFRBASE_FED_INDEX		RFRBASE_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RFRASPC	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRFCAT	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRPROM	SQL Table	S10B80.FAISMGR	Join
RPRADSB	SQL Table	S10B80.FAISMGR	Join
RPRATRM	SQL Table	S10B80.FAISMGR	Join
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
RPRBAKO	SQL Table	S10B80.FAISMGR	Join
RPRLAPP	SQL Table	S10B80.FAISMGR	Join
RPRTIIV	SQL Table	S10B80.FAISMGR	Join
AR_TRACKING_REQUIREMENTS	SQL View	S10B80.BANINST1	Join
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
F_FA_AMT_TERM_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_FA_AMT_YEAR_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_FINAID_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_INST_AID_FNC	SQL Function	S10B80.BANINST1	Use (select)
ADDLREQ_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTRKR	Rely On
AWARD_DTL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKACPT	Rely On
AWARD_DTL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKRHST	Rely On
AWARD_MSG_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKRHST	Rely On
FUND_CODE_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
LOAN_DETAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKLHST	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKPAYS	Rely On
RRRAREQ_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTRKR	Rely On
RRRTMSG_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKTMSG	Rely On
WS_DATA_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
BASE_VRNO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
PROM_VRNO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RFRBASE_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
RFRBASE_VR_MSG_NO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
FUND_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
CALC_RPRAWRD_OFFER_AMT	Oracle Package Cursor	S10B80.BANINST1.BWRKSUMM	Use (select)
RPRTIIVC	Oracle Package Cursor	S10B80.BANINST1.BWRKTIVW	Use (select)
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_ACG_SMART_EXCEEDS_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_ANN_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_AWARD_EXCEEDS_CUM_LIMIT	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_MAX	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_AWARD_EXCEEDS_NEED	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
P_BUILDROTWFAE	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_FUND_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_NSLDS_CUM_TEST_AS_IND	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
P_SAR_DATE_PROCESSING	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (select)
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
RFRBASE_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_ACCEPTED_ACG_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_ACCEPTED_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_ACCEPTED_SMART_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_AMOUNT_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_DETAIL_CODE_ACTIVE	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_FUND_CODE_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Use (select)
F_FUND_ID_IS_SMRT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Use (select)
F_GET_FEDERAL_RULES	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_RULES	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_RULES	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_GET_FUND_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_GET_PELL_FUND	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_PELL_OFRD_CNT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_RFRFFID_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_GET_RFRFFID_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_GRANT_YEAR_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_HAS_PELL	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_IS_PELL	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_IS_PELL	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_NON_OVERRIDE_NEED_EXISTS	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_NSLDS_AGG_LIMITS_EXCEEDED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_CALC_BANNER_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
F_NSLDS_CALC_PRIOR_COLL_PAID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_NSLDS_INCLUDES_AID_YEAR	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PACKAGE_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_PACKAGE_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_PELL_EFC_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PELL_EFC_IS_DETERMINED	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_PELL_GRAD	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_PLUS_AWARDED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI07	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI08	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI09	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI04	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI05	Use (select)
F_SELECT_PELL_DISB_SUM	Oracle Package Function	S10B80.BANINST1.REKCI06	Use (select)
F_TITLE_IV_EFC_ELIGIBLE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_DEGREE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FEDERAL_FUND	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_LOAD	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_OFFICIAL	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_PELL_AUTHORIZATION	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_PELL_DISBURSEMENT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_REDUCE_NEED	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Use (select)
C_GET_FUND_CODE	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
GETACTIVEAIDYEARC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETAWDDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKRHST	Use (select)
GETAWDDTL_C	Oracle Package Cursor	S10B80.BANINST1.BWRKACPT	Use (select)
GETAWDMSGC	Oracle Package Cursor	S10B80.BANINST1.BWRKRHST	Use (select)
GETLOANDTLC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETPAYITEMC	Oracle Package Cursor	S10B80.BANINST1.BWRKPAYS	Use (select)
GETPROMREQC	Oracle Package Cursor	S10B80.BANINST1.BWRKTRKR	Use (select)
GETTRKMSGC	Oracle Package Cursor	S10B80.BANINST1.BWRKTMSG	Use (select)
GETTRKREQC	Oracle Package Cursor	S10B80.BANINST1.BWRKTRKR	Use (select)
RFRBASE_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RFKSELS	Rely On
RFRBASE_ROW_BY_CODE_C	Oracle Package Cursor	S10B80.BANINST1.RFKSELS	Use (select)Rely On
P_CALCULATE_LOAD	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_CALC_PELL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_CHK_ACTIVE_FUND_CODE	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_CREATE_FUND	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (Insert)
P_GET_PELL_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_RFRBASE_ROW	Oracle Package Procedure	S10B80.BANINST1.RFKFUNC	Rely On
P_GET_RPRATRM_RTVAWST_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_GET_RPRAWRD_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_GET_RPRLAPP_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_OPEN_AWARDS_CV	Oracle Package Procedure	S10B80.BANINST1.RPKPCKG	Use (select)
P_PA_RFRBASE_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_RFRBASE_EQUAL_2	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_RFRBASE_EQUAL_N_NOT_PELL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PROCESS_ONLINE_AWARDS	Oracle Package Procedure	S10B80.BANINST1.RPKAFRM	Use (select)
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_RFRBASE_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKRRTS	Rely On
P_RFRBASE_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKRRTS	Rely On
P_SELECT_RFRBASE_FUND	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Rely On
P_SELECT_RFRBASE_FUND	Oracle Package Procedure	S10B80.BANINST1.ROKPELL	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Use (select)Rely On
P_VR_BUILD_AWARDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRAWD	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
P_VR_GET_LOAN_INFO	Oracle Package Procedure	S10B80.BANINST1.VRRKRLAP	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_DISBURSEMENT	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_DL_REFUND	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_FUND_CATEGORY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_SCHEDULE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
F_ALLOWWEBUPDATE	Oracle Package Function	S10B80.BANINST1.BWRKACPT	Use (select)
F_CALC_ALGORITHMIC_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_CALC_PELL_AWARD	Oracle Package Function	S10B80.BANINST1.RNKNEED	Use (select)
F_CHECK_TITLEIV_LOANS	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_CHECK_WORKSTUDY	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_COUNT_RFRBASE_FUND_CODES	Oracle Package Function	S10B80.BANINST1.ROKPELL	Rely On
F_COUNT_RFRBASE_FUND_CODES	Oracle Package Function	S10B80.BANINST1.ROKPELL	Use (select)
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Use (select)
F_FUND_IS_PELL	Oracle Package Function	S10B80.BANINST1.RPKAWRD	Use (select)
F_GET_AMT_DUE	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_AWARDS_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_GET_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Use (select)
F_GET_FSRC_EXISTING_AMT	Oracle Package Function	S10B80.BANINST1.RPKPCKG	Use (select)
F_GET_GRANT_TYPE	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_MEMO_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Use (select)
F_GET_MIN_TERM	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_NOPAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_PAID_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Use (select)
F_GET_PRIOR_YEAR_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Rely On
F_GET_PRIOR_YEAR_FFID_OFFER	Oracle Package Function	S10B80.BANINST1.RPKALGR	Use (select)
F_GET_TRKREQ	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_IS_CITIZEN	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_FUND_CATEGORY_RULES	Use (select)
F_PELL_EFC_IS_DETERMINED	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_VAL_DEGREE_BY_JULY	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Rely On
F_VAL_DETAIL_CODE	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION	Rely On
F_VAL_PRIOR_ACG_SMART	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION_US	Use (select)
RFRBASE	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_RFRBASE	SQL Index	S10B80.FAISMGR	Rely On
RFRBASE_DETAIL_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRBASE_FED_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RFRFFID	SQL Table	S10B80.FAISMGR	Join
RJRSEAR	SQL Table	S10B80.FAISMGR	Join
RPTAWRD	SQL Table	S10B80.FAISMGR	Join
RTVFSRC	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVFTYP	SQL Table	S10B80.FAISMGR	Refer (no action)
ET_RFRBASE_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_RFRBASE_AUR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (update,after,each row)
TBRACCD	SQL Table	S10B80.TAISMGR	Join
TBRMEMO	SQL Table	S10B80.TAISMGR	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RFRBASE

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:46:000	04/02/2008 10:35:18:000

Source Code Comments

Fund Base Data Table

Columns Comments for RFRBASE_FUND_CODE (# 1)

Source Code Comments

FUND CODE: This field is used to establish and maintain valid fund codes used by the institution.

Columns Comments for RFRBASE_FUND_TITLE (# 2)

Source Code Comments

FUND SHORT TITLE: The short description of the fund code.

Columns Comments for RFRBASE_FSRC_CODE (# 3)

Source Code Comments

FUND SOURCE CODE: This field identifies the fund source code to be associated with the fund code.

Columns Comments for RFRBASE_FTYP_CODE (# 4)

Source Code Comments

FUND TYPE CODE: This field links the fund code to a specific fund type code.

Columns Comments for RFRBASE_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for RFRBASE_DETAIL_CODE (# 6)

Source Code Comments

ACCOUNTS RECEIVABLE DETAIL CODE: This code is used to link a Financial Aid Fund Code to an AR detail code for crediting funds to student accounts.

Columns Comments for RFRBASE_FED_FUND_ID (# 7)

Source Code Comments

FEDERAL FUND ID: This code specifies the federal fund if appropriate associated with the fund code.

Columns Comments for RFRBASE_PRINT_SEQ_NO (# 8)

Source Code Comments

PRINT SEQUENCE NUMBER: Determines the relative order in which fund codes will print.

Columns Comments for RFRBASE_VR_MSG_NO (# 9)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the fund code

Columns Comments for RFRBASE_ACTIVE_IND (# 10)

Source Code Comments

ACTIVE INDICATOR: Indicates whether the fund code is active.

Columns Comments for RFRBASE_XREF_VALUE (# 11)

Source Code Comments

FUND CROSS REFERENCE: A user defined cross reference value.

Columns Comments for RFRBASE_FUND_TITLE_LONG (# 12)

Source Code Comments

FUND LONG TITLE: The full description of the fund code.

Table RJBJOBT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RJBJOBT_CODE	VARCHAR2(6)	No	*
RJBJOBT_DESC	VARCHAR2(30)	No
RJBJOBT_HRLY_PAY_IND	VARCHAR2(1)	No
RJBJOBT_PAY_RANGE_LOW	NUMBER(7,2)	No
RJBJOBT_PAY_RANGE_HIGH	NUMBER(7,2)	No
RJBJOBT_DEFAULT_PAY	NUMBER(7,2)	No
RJBJOBT_ACTIVITY_DATE	DATE	Yes
RJBJOBT_REQUIREMENTS	VARCHAR2(180)	Yes
RJBJOBT_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RJBJOBT	Unique	RJBJOBT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
RJBJOBT	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_RJBJOBT	SQL Index	S10B80.FAISMGR	Rely On
RT_RJBJOBT_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJBJOBT_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.RJBJOBT

Object Dates

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

Source Code Comments

Job Title Table

Columns Comments for RJBJOBT_CODE (# 1)

Source Code Comments

JOB TITLE CODE: The Student Employment Module code that controls the student's pay rate and required job skills for a particular job.

Columns Comments for RJBJOBT_DESC (# 2)

Source Code Comments

JOB TITLE DESCRIPTION: The description for the Job Title Code.

Columns Comments for RJBJOBT_HRLY_PAY_IND (# 3)

Source Code Comments

HOURLY PAY INDICATOR: Indicates if the pay range and default amounts mean an hourly rate of pay (Y) or a stipend amount (N).

Columns Comments for RJBJOBT_PAY_RANGE_LOW (# 4)

Source Code Comments

PAY RANGE LOW: The low end of the range of eligible pay rates for a particular Job Title Code.

Columns Comments for RJBJOBT_PAY_RANGE_HIGH (# 5)

Source Code Comments

PAY RANGE HIGH: The high end of the range of eligible pay rates for a particular job title code.

Columns Comments for RJBJOBT_DEFAULT_PAY (# 6)

Source Code Comments

DEFAULT PAY: This is the amount (hourly rate or stipend amount) that is defaulted on the Authorization Form for a particular job title.

Columns Comments for RJBJOBT_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: The date that information in this record was entered or last updated.

Columns Comments for RJBJOBT_REQUIREMENTS (# 8)

Source Code Comments

JOB TITLE REQUIREMENTS: A list of required job skills for a particular Job Title Code.

Columns Comments for RJBJOBT_USER_ID (# 9)

Source Code Comments

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

Table RJBPLBD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RJBPLBD_PLACE_CDE	VARCHAR2(6)	No	*	*
RJBPLBD_PLACE_DESC	VARCHAR2(30)	No
RJBPLBD_SUPERVISOR	VARCHAR2(30)	No
RJBPLBD_ACTIVITY_DATE	DATE	Yes
RJBPLBD_PHONE_AREA	VARCHAR2(6)	Yes
RJBPLBD_PHONE_NUMBER	VARCHAR2(12)	Yes
RJBPLBD_PHONE_EXT	VARCHAR2(10)	Yes
RJBPLBD_STREET_LINE1	VARCHAR2(75)	Yes
RJBPLBD_STREET_LINE2	VARCHAR2(75)	Yes
RJBPLBD_STREET_LINE3	VARCHAR2(75)	Yes
RJBPLBD_CITY	VARCHAR2(50)	Yes
RJBPLBD_STAT_CODE	VARCHAR2(3)	Yes		*
RJBPLBD_ZIP	VARCHAR2(30)	Yes
RJBPLBD_NATN_CODE	VARCHAR2(5)	Yes		*
RJBPLBD_STREET_LINE4	VARCHAR2(75)	Yes
RJBPLBD_HOUSE_NUMBER	VARCHAR2(10)	Yes
RJBPLBD_CTRY_CODE_PHONE	VARCHAR2(4)	Yes
RJBPLBD_EMAIL_ADDRESS	VARCHAR2(128)	Yes
RJBPLBD_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJBPLBD_NATN_CODE	STVNATN_CODE	STVNATN
RJBPLBD_STAT_CODE	STVSTAT_CODE	STVSTAT
RJBPLBD_PLACE_CDE	RJRSEAR_PLACE_CDE	RJRSEAR

Index

Index Name	Index Type	Column Name
PK_RJBPLBD	Unique	RJBPLBD_PLACE_CDE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RJRPLRL	SQL Table	S10B80.FAISMGR	Refer (no action)
DIR_LIST_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
WS_DATA_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
C_GET_AUTH_DATA	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
P_PA_RJBPLBD_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
F_GET_DIR_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_NOPAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_NOPAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_POSITION_TITLE	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
RJBPLBD	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_RJBPLBD	SQL Index	S10B80.FAISMGR	Rely On
RJRSEAR	SQL Table	S10B80.FAISMGR	Join
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)
RT_RJBPLBD_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJBPLBD_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.RJBPLBD

Object Dates

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

Source Code Comments

Placement Base Data Table

Columns Comments for RJBPLBD_STREET_LINE4 (# 15)

Source Code Comments

STREET LINE4: Employment site number and street name for address line 4.

Columns Comments for RJBPLBD_HOUSE_NUMBER (# 16)

Source Code Comments

HOUSE NUMBER: Employment site building or lot number on a street or in an area.

Columns Comments for RJBPLBD_CTRY_CODE_PHONE (# 17)

Source Code Comments

TELEPHONE COUNTRY CODE: Employment site telephone code designating the region or country.

Columns Comments for RJBPLBD_EMAIL_ADDRESS (# 18)

Source Code Comments

EMAIL ADDRESS: Supervisor's E-mail Address.

Columns Comments for RJBPLBD_USER_ID (# 19)

Source Code Comments

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

Table RJBSEDR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RJBSEDR_AIDY_CODE	VARCHAR2(4)	No	*	*
RJBSEDR_AUTH_START_DATE	DATE	No
RJBSEDR_AUTH_END_DATE	DATE	No
RJBSEDR_PAY_START_DATE	DATE	No
RJBSEDR_PAY_END_DATE	DATE	No
RJBSEDR_AUST_CODE	VARCHAR2(4)	No		*
RJBSEDR_ACTIVITY_DATE	DATE	Yes
RJBSEDR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJBSEDR_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RJBSEDR_AUST_CODE	RTVAUST_CODE	RTVAUST

Index

Index Name	Index Type	Column Name
PK_RJBSEDR	Unique	RJBSEDR_AIDY_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_RJBSEDR	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVAUST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RJBSEDR_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJBSEDR_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.RJBSEDR

Object Dates

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

Source Code Comments

Student Employment Default Rules Table

Columns Comments for RJBSEDR_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 RJRPAYL

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RJRPAYL_AIDY_CODE	VARCHAR2(4)	No	*	*
RJRPAYL_YEAR	VARCHAR2(4)	No	*
RJRPAYL_PICT_CODE	VARCHAR2(2)	No	*
RJRPAYL_PAYNO	NUMBER(3,0)	No	*
RJRPAYL_TERM_CODE	VARCHAR2(6)	No		*
RJRPAYL_ACTIVITY_DATE	DATE	Yes
RJRPAYL_PROCESS_IND	VARCHAR2(1)	Yes
RJRPAYL_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJRPAYL_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RJRPAYL_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RJRPAYL	Unique	RJRPAYL_AIDY_CODE
PK_RJRPAYL	Unique	RJRPAYL_YEAR
PK_RJRPAYL	Unique	RJRPAYL_PICT_CODE
PK_RJRPAYL	Unique	RJRPAYL_PAYNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_PA_RJRPAYL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
RJRPAYL	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_RJRPAYL	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
RT_RJRPAYL_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJRPAYL_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.RJRPAYL

Object Dates

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

Source Code Comments

Payroll Load Rules Table

Columns Comments for RJRPAYL_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 RJRPLRL

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
RJRPLRL_AIDY_CODE	VARCHAR2(4)	No	*
RJRPLRL_PLACE_CDE	VARCHAR2(6)	No	*
RJRPLRL_ALLOCATION	NUMBER(11,2)	No
RJRPLRL_ECLS_CODE	VARCHAR2(2)	No
RJRPLRL_POSN	VARCHAR2(6)	No
RJRPLRL_ORGN_CODE	VARCHAR2(6)	No
RJRPLRL_ACTIVITY_DATE	DATE	Yes
RJRPLRL_COAS_CODE	VARCHAR2(1)	Yes
RJRPLRL_ECLS_DESC	VARCHAR2(30)	Yes
RJRPLRL_POSN_TITLE	VARCHAR2(30)	Yes
RJRPLRL_ORGN_DESC	VARCHAR2(35)	Yes
RJRPLRL_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJRPLRL_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RJRPLRL_PLACE_CDE	RJBPLBD_PLACE_CDE	RJBPLBD

Index

Index Name	Index Type	Column Name
RJRPLRL_KEY_INDEX		RJRPLRL_AIDY_CODE
RJRPLRL_KEY_INDEX		RJRPLRL_PLACE_CDE
RJRPLRL_KEY_INDEX		RJRPLRL_POSN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_PA_RJRPLRL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
F_GET_POSITION_TITLE	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_POSITION_TITLE	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
RJRPLRL	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
RJRPLRL_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RJBPLBD	SQL Table	S10B80.FAISMGR	Refer (no action)
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RJRPLRL_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJRPLRL_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.RJRPLRL

Object Dates

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

Source Code Comments

Placement Rules Table

Columns Comments for RJRPLRL_USER_ID (# 12)

Source Code Comments

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

Table RJRSEAR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RJRSEAR_AIDY_CODE	VARCHAR2(4)	No	*	*
RJRSEAR_PIDM	NUMBER(8,0)	No	*
RJRSEAR_JOBT_CODE	VARCHAR2(6)	No
RJRSEAR_PLACE_CDE	VARCHAR2(6)	No
RJRSEAR_POSN	VARCHAR2(6)	No	*
RJRSEAR_SUFF	VARCHAR2(2)	No	*
RJRSEAR_AUST_CODE	VARCHAR2(4)	No		*
RJRSEAR_AUTH_START_DATE	DATE	No
RJRSEAR_AUTH_END_DATE	DATE	No
RJRSEAR_PAY_START_DATE	DATE	No
RJRSEAR_PAY_END_DATE	DATE	No
RJRSEAR_ACTIVITY_DATE	DATE	Yes
RJRSEAR_FUND_CODE	VARCHAR2(6)	Yes
RJRSEAR_AUTH_HRS	NUMBER(6,2)	Yes
RJRSEAR_PAY_RATE	NUMBER(11,6)	Yes
RJRSEAR_AUTH_EARNINGS	NUMBER(11,2)	Yes
RJRSEAR_STIPEND_AMT	NUMBER(11,2)	Yes
RJRSEAR_SORT_KEY	VARCHAR2(20)	Yes
RJRSEAR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJRSEAR_AUST_CODE	RTVAUST_CODE	RTVAUST
RJRSEAR_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RJRSEAR	Unique	RJRSEAR_AIDY_CODE
PK_RJRSEAR	Unique	RJRSEAR_PIDM
PK_RJRSEAR	Unique	RJRSEAR_POSN
PK_RJRSEAR	Unique	RJRSEAR_SUFF
RJRSEAR_KEY_INDEX		RJRSEAR_AIDY_CODE
RJRSEAR_KEY_INDEX		RJRSEAR_PLACE_CDE
RJRSEAR_KEY_INDEX		RJRSEAR_POSN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RFRBASE	SQL Table	S10B80.FAISMGR	Join
RJBPLBD	SQL Table	S10B80.FAISMGR	Join
AIDY_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
AID_YEAR_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
AUTH_DATA_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
FUND_CODE_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
WS_DATA_REC	Oracle Package Type	S10B80.BANINST1.BWRCBREF	Rely On
F_AWARD_AUTHORIZED	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Rely On
F_AWARD_AUTHORIZED	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
C_GET_AID_YEAR	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Rely On
C_GET_AID_YEAR	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
C_GET_AUTH_DATA	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Rely On
C_GET_AUTH_DATA	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
C_GET_FUND_CODE	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Rely On
C_GET_FUND_CODE	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert)
F_GET_DIR_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_DIR_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_NOPAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_PERSONAL_AIDY_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_PERSONAL_AIDY_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_VALIDATE_AID_YEAR	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_VALIDATE_AID_YEAR	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
RJRSEAR	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_RJRSEAR	SQL Index	S10B80.FAISMGR	Rely On
RJRSEAR_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVAUST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RJRSEAR_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJRSEAR_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.RJRSEAR

Object Dates

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

Source Code Comments

Student Employment Authorization Table

Columns Comments for RJRSEAR_JOBT_CODE (# 3)

Source Code Comments

JOB TITLE CODE: The student's Job Title for this authorization record.

Columns Comments for RJRSEAR_SORT_KEY (# 18)

Source Code Comments

SORT KEY: Field used for enabling dynamic sorting by any value which is entered into this field.

Columns Comments for RJRSEAR_USER_ID (# 19)

Source Code Comments

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

Table RJRSERF

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
RJRSERF_AIDY_CODE	VARCHAR2(4)	No	*
RJRSERF_PIDM	NUMBER(8,0)	No
RJRSERF_REF_DATE	DATE	No
RJRSERF_RFST_CODE	VARCHAR2(4)	No	*
RJRSERF_PLACE_CDE	VARCHAR2(6)	No
RJRSERF_ACTIVITY_DATE	DATE	Yes
RJRSERF_FUND_CODE	VARCHAR2(6)	Yes
RJRSERF_POSN	VARCHAR2(6)	Yes
RJRSERF_SUFF	VARCHAR2(2)	Yes
RJRSERF_JOBT_CODE	VARCHAR2(6)	Yes
RJRSERF_COMMENT	VARCHAR2(50)	Yes
RJRSERF_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJRSERF_RFST_CODE	RTVRFST_CODE	RTVRFST
RJRSERF_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
RJRSERF_INDEX		RJRSERF_AIDY_CODE
RJRSERF_INDEX		RJRSERF_PIDM
RJRSERF_INDEX		RJRSERF_REF_DATE

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
RJRSERF_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRFST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RJRSERF_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJRSERF_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.RJRSERF

Object Dates

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

Source Code Comments

Student Employment Referral Table

Columns Comments for RJRSERF_FUND_CODE (# 7)

Source Code Comments

FUND CODE: The financial aid source that will be funding the job.

Columns Comments for RJRSERF_POSN (# 8)

Source Code Comments

POSITION CODE: The BANNER Human Resources position code that controls the job.

Columns Comments for RJRSERF_SUFF (# 9)

Source Code Comments

POSITION CODE SUFFIX: The BANNER HR suffix for the student's position code.

Columns Comments for RJRSERF_JOBT_CODE (# 10)

Source Code Comments

JOB TITLE CODE: The student employment job title code for the referral.

Columns Comments for RJRSERF_USER_ID (# 12)

Source Code Comments

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

Table RJRSEWH

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
RJRSEWH_AIDY_CODE	VARCHAR2(4)	No	*
RJRSEWH_PIDM	NUMBER(8,0)	No
RJRSEWH_POSN	VARCHAR2(6)	No
RJRSEWH_SUFF	VARCHAR2(2)	No
RJRSEWH_PAY_END_DATE	DATE	No
RJRSEWH_ACTIVITY_DATE	DATE	Yes
RJRSEWH_HRS	NUMBER(6,2)	Yes
RJRSEWH_RATE	NUMBER(11,6)	Yes
RJRSEWH_AMT	NUMBER(11,2)	Yes
RJRSEWH_YEAR	VARCHAR2(4)	Yes
RJRSEWH_PICT_CODE	VARCHAR2(2)	Yes
RJRSEWH_PAYNO	NUMBER(3,0)	Yes
RJRSEWH_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

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

Index

Index Name	Index Type	Column Name
RJRSEWH_INDEX		RJRSEWH_AIDY_CODE
RJRSEWH_INDEX		RJRSEWH_PIDM
RJRSEWH_INDEX		RJRSEWH_POSN
RJRSEWH_INDEX		RJRSEWH_SUFF
RJRSEWH_INDEX		RJRSEWH_PAY_END_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_POSITION_TITLE	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Rely On
F_GET_WS_DISPLAY_DATA	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
RJRSEWH	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
RJRSEWH_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RJRSEWH_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RJRSEWH_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.RJRSEWH

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:01:000	04/02/2008 10:35:21:000

Source Code Comments

Student Employment Work History Table

Columns Comments for RJRSEWH_USER_ID (# 13)

Source Code Comments

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

Table RORENRL

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RORENRL_PIDM	NUMBER(8,0)	No	*	*
RORENRL_TERM_CODE	VARCHAR2(6)	No	*	*
RORENRL_FINAID_CREDIT_HR	NUMBER(9,3)	No
RORENRL_FINAID_BILL_HR	NUMBER(9,3)	No
RORENRL_ACTIVITY_DATE	DATE	No
RORENRL_FINAID_ADJ_HR	NUMBER(9,3)	No
RORENRL_USER_ID	VARCHAR2(30)	Yes
RORENRL_SYS_IND	VARCHAR2(1)	Yes
RORENRL_CONSORTIUM_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORENRL_TERM_CODE	STVTERM_CODE	STVTERM
RORENRL_PIDM	RPRATRM_PIDM	RPRATRM
RORENRL_TERM_CODE	RPRATRM_TERM_CODE	RPRATRM

Index

Index Name	Index Type	Column Name
PK_RORENRL	Unique	RORENRL_PIDM
PK_RORENRL	Unique	RORENRL_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Use (select)
P_CALCULATE_LOAD	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_CALC_LOAN_ENROLL_STATUS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
F_CALC_STUD_ADJ_HRS	Oracle Package Function	S10B80.BANINST1.ROKMISC	Rely On
F_CALC_STUD_BILL_HRS	Oracle Package Function	S10B80.BANINST1.ROKMISC	Rely On
F_CALC_STUD_CREDIT_HRS	Oracle Package Function	S10B80.BANINST1.ROKMISC	Rely On
RORENRL	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_RORENRL	SQL Index	S10B80.FAISMGR	Rely On
RPRATRM	SQL Table	S10B80.FAISMGR	Join
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RORENRL

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:05:000	04/02/2008 10:35:21:000

Source Code Comments

Financial Aid Enrollment Table

Columns Comments for RORENRL_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RORENRL_TERM_CODE (# 2)

Source Code Comments

TERM CODE: The term in which the enrollment and billing hours are associated for this record.

Columns Comments for RORENRL_FINAID_CREDIT_HR (# 3)

Source Code Comments

FINANCIAL AID CREDIT HOURS: This field maintains the enrollment credit hours of the student in this record as of the financial aid cut-off date.

Columns Comments for RORENRL_FINAID_BILL_HR (# 4)

Source Code Comments

FINANCIAL AID BILLING HOURS: This field maintains the billing hours of the student as of the financial aid cut-off date.

Columns Comments for RORENRL_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 RORENRL_FINAID_ADJ_HR (# 6)

Source Code Comments

FINANCIAL AID ADJUSTED HOURS: Calculated hours in a student's schedule excluding dropped and audited courses and including non-credit/remedial courses.

Columns Comments for RORENRL_USER_ID (# 7)

Source Code Comments

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

Columns Comments for RORENRL_SYS_IND (# 8)

Source Code Comments

SYSTEM/MANUAL INDICATOR: Indicator to show if the financial aid enrollment hours were assigned (M)anually or by the (S)ystem.

Columns Comments for RORENRL_CONSORTIUM_IND (# 9)

Source Code Comments

TERM CONSORTIUM INDICATOR: Allows students to be identified as consortium participants on a term by term basis.

Table RORSAPR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RORSAPR_PIDM	NUMBER(8,0)	No	*
RORSAPR_TERM_CODE	VARCHAR2(6)	No	*	*
RORSAPR_SAPR_CODE	VARCHAR2(6)	No		*
RORSAPR_ACTIVITY_DATE	DATE	No
RORSAPR_SAPR_CODE_CALC	VARCHAR2(6)	Yes		*
RORSAPR_LOCK_IND	VARCHAR2(1)	Yes
RORSAPR_SLCT_IND	VARCHAR2(1)	Yes
RORSAPR_USER_ID	VARCHAR2(30)	Yes
RORSAPR_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORSAPR_SAPR_CODE	RTVSAPR_CODE	RTVSAPR
RORSAPR_SAPR_CODE_CALC	RTVSAPR_CODE	RTVSAPR
RORSAPR_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RORSAPR	Unique	RORSAPR_PIDM
PK_RORSAPR	Unique	RORSAPR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROVSA03	SQL View	S10B80.BANINST1	Use (select)
ROVSA04	SQL View	S10B80.BANINST1	Use (select)
ROVSA05	SQL View	S10B80.BANINST1	Use (select)
ROVSA06	SQL View	S10B80.BANINST1	Use (select)
ROVSA07	SQL View	S10B80.BANINST1	Use (select)
ROVSA08	SQL View	S10B80.BANINST1	Use (select)
ROVSA09	SQL View	S10B80.BANINST1	Use (select)
ROVSAPR	SQL View	S10B80.BANINST1	Use (select)
RORSAPR_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
SAPR_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
SAPR_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
PREV_SAP_CODE_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
PREV_SAP_TERM_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
RORSAPR_LOCKED_IND_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
F_GET_SAPR_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_GET_SAPR_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_MAINTAIN_SAP_ALL_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_ALL_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_INST_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_INST_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_STATE_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_STATE_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_TITLE_IV_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_TITLE_IV_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_RORSAPR_EXISTS	Oracle Package Function	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (select)
GETFASAPC	Oracle Package Cursor	S10B80.BANINST1.BWRKSAPH	Use (select)Rely On
RORSAPR_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.ROKSELS	Rely On
RORSAPR_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.ROKSELS	Use (select)Rely On
P_ADD_RORSAPR	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (Insert,update)
P_ALL_RORSTAT_FOR_TERM	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (update)
P_ALL_SFBETRM_FOR_TERM	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (update)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_REQUIREMENT	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (Insert)
P_DISPLAY_RORSAPR	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RORSAPR	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_DISPSAP	Oracle Package Procedure	S10B80.BANINST1.BWRKSAPH	Rely On
P_DISPSUMM	Oracle Package Procedure	S10B80.BANINST1.BWRKSUMM	Rely On
P_EXE_ROBBGRP	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (update)
P_GET_RORSAPR_RTVSAPR_ROWS	Oracle Package Procedure	S10B80.BANINST1.ROKFUNC	Rely On
P_TRANSLATE_RULE	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (update)
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
RORSAPR	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_RORSAPR	SQL Index	S10B80.FAISMGR	Rely On
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RORSAPR

Object Dates

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

Source Code Comments

Satisfactory Academic Progress Rules Table

Columns Comments for RORSAPR_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RORSAPR_TERM_CODE (# 2)

Source Code Comments

TERM CODE: The term associated with the SAP code in this student's record.

Columns Comments for RORSAPR_SAPR_CODE (# 3)

Source Code Comments

SATISFACTORY ACADEMIC PROGRESS CODE: This field maintains the student's SAP c ode associated with the term code in this record.

Columns Comments for RORSAPR_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for RORSAPR_SAPR_CODE_CALC (# 5)

Source Code Comments

CALCULATED SAP STATUS CODE: Code which represents the calculated academic progress of applicants and aid recipients for the most recently completed term.

Columns Comments for RORSAPR_LOCK_IND (# 6)

Source Code Comments

LOCK INDICATOR: This field identifies whether a lock exists on the particular SAP Status. The lock will maintain that student in its current status so that no changes can occur on that SAP Status either manually or in batch.

Columns Comments for RORSAPR_SLCT_IND (# 7)

Source Code Comments

SELECT INDICATOR: This field is used by the Batch Process and indicates whether the student has already been processed.

Columns Comments for RORSAPR_USER_ID (# 8)

Source Code Comments

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

Columns Comments for RORSAPR_DATA_ORIGIN (# 9)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Table RORSTRF

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RORSTRF_SAPR_CODE_PREV	VARCHAR2(6)	No	*	*
RORSTRF_SAPR_CODE_CALC	VARCHAR2(6)	No	*	*
RORSTRF_SAPR_CODE_NEW	VARCHAR2(6)	No		*
RORSTRF_USER_ID	VARCHAR2(30)	No
RORSTRF_ACTIVITY_DATE	DATE	No
RORSTRF_LETR_CODE	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORSTRF_SAPR_CODE_PREV	RTVSAPR_CODE	RTVSAPR
RORSTRF_SAPR_CODE_CALC	RTVSAPR_CODE	RTVSAPR
RORSTRF_SAPR_CODE_NEW	RTVSAPR_CODE	RTVSAPR
RORSTRF_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_RORSTRF	Unique	RORSTRF_SAPR_CODE_PREV
PK_RORSTRF	Unique	RORSTRF_SAPR_CODE_CALC

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RORSTRF_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
RORSTRF_LETTER_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
RORSTRF	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_RORSTRF	SQL Index	S10B80.FAISMGR	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RORSTRF

Object Dates

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

Source Code Comments

SAP Translation Rules Table

Columns Comments for RORSTRF_SAPR_CODE_PREV (# 1)

Source Code Comments

PREVIOUS SAP STATUS CODE: Code which represents the previous academic progress of applicants and aid recipients.

Columns Comments for RORSTRF_SAPR_CODE_CALC (# 2)

Source Code Comments

CALCULATED SAP STATUS CODE: Code which represents the calculated academic progress of applicants and aid recipients for the most recently completed term.

Columns Comments for RORSTRF_SAPR_CODE_NEW (# 3)

Source Code Comments

NEW SAP STATUS CODE: Code which represents the New academic progress of applicants and aid recipients from the rule based on the combination of Previous and Calculated SAP Status Codes.

Columns Comments for RORSTRF_USER_ID (# 4)

Source Code Comments

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

Columns Comments for RORSTRF_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for RORSTRF_LETR_CODE (# 6)

Source Code Comments

LETTER CODE: Code of the letter to be posted when attaining the corresponding New SAP Status. Letter code references GTVLETR table.

Table RPRATRM

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRATRM_AIDY_CODE	VARCHAR2(4)	No	*	*
RPRATRM_PIDM	NUMBER(8,0)	No	*
RPRATRM_FUND_CODE	VARCHAR2(6)	No	*	*
RPRATRM_TERM_CODE	VARCHAR2(6)	No	*	*
RPRATRM_OFFER_AMT	NUMBER(11,2)	No
RPRATRM_OFFER_DATE	DATE	No
RPRATRM_ACTIVITY_DATE	DATE	No
RPRATRM_DISB_FINAL_IND	VARCHAR2(1)	No
RPRATRM_DIST_PCT	NUMBER(6,3)	Yes
RPRATRM_MEMO_EXP_DATE	DATE	Yes
RPRATRM_ORIG_OFFER_AMT	NUMBER(11,2)	Yes
RPRATRM_ORIG_OFFER_DATE	DATE	Yes
RPRATRM_ACCEPT_AMT	NUMBER(11,2)	Yes
RPRATRM_ACCEPT_DATE	DATE	Yes
RPRATRM_DECLINE_AMT	NUMBER(11,2)	Yes
RPRATRM_DECLINE_DATE	DATE	Yes
RPRATRM_CANCEL_AMT	NUMBER(11,2)	Yes
RPRATRM_CANCEL_DATE	DATE	Yes
RPRATRM_AUTHORIZE_AMT	NUMBER(11,2)	Yes
RPRATRM_AUTHORIZE_DATE	DATE	Yes
RPRATRM_MEMO_AMT	NUMBER(11,2)	Yes
RPRATRM_MEMO_DATE	DATE	Yes
RPRATRM_PAID_AMT	NUMBER(11,2)	Yes
RPRATRM_PAID_DATE	DATE	Yes
RPRATRM_PCKG_LOAD_IND	VARCHAR2(1)	No
RPRATRM_NSLDS_OVRD_IND	VARCHAR2(1)	Yes
RPRATRM_PELL_AWRD_LOAD_OPT	VARCHAR2(1)	Yes
RPRATRM_LOCK_IND	VARCHAR2(1)	Yes
RPRATRM_USER_ID	VARCHAR2(30)	Yes
RPRATRM_CIP_OVERRIDE_CODE	VARCHAR2(6)	Yes
RPRATRM_DATA_ORIGIN	VARCHAR2(30)	Yes
RPRATRM_OVERRIDE_DISB_RULE	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRATRM_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPRATRM_TERM_CODE	STVTERM_CODE	STVTERM
RPRATRM_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE
RPRATRM_FUND_CODE	ADRFUND_FA_FUND_CODE	ADRFUND

Index

Index Name	Index Type	Column Name
PK_RPRATRM	Unique	RPRATRM_AIDY_CODE
PK_RPRATRM	Unique	RPRATRM_PIDM
PK_RPRATRM	Unique	RPRATRM_FUND_CODE
PK_RPRATRM	Unique	RPRATRM_TERM_CODE
RPRATRM_KEY_INDEX2		RPRATRM_FUND_CODE
RPRATRM_KEY_INDEX2		RPRATRM_AIDY_CODE
RPRATRM_PIDM_INDEX		RPRATRM_PIDM
RPRATRM_PIDM_INDEX		RPRATRM_FUND_CODE
RPRATRM_PIDM_INDEX		RPRATRM_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RORENRL	SQL Table	S10B80.FAISMGR	Join
RORSTAT	SQL Table	S10B80.FAISMGR	Join
RORTPRD	SQL Table	S10B80.FAISMGR	Join
RORVIEW	SQL Table	S10B80.FAISMGR	Join
RPRADSB	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ADVAWRD	SQL View	S10B80.BANINST1	Use (select)
RFVFTRM	SQL View	S10B80.BANINST1	Use (select)
RNVAND0	SQL View	S10B80.BANINST1	Join
RPVATRM	SQL View	S10B80.BANINST1	Use (select)
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
RPVFTRM	SQL View	S10B80.BANINST1	Use (select)
RPVTERM	SQL View	S10B80.BANINST1	Join
RPVTERM	SQL View	S10B80.BANINST1	Use (select)
F_FA_AMT_TERM_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_FA_AMT_YEAR_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_PCKG_LOAD_IND	SQL Function	S10B80.BANINST1	Use (select)
F_INST_AID_FNC	SQL Function	S10B80.BANINST1	Use (select)
AWARD_SCHEDULE_REC	Oracle Package Type	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
EXISTTERMSCHEDRECTYPE	Oracle Package Type	S10B80.BANINST1.RPKATRM	Rely On
PAYMENT_TYPE	Oracle Package Type	S10B80.BANINST1.BWRKPAYS	Rely On
TERMSCHEDRECTYPE	Oracle Package Type	S10B80.BANINST1.RPKATRM	Rely On
RPRATRM_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
GETROUNDAMTC	Oracle Package Cursor	S10B80.BANINST1.BWRKPAYS	Use (select)
P_ACHIEVE_TERM_SCHEDULE	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_ACPT_OR_OFRD	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_BUILDROTWFAE	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GET_LOAD_FROM_HOURS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_RECALC_TERM_SCHEDULE	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_AWARD_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_AWARD_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_BUILD_RPRATRM_REC	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_CIP_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_COD_TERM_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Rely On
F_DISB_SCHED_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_DISB_SCHED_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_FUND_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_FUND_ID_IS_SMRT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_GET_AWARD_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_FED_FUND_ID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_MEMO_EXP_DATE	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_PCKG_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_PELL_FUND	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_PELL_FUND	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_PELL_OFRD_CNT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_PELL_OFRD_CNT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_SAPR_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_IN_DEFAULT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_IS_LOAN_PROCESS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_LOCKED_TERM_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Rely On
F_LOCKED_TERM_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Use (select)
F_MISSING_SCHEDULE	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Use (select)
F_OWES_REFUND	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_PAID_TERM_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Rely On
F_PAID_TERM_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Use (select)
F_TERM_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_TERM_CODE_IN_AID_PERIOD	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_VALID_ACCEPT_AMT	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
F_VAL_DEGREE	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_FED_LIMITS	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_LOAD	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_PELL_AUTHORIZATION	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
F_VAL_PELL_AUTHORIZATION	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Use (select)
F_VAL_PELL_DISBURSEMENT	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
GETPAYITEMC	Oracle Package Cursor	S10B80.BANINST1.BWRKPAYS	Use (select)
RPRATRM_C	Oracle Package Cursor	S10B80.BANINST1.RPKATRM	Rely On
RPRATRM_C	Oracle Package Cursor	S10B80.BANINST1.RPKATRM	Use (select)
RPRATRM_ROW_BY_MULTI_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Rely On
RPRATRM_ROW_BY_MULTI_C	Oracle Package Cursor	S10B80.BANINST1.RPKSELS	Use (select)Rely On
P_ADD_AWARD_TERM_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On
P_ADD_AWARD_TERM_REC	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Use (select)
P_ADD_PROM_NOTE	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (select)
P_ADD_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_CALCULATE_LOAD	Oracle Package Procedure	S10B80.BANINST1.RPKLOAD	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_RPRATRM	Use (delete)
P_DELETE_PROM_NOTE	Oracle Package Procedure	S10B80.BANINST1.RPKAWRD	Use (select)
P_DELETE_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_DELETE_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Use (select)
P_DISPLAY_RPRATRM	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_RPRATRM	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_GET_GRANT_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_PELL_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_RPRATRM_RTVAWST_ROWS	Oracle Package Procedure	S10B80.BANINST1.RPKFUNC	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_RPRATRM	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_RPRATRM	Use (update)Rely On
P_UPDATE_EXISTING_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_UPDATE_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Rely On
P_UPDATE_SCHEDULES	Oracle Package Procedure	S10B80.BANINST1.RPKATRM	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_AWARD_SCHEDULE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_STATUS_RULES	Rely On
P_VALIDATE_AWARD	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
P_VALIDATE_AWARD	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION_US	Rely On
P_VALIDATE_DISBURSEMENT	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_VALIDATE_DISBURSEMENT_US	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION_US	Rely On
P_VALIDATE_MEMOS	Oracle Package Procedure	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
P_VALIDATE_PACKAGE_AWARD	Oracle Package Procedure	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
P_VR_GET_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRPMT	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_DISBURSEMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_APPLICANT_STATUS	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_PELL_ORIGINATIONS	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD_SCHEDULE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert)
F_AWARD_TERM_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_AWARD_TERM_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_CHECK_FUTURE_TERM_DISBURSED	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Rely On
F_CHECK_FUTURE_TERM_DISBURSED	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_CHECK_UNPAID_AWARDS	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Rely On
F_CHECK_UNPROCESSED_AID	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Rely On
F_CHECK_UNPROCESSED_AID	Oracle Package Function	S10B80.BANINST1.ROKWFLB	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
F_GET_AWARD_SCHED_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_GET_AWARD_SCHED_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_GET_CIP_CODE	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_CIP_CODE_ATRM	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_CIP_CODE_ATRM	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_MEMO_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Rely On
F_GET_MIN_TERM	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_MIN_TERM	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_GET_PAID_AMOUNT	Oracle Package Function	S10B80.BANINST1.RPKATRM	Rely On
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_AWARD_DISBURSEMENT_RULES	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RP_AWARD_SCHEDULE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_AWARD_SCHEDULE	Use (select)
F_VAL_RULES	Oracle Package Function	S10B80.BANINST1.RPK_COMMON_VALIDATION	Rely On
RPRATRM	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_RPRATRM	SQL Index	S10B80.FAISMGR	Rely On
RPRATRM_KEY_INDEX2	SQL Index	S10B80.FAISMGR	Rely On
RPRATRM_PIDM_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ADRFUND	SQL Table	S10B80.ALUMNI	Join
RFRBASE	SQL Table	S10B80.FAISMGR	Join
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
RT_RPRATRM_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRATRM_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.RPRATRM

Object Dates

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

Source Code Comments

Applicant Award by Term Table

Columns Comments for RPRATRM_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year associated with the award schedule.

Columns Comments for RPRATRM_PIDM (# 2)

Source Code Comments

PIDM: The internal system generated student identification number.

Columns Comments for RPRATRM_FUND_CODE (# 3)

Source Code Comments

FUND CODE: The fund code associated with the award schedule.

Columns Comments for RPRATRM_TERM_CODE (# 4)

Source Code Comments

TERM CODE: The term code associated with the award schedule.

Columns Comments for RPRATRM_OFFER_AMT (# 5)

Source Code Comments

OFFERED AMOUNT: The offered dollar amount of the award for the term.

Columns Comments for RPRATRM_OFFER_DATE (# 6)

Source Code Comments

OFFERED DATE: The date the award was offered for the term.

Columns Comments for RPRATRM_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: The date the information in this record was entered or updated.

Columns Comments for RPRATRM_DISB_FINAL_IND (# 8)

Source Code Comments

DISBURSED FINAL INDICATOR: Indicates if all disbursements have been made within the term indicated.

Columns Comments for RPRATRM_DIST_PCT (# 9)

Source Code Comments

DISTRIBUTION PERCENT: The distribution percent of the award for the term. This column will be made obsolete in the future.

Columns Comments for RPRATRM_MEMO_EXP_DATE (# 10)

Source Code Comments

MEMO EXPIRATION DATE: The date the memo of this award for this term will be cancelled.

Columns Comments for RPRATRM_ORIG_OFFER_AMT (# 11)

Source Code Comments

ORIGINAL OFFERED AMOUNT: The original offered dollar amount of this award for this term.

Columns Comments for RPRATRM_ORIG_OFFER_DATE (# 12)

Source Code Comments

ORIGINAL OFFERED DATE: The date the award was originally offered for this term.

Columns Comments for RPRATRM_ACCEPT_AMT (# 13)

Source Code Comments

ACCEPTED AMOUNT: The accepted dollar amount of the award for this term.

Columns Comments for RPRATRM_ACCEPT_DATE (# 14)

Source Code Comments

ACCEPTED DATE: The date the award was accepted for this term.

Columns Comments for RPRATRM_DECLINE_AMT (# 15)

Source Code Comments

DECLINED AMOUNT: The declined dollar amount of the award for this term.

Columns Comments for RPRATRM_DECLINE_DATE (# 16)

Source Code Comments

DECLINED DATE: The date the award was declined for this term.

Columns Comments for RPRATRM_CANCEL_AMT (# 17)

Source Code Comments

CANCELLED AMOUNT: The cancelled dollar amount of the award for this term.

Columns Comments for RPRATRM_CANCEL_DATE (# 18)

Source Code Comments

CANCELLED DATE: The date the award was cancelled for this term.

Columns Comments for RPRATRM_AUTHORIZE_AMT (# 19)

Source Code Comments

AUTHORIZED AMOUNT: The authorized dollar amount of the award for this term.

Columns Comments for RPRATRM_AUTHORIZE_DATE (# 20)

Source Code Comments

AUTHORIZED DATE: The date the award was authorized for this term.

Columns Comments for RPRATRM_MEMO_AMT (# 21)

Source Code Comments

MEMOED AMOUNT: The memo dollar amount of the award for this term.

Columns Comments for RPRATRM_MEMO_DATE (# 22)

Source Code Comments

MEMOED DATE: The date of the memo of the award for this term.

Columns Comments for RPRATRM_PAID_AMT (# 23)

Source Code Comments

PAID AMOUNT: The paid dollar amount of the award for this term.

Columns Comments for RPRATRM_PAID_DATE (# 24)

Source Code Comments

PAID DATE: The date the award was paid for this term.

Columns Comments for RPRATRM_PCKG_LOAD_IND (# 25)

Source Code Comments

PACKAGING LOAD INDICATOR: The enrollment status for this term.

Columns Comments for RPRATRM_NSLDS_OVRD_IND (# 26)

Source Code Comments

NSLDS OVERRIDE: Indicates the rules which have been overridden for the award for the term.

Columns Comments for RPRATRM_PELL_AWRD_LOAD_OPT (# 27)

Source Code Comments

APPLICANT PELL AWARD ENROLLMENT OPTION: The enrollment option used when the Pell award was packaged for the term.

Columns Comments for RPRATRM_LOCK_IND (# 28)

Source Code Comments

TERM-BASED LOCK INDICATOR: Indicates if the award has been locked for the term.

Columns Comments for RPRATRM_USER_ID (# 29)

Source Code Comments

USER ID: The user ID of the person who inserted or last updated this record.

Columns Comments for RPRATRM_CIP_OVERRIDE_CODE (# 30)

Source Code Comments

CIP OVERRIDE CODE: The Classification of Instructional Program Code for the program the student intends to major in if the school does not require students to declare a major by their junior year.

Columns Comments for RPRATRM_DATA_ORIGIN (# 31)

Source Code Comments

DATA ORIGIN: Source system that created or updated the data.

Columns Comments for RPRATRM_OVERRIDE_DISB_RULE (# 32)

Source Code Comments

OVERRIDE FUND DISBURSEMENT RULE: Indicates whether the fund disbursement rule will be overridden when disbursing a fund to the student for a term.

Table RTVAUST

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVAUST_CODE	VARCHAR2(4)	No	*
RTVAUST_DESC	VARCHAR2(30)	No
RTVAUST_ACTIVE_IND	VARCHAR2(1)	No
RTVAUST_ACTIVITY_DATE	DATE	Yes
RTVAUST_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVAUST	Unique	RTVAUST_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RJBSEDR	SQL Table	S10B80.FAISMGR	Refer (no action)
RJRSEAR	SQL Table	S10B80.FAISMGR	Refer (no action)
F_AWARD_AUTHORIZED	Oracle Package Function	S10B80.BANINST1.RB_AWARD	Use (select)
C_GET_AID_YEAR	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
C_GET_AUTH_DATA	Oracle Package Cursor	S10B80.BANINST1.BWRCBREF	Use (select)
RTVAUSTC	Oracle Package Cursor	S10B80.BANINST1.RTKAUST	Use (select)Rely On
P_PA_RTVAUST_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_TEMP_AWARD	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_AWARD	Use (Insert,select)
F_GET_PERSONAL_AIDY_LIST	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
F_VALIDATE_AID_YEAR	Oracle Package Function	S10B80.BANINST1.BWRCBREF	Use (select)
RTVAUST	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_RTVAUST	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVAUST_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVAUST_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.RTVAUST

Object Dates

Creation Date	Analysis Date
04/02/2008 10:27:01:000	04/02/2008 10:35:20:000

Source Code Comments

Employment Authorization Status Validation Table

Columns Comments for RTVAUST_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 RTVRFST

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVRFST_CODE	VARCHAR2(4)	No	*
RTVRFST_DESC	VARCHAR2(30)	No
RTVRFST_ACTIVITY_DATE	DATE	Yes
RTVRFST_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVRFST	Unique	RTVRFST_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RJRSERF	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRFSTC	Oracle Package Cursor	S10B80.BANINST1.RTKRFST	Use (select)Rely On
RTVRFST	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_RTVRFST	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVRFST_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVRFST_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.RTVRFST

Object Dates

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

Source Code Comments

Referral Status Validation Table

Columns Comments for RTVRFST_USER_ID (# 4)

Source Code Comments

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

Table RTVSAPR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RTVSAPR_CODE	VARCHAR2(6)	No	*
RTVSAPR_DESC	VARCHAR2(30)	No
RTVSAPR_PCKG_IND	VARCHAR2(1)	No
RTVSAPR_DISB_IND	VARCHAR2(1)	No
RTVSAPR_AID_TYPE	NUMBER(2,0)	No
RTVSAPR_ACTIVITY_DATE	DATE	No
RTVSAPR_VR_MSG_NO	NUMBER(6,0)	Yes
RTVSAPR_LETR_CODE	VARCHAR2(15)	Yes		*
RTVSAPR_PRIORITY	NUMBER(6,0)	Yes
RTVSAPR_ACTIVE_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RTVSAPR_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_RTVSAPR	Unique	RTVSAPR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSTRF	SQL Table	S10B80.FAISMGR	Refer (no action)
ROTSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVSAPR_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
SAPR_REC	Oracle Package Type	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
SAPR_REC	Oracle Package Type	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
RTVSAPR_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
RTVSAPR_LETTER_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
F_GET_SAPR_DATA	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Use (select)
F_GET_SAPR_DATA	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Use (select)
F_MAINTAIN_SAP_ALL_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_ALL_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_FED_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_INST_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_INST_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_STATE_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_STATE_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
F_MAINTAIN_SAP_TITLE_IV_AID	Oracle Package Function	S10B80.BANINST1.RPK_AWARD_VALIDATION	Rely On
F_MAINTAIN_SAP_TITLE_IV_AID	Oracle Package Function	S10B80.BANINST1.RPK_DISB_VALIDATION	Rely On
RTVSAPRC	Oracle Package Cursor	S10B80.BANINST1.RTKSAPR	Use (select)Rely On
RTVSAPR_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVSAPR	Rely On
RTVSAPR_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVSAPR	Use (select)Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (select)
P_DISPSAP	Oracle Package Procedure	S10B80.BANINST1.BWRKSAPH	Rely On
P_DISPSUMM	Oracle Package Procedure	S10B80.BANINST1.BWRKSUMM	Rely On
P_GET_RORSAPR_RTVSAPR_ROWS	Oracle Package Procedure	S10B80.BANINST1.ROKFUNC	Rely On
P_VR_GET_FIN_HOLDS	Oracle Package Procedure	S10B80.BANINST1.VRRKRGNS	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_PGRP_CATEGORY	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_RTVSAPR	Rely On
F_CODE_IS_ACTIVE	Oracle Package Function	S10B80.BANINST1.RB_RTVSAPR	Rely On
F_GET_DEFAULT_SAPR_CODE	Oracle Package Function	S10B80.BANINST1.ROKSAPR	Use (select)
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.RB_RTVSAPR	Rely On
RTVSAPR	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_RTVSAPR	SQL Index	S10B80.FAISMGR	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVSAPR

Object Dates

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

Source Code Comments

Satisfactory Academic Progress Validation Table

Columns Comments for RTVSAPR_CODE (# 1)

Source Code Comments

SATISFACTORY ACADEMIC PROGRESS CODE: This code defines various codes related to the academic progress of applicants and aid recipients.

Columns Comments for RTVSAPR_DESC (# 2)

Source Code Comments

SATISFACTORY ACADEMIC PROGRESS CODE DESCRIPTION: The description of the SAP codes.

Columns Comments for RTVSAPR_PCKG_IND (# 3)

Source Code Comments

PREVENT PACKAGING INDICATOR: This field indicates whether the SAP code prevents the packaging of the indicated types of aid.

Columns Comments for RTVSAPR_DISB_IND (# 4)

Source Code Comments

PREVENT DISBURSEMENT INDICATOR: This field indicates whether the SAP code should prevent disbursement of the indicated types of aid.

Columns Comments for RTVSAPR_AID_TYPE (# 5)

Source Code Comments

PREVENT WHICH AID TYPE: This field indicates which type(s) of aid the SAP code will prevent from packaging and/or disbursing.

Columns Comments for RTVSAPR_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for RTVSAPR_VR_MSG_NO (# 7)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the academic progress code

Columns Comments for RTVSAPR_LETR_CODE (# 8)

Source Code Comments

LETTER CODE: Default code of the letter to be posted when attaining the corresponding SAP Status. Letter code references GTVLETR table.

Columns Comments for RTVSAPR_PRIORITY (# 9)

Source Code Comments

SAP CODE PRIORITY: The priority order in which SAP codes are assigned to students; lowest priority numbers are assigned first.

Columns Comments for RTVSAPR_ACTIVE_IND (# 10)

Source Code Comments

ACTIVE INDICATOR: Indicates whether the satisfactory academic progress code is active.

Table STVNATN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
STVNATN_CODE	VARCHAR2(5)	No	*
STVNATN_NATION	VARCHAR2(30)	No
STVNATN_CAPITAL	VARCHAR2(20)	Yes
STVNATN_AREA	NUMBER(22,0)	Yes
STVNATN_POPULATION	NUMBER(22,0)	Yes
STVNATN_ACTIVITY_DATE	DATE	No
STVNATN_EDI_EQUIV	VARCHAR2(2)	Yes
STVNATN_LMS_EQUIV	VARCHAR2(2)	Yes
STVNATN_POSTAL_MASK	VARCHAR2(15)	Yes
STVNATN_TELE_MASK	VARCHAR2(15)	Yes
STVNATN_STATSCAN_CDE	VARCHAR2(5)	Yes
STVNATN_SCOD_CODE_ISO	VARCHAR2(3)	Yes
STVNATN_SSA_REPORTING_EQUIV	VARCHAR2(2)	Yes
STVNATN_SEVIS_EQUIV	VARCHAR2(2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVNATN	Unique	STVNATN_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
STVNATN	Oracle Synonym	S10B80.FAISMGR	Rely On
AORCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GOBINTL	SQL Table	S10B80.GENERAL	Refer (no action)
GOBSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSEVD	SQL Table	S10B80.GENERAL	Refer (no action)
GORVISA	SQL Table	S10B80.GENERAL	Refer (no action)
GTVCURR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVZIPC	SQL Table	S10B80.GENERAL	Refer (no action)
GUBINST	SQL Table	S10B80.GENERAL	Refer (no action)
GURAPAY	SQL Table	S10B80.GENERAL	Refer (no action)
PPREXPE	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRHSIL	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRJBLN	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTER	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTIN	SQL Table	S10B80.PAYROLL	Refer (no action)
RJBPLBD	SQL Table	S10B80.FAISMGR	Refer (no action)
RPBLNDR	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLARF	SQL Table	S10B80.FAISMGR	Refer (no action)
SABSUPL	SQL Table	S10B80.SATURN	Refer (no action)
SFRENRL	SQL Table	S10B80.SATURN	Refer (no action)
SHBDIPL	SQL Table	S10B80.SATURN	Refer (no action)
SHBGAPP	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRAN	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRTC	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SMTPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SOBSBGI	SQL Table	S10B80.SATURN	Refer (no action)
SPBPERS	SQL Table	S10B80.SATURN	Refer (no action)
SPRADDR	SQL Table	S10B80.SATURN	Refer (no action)
SPREMRG	SQL Table	S10B80.SATURN	Refer (no action)
SPRINTL	SQL Table	S10B80.SATURN	Refer (no action)
SRTADDR	SQL Table	S10B80.SATURN	Refer (no action)
SRTHSCH	SQL Table	S10B80.SATURN	Refer (no action)
SRTINTL	SQL Table	S10B80.SATURN	Refer (no action)
SRTPCOL	SQL Table	S10B80.SATURN	Refer (no action)
SRTSUPL	SQL Table	S10B80.SATURN	Refer (no action)
STVEMPL	SQL Table	S10B80.SATURN	Refer (no action)
AF_VENDOR_VOLUME	SQL View	S10B80.BANINST1	Use (select)
APVADRS	SQL View	S10B80.BANINST1	Use (select)
GOVSVDP	SQL View	S10B80.BANINST1	Use (select)
GOVSVEV	SQL View	S10B80.BANINST1	Use (select)
GOVSVSD	SQL View	S10B80.BANINST1	Use (select)
PAVAPPL	SQL View	S10B80.BANINST1	Use (select)
PEVEMPL	SQL View	S10B80.BANINST1	Use (select)
POVDATA	SQL View	S10B80.BANINST1	Use (select)
PPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVADDR	SQL View	S10B80.BANINST1	Use (select)
RPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVFDRS	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SGVADRS	SQL View	S10B80.BANINST1	Use (select)
SPVADDF	SQL View	S10B80.BANINST1	Use (select)
SPVADDI	SQL View	S10B80.BANINST1	Use (select)
SPVADDS	SQL View	S10B80.BANINST1	Use (select)
SPVADRS	SQL View	S10B80.BANINST1	Use (select)
SPVINTL	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
STVNATV	SQL View	S10B80.BANINST1	Use (select)
F_COMMON_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
ADDRESS_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSPKCOM	Rely On
NATN_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWAKADVS	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWAKJPST	Rely On
GETSTVNATNC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
STVNATNC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVNATNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
STVNATNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
STVNATNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKJPST	Use (select)Rely On
STVNATN_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
P_GENOPTIONSNATN	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_LOOKUPSBGICODE	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
CUR_OF_NATN	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PR_NATN	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
GV_NATION_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_NATION_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_NATION_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_NATION_CODE4	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_NATN_DESC	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOEMR	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
STVNATN_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Rely On
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Use (select)
STVNATNC	Oracle Package Cursor	S10B80.BANINST1.STKNATN	Use (select)Rely On
STVNATNLISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKLIST	Use (select)Rely On
STVNATNLISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
STVNATN_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVNATN	Rely On
STVNATN_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVNATN	Use (select)Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CCPAYMENTSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CC_PAYMENT_STATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_COLLECT_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CREDIT_CARD_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DELETE_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPADDRVIEW	Oracle Package Procedure	S10B80.BANINST1.BWLKOSAD	Rely On
P_DISPADDRVIEW	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_DISPSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_STATUS_OF_ORDER	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_EDIT_SHIP_CODE	Oracle Package Procedure	S10B80.BANINST1.FSKSHIP	Rely On
P_EDIT_SHIP_CODE	Oracle Package Procedure	S10B80.BANINST1.FSKSHIP	Use (select)
P_GET_SOBSBGI_INFO	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP	Use (select)
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_LOAD_INTL	Oracle Package Procedure	S10B80.BANINST1.SAKL030	Rely On
P_LOAD_INTL	Oracle Package Procedure	S10B80.BANINST1.SAKL030	Use (select)
P_LOOKUP_SBGI_CODE	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_MAKE_A_DONATION	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_PROCADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_PURCHASEORDER	Oracle Package Procedure	S10B80.BANINST1.BWFKPURR	Rely On
P_PURCHASEORDER	Oracle Package Procedure	S10B80.BANINST1.BWFKPURR	Use (select)
P_REQUISITION	Oracle Package Procedure	S10B80.BANINST1.BWFKREQN	Rely On
P_REQUISITION	Oracle Package Procedure	S10B80.BANINST1.BWFKREQN	Use (select)
P_UPDATE_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVNATN	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_VALIDATION_DISPLAY	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_VIEWDCSR	Oracle Package Procedure	S10B80.BANINST1.BWFKVDCR	Rely On
P_VIEWINV	Oracle Package Procedure	S10B80.BANINST1.BWFKVINV	Rely On
P_VIEWPUR	Oracle Package Procedure	S10B80.BANINST1.BWFKVPUR	Rely On
P_VIEWREQ	Oracle Package Procedure	S10B80.BANINST1.BWFKVREQ	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_EXPERIENCE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_VISA	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_DRIVER_LICENSE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_BIO	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_CERTIFICATION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EFDTEST	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MISC_HEADER	Use (Insert)
F_CALC_NATION	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVNATN	Rely On
F_DOMESTIC_ADDR	Oracle Package Function	S10B80.BANINST1.SHKPXML	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVNATN	Rely On
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.BWFKVDOC	Rely On
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.BWFKVDOC	Use (select)
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.TTKSELS	Rely On
F_GET_NATN_DESC	Oracle Package Function	S10B80.BANINST1.TTKSELS	Use (select)
F_GET_STVNATN_DESC	Oracle Package Function	S10B80.BANINST1.FRKIDEN	Rely On
F_GET_STVNATN_DESC	Oracle Package Function	S10B80.BANINST1.FRKIDEN	Use (select)
F_OPEN_STVNATN_RC	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Use (select)
F_SORXREF_CHK	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_SORXREF_VAL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
STVNATN	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_STVNATN	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVNATN

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:08:000	04/02/2008 21:17:58:000

Source Code Comments

Nation Validation Table

Columns Comments for STVNATN_CODE (# 1)

Source Code Comments

This field identifies the nation code referenced in the Gen. Person, Admissions, Gen. Student, and Student Billing Modules.

Columns Comments for STVNATN_NATION (# 2)

Source Code Comments

This field specifies the nation/country associated with the nation code.

Columns Comments for STVNATN_CAPITAL (# 3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_AREA (# 4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_POPULATION (# 5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_ACTIVITY_DATE (# 6)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVNATN_EDI_EQUIV (# 7)

Source Code Comments

EDI/SPEEDE country code that equates to the nation code. Refer to the SPEEDE Implementation Guide, Appendix B, data element 26 for valid values.

Columns Comments for STVNATN_LMS_EQUIV (# 8)

Source Code Comments

LMS (IA Plus) nation (country) code that equates to this Banner nation code. Translation to this LMS code occurs during the LMS transaction feed from Banner FA.

Columns Comments for STVNATN_STATSCAN_CDE (# 11)

Source Code Comments

Statistics Canadian specific code.

Columns Comments for STVNATN_SCOD_CODE_ISO (# 12)

Source Code Comments

ISO CODE: The three character International Standards Organization (ISO) Code associated with the user defined nation code.

Columns Comments for STVNATN_SSA_REPORTING_EQUIV (# 13)

Source Code Comments

Social Security Administration country code that equates to the nation code. Refer to the Magnetic Media Reporting and Electronic Filing (MMREF-1) Guide, Appendix C, for valid values.

Columns Comments for STVNATN_SEVIS_EQUIV (# 14)

Source Code Comments

SEVIS EQUIVALENCY: SEVIS code for nation

Table STVSTAT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
STVSTAT_CODE	VARCHAR2(3)	No	*	*
STVSTAT_DESC	VARCHAR2(30)	No
STVSTAT_ACTIVITY_DATE	DATE	No
STVSTAT_EDI_EQUIV	VARCHAR2(2)	Yes
STVSTAT_STATSCAN_CDE	VARCHAR2(5)	Yes
STVSTAT_IPEDS_CDE	VARCHAR2(5)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVSTAT_CODE	SIBFACD_BIRTH_STATE	SIBFACD

Index

Index Name	Index Type	Column Name
PK_STVSTAT	Unique	STVSTAT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
STVSTAT	Oracle Synonym	S10B80.FAISMGR	Rely On
AORCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
AORJPST	SQL Table	S10B80.ALUMNI	Join
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GOBSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVAS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVEI	SQL Table	S10B80.GENERAL	Refer (no action)
GTVZIPC	SQL Table	S10B80.GENERAL	Refer (no action)
GUBINST	SQL Table	S10B80.GENERAL	Refer (no action)
GURAPAY	SQL Table	S10B80.GENERAL	Refer (no action)
PEREEO5	SQL Table	S10B80.PAYROLL	Refer (no action)
PPREXPE	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRERST	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRINST	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRLOCN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRSCHL	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTER	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTIN	SQL Table	S10B80.PAYROLL	Refer (no action)
RHRRQST	SQL Table	S10B80.FAISMGR	Refer (no action)
RJBPLBD	SQL Table	S10B80.FAISMGR	Refer (no action)
RORCAMP	SQL Table	S10B80.FAISMGR	Refer (no action)
RPBLNDR	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLARF	SQL Table	S10B80.FAISMGR	Refer (no action)
SABSUPL	SQL Table	S10B80.SATURN	Refer (no action)
SFRENRL	SQL Table	S10B80.SATURN	Refer (no action)
SHBDIPL	SQL Table	S10B80.SATURN	Refer (no action)
SHBGAPP	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRAN	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRTC	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SMTPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SOBSBGI	SQL Table	S10B80.SATURN	Refer (no action)
SORMSTA	SQL Table	S10B80.SATURN	Refer (no action)
SORT22A	SQL Table	S10B80.SATURN	Refer (no action)
SPBPERS	SQL Table	S10B80.SATURN	Refer (no action)
SPRADDR	SQL Table	S10B80.SATURN	Refer (no action)
SPREMRG	SQL Table	S10B80.SATURN	Refer (no action)
SRTADDR	SQL Table	S10B80.SATURN	Refer (no action)
SRTHSCH	SQL Table	S10B80.SATURN	Refer (no action)
SRTSUPL	SQL Table	S10B80.SATURN	Refer (no action)
STVEMPL	SQL Table	S10B80.SATURN	Refer (no action)
APVADRS	SQL View	S10B80.BANINST1	Use (select)
GOVSVEV	SQL View	S10B80.BANINST1	Use (select)
GOVSVSD	SQL View	S10B80.BANINST1	Use (select)
PAVAPPL	SQL View	S10B80.BANINST1	Use (select)
PEVEMPL	SQL View	S10B80.BANINST1	Use (select)
POVDATA	SQL View	S10B80.BANINST1	Use (select)
PPVADRS	SQL View	S10B80.BANINST1	Use (select)
PPVFACD	SQL View	S10B80.BANINST1	Use (select)
RPVADDR	SQL View	S10B80.BANINST1	Use (select)
RPVADRS	SQL View	S10B80.BANINST1	Use (select)
RPVFDRS	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SGVADRS	SQL View	S10B80.BANINST1	Use (select)
SIVFACD	SQL View	S10B80.BANINST1	Use (select)
SPVADDF	SQL View	S10B80.BANINST1	Use (select)
SPVADDI	SQL View	S10B80.BANINST1	Use (select)
SPVADDS	SQL View	S10B80.BANINST1	Use (select)
SPVADRS	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_GET_STVSTAT_IPEDS_CDE	SQL Function	S10B80.BANINST1	Rely On
F_GET_STVSTAT_IPEDS_CDE	SQL Function	S10B80.BANINST1	Use (select)Rely On
STAT_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKJPST	Rely On
STAT_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKADVS	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKJPST	Rely On
AORJPSTSTATVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKJPST	Use (select)
GETSTVSTATC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
STVSTATC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVSTATVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
STVSTATVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
STVSTATVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)Rely On
STVSTATVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKJPST	Use (select)Rely On
STVSTAT_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
STVSTAT_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
P_GENOPTIONSSTAT	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_LOOKUPSBGICODE	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
ACAD_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWCKGSTU	Rely On
GV_STAT_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_STAT_DESC	Oracle Package Variable	S10B80.BANINST1.BWSKRQST	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOEMR	Rely On
STVSTAT_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
F_GET_STAT_DESC	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Rely On
F_GET_STAT_DESC	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Use (select)
STVSTATC	Oracle Package Cursor	S10B80.BANINST1.STKSTAT	Use (select)Rely On
STVSTATLISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKLIST	Use (select)Rely On
STVSTATLISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
STVSTAT_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVSTAT	Rely On
STVSTAT_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVSTAT	Use (select)Rely On
P_COLLECT_CREDIT_CARD_INFO	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWAKCPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKAPMT	Rely On
P_CREDITCARDPAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCPMT	Rely On
P_CREDIT_CARD_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWCCP	Rely On
P_DELETE_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPADDRVIEW	Oracle Package Procedure	S10B80.BANINST1.BWLKOSAD	Rely On
P_DISPADDRVIEW	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_DISPSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_CONFIRM	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_STATUS_OF_ORDER	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_INSERT_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_LOOKUP_SBGI_CODE	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_MAKE_A_DONATION	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_PROCADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_UPDATE_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVSTAT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALADDRUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_VALIDATION_DISPLAY	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_EXPERIENCE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_DRIVER_LICENSE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_HOUSING_PROFILE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_BIO	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_CERTIFICATION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_ADDRESS	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_ENTITY_ADDRESS	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MISC_HEADER	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVSTAT	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVSTAT	Rely On
F_GET_STAT_DESC	Oracle Package Function	S10B80.BANINST1.TTKSELS	Rely On
F_GET_STAT_DESC	Oracle Package Function	S10B80.BANINST1.TTKSELS	Use (select)
STVSTAT	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_STVSTAT	SQL Index	S10B80.SATURN	Rely On
SIBFACD	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVSTAT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:10:000	04/02/2008 21:17:58:000

Source Code Comments

State Code Validation Table

Columns Comments for STVSTAT_CODE (# 1)

Source Code Comments

This field identifies the state code referenced in the Gen. Person, Admissions, Gen. Student, Student Billing, and Academic History Modules.

Columns Comments for STVSTAT_DESC (# 2)

Source Code Comments

This field specifies the state associated with the state code.

Columns Comments for STVSTAT_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date a record was created or deleted.

Columns Comments for STVSTAT_EDI_EQUIV (# 4)

Source Code Comments

This is the state equivalent code EDI will use for electronic transcripts for the BANNER2 state code matched on column STVSTAT_CODE.

Columns Comments for STVSTAT_STATSCAN_CDE (# 5)

Source Code Comments

Statistics Canadian specific code.

Columns Comments for STVSTAT_IPEDS_CDE (# 6)

Source Code Comments

Free format code for Student IPEDS reporting.

Link between RJRSEAR and RTVAUST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJRSEAR and RTVAUST (FK1_RJRSEAR_INV_RTVAUST_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJRSEAR	RJRSEAR_AUST_CODE	RTVAUST_CODE	RTVAUST	(1,1)-(0,n)

Link between RORSAPR and RTVSAPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RORSAPR and RTVSAPR (FK1_RORSAPR_INV_RTVSAPR_CODE)	FAISMGR
Refer (no action)	Link Informative Foreign Key Between RORSAPR and RTVSAPR (FK2_RORSAPR_INV_RTVSAPR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSAPR	RORSAPR_SAPR_CODE	RTVSAPR_CODE	RTVSAPR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSAPR	RORSAPR_SAPR_CODE_CALC	RTVSAPR_CODE	RTVSAPR	(0,1)-(0,n)

Link between RJRPLRL and RJBPLBD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJRPLRL and RJBPLBD (FK1_RJRPLRL_INV_RJBPLBD_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJRPLRL	RJRPLRL_PLACE_CDE	RJBPLBD_PLACE_CDE	RJBPLBD	(1,1)-(0,n)

Link between RORSTRF and RTVSAPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RORSTRF and RTVSAPR (FK1_RORSTRF_INV_RTVSAPR_CODE)	FAISMGR
Refer (no action)	Link Informative Foreign Key Between RORSTRF and RTVSAPR (FK2_RORSTRF_INV_RTVSAPR_CODE)	FAISMGR
Refer (no action)	Link Informative Foreign Key Between RORSTRF and RTVSAPR (FK3_RORSTRF_INV_RTVSAPR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSTRF	RORSTRF_SAPR_CODE_PREV	RTVSAPR_CODE	RTVSAPR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSTRF	RORSTRF_SAPR_CODE_CALC	RTVSAPR_CODE	RTVSAPR	(1,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSTRF	RORSTRF_SAPR_CODE_NEW	RTVSAPR_CODE	RTVSAPR	(1,1)-(0,n)

Link between RJBSEDR and RTVAUST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJBSEDR and RTVAUST (FK1_RJBSEDR_INV_RTVAUST_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJBSEDR	RJBSEDR_AUST_CODE	RTVAUST_CODE	RTVAUST	(1,1)-(0,n)

Link between RJRSERF and RTVRFST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJRSERF and RTVRFST (FK1_RJRSERF_INV_RTVRFST_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJRSERF	RJRSERF_RFST_CODE	RTVRFST_CODE	RTVRFST	(1,1)-(0,n)

Link between RPRATRM and RFRBASE

Join Information

Objects list
schema-function : S10B80.BANINST1.F_FA_AMT_YEAR_FNC schema-function : S10B80.BANINST1.F_INST_AID_FNC schema-function : S10B80.BANINST1.F_FA_AMT_TERM_FNC scope-procedure : S10B80.BANINST1.ROKWEXT.P_BUILDROTWFAE scope-function : S10B80.BANINST1.RPK_DISB_VALIDATION_US.F_VAL_PELL_AUTHORIZATION

Link List

Link Type	Link	Project
Join	Link Between RPRATRM and RFRBASE	FAISMGR

List of Real links

Link type	Between	And
Join	RPRATRM	RFRBASE

Link between RORENRL and RPRATRM

Join Information

Objects list
schema-view : S10B80.BANINST1.RPVAWT2

Link List

Link Type	Link	Project
Join	Link Between RORENRL and RPRATRM	FAISMGR

List of Real links

Link type	Between	And
Join	RORENRL	RPRATRM

Link between RFRBASE and RJRSEAR

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWRCBREF.C_GET_FUND_CODE

Link List

Link Type	Link	Project
Join	Link Between RFRBASE and RJRSEAR	FAISMGR

List of Real links

Link type	Between	And
Join	RFRBASE	RJRSEAR

Link between RJBPLBD and RJRSEAR

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWRCBREF.C_GET_AUTH_DATA scope-function : S10B80.BANINST1.BWRCBREF.F_GET_DIR_LIST

Link List

Link Type	Link	Project
Join	Link Between RJBPLBD and RJRSEAR	FAISMGR

List of Real links

Link type	Between	And
Join	RJBPLBD	RJRSEAR

Link between RORSTRF and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RORSTRF and GTVLETR (FK4_RORSTRF_INV_GTVLETR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RORSTRF	RORSTRF_LETR_CODE	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between RTVSAPR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RTVSAPR and GTVLETR (FK1_RTVSAPR_INV_GTVLETR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RTVSAPR	RTVSAPR_LETR_CODE	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between RJBPLBD and STVNATN

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJBPLBD and STVNATN (FK1_RJBPLBD_INV_STVNATN_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJBPLBD	RJBPLBD_NATN_CODE	STVNATN_CODE	STVNATN	(0,1)-(0,n)

Link between RJBPLBD and STVSTAT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RJBPLBD and STVSTAT (FK1_RJBPLBD_INV_STVSTAT_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RJBPLBD	RJBPLBD_STAT_CODE	STVSTAT_CODE	STVSTAT	(0,1)-(0,n)