SIBCFTE SIBFACD SIBFACD_TMP SIBINST SIBTERM SIRASGN SIRATTR SIRCMNT SIRCOLC SIRCOLR SIRDPCL SIRFCNT SIRFLCT SIRFLRC SIRFLRT SIRICNT SIRLVAS SIRNIST SIRNLVA SIROFFC

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 PK 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 PK FK
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 )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIALVAS.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIACONA.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SSASECT.KEY_BLOCK.SSASECT_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SSAPREQ.KEY_BLOCK.SSASECT_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIALVAS.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SSAPREQ.KEY_BLOCK.SSASECT_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIACONA.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
SIBTERM SYNONYM S4B70.PUBLIC Rely on ()
SIBTERM Forms DataBlock BANNER7_FORMS.SIATERM Rely on () Use(insert,update,delete,select )
SIBTERM Forms DataBlock BANNER7_FORMS_10G.SIATERM Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SIBTERM INDEX S4B70.SATURN Rely on ()
SIRASGN TABLE S4B70.SATURN Join
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
SIRASGN_TERM_CODE SSBSECT_TERM_CODE SSBSECT
SIRASGN_CRN SSBSECT_CRN SSBSECT
SIRASGN_ASTY_CODE STVASTY_CODE STVASTY
SIRASGN_FCNT_CODE STVFCNT_CODE STVFCNT
SIRASGN_TERM_CODE STVTERM_CODE STVTERM
SIRASGN_PIDM SIRCOLR_PIDM SIRCOLR
SIRASGN_TERM_CODE SIRCOLR_TERM_CODE SIRCOLR
SIRASGN_FCNT_CODE SIRCOLR_FCNT_CODE SIRCOLR
SIRASGN_TERM_CODE SFRSTCR_TERM_CODE SFRSTCR
SIRASGN_CRN SFRSTCR_CRN SFRSTCR

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
BAA8 Cobol Paragraph [F:\banner\cobol].SCTC1000.AA-COMMAND-SECT-END Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERXEREC.MAA-MAINLINE-SECT Use(select )
altmacro C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacroa C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacroad C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacroc C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacroca C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacrocad C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacrocd C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
altmacrod C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
calc_salary C/C++ Function [F:\BANNER\C\SIRASGQ.PC] Use(select )
countpidm C/C++ Function [F:\BANNER\C\SSRSECT.PC] Use(select )
faculty_body C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use()
get_fcnt_wkld C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
get_prog_type C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use()
get_workload C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
get_workload2 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
lock_tables C/C++ Function [F:\BANNER\C\SSRROLL.PC] Use()
locktbl C/C++ Function [F:\BANNER\C\SSPSCHD.PC] Use()
sb_sel_sched_data C/C++ Function [F:\BANNER\C\TSRCBIL.PC] Use(select )
sel_faculty C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_faculty_fte1 C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_faculty_weekly_hrs C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_pebempl C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_pebempl1 C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_sched_data C/C++ Function [F:\BANNER\C\TSRTBIL.PC] Use(select )
sel_sched_data_rq C/C++ Function [F:\BANNER\C\TSRTBIL.PC] Use(select )
sel_sirasgn C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_student_courses C/C++ Function [F:\BANNER\C\ISRKSCH.PC] Use(select )
selasgn C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selasgn C/C++ Function [F:\BANNER\C\SSRROLL.PC] Use(select )
selbldg C/C++ Function [F:\BANNER\C\ISRKCRS.PC] Use(select )
selcolr1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_1 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_2 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_2 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_3 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_3 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selins C/C++ Function [F:\BANNER\C\SSPSCHD.PC] Use(select )
selmacro C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacro1 C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(select )
selmacroa C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacroad C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacroc C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacroca C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacrocad C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacrocd C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selmacrod C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selpidm C/C++ Function [F:\BANNER\C\SFRSLST.PC] Use(select )
selpidm C/C++ Function [F:\BANNER\C\SSRSECT.PC] Use(select )
writeInstruct C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
writeUser C/C++ Function [F:\BANNER\C\ICSORIMS.PC] Use(select )
write_assignments C/C++ Function [F:\BANNER\C\ICGORLDI.PC] Use(select )
write_instruct C/C++ Function [F:\BANNER\C\ICSORSPF.PC] Use(select )
ST_SIRASGN_AR_LDI TRIGGER S4B70.SATURN Rely on ()
SIBTERM TABLE S4B70.SATURN Join
SIRFCNT TABLE S4B70.SATURN Join
SPRIDEN TABLE S4B70.SATURN Join
SSRMEET TABLE S4B70.SATURN Join
SSRXLST TABLE S4B70.SATURN Join
AS_INSTRUCTIONAL_ASSIGNMENT VIEW S4B70.BANINST1 Use(select )
SFVSTMS VIEW S4B70.BANINST1 Use(select )
SFVTFAN VIEW S4B70.BANINST1 Use(select )
SIVASGN VIEW S4B70.BANINST1 Use(select )
SIVCALC VIEW S4B70.BANINST1 Use(select )
SIVCONT VIEW S4B70.BANINST1 Use(select )
SIVPFAC VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST.SIBINST_FCST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST.SIBINST_FCST_CODE Use(select )
CHECK_INST Forms Trigger BANNER7_FORMS.SSASECT Use(select )
CHECK_INST Forms Trigger BANNER7_FORMS_10G.SSASECT Use(select )
CHECK_PRIM_SIRASGN Forms Trigger BANNER7_FORMS.SIAASGN Use(select )
CHECK_PRIM_SIRASGN Forms Trigger BANNER7_FORMS_10G.SIAASGN Use(select )
INST_INSERT Forms Trigger BANNER7_FORMS.SSASECT Use(select )
INST_INSERT Forms Trigger BANNER7_FORMS_10G.SSASECT Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS.SIAASGN Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS_10G.SIAASGN Use(select )
SUM_WORKLOAD Forms Trigger BANNER7_FORMS.SIACONA Use(select )
SUM_WORKLOAD Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
ADD_INST Forms Trigger BANNER7_FORMS.SIAASGN.SIRASGN Use(select )
ADD_INST Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRASGN Use(select )
CHECK_PERCENT Forms Trigger BANNER7_FORMS.SSASECT.SIRASGN Use(select )
CHECK_PERCENT Forms Trigger BANNER7_FORMS_10G.SSASECT.SIRASGN Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SSASECT.SSRMEET Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SSASECT.SSRMEET Use(select )
KEY-DUP-ITEM Forms Trigger BANNER7_FORMS.SSASECT.SSRMEET Use(select )
KEY-DUP-ITEM Forms Trigger BANNER7_FORMS_10G.SSASECT.SSRMEET Use(select )
ON-DELETE Forms Trigger BANNER7_FORMS.SSASECT.SSBSECT Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS.SSASECT.SIRASGN Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.SSASECT.SIRASGN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIQSECM.SIVSECM Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIQSECM.SIVSECM Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SFAALST.SIRASGN Rely on ()
CHECK_FOR_OTHER_PRIMARY Forms Procedure BANNER7_FORMS.SIAASGN Use(select )
CHECK_FOR_OTHER_PRIMARY Forms Procedure BANNER7_FORMS_10G.SIAASGN Use(select )
CHECK_SIRASGN_DELETE Forms Procedure BANNER7_FORMS.SIAASGN Rely on ()
CHECK_SIRASGN_DELETE Forms Procedure BANNER7_FORMS_10G.SIAASGN Use(select )
CHECK_SIRASGN_DELETE Forms Procedure BANNER7_FORMS_10G.SIAASGN Rely on ()
CHECK_SIRASGN_DELETE Forms Procedure BANNER7_FORMS.SIAASGN Use(select )
DEFAULT_PRIMARY_IND Forms Procedure BANNER7_FORMS.SIAASGN Rely on ()
DEFAULT_PRIMARY_IND Forms Procedure BANNER7_FORMS.SIAASGN Use(select )
DEFAULT_PRIMARY_IND Forms Procedure BANNER7_FORMS_10G.SIAASGN Rely on ()
DEFAULT_PRIMARY_IND Forms Procedure BANNER7_FORMS_10G.SIAASGN Use(select )
GET_ADD_INST Forms Procedure BANNER7_FORMS.SIAASGN Use(select )
GET_ADD_INST Forms Procedure BANNER7_FORMS_10G.SIAASGN Use(select )
GET_SESSION Forms Procedure BANNER7_FORMS.SIAASGN Use(select )
GET_SESSION Forms Procedure BANNER7_FORMS_10G.SIAASGN Use(select )
UPDATE_SFRAREG_INSTRUCTOR Forms Procedure BANNER7_FORMS.SSASECT Rely on ()
UPDATE_SFRAREG_INSTRUCTOR Forms Procedure BANNER7_FORMS.SSASECT Use(select )
UPDATE_SFRAREG_INSTRUCTOR Forms Procedure BANNER7_FORMS_10G.SSASECT Rely on ()
UPDATE_SFRAREG_INSTRUCTOR Forms Procedure BANNER7_FORMS_10G.SSASECT Use(select )
F_FACULTY_SCHEDULED_IND FUNCTION S4B70.BANINST1 Use(select )
F_GET_INSTR_SPRIDEN_ROWID FUNCTION S4B70.BANINST1 Use(select )
F_INSTRUCTOR_FNC FUNCTION S4B70.BANINST1 Use(select )
SELECT_SIRASGN_1 Forms Function BANNER7_FORMS.SIAINST Use(select )
SELECT_SIRASGN_1 Forms Function BANNER7_FORMS_10G.SIAINST Use(select )
SIRASGN_COUNT_INST Forms Function BANNER7_FORMS.SIAASGN Use(select )
SIRASGN_COUNT_INST Forms Function BANNER7_FORMS_10G.SIAASGN Use(select )
SIRASGN_INST_EXIST Forms Function BANNER7_FORMS.SSASECT Use(select )
SIRASGN_INST_EXIST Forms Function BANNER7_FORMS_10G.SSASECT Use(select )
ASSIGNMENTS_REC_TYPE Package Type S4B70.BANINST1.ICSPKCOM Rely on ()
FACASSIGNMENT_REC Package Type S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
ASSIGN_REC_TYPE Package Type S4B70.BANINST1.ICSIKLDI Rely on ()
ENROLL_REC_TYPE Package Type S4B70.BANINST1.ICSFKLDI Rely on ()
P_BUILDSOTWREG Package procedure S4B70.BANINST1.SOKWEXT Use(select )
P_OVERLAY_VALIDATION_REC Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
DELIVERY_SYSTEM_C Package cursor S4B70.BANINST1.ICSIKCOM Rely on ()
SIRASGNC Package cursor S4B70.BANINST1.BWCKGENS Use(select )
SIRASGN_C Package cursor S4B70.BANINST1.BWCKSCHD Use(select )
SIRASGN_C Package cursor S4B70.BANINST1.ICSIKCOM Use(select )
SIRASGN_C Package cursor S4B70.BANINST1.ICSIKCOM Rely on ()
SIROFFC_PRIM_C Package cursor S4B70.BANINST1.BWLKOFFH Use(select )
CRN Package variable S4B70.BANINST1.BWLKOIDS Rely on ()
CRN Package variable S4B70.BANINST1.BWLKOCRN Rely on ()
HOLD_CRN Package variable S4B70.BANINST1.BWLKFCWL Rely on ()
F_BUILD_SIRASGN_REC Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_BUILD_SIRASGN_REC Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_CALC_ONLINETOPIC Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CALC_SOURCEDID_ID Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CALC_STATUS Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CALC_SUBROLE Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CALC_VALID_DELIVERY_SYSTEM Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CHECKFACULTYRELATION Package function S4B70.BANINST1.BWLKILIB Rely on ()
F_CHECKFACULTYRELATION Package function S4B70.BANINST1.BWLKILIB Use(select )
F_CHECK_FACUTLY_ASSGN Package function S4B70.BANINST1.SP_GRADING_RULES Rely on ()
F_GET_DASHBORD Package function S4B70.BANINST1.CLOBPERS Use(select )
F_HAS_ROLE Package function S4B70.BANINST1.ICGOKROL Use(select )
P_CREATE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_CREATE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Use(select )
P_DELETE Package procedure S4B70.BANINST1.GB_SECTION Use(delete )
P_DELETE Package procedure S4B70.BANINST1.SB_SECTION Use(delete )
P_DELETE Package procedure S4B70.BANINST1.DML_SIRASGN Use(delete )
P_DELETE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Rely on ()
P_DISPCRSESCHDDETL Package procedure S4B70.BANINST1.BWCKGENS Rely on ()
P_DISPINTABLE Package procedure S4B70.BANINST1.BWLKFROV Use(select )
P_DISP_ACTIVE_REGS Package procedure S4B70.BANINST1.BWCKGENS Rely on ()
P_DISP_MEETING_TIMES Package procedure S4B70.BANINST1.BWCKFRMT Use(select )
P_FACACTASSIGN Package procedure S4B70.BANINST1.BWLKASGN Use(select )
P_FACASSIGNHIST Package procedure S4B70.BANINST1.BWLKASGN Use(select )
P_FACCLALIST Package procedure S4B70.BANINST1.BWLKFCWL Rely on ()
P_FACCLALISTSUM Package procedure S4B70.BANINST1.BWLKFCWL Rely on ()
P_FACCRNSEL Package procedure S4B70.BANINST1.BWLKOCRN Use(select )
P_FACDISPSHRMRKS Package procedure S4B70.BANINST1.BWLKEGRB Use(select )
P_FACDISPSHRSMRK Package procedure S4B70.BANINST1.BWLKEGRB Use(select )
P_FACIDSHRMRKSPROC Package procedure S4B70.BANINST1.BWLKEGRB Use(select )
P_FACIDSHRSMRKPROC Package procedure S4B70.BANINST1.BWLKEGRB Use(select )
P_FACMIDGRD Package procedure S4B70.BANINST1.BWLKFMGD Rely on ()
P_FACSCHED Package procedure S4B70.BANINST1.BWLKIFAC Use(select )
P_FACSTORECRN Package procedure S4B70.BANINST1.BWLKOCRN Rely on ()
P_FACWAITLIST Package procedure S4B70.BANINST1.BWLKFCWL Rely on ()
P_FACWAITLISTSUM Package procedure S4B70.BANINST1.BWLKFCWL Rely on ()
P_FAC_OFFICE_HOURS Package procedure S4B70.BANINST1.BWLKOFFH Rely on ()
P_FAC_OFFICE_HOURS Package procedure S4B70.BANINST1.BWLKOFFH Use(select )
P_GET_FAC_FINAL Package procedure S4B70.BANINST1.BWLCBREF Use(select )
P_GET_FAC_GRDEBOOK Package procedure S4B70.BANINST1.BWLCBREF Use(select )
P_GET_FAC_MIDTERM Package procedure S4B70.BANINST1.BWLCBREF Use(select )
P_GET_PRIMARY_INSTRUCTOR_PIDM Package procedure S4B70.BANINST1.SIKLIBS Rely on ()
P_GET_PRIMARY_INSTRUCTOR_PIDM Package procedure S4B70.BANINST1.SIKLIBS Use(select )
P_INSERT Package procedure S4B70.BANINST1.DML_SIRASGN Rely on () Use(insert )
P_INSERT_SFRAREG Package procedure S4B70.BANINST1.SFKMODS Rely on ()
P_INSERT_SHRINST_FROM_SIRASGN Package procedure S4B70.BANINST1.SHKMODS Rely on ()
P_INSERT_SHRINST_FROM_SIRASGN Package procedure S4B70.BANINST1.SHKMODS Use(select )
P_LISTCRSE Package procedure S4B70.BANINST1.BWCKGENS Use(select )
P_LOAD_TEMPLATE Package procedure S4B70.BANINST1.BWCKWEEK Use(select )
P_LOCK Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_LOCK Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
P_OPEN_STUDENT_LIST_C Package procedure S4B70.BANINST1.BWLKOIDS Use(select )
P_POSTELTGRADES Package procedure S4B70.BANINST1.ICSFKGEX Rely on ()
P_POSTELTGRADES Package procedure S4B70.BANINST1.ICSFKGEX Rely on ()
P_POST_GRADE Package procedure S4B70.BANINST1.SP_GRADING Rely on ()
P_PRINTLINKS Package procedure S4B70.BANINST1.BWLKFCWL Rely on ()
P_PRINTLINKS Package procedure S4B70.BANINST1.BWLKFMGD Rely on ()
P_PRINTLINKS Package procedure S4B70.BANINST1.BWLKEGRB Rely on ()
P_PROCESS_SFRAREG Package procedure S4B70.BANINST1.SFKFUNC Rely on ()
P_REGISTER_ENTITY Package procedure S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
P_SAVE_ASSIGNMENT Package procedure S4B70.BANINST1.ICSIKLDI Rely on ()
P_SELECT_SHRINST_SIRASGN Package procedure S4B70.BANINST1.SHKSELS Rely on ()
P_SEND_ADD_NEW_FAC_USER Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_ADD_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_SEND_ASSIGNMENT Package procedure S4B70.BANINST1.ICSIKLDI Rely on ()
P_SEND_DELETE_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKSEV Rely on ()
P_SEND_DEL_TEACH_ASSIGN Package procedure S4B70.BANINST1.ICSIKEVN Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.DML_SIRASGN Rely on ()
P_UPDATE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_FACULTY_RULES Rely on ()
P_VALIDATE Package procedure S4B70.BANINST1.SB_FACULTY_RULES Use(select )
ASSIGNMENTS_C Package cursor S4B70.BANINST1.ICSPKCOM Use(select )
ASSIGNMENTS_C Package cursor S4B70.BANINST1.ICSPKCOM Rely on ()
INSTRC Package cursor S4B70.BANINST1.SFKCURS Use(select )
SHRINST_SIRASGN_C Package cursor S4B70.BANINST1.SHKSELS Rely on ()
SHRINST_SIRASGN_C Package cursor S4B70.BANINST1.SHKSELS Use(select )
SIRASGNC Package cursor S4B70.BANINST1.SFKCURS Rely on () Use(select )
SIRASGN_BY_PIDM_C Package cursor S4B70.BANINST1.SIKLIBS Rely on ()
SIRASGN_BY_PIDM_C Package cursor S4B70.BANINST1.SIKLIBS Rely on () Use(select )
SIRASGN_C Package cursor S4B70.BANINST1.ICSIKLIB Rely on ()
SIRASGN_C Package cursor S4B70.BANINST1.ICSSKCOM Rely on ()
SIRASGN_C Package cursor S4B70.BANINST1.ICSSKCOM Rely on () Use(select )
SIRASGN_ROLE_C Package cursor S4B70.BANINST1.ICSIKLIB Rely on ()
F_CALC_VALID_LDIMODE Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_CALC_WORKLOAD Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_CHECKCRNACCESS Package function S4B70.BANINST1.BWLKILIB Use(select )
F_CHECK_ASSIGNMENTS Package function S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
F_CHECK_PRIM_SIRASGN Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_CHECK_PRIM_SIRASGN Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_CHECK_SSRMEET_SESSION Package function S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
F_DEFAULT_CATEGORY Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_DEFAULT_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_EXISTS Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_GET_ASSIGNMENT Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_GET_ASSIGNMENT Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_GET_DASHBOARD Package function S4B70.BANINST1.CHNLSKBL Use(select )
F_GET_DASHBOARD_COUNT Package function S4B70.BANINST1.CHNLSKBL Use(select )
F_GET_DASHBOARD_COUNT Package function S4B70.BANINST1.BWLCBREF Use(select )
F_GET_DASHBOARD_CRN Package function S4B70.BANINST1.CHNLSKBL Use(select )
F_GET_DASHBOARD_SUBJ Package function S4B70.BANINST1.BWLCBREF Use(select )
F_GET_DASHBOARD_TERM Package function S4B70.BANINST1.BWLCBREF Use(select )
F_GET_EVENT_HEADER Package function S4B70.BANINST1.ICSIKCOM Rely on ()
F_GET_FACDTRANGE Package function S4B70.BANINST1.BWLCBREF Use(select )
F_GET_SESSION Package function S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
F_GET_SESSION Package function S4B70.BANINST1.SB_FACASSIGNMENT_RULES Use(select )
F_PARENT_EXISTS Package function S4B70.BANINST1.SB_FACASSIGNMENT_RULES Rely on ()
F_PRIMARYFAC Package function S4B70.BANINST1.BWLKILIB Use(select )
F_QUERY_ALL Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_QUERY_ALL Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_QUERY_BY_ROWID Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_QUERY_ONE Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_QUERY_ONE Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_QUERY_ONE_LOCK Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_STUDENT_ID_TYPE Package function S4B70.BANINST1.BWLCXCHN Use(select )
F_VALIDFACFORCRN Package function S4B70.BANINST1.BWLKILIB Use(select )
F_VALID_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
SIRASGN SYNONYM S4B70.PUBLIC Rely on ()
SIRASGN Forms DataBlock BANNER7_FORMS.SSAEVAL Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SFAALST Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SFASLST Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SSAXMTI Rely on () Use(insert,update,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SFAMASS Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SFAALST Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SSAEVAL Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SSASECT Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SFAMASS Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SIAASGN Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SSASECT Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS_10G.SFASLST Rely on () Use(insert,update,delete,select )
SIRASGN Forms DataBlock BANNER7_FORMS.SIAASGN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SIRASGN INDEX S4B70.SATURN Rely on ()
SIRASGN_KEY_INDEX2 INDEX S4B70.SATURN Rely on ()
ST_ICADR_DELETE_TEACH_ASSIGN TRIGGER S4B70.SATURN Fire(delete after each row )
ST_ICAIR_ADD_TEACH_ASSIGN TRIGGER S4B70.SATURN Fire(insert after each row )
ST_SIRASGN_ADR_IC TRIGGER S4B70.SATURN Fire(delete after each row )
ST_SIRASGN_AIR_IC TRIGGER S4B70.SATURN Fire(insert after each row )
ST_SIRASGN_AR_LDI TRIGGER S4B70.SATURN Fire(insert,update,delete after each row )
ST_SIRASGN_AS_LDI TRIGGER S4B70.SATURN Fire(insert,update,delete after all rows )
SFRSTCR TABLE S4B70.SATURN Join
SIRCOLR TABLE S4B70.SATURN Join
SSBSECT TABLE S4B70.SATURN Refer( No Action )
STVASTY TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

Position number. 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

Position number suffix. 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

Table SIRATTR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRATTR_PIDM SIRATTR_PIDM NUMBER(8,0) No
SIRATTR_TERM_CODE_EFF SIRATTR_TERM_CODE_EFF VARCHAR2(6) No *
SIRATTR_FATT_CODE SIRATTR_FATT_CODE VARCHAR2(4) Yes *
SIRATTR_ACTIVITY_DATE 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
SIRATTR SYNONYM S4B70.PUBLIC Rely on ()
AS_FACULTY_ATTRIBUTE VIEW S4B70.BANINST1 Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST Use(select )
END_ATTR_TERM Forms Trigger BANNER7_FORMS.SIAINST.SIRATTR Use(insert )
END_ATTR_TERM Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRATTR Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAINST.SIRATTR Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRATTR Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAINST.SIRATTR Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRATTR Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAINST.SIRATTR Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRATTR Use(select )
F_GET_SIRATTR_DATA FUNCTION S4B70.BANINST1 Use(select )
F_STUDENT_CHECK_FOR_MORE FUNCTION S4B70.BANINST1 Use(select )
SELECT_DUAL_1 Forms Function BANNER7_FORMS.SIAFAVL Use(select )
SELECT_DUAL_1 Forms Function BANNER7_FORMS.SOAFAVQ Use(select )
SELECT_DUAL_1 Forms Function BANNER7_FORMS_10G.SIAFAVL Use(select )
SELECT_DUAL_1 Forms Function BANNER7_FORMS_10G.SOAFAVQ Use(select )
UT_SB_FACULTYDELETEAPI Package procedure S4B70.BANINST1.UT_SB_FACULTY Use(insert )
F_VERIFYCRNFACPROCESS Package function S4B70.BANINST1.BWLKILIB Use(select )
F_VERIFYFACPROCESS Package function S4B70.BANINST1.BWLKILIB Use(select )
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Use(select )
P_FACADVRSECURITY Package procedure S4B70.BANINST1.BWLKSECR Use(select )
F_CHECKCRNACCESS Package function S4B70.BANINST1.BWLKILIB Use(select )
F_GET_END_SIRATTR_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
SIRATTR Forms DataBlock BANNER7_FORMS.SIAINST Rely on () Use(insert,update,delete,select )
SIRATTR Forms DataBlock BANNER7_FORMS_10G.SIAINST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRATTR_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVFATT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRCMNT_PIDM SIRCMNT_PIDM NUMBER(8,0) No
SIRCMNT_TERM_CODE_EFF SIRCMNT_TERM_CODE_EFF VARCHAR2(6) No *
SIRCMNT_SEQNO SIRCMNT_SEQNO NUMBER(23,20) Yes
SIRCMNT_TEXT SIRCMNT_TEXT VARCHAR2(60) Yes
SIRCMNT_ACTIVITY_DATE 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
SIRCMNT SYNONYM S4B70.PUBLIC Rely on ()
CHK_DELETE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST Use(select )
END_CMNT_TERM Forms Trigger BANNER7_FORMS.SIAINST.SIRCMNT Use(insert )
END_CMNT_TERM Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRCMNT Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAINST.SIRCMNT Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRCMNT Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAINST.SIRCMNT Use(delete,select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRCMNT Use(delete,select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAINST.SIRCMNT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRCMNT Use(select )
UT_SB_FACULTYDELETEAPI Package procedure S4B70.BANINST1.UT_SB_FACULTY Use(insert )
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Use(select )
SIRCMNT Forms DataBlock BANNER7_FORMS.SIAINST Rely on () Use(insert,update,delete,select )
SIRCMNT Forms DataBlock BANNER7_FORMS_10G.SIAINST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRCMNT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRCOLC_SESSIONID SIRCOLC_SESSIONID VARCHAR2(10) No *
SIRCOLC_FATT_CODE 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)

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

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SIRCOLC INDEX S4B70.SATURN Rely on ()
STVFATT TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

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

Foreign Key information

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

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
chkcolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
chkcolr C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
del_sircolr C/C++ Function [F:\BANNER\C\PEPFACL.PC] Use(delete )
delcolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(delete )
delcolr C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(delete )
ins_sircolr C/C++ Function [F:\BANNER\C\PEPFACL.PC] Use(insert )
inscolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(insert )
inscolr C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(insert )
upd_sircolr C/C++ Function [F:\BANNER\C\PEPFACL.PC] Use(update )
updcolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(update )
updcolr C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(update )
SIRCOLR SYNONYM S4B70.PUBLIC Rely on ()
SIBCFTE TABLE S4B70.SATURN Join
SIRASGN TABLE S4B70.SATURN Join
SIRFCNT TABLE S4B70.SATURN Join
SIVCALC VIEW S4B70.BANINST1 Use(select )
SIVCONT VIEW S4B70.BANINST1 Use(select )
SIVPFAC VIEW S4B70.BANINST1 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 )
PRE-UPDATE Forms Trigger BANNER7_FORMS.SIAASGN.WORKLOAD Use(insert,update,select )
PRE-UPDATE Forms Trigger BANNER7_FORMS_10G.SIAASGN.WORKLOAD Use(insert,update,select )
SELECT_SIBCFTE_3 Forms Function BANNER7_FORMS.SIACONA Use(select )
SELECT_SIBCFTE_3 Forms Function BANNER7_FORMS_10G.SIACONA Use(select )
WORKLOAD Forms DataBlock BANNER7_FORMS.SIACONA Rely on () Use(insert,update,delete,select )
WORKLOAD Forms DataBlock BANNER7_FORMS_10G.SIACONA Rely on () Use(insert,update,delete,select )
WORKLOAD_TOTAL Forms DataBlock BANNER7_FORMS.SIACONA Rely on () Use(insert,update,delete,select )
WORKLOAD_TOTAL Forms DataBlock BANNER7_FORMS_10G.SIACONA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

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

Table Columns information

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

Foreign Key information

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

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
get_report_institution C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use()
selcldp C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcldp C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_1 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_2 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_2 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr1_3 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_3 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr_1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_1 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr_2 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_2 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selcolr_3 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_3 C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
seldept C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
seldept C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
write_faculty_department C/C++ Function [F:\BANNER\C\ICGORLDI.PC] Use(select )
SIRDPCL SYNONYM S4B70.PUBLIC Rely on ()
AS_FACULTY_DEPARTMENT_COLLEGE VIEW S4B70.BANINST1 Use(select )
SIVFACL VIEW S4B70.BANINST1 Use(select )
SIRDPCL_RG Forms Record Group BANNER7_FORMS.SIAIQRY Use(select )
SIRDPCL_RG Forms Record Group BANNER7_FORMS_10G.SIAIQRY Use(select )
CHECK_HOME_IND Forms Trigger BANNER7_FORMS.SIAINST.SIRDPCL Use(select )
CHECK_HOME_IND Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRDPCL Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST Use(select )
END_DPCL_TERM Forms Trigger BANNER7_FORMS.SIAINST.SIRDPCL Use(insert )
END_DPCL_TERM Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRDPCL Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAINST.SIRDPCL Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRDPCL Use(insert,select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIACONQ.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIAFAVL.SIVINST Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SOAFAVQ.SIVINST Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIACONQ.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIAIQRY.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIAFAVL.SIVINST Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIAIQRY.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SOAFAVQ.SIVINST Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAINST.SIRDPCL Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRDPCL Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAINST.SIRDPCL Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRDPCL Use(select )
F_CONCAT_SIRDPCL FUNCTION S4B70.BANINST1 Use(select )
F_INSTRUCTOR_FNC FUNCTION S4B70.BANINST1 Use(select )
UT_SB_FACULTYDELETEAPI Package procedure S4B70.BANINST1.UT_SB_FACULTY Use(insert )
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Use(select )
F_GET_END_SIRDPCL_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
SIRDPCL Forms DataBlock BANNER7_FORMS.SIAINST Rely on () Use(insert,update,delete,select )
SIRDPCL Forms DataBlock BANNER7_FORMS_10G.SIAINST Rely on () Use(insert,update,delete,select )
SIVINST Forms DataBlock BANNER7_FORMS.SIAFAVL Use(select )
SIVINST Forms DataBlock BANNER7_FORMS_10G.SIAFAVL Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRDPCL_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVCOLL TABLE S4B70.SATURN Refer( No Action )
STVDEPT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

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

Foreign Key information

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

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
get_sum_nist C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selfcnt C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
SIRFCNT SYNONYM S4B70.PUBLIC Rely on ()
SIRNIST TABLE S4B70.SATURN Join
SIVCONT VIEW S4B70.BANINST1 Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS.SIACONA Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
SUM_WORKLOAD Forms Trigger BANNER7_FORMS.SIACONA Use(select )
SUM_WORKLOAD Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
END_FCNT_TERM Forms Trigger BANNER7_FORMS.SIAFCTR.SIRFCNT Use(insert )
END_FCNT_TERM Forms Trigger BANNER7_FORMS_10G.SIAFCTR.SIRFCNT Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAFCTR.SIRFCNT Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAFCTR.SIRFCNT Use(insert,select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAFCTR.SIRFCNT Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAFCTR.SIRFCNT Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAFCTR.SIRFCNT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAFCTR.SIRFCNT Use(select )
SIRFCNT Forms DataBlock BANNER7_FORMS.SIAFCTR Rely on () Use(insert,update,delete,select )
SIRFCNT Forms DataBlock BANNER7_FORMS_10G.SIAFCTR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRFLCT_TERM_CODE SIRFLCT_TERM_CODE VARCHAR2(6) No *
SIRFLCT_FCNT_CODE SIRFLCT_FCNT_CODE VARCHAR2(2) No *
SIRFLCT_STATUS SIRFLCT_STATUS VARCHAR2(1) No
SIRFLCT_CNTR_CODE SIRFLCT_CNTR_CODE VARCHAR2(6) Yes *
SIRFLCT_CREDIT_HR_LOW SIRFLCT_CREDIT_HR_LOW NUMBER(9,3) Yes
SIRFLCT_CREDIT_HR_HIGH SIRFLCT_CREDIT_HR_HIGH NUMBER(9,3) Yes
SIRFLCT_CREDIT_HR_LOW_GEN SIRFLCT_CREDIT_HR_LOW_GEN NUMBER(9,3) Yes
SIRFLCT_CREDIT_HR_HIGH_GEN SIRFLCT_CREDIT_HR_HIGH_GEN NUMBER(9,3) Yes
SIRFLCT_CONTACT_HR_LOW SIRFLCT_CONTACT_HR_LOW NUMBER(9,3) Yes
SIRFLCT_CONTACT_HR_HIGH SIRFLCT_CONTACT_HR_HIGH NUMBER(9,3) Yes
SIRFLCT_CONTACT_HR_LOW_WEEK SIRFLCT_CONTACT_HR_LOW_WEEK NUMBER(9,3) Yes
SIRFLCT_CONTACT_HR_HIGH_WEEK SIRFLCT_CONTACT_HR_HIGH_WEEK NUMBER(9,3) Yes
SIRFLCT_INST_WORKLOAD_LOW SIRFLCT_INST_WORKLOAD_LOW NUMBER(9,3) Yes
SIRFLCT_INST_WORKLOAD_HIGH SIRFLCT_INST_WORKLOAD_HIGH NUMBER(9,3) Yes
SIRFLCT_NIST_WORKLOAD_LOW SIRFLCT_NIST_WORKLOAD_LOW NUMBER(9,3) Yes
SIRFLCT_NIST_WORKLOAD_HIGH SIRFLCT_NIST_WORKLOAD_HIGH NUMBER(9,3) Yes
SIRFLCT_TOT_WORKLOAD_LOW SIRFLCT_TOT_WORKLOAD_LOW NUMBER(11,3) Yes
SIRFLCT_TOT_WORKLOAD_HIGH SIRFLCT_TOT_WORKLOAD_HIGH NUMBER(11,3) Yes
SIRFLCT_FTE_LOW SIRFLCT_FTE_LOW NUMBER(5,2) Yes
SIRFLCT_FTE_HIGH SIRFLCT_FTE_HIGH NUMBER(5,2) Yes
SIRFLCT_ACTIVITY_DATE 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)

Object Name Object Type Parent Name Link Type
delflct C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(delete )
get_flct C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selmacro4 C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(select )
SIRFLCT SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAFLCT.STVTERM.SIRFLCT_TERM_CODE_DEF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAFLCT.STVTERM.SIRFLCT_TERM_CODE_DEF Use(select )
CHECK_TERM_RULE Forms Trigger BANNER7_FORMS.SIAFLCT Use(select )
CHECK_TERM_RULE Forms Trigger BANNER7_FORMS_10G.SIAFLCT Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SIACONA.WORKLOAD_TOTAL Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SIACONA.WORKLOAD_TOTAL Use(select )
POST-UPDATE Forms Trigger BANNER7_FORMS.SIAFLCT.STVTERM Use(insert,select )
POST-UPDATE Forms Trigger BANNER7_FORMS_10G.SIAFLCT.STVTERM Use(insert,select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SIACONA.SIRFLCT Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS_10G.SIACONA.SIRFLCT Use(select )
SIRFLCT Forms DataBlock BANNER7_FORMS.SIAFLCT Rely on () Use(insert,update,delete,select )
SIRFLCT Forms DataBlock BANNER7_FORMS_10G.SIACONA Rely on () Use(insert,update,delete,select )
SIRFLCT Forms DataBlock BANNER7_FORMS_10G.SIAFLCT Rely on () Use(insert,update,delete,select )
SIRFLCT Forms DataBlock BANNER7_FORMS.SIACONA Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRFLCT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVCNTR TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

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

Object Name Object Type Parent Name Link Type
find_rule C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
get_rule C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
SIRFLRC SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.SIACONQ.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIACONA.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIACONA.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIACONQ.KEY_BLOCK.KEYBLCK_TERM_CODE Use(select )
END_FLRC_TERM Forms Trigger BANNER7_FORMS.SIAFLRC.SIRFLRC Use(insert )
END_FLRC_TERM Forms Trigger BANNER7_FORMS_10G.SIAFLRC.SIRFLRC Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAFLRC.SIRFLRC Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAFLRC.SIRFLRC Use(insert,select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SIACONA.WORKLOAD Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SIACONA.WORKLOAD Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAFLRC.SIRFLRC Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAFLRC.SIRFLRC Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAFLRC.SIRFLRC Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAFLRC.SIRFLRC Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SIACONA.SIRFLRC Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS_10G.SIACONA.SIRFLRC Use(select )
SIRFLRC Forms DataBlock BANNER7_FORMS.SIACONA Rely on () Use(insert,update,delete,select )
SIRFLRC Forms DataBlock BANNER7_FORMS.SIAFLRC Rely on () Use(insert,update,delete,select )
SIRFLRC Forms DataBlock BANNER7_FORMS_10G.SIACONA Rely on () Use(insert,update,delete,select )
SIRFLRC Forms DataBlock BANNER7_FORMS_10G.SIAFLRC Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRFLRC_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVCNTR TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRFLRT_TERM_CODE SIRFLRT_TERM_CODE VARCHAR2(6) No *
SIRFLRT_STATUS SIRFLRT_STATUS VARCHAR2(1) No
SIRFLRT_WKLD_CODE SIRFLRT_WKLD_CODE VARCHAR2(6) Yes *
SIRFLRT_CREDIT_HR_LOW SIRFLRT_CREDIT_HR_LOW NUMBER(9,3) Yes
SIRFLRT_CREDIT_HR_HIGH SIRFLRT_CREDIT_HR_HIGH NUMBER(9,3) Yes
SIRFLRT_CREDIT_HR_LOW_GEN SIRFLRT_CREDIT_HR_LOW_GEN NUMBER(9,3) Yes
SIRFLRT_CREDIT_HR_HIGH_GEN SIRFLRT_CREDIT_HR_HIGH_GEN NUMBER(9,3) Yes
SIRFLRT_CONTACT_HR_LOW SIRFLRT_CONTACT_HR_LOW NUMBER(9,3) Yes
SIRFLRT_CONTACT_HR_HIGH SIRFLRT_CONTACT_HR_HIGH NUMBER(9,3) Yes
SIRFLRT_CONTACT_HR_LOW_WEEK SIRFLRT_CONTACT_HR_LOW_WEEK NUMBER(9,3) Yes
SIRFLRT_CONTACT_HR_HIGH_WEEK SIRFLRT_CONTACT_HR_HIGH_WEEK NUMBER(9,3) Yes
SIRFLRT_INST_WORKLOAD_LOW SIRFLRT_INST_WORKLOAD_LOW NUMBER(9,3) Yes
SIRFLRT_INST_WORKLOAD_HIGH SIRFLRT_INST_WORKLOAD_HIGH NUMBER(9,3) Yes
SIRFLRT_NIST_WORKLOAD_LOW SIRFLRT_NIST_WORKLOAD_LOW NUMBER(9,3) Yes
SIRFLRT_NIST_WORKLOAD_HIGH SIRFLRT_NIST_WORKLOAD_HIGH NUMBER(9,3) Yes
SIRFLRT_TOT_WORKLOAD_LOW SIRFLRT_TOT_WORKLOAD_LOW NUMBER(11,3) Yes
SIRFLRT_TOT_WORKLOAD_HIGH SIRFLRT_TOT_WORKLOAD_HIGH NUMBER(11,3) Yes
SIRFLRT_FTE_LOW SIRFLRT_FTE_LOW NUMBER(5,2) Yes
SIRFLRT_FTE_HIGH SIRFLRT_FTE_HIGH NUMBER(5,2) Yes
SIRFLRT_ACTIVITY_DATE 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
delflrt C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(delete )
find_rule C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
get_rule C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
selmacro3 C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(select )
SIRFLRT SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIALVAS.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIALVAS.KEY_BLOCK.KEYBLOC_TERM_CODE_EFF Use(select )
SIRFLRT_RG Forms Record Group BANNER7_FORMS.SIAFLCT Use(select )
SIRFLRT_RG Forms Record Group BANNER7_FORMS.SIAFLRT Use(select )
SIRFLRT_RG Forms Record Group BANNER7_FORMS_10G.SIAFLCT Use(select )
SIRFLRT_RG Forms Record Group BANNER7_FORMS_10G.SIAFLRT Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SIAASGN.WORKLOAD Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SIAASGN.WORKLOAD Use(select )
POST-UPDATE Forms Trigger BANNER7_FORMS.SIAFLRT.STVTERM Use(insert,select )
POST-UPDATE Forms Trigger BANNER7_FORMS_10G.SIAFLRT.STVTERM Use(insert,select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SIAASGN.SIRFLRT Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRFLRT Use(select )
SELECT_SIRFLRT_1 Forms Function BANNER7_FORMS.SIAFLRT Use(select )
SELECT_SIRFLRT_1 Forms Function BANNER7_FORMS_10G.SIAFLRT Use(select )
SIRFLRT Forms DataBlock BANNER7_FORMS.SIAASGN Rely on () Use(insert,update,delete,select )
SIRFLRT Forms DataBlock BANNER7_FORMS_10G.SIAASGN Rely on () Use(insert,update,delete,select )
SIRFLRT Forms DataBlock BANNER7_FORMS_10G.SIAFLRT Rely on () Use(insert,update,delete,select )
SIRFLRT Forms DataBlock BANNER7_FORMS.SIAFLRT Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRFLRT_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVWKLD TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRICNT_PIDM SIRICNT_PIDM NUMBER(8,0) No *
SIRICNT_TERM_CODE_EFF SIRICNT_TERM_CODE_EFF VARCHAR2(6) No *
SIRICNT_FCNT_CODE SIRICNT_FCNT_CODE VARCHAR2(2) Yes *
SIRICNT_CNTR_CODE SIRICNT_CNTR_CODE VARCHAR2(6) Yes *
SIRICNT_DEF_IND SIRICNT_DEF_IND VARCHAR2(1) Yes
SIRICNT_ACTIVITY_DATE 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
NAA2 Cobol Paragraph [F:\banner\cobol].SERXEREC.NAA-REPORT-SECT Use(select )
selcolr C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_2 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr1_3 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_1 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_2 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
selcolr_3 C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
SERXEREC Cobol Program F:\banner\cobol Use()
AS_FACULTY_CONTRACT VIEW S4B70.BANINST1 Use(select )
SIVFACL VIEW S4B70.BANINST1 Use(select )
SIVINST VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.SIRASGN.SIRASGN_CRN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.SIRNIST.SIRNIST_NIST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRLVAS.SIRLVAS_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRNLVA.SIRNLVA_NIST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRNLVA.SIRNLVA_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRASGN.SIRASGN_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRASGN.SIRASGN_CRN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRNIST.SIRNIST_NIST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SIAASGN.SIRNIST.SIRNIST_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIALVAS.SIRNLVA.SIRNLVA_NIST_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIALVAS.SIRNLVA.SIRNLVA_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIALVAS.SIRLVAS.SIRLVAS_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.SIRASGN.SIRASGN_FCNT_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SIAASGN.SIRNIST.SIRNIST_FCNT_CODE Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS.SIACONA Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
STVFCNT_RG Forms Record Group BANNER7_FORMS.SIAASGN Use(select )
STVFCNT_RG Forms Record Group BANNER7_FORMS_10G.SIAASGN Use(select )
END_FCNT_TERM Forms Trigger BANNER7_FORMS.SIAINST.SIRICNT Use(insert )
END_FCNT_TERM Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRICNT Use(insert )
GET_ICNT Forms Trigger BANNER7_FORMS.SSASECT.SIRASGN Use(select )
GET_ICNT Forms Trigger BANNER7_FORMS_10G.SSASECT.SIRASGN Use(select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SIAINST.SIRICNT Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRICNT Use(insert,select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SIAINST.SIRICNT Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRICNT Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIACONQ.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIACONQ.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SIAIQRY.SIVFACQ Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SIAIQRY.SIVFACQ Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SIAINST.SIRICNT Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRICNT Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SIAINST.SIRICNT Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SIAINST.SIRICNT Use(select )
SELECT_SIRICNT_1 Forms Function BANNER7_FORMS.SIALVAS Use(select )
SELECT_SIRICNT_1 Forms Function BANNER7_FORMS.SIAASGN Use(select )
SELECT_SIRICNT_1 Forms Function BANNER7_FORMS_10G.SIAASGN Use(select )
SELECT_SIRICNT_1 Forms Function BANNER7_FORMS_10G.SIALVAS Use(select )
F_DEFAULT_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
F_DEFAULT_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_GET_END_SIRICNT_TERM Package function S4B70.BANINST1.SOKODSF Use(select )
F_VALID_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Rely on ()
F_VALID_FCNT Package function S4B70.BANINST1.SB_FACASSIGNMENT Use(select )
SIRICNT SYNONYM S4B70.PUBLIC Rely on ()
SIRICNT Forms DataBlock BANNER7_FORMS.SIAINST Rely on () Use(insert,update,delete,select )
SIRICNT Forms DataBlock BANNER7_FORMS_10G.SIAINST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

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

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

Table Columns information

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

Foreign Key information

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

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)

Object Name Object Type Parent Name Link Type
faculty_body C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use()
sel_faculty C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_faculty_weekly_hrs C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_pebempl C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_pebempl1 C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_sirlvas C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
SIRLVAS SYNONYM S4B70.PUBLIC Rely on ()
ADD_INST Forms Trigger BANNER7_FORMS.SIALVAS.SIRLVAS Use(select )
ADD_INST Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRLVAS Use(select )
CHECK_PRIM Forms Trigger BANNER7_FORMS.SIALVAS.SIRLVAS Use(select )
CHECK_PRIM Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRLVAS Use(select )
CHECK_PRIMARY Forms Trigger BANNER7_FORMS.SIALVAS.SIRLVAS Use(select )
CHECK_PRIMARY Forms Trigger BANNER7_FORMS_10G.SIALVAS.SIRLVAS Use(select )
SIRLVAS Forms DataBlock BANNER7_FORMS.SIALVAS Rely on () Use(insert,update,delete,select )
SIRLVAS Forms DataBlock BANNER7_FORMS_10G.SIALVAS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SIRLVAS INDEX S4B70.SATURN Rely on ()
SIRLVAS_KEY_INDEX2 INDEX S4B70.SATURN Rely on ()
SSBSECT TABLE S4B70.SATURN Refer( No Action )
STVASTY TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
SIRNIST_TERM_CODE STVTERM_CODE STVTERM
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_COLL_CODE STVCOLL_CODE STVCOLL
SIRNIST_DEPT_CODE STVDEPT_CODE STVDEPT
SIRNIST_TERM_CODE SIRFCNT_TERM_CODE SIRFCNT

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
calc_salary C/C++ Function [F:\BANNER\C\SIRASGQ.PC] Use(select )
delnist C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(delete )
faculty_body C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use()
get_fcnt_nist C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
get_sum_nist C/C++ Function [F:\BANNER\C\SIRCTAL.PC] Use(select )
get_sum_nist C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
sel_faculty_fte2 C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_sirnist C/C++ Function [F:\BANNER\C\PEPFACL.PC] Use(select )
sel_sirnist C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
selmacro1 C/C++ Function [F:\BANNER\C\SIRASGQ.PC] Use(select )
selmacro2 C/C++ Function [F:\BANNER\C\SIPASGN.PC] Use(select )
selnist C/C++ Function [F:\BANNER\C\SIRTRAL.PC] Use(select )
SIRNIST SYNONYM S4B70.PUBLIC Rely on ()
AS_NONINSTRUCTIONAL_ASSIGNMENT VIEW S4B70.BANINST1 Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS.SIAASGN Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS_10G.SIAASGN Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
INST_SUMMARY Forms Trigger BANNER7_FORMS.SIACONA Use(select )
INST_SUMMARY2 Forms Trigger BANNER7_FORMS.SIACONA Use(select )
INST_SUMMARY2 Forms Trigger BANNER7_FORMS_10G.SIACONA Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS.SIAINST.SIBINST Use(select )
CHK_DELETE Forms Trigger BANNER7_FORMS_10G.SIAINST.SIBINST Use(select )
F_CONCAT_SIRNIST FUNCTION S4B70.BANINST1 Use(select )
F_STUDENT_CHECK_FOR_MORE FUNCTION S4B70.BANINST1 Use(select )
UT_SB_FACULTYDELETEAPI Package procedure S4B70.BANINST1.UT_SB_FACULTY Use(insert )
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Rely on ()
P_DELETE Package procedure S4B70.BANINST1.SB_FACULTY Use(select )
SIRNIST Forms DataBlock BANNER7_FORMS.SIAASGN Rely on () Use(insert,update,delete,select )
SIRNIST 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
SIRNIST_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SIRFCNT TABLE S4B70.SATURN Join
STVASTY TABLE S4B70.SATURN Refer( No Action )
STVCOLL TABLE S4B70.SATURN Refer( No Action )
STVDEPT TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVNIST TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVTOPS TABLE S4B70.SATURN Refer( No Action )

Comments

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

Non-instructional position number. 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

Non-instructional position number suffix. 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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIRNLVA_TERM_CODE SIRNLVA_TERM_CODE VARCHAR2(6) No *
SIRNLVA_PIDM SIRNLVA_PIDM NUMBER(8,0) No
SIRNLVA_ACTIVITY_DATE SIRNLVA_ACTIVITY_DATE DATE No
SIRNLVA_NIST_CODE SIRNLVA_NIST_CODE VARCHAR2(4) Yes *
SIRNLVA_COLL_CODE SIRNLVA_COLL_CODE VARCHAR2(2) Yes *
SIRNLVA_DEPT_CODE SIRNLVA_DEPT_CODE VARCHAR2(4) Yes *
SIRNLVA_NIST_WORKLOAD SIRNLVA_NIST_WORKLOAD NUMBER(9,3) Yes
SIRNLVA_NIST_WEEKLY_HRS SIRNLVA_NIST_WEEKLY_HRS NUMBER(9,3) Yes
SIRNLVA_TOPS_CODE SIRNLVA_TOPS_CODE VARCHAR2(6) Yes *
SIRNLVA_FCNT_CODE SIRNLVA_FCNT_CODE VARCHAR2(2) Yes *
SIRNLVA_POSN SIRNLVA_POSN VARCHAR2(6) Yes
SIRNLVA_SUFF SIRNLVA_SUFF VARCHAR2(2) Yes
SIRNLVA_ASTY_CODE 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)

Object Name Object Type Parent Name Link Type
faculty_body C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use()
sel_faculty_fte2 C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_sirnlva C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
SIRNLVA SYNONYM S4B70.PUBLIC Rely on ()
SIRNLVA Forms DataBlock BANNER7_FORMS.SIALVAS Rely on () Use(insert,update,delete,select )
SIRNLVA Forms DataBlock BANNER7_FORMS_10G.SIALVAS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SIRNLVA_KEY_INDEX INDEX S4B70.SATURN Rely on ()
STVASTY TABLE S4B70.SATURN Refer( No Action )
STVCOLL TABLE S4B70.SATURN Refer( No Action )
STVDEPT TABLE S4B70.SATURN Refer( No Action )
STVFCNT TABLE S4B70.SATURN Refer( No Action )
STVNIST TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVTOPS TABLE S4B70.SATURN Refer( No Action )

Comments

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

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SIROFFC_TERM_CODE SIROFFC_TERM_CODE VARCHAR2(6) No * *
SIROFFC_CRN SIROFFC_CRN VARCHAR2(30) No *
SIROFFC_PIDM SIROFFC_PIDM NUMBER(8,0) No
SIROFFC_FROM_DATE SIROFFC_FROM_DATE DATE No *
SIROFFC_TO_DATE SIROFFC_TO_DATE DATE No *
SIROFFC_FROM_TIME SIROFFC_FROM_TIME VARCHAR2(4) No *
SIROFFC_TO_TIME SIROFFC_TO_TIME VARCHAR2(4) No *
SIROFFC_DISPLAY_IND SIROFFC_DISPLAY_IND VARCHAR2(1) No
SIROFFC_ACTIVITY_DATE SIROFFC_ACTIVITY_DATE DATE No
SIROFFC_USER_ID SIROFFC_USER_ID VARCHAR2(30) No
SIROFFC_LOCATION SIROFFC_LOCATION VARCHAR2(100) Yes
SIROFFC_TELE_CODE SIROFFC_TELE_CODE VARCHAR2(4) Yes *
SIROFFC_PHONE_AREA SIROFFC_PHONE_AREA VARCHAR2(3) Yes
SIROFFC_PHONE_NUMBER SIROFFC_PHONE_NUMBER VARCHAR2(7) Yes
SIROFFC_PHONE_EXTN SIROFFC_PHONE_EXTN VARCHAR2(4) Yes
SIROFFC_SUN_DAY SIROFFC_SUN_DAY VARCHAR2(1) Yes
SIROFFC_MON_DAY SIROFFC_MON_DAY VARCHAR2(1) Yes
SIROFFC_TUE_DAY SIROFFC_TUE_DAY VARCHAR2(1) Yes
SIROFFC_WED_DAY SIROFFC_WED_DAY VARCHAR2(1) Yes
SIROFFC_THU_DAY SIROFFC_THU_DAY VARCHAR2(1) Yes
SIROFFC_FRI_DAY SIROFFC_FRI_DAY VARCHAR2(1) Yes
SIROFFC_SAT_DAY SIROFFC_SAT_DAY VARCHAR2(1) 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

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 SYNONYM S4B70.PUBLIC Rely on ()
SIROFFC_C Package cursor S4B70.BANINST1.BWLKOFFH Use(select )
SIROFFC_C Package cursor S4B70.BANINST1.BWCKGENS Use(select )
SIROFFC_PRIM_C Package cursor S4B70.BANINST1.BWLKOFFH Use(select )
P_FACSCHED Package procedure S4B70.BANINST1.BWLKIFAC Use(select )
P_FAC_OFFICE_HRS_POST Package procedure S4B70.BANINST1.BWLKOFFH Use(insert,delete )
P_OFFICE_HOURS Package procedure S4B70.BANINST1.BWCKFRMT Use(select )
P_SEL_OFFICE_HOURS Package procedure S4B70.BANINST1.BWLKOFFH Rely on ()
F_GET_OHR Package function S4B70.BANINST1.BWLCBREF Use(select )
F_OFFICE_HOURS_EXIST Package function S4B70.BANINST1.BWLKASGN Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SIROFFC INDEX S4B70.SATURN Rely on ()
STVTELE TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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.

Link between SIRICNT and SIBINST

Caller : SIRICNT
Called : SIBINST

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVINST

Link List

Link Type Link Project
Join Link Between SIRICNT and SIBINST SATURN

Link Between SIRICNT and SIBINST

Caller : SIRICNT
Called : SIBINST
Link Type : Join
Link : Link Between SIRICNT and SIBINST

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIRICNT SIRICNT_PIDM SIBINST_PIDM SIBINST (0,1)-(0,1)

Comments

Link between SIBTERM and SIRASGN

Caller : SIBTERM
Called : SIRASGN

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCALC
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type Link Project
Join Link Between SIBTERM and SIRASGN SATURN

Link Between SIBTERM and SIRASGN

Caller : SIBTERM
Called : SIRASGN
Link Type : Join
Link : Link Between SIBTERM and SIRASGN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIBTERM SIBTERM_TERM_CODE SIRASGN_TERM_CODE SIRASGN (0,1)-(0,1)

Comments

Link between SIRASGN and SIRCOLR

Caller : SIRASGN
Called : SIRCOLR

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCALC
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type Link Project
Join Link Between SIRASGN and SIRCOLR SATURN

Link Between SIRASGN and SIRCOLR

Caller : SIRASGN
Called : SIRCOLR
Link Type : Join
Link : Link Between SIRASGN and SIRCOLR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIRASGN SIRASGN_TERM_CODE SIRCOLR_TERM_CODE SIRCOLR (0,1)-(0,1)
SIRASGN SIRASGN_PIDM SIRCOLR_PIDM SIRCOLR (0,1)-(0,1)
SIRASGN SIRASGN_FCNT_CODE SIRCOLR_FCNT_CODE SIRCOLR (0,1)-(0,1)

Comments

Link between SIBCFTE and SIRCOLR

Caller : SIBCFTE
Called : SIRCOLR

Join Information

Objects list
forms-module-function : BANNER7_FORMS.SIACONA.SELECT_SIBCFTE_3
schema-view : S4B70.BANINST1.SIVCONT
forms-module-trigger : BANNER7_FORMS.SIACONA.INST_SUMMARY
forms-module-trigger : BANNER7_FORMS.SIACONA.INST_SUMMARY2
forms-module-function : BANNER7_FORMS_10G.SIACONA.SELECT_SIBCFTE_3
forms-module-trigger : BANNER7_FORMS_10G.SIACONA.INST_SUMMARY
forms-module-trigger : BANNER7_FORMS_10G.SIACONA.INST_SUMMARY2

Link List

Link Type Link Project
Join Link Between SIBCFTE and SIRCOLR SATURN

Link Between SIBCFTE and SIRCOLR

Caller : SIBCFTE
Called : SIRCOLR
Link Type : Join
Link : Link Between SIBCFTE and SIRCOLR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIBCFTE SIBCFTE_FCNT_CODE SIRCOLR_FCNT_CODE SIRCOLR (0,1)-(0,1)
SIBCFTE SIBCFTE_TERM_CODE_EFF SIRCOLR_TERM_CODE_EFF SIRCOLR (0,1)-(0,1)

Comments

Link between SIRFCNT and SIRASGN

Caller : SIRFCNT
Called : SIRASGN

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type Link Project
Join Link Between SIRFCNT and SIRASGN SATURN

Link Between SIRFCNT and SIRASGN

Caller : SIRFCNT
Called : SIRASGN
Link Type : Join
Link : Link Between SIRFCNT and SIRASGN

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIRFCNT SIRFCNT_TERM_CODE SIRASGN_TERM_CODE SIRASGN (0,1)-(0,1)

Comments

Link between SIRFCNT and SIRCOLR

Caller : SIRFCNT
Called : SIRCOLR

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type Link Project
Join Link Between SIRFCNT and SIRCOLR SATURN

Link Between SIRFCNT and SIRCOLR

Caller : SIRFCNT
Called : SIRCOLR
Link Type : Join
Link : Link Between SIRFCNT and SIRCOLR

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIRFCNT SIRFCNT_FCNT_CODE SIRCOLR_FCNT_CODE SIRCOLR (0,1)-(0,1)

Comments

Link between SIRNIST and SIRFCNT

Caller : SIRNIST
Called : SIRFCNT

Join Information

Objects list
forms-module-trigger : BANNER7_FORMS.SIACONA.INST_SUMMARY
forms-module-trigger : BANNER7_FORMS_10G.SIACONA.INST_SUMMARY

Link List

Link Type Link Project
Join Link Between SIRNIST and SIRFCNT SATURN

Link Between SIRNIST and SIRFCNT

Caller : SIRNIST
Called : SIRFCNT
Link Type : Join
Link : Link Between SIRNIST and SIRFCNT

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SIRNIST SIRNIST_TERM_CODE SIRFCNT_TERM_CODE SIRFCNT (0,1)-(0,1)

Comments