Model E-mail_View_and_Update*

Model Label :

List of Objects

Object Name	Object Type	Layer Name
APBWIDN	SQL Table	Default
GOREMAL	SQL Table	Default
GTVEMAL	SQL Table	Default
ROTEMAL	SQL Table	Default
SARADAP	SQL Table	Default
SPBPERS	SQL Table	Default
SRBWPRO	SQL Table	Default
SRTEMAL	SQL Table	Default

Model View

Table APBWIDN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
APBWIDN_ID	VARCHAR2(9)	No	*
APBWIDN_PIN	VARCHAR2(256)	No
APBWIDN_ACTIVITY_DATE	DATE	No
APBWIDN_USER	VARCHAR2(30)	No
APBWIDN_ACCEPTED_IND	VARCHAR2(1)	No
APBWIDN_QUESTION	VARCHAR2(90)	Yes
APBWIDN_ANSWER	VARCHAR2(30)	Yes
APBWIDN_PIDM	NUMBER(8,0)	Yes
APBWIDN_LAST_NAME	VARCHAR2(60)	Yes
APBWIDN_FIRST_NAME	VARCHAR2(60)	Yes
APBWIDN_MI	VARCHAR2(60)	Yes
APBWIDN_MAIDEN_NAME	VARCHAR2(60)	Yes
APBWIDN_NAME_PREFIX	VARCHAR2(20)	Yes
APBWIDN_NAME_SUFFIX	VARCHAR2(20)	Yes
APBWIDN_BIRTH_DATE	DATE	Yes
APBWIDN_SEX	VARCHAR2(1)	Yes
APBWIDN_ATYP_CODE	VARCHAR2(2)	Yes		*
APBWIDN_STREET_LINE1	VARCHAR2(75)	Yes
APBWIDN_STREET_LINE2	VARCHAR2(75)	Yes
APBWIDN_STREET_LINE3	VARCHAR2(75)	Yes
APBWIDN_CITY	VARCHAR2(50)	Yes
APBWIDN_STAT_CODE	VARCHAR2(3)	Yes		*
APBWIDN_ZIP	VARCHAR2(30)	Yes
APBWIDN_CNTY_CODE	VARCHAR2(5)	Yes		*
APBWIDN_NATN_CODE	VARCHAR2(5)	Yes		*
APBWIDN_TELE_CODE	VARCHAR2(4)	Yes		*
APBWIDN_PHONE_AREA	VARCHAR2(6)	Yes
APBWIDN_PHONE_NUMBER	VARCHAR2(12)	Yes
APBWIDN_PHONE_EXT	VARCHAR2(10)	Yes
APBWIDN_INTL_ACCESS	VARCHAR2(16)	Yes
APBWIDN_UNLIST_IND	VARCHAR2(1)	Yes
APBWIDN_FAX_TELE_CODE	VARCHAR2(4)	Yes		*
APBWIDN_FAX_AREA	VARCHAR2(6)	Yes
APBWIDN_FAX_NUMBER	VARCHAR2(12)	Yes
APBWIDN_FAX_INTL_ACCESS	VARCHAR2(16)	Yes
APBWIDN_FAX_UNLIST_IND	VARCHAR2(1)	Yes
APBWIDN_EMAIL_ADDRESS	VARCHAR2(128)	Yes
APBWIDN_EMAL_CODE	VARCHAR2(4)	Yes		*
APBWIDN_SPS_LAST_NAME	VARCHAR2(60)	Yes
APBWIDN_SPS_FIRST_NAME	VARCHAR2(60)	Yes
APBWIDN_SPS_MI	VARCHAR2(60)	Yes
APBWIDN_PREF_CLAS	VARCHAR2(4)	Yes
APBWIDN_PREF_COLL	VARCHAR2(2)	Yes
APBWIDN_DONR_CODE	VARCHAR2(4)	Yes		*
APBWIDN_LAST_LOGIN_DATE	DATE	Yes
APBWIDN_STREET_LINE4	VARCHAR2(75)	Yes
APBWIDN_CTRY_CODE_PHONE	VARCHAR2(4)	Yes
APBWIDN_SURNAME_PREFIX	VARCHAR2(60)	Yes
APBWIDN_HOUSE_NUMBER	VARCHAR2(10)	Yes
APBWIDN_SALT	VARCHAR2(128)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APBWIDN_DONR_CODE	ATVDONR_CODE	ATVDONR
APBWIDN_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
APBWIDN_NATN_CODE	STVNATN_CODE	STVNATN
APBWIDN_STAT_CODE	STVSTAT_CODE	STVSTAT
APBWIDN_CNTY_CODE	STVCNTY_CODE	STVCNTY
APBWIDN_ATYP_CODE	STVATYP_CODE	STVATYP
APBWIDN_TELE_CODE	STVTELE_CODE	STVTELE
APBWIDN_FAX_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_APBWIDN	Unique	APBWIDN_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
AGBGHLD	SQL Table	S10B80.ALUMNI	Join
APBWIDN_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
APBWIDNVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKNGFT	Use (select)
GETAPBWIDNBYPIDMC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)
GETAPBWIDNC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)
P_DISPFORGOTPIN	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
P_UPDATEADVIDNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
AIDM	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
APBWIDN_REC	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
HOLD_AIDM	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
PIDM	Oracle Package Variable	S10B80.BANINST1.BWAKNGFT	Rely On
PINHASH	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
PINSALT	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
P_DISPLOGOUTNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_DONATION_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.BWAKNGFT	Rely On
P_PROCFORCEPINCHANGE	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_PROCFORGOTPIN	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
P_PROCLOGINNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Rely On
P_PROCLOGINNON	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (Insert)
P_PROCPERSINFO	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_PROCPINCHANGE	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_PROCPININVALID	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_PROCPINVERIFYEXIST	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (update)
P_PROCPINVERIFYNEW	Oracle Package Procedure	S10B80.BANINST1.BWAKALOG	Use (delete)
APBWIDN	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_APBWIDN	SQL Index	S10B80.ALUMNI	Rely On
ATVDONR	SQL Table	S10B80.ALUMNI	Refer (no action)
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVCNTY	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.APBWIDN

Object Dates

Creation Date	Analysis Date
04/02/2008 13:47:18:000	04/02/2008 13:49:23:000

Source Code Comments

Web Access Base Record Hold Table.

Columns Comments for APBWIDN_ID (# 1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for APBWIDN_PIN (# 2)

Source Code Comments

Personal Identification Number selected by the Web user.

Columns Comments for APBWIDN_ACTIVITY_DATE (# 3)

Source Code Comments

Date record created or updated.

Columns Comments for APBWIDN_USER (# 4)

Source Code Comments

User who created or changed the record.

Columns Comments for APBWIDN_ACCEPTED_IND (# 5)

Source Code Comments

Accepted Indicator, Y = Accepted, N = not Accepted.

Columns Comments for APBWIDN_QUESTION (# 6)

Source Code Comments

Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_ANSWER (# 7)

Source Code Comments

Answer to Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_PIDM (# 8)

Source Code Comments

Internal ID of person in Banner.

Columns Comments for APBWIDN_LAST_NAME (# 9)

Source Code Comments

Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_FIRST_NAME (# 10)

Source Code Comments

First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MI (# 11)

Source Code Comments

Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MAIDEN_NAME (# 12)

Source Code Comments

Maiden Name of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_PREFIX (# 13)

Source Code Comments

Name prefix of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_SUFFIX (# 14)

Source Code Comments

Name suffix of user with no Banner PIDM.

Columns Comments for APBWIDN_BIRTH_DATE (# 15)

Source Code Comments

Birth Date of user with no Banner PIDM.

Columns Comments for APBWIDN_SEX (# 16)

Source Code Comments

Gender of user with no Banner PIDM.

Columns Comments for APBWIDN_ATYP_CODE (# 17)

Source Code Comments

Address Type of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE1 (# 18)

Source Code Comments

Street Line 1 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE2 (# 19)

Source Code Comments

Street Line 2 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE3 (# 20)

Source Code Comments

Street Line 3 of user with no Banner PIDM.

Columns Comments for APBWIDN_CITY (# 21)

Source Code Comments

Address City of user with no Banner PIDM.

Columns Comments for APBWIDN_STAT_CODE (# 22)

Source Code Comments

Address State of user with no Banner PIDM.

Columns Comments for APBWIDN_ZIP (# 23)

Source Code Comments

Address Zip/Postal Code of user with no Banner PIDM.

Columns Comments for APBWIDN_CNTY_CODE (# 24)

Source Code Comments

Address County of user with no Banner PIDM.

Columns Comments for APBWIDN_NATN_CODE (# 25)

Source Code Comments

Address Nation of user with no Banner PIDM.

Columns Comments for APBWIDN_TELE_CODE (# 26)

Source Code Comments

Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_AREA (# 27)

Source Code Comments

Phone Number Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_NUMBER (# 28)

Source Code Comments

Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_EXT (# 29)

Source Code Comments

Phone Number Extension of user with no Banner PIDM.

Columns Comments for APBWIDN_INTL_ACCESS (# 30)

Source Code Comments

Internation Access Code of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_UNLIST_IND (# 31)

Source Code Comments

Unlisted Indicator of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_TELE_CODE (# 32)

Source Code Comments

FAX Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_AREA (# 33)

Source Code Comments

FAX Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_NUMBER (# 34)

Source Code Comments

FAX Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_INTL_ACCESS (# 35)

Source Code Comments

Internation Access Code of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_UNLIST_IND (# 36)

Source Code Comments

Unlisted Indicator of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAIL_ADDRESS (# 37)

Source Code Comments

Email Address of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAL_CODE (# 38)

Source Code Comments

Email Code of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_LAST_NAME (# 39)

Source Code Comments

Spouse Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_FIRST_NAME (# 40)

Source Code Comments

Spouse First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_MI (# 41)

Source Code Comments

Spouse Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_PREF_CLAS (# 42)

Source Code Comments

Preferred class of user with no Banner PIDM.

Columns Comments for APBWIDN_DONR_CODE (# 44)

Source Code Comments

Donor Code of user with no Banner PIDM.

Columns Comments for APBWIDN_LAST_LOGIN_DATE (# 45)

Source Code Comments

Date user with no Banner PIDM last logged into the web.

Columns Comments for APBWIDN_STREET_LINE4 (# 46)

Source Code Comments

STREET LINE4: This field maintains line four of the street address.

Columns Comments for APBWIDN_CTRY_CODE_PHONE (# 47)

Source Code Comments

TELEPHONE COUNTRY CODE: Code designating the region or country.

Columns Comments for APBWIDN_SURNAME_PREFIX (# 48)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac, etc.)

Columns Comments for APBWIDN_HOUSE_NUMBER (# 49)

Source Code Comments

HOUSE NUMBER: Building or lot number on a street or in an area.

Columns Comments for APBWIDN_SALT (# 50)

Source Code Comments

SALT: Random value used in generation of PIN Hash.

Table GOREMAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GOREMAL_PIDM	NUMBER(8,0)	No	*	*
GOREMAL_EMAL_CODE	VARCHAR2(4)	No	*	*
GOREMAL_EMAIL_ADDRESS	VARCHAR2(128)	No	*
GOREMAL_STATUS_IND	VARCHAR2(1)	No
GOREMAL_PREFERRED_IND	VARCHAR2(1)	No
GOREMAL_ACTIVITY_DATE	DATE	No
GOREMAL_USER_ID	VARCHAR2(30)	No
GOREMAL_COMMENT	VARCHAR2(60)	Yes
GOREMAL_DISP_WEB_IND	VARCHAR2(1)	No
GOREMAL_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
GOREMAL_PIDM	SARADAP_PIDM	SARADAP
GOREMAL_EMAL_CODE	GORICCR_VALUE	GORICCR

Index

Index Name	Index Type	Column Name
PK_GOREMAL	Unique	GOREMAL_PIDM
PK_GOREMAL	Unique	GOREMAL_EMAL_CODE
PK_GOREMAL	Unique	GOREMAL_EMAIL_ADDRESS

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRADVR	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
GT_GOREMAL_AR_LDI	SQL Trigger	S10B80.GENERAL	Rely On
SAVAMCD	SQL View	S10B80.BANINST1	Use (select)
F_GET_EMAIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
EMAIL_REC	Oracle Package Type	S10B80.BANINST1.GB_EMAIL	Rely On
EMAIL_RECORD	Oracle Package Type	S10B80.BANINST1.GOKSEVN	Rely On
EMAIL_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
EMAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKADVS	Rely On
GOREMAL_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
GOREMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
PREV_EMAL	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GET_GOREMAL_EMAIL_C	Oracle Package Cursor	S10B80.BANINST1.BWLKFCWL	Use (select)
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GOREMALEMALEADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALPREFC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALPREFERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
GOREMAL_BY_PREFERRED_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
GOREMAL_BY_PREFERRED_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
GOREMAL_BY_TYPE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
GOREMAL_BY_TYPE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
GOREMAL_ETYP_C	Oracle Package Cursor	S10B80.BANINST1.APKLDRD	Rely On
GOREMAL_ETYP_C	Oracle Package Cursor	S10B80.BANINST1.APKLDRD	Use (select)Rely On
LATEST_SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
P_MATCH_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_OPEN_GOREMAL_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
EMAIL	Oracle Package Variable	S10B80.BANINST1.BWLKFCWL	Rely On
GOREMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GV_EMAIL_ADDRESS1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_ADDRESS2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_ADDRESS3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_FRN_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_GOREMAL_REC	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_BUILD_MAIL_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	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_BUILD_US_ADDRESS	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_EMAILSDAXEXISTS	Oracle Package Function	S10B80.BANINST1.GOKSEVN	Use (select)
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.ICSPKLDI	Rely On
F_GOREMAL_EXISTS	Oracle Package Function	S10B80.BANINST1.GOKCMPK	Use (select)
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
GOREMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (delete)
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Rely On
P_DISPADVISEES	Oracle Package Procedure	S10B80.BANINST1.BWLKADVR	Use (select)
P_DISPCURRENT	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_DISPEVALADDITIONAL	Oracle Package Procedure	S10B80.BANINST1.BWCKSNCR	Rely On
P_DISPEVALDETAILREQ	Oracle Package Procedure	S10B80.BANINST1.BWCKSMLT	Rely On
P_DISPEVALGENERALREQ	Oracle Package Procedure	S10B80.BANINST1.BWCKSMLT	Rely On
P_EMAILEVENTCHECK	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_EMAIL_INSERT	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_EMAIL_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GOKSEVN	Rely On
P_GETEMAILS	Oracle Package Procedure	S10B80.BANINST1.BWPKEDIR	Use (select)
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Rely On
P_GET_GIFT_INFO	Oracle Package Procedure	S10B80.BANINST1.AOKWEVN	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCBREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWSCJREF	Use (select)
P_GET_STUDENT_ADVISORS	Oracle Package Procedure	S10B80.BANINST1.BWXCBREF	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (Insert)Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOAD_EMAIL	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOAD_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SAKL045	Rely On
P_LOAD_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SAKL045	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Use (select)
P_MODIFY_USER	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
P_MODIFY_USER	Oracle Package Procedure	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Rely On
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GOREMAL	Use (update)Rely On
P_VALEMAILUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOADR	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_EMAIL_RULES	Use (select)
P_VERIFYDISPEVALVIEWOPTION	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
F_CLASS_EMAIL_STR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Rely On
F_CLASS_EMAIL_STR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_DISP_INSTR_EMAIL_ICON	Oracle Package Function	S10B80.BANINST1.BWCKFRMT	Rely On
F_DISP_INSTR_EMAIL_ICON	Oracle Package Function	S10B80.BANINST1.BWCKFRMT	Use (select)
F_EMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Rely On
F_EMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SFKWLAT	Use (select)
F_EQUAL_E_ADDRESS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Rely On
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKSMLT	Use (select)
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_GETEMAILADDRESS	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
F_GET_ADV_DASH_COMMON_XML	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
F_GET_ADV_DASH_RESULT	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Rely On
F_GET_EMAIL	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.VIJAYSPKLDI	Rely On
F_GET_PERSON_XML	Oracle Package Function	S10B80.BANINST1.XCHAPERS	Use (select)
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_LOOKUP_USER	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
F_LOOKUP_USER	Oracle Package Function	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Use (select)
F_PREFERRED_IND_RULE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_EMAIL	Use (select)
GOREMAL	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_GOREMAL	SQL Index	S10B80.GENERAL	Rely On
GORICCR	SQL Table	S10B80.GENERAL	Join
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
SARADAP	SQL Table	S10B80.SATURN	Join
GT_GOREMAL_AR_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,each row)
GT_GOREMAL_AS_LDI	SQL Trigger	S10B80.GENERAL	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOREMAL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:03:000	04/02/2008 21:17:57:000

Source Code Comments

Person E-mail repeating table.

Columns Comments for GOREMAL_PIDM (# 1)

Source Code Comments

The pidm of the entity who owns this e-mail information.

Columns Comments for GOREMAL_EMAL_CODE (# 2)

Source Code Comments

The type of e-mail address.

Columns Comments for GOREMAL_EMAIL_ADDRESS (# 3)

Source Code Comments

The e-mail address.

Columns Comments for GOREMAL_STATUS_IND (# 4)

Source Code Comments

The status of the e-mail address: (A)ctive, (I)nactive

Columns Comments for GOREMAL_PREFERRED_IND (# 5)

Source Code Comments

This column indicates if the e-mail address is the preferred contact address.

Columns Comments for GOREMAL_ACTIVITY_DATE (# 6)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GOREMAL_USER_ID (# 7)

Source Code Comments

The user id when the row was added or modified.

Columns Comments for GOREMAL_COMMENT (# 8)

Source Code Comments

This is a free format comment regarding the e-mail information.

Columns Comments for GOREMAL_DISP_WEB_IND (# 9)

Source Code Comments

Indicate whether a e-mail address should appear on Web.

Columns Comments for GOREMAL_DATA_ORIGIN (# 10)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Table GTVEMAL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVEMAL_CODE	VARCHAR2(4)	No	*
GTVEMAL_DESC	VARCHAR2(60)	Yes
GTVEMAL_ACTIVITY_DATE	DATE	No
GTVEMAL_DISP_WEB_IND	VARCHAR2(1)	No
GTVEMAL_URL_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEMAL	Unique	GTVEMAL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVEMAL	Oracle Synonym	S10B80.FAISMGR	Rely On
APBWIDN	SQL Table	S10B80.ALUMNI	Refer (no action)
GORCMSC	SQL Table	S10B80.GENERAL	Refer (no action)
GOREMAL	SQL Table	S10B80.GENERAL	Refer (no action)
ROTEMAL	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWAPP	SQL Table	S10B80.SATURN	Refer (no action)
SMBWCRL	SQL Table	S10B80.SATURN	Refer (no action)
SRBWPRO	SQL Table	S10B80.SATURN	Refer (no action)
SRTEMAL	SQL Table	S10B80.SATURN	Refer (no action)
EMAIL_RECORD	Oracle Package Type	S10B80.BANINST1.GOKSEVN	Rely On
EMAL_TYPE	Oracle Package Type	S10B80.BANINST1.BWAKADVS	Rely On
GOREMAL_LINK_TYPE	Oracle Package Type	S10B80.BANINST1.BWGKOADR	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOADR	Rely On
GETGTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
GOREMALEMALEADDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALERIDC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALLINKC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)
GOREMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.BWGKOPRF	Use (select)
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.BWGKOGAD	Use (select)Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWLKOSAD	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GTVEMAL_REC	Oracle Package Variable	S10B80.BANINST1.BWGKOPRF	Rely On
GV_EMAIL_CODE1	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE2	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_EMAIL_CODE3	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_CHECK_EMAL_CODE	Oracle Package Function	S10B80.BANINST1.SAKL045	Use (select)
GTVEMALC	Oracle Package Cursor	S10B80.BANINST1.GTKEMAL	Use (select)Rely On
GTVEMALLISTC	Oracle Package Cursor	S10B80.BANINST1.GOKLIBS	Use (select)Rely On
GTVEMALVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMALWEBLISTC	Oracle Package Cursor	S10B80.BANINST1.BWGKOADR	Use (select)Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Rely On
GTVEMAL_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVEMAL	Use (select)Rely On
P_DISPEMAILUPDATE	Oracle Package Procedure	S10B80.BANINST1.BWGKOGAD	Rely On
P_PA_GTVEMAL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (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_EMAIL	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_CM_DISP_HIER	Use (Insert,select)
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_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_EFDTEST	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVEMAL	Rely On
F_GTVEMAL_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_SORXREF_CHK	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_SORXREF_VAL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
GTVEMAL	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_GTVEMAL	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVEMAL

Object Dates

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

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (# 1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (# 2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (# 3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (# 4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (# 5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table ROTEMAL

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
ROTEMAL_PIDM	NUMBER(8,0)	No
ROTEMAL_EMAL_CODE	VARCHAR2(4)	No	*
ROTEMAL_EMAIL_ADDRESS	VARCHAR2(128)	No
ROTEMAL_STATUS_IND	VARCHAR2(1)	No
ROTEMAL_PREFERRED_IND	VARCHAR2(1)	No
ROTEMAL_ACTIVITY_DATE	DATE	No
ROTEMAL_USER_ID	VARCHAR2(30)	No
ROTEMAL_COMMENT	VARCHAR2(60)	Yes
ROTEMAL_DISP_WEB_IND	VARCHAR2(1)	No
ROTEMAL_INFC_CODE	VARCHAR2(7)	No
ROTEMAL_AIDY_CODE	VARCHAR2(4)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ROTEMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL

Index

Index Name	Index Type	Column Name
ROTEMAL_EMAL_INDEX		ROTEMAL_PIDM
ROTEMAL_EMAL_INDEX		ROTEMAL_EMAL_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
ROTEMAL_EMAL_INDEX	SQL Index	S10B80.FAISMGR	Rely On
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.ROTEMAL

Object Dates

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

Source Code Comments

Temporary E-Mail Address Table

Columns Comments for ROTEMAL_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number of the entity who owns this e-mail address information.

Columns Comments for ROTEMAL_EMAL_CODE (# 2)

Source Code Comments

E-MAIL CODE: The code for identifying the type of e-mail address.

Columns Comments for ROTEMAL_EMAIL_ADDRESS (# 3)

Source Code Comments

E-MAIL ADDRESS: The e-mail address for this entity.

Columns Comments for ROTEMAL_STATUS_IND (# 4)

Source Code Comments

E-MAIL STATUS INDICATOR: The current status of the e-mail address.

Columns Comments for ROTEMAL_PREFERRED_IND (# 5)

Source Code Comments

E-MAIL PREFERRED INDICATOR: This column indicates if the e-mail address is the preferred contact address.

Columns Comments for ROTEMAL_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date this record was created or last updated.

Columns Comments for ROTEMAL_USER_ID (# 7)

Source Code Comments

USER ID: The user ID who created or last updated this record.

Columns Comments for ROTEMAL_COMMENT (# 8)

Source Code Comments

E-MAIL COMMENT: This is a free format comment field regarding the e-mail information.

Columns Comments for ROTEMAL_DISP_WEB_IND (# 9)

Source Code Comments

DISPLAY ON WEB INDICATOR: A 'Y' in this field indicates that the e-mail information for this entity may be accessed via Banner Web.

Columns Comments for ROTEMAL_INFC_CODE (# 10)

Source Code Comments

INTERFACE DATA CODE: A code from the Interface Tape Table indicating the source and format of the application record.

Columns Comments for ROTEMAL_AIDY_CODE (# 11)

Source Code Comments

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

Table SARADAP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SARADAP_APPL_NO	NUMBER(2,0)	No	*	*
SARADAP_LEVL_CODE	VARCHAR2(2)	Yes		*
SARADAP_APPL_DATE	DATE	No
SARADAP_APST_CODE	VARCHAR2(1)	No		*
SARADAP_APST_DATE	DATE	No
SARADAP_MAINT_IND	VARCHAR2(1)	No
SARADAP_ADMT_CODE	VARCHAR2(2)	Yes		*
SARADAP_STYP_CODE	VARCHAR2(1)	No		*
SARADAP_CAMP_CODE	VARCHAR2(3)	Yes		*
SARADAP_SITE_CODE	VARCHAR2(3)	Yes		*
SARADAP_COLL_CODE_1	VARCHAR2(2)	Yes		*
SARADAP_DEGC_CODE_1	VARCHAR2(6)	Yes		*
SARADAP_MAJR_CODE_1	VARCHAR2(4)	Yes		*
SARADAP_COLL_CODE_2	VARCHAR2(2)	Yes		*
SARADAP_DEGC_CODE_2	VARCHAR2(6)	Yes		*
SARADAP_MAJR_CODE_2	VARCHAR2(4)	Yes		*
SARADAP_RESD_CODE	VARCHAR2(1)	No		*
SARADAP_FULL_PART_IND	VARCHAR2(1)	Yes		*
SARADAP_SESS_CODE	VARCHAR2(1)	Yes		*
SARADAP_WRSN_CODE	VARCHAR2(2)	Yes		*
SARADAP_INTV_CODE	VARCHAR2(1)	Yes		*
SARADAP_FEE_IND	VARCHAR2(1)	Yes
SARADAP_FEE_DATE	DATE	Yes
SARADAP_ACTIVITY_DATE	DATE	No
SARADAP_RATE_CODE	VARCHAR2(5)	Yes		*
SARADAP_EGOL_CODE	VARCHAR2(2)	Yes		*
SARADAP_EDLV_CODE	VARCHAR2(3)	Yes		*
SARADAP_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE	VARCHAR2(4)	Yes		*
SARADAP_SBGI_CODE	VARCHAR2(6)	Yes		*
SARADAP_RECR_CODE	VARCHAR2(3)	Yes		*
SARADAP_RTYP_CODE	VARCHAR2(2)	Yes		*
SARADAP_DEPT_CODE_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
SARADAP_PROGRAM_1	VARCHAR2(12)	Yes		*
SARADAP_TERM_CODE_CTLG_1	VARCHAR2(6)	Yes		*
SARADAP_MAJR_CODE_1_2	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE_1_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_1_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_1_3	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_121	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_122	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_123	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_1_1	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_1_2	VARCHAR2(4)	Yes		*
SARADAP_PROGRAM_2	VARCHAR2(12)	Yes		*
SARADAP_TERM_CODE_CTLG_2	VARCHAR2(6)	Yes		*
SARADAP_LEVL_CODE_2	VARCHAR2(2)	Yes		*
SARADAP_CAMP_CODE_2	VARCHAR2(3)	Yes		*
SARADAP_MAJR_CODE_2_2	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE_2_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_211	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_212	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_213	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_221	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_222	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_223	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_2_1	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_2_2	VARCHAR2(4)	Yes		*
SARADAP_CURR_RULE_1	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_1_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_3	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_1_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_3	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_1_1	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_1_2	NUMBER(8,0)	Yes		*
SARADAP_CURR_RULE_2	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_2_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_3	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_2_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_3	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_2_1	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_2_2	NUMBER(8,0)	Yes		*
SARADAP_WEB_ACCT_MISC_IND	VARCHAR2(1)	Yes
SARADAP_WEB_CASHIER_USER	VARCHAR2(30)	Yes
SARADAP_WEB_TRANS_NO	NUMBER(8,0)	Yes
SARADAP_WEB_AMOUNT	NUMBER(12,2)	Yes
SARADAP_WEB_RECEIPT_NUMBER	NUMBER(8,0)	Yes
SARADAP_WAIV_CODE	VARCHAR2(4)	Yes		*
SARADAP_DATA_ORIGIN	VARCHAR2(30)	Yes
SARADAP_USER_ID	VARCHAR2(30)	Yes
SARADAP_APPL_PREFERENCE	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARADAP_SITE_CODE	STVSITE_CODE	STVSITE
SARADAP_RECR_CODE	STVRECR_CODE	STVRECR
SARADAP_SBGI_CODE	STVSBGI_CODE	STVSBGI
SARADAP_CCON_RULE_22_1	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_22_2	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_22_3	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_11_1	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_11_2	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_11_3	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_12_1	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_12_2	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_12_3	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_21_1	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_21_2	SORCCON_CCON_RULE	SORCCON
SARADAP_CCON_RULE_21_3	SORCCON_CCON_RULE	SORCCON
SARADAP_MAJR_CODE_MINR_1_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_2_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_1_3	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_221	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_222	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_223	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_MINR_1_1	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_213	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_MINR_2_1	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_212	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_1	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_MINR_2_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_211	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_1	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_1_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_1_2	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_121	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_122	STVMAJR_CODE	STVMAJR
SARADAP_MAJR_CODE_CONC_123	STVMAJR_CODE	STVMAJR
SARADAP_PROGRAM_1	SMRPRLE_PROGRAM	SMRPRLE
SARADAP_PROGRAM_2	SMRPRLE_PROGRAM	SMRPRLE
SARADAP_CURR_RULE_1	SOBCURR_CURR_RULE	SOBCURR
SARADAP_CURR_RULE_2	SOBCURR_CURR_RULE	SOBCURR
SARADAP_CMJR_RULE_1_1	SORCMJR_CMJR_RULE	SORCMJR
SARADAP_CMJR_RULE_1_2	SORCMJR_CMJR_RULE	SORCMJR
SARADAP_CMJR_RULE_2_1	SORCMJR_CMJR_RULE	SORCMJR
SARADAP_CMJR_RULE_2_2	SORCMJR_CMJR_RULE	SORCMJR
SARADAP_CMNR_RULE_1_1	SORCMNR_CMNR_RULE	SORCMNR
SARADAP_CMNR_RULE_1_2	SORCMNR_CMNR_RULE	SORCMNR
SARADAP_CMNR_RULE_2_1	SORCMNR_CMNR_RULE	SORCMNR
SARADAP_CMNR_RULE_2_2	SORCMNR_CMNR_RULE	SORCMNR
SARADAP_ADMT_CODE	STVADMT_CODE	STVADMT
SARADAP_APST_CODE	STVAPST_CODE	STVAPST
SARADAP_CAMP_CODE	STVCAMP_CODE	STVCAMP
SARADAP_CAMP_CODE_2	STVCAMP_CODE	STVCAMP
SARADAP_COLL_CODE_1	STVCOLL_CODE	STVCOLL
SARADAP_COLL_CODE_2	STVCOLL_CODE	STVCOLL
SARADAP_DEGC_CODE_1	STVDEGC_CODE	STVDEGC
SARADAP_DEGC_CODE_2	STVDEGC_CODE	STVDEGC
SARADAP_DEPT_CODE	STVDEPT_CODE	STVDEPT
SARADAP_DEPT_CODE_2	STVDEPT_CODE	STVDEPT
SARADAP_DEPT_CODE_1_2	STVDEPT_CODE	STVDEPT
SARADAP_DEPT_CODE_2_2	STVDEPT_CODE	STVDEPT
SARADAP_EDLV_CODE	STVEDLV_CODE	STVEDLV
SARADAP_EGOL_CODE	STVEGOL_CODE	STVEGOL
SARADAP_INTV_CODE	STVINTV_CODE	STVINTV
SARADAP_LEVL_CODE	STVLEVL_CODE	STVLEVL
SARADAP_LEVL_CODE_2	STVLEVL_CODE	STVLEVL
SARADAP_RATE_CODE	STVRATE_CODE	STVRATE
SARADAP_RESD_CODE	STVRESD_CODE	STVRESD
SARADAP_RTYP_CODE	STVRTYP_CODE	STVRTYP
SARADAP_SESS_CODE	STVSESS_CODE	STVSESS
SARADAP_STYP_CODE	STVSTYP_CODE	STVSTYP
SARADAP_TERM_CODE_ENTRY	STVTERM_CODE	STVTERM
SARADAP_TERM_CODE_CTLG_1	STVTERM_CODE	STVTERM
SARADAP_TERM_CODE_CTLG_2	STVTERM_CODE	STVTERM
SARADAP_WAIV_CODE	STVWAIV_CODE	STVWAIV
SARADAP_WRSN_CODE	STVWRSN_CODE	STVWRSN
SARADAP_TERM_CODE_ENTRY	SORLCUR_TERM_CODE	SORLCUR
SARADAP_APPL_NO	SORLCUR_KEY_SEQNO	SORLCUR
SARADAP_PIDM	SORLCUR_PIDM	SORLCUR
SARADAP_RESD_CODE	SARDCSN_RESD_CODE	SARDCSN
SARADAP_ADMT_CODE	SARDCSN_ADMT_CODE	SARDCSN
SARADAP_STYP_CODE	SARDCSN_STYP_CODE	SARDCSN
SARADAP_SESS_CODE	SARDCSN_SESS_CODE	SARDCSN
SARADAP_FULL_PART_IND	SARDCSN_FULL_PART_IND	SARDCSN
SARADAP_TERM_CODE_ENTRY	SARDCSN_TERM_CODE	SARDCSN
SARADAP_TERM_CODE_ENTRY	SABVWID_TERM_CODE	SABVWID
SARADAP_APPL_NO	SABVWID_APPL_NO	SABVWID
SARADAP_PIDM	SABVWID_PIDM	SABVWID
SARADAP_PIDM	SORHSCH_PIDM	SORHSCH
SARADAP_PIDM	SRBRECR_PIDM	SRBRECR
SARADAP_TERM_CODE_ENTRY	SRBRECR_TERM_CODE	SRBRECR

Index

Index Name	Index Type	Column Name
PK_SARADAP	Unique	SARADAP_PIDM
PK_SARADAP	Unique	SARADAP_TERM_CODE_ENTRY
PK_SARADAP	Unique	SARADAP_APPL_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GOREMAL	SQL Table	S10B80.GENERAL	Join
GORVISA	SQL Table	S10B80.GENERAL	Join
GTVSDAX	SQL Table	S10B80.GENERAL	Join
SABSUPL	SQL Table	S10B80.SATURN	Join
SARAPPD	SQL Table	S10B80.SATURN	Refer (no action)
SARCHKL	SQL Table	S10B80.SATURN	Refer (no action)
SARCHRT	SQL Table	S10B80.SATURN	Refer (no action)
SARCTRL	SQL Table	S10B80.SATURN	Join
SARDSCL	SQL Table	S10B80.SATURN	Refer (no action)
SARQUAN	SQL Table	S10B80.SATURN	Refer (no action)
SARRSRC	SQL Table	S10B80.SATURN	Join
SORCONT	SQL Table	S10B80.SATURN	Join
SORCRSS	SQL Table	S10B80.SATURN	Join
SORGPAT	SQL Table	S10B80.SATURN	Join
SORMADM	SQL Table	S10B80.SATURN	Join
SORMAPS	SQL Table	S10B80.SATURN	Join
SORMRTY	SQL Table	S10B80.SATURN	Join
SORMSTY	SQL Table	S10B80.SATURN	Join
SORPCOL	SQL Table	S10B80.SATURN	Join
SORTEST	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRADDR	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ST_SARADAP_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
MAHACURTEST1	SQL View	S10B80.BANINST1	Use (select)
MAHACURTEST2	SQL View	S10B80.BANINST1	Use (select)
RCVAPL2	SQL View	S10B80.BANINST1	Use (select)
ROVA203	SQL View	S10B80.BANINST1	Use (select)
ROVA204	SQL View	S10B80.BANINST1	Use (select)
ROVA205	SQL View	S10B80.BANINST1	Use (select)
ROVA206	SQL View	S10B80.BANINST1	Use (select)
ROVA207	SQL View	S10B80.BANINST1	Use (select)
ROVA208	SQL View	S10B80.BANINST1	Use (select)
ROVA209	SQL View	S10B80.BANINST1	Use (select)
ROVAD03	SQL View	S10B80.BANINST1	Use (select)
ROVAD04	SQL View	S10B80.BANINST1	Use (select)
ROVAD05	SQL View	S10B80.BANINST1	Use (select)
ROVAD06	SQL View	S10B80.BANINST1	Use (select)
ROVAD07	SQL View	S10B80.BANINST1	Use (select)
ROVAD08	SQL View	S10B80.BANINST1	Use (select)
ROVAD09	SQL View	S10B80.BANINST1	Use (select)
ROVADAP	SQL View	S10B80.BANINST1	Use (select)
ROVAM05	SQL View	S10B80.BANINST1	Use (select)
ROVAM06	SQL View	S10B80.BANINST1	Use (select)
ROVAM07	SQL View	S10B80.BANINST1	Use (select)
ROVAM08	SQL View	S10B80.BANINST1	Use (select)
ROVAM09	SQL View	S10B80.BANINST1	Use (select)
ROVAY05	SQL View	S10B80.BANINST1	Use (select)
ROVAY06	SQL View	S10B80.BANINST1	Use (select)
ROVAY07	SQL View	S10B80.BANINST1	Use (select)
ROVAY08	SQL View	S10B80.BANINST1	Use (select)
ROVAY09	SQL View	S10B80.BANINST1	Use (select)
ROVSTU2	SQL View	S10B80.BANINST1	Use (select)
ROVSTU3	SQL View	S10B80.BANINST1	Join
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
SAVACUR	SQL View	S10B80.BANINST1	Use (select)
SAVADM2	SQL View	S10B80.BANINST1	Use (select)
SAVADM2_LATEST	SQL View	S10B80.BANINST1	Use (select)
SAVADM2_N	SQL View	S10B80.BANINST1	Use (select)
SAVADMT	SQL View	S10B80.BANINST1	Use (select)
SAVADRS	SQL View	S10B80.BANINST1	Use (select)
SAVAMC2	SQL View	S10B80.BANINST1	Use (select)
SAVAMCD	SQL View	S10B80.BANINST1	Use (select)
SAVAMCT	SQL View	S10B80.BANINST1	Use (select)
SAVAPDC	SQL View	S10B80.BANINST1	Join
SAVAPDC	SQL View	S10B80.BANINST1	Use (select)
SAVAPDC_EXP	SQL View	S10B80.BANINST1	Use (select)
SAVAPDC_EXP1	SQL View	S10B80.BANINST1	Use (select)
SAVAPDC_OBJ	SQL View	S10B80.BANINST1	Use (select)
SAVCCUR	SQL View	S10B80.BANINST1	Use (select)
SAVCHRT	SQL View	S10B80.BANINST1	Use (select)
SAVDCSN	SQL View	S10B80.BANINST1	Use (select)
SAVLIF1	SQL View	S10B80.BANINST1	Use (select)
SAVPCO1	SQL View	S10B80.BANINST1	Use (select)
SAVSEC1	SQL View	S10B80.BANINST1	Use (select)
SAVSTRG	SQL View	S10B80.BANINST1	Use (select)
SAVTEST1	SQL View	S10B80.BANINST1	Use (select)
SOVAREC	SQL View	S10B80.BANINST1	Use (select)
SOVCFOS	SQL View	S10B80.BANINST1	Join
SOVCOLL	SQL View	S10B80.BANINST1	Use (select)
SOVCOLL_OJ	SQL View	S10B80.BANINST1	Use (select)
SOVCOLL_OLD	SQL View	S10B80.BANINST1	Use (select)
SOVHSCH	SQL View	S10B80.BANINST1	Use (select)
SOVLCUR	SQL View	S10B80.BANINST1	Join
SOVLFOS	SQL View	S10B80.BANINST1	Join
SOVSCOR	SQL View	S10B80.BANINST1	Use (select)
SOVSCOR_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVSTRG	SQL View	S10B80.BANINST1	Use (select)
SRVLIF1	SQL View	S10B80.BANINST1	Use (select)
SRVPCO1	SQL View	S10B80.BANINST1	Use (select)
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
SRVSEC1	SQL View	S10B80.BANINST1	Use (select)
SRVSTRG	SQL View	S10B80.BANINST1	Use (select)
F_ADMS_APPLICANT_FNC	SQL Function	S10B80.BANINST1	Rely On
F_ADMS_APPLICANT_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_ADMS_APPLICANT_WITHDRAWN	SQL Function	S10B80.BANINST1	Use (select)
F_ADMS_APPLICATION_STATUS	SQL Function	S10B80.BANINST1	Use (select)
F_APPLIED_ADMISSIONS	SQL Function	S10B80.BANINST1	Use (select)
F_GET_CURRENT_SARADAP_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_SORCONT_CONTACT_DATE	SQL Function	S10B80.BANINST1	Rely On
F_LEVEL_ADMITTED_FNC	SQL Function	S10B80.BANINST1	Rely On
F_LEVEL_ADMITTED_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_LEVEL_APPL_FNC	SQL Function	S10B80.BANINST1	Rely On
F_LEVEL_APPL_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_ADMISSIONS_IND	SQL Function	S10B80.BANINST1	Use (select)
ADMISSIONSAPPLICATION_REC	Oracle Package Type	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
SARADAP_TAB_TYPE	Oracle Package Type	S10B80.BANINST1.SOKTABS	Rely On
G_TERMCODE	Oracle Package Variable	S10B80.BANINST1.EOKSLNK	Rely On
SARADAP_BY_AIDM_APPL_C	Oracle Package Cursor	S10B80.BANINST1.BWSKAPRF	Rely On
SARADAP_BY_AIDM_APPL_C	Oracle Package Cursor	S10B80.BANINST1.BWSKAPRF	Use (select)
SARADAP_DISP_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
SARADAP_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
P_ADMIT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_BUILDSOTWADA	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_DELETE_STUDENT	Oracle Package Procedure	S10B80.BANINST1.UT_GRADEROLL	Use (delete)
P_DELETE_STUDENT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Use (delete,select)
P_LOAD_APPLICATION_ONE_OR_MANY	Oracle Package Procedure	S10B80.BANINST1.SAKL010	Rely On
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
P_PRINT_APPLICANT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_PRINT_APPLICANT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Use (select)Rely On
P_STUDENT_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.UT_GRADEROLL	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_TEST_DRIVER	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_GRADEROLL	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_REGISTRATION	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TEST_PACKAGE	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_STUDENT_OAPERF	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING	Rely On
APPL_NO	Oracle Package Variable	S10B80.BANINST1.UT_SRRINQR	Rely On
GV_APPL_NO_INOUT	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_SARADAP_REC	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
F_GET_APPL_NO	Oracle Package Function	S10B80.BANINST1.SAKL010	Use (select)
F_LFOS_ORDER_EXISTS	Oracle Package Function	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
F_MATCH_SARADAP	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
F_ORDER_EXISTS	Oracle Package Function	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
F_VERIFY_STUDENT	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
SARADAPC	Oracle Package Cursor	S10B80.BANINST1.SAKLIBS	Use (select)Rely On
SARADAP_BY_PIDM_APPL_C	Oracle Package Cursor	S10B80.BANINST1.SAKLIBS	Rely On
SARADAP_BY_PIDM_APPL_C	Oracle Package Cursor	S10B80.BANINST1.SAKLIBS	Use (select)Rely On
SARADAP_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SAKLIBS	Rely On
SARADAP_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SAKLIBS	Use (select)Rely On
SARADAP_ROW_BY_PIDM_TERM_C	Oracle Package Cursor	S10B80.BANINST1.SAKSELS	Rely On
SARADAP_ROW_BY_PIDM_TERM_C	Oracle Package Cursor	S10B80.BANINST1.SAKSELS	Use (select)Rely On
P_AUTO_DECISION	Oracle Package Procedure	S10B80.BANINST1.SAKDCSN	Rely On
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Use (select)Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
P_CREATE_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Rely On
P_CREATE_RECRUIT_ROWS	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_DECISION_PROCESSING	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SARADAP	Use (delete)
P_DELETE_APPLICATIONS	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_DISPAPPLICATIONS	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISPCHOICES	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_DISPCURSOURCESARADAP	Oracle Package Procedure	S10B80.BANINST1.BWCKCAPP	Rely On
P_DISPSTATUS	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISPSTATUSSARADAP	Oracle Package Procedure	S10B80.BANINST1.BWSKASTA	Rely On
P_DISP_PREF	Oracle Package Procedure	S10B80.BANINST1.BWSKAPRF	Rely On
P_GET_SARADAP	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Use (select)Rely On
P_GET_SARADAP_ROWS	Oracle Package Procedure	S10B80.BANINST1.SAKFUNC	Rely On
P_GET_SARADAP_ROWS	Oracle Package Procedure	S10B80.BANINST1.SAKFUNC	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SARADAP	Use (Insert)Rely On
P_INSERT_ATTRIBUTE	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Rely On
P_INSERT_COHORT	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Rely On
P_INSERT_SARCHKL	Oracle Package Procedure	S10B80.BANINST1.EOKSLNK	Rely On
P_INSERT_SARCHKL	Oracle Package Procedure	S10B80.BANINST1.EOKSLNK	Use (select)
P_INSERT_SARRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SARRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Rely On
P_INSERT_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Use (select)
P_INTL_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_INTL_UPDCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_INTL_UPDCOMMENT	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_LEARNER_ADMITREPLACE	Oracle Package Procedure	S10B80.BANINST1.SAKDCSN	Rely On
P_LOAD_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.SAKL010	Rely On
P_LOAD_SARQUAN	Oracle Package Procedure	S10B80.BANINST1.SAKL170	Rely On
P_LOAD_SARQUAN	Oracle Package Procedure	S10B80.BANINST1.SAKL170	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_NEWAPPCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)Rely On
P_PROCESS_DECSN	Oracle Package Procedure	S10B80.BANINST1.SAKDCSN	Rely On
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_PROC_PREF	Oracle Package Procedure	S10B80.BANINST1.BWSKAPRF	Use (update)
P_QUICK_ADMIT	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION_RULES	Rely On
P_REVIEWDECISION	Oracle Package Procedure	S10B80.BANINST1.SAKDCRV	Rely On
P_REVIEWDECISION	Oracle Package Procedure	S10B80.BANINST1.SAKDCRV	Rely On
P_SARCHKB_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Rely On
P_SARCHKB_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)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	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_SORTEST_INSCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_SORTEST_UPDCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_UPDAPPCHECKLIST	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_UPDAPPSTATUS	Oracle Package Procedure	S10B80.BANINST1.SAKCHKB	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SARADAP	Use (update)Rely On
P_UPDATE_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.DML_SARADAP	Rely On
P_UPDATE_SARADAP_APST	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION_RULES	Rely On
P_VR_APPLY_CC_PAYMENT	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_BIL_OPTIONS_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_BUILD_BAD_CC_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_BUILD_PAYMENT_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_GIVE_DECISION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_GIVE_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_NO_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_ADM_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_BAD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BAD_EXPDATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_BILLING_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_CC_NUMBER_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_CC_STATUS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_DETAIL_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_DIFF_AMOUNT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXPIR_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_EXP_DATE_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_GOOD_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_MISSING_REQMNTS	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MORE_REQ	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROCESS_MULTI_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_REVIEW_OPTIONS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROCESS_SINGLE_CC_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCESS_TOTAL_AMT_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROCES_NONSTU_DET_OPT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_PROMPT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_PROMPT_CC_NUMBER	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_PROMPT_EXP_DATE	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
P_VR_REVIEW_CHRGS_AND_PYMNTS	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_BALANCE	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REVIEW_NONSTU_DETAIL_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_AND_SPK_ACCT_MENU	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_REV_NONSTU_CHRG_AND_PMNT	Oracle Package Procedure	S10B80.BANINST1.VRTKSBIL	Rely On
P_VR_SELECT_ANOTHER_APPL	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_SELECT_APPLICATION	Oracle Package Procedure	S10B80.BANINST1.VRSKAADM	Rely On
P_VR_VERIFY_CREDIT_CARD	Oracle Package Procedure	S10B80.BANINST1.VRTKSPAY	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_APPLICATION_DECISION	Use (Insert,select)
F_APPLICANT_IND	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
F_CHECKCURRICULUM	Oracle Package Function	S10B80.BANINST1.SAKDCRV	Rely On
F_CHECK_FOR_MANDATORY_IND	Oracle Package Function	S10B80.BANINST1.SAKSELS	Rely On
F_CHECK_SARADAP	Oracle Package Function	S10B80.BANINST1.EOKSLNK	Use (select)
F_CHECK_SARADAP_ALL	Oracle Package Function	S10B80.BANINST1.EOKSLNK	Use (select)
F_CHECK_SARADAP_TERM	Oracle Package Function	S10B80.BANINST1.EOKSLNK	Use (select)
F_CHKRATING	Oracle Package Function	S10B80.BANINST1.SAKDCRV	Rely On
F_CONVERT_APPLICANT	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Rely On
F_CONVERT_APPLICANT	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Use (select)
F_CREATE_LEARNER	Oracle Package Function	S10B80.BANINST1.SAKDCSN	Rely On
F_CURRICULUM	Oracle Package Function	S10B80.BANINST1.LCURTEST	Rely On
F_DUPAPPL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Rely On
F_DUPAPPL	Oracle Package Function	S10B80.BANINST1.SAKPCOM	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_FIELDOFSTUDY	Oracle Package Function	S10B80.BANINST1.SOKCCUR	Rely On
F_FIELDOFSTUDY	Oracle Package Function	S10B80.BANINST1.LCURTEST	Rely On
F_FIND_ACCEPTABLE	Oracle Package Function	S10B80.BANINST1.SAKDCSN	Rely On
F_FIND_EXISTING_CURR_MATCH	Oracle Package Function	S10B80.BANINST1.SAKDCSN	Rely On
F_FIND_IF_STUDENT	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_FIND_IF_STUDENT_FINAID	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_FIRST_TIME_BORROWER	Oracle Package Function	S10B80.BANINST1.RPKLOAN	Use (select)
F_GETSARADAPSEQNO	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_GET_SARADAP_ROWID	Oracle Package Function	S10B80.BANINST1.EOKSLNK	Use (select)
F_HIGHSCHOOL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Rely On
F_HIGHSCHOOL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Rely On
F_INTACCEPT_IND	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_QUERY_BY_PREFERENCE	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (select)
F_RECRUIT_IND	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
F_TEST_SARADAP_EXIST	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
F_TEST_SARADAP_SECD	Oracle Package Function	S10B80.BANINST1.BWCKCMPL	Use (select)
F_TEST_SARADAP_SECD	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Use (select)
SARADAP	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_SARADAP	SQL Index	S10B80.SATURN	Rely On
SABVWID	SQL Table	S10B80.SATURN	Join
SARDCSN	SQL Table	S10B80.SATURN	Join
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
SOBCURR	SQL Table	S10B80.SATURN	Refer (no action)
SORCCON	SQL Table	S10B80.SATURN	Refer (no action)
SORCMJR	SQL Table	S10B80.SATURN	Refer (no action)
SORCMNR	SQL Table	S10B80.SATURN	Refer (no action)
SORHSCH	SQL Table	S10B80.SATURN	Join
SORLCUR	SQL Table	S10B80.SATURN	Join
SRBRECR	SQL Table	S10B80.SATURN	Join
STVADMT	SQL Table	S10B80.SATURN	Refer (no action)
STVAPST	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVEDLV	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVINTV	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVRATE	SQL Table	S10B80.SATURN	Refer (no action)
STVRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVRESD	SQL Table	S10B80.SATURN	Refer (no action)
STVRTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSESS	SQL Table	S10B80.SATURN	Refer (no action)
STVSITE	SQL Table	S10B80.SATURN	Refer (no action)
STVSTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWAIV	SQL Table	S10B80.SATURN	Refer (no action)
STVWRSN	SQL Table	S10B80.SATURN	Refer (no action)
ST_ICAIR_APPLICATION_RECEIVED	SQL Trigger	S10B80.SATURN	Fire (Insert,after,each row)
ST_SARADAP_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SARADAP_AS_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SARADAP

Object Dates

Creation Date	Analysis Date
04/02/2008 21:04:44:000	04/02/2008 21:18:24:000

Source Code Comments

Admissions Application Repeating Table

Lock

Permanently locked by DAM

Columns Comments for SARADAP_PIDM (# 1)

Source Code Comments

This field identifies the applicant internal identification number.

Columns Comments for SARADAP_TERM_CODE_ENTRY (# 2)

Source Code Comments

This field identifies the term associated with the information on applicant record.

Columns Comments for SARADAP_APPL_NO (# 3)

Source Code Comments

This field identifies the application number of the admissions record for a specific term.

Columns Comments for SARADAP_LEVL_CODE (# 4)

Source Code Comments

This field identifies the level to which the applicant is applying.

Columns Comments for SARADAP_APPL_DATE (# 5)

Source Code Comments

This field identifies the date of the application record.

Columns Comments for SARADAP_APST_CODE (# 6)

Source Code Comments

This field identifies the status of the application.

Columns Comments for SARADAP_APST_DATE (# 7)

Source Code Comments

This field identifies the date associated with the most current status of the application.

Columns Comments for SARADAP_MAINT_IND (# 8)

Source Code Comments

This field identifies whether the status of the application is being maintained by the system or the user.

Columns Comments for SARADAP_ADMT_CODE (# 9)

Source Code Comments

This field identifies the admission type of the applicant.

Columns Comments for SARADAP_STYP_CODE (# 10)

Source Code Comments

This field identifies the type of student the applicant will become if admitted.

Columns Comments for SARADAP_CAMP_CODE (# 11)

Source Code Comments

This field identifies the campus to which applicant is applying.

Columns Comments for SARADAP_SITE_CODE (# 12)

Source Code Comments

This field identifies the site to which applicant is applying.

Columns Comments for SARADAP_COLL_CODE_1 (# 13)

Source Code Comments

This field identifies the primary college to which applicant is applying.

Columns Comments for SARADAP_DEGC_CODE_1 (# 14)

Source Code Comments

This field identifies the primary degree to which applicant is applying.

Columns Comments for SARADAP_MAJR_CODE_1 (# 15)

Source Code Comments

This field identifies the primary major to which applicant is applying.

Columns Comments for SARADAP_COLL_CODE_2 (# 16)

Source Code Comments

Curriculum 2 College Code

Columns Comments for SARADAP_DEGC_CODE_2 (# 17)

Source Code Comments

This field identifies the secondary degree to which applicant is applying.

Columns Comments for SARADAP_MAJR_CODE_2 (# 18)

Source Code Comments

This field identifies the secondary major to which applicant is applying.

Columns Comments for SARADAP_RESD_CODE (# 19)

Source Code Comments

This field identifies the residency classification of the applicant.

Columns Comments for SARADAP_FULL_PART_IND (# 20)

Source Code Comments

This field identifies if applicant intention is for full or part time enrollment.

Columns Comments for SARADAP_SESS_CODE (# 21)

Source Code Comments

This field identifies which session applicant is applying for.

Columns Comments for SARADAP_WRSN_CODE (# 22)

Source Code Comments

This field identifies the reason why an application has been withdrawn.

Columns Comments for SARADAP_INTV_CODE (# 23)

Source Code Comments

This field identifies the status of the interview associated with the applicant.

Columns Comments for SARADAP_FEE_IND (# 24)

Source Code Comments

This field identifies whether an application fee has been assessed.

Columns Comments for SARADAP_FEE_DATE (# 25)

Source Code Comments

This field identifies the date application fee has been assessed.

Columns Comments for SARADAP_ACTIVITY_DATE (# 26)

Source Code Comments

This field identifies the most current date record was created or changed.

Columns Comments for SARADAP_RATE_CODE (# 27)

Source Code Comments

This field identifies a specific assessment rate assigned to the student.

Columns Comments for SARADAP_EGOL_CODE (# 28)

Source Code Comments

Educational Goal Code

Columns Comments for SARADAP_EDLV_CODE (# 29)

Source Code Comments

Education Level Code

Columns Comments for SARADAP_MAJR_CODE_CONC_1 (# 30)

Source Code Comments

Area of Concentration code.

Columns Comments for SARADAP_DEPT_CODE (# 31)

Source Code Comments

Department Code.

Columns Comments for SARADAP_SBGI_CODE (# 32)

Source Code Comments

Institution Attending code. Thisfield represents the institution the student decided to attend rather than the home institution.

Columns Comments for SARADAP_RECR_CODE (# 33)

Source Code Comments

Recruiter Code.

Columns Comments for SARADAP_RTYP_CODE (# 34)

Source Code Comments

Recruit Type code.

Columns Comments for SARADAP_DEPT_CODE_2 (# 35)

Source Code Comments

Department Code for second curriculum.

Columns Comments for SARADAP_MAJR_CODE_CONC_2 (# 36)

Source Code Comments

Area of Concentration code.

Columns Comments for SARADAP_PROGRAM_1 (# 37)

Source Code Comments

Curriculum 1 Program Code

Columns Comments for SARADAP_TERM_CODE_CTLG_1 (# 38)

Source Code Comments

Curriculum 1 Catalog Term Code

Columns Comments for SARADAP_MAJR_CODE_1_2 (# 39)

Source Code Comments

Major Code 2 on First Curriculum

Columns Comments for SARADAP_DEPT_CODE_1_2 (# 40)

Source Code Comments

Department Code 2 on First Curriculum

Columns Comments for SARADAP_MAJR_CODE_CONC_1_2 (# 41)

Source Code Comments

Concentration Code 2 on Major 1, Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_CONC_1_3 (# 42)

Source Code Comments

Concentration Code 3 on Major 1, Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_CONC_121 (# 43)

Source Code Comments

Concentration Code 1 onMajor 2, Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_CONC_122 (# 44)

Source Code Comments

Concentration Code 2 on Major 2, Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_CONC_123 (# 45)

Source Code Comments

Concentration Code 3 on Major 2, Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_MINR_1_1 (# 46)

Source Code Comments

Minor Code 1 on Curriculum 1

Columns Comments for SARADAP_MAJR_CODE_MINR_1_2 (# 47)

Source Code Comments

Minor 2 on Curriculum 1

Columns Comments for SARADAP_PROGRAM_2 (# 48)

Source Code Comments

Curriculum 2 Program Code

Columns Comments for SARADAP_TERM_CODE_CTLG_2 (# 49)

Source Code Comments

Curriculum 2 Catalog Term Code

Columns Comments for SARADAP_LEVL_CODE_2 (# 50)

Source Code Comments

Curriculum 2 Level Code

Columns Comments for SARADAP_MAJR_CODE_2_2 (# 52)

Source Code Comments

Major Code 2 on Curriculum 2

Columns Comments for SARADAP_DEPT_CODE_2_2 (# 53)

Source Code Comments

Department Code 2 on Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_211 (# 54)

Source Code Comments

Concentration Code 1 on MAjor 1, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_212 (# 55)

Source Code Comments

Concentration Code 2 on Major 1, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_213 (# 56)

Source Code Comments

Concentration Code 3 on Major 1, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_221 (# 57)

Source Code Comments

Concentration Code 1 on Major 2, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_222 (# 58)

Source Code Comments

Concentration Code 2 on Major 2, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_CONC_223 (# 59)

Source Code Comments

Concentration Code 3 on Major 3, Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_MINR_2_1 (# 60)

Source Code Comments

Minor Code 1 on Curriculum 2

Columns Comments for SARADAP_MAJR_CODE_MINR_2_2 (# 61)

Source Code Comments

Minor Code 2 on Curriculum 2

Columns Comments for SARADAP_CURR_RULE_1 (# 62)

Source Code Comments

Curriculum 1 Rule reference

Columns Comments for SARADAP_CMJR_RULE_1_1 (# 63)

Source Code Comments

Curriculum 1 Major 1 Rule Reference

Columns Comments for SARADAP_CCON_RULE_11_1 (# 64)

Source Code Comments

Concentration 1, Major 1, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CCON_RULE_11_2 (# 65)

Source Code Comments

Concentration 2, Major 1, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CCON_RULE_11_3 (# 66)

Source Code Comments

Concentration 3, Major 1, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CMJR_RULE_1_2 (# 67)

Source Code Comments

Major 2, Curriculum Rule Reference

Columns Comments for SARADAP_CCON_RULE_12_1 (# 68)

Source Code Comments

Concentration 1, Major 2, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CCON_RULE_12_2 (# 69)

Source Code Comments

Concentration 2, Major 2, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CCON_RULE_12_3 (# 70)

Source Code Comments

Concentration 3, Major 2, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CMNR_RULE_1_1 (# 71)

Source Code Comments

Minor 1, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CMNR_RULE_1_2 (# 72)

Source Code Comments

Minor 2, Curriculum 1 Rule Reference

Columns Comments for SARADAP_CURR_RULE_2 (# 73)

Source Code Comments

Curriculum 2 Rule Reference

Columns Comments for SARADAP_CMJR_RULE_2_1 (# 74)

Source Code Comments

Major 1, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_21_1 (# 75)

Source Code Comments

Concentration 1, Major 1, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_21_2 (# 76)

Source Code Comments

Concentration 2, Major 1, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_21_3 (# 77)

Source Code Comments

Concentration 3, Major 1, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CMJR_RULE_2_2 (# 78)

Source Code Comments

Major 2, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_22_1 (# 79)

Source Code Comments

Concentration 1, Major 2, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_22_2 (# 80)

Source Code Comments

Concentration 2, Major 2, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CCON_RULE_22_3 (# 81)

Source Code Comments

Concentration 3, Major 2, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CMNR_RULE_2_1 (# 82)

Source Code Comments

Minor 1, Curriculum 2 Rule Reference

Columns Comments for SARADAP_CMNR_RULE_2_2 (# 83)

Source Code Comments

Minor 2, Curriculum 2 Rule Reference

Columns Comments for SARADAP_WEB_ACCT_MISC_IND (# 84)

Source Code Comments

Indicator to identify where receivable for web entered credit card payment for application fee is found. Values are M for misc, T for tbraccd.

Columns Comments for SARADAP_WEB_CASHIER_USER (# 85)

Source Code Comments

User of cashier on transaction for web entered credit card payment for application fee.

Columns Comments for SARADAP_WEB_TRANS_NO (# 86)

Source Code Comments

Transaction number of cashier on transaction for web entered credit card payment for application fee.

Columns Comments for SARADAP_WEB_AMOUNT (# 87)

Source Code Comments

Amount of transaction for web entered credit card payment for application fee.

Columns Comments for SARADAP_WEB_RECEIPT_NUMBER (# 88)

Source Code Comments

Receipt number on transaction for web entered credit card payment for application fee.

Columns Comments for SARADAP_WAIV_CODE (# 89)

Source Code Comments

Application fee waiver reason.

Columns Comments for SARADAP_DATA_ORIGIN (# 90)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SARADAP_USER_ID (# 91)

Source Code Comments

USER ID: The most recent user to create or update a record.

Columns Comments for SARADAP_APPL_PREFERENCE (# 92)

Source Code Comments

APPLICATION PREFERENECE: A number designating the ordinal preference of the application.

Table SPBPERS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_SSN	VARCHAR2(15)	Yes
SPBPERS_BIRTH_DATE	DATE	Yes
SPBPERS_LGCY_CODE	VARCHAR2(1)	Yes		*
SPBPERS_ETHN_CODE	VARCHAR2(2)	Yes		*
SPBPERS_MRTL_CODE	VARCHAR2(1)	Yes		*
SPBPERS_RELG_CODE	VARCHAR2(2)	Yes		*
SPBPERS_SEX	VARCHAR2(1)	Yes
SPBPERS_CONFID_IND	VARCHAR2(1)	Yes
SPBPERS_DEAD_IND	VARCHAR2(1)	Yes
SPBPERS_VETC_FILE_NUMBER	VARCHAR2(10)	Yes
SPBPERS_LEGAL_NAME	VARCHAR2(500)	Yes
SPBPERS_PREF_FIRST_NAME	VARCHAR2(60)	Yes
SPBPERS_NAME_PREFIX	VARCHAR2(20)	Yes
SPBPERS_NAME_SUFFIX	VARCHAR2(20)	Yes
SPBPERS_ACTIVITY_DATE	DATE	No
SPBPERS_VERA_IND	VARCHAR2(1)	Yes
SPBPERS_CITZ_IND	VARCHAR2(1)	Yes
SPBPERS_DEAD_DATE	DATE	Yes
SPBPERS_PIN	RAW(1)	Yes
SPBPERS_CITZ_CODE	VARCHAR2(2)	Yes		*
SPBPERS_HAIR_CODE	VARCHAR2(2)	Yes
SPBPERS_EYES_CODE	VARCHAR2(2)	Yes
SPBPERS_CITY_BIRTH	VARCHAR2(50)	Yes
SPBPERS_STAT_CODE_BIRTH	VARCHAR2(3)	Yes		*
SPBPERS_DRIVER_LICENSE	VARCHAR2(20)	Yes
SPBPERS_STAT_CODE_DRIVER	VARCHAR2(3)	Yes		*
SPBPERS_NATN_CODE_DRIVER	VARCHAR2(5)	Yes		*
SPBPERS_UOMS_CODE_HEIGHT	VARCHAR2(4)	Yes		*
SPBPERS_HEIGHT	NUMBER(2,0)	Yes
SPBPERS_UOMS_CODE_WEIGHT	VARCHAR2(4)	Yes		*
SPBPERS_WEIGHT	NUMBER(4,0)	Yes
SPBPERS_SDVET_IND	VARCHAR2(1)	Yes
SPBPERS_LICENSE_ISSUED_DATE	DATE	Yes
SPBPERS_LICENSE_EXPIRES_DATE	DATE	Yes
SPBPERS_INCAR_IND	VARCHAR2(1)	Yes
SPBPERS_WEBID	RAW(1)	Yes
SPBPERS_WEB_LAST_ACCESS	RAW(1)	Yes
SPBPERS_PIN_DISABLED_IND	RAW(1)	Yes
SPBPERS_ITIN	NUMBER(9,0)	Yes
SPBPERS_ACTIVE_DUTY_SEPR_DATE	DATE	Yes
SPBPERS_DATA_ORIGIN	VARCHAR2(30)	Yes
SPBPERS_USER_ID	VARCHAR2(30)	Yes
SPBPERS_ETHN_CDE	VARCHAR2(1)	Yes
SPBPERS_CONFIRMED_RE_CDE	VARCHAR2(1)	Yes
SPBPERS_CONFIRMED_RE_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPBPERS_UOMS_CODE_HEIGHT	GTVUOMS_CODE	GTVUOMS
SPBPERS_UOMS_CODE_WEIGHT	GTVUOMS_CODE	GTVUOMS
SPBPERS_NATN_CODE_DRIVER	STVNATN_CODE	STVNATN
SPBPERS_RELG_CODE	STVRELG_CODE	STVRELG
SPBPERS_STAT_CODE_BIRTH	STVSTAT_CODE	STVSTAT
SPBPERS_STAT_CODE_DRIVER	STVSTAT_CODE	STVSTAT
SPBPERS_CITZ_CODE	STVCITZ_CODE	STVCITZ
SPBPERS_MRTL_CODE	STVMRTL_CODE	STVMRTL
SPBPERS_ETHN_CODE	STVETHN_CODE	STVETHN
SPBPERS_LGCY_CODE	STVLGCY_CODE	STVLGCY
SPBPERS_PIDM	SARADAP_PIDM	SARADAP
SPBPERS_PIDM	SHRTTRM_PIDM	SHRTTRM
SPBPERS_PIDM	RORSTAT_PIDM	RORSTAT
SPBPERS_CITZ_CODE	SARDCSN_CITZ_CODE	SARDCSN
SPBPERS_PIDM	APRDHIS_PIDM	APRDHIS
SPBPERS_PIDM	SLRRMAT_PIDM	SLRRMAT
SPBPERS_PIDM	SFBETRM_PIDM	SFBETRM
SPBPERS_PIDM	SRBRECR_PIDM	SRBRECR
SPBPERS_PIDM	SGBSTDN_PIDM	SGBSTDN
SPBPERS_PIDM	RPRATRM_PIDM	RPRATRM
SPBPERS_PIDM	GORSEVD_DEP_PIDM	GORSEVD
SPBPERS_PIDM	GOBSEVS_PIDM	GOBSEVS
SPBPERS_PIDM	APRCHIS_PIDM	APRCHIS
SPBPERS_PIDM	PEBEMPL_PIDM	PEBEMPL
SPBPERS_PIDM	NBRBJOB_PIDM	NBRBJOB
SPBPERS_PIDM	GOREMAL_PIDM	GOREMAL
SPBPERS_PIDM	SPRMEDI_PIDM	SPRMEDI
SPBPERS_PIDM	APRACYR_PIDM	APRACYR

Index

Index Name	Index Type	Column Name
PK_SPBPERS	Unique	SPBPERS_PIDM
SPBPERS_SSN_INDEX		SPBPERS_SSN

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRCHLD	SQL Table	S10B80.ALUMNI	Join
APRCSPS	SQL Table	S10B80.ALUMNI	Join
APRXREF	SQL Table	S10B80.ALUMNI	Join
PABAPPL	SQL Table	S10B80.PAYROLL	Join
PDRBENE	SQL Table	S10B80.PAYROLL	Join
RPRAWRD	SQL Table	S10B80.FAISMGR	Join
SHRNCRS	SQL Table	S10B80.SATURN	Join
SLRRASG	SQL Table	S10B80.SATURN	Join
SORMCTZ	SQL Table	S10B80.SATURN	Join
SORMETH	SQL Table	S10B80.SATURN	Join
SORMLGY	SQL Table	S10B80.SATURN	Join
SORMSEX	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ST_SPBPERS_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
ADVDSG1	SQL View	S10B80.BANINST1	Use (select)
AFVCMP1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD1	SQL View	S10B80.BANINST1	Use (select)
AGVGFD2	SQL View	S10B80.BANINST1	Join
AGVGIV1	SQL View	S10B80.BANINST1	Use (select)
AGVGMD1	SQL View	S10B80.BANINST1	Use (select)
AGVGMEM	SQL View	S10B80.BANINST1	Join
AGVPLD1	SQL View	S10B80.BANINST1	Use (select)
AGVPLD2	SQL View	S10B80.BANINST1	Join
AOVIDEN	SQL View	S10B80.BANINST1	Use (select)
AOVORG1	SQL View	S10B80.BANINST1	Use (select)
APVBRWS	SQL View	S10B80.BANINST1	Use (select)
APVCHLD	SQL View	S10B80.BANINST1	Use (select)
APVCNI1	SQL View	S10B80.BANINST1	Use (select)
APVCSPS	SQL View	S10B80.BANINST1	Use (select)
APVENTY	SQL View	S10B80.BANINST1	Join
APVXREF	SQL View	S10B80.BANINST1	Use (select)
AT_AR_BALANCE_BY_ENTITY	SQL View	S10B80.BANINST1	Use (select)
GOVSRVR	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)
GPVENT1	SQL View	S10B80.BANINST1	Use (select)
GUVALTI	SQL View	S10B80.BANINST1	Use (select)
PAVAPPL	SQL View	S10B80.BANINST1	Use (select)
PAVREQ1	SQL View	S10B80.BANINST1	Use (select)
PDVBENE	SQL View	S10B80.BANINST1	Use (select)
PDVDED1	SQL View	S10B80.BANINST1	Use (select)
PEVACP0	SQL View	S10B80.BANINST1	Use (select)
PEVACP1	SQL View	S10B80.BANINST1	Join
PEVDEG0	SQL View	S10B80.BANINST1	Use (select)
PEVDEG1	SQL View	S10B80.BANINST1	Join
PEVEMPL	SQL View	S10B80.BANINST1	Use (select)
PEVJOB1	SQL View	S10B80.BANINST1	Use (select)
PEVPRF1	SQL View	S10B80.BANINST1	Use (select)
PEVREC0	SQL View	S10B80.BANINST1	Use (select)
PEVREC1	SQL View	S10B80.BANINST1	Join
PEVVER2	SQL View	S10B80.BANINST1	Use (select)
RCVAPL2	SQL View	S10B80.BANINST1	Use (select)
ROVFINS	SQL View	S10B80.BANINST1	Use (select)
ROVSTU3	SQL View	S10B80.BANINST1	Use (select)
RPVAWT2	SQL View	S10B80.BANINST1	Use (select)
RPVAWY2	SQL View	S10B80.BANINST1	Use (select)
SAVADM2_N	SQL View	S10B80.BANINST1	Use (select)
SAVADMT	SQL View	S10B80.BANINST1	Use (select)
SAVAMC2	SQL View	S10B80.BANINST1	Use (select)
SAVAMCD	SQL View	S10B80.BANINST1	Use (select)
SAVDCSN	SQL View	S10B80.BANINST1	Use (select)
SAVLIF1	SQL View	S10B80.BANINST1	Use (select)
SFVSTDN	SQL View	S10B80.BANINST1	Use (select)
SGVSTDN	SQL View	S10B80.BANINST1	Use (select)
SHVDTL2_OLD	SQL View	S10B80.BANINST1	Use (select)
SHVIPED	SQL View	S10B80.BANINST1	Use (select)
SHVIPED_OJ	SQL View	S10B80.BANINST1	Use (select)
SHVTER1	SQL View	S10B80.BANINST1	Use (select)
SHVYEA1	SQL View	S10B80.BANINST1	Use (select)
SLVRMAT	SQL View	S10B80.BANINST1	Use (select)
SLVRUSE	SQL View	S10B80.BANINST1	Use (select)
SOVPERS	SQL View	S10B80.BANINST1	Use (select)
SOVPERS_OJ	SQL View	S10B80.BANINST1	Use (select)
SPVCURR	SQL View	S10B80.BANINST1	Use (select)
SPVPERS	SQL View	S10B80.BANINST1	Use (select)
SPVTER1	SQL View	S10B80.BANINST1	Use (select)
SPVYEA1	SQL View	S10B80.BANINST1	Use (select)
SRVLIF1	SQL View	S10B80.BANINST1	Use (select)
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
TOVAPC1	SQL View	S10B80.BANINST1	Use (select)
TOVAPP1	SQL View	S10B80.BANINST1	Use (select)
TOVDEP1	SQL View	S10B80.BANINST1	Use (select)
TOVINS2	SQL View	S10B80.BANINST1	Use (select)
F_BENEFICIARY_INFO	SQL Function	S10B80.BANINST1	Rely On
F_BENEFICIARY_INFO	SQL Function	S10B80.BANINST1	Use (select)
F_GET_ETCT_CODE	SQL Function	S10B80.BANINST1	Rely On
F_SPOUSE_INFO	SQL Function	S10B80.BANINST1	Use (select)
BIO_REC	Oracle Package Type	S10B80.BANINST1.GB_BIO	Rely On
BIO_REC	Oracle Package Type	S10B80.BANINST1.GB_BIO_G	Rely On
FULL_NAME_TYPE	Oracle Package Type	S10B80.BANINST1.SPKLIBS	Rely On
NET_USER	Oracle Package Type	S10B80.BANINST1.IMF_SERVICE	Rely On
PERSON_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSPKCOM	Rely On
PERS_TYPE	Oracle Package Type	S10B80.BANINST1.BWPKEPLK	Rely On
SHORT_BIO_REC	Oracle Package Type	S10B80.BANINST1.SRKPREL	Rely On
T_STUDTLTYPE	Oracle Package Type	S10B80.BANINST1.BWCKGSTU	Rely On
CHECKSTUDECEASEDC	Oracle Package Cursor	S10B80.BANINST1.BWLKOIDS	Use (select)
C_GETSTUDTLC	Oracle Package Cursor	S10B80.BANINST1.BWCKGSTU	Use (select)
SPBPERSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKLIBS	Use (select)Rely On
PIDM	Oracle Package Variable	S10B80.BANINST1.SRKPREL	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKSRCH	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWAKSRCH	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKCPRF	Rely On
SPOUSE_SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWDKLIBS	Rely On
CONFID_INDC	Oracle Package Cursor	S10B80.BANINST1.BWCKLIBS	Use (select)
EMPL_C	Oracle Package Cursor	S10B80.BANINST1.PP_W2_2006	Use (select)
EMPL_C	Oracle Package Cursor	S10B80.BANINST1.PP_W2_2007	Use (select)
GETBIRTHDATEC	Oracle Package Cursor	S10B80.BANINST1.BWPKEBST	Use (select)
LATEST_SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
PERSON_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
SEARCHVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKADVS	Use (select)
SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWAKSRCH	Use (select)
SPBPERSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKSRCH	Use (select)Rely On
SPBPERSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
SPBPERSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWGKOMAR	Use (select)
SPBPERSVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKCPRF	Use (select)Rely On
SPBPERS_C	Oracle Package Cursor	S10B80.BANINST1.BWCKOTRN	Use (select)
SPLITINDIVIDC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
SPLITINSTC	Oracle Package Cursor	S10B80.BANINST1.BWAKCPMT	Use (select)
SPOUSEVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWAKPLDG	Use (select)
P_CREATE_PERSON	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_GETSPBPERS	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Rely On
P_GETSPBPERS	Oracle Package Procedure	S10B80.BANINST1.ROKWEXT	Use (select)
P_GETSPBPERS	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Rely On
P_GETSPBPERS	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_OPEN_SPBPERS_CV	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Rely On
P_PRIMARY_MATCH_SSN	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Rely On
P_PRIMARY_MATCH_SSN	Oracle Package Procedure	S10B80.BANINST1.GOKCMPK	Use (select)
UT_PB_W2_FEDERALDELETEAPI	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_FEDERAL	Use (select)
CUR_PREFIX	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_PREF_NAME	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
CUR_SUFFIX	Oracle Package Variable	S10B80.BANINST1.BWPKEDIR	Rely On
GV_BIRTH_DATE	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_PREFIX	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
GV_SSN	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_SUFFIX	Oracle Package Variable	S10B80.BANINST1.GP_UDC_USER_PROVISIONING	Rely On
SPBPERS_REC	Oracle Package Variable	S10B80.BANINST1.BWPKDBCV	Rely On
F_BIO_DECEASED	Oracle Package Function	S10B80.BANINST1.SOKMAUD	Rely On
F_BIO_DECEASED	Oracle Package Function	S10B80.BANINST1.SOKMAUD	Use (select)Rely On
F_BUILD_SPBPERS_REC	Oracle Package Function	S10B80.BANINST1.GB_BIO	Rely On
F_BUILD_SPBPERS_REC	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Rely On
F_DIPLOMA_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Rely On
F_GET_GENDER	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_GET_ID	Oracle Package Function	S10B80.BANINST1.BWPKEPCR	Use (select)
F_GET_ORDERSTR	Oracle Package Function	S10B80.BANINST1.BWPKEPLK	Rely On
F_IDEN_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Rely On
F_IDEN_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Use (select)
F_LEGAL_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Rely On
F_MATCH_SPBPERS	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
F_SUFFIX	Oracle Package Function	S10B80.BANINST1.BWSKGRAD	Rely On
F_SUFFIX	Oracle Package Function	S10B80.BANINST1.BWSKGRAD	Use (select)
FULL_NAME_C	Oracle Package Cursor	S10B80.BANINST1.SPKLIBS	Use (select)
GETPERSDOBC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
GETPERSSSNC	Oracle Package Cursor	S10B80.BANINST1.BWRKLHST	Use (select)
SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
SPBPERSC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
SPBPERS_C	Oracle Package Cursor	S10B80.BANINST1.TTKSELS	Rely On
SPBPERS_C	Oracle Package Cursor	S10B80.BANINST1.TTKSELS	Use (select)Rely On
SPBPERS_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SPKSELS	Rely On
SPBPERS_ROW_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SPKSELS	Use (select)Rely On
P_ACKNOWLEDGEMENT_PAGE	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Rely On
P_ACKNOWLEDGEMENT_PAGE	Oracle Package Procedure	S10B80.BANINST1.BWGKCCRD	Use (select)Rely On
P_ACREC_ACAWARD_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_ACADAWARD_EXP	Use (select)
P_APTADDR_IN_USE	Oracle Package Procedure	S10B80.BANINST1.AOKHHLD	Use (select)
P_BUILDPATRECR	Oracle Package Procedure	S10B80.BANINST1.PAKRECR	Use (select)
P_BUILDPETDEGR	Oracle Package Procedure	S10B80.BANINST1.PEKDEGR	Use (select)
P_BUILDPETWEMP	Oracle Package Procedure	S10B80.BANINST1.PEKWEMP	Use (select)
P_CHECK_COMBINATIONS	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_CONFIDSTUDINFO	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Rely On
P_CONFIDSTUDINFO	Oracle Package Procedure	S10B80.BANINST1.BWCKLIBS	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Rely On
P_CREATE_MATERIALS	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_CREATE_W2	Oracle Package Procedure	S10B80.BANINST1.PP_W2	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SPBPERS	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Rely On
P_DISPPERSEARCHRESULTS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_DISP_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_DISP_DIPLOMA_NAME	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_EDIT_EMPLOYEE_ID	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_EMPLOYEE_ID	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EVALUATE_MG_ELIGIBILITY	Oracle Package Procedure	S10B80.BANINST1.AXKEXMG	Use (select)
P_FACVERIFYID	Oracle Package Procedure	S10B80.BANINST1.BWLKFTRN	Use (select)
P_GETPERSON	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_GET_CITIZEN_CODE	Oracle Package Procedure	S10B80.BANINST1.POKWLIB	Rely On
P_GET_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.TTKSELS	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SPBPERS	Use (Insert)Rely On
P_INSERT_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORCONT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_LOAD_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SAKL020	Rely On
P_LOAD_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SAKL020	Use (select)
P_LOAD_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.APKLDRD	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Use (select)
P_MAJOR2INTEREST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_OPEN_STUDENT_LIST_C	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Rely On
P_PERSON_ELEMENT	Oracle Package Procedure	S10B80.BANINST1.SB_PESCXML_PERSON_EXP	Use (select)
P_PRINTPERSEARCHROW	Oracle Package Procedure	S10B80.BANINST1.BWPKEPLK	Rely On
P_PRINT_PREV_NXT_LINKS	Oracle Package Procedure	S10B80.BANINST1.BWPKEPLK	Rely On
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROC_DIPLOMA_ADDR	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_PROC_DIPLOMA_NAME	Oracle Package Procedure	S10B80.BANINST1.BWSKGRAD	Rely On
P_QUICK_ADMIT	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_RULES	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G_RULES	Rely On
P_SEARCHPERSON	Oracle Package Procedure	S10B80.BANINST1.BWPKEPAF	Rely On
P_SPBPERS_AIR	Oracle Package Procedure	S10B80.BANINST1.EOKRFSY	Rely On
P_SPBPERS_AUR	Oracle Package Procedure	S10B80.BANINST1.EOKRFSY	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SPBPERS	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_BIO_G_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.PB_W2_FEDERAL_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.PB_W2_FEDERAL_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMMATE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_ROOMPREFERENCE_RULES	Use (select)Rely On
P_VALIDATE_STUDENT_ID	Oracle Package Procedure	S10B80.BANINST1.SPKFUNC	Rely On
P_VALIDATE_SUPERVISOR_PIDM	Oracle Package Procedure	S10B80.BANINST1.NBKJOBS	Rely On
P_VALIDATE_SUPERVISOR_PIDM	Oracle Package Procedure	S10B80.BANINST1.NBKJOBS	Use (select)Rely On
P_VIEWTRANSCRIPT	Oracle Package Procedure	S10B80.BANINST1.BWCKOTRN	Rely On
P_VR_MENU_OPTION	Oracle Package Procedure	S10B80.BANINST1.VRGKOCTL	Rely On
P_VR_VALIDATE_ID	Oracle Package Procedure	S10B80.BANINST1.VRSKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_LOCAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_STATE	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_FEDERAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_PERSON_IDENTITY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_CODED_INFO	Use (select)
UT_TEARDOWN	Oracle Package Procedure	S10B80.BANINST1.UT_GB_SECTION	Use (delete)
F_BUILD_FULL_NAME	Oracle Package Function	S10B80.BANINST1.GOKPAPI	Rely On
F_CALC_FULL_NAME	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CALC_GENDER	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CALC_NICKNAME	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_CHECKDEADIND	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_CHECK_BLDG	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_CHECK_CITZ	Oracle Package Function	S10B80.BANINST1.GOKVISA	Use (select)
F_CHECK_ROOM	Oracle Package Function	S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES	Rely On
F_CITZ_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Rely On
F_CONFIDSTUDINFO_L	Oracle Package Function	S10B80.BANINST1.BWCKLIBS	Rely On
F_CVT_GET_CURR_SPS	Oracle Package Function	S10B80.BANINST1.AOKLIBS	Use (select)
F_DECEASEDPERSCHECK	Oracle Package Function	S10B80.BANINST1.BWCKREGS	Use (select)
F_DISP_SEARCH_LINK	Oracle Package Function	S10B80.BANINST1.BWPKEPLK	Rely On
F_EMPLOYEE_DECEASED	Oracle Package Function	S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT	Rely On
F_EMPLOYEE_DECEASED	Oracle Package Function	S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT	Use (select)
F_EMPLOYEE_DECEASED	Oracle Package Function	S10B80.BANINST1.PX_MASS_ROE	Rely On
F_EMPLOYEE_DECEASED	Oracle Package Function	S10B80.BANINST1.PX_MASS_ROE	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BIO	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BIO	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Use (select)
F_GET_BIRTHDATE	Oracle Package Function	S10B80.BANINST1.BWPKEPLK	Rely On
F_GET_BIRTHDATE	Oracle Package Function	S10B80.BANINST1.BWPKEPLK	Use (select)
F_GET_BIRTH_DATE	Oracle Package Function	S10B80.BANINST1.SPKSELS	Rely On
F_GET_INPUTCOUNT	Oracle Package Function	S10B80.BANINST1.BWPKEPLK	Rely On
F_GET_PERSON_BY_ID	Oracle Package Function	S10B80.BANINST1.GB_PERSON	Use (select)
F_GET_SPBPERS_REC	Oracle Package Function	S10B80.BANINST1.SPKSELS	Rely On
F_HOUSEHOLD_COUNT	Oracle Package Function	S10B80.BANINST1.AOKHHLD	Use (select)
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Rely On
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Use (select)
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_IDNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Use (select)
F_IDNAME_SEARCH_MOD	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_IDNAME_SEARCH_NEW	Oracle Package Function	S10B80.BANINST1.TEST_LVH	Rely On
F_MINIMAL_BIO_INFO_EXISTS	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BIO	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BIO	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_BIO	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BIO	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BIO	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BIO	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BIO	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.GB_BIO_G	Use (select)
F_RACE_ETHN_EXISTS	Oracle Package Function	S10B80.BANINST1.NOKEPCR	Rely On
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_SIN_EXISTS	Oracle Package Function	S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT	Rely On
F_SIN_EXISTS	Oracle Package Function	S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT	Use (select)
F_SSNNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Rely On
F_SSNNAME_SEARCH	Oracle Package Function	S10B80.BANINST1.GB_IDENTIFICATION	Use (select)
F_STUDENT_ID_TYPE	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Use (select)
F_TRANSCRIPT_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Rely On
F_TRANSCRIPT_NAME	Oracle Package Function	S10B80.BANINST1.SHKTRAN	Use (select)
SPBPERS	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_SPBPERS	SQL Index	S10B80.SATURN	Rely On
SPBPERS_SSN_INDEX	SQL Index	S10B80.SATURN	Rely On
APRACYR	SQL Table	S10B80.ALUMNI	Join
APRCHIS	SQL Table	S10B80.ALUMNI	Join
APRDHIS	SQL Table	S10B80.ALUMNI	Join
GOBSEVS	SQL Table	S10B80.GENERAL	Join
GOREMAL	SQL Table	S10B80.GENERAL	Join
GORSEVD	SQL Table	S10B80.GENERAL	Join
GTVUOMS	SQL Table	S10B80.GENERAL	Refer (no action)
NBRBJOB	SQL Table	S10B80.POSNCTL	Join
PEBEMPL	SQL Table	S10B80.PAYROLL	Join
RORSTAT	SQL Table	S10B80.FAISMGR	Join
RPRATRM	SQL Table	S10B80.FAISMGR	Join
SARADAP	SQL Table	S10B80.SATURN	Join
SARDCSN	SQL Table	S10B80.SATURN	Join
SFBETRM	SQL Table	S10B80.SATURN	Join
SGBSTDN	SQL Table	S10B80.SATURN	Join
SHRTTRM	SQL Table	S10B80.SATURN	Join
SLRRMAT	SQL Table	S10B80.SATURN	Join
SPRMEDI	SQL Table	S10B80.SATURN	Join
SRBRECR	SQL Table	S10B80.SATURN	Join
STVCITZ	SQL Table	S10B80.SATURN	Refer (no action)
STVETHN	SQL Table	S10B80.SATURN	Refer (no action)
STVLGCY	SQL Table	S10B80.SATURN	Refer (no action)
STVMRTL	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVRELG	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)
ET_SPBPERS_AIR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (Insert,after,each row)
ET_SPBPERS_AUR_EXTSOL	SQL Trigger	S10B80.BANIMGR	Fire (update,after,each row)
ST_SPBPERS_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SPBPERS_AS_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SPBPERS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:40:04:000	04/02/2008 21:18:03:000

Source Code Comments

Basic Person Base Table

Lock

Permanently locked by DAM

Columns Comments for SPBPERS_PIDM (# 1)

Source Code Comments

Internal Identification Number of Person.

Columns Comments for SPBPERS_SSN (# 2)

Source Code Comments

This field maintains person social security number.

Columns Comments for SPBPERS_BIRTH_DATE (# 3)

Source Code Comments

This field maintains person birth date.

Columns Comments for SPBPERS_LGCY_CODE (# 4)

Source Code Comments

This field maintains legacy code associated with person.

Columns Comments for SPBPERS_ETHN_CODE (# 5)

Source Code Comments

ETHNIC CODE: This field identifies the ethnic code referenced on the General Person Form (SPAPERS) and by the Source/Base Institution Year Form (SOABGIY). The code is mapped to other codes which are required for government reporting.

Columns Comments for SPBPERS_MRTL_CODE (# 6)

Source Code Comments

This field maintains martial status associated with person.

Columns Comments for SPBPERS_RELG_CODE (# 7)

Source Code Comments

This field maintains religious affiliation associated with person.

Columns Comments for SPBPERS_SEX (# 8)

Source Code Comments

This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.

Columns Comments for SPBPERS_CONFID_IND (# 9)

Source Code Comments

This field identifies if a person record is confidential Valid value is: Y - confidential.

Columns Comments for SPBPERS_DEAD_IND (# 10)

Source Code Comments

This field indicates if a person is deceased. Valid value is: Y - deceased.

Columns Comments for SPBPERS_VETC_FILE_NUMBER (# 11)

Source Code Comments

This field maintains veteran identification number associated with person.

Columns Comments for SPBPERS_LEGAL_NAME (# 12)

Source Code Comments

This field maintains legal name associated with person.

Columns Comments for SPBPERS_PREF_FIRST_NAME (# 13)

Source Code Comments

This field maintains the preferred first name associated with person.

Columns Comments for SPBPERS_NAME_PREFIX (# 14)

Source Code Comments

This field maintains the prefix (Mr, Mrs, etc) used before person name.

Columns Comments for SPBPERS_NAME_SUFFIX (# 15)

Source Code Comments

This field maintains the suffix (Jr, Sr, etc) used after person name.

Columns Comments for SPBPERS_ACTIVITY_DATE (# 16)

Source Code Comments

This field defines the most current date a record is added or changed.

Columns Comments for SPBPERS_VERA_IND (# 17)

Source Code Comments

Veteran Category. None, (O)ther Protected Veteran Only, (V)ietnam Veteran only, (B)oth Vietnam and Other Eligible Veteran.

Columns Comments for SPBPERS_CITZ_IND (# 18)

Source Code Comments

Citizen Indicator.

Columns Comments for SPBPERS_DEAD_DATE (# 19)

Source Code Comments

Person Deceased Date.

Columns Comments for SPBPERS_PIN (# 20)

Source Code Comments

Person Identification Number. This column is obsolete, now gobtpac_pin

Columns Comments for SPBPERS_CITZ_CODE (# 21)

Source Code Comments

Person Citizen Type

Columns Comments for SPBPERS_HAIR_CODE (# 22)

Source Code Comments

The hair color of the person being defined.

Columns Comments for SPBPERS_EYES_CODE (# 23)

Source Code Comments

The eye color of the person being defined.

Columns Comments for SPBPERS_CITY_BIRTH (# 24)

Source Code Comments

The city where the person was born.

Columns Comments for SPBPERS_STAT_CODE_BIRTH (# 25)

Source Code Comments

The state in which the person was born.

Columns Comments for SPBPERS_DRIVER_LICENSE (# 26)

Source Code Comments

The Driver License Number as it appears on the actual license.

Columns Comments for SPBPERS_STAT_CODE_DRIVER (# 27)

Source Code Comments

The State code describing the state the driver license was issued.

Columns Comments for SPBPERS_NATN_CODE_DRIVER (# 28)

Source Code Comments

The Nation code associated with the Nation the Driver license was issued.

Columns Comments for SPBPERS_UOMS_CODE_HEIGHT (# 29)

Source Code Comments

The Unit of Measure describing the height value.

Columns Comments for SPBPERS_HEIGHT (# 30)

Source Code Comments

The number value describing the height of the person.

Columns Comments for SPBPERS_UOMS_CODE_WEIGHT (# 31)

Source Code Comments

The Unit of Measure describing the weight value.

Columns Comments for SPBPERS_WEIGHT (# 32)

Source Code Comments

The number value describing the weight of the person.

Columns Comments for SPBPERS_SDVET_IND (# 33)

Source Code Comments

Indicator to identify an individual as a special disabled veteran.

Columns Comments for SPBPERS_LICENSE_ISSUED_DATE (# 34)

Source Code Comments

The issue date of the individuals driver license.

Columns Comments for SPBPERS_LICENSE_EXPIRES_DATE (# 35)

Source Code Comments

The expiration date of the individuals driver license.

Columns Comments for SPBPERS_INCAR_IND (# 36)

Source Code Comments

The indication of the individuals incarceration.

Columns Comments for SPBPERS_WEBID (# 37)

Source Code Comments

Web identification session token is now obsolete.

Columns Comments for SPBPERS_WEB_LAST_ACCESS (# 38)

Source Code Comments

Web last access time stamp is now obsolete.

Columns Comments for SPBPERS_PIN_DISABLED_IND (# 39)

Source Code Comments

Indicates whether or not the PIN number is disabled. This column is obsolete, now gobtpac_pin_disabled_ind

Columns Comments for SPBPERS_ITIN (# 40)

Source Code Comments

The international tax id number.

Columns Comments for SPBPERS_ACTIVE_DUTY_SEPR_DATE (# 41)

Source Code Comments

Active Duty Separation Date: The Date that the person was separated from active duty.

Columns Comments for SPBPERS_DATA_ORIGIN (# 42)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for SPBPERS_USER_ID (# 43)

Source Code Comments

USER ID: User who inserted or last update the data

Columns Comments for SPBPERS_ETHN_CDE (# 44)

Source Code Comments

ETHNIC CODE: This field identifies the ethnic code defined by the U.S. government. The valid values are 1 - Not Hispanic or Latino, 2 - Hispanic or Latino, or null.

Columns Comments for SPBPERS_CONFIRMED_RE_CDE (# 45)

Source Code Comments

RACE AND ETHNICITY CONFIRMED: This field identifies the race and ethnicity has been confirmed. Valid values are (Y)es, (N)o and Null.

Columns Comments for SPBPERS_CONFIRMED_RE_DATE (# 46)

Source Code Comments

RACE AND ETHNICITY CONFIRMED DATE: This field identifies when the race and ethnicity has been confirmed.

Table SRBWPRO

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRBWPRO_PREL_CODE	VARCHAR2(10)	No	*	*
SRBWPRO_WPIC_CODE	VARCHAR2(10)	No	*
SRBWPRO_DISPLAY_ORDER	NUMBER(3,0)	No
SRBWPRO_ACTIVITY_DATE	DATE	No
SRBWPRO_ATYP_CODE	VARCHAR2(2)	Yes		*
SRBWPRO_EMAL_CODE	VARCHAR2(4)	Yes		*
SRBWPRO_RESPONSE_REQ_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRBWPRO_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
SRBWPRO_ATYP_CODE	STVATYP_CODE	STVATYP
SRBWPRO_PREL_CODE	STVPREL_CODE	STVPREL

Index

Index Name	Index Type	Column Name
PK_SRBWPRO	Unique	SRBWPRO_PREL_CODE
PK_SRBWPRO	Unique	SRBWPRO_WPIC_CODE
SRBWPRO_KEY_INDEX		SRBWPRO_PREL_CODE
SRBWPRO_KEY_INDEX		SRBWPRO_DISPLAY_ORDER

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_GENERATEFORM	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
P_CHOOSEPROSPECTTYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
SRBWPRO	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_SRBWPRO	SQL Index	S10B80.SATURN	Rely On
SRBWPRO_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVPREL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRBWPRO

Object Dates

Creation Date	Analysis Date
04/02/2008 20:35:50:000	04/02/2008 21:17:59:000

Source Code Comments

Web Prospect Section Rules Form, SRAWPRO that will be used by an institution to designate what pieces of data will be displayed on each different type of Prospect Code defined on STVWPRO.

Columns Comments for SRBWPRO_PREL_CODE (# 1)

Source Code Comments

Electronic Prospect Code for display selection.

Columns Comments for SRBWPRO_WPIC_CODE (# 2)

Source Code Comments

WEB Prospect Selection Code.

Columns Comments for SRBWPRO_DISPLAY_ORDER (# 3)

Source Code Comments

The order the Data is displayed on the Web Prospect Page.

Columns Comments for SRBWPRO_ATYP_CODE (# 5)

Source Code Comments

The address type for the Web Prospect page.

Columns Comments for SRBWPRO_RESPONSE_REQ_IND (# 7)

Source Code Comments

Indicator that the data must be filled in on the Prospect Web page before being saved in the database.

Table SRTEMAL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTEMAL_RIDM	NUMBER(8,0)	No	*	*
SRTEMAL_EMAL_CODE	VARCHAR2(4)	No	*	*
SRTEMAL_EMAIL_ADDRESS	VARCHAR2(128)	No
SRTEMAL_STATUS_IND	VARCHAR2(1)	No
SRTEMAL_ACTIVITY_DATE	DATE	No
SRTEMAL_USER_ID	VARCHAR2(30)	No
SRTEMAL_PREFERRED_IND	VARCHAR2(1)	Yes
SRTEMAL_COMMENT	VARCHAR2(60)	Yes
SRTEMAL_DISP_WEB_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTEMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
SRTEMAL_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTEMAL	Unique	SRTEMAL_RIDM
PK_SRTEMAL	Unique	SRTEMAL_EMAL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPERS	SQL Table	S10B80.SATURN	Join
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_EMAIL_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
EMAIL_ADDRESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
EMAL_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
VERIFY_EMAIL_ADDRESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LATEST_SRTPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
SRTEMALC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_BUILD_SRTEMAL_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL_RULES	Rely On
F_EQUAL_E_ADDRESS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
SRTEMAL	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_SRTEMAL	SQL Index	S10B80.SATURN	Rely On
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
SRTPREL	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTEMAL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:57:21:000	04/02/2008 21:18:18:000

Source Code Comments

Table used to store email of Electronic Prospect before moving to Banner Production Table GUREMAL.

Columns Comments for SRTEMAL_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTEMAL_EMAL_CODE (# 2)

Source Code Comments

Code to identify the type of email address.

Columns Comments for SRTEMAL_EMAIL_ADDRESS (# 3)

Source Code Comments

The email address of the Prospect.

Columns Comments for SRTEMAL_STATUS_IND (# 4)

Source Code Comments

Status indicator for active, inactive of the email address.

Columns Comments for SRTEMAL_ACTIVITY_DATE (# 5)

Source Code Comments

Date of most recent update or of creation.

Columns Comments for SRTEMAL_USER_ID (# 6)

Source Code Comments

User ID of person who entered the email address.

Columns Comments for SRTEMAL_PREFERRED_IND (# 7)

Source Code Comments

Indicator if the email address is the persons preferred address.

Columns Comments for SRTEMAL_COMMENT (# 8)

Source Code Comments

General comment text area about the email address.

Columns Comments for SRTEMAL_DISP_WEB_IND (# 9)

Source Code Comments

Indicator that the email should be displayed on the web.

Link between SPBPERS and SARADAP

Join Information

Objects list
schema-view : S10B80.BANINST1.SAVLIF1 schema-view : S10B80.BANINST1.SAVADMT schema-view : S10B80.BANINST1.SAVDCSN schema-view : S10B80.BANINST1.SAVAMC2 schema-view : S10B80.BANINST1.SAVAMCD schema-view : S10B80.BANINST1.SAVADM2_N

Link List

Link Type	Link	Project
Join	Link Between SPBPERS and SARADAP	SATURN

List of Real links

Link type	Between	And
Join	SPBPERS	SARADAP

Link between GOREMAL and SARADAP

Join Information

Objects list
schema-view : S10B80.BANINST1.SAVAMCD

Link List

Link Type	Link	Project
Join	Link Between GOREMAL and SARADAP	GENERAL

List of Real links

Link type	Between	And
Join	GOREMAL	SARADAP

Link between SPBPERS and GOREMAL

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWSKALOG.LATEST_SPBPERSC

Link List

Link Type	Link	Project
Join	Link Between SPBPERS and GOREMAL	SATURN

List of Real links

Link type	Between	And
Join	SPBPERS	GOREMAL

Link between APBWIDN and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between APBWIDN and GTVEMAL (FK1_APBWIDN_INV_GTVEMAL_KEY)	ALUMNI

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
APBWIDN	APBWIDN_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(0,1)-(0,n)

Link between ROTEMAL and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between ROTEMAL and GTVEMAL (FK1_ROTEMAL_INV_GTVEMAL_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
ROTEMAL	ROTEMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(1,1)-(0,n)

Link between GOREMAL and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GOREMAL and GTVEMAL (FK1_GOREMAL_INV_GTVEMAL_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GOREMAL	GOREMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(1,1)-(0,n)

Link between SRBWPRO and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SRBWPRO and GTVEMAL (FK2_SRBWPRO_INV_GTVEMAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SRBWPRO	SRBWPRO_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(0,1)-(0,n)

Link between SRTEMAL and GTVEMAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SRTEMAL and GTVEMAL (FK1_SRTEMAL_INV_STVEMAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SRTEMAL	SRTEMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL	(1,1)-(0,n)