Model Recruiting*

Model Label : Recruiting SR% tables and some supporting tables

List of Objects

Object Name	Object Type	Layer Name
PK_SRBPRED	SQL Index	Default
PK_SRBRECR	SQL Index	Default
PK_SRBWPDS	SQL Index	Default
PK_SRBWPRO	SQL Index	Default
PK_SRRCHRT	SQL Index	Default
PK_SRRLEND	SQL Index	Default
PK_SRRRATT	SQL Index	Default
PK_SRRRSRC	SQL Index	Default
PK_SRRTPTS	SQL Index	Default
PK_SRRVIST	SQL Index	Default
PK_SRRWACK	SQL Index	Default
PK_SRTADDR	SQL Index	Default
PK_SRTCRSS	SQL Index	Default
PK_SRTDEGR	SQL Index	Default
PK_SRTEMAL	SQL Index	Default
PK_SRTGPAT	SQL Index	Default
PK_SRTHSCH	SQL Index	Default
PK_SRTIDEN	SQL Index	Default
PK_SRTINTS	SQL Index	Default
PK_SRTLEND	SQL Index	Default
PK_SRTMAJR	SQL Index	Default
PK_SRTMATL	SQL Index	Default
PK_SRTPCOL	SQL Index	Default
PK_SRTPERS	SQL Index	Default
PK_SRTPRAC	SQL Index	Default
PK_SRTPREL	SQL Index	Default
PK_SRTSUPL	SQL Index	Default
PK_SRTTELE	SQL Index	Default
PK_SRTTEST	SQL Index	Default
PK_SRTTPFD	SQL Index	Default
PK_SRTTSPC	SQL Index	Default
SRBPRED	SQL Table	Default
SRBRECR	SQL Table	Default
SRBWPDS	SQL Table	Default
SRBWPRO	SQL Table	Default
SRRCHRT	SQL Table	Default
SRRLEND	SQL Table	Default
SRRRATT	SQL Table	Default
SRRRCMT	SQL Table	Default
SRRRSRC	SQL Table	Default
SRRTPTS	SQL Table	Default
SRRVIST	SQL Table	Default
SRRWACK	SQL Table	Default
SRTADDR	SQL Table	Default
SRTCRSS	SQL Table	Default
SRTDEGR	SQL Table	Default
SRTEMAL	SQL Table	Default
SRTGPAT	SQL Table	Default
SRTHSCH	SQL Table	Default
SRTIDEN	SQL Table	Default
SRTINTL	SQL Table	Default
SRTINTS	SQL Table	Default
SRTLEND	SQL Table	Default
SRTMAJR	SQL Table	Default
SRTMATL	SQL Table	Default
SRTPCOL	SQL Table	Default
SRTPERS	SQL Table	Default
SRTPRAC	SQL Table	Default
SRTPREL	SQL Table	Default
SRTRECR	SQL Table	Default
SRTSUPL	SQL Table	Default
SRTTELE	SQL Table	Default
SRTTEST	SQL Table	Default
SRTTPFD	SQL Table	Default
SRTTSPC	SQL Table	Default

Model View

Index PK_SRBPRED

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRBPRED
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRBPRED_PREL_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRBPRED	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRBPRED

Object Dates

Creation Date	Analysis Date
04/02/2008 20:52:05:000	04/02/2008 20:52:05:000

Index PK_SRBRECR

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRBRECR
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRBRECR_PIDM	NUMBER	8	8
SRBRECR_TERM_CODE	VARCHAR2	6	0
SRBRECR_ADMIN_SEQNO	NUMBER	2	2

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRBRECR	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRBRECR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:35:000	04/02/2008 20:53:35:000

Index PK_SRBWPDS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRBWPDS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length
SRBWPDS_PREL_CODE	VARCHAR2	10
SRBWPDS_VAL_TABLE	VARCHAR2	30
SRBWPDS_VAL_CODE	VARCHAR2	12

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRBWPDS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRBWPDS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:34:06:000	04/02/2008 20:34:06:000

Index PK_SRBWPRO

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRBWPRO
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRBWPRO_PREL_CODE	VARCHAR2	10	0
SRBWPRO_WPIC_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRBWPRO	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRBWPRO

Object Dates

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

Index PK_SRRCHRT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRCHRT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRCHRT_PIDM	NUMBER	8	8
SRRCHRT_TERM_CODE	VARCHAR2	6	0
SRRCHRT_ADMIN_SEQNO	NUMBER	2	2
SRRCHRT_CHRT_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRCHRT	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRCHRT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:59:52:000	04/02/2008 20:59:52:000

Index PK_SRRLEND

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRLEND
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRLEND_PIDM	NUMBER	8	8
SRRLEND_TERM_CODE	VARCHAR2	6	0
SRRLEND_ADMIN_SEQNO	NUMBER	2	2
SRRLEND_LEND_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRLEND	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRLEND

Object Dates

Creation Date	Analysis Date
04/02/2008 21:02:27:000	04/02/2008 21:02:27:000

Index PK_SRRRATT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRRATT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRRATT_PIDM	NUMBER	8	8
SRRRATT_TERM_CODE	VARCHAR2	6	0
SRRRATT_ADMIN_SEQNO	NUMBER	2	2
SRRRATT_ATTS_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRRATT	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRRATT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:37:000	04/02/2008 20:55:37:000

Index PK_SRRRSRC

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRRSRC
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRRSRC_PIDM	NUMBER	8	8
SRRRSRC_TERM_CODE	VARCHAR2	6	0
SRRRSRC_ADMIN_SEQNO	NUMBER	2	2
SRRRSRC_SBGI_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRRSRC	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRRSRC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:35:39:000	04/02/2008 20:35:39:000

Index PK_SRRTPTS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRTPTS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRTPTS_TESC_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRTPTS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRTPTS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:47:28:000	04/02/2008 20:47:28:000

Index PK_SRRVIST

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRVIST
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRVIST_SBGI_CODE	VARCHAR2	6	0
SRRVIST_RECR_CODE	VARCHAR2	3	0
SRRVIST_CONTACT_DATE	DATE	7	0
SRRVIST_CONTACT_FROM_TIME	NUMBER	4	4
SRRVIST_CONTACT_TO_TIME	NUMBER	4	4

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRVIST	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRVIST

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:32:000	04/02/2008 20:42:32:000

Index PK_SRRWACK

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRRWACK
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRRWACK_PREL_CODE	VARCHAR2	10	0
SRRWACK_SEQ_NO	NUMBER	3	3

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRRWACK	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRRWACK

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:27:000	04/02/2008 20:51:27:000

Index PK_SRTADDR

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTADDR
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTADDR_RIDM	NUMBER	8	8
SRTADDR_ATYP_CODE	VARCHAR2	2	0
SRTADDR_SEQNO	NUMBER	2	2

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTADDR	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTADDR

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:36:000	04/02/2008 21:06:36:000

Index PK_SRTCRSS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTCRSS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTCRSS_RIDM	NUMBER	8	8
SRTCRSS_CRSS_CODE	VARCHAR2	8	0
SRTCRSS_TERM_CODE_ENTRY	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTCRSS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTCRSS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:56:06:000	04/02/2008 20:56:06:000

Index PK_SRTDEGR

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTDEGR
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTDEGR_RIDM	NUMBER	8	8
SRTDEGR_SBGI_CODE	VARCHAR2	6	0
SRTDEGR_DEGR_SEQ_NO	NUMBER	2	2

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTDEGR	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTDEGR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:14:000	04/02/2008 20:43:14:000

Index PK_SRTEMAL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTEMAL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTEMAL_RIDM	NUMBER	8	8
SRTEMAL_EMAL_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTEMAL	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTEMAL

Object Dates

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

Index PK_SRTGPAT

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTGPAT
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTGPAT_RIDM	NUMBER	8	8
SRTGPAT_GPAT_CODE	VARCHAR2	8	0
SRTGPAT_TERM_CODE_ENTRY	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTGPAT	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTGPAT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:03:59:000	04/02/2008 21:03:59:000

Index PK_SRTHSCH

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTHSCH
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTHSCH_RIDM	NUMBER	8	8
SRTHSCH_SBGI_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTHSCH	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTHSCH

Object Dates

Creation Date	Analysis Date
04/02/2008 20:56:09:000	04/02/2008 20:56:09:000

Index PK_SRTIDEN

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTIDEN
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTIDEN_RIDM	NUMBER	8	8

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTIDEN	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTIDEN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:36:48:000	04/02/2008 20:36:48:000

Index PK_SRTINTS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTINTS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTINTS_RIDM	NUMBER	8	8
SRTINTS_INTS_CODE	VARCHAR2	2	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTINTS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTINTS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:49:06:000	04/02/2008 20:49:06:000

Index PK_SRTLEND

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTLEND
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTLEND_RIDM	NUMBER	8	8
SRTLEND_LEND_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTLEND	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTLEND

Object Dates

Creation Date	Analysis Date
04/02/2008 20:46:43:000	04/02/2008 20:46:43:000

Index PK_SRTMAJR

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTMAJR
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTMAJR_RIDM	NUMBER	8	8
SRTMAJR_SBGI_CODE	VARCHAR2	6	0
SRTMAJR_DEGR_SEQ_NO	NUMBER	2	2

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTMAJR	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTMAJR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:06:000	04/02/2008 20:42:06:000

Index PK_SRTMATL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTMATL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTMATL_RIDM	NUMBER	8	8
SRTMATL_MATL_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTMATL	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTMATL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:27:000	04/02/2008 20:43:27:000

Index PK_SRTPCOL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTPCOL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTPCOL_RIDM	NUMBER	8	8
SRTPCOL_SBGI_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPCOL	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTPCOL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:56:55:000	04/02/2008 20:56:55:000

Index PK_SRTPERS

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTPERS
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTPERS_RIDM	NUMBER	8	8

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPERS	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTPERS

Object Dates

Creation Date	Analysis Date
04/02/2008 21:06:38:000	04/02/2008 21:06:38:000

Index PK_SRTPRAC

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTPRAC
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTPRAC_RIDM	NUMBER	8	8
SRTPRAC_RACE_CDE	VARCHAR2	3	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPRAC	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTPRAC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:54:56:000	04/02/2008 20:54:56:000

Index PK_SRTPREL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTPREL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTPREL_RIDM	NUMBER	8	8
SRTPREL_PREL_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPREL	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTPREL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:17:000	04/02/2008 20:55:17:000

Index PK_SRTSUPL

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTSUPL
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTSUPL_RIDM	NUMBER	8	8
SRTSUPL_TERM_CODE_ENTRY	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTSUPL	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTSUPL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:18:000	04/02/2008 20:42:18:000

Index PK_SRTTELE

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTTELE
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTTELE_RIDM	NUMBER	8	8
SRTTELE_TELE_CODE	VARCHAR2	4	0
SRTTELE_SEQNO	NUMBER	3	3

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTTELE	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTTELE

Object Dates

Creation Date	Analysis Date
04/02/2008 20:50:20:000	04/02/2008 20:50:20:000

Index PK_SRTTEST

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTTEST
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTTEST_RIDM	NUMBER	8	8
SRTTEST_TESC_CODE	VARCHAR2	4	0
SRTTEST_TEST_DATE	DATE	7	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTTEST	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTTEST

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:31:000	04/02/2008 20:51:31:000

Index PK_SRTTPFD

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTTPFD
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTTPFD_TAPE_CODE	VARCHAR2	10	0
SRTTPFD_REC_NUMBER	NUMBER	2	2
SRTTPFD_START_POS	NUMBER	5	5

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTTPFD	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTTPFD

Object Dates

Creation Date	Analysis Date
04/02/2008 21:05:39:000	04/02/2008 21:05:39:000

Index PK_SRTTSPC

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SRTTSPC
Owner Name
Index Type UNIQUE

Index Columns information

Column Name	Column Type	Column Length	Column precision
SRTTSPC_RIDM	NUMBER	8	8
SRTTSPC_TESC_CODE	VARCHAR2	4	0
SRTTSPC_TEST_DATE	DATE	7	0
SRTTSPC_TSPT_CODE	VARCHAR2	10	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTTSPC	SQL Table	S10B80.SATURN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SRTTSPC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:45:55:000	04/02/2008 20:45:55:000

Table SRBPRED

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRBPRED_PREL_CODE	VARCHAR2(10)	No	*
SRBPRED_LEVL_CODE	VARCHAR2(2)	No		*
SRBPRED_ACTIVITY_DATE	DATE	No
SRBPRED_TAPE_ID	VARCHAR2(6)	Yes
SRBPRED_TERM_CODE	VARCHAR2(6)	Yes		*
SRBPRED_RECR_CODE	VARCHAR2(3)	Yes		*
SRBPRED_RTYP_CODE	VARCHAR2(2)	Yes		*
SRBPRED_STYP_CODE	VARCHAR2(1)	Yes		*
SRBPRED_EGOL_CODE	VARCHAR2(2)	Yes		*
SRBPRED_VTYP_CODE	VARCHAR2(2)	Yes
SRBPRED_TSRC_CODE	VARCHAR2(4)	Yes		*
SRBPRED_SBGI_CODE	VARCHAR2(6)	Yes		*
SRBPRED_CTYP_CODE	VARCHAR2(3)	Yes		*
SRBPRED_TERM_CODE_CTLG	VARCHAR2(6)	Yes
SRBPRED_PROGRAM	VARCHAR2(12)	Yes		*
SRBPRED_DEGC_CODE	VARCHAR2(6)	Yes		*
SRBPRED_CAMP_CODE	VARCHAR2(3)	Yes		*
SRBPRED_COLL_CODE	VARCHAR2(2)	Yes		*
SRBPRED_MAJR_CODE	VARCHAR2(4)	Yes		*
SRBPRED_DEPT_CODE	VARCHAR2(4)	Yes		*
SRBPRED_RSTA_CODE	VARCHAR2(2)	Yes		*
SRBPRED_ADMT_CODE	VARCHAR2(2)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRBPRED_COLL_CODE	STVCOLL_CODE	STVCOLL
SRBPRED_MAJR_CODE	STVMAJR_CODE	STVMAJR
SRBPRED_ADMT_CODE	STVADMT_CODE	STVADMT
SRBPRED_RTYP_CODE	STVRTYP_CODE	STVRTYP
SRBPRED_STYP_CODE	STVSTYP_CODE	STVSTYP
SRBPRED_EGOL_CODE	STVEGOL_CODE	STVEGOL
SRBPRED_CTYP_CODE	STVCTYP_CODE	STVCTYP
SRBPRED_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRBPRED_DEPT_CODE	STVDEPT_CODE	STVDEPT
SRBPRED_TSRC_CODE	STVTSRC_CODE	STVTSRC
SRBPRED_CAMP_CODE	STVCAMP_CODE	STVCAMP
SRBPRED_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE
SRBPRED_LEVL_CODE	STVLEVL_CODE	STVLEVL
SRBPRED_TERM_CODE	STVTERM_CODE	STVTERM
SRBPRED_RECR_CODE	STVRECR_CODE	STVRECR
SRBPRED_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRBPRED_RSTA_CODE	STVRSTA_CODE	STVRSTA

Index

Index Name	Index Type	Column Name
PK_SRBPRED	Unique	SRBPRED_PREL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRBPRED_CUR	Oracle Package Cursor	S10B80.BANINST1.BWSKWPRV	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRBPRED	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_SRBPRED	SQL Index	S10B80.SATURN	Rely On
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
STVADMT	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVCTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVRSTA	SQL Table	S10B80.SATURN	Refer (no action)
STVRTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVTSRC	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRBPRED

Object Dates

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

Source Code Comments

Default values for Web for Prospect Web pages.

Columns Comments for SRBPRED_PREL_CODE (# 1)

Source Code Comments

Electronic Prospect Code for default values.

Columns Comments for SRBPRED_LEVL_CODE (# 2)

Source Code Comments

Level default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the date of creation or update.

Columns Comments for SRBPRED_TAPE_ID (# 4)

Source Code Comments

Tape ID for Electronic Prospect Tape Source.

Columns Comments for SRBPRED_TERM_CODE (# 5)

Source Code Comments

Term Code of Electronic Prospect Recruit Peroid.

Columns Comments for SRBPRED_RECR_CODE (# 6)

Source Code Comments

Recruit default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_RTYP_CODE (# 7)

Source Code Comments

Recruit type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_STYP_CODE (# 8)

Source Code Comments

Student type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_EGOL_CODE (# 9)

Source Code Comments

Education level default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_VTYP_CODE (# 10)

Source Code Comments

Visa Type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_TSRC_CODE (# 11)

Source Code Comments

Tape source default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_SBGI_CODE (# 12)

Source Code Comments

Recruit source default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_CTYP_CODE (# 13)

Source Code Comments

Contact type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_TERM_CODE_CTLG (# 14)

Source Code Comments

Catalog term default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_PROGRAM (# 15)

Source Code Comments

Degree default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_DEGC_CODE (# 16)

Source Code Comments

Degree default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_CAMP_CODE (# 17)

Source Code Comments

Campus default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_COLL_CODE (# 18)

Source Code Comments

College default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_MAJR_CODE (# 19)

Source Code Comments

Major default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_DEPT_CODE (# 20)

Source Code Comments

Department default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_RSTA_CODE (# 21)

Source Code Comments

Status of recruit

Columns Comments for SRBPRED_ADMT_CODE (# 22)

Source Code Comments

Type of application

Table SRBRECR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRBRECR_PIDM	NUMBER(8,0)	No	*	*
SRBRECR_TERM_CODE	VARCHAR2(6)	No	*	*
SRBRECR_ADMIN_SEQNO	NUMBER(2,0)	No	*	*
SRBRECR_DEPT_CODE	VARCHAR2(4)	Yes		*
SRBRECR_LEVL_CODE	VARCHAR2(2)	Yes		*
SRBRECR_DEGC_CODE	VARCHAR2(6)	Yes		*
SRBRECR_MAJR_CODE	VARCHAR2(4)	Yes		*
SRBRECR_RECR_CODE	VARCHAR2(3)	Yes		*
SRBRECR_RSTA_CODE	VARCHAR2(2)	Yes		*
SRBRECR_ACTIVITY_DATE	DATE	No
SRBRECR_SELECT_IND	VARCHAR2(1)	Yes
SRBRECR_ADD_DATE	DATE	No
SRBRECR_ADMT_CODE	VARCHAR2(2)	Yes
SRBRECR_CAMP_CODE	VARCHAR2(3)	Yes
SRBRECR_COLL_CODE	VARCHAR2(2)	Yes		*
SRBRECR_MAJR_CODE2	VARCHAR2(4)	Yes		*
SRBRECR_EDLV_CODE	VARCHAR2(3)	Yes		*
SRBRECR_EGOL_CODE	VARCHAR2(2)	Yes		*
SRBRECR_FULL_PART_IND	VARCHAR2(1)	Yes
SRBRECR_SBGI_CODE	VARCHAR2(6)	Yes		*
SRBRECR_WRSN_CODE	VARCHAR2(2)	Yes		*
SRBRECR_RTYP_CODE	VARCHAR2(2)	Yes		*
SRBRECR_RESD_CODE	VARCHAR2(1)	Yes		*
SRBRECR_SESS_CODE	VARCHAR2(1)	Yes		*
SRBRECR_SITE_CODE	VARCHAR2(3)	Yes		*
SRBRECR_STYP_CODE	VARCHAR2(1)	Yes		*
SRBRECR_PROGRAM_1	VARCHAR2(12)	Yes		*
SRBRECR_TERM_CODE_CTLG_1	VARCHAR2(6)	Yes		*
SRBRECR_DEPT_CODE_2	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_111	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_112	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_113	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_121	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_122	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_CONC_123	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
SRBRECR_MAJR_CODE_MINR_1_2	VARCHAR2(4)	Yes		*
SRBRECR_CURR_RULE_1	NUMBER(8,0)	Yes		*
SRBRECR_CMJR_RULE_1_1	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_11_1	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_11_2	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_11_3	NUMBER(8,0)	Yes		*
SRBRECR_CMJR_RULE_1_2	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_12_1	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_12_2	NUMBER(8,0)	Yes		*
SRBRECR_CCON_RULE_12_3	NUMBER(8,0)	Yes		*
SRBRECR_CMNR_RULE_1_1	NUMBER(8,0)	Yes		*
SRBRECR_CMNR_RULE_1_2	NUMBER(8,0)	Yes		*
SRBRECR_DATA_ORIGIN	VARCHAR2(30)	Yes
SRBRECR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRBRECR_WRSN_CODE	STVWRSN_CODE	STVWRSN
SRBRECR_MAJR_CODE_CONC_112	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_CONC_113	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_CONC_121	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_CONC_122	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_CONC_123	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_MINR_1	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_MINR_1_2	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE2	STVMAJR_CODE	STVMAJR
SRBRECR_MAJR_CODE_CONC_111	STVMAJR_CODE	STVMAJR
SRBRECR_CURR_RULE_1	SOBCURR_CURR_RULE	SOBCURR
SRBRECR_CCON_RULE_12_2	SORCCON_CCON_RULE	SORCCON
SRBRECR_CCON_RULE_12_3	SORCCON_CCON_RULE	SORCCON
SRBRECR_CCON_RULE_11_1	SORCCON_CCON_RULE	SORCCON
SRBRECR_CCON_RULE_11_2	SORCCON_CCON_RULE	SORCCON
SRBRECR_CCON_RULE_11_3	SORCCON_CCON_RULE	SORCCON
SRBRECR_CCON_RULE_12_1	SORCCON_CCON_RULE	SORCCON
SRBRECR_COLL_CODE	STVCOLL_CODE	STVCOLL
SRBRECR_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRBRECR_EGOL_CODE	STVEGOL_CODE	STVEGOL
SRBRECR_RESD_CODE	STVRESD_CODE	STVRESD
SRBRECR_RTYP_CODE	STVRTYP_CODE	STVRTYP
SRBRECR_SESS_CODE	STVSESS_CODE	STVSESS
SRBRECR_STYP_CODE	STVSTYP_CODE	STVSTYP
SRBRECR_DEPT_CODE_2	STVDEPT_CODE	STVDEPT
SRBRECR_DEPT_CODE	STVDEPT_CODE	STVDEPT
SRBRECR_EDLV_CODE	STVEDLV_CODE	STVEDLV
SRBRECR_CMJR_RULE_1_2	SORCMJR_CMJR_RULE	SORCMJR
SRBRECR_CMJR_RULE_1_1	SORCMJR_CMJR_RULE	SORCMJR
SRBRECR_PROGRAM_1	SMRPRLE_PROGRAM	SMRPRLE
SRBRECR_LEVL_CODE	STVLEVL_CODE	STVLEVL
SRBRECR_TERM_CODE_CTLG_1	STVTERM_CODE	STVTERM
SRBRECR_TERM_CODE	STVTERM_CODE	STVTERM
SRBRECR_SITE_CODE	STVSITE_CODE	STVSITE
SRBRECR_RECR_CODE	STVRECR_CODE	STVRECR
SRBRECR_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRBRECR_CMNR_RULE_1_2	SORCMNR_CMNR_RULE	SORCMNR
SRBRECR_CMNR_RULE_1_1	SORCMNR_CMNR_RULE	SORCMNR
SRBRECR_RSTA_CODE	STVRSTA_CODE	STVRSTA
SRBRECR_TERM_CODE	SORLCUR_TERM_CODE	SORLCUR
SRBRECR_ADMIN_SEQNO	SORLCUR_KEY_SEQNO	SORLCUR
SRBRECR_PIDM	SORLCUR_PIDM	SORLCUR
SRBRECR_PIDM	SORPCOL_PIDM	SORPCOL
SRBRECR_PIDM	SORHSCH_PIDM	SORHSCH

Index

Index Name	Index Type	Column Name
PK_SRBRECR	Unique	SRBRECR_PIDM
PK_SRBRECR	Unique	SRBRECR_TERM_CODE
PK_SRBRECR	Unique	SRBRECR_ADMIN_SEQNO
SRBRECR_KEY_INDEX2		SRBRECR_RECR_CODE
SRBRECR_KEY_INDEX2		SRBRECR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVSDAX	SQL Table	S10B80.GENERAL	Join
SARADAP	SQL Table	S10B80.SATURN	Join
SFBETRM	SQL Table	S10B80.SATURN	Join
SORCONT	SQL Table	S10B80.SATURN	Join
SORINTS	SQL Table	S10B80.SATURN	Join
SORMADM	SQL Table	S10B80.SATURN	Join
SORMRTY	SQL Table	S10B80.SATURN	Join
SORMSTY	SQL Table	S10B80.SATURN	Join
SPBPERS	SQL Table	S10B80.SATURN	Join
SPRADDR	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
SRRCHRT	SQL Table	S10B80.SATURN	Refer (no action)
SRRLEND	SQL Table	S10B80.SATURN	Refer (no action)
SRRRSRC	SQL Table	S10B80.SATURN	Refer (no action)
ST_SRBRECR_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
SOVRREC	SQL View	S10B80.BANINST1	Use (select)
SPVSTRG	SQL View	S10B80.BANINST1	Use (select)
SRVACUR	SQL View	S10B80.BANINST1	Use (select)
SRVADRS	SQL View	S10B80.BANINST1	Use (select)
SRVCCUR	SQL View	S10B80.BANINST1	Use (select)
SRVCONT	SQL View	S10B80.BANINST1	Use (select)
SRVCONT_OJ	SQL View	S10B80.BANINST1	Use (select)
SRVINTS	SQL View	S10B80.BANINST1	Use (select)
SRVLIF1	SQL View	S10B80.BANINST1	Use (select)
SRVPCO1	SQL View	S10B80.BANINST1	Use (select)
SRVRCR1	SQL View	S10B80.BANINST1	Use (select)
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
SRVRSR1	SQL View	S10B80.BANINST1	Use (select)
SRVSEC1	SQL View	S10B80.BANINST1	Use (select)
SRVSRCE	SQL View	S10B80.BANINST1	Use (select)
SRVSTRG	SQL View	S10B80.BANINST1	Use (select)
F_INQUIRER_FNC	SQL Function	S10B80.BANINST1	Rely On
F_INQUIRER_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_RECRUIT_IND	SQL Function	S10B80.BANINST1	Use (select)
RECRUIT_REC	Oracle Package Type	S10B80.BANINST1.SB_RECRUIT	Rely On
SRBRECR_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
SRBRECR_DISP_ALL_C	Oracle Package Cursor	S10B80.BANINST1.BWCKCAPP	Use (select)
P_BUILDSOTWADA	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Rely On
P_PRINT_RECRUIT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Rely On
P_PRINT_RECRUIT	Oracle Package Procedure	S10B80.BANINST1.TS_SB_CURRICULUM	Use (select)Rely On
F_BUILD_SRBRECR_REC	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Rely On
F_MATCH_SRBRECR	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
F_VERIFY_STUDENT	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_CONVERT_CURR	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Use (select)Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Rely On
P_CREATE_RECRUIT	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Rely On
P_CREATE_RECRUIT_ROWS	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (select)Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRBRECR	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRBRECR	Use (Insert)Rely On
P_INSERT_COMMPLAN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_RECRUIT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_RECRUIT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Rely On
P_INSERT_SMRRQCM	Oracle Package Procedure	S10B80.BANINST1.BWCKCMPL	Use (select)
P_INSERT_SRRLEND	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_PUSH_RECRUIT_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Rely On
P_PUSH_RECRUIT_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.SOKLCUR	Use (select)
P_QUICK_ADMIT	Oracle Package Procedure	S10B80.BANINST1.SAKQADM	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRBRECR	Use (update)Rely On
P_UPDATE_CURRICULUM	Oracle Package Procedure	S10B80.BANINST1.DML_SRBRECR	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
F_CONVERT_RECRUIT	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Rely On
F_CONVERT_RECRUIT	Oracle Package Function	S10B80.BANINST1.SOKLCUR	Use (select)
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_FIND_IF_STUDENT	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_FIND_IF_STUDENT_FINAID	Oracle Package Function	S10B80.BANINST1.SOKFGAC	Use (select)
F_GETSRBRECRSEQNO	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_GET_SRRLEND_LEND_CODE	Oracle Package Function	S10B80.BANINST1.SRKSELS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT	Use (select)
F_RECRUIT_IND	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
F_SELECT_IND_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_RECRUIT_RULES	Use (select)
F_TEST_SRBRECR_EXIST	Oracle Package Function	S10B80.BANINST1.BWCKCAPP	Rely On
SRBRECR	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_SRBRECR	SQL Index	S10B80.SATURN	Rely On
SRBRECR_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
SOBCURR	SQL Table	S10B80.SATURN	Refer (no action)
SORCCON	SQL Table	S10B80.SATURN	Refer (no action)
SORCMJR	SQL Table	S10B80.SATURN	Refer (no action)
SORCMNR	SQL Table	S10B80.SATURN	Refer (no action)
SORHSCH	SQL Table	S10B80.SATURN	Join
SORLCUR	SQL Table	S10B80.SATURN	Join
SORPCOL	SQL Table	S10B80.SATURN	Join
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVEDLV	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVRESD	SQL Table	S10B80.SATURN	Refer (no action)
STVRSTA	SQL Table	S10B80.SATURN	Refer (no action)
STVRTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSESS	SQL Table	S10B80.SATURN	Refer (no action)
STVSITE	SQL Table	S10B80.SATURN	Refer (no action)
STVSTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWRSN	SQL Table	S10B80.SATURN	Refer (no action)
ST_SRBRECR_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SRBRECR_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.SRBRECR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:53:34:000	04/02/2008 21:18:15:000

Source Code Comments

Recruiting Base Table

Columns Comments for SRBRECR_PIDM (# 1)

Source Code Comments

Internal identification number.

Columns Comments for SRBRECR_TERM_CODE (# 2)

Source Code Comments

This field defines the effective term the recruiting records will be viewed or created.

Columns Comments for SRBRECR_ADMIN_SEQNO (# 3)

Source Code Comments

This field does not display on the form. It assigns an internal sequence number to each term record.

Columns Comments for SRBRECR_DEPT_CODE (# 4)

Source Code Comments

This field defines the department associated with the prospect recruiting record.

Columns Comments for SRBRECR_LEVL_CODE (# 5)

Source Code Comments

This field defines the level code associated with the prospect recruiting record.

Columns Comments for SRBRECR_DEGC_CODE (# 6)

Source Code Comments

This field defines the degree code associated with the prospect recruiting record.

Columns Comments for SRBRECR_MAJR_CODE (# 7)

Source Code Comments

This field defines the major code associated with the prospect recruiting record.

Columns Comments for SRBRECR_RECR_CODE (# 8)

Source Code Comments

This field defines the recruiter assigned to the prospect recruiting record.

Columns Comments for SRBRECR_RSTA_CODE (# 9)

Source Code Comments

This field defines the status of the prospect associated with the recruiting record.

Columns Comments for SRBRECR_ACTIVITY_DATE (# 10)

Source Code Comments

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

Columns Comments for SRBRECR_SELECT_IND (# 11)

Source Code Comments

Selected indicator to specify which record is current or most recent recruiting record. Informational only Values are Y or null. Only 1 record per term may be selected.

Columns Comments for SRBRECR_ADD_DATE (# 12)

Source Code Comments

Date record added.

Columns Comments for SRBRECR_ADMT_CODE (# 13)

Source Code Comments

Admission Type code.

Columns Comments for SRBRECR_CAMP_CODE (# 14)

Source Code Comments

Campus code.

Columns Comments for SRBRECR_COLL_CODE (# 15)

Source Code Comments

College code.

Columns Comments for SRBRECR_MAJR_CODE2 (# 16)

Source Code Comments

Area of Concentration code.

Columns Comments for SRBRECR_EDLV_CODE (# 17)

Source Code Comments

Education Level code.

Columns Comments for SRBRECR_EGOL_CODE (# 18)

Source Code Comments

Education Goal code.

Columns Comments for SRBRECR_FULL_PART_IND (# 19)

Source Code Comments

Fulltime-Parttime Indicator. If not null, values are F or P.

Columns Comments for SRBRECR_SBGI_CODE (# 20)

Source Code Comments

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

Columns Comments for SRBRECR_WRSN_CODE (# 21)

Source Code Comments

Withdrawal Reason code. Used when student decides not to attend home institution.

Columns Comments for SRBRECR_RTYP_CODE (# 22)

Source Code Comments

Recruit Type code.

Columns Comments for SRBRECR_RESD_CODE (# 23)

Source Code Comments

Residency code.

Columns Comments for SRBRECR_SESS_CODE (# 24)

Source Code Comments

Session code.

Columns Comments for SRBRECR_SITE_CODE (# 25)

Source Code Comments

Site code.

Columns Comments for SRBRECR_STYP_CODE (# 26)

Source Code Comments

Student Type code.

Columns Comments for SRBRECR_PROGRAM_1 (# 27)

Source Code Comments

Curriculum 1 Program Code

Columns Comments for SRBRECR_TERM_CODE_CTLG_1 (# 28)

Source Code Comments

Curriculum 1 Catalog Term Code

Columns Comments for SRBRECR_DEPT_CODE_2 (# 29)

Source Code Comments

Department Code 2 on Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_111 (# 30)

Source Code Comments

Concentration Code 1 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_112 (# 31)

Source Code Comments

Concentration Code 2 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_113 (# 32)

Source Code Comments

Concentration Code 3 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_121 (# 33)

Source Code Comments

Concentration Code 1 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_122 (# 34)

Source Code Comments

Concentration Code 2 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_123 (# 35)

Source Code Comments

Concentration Code 3 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_MINR_1 (# 36)

Source Code Comments

Minor 1 on Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_MINR_1_2 (# 37)

Source Code Comments

Minor 2 on Curriculum 1

Columns Comments for SRBRECR_CURR_RULE_1 (# 38)

Source Code Comments

Curriculum 1 Rule reference

Columns Comments for SRBRECR_CMJR_RULE_1_1 (# 39)

Source Code Comments

Curriculum 1 Major 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_1 (# 40)

Source Code Comments

Concentration 1, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_2 (# 41)

Source Code Comments

Concentration 2, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_3 (# 42)

Source Code Comments

Concentration 3, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMJR_RULE_1_2 (# 43)

Source Code Comments

Major 2, Curriculum Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_1 (# 44)

Source Code Comments

Concentration 1, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_2 (# 45)

Source Code Comments

Concentration 2, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_3 (# 46)

Source Code Comments

Concentration 3, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMNR_RULE_1_1 (# 47)

Source Code Comments

Minor 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMNR_RULE_1_2 (# 48)

Source Code Comments

Minor 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_DATA_ORIGIN (# 49)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SRBRECR_USER_ID (# 50)

Source Code Comments

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

Table SRBWPDS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRBWPDS_PREL_CODE	VARCHAR2(10)	No	*	*
SRBWPDS_VAL_TABLE	VARCHAR2(30)	No	*
SRBWPDS_VAL_CODE	VARCHAR2(12)	No	*
SRBWPDS_VAL_DESC	VARCHAR2(30)	No
SRBWPDS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRBWPDS_PREL_CODE	STVPREL_CODE	STVPREL

Index

Index Name	Index Type	Column Name
PK_SRBWPDS	Unique	SRBWPDS_PREL_CODE
PK_SRBWPDS	Unique	SRBWPDS_VAL_TABLE
PK_SRBWPDS	Unique	SRBWPDS_VAL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_GENOPTIONSLISTTAB	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
SRBWPDS	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_SRBWPDS	SQL Index	S10B80.SATURN	Rely On
STVPREL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRBWPDS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:34:06:000	04/02/2008 21:17:58:000

Source Code Comments

Web Prospect Validation Code Display Section Rules Form. This form determines which validation values from the validation tables will be displayed on specific Prospect Web pages.

Columns Comments for SRBWPDS_PREL_CODE (# 1)

Source Code Comments

Electronic Prospect Code for display selection.

Columns Comments for SRBWPDS_VAL_TABLE (# 2)

Source Code Comments

Validation Table Suffix of the item to be displayed.

Columns Comments for SRBWPDS_VAL_CODE (# 3)

Source Code Comments

Validation Table code to be displayed on the Prospect Web page.

Columns Comments for SRBWPDS_VAL_DESC (# 4)

Source Code Comments

Validation Table code description to be displayed on the Prospect Web page.

Table SRBWPRO

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_GENERATEFORM	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
P_CHOOSEPROSPECTTYPE	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
SRBWPRO	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SRBWPRO	SQL Index	S10B80.SATURN	Rely On
SRBWPRO_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVPREL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRBWPRO

Object Dates

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

Source Code Comments

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

Columns Comments for SRBWPRO_PREL_CODE (# 1)

Source Code Comments

Electronic Prospect Code for display selection.

Columns Comments for SRBWPRO_WPIC_CODE (# 2)

Source Code Comments

WEB Prospect Selection Code.

Columns Comments for SRBWPRO_DISPLAY_ORDER (# 3)

Source Code Comments

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

Columns Comments for SRBWPRO_ATYP_CODE (# 5)

Source Code Comments

The address type for the Web Prospect page.

Columns Comments for SRBWPRO_RESPONSE_REQ_IND (# 7)

Source Code Comments

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

Table SRRCHRT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRCHRT_PIDM	NUMBER(8,0)	No	*	*
SRRCHRT_TERM_CODE	VARCHAR2(6)	No	*	*
SRRCHRT_ADMIN_SEQNO	NUMBER(2,0)	No	*	*
SRRCHRT_CHRT_CODE	VARCHAR2(10)	No	*	*
SRRCHRT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRCHRT_PIDM	SRBRECR_PIDM	SRBRECR
SRRCHRT_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR
SRRCHRT_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR
SRRCHRT_CHRT_CODE	STVCHRT_CODE	STVCHRT
SRRCHRT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SRRCHRT	Unique	SRRCHRT_PIDM
PK_SRRCHRT	Unique	SRRCHRT_TERM_CODE
PK_SRRCHRT	Unique	SRRCHRT_ADMIN_SEQNO
PK_SRRCHRT	Unique	SRRCHRT_CHRT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_RECR_COHORT_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_MATCH_SRRCHRT	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
SRRCHRT	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_SRRCHRT	SQL Index	S10B80.SATURN	Rely On
SRBRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVCHRT	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRCHRT

Object Dates

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

Source Code Comments

Cohort Recruiting Table

Columns Comments for SRRCHRT_PIDM (# 1)

Source Code Comments

Internal Person Identification Number

Columns Comments for SRRCHRT_TERM_CODE (# 2)

Source Code Comments

Term code

Columns Comments for SRRCHRT_ADMIN_SEQNO (# 3)

Source Code Comments

Sequence Number

Columns Comments for SRRCHRT_CHRT_CODE (# 4)

Source Code Comments

Cohort Code

Columns Comments for SRRCHRT_ACTIVITY_DATE (# 5)

Source Code Comments

The Activity Date

Table SRRLEND

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRLEND_PIDM	NUMBER(8,0)	No	*	*
SRRLEND_TERM_CODE	VARCHAR2(6)	No	*	*
SRRLEND_ADMIN_SEQNO	NUMBER(2,0)	No	*	*
SRRLEND_LEND_CODE	VARCHAR2(10)	No	*	*
SRRLEND_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRLEND_PIDM	SRBRECR_PIDM	SRBRECR
SRRLEND_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR
SRRLEND_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR
SRRLEND_LEND_CODE	STVLEND_CODE	STVLEND
SRRLEND_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SRRLEND	Unique	SRRLEND_PIDM
PK_SRRLEND	Unique	SRRLEND_TERM_CODE
PK_SRRLEND	Unique	SRRLEND_ADMIN_SEQNO
PK_SRRLEND	Unique	SRRLEND_LEND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_SRRLEND_LEND_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_SRRLEND_ROWID	SQL Function	S10B80.BANINST1	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (delete)
P_INSERT_SRRLEND	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
F_GET_SRRLEND_LEND_CODE	Oracle Package Function	S10B80.BANINST1.SRKSELS	Rely On
F_GET_SRRLEND_LEND_CODE	Oracle Package Function	S10B80.BANINST1.SRKSELS	Use (select)
F_SRRLEND_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Rely On
F_SRRLEND_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS	Use (select)
F_SRRLEND_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Rely On
F_SRRLEND_VALUE	Oracle Package Function	S10B80.BANINST1.SOKLIBS_OJ	Use (select)
SRRLEND	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_SRRLEND	SQL Index	S10B80.SATURN	Rely On
SRBRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVLEND	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRLEND

Object Dates

Creation Date	Analysis Date
04/02/2008 21:02:27:000	04/02/2008 21:18:22:000

Source Code Comments

Table used to store how I learned of the institution code of Recruit.

Columns Comments for SRRLEND_PIDM (# 1)

Source Code Comments

Unique ID of Recruit.

Columns Comments for SRRLEND_TERM_CODE (# 2)

Source Code Comments

Term code of Recruit.

Columns Comments for SRRLEND_ADMIN_SEQNO (# 3)

Source Code Comments

Seqno of Recruit Record for the Term.

Columns Comments for SRRLEND_LEND_CODE (# 4)

Source Code Comments

Legend code of Recruit.

Columns Comments for SRRLEND_ACTIVITY_DATE (# 5)

Source Code Comments

This field identifies the most recent date of creation or update.

Table SRRRATT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRRATT_PIDM	NUMBER(8,0)	No	*
SRRRATT_TERM_CODE	VARCHAR2(6)	No	*	*
SRRRATT_ADMIN_SEQNO	NUMBER(2,0)	No	*
SRRRATT_ATTS_CODE	VARCHAR2(4)	No	*	*
SRRRATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRRATT_ATTS_CODE	STVATTS_CODE	STVATTS
SRRRATT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SRRRATT	Unique	SRRRATT_PIDM
PK_SRRRATT	Unique	SRRRATT_TERM_CODE
PK_SRRRATT	Unique	SRRRATT_ADMIN_SEQNO
PK_SRRRATT	Unique	SRRRATT_ATTS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SORMATT	SQL Table	S10B80.SATURN	Join
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
F_MATCH_SRRRATT	Oracle Package Function	S10B80.BANINST1.SOKAINF	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
SRRRATT	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_SRRRATT	SQL Index	S10B80.SATURN	Rely On
STVATTS	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRRATT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:55:37:000	04/02/2008 21:18:17:000

Source Code Comments

Recruiting Attribute Repeating Table.

Columns Comments for SRRRATT_PIDM (# 1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SRRRATT_TERM_CODE (# 2)

Source Code Comments

The term associated with the attributes.

Columns Comments for SRRRATT_ADMIN_SEQNO (# 3)

Source Code Comments

The administrative sequence number of the prospect record associated with the attribute.

Columns Comments for SRRRATT_ATTS_CODE (# 4)

Source Code Comments

The recruiting attributes for the person and term.

Columns Comments for SRRRATT_ACTIVITY_DATE (# 5)

Source Code Comments

The date the record was last updated.

Table SRRRCMT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SRRRCMT_PIDM	NUMBER(8,0)	No
SRRRCMT_TERM_CODE	VARCHAR2(6)	No	*
SRRRCMT_SEQNO	NUMBER(3,0)	No
SRRRCMT_COMMENT_TEXT	VARCHAR2(4000)	Yes
SRRRCMT_ORIG_CODE	VARCHAR2(4)	No	*
SRRRCMT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRRCMT_ORIG_CODE	STVORIG_CODE	STVORIG
SRRRCMT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SRRRCMT_KEY_INDEX		SRRRCMT_PIDM
SRRRCMT_KEY_INDEX		SRRRCMT_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (delete)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
SRRRCMT	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
SRRRCMT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVORIG	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRRCMT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:04:23:000	04/02/2008 21:18:23:000

Source Code Comments

Recruiting Comment Table

Columns Comments for SRRRCMT_PIDM (# 1)

Source Code Comments

Internal identification number of prospect.

Columns Comments for SRRRCMT_TERM_CODE (# 2)

Source Code Comments

This field identifies the term associated with prospect record.

Columns Comments for SRRRCMT_SEQNO (# 3)

Source Code Comments

This field does not display on the form. It identifies an internal sequence number assigned to each comment created.

Columns Comments for SRRRCMT_COMMENT_TEXT (# 4)

Source Code Comments

This field specifies the recruiting comment(s) associated with prospect record.

Columns Comments for SRRRCMT_ORIG_CODE (# 5)

Source Code Comments

This field identifies the originator of the comment associated with prospect.

Columns Comments for SRRRCMT_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table SRRRSRC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRRSRC_ADMIN_SEQNO	NUMBER(2,0)	No	*	*
SRRRSRC_PIDM	NUMBER(8,0)	No	*	*
SRRRSRC_TERM_CODE	VARCHAR2(6)	No	*	*
SRRRSRC_SBGI_CODE	VARCHAR2(6)	No	*	*
SRRRSRC_PRIMARY_SRCE_IND	VARCHAR2(1)	Yes
SRRRSRC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRRSRC_PIDM	SRBRECR_PIDM	SRBRECR
SRRRSRC_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR
SRRRSRC_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR
SRRRSRC_TERM_CODE	STVTERM_CODE	STVTERM
SRRRSRC_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SRRRSRC	Unique	SRRRSRC_PIDM
PK_SRRRSRC	Unique	SRRRSRC_TERM_CODE
PK_SRRRSRC	Unique	SRRRSRC_ADMIN_SEQNO
PK_SRRRSRC	Unique	SRRRSRC_SBGI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SORMSRC	SQL Table	S10B80.SATURN	Join
SRVRECR	SQL View	S10B80.BANINST1	Use (select)
SRVRSR1	SQL View	S10B80.BANINST1	Use (select)
SRVSRCE	SQL View	S10B80.BANINST1	Use (select)
F_RECRUIT_SOURCE	SQL Function	S10B80.BANINST1	Use (select)
F_RECR_SOURCE_FNC	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
P_CREATE_RECRUIT	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_RECRUIT	Use (delete)
P_INSERT_RECRUIT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (Insert,select)
P_INSERT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SAKMODS	Use (Insert)
P_INSERT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_RECRUIT	Use (Insert)
SRRRSRC	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_SRRRSRC	SQL Index	S10B80.SATURN	Rely On
SRBRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRRSRC

Object Dates

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

Source Code Comments

Source of Recruit Repeating Table

Columns Comments for SRRRSRC_ADMIN_SEQNO (# 1)

Source Code Comments

This field does not display on form. It assigns an internal sequence number to each source background record.

Columns Comments for SRRRSRC_PIDM (# 2)

Source Code Comments

Internal identification number associated with prospect.

Columns Comments for SRRRSRC_TERM_CODE (# 3)

Source Code Comments

This field identifies the term associated with the recruiting record.

Columns Comments for SRRRSRC_SBGI_CODE (# 4)

Source Code Comments

This field identifies the source background associated with the prospect.

Columns Comments for SRRRSRC_PRIMARY_SRCE_IND (# 5)

Source Code Comments

This field specifies if the source type is the primary source of the prospect.

Columns Comments for SRRRSRC_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table SRRTPTS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRTPTS_TESC_CODE	VARCHAR2(4)	No	*	*
SRRTPTS_TESC_CODE_DATE_ORIGIN	VARCHAR2(4)	No
SRRTPTS_ACTIVITY_DATE	DATE	No
SRRTPTS_USER_ID	VARCHAR2(30)	No
SRRTPTS_SYS_REQ_IND	VARCHAR2(1)	No
SRRTPTS_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRTPTS_TESC_CODE	STVTESC_CODE	STVTESC

Index

Index Name	Index Type	Column Name
PK_SRRTPTS	Unique	SRRTPTS_TESC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
DATAFILE_TEST_SCORE_REC	Oracle Package Type	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_BUILD_SRRTPTS_REC	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRRTPTS	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRRTPTS	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRRTPTS	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
F_SYS_REQ	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Rely On
F_SYS_REQ	Oracle Package Function	S10B80.BANINST1.SB_DATAFILE_TEST_SCORE	Use (select)
SRRTPTS	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_SRRTPTS	SQL Index	S10B80.SATURN	Rely On
STVTESC	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRTPTS

Object Dates

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

Source Code Comments

Tape file test score control table.

Columns Comments for SRRTPTS_TESC_CODE (# 1)

Source Code Comments

TESC CODE: Test Code for which the date origin will established.

Columns Comments for SRRTPTS_TESC_CODE_DATE_ORIGIN (# 2)

Source Code Comments

TESC CODE DATE ORIGIN: The test date origin for the data file.

Columns Comments for SRRTPTS_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRRTPTS table.

Columns Comments for SRRTPTS_USER_ID (# 4)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user.

Columns Comments for SRRTPTS_SYS_REQ_IND (# 5)

Source Code Comments

SYTEM REQUIRED INDICATOR: This field indicates that a record is delivered by SunGard SCT and is required by the system.

Columns Comments for SRRTPTS_DATA_ORIGIN (# 6)

Source Code Comments

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

Table SRRVIST

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRVIST_TERM_CODE	VARCHAR2(6)	No		*
SRRVIST_RECR_CODE	VARCHAR2(3)	No	*	*
SRRVIST_SBGI_CODE	VARCHAR2(6)	No	*	*
SRRVIST_CTYP_CODE	VARCHAR2(3)	No		*
SRRVIST_CONTACT_DATE	DATE	No	*
SRRVIST_CONTACT_TO_TIME	NUMBER(4,0)	No	*
SRRVIST_CONTACT_FROM_TIME	NUMBER(4,0)	No	*
SRRVIST_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRVIST_CTYP_CODE	STVCTYP_CODE	STVCTYP
SRRVIST_TERM_CODE	STVTERM_CODE	STVTERM
SRRVIST_RECR_CODE	STVRECR_CODE	STVRECR
SRRVIST_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SRRVIST	Unique	SRRVIST_SBGI_CODE
PK_SRRVIST	Unique	SRRVIST_RECR_CODE
PK_SRRVIST	Unique	SRRVIST_CONTACT_DATE
PK_SRRVIST	Unique	SRRVIST_CONTACT_FROM_TIME
PK_SRRVIST	Unique	SRRVIST_CONTACT_TO_TIME
SRRVIST_KEY_INDEX2		SRRVIST_TERM_CODE
SRRVIST_KEY_INDEX2		SRRVIST_SBGI_CODE
SRRVIST_KEY_INDEX3		SRRVIST_TERM_CODE
SRRVIST_KEY_INDEX3		SRRVIST_RECR_CODE
SRRVIST_KEY_INDEX3		SRRVIST_CONTACT_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SRRVIST	SQL Index	S10B80.SATURN	Rely On
SRRVIST_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SRRVIST_KEY_INDEX3	SQL Index	S10B80.SATURN	Rely On
STVCTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRVIST

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:32:000	04/02/2008 21:18:06:000

Source Code Comments

Recuiters Visit to Source Repeating Table

Columns Comments for SRRVIST_TERM_CODE (# 1)

Source Code Comments

This field identifies the term for which appointments/visits are to be displayed.

Columns Comments for SRRVIST_RECR_CODE (# 2)

Source Code Comments

This field identifies the recruiter whose appointments/visits are to be displayed.

Columns Comments for SRRVIST_SBGI_CODE (# 3)

Source Code Comments

This field identifies the source of the contact type associated with appointment scheduled for prospect.

Columns Comments for SRRVIST_CTYP_CODE (# 4)

Source Code Comments

This field identifies the type of appointment scheduled for the prospect.

Columns Comments for SRRVIST_CONTACT_DATE (# 5)

Source Code Comments

This field identifies the date of the appointment sheduled with prospect.

Columns Comments for SRRVIST_CONTACT_TO_TIME (# 6)

Source Code Comments

This field identifies the begin time of appointment scheduled with prospect.

Columns Comments for SRRVIST_CONTACT_FROM_TIME (# 7)

Source Code Comments

This field identifies the end time of appointment scheduled with prospect.

Columns Comments for SRRVIST_ACTIVITY_DATE (# 8)

Source Code Comments

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

Table SRRWACK

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRRWACK_PREL_CODE	VARCHAR2(10)	No	*	*
SRRWACK_SEQ_NO	NUMBER(3,0)	No	*
SRRWACK_FORMAT_VAR	VARCHAR2(5)	Yes
SRRWACK_WACK_CODE	VARCHAR2(25)	Yes		*
SRRWACK_TEXT_VAR	VARCHAR2(250)	Yes
SRRWACK_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRRWACK_WACK_CODE	STVWACK_CODE	STVWACK
SRRWACK_PREL_CODE	STVPREL_CODE	STVPREL

Index

Index Name	Index Type	Column Name
PK_SRRWACK	Unique	SRRWACK_PREL_CODE
PK_SRRWACK	Unique	SRRWACK_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_PRINTACKNOWLEDGEMENT	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Use (select)
SRRWACK	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_SRRWACK	SQL Index	S10B80.SATURN	Rely On
STVPREL	SQL Table	S10B80.SATURN	Refer (no action)
STVWACK	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRRWACK

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:27:000	04/02/2008 21:18:13:000

Source Code Comments

Web Prospect Acknowledgment Letter Ruels.

Columns Comments for SRRWACK_PREL_CODE (# 1)

Source Code Comments

Electronic Prospect Code

Columns Comments for SRRWACK_SEQ_NO (# 2)

Source Code Comments

Sequence number of acknowlegment text or wack code in the letter.

Columns Comments for SRRWACK_FORMAT_VAR (# 3)

Source Code Comments

Paragraph and page formating to be done before wack code or text.

Columns Comments for SRRWACK_WACK_CODE (# 4)

Source Code Comments

Acknowlegement code item to be inserted in letter.

Columns Comments for SRRWACK_TEXT_VAR (# 5)

Source Code Comments

Text to be inserted into acknowlegment letter

Columns Comments for SRRWACK_ACTIVITY_DATE (# 6)

Source Code Comments

Date acknowlegment letter item was updated/inserted.

Table SRTADDR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTADDR_RIDM	NUMBER(8,0)	No	*	*
SRTADDR_ATYP_CODE	VARCHAR2(2)	No	*	*
SRTADDR_SEQNO	NUMBER(2,0)	No	*
SRTADDR_CITY	VARCHAR2(50)	No
SRTADDR_ACTIVITY_DATE	DATE	No
SRTADDR_FROM_DATE	DATE	Yes
SRTADDR_TO_DATE	DATE	Yes
SRTADDR_STREET_LINE1	VARCHAR2(75)	Yes
SRTADDR_STREET_LINE2	VARCHAR2(75)	Yes
SRTADDR_STREET_LINE3	VARCHAR2(75)	Yes
SRTADDR_STAT_CODE	VARCHAR2(3)	Yes		*
SRTADDR_ZIP	VARCHAR2(30)	Yes
SRTADDR_CNTY_CODE	VARCHAR2(5)	Yes		*
SRTADDR_NATN_CODE	VARCHAR2(5)	Yes		*
SRTADDR_STATUS_IND	VARCHAR2(1)	Yes
SRTADDR_ASRC_CODE	VARCHAR2(4)	Yes		*
SRTADDR_HOUSE_NUMBER	VARCHAR2(10)	Yes
SRTADDR_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTADDR_ASRC_CODE	STVASRC_CODE	STVASRC
SRTADDR_ATYP_CODE	STVATYP_CODE	STVATYP
SRTADDR_STAT_CODE	STVSTAT_CODE	STVSTAT
SRTADDR_CNTY_CODE	STVCNTY_CODE	STVCNTY
SRTADDR_NATN_CODE	STVNATN_CODE	STVNATN
SRTADDR_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTADDR	Unique	SRTADDR_RIDM
PK_SRTADDR	Unique	SRTADDR_ATYP_CODE
PK_SRTADDR	Unique	SRTADDR_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_ADDR_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
ADDR1_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_CNTY_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_NATN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_STR1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_STR2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_STR3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR1_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_CNTY_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_NATN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_STR1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_STR2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_STR3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ADDR2_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
SRTADDR_PREV_APPC	Oracle Package Cursor	S10B80.BANINST1.BWSKAADR	Use (select)
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAADR	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
F_BUILD_SRTADDR_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTADDR	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTADDR	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTADDR	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_ADDR_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_ADDR	Use (select)
SRTADDR	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_SRTADDR	SQL Index	S10B80.SATURN	Rely On
SRTPREL	SQL Table	S10B80.SATURN	Join
STVASRC	SQL Table	S10B80.SATURN	Refer (no action)
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVCNTY	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTADDR

Object Dates

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

Source Code Comments

Electronic Prospect address loaded from search and test score tapes, or entered on Web for Prospects.

Columns Comments for SRTADDR_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTADDR_ATYP_CODE (# 2)

Source Code Comments

This field identifies the type of address associated with person.

Columns Comments for SRTADDR_SEQNO (# 3)

Source Code Comments

This field assigns an internal sequence number to each address type associated with person. This field does not display on screen.

Columns Comments for SRTADDR_CITY (# 4)

Source Code Comments

This field maintains the city associated with the address of person.

Columns Comments for SRTADDR_ACTIVITY_DATE (# 5)

Source Code Comments

This field identifies the last date the SRTADDR record was updated.

Columns Comments for SRTADDR_FROM_DATE (# 6)

Source Code Comments

This field maintains the effective start date of address associated with person.

Columns Comments for SRTADDR_TO_DATE (# 7)

Source Code Comments

This field maintains the effective end date of address associated with person.

Columns Comments for SRTADDR_STREET_LINE1 (# 8)

Source Code Comments

This field maintains the first line of the address associated with person.

Columns Comments for SRTADDR_STREET_LINE2 (# 9)

Source Code Comments

This field maintains the second line of the address associated with person.

Columns Comments for SRTADDR_STREET_LINE3 (# 10)

Source Code Comments

This field maintains the third line of the address associated with person.

Columns Comments for SRTADDR_STAT_CODE (# 11)

Source Code Comments

This field maintains the state associated with the address of person.

Columns Comments for SRTADDR_ZIP (# 12)

Source Code Comments

This field maintains the zip code associated with the address of person.

Columns Comments for SRTADDR_CNTY_CODE (# 13)

Source Code Comments

This field maintains the county associated with the address of person.

Columns Comments for SRTADDR_NATN_CODE (# 14)

Source Code Comments

This field maintains the nation/country associated with the address of person.

Columns Comments for SRTADDR_STATUS_IND (# 15)

Source Code Comments

This field identifies if addres s information is inactive. Valid value is I - Inactive.

Columns Comments for SRTADDR_ASRC_CODE (# 16)

Source Code Comments

ADDRESS SOURCE CODE: Address Source code for which the address is being reported.

Columns Comments for SRTADDR_HOUSE_NUMBER (# 17)

Source Code Comments

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

Columns Comments for SRTADDR_STREET_LINE4 (# 18)

Source Code Comments

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

Table SRTCRSS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTCRSS_RIDM	NUMBER(8,0)	No	*
SRTCRSS_CRSS_CODE	VARCHAR2(8)	No	*	*
SRTCRSS_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SRTCRSS_HOURS	NUMBER(11,3)	No
SRTCRSS_ACTIVITY_DATE	DATE	No
SRTCRSS_SBGI_CODE	VARCHAR2(6)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTCRSS_TERM_CODE_ENTRY	STVTERM_CODE	STVTERM
SRTCRSS_CRSS_CODE	STVCRSS_CODE	STVCRSS
SRTCRSS_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SRTCRSS	Unique	SRTCRSS_RIDM
PK_SRTCRSS	Unique	SRTCRSS_CRSS_CODE
PK_SRTCRSS	Unique	SRTCRSS_TERM_CODE_ENTRY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_SORCRSS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORCRSS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_UPDATE_SORCRSS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_UPDATE_SORCRSS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
F_SAME_SORCRSS_EXISTS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
SRTCRSS	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_SRTCRSS	SQL Index	S10B80.SATURN	Rely On
STVCRSS	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTCRSS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:56:06:000	04/02/2008 21:18:17:000

Source Code Comments

Temporary Course Summary table.

Columns Comments for SRTCRSS_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Course Summary will be stored.

Columns Comments for SRTCRSS_CRSS_CODE (# 2)

Source Code Comments

COURSE SUMMARY CODE: This field identifies the Course Summary code.

Columns Comments for SRTCRSS_TERM_CODE_ENTRY (# 3)

Source Code Comments

TERM CODE ENTRY: The Term Code of Entry for the Course Summary for the person.

Columns Comments for SRTCRSS_HOURS (# 4)

Source Code Comments

HOURS: This field indicates the Hours associated with the Course Summary.

Columns Comments for SRTCRSS_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTCRSS table.

Columns Comments for SRTCRSS_SBGI_CODE (# 6)

Source Code Comments

SBGI CODE: This field indicates source code of the institution from which the Course Summary is recorded.

Table SRTDEGR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTDEGR_RIDM	NUMBER(8,0)	No	*
SRTDEGR_SBGI_CODE	VARCHAR2(6)	No	*	*
SRTDEGR_DEGC_CODE	VARCHAR2(6)	Yes		*
SRTDEGR_DEGR_SEQ_NO	NUMBER(2,0)	No	*
SRTDEGR_EGOL_CODE	VARCHAR2(2)	Yes		*
SRTDEGR_ATTEND_FROM	DATE	Yes
SRTDEGR_ATTEND_TO	DATE	Yes
SRTDEGR_DEGC_DATE	DATE	Yes
SRTDEGR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTDEGR_EGOL_CODE	STVEGOL_CODE	STVEGOL
SRTDEGR_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRTDEGR_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SRTDEGR	Unique	SRTDEGR_RIDM
PK_SRTDEGR	Unique	SRTDEGR_SBGI_CODE
PK_SRTDEGR	Unique	SRTDEGR_DEGR_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTDEGR	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_SRTDEGR	SQL Index	S10B80.SATURN	Rely On
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTDEGR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:14:000	04/02/2008 21:18:06:000

Source Code Comments

Temporary Degree table.

Columns Comments for SRTDEGR_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Degree will be stored.

Columns Comments for SRTDEGR_SBGI_CODE (# 2)

Source Code Comments

SBGI CODE: This field identifies institution source code of the prior college.

Columns Comments for SRTDEGR_DEGC_CODE (# 3)

Source Code Comments

DEGREE CODE: The Degree Code of earned at the prior college.

Columns Comments for SRTDEGR_DEGR_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: This field indicates the sequence number associated with the Degree at this college.

Columns Comments for SRTDEGR_EGOL_CODE (# 5)

Source Code Comments

EDUCATIONAL GOAL: This field indicates the educational goal of the degree.

Columns Comments for SRTDEGR_ATTEND_FROM (# 6)

Source Code Comments

ATTENDANCE FROM DATE: This field indicates date from which the person attended the prior college.

Columns Comments for SRTDEGR_ATTEND_TO (# 7)

Source Code Comments

ATTENDANCE TO DATE: This field indicates date to which the person attended the prior college.

Columns Comments for SRTDEGR_DEGC_DATE (# 8)

Source Code Comments

DEGREE DATE: This field indicates date on which the degree was completed.

Columns Comments for SRTDEGR_ACTIVITY_DATE (# 9)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTDEGR table.

Table SRTEMAL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTPERS	SQL Table	S10B80.SATURN	Join
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_EMAIL_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
EMAIL_ADDRESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
EMAL_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
VERIFY_EMAIL_ADDRESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LATEST_SRTPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
SRTEMALC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_BUILD_SRTEMAL_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (delete)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GOREMAL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTEMAL	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_EMAIL_RULES	Rely On
F_EQUAL_E_ADDRESS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_EMAIL	Use (select)
SRTEMAL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SRTEMAL	SQL Index	S10B80.SATURN	Rely On
GTVEMAL	SQL Table	S10B80.GENERAL	Refer (no action)
SRTPREL	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTEMAL

Object Dates

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

Source Code Comments

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

Columns Comments for SRTEMAL_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTEMAL_EMAL_CODE (# 2)

Source Code Comments

Code to identify the type of email address.

Columns Comments for SRTEMAL_EMAIL_ADDRESS (# 3)

Source Code Comments

The email address of the Prospect.

Columns Comments for SRTEMAL_STATUS_IND (# 4)

Source Code Comments

Status indicator for active, inactive of the email address.

Columns Comments for SRTEMAL_ACTIVITY_DATE (# 5)

Source Code Comments

Date of most recent update or of creation.

Columns Comments for SRTEMAL_USER_ID (# 6)

Source Code Comments

User ID of person who entered the email address.

Columns Comments for SRTEMAL_PREFERRED_IND (# 7)

Source Code Comments

Indicator if the email address is the persons preferred address.

Columns Comments for SRTEMAL_COMMENT (# 8)

Source Code Comments

General comment text area about the email address.

Columns Comments for SRTEMAL_DISP_WEB_IND (# 9)

Source Code Comments

Indicator that the email should be displayed on the web.

Table SRTGPAT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTGPAT_RIDM	NUMBER(8,0)	No	*
SRTGPAT_GPAT_CODE	VARCHAR2(8)	No	*	*
SRTGPAT_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SRTGPAT_GPA	NUMBER(23,9)	No
SRTGPAT_PLUS_MINUS_IND	VARCHAR2(1)	No
SRTGPAT_ACTIVITY_DATE	DATE	No
SRTGPAT_SBGI_CODE	VARCHAR2(6)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTGPAT_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRTGPAT_GPAT_CODE	STVGPAT_CODE	STVGPAT
SRTGPAT_TERM_CODE_ENTRY	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SRTGPAT	Unique	SRTGPAT_RIDM
PK_SRTGPAT	Unique	SRTGPAT_GPAT_CODE
PK_SRTGPAT	Unique	SRTGPAT_TERM_CODE_ENTRY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_SORGPAT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORGPAT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_UPDATE_SORGPAT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_UPDATE_SORGPAT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
F_SAME_SORGPAT_EXISTS	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
SRTGPAT	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_SRTGPAT	SQL Index	S10B80.SATURN	Rely On
STVGPAT	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTGPAT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:03:58:000	04/02/2008 21:18:23:000

Source Code Comments

Temporary GPA Type table.

Columns Comments for SRTGPAT_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the GPA Type will be stored.

Columns Comments for SRTGPAT_GPAT_CODE (# 2)

Source Code Comments

GPAT CODE: This field identifies the GPA Type.

Columns Comments for SRTGPAT_TERM_CODE_ENTRY (# 3)

Source Code Comments

TERM CODE ENTRY: The Term Code of Entry for the GPA for the person.

Columns Comments for SRTGPAT_GPA (# 4)

Source Code Comments

GPA: This field indicates the GPA value associated with the GPA type.

Columns Comments for SRTGPAT_PLUS_MINUS_IND (# 5)

Source Code Comments

PLUS MINUS IND: This field indicates whether the GPA value includes a plus or a minus.

Columns Comments for SRTGPAT_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTGPAT table.

Columns Comments for SRTGPAT_SBGI_CODE (# 7)

Source Code Comments

SBGI CODE: This field indicates source code of the institution from which the GPA Type is recorded.

Table SRTHSCH

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTHSCH_RIDM	NUMBER(8,0)	No	*	*
SRTHSCH_SBGI_CODE	VARCHAR2(6)	No	*	*
SRTHSCH_ACTIVITY_DATE	DATE	No
SRTHSCH_SBGI_DESC	VARCHAR2(30)	Yes
SRTHSCH_STREET_LINE1	VARCHAR2(75)	Yes
SRTHSCH_STREET_LINE2	VARCHAR2(75)	Yes
SRTHSCH_STREET_LINE3	VARCHAR2(75)	Yes
SRTHSCH_CITY	VARCHAR2(50)	Yes
SRTHSCH_STAT_CODE	VARCHAR2(3)	Yes		*
SRTHSCH_ZIP	VARCHAR2(30)	Yes
SRTHSCH_NATN_CODE	VARCHAR2(5)	Yes		*
SRTHSCH_GRADUATION_DATE	DATE	Yes
SRTHSCH_GPA	VARCHAR2(24)	Yes
SRTHSCH_CLASS_RANK	NUMBER(4,0)	Yes
SRTHSCH_CLASS_SIZE	NUMBER(4,0)	Yes
SRTHSCH_PERCENTILE	NUMBER(5,2)	Yes
SRTHSCH_DPLM_CODE	VARCHAR2(2)	Yes		*
SRTHSCH_COLL_PREP_IND	VARCHAR2(1)	Yes
SRTHSCH_TRANS_RECV_DATE	DATE	Yes
SRTHSCH_GRAD_DAY	VARCHAR2(2)	Yes
SRTHSCH_GRAD_MON	VARCHAR2(2)	Yes
SRTHSCH_GRAD_YEAR	VARCHAR2(2)	Yes
SRTHSCH_GRAD_CENTURY	VARCHAR2(2)	Yes
SRTHSCH_EPS_CODE	VARCHAR2(5)	Yes
SRTHSCH_GRADE_AVERAGE	VARCHAR2(24)	Yes
SRTHSCH_SBGI_CODE_INVALID	VARCHAR2(6)	Yes
SRTHSCH_HOUSE_NUMBER	VARCHAR2(10)	Yes
SRTHSCH_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTHSCH_DPLM_CODE	STVDPLM_CODE	STVDPLM
SRTHSCH_STAT_CODE	STVSTAT_CODE	STVSTAT
SRTHSCH_NATN_CODE	STVNATN_CODE	STVNATN
SRTHSCH_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRTHSCH_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTHSCH	Unique	SRTHSCH_RIDM
PK_SRTHSCH	Unique	SRTHSCH_SBGI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
HS_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_GPA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_NATN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_SBGI_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_SBGI_CODE_INVALID	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_STR1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_STR2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_STR3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
HS_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
RECR_HSC	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
SRTHSCHC	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SORHSCH_SELFREPORT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORHSCH_SELFREPORT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
SRTHSCH	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_SRTHSCH	SQL Index	S10B80.SATURN	Rely On
SRTPREL	SQL Table	S10B80.SATURN	Join
STVDPLM	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTHSCH

Object Dates

Creation Date	Analysis Date
04/02/2008 20:56:09:000	04/02/2008 21:18:17:000

Source Code Comments

High Schools loaded from Electronic Prospect sources.

Columns Comments for SRTHSCH_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTHSCH_SBGI_CODE (# 2)

Source Code Comments

This field identifies the high school code of the prospect/applicant.

Columns Comments for SRTHSCH_ACTIVITY_DATE (# 3)

Source Code Comments

This field indicates the last date the SRTHSCH record was updated.

Columns Comments for SRTHSCH_SBGI_DESC (# 4)

Source Code Comments

This field is the name of the high school of the prospect/applicant.

Columns Comments for SRTHSCH_STREET_LINE1 (# 5)

Source Code Comments

This field identifies the first line of the source institutions address.

Columns Comments for SRTHSCH_STREET_LINE2 (# 6)

Source Code Comments

This field identifies the second line of the source institutions address.

Columns Comments for SRTHSCH_STREET_LINE3 (# 7)

Source Code Comments

This field identifies the third line of the source institutions address.

Columns Comments for SRTHSCH_CITY (# 8)

Source Code Comments

This field identifies the city of the source institutions address.

Columns Comments for SRTHSCH_STAT_CODE (# 9)

Source Code Comments

This field identifies the state of the source institutions address.

Columns Comments for SRTHSCH_NATN_CODE (# 11)

Source Code Comments

This field identifies the nation of the source background institution.

Columns Comments for SRTHSCH_GRADUATION_DATE (# 12)

Source Code Comments

This field identifies the prospect/applicant graduation date from high school.

Columns Comments for SRTHSCH_GPA (# 13)

Source Code Comments

This field identifies the prospect/applicant high school GPA.

Columns Comments for SRTHSCH_CLASS_RANK (# 14)

Source Code Comments

This field identifies the prospect/applicant high school class rank.

Columns Comments for SRTHSCH_CLASS_SIZE (# 15)

Source Code Comments

This field indicates the size of the prospect/applicant high school graduating class size.

Columns Comments for SRTHSCH_PERCENTILE (# 16)

Source Code Comments

This field identifies the prospect/applicant class percentile as related to class rank and size.

Columns Comments for SRTHSCH_DPLM_CODE (# 17)

Source Code Comments

This field indicates the prospect/applicant high school diploma type, ie., college prep.

Columns Comments for SRTHSCH_COLL_PREP_IND (# 18)

Source Code Comments

This field indicates whether the prospect/applicant high school program was college prep. Values are "Y" or " ".

Columns Comments for SRTHSCH_TRANS_RECV_DATE (# 19)

Source Code Comments

This field identifies the date the prospect/applicant high school transcript was received.

Columns Comments for SRTHSCH_GRAD_DAY (# 20)

Source Code Comments

This field identifies the prospect/applicant graduation day, as part of the complete date, from high school.

Columns Comments for SRTHSCH_GRAD_MON (# 21)

Source Code Comments

This field identifies the prospect/applicant graduation month, as part of the complete date, from high school.

Columns Comments for SRTHSCH_GRAD_YEAR (# 22)

Source Code Comments

This field identifies the prospect/applicant graduation year, as part of the complete date, from high school.

Columns Comments for SRTHSCH_GRAD_CENTURY (# 23)

Source Code Comments

This field identifies the prospect/applicant graduation century, as part of the complete date, from high school.

Columns Comments for SRTHSCH_EPS_CODE (# 24)

Source Code Comments

Enrollment Planning Service code. Usually in format NY-01.

Columns Comments for SRTHSCH_GRADE_AVERAGE (# 25)

Source Code Comments

This field identifies the prospect/applicant high school grade average.

Columns Comments for SRTHSCH_SBGI_CODE_INVALID (# 26)

Source Code Comments

This field identifies the high school code of the prospect/applicant. This code is not valid in the STVSBGI table and is saved for information.

Columns Comments for SRTHSCH_HOUSE_NUMBER (# 27)

Source Code Comments

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

Columns Comments for SRTHSCH_STREET_LINE4 (# 28)

Source Code Comments

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

Table SRTIDEN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTIDEN_RIDM	NUMBER(8,0)	No	*	*
SRTIDEN_ID	VARCHAR2(9)	No		*
SRTIDEN_LAST_NAME	VARCHAR2(60)	No
SRTIDEN_ACTIVITY_DATE	DATE	No
SRTIDEN_PIDM	NUMBER(8,0)	Yes
SRTIDEN_FIRST_NAME	VARCHAR2(60)	Yes
SRTIDEN_MI	VARCHAR2(60)	Yes
SRTIDEN_NTYP_CODE	VARCHAR2(4)	Yes		*
SRTIDEN_MATCH_STATUS	VARCHAR2(1)	Yes
SRTIDEN_DATE_MATCHED	DATE	Yes
SRTIDEN_AMCAS_ID	VARCHAR2(10)	Yes
SRTIDEN_LAST_NAME_OLD	VARCHAR2(60)	Yes
SRTIDEN_SURNAME_PREFIX	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTIDEN_NTYP_CODE	GTVNTYP_CODE	GTVNTYP
SRTIDEN_RIDM	SRTPREL_RIDM	SRTPREL
SRTIDEN_RIDM	SRTPERS_RIDM	SRTPERS
SRTIDEN_ID	SRTPERS_SSN	SRTPERS

Index

Index Name	Index Type	Column Name
PK_SRTIDEN	Unique	SRTIDEN_RIDM
SRTIDEN_ID_INDEX		SRTIDEN_ID
SRTIDEN_MATCH_INDEX		SRTIDEN_MATCH_STATUS
SRTIDEN_NAME_INDEX		SRTIDEN_LAST_NAME
SRTIDEN_NAME_INDEX		SRTIDEN_FIRST_NAME
SRTIDEN_NAME_INDEX		SRTIDEN_MI
SRTIDEN_NTYP_INDEX		SRTIDEN_NTYP_CODE
SRTIDEN_PIDM_INDEX		SRTIDEN_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPRIDEN	SQL Table	S10B80.SATURN	Join
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT	Rely On
FIRST_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LAST_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
MIDDLE_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NTYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
RIDM	Oracle Package Variable	S10B80.BANINST1.SRKPREL	Rely On
GET_RIDM	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
GET_RIDM	Oracle Package Cursor	S10B80.BANINST1.BWSKAADR	Use (select)
GET_SRTIDENC	Oracle Package Cursor	S10B80.BANINST1.BWSKAHSC	Use (select)
GET_SRTIDENC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAACT	Rely On
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAACT	Use (select)Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Rely On
F_BUILD_SRTIDEN_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTIDEN	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTIDEN	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_SORHSCH	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPRIDEN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPRIDEN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (update,select)
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTIDEN	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT	Rely On
P_UPDATE_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_UPDATE_SPRIDEN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_UPDATE_SPRIDEN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Use (select)
F_GET_PROSPECT_SOBSEQN	Oracle Package Function	S10B80.BANINST1.SRKPREL	Rely On
F_GET_PROSPECT_SOBSEQN	Oracle Package Function	S10B80.BANINST1.SRKPREL	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT	Use (select)
SRTIDEN	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_SRTIDEN	SQL Index	S10B80.SATURN	Rely On
SRTIDEN_ID_INDEX	SQL Index	S10B80.SATURN	Rely On
SRTIDEN_MATCH_INDEX	SQL Index	S10B80.SATURN	Rely On
SRTIDEN_NAME_INDEX	SQL Index	S10B80.SATURN	Rely On
SRTIDEN_NTYP_INDEX	SQL Index	S10B80.SATURN	Rely On
SRTIDEN_PIDM_INDEX	SQL Index	S10B80.SATURN	Rely On
GTVNTYP	SQL Table	S10B80.GENERAL	Refer (no action)
SRTPERS	SQL Table	S10B80.SATURN	Join
SRTPREL	SQL Table	S10B80.SATURN	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTIDEN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:36:48:000	04/02/2008 21:18:00:000

Source Code Comments

Electronic Prospect person data loaded from search and test score tapes, or entered on Web for Prospects.

Columns Comments for SRTIDEN_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTIDEN_ID (# 2)

Source Code Comments

This field defines the identification number used to access person on-line.

Columns Comments for SRTIDEN_LAST_NAME (# 3)

Source Code Comments

This field defines the last name of person.

Columns Comments for SRTIDEN_ACTIVITY_DATE (# 4)

Source Code Comments

This field identifies the last date the SRTPERS record was updated.

Columns Comments for SRTIDEN_PIDM (# 5)

Source Code Comments

Internal identification number of the person from their SPRIDEN record. This value is filled in once the Prospect is matched or migrated to SPRIDEN.

Columns Comments for SRTIDEN_FIRST_NAME (# 6)

Source Code Comments

This field identifies the first name of person.

Columns Comments for SRTIDEN_MI (# 7)

Source Code Comments

This field identifies the middle name of person.

Columns Comments for SRTIDEN_NTYP_CODE (# 8)

Source Code Comments

The name type code associated with the ID and name.

Columns Comments for SRTIDEN_MATCH_STATUS (# 9)

Source Code Comments

The status code of the match to an existing person in SPRIDEN. Valid values are N)new, (M)matched. A blank value is unprocessed.

Columns Comments for SRTIDEN_DATE_MATCHED (# 10)

Source Code Comments

The date the match to SPRIDEN took place.

Columns Comments for SRTIDEN_AMCAS_ID (# 11)

Source Code Comments

AMCAS ID: External ID provided by AMCAS for applicant.

Columns Comments for SRTIDEN_LAST_NAME_OLD (# 12)

Source Code Comments

OLD LAST NAME: Old Last Name provided by AMCAS for applicant.

Columns Comments for SRTIDEN_SURNAME_PREFIX (# 13)

Source Code Comments

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

Table SRTINTL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SRTINTL_RIDM	NUMBER(8,0)	No	*
SRTINTL_VTYP_CODE_CURRENT	VARCHAR2(2)	Yes	*
SRTINTL_ACTIVITY_DATE	DATE	No
SRTINTL_VISA_NUMBER	VARCHAR2(18)	Yes
SRTINTL_VISA_ISSUE_DATE	DATE	Yes
SRTINTL_VISA_EXPIRE_DATE	DATE	Yes
SRTINTL_SPON_CODE	VARCHAR2(3)	Yes
SRTINTL_NATN_CODE_BIRTH	VARCHAR2(5)	Yes	*
SRTINTL_NATN_CODE_LEGAL	VARCHAR2(5)	Yes	*
SRTINTL_PASSPORT_ID	VARCHAR2(25)	Yes
SRTINTL_PASSPORT_EXP_DATE	DATE	Yes
SRTINTL_ALIEN_REG_NUMBER	VARCHAR2(11)	Yes
SRTINTL_I20_ID_NUMBER	VARCHAR2(11)	Yes
SRTINTL_I94_STATUS	VARCHAR2(3)	Yes
SRTINTL_I94_DATE	DATE	Yes
SRTINTL_VTYP_CODE_ENTRY	VARCHAR2(2)	Yes
SRTINTL_ENTRY_DATE	DATE	Yes
SRTINTL_ENTRY_EXP_DATE	DATE	Yes
SRTINTL_PENT_CODE	VARCHAR2(3)	Yes
SRTINTL_NO_ENTRIES	VARCHAR2(2)	Yes
SRTINTL_ADMR_CODE	VARCHAR2(4)	Yes
SRTINTL_RECV_DATE	DATE	Yes
SRTINTL_I20_DATE	DATE	Yes
SRTINTL_LANG_CODE	VARCHAR2(3)	Yes
SRTINTL_I20_IND	VARCHAR2(1)	Yes
SRTINTL_SPOUSE_IND	VARCHAR2(1)	Yes
SRTINTL_CHILD_NUMBER	NUMBER(2,0)	Yes
SRTINTL_EMPT_CODE	VARCHAR2(3)	Yes
SRTINTL_SIGNATURE_IND	VARCHAR2(1)	Yes
SRTINTL_FOREIGN_SSN	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTINTL_VTYP_CODE_CURRENT	STVVTYP_CODE	STVVTYP
SRTINTL_NATN_CODE_BIRTH	STVNATN_CODE	STVNATN
SRTINTL_NATN_CODE_LEGAL	STVNATN_CODE	STVNATN
SRTINTL_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
UK_SRTINTL	Unique	SRTINTL_RIDM
UK_SRTINTL	Unique	SRTINTL_VTYP_CODE_CURRENT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
FOREIGN_SSN	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NATIVE_LANG_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NATN_CODE_BIRTH	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NATN_CODE_LEGAL	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
VISA_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
VTYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
SRTINTL	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
UK_SRTINTL	SQL Index	S10B80.SATURN	Rely On
SRTPREL	SQL Table	S10B80.SATURN	Join
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVVTYP	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTINTL

Object Dates

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

Source Code Comments

Table used to store international information of Electronic Prospect before migrating the prospect to Banner Production Tables.

Columns Comments for SRTINTL_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTINTL_VTYP_CODE_CURRENT (# 2)

Source Code Comments

Current visa type submitted by Electronic Prospect

Columns Comments for SRTINTL_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date of creation or update.

Columns Comments for SRTINTL_VISA_NUMBER (# 4)

Source Code Comments

This field identifies the Visa number assigned to Visa type specified.

Columns Comments for SRTINTL_VISA_ISSUE_DATE (# 5)

Source Code Comments

This field identifies date Visa was issued.

Columns Comments for SRTINTL_VISA_EXPIRE_DATE (# 6)

Source Code Comments

This field identifies the date Visa will expire.

Columns Comments for SRTINTL_SPON_CODE (# 7)

Source Code Comments

This field identifies the sponsor code of person.

Columns Comments for SRTINTL_NATN_CODE_BIRTH (# 8)

Source Code Comments

This field identifies the nation of birth of person.

Columns Comments for SRTINTL_NATN_CODE_LEGAL (# 9)

Source Code Comments

This field identifies nation of citizenship of person.

Columns Comments for SRTINTL_PASSPORT_ID (# 10)

Source Code Comments

This field identifies number assigned to passport.

Columns Comments for SRTINTL_PASSPORT_EXP_DATE (# 11)

Source Code Comments

This field identifies date passport will expire.

Columns Comments for SRTINTL_ALIEN_REG_NUMBER (# 12)

Source Code Comments

This field identifies alien registration number assigned to person.

Columns Comments for SRTINTL_I20_ID_NUMBER (# 13)

Source Code Comments

This field identifies the I20 ID admissions number assigned to person.

Columns Comments for SRTINTL_I94_STATUS (# 14)

Source Code Comments

This field identifies person status authorized by I94.

Columns Comments for SRTINTL_I94_DATE (# 15)

Source Code Comments

This field identifies date I94 duration status will expire.

Columns Comments for SRTINTL_VTYP_CODE_ENTRY (# 16)

Source Code Comments

This field identifies Visa type which person originally entered the United States with.

Columns Comments for SRTINTL_ENTRY_DATE (# 17)

Source Code Comments

This field identifies entry date to United States on original entry Visa.

Columns Comments for SRTINTL_ENTRY_EXP_DATE (# 18)

Source Code Comments

This field identifies date of expiration of original entry Visa.

Columns Comments for SRTINTL_PENT_CODE (# 19)

Source Code Comments

This field identifies the point of entry into United States by person.

Columns Comments for SRTINTL_NO_ENTRIES (# 20)

Source Code Comments

This field identifies the number of entries into the United States by person with current Visa type.

Columns Comments for SRTINTL_ADMR_CODE (# 21)

Source Code Comments

This field identifies the admissions request code associated with Visa type.

Columns Comments for SRTINTL_RECV_DATE (# 22)

Source Code Comments

This field identifies the receive date of the admissions checklist item associated with Visa type.

Columns Comments for SRTINTL_I20_DATE (# 23)

Source Code Comments

The date that I-20 is issued

Columns Comments for SRTINTL_LANG_CODE (# 24)

Source Code Comments

The students native language code

Columns Comments for SRTINTL_I20_IND (# 25)

Source Code Comments

The indicator that indicate whether the student needs an I-20 or not; value Y for yes, N for no and blank for not reported

Columns Comments for SRTINTL_SPOUSE_IND (# 26)

Source Code Comments

The Indicator that indicate whether the spouse is accompanying the student; value Y for yes, N for no and blank for not reported.

Columns Comments for SRTINTL_CHILD_NUMBER (# 27)

Source Code Comments

The number of children are accompanying the student

Columns Comments for SRTINTL_EMPT_CODE (# 28)

Source Code Comments

The employment type of the student

Columns Comments for SRTINTL_SIGNATURE_IND (# 29)

Source Code Comments

The indicator of the signature confirming availability of funds

Columns Comments for SRTINTL_FOREIGN_SSN (# 30)

Source Code Comments

FOREIGN SOCIAL SECURITY NUMBER: Stores the SSN for Non Resident employees.

Table SRTINTS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTINTS_RIDM	NUMBER(8,0)	No	*
SRTINTS_INTS_CODE	VARCHAR2(2)	No	*	*
SRTINTS_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTINTS_INTS_CODE	STVINTS_CODE	STVINTS

Index

Index Name	Index Type	Column Name
PK_SRTINTS	Unique	SRTINTS_RIDM
PK_SRTINTS	Unique	SRTINTS_INTS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
INTS_CODE_1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
INTS_CODE_2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
INTS_CODE_3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
INTS_CODE_4	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
INTS_CODE_5	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAACT	Rely On
EXTRACT_DEFAULT_DATA	Oracle Package Procedure	S10B80.BANINST1.BWSKAACT	Use (select)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SORINTS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORINTS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTINTS	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_SRTINTS	SQL Index	S10B80.SATURN	Rely On
STVINTS	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTINTS

Object Dates

Creation Date	Analysis Date
04/02/2008 20:49:06:000	04/02/2008 21:18:12:000

Source Code Comments

Table used to store interests of Electronic Prospect before migrating the prospect to Banner Production Tables.

Columns Comments for SRTINTS_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTINTS_INTS_CODE (# 2)

Source Code Comments

Interest code of Electronic Prospect.

Columns Comments for SRTINTS_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date of creation or update.

Table SRTLEND

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTLEND_RIDM	NUMBER(8,0)	No	*
SRTLEND_LEND_CODE	VARCHAR2(10)	No	*	*
SRTLEND_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTLEND_LEND_CODE	STVLEND_CODE	STVLEND

Index

Index Name	Index Type	Column Name
PK_SRTLEND	Unique	SRTLEND_RIDM
PK_SRTLEND	Unique	SRTLEND_LEND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
LEND_CODE_1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LEND_CODE_2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LEND_CODE_3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SRRLEND	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTLEND	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_SRTLEND	SQL Index	S10B80.SATURN	Rely On
STVLEND	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTLEND

Object Dates

Creation Date	Analysis Date
04/02/2008 20:46:42:000	04/02/2008 21:18:10:000

Source Code Comments

Table used to store how I learned of the institution code of Electronic Prospect before migrating the prospect to Banner Production Tables.

Columns Comments for SRTLEND_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTLEND_LEND_CODE (# 2)

Source Code Comments

Legend code of Electronic Prospect.

Columns Comments for SRTLEND_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date of creation or update.

Table SRTMAJR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTMAJR_RIDM	NUMBER(8,0)	No	*
SRTMAJR_SBGI_CODE	VARCHAR2(6)	No	*	*
SRTMAJR_DEGC_CODE	VARCHAR2(6)	Yes		*
SRTMAJR_DEGR_SEQ_NO	NUMBER(2,0)	No	*
SRTMAJR_MAJR_CODE_MAJOR	VARCHAR2(4)	No		*
SRTMAJR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTMAJR_MAJR_CODE_MAJOR	STVMAJR_CODE	STVMAJR
SRTMAJR_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRTMAJR_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SRTMAJR	Unique	SRTMAJR_RIDM
PK_SRTMAJR	Unique	SRTMAJR_SBGI_CODE
PK_SRTMAJR	Unique	SRTMAJR_DEGR_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTMAJR	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_SRTMAJR	SQL Index	S10B80.SATURN	Rely On
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTMAJR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:06:000	04/02/2008 21:18:05:000

Source Code Comments

Temporary Major table.

Columns Comments for SRTMAJR_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Major will be stored.

Columns Comments for SRTMAJR_SBGI_CODE (# 2)

Source Code Comments

SBGI CODE: This field identifies institution source code of the prior college.

Columns Comments for SRTMAJR_DEGC_CODE (# 3)

Source Code Comments

MAJREE CODE: The Degree Code of earned at the prior college.

Columns Comments for SRTMAJR_DEGR_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: This field indicates the sequence number associated with the Degree at this college.

Columns Comments for SRTMAJR_MAJR_CODE_MAJOR (# 5)

Source Code Comments

MAJOR: This field indicates the major of the person at the prior college.

Columns Comments for SRTMAJR_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTMAJR table.

Table SRTMATL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTMATL_RIDM	NUMBER(8,0)	No	*
SRTMATL_MATL_CODE	VARCHAR2(4)	No	*	*
SRTMATL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTMATL_MATL_CODE	STVMATL_CODE	STVMATL

Index

Index Name	Index Type	Column Name
PK_SRTMATL	Unique	SRTMATL_RIDM
PK_SRTMATL	Unique	SRTMATL_MATL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
MATL_CODE_1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
MATL_CODE_2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
MATL_CODE_3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTMATL	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_SRTMATL	SQL Index	S10B80.SATURN	Rely On
STVMATL	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTMATL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:27:000	04/02/2008 21:18:06:000

Source Code Comments

Data area to store electronic prospect requested materials.

Columns Comments for SRTMATL_RIDM (# 1)

Source Code Comments

RIDM value of electronic prospect.

Columns Comments for SRTMATL_MATL_CODE (# 2)

Source Code Comments

Material code of prospects requested material.

Columns Comments for SRTMATL_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the most recent date a record was created

Table SRTPCOL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTPCOL_RIDM	NUMBER(8,0)	No	*	*
SRTPCOL_SBGI_CODE	VARCHAR2(6)	No	*	*
SRTPCOL_ACTIVITY_DATE	DATE	No
SRTPCOL_SBGI_DESC	VARCHAR2(30)	Yes
SRTPCOL_STREET_LINE1	VARCHAR2(75)	Yes
SRTPCOL_STREET_LINE2	VARCHAR2(75)	Yes
SRTPCOL_STREET_LINE3	VARCHAR2(75)	Yes
SRTPCOL_CITY	VARCHAR2(50)	Yes
SRTPCOL_STAT_CODE	VARCHAR2(3)	Yes
SRTPCOL_ZIP	VARCHAR2(30)	Yes
SRTPCOL_NATN_CODE	VARCHAR2(5)	Yes		*
SRTPCOL_ATTEND_FROM	DATE	Yes
SRTPCOL_ATTEND_TO	DATE	Yes
SRTPCOL_DEGC_CODE	VARCHAR2(6)	Yes		*
SRTPCOL_TRANS_RECV_DATE	DATE	Yes
SRTPCOL_HOURS_TRANSFERRED	NUMBER(11,3)	Yes
SRTPCOL_GPA_TRANSFERRED	VARCHAR2(24)	Yes
SRTPCOL_GRAD_DAY	VARCHAR2(2)	Yes
SRTPCOL_GRAD_MON	VARCHAR2(2)	Yes
SRTPCOL_GRAD_YEAR	VARCHAR2(2)	Yes
SRTPCOL_GRAD_CENTURY	VARCHAR2(2)	Yes
SRTPCOL_GRADUATION_DATE	DATE	Yes
SRTPCOL_SBGI_CODE_INVALID	VARCHAR2(6)	Yes
SRTPCOL_PRIMARY_IND	VARCHAR2(1)	Yes
SRTPCOL_HOUSE_NUMBER	VARCHAR2(10)	Yes
SRTPCOL_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTPCOL_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRTPCOL_NATN_CODE	STVNATN_CODE	STVNATN
SRTPCOL_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRTPCOL_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTPCOL	Unique	SRTPCOL_RIDM
PK_SRTPCOL	Unique	SRTPCOL_SBGI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PCOL_CITY	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_DEGC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_GPA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_NAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_NATN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_SBGI_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_SBGI_CODE_INVALID	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_STAT_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_STR1	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_STR2	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_STR3	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
PCOL_ZIP	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
RECR_PCC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
SRTPCOLC	Oracle Package Cursor	S10B80.BANINST1.BWSKAPCL	Use (select)
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORPCOL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_WEBPROSPECTMAIN	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRO	Rely On
SRTPCOL	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_SRTPCOL	SQL Index	S10B80.SATURN	Rely On
SRTPREL	SQL Table	S10B80.SATURN	Join
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTPCOL

Object Dates

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

Source Code Comments

Electronic Prospect prior college loaded from search and test score tapes, or entered on Web for Prospects.

Columns Comments for SRTPCOL_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTPCOL_ACTIVITY_DATE (# 3)

Source Code Comments

This field identifies the last date the SRTPCOL record was updated.

Columns Comments for SRTPCOL_SBGI_DESC (# 4)

Source Code Comments

This field is the name of the prior college of the prospect/applicant.

Columns Comments for SRTPCOL_STREET_LINE1 (# 5)

Source Code Comments

This field identifies the first line of the source institutions address.

Columns Comments for SRTPCOL_STREET_LINE2 (# 6)

Source Code Comments

This field identifies the second line of the source institutions address.

Columns Comments for SRTPCOL_STREET_LINE3 (# 7)

Source Code Comments

This field identifies the third line of the source institutions address.

Columns Comments for SRTPCOL_CITY (# 8)

Source Code Comments

This field identifies the city of the source institutions address.

Columns Comments for SRTPCOL_STAT_CODE (# 9)

Source Code Comments

This field identifies the state of the source institutions address.

Columns Comments for SRTPCOL_NATN_CODE (# 11)

Source Code Comments

This field identifies the nation of the source background institution.

Columns Comments for SRTPCOL_ATTEND_FROM (# 12)

Source Code Comments

This field represents the first date of attendance at the prior college.

Columns Comments for SRTPCOL_ATTEND_TO (# 13)

Source Code Comments

This field represents the last date of attendance at the prior college.

Columns Comments for SRTPCOL_DEGC_CODE (# 14)

Source Code Comments

This field identifies the degree received at the prior college.

Columns Comments for SRTPCOL_HOURS_TRANSFERRED (# 16)

Source Code Comments

This field indicates the total number hours transferred from the prior college. This field is informational and does not update the transfer GPA in Academic History.

Columns Comments for SRTPCOL_GPA_TRANSFERRED (# 17)

Source Code Comments

This field identifies the transfer GPA. This is informational and does not update the transfer GPA in Academic History.

Columns Comments for SRTPCOL_GRAD_DAY (# 18)

Source Code Comments

This field identifies the prospect/applicant graduation day, as part of the complete date, from prior college.

Columns Comments for SRTPCOL_GRAD_MON (# 19)

Source Code Comments

This field identifies the prospect/applicant graduation month, as part of the complete date, from prior college.

Columns Comments for SRTPCOL_GRAD_YEAR (# 20)

Source Code Comments

This field identifies the prospect/applicant graduation year, as part of the complete date, from prior college.

Columns Comments for SRTPCOL_GRAD_CENTURY (# 21)

Source Code Comments

This field identifies the prospect/applicant graduation century, as part of the complete date, from prior college.

Columns Comments for SRTPCOL_GRADUATION_DATE (# 22)

Source Code Comments

This field identifies the prospect/applicant graduation date from prior college.

Columns Comments for SRTPCOL_SBGI_CODE_INVALID (# 23)

Source Code Comments

This field identifies the prior college code of the prospect/applicant. This code is not valid in the STVSBGI table and is saved for information.

Columns Comments for SRTPCOL_PRIMARY_IND (# 24)

Source Code Comments

PRIMARY INDICATOR: Prior college was the primary undergraduate institution attended.

Columns Comments for SRTPCOL_HOUSE_NUMBER (# 25)

Source Code Comments

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

Columns Comments for SRTPCOL_STREET_LINE4 (# 26)

Source Code Comments

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

Table SRTPERS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTPERS_RIDM	NUMBER(8,0)	No	*	*
SRTPERS_ACTIVITY_DATE	DATE	No
SRTPERS_SSN	VARCHAR2(15)	Yes
SRTPERS_BIRTH_DATE	DATE	Yes
SRTPERS_LGCY_CODE	VARCHAR2(1)	Yes		*
SRTPERS_ETHN_CODE	VARCHAR2(2)	Yes		*
SRTPERS_MRTL_CODE	VARCHAR2(1)	Yes		*
SRTPERS_RELG_CODE	VARCHAR2(2)	Yes		*
SRTPERS_SEX	VARCHAR2(1)	Yes
SRTPERS_CONFID_IND	VARCHAR2(1)	Yes
SRTPERS_DEAD_IND	VARCHAR2(1)	Yes
SRTPERS_VETC_FILE_NUMBER	VARCHAR2(10)	Yes
SRTPERS_LEGAL_NAME	VARCHAR2(500)	Yes
SRTPERS_PREF_FIRST_NAME	VARCHAR2(60)	Yes
SRTPERS_NAME_PREFIX	VARCHAR2(4)	Yes
SRTPERS_NAME_SUFFIX	VARCHAR2(4)	Yes
SRTPERS_BIRTH_DAY	VARCHAR2(2)	Yes
SRTPERS_BIRTH_MON	VARCHAR2(2)	Yes
SRTPERS_BIRTH_YEAR	VARCHAR2(2)	Yes
SRTPERS_BIRTH_CENTURY	VARCHAR2(2)	Yes
SRTPERS_CITZ_CODE	VARCHAR2(2)	Yes		*
SRTPERS_SSN_OLD	VARCHAR2(9)	Yes
SRTPERS_ETHN_CATEGORY	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTPERS_CITZ_CODE	STVCITZ_CODE	STVCITZ
SRTPERS_LGCY_CODE	STVLGCY_CODE	STVLGCY
SRTPERS_ETHN_CODE	STVETHN_CODE	STVETHN
SRTPERS_MRTL_CODE	STVMRTL_CODE	STVMRTL
SRTPERS_RELG_CODE	STVRELG_CODE	STVRELG
SRTPERS_RIDM	SRTPREL_RIDM	SRTPREL
SRTPERS_RIDM	SRTEMAL_RIDM	SRTEMAL

Index

Index Name	Index Type	Column Name
PK_SRTPERS	Unique	SRTPERS_RIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTIDEN	SQL Table	S10B80.SATURN	Join
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_BIO_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
CITZ_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ETHN_CAT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
ETHN_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
GENDER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NAME_PREFIX	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NAME_SUFFIX	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
NICKNAME	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
SSNTINTFN	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
LATEST_SRTPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)
SRTPERSC	Oracle Package Cursor	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
F_BUILD_SRTPERS_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTPERS	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTPERS	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SPRIDEN	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Rely On
P_PROCNEWAPP	Oracle Package Procedure	S10B80.BANINST1.BWSKALOG	Use (select)Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTPERS	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_BIO_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_BIO	Use (select)
SRTPERS	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_SRTPERS	SQL Index	S10B80.SATURN	Rely On
SRTEMAL	SQL Table	S10B80.SATURN	Join
SRTPREL	SQL Table	S10B80.SATURN	Join
STVCITZ	SQL Table	S10B80.SATURN	Refer (no action)
STVETHN	SQL Table	S10B80.SATURN	Refer (no action)
STVLGCY	SQL Table	S10B80.SATURN	Refer (no action)
STVMRTL	SQL Table	S10B80.SATURN	Refer (no action)
STVRELG	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTPERS

Object Dates

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

Source Code Comments

Electronic Prospect biographic data loaded from search and test score tapes, or entered on Web for Prospects.

Columns Comments for SRTPERS_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTPERS_ACTIVITY_DATE (# 2)

Source Code Comments

This field identifies the last date the SRTPERS record was updated.

Columns Comments for SRTPERS_SSN (# 3)

Source Code Comments

This field maintains person social security number.

Columns Comments for SRTPERS_BIRTH_DATE (# 4)

Source Code Comments

This field maintains person birth date.

Columns Comments for SRTPERS_LGCY_CODE (# 5)

Source Code Comments

This field maintains legacy code associated with person.

Columns Comments for SRTPERS_ETHN_CODE (# 6)

Source Code Comments

This field maintains ethnicity code associated with person.

Columns Comments for SRTPERS_MRTL_CODE (# 7)

Source Code Comments

This field maintains martial status associated with person.

Columns Comments for SRTPERS_RELG_CODE (# 8)

Source Code Comments

This field maintains religious affiliation associated with person.

Columns Comments for SRTPERS_SEX (# 9)

Source Code Comments

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

Columns Comments for SRTPERS_CONFID_IND (# 10)

Source Code Comments

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

Columns Comments for SRTPERS_DEAD_IND (# 11)

Source Code Comments

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

Columns Comments for SRTPERS_VETC_FILE_NUMBER (# 12)

Source Code Comments

This field maintains veteran identification number associated with person.

Columns Comments for SRTPERS_LEGAL_NAME (# 13)

Source Code Comments

This field maintains legal name associated with person.

Columns Comments for SRTPERS_NAME_PREFIX (# 15)

Source Code Comments

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

Columns Comments for SRTPERS_NAME_SUFFIX (# 16)

Source Code Comments

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

Columns Comments for SRTPERS_CITZ_CODE (# 21)

Source Code Comments

Person Citizen Type

Columns Comments for SRTPERS_SSN_OLD (# 22)

Source Code Comments

AMCAS OLD SSN: Old SSN provided by AMCAS for applicant.

Columns Comments for SRTPERS_ETHN_CATEGORY (# 23)

Source Code Comments

NEW ETHNICITY/ETHNIC CATEGORY: New Ethnicity provided by applicant.

Table SRTPRAC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTPRAC_RIDM	NUMBER(8,0)	No	*
SRTPRAC_RACE_CDE	VARCHAR2(3)	No	*	*
SRTPRAC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTPRAC_RACE_CDE	GORRACE_RACE_CDE	GORRACE

Index

Index Name	Index Type	Column Name
PK_SRTPRAC	Unique	SRTPRAC_RIDM
PK_SRTPRAC	Unique	SRTPRAC_RACE_CDE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_GORPRAC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GORPRAC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPBPERS	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
SRTPRAC	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_SRTPRAC	SQL Index	S10B80.SATURN	Rely On
GORRACE	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTPRAC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:54:56:000	04/02/2008 21:18:16:000

Source Code Comments

Temporary Race table.

Columns Comments for SRTPRAC_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Race will be stored.

Columns Comments for SRTPRAC_RACE_CDE (# 2)

Source Code Comments

RACE CODE: This field identifies the Race code.

Columns Comments for SRTPRAC_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTPRAC table.

Table SRTPREL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTPREL_RIDM	NUMBER(8,0)	No	*
SRTPREL_PREL_CODE	VARCHAR2(10)	No	*	*
SRTPREL_USER	VARCHAR2(30)	No
SRTPREL_ADD_DATE	DATE	No
SRTPREL_TERM_CODE	VARCHAR2(6)	No		*
SRTPREL_ADMIN_SEQNO	NUMBER(2,0)	No
SRTPREL_LEVL_CODE	VARCHAR2(2)	No		*
SRTPREL_DEGC_CODE	VARCHAR2(6)	No		*
SRTPREL_MAJR_CODE	VARCHAR2(4)	No		*
SRTPREL_ACTIVITY_DATE	DATE	No
SRTPREL_TAPE_ID	VARCHAR2(6)	Yes
SRTPREL_LOAD_STATUS	VARCHAR2(1)	Yes
SRTPREL_LOAD_DATE	DATE	Yes
SRTPREL_PROGRAM	VARCHAR2(12)	Yes		*
SRTPREL_DEPT_CODE	VARCHAR2(4)	Yes		*
SRTPREL_COLL_CODE	VARCHAR2(2)	Yes		*
SRTPREL_CAMP_CODE	VARCHAR2(3)	Yes		*
SRTPREL_RECR_CODE	VARCHAR2(3)	Yes		*
SRTPREL_RSTA_CODE	VARCHAR2(2)	Yes		*
SRTPREL_SELECT_IND	VARCHAR2(1)	Yes
SRTPREL_ADMT_CODE	VARCHAR2(2)	Yes		*
SRTPREL_STYP_CODE	VARCHAR2(1)	Yes		*
SRTPREL_MAJR_CODE_2	VARCHAR2(4)	Yes		*
SRTPREL_MAJR_CODE_3	VARCHAR2(4)	Yes
SRTPREL_MAJR_CODE_4	VARCHAR2(4)	Yes
SRTPREL_EDLV_CODE	VARCHAR2(3)	Yes		*
SRTPREL_EGOL_CODE	VARCHAR2(2)	Yes		*
SRTPREL_FULL_PART_IND	VARCHAR2(1)	Yes
SRTPREL_SBGI_CODE	VARCHAR2(6)	Yes		*
SRTPREL_WRSN_CODE	VARCHAR2(2)	Yes		*
SRTPREL_RTYP_CODE	VARCHAR2(2)	Yes		*
SRTPREL_RESD_CODE	VARCHAR2(1)	Yes		*
SRTPREL_SESS_CODE	VARCHAR2(1)	Yes		*
SRTPREL_SITE_CODE	VARCHAR2(3)	Yes		*
SRTPREL_TSRC_CODE	VARCHAR2(4)	Yes		*
SRTPREL_CTYP_CODE	VARCHAR2(3)	Yes		*
SRTPREL_HIGH_ACTIVITY1	VARCHAR2(6)	Yes
SRTPREL_HIGH_ACTIVITY2	VARCHAR2(6)	Yes
SRTPREL_HIGH_ACTIVITY3	VARCHAR2(6)	Yes
SRTPREL_HIGH_ACTIVITY4	VARCHAR2(6)	Yes
SRTPREL_HIGH_ACTIVITY5	VARCHAR2(6)	Yes
SRTPREL_COLL_ACTIVITY1	VARCHAR2(6)	Yes
SRTPREL_COLL_ACTIVITY2	VARCHAR2(6)	Yes
SRTPREL_COLL_ACTIVITY3	VARCHAR2(6)	Yes
SRTPREL_COLL_ACTIVITY4	VARCHAR2(6)	Yes
SRTPREL_COLL_ACTIVITY5	VARCHAR2(6)	Yes
SRTPREL_PACT_LOW	VARCHAR2(6)	Yes
SRTPREL_PACT_HIGH	VARCHAR2(6)	Yes
SRTPREL_PLAN_COMPOSITE	VARCHAR2(6)	Yes
SRTPREL_ACT_COMPOSITE	VARCHAR2(6)	Yes
SRTPREL_PSAT_LOW	VARCHAR2(6)	Yes
SRTPREL_PSAT_HIGH	VARCHAR2(6)	Yes
SRTPREL_PSAT_VERBAL	VARCHAR2(6)	Yes
SRTPREL_PSAT_MATH	VARCHAR2(6)	Yes
SRTPREL_TERM_CODE_CTLG	VARCHAR2(6)	Yes		*
SRTPREL_MAJR_CODE_5	VARCHAR2(4)	Yes
SRTPREL_MAJR_PSAT	VARCHAR2(4)	Yes
SRTPREL_MAJR_CODE_6	VARCHAR2(4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTPREL_WRSN_CODE	STVWRSN_CODE	STVWRSN
SRTPREL_ADMT_CODE	STVADMT_CODE	STVADMT
SRTPREL_STYP_CODE	STVSTYP_CODE	STVSTYP
SRTPREL_MAJR_CODE_2	STVMAJR_CODE	STVMAJR
SRTPREL_MAJR_CODE	STVMAJR_CODE	STVMAJR
SRTPREL_EGOL_CODE	STVEGOL_CODE	STVEGOL
SRTPREL_RTYP_CODE	STVRTYP_CODE	STVRTYP
SRTPREL_RESD_CODE	STVRESD_CODE	STVRESD
SRTPREL_SESS_CODE	STVSESS_CODE	STVSESS
SRTPREL_CTYP_CODE	STVCTYP_CODE	STVCTYP
SRTPREL_COLL_CODE	STVCOLL_CODE	STVCOLL
SRTPREL_DEGC_CODE	STVDEGC_CODE	STVDEGC
SRTPREL_DEPT_CODE	STVDEPT_CODE	STVDEPT
SRTPREL_TSRC_CODE	STVTSRC_CODE	STVTSRC
SRTPREL_CAMP_CODE	STVCAMP_CODE	STVCAMP
SRTPREL_EDLV_CODE	STVEDLV_CODE	STVEDLV
SRTPREL_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE
SRTPREL_LEVL_CODE	STVLEVL_CODE	STVLEVL
SRTPREL_TERM_CODE_CTLG	STVTERM_CODE	STVTERM
SRTPREL_TERM_CODE	STVTERM_CODE	STVTERM
SRTPREL_SITE_CODE	STVSITE_CODE	STVSITE
SRTPREL_RECR_CODE	STVRECR_CODE	STVRECR
SRTPREL_SBGI_CODE	STVSBGI_CODE	STVSBGI
SRTPREL_RSTA_CODE	STVRSTA_CODE	STVRSTA
SRTPREL_PREL_CODE	STVPREL_CODE	STVPREL

Index

Index Name	Index Type	Column Name
PK_SRTPREL	Unique	SRTPREL_RIDM
PK_SRTPREL	Unique	SRTPREL_PREL_CODE
SRTPREL_KEY_INDEX		SRTPREL_PREL_CODE
SRTPREL_KEY_INDEX		SRTPREL_TAPE_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTADDR	SQL Table	S10B80.SATURN	Join
SRTEMAL	SQL Table	S10B80.SATURN	Join
SRTHSCH	SQL Table	S10B80.SATURN	Join
SRTIDEN	SQL Table	S10B80.SATURN	Join
SRTINTL	SQL Table	S10B80.SATURN	Join
SRTPCOL	SQL Table	S10B80.SATURN	Join
SRTPERS	SQL Table	S10B80.SATURN	Join
SRTSUPL	SQL Table	S10B80.SATURN	Join
SRTTELE	SQL Table	S10B80.SATURN	Join
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
MAJR_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
STYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TERM_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_RECRUIT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SARRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORCONT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SRBRECR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SRBRECR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SRRRSRC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (update,select)Rely On
SRTPREL	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_SRTPREL	SQL Index	S10B80.SATURN	Rely On
SRTPREL_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SMRPRLE	SQL Table	S10B80.SATURN	Refer (no action)
STVADMT	SQL Table	S10B80.SATURN	Refer (no action)
STVCAMP	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVCTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVDEGC	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVEDLV	SQL Table	S10B80.SATURN	Refer (no action)
STVEGOL	SQL Table	S10B80.SATURN	Refer (no action)
STVLEVL	SQL Table	S10B80.SATURN	Refer (no action)
STVMAJR	SQL Table	S10B80.SATURN	Refer (no action)
STVPREL	SQL Table	S10B80.SATURN	Refer (no action)
STVRECR	SQL Table	S10B80.SATURN	Refer (no action)
STVRESD	SQL Table	S10B80.SATURN	Refer (no action)
STVRSTA	SQL Table	S10B80.SATURN	Refer (no action)
STVRTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSESS	SQL Table	S10B80.SATURN	Refer (no action)
STVSITE	SQL Table	S10B80.SATURN	Refer (no action)
STVSTYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVTSRC	SQL Table	S10B80.SATURN	Refer (no action)
STVWRSN	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTPREL

Object Dates

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

Source Code Comments

Electronic Prospect source information table.

Columns Comments for SRTPREL_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTPREL_PREL_CODE (# 2)

Source Code Comments

Code to identify the Electronic Prospect Source.

Columns Comments for SRTPREL_USER (# 3)

Source Code Comments

User who created the Electronic Prospect.

Columns Comments for SRTPREL_ADD_DATE (# 4)

Source Code Comments

Date added to SRTPREL.

Columns Comments for SRTPREL_TERM_CODE (# 5)

Source Code Comments

Term code Electronic Prospect inquired about.

Columns Comments for SRTPREL_ADMIN_SEQNO (# 6)

Source Code Comments

Sequence number of Electronic Prospect source record.

Columns Comments for SRTPREL_LEVL_CODE (# 7)

Source Code Comments

Level of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_DEGC_CODE (# 8)

Source Code Comments

Degree of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_MAJR_CODE (# 9)

Source Code Comments

Major of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_ACTIVITY_DATE (# 10)

Source Code Comments

This field identifies the most recent date of creation or update.

Columns Comments for SRTPREL_TAPE_ID (# 11)

Source Code Comments

Unique ID to identify the physical tape of the Electronic Prospect Source data.

Columns Comments for SRTPREL_LOAD_STATUS (# 12)

Source Code Comments

Status to indicate if Prospect was matched to Banner or new to Banner.

Columns Comments for SRTPREL_LOAD_DATE (# 13)

Source Code Comments

Date Electronic Prospects record was migrated to Production Banner tables.

Columns Comments for SRTPREL_PROGRAM (# 14)

Source Code Comments

Program Electronic Prospect is being considered.

Columns Comments for SRTPREL_DEPT_CODE (# 15)

Source Code Comments

Department of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_COLL_CODE (# 16)

Source Code Comments

College of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_CAMP_CODE (# 17)

Source Code Comments

Campus of program Electronic Prospect is being considered.

Columns Comments for SRTPREL_RECR_CODE (# 18)

Source Code Comments

Recruit code of Electronic Prospect.

Columns Comments for SRTPREL_RSTA_CODE (# 19)

Source Code Comments

Recruit status of Electronic Prospect.

Columns Comments for SRTPREL_SELECT_IND (# 20)

Source Code Comments

Indicator if PREL is the selected one for the person.

Columns Comments for SRTPREL_ADMT_CODE (# 21)

Source Code Comments

Admit code of Electronic Prospect.

Columns Comments for SRTPREL_STYP_CODE (# 22)

Source Code Comments

Student type code of Electronic Prospect.

Columns Comments for SRTPREL_MAJR_CODE_2 (# 23)

Source Code Comments

Major Electronic Prospect is considering.

Columns Comments for SRTPREL_MAJR_CODE_3 (# 24)

Source Code Comments

Major Electronic Prospect is considering.

Columns Comments for SRTPREL_MAJR_CODE_4 (# 25)

Source Code Comments

Major Electronic Prospect is considering.

Columns Comments for SRTPREL_TERM_CODE_CTLG (# 55)

Source Code Comments

Catalog term code for Electronic Prospect recruiting term.

Columns Comments for SRTPREL_MAJR_CODE_5 (# 56)

Source Code Comments

Major Electronic Prospect is considering.

Columns Comments for SRTPREL_MAJR_PSAT (# 57)

Source Code Comments

PSAT Major Electronic Prospect is considering.

Columns Comments for SRTPREL_MAJR_CODE_6 (# 58)

Source Code Comments

Major Electronic Prospect is considering.

Table SRTRECR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SRTRECR_PIDM	NUMBER(8,0)	No
SRTRECR_TERM_CODE	VARCHAR2(6)	No
SRTRECR_ADMIN_SEQNO	NUMBER(2,0)	No
SRTRECR_DEPT_CODE	VARCHAR2(4)	No
SRTRECR_LEVL_CODE	VARCHAR2(2)	No
SRTRECR_DEGC_CODE	VARCHAR2(6)	No
SRTRECR_MAJR_CODE	VARCHAR2(4)	No
SRTRECR_RECR_CODE	VARCHAR2(3)	Yes
SRTRECR_RSTA_CODE	VARCHAR2(2)	Yes
SRTRECR_ACTIVITY_DATE	DATE	No
SRTRECR_SELECT_IND	VARCHAR2(1)	Yes
SRTRECR_ADD_DATE	DATE	Yes
SRTRECR_ADMT_CODE	VARCHAR2(2)	Yes
SRTRECR_CAMP_CODE	VARCHAR2(3)	Yes
SRTRECR_COLL_CODE	VARCHAR2(2)	Yes
SRTRECR_MAJR_CODE_2	VARCHAR2(4)	Yes
SRTRECR_EDLV_CODE	VARCHAR2(3)	Yes
SRTRECR_EGOL_CODE	VARCHAR2(2)	Yes
SRTRECR_FULL_PART_IND	VARCHAR2(1)	Yes
SRTRECR_SBGI_CODE	VARCHAR2(6)	Yes
SRTRECR_WRSN_CODE	VARCHAR2(2)	Yes
SRTRECR_RTYP_CODE	VARCHAR2(2)	Yes
SRTRECR_RESD_CODE	VARCHAR2(1)	Yes
SRTRECR_SESS_CODE	VARCHAR2(1)	Yes
SRTRECR_SITE_CODE	VARCHAR2(3)	Yes
SRTRECR_STYP_CODE	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SRTRECR_KEY_INDEX		SRTRECR_PIDM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRTRECR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTRECR

Object Dates

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

Source Code Comments

Temporary SRBRECR Table

Columns Comments for SRTRECR_SELECT_IND (# 11)

Source Code Comments

Selected indicator to specify which record is current or most recent recruiting record. Informational only Values are Y or null. Only 1 record per term may be selected.

Columns Comments for SRTRECR_ADD_DATE (# 12)

Source Code Comments

Date record added.

Columns Comments for SRTRECR_ADMT_CODE (# 13)

Source Code Comments

Admission Type code.

Columns Comments for SRTRECR_CAMP_CODE (# 14)

Source Code Comments

Campus code.

Columns Comments for SRTRECR_COLL_CODE (# 15)

Source Code Comments

College code.

Columns Comments for SRTRECR_MAJR_CODE_2 (# 16)

Source Code Comments

Area of Concentration code.

Columns Comments for SRTRECR_EDLV_CODE (# 17)

Source Code Comments

Education Level code.

Columns Comments for SRTRECR_EGOL_CODE (# 18)

Source Code Comments

Education Goal code.

Columns Comments for SRTRECR_FULL_PART_IND (# 19)

Source Code Comments

Fulltime-Parttime Indicator. If not null, values are F or P.

Columns Comments for SRTRECR_SBGI_CODE (# 20)

Source Code Comments

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

Columns Comments for SRTRECR_WRSN_CODE (# 21)

Source Code Comments

Withdrawal Reason code. Used when student decides not to attend home institution.

Columns Comments for SRTRECR_RTYP_CODE (# 22)

Source Code Comments

Recruit Type code.

Columns Comments for SRTRECR_RESD_CODE (# 23)

Source Code Comments

Residency code.

Columns Comments for SRTRECR_SESS_CODE (# 24)

Source Code Comments

Session code.

Columns Comments for SRTRECR_SITE_CODE (# 25)

Source Code Comments

Site code.

Columns Comments for SRTRECR_STYP_CODE (# 26)

Source Code Comments

Student Type code.

Table SRTSUPL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTSUPL_RIDM	NUMBER(8,0)	No	*	*
SRTSUPL_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SRTSUPL_CNTY_CODE_ADMIT	VARCHAR2(5)	Yes		*
SRTSUPL_CNTY_ADMIT_RURAL	VARCHAR2(1)	Yes
SRTSUPL_STAT_CODE_ADMIT	VARCHAR2(3)	Yes		*
SRTSUPL_NATN_CODE_ADMIT	VARCHAR2(5)	Yes		*
SRTSUPL_CITY_BIRTH	VARCHAR2(20)	Yes
SRTSUPL_CNTY_CODE_BIRTH	VARCHAR2(5)	Yes		*
SRTSUPL_CNTY_BIRTH_RURAL	VARCHAR2(1)	Yes
SRTSUPL_STAT_CODE_BIRTH	VARCHAR2(3)	Yes		*
SRTSUPL_NATN_CODE_BIRTH	VARCHAR2(5)	Yes		*
SRTSUPL_SBGI_CODE_ADMIT	VARCHAR2(6)	Yes		*
SRTSUPL_ETHN_CODE_SELF	VARCHAR2(2)	Yes		*
SRTSUPL_ESEL_CODE	VARCHAR2(2)	Yes		*
SRTSUPL_NUMBER_DEPS	NUMBER(2,0)	Yes
SRTSUPL_AGENCY_FILE_NO	VARCHAR2(10)	Yes
SRTSUPL_APP_YEAR_AGENCY	NUMBER(4,0)	Yes
SRTSUPL_PREV_APP_1	NUMBER(4,0)	Yes
SRTSUPL_PREV_APP_2	NUMBER(4,0)	Yes
SRTSUPL_PREV_APP_3	NUMBER(4,0)	Yes
SRTSUPL_PREV_APP_4	NUMBER(4,0)	Yes
SRTSUPL_AGENCY_FEE_WAIVED	VARCHAR2(1)	Yes
SRTSUPL_CYCLE_ADDED	NUMBER(3,0)	Yes
SRTSUPL_CYCLE_CHANGED	NUMBER(3,0)	Yes
SRTSUPL_AGENCY_REPORT_DATE	DATE	Yes
SRTSUPL_NEXT_MCAT_DATE	DATE	Yes
SRTSUPL_FLAG1	VARCHAR2(1)	Yes
SRTSUPL_FLAG2	VARCHAR2(1)	Yes
SRTSUPL_FLAG3	VARCHAR2(1)	Yes
SRTSUPL_FLAG4	VARCHAR2(1)	Yes
SRTSUPL_FLAG5	VARCHAR2(1)	Yes
SRTSUPL_FLAG6	VARCHAR2(1)	Yes
SRTSUPL_FLAG7	VARCHAR2(1)	Yes
SRTSUPL_FLAG8	VARCHAR2(1)	Yes
SRTSUPL_FLAG9	VARCHAR2(1)	Yes
SRTSUPL_FLAG10	VARCHAR2(1)	Yes
SRTSUPL_INST_DATA1	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA2	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA3	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA4	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA5	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA6	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA7	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA8	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA9	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA10	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA11	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA12	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA13	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA14	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA15	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA16	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA17	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA18	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA19	VARCHAR2(60)	Yes
SRTSUPL_INST_DATA20	VARCHAR2(60)	Yes
SRTSUPL_ACTIVITY_DATE	DATE	Yes
SRTSUPL_EFFEC_DATE	DATE	Yes
SRTSUPL_APPL_TYPE	VARCHAR2(1)	Yes
SRTSUPL_BIO_NUMBER	VARCHAR2(22)	Yes
SRTSUPL_HISP_IND	VARCHAR2(1)	Yes
SRTSUPL_RACE1	VARCHAR2(3)	Yes		*
SRTSUPL_RACE2	VARCHAR2(3)	Yes		*
SRTSUPL_RACE3	VARCHAR2(3)	Yes		*
SRTSUPL_RACE4	VARCHAR2(3)	Yes		*
SRTSUPL_RACE5	VARCHAR2(3)	Yes		*
SRTSUPL_RACE6	VARCHAR2(3)	Yes		*
SRTSUPL_RACE7	VARCHAR2(3)	Yes		*
SRTSUPL_RACE8	VARCHAR2(3)	Yes		*
SRTSUPL_RACE9	VARCHAR2(3)	Yes		*
SRTSUPL_RACE10	VARCHAR2(3)	Yes		*
SRTSUPL_ETHNIC1	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC2	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC3	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC4	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC5	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC6	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC7	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC8	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC9	VARCHAR2(2)	Yes
SRTSUPL_ETHNIC10	VARCHAR2(2)	Yes
SRTSUPL_SCHOOL_STATE	VARCHAR2(2)	Yes
SRTSUPL_SCHOOL_NUM	NUMBER(3,0)	Yes
SRTSUPL_DATE_APPLIED	DATE	Yes
SRTSUPL_EARLY_DECISION	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTSUPL_CNTY_CODE_ADMIT	STVCNTY_CODE	STVCNTY
SRTSUPL_CNTY_CODE_BIRTH	STVCNTY_CODE	STVCNTY
SRTSUPL_RACE10	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE1	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE2	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE3	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE4	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE5	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE6	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE7	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE8	GORRACE_RACE_CDE	GORRACE
SRTSUPL_RACE9	GORRACE_RACE_CDE	GORRACE
SRTSUPL_NATN_CODE_ADMIT	STVNATN_CODE	STVNATN
SRTSUPL_NATN_CODE_BIRTH	STVNATN_CODE	STVNATN
SRTSUPL_STAT_CODE_ADMIT	STVSTAT_CODE	STVSTAT
SRTSUPL_STAT_CODE_BIRTH	STVSTAT_CODE	STVSTAT
SRTSUPL_ESEL_CODE	STVESEL_CODE	STVESEL
SRTSUPL_TERM_CODE_ENTRY	STVTERM_CODE	STVTERM
SRTSUPL_ETHN_CODE_SELF	STVETHN_CODE	STVETHN
SRTSUPL_SBGI_CODE_ADMIT	STVSBGI_CODE	STVSBGI
SRTSUPL_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTSUPL	Unique	SRTSUPL_RIDM
PK_SRTSUPL	Unique	SRTSUPL_TERM_CODE_ENTRY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_INTL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_INSERT_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_MIGRATE_PROSPECT	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
P_UPDATE_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_UPDATE_SABSUPL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
SRTSUPL	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_SRTSUPL	SQL Index	S10B80.SATURN	Rely On
GORRACE	SQL Table	S10B80.GENERAL	Refer (no action)
SRTPREL	SQL Table	S10B80.SATURN	Join
STVCNTY	SQL Table	S10B80.SATURN	Refer (no action)
STVESEL	SQL Table	S10B80.SATURN	Refer (no action)
STVETHN	SQL Table	S10B80.SATURN	Refer (no action)
STVNATN	SQL Table	S10B80.SATURN	Refer (no action)
STVSBGI	SQL Table	S10B80.SATURN	Refer (no action)
STVSTAT	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTSUPL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:42:17:000	04/02/2008 21:18:05:000

Source Code Comments

Temporary Supplemental Information table.

Columns Comments for SRTSUPL_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Supplemental Information will be stored.

Columns Comments for SRTSUPL_TERM_CODE_ENTRY (# 2)

Source Code Comments

TERM CODE ENTRY: The Term Code of Entry for the Supplemental Information for the person.

Columns Comments for SRTSUPL_CNTY_CODE_ADMIT (# 3)

Source Code Comments

COUNTY CODE ADMIT: This field indicates the county code associated with the person when they were admitted.

Columns Comments for SRTSUPL_CNTY_ADMIT_RURAL (# 4)

Source Code Comments

COUNTY ADMIT RURAL: This field indicates whether the county code of admissions is a rural county.

Columns Comments for SRTSUPL_STAT_CODE_ADMIT (# 5)

Source Code Comments

STATE CODE ADMIT: This field identifies the state code of the person when they sought admission.

Columns Comments for SRTSUPL_NATN_CODE_ADMIT (# 6)

Source Code Comments

NATION CODE ADMIT: This field identifies the nation code of the person when they sought admission.

Columns Comments for SRTSUPL_CITY_BIRTH (# 7)

Source Code Comments

CITY BIRTH: This field identifies the city where the applicant was born.

Columns Comments for SRTSUPL_CNTY_CODE_BIRTH (# 8)

Source Code Comments

COUNTY CODE BIRTH: This field identifies the county where the applicant was born.

Columns Comments for SRTSUPL_CNTY_BIRTH_RURAL (# 9)

Source Code Comments

COUNTY BIRTH RURAL: This field indicates if the county of birth was rural.

Columns Comments for SRTSUPL_STAT_CODE_BIRTH (# 10)

Source Code Comments

STATE CODE BIRTH: This field identifies the state where the applicant was born.

Columns Comments for SRTSUPL_NATN_CODE_BIRTH (# 11)

Source Code Comments

NATION CODE BIRTH: This field identifies the nation where the applicant was born.

Columns Comments for SRTSUPL_SBGI_CODE_ADMIT (# 12)

Source Code Comments

SBGI CODE ADMIT: This field indicates source code of the institution from which the applicant applied.

Columns Comments for SRTSUPL_ETHN_CODE_SELF (# 13)

Source Code Comments

ETHNIC CODE SELF: This field identifies the applicant?s self-reported ethnicity.

Columns Comments for SRTSUPL_ESEL_CODE (# 14)

Source Code Comments

ESEL ELIGIBILITY CODE: This indicates if the applicant has special considerations.

Columns Comments for SRTSUPL_NUMBER_DEPS (# 15)

Source Code Comments

NUMBER DEPENDENTS: This indicates the number of dependents that the applicant has.

Columns Comments for SRTSUPL_AGENCY_FILE_NO (# 16)

Source Code Comments

AGENCY FILE NUMBER: This field identifies the agency file number associated with their AMCAS application.

Columns Comments for SRTSUPL_APP_YEAR_AGENCY (# 17)

Source Code Comments

APP YEAR AGENCY: This field identifies the year of application for this application.

Columns Comments for SRTSUPL_PREV_APP_1 (# 18)

Source Code Comments

PREV APP 1: This field identifies the year of the most recent application prior to the current application.

Columns Comments for SRTSUPL_PREV_APP_2 (# 19)

Source Code Comments

PREV APP 2: This field identifies the year of the second most recent application prior to the current application.

Columns Comments for SRTSUPL_PREV_APP_3 (# 20)

Source Code Comments

PREV APP 3: This field identifies the year of the third most recent application prior to the current year.

Columns Comments for SRTSUPL_PREV_APP_4 (# 21)

Source Code Comments

PREV APP 4: This field identifies the year of the fourth most recent application prior to the current year.

Columns Comments for SRTSUPL_AGENCY_FEE_WAIVED (# 22)

Source Code Comments

AGENCY FEE WAIVED: This field indicates if the agency fee has been waived for this application.

Columns Comments for SRTSUPL_CYCLE_ADDED (# 23)

Source Code Comments

CYCLE ADDED: This field identifies the cycle in which the application was added.

Columns Comments for SRTSUPL_CYCLE_CHANGED (# 24)

Source Code Comments

CYCLE CHANGED: This field identifies the cycle in which the application was changed.

Columns Comments for SRTSUPL_AGENCY_REPORT_DATE (# 25)

Source Code Comments

AGENCY REPORT DATE: This field identifies when an admission action file was last created for this application.

Columns Comments for SRTSUPL_NEXT_MCAT_DATE (# 26)

Source Code Comments

NEXT MCAT DATE: This field identifies when this applicant may take the MCAT next.

Columns Comments for SRTSUPL_FLAG1 (# 27)

Source Code Comments

FLAG1: This field indicates if the applicant is disadvantaged.

Columns Comments for SRTSUPL_FLAG2 (# 28)

Source Code Comments

FLAG2: This field indicates if the applicant has had military service.

Columns Comments for SRTSUPL_FLAG3 (# 29)

Source Code Comments

FLAG3: This field indicates if the applicant has previously been matriculated as a medical school student.

Columns Comments for SRTSUPL_FLAG4 (# 30)

Source Code Comments

FLAG4: This field indicates if the applicant has had an institutional action taken against them.

Columns Comments for SRTSUPL_FLAG5 (# 31)

Source Code Comments

FLAG5: This field indicates if the applicant has committed a felony.

Columns Comments for SRTSUPL_FLAG6 (# 32)

Source Code Comments

FLAG6: This is a supplemental indicator field.

Columns Comments for SRTSUPL_FLAG7 (# 33)

Source Code Comments

FLAG7: This is a supplemental indicator field.

Columns Comments for SRTSUPL_FLAG8 (# 34)

Source Code Comments

FLAG8: This is a supplemental indicator field.

Columns Comments for SRTSUPL_FLAG9 (# 35)

Source Code Comments

FLAG9: This is a supplemental indicator field.

Columns Comments for SRTSUPL_FLAG10 (# 36)

Source Code Comments

FLAG10: This is a supplemental indicator field.

Columns Comments for SRTSUPL_INST_DATA1 (# 37)

Source Code Comments

INST DATA1: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA2 (# 38)

Source Code Comments

INST DATA2: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA3 (# 39)

Source Code Comments

INST DATA3: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA4 (# 40)

Source Code Comments

INST DATA4: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA5 (# 41)

Source Code Comments

INST DATA5: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA6 (# 42)

Source Code Comments

INST DATA6: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA7 (# 43)

Source Code Comments

INST DATA7: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA8 (# 44)

Source Code Comments

INST DATA8: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA9 (# 45)

Source Code Comments

INST DATA9: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA10 (# 46)

Source Code Comments

INST DATA10: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA11 (# 47)

Source Code Comments

INST DATA11: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA12 (# 48)

Source Code Comments

INST DATA12: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA13 (# 49)

Source Code Comments

INST DATA13: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA14 (# 50)

Source Code Comments

INST DATA14: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA15 (# 51)

Source Code Comments

INST DATA15: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA16 (# 52)

Source Code Comments

INST DATA16: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA17 (# 53)

Source Code Comments

INST DATA17: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA18 (# 54)

Source Code Comments

INST DATA18: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA19 (# 55)

Source Code Comments

INST DATA19: This is a supplemental data field.

Columns Comments for SRTSUPL_INST_DATA20 (# 56)

Source Code Comments

INST DATA20: This is a supplemental data field.

Columns Comments for SRTSUPL_ACTIVITY_DATE (# 57)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTSUPL table.

Columns Comments for SRTSUPL_EFFEC_DATE (# 58)

Source Code Comments

EFFECTIVE DATE: Date when the application data was last updated by AMCAS.

Columns Comments for SRTSUPL_APPL_TYPE (# 59)

Source Code Comments

APPLICATION TYPE: AMCAS application type code.

Columns Comments for SRTSUPL_BIO_NUMBER (# 60)

Source Code Comments

BIO NUMBER: Bio number assigned by AMCAS.

Columns Comments for SRTSUPL_HISP_IND (# 61)

Source Code Comments

HISP IND: AMCAS Hispanic ethnicity indicator.

Columns Comments for SRTSUPL_RACE1 (# 62)

Source Code Comments

RACE1: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE2 (# 63)

Source Code Comments

RACE2: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE3 (# 64)

Source Code Comments

RACE3: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE4 (# 65)

Source Code Comments

RACE4: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE5 (# 66)

Source Code Comments

RACE5: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE6 (# 67)

Source Code Comments

RACE6: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE7 (# 68)

Source Code Comments

RACE7: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE8 (# 69)

Source Code Comments

RACE8: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE9 (# 70)

Source Code Comments

RACE9: Race code reported by AMCAS.

Columns Comments for SRTSUPL_RACE10 (# 71)

Source Code Comments

RACE10: Race code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC1 (# 72)

Source Code Comments

ETHNIC1: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC2 (# 73)

Source Code Comments

ETHNIC2: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC3 (# 74)

Source Code Comments

ETHNIC3: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC4 (# 75)

Source Code Comments

ETHNIC4: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC5 (# 76)

Source Code Comments

ETHNIC5: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC6 (# 77)

Source Code Comments

ETHNIC6: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC7 (# 78)

Source Code Comments

ETHNIC7: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC8 (# 79)

Source Code Comments

ETHNIC8: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC9 (# 80)

Source Code Comments

ETHNIC9: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_ETHNIC10 (# 81)

Source Code Comments

ETHNIC10: Ethnic code reported by AMCAS.

Columns Comments for SRTSUPL_SCHOOL_STATE (# 82)

Source Code Comments

SCHOOL STATE: State of School reported by AMCAS.

Columns Comments for SRTSUPL_SCHOOL_NUM (# 83)

Source Code Comments

SCHOOL NUMBER: Identifier of school reported by AMCAS.

Columns Comments for SRTSUPL_DATE_APPLIED (# 84)

Source Code Comments

DATE APPLIED: First date applicant submitted data to AMCAS.

Columns Comments for SRTSUPL_EARLY_DECISION (# 85)

Source Code Comments

EARLY DECISION: Early decision is translated to a degree code reported by AMCAS.

Table SRTTELE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTTELE_RIDM	NUMBER(8,0)	No	*	*
SRTTELE_SEQNO	NUMBER(3,0)	No	*
SRTTELE_TELE_CODE	VARCHAR2(4)	No	*	*
SRTTELE_ACTIVITY_DATE	DATE	No
SRTTELE_PHONE_AREA	VARCHAR2(6)	Yes
SRTTELE_PHONE_NUMBER	VARCHAR2(12)	Yes
SRTTELE_PHONE_EXT	VARCHAR2(10)	Yes
SRTTELE_STATUS_IND	VARCHAR2(1)	Yes
SRTTELE_ATYP_CODE	VARCHAR2(2)	Yes		*
SRTTELE_ADDR_SEQNO	NUMBER(2,0)	Yes
SRTTELE_PRIMARY_IND	VARCHAR2(1)	Yes
SRTTELE_UNLIST_IND	VARCHAR2(1)	Yes
SRTTELE_COMMENT	VARCHAR2(60)	Yes
SRTTELE_INTL_ACCESS	VARCHAR2(16)	Yes
SRTTELE_CTRY_CODE_PHONE	VARCHAR2(4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTTELE_ATYP_CODE	STVATYP_CODE	STVATYP
SRTTELE_TELE_CODE	STVTELE_CODE	STVTELE
SRTTELE_RIDM	SRTPREL_RIDM	SRTPREL

Index

Index Name	Index Type	Column Name
PK_SRTTELE	Unique	SRTTELE_RIDM
PK_SRTTELE	Unique	SRTTELE_TELE_CODE
PK_SRTTELE	Unique	SRTTELE_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SRVPREL	SQL View	S10B80.BANINST1	Use (select)
PROSPECT_TELE_REC	Oracle Package Type	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
TELE1_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE1_INTL_ACCESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE1_PHONE_AREA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE1_PHONE_EXT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE1_PHONE_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE2_ATYP_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE2_INTL_ACCESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE2_PHONE_AREA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE2_PHONE_EXT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE2_PHONE_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE3_INTL_ACCESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE3_PHONE_AREA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE3_PHONE_EXT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE3_PHONE_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE3_TELE_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE4_INTL_ACCESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE4_PHONE_AREA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE4_PHONE_EXT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE4_PHONE_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE4_TELE_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE5_INTL_ACCESS	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE5_PHONE_AREA	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE5_PHONE_EXT	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE5_PHONE_NUMBER	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TELE5_TELE_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
SRTTELE_PREV_APPC	Oracle Package Cursor	S10B80.BANINST1.BWSKAADR	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
F_BUILD_SRTTELE_REC	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTTELE	Use (delete)
P_EVALUATE_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SRTTELE	Use (Insert)Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPRADDR	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_INSERT_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SPRTELE	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SRTTELE	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_PROSPECT_TELE_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_PROSPECT_TELE	Use (select)
SRTTELE	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_SRTTELE	SQL Index	S10B80.SATURN	Rely On
SRTPREL	SQL Table	S10B80.SATURN	Join
STVATYP	SQL Table	S10B80.SATURN	Refer (no action)
STVTELE	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTTELE

Object Dates

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

Source Code Comments

Electronic Prospect telephone numbers loaded from search and test score tapes, or entered on Web for Prospects.

Columns Comments for SRTTELE_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTTELE_SEQNO (# 2)

Source Code Comments

Unique sequence number for telephone numbers associated with RIDM.

Columns Comments for SRTTELE_TELE_CODE (# 3)

Source Code Comments

Telelphone Type Code.

Columns Comments for SRTTELE_ACTIVITY_DATE (# 4)

Source Code Comments

Date of last activity for telephone record.

Columns Comments for SRTTELE_PHONE_AREA (# 5)

Source Code Comments

Telephone number area code.

Columns Comments for SRTTELE_PHONE_NUMBER (# 6)

Source Code Comments

Telephone number.

Columns Comments for SRTTELE_PHONE_EXT (# 7)

Source Code Comments

Telephone number extention.

Columns Comments for SRTTELE_STATUS_IND (# 8)

Source Code Comments

Status of telelphone number, active or inactive.

Columns Comments for SRTTELE_ATYP_CODE (# 9)

Source Code Comments

Optional Address Type code associated with telephone number.

Columns Comments for SRTTELE_ADDR_SEQNO (# 10)

Source Code Comments

Address type sequence number associated with address type.

Columns Comments for SRTTELE_PRIMARY_IND (# 11)

Source Code Comments

Primary indicator to denote primary telephone numbers based on telephone types.

Columns Comments for SRTTELE_UNLIST_IND (# 12)

Source Code Comments

Unlisted telephone number indicator.

Columns Comments for SRTTELE_COMMENT (# 13)

Source Code Comments

Comment relating to telephone number.

Columns Comments for SRTTELE_INTL_ACCESS (# 14)

Source Code Comments

Free format International access code for telephone number including country and city code.

Columns Comments for SRTTELE_CTRY_CODE_PHONE (# 15)

Source Code Comments

COUNTRY CODE: Telephone code that designates the region and country.

Table SRTTEST

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTTEST_RIDM	NUMBER(8,0)	No	*
SRTTEST_TESC_CODE	VARCHAR2(4)	No	*	*
SRTTEST_TEST_DATE	DATE	No	*
SRTTEST_TEST_SCORE	VARCHAR2(5)	No
SRTTEST_ACTIVITY_DATE	DATE	No
SRTTEST_TSRC_CODE	VARCHAR2(4)	Yes
SRTTEST_TADM_CODE	VARCHAR2(2)	Yes		*
SRTTEST_TEST_DAY	VARCHAR2(2)	Yes
SRTTEST_TEST_MON	VARCHAR2(2)	Yes
SRTTEST_TEST_YEAR	VARCHAR2(2)	Yes
SRTTEST_TEST_CENTURY	VARCHAR2(2)	Yes
SRTTEST_RCRV_IND	VARCHAR2(1)	Yes
SRTTEST_SAT_ESSAY_ID	VARCHAR2(10)	Yes
SRTTEST_TEFR_CODE	VARCHAR2(2)	Yes		*
SRTTEST_TEAC_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTTEST_TADM_CODE	STVTADM_CODE	STVTADM
SRTTEST_TEAC_CODE	STVTEAC_CODE	STVTEAC
SRTTEST_TEFR_CODE	STVTEFR_CODE	STVTEFR
SRTTEST_TESC_CODE	STVTESC_CODE	STVTESC

Index

Index Name	Index Type	Column Name
PK_SRTTEST	Unique	SRTTEST_RIDM
PK_SRTTEST	Unique	SRTTEST_TESC_CODE
PK_SRTTEST	Unique	SRTTEST_TEST_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
TEST1_SCORE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST1_TESC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST2_SCORE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST2_TESC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST3_SCORE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST3_TESC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST4_SCORE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST4_TESC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST5_SCORE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
TEST5_TESC_CODE	Oracle Package Variable	S10B80.BANINST1.BWSKWPRO	Rely On
P_INSERTDATAINTOTABLES	Oracle Package Procedure	S10B80.BANINST1.BWSKWPRV	Use (Insert)
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
SRTTEST	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_SRTTEST	SQL Index	S10B80.SATURN	Rely On
STVTADM	SQL Table	S10B80.SATURN	Refer (no action)
STVTEAC	SQL Table	S10B80.SATURN	Refer (no action)
STVTEFR	SQL Table	S10B80.SATURN	Refer (no action)
STVTESC	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTTEST

Object Dates

Creation Date	Analysis Date
04/02/2008 20:51:31:000	04/02/2008 21:18:13:000

Source Code Comments

Electronic Prospect test scores loaded from test score tapes and entered on Web for Prospects.

Columns Comments for SRTTEST_RIDM (# 1)

Source Code Comments

Unique ID of Electronic Prospect.

Columns Comments for SRTTEST_TESC_CODE (# 2)

Source Code Comments

This field identifies the Test Score Code associated with various tests,ie., SAT, ACT, placement scores.

Columns Comments for SRTTEST_TEST_DATE (# 3)

Source Code Comments

This field identifies the date a particular test was taken.

Columns Comments for SRTTEST_TEST_SCORE (# 4)

Source Code Comments

This field identifies a particular test score.

Columns Comments for SRTTEST_ACTIVITY_DATE (# 5)

Source Code Comments

This field identifies the last date the SORTEST record was updated.

Columns Comments for SRTTEST_TSRC_CODE (# 6)

Source Code Comments

This field identifies the source, or how the test score was entered, ie., magnetic tape, self reported.

Columns Comments for SRTTEST_TADM_CODE (# 7)

Source Code Comments

This field identifies the administrative type of a particular test, ie.,locally or nationally administered.

Columns Comments for SRTTEST_TEST_DAY (# 8)

Source Code Comments

This field identifies the day a particular test was taken.

Columns Comments for SRTTEST_TEST_MON (# 9)

Source Code Comments

This field identifies the month a particular test was taken.

Columns Comments for SRTTEST_TEST_YEAR (# 10)

Source Code Comments

This field identifies the year a particular test was taken.

Columns Comments for SRTTEST_TEST_CENTURY (# 11)

Source Code Comments

This field identifies the century a particular test was taken.

Columns Comments for SRTTEST_RCRV_IND (# 12)

Source Code Comments

Indicates whether SAT score has been Recentered and/or Revised.

Columns Comments for SRTTEST_SAT_ESSAY_ID (# 13)

Source Code Comments

SAT Essay ID to view the prospects essay on the SAT website.

Columns Comments for SRTTEST_TEFR_CODE (# 14)

Source Code Comments

TEST FORM CODE: Test Form Used for which the test score is being reported.

Columns Comments for SRTTEST_TEAC_CODE (# 15)

Source Code Comments

TEST ACCOMMODATION CODE: Test Accommodation for which the test score is being reported.

Table SRTTPFD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
SRTTPFD_TAPE_CODE	VARCHAR2(10)	No	*
SRTTPFD_REC_NUMBER	NUMBER(2,0)	No	*
SRTTPFD_TPFD_CODE	VARCHAR2(40)	No
SRTTPFD_START_POS	NUMBER(5,0)	No	*
SRTTPFD_END_POS	NUMBER(5,0)	Yes
SRTTPFD_ACTIVITY_DATE	DATE	No
SRTTPFD_OCC	NUMBER(3,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SRTTPFD	Unique	SRTTPFD_TAPE_CODE
PK_SRTTPFD	Unique	SRTTPFD_REC_NUMBER
PK_SRTTPFD	Unique	SRTTPFD_START_POS
SRTTPFD_KEY_INDEX	Unique	SRTTPFD_TAPE_CODE
SRTTPFD_KEY_INDEX	Unique	SRTTPFD_REC_NUMBER
SRTTPFD_KEY_INDEX	Unique	SRTTPFD_TPFD_CODE
SRTTPFD_KEY_INDEX	Unique	SRTTPFD_OCC

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_SRTTPFD	SQL Index	S10B80.SATURN	Rely On
SRTTPFD_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTTPFD

Object Dates

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

Source Code Comments

Rule Table to identify the position and length of data items on Electronic Prospect Tapes.

Columns Comments for SRTTPFD_TAPE_CODE (# 1)

Source Code Comments

Tape Code that identifies the Electronic Prospect Tape.

Columns Comments for SRTTPFD_REC_NUMBER (# 2)

Source Code Comments

The record number for an individual on a prospect tape. Some tapes split the data for an individual on two lines, this will indicate the line number the data exists on.

Columns Comments for SRTTPFD_TPFD_CODE (# 3)

Source Code Comments

Code to identify the Electronic Prospect Tape data item.

Columns Comments for SRTTPFD_START_POS (# 4)

Source Code Comments

Numeric position of where the data item begins on the Prospect Tape.

Columns Comments for SRTTPFD_END_POS (# 5)

Source Code Comments

Numeric value of the last position of the data item on the Prospect Tape.

Columns Comments for SRTTPFD_OCC (# 7)

Source Code Comments

Numeric value of the occurrence of the data item on the Prospect Tape. This will be implemented with a future release of the search tape module.

Table SRTTSPC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SRTTSPC_RIDM	NUMBER(8,0)	No	*
SRTTSPC_TESC_CODE	VARCHAR2(4)	No	*	*
SRTTSPC_TEST_DATE	DATE	No	*
SRTTSPC_TSPT_CODE	VARCHAR2(10)	No	*	*
SRTTSPC_PERCENTILE	VARCHAR2(10)	No
SRTTSPC_ACTIVITY_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SRTTSPC_TSPT_CODE	STVTSPT_CODE	STVTSPT
SRTTSPC_TESC_CODE	STVTESC_CODE	STVTESC

Index

Index Name	Index Type	Column Name
PK_SRTTSPC	Unique	SRTTSPC_RIDM
PK_SRTTSPC	Unique	SRTTSPC_TESC_CODE
PK_SRTTSPC	Unique	SRTTSPC_TEST_DATE
PK_SRTTSPC	Unique	SRTTSPC_TSPT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_INSERT_SORTSPC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_SORTSPC	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)Rely On
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_PROCESS_SRTTEST	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (select)
SRTTSPC	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_SRTTSPC	SQL Index	S10B80.SATURN	Rely On
STVTESC	SQL Table	S10B80.SATURN	Refer (no action)
STVTSPT	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SRTTSPC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:45:55:000	04/02/2008 21:18:09:000

Source Code Comments

Temporary Test Percentile Table.

Columns Comments for SRTTSPC_RIDM (# 1)

Source Code Comments

RIDM: RIDM for which the Percentiles will be stored.

Columns Comments for SRTTSPC_TESC_CODE (# 2)

Source Code Comments

TEST CODE: This field identifies the Test code for which the percentiles are reported.

Columns Comments for SRTTSPC_TEST_DATE (# 3)

Source Code Comments

TEST DATE: The date that the test was taken.

Columns Comments for SRTTSPC_TSPT_CODE (# 4)

Source Code Comments

TEST PERCENTILE TYPE: The Type of Percentile being reported.

Columns Comments for SRTTSPC_PERCENTILE (# 5)

Source Code Comments

PERCENTILE: This field indicates the percentile associated with the test code and type.

Columns Comments for SRTTSPC_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the SRTTSPC table.

Link between SRTADDR and PK_SRTADDR

Link List

Link Type	Link	Project
Rely On	Link Between SRTADDR and PK_SRTADDR	SATURN

List of Real links

Link type	Between	And
Rely On	SRTADDR	PK_SRTADDR

Link between SRTPERS and PK_SRTPERS

Link List

Link Type	Link	Project
Rely On	Link Between SRTPERS and PK_SRTPERS	SATURN

List of Real links

Link type	Between	And
Rely On	SRTPERS	PK_SRTPERS

Link between SRTINTL and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTINTL and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTINTL	SRTPREL

Link between SRTEMAL and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTEMAL and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTEMAL	SRTPREL

Link between SRTHSCH and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTHSCH and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTHSCH	SRTPREL

Link between SRTPERS and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTPERS and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTPERS	SRTPREL

Link between SRTTELE and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTTELE and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTTELE	SRTPREL

Link between SRTADDR and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTADDR and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTADDR	SRTPREL

Link between SRTIDEN and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTIDEN and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTIDEN	SRTPREL

Link between SRTSUPL and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTSUPL and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTSUPL	SRTPREL

Link between SRTPCOL and SRTPREL

Join Information

Objects list
schema-view : S10B80.BANINST1.SRVPREL

Link List

Link Type	Link	Project
Join	Link Between SRTPCOL and SRTPREL	SATURN

List of Real links

Link type	Between	And
Join	SRTPCOL	SRTPREL

Link between SRTPERS and SRTEMAL

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between SRTPERS and SRTEMAL	SATURN

List of Real links

Link type	Between	And
Join	SRTPERS	SRTEMAL

Link between SRTIDEN and SRTPERS

Join Information

Objects list
scope-procedure : S10B80.BANINST1.SRKPREL.P_INSERT_SPRIDEN scope-procedure : S10B80.BANINST1.SRKPREL.P_MIGRATE_PROSPECT

Link List

Link Type	Link	Project
Join	Link Between SRTIDEN and SRTPERS	SATURN

List of Real links

Link type	Between	And
Join	SRTIDEN	SRTPERS

Link between SRBWPDS and PK_SRBWPDS

Link List

Link Type	Link	Project
Rely On	Link Between SRBWPDS and PK_SRBWPDS	SATURN

List of Real links

Link type	Between	And
Rely On	SRBWPDS	PK_SRBWPDS

Link between SRRRSRC and PK_SRRRSRC

Link List

Link Type	Link	Project
Rely On	Link Between SRRRSRC and PK_SRRRSRC	SATURN

List of Real links

Link type	Between	And
Rely On	SRRRSRC	PK_SRRRSRC

Link between SRBWPRO and PK_SRBWPRO

Link List

Link Type	Link	Project
Rely On	Link Between SRBWPRO and PK_SRBWPRO	SATURN

List of Real links

Link type	Between	And
Rely On	SRBWPRO	PK_SRBWPRO

Link between SRTIDEN and PK_SRTIDEN

Link List

Link Type	Link	Project
Rely On	Link Between SRTIDEN and PK_SRTIDEN	SATURN

List of Real links

Link type	Between	And
Rely On	SRTIDEN	PK_SRTIDEN

Link between SRTMAJR and PK_SRTMAJR

Link List

Link Type	Link	Project
Rely On	Link Between SRTMAJR and PK_SRTMAJR	SATURN

List of Real links

Link type	Between	And
Rely On	SRTMAJR	PK_SRTMAJR

Link between SRTSUPL and PK_SRTSUPL

Link List

Link Type	Link	Project
Rely On	Link Between SRTSUPL and PK_SRTSUPL	SATURN

List of Real links

Link type	Between	And
Rely On	SRTSUPL	PK_SRTSUPL

Link between SRRVIST and PK_SRRVIST

Link List

Link Type	Link	Project
Rely On	Link Between SRRVIST and PK_SRRVIST	SATURN

List of Real links

Link type	Between	And
Rely On	SRRVIST	PK_SRRVIST

Link between SRTDEGR and PK_SRTDEGR

Link List

Link Type	Link	Project
Rely On	Link Between SRTDEGR and PK_SRTDEGR	SATURN

List of Real links

Link type	Between	And
Rely On	SRTDEGR	PK_SRTDEGR

Link between SRTMATL and PK_SRTMATL

Link List

Link Type	Link	Project
Rely On	Link Between SRTMATL and PK_SRTMATL	SATURN

List of Real links

Link type	Between	And
Rely On	SRTMATL	PK_SRTMATL

Link between SRTTSPC and PK_SRTTSPC

Link List

Link Type	Link	Project
Rely On	Link Between SRTTSPC and PK_SRTTSPC	SATURN

List of Real links

Link type	Between	And
Rely On	SRTTSPC	PK_SRTTSPC

Link between SRTLEND and PK_SRTLEND

Link List

Link Type	Link	Project
Rely On	Link Between SRTLEND and PK_SRTLEND	SATURN

List of Real links

Link type	Between	And
Rely On	SRTLEND	PK_SRTLEND

Link between SRRTPTS and PK_SRRTPTS

Link List

Link Type	Link	Project
Rely On	Link Between SRRTPTS and PK_SRRTPTS	SATURN

List of Real links

Link type	Between	And
Rely On	SRRTPTS	PK_SRRTPTS

Link between SRTINTS and PK_SRTINTS

Link List

Link Type	Link	Project
Rely On	Link Between SRTINTS and PK_SRTINTS	SATURN

List of Real links

Link type	Between	And
Rely On	SRTINTS	PK_SRTINTS

Link between SRTTELE and PK_SRTTELE

Link List

Link Type	Link	Project
Rely On	Link Between SRTTELE and PK_SRTTELE	SATURN

List of Real links

Link type	Between	And
Rely On	SRTTELE	PK_SRTTELE

Link between SRRWACK and PK_SRRWACK

Link List

Link Type	Link	Project
Rely On	Link Between SRRWACK and PK_SRRWACK	SATURN

List of Real links

Link type	Between	And
Rely On	SRRWACK	PK_SRRWACK

Link between SRTTEST and PK_SRTTEST

Link List

Link Type	Link	Project
Rely On	Link Between SRTTEST and PK_SRTTEST	SATURN

List of Real links

Link type	Between	And
Rely On	SRTTEST	PK_SRTTEST

Link between SRBPRED and PK_SRBPRED

Link List

Link Type	Link	Project
Rely On	Link Between SRBPRED and PK_SRBPRED	SATURN

List of Real links

Link type	Between	And
Rely On	SRBPRED	PK_SRBPRED

Link between SRBRECR and PK_SRBRECR

Link List

Link Type	Link	Project
Rely On	Link Between SRBRECR and PK_SRBRECR	SATURN

List of Real links

Link type	Between	And
Rely On	SRBRECR	PK_SRBRECR

Link between SRRRSRC and SRBRECR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SRRRSRC and SRBRECR (FK1_SRRRSRC_INV_SRBRECR_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SRRRSRC	SRRRSRC_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR	(1,1)-(0,n)
SRRRSRC	SRRRSRC_PIDM	SRBRECR_PIDM	SRBRECR	(1,1)-(0,n)
SRRRSRC	SRRRSRC_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR	(1,1)-(0,n)

Link between SRTPRAC and PK_SRTPRAC

Link List

Link Type	Link	Project
Rely On	Link Between SRTPRAC and PK_SRTPRAC	SATURN

List of Real links

Link type	Between	And
Rely On	SRTPRAC	PK_SRTPRAC

Link between SRTPREL and PK_SRTPREL

Link List

Link Type	Link	Project
Rely On	Link Between SRTPREL and PK_SRTPREL	SATURN

List of Real links

Link type	Between	And
Rely On	SRTPREL	PK_SRTPREL

Link between SRRRATT and PK_SRRRATT

Link List

Link Type	Link	Project
Rely On	Link Between SRRRATT and PK_SRRRATT	SATURN

List of Real links

Link type	Between	And
Rely On	SRRRATT	PK_SRRRATT

Link between SRTCRSS and PK_SRTCRSS

Link List

Link Type	Link	Project
Rely On	Link Between SRTCRSS and PK_SRTCRSS	SATURN

List of Real links

Link type	Between	And
Rely On	SRTCRSS	PK_SRTCRSS

Link between SRTHSCH and PK_SRTHSCH

Link List

Link Type	Link	Project
Rely On	Link Between SRTHSCH and PK_SRTHSCH	SATURN

List of Real links

Link type	Between	And
Rely On	SRTHSCH	PK_SRTHSCH

Link between SRTPCOL and PK_SRTPCOL

Link List

Link Type	Link	Project
Rely On	Link Between SRTPCOL and PK_SRTPCOL	SATURN

List of Real links

Link type	Between	And
Rely On	SRTPCOL	PK_SRTPCOL

Link between SRTEMAL and PK_SRTEMAL

Link List

Link Type	Link	Project
Rely On	Link Between SRTEMAL and PK_SRTEMAL	SATURN

List of Real links

Link type	Between	And
Rely On	SRTEMAL	PK_SRTEMAL

Link between SRRCHRT and PK_SRRCHRT

Link List

Link Type	Link	Project
Rely On	Link Between SRRCHRT and PK_SRRCHRT	SATURN

List of Real links

Link type	Between	And
Rely On	SRRCHRT	PK_SRRCHRT

Link between SRRCHRT and SRBRECR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SRRCHRT and SRBRECR (FK1_SRRCHRT_INV_SRBRECR_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SRRCHRT	SRRCHRT_PIDM	SRBRECR_PIDM	SRBRECR	(1,1)-(0,n)
SRRCHRT	SRRCHRT_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR	(1,1)-(0,n)
SRRCHRT	SRRCHRT_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR	(1,1)-(0,n)

Link between SRRLEND and PK_SRRLEND

Link List

Link Type	Link	Project
Rely On	Link Between SRRLEND and PK_SRRLEND	SATURN

List of Real links

Link type	Between	And
Rely On	SRRLEND	PK_SRRLEND

Link between SRRLEND and SRBRECR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SRRLEND and SRBRECR (FK1_SRRLEND_INV_SRBRECR_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SRRLEND	SRRLEND_PIDM	SRBRECR_PIDM	SRBRECR	(1,1)-(0,n)
SRRLEND	SRRLEND_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR	(1,1)-(0,n)
SRRLEND	SRRLEND_ADMIN_SEQNO	SRBRECR_ADMIN_SEQNO	SRBRECR	(1,1)-(0,n)

Link between SRTGPAT and PK_SRTGPAT

Link List

Link Type	Link	Project
Rely On	Link Between SRTGPAT and PK_SRTGPAT	SATURN

List of Real links

Link type	Between	And
Rely On	SRTGPAT	PK_SRTGPAT

Link between SRTTPFD and PK_SRTTPFD

Link List

Link Type	Link	Project
Rely On	Link Between SRTTPFD and PK_SRTTPFD	SATURN

List of Real links

Link type	Between	And
Rely On	SRTTPFD	PK_SRTTPFD