Model Faculty Load Tables

Model Label : Tables used for Banner Student Faculty Load

List of Objects

Object Name	Object Type	Layer Name
SIBCFTE	TABLE	Default
SIBFACD	TABLE	Default
SIBFACD_TMP	TABLE	Default
SIBINST	TABLE	Default
SIBTERM	TABLE	Default
SIRASGN	TABLE	Default
SIRATTR	TABLE	Default
SIRCMNT	TABLE	Default
SIRCOLC	TABLE	Default
SIRCOLR	TABLE	Default
SIRDPCL	TABLE	Default
SIRFCNT	TABLE	Default
SIRFLCT	TABLE	Default
SIRFLRC	TABLE	Default
SIRFLRT	TABLE	Default
SIRICNT	TABLE	Default
SIRLVAS	TABLE	Default
SIRNIST	TABLE	Default
SIRNLVA	TABLE	Default
SIROFFC	TABLE	Default

Comments

Model View

Table SIBCFTE

Schema Name SATURN
Label SIBCFTE
Server name S4B70
Creation Date 09/29/2003 12:09:43:000

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBCFTE_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIBCFTE_FCNT_CODE	STVFCNT_CODE	STVFCNT
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
get_term_fte	C/C++ Function	[F:\BANNER\C\SIRCTAL.PC]	Use(select )
termeff	C/C++ Function	[F:\BANNER\C\SIRCTAL.PC]	Use(select )
SIBCFTE	SYNONYM	S4B70.PUBLIC	Rely on ()
SIVCONT	VIEW	S4B70.BANINST1	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.SIACONA	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.SIACONA	Use(select )
INST_SUMMARY	Forms Trigger	BANNER7_FORMS.SIACONA	Use(select )
INST_SUMMARY	Forms Trigger	BANNER7_FORMS_10G.SIACONA	Use(select )
INST_SUMMARY2	Forms Trigger	BANNER7_FORMS.SIACONA	Use(select )
INST_SUMMARY2	Forms Trigger	BANNER7_FORMS_10G.SIACONA	Use(select )
END_FLRC_TERM	Forms Trigger	BANNER7_FORMS.SIACFTE.SIBCFTE	Use(insert )
END_FLRC_TERM	Forms Trigger	BANNER7_FORMS_10G.SIACFTE.SIBCFTE	Use(insert )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS.SIACFTE.SIBCFTE	Use(insert,select )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS_10G.SIACFTE.SIBCFTE	Use(insert,select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SIACFTE.SIBCFTE	Use(delete )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SIACFTE.SIBCFTE	Use(delete )
PRE-QUERY	Forms Trigger	BANNER7_FORMS.SIACFTE.SIBCFTE	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS_10G.SIACFTE.SIBCFTE	Use(select )
SELECT_SIBCFTE_3	Forms Function	BANNER7_FORMS.SIACONA	Use(select )
SELECT_SIBCFTE_3	Forms Function	BANNER7_FORMS_10G.SIACONA	Use(select )
SIBCFTE	Forms DataBlock	BANNER7_FORMS.SIACFTE	Rely on () Use(insert,update,delete,select )
SIBCFTE	Forms DataBlock	BANNER7_FORMS_10G.SIACFTE	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBCFTE_KEY_INDEX	INDEX	S4B70.SATURN	Rely on ()
SIRCOLR	TABLE	S4B70.SATURN	Join
STVFCNT	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

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

Schema Name SATURN
Label SIBFACD
Server name S4B70
Creation Date 09/09/2004 23:42:32:000

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBFACD_TENR_CODE	PTRTENR_CODE	PTRTENR

Index

Index Name	Index Type	Column Name
PK_SIBFACD	Unique	SIBFACD_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
get_academic_title	C/C++ Function	[F:\BANNER\C\ICGORLDI.PC]	Use(select )
sel_a_tenure	C/C++ Function	[F:\BANNER\C\PERAPND.PC]	Use(select )
sel_all_tenure_count	C/C++ Function	[F:\BANNER\C\PERAPND.PC]	Use(select )
sel_hire_fac_mem	C/C++ Function	[F:\BANNER\C\PEREO61.PC]	Use(select )
sel_hire_other_mem	C/C++ Function	[F:\BANNER\C\PEREO61.PC]	Use(select )
sel_rank_mem	C/C++ Function	[F:\BANNER\C\PEREO61.PC]	Use(select )
sel_ten_other	C/C++ Function	[F:\BANNER\C\PEREO61.PC]	Use(select )
sel_tenr_info	C/C++ Function	[F:\BANNER\C\PEREO6D.PC]	Use(select )
sel_tenure	C/C++ Function	[F:\BANNER\C\PERAPND.PC]	Use(select )
sel_tenure_count	C/C++ Function	[F:\BANNER\C\PERAPND.PC]	Use(select )
SIBFACD	SYNONYM	S4B70.PUBLIC	Rely on ()
ST_SIBFACD_AR_LDI	TRIGGER	S4B70.SATURN	Rely on ()
AS_FACULTY	VIEW	S4B70.BANINST1	Use(select )
PPVFACD	VIEW	S4B70.BANINST1	Use(select )
SIVFAC2	VIEW	S4B70.BANINST1	Use(select )
SIVFACD	VIEW	S4B70.BANINST1	Use(select )
SIVFACL	VIEW	S4B70.BANINST1	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SIAIQRY.SIVFACQ	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SIAIQRY.SIVFACQ	Use(select )
P_GETFACULTYRANKANDTENURE	Package procedure	S4B70.BANINST1.PEKWEMP	Use(select )
ACADEMIC_TITLE_C	Package cursor	S4B70.BANINST1.ICSPKCOM	Use(select )
ACADEMIC_TITLE_C	Package cursor	S4B70.BANINST1.ICSPKCOM	Rely on ()
F_GETTENUREDESC	Package function	S4B70.BANINST1.BWPKSJOB	Use(select )
P_SEND_PERSON	Package procedure	S4B70.BANINST1.ICSPKLDI	Rely on ()
F_GET_ACADEMIC_TITLE	Package function	S4B70.BANINST1.ICSPKCOM	Rely on ()
F_GET_RANK_CODE	Package function	S4B70.BANINST1.NBKBUDG	Use(select )
SIBFACD	Forms DataBlock	BANNER7_FORMS.PEAFACD	Rely on () Use(insert,update,delete,select )
SIBFACD	Forms DataBlock	BANNER7_FORMS_10G.SIAFPER	Rely on () Use(insert,update,delete,select )
SIBFACD	Forms DataBlock	BANNER7_FORMS_10G.PEAFACD	Rely on () Use(insert,update,delete,select )
SIBFACD	Forms DataBlock	BANNER7_FORMS.SIAFPER	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SIBFACD	INDEX	S4B70.SATURN	Rely on ()
ST_SIBFACD_AR_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update,delete after each row )
ST_SIBFACD_AS_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update,delete after all rows )
PTRTENR	TABLE	S4B70.PAYROLL	Refer( No Action )

Comments

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

Schema Name SATURN
Label SIBFACD_TMP
Server name S4B70
Creation Date 07/21/2003 16:28:22:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SIBFACD_TMP	SYNONYM	S4B70.PUBLIC	Rely on ()

Comments

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

Schema Name SATURN
Label SIBINST
Server name S4B70
Creation Date 09/10/2004 01:06:49:000

Table Columns information

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

Foreign Key information

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

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
MAA3	Cobol Paragraph	[F:\banner\cobol].SERXEREC.MAA-MAINLINE-SECT	Use(select )
sel_sivfacq	C/C++ Function	[F:\BANNER\C\PEPFACL.PC]	Use(select )
selfac1	C/C++ Function	[F:\BANNER\C\SPRPDIR.PC]	Use(select )
selfact	C/C++ Function	[F:\BANNER\C\SPRPDIR.PC]	Use(select )
selfact_nopop	C/C++ Function	[F:\BANNER\C\SPRPDIR.PC]	Use(select )
selinstr	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(select )
validate	C/C++ Function	[F:\BANNER\C\SFPAGRD.PC]	Use(select )
writeUser	C/C++ Function	[F:\BANNER\C\ICSORIMS.PC]	Use(select )
write_user	C/C++ Function	[F:\BANNER\C\ICSORSPF.PC]	Use(select )
ST_SIBINST_AR_LDI	TRIGGER	S4B70.SATURN	Rely on ()
SIRICNT	TABLE	S4B70.SATURN	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
AS_FACULTY	VIEW	S4B70.BANINST1	Use(select )
SIVFAC2	VIEW	S4B70.BANINST1	Use(select )
SIVFACL	VIEW	S4B70.BANINST1	Use(select )
SIVFACQ	VIEW	S4B70.BANINST1	Use(select )
SIVINST	VIEW	S4B70.BANINST1	Use(select )
CHECK_ADVR	Forms Trigger	BANNER7_FORMS.SHANCRS.SHRNCRS.ADVR_ID	Use(select )
CHECK_ADVR	Forms Trigger	BANNER7_FORMS_10G.SHANCRS.SHRNCRS.ADVR_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHATCKC.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHATCKS.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SIRASGN.SIRASGN_IDNO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHATCKP.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHATCKP.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHATCKS.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHATCKC.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHATCKN.SHRINST.SHRINST_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SIRASGN.SIRASGN_IDNO	Use(select )
CHECK_INST	Forms Trigger	BANNER7_FORMS.SIAINST	Use(select )
CHECK_INST	Forms Trigger	BANNER7_FORMS_10G.SIAINST	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.SIAASGN	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.SIALVAS	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.SIAASGN	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.SIALVAS	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SOAFAVQ.SIVINST	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SIAFAVL.SIVINST	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SIIINST.SIBINST	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SIAFAVL.SIVINST	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SOAFAVQ.SIVINST	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SIIINST.SIBINST	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SGAADVR.SGRADVR	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SGAADVR.SGRADVR	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS.SIAINST.SIBINST	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS_10G.SIAINST.SIBINST	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.SGAADVR.SGRADVR	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SGAADVR.SGRADVR	Use(select )
ADDL_STUDENT_DATA	Forms Procedure	BANNER7_FORMS.SOASRVW	Use(select )
ADDL_STUDENT_DATA	Forms Procedure	BANNER7_FORMS_10G.SOASRVW	Use(select )
F_STUDENT_FACULTY_IND	FUNCTION	S4B70.BANINST1	Use(select )
SELECT_SIBINST_2	Forms Function	BANNER7_FORMS.SIACONA	Use(select )
SELECT_SIBINST_2	Forms Function	BANNER7_FORMS_10G.SIACONA	Use(select )
FACULTY_REC	Package Type	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_OVERLAY_VALIDATION_REC	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
UT_SB_FACULTYCREATEAPI	Package procedure	S4B70.BANINST1.UT_SB_FACULTY	Use(insert )
UT_SB_FACULTYDELETEAPI	Package procedure	S4B70.BANINST1.UT_SB_FACULTY	Use(insert )
UT_SB_FACULTYUPDATEAPI	Package procedure	S4B70.BANINST1.UT_SB_FACULTY	Use(insert )
F_BUILD_SIBINST_REC	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_BUILD_SIBINST_REC	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_HAS_ROLE	Package function	S4B70.BANINST1.ICGOKROL	Use(select )
P_ADVENTERID	Package procedure	S4B70.BANINST1.BWLKOIDS	Use(select )
P_CREATE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.DML_SIBINST	Use(delete )
P_FACADVRSECURITY	Package procedure	S4B70.BANINST1.BWLKSECR	Use(select )
P_FACENTERID	Package procedure	S4B70.BANINST1.BWLKOIDS	Use(select )
P_INSERT	Package procedure	S4B70.BANINST1.DML_SIBINST	Rely on () Use(insert )
P_LOCK	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_LOCK	Package procedure	S4B70.BANINST1.SB_FACULTY	Use(select )
P_REGISTER_ENTITY	Package procedure	S4B70.BANINST1.SB_FACULTY_RULES	Rely on ()
P_SEND_ADD_NEW_FAC_USER	Package procedure	S4B70.BANINST1.ICSIKSEV	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.SB_FACULTY	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.DML_SIBINST	Rely on ()
P_VALIDATE	Package procedure	S4B70.BANINST1.SB_FACULTY_RULES	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_FACASSIGNMENT	Use(insert,select )
FACULTY_STVTERMC	Package cursor	S4B70.BANINST1.SFKCURS	Use(select )
SIBINSTC	Package cursor	S4B70.BANINST1.BWLKILIB	Rely on () Use(select )
SIBINST_C	Package cursor	S4B70.BANINST1.SIKLIBS	Rely on ()
SIBINST_C	Package cursor	S4B70.BANINST1.SIKLIBS	Rely on () Use(select )
SIBINST_COUNT_C	Package cursor	S4B70.BANINST1.ICSIKLIB	Rely on ()
SIBINST_NEXT_C	Package cursor	S4B70.BANINST1.SIKLIBS	Rely on ()
SIBINST_NEXT_C	Package cursor	S4B70.BANINST1.SIKLIBS	Rely on () Use(select )
F_ACTIVEFACADVR	Package function	S4B70.BANINST1.BWLKILIB	Rely on ()
F_ACTIVEFACADVR	Package function	S4B70.BANINST1.BWLKILIB	Rely on ()
F_EXISTS	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_EXISTS	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_GET_END_SIBINST_TERM	Package function	S4B70.BANINST1.SOKODSF	Use(select )
F_PERSON_IS_FACULTY	Package function	S4B70.BANINST1.SIKLIBS	Rely on ()
F_PERSON_IS_FACULTY	Package function	S4B70.BANINST1.SIKLIBS	Rely on ()
F_PRIMARYFAC	Package function	S4B70.BANINST1.BWLKILIB	Rely on ()
F_PRIMARYFAC	Package function	S4B70.BANINST1.BWLKILIB	Rely on () Use(select )
F_QUERY_ALL	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_QUERY_ALL	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_QUERY_BY_ROWID	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_QUERY_ONE	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_QUERY_ONE	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_QUERY_ONE_SCHEDULED	Package function	S4B70.BANINST1.SB_FACULTY	Use(select )
F_QUERY_ONE_SCHEDULED	Package function	S4B70.BANINST1.SB_FACULTY	Rely on ()
F_VALIDFAC	Package function	S4B70.BANINST1.BWLKILIB	Rely on ()
F_VALIDFAC	Package function	S4B70.BANINST1.BWLKILIB	Rely on () Use(select )
SIBINST	SYNONYM	S4B70.PUBLIC	Rely on ()
SIBINST	Forms DataBlock	BANNER7_FORMS.SIIINST	Rely on () Use(select )
SIBINST	Forms DataBlock	BANNER7_FORMS_10G.SIAINST	Rely on () Use(insert,update,delete,select )
SIBINST	Forms DataBlock	BANNER7_FORMS_10G.SIIINST	Rely on () Use(select )
SIBINST	Forms DataBlock	BANNER7_FORMS.SIAINST	Rely on () Use(insert,update,delete,select )
WORKLOAD	Forms DataBlock	BANNER7_FORMS.SIAASGN	Rely on () Use(insert,update,delete,select )
WORKLOAD	Forms DataBlock	BANNER7_FORMS_10G.SIAASGN	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SIBINST	INDEX	S4B70.SATURN	Rely on ()
ST_ICAIR_ADD_NEW_FAC_USER	TRIGGER	S4B70.SATURN	Fire(insert after each row )
ST_ICAIS_ADD_NEW_FAC_USER	TRIGGER	S4B70.SATURN	Fire(insert after all rows )
ST_ICBIS_ADD_NEW_FAC_USER	TRIGGER	S4B70.SATURN	Fire(insert before all rows )
ST_SIBINST_AIR	TRIGGER	S4B70.SATURN	Fire(insert after each row )
ST_SIBINST_AIR_IC	TRIGGER	S4B70.SATURN	Fire(insert after each row )
ST_SIBINST_AIS	TRIGGER	S4B70.SATURN	Fire(insert after all rows )
ST_SIBINST_AIS_IC	TRIGGER	S4B70.SATURN	Fire(insert after all rows )
ST_SIBINST_AR_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update,delete after each row )
ST_SIBINST_AS_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update,delete after all rows )
ST_SIBINST_AUR_IC	TRIGGER	S4B70.SATURN	Fire(update after each row )
ST_SIBINST_AUS_IC	TRIGGER	S4B70.SATURN	Fire(update after all rows )
STVCNTR	TABLE	S4B70.SATURN	Refer( No Action )
STVFCNT	TABLE	S4B70.SATURN	Refer( No Action )
STVFCST	TABLE	S4B70.SATURN	Refer( No Action )
STVFCTG	TABLE	S4B70.SATURN	Refer( No Action )
STVFSTP	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )
STVWKLD	TABLE	S4B70.SATURN	Refer( No Action )

Comments

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

Schema Name SATURN
Label SIBTERM
Server name S4B70
Creation Date 09/29/2003 12:09:44:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SIBTERM_TERM_CODE	SIBTERM_TERM_CODE	VARCHAR2(6)	No	*	*
SIBTERM_FTE_FACTOR	SIBTERM_FTE_FACTOR	NUMBER(3,0)	No
SIBTERM_CALC_DEV_FACTOR	SIBTERM_CALC_DEV_FACTOR	NUMBER(3,0)	No
SIBTERM_ACTIVITY_DATE	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
MAA3	Cobol Paragraph	[F:\banner\cobol].SERXFREC.MAA-MAINLINE-SECT	Use(select )
NBB2	Cobol Paragraph	[F:\banner\cobol].SERXEREC.NBB-CALC-FTE	Use(select )
find_term_fte	C/C++ Function	[F:\BANNER\C\SIRASGQ.PC]	Use(select )
get_fcnt_wkld	C/C++ Function	[F:\BANNER\C\SIRCTAL.PC]	Use(select )
get_term_fte	C/C++ Function	[F:\BANNER\C\SIRTRAL.PC]	Use(select )
get_workload	C/C++ Function	[F:\BANNER\C\SIRTRAL.PC]	Use(select )
sel_faculty_fte1	C/C++ Function	[F:\BANNER\C\PEPAEXT.PC]	Use(select )
sel_faculty_fte2	C/C++ Function	[F:\BANNER\C\PEPAEXT.PC]	Use(select )
SERXEREC	Cobol Program	F:\banner\cobol	Use()
SERXFREC	Cobol Program	F:\banner\cobol	Use()
SIVCALC	VIEW	S4B70.BANINST1	Use(select )
SIVCONT	VIEW	S4B70.BANINST1	Use(select )
SIVPFAC	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.KEY_BLOCK.SSASECT_TERM_CODE	Use(select )