AABDINS AABMINT AABMSHP AARCMEM AARINCM AARMBCM AARMBIN AARMCMT AARMEMB AARMINT AARMPRE ATVAMCT ATVAMGP ATVAMIN ATVAMST ATVAMTP ATVDCAM GTVLETR STVATYP STVCOLL

Model Membership*


Model Label :

List of Objects

Object Name Object Type Layer Name
AABDINS SQL Table Default
AABMINT SQL Table Default
AABMSHP SQL Table Default
AARCMEM SQL Table Default
AARINCM SQL Table Default
AARMBCM SQL Table Default
AARMBIN SQL Table Default
AARMCMT SQL Table Default
AARMEMB SQL Table Default
AARMINT SQL Table Default
AARMPRE SQL Table Default
ATVAMCT SQL Table Default
ATVAMGP SQL Table Default
ATVAMIN SQL Table Default
ATVAMST SQL Table Default
ATVAMTP SQL Table Default
ATVDCAM SQL Table Default
GTVLETR SQL Table Default
STVATYP SQL Table Default
STVCOLL SQL Table Default

Model View

Table AABDINS

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AABDINS_PIDM   NUMBER(8,0) No * *
AABDINS_MEMBERSHIP   VARCHAR2(5) No * *
AABDINS_MEMB_NO   VARCHAR2(7) No * *
AABDINS_FREQ_CODE   VARCHAR2(2) No   *
AABDINS_BILL_DATE   DATE No    
AABDINS_ACTIVITY_DATE   DATE No    
AABDINS_PDUR_CODE   VARCHAR2(1) Yes   *
AABDINS_LETR_CODE   VARCHAR2(15) Yes   *
AABDINS_RENEWAL_PIDM   NUMBER(8,0) Yes    
AABDINS_ATYP_CODE   VARCHAR2(2) Yes   *
AABDINS_LAST_BILL_DATE   DATE Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
AABDINS_PIDM AARMEMB_PIDM AARMEMB
AABDINS_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB
AABDINS_MEMB_NO AARMEMB_MEMB_NO AARMEMB
AABDINS_FREQ_CODE ATVFREQ_CODE ATVFREQ
AABDINS_PDUR_CODE ATVPDUR_CODE ATVPDUR
AABDINS_LETR_CODE GTVLETR_CODE GTVLETR
AABDINS_ATYP_CODE STVATYP_CODE STVATYP

Index

Index Name Index Type Column Name
PK_AABDINS Unique AABDINS_PIDM
PK_AABDINS Unique AABDINS_MEMBERSHIP
PK_AABDINS Unique AABDINS_MEMB_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AABDINS SQL Index S10B80.ALUMNI Rely On
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
ATVFREQ SQL Table S10B80.ALUMNI Refer (no action)
ATVPDUR SQL Table S10B80.ALUMNI Refer (no action)
GTVLETR SQL Table S10B80.GENERAL Refer (no action)
STVATYP SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AABDINS

Object Dates

Creation Date Analysis Date
04/02/2008 13:46:37:000 04/02/2008 13:49:22:000

Source Code Comments

Membership Dues Installment Base Table

Columns Comments for AABDINS_PIDM (# 1)

Source Code Comments

Internal system generated identification number of the constituent.

Columns Comments for AABDINS_MEMBERSHIP (# 2)

Source Code Comments

Membership code for the association.

Columns Comments for AABDINS_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AABDINS_FREQ_CODE (# 4)

Source Code Comments

Frequency for installmemt reminders for the dues payments.

Columns Comments for AABDINS_BILL_DATE (# 5)

Source Code Comments

First billing date for the dues.

Columns Comments for AABDINS_ACTIVITY_DATE (# 6)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABDINS_PDUR_CODE (# 7)

Source Code Comments

Specifies the duration of the dues.

Columns Comments for AABDINS_LETR_CODE (# 8)

Source Code Comments

Specifies the letter to be generated for the renewal.

Columns Comments for AABDINS_RENEWAL_PIDM (# 9)

Source Code Comments

Internal system identification number of the renewal party.

Columns Comments for AABDINS_ATYP_CODE (# 10)

Source Code Comments

Address type code for the renewal party.

Columns Comments for AABDINS_LAST_BILL_DATE (# 11)

Source Code Comments

The last billing date for the dues installment.

Table AABMINT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AABMINT_INTEREST   VARCHAR2(5) No * *
AABMINT_NAME   VARCHAR2(60) No    
AABMINT_AMIN_CODE   VARCHAR2(2) No   *
AABMINT_RESTR_IND   VARCHAR2(1) No    
AABMINT_ACTIVITY_DATE   DATE No    
AABMINT_DUES_SUB_IND   VARCHAR2(1) Yes    
AABMINT_GL_NO_CREDIT   VARCHAR2(60) Yes    
AABMINT_AMGP_CODE   VARCHAR2(5) Yes   *
AABMINT_COLL_CODE   VARCHAR2(2) Yes   *
AABMINT_COAS_CODE   VARCHAR2(1) Yes    
AABMINT_ACCI_CODE   VARCHAR2(6) Yes    
AABMINT_FUND_CODE   VARCHAR2(6) Yes    
AABMINT_ORGN_CODE   VARCHAR2(6) Yes    
AABMINT_ACCT_CODE   VARCHAR2(6) Yes    
AABMINT_PROG_CODE   VARCHAR2(6) Yes    
AABMINT_ACTV_CODE   VARCHAR2(6) Yes    
AABMINT_LOCN_CODE   VARCHAR2(6) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
AABMINT_AMGP_CODE ATVAMGP_CODE ATVAMGP
AABMINT_AMIN_CODE ATVAMIN_CODE ATVAMIN
AABMINT_COLL_CODE STVCOLL_CODE STVCOLL
AABMINT_INTEREST AARMBIN_INTEREST AARMBIN

Index

Index Name Index Type Column Name
PK_AABMINT Unique AABMINT_INTEREST

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AARINCM SQL Table S10B80.ALUMNI Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AABMINT SQL Index S10B80.ALUMNI Rely On
AARMBIN SQL Table S10B80.ALUMNI Join
ATVAMGP SQL Table S10B80.ALUMNI Refer (no action)
ATVAMIN SQL Table S10B80.ALUMNI Refer (no action)
STVCOLL SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AABMINT

Object Dates

Creation Date Analysis Date
04/02/2008 13:43:08:000 04/02/2008 13:49:18:000

Source Code Comments

Membership Interest Header Table

Columns Comments for AABMINT_INTEREST (# 1)

Source Code Comments

Membership interest code.

Columns Comments for AABMINT_NAME (# 2)

Source Code Comments

Interest description of the name for the interest.

Columns Comments for AABMINT_AMIN_CODE (# 3)

Source Code Comments

Interest type code associated with the interest.

Columns Comments for AABMINT_RESTR_IND (# 4)

Source Code Comments

Indicates whether the interest is restricted to transfer of memberships over fiscal years.

Columns Comments for AABMINT_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABMINT_DUES_SUB_IND (# 6)

Source Code Comments

Dues or subscription indicator for interest code.

Columns Comments for AABMINT_GL_NO_CREDIT (# 7)

Source Code Comments

General ledger account number associated with interest.

Columns Comments for AABMINT_AMGP_CODE (# 8)

Source Code Comments

Group code associated with the interest.

Columns Comments for AABMINT_COLL_CODE (# 9)

Source Code Comments

College code associated with the interest.

Columns Comments for AABMINT_COAS_CODE (# 10)

Source Code Comments

Banner Finance Chart of Accounts.

Columns Comments for AABMINT_ACCI_CODE (# 11)

Source Code Comments

Banner Finance Account Index Code.

Columns Comments for AABMINT_FUND_CODE (# 12)

Source Code Comments

Banner Finance Fund Code.

Columns Comments for AABMINT_ORGN_CODE (# 13)

Source Code Comments

Banner Finance Organization Code.

Columns Comments for AABMINT_ACCT_CODE (# 14)

Source Code Comments

Banner Finance Account Code.

Columns Comments for AABMINT_PROG_CODE (# 15)

Source Code Comments

Banner Finance Program Code.

Columns Comments for AABMINT_ACTV_CODE (# 16)

Source Code Comments

Banner Finance Activity Code.

Columns Comments for AABMINT_LOCN_CODE (# 17)

Source Code Comments

Banner Finance Location Code.

Table AABMSHP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AABMSHP_MEMBERSHIP   VARCHAR2(5) No *  
AABMSHP_LETR_CODE_CARD   VARCHAR2(15) Yes   *
AABMSHP_ACTIVITY_DATE   DATE No    
AABMSHP_DEFAULT_INTEREST   VARCHAR2(5) Yes    
AABMSHP_AMTP_CODE_DFLT   VARCHAR2(3) Yes   *
AABMSHP_NAME   VARCHAR2(60) Yes    
AABMSHP_AMST_CODE   VARCHAR2(1) Yes   *
AABMSHP_AMST_DATE   DATE Yes    
AABMSHP_GRACE_PERIOD   NUMBER(2,0) Yes    
AABMSHP_DURATION   NUMBER(3,0) Yes    
AABMSHP_ENDING_DATE_MO   VARCHAR2(2) Yes    
AABMSHP_ENDING_DATE_DAY   VARCHAR2(2) Yes    
AABMSHP_LETR_CODE_RENEW   VARCHAR2(15) Yes   *

Foreign Key information

Column name is Foreign Key For Column on Table
AABMSHP_AMST_CODE ATVAMST_CODE ATVAMST
AABMSHP_AMTP_CODE_DFLT ATVAMTP_CODE ATVAMTP
AABMSHP_LETR_CODE_CARD GTVLETR_CODE GTVLETR
AABMSHP_LETR_CODE_RENEW GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_AABMSHP Unique AABMSHP_MEMBERSHIP

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AARMBCM SQL Table S10B80.ALUMNI Refer (no action)
AARMBIN SQL Table S10B80.ALUMNI Refer (no action)
AABMSHP_REC Oracle Package Variable S10B80.BANINST1.BWDKSRCH Rely On
AABMSHP_REC Oracle Package Variable S10B80.BANINST1.BWDKCPRF Rely On
AABMSHPVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKSRCH Use (select)Rely On
AABMSHPVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKCPRF Use (select)Rely On
F_AABMSHP_EQUAL Oracle Package Function S10B80.BANINST1.AOKPVAL Use (select)
AABMSHP 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_AABMSHP SQL Index S10B80.ALUMNI Rely On
ATVAMST SQL Table S10B80.ALUMNI Refer (no action)
ATVAMTP SQL Table S10B80.ALUMNI Refer (no action)
GTVLETR SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AABMSHP

Object Dates

Creation Date Analysis Date
04/02/2008 13:45:28:000 04/02/2008 13:49:21:000

Source Code Comments

Membership Header Table

Columns Comments for AABMSHP_MEMBERSHIP (# 1)

Source Code Comments

Membership code for association.

Columns Comments for AABMSHP_LETR_CODE_CARD (# 2)

Source Code Comments

Default letter code for membership card when membership is created.

Columns Comments for AABMSHP_ACTIVITY_DATE (# 3)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AABMSHP_DEFAULT_INTEREST (# 4)

Source Code Comments

Default interest code for membership.

Columns Comments for AABMSHP_AMTP_CODE_DFLT (# 5)

Source Code Comments

Membership type that is the default value for the membership.

Columns Comments for AABMSHP_NAME (# 6)

Source Code Comments

Membership name is the description of the membership code.

Columns Comments for AABMSHP_AMST_CODE (# 7)

Source Code Comments

Status indicator that is for the membership.

Columns Comments for AABMSHP_AMST_DATE (# 8)

Source Code Comments

Status date of the indicator.

Columns Comments for AABMSHP_GRACE_PERIOD (# 9)

Source Code Comments

The number of months a grace period is allowed for the membership.

Columns Comments for AABMSHP_DURATION (# 10)

Source Code Comments

Default duration of membership.

Columns Comments for AABMSHP_ENDING_DATE_MO (# 11)

Source Code Comments

The numeric value of the month that is used instead of duration.

Columns Comments for AABMSHP_ENDING_DATE_DAY (# 12)

Source Code Comments

The numeric value of the day that is used instead of duration.

Columns Comments for AABMSHP_LETR_CODE_RENEW (# 13)

Source Code Comments

Letter code defaulting to membership for renewal letter code.

Table AARCMEM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARCMEM_PIDM   NUMBER(8,0) No   *
AARCMEM_MEMBERSHIP   VARCHAR2(5) No   *
AARCMEM_MEMB_NO   VARCHAR2(7) No   *
AARCMEM_LINK_PIDM   NUMBER(8,0) No    
AARCMEM_LINK_MEMB_NO   VARCHAR2(7) No    
AARCMEM_ACTIVITY_DATE   DATE No    
AARCMEM_LINK_IND   VARCHAR2(1) Yes    
AARCMEM_REN_REM_IND   VARCHAR2(1) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
AARCMEM_PIDM AARMEMB_PIDM AARMEMB
AARCMEM_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB
AARCMEM_MEMB_NO AARMEMB_MEMB_NO AARMEMB

Index

Index Name Index Type Column Name
AARCMEM_KEY_INDEX Unique AARCMEM_PIDM
AARCMEM_KEY_INDEX Unique AARCMEM_MEMBERSHIP
AARCMEM_KEY_INDEX Unique AARCMEM_MEMB_NO
AARCMEM_KEY_INDEX Unique AARCMEM_LINK_PIDM
AARCMEM_KEY_INDEX2 Unique AARCMEM_LINK_PIDM
AARCMEM_KEY_INDEX2 Unique AARCMEM_LINK_MEMB_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
AARCMEM_KEY_INDEX SQL Index S10B80.ALUMNI Rely On
AARCMEM_KEY_INDEX2 SQL Index S10B80.ALUMNI Rely On
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARCMEM

Object Dates

Creation Date Analysis Date
04/02/2008 13:44:10:000 04/02/2008 13:49:19:000

Source Code Comments

Co-Membership Repeating Table

Columns Comments for AARCMEM_PIDM (# 1)

Source Code Comments

Internal system generated identification number for the member.

Columns Comments for AARCMEM_MEMBERSHIP (# 2)

Source Code Comments

Membership code for the member.

Columns Comments for AARCMEM_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARCMEM_LINK_PIDM (# 4)

Source Code Comments

Internal system generated identification number for the co-member.

Columns Comments for AARCMEM_LINK_MEMB_NO (# 5)

Source Code Comments

System generated number that uniquely identifies a co-member membership.

Columns Comments for AARCMEM_ACTIVITY_DATE (# 6)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARCMEM_LINK_IND (# 7)

Source Code Comments

Indicator to link memberships.

Columns Comments for AARCMEM_REN_REM_IND (# 8)

Source Code Comments

Indicator representing which id is used for renewal/reminder.

Table AARINCM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARINCM_INTEREST   VARCHAR2(5) No * *
AARINCM_SEQNO   NUMBER(9,2) No *  
AARINCM_COMMENT   VARCHAR2(60) No    
AARINCM_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
AARINCM_INTEREST AABMINT_INTEREST AABMINT

Index

Index Name Index Type Column Name
PK_AARINCM Unique AARINCM_INTEREST
PK_AARINCM Unique AARINCM_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AARINCM SQL Index S10B80.ALUMNI Rely On
AABMINT SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARINCM

Object Dates

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

Source Code Comments

Membership Header Interests Comments Table

Columns Comments for AARINCM_INTEREST (# 1)

Source Code Comments

Membership Interest codes for association.

Columns Comments for AARINCM_SEQNO (# 2)

Source Code Comments

Comment sequence number.

Columns Comments for AARINCM_COMMENT (# 3)

Source Code Comments

Comment text.

Columns Comments for AARINCM_ACTIVITY_DATE (# 4)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMBCM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMBCM_MEMBERSHIP   VARCHAR2(5) No * *
AARMBCM_SEQNO   NUMBER(9,2) No *  
AARMBCM_COMMENT   VARCHAR2(60) No    
AARMBCM_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMBCM_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP

Index

Index Name Index Type Column Name
PK_AARMBCM Unique AARMBCM_MEMBERSHIP
PK_AARMBCM Unique AARMBCM_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AARMBCM SQL Index S10B80.ALUMNI Rely On
AABMSHP SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMBCM

Object Dates

Creation Date Analysis Date
04/02/2008 13:46:55:000 04/02/2008 13:49:23:000

Source Code Comments

Membership Header Comments Table

Columns Comments for AARMBCM_MEMBERSHIP (# 1)

Source Code Comments

Membership code for association.

Columns Comments for AARMBCM_SEQNO (# 2)

Source Code Comments

Membership comment sequence number system generated.

Columns Comments for AARMBCM_COMMENT (# 3)

Source Code Comments

Membership comment line.

Columns Comments for AARMBCM_ACTIVITY_DATE (# 4)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMBIN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMBIN_MEMBERSHIP   VARCHAR2(5) No * *
AARMBIN_INTEREST   VARCHAR2(5) No *  
AARMBIN_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMBIN_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP

Index

Index Name Index Type Column Name
PK_AARMBIN Unique AARMBIN_MEMBERSHIP
PK_AARMBIN Unique AARMBIN_INTEREST

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMINT SQL Table S10B80.ALUMNI Join

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AARMBIN SQL Index S10B80.ALUMNI Rely On
AABMSHP SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMBIN

Object Dates

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

Source Code Comments

Membership Header Interest Table

Columns Comments for AARMBIN_MEMBERSHIP (# 1)

Source Code Comments

Membership code for association.

Columns Comments for AARMBIN_INTEREST (# 2)

Source Code Comments

Membership interest code.

Columns Comments for AARMBIN_ACTIVITY_DATE (# 3)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMCMT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMCMT_PIDM   NUMBER(8,0) No * *
AARMCMT_MEMBERSHIP   VARCHAR2(5) No * *
AARMCMT_MEMB_NO   VARCHAR2(7) No * *
AARMCMT_SEQNO   NUMBER(9,2) No *  
AARMCMT_COMMENT   VARCHAR2(60) No    
AARMCMT_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMCMT_PIDM AARMEMB_PIDM AARMEMB
AARMCMT_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB
AARMCMT_MEMB_NO AARMEMB_MEMB_NO AARMEMB

Index

Index Name Index Type Column Name
PK_AARMCMT Unique AARMCMT_PIDM
PK_AARMCMT Unique AARMCMT_MEMBERSHIP
PK_AARMCMT Unique AARMCMT_MEMB_NO
PK_AARMCMT Unique AARMCMT_SEQNO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AARMCMT SQL Index S10B80.ALUMNI Rely On
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMCMT

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:20:000 04/02/2008 13:49:16:000

Source Code Comments

Individual Membership Comments Table

Columns Comments for AARMCMT_PIDM (# 1)

Source Code Comments

Internal system generated identification number for the person.

Columns Comments for AARMCMT_MEMBERSHIP (# 2)

Source Code Comments

Membership codes for person.

Columns Comments for AARMCMT_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMCMT_SEQNO (# 4)

Source Code Comments

Comment sequence number.

Columns Comments for AARMCMT_COMMENT (# 5)

Source Code Comments

Comment text.

Columns Comments for AARMCMT_ACTIVITY_DATE (# 6)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMEMB

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMEMB_PIDM   NUMBER(8,0) No *  
AARMEMB_MEMBERSHIP   VARCHAR2(5) No *  
AARMEMB_MEMB_NO   VARCHAR2(7) No *  
AARMEMB_LETR_CODE   VARCHAR2(15) Yes   *
AARMEMB_AMCT_CODE   VARCHAR2(5) No   *
AARMEMB_AMTP_CODE   VARCHAR2(3) No   *
AARMEMB_ENTRY_DATE   DATE No    
AARMEMB_AMST_CODE   VARCHAR2(1) No   *
AARMEMB_AMST_DATE   DATE No    
AARMEMB_ACTIVITY_DATE   DATE No    
AARMEMB_REMINDER_PIDM   NUMBER(8,0) Yes    
AARMEMB_ATYP_CODE_REM   VARCHAR2(2) Yes   *
AARMEMB_RENEWAL_PIDM   NUMBER(8,0) Yes    
AARMEMB_RENEWAL_DATE   DATE Yes    
AARMEMB_ATYP_CODE_REN   VARCHAR2(2) Yes   *
AARMEMB_DCAM_CODE   VARCHAR2(2) Yes   *
AARMEMB_DURATION   NUMBER(3,0) Yes    
AARMEMB_RULE_NO   NUMBER(4,0) Yes    
AARMEMB_CARD_IND   VARCHAR2(1) Yes    
AARMEMB_CARD_DATE   DATE Yes    
AARMEMB_GRACE_PERIOD   NUMBER(2,0) Yes    
AARMEMB_AMT_QUALIFY   NUMBER(11,2) Yes    
AARMEMB_EXP_DATE   DATE Yes    
AARMEMB_MEMB_NAME   VARCHAR2(120) Yes    
AARMEMB_LETR_CODE_RENEW   VARCHAR2(15) Yes   *
AARMEMB_STATUS_OVERRIDE_IND   VARCHAR2(1) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMEMB_AMCT_CODE ATVAMCT_CODE ATVAMCT
AARMEMB_AMST_CODE ATVAMST_CODE ATVAMST
AARMEMB_AMTP_CODE ATVAMTP_CODE ATVAMTP
AARMEMB_LETR_CODE GTVLETR_CODE GTVLETR
AARMEMB_LETR_CODE_RENEW GTVLETR_CODE GTVLETR
AARMEMB_DCAM_CODE ATVDCAM_CODE ATVDCAM
AARMEMB_ATYP_CODE_REN STVATYP_CODE STVATYP
AARMEMB_ATYP_CODE_REM STVATYP_CODE STVATYP

Index

Index Name Index Type Column Name
AARMEMB_KEY_INDEX2   AARMEMB_AMCT_CODE
PK_AARMEMB Unique AARMEMB_PIDM
PK_AARMEMB Unique AARMEMB_MEMBERSHIP
PK_AARMEMB Unique AARMEMB_MEMB_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABDINS SQL Table S10B80.ALUMNI Refer (no action)
AARCMEM SQL Table S10B80.ALUMNI Refer (no action)
AARMCMT SQL Table S10B80.ALUMNI Refer (no action)
AARMINT SQL Table S10B80.ALUMNI Refer (no action)
AARMPRE SQL Table S10B80.ALUMNI Refer (no action)
AARMEMB_REC Oracle Package Variable S10B80.BANINST1.BWDKSRCH Rely On
AARMEMB_REC Oracle Package Variable S10B80.BANINST1.BWDKCPRF Rely On
AARMEMBVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKCPRF Use (select)Rely On
AARMEMB 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
AARMEMB_KEY_INDEX2 SQL Index S10B80.ALUMNI Rely On
PK_AARMEMB SQL Index S10B80.ALUMNI Rely On
ATVAMCT SQL Table S10B80.ALUMNI Refer (no action)
ATVAMST SQL Table S10B80.ALUMNI Refer (no action)
ATVAMTP SQL Table S10B80.ALUMNI Refer (no action)
ATVDCAM SQL Table S10B80.ALUMNI Refer (no action)
GTVLETR SQL Table S10B80.GENERAL Refer (no action)
STVATYP SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMEMB

Object Dates

Creation Date Analysis Date
04/02/2008 13:43:01:000 04/02/2008 13:49:18:000

Source Code Comments

Membership Repeating Table

Columns Comments for AARMEMB_PIDM (# 1)

Source Code Comments

Internal system identification number for the person.

Columns Comments for AARMEMB_MEMBERSHIP (# 2)

Source Code Comments

Membership code for association.

Columns Comments for AARMEMB_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMEMB_LETR_CODE (# 4)

Source Code Comments

Letter that gets sent out with the membership card.

Columns Comments for AARMEMB_AMCT_CODE (# 5)

Source Code Comments

Membership category code.

Columns Comments for AARMEMB_AMTP_CODE (# 6)

Source Code Comments

Membership type code.

Columns Comments for AARMEMB_ENTRY_DATE (# 7)

Source Code Comments

Date of entry of membership.

Columns Comments for AARMEMB_AMST_CODE (# 8)

Source Code Comments

Status code for individual membership.

Columns Comments for AARMEMB_AMST_DATE (# 9)

Source Code Comments

Date of membership status.

Columns Comments for AARMEMB_ACTIVITY_DATE (# 10)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARMEMB_REMINDER_PIDM (# 11)

Source Code Comments

Internal system identification number of the reminder party.

Columns Comments for AARMEMB_ATYP_CODE_REM (# 12)

Source Code Comments

Address type code for the reminder party.

Columns Comments for AARMEMB_RENEWAL_PIDM (# 13)

Source Code Comments

Internal system identification number of the renewal party.

Columns Comments for AARMEMB_RENEWAL_DATE (# 14)

Source Code Comments

Date of renewal for future memberships.

Columns Comments for AARMEMB_ATYP_CODE_REN (# 15)

Source Code Comments

Address type code for renewal party.

Columns Comments for AARMEMB_DCAM_CODE (# 16)

Source Code Comments

Assignment method for membership.

Columns Comments for AARMEMB_DURATION (# 17)

Source Code Comments

Length of duration for membership.

Columns Comments for AARMEMB_RULE_NO (# 18)

Source Code Comments

Rule number pertaining to membership.

Columns Comments for AARMEMB_CARD_IND (# 19)

Source Code Comments

Indicator showing whether membership card was sent.

Columns Comments for AARMEMB_CARD_DATE (# 20)

Source Code Comments

Date card was sent.

Columns Comments for AARMEMB_GRACE_PERIOD (# 21)

Source Code Comments

Grace period allowed for the membership.

Columns Comments for AARMEMB_AMT_QUALIFY (# 22)

Source Code Comments

Amount qualify which is taken from the membership rule form, that this person has to meet for the membership.

Columns Comments for AARMEMB_EXP_DATE (# 23)

Source Code Comments

Expiration date of the membership.

Columns Comments for AARMEMB_MEMB_NAME (# 24)

Source Code Comments

Default membership name for membership card and other references to the member.

Columns Comments for AARMEMB_LETR_CODE_RENEW (# 25)

Source Code Comments

Letter code that will be received by the person getting the renewal.

Columns Comments for AARMEMB_STATUS_OVERRIDE_IND (# 26)

Source Code Comments

Status override indicator. If N, status will not be automatically overriden by incoming dues prior to the renewal and expiration dates.

Table AARMINT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMINT_PIDM   NUMBER(8,0) No * *
AARMINT_MEMBERSHIP   VARCHAR2(5) No * *
AARMINT_MEMB_NO   VARCHAR2(7) No * *
AARMINT_INTEREST   VARCHAR2(5) No *  
AARMINT_TRANS_NO   VARCHAR2(7) No *  
AARMINT_AMOUNT   NUMBER(11,2) No    
AARMINT_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMINT_PIDM AARMEMB_PIDM AARMEMB
AARMINT_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB
AARMINT_MEMB_NO AARMEMB_MEMB_NO AARMEMB

Index

Index Name Index Type Column Name
PK_AARMINT Unique AARMINT_PIDM
PK_AARMINT Unique AARMINT_MEMBERSHIP
PK_AARMINT Unique AARMINT_MEMB_NO
PK_AARMINT Unique AARMINT_INTEREST
PK_AARMINT Unique AARMINT_TRANS_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AARDUES SQL Table S10B80.ALUMNI Join
AAVDUES SQL View S10B80.BANINST1 Use (select)
AARMINT 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_AARMINT SQL Index S10B80.ALUMNI Rely On
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMINT

Object Dates

Creation Date Analysis Date
04/02/2008 13:46:44:000 04/02/2008 13:49:22:000

Source Code Comments

Individual Membership Interest Table

Columns Comments for AARMINT_PIDM (# 1)

Source Code Comments

Internal system generated identification number for the person.

Columns Comments for AARMINT_MEMBERSHIP (# 2)

Source Code Comments

Membership code for the interest.

Columns Comments for AARMINT_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMINT_INTEREST (# 4)

Source Code Comments

Interest code.

Columns Comments for AARMINT_TRANS_NO (# 5)

Source Code Comments

Transaction number for the membership payment.

Columns Comments for AARMINT_AMOUNT (# 6)

Source Code Comments

Amount of the membership payment.

Columns Comments for AARMINT_ACTIVITY_DATE (# 7)

Source Code Comments

System generated date that is updated on insert or update.

Table AARMPRE

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
AARMPRE_PIDM   NUMBER(8,0) No * *
AARMPRE_MEMBERSHIP   VARCHAR2(5) No * *
AARMPRE_MEMB_NO   VARCHAR2(7) No * *
AARMPRE_DCPR_CODE   VARCHAR2(4) No * *
AARMPRE_ACTIVITY_DATE   DATE No    
AARMPRE_PREM_IND   VARCHAR2(1) Yes    
AARMPRE_PREM_DATE   DATE Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
AARMPRE_DCPR_CODE ATVDCPR_CODE ATVDCPR
AARMPRE_PIDM AARMEMB_PIDM AARMEMB
AARMPRE_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB
AARMPRE_MEMB_NO AARMEMB_MEMB_NO AARMEMB

Index

Index Name Index Type Column Name
PK_AARMPRE Unique AARMPRE_PIDM
PK_AARMPRE Unique AARMPRE_MEMBERSHIP
PK_AARMPRE Unique AARMPRE_MEMB_NO
PK_AARMPRE Unique AARMPRE_DCPR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_AARMPRE SQL Index S10B80.ALUMNI Rely On
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
ATVDCPR SQL Table S10B80.ALUMNI Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.AARMPRE

Object Dates

Creation Date Analysis Date
04/02/2008 13:46:26:000 04/02/2008 13:49:22:000

Source Code Comments

Individual Premium Repeating Table

Columns Comments for AARMPRE_PIDM (# 1)

Source Code Comments

Internal system identification number for person.

Columns Comments for AARMPRE_MEMBERSHIP (# 2)

Source Code Comments

Code for the membership.

Columns Comments for AARMPRE_MEMB_NO (# 3)

Source Code Comments

System generated number that uniquely identifies a membership.

Columns Comments for AARMPRE_DCPR_CODE (# 4)

Source Code Comments

Code for the membership premium.

Columns Comments for AARMPRE_ACTIVITY_DATE (# 5)

Source Code Comments

System generated date that is updated on insert or update.

Columns Comments for AARMPRE_PREM_IND (# 6)

Source Code Comments

Indicator to show whether premium has been sent.

Columns Comments for AARMPRE_PREM_DATE (# 7)

Source Code Comments

Date the premium was sent.

Table ATVAMCT

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMCT_CODE   VARCHAR2(5) No *  
ATVAMCT_DESC   VARCHAR2(30) No    
ATVAMCT_ACTIVITY_DATE   DATE No    
ATVAMCT_LIFETIME_IND   VARCHAR2(1) Yes    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMCT Unique ATVAMCT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AARAKCT SQL Table S10B80.ALUMNI Refer (no action)
AARDUES SQL Table S10B80.ALUMNI Refer (no action)
AARMBDP SQL Table S10B80.ALUMNI Refer (no action)
AARMBRL SQL Table S10B80.ALUMNI Refer (no action)
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
ATVAMCTC Oracle Package Cursor S10B80.BANINST1.ATKAMCT Use (select)Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.AOKPVAL Rely On
ATVAMCT 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_ATVAMCT SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMCT

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:07:000 04/02/2008 13:49:16:000

Source Code Comments

Membership Category Code Validation Table

Columns Comments for ATVAMCT_CODE (# 1)

Source Code Comments

Membership category code.

Columns Comments for ATVAMCT_DESC (# 2)

Source Code Comments

Membership category code description.

Columns Comments for ATVAMCT_ACTIVITY_DATE (# 3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for ATVAMCT_LIFETIME_IND (# 4)

Source Code Comments

Indicator for lifetime categories.

Table ATVAMGP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMGP_CODE   VARCHAR2(5) No *  
ATVAMGP_DESC   VARCHAR2(30) No    
ATVAMGP_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMGP Unique ATVAMGP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMINT SQL Table S10B80.ALUMNI Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_ATVAMGP SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMGP

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:18:000 04/02/2008 13:49:16:000

Source Code Comments

Membership Group Code Validation Table

Columns Comments for ATVAMGP_CODE (# 1)

Source Code Comments

Membership group code.

Columns Comments for ATVAMGP_DESC (# 2)

Source Code Comments

Membership group code description.

Columns Comments for ATVAMGP_ACTIVITY_DATE (# 3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table ATVAMIN

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMIN_CODE   VARCHAR2(2) No *  
ATVAMIN_DESC   VARCHAR2(30) No    
ATVAMIN_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMIN Unique ATVAMIN_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMINT SQL Table S10B80.ALUMNI Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_ATVAMIN SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMIN

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:21:000 04/02/2008 13:49:16:000

Source Code Comments

Membership Interest Type Validation Table

Columns Comments for ATVAMIN_CODE (# 1)

Source Code Comments

Membership Interest type code.

Columns Comments for ATVAMIN_DESC (# 2)

Source Code Comments

Membership Interest type code description.

Columns Comments for ATVAMIN_ACTIVITY_DATE (# 3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table ATVAMST

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMST_CODE   VARCHAR2(1) No *  
ATVAMST_DESC   VARCHAR2(30) No    
ATVAMST_ACTIVE_IND   VARCHAR2(1) No    
ATVAMST_ACTIVITY_DATE   DATE No    
ATVAMST_GRACE_IND   VARCHAR2(1) Yes    
ATVAMST_EXPIRED_IND   VARCHAR2(1) Yes    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMST Unique ATVAMST_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMSHP SQL Table S10B80.ALUMNI Refer (no action)
AARMBDP SQL Table S10B80.ALUMNI Refer (no action)
AARMBRL SQL Table S10B80.ALUMNI Refer (no action)
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
ATVAMST_REC Oracle Package Variable S10B80.BANINST1.BWDKCPRF Rely On
ATVAMSTVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKCPRF Use (select)Rely On
ATVAMSTC Oracle Package Cursor S10B80.BANINST1.ATKAMST Use (select)Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.AOKPVAL Rely On
ATVAMST 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_ATVAMST SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMST

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:40:000 04/02/2008 13:49:16:000

Source Code Comments

Membership Status Code Validation Table

Columns Comments for ATVAMST_CODE (# 1)

Source Code Comments

Membership status code.

Columns Comments for ATVAMST_DESC (# 2)

Source Code Comments

Membership status code description.

Columns Comments for ATVAMST_ACTIVE_IND (# 3)

Source Code Comments

Membership status active indicator.

Columns Comments for ATVAMST_ACTIVITY_DATE (# 4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for ATVAMST_GRACE_IND (# 5)

Source Code Comments

Grace period indicator.

Columns Comments for ATVAMST_EXPIRED_IND (# 6)

Source Code Comments

Expired indicator.

Table ATVAMTP

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVAMTP_CODE   VARCHAR2(3) No *  
ATVAMTP_DESC   VARCHAR2(30) No    
ATVAMTP_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVAMTP Unique ATVAMTP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMSHP SQL Table S10B80.ALUMNI Refer (no action)
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
ATVAMTP_REC Oracle Package Variable S10B80.BANINST1.BWDKSRCH Rely On
ATVAMTPVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKSRCH Use (select)Rely On
ATVAMTP 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_ATVAMTP SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVAMTP

Object Dates

Creation Date Analysis Date
04/02/2008 13:41:43:000 04/02/2008 13:49:16:000

Source Code Comments

Membership Type Validation Table

Columns Comments for ATVAMTP_CODE (# 1)

Source Code Comments

Membership type code.

Columns Comments for ATVAMTP_DESC (# 2)

Source Code Comments

Membership type code description.

Columns Comments for ATVAMTP_ACTIVITY_DATE (# 3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table ATVDCAM

Server Name S10B80
Database Name ALUMNI
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ATVDCAM_CODE   VARCHAR2(2) No *  
ATVDCAM_DESC   VARCHAR2(30) No    
ATVDCAM_MAN_SYS_IND   VARCHAR2(1) No    
ATVDCAM_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ATVDCAM Unique ATVDCAM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AARMEMB SQL Table S10B80.ALUMNI Refer (no action)
APRDCLB SQL Table S10B80.ALUMNI Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_ATVDCAM SQL Index S10B80.ALUMNI Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.ALUMNI.ATVDCAM

Object Dates

Creation Date Analysis Date
04/02/2008 13:46:45:000 04/02/2008 13:49:22:000

Source Code Comments

Gift Society Assignment Validation Table

Columns Comments for ATVDCAM_CODE (# 1)

Source Code Comments

This field specifies the gift society assignment code.

Columns Comments for ATVDCAM_DESC (# 2)

Source Code Comments

This field specifies the description of the gift society assignment code.

Columns Comments for ATVDCAM_MAN_SYS_IND (# 3)

Source Code Comments

This field indicates how a gift society may be assigned, system calculated or manual assignment.

Columns Comments for ATVDCAM_ACTIVITY_DATE (# 4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table GTVLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

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

Foreign Key information

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

Index

Index Name Index Type Column Name
PK_GTVLETR Unique GTVLETR_CODE

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVLETR SQL Index S10B80.GENERAL Rely On
GTVLETR SQL Table S10B80.GENERAL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVLETR

Object Dates

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

Source Code Comments

Letter Process Letter Validation Table

Columns Comments for GTVLETR_CODE (# 1)

Source Code Comments

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

Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for GTVLETR_DUPL_IND (# 3)

Source Code Comments

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

Columns Comments for GTVLETR_DESC (# 4)

Source Code Comments

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

Columns Comments for GTVLETR_PRINT_COMMAND (# 5)

Source Code Comments

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

Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)

Source Code Comments

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

Table STVATYP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

Index

Index Name Index Type Column Name
PK_STVATYP Unique STVATYP_CODE

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_STVATYP SQL Index S10B80.SATURN Rely On
STVTELE SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.STVATYP

Object Dates

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

Source Code Comments

Address Type Validation Table

Columns Comments for STVATYP_CODE (# 1)

Source Code Comments

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

Columns Comments for STVATYP_DESC (# 2)

Source Code Comments

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

Columns Comments for STVATYP_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for STVATYP_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVATYP_TELE_CODE (# 5)

Source Code Comments

Default Telephone type code for telephone number.

Columns Comments for STVATYP_UPDATE_WEB_IND (# 6)

Source Code Comments

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

Table STVCOLL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
STVCOLL_CODE   VARCHAR2(2) No *  
STVCOLL_DESC   VARCHAR2(30) No    
STVCOLL_ADDR_STREET_LINE1   VARCHAR2(75) Yes    
STVCOLL_ADDR_STREET_LINE2   VARCHAR2(75) Yes    
STVCOLL_ADDR_STREET_LINE3   VARCHAR2(75) Yes    
STVCOLL_ADDR_CITY   VARCHAR2(50) Yes    
STVCOLL_ADDR_STATE   VARCHAR2(2) Yes    
STVCOLL_ADDR_COUNTRY   VARCHAR2(28) Yes    
STVCOLL_ADDR_ZIP_CODE   VARCHAR2(10) Yes    
STVCOLL_ACTIVITY_DATE   DATE Yes    
STVCOLL_SYSTEM_REQ_IND   VARCHAR2(1) Yes    
STVCOLL_VR_MSG_NO   NUMBER(6,0) Yes    
STVCOLL_STATSCAN_CDE3   VARCHAR2(6) Yes    
STVCOLL_DICD_CODE   VARCHAR2(3) Yes    
STVCOLL_HOUSE_NUMBER   VARCHAR2(10) Yes    
STVCOLL_ADDR_STREET_LINE4   VARCHAR2(75) Yes    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_STVCOLL Unique STVCOLL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
AABMINT SQL Table S10B80.ALUMNI Refer (no action)
ADBDESG SQL Table S10B80.ALUMNI Refer (no action)
APBCONS SQL Table S10B80.ALUMNI Refer (no action)
APRADEG SQL Table S10B80.ALUMNI Refer (no action)
ASBSORG SQL Table S10B80.ALUMNI Refer (no action)
GTVEMPH SQL Table S10B80.GENERAL Refer (no action)
PEBEMPL SQL Table S10B80.PAYROLL Refer (no action)
PERFASG SQL Table S10B80.PAYROLL Refer (no action)
PERFNIO SQL Table S10B80.PAYROLL Refer (no action)
PERFNIS SQL Table S10B80.PAYROLL Refer (no action)
PTRSCHD SQL Table S10B80.PAYROLL Refer (no action)
PTRSCLV SQL Table S10B80.PAYROLL Refer (no action)
SARADAP SQL Table S10B80.SATURN Refer (no action)
SARCHKB SQL Table S10B80.SATURN Refer (no action)
SARDCSN SQL Table S10B80.SATURN Refer (no action)
SARQKER SQL Table S10B80.SATURN Refer (no action)
SARRRFT SQL Table S10B80.SATURN Refer (no action)
SARWAAD SQL Table S10B80.SATURN Refer (no action)
SARWADF SQL Table S10B80.SATURN Refer (no action)
SCBCDEP SQL Table S10B80.SATURN Refer (no action)
SCBCDTL SQL Table S10B80.SATURN Refer (no action)
SCBCRSE SQL Table S10B80.SATURN Refer (no action)
SCRCDTX SQL Table S10B80.SATURN Refer (no action)
SCRFEES SQL Table S10B80.SATURN Refer (no action)
SCRRCOL SQL Table S10B80.SATURN Refer (no action)
SDBPROG SQL Table S10B80.SATURN Refer (no action)
SFRMHRS SQL Table S10B80.SATURN Refer (no action)
SFRRGFE SQL Table S10B80.SATURN Refer (no action)
SFRTMSL SQL Table S10B80.SATURN Refer (no action)
SFRTMST SQL Table S10B80.SATURN Refer (no action)
SGBSTDN SQL Table S10B80.SATURN Refer (no action)
SGRASSI SQL Table S10B80.SATURN Refer (no action)
SHBCOMI SQL Table S10B80.SATURN Refer (no action)
SHBGADS SQL Table S10B80.SATURN Refer (no action)
SHBGELR SQL Table S10B80.SATURN Refer (no action)
SHBGSCH SQL Table S10B80.SATURN Refer (no action)
SHRASDL SQL Table S10B80.SATURN Refer (no action)
SHRASGE SQL Table S10B80.SATURN Refer (no action)
SHRASTR SQL Table S10B80.SATURN Refer (no action)
SHRCAST SQL Table S10B80.SATURN Refer (no action)
SHRCOMM SQL Table S10B80.SATURN Refer (no action)
SHRDGMR SQL Table S10B80.SATURN Refer (no action)
SHRPREV SQL Table S10B80.SATURN Refer (no action)
SHRPRGE SQL Table S10B80.SATURN Refer (no action)
SHRTCKN SQL Table S10B80.SATURN Refer (no action)
SIRDPCL SQL Table S10B80.SATURN Refer (no action)
SIRNIST SQL Table S10B80.SATURN Refer (no action)
SIRNLVA SQL Table S10B80.SATURN Refer (no action)
SMRACAA SQL Table S10B80.SATURN Refer (no action)
SMRAQUA SQL Table S10B80.SATURN Refer (no action)
SMRAREX SQL Table S10B80.SATURN Refer (no action)
SMRARSA SQL Table S10B80.SATURN Refer (no action)
SMRARUL SQL Table S10B80.SATURN Refer (no action)
SMRGCAA SQL Table S10B80.SATURN Refer (no action)
SMRGREX SQL Table S10B80.SATURN Refer (no action)
SMRGRSA SQL Table S10B80.SATURN Refer (no action)
SMRGRUL SQL Table S10B80.SATURN Refer (no action)
SMRIECO SQL Table S10B80.SATURN Refer (no action)
SMRPCRS SQL Table S10B80.SATURN Refer (no action)
SMRPRLE SQL Table S10B80.SATURN Refer (no action)
SMRPRRQ SQL Table S10B80.SATURN Refer (no action)
SMRPRSA SQL Table S10B80.SATURN Refer (no action)
SMRRQCM SQL Table S10B80.SATURN Refer (no action)
SMRSACA SQL Table S10B80.SATURN Refer (no action)
SMRSARE SQL Table S10B80.SATURN Refer (no action)
SMRSARS SQL Table S10B80.SATURN Refer (no action)
SMRSARU SQL Table S10B80.SATURN Refer (no action)
SMRSGCA SQL Table S10B80.SATURN Refer (no action)
SMRSGRE SQL Table S10B80.SATURN Refer (no action)
SMRSGRS SQL Table S10B80.SATURN Refer (no action)
SMRSGRU SQL Table S10B80.SATURN Refer (no action)
SMRSPRS SQL Table S10B80.SATURN Refer (no action)
SMTPRRQ SQL Table S10B80.SATURN Refer (no action)
SOBCSPR SQL Table S10B80.SATURN Refer (no action)
SOBCURR SQL Table S10B80.SATURN Refer (no action)
SOBEXCR SQL Table S10B80.SATURN Refer (no action)
SOBODTE SQL Table S10B80.SATURN Refer (no action)
SOBROPR SQL Table S10B80.SATURN Refer (no action)
SORCCOL SQL Table S10B80.SATURN Refer (no action)
SORCOMM SQL Table S10B80.SATURN Refer (no action)
SORDEGR SQL Table S10B80.SATURN Refer (no action)
SOREQUI SQL Table S10B80.SATURN Refer (no action)
SOREXTN SQL Table S10B80.SATURN Refer (no action)
SORLCDF SQL Table S10B80.SATURN Refer (no action)
SORLCUR SQL Table S10B80.SATURN Refer (no action)
SORRFND SQL Table S10B80.SATURN Refer (no action)
SORRSTS SQL Table S10B80.SATURN Refer (no action)
SORWDSP SQL Table S10B80.SATURN Join
SRBPRED SQL Table S10B80.SATURN Refer (no action)
SRBRECR SQL Table S10B80.SATURN Refer (no action)
SRTPREL SQL Table S10B80.SATURN Refer (no action)
SSBDFEE SQL Table S10B80.SATURN Refer (no action)
SSBOVRR SQL Table S10B80.SATURN Refer (no action)
SSRFEES SQL Table S10B80.SATURN Refer (no action)
SSRRCOL SQL Table S10B80.SATURN Refer (no action)
SSRRESV SQL Table S10B80.SATURN Refer (no action)
ST_STVCOLL_AR_LDI SQL Trigger S10B80.SATURN Rely On
AG_EVENTS_AND_FUNCTIONS SQL View S10B80.BANINST1 Use (select)
GEVEVN1 SQL View S10B80.BANINST1 Join
SAVADMT SQL View S10B80.BANINST1 Use (select)
SOVCOLL SQL View S10B80.BANINST1 Use (select)
SOVDATA SQL View S10B80.BANINST1 Use (select)
SOVDEGR SQL View S10B80.BANINST1 Use (select)
SOVDGMR SQL View S10B80.BANINST1 Use (select)
SOVDGMR_OJ SQL View S10B80.BANINST1 Use (select)
SOVSTDN SQL View S10B80.BANINST1 Use (select)
F_GET_DESC_ALUMNI SQL Function S10B80.BANINST1 Use (select)
F_GET_DESC_FNC SQL Function S10B80.BANINST1 Use (select)
F_STUDENT_GET_DESC SQL Function S10B80.BANINST1 Use (select)
COLLEGE_REC_TYPE Oracle Package Type S10B80.BANINST1.ICSCKCOM Rely On
COLL_TYPE Oracle Package Type S10B80.BANINST1.BWAKSRCH Rely On
SORCMJRC Oracle Package Cursor S10B80.BANINST1.BWSKXMIS Use (select)
STVCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKLIBS Use (select)Rely On
STVCOLL_TAB_TYPE Oracle Package Type S10B80.BANINST1.SOKTABS Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWDKSRCH Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWDKPSRC Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWDKLIBS Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWDKCPRF Rely On
COLLEGE_REC_TYPE Oracle Package Type S10B80.BANINST1.ICSCKLDI Rely On
GT_CURRICULUM_REC Oracle Package Type S10B80.BANINST1.SP_HOUSING_PROFILE Rely On
GETSTVCOLLC Oracle Package Cursor S10B80.BANINST1.BWAKALOG Use (select)Rely On
PREFCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKSRCH Use (select)Rely On
PREFCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKPSRC Use (select)Rely On
STVCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKSRCH Use (select)Rely On
STVCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKPSRC Use (select)Rely On
STVCOLLVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKCPRF Use (select)Rely On
STVCOLL_ADDRESSC Oracle Package Cursor S10B80.BANINST1.BWSKWTRR Rely On
STVCOLL_ADDRESSC Oracle Package Cursor S10B80.BANINST1.BWSKWTRR Use (select)
STVCOLL_C Oracle Package Cursor S10B80.BANINST1.BWCKSMDS Use (select)
STVCOLL_LISTC Oracle Package Cursor S10B80.BANINST1.BWSKWTRR Use (select)
P_CREATE_APPL Oracle Package Procedure S10B80.BANINST1.TS_STUDENT_OAPERF Rely On
P_DELETE_ALL Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (delete,select)
P_LEARNER_CURRICULUM Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT Rely On
P_LEARNER_CURRICULUM Oracle Package Procedure S10B80.BANINST1.TS_SB_GRADEROLL Rely On
P_LEARNER_CURRICULUM Oracle Package Procedure S10B80.BANINST1.TS_SB_REGISTRATION Rely On
P_LEARNER_CURRICULUM Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES Rely On
P_LEARNER_CURRICULUM Oracle Package Procedure S10B80.BANINST1.TS_SB_CURRICULUM Rely On
P_ONETIMEVALUES Oracle Package Procedure S10B80.BANINST1.TS_STUDENT_OAPERF Rely On
P_ONETIMEVALUES Oracle Package Procedure S10B80.BANINST1.TS_STUDENT_OAPERF Use (Insert,select)
P_PRINT_COLLEGES Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_PROC_SET_INFO Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_SFRRGFE Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT Rely On
P_SFRRGFE Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES Rely On
P_VALIDATION Oracle Package Procedure S10B80.BANINST1.TS_STUDENT_OAPERF Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_GRADEROLL Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_REGISTRATION Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_CURRICULUM Use (Insert)
P_VALIDATION_DATA Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING Use (Insert)
TESTCASE_CC Oracle Package Procedure S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWSKRSTA Rely On
STVCOLL_REC Oracle Package Variable S10B80.BANINST1.BWAKALOG Rely On
APBCONSCOLLSVIEWC Oracle Package Cursor S10B80.BANINST1.BWAKSRCH Use (select)
STVCOLLC Oracle Package Cursor S10B80.BANINST1.STKCOLL Use (select)Rely On
STVCOLL_C Oracle Package Cursor S10B80.BANINST1.GB_STVCOLL Rely On
STVCOLL_C Oracle Package Cursor S10B80.BANINST1.GB_STVCOLL Use (select)Rely On
STVCOLL_WDSP_C Oracle Package Cursor S10B80.BANINST1.BWCKLIBS Use (select)Rely On
P_CAT_SEARCH Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_CHECKBASE Oracle Package Procedure S10B80.BANINST1.SOKCURR Rely On
P_CHECKCURRICULUM Oracle Package Procedure S10B80.BANINST1.SOKCURR Rely On
P_CHECKPROGRAMMAJOR Oracle Package Procedure S10B80.BANINST1.SOKCURR Rely On
P_CREATE_SECTION_DFT_RULES Oracle Package Procedure S10B80.BANINST1.SSKOLRP Rely On
P_DELETE_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_DELETE_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (delete)
P_DISPCURRENT_TABLE Oracle Package Procedure S10B80.BANINST1.BWCKCAPP Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.SB_COURSE_CATALOG Rely On
P_DISPLAY_COURSES Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Rely On
P_DISPLAY_INFO Oracle Package Procedure S10B80.BANINST1.BWCKCTLG Use (select)Rely On
P_DISPLAY_STEP_EIGHT Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_FIVE Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_FOUR Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_NINE Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_SEVEN Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_SIX Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_THREE Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_DISPLAY_STEP_THREE Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Use (select)Rely On
P_DISP_CONFIRM Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_PAYMENT_TYPE Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_TRANSCRIPT_ADDRESS Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_TRANSCRIPT_REQUEST_DATA Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_TRANSCRIPT_REQUEST_TYPE Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DISP_TRANS_REQUEST_CHARGES Oracle Package Procedure S10B80.BANINST1.BWSKWTRR Rely On
P_DO_WHATIF_CAPP Oracle Package Procedure S10B80.BANINST1.BWCKCMPL Rely On
P_FACCLAWAITSUM Oracle Package Procedure S10B80.BANINST1.BWLKFCWL Rely On
P_FACSCHED Oracle Package Procedure S10B80.BANINST1.BWLKIFAC Rely On
P_FORMAT_BASE_CURR Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_GETACCESSIBLECOLLDEPT Oracle Package Procedure S10B80.BANINST1.SOKEPRT Use (select)
P_GET_SMBPOGN Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_SMRAOSA Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_SMRDOEX Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_SMRGOSA Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_SMRPOSA Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_SMRRQCM Oracle Package Procedure S10B80.BANINST1.SMKXAPI Rely On
P_GET_STVCOLL_ROW Oracle Package Procedure S10B80.BANINST1.STKSELS Rely On
P_INSERT_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_INSERT_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (Insert)
P_INSERT_WHATIF_SMRRQCM Oracle Package Procedure S10B80.BANINST1.BWCKCMPL Rely On
P_MIGRATE_PROSPECT Oracle Package Procedure S10B80.BANINST1.SRKPREL Rely On
P_PRINT_CRSE_INFO_WINDOW Oracle Package Procedure S10B80.BANINST1.BWPKFLDT Rely On
P_SAVE_COLLEGE Oracle Package Procedure S10B80.BANINST1.ICSCKLDI Rely On
P_SEND_COLLEGE Oracle Package Procedure S10B80.BANINST1.ICSCKLDI Rely On
P_UPDATE_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Rely On
P_UPDATE_STVCOLL Oracle Package Procedure S10B80.BANINST1.TS_SB_VALIDATION Use (update)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.AOKPVAL Rely On
P_VERIFYDATA Oracle Package Procedure S10B80.BANINST1.SOKCURR Rely On
P_WHATIF_FINAL_STEP Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_WHATIF_NEXT_STEP Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
P_WHATIF_SUBMIT Oracle Package Procedure S10B80.BANINST1.BWCKSMDS Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FIELDOFSTUDY Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_GRADAPP_ELIGIBLE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_CLASSTIMES Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_LEARNERMODULE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_TRANSCRIPT_REQ_NAME Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_BLDGDEFINITION Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_GRADAPP_SELRULE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_INSTITUTION_ROLE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_GB_PCOL_DEGREE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_FAC_SCHRATE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_FAC_NISTCOMP Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_CURRICULUM Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_HOUSING_PROFILE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_FAC_SCLRATE Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_BLDGDEFINITION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_NOTIFICATION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_REORDERING Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_COURSE_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_LDICOURSE Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_LEARNER Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_EXCLUSION Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_FAC_NIOLCOMP Use (Insert)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_TRANSFER_CRSE Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SP_TRANSFER_CRSE 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_SB_CRSE_SELECT_PRI Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_SECTION_LABOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACASSIGNMENT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_FACULTY Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_COLLECTOR Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_WL_SECTION_CTRL Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_SB_LEARNEROUTCOME Use (Insert,select)
UT_TEARDOWN Oracle Package Procedure S10B80.BANINST1.UT_SB_BLDGDEFINITION Use (delete)
F_CHECKCURRICULUM Oracle Package Function S10B80.BANINST1.SAKDCRV Rely On
F_CODE_EXISTS Oracle Package Function S10B80.BANINST1.GB_STVCOLL Rely On
F_COLL_CHK Oracle Package Function S10B80.BANINST1.SAKPCOM Use (select)
F_FTE_FACTOR Oracle Package Function S10B80.BANINST1.SIKLOAD Rely On
F_GETCODEDESCRIPTION Oracle Package Function S10B80.BANINST1.BWLKSECR Use (select)
F_GET_COLLEGE Oracle Package Function S10B80.BANINST1.ICSCKLDI Rely On
F_GET_COLLEGE Oracle Package Function S10B80.BANINST1.ICSCKCOM Rely On
F_GET_COLLEGE Oracle Package Function S10B80.BANINST1.ICSCKCOM Use (select)
F_GET_COLL_DESC Oracle Package Function S10B80.BANINST1.STVFUNC Rely On
F_GET_COLL_DESC Oracle Package Function S10B80.BANINST1.STVFUNC Use (select)
F_GET_DESCRIPTION Oracle Package Function S10B80.BANINST1.GB_STVCOLL Rely On
F_MATCH_CURRICULUM Oracle Package Function S10B80.BANINST1.SOKCCUR Rely On
F_NIST_COMPENSATION_APPLIED Oracle Package Function S10B80.BANINST1.SIKAFLA Rely On
F_NIST_COMPENSATION_EXTRACTED Oracle Package Function S10B80.BANINST1.SIKAFLA Rely On
F_STVCOLL_LIKE Oracle Package Function S10B80.BANINST1.AOKPVAL Use (select)
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKSMDS Rely On
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKSMDS Use (select)
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKSMLT Rely On
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKSMLT Use (select)
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKCAPP Rely On
GET_COLL_DESC Oracle Package Function S10B80.BANINST1.BWCKCAPP Use (select)
STVCOLL 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_STVCOLL SQL Index S10B80.SATURN Rely On
ST_STVCOLL_AR_LDI SQL Trigger S10B80.SATURN Fire (Insert,update,delete,after,each row)
ST_STVCOLL_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.STVCOLL

Object Dates

Creation Date Analysis Date
04/02/2008 20:50:54:000 04/02/2008 21:18:13:000

Source Code Comments

College Validation Table

Columns Comments for STVCOLL_CODE (# 1)

Source Code Comments

This field identifies the college code referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules. Reqd value: 00 - No College Designated.

Columns Comments for STVCOLL_DESC (# 2)

Source Code Comments

This field specifies the college or school (i.e. **Banner"s** highest administrative unit) associated with the college code.

Columns Comments for STVCOLL_ADDR_STREET_LINE1 (# 3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE2 (# 4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE3 (# 5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_CITY (# 6)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STATE (# 7)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_COUNTRY (# 8)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_ZIP_CODE (# 9)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ACTIVITY_DATE (# 10)

Source Code Comments

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

Columns Comments for STVCOLL_SYSTEM_REQ_IND (# 11)

Source Code Comments

System Required Indicator

Columns Comments for STVCOLL_VR_MSG_NO (# 12)

Source Code Comments

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

Columns Comments for STVCOLL_STATSCAN_CDE3 (# 13)

Source Code Comments

Statistics Canadian reporting institution specific code.

Columns Comments for STVCOLL_DICD_CODE (# 14)

Source Code Comments

MIS DISTRICT/DIVISION CODE: This field indicates equivalent district or division associated with an Institution.

Columns Comments for STVCOLL_HOUSE_NUMBER (# 15)

Source Code Comments

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

Columns Comments for STVCOLL_ADDR_STREET_LINE4 (# 16)

Source Code Comments

This field is not currently in use.

Link between AABMINT and AARMBIN


Join Information

Objects list
User link

Link List

Link Type Link Project
Join Link Between AABMINT and AARMBIN ALUMNI

List of Real links

Link type Between And
Join AABMINT AARMBIN

Link between AARMCMT and AARMEMB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMCMT and AARMEMB (FK1_AARMCMT_INV_AARMEMB_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMCMT AARMCMT_PIDM AARMEMB_PIDM AARMEMB (1,1)-(0,n)
AARMCMT AARMCMT_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB (1,1)-(0,n)
AARMCMT AARMCMT_MEMB_NO AARMEMB_MEMB_NO AARMEMB (1,1)-(0,n)

Link between AARMEMB and ATVAMCT


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and ATVAMCT (FK1_AARMEMB_INV_ATVAMCT_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMEMB AARMEMB_AMCT_CODE ATVAMCT_CODE ATVAMCT (1,1)-(0,n)

Link between AARMEMB and ATVAMST


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and ATVAMST (FK1_AARMEMB_INV_ATVAMST_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMEMB AARMEMB_AMST_CODE ATVAMST_CODE ATVAMST (1,1)-(0,n)

Link between AARMEMB and ATVAMTP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and ATVAMTP (FK1_AARMEMB_INV_ATVAMTP_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMEMB AARMEMB_AMTP_CODE ATVAMTP_CODE ATVAMTP (1,1)-(0,n)

Link between AARMEMB and GTVLETR


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and GTVLETR (FK1_AARMEMB_INV_GTVLETR_CODE) ALUMNI
Refer (no action) Link Informative Foreign Key Between AARMEMB and GTVLETR (FK2_AARMEMB_INV_GTVLETR_CODE) ALUMNI

Foreign Key information

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

Foreign Key information

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

Link between AABMINT and ATVAMGP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMINT and ATVAMGP (FK1_AABMINT_INV_ATVAMGP_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_AMGP_CODE ATVAMGP_CODE ATVAMGP (0,1)-(0,n)

Link between AABMINT and ATVAMIN


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMINT and ATVAMIN (FK1_AABMINT_INV_ATVAMIN_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_AMIN_CODE ATVAMIN_CODE ATVAMIN (1,1)-(0,n)

Link between AARCMEM and AARMEMB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARCMEM and AARMEMB (FK1_AARCMEM_INV_AARMEMB_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARCMEM AARCMEM_PIDM AARMEMB_PIDM AARMEMB (1,1)-(0,n)
AARCMEM AARCMEM_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB (1,1)-(0,n)
AARCMEM AARCMEM_MEMB_NO AARMEMB_MEMB_NO AARMEMB (1,1)-(0,n)

Link between AABMSHP and ATVAMST


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMSHP and ATVAMST (FK1_AABMSHP_INV_ATVAMST_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMSHP AABMSHP_AMST_CODE ATVAMST_CODE ATVAMST (0,1)-(0,n)

Link between AABMSHP and ATVAMTP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMSHP and ATVAMTP (FK1_AABMSHP_INV_ATVAMTP_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMSHP AABMSHP_AMTP_CODE_DFLT ATVAMTP_CODE ATVAMTP (0,1)-(0,n)

Link between AABMSHP and GTVLETR


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMSHP and GTVLETR (FK1_AABMSHP_INV_GTVLETR_CODE) ALUMNI
Refer (no action) Link Informative Foreign Key Between AABMSHP and GTVLETR (FK2_AABMSHP_INV_GTVLETR_CODE) ALUMNI

Foreign Key information

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

Foreign Key information

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

Link between AARMPRE and AARMEMB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMPRE and AARMEMB (FK1_AARMPRE_INV_AARMEMB_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMPRE AARMPRE_PIDM AARMEMB_PIDM AARMEMB (1,1)-(0,n)
AARMPRE AARMPRE_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB (1,1)-(0,n)
AARMPRE AARMPRE_MEMB_NO AARMEMB_MEMB_NO AARMEMB (1,1)-(0,n)

Link between AABDINS and AARMEMB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABDINS and AARMEMB (FK1_AABDINS_INV_AARMEMB_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABDINS AABDINS_PIDM AARMEMB_PIDM AARMEMB (1,1)-(0,1)
AABDINS AABDINS_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB (1,1)-(0,1)
AABDINS AABDINS_MEMB_NO AARMEMB_MEMB_NO AARMEMB (1,1)-(0,1)

Link between AABDINS and GTVLETR


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABDINS and GTVLETR (FK1_AABDINS_INV_GTVLETR_CODE) ALUMNI

Foreign Key information

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

Link between AARMINT and AARMEMB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMINT and AARMEMB (FK1_AARMINT_INV_AARMEMB_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMINT AARMINT_PIDM AARMEMB_PIDM AARMEMB (1,1)-(0,n)
AARMINT AARMINT_MEMBERSHIP AARMEMB_MEMBERSHIP AARMEMB (1,1)-(0,n)
AARMINT AARMINT_MEMB_NO AARMEMB_MEMB_NO AARMEMB (1,1)-(0,n)

Link between AARMEMB and ATVDCAM


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and ATVDCAM (FK1_AARMEMB_INV_ATVDCAM_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMEMB AARMEMB_DCAM_CODE ATVDCAM_CODE ATVDCAM (0,1)-(0,n)

Link between AARMBCM and AABMSHP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMBCM and AABMSHP (FK1_AARMBCM_INV_AABMSHP_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMBCM AARMBCM_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP (1,1)-(0,n)

Link between AARMBIN and AABMSHP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMBIN and AABMSHP (FK1_AARMBIN_INV_AABMSHP_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARMBIN AARMBIN_MEMBERSHIP AABMSHP_MEMBERSHIP AABMSHP (1,1)-(0,n)

Link between AARINCM and AABMINT


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARINCM and AABMINT (FK1_AARINCM_INV_AABMINT_KEY) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AARINCM AARINCM_INTEREST AABMINT_INTEREST AABMINT (1,1)-(0,n)

Link between GTVLETR and GTVLETR


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between GTVLETR and GTVLETR (FK1_GTVLETR_INV_GTVLETR_CODE) GENERAL

Foreign Key information

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

Link between AABDINS and STVATYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABDINS and STVATYP (FK1_AABDINS_INV_STVATYP_CODE) ALUMNI

Foreign Key information

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

Link between AARMEMB and STVATYP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AARMEMB and STVATYP (FK1_AARMEMB_INV_STVATYP_CODE) ALUMNI
Refer (no action) Link Informative Foreign Key Between AARMEMB and STVATYP (FK2_AARMEMB_INV_STVATYP_CODE) ALUMNI

Foreign Key information

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

Foreign Key information

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

Link between AABMINT and STVCOLL


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between AABMINT and STVCOLL (FK1_AABMINT_INV_STVCOLL_CODE) ALUMNI

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
AABMINT AABMINT_COLL_CODE STVCOLL_CODE STVCOLL (0,1)-(0,n)