Model Faculty Load*

Model Label : Faculty Load SI% tables and some support tables

List of Objects

Object Name	Object Type	Layer Name
PK_SIBFACD	SQL Index	Default
PK_SIBINST	SQL Index	Default
PK_SIBTERM	SQL Index	Default
PK_SIRASGN	SQL Index	Default
PK_SIRCOLC	SQL Index	Default
PK_SIRCOLR	SQL Index	Default
PK_SIRLVAS	SQL Index	Default
PK_SIROFFC	SQL Index	Default
SIBCFTE	SQL Table	Default
SIBFACD	SQL Table	Default
SIBFACD_TMP	SQL Table	Default
SIBINST	SQL Table	Default
SIBTERM	SQL Table	Default
SIRASGN	SQL Table	Default
SIRATTR	SQL Table	Default
SIRCMNT	SQL Table	Default
SIRCOLC	SQL Table	Default
SIRCOLR	SQL Table	Default
SIRDPCL	SQL Table	Default
SIRFCNT	SQL Table	Default
SIRFLCT	SQL Table	Default
SIRFLRC	SQL Table	Default
SIRFLRT	SQL Table	Default
SIRICNT	SQL Table	Default
SIRLVAS	SQL Table	Default
SIRNIST	SQL Table	Default
SIRNLVA	SQL Table	Default
SIROFFC	SQL Table	Default

Model View

Index PK_SIBFACD

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIBFACD_PIDM	NUMBER	8	8

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBFACD	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_SIBFACD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:11:000	04/02/2008 20:58:11:000

Index PK_SIBINST

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIBINST_PIDM	NUMBER	8	8
SIBINST_TERM_CODE_EFF	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBINST	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_SIBINST

Object Dates

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

Index PK_SIBTERM

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIBTERM_TERM_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBTERM	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_SIBTERM

Object Dates

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

Index PK_SIRASGN

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIRASGN_TERM_CODE	VARCHAR2	6	0
SIRASGN_CRN	VARCHAR2	5	0
SIRASGN_PIDM	NUMBER	8	8
SIRASGN_CATEGORY	VARCHAR2	2	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRASGN	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_SIRASGN

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:24:000	04/02/2008 20:58:24:000

Index PK_SIRCOLC

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIRCOLC_SESSIONID	VARCHAR2	10	0
SIRCOLC_FATT_CODE	VARCHAR2	4	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRCOLC	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_SIRCOLC

Object Dates

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

Index PK_SIRCOLR

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIRCOLR_SESSIONID	VARCHAR2	30	0
SIRCOLR_PIDM	NUMBER	8	8
SIRCOLR_TERM_CODE	VARCHAR2	6	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRCOLR	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_SIRCOLR

Object Dates

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

Index PK_SIRLVAS

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

Index Columns information

Column Name	Column Type	Column Length	Column precision
SIRLVAS_TERM_CODE	VARCHAR2	6	0
SIRLVAS_CRN	VARCHAR2	5	0
SIRLVAS_PIDM	NUMBER	8	8
SIRLVAS_CATEGORY	VARCHAR2	2	0

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRLVAS	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_SIRLVAS

Object Dates

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

Index PK_SIROFFC

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

Index Columns information

Column Name	Column Type	Column Length
SIROFFC_TERM_CODE	VARCHAR2	6
SIROFFC_CRN	VARCHAR2	30
SIROFFC_FROM_DATE	DATE	7
SIROFFC_TO_DATE	DATE	7
SIROFFC_FROM_TIME	VARCHAR2	4
SIROFFC_TO_TIME	VARCHAR2	4

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIROFFC	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_SIROFFC

Object Dates

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

Table SIBCFTE

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIBCFTE_FCNT_CODE	VARCHAR2(2)	No	*
SIBCFTE_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIBCFTE_FTE_FACTOR	NUMBER(3,0)	No
SIBCFTE_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBCFTE_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIBCFTE_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIBCFTE_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR
SIBCFTE_TERM_CODE_EFF	SIRCOLR_TERM_CODE_EFF	SIRCOLR

Index

Index Name	Index Type	Column Name
SIBCFTE_KEY_INDEX		SIBCFTE_FCNT_CODE
SIBCFTE_KEY_INDEX		SIBCFTE_TERM_CODE_EFF

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIVCONT	SQL View	S10B80.BANINST1	Use (select)
F_GET_MIN_SIBCFTE_FTE_FACTOR	SQL Function	S10B80.BANINST1	Use (select)
F_GET_MIN_SIBCFTE_FTE_TERM	SQL Function	S10B80.BANINST1	Use (select)
SIBCFTE	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
SIBCFTE_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SIRCOLR	SQL Table	S10B80.SATURN	Join
STVFCNT	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.SIBCFTE

Object Dates

Creation Date	Analysis Date
04/02/2008 20:43:48:000	04/02/2008 21:18:07:000

Source Code Comments

Faculty Workload Contract FTE Rule Table

Columns Comments for SIBCFTE_FCNT_CODE (# 1)

Source Code Comments

The faculty member workload rule contract code

Columns Comments for SIBCFTE_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member workload FTE

Columns Comments for SIBCFTE_FTE_FACTOR (# 3)

Source Code Comments

The full time equivalent factor

Columns Comments for SIBCFTE_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIBFACD

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIBFACD_PIDM	NUMBER(8,0)	No	*	*
SIBFACD_1ST_APPT_DATE	DATE	Yes
SIBFACD_RANK_CODE	VARCHAR2(1)	Yes
SIBFACD_RANK_DATE	DATE	Yes
SIBFACD_DISP_CODE	VARCHAR2(3)	Yes
SIBFACD_TENR_CODE	VARCHAR2(2)	Yes		*
SIBFACD_TENURE_DATE	DATE	Yes
SIBFACD_TENURE_REV_DATE	DATE	Yes
SIBFACD_LAST_SABB_DATE	DATE	Yes
SIBFACD_NEXT_SABB_DATE	DATE	Yes
SIBFACD_YRS_EXP	NUMBER(2,0)	Yes
SIBFACD_BIRTH_STATE	VARCHAR2(3)	Yes
SIBFACD_AAUP_MEM_IND	VARCHAR2(1)	Yes
SIBFACD_ACTIVITY_DATE	DATE	No
SIBFACD_ACADEMIC_TITLE	VARCHAR2(60)	Yes
SIBFACD_PRIMARY_ACTIVITY	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBFACD_TENR_CODE	PTRTENR_CODE	PTRTENR
SIBFACD_PIDM	SIBINST_PIDM	SIBINST

Index

Index Name	Index Type	Column Name
PK_SIBFACD	Unique	SIBFACD_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTVDISP	SQL Table	S10B80.PAYROLL	Join
PTVRANK	SQL Table	S10B80.PAYROLL	Join
STVSTAT	SQL Table	S10B80.SATURN	Join
ST_SIBFACD_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
PPVFACD	SQL View	S10B80.BANINST1	Use (select)
SIVFACD	SQL View	S10B80.BANINST1	Use (select)
SIVFACD_OJ	SQL View	S10B80.BANINST1	Use (select)
SIVFACL	SQL View	S10B80.BANINST1	Use (select)
F_GET_SIBFACD_TENR_CODE	SQL Function	S10B80.BANINST1	Rely On
F_GET_SIBFACD_TENR_CODE	SQL Function	S10B80.BANINST1	Use (select)Rely On
F_GET_SIBFACD_VALUE	SQL Function	S10B80.BANINST1	Rely On
F_GET_SIBFACD_VALUE	SQL Function	S10B80.BANINST1	Use (select)
ACADEMIC_TITLE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
ACADEMIC_TITLE_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
P_GETFACULTYRANKANDTENURE	Oracle Package Procedure	S10B80.BANINST1.PEKWEMP	Use (select)
F_GETTENUREDESC	Oracle Package Function	S10B80.BANINST1.BWPKSJOB	Use (select)
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.ICSPKLDI	Rely On
F_GET_ACADEMIC_TITLE	Oracle Package Function	S10B80.BANINST1.ICSPKCOM	Rely On
F_GET_PERSON_DETAILS	Oracle Package Function	S10B80.BANINST1.VIJAYSPKLDI	Rely On
F_GET_RANK_CODE	Oracle Package Function	S10B80.BANINST1.NBKBUDG	Use (select)
F_GET_SIBFACD_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Rely On
F_GET_SIBFACD_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Use (select)
SIBFACD	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_SIBFACD	SQL Index	S10B80.SATURN	Rely On
PTRTENR	SQL Table	S10B80.PAYROLL	Refer (no action)
SIBINST	SQL Table	S10B80.SATURN	Join
ST_SIBFACD_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SIBFACD_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.SIBFACD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:11:000	04/02/2008 21:18:19:000

Source Code Comments

Faculty Information Table

Columns Comments for SIBFACD_PIDM (# 1)

Source Code Comments

Faculty pidm

Columns Comments for SIBFACD_1ST_APPT_DATE (# 2)

Source Code Comments

First Appointment Date

Columns Comments for SIBFACD_RANK_CODE (# 3)

Source Code Comments

Faculty Rank Code

Columns Comments for SIBFACD_RANK_DATE (# 4)

Source Code Comments

Faculty Rank Code Date

Columns Comments for SIBFACD_DISP_CODE (# 5)

Source Code Comments

Faculty Discipline Code

Columns Comments for SIBFACD_TENR_CODE (# 6)

Source Code Comments

Faculty Tenure Code

Columns Comments for SIBFACD_TENURE_DATE (# 7)

Source Code Comments

Faculty Tenure Date

Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)

Source Code Comments

Faculty Tenure Review Date

Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)

Source Code Comments

Faculty Last Sabbatical Date

Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)

Source Code Comments

Faculty Next Sabbatical Date

Columns Comments for SIBFACD_YRS_EXP (# 11)

Source Code Comments

Years Experience

Columns Comments for SIBFACD_BIRTH_STATE (# 12)

Source Code Comments

State of Birth

Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)

Source Code Comments

American Association of University Professors member indicator

Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)

Source Code Comments

Activity Date

Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)

Source Code Comments

ACADEMIC TITLE: The formal title of this faculty member.

Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)

Source Code Comments

Indicate whether primary activity is Instructional, Research or Administrative.

Table SIBFACD_TMP

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
SIBFACD_PIDM	NUMBER(8,0)	No
SIBFACD_1ST_APPT_DT	DATE	Yes
SIBFACD_RANK_CODE	VARCHAR2(1)	Yes
SIBFACD_RANK_DATE	DATE	Yes
SIBFACD_DISP_CODE	VARCHAR2(3)	Yes
SIBFACD_TENR_CODE	VARCHAR2(2)	Yes
SIBFACD_TENURE_DATE	DATE	Yes
SIBFACD_TENURE_REV_DATE	DATE	Yes
SIBFACD_LAST_SABB_DATE	DATE	Yes
SIBFACD_NEXT_SABB_DATE	DATE	Yes
SIBFACD_YRS_EXP	NUMBER(2,0)	Yes
SIBFACD_BIRTH_STATE	VARCHAR2(3)	Yes
SIBFACD_AAUP_MEM_IND	VARCHAR2(1)	Yes
SIBFACD_ACTIVITY_DATE	DATE	No
SIBFACD_ACADEMIC_TITLE	VARCHAR2(60)	Yes
SIBFACD_PRIMARY_ACTIVITY	VARCHAR2(1)	Yes

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIBFACD_TMP

Object Dates

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

Source Code Comments

Faculty Information Table

Columns Comments for SIBFACD_PIDM (# 1)

Source Code Comments

Faculty pidm

Columns Comments for SIBFACD_1ST_APPT_DT (# 2)

Source Code Comments

First Appointment Date

Columns Comments for SIBFACD_RANK_CODE (# 3)

Source Code Comments

Faculty Rank Code

Columns Comments for SIBFACD_RANK_DATE (# 4)

Source Code Comments

Faculty Rank Code Date

Columns Comments for SIBFACD_DISP_CODE (# 5)

Source Code Comments

Faculty Discipline Code

Columns Comments for SIBFACD_TENR_CODE (# 6)

Source Code Comments

Faculty Tenure Code

Columns Comments for SIBFACD_TENURE_DATE (# 7)

Source Code Comments

Faculty Tenure Date

Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)

Source Code Comments

Faculty Tenure Review Date

Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)

Source Code Comments

Faculty Last Sabbatical Date

Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)

Source Code Comments

Faculty Next Sabbatical Date

Columns Comments for SIBFACD_YRS_EXP (# 11)

Source Code Comments

Years Experience

Columns Comments for SIBFACD_BIRTH_STATE (# 12)

Source Code Comments

State of Birth

Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)

Source Code Comments

American Association of University Professors member indicator

Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)

Source Code Comments

Activity Date

Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)

Source Code Comments

ACADEMIC TITLE: The formal title of this faculty member.

Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)

Source Code Comments

Indicate whether primary activity is Instructional, Research or Administrative.

Table SIBINST

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIBINST_PIDM	NUMBER(8,0)	No	*	*
SIBINST_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SIBINST_FCST_CODE	VARCHAR2(2)	No		*
SIBINST_FCTG_CODE	VARCHAR2(6)	Yes		*
SIBINST_FSTP_CODE	VARCHAR2(4)	Yes		*
SIBINST_FCNT_CODE	VARCHAR2(2)	Yes		*
SIBINST_SCHD_IND	VARCHAR2(1)	Yes
SIBINST_ADVR_IND	VARCHAR2(1)	Yes
SIBINST_FCST_DATE	DATE	No
SIBINST_WKLD_CODE	VARCHAR2(6)	Yes		*
SIBINST_CNTR_CODE	VARCHAR2(6)	Yes		*
SIBINST_APPOINT_DATE	DATE	Yes
SIBINST_ACTIVITY_DATE	DATE	No
SIBINST_DATA_ORIGIN	VARCHAR2(30)	Yes
SIBINST_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBINST_FCST_CODE	STVFCST_CODE	STVFCST
SIBINST_FCTG_CODE	STVFCTG_CODE	STVFCTG
SIBINST_FSTP_CODE	STVFSTP_CODE	STVFSTP
SIBINST_CNTR_CODE	STVCNTR_CODE	STVCNTR
SIBINST_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIBINST_WKLD_CODE	STVWKLD_CODE	STVWKLD
SIBINST_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIBINST_PIDM	SIRASGN_PIDM	SIRASGN

Index

Index Name	Index Type	Column Name
PK_SIBINST	Unique	SIBINST_PIDM
PK_SIBINST	Unique	SIBINST_TERM_CODE_EFF

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBFACD	SQL Table	S10B80.SATURN	Join
SIRDPCL	SQL Table	S10B80.SATURN	Join
SIRICNT	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
ST_SIBINST_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
SIVFAC2	SQL View	S10B80.BANINST1	Use (select)
SIVFACL	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_1	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_11	SQL View	S10B80.BANINST1	Use (select)
SIVFACQ	SQL View	S10B80.BANINST1	Use (select)
SIVINST	SQL View	S10B80.BANINST1	Use (select)
F_GET_MAX_SIVFAC_TERM	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_FACULTY_IND	SQL Function	S10B80.BANINST1	Use (select)
FACULTY_REC	Oracle Package Type	S10B80.BANINST1.SB_FACULTY	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
F_BUILD_SIBINST_REC	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_HAS_ROLE	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
FACULTY_STVTERMC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Use (select)
SIBINSTC	Oracle Package Cursor	S10B80.BANINST1.BWLKILIB	Use (select)Rely On
SIBINST_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Rely On
SIBINST_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Use (select)Rely On
SIBINST_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Rely On
SIBINST_COUNT_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Use (select)
SIBINST_NEXT_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Rely On
SIBINST_NEXT_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Use (select)Rely On
P_ADVENTERID	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SIBINST	Use (delete)
P_FACADVRSECURITY	Oracle Package Procedure	S10B80.BANINST1.BWLKSECR	Use (select)
P_FACENTERID	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Rely On
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SIBINST	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SIBINST	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACASSIGNMENT	Use (Insert,select)
F_ACTIVEFACADVR	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Rely On
F_ACTIVE_LIMIT	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_GET_SIBINST_MAX_TERM_CODE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Rely On
F_GET_SIBINST_MAX_TERM_CODE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Use (select)
F_PERSON_IS_FACULTY	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Rely On
F_PRIMARYFAC	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Rely On
F_PRIMARYFAC	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_QUERY_ONE_SCHEDULED	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Rely On
F_QUERY_ONE_SCHEDULED	Oracle Package Function	S10B80.BANINST1.SB_FACULTY	Use (select)
F_USERHASSIRDPCLREC	Oracle Package Function	S10B80.BANINST1.SOKEPRT	Rely On
F_USERHASSIRDPCLREC	Oracle Package Function	S10B80.BANINST1.SOKEPRT	Use (select)
F_VALIDFAC	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Rely On
F_VALIDFAC	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)Rely On
SIBINST	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_SIBINST	SQL Index	S10B80.SATURN	Rely On
SIRASGN	SQL Table	S10B80.SATURN	Join
STVCNTR	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	SQL Table	S10B80.SATURN	Refer (no action)
STVFCST	SQL Table	S10B80.SATURN	Refer (no action)
STVFCTG	SQL Table	S10B80.SATURN	Refer (no action)
STVFSTP	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWKLD	SQL Table	S10B80.SATURN	Refer (no action)
ST_SIBINST_AIR	SQL Trigger	S10B80.SATURN	Fire (Insert,after,each row)
ST_SIBINST_AIS	SQL Trigger	S10B80.SATURN	Fire (Insert,after,all rows)
ST_SIBINST_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SIBINST_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.SIBINST

Object Dates

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

Source Code Comments

Faculty Member Base Table

Columns Comments for SIBINST_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIBINST_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIBINST_FCST_CODE (# 3)

Source Code Comments

Faculty member status

Columns Comments for SIBINST_FCTG_CODE (# 4)

Source Code Comments

Faculty member category

Columns Comments for SIBINST_FSTP_CODE (# 5)

Source Code Comments

Faculty member staff type which is required for workload calculation

Columns Comments for SIBINST_FCNT_CODE (# 6)

Source Code Comments

Faculty member contract rule which is required for workload calculation

Columns Comments for SIBINST_SCHD_IND (# 7)

Source Code Comments

Faculty member available of schedule indicator

Columns Comments for SIBINST_ADVR_IND (# 8)

Source Code Comments

Faculty member available of advisment indicator

Columns Comments for SIBINST_FCST_DATE (# 9)

Source Code Comments

Faculty member status date

Columns Comments for SIBINST_WKLD_CODE (# 10)

Source Code Comments

Faculty member workload rule code

Columns Comments for SIBINST_CNTR_CODE (# 11)

Source Code Comments

Faculty member contract rule code

Columns Comments for SIBINST_APPOINT_DATE (# 12)

Source Code Comments

The date the appointment was awarded

Columns Comments for SIBINST_ACTIVITY_DATE (# 13)

Source Code Comments

Activity date

Columns Comments for SIBINST_DATA_ORIGIN (# 14)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SIBINST_USER_ID (# 15)

Source Code Comments

USER ID: User who inserted or last update the data

Table SIBTERM

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIBTERM_TERM_CODE	VARCHAR2(6)	No	*	*
SIBTERM_FTE_FACTOR	NUMBER(3,0)	No
SIBTERM_CALC_DEV_FACTOR	NUMBER(3,0)	No
SIBTERM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBTERM_TERM_CODE	STVTERM_CODE	STVTERM
SIBTERM_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN

Index

Index Name	Index Type	Column Name
PK_SIBTERM	Unique	SIBTERM_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIVCALC	SQL View	S10B80.BANINST1	Use (select)
SIVCONT	SQL View	S10B80.BANINST1	Use (select)
SIVPFAC	SQL View	S10B80.BANINST1	Use (select)
F_ACTIVE_LIMIT	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
SIBTERM	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_SIBTERM	SQL Index	S10B80.SATURN	Rely On
SIRASGN	SQL Table	S10B80.SATURN	Join
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIBTERM

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:53:000	04/02/2008 21:18:19:000

Source Code Comments

Faculty load FTE and calculation fators rules Base Table

Columns Comments for SIBTERM_TERM_CODE (# 1)

Source Code Comments

Term of the rule

Columns Comments for SIBTERM_FTE_FACTOR (# 2)

Source Code Comments

Faculty load FTE factor

Columns Comments for SIBTERM_CALC_DEV_FACTOR (# 3)

Source Code Comments

Faculty load calculation deviation factor

Columns Comments for SIBTERM_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRASGN

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_PIDM	NUMBER(8,0)	No	*	*
SIRASGN_CATEGORY	VARCHAR2(2)	No	*
SIRASGN_PERCENT_RESPONSE	NUMBER(3,0)	No
SIRASGN_WORKLOAD_ADJUST	NUMBER(9,3)	Yes
SIRASGN_PERCENT_SESS	NUMBER(3,0)	No
SIRASGN_PRIMARY_IND	VARCHAR2(1)	Yes
SIRASGN_OVER_RIDE	VARCHAR2(1)	Yes
SIRASGN_POSITION	NUMBER(8,0)	Yes
SIRASGN_ACTIVITY_DATE	DATE	No
SIRASGN_FCNT_CODE	VARCHAR2(2)	Yes		*
SIRASGN_POSN	VARCHAR2(6)	Yes
SIRASGN_SUFF	VARCHAR2(2)	Yes
SIRASGN_ASTY_CODE	VARCHAR2(4)	Yes		*
SIRASGN_DATA_ORIGIN	VARCHAR2(30)	Yes
SIRASGN_USER_ID	VARCHAR2(30)	Yes
SIRASGN_WORKLOAD_INCR	NUMBER(9,3)	Yes
SIRASGN_INCR_ENRL	NUMBER(4,0)	Yes
SIRASGN_INCR_ENRL_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRASGN_ASTY_CODE	STVASTY_CODE	STVASTY
SIRASGN_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRASGN_TERM_CODE	STVTERM_CODE	STVTERM
SIRASGN_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SIRASGN_CRN	SSBSECT_CRN	SSBSECT
SIRASGN_CRN	SFRSTCR_CRN	SFRSTCR
SIRASGN_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SIRASGN_PIDM	SIRCOLR_PIDM	SIRCOLR
SIRASGN_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR
SIRASGN_TERM_CODE	SIRCOLR_TERM_CODE	SIRCOLR
SIRASGN_CRN	SHRTCKN_CRN	SHRTCKN
SIRASGN_TERM_CODE	SHRTCKN_TERM_CODE	SHRTCKN
SIRASGN_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SIRASGN_PIDM	SFRAREG_INSTRUCTOR_PIDM	SFRAREG
SIRASGN_TERM_CODE	SFRAREG_TERM_CODE	SFRAREG
SIRASGN_CRN	SFRAREG_CRN	SFRAREG

Index

Index Name	Index Type	Column Name
PK_SIRASGN	Unique	SIRASGN_TERM_CODE
PK_SIRASGN	Unique	SIRASGN_CRN
PK_SIRASGN	Unique	SIRASGN_PIDM
PK_SIRASGN	Unique	SIRASGN_CATEGORY
SIRASGN_KEY_INDEX2	Unique	SIRASGN_PIDM
SIRASGN_KEY_INDEX2	Unique	SIRASGN_TERM_CODE
SIRASGN_KEY_INDEX2	Unique	SIRASGN_CRN
SIRASGN_KEY_INDEX2	Unique	SIRASGN_CATEGORY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBINST	SQL Table	S10B80.SATURN	Join
SIBTERM	SQL Table	S10B80.SATURN	Join
SIRFCNT	SQL Table	S10B80.SATURN	Join
SIROFFC	SQL Table	S10B80.SATURN	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
SSRMEET	SQL Table	S10B80.SATURN	Join
SSRXLST	SQL Table	S10B80.SATURN	Join
ST_SIRASGN_AR_LDI	SQL Trigger	S10B80.SATURN	Rely On
SFVSTMS	SQL View	S10B80.BANINST1	Use (select)
SFVSTMS_EXP	SQL View	S10B80.BANINST1	Use (select)
SFVTFAN	SQL View	S10B80.BANINST1	Use (select)
SIVASGN	SQL View	S10B80.BANINST1	Use (select)
SIVCALC	SQL View	S10B80.BANINST1	Use (select)
SIVCONT	SQL View	S10B80.BANINST1	Use (select)
SIVPFAC	SQL View	S10B80.BANINST1	Use (select)
F_FACULTY_SCHEDULED_IND	SQL Function	S10B80.BANINST1	Use (select)
F_GET_INSTR_SPRIDEN_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_GET_MIN_SIBCFTE_FTE_FACTOR	SQL Function	S10B80.BANINST1	Rely On
F_INSTRUCTOR_FNC	SQL Function	S10B80.BANINST1	Use (select)
ASSIGNMENTS_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSPKCOM	Rely On
FACASSIGNMENT_REC	Oracle Package Type	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
ASSIGN_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSIKLDI	Rely On
ENROLL_REC_TYPE	Oracle Package Type	S10B80.BANINST1.ICSFKLDI	Rely On
BASE_WORKLOAD_C	Oracle Package Cursor	S10B80.BANINST1.SIKLOAD	Rely On
DELIVERY_SYSTEM_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKCOM	Rely On
SIRASGNC	Oracle Package Cursor	S10B80.BANINST1.BWCKFRMT	Rely On
SIRASGNC	Oracle Package Cursor	S10B80.BANINST1.BWCKFRMT	Use (select)
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.BWCKSCHD	Use (select)
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKCOM	Rely On
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKCOM	Use (select)
SIROFFC_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWLKOFFH	Use (select)
P_BUILDSOTWREG	Oracle Package Procedure	S10B80.BANINST1.SOKWEXT	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
CRN	Oracle Package Variable	S10B80.BANINST1.BWLKOIDS	Rely On
CRN	Oracle Package Variable	S10B80.BANINST1.BWLKOCRN	Rely On
HOLD_CRN	Oracle Package Variable	S10B80.BANINST1.BWLKFCWL	Rely On
SHRINST_ROW	Oracle Package Variable	S10B80.BANINST1.SHKROLS	Rely On
F_BUILD_SIRASGN_REC	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_CALC_STATUS	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CALC_SUBROLE	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CALC_VALID_DELIVERY_SYSTEM	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CHECKFACULTYRELATION	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Rely On
F_CHECKFACULTYRELATION	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_CHECK_FACUTLY_ASSGN	Oracle Package Function	S10B80.BANINST1.SP_GRADING_RULES	Rely On
F_GET_DASHBORD	Oracle Package Function	S10B80.BANINST1.CLOBPERS	Use (select)
F_HAS_ROLE	Oracle Package Function	S10B80.BANINST1.ICGOKROL	Use (select)
ASSIGNMENTS_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Rely On
ASSIGNMENTS_C	Oracle Package Cursor	S10B80.BANINST1.ICSPKCOM	Use (select)
MULTI_TERM_INSTRC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Use (select)
SHRINST_SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.SHKSELS	Rely On
SHRINST_SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.SHKSELS	Use (select)Rely On
SINGLE_TERM_INSTRC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Use (select)
SIRASGNC	Oracle Package Cursor	S10B80.BANINST1.SFKCURS	Use (select)Rely On
SIRASGN_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Rely On
SIRASGN_BY_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.SIKLIBS	Use (select)Rely On
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSSKCOM	Rely On
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSSKCOM	Use (select)Rely On
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Rely On
SIRASGN_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Use (select)Rely On
SIRASGN_ROLE_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Rely On
SIRASGN_ROLE_C	Oracle Package Cursor	S10B80.BANINST1.ICSIKLIB	Use (select)Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_SIRASGN	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_SECTION	Use (delete)
P_DISPINTABLE	Oracle Package Procedure	S10B80.BANINST1.BWLKFROV	Use (select)
P_DISPLAY_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWSKOFFH	Use (select)
P_FACACTASSIGN	Oracle Package Procedure	S10B80.BANINST1.BWLKASGN	Use (select)
P_FACASSIGNHIST	Oracle Package Procedure	S10B80.BANINST1.BWLKASGN	Use (select)
P_FACCLALIST	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACCLALISTSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACCRNSEL	Oracle Package Procedure	S10B80.BANINST1.BWLKOCRN	Use (select)
P_FACDISPSHRMRKS	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACDISPSHRSMRK	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACIDSHRMRKSPROC	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACIDSHRSMRKPROC	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Use (select)
P_FACMIDGRD	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Rely On
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Use (select)
P_FACSTORECRN	Oracle Package Procedure	S10B80.BANINST1.BWLKOCRN	Rely On
P_FACWAITLIST	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FACWAITLISTSUM	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_FAC_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Rely On
P_FAC_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Use (select)
P_GET_FAC_FINAL	Oracle Package Procedure	S10B80.BANINST1.BWLCBREF	Use (select)
P_GET_FAC_GRDEBOOK	Oracle Package Procedure	S10B80.BANINST1.BWLCBREF	Use (select)
P_GET_FAC_MIDTERM	Oracle Package Procedure	S10B80.BANINST1.BWLCBREF	Use (select)
P_GET_PRIMARY_INSTRUCTOR_PIDM	Oracle Package Procedure	S10B80.BANINST1.SIKLIBS	Rely On
P_GET_PRIMARY_INSTRUCTOR_PIDM	Oracle Package Procedure	S10B80.BANINST1.SIKLIBS	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_SIRASGN	Use (Insert)Rely On
P_INSERT_SFRAREG	Oracle Package Procedure	S10B80.BANINST1.SFKMODS	Rely On
P_INSERT_SHRINST_FROM_SIRASGN	Oracle Package Procedure	S10B80.BANINST1.SHKMODS	Rely On
P_INSERT_SHRINST_FROM_SIRASGN	Oracle Package Procedure	S10B80.BANINST1.SHKMODS	Use (select)
P_INSTRUCTOR_LIST	Oracle Package Procedure	S10B80.BANINST1.BWCKFRMT	Rely On
P_LISTCRSE	Oracle Package Procedure	S10B80.BANINST1.BWCKGENS	Use (select)
P_LOAD_TEMPLATE	Oracle Package Procedure	S10B80.BANINST1.BWCKWEEK	Use (select)
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
P_OPEN_STUDENT_LIST_C	Oracle Package Procedure	S10B80.BANINST1.BWLKOIDS	Use (select)
P_POSTELTGRADES	Oracle Package Procedure	S10B80.BANINST1.ICSFKGEX	Rely On
P_POST_GRADE	Oracle Package Procedure	S10B80.BANINST1.SP_GRADING	Rely On
P_PRINTLINKS	Oracle Package Procedure	S10B80.BANINST1.BWLKFCWL	Rely On
P_PRINTLINKS	Oracle Package Procedure	S10B80.BANINST1.BWLKEGRB	Rely On
P_PRINTLINKS	Oracle Package Procedure	S10B80.BANINST1.BWLKFMGD	Rely On
P_PROCESS_SFRAREG	Oracle Package Procedure	S10B80.BANINST1.SFKFUNC	Rely On
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
P_SAVE_ASSIGNMENT	Oracle Package Procedure	S10B80.BANINST1.ICSIKLDI	Rely On
P_SELECT_SHRINST_SIRASGN	Oracle Package Procedure	S10B80.BANINST1.SHKSELS	Rely On
P_SEND_ASSIGNMENT	Oracle Package Procedure	S10B80.BANINST1.ICSIKLDI	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_SIRASGN	Use (update)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY_RULES	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY_RULES	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert)
UT_TEARDOWN	Oracle Package Procedure	S10B80.BANINST1.UT_SP_GRADING	Use (delete)
F_ACTIVE_LIMIT	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_ASGN_COMPENSATION_APPLIED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_ASGN_COMPENSATION_EXTRACTED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_CALC_ONLINETOPIC	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CALC_SOURCEDID_ID	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CALC_VALID_LDIMODE	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_CALC_WORKLOAD	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_CALC_WORKLOAD_BASE	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_CHECKCRNACCESS	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_CHECK_ASSIGNMENTS	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
F_CHECK_POSN_IS_VALID_ACTIVE	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_CHECK_PRIM_SIRASGN	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_CHECK_PRIM_SIRASGN	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_CHECK_SSRMEET_SESSION	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
F_DEFAULT_CATEGORY	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_DEFAULT_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_FTE_FACTOR	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_GET_ASSIGNMENT	Oracle Package Function	S10B80.BANINST1.ICSIKLDI	Rely On
F_GET_ASSIGNMENT	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_GET_DASHBOARD	Oracle Package Function	S10B80.BANINST1.CHNLSKBL	Use (select)
F_GET_DASHBOARD_COUNT	Oracle Package Function	S10B80.BANINST1.CHNLSKBL	Use (select)
F_GET_DASHBOARD_COUNT	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_GET_DASHBOARD_CRN	Oracle Package Function	S10B80.BANINST1.CHNLSKBL	Use (select)
F_GET_DASHBOARD_SUBJ	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_GET_DASHBOARD_TERM	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_GET_EVENT_HEADER	Oracle Package Function	S10B80.BANINST1.ICSIKCOM	Rely On
F_GET_FACDTRANGE	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_GET_SESSION	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
F_GET_SESSION	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Use (select)
F_NIST_COMPENSATION_APPLIED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_NIST_COMPENSATION_EXTRACTED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT_RULES	Rely On
F_PRIMARYFAC	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_SECTION_INSTRUCTOR	Oracle Package Function	S10B80.BANINST1.SSKSELS	Use (select)
F_STUDENT_ID_TYPE	Oracle Package Function	S10B80.BANINST1.BWLCXCHN	Use (select)
F_VALIDFACFORCRN	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_VALID_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
TEST1	Oracle Package Function	S10B80.BANINST1.TESTPACK	Use (select)
SIRASGN	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_SIRASGN	SQL Index	S10B80.SATURN	Rely On
SIRASGN_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SFRAREG	SQL Table	S10B80.SATURN	Join
SFRSTCR	SQL Table	S10B80.SATURN	Join
SHRTCKN	SQL Table	S10B80.SATURN	Join
SIRCOLR	SQL Table	S10B80.SATURN	Join
SOBTERM	SQL Table	S10B80.SATURN	Join
SSBSECT	SQL Table	S10B80.SATURN	Refer (no action)
STVASTY	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
ST_SIRASGN_AR_LDI	SQL Trigger	S10B80.SATURN	Fire (Insert,update,delete,after,each row)
ST_SIRASGN_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.SIRASGN

Object Dates

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

Source Code Comments

Faculty Member Instructional Assignment Repeating Table

Columns Comments for SIRASGN_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member assignment

Columns Comments for SIRASGN_CRN (# 2)

Source Code Comments

The course reference of the course that the instructor was assigned to

Columns Comments for SIRASGN_PIDM (# 3)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRASGN_CATEGORY (# 4)

Source Code Comments

The session indicator associated with the assignment

Columns Comments for SIRASGN_PERCENT_RESPONSE (# 5)

Source Code Comments

Faculty members percentage of responsibility to the assignment

Columns Comments for SIRASGN_WORKLOAD_ADJUST (# 6)

Source Code Comments

Faculty Adjustied Workload for instructional assignment.

Columns Comments for SIRASGN_PERCENT_SESS (# 7)

Source Code Comments

Faculty session percentage of responsibility of instructional assignment.

Columns Comments for SIRASGN_PRIMARY_IND (# 8)

Source Code Comments

The primary instructor of the course

Columns Comments for SIRASGN_OVER_RIDE (# 9)

Source Code Comments

Override Indicator.

Columns Comments for SIRASGN_POSITION (# 10)

Source Code Comments

Faculty Position.

Columns Comments for SIRASGN_ACTIVITY_DATE (# 11)

Source Code Comments

Activity date

Columns Comments for SIRASGN_FCNT_CODE (# 12)

Source Code Comments

The contract type that the instructional assignment is associated with

Columns Comments for SIRASGN_POSN (# 13)

Source Code Comments

This field is the Position number for the faculty assignment. It is used to tie the faculty member's assignment to a position defined in the BANNER Human Resources system

Columns Comments for SIRASGN_SUFF (# 14)

Source Code Comments

This field is the Position number suffix. It is used to tie the faculty member's assignment to a position defined in the BANNER Human Resources System

Columns Comments for SIRASGN_ASTY_CODE (# 15)

Source Code Comments

Faculty Assignment Type Code

Columns Comments for SIRASGN_DATA_ORIGIN (# 16)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SIRASGN_USER_ID (# 17)

Source Code Comments

USER ID: User who inserted or last update the data

Columns Comments for SIRASGN_WORKLOAD_INCR (# 18)

Source Code Comments

WORKLOAD INCREMENT: Incremental workload derived from enrollment count.

Columns Comments for SIRASGN_INCR_ENRL (# 19)

Source Code Comments

INCREMENT ENROLLMENT: Enrollment count used to calculate workload increment.

Columns Comments for SIRASGN_INCR_ENRL_DATE (# 20)

Source Code Comments

INCREMENT ENROLLMENT DATE: Registration date used to derive workload increment from enrollment count.

Table SIRATTR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRATTR_PIDM	NUMBER(8,0)	No
SIRATTR_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRATTR_FATT_CODE	VARCHAR2(4)	Yes	*
SIRATTR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRATTR_FATT_CODE	STVFATT_CODE	STVFATT
SIRATTR_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRATTR_KEY_INDEX	Unique	SIRATTR_PIDM
SIRATTR_KEY_INDEX	Unique	SIRATTR_TERM_CODE_EFF
SIRATTR_KEY_INDEX	Unique	SIRATTR_FATT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_GET_SIRATTR_DATA	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
F_VERIFYCRNFACPROCESS	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_VERIFYFACPROCESS	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
P_FACADVRSECURITY	Oracle Package Procedure	S10B80.BANINST1.BWLKSECR	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert)
F_CHECKCRNACCESS	Oracle Package Function	S10B80.BANINST1.BWLKILIB	Use (select)
F_SIRATTR_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Rely On
F_SIRATTR_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Use (select)
SIRATTR	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
SIRATTR_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVFATT	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.SIRATTR

Object Dates

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

Source Code Comments

Faculty Attribute Information Repeating Table

Columns Comments for SIRATTR_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRATTR_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRATTR_FATT_CODE (# 3)

Source Code Comments

The faculty member attribute

Columns Comments for SIRATTR_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRCMNT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRCMNT_PIDM	NUMBER(8,0)	No
SIRCMNT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRCMNT_SEQNO	NUMBER(23,20)	Yes
SIRCMNT_TEXT	VARCHAR2(60)	Yes
SIRCMNT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRCMNT_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRCMNT_KEY_INDEX		SIRCMNT_PIDM
SIRCMNT_KEY_INDEX		SIRCMNT_TERM_CODE_EFF
SIRCMNT_KEY_INDEX		SIRCMNT_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert)
SIRCMNT	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
SIRCMNT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIRCMNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:46:000	04/02/2008 21:18:19:000

Source Code Comments

Faculty Comment Information Repeating Table

Columns Comments for SIRCMNT_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRCMNT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRCMNT_SEQNO (# 3)

Source Code Comments

The sequence number of the faculty member comments

Columns Comments for SIRCMNT_TEXT (# 4)

Source Code Comments

The comments of the faculty member comments

Columns Comments for SIRCMNT_ACTIVITY_DATE (# 5)

Source Code Comments

Activity date

Table SIRCOLC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SIRCOLC_SESSIONID		VARCHAR2(10)	No	*
SIRCOLC_FATT_CODE		VARCHAR2(4)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRCOLC_FATT_CODE	STVFATT_CODE	STVFATT

Index

Index Name	Index Type	Column Name
PK_SIRCOLC	Unique	SIRCOLC_SESSIONID
PK_SIRCOLC	Unique	SIRCOLC_FATT_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIRCOLC

Object Dates

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

Source Code Comments

Faculty Member Collector Table

Columns Comments for SIRCOLC_SESSIONID (# 1)

Source Code Comments

Unique Session Id created for collected record.

Columns Comments for SIRCOLC_FATT_CODE (# 2)

Source Code Comments

Faculty Attribute Code for collected record.

Table SIRCOLR

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIRCOLR_SESSIONID	VARCHAR2(30)	No	*
SIRCOLR_PIDM	NUMBER(8,0)	No	*
SIRCOLR_TERM_CODE	VARCHAR2(6)	No	*	*
SIRCOLR_FCNT_CODE	VARCHAR2(2)	Yes		*
SIRCOLR_ACTIVITY_DATE	DATE	No
SIRCOLR_TERM_CODE_EFF	VARCHAR2(6)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRCOLR_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRCOLR_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRCOLR_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SIRCOLR	Unique	SIRCOLR_SESSIONID
PK_SIRCOLR	Unique	SIRCOLR_PIDM
PK_SIRCOLR	Unique	SIRCOLR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBCFTE	SQL Table	S10B80.SATURN	Join
SIRASGN	SQL Table	S10B80.SATURN	Join
SIRFCNT	SQL Table	S10B80.SATURN	Join
SIVCALC	SQL View	S10B80.BANINST1	Use (select)
SIVCONT	SQL View	S10B80.BANINST1	Use (select)
SIVPFAC	SQL View	S10B80.BANINST1	Use (select)
F_GET_MIN_SIBCFTE_FTE_FACTOR	SQL Function	S10B80.BANINST1	Use (select)
SIRCOLR	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_SIRCOLR	SQL Index	S10B80.SATURN	Rely On
STVFCNT	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.SIRCOLR

Object Dates

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

Source Code Comments

Faculty Load Collector Repeating Table

Columns Comments for SIRCOLR_SESSIONID (# 1)

Source Code Comments

Unique Session Id created for collected record.

Columns Comments for SIRCOLR_PIDM (# 2)

Source Code Comments

Pidm created for the collected record.

Columns Comments for SIRCOLR_TERM_CODE (# 3)

Source Code Comments

Term Code created for collected record.

Columns Comments for SIRCOLR_FCNT_CODE (# 4)

Source Code Comments

Contract Code of the Collected Record.

Columns Comments for SIRCOLR_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SIRCOLR_TERM_CODE_EFF (# 6)

Source Code Comments

The effective term of the contract summary processing

Table SIRDPCL

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRDPCL_PIDM	NUMBER(8,0)	No	*
SIRDPCL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRDPCL_COLL_CODE	VARCHAR2(2)	Yes	*
SIRDPCL_DEPT_CODE	VARCHAR2(4)	Yes	*
SIRDPCL_HOME_IND	VARCHAR2(1)	Yes
SIRDPCL_PERCENTAGE	NUMBER(3,0)	Yes
SIRDPCL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRDPCL_COLL_CODE	STVCOLL_CODE	STVCOLL
SIRDPCL_DEPT_CODE	STVDEPT_CODE	STVDEPT
SIRDPCL_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRDPCL_PIDM	SIBINST_PIDM	SIBINST

Index

Index Name	Index Type	Column Name
SIRDPCL_KEY_INDEX	Unique	SIRDPCL_PIDM
SIRDPCL_KEY_INDEX	Unique	SIRDPCL_TERM_CODE_EFF
SIRDPCL_KEY_INDEX	Unique	SIRDPCL_COLL_CODE
SIRDPCL_KEY_INDEX	Unique	SIRDPCL_DEPT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIVFACL	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_1	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_11	SQL View	S10B80.BANINST1	Use (select)
F_CONCAT_SIRDPCL	SQL Function	S10B80.BANINST1	Use (select)
F_INSTRUCTOR_FNC	SQL Function	S10B80.BANINST1	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
P_GETACCESSIBLECOLLDEPT	Oracle Package Procedure	S10B80.BANINST1.SOKEPRT	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert)
F_USERHASSIRDPCLREC	Oracle Package Function	S10B80.BANINST1.SOKEPRT	Use (select)
SIRDPCL	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
SIRDPCL_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SIBINST	SQL Table	S10B80.SATURN	Join
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	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.SIRDPCL

Object Dates

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

Source Code Comments

Faculty Member Department and College Information Repeating Table

Columns Comments for SIRDPCL_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRDPCL_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRDPCL_COLL_CODE (# 3)

Source Code Comments

The college which faculty member is assigned to

Columns Comments for SIRDPCL_DEPT_CODE (# 4)

Source Code Comments

The department which faculty member is assigned to

Columns Comments for SIRDPCL_HOME_IND (# 5)

Source Code Comments

The home administrative department and college indicator

Columns Comments for SIRDPCL_PERCENTAGE (# 6)

Source Code Comments

Faculty members percentage of responsibility to the department and college

Columns Comments for SIRDPCL_ACTIVITY_DATE (# 7)

Source Code Comments

Activity date

Table SIRFCNT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRFCNT_FCNT_CODE	VARCHAR2(2)	No	*
SIRFCNT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRFCNT_TERM_CODE	VARCHAR2(6)	Yes	*
SIRFCNT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRFCNT_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRFCNT_TERM_CODE	STVTERM_CODE	STVTERM
SIRFCNT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRFCNT_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN
SIRFCNT_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR

Index

Index Name	Index Type	Column Name
SIRFCNT_KEY_INDEX	Unique	SIRFCNT_FCNT_CODE
SIRFCNT_KEY_INDEX	Unique	SIRFCNT_TERM_CODE_EFF
SIRFCNT_KEY_INDEX	Unique	SIRFCNT_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIVCONT	SQL View	S10B80.BANINST1	Use (select)
F_GET_MIN_SIBCFTE_FTE_FACTOR	SQL Function	S10B80.BANINST1	Use (select)
SIRFCNT	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
SIRFCNT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SIRASGN	SQL Table	S10B80.SATURN	Join
SIRCOLR	SQL Table	S10B80.SATURN	Join
STVFCNT	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.SIRFCNT

Object Dates

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

Source Code Comments

Faculty Contract Rule Information Repeating Table

Columns Comments for SIRFCNT_FCNT_CODE (# 1)

Source Code Comments

The faculty contract rule

Columns Comments for SIRFCNT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term for the faculty contract rule

Columns Comments for SIRFCNT_TERM_CODE (# 3)

Source Code Comments

Terms for the faculty contract type

Columns Comments for SIRFCNT_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRFLCT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRFLCT_TERM_CODE	VARCHAR2(6)	No	*
SIRFLCT_FCNT_CODE	VARCHAR2(2)	No	*
SIRFLCT_STATUS	VARCHAR2(1)	No
SIRFLCT_CNTR_CODE	VARCHAR2(6)	Yes	*
SIRFLCT_CREDIT_HR_LOW	NUMBER(9,3)	Yes
SIRFLCT_CREDIT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLCT_CREDIT_HR_LOW_GEN	NUMBER(9,3)	Yes
SIRFLCT_CREDIT_HR_HIGH_GEN	NUMBER(9,3)	Yes
SIRFLCT_CONTACT_HR_LOW	NUMBER(9,3)	Yes
SIRFLCT_CONTACT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLCT_CONTACT_HR_LOW_WEEK	NUMBER(9,3)	Yes
SIRFLCT_CONTACT_HR_HIGH_WEEK	NUMBER(9,3)	Yes
SIRFLCT_INST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLCT_INST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLCT_NIST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLCT_NIST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLCT_TOT_WORKLOAD_LOW	NUMBER(11,3)	Yes
SIRFLCT_TOT_WORKLOAD_HIGH	NUMBER(11,3)	Yes
SIRFLCT_FTE_LOW	NUMBER(5,2)	Yes
SIRFLCT_FTE_HIGH	NUMBER(5,2)	Yes
SIRFLCT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRFLCT_CNTR_CODE	STVCNTR_CODE	STVCNTR
SIRFLCT_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRFLCT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRFLCT_KEY_INDEX		SIRFLCT_TERM_CODE
SIRFLCT_KEY_INDEX		SIRFLCT_FCNT_CODE
SIRFLCT_KEY_INDEX		SIRFLCT_STATUS
SIRFLCT_KEY_INDEX		SIRFLCT_CNTR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRFLCT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVCNTR	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	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.SIRFLCT

Object Dates

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

Source Code Comments

Faculty Member Contract Term Rule Table

Columns Comments for SIRFLCT_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member contract rule

Columns Comments for SIRFLCT_FCNT_CODE (# 2)

Source Code Comments

The faculty member contract type code

Columns Comments for SIRFLCT_STATUS (# 3)

Source Code Comments

The faculty member contract rule status

Columns Comments for SIRFLCT_CNTR_CODE (# 4)

Source Code Comments

The faculty member contract rule code

Columns Comments for SIRFLCT_CREDIT_HR_LOW (# 5)

Source Code Comments

The faculty member contract rule low range total credit hours

Columns Comments for SIRFLCT_CREDIT_HR_HIGH (# 6)

Source Code Comments

The faculty member contract rule high range total credit hours

Columns Comments for SIRFLCT_CREDIT_HR_LOW_GEN (# 7)

Source Code Comments

The faculty member contract rule low range total generated credit hours

Columns Comments for SIRFLCT_CREDIT_HR_HIGH_GEN (# 8)

Source Code Comments

The faculty member contract rule high range total generated credit hours

Columns Comments for SIRFLCT_CONTACT_HR_LOW (# 9)

Source Code Comments

The faculty member contract rule total low range total contact hours

Columns Comments for SIRFLCT_CONTACT_HR_HIGH (# 10)

Source Code Comments

The faculty member contract rule high range total contact hours

Columns Comments for SIRFLCT_CONTACT_HR_LOW_WEEK (# 11)

Source Code Comments

The faculty member contract rule low range total weekly contact hours

Columns Comments for SIRFLCT_CONTACT_HR_HIGH_WEEK (# 12)

Source Code Comments

The faculty member contract rule high range total weekly contact hours

Columns Comments for SIRFLCT_INST_WORKLOAD_LOW (# 13)

Source Code Comments

The faculty member contract rule low range total instructional workload

Columns Comments for SIRFLCT_INST_WORKLOAD_HIGH (# 14)

Source Code Comments

The faculty member contract rule total high range total instructional workload

Columns Comments for SIRFLCT_NIST_WORKLOAD_LOW (# 15)

Source Code Comments

The faculty member contract rule low range total non-instructional workload

Columns Comments for SIRFLCT_NIST_WORKLOAD_HIGH (# 16)

Source Code Comments

The faculty member contract rule high range total non-instructional workload

Columns Comments for SIRFLCT_TOT_WORKLOAD_LOW (# 17)

Source Code Comments

The faculty member contract rule low range total workload

Columns Comments for SIRFLCT_TOT_WORKLOAD_HIGH (# 18)

Source Code Comments

The faculty member contract rule high range total workload

Columns Comments for SIRFLCT_FTE_LOW (# 19)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLCT_FTE_HIGH (# 20)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLCT_ACTIVITY_DATE (# 21)

Source Code Comments

Activity date

Table SIRFLRC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRFLRC_FCNT_CODE	VARCHAR2(2)	No	*
SIRFLRC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRFLRC_STATUS	VARCHAR2(1)	Yes
SIRFLRC_CNTR_CODE	VARCHAR2(6)	Yes	*
SIRFLRC_CREDIT_HR_LOW	NUMBER(9,3)	Yes
SIRFLRC_CREDIT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLRC_CREDIT_HR_LOW_GEN	NUMBER(9,3)	Yes
SIRFLRC_CREDIT_HR_HIGH_GEN	NUMBER(9,3)	Yes
SIRFLRC_CONTACT_HR_LOW	NUMBER(9,3)	Yes
SIRFLRC_CONTACT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLRC_CONTACT_HR_LOW_WEEK	NUMBER(9,3)	Yes
SIRFLRC_CONTACT_HR_HIGH_WEEK	NUMBER(9,3)	Yes
SIRFLRC_INST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLRC_INST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLRC_NIST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLRC_NIST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLRC_TOT_WORKLOAD_LOW	NUMBER(11,3)	Yes
SIRFLRC_TOT_WORKLOAD_HIGH	NUMBER(11,3)	Yes
SIRFLRC_FTE_FACTOR	NUMBER(3,0)	Yes
SIRFLRC_FTE_LOW	NUMBER(5,2)	Yes
SIRFLRC_FTE_HIGH	NUMBER(5,2)	Yes
SIRFLRC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRFLRC_CNTR_CODE	STVCNTR_CODE	STVCNTR
SIRFLRC_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRFLRC_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRFLRC_KEY_INDEX		SIRFLRC_FCNT_CODE
SIRFLRC_KEY_INDEX		SIRFLRC_TERM_CODE_EFF
SIRFLRC_KEY_INDEX		SIRFLRC_STATUS
SIRFLRC_KEY_INDEX		SIRFLRC_CNTR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRFLRC_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVCNTR	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	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.SIRFLRC

Object Dates

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

Source Code Comments

Faculty Member Workload Contract Rule Table

Columns Comments for SIRFLRC_FCNT_CODE (# 1)

Source Code Comments

The faculty member workload rule contract code

Columns Comments for SIRFLRC_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member workload rule

Columns Comments for SIRFLRC_STATUS (# 3)

Source Code Comments

The faculty member workload rule status

Columns Comments for SIRFLRC_CNTR_CODE (# 4)

Source Code Comments

The faculty member workload rule code

Columns Comments for SIRFLRC_CREDIT_HR_LOW (# 5)

Source Code Comments

The faculty member workload rule low range total credit hours

Columns Comments for SIRFLRC_CREDIT_HR_HIGH (# 6)

Source Code Comments

The faculty member workload rule high range total credit hours

Columns Comments for SIRFLRC_CREDIT_HR_LOW_GEN (# 7)

Source Code Comments

The faculty member workload rule low range total generated credit hours

Columns Comments for SIRFLRC_CREDIT_HR_HIGH_GEN (# 8)

Source Code Comments

The faculty member workload rule high range total generated credit hours

Columns Comments for SIRFLRC_CONTACT_HR_LOW (# 9)

Source Code Comments

The faculty member workload rule total low range total contact hours

Columns Comments for SIRFLRC_CONTACT_HR_HIGH (# 10)

Source Code Comments

The faculty member workload rule high range total contact hours

Columns Comments for SIRFLRC_CONTACT_HR_LOW_WEEK (# 11)

Source Code Comments

The faculty member workload rule low range total weekly contact hours

Columns Comments for SIRFLRC_CONTACT_HR_HIGH_WEEK (# 12)

Source Code Comments

The faculty member workload rule high range total weekly contact hours

Columns Comments for SIRFLRC_INST_WORKLOAD_LOW (# 13)

Source Code Comments

The faculty member workload rule low range total instructional workload

Columns Comments for SIRFLRC_INST_WORKLOAD_HIGH (# 14)

Source Code Comments

The faculty member workload rule total high range total instructional workload

Columns Comments for SIRFLRC_NIST_WORKLOAD_LOW (# 15)

Source Code Comments

The faculty member workload rule low range total non-instructional workload

Columns Comments for SIRFLRC_NIST_WORKLOAD_HIGH (# 16)

Source Code Comments

The faculty member workload rule high range total non-instructional workload

Columns Comments for SIRFLRC_TOT_WORKLOAD_LOW (# 17)

Source Code Comments

The faculty member workload rule low range total workload

Columns Comments for SIRFLRC_TOT_WORKLOAD_HIGH (# 18)

Source Code Comments

The faculty member workload rule high range total workload

Columns Comments for SIRFLRC_FTE_FACTOR (# 19)

Source Code Comments

The full time equivalent factor

Columns Comments for SIRFLRC_FTE_LOW (# 20)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLRC_FTE_HIGH (# 21)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLRC_ACTIVITY_DATE (# 22)

Source Code Comments

Activity date

Table SIRFLRT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRFLRT_TERM_CODE	VARCHAR2(6)	No	*
SIRFLRT_STATUS	VARCHAR2(1)	No
SIRFLRT_WKLD_CODE	VARCHAR2(6)	Yes	*
SIRFLRT_CREDIT_HR_LOW	NUMBER(9,3)	Yes
SIRFLRT_CREDIT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLRT_CREDIT_HR_LOW_GEN	NUMBER(9,3)	Yes
SIRFLRT_CREDIT_HR_HIGH_GEN	NUMBER(9,3)	Yes
SIRFLRT_CONTACT_HR_LOW	NUMBER(9,3)	Yes
SIRFLRT_CONTACT_HR_HIGH	NUMBER(9,3)	Yes
SIRFLRT_CONTACT_HR_LOW_WEEK	NUMBER(9,3)	Yes
SIRFLRT_CONTACT_HR_HIGH_WEEK	NUMBER(9,3)	Yes
SIRFLRT_INST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLRT_INST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLRT_NIST_WORKLOAD_LOW	NUMBER(9,3)	Yes
SIRFLRT_NIST_WORKLOAD_HIGH	NUMBER(9,3)	Yes
SIRFLRT_TOT_WORKLOAD_LOW	NUMBER(11,3)	Yes
SIRFLRT_TOT_WORKLOAD_HIGH	NUMBER(11,3)	Yes
SIRFLRT_FTE_LOW	NUMBER(5,2)	Yes
SIRFLRT_FTE_HIGH	NUMBER(5,2)	Yes
SIRFLRT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRFLRT_WKLD_CODE	STVWKLD_CODE	STVWKLD
SIRFLRT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRFLRT_KEY_INDEX		SIRFLRT_TERM_CODE
SIRFLRT_KEY_INDEX		SIRFLRT_STATUS
SIRFLRT_KEY_INDEX		SIRFLRT_WKLD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_SFRRSTS	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
SIRFLRT	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
SIRFLRT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVWKLD	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIRFLRT

Object Dates

Creation Date	Analysis Date
04/02/2008 21:00:30:000	04/02/2008 21:18:21:000

Source Code Comments

Faculty Member Workload Term Rule Table

Columns Comments for SIRFLRT_TERM_CODE (# 1)

Source Code Comments

Effective term of the faculty member workload rule

Columns Comments for SIRFLRT_STATUS (# 2)

Source Code Comments

The faculty member workload rule status

Columns Comments for SIRFLRT_WKLD_CODE (# 3)

Source Code Comments

The faculty member workload rule code

Columns Comments for SIRFLRT_CREDIT_HR_LOW (# 4)

Source Code Comments

The faculty member workload rule low range total credit hours

Columns Comments for SIRFLRT_CREDIT_HR_HIGH (# 5)

Source Code Comments

The faculty member workload rule high range total credit hours

Columns Comments for SIRFLRT_CREDIT_HR_LOW_GEN (# 6)

Source Code Comments

The faculty member workload rule low range total generated credit hours

Columns Comments for SIRFLRT_CREDIT_HR_HIGH_GEN (# 7)

Source Code Comments

The faculty member workload rule high range total generated credit hours

Columns Comments for SIRFLRT_CONTACT_HR_LOW (# 8)

Source Code Comments

The faculty member workload rule total low range total contact hours

Columns Comments for SIRFLRT_CONTACT_HR_HIGH (# 9)

Source Code Comments

The faculty member workload rule high range total contact hours

Columns Comments for SIRFLRT_CONTACT_HR_LOW_WEEK (# 10)

Source Code Comments

The faculty member workload rule low range total weekly contact hours

Columns Comments for SIRFLRT_CONTACT_HR_HIGH_WEEK (# 11)

Source Code Comments

The faculty member workload rule high range total weekly contact hours

Columns Comments for SIRFLRT_INST_WORKLOAD_LOW (# 12)

Source Code Comments

The faculty member workload rule low range total instructional workload

Columns Comments for SIRFLRT_INST_WORKLOAD_HIGH (# 13)

Source Code Comments

The faculty member workload rule total high range total instructional workload

Columns Comments for SIRFLRT_NIST_WORKLOAD_LOW (# 14)

Source Code Comments

The faculty member workload rule low range total non-instructional workload

Columns Comments for SIRFLRT_NIST_WORKLOAD_HIGH (# 15)

Source Code Comments

The faculty member workload rule high range total non-instructional workload

Columns Comments for SIRFLRT_TOT_WORKLOAD_LOW (# 16)

Source Code Comments

The faculty member workload rule low range total workload

Columns Comments for SIRFLRT_TOT_WORKLOAD_HIGH (# 17)

Source Code Comments

The faculty member workload rule high range total workload

Columns Comments for SIRFLRT_FTE_LOW (# 18)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLRT_FTE_HIGH (# 19)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLRT_ACTIVITY_DATE (# 20)

Source Code Comments

Activity date

Table SIRICNT

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRICNT_PIDM	NUMBER(8,0)	No	*
SIRICNT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SIRICNT_FCNT_CODE	VARCHAR2(2)	Yes	*
SIRICNT_CNTR_CODE	VARCHAR2(6)	Yes	*
SIRICNT_DEF_IND	VARCHAR2(1)	Yes
SIRICNT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRICNT_CNTR_CODE	STVCNTR_CODE	STVCNTR
SIRICNT_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRICNT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRICNT_PIDM	SIBINST_PIDM	SIBINST

Index

Index Name	Index Type	Column Name
SIRICNT_KEY_INDEX		SIRICNT_PIDM
SIRICNT_KEY_INDEX		SIRICNT_TERM_CODE_EFF
SIRICNT_KEY_INDEX		SIRICNT_FCNT_CODE
SIRICNT_KEY_INDEX		SIRICNT_CNTR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIVFACL	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_1	SQL View	S10B80.BANINST1	Use (select)
SIVFACL_11	SQL View	S10B80.BANINST1	Use (select)
SIVINST	SQL View	S10B80.BANINST1	Use (select)
F_DEFAULT_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_DEFAULT_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
F_VALID_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Rely On
F_VALID_FCNT	Oracle Package Function	S10B80.BANINST1.SB_FACASSIGNMENT	Use (select)
SIRICNT	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
SIRICNT_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
SIBINST	SQL Table	S10B80.SATURN	Join
STVCNTR	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	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.SIRICNT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:58:26:000	04/02/2008 21:18:19:000

Source Code Comments

Faculty Contract Type Repeating Table

Columns Comments for SIRICNT_PIDM (# 1)

Source Code Comments

The internal system identifier of the faculty member

Columns Comments for SIRICNT_TERM_CODE_EFF (# 2)

Source Code Comments

The effective term of the faculty members contract type(s)

Columns Comments for SIRICNT_FCNT_CODE (# 3)

Source Code Comments

The contract type(s) that are associated with a faculty member

Columns Comments for SIRICNT_CNTR_CODE (# 4)

Source Code Comments

The contract rule code(s) that are associated with a faculty member

Columns Comments for SIRICNT_DEF_IND (# 5)

Source Code Comments

Default indicator shows which of the contract types is defined as the default for assignments. Valid values are D for the default and N for not the default

Columns Comments for SIRICNT_ACTIVITY_DATE (# 6)

Source Code Comments

The date the record was created or last updated

Table SIRLVAS

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIRLVAS_TERM_CODE	VARCHAR2(6)	No	*	*
SIRLVAS_CRN	VARCHAR2(5)	No	*	*
SIRLVAS_PIDM	NUMBER(8,0)	No	*
SIRLVAS_CATEGORY	VARCHAR2(2)	No	*
SIRLVAS_PERCENT_RESPONSE	NUMBER(3,0)	No
SIRLVAS_PERCENT_SESS	NUMBER(3,0)	No
SIRLVAS_ACTIVITY_DATE	DATE	No
SIRLVAS_WORKLOAD_ADJUST	NUMBER(7,3)	Yes
SIRLVAS_PRIMARY_IND	VARCHAR2(1)	Yes
SIRLVAS_OVERRIDE_IND	VARCHAR2(1)	Yes
SIRLVAS_POSITION	NUMBER(8,0)	Yes
SIRLVAS_FCNT_CODE	VARCHAR2(2)	Yes		*
SIRLVAS_POSN	VARCHAR2(6)	Yes
SIRLVAS_SUFF	VARCHAR2(2)	Yes
SIRLVAS_ASTY_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRLVAS_ASTY_CODE	STVASTY_CODE	STVASTY
SIRLVAS_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRLVAS_TERM_CODE	STVTERM_CODE	STVTERM
SIRLVAS_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SIRLVAS_CRN	SSBSECT_CRN	SSBSECT

Index

Index Name	Index Type	Column Name
PK_SIRLVAS	Unique	SIRLVAS_TERM_CODE
PK_SIRLVAS	Unique	SIRLVAS_CRN
PK_SIRLVAS	Unique	SIRLVAS_PIDM
PK_SIRLVAS	Unique	SIRLVAS_CATEGORY
SIRLVAS_KEY_INDEX2	Unique	SIRLVAS_PIDM
SIRLVAS_KEY_INDEX2	Unique	SIRLVAS_TERM_CODE
SIRLVAS_KEY_INDEX2	Unique	SIRLVAS_CRN
SIRLVAS_KEY_INDEX2	Unique	SIRLVAS_CATEGORY

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_SIRLVAS	SQL Index	S10B80.SATURN	Rely On
SIRLVAS_KEY_INDEX2	SQL Index	S10B80.SATURN	Rely On
SSBSECT	SQL Table	S10B80.SATURN	Refer (no action)
STVASTY	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	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.SIRLVAS

Object Dates

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

Source Code Comments

Faculty Leave Assignment Table

Columns Comments for SIRLVAS_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member leave assignment.

Columns Comments for SIRLVAS_CRN (# 2)

Source Code Comments

The course reference of the course that the instructor was assigned to.

Columns Comments for SIRLVAS_PIDM (# 3)

Source Code Comments

The pidm of the faculty member.

Columns Comments for SIRLVAS_CATEGORY (# 4)

Source Code Comments

The session indicator associated with the assignment.

Columns Comments for SIRLVAS_PERCENT_RESPONSE (# 5)

Source Code Comments

Faculty members percentage of the responsibility to the assignment.

Columns Comments for SIRLVAS_PERCENT_SESS (# 6)

Source Code Comments

Faculty session percentage of the responsibility of instructional assignment.

Columns Comments for SIRLVAS_ACTIVITY_DATE (# 7)

Source Code Comments

The Activity Date

Columns Comments for SIRLVAS_WORKLOAD_ADJUST (# 8)

Source Code Comments

Faculty Adjusted Workload for instructional assignment.

Columns Comments for SIRLVAS_PRIMARY_IND (# 9)

Source Code Comments

The primary instructor of the course.

Columns Comments for SIRLVAS_OVERRIDE_IND (# 10)

Source Code Comments

Override Indicator.

Columns Comments for SIRLVAS_POSITION (# 11)

Source Code Comments

Faculty Position.

Columns Comments for SIRLVAS_FCNT_CODE (# 12)

Source Code Comments

The contract type that the instructional assignment is associated with.

Columns Comments for SIRLVAS_POSN (# 13)

Source Code Comments

Position number.

Columns Comments for SIRLVAS_SUFF (# 14)

Source Code Comments

Position number suffix.

Columns Comments for SIRLVAS_ASTY_CODE (# 15)

Source Code Comments

Assignment Type Code

Table SIRNIST

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRNIST_TERM_CODE	VARCHAR2(6)	No	*
SIRNIST_PIDM	NUMBER(8,0)	No
SIRNIST_NIST_CODE	VARCHAR2(4)	Yes	*
SIRNIST_COLL_CODE	VARCHAR2(2)	Yes	*
SIRNIST_DEPT_CODE	VARCHAR2(4)	Yes	*
SIRNIST_NIST_WORKLOAD	NUMBER(9,3)	Yes
SIRNIST_TOPS_CODE	VARCHAR2(6)	Yes	*
SIRNIST_ACTIVITY_DATE	DATE	No
SIRNIST_FCNT_CODE	VARCHAR2(2)	Yes	*
SIRNIST_POSN	VARCHAR2(6)	Yes
SIRNIST_SUFF	VARCHAR2(2)	Yes
SIRNIST_ASTY_CODE	VARCHAR2(4)	Yes	*
SIRNIST_WEEKLY_HRS	NUMBER(9,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRNIST_COLL_CODE	STVCOLL_CODE	STVCOLL
SIRNIST_DEPT_CODE	STVDEPT_CODE	STVDEPT
SIRNIST_ASTY_CODE	STVASTY_CODE	STVASTY
SIRNIST_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRNIST_NIST_CODE	STVNIST_CODE	STVNIST
SIRNIST_TOPS_CODE	STVTOPS_CODE	STVTOPS
SIRNIST_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SIRNIST_KEY_INDEX		SIRNIST_TERM_CODE
SIRNIST_KEY_INDEX		SIRNIST_PIDM
SIRNIST_KEY_INDEX		SIRNIST_NIST_CODE
SIRNIST_KEY_INDEX		SIRNIST_COLL_CODE
SIRNIST_KEY_INDEX		SIRNIST_DEPT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_CONCAT_SIRNIST	SQL Function	S10B80.BANINST1	Use (select)
F_GET_DESCRIPTION	SQL Function	S10B80.BANINST1	Rely On
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_FACULTY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_FACULTY	Use (Insert)
F_ACTIVE_LIMIT	Oracle Package Function	S10B80.BANINST1.SIKLOAD	Rely On
F_NIST_COMPENSATION_APPLIED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_NIST_COMPENSATION_EXTRACTED	Oracle Package Function	S10B80.BANINST1.SIKAFLA	Rely On
F_SIRNIST_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Rely On
F_SIRNIST_VALUE	Oracle Package Function	S10B80.BANINST1.SIKLIBS	Use (select)Rely On
SIRNIST	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
SIRNIST_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVASTY	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	SQL Table	S10B80.SATURN	Refer (no action)
STVNIST	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVTOPS	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIRNIST

Object Dates

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

Source Code Comments

Faculty Member Non-instructional Assignment Repeating Table

Columns Comments for SIRNIST_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member assignment

Columns Comments for SIRNIST_PIDM (# 2)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRNIST_NIST_CODE (# 3)

Source Code Comments

The non-instructional type code

Columns Comments for SIRNIST_COLL_CODE (# 4)

Source Code Comments

The non-instructional college code

Columns Comments for SIRNIST_DEPT_CODE (# 5)

Source Code Comments

The non-instructional department code

Columns Comments for SIRNIST_NIST_WORKLOAD (# 6)

Source Code Comments

The non-instructional workload value

Columns Comments for SIRNIST_TOPS_CODE (# 7)

Source Code Comments

The TOP or CSS code

Columns Comments for SIRNIST_ACTIVITY_DATE (# 8)

Source Code Comments

Activity date

Columns Comments for SIRNIST_FCNT_CODE (# 9)

Source Code Comments

The contract type that the non-instructional assignment is associated with

Columns Comments for SIRNIST_POSN (# 10)

Source Code Comments

This field is the Non-instructional position number. It is used to tie the faculty member's assignment to a position defined in the BANNER Human Resources System

Columns Comments for SIRNIST_SUFF (# 11)

Source Code Comments

This field is the Non-instructional position number suffix. It is used to tie the faculty member's assignment to a position defined in the BANNER Human Resources System

Columns Comments for SIRNIST_ASTY_CODE (# 12)

Source Code Comments

Faculty Assignment Type Code

Columns Comments for SIRNIST_WEEKLY_HRS (# 13)

Source Code Comments

Weekly Contact Hours

Table SIRNLVA

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
SIRNLVA_TERM_CODE	VARCHAR2(6)	No	*
SIRNLVA_PIDM	NUMBER(8,0)	No
SIRNLVA_ACTIVITY_DATE	DATE	No
SIRNLVA_NIST_CODE	VARCHAR2(4)	Yes	*
SIRNLVA_COLL_CODE	VARCHAR2(2)	Yes	*
SIRNLVA_DEPT_CODE	VARCHAR2(4)	Yes	*
SIRNLVA_NIST_WORKLOAD	NUMBER(9,3)	Yes
SIRNLVA_NIST_WEEKLY_HRS	NUMBER(9,3)	Yes
SIRNLVA_TOPS_CODE	VARCHAR2(6)	Yes	*
SIRNLVA_FCNT_CODE	VARCHAR2(2)	Yes	*
SIRNLVA_POSN	VARCHAR2(6)	Yes
SIRNLVA_SUFF	VARCHAR2(2)	Yes
SIRNLVA_ASTY_CODE	VARCHAR2(4)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRNLVA_ASTY_CODE	STVASTY_CODE	STVASTY
SIRNLVA_COLL_CODE	STVCOLL_CODE	STVCOLL
SIRNLVA_DEPT_CODE	STVDEPT_CODE	STVDEPT
SIRNLVA_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRNLVA_NIST_CODE	STVNIST_CODE	STVNIST
SIRNLVA_TERM_CODE	STVTERM_CODE	STVTERM
SIRNLVA_TOPS_CODE	STVTOPS_CODE	STVTOPS

Index

Index Name	Index Type	Column Name
SIRNLVA_KEY_INDEX	Unique	SIRNLVA_TERM_CODE
SIRNLVA_KEY_INDEX	Unique	SIRNLVA_PIDM
SIRNLVA_KEY_INDEX	Unique	SIRNLVA_NIST_CODE
SIRNLVA_KEY_INDEX	Unique	SIRNLVA_COLL_CODE
SIRNLVA_KEY_INDEX	Unique	SIRNLVA_DEPT_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIRNLVA_KEY_INDEX	SQL Index	S10B80.SATURN	Rely On
STVASTY	SQL Table	S10B80.SATURN	Refer (no action)
STVCOLL	SQL Table	S10B80.SATURN	Refer (no action)
STVDEPT	SQL Table	S10B80.SATURN	Refer (no action)
STVFCNT	SQL Table	S10B80.SATURN	Refer (no action)
STVNIST	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)
STVTOPS	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SIRNLVA

Object Dates

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

Source Code Comments

Faculty Leave Non-Instructional Assignment Table

Columns Comments for SIRNLVA_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member leave assignment.

Columns Comments for SIRNLVA_PIDM (# 2)

Source Code Comments

The pidm of the faculty member.

Columns Comments for SIRNLVA_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Columns Comments for SIRNLVA_NIST_CODE (# 4)

Source Code Comments

The non-instructional type code.

Columns Comments for SIRNLVA_COLL_CODE (# 5)

Source Code Comments

The non-instructional college code

Columns Comments for SIRNLVA_DEPT_CODE (# 6)

Source Code Comments

The non-instructional department code.

Columns Comments for SIRNLVA_NIST_WORKLOAD (# 7)

Source Code Comments

The non-instructional workload value.

Columns Comments for SIRNLVA_NIST_WEEKLY_HRS (# 8)

Source Code Comments

The non-instructional weekly contact hours.

Columns Comments for SIRNLVA_TOPS_CODE (# 9)

Source Code Comments

The TOP of CSS code.

Columns Comments for SIRNLVA_FCNT_CODE (# 10)

Source Code Comments

The contract type that the non-instructional assignment is associated with.

Columns Comments for SIRNLVA_POSN (# 11)

Source Code Comments

Position number.

Columns Comments for SIRNLVA_SUFF (# 12)

Source Code Comments

Position number suffix.

Columns Comments for SIRNLVA_ASTY_CODE (# 13)

Source Code Comments

Assignment Type Code

Table SIROFFC

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
SIROFFC_TERM_CODE	VARCHAR2(6)	No	*	*
SIROFFC_CRN	VARCHAR2(30)	No	*	*
SIROFFC_PIDM	NUMBER(8,0)	No		*
SIROFFC_FROM_DATE	DATE	No	*
SIROFFC_TO_DATE	DATE	No	*
SIROFFC_FROM_TIME	VARCHAR2(4)	No	*
SIROFFC_TO_TIME	VARCHAR2(4)	No	*
SIROFFC_DISPLAY_IND	VARCHAR2(1)	No
SIROFFC_ACTIVITY_DATE	DATE	No
SIROFFC_USER_ID	VARCHAR2(30)	No
SIROFFC_LOCATION	VARCHAR2(100)	Yes
SIROFFC_TELE_CODE	VARCHAR2(4)	Yes		*
SIROFFC_PHONE_AREA	VARCHAR2(6)	Yes
SIROFFC_PHONE_NUMBER	VARCHAR2(12)	Yes
SIROFFC_PHONE_EXTN	VARCHAR2(10)	Yes
SIROFFC_SUN_DAY	VARCHAR2(1)	Yes
SIROFFC_MON_DAY	VARCHAR2(1)	Yes
SIROFFC_TUE_DAY	VARCHAR2(1)	Yes
SIROFFC_WED_DAY	VARCHAR2(1)	Yes
SIROFFC_THU_DAY	VARCHAR2(1)	Yes
SIROFFC_FRI_DAY	VARCHAR2(1)	Yes
SIROFFC_SAT_DAY	VARCHAR2(1)	Yes
SIROFFC_CTRY_CODE_PHONE	VARCHAR2(4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIROFFC_TELE_CODE	STVTELE_CODE	STVTELE
SIROFFC_TERM_CODE	STVTERM_CODE	STVTERM
SIROFFC_PIDM	SIRASGN_PIDM	SIRASGN
SIROFFC_CRN	SIRASGN_CRN	SIRASGN
SIROFFC_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN

Index

Index Name	Index Type	Column Name
PK_SIROFFC	Unique	SIROFFC_TERM_CODE
PK_SIROFFC	Unique	SIROFFC_CRN
PK_SIROFFC	Unique	SIROFFC_FROM_DATE
PK_SIROFFC	Unique	SIROFFC_TO_DATE
PK_SIROFFC	Unique	SIROFFC_FROM_TIME
PK_SIROFFC	Unique	SIROFFC_TO_TIME

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIROFFC_C	Oracle Package Cursor	S10B80.BANINST1.BWCKFRMT	Use (select)
SIROFFC_C	Oracle Package Cursor	S10B80.BANINST1.BWLKOFFH	Use (select)
SIROFFC_PRIM_C	Oracle Package Cursor	S10B80.BANINST1.BWLKOFFH	Use (select)
P_FACSCHED	Oracle Package Procedure	S10B80.BANINST1.BWLKIFAC	Use (select)
P_FAC_OFFICE_HRS_POST	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Use (Insert,delete)
P_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWCKFRMT	Use (select)
P_SEL_OFFICE_HOURS	Oracle Package Procedure	S10B80.BANINST1.BWLKOFFH	Rely On
F_GET_OHR	Oracle Package Function	S10B80.BANINST1.BWLCBREF	Use (select)
F_OFFICE_HOURS_EXIST	Oracle Package Function	S10B80.BANINST1.BWLKASGN	Use (select)
SIROFFC	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_SIROFFC	SQL Index	S10B80.SATURN	Rely On
SIRASGN	SQL Table	S10B80.SATURN	Join
STVTELE	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.SIROFFC

Object Dates

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

Source Code Comments

This table permits the display and maintenance of an instructor's office hours.

Columns Comments for SIROFFC_TERM_CODE (# 1)

Source Code Comments

Term code: The term code that the data is associated with.

Columns Comments for SIROFFC_CRN (# 2)

Source Code Comments

Course Reference Number: The crn of the section that the data is associated with.

Columns Comments for SIROFFC_PIDM (# 3)

Source Code Comments

Person Internal Identification Number: The pidm of the instructor that the data is associated with.

Columns Comments for SIROFFC_FROM_DATE (# 4)

Source Code Comments

From Date: This date represents the beginning date of an effective date range for the asociated office hours.

Columns Comments for SIROFFC_TO_DATE (# 5)

Source Code Comments

To Time: This time represents the end time of a period of time the instructor will be availble to students.

Columns Comments for SIROFFC_FROM_TIME (# 6)

Source Code Comments

From Time: This time represents the beginning time of a period of time the instructor will be available to students.

Columns Comments for SIROFFC_DISPLAY_IND (# 8)

Source Code Comments

Display Indicator: This indicator controls the display of information to the student.

Columns Comments for SIROFFC_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for SIROFFC_USER_ID (# 10)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for SIROFFC_LOCATION (# 11)

Source Code Comments

Location: User defined field to contain any type of location description.

Columns Comments for SIROFFC_TELE_CODE (# 12)

Source Code Comments

Phone Type: This field contains the phone type used to retrieve data from SPRTELE if desired.

Columns Comments for SIROFFC_PHONE_AREA (# 13)

Source Code Comments

Phone Area Code: This field contains the phone area code.

Columns Comments for SIROFFC_PHONE_NUMBER (# 14)

Source Code Comments

Phone Number: This field contains the 7 digit phone number.

Columns Comments for SIROFFC_PHONE_EXTN (# 15)

Source Code Comments

Phone Extension: This field contains the phone number extension.

Columns Comments for SIROFFC_SUN_DAY (# 16)

Source Code Comments

Sunday day of week: indicates the activity takes place on Sunday.

Columns Comments for SIROFFC_MON_DAY (# 17)

Source Code Comments

Monday day of week: indicates the activity takes place on Monday.

Columns Comments for SIROFFC_TUE_DAY (# 18)

Source Code Comments

Tuesday day of week: indicates the activity takes place on Tuesday.

Columns Comments for SIROFFC_WED_DAY (# 19)

Source Code Comments

Wednesday day of week: indicates the activity takes place on Wednesday.

Columns Comments for SIROFFC_THU_DAY (# 20)

Source Code Comments

Thursday day of week: indicates the activity takes place on Thursday.

Columns Comments for SIROFFC_FRI_DAY (# 21)

Source Code Comments

Friday day of week: indicates the activity takes place on Friday.

Columns Comments for SIROFFC_SAT_DAY (# 22)

Source Code Comments

Saturday day of week: indicates the activity takes place on Saturday.

Columns Comments for SIROFFC_CTRY_CODE_PHONE (# 23)

Source Code Comments

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

Link between SIRDPCL and SIBINST

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVFACL_1 schema-view : S10B80.BANINST1.SIVFACL schema-view : S10B80.BANINST1.SIVFACL_11

Link List

Link Type	Link	Project
Join	Link Between SIRDPCL and SIBINST	SATURN

List of Real links

Link type	Between	And
Join	SIRDPCL	SIBINST

Link between SIRICNT and SIBINST

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVFACL_1 schema-view : S10B80.BANINST1.SIVINST schema-view : S10B80.BANINST1.SIVFACL schema-view : S10B80.BANINST1.SIVFACL_11

Link List

Link Type	Link	Project
Join	Link Between SIRICNT and SIBINST	SATURN

List of Real links

Link type	Between	And
Join	SIRICNT	SIBINST

Link between SIBCFTE and SIRCOLR

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVCONT schema-function : S10B80.BANINST1.F_GET_MIN_SIBCFTE_FTE_FACTOR

Link List

Link Type	Link	Project
Join	Link Between SIBCFTE and SIRCOLR	SATURN

List of Real links

Link type	Between	And
Join	SIBCFTE	SIRCOLR

Link between SIBTERM and SIRASGN

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVCONT schema-view : S10B80.BANINST1.SIVCALC schema-view : S10B80.BANINST1.SIVPFAC

Link List

Link Type	Link	Project
Join	Link Between SIBTERM and SIRASGN	SATURN

List of Real links

Link type	Between	And
Join	SIBTERM	SIRASGN

Link between SIRFCNT and SIRASGN

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVCONT

Link List

Link Type	Link	Project
Join	Link Between SIRFCNT and SIRASGN	SATURN

List of Real links

Link type	Between	And
Join	SIRFCNT	SIRASGN

Link between SIRASGN and SIRCOLR

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVCONT schema-view : S10B80.BANINST1.SIVCALC schema-view : S10B80.BANINST1.SIVPFAC

Link List

Link Type	Link	Project
Join	Link Between SIRASGN and SIRCOLR	SATURN

List of Real links

Link type	Between	And
Join	SIRASGN	SIRCOLR

Link between SIRFCNT and SIRCOLR

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVCONT

Link List

Link Type	Link	Project
Join	Link Between SIRFCNT and SIRCOLR	SATURN

List of Real links

Link type	Between	And
Join	SIRFCNT	SIRCOLR

Link between SIBFACD and SIBINST

Join Information

Objects list
schema-view : S10B80.BANINST1.SIVFACL

Link List

Link Type	Link	Project
Join	Link Between SIBFACD and SIBINST	SATURN

List of Real links

Link type	Between	And
Join	SIBFACD	SIBINST

Link between SIBINST and SIRASGN

Join Information

Objects list
scope-function : S10B80.BANINST1.BWLKILIB.F_PRIMARYFAC

Link List

Link Type	Link	Project
Join	Link Between SIBINST and SIRASGN	SATURN

List of Real links

Link type	Between	And
Join	SIBINST	SIRASGN

Link between SIROFFC and SIRASGN

Join Information

Objects list
scope-cursor : S10B80.BANINST1.BWLKOFFH.SIROFFC_PRIM_C

Link List

Link Type	Link	Project
Join	Link Between SIROFFC and SIRASGN	SATURN

List of Real links

Link type	Between	And
Join	SIROFFC	SIRASGN

Link between SIRCOLC and PK_SIRCOLC

Link List

Link Type	Link	Project
Rely On	Link Between SIRCOLC and PK_SIRCOLC	SATURN

List of Real links

Link type	Between	And
Rely On	SIRCOLC	PK_SIRCOLC

Link between SIRCOLR and PK_SIRCOLR

Link List

Link Type	Link	Project
Rely On	Link Between SIRCOLR and PK_SIRCOLR	SATURN

List of Real links

Link type	Between	And
Rely On	SIRCOLR	PK_SIRCOLR

Link between SIRLVAS and PK_SIRLVAS

Link List

Link Type	Link	Project
Rely On	Link Between SIRLVAS and PK_SIRLVAS	SATURN

List of Real links

Link type	Between	And
Rely On	SIRLVAS	PK_SIRLVAS

Link between SIROFFC and PK_SIROFFC

Link List

Link Type	Link	Project
Rely On	Link Between SIROFFC and PK_SIROFFC	SATURN

List of Real links

Link type	Between	And
Rely On	SIROFFC	PK_SIROFFC

Link between SIBINST and PK_SIBINST

Link List

Link Type	Link	Project
Rely On	Link Between SIBINST and PK_SIBINST	SATURN

List of Real links

Link type	Between	And
Rely On	SIBINST	PK_SIBINST

Link between SIBFACD and PK_SIBFACD

Link List

Link Type	Link	Project
Rely On	Link Between SIBFACD and PK_SIBFACD	SATURN

List of Real links

Link type	Between	And
Rely On	SIBFACD	PK_SIBFACD

Link between SIRASGN and PK_SIRASGN

Link List

Link Type	Link	Project
Rely On	Link Between SIRASGN and PK_SIRASGN	SATURN

List of Real links

Link type	Between	And
Rely On	SIRASGN	PK_SIRASGN

Link between SIBTERM and PK_SIBTERM

Link List

Link Type	Link	Project
Rely On	Link Between SIBTERM and PK_SIBTERM	SATURN

List of Real links

Link type	Between	And
Rely On	SIBTERM	PK_SIBTERM