Model Faculty Load

Model Label : ERD For Banner Student Faculty Load Module (SI% Tables )
Path : BANNER DEV/Student/Faculty_Load/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 MALDEV8_B60
Creation Date 04/15/2002 18:12:08:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SIBCFTE_FCNT_CODE	SIBCFTE_FCNT_CODE	VARCHAR2(2)	No	*
SIBCFTE_FCNT_CODE	SIBCFTE_FCNT_CODE	VARCHAR2(2)	No	*
SIBCFTE_TERM_CODE_EFF	SIBCFTE_TERM_CODE_EFF	VARCHAR2(6)	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_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIBCFTE_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIBCFTE_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR
SIBCFTE_TERM_CODE_EFF	SIRCOLR_TERM_CODE_EFF	SIRCOLR

Index

Index Name	Index Type	Column Name
SIBCFTE_KEY_INDEX		SIBCFTE_FCNT_CODE
SIBCFTE_KEY_INDEX		SIBCFTE_TERM_CODE_EFF

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09: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_PIDM	SIBINST_PIDM	SIBINST

Index

Index Name	Index Type	Column Name
PK_SIBFACD	Unique	SIBFACD_PIDM

Comments

Source Code Comments

Faculty Information Table

Impact job : sibfacd_disp_code IA New Job

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 MALDEV8_B60
Creation Date 04/04/2002 20:14:52:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09: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

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
SIBINST_PIDM	SIRASGN_PIDM	SIRASGN

Index

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

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

Table SIBTERM

Schema Name SATURN
Label SIBTERM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:09:000

Table Columns information

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

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 MALDEV8_B60
Creation Date 04/22/2003 16:14:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_PIDM	SIRASGN_PIDM	NUMBER(8,0)	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_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		*

Foreign Key information

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

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

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

Table SIRATTR

Schema Name SATURN
Label SIRATTR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	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

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	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

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09: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

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09: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_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

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_COLL_CODE	STVCOLL_CODE	STVCOLL
SIRDPCL_DEPT_CODE	STVDEPT_CODE	STVDEPT
SIRDPCL_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRDPCL_PIDM	SIBINST_PIDM	SIBINST

Index

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

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 MALDEV8_B60
Creation Date 04/15/2002 18:12:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SIRFCNT_FCNT_CODE	SIRFCNT_FCNT_CODE	VARCHAR2(2)	No	*
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_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_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRFCNT_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN
SIRFCNT_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR

Index

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

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 MALDEV8_B60
Creation Date 08/27/2002 00:01:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	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