Model History and Transcripts

Model Label : Banner Financial Aid History and Transcripts Module

List of Objects

Object Name	Object Type	Layer Name
RHBDFLT	SQL Table	Default
RHBTINF	SQL Table	Default
RHBTRNS	SQL Table	Default
RHRAWRD	SQL Table	Default
RHRCOMM	SQL Table	Default
RHRFUND	SQL Table	Default
RHRLOAN	SQL Table	Default
RHRPCMT	SQL Table	Default
RHRPCOL	SQL Table	Default
RHRRQST	SQL Table	Default
RHRTCMT	SQL Table	Default
RTVCCOM	SQL Table	Default
STVATYP	SQL Table	Default
STVSBGI	SQL Table	Default
STVSTAT	SQL Table	Default

Model View

Table RHBDFLT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RHBDFLT_REQUESTOR_NAME	VARCHAR2(30)	No
RHBDFLT_REQUESTOR_TITLE	VARCHAR2(30)	No
RHBDFLT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHBDFLT

Object Dates

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

Source Code Comments

Transcript Default Table

Columns Comments for RHBDFLT_REQUESTOR_NAME (# 1)

Source Code Comments

DEFAULT SIGNED NAME: The default for the typed name which should appear on outgoing Financial Aid Transcripts. Can be overridden on the Transcript Request Form (RHARQST).

Columns Comments for RHBDFLT_REQUESTOR_TITLE (# 2)

Source Code Comments

SIGNED NAME TITLE: The default for the title associated with the typed name which should appear on outgoing Financial Aid Transcripts. Can be overridden on the Transcript Request Form (RHARQST).

Columns Comments for RHBDFLT_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table RHBTINF

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RHBTINF_PIDM	NUMBER(8,0)	No	*
RHBTINF_ACTIVITY_DATE	DATE	No
RHBTINF_NO_AID_IND	VARCHAR2(1)	Yes
RHBTINF_NO_RECORD_IND	VARCHAR2(1)	Yes
RHBTINF_NDSL_BAL_IND	VARCHAR2(1)	Yes
RHBTINF_PELL_SEOG_RFND_IND	VARCHAR2(1)	Yes
RHBTINF_PERK_DFLT_IND	VARCHAR2(1)	Yes
RHBTINF_SSIG_RFND_IND	VARCHAR2(1)	Yes
RHBTINF_GSL_DFLT_IND	VARCHAR2(1)	Yes
RHBTINF_NO_AID_OR_REC_IND	VARCHAR2(1)	Yes
RHBTINF_FPERK_ELO_STY_ABRD_IND	VARCHAR2(1)	Yes
RHBTINF_FPERK_BAL_1992_IND	VARCHAR2(1)	Yes
RHBTINF_FPERK_DFLT_BKRUPT_IND	VARCHAR2(1)	Yes
RHBTINF_FFEL_DFLT_BKRUPT_IND	VARCHAR2(1)	Yes
RHBTINF_ADDITIONAL_UNSUB_IND	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RHBTINF	Unique	RHBTINF_PIDM

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_RHBTINF	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHBTINF

Object Dates

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

Source Code Comments

Institution Transcript Information Table

Columns Comments for RHBTINF_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RHBTINF_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for RHBTINF_NO_AID_IND (# 3)

Source Code Comments

NO AID INDICATOR: This indicator defines whether the student has had Title IV assistance at this institution. This indicator, if present, will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_NO_RECORD_IND (# 4)

Source Code Comments

NO RECORD INDICATOR: This indicator defines whether the institution still has financial aid records for this student. This indicator, if present, will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_NDSL_BAL_IND (# 5)

Source Code Comments

NDSL BALANCE INDICATOR: This indicator is used to identify if the student had a prior balance on an NDSL loan prior to July 1, 1987. This indicator, if present will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_PELL_SEOG_RFND_IND (# 6)

Source Code Comments

PELL or SEOG REFUND INDICATOR: This field indicates whether the student owes a refund on PELL or SEOG. This indicator, if present, will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_PERK_DFLT_IND (# 7)

Source Code Comments

PERKINS DEFAULT INDICATOR: This field indicates whether the student is in default on a Perkins Loan, NDSL, or ICL (Income Contingent Loan at this institution. This indicator, if present, will print on outgoing FAT's.

Columns Comments for RHBTINF_SSIG_RFND_IND (# 8)

Source Code Comments

SSIG REFUND INDICATOR: This field indicates whether the student owes a refund on SSIG received at this institution. This indicator, if present, will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_GSL_DFLT_IND (# 9)

Source Code Comments

GSL DEFAULT INDICATOR:This field indicates whether the student is in default on a GSL, FISL, SLS, PLUS, or on a Consolidation Loan. This indicator, if present will print on outgoing Financial Aid Transcripts.

Columns Comments for RHBTINF_FPERK_ELO_STY_ABRD_IND (# 11)

Source Code Comments

Indicates the student received increased Federal Perkins Loan/NDSL at this institution due to the Expanded Lending Option or study abroad.

Columns Comments for RHBTINF_FPERK_BAL_1992_IND (# 12)

Source Code Comments

Indicates the student had an outstanding balance on a Federal Perkins Loan/NDSL at this institution on October 1, 1992, which is still outstanding.

Columns Comments for RHBTINF_FPERK_DFLT_BKRUPT_IND (# 13)

Source Code Comments

Indicates that the institution is aware that the defaulted Federal Perkins Loan/NDSL/ICL has been discharged in bankruptcy.

Columns Comments for RHBTINF_FFEL_DFLT_BKRUPT_IND (# 14)

Source Code Comments

Indicates that the institution is aware that the defaulted FFEL or FDSL has been discharged in bankruptcy.

Columns Comments for RHBTINF_ADDITIONAL_UNSUB_IND (# 15)

Source Code Comments

Indicates the student got additional unsubsidized Fed Stafford/Direct Stafford/Ford funds at this institution.

Table RHBTRNS

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHBTRNS_PIDM	NUMBER(8,0)	No	*
RHBTRNS_SEQ_NO	NUMBER(2,0)	No	*
RHBTRNS_AIDY_CODE	VARCHAR2(4)	No		*
RHBTRNS_ACTIVITY_DATE	DATE	No
RHBTRNS_SBGI_CODE	VARCHAR2(6)	Yes		*
RHBTRNS_NAME	VARCHAR2(30)	Yes
RHBTRNS_ATTEND_FROM	VARCHAR2(11)	Yes
RHBTRNS_ATTEND_TO	VARCHAR2(11)	Yes
RHBTRNS_NO_AID_IND	VARCHAR2(1)	Yes
RHBTRNS_NO_RECORD_IND	VARCHAR2(1)	Yes
RHBTRNS_FIRST_START	VARCHAR2(9)	Yes
RHBTRNS_FIRST_END	VARCHAR2(9)	Yes
RHBTRNS_CURR_START	VARCHAR2(2)	Yes
RHBTRNS_CURR_END	VARCHAR2(2)	Yes
RHBTRNS_PREV_START	VARCHAR2(2)	Yes
RHBTRNS_PREV_END	VARCHAR2(2)	Yes
RHBTRNS_NDSL_BAL_IND	VARCHAR2(1)	Yes
RHBTRNS_PELL_SEOG_RFND_IND	VARCHAR2(1)	Yes
RHBTRNS_PERK_DFLT_IND	VARCHAR2(1)	Yes
RHBTRNS_GSL_DFLT_IND	VARCHAR2(1)	Yes
RHBTRNS_SSIG_RFND_IND	VARCHAR2(1)	Yes
RHBTRNS_FPERK_ELO_STY_ABRD_IND	VARCHAR2(1)	Yes
RHBTRNS_FPERK_BAL_1992_IND	VARCHAR2(1)	Yes
RHBTRNS_FPERK_DFLT_BKRUPT_IND	VARCHAR2(1)	Yes
RHBTRNS_FFEL_DFLT_BKRUPT_IND	VARCHAR2(1)	Yes
RHBTRNS_ADDITIONAL_UNSUB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHBTRNS_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RHBTRNS_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_RHBTRNS	Unique	RHBTRNS_PIDM
PK_RHBTRNS	Unique	RHBTRNS_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RHRAWRD	SQL Table	S10B80.FAISMGR	Refer (no action)
RHRLOAN	SQL Table	S10B80.FAISMGR	Refer (no action)
RHRPCMT	SQL Table	S10B80.FAISMGR	Refer (no action)
RHRPCOL	SQL Table	S10B80.FAISMGR	Refer (no action)
ROVPCOL	SQL View	S10B80.BANINST1	Use (select)
RHBTRNS	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_RHBTRNS	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHBTRNS

Object Dates

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

Source Code Comments

Prior Institution Transcript Base Table

Columns Comments for RHBTRNS_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHBTRNS_SEQ_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: Represents the system maintained counter for Financial Aid Transcripts.

Columns Comments for RHBTRNS_AIDY_CODE (# 3)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. Examples: 9091, 9192, 9293, etc.

Columns Comments for RHBTRNS_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for RHBTRNS_SBGI_CODE (# 5)

Source Code Comments

SOURCE BACKGROUND INFORMATION CODE: This code represents the institution for which the incoming Financial Aid Transcript is received.

Columns Comments for RHBTRNS_NAME (# 6)

Source Code Comments

STUDENT NAME: This field shows the students name as reported on the incoming FAT.

Columns Comments for RHBTRNS_ATTEND_FROM (# 7)

Source Code Comments

ATTEND FROM: This field represents the beginning date of enrollment at the institution in which the FAT is received from.

Columns Comments for RHBTRNS_ATTEND_TO (# 8)

Source Code Comments

ATTEND TO: This field represents the ending date of enrollment at the institution in which the FAT is received from.

Columns Comments for RHBTRNS_NO_AID_IND (# 9)

Source Code Comments

NO AID INDICATOR: This field indicates that a student neither received nor benefited from any Title IV aid while attending the institution reported on the FAT.

Columns Comments for RHBTRNS_NO_RECORD_IND (# 10)

Source Code Comments

NO RECORD INDICATOR: This field indicates that the institution no longer has records or is required to keep records for a student from the institution reported on the FAT.

Columns Comments for RHBTRNS_FIRST_START (# 11)

Source Code Comments

FIRST START YEAR: This field represents the first award year that a student received Title IV aid at the institution reported on the FAT.

Columns Comments for RHBTRNS_FIRST_END (# 12)

Source Code Comments

FIRST END YEAR: This field is the first award year that a student received Title IV aid at the institution reported on the incoming FAT.

Columns Comments for RHBTRNS_CURR_START (# 13)

Source Code Comments

CURRENT START YEAR: This field is the current start year that an independent student received Title IV aid as reported on an incoming FAT.

Columns Comments for RHBTRNS_CURR_END (# 14)

Source Code Comments

CURRENT END YEAR: This field is the current year end that an independent student received Title IV aid as reported on an incoming FAT.

Columns Comments for RHBTRNS_PREV_START (# 15)

Source Code Comments

PREVIOUS START YEAR: This field identifies the previous start award year that a student received Title IV aid as an independent student at the institution reported on the FAT.

Columns Comments for RHBTRNS_PREV_END (# 16)

Source Code Comments

PREVIOUS END YEAR: This field identifies the previous end award year that a student received Title IV aid as an independent student at the institution reported on the FAT.

Columns Comments for RHBTRNS_NDSL_BAL_IND (# 17)

Source Code Comments

NDSL BALANCE INDICATOR: This field indicates whether a student had an outstanding balance on an NDSL at the institution reported on the FAT as of July 1, 1987.

Columns Comments for RHBTRNS_PELL_SEOG_RFND_IND (# 18)

Source Code Comments

PELL/SEOG REFUND INDICATOR: This field indicates that a student owes a refund on a Pell Grant or SEOG at the institution reported on the FAT.

Columns Comments for RHBTRNS_PERK_DFLT_IND (# 19)

Source Code Comments

PERKINS DEFAULT INDICATOR: This field indicates that the student is on default on a Perkins Loan or Income Contingent Loan at the institution reported on the FAT.

Columns Comments for RHBTRNS_GSL_DFLT_IND (# 20)

Source Code Comments

GSL DEFAULT INDICATOR: This field indicates that the institution knew that the student was in default on a GSL, FISL, SLS, or PLUS at the institution reported on the incoming FAT.

Columns Comments for RHBTRNS_SSIG_RFND_IND (# 21)

Source Code Comments

SSIG REFUND INDICATOR: This field identifies whether the student owes a refund on SSIG.

Columns Comments for RHBTRNS_FPERK_ELO_STY_ABRD_IND (# 22)

Source Code Comments

Indicates if the student previously received increased Federal Perkins Loan/NDSL due to the Expanded Lending Option or study abroad.

Columns Comments for RHBTRNS_FPERK_BAL_1992_IND (# 23)

Source Code Comments

Indicates if the student had an outstanding balance on a Federal Perkins Loan/NDSL at another institution on October 1, 1992, which is still outstanding.

Columns Comments for RHBTRNS_FPERK_DFLT_BKRUPT_IND (# 24)

Source Code Comments

Indicates if the previous institution was aware that the defaulted Federal Perkins Loan/NDSL/ICL has been discharged in bankruptcy.

Columns Comments for RHBTRNS_FFEL_DFLT_BKRUPT_IND (# 25)

Source Code Comments

Indicates if the previous institution was aware that the defaulted FFEL or FDSL has been discharged in bankruptcy.

Columns Comments for RHBTRNS_ADDITIONAL_UNSUB_IND (# 26)

Source Code Comments

Indicates the student got additional unsubsidized Fed Stafford/Direct Stafford/Ford funds at this institution.

Table RHRAWRD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHRAWRD_PIDM	NUMBER(8,0)	No	*	*
RHRAWRD_TRNS_SEQ_NO	NUMBER(2,0)	No	*	*
RHRAWRD_FUND_CODE	VARCHAR2(6)	No	*
RHRAWRD_ACTIVITY_DATE	DATE	No
RHRAWRD_CURRENT_YEAR	NUMBER(11,2)	Yes
RHRAWRD_CUM_TOTAL	NUMBER(11,2)	Yes
RHRAWRD_DISBURSE_TOTAL	NUMBER(11,2)	Yes
RHRAWRD_SCHEDULE_AWARD	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRAWRD_PIDM	RHBTRNS_PIDM	RHBTRNS
RHRAWRD_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS

Index

Index Name	Index Type	Column Name
PK_RHRAWRD	Unique	RHRAWRD_PIDM
PK_RHRAWRD	Unique	RHRAWRD_TRNS_SEQ_NO
PK_RHRAWRD	Unique	RHRAWRD_FUND_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_RHRAWRD	SQL Index	S10B80.FAISMGR	Rely On
RHBTRNS	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRAWRD

Object Dates

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

Source Code Comments

Prior Institution Transcript Award Table

Columns Comments for RHRAWRD_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHRAWRD_TRNS_SEQ_NO (# 2)

Source Code Comments

TRANSCRIPT SEQUENCE NUMBER: The system generated sequence number associated with a specific Financial Aid Transcript.

Columns Comments for RHRAWRD_FUND_CODE (# 3)

Source Code Comments

FUND CODE: tThe fund code assigned to the various types of aid reported on the incoming Financial Aid Transcript.

Columns Comments for RHRAWRD_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for RHRAWRD_CURRENT_YEAR (# 5)

Source Code Comments

CURRENT YEAR: The current year amount of aid received by the student as reported on a Financial Aid Transcript for each specific fund code.

Columns Comments for RHRAWRD_CUM_TOTAL (# 6)

Source Code Comments

CUMULATIVE TOTAL: The cumulative total aid reported on a Financial Aid Transcript for each specific fund code.

Columns Comments for RHRAWRD_DISBURSE_TOTAL (# 7)

Source Code Comments

TOTAL DISBURSEMENT AMOUNT: The amount of aid which has actually been disbursed as reported on a Financial Aid Transcript for various fund codes.

Columns Comments for RHRAWRD_SCHEDULE_AWARD (# 8)

Source Code Comments

SCHEDULED AWARD: The amount of aid which has been scheduled for a student from a prior institution but which has not yet been disbursed as reported on the incoming Financial Aid Transcript.

Table RHRCOMM

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHRCOMM_PIDM	NUMBER(8,0)	No	*
RHRCOMM_SEQNO	NUMBER(23,20)	No	*
RHRCOMM_USER_ID	VARCHAR2(30)	No
RHRCOMM_ACTIVITY_DATE	DATE	No
RHRCOMM_ORIG_DATE	DATE	No
RHRCOMM_AIDY_CODE	VARCHAR2(4)	Yes		*
RHRCOMM_COMMENT	VARCHAR2(4000)	Yes
RHRCOMM_CATEGORY_CODE	VARCHAR2(7)	Yes		*
RHRCOMM_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRCOMM_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RHRCOMM_CATEGORY_CODE	RTVCCOM_CODE	RTVCCOM

Index

Index Name	Index Type	Column Name
PK_RHRCOMM	Unique	RHRCOMM_PIDM
PK_RHRCOMM	Unique	RHRCOMM_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APPLICANT_COMMENT_REC	Oracle Package Type	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
CALC_CMNT_IND	Oracle Package Cursor	S10B80.BANINST1.ROKSUMM	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
F_BUILD_RHRCOMM_REC	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_RHRCOMM	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_RHRCOMM	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_RHRCOMM	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_APPLICANT_COMMENT_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_APPLICANT_COMMENT	Use (select)
RHRCOMM	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_RHRCOMM	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCCOM	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRCOMM

Object Dates

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

Source Code Comments

Applicants Comments

Columns Comments for RHRCOMM_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RHRCOMM_SEQNO (# 2)

Source Code Comments

SEQUENCE NUMBER: The system-generated sequence number assigned to the comment in this record.

Columns Comments for RHRCOMM_USER_ID (# 3)

Source Code Comments

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

Columns Comments for RHRCOMM_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for RHRCOMM_ORIG_DATE (# 5)

Source Code Comments

ORIGINAL DATE: The date that the original comment was entered on the student's record.

Columns Comments for RHRCOMM_AIDY_CODE (# 6)

Source Code Comments

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

Columns Comments for RHRCOMM_COMMENT (# 7)

Source Code Comments

COMMENT: The comments associated with the student's record.

Columns Comments for RHRCOMM_CATEGORY_CODE (# 8)

Source Code Comments

CATEGORY CODE: The category code for applicant comments.

Columns Comments for RHRCOMM_DATA_ORIGIN (# 9)

Source Code Comments

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

Table RHRFUND

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RHRFUND_FUND_CODE	VARCHAR2(6)	No	*
RHRFUND_ACTIVITY_DATE	DATE	No
RHRFUND_ACCEPT_IND	VARCHAR2(1)	No
RHRFUND_PAID_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RHRFUND	Unique	RHRFUND_FUND_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_RHRFUND	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRFUND

Object Dates

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

Source Code Comments

Transcript Rules Table

Columns Comments for RHRFUND_FUND_CODE (# 1)

Source Code Comments

FUND CODE: The fund codes which will be included on the institutions Financial Aid Transcript.

Columns Comments for RHRFUND_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for RHRFUND_ACCEPT_IND (# 3)

Source Code Comments

ACCEPT INDICATOR: This field defines whether the accepted amount for the fund will be reported on the institutions Financial Aid Transcript.

Columns Comments for RHRFUND_PAID_IND (# 4)

Source Code Comments

PAID INDICATOR: This field defines whether the actual disbursements for the fund will be reported on the institutions Financial Aid Transcript.

Table RHRLOAN

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHRLOAN_PIDM	NUMBER(8,0)	No	*	*
RHRLOAN_TRNS_SEQ_NO	NUMBER(2,0)	No	*	*
RHRLOAN_FUND_CODE	VARCHAR2(6)	No	*
RHRLOAN_FROM_PERIOD	VARCHAR2(11)	No	*
RHRLOAN_TO_PERIOD	VARCHAR2(11)	No	*
RHRLOAN_LOAN_TOTAL	NUMBER(11,2)	No
RHRLOAN_ACTIVITY_DATE	DATE	No
RHRLOAN_GRADE_LEVEL	VARCHAR2(1)	Yes
RHRLOAN_CUM_LOAN_TOTAL	NUMBER(11,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRLOAN_PIDM	RHBTRNS_PIDM	RHBTRNS
RHRLOAN_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS

Index

Index Name	Index Type	Column Name
PK_RHRLOAN	Unique	RHRLOAN_PIDM
PK_RHRLOAN	Unique	RHRLOAN_TRNS_SEQ_NO
PK_RHRLOAN	Unique	RHRLOAN_FUND_CODE
PK_RHRLOAN	Unique	RHRLOAN_FROM_PERIOD
PK_RHRLOAN	Unique	RHRLOAN_TO_PERIOD

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_RHRLOAN	SQL Index	S10B80.FAISMGR	Rely On
RHBTRNS	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRLOAN

Object Dates

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

Source Code Comments

Prior Institution Transcript Loan Table

Columns Comments for RHRLOAN_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHRLOAN_TRNS_SEQ_NO (# 2)

Source Code Comments

TRANSCRIPT SEQUENCE NUMBER: The system generated sequence number associated with a specific Financial Aid Transcript.

Columns Comments for RHRLOAN_FUND_CODE (# 3)

Source Code Comments

FUND CODE: The code associated with the specific type of aid as reported on an incoming Financial Aid Transcript.

Columns Comments for RHRLOAN_FROM_PERIOD (# 4)

Source Code Comments

FROM PERIOD: The beginning period of the loan associated with a fund code reported from prior institution on a Financial Aid Transcript.

Columns Comments for RHRLOAN_TO_PERIOD (# 5)

Source Code Comments

LOAN TO PERIOD: The ending loan period associated with the specific fund code as reported on an incoming Financial Aid Transcript.

Columns Comments for RHRLOAN_LOAN_TOTAL (# 6)

Source Code Comments

LOAN TOTAL: The total amount of loan associated with the specific fund code and loan period as reported on an incoming Financial Aid Transcript.

Columns Comments for RHRLOAN_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for RHRLOAN_GRADE_LEVEL (# 8)

Source Code Comments

This is the student's grade level code for the loan application.

Columns Comments for RHRLOAN_CUM_LOAN_TOTAL (# 9)

Source Code Comments

The cumulative amount of loan borrowed at prior institution.

Table RHRPCMT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHRPCMT_PIDM	NUMBER(8,0)	No	*	*
RHRPCMT_TRNS_SEQ_NO	NUMBER(2,0)	No	*
RHRPCMT_SEQ_NO	NUMBER(6,3)	No	*	*
RHRPCMT_COMMENT	VARCHAR2(65)	No
RHRPCMT_USER_ID	VARCHAR2(30)	No
RHRPCMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRPCMT_PIDM	RHBTRNS_PIDM	RHBTRNS
RHRPCMT_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS

Index

Index Name	Index Type	Column Name
PK_RHRPCMT	Unique	RHRPCMT_PIDM
PK_RHRPCMT	Unique	RHRPCMT_TRNS_SEQ_NO
PK_RHRPCMT	Unique	RHRPCMT_SEQ_NO

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_RHRPCMT	SQL Index	S10B80.FAISMGR	Rely On
RHBTRNS	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRPCMT

Object Dates

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

Source Code Comments

Prior Institution Transcript Comment Table

Columns Comments for RHRPCMT_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number of the student in this record.

Columns Comments for RHRPCMT_TRNS_SEQ_NO (# 2)

Source Code Comments

TRANSCRIPT SEQUENCE NUMBER: The sequence number assigned to the transcript.

Columns Comments for RHRPCMT_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: A system-generated sequence number assigned to the comment in this record.

Columns Comments for RHRPCMT_COMMENT (# 4)

Source Code Comments

COMMENT: This field maintains potential comments which may come in on a in-coming Financial Aid Transcript associated with the applicant in this record.

Columns Comments for RHRPCMT_USER_ID (# 5)

Source Code Comments

USER ID: This field represents the user ID of the user who created the comment.

Columns Comments for RHRPCMT_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table RHRPCOL

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
RHRPCOL_PIDM	NUMBER(8,0)	No	*
RHRPCOL_TRNS_SEQ_NO	NUMBER(2,0)	No	*
RHRPCOL_ACTIVITY_DATE	DATE	No
RHRPCOL_SBGI_CODE	VARCHAR2(6)	Yes	*
RHRPCOL_NAME	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRPCOL_PIDM	RHBTRNS_PIDM	RHBTRNS
RHRPCOL_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS
RHRPCOL_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
RHRPCOL_KEY_INDEX		RHRPCOL_PIDM
RHRPCOL_KEY_INDEX		RHRPCOL_TRNS_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROVPCOL	SQL View	S10B80.BANINST1	Use (select)
RHRPCOL	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
RHRPCOL_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RHBTRNS	SQL Table	S10B80.FAISMGR	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRPCOL

Object Dates

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

Source Code Comments

Prior Institution Transcript Prior College Table

Columns Comments for RHRPCOL_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHRPCOL_TRNS_SEQ_NO (# 2)

Source Code Comments

TRANSCRIPT SEQUENCE NUMBER: A system-generated sequence number associated with a incoming Financial Aid Transcript.

Columns Comments for RHRPCOL_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for RHRPCOL_SBGI_CODE (# 4)

Source Code Comments

SOURCE BACKGROUND INFORMATION CODE: The code associated with the prior institution in which a student has attended as reported on an incoming Financial Aid Transcript.

Columns Comments for RHRPCOL_NAME (# 5)

Source Code Comments

INSTITUTION NAME: The name of the prior institution attended as associated with the SBGI code.

Table RHRRQST

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RHRRQST_USER	VARCHAR2(30)	No	*
RHRRQST_PIDM	NUMBER(8,0)	No	*
RHRRQST_SEQ_NO	NUMBER(2,0)	No	*
RHRRQST_REQUEST_DATE	DATE	No
RHRRQST_REQUESTOR_NAME	VARCHAR2(30)	No
RHRRQST_REQUESTOR_TITLE	VARCHAR2(30)	No
RHRRQST_ACTIVITY_DATE	DATE	No
RHRRQST_SBGI_CODE	VARCHAR2(6)	Yes		*
RHRRQST_ATYP_CODE	VARCHAR2(2)	Yes		*
RHRRQST_ADDR_SEQ_NO	NUMBER(2,0)	Yes
RHRRQST_PRINT_DATE	DATE	Yes
RHRRQST_ADDR_NAME	VARCHAR2(30)	Yes
RHRRQST_STREET1	VARCHAR2(30)	Yes
RHRRQST_STREET2	VARCHAR2(30)	Yes
RHRRQST_STREET3	VARCHAR2(30)	Yes
RHRRQST_CITY	VARCHAR2(18)	Yes
RHRRQST_STAT_CODE	VARCHAR2(3)	Yes		*
RHRRQST_ZIP	VARCHAR2(10)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RHRRQST_STAT_CODE	STVSTAT_CODE	STVSTAT
RHRRQST_ATYP_CODE	STVATYP_CODE	STVATYP
RHRRQST_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_RHRRQST	Unique	RHRRQST_PIDM
PK_RHRRQST	Unique	RHRRQST_USER
PK_RHRRQST	Unique	RHRRQST_SEQ_NO

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_RHRRQST	SQL Index	S10B80.FAISMGR	Rely On
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRRQST

Object Dates

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

Source Code Comments

Transcript Request Table

Columns Comments for RHRRQST_USER (# 1)

Source Code Comments

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

Columns Comments for RHRRQST_PIDM (# 2)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHRRQST_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: The system-generated sequence number assigned to a particular Financial Aid Transcript request.

Columns Comments for RHRRQST_REQUEST_DATE (# 4)

Source Code Comments

REQUEST DATE: The date that the Financial Aid Transcript was requested for a particular institution.

Columns Comments for RHRRQST_REQUESTOR_NAME (# 5)

Source Code Comments

REQUESTOR NAME: The typed name which appears on the outgoing FAT defaulted from RHBDFLT.

Columns Comments for RHRRQST_REQUESTOR_TITLE (# 6)

Source Code Comments

REQUESTOR TITLE: The title associated with the typed name appearing on the outgoing FAT defaulted from RHBDFLT.

Columns Comments for RHRRQST_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for RHRRQST_SBGI_CODE (# 8)

Source Code Comments

SOURCE BACKGROUND INFORMATION CODE: The code associated with the institution w re the Financial Aid Transcript will be or was sent. The code can be left blank if a manual address will be added.

Columns Comments for RHRRQST_ATYP_CODE (# 9)

Source Code Comments

ADDRESS TYPE CODE: The address code for the address which the institution wishes to report for a student on an outgoing Financial Aid Transcript.

Columns Comments for RHRRQST_ADDR_SEQ_NO (# 10)

Source Code Comments

ADDRESS SEQUENCE NUMBER: This field identifies a sequence of addresses within an address type.

Columns Comments for RHRRQST_PRINT_DATE (# 11)

Source Code Comments

PRINT DATE: The date the actual Financial Aid Transcript was printed.

Columns Comments for RHRRQST_ADDR_NAME (# 12)

Source Code Comments

ADDRESS NAME: The name of the institution where the Financial Aid Transcript will be or was sent defaulted from the SBGI table. This field can be entered.

Columns Comments for RHRRQST_STREET1 (# 13)

Source Code Comments

STREET1: Street address defaulted from the SBGI table. This field can be manually entered if the SBGI code is left blank.

Columns Comments for RHRRQST_STREET2 (# 14)

Source Code Comments

STREET2: An additional street address of the institution defaulted from the SBGI table. This field can be manually entered if the SBGI code is left blank.

Columns Comments for RHRRQST_STREET3 (# 15)

Source Code Comments

STREET3: An additional street address of the institution defaulted from the SBGI table. This field can be manually entered if the SBGI code is left blank.

Columns Comments for RHRRQST_CITY (# 16)

Source Code Comments

CITY: The city associated with the institution where the Financial Aid Transcript will be or was mailed defaulted from the SBGI table. This field can be manually entered.

Columns Comments for RHRRQST_STAT_CODE (# 17)

Source Code Comments

STATE CODE: The abbreviation for the state where the Financial Aid Transcript will be or was sent.

Columns Comments for RHRRQST_ZIP (# 18)

Source Code Comments

ZIP CODE: The zip code associated with the city and state where the Financial Aid Transcript will be or was sent.

Table RHRTCMT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RHRTCMT_PIDM	NUMBER(8,0)	No	*
RHRTCMT_COMMENT_SEQ_NO	NUMBER(6,3)	No	*
RHRTCMT_COMMENT	VARCHAR2(50)	No
RHRTCMT_USER_ID	VARCHAR2(30)	No
RHRTCMT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RHRTCMT	Unique	RHRTCMT_PIDM
PK_RHRTCMT	Unique	RHRTCMT_COMMENT_SEQ_NO

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_RHRTCMT	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RHRTCMT

Object Dates

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

Source Code Comments

Transcript Comment Table

Columns Comments for RHRTCMT_PIDM (# 1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for RHRTCMT_COMMENT_SEQ_NO (# 2)

Source Code Comments

TRANSCRIPT COMMENT SEQUENCE NUMBER: The system-generated sequence number assigned to a transcript comment.

Columns Comments for RHRTCMT_COMMENT (# 3)

Source Code Comments

TRANSCRIPT COMMENT: A free-form entry which will appear on a Financial Aid Transcript.

Columns Comments for RHRTCMT_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 RHRTCMT_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table RTVCCOM

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVCCOM_CODE	VARCHAR2(7)	No	*
RTVCCOM_DESC	VARCHAR2(200)	No
RTVCCOM_DATA_ORIGIN	VARCHAR2(30)	Yes
RTVCCOM_USER_ID	VARCHAR2(30)	Yes
RTVCCOM_ACTIVITY_DATE	DATE	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVCCOM	Unique	RTVCCOM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RHRCOMM	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCCOM_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVCCOM	Rely On
RTVCCOM_C	Oracle Package Cursor	S10B80.BANINST1.RB_RTVCCOM	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_APPLICANT_COMMENT	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_RTVCCOM	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.RB_RTVCCOM	Rely On
RTVCCOM	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_RTVCCOM	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVCCOM_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.RTVCCOM

Object Dates

Creation Date	Analysis Date
04/02/2008 10:30:27:000	04/02/2008 10:35:22:000

Source Code Comments

Comment Category Code Validation Table

Columns Comments for RTVCCOM_CODE (# 1)

Source Code Comments

CATEGORY_CODE: The category code for applicant comments.

Columns Comments for RTVCCOM_DESC (# 2)

Source Code Comments

CATEGORY DESCRIPTION: The description of the comment category code.

Columns Comments for RTVCCOM_DATA_ORIGIN (# 3)

Source Code Comments

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

Columns Comments for RTVCCOM_USER_ID (# 4)

Source Code Comments

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

Columns Comments for RTVCCOM_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table STVATYP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
STVATYP_CODE	VARCHAR2(2)	No	*
STVATYP_DESC	VARCHAR2(30)	Yes
STVATYP_ACTIVITY_DATE	DATE	No
STVATYP_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVATYP_TELE_CODE	VARCHAR2(4)	Yes		*
STVATYP_UPDATE_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVATYP_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_STVATYP	Unique	STVATYP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRGASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRPASC	SQL Table	S10B80.ALUMNI	Refer (no action)
AMBMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
AOBORGN	SQL Table	S10B80.ALUMNI	Refer (no action)
AORCONT	SQL Table	S10B80.ALUMNI	Refer (no action)
APBCONS	SQL Table	S10B80.ALUMNI	Refer (no action)
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
APRCHLD	SQL Table	S10B80.ALUMNI	Refer (no action)
APRMAIL	SQL Table	S10B80.ALUMNI	Refer (no action)
ASBSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
ASRSORG	SQL Table	S10B80.ALUMNI	Refer (no action)
GERATTD	SQL Table	S10B80.GENERAL	Refer (no action)
GERPART	SQL Table	S10B80.GENERAL	Refer (no action)
GOBSEVS	SQL Table	S10B80.GENERAL	Refer (no action)
GORADRL	SQL Table	S10B80.GENERAL	Join
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVAS	SQL Table	S10B80.GENERAL	Refer (no action)
GORSVEI	SQL Table	S10B80.GENERAL	Refer (no action)
GTVSDAX	SQL Table	S10B80.GENERAL	Join
GURAPAY	SQL Table	S10B80.GENERAL	Refer (no action)
PXR1099	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRMTTN	SQL Table	S10B80.PAYROLL	Refer (no action)
RHRRQST	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SORFOLK	SQL Table	S10B80.SATURN	Refer (no action)
SORMSTA	SQL Table	S10B80.SATURN	Refer (no action)
SORXREF	SQL Table	S10B80.SATURN	Join
SPRADDR	SQL Table	S10B80.SATURN	Refer (no action)
SPREMRG	SQL Table	S10B80.SATURN	Refer (no action)
SPRTELE	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTADDR	SQL Table	S10B80.SATURN	Refer (no action)
SRTTELE	SQL Table	S10B80.SATURN	Refer (no action)
APVADRS	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)
SPVADDI_OJ	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	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESC_ALUMNI	SQL Function	S10B80.BANINST1	Use (select)
ADDRESS_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
ADDRESS_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKPREF	Rely On
ADDR_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
MAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKMAIL	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKPREF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWDKPREF	Use (select)
GETALLATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKWRUL	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKPREF	Use (select)
GETSTVATYPC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
SPRADDRLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
SPRADDR_ACTIVE_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SPRADDR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWPKEPCR	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKRQST	Use (select)
SPRADDR_LISTC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
STVATYPUPDATEC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWLKOSAD	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
STVATYPVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
P_DEFAULT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
ATYP	Oracle Package Variable	S10B80.BANINST1.BWSKAADR	Rely On
GV_ATYP_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_ATYP_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_FRN_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
GV_US_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
STVATYP_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
F_BUILD_STUDENT	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_CHK_SPRADDR	Oracle Package Function	S10B80.BANINST1.SAKL050	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Rely On
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAPAR	Use (select)
F_GETQUALIFIERS	Oracle Package Function	S10B80.BANINST1.BWSKAADR	Use (select)
F_GET_ADDR_TYPE	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Use (select)
F_GET_MAX_ADDRESS_SEQNO	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
APRMAILGETVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
APRMAILVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
SPRADDRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKMAIL	Use (select)
STVATYPC	Oracle Package Cursor	S10B80.BANINST1.STKATYP	Use (select)Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Rely On
STVATYP_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVATYP	Use (select)Rely On
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Use (select)
P_DISP_TRANSCRIPT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Rely On
P_LOOKUP	Oracle Package Procedure	S10B80.BANINST1.BWFKPROC	Use (select)
P_PA_STVATYP_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PA_STVATYP_HIERARCHY_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PREF_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWAKPREF	Use (select)
P_PROCESS_HOUSEHOLD_ADDR_RECS	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_STVATYP_PRTY	Oracle Package Procedure	S10B80.BANINST1.SOKPVAL	Use (select)
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVATYP	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.TOKPVAL	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_VALIDATEDATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_TELEPHONE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_MEMO	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_CUSTOMER_PROFILE	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_AB_ADV_ORGANIZATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISPLAY_OPTIONS	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_TB_RECEIVABLE	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_CM_SOURCE_RULES	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SP_LDIPERSON	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_CARDHOLDER	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_ADDRESS	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,update)
F_ADDRESS_TELEPHONE_VALUE	Oracle Package Function	S10B80.BANINST1.GOKSELS	Rely On
F_ADDRESS_VALUE	Oracle Package Function	S10B80.BANINST1.P_ADDR_TELE	Rely On
F_ADD_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_EXPIRE_ENTITY_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_ENTITY_ADDRESS	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVATYP	Rely On
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Rely On
F_GET_VALID_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_ADDRESS	Use (select)
STVATYP	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_STVATYP	SQL Index	S10B80.SATURN	Rely On
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVATYP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:48:46:000	04/02/2008 21:18:11:000

Source Code Comments

Address Type Validation Table

Columns Comments for STVATYP_CODE (# 1)

Source Code Comments

A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Columns Comments for STVATYP_DESC (# 2)

Source Code Comments

This field identifies the address type associated with the type code.

Columns Comments for STVATYP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for STVATYP_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVATYP_TELE_CODE (# 5)

Source Code Comments

Default Telephone type code for telephone number.

Columns Comments for STVATYP_UPDATE_WEB_IND (# 6)

Source Code Comments

Web update indicator. This column is now obsolete. Refer to table goradrl

Table STVSBGI

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
STVSBGI_CODE	VARCHAR2(6)	No	*	*
STVSBGI_TYPE_IND	VARCHAR2(1)	No
STVSBGI_SRCE_IND	VARCHAR2(1)	Yes
STVSBGI_DESC	VARCHAR2(30)	Yes
STVSBGI_ACTIVITY_DATE	DATE	No
STVSBGI_ADMR_CODE	VARCHAR2(4)	Yes		*
STVSBGI_EDI_CAPABLE	VARCHAR2(1)	Yes
STVSBGI_FICE	VARCHAR2(6)	Yes
STVSBGI_VR_MSG_NO	NUMBER(6,0)	Yes
STVSBGI_DISP_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVSBGI_ADMR_CODE	STVADMR_CODE	STVADMR
STVSBGI_CODE	SORHSCH_SBGI_CODE	SORHSCH

Index

Index Name	Index Type	Column Name
PK_STVSBGI	Unique	STVSBGI_CODE
STVSBGI_KEY_INDEX		STVSBGI_TYPE_IND
STVSBGI_KEY_INDEX		STVSBGI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRADEG	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
GORSGEO	SQL Table	S10B80.GENERAL	Refer (no action)
RHBTRNS	SQL Table	S10B80.FAISMGR	Refer (no action)
RHRPCOL	SQL Table	S10B80.FAISMGR	Refer (no action)
RHRRQST	SQL Table	S10B80.FAISMGR	Refer (no action)
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RRRAREQ	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVINFC	SQL Table	S10B80.FAISMGR	Refer (no action)
SABSUPL	SQL Table	S10B80.SATURN	Refer (no action)
SARADAP	SQL Table	S10B80.SATURN	Refer (no action)
SARQKER	SQL Table	S10B80.SATURN	Refer (no action)
SARRSRC	SQL Table	S10B80.SATURN	Refer (no action)
SARWADF	SQL Table	S10B80.SATURN	Refer (no action)
SCRSBGI	SQL Table	S10B80.SATURN	Refer (no action)
SHBCATT	SQL Table	S10B80.SATURN	Refer (no action)
SHBCGPA	SQL Table	S10B80.SATURN	Join
SHBTATC	SQL Table	S10B80.SATURN	Refer (no action)
SHREGPA	SQL Table	S10B80.SATURN	Refer (no action)
SHRICMT	SQL Table	S10B80.SATURN	Refer (no action)
SHRTATC	SQL Table	S10B80.SATURN	Refer (no action)
SHRTCAT	SQL Table	S10B80.SATURN	Refer (no action)
SHRTCMT	SQL Table	S10B80.SATURN	Refer (no action)
SHRTGRD	SQL Table	S10B80.SATURN	Refer (no action)
SHRTRAT	SQL Table	S10B80.SATURN	Refer (no action)
SHRTRIT	SQL Table	S10B80.SATURN	Refer (no action)
SHRTRTA	SQL Table	S10B80.SATURN	Refer (no action)
SHRTRTK	SQL Table	S10B80.SATURN	Refer (no action)
SHRTTRM	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRAN	SQL Table	S10B80.SATURN	Refer (no action)
SHTTRTC	SQL Table	S10B80.SATURN	Refer (no action)
SMRPCRS	SQL Table	S10B80.SATURN	Refer (no action)
SMRPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SMTPRRQ	SQL Table	S10B80.SATURN	Refer (no action)
SOBSBGA	SQL Table	S10B80.SATURN	Refer (no action)
SOBSBGI	SQL Table	S10B80.SATURN	Refer (no action)
SORAPPT	SQL Table	S10B80.SATURN	Refer (no action)
SORBACD	SQL Table	S10B80.SATURN	Refer (no action)
SORBCHR	SQL Table	S10B80.SATURN	Refer (no action)
SORBCMT	SQL Table	S10B80.SATURN	Refer (no action)
SORBCNT	SQL Table	S10B80.SATURN	Refer (no action)
SORBDEG	SQL Table	S10B80.SATURN	Refer (no action)
SORBDMO	SQL Table	S10B80.SATURN	Refer (no action)
SORBDPL	SQL Table	S10B80.SATURN	Refer (no action)
SORBETH	SQL Table	S10B80.SATURN	Refer (no action)
SORBTAC	SQL Table	S10B80.SATURN	Refer (no action)
SORBTAG	SQL Table	S10B80.SATURN	Refer (no action)
SORBTAI	SQL Table	S10B80.SATURN	Refer (no action)
SORBTAL	SQL Table	S10B80.SATURN	Refer (no action)
SORBTAP	SQL Table	S10B80.SATURN	Refer (no action)
SORBTST	SQL Table	S10B80.SATURN	Refer (no action)
SORCONC	SQL Table	S10B80.SATURN	Refer (no action)
SORCRSS	SQL Table	S10B80.SATURN	Refer (no action)
SORDEGR	SQL Table	S10B80.SATURN	Refer (no action)
SORGPAT	SQL Table	S10B80.SATURN	Refer (no action)
SORHSBJ	SQL Table	S10B80.SATURN	Refer (no action)
SORMAJR	SQL Table	S10B80.SATURN	Refer (no action)
SORMINR	SQL Table	S10B80.SATURN	Refer (no action)
SORMSRC	SQL Table	S10B80.SATURN	Refer (no action)
SORPCOL	SQL Table	S10B80.SATURN	Refer (no action)
SRBPRED	SQL Table	S10B80.SATURN	Refer (no action)
SRBRECR	SQL Table	S10B80.SATURN	Refer (no action)
SRRRSRC	SQL Table	S10B80.SATURN	Refer (no action)
SRRVIST	SQL Table	S10B80.SATURN	Refer (no action)
SRTCRSS	SQL Table	S10B80.SATURN	Refer (no action)
SRTDEGR	SQL Table	S10B80.SATURN	Refer (no action)
SRTGPAT	SQL Table	S10B80.SATURN	Refer (no action)
SRTHSCH	SQL Table	S10B80.SATURN	Refer (no action)
SRTMAJR	SQL Table	S10B80.SATURN	Refer (no action)
SRTPCOL	SQL Table	S10B80.SATURN	Refer (no action)
SRTPREL	SQL Table	S10B80.SATURN	Refer (no action)
SRTSUPL	SQL Table	S10B80.SATURN	Refer (no action)
STVINFC	SQL Table	S10B80.SATURN	Refer (no action)
POVDATA	SQL View	S10B80.BANINST1	Use (select)
ROVPCOL	SQL View	S10B80.BANINST1	Use (select)
SAVADAS1	SQL View	S10B80.BANINST1	Join
SAVADAS1	SQL View	S10B80.BANINST1	Use (select)
SAVSGEO	SQL View	S10B80.BANINST1	Use (select)
SOVCOLL	SQL View	S10B80.BANINST1	Use (select)
SOVCOLP	SQL View	S10B80.BANINST1	Use (select)
SOVCONC	SQL View	S10B80.BANINST1	Use (select)
SOVDATA	SQL View	S10B80.BANINST1	Use (select)
SOVDEGR	SQL View	S10B80.BANINST1	Use (select)
SOVHSCH	SQL View	S10B80.BANINST1	Use (select)
SOVMAJR	SQL View	S10B80.BANINST1	Use (select)
SOVMINR	SQL View	S10B80.BANINST1	Use (select)
SOVSBGV	SQL View	S10B80.BANINST1	Use (select)
SOVSBGV_OJ	SQL View	S10B80.BANINST1	Use (select)
SRVHSCH	SQL View	S10B80.BANINST1	Use (select)
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
SRVSRCE	SQL View	S10B80.BANINST1	Use (select)
F_FINAID_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)
INSTITUTION_REC	Oracle Package Type	S10B80.BANINST1.STKSBGI	Rely On
CITY_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
NATN_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
SBGI_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
STAT_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
SBGI_DESC_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
SBGI_VRNO_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
STVSBGI_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.ROKTABS	Rely On
STVSBGI_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
STVSBGI_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
GET_INST_CODE_C	Oracle Package Cursor	S10B80.BANINST1.SB_PESCXML_TRANDATA_EXP	Use (select)
PREV_HSC	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
RECR_HS2C	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
RECR_PC2C	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
SBGI_INFO2_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKWPRV	Use (select)
SBGI_INFO_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKWPRO	Use (select)
SBGI_INFO_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKWPRV	Use (select)
SBGI_INFO_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
SBGI_INFO_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
SOBSBGI_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
SOBSBGI_ADDRESSC	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SOBSBGI_ADDRESSD	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Rely On
SOBSBGI_ADDRESSD	Oracle Package Cursor	S10B80.BANINST1.BWSKWTRR	Use (select)
SORPCOLC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
STVSBGIVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
STVSBGIVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
P_OPEN_SORHSCH_CV	Oracle Package Procedure	S10B80.BANINST1.SAKMTCH	Use (select)
P_ORGID	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_TRANDATA_EXP	Rely On
P_PROC_SET_INFO	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
F_CHECK_STVSBGI	Oracle Package Function	S10B80.BANINST1.SAKL010	Use (select)
F_CHK_SBGI_CODE	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Rely On
F_CHK_SBGI_CODE	Oracle Package Function	S10B80.BANINST1.BWSKWTRR	Use (select)
F_GET_ADMR_CODE	Oracle Package Function	S10B80.BANINST1.SAKL090	Use (select)
F_GET_SBGIADMR	Oracle Package Function	S10B80.BANINST1.SAKL060	Use (select)
F_MATCH_SORHSCH	Oracle Package Function	S10B80.BANINST1.SOKAINF	Rely On
F_MATCH_SORPCOL	Oracle Package Function	S10B80.BANINST1.SOKAINF	Rely On
F_SBGI_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_REQUIREMENT_RULES	Rely On
F_SBGI_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_REQUIREMENT_RULES	Use (select)
STVSBGIC	Oracle Package Cursor	S10B80.BANINST1.STKSBGI	Use (select)Rely On
STVSBGI_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVSBGI	Rely On
STVSBGI_C	Oracle Package Cursor	S10B80.BANINST1.GB_STVSBGI	Use (select)Rely On
P_ACADREC_COURSE_UDE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_COURSE_UDE_EXP	Rely On
P_ACADSESS_COURSE_UDE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_COURSE_UDE_EXP	Rely On
P_ACAWARD_ACSUM_DEGR_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADSUMMARY_EXP	Rely On
P_ACREC_ACADEMIC_PGM_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADPROGRAM_EXP	Rely On
P_ACREC_ACADSESS_INPRG_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADSESSION_EXP	Rely On
P_ACREC_ACADSESS_INST_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADSESSION_EXP	Rely On
P_ACREC_ACADSESS_TRANS_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADSESSION_EXP	Rely On
P_ACREC_ACAWARD_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADAWARD_EXP	Rely On
P_ACREC_ACSUM_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADSUMMARY_EXP	Rely On
P_ACREC_ADDLSTUACHEIV_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ADDLSTUACHV_EXP	Rely On
P_ACREC_INST_COURSE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_COURSE_EXP	Rely On
P_ACREC_SCHOOL_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_SCHOOL_EXP	Rely On
P_ACREC_TRANS_COURSE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_COURSE_EXP	Rely On
P_ACREC_TRANS_SCHOOL_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_SCHOOL_EXP	Rely On
P_ACREC_TRANS_SCHOOL_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_SCHOOL_EXP	Use (select)Rely On
P_ACREC_UDE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACREC_UDE_EXP	Rely On
P_DELETE_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_DELETE_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (delete)
P_DEL_LOAD	Oracle Package Procedure	S10B80.BANINST1.DLINDBLO	Rely On
P_DEL_LOAD	Oracle Package Procedure	S10B80.BANINST1.DLINDBLO	Rely On
P_DISP_PAYMENT_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_ADDRESS	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_DISP_TRANS_REQUEST_CHARGES	Oracle Package Procedure	S10B80.BANINST1.BWSKWTRR	Rely On
P_GET_SOBBGTA_INFO	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP	Use (select)
P_GET_STVSBGI_ROW	Oracle Package Procedure	S10B80.BANINST1.RRKFUNC	Rely On
P_INSERT_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_SORHSCH_SELFREPORT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_INSERT_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (Insert)
P_MAIN_UDE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_MAIN_UDE_EXP	Rely On
P_ORGID	Oracle Package Procedure	S10B80.BANINST1.SHKPXEX	Rely On
P_PA_STVSBGI_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Rely On
P_SELECT_SARHSCH	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Use (select)
P_SORHSCH_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Rely On
P_SORHSCH_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORHSCH_UPDCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORHSCH_UPDCOMMENT	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORPCOL_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Rely On
P_SORPCOL_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORPCOL_UPDCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORPCOL_UPDCOMMENT	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_STUDENT_UDE_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_STUDENT_UDE_EXP	Rely On
P_TRANSMIT_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP	Rely On
P_TRANSMIT_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_TRANDATA_EXP	Rely On
P_UPDATE_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Rely On
P_UPDATE_STVSBGI	Oracle Package Procedure	S10B80.BANINST1.TS_SB_VALIDATION	Use (update)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_HIGHSCHOOL_RULES	Use (select)
P_VIEWTRANSCRIPT	Oracle Package Procedure	S10B80.BANINST1.BWCKOTRN	Rely On
P_VR_SPEAK_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRRKRREQ	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_CRSE_CMT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_EQUIV	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_CRSE	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_PCOL_MINOR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_REQUIREMENT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_PCOL_CONCENTRATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_CRSE_ATTR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_RB_PGRP_CATEGORY	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_APPLICATION_DECISION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_PCOL_MAJOR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_EQUIV_ATTR	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_TRANSFER_EQUIV_CMT	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
F_CHECK_STVSBGI_ADMR	Oracle Package Function	S10B80.BANINST1.GB_PRIOR_COLLEGE_RULES	Rely On
F_CHECK_STVSBGI_TYPE	Oracle Package Function	S10B80.BANINST1.GB_PRIOR_COLLEGE_RULES	Rely On
F_CHECK_VALID_SBGI	Oracle Package Function	S10B80.BANINST1.EOKSLNK	Use (select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_STVSBGI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_STVSBGI	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.STKSBGI	Use (select)
F_STVSBGI_EXISTS	Oracle Package Function	S10B80.BANINST1.STKSBGI	Rely On
F_STVSBGI_EXISTS	Oracle Package Function	S10B80.BANINST1.STKSBGI	Use (select)
F_VALID_INSTITUTION	Oracle Package Function	S10B80.BANINST1.SHKPXEX	Rely On
F_VALID_INSTITUTION	Oracle Package Function	S10B80.BANINST1.SHKPXEX	Use (select)
F_VALID_SBGI	Oracle Package Function	S10B80.BANINST1.SAKQADM	Use (select)
STVSBGI	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_STVSBGI	SQL Index	S10B80.SATURN	Rely On
STVSBGI_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SORHSCH	SQL Table	S10B80.SATURN	Join
STVADMR	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVSBGI

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:18:000	04/02/2008 21:18:25:000

Source Code Comments

Source/Background Inst Validation Table

Columns Comments for STVSBGI_CODE (# 1)

Source Code Comments

This field identifies the source/background institution code referenced in the Recruiting, Admissions and Academic History Modules.

Columns Comments for STVSBGI_TYPE_IND (# 2)

Source Code Comments

This field identifies the source/background institution type (e.g. college, high school, source-only)

Columns Comments for STVSBGI_SRCE_IND (# 3)

Source Code Comments

This field indicates whether source/background institution is a recruiting source.

Columns Comments for STVSBGI_DESC (# 4)

Source Code Comments

This field specifies the source or background institution associated with the source/background institution code.

Columns Comments for STVSBGI_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for STVSBGI_ADMR_CODE (# 6)

Source Code Comments

This field identifies required admissions request items associated with source/background institution.

Columns Comments for STVSBGI_EDI_CAPABLE (# 7)

Source Code Comments

Electronic Capable Institution: P - PESC/XML, E - EDI, N or Null - No

Columns Comments for STVSBGI_FICE (# 8)

Source Code Comments

This field holds the FICE code of the institution, for EDI, unless STVSBGI_CODE contains the FICE code.

Columns Comments for STVSBGI_VR_MSG_NO (# 9)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the source/background institution code.

Columns Comments for STVSBGI_DISP_WEB_IND (# 10)

Source Code Comments

Display on Web Indicator is now obsolete.

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 RHBTRNS and STVSBGI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHBTRNS and STVSBGI (FK1_RHBTRNS_INV_STVSBGI_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHBTRNS	RHBTRNS_SBGI_CODE	STVSBGI_CODE	STVSBGI	(0,1)-(0,n)

Link between RHRPCOL and STVSBGI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRPCOL and STVSBGI (FK1_RHRPCOL_INV_STVSBGI_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRPCOL	RHRPCOL_SBGI_CODE	STVSBGI_CODE	STVSBGI	(0,1)-(0,n)

Link between RHRRQST and STVSBGI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRRQST and STVSBGI (FK1_RHRRQST_INV_STVSBGI_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRRQST	RHRRQST_SBGI_CODE	STVSBGI_CODE	STVSBGI	(0,1)-(0,n)

Link between RHRAWRD and RHBTRNS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRAWRD and RHBTRNS (FK1_RHRAWRD_INV_RHBTRNS_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRAWRD	RHRAWRD_PIDM	RHBTRNS_PIDM	RHBTRNS	(1,1)-(0,n)
RHRAWRD	RHRAWRD_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS	(1,1)-(0,n)

Link between RHRLOAN and RHBTRNS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRLOAN and RHBTRNS (FK1_RHRLOAN_INV_RHBTRNS_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRLOAN	RHRLOAN_PIDM	RHBTRNS_PIDM	RHBTRNS	(1,1)-(0,n)
RHRLOAN	RHRLOAN_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS	(1,1)-(0,n)

Link between RHRPCMT and RHBTRNS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRPCMT and RHBTRNS (FK1_RHRPCMT_INV_RHBTRNS_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRPCMT	RHRPCMT_PIDM	RHBTRNS_PIDM	RHBTRNS	(1,1)-(0,n)
RHRPCMT	RHRPCMT_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS	(1,1)-(0,n)

Link between RHRPCOL and RHBTRNS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRPCOL and RHBTRNS (FK1_RHRPCOL_INV_RHBTRNS_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRPCOL	RHRPCOL_PIDM	RHBTRNS_PIDM	RHBTRNS	(1,1)-(0,n)
RHRPCOL	RHRPCOL_TRNS_SEQ_NO	RHBTRNS_SEQ_NO	RHBTRNS	(1,1)-(0,n)

Link between RHRCOMM and RTVCCOM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRCOMM and RTVCCOM (FK1_RHRCOMM_INV_RTVCCOM_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRCOMM	RHRCOMM_CATEGORY_CODE	RTVCCOM_CODE	RTVCCOM	(0,1)-(0,n)

Link between RHRRQST and STVSTAT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRRQST and STVSTAT (FK1_RHRRQST_INV_STVSTAT_CODE)	FAISMGR

Foreign Key information

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

Link between RHRRQST and STVATYP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RHRRQST and STVATYP (FK1_RHRRQST_INV_STVATYP_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RHRRQST	RHRRQST_ATYP_CODE	STVATYP_CODE	STVATYP	(0,1)-(0,n)