Model Faculty_Load_ERD*

Model Label : ba student faculty load ERD

List of Objects

Object Name	Object Type	Layer Name
PTRTENR	TABLE	ERD
SFRSTCR	TABLE	ERD
SIBCFTE	TABLE	Tables
SIBFACD	TABLE	Tables
SIBFACD_TMP	TABLE	Tables
SIBINST	TABLE	Tables
SIBTERM	TABLE	Tables
SIRASGN	TABLE	Tables
SIRATTR	TABLE	Tables
SIRCMNT	TABLE	Tables
SIRCOLC	TABLE	Tables
SIRCOLR	TABLE	Tables
SIRDPCL	TABLE	Tables
SIRFCNT	TABLE	Tables
SIRFLCT	TABLE	Tables
SIRFLRC	TABLE	Tables
SIRFLRT	TABLE	Tables
SIRICNT	TABLE	Tables
SIRLVAS	TABLE	Tables
SIRNIST	TABLE	Tables
SIRNLVA	TABLE	Tables
SIROFFC	TABLE	Tables
SPRIDEN	TABLE	ERD
SSBSECT	TABLE	ERD
SSRMEET	TABLE	ERD
SSRXLST	TABLE	ERD
STVASTY	TABLE	ERD
STVCNTR	TABLE	Tables
STVCOLL	TABLE	ERD
STVDEPT	TABLE	ERD
STVFATT	TABLE	ERD
STVFCNT	TABLE	ERD
STVFCST	TABLE	ERD
STVFCTG	TABLE	ERD
STVFSTP	TABLE	ERD
STVNIST	TABLE	ERD
STVTELE	TABLE	ERD
STVTOPS	TABLE	ERD
STVWKLD	TABLE	ERD

Model View

Table PTRTENR

Server Name S4B70.SCT.COM
Database Name PAYROLL
Table Label PTRTENR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
PTRTENR_CODE	PTRTENR_CODE	VARCHAR2(2)	No	*
PTRTENR_DESC	PTRTENR_DESC	VARCHAR2(30)	No
PTRTENR_DATE_IND	PTRTENR_DATE_IND	VARCHAR2(1)	No
PTRTENR_REVIEW_DATE_IND	PTRTENR_REVIEW_DATE_IND	VARCHAR2(1)	No
PTRTENR_EEO_TENURE_IND	PTRTENR_EEO_TENURE_IND	VARCHAR2(1)	No
PTRTENR_ACTIVITY_DATE	PTRTENR_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRTENR	Unique	PTRTENR_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:36:000

Source Code Comments

Faculty Member Tenure Status Code Table

Columns Comments for PTRTENR_CODE (# 1)

Source Code Comments

Faculty member tenure status code

Columns Comments for PTRTENR_DESC (# 2)

Source Code Comments

Description of faculty member tenure status code

Columns Comments for PTRTENR_DATE_IND (# 3)

Source Code Comments

Tenure Date Indicator

Columns Comments for PTRTENR_REVIEW_DATE_IND (# 4)

Source Code Comments

Tenure Review Date Indicator

Columns Comments for PTRTENR_EEO_TENURE_IND (# 5)

Source Code Comments

EEO Tenure Indicator.

Columns Comments for PTRTENR_ACTIVITY_DATE (# 6)

Source Code Comments

The date of the last insert or update of this record

Table SFRSTCR

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SFRSTCR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CLASS_SORT_KEY	SFRSTCR_CLASS_SORT_KEY	NUMBER(4,0)	Yes
SFRSTCR_REG_SEQ	SFRSTCR_REG_SEQ	NUMBER(4,0)	No
SFRSTCR_PTRM_CODE	SFRSTCR_PTRM_CODE	VARCHAR2(3)	Yes		*
SFRSTCR_RSTS_CODE	SFRSTCR_RSTS_CODE	VARCHAR2(2)	Yes		*
SFRSTCR_RSTS_DATE	SFRSTCR_RSTS_DATE	DATE	Yes
SFRSTCR_ERROR_FLAG	SFRSTCR_ERROR_FLAG	VARCHAR2(1)	Yes
SFRSTCR_MESSAGE	SFRSTCR_MESSAGE	VARCHAR2(25)	Yes
SFRSTCR_BILL_HR	SFRSTCR_BILL_HR	NUMBER(7,3)	Yes
SFRSTCR_WAIV_HR	SFRSTCR_WAIV_HR	NUMBER(7,3)	Yes
SFRSTCR_CREDIT_HR	SFRSTCR_CREDIT_HR	NUMBER(7,3)	Yes
SFRSTCR_BILL_HR_HOLD	SFRSTCR_BILL_HR_HOLD	NUMBER(7,3)	Yes
SFRSTCR_CREDIT_HR_HOLD	SFRSTCR_CREDIT_HR_HOLD	NUMBER(7,3)	Yes
SFRSTCR_GMOD_CODE	SFRSTCR_GMOD_CODE	VARCHAR2(1)	Yes		*
SFRSTCR_GRDE_CODE	SFRSTCR_GRDE_CODE	VARCHAR2(6)	Yes
SFRSTCR_GRDE_CODE_MID	SFRSTCR_GRDE_CODE_MID	VARCHAR2(6)	Yes
SFRSTCR_GRDE_DATE	SFRSTCR_GRDE_DATE	DATE	Yes
SFRSTCR_DUPL_OVER	SFRSTCR_DUPL_OVER	VARCHAR2(1)	Yes
SFRSTCR_LINK_OVER	SFRSTCR_LINK_OVER	VARCHAR2(1)	Yes
SFRSTCR_CORQ_OVER	SFRSTCR_CORQ_OVER	VARCHAR2(1)	Yes
SFRSTCR_PREQ_OVER	SFRSTCR_PREQ_OVER	VARCHAR2(1)	Yes
SFRSTCR_TIME_OVER	SFRSTCR_TIME_OVER	VARCHAR2(1)	Yes
SFRSTCR_CAPC_OVER	SFRSTCR_CAPC_OVER	VARCHAR2(1)	Yes
SFRSTCR_LEVL_OVER	SFRSTCR_LEVL_OVER	VARCHAR2(1)	Yes
SFRSTCR_COLL_OVER	SFRSTCR_COLL_OVER	VARCHAR2(1)	Yes
SFRSTCR_MAJR_OVER	SFRSTCR_MAJR_OVER	VARCHAR2(1)	Yes
SFRSTCR_CLAS_OVER	SFRSTCR_CLAS_OVER	VARCHAR2(1)	Yes
SFRSTCR_APPR_OVER	SFRSTCR_APPR_OVER	VARCHAR2(1)	Yes
SFRSTCR_APPR_RECEIVED_IND	SFRSTCR_APPR_RECEIVED_IND	VARCHAR2(1)	Yes
SFRSTCR_ADD_DATE	SFRSTCR_ADD_DATE	DATE	No
SFRSTCR_ACTIVITY_DATE	SFRSTCR_ACTIVITY_DATE	DATE	No
SFRSTCR_LEVL_CODE	SFRSTCR_LEVL_CODE	VARCHAR2(2)	No		*
SFRSTCR_CAMP_CODE	SFRSTCR_CAMP_CODE	VARCHAR2(3)	No		*
SFRSTCR_RESERVED_KEY	SFRSTCR_RESERVED_KEY	VARCHAR2(8)	Yes
SFRSTCR_ATTEND_HR	SFRSTCR_ATTEND_HR	NUMBER(9,3)	Yes
SFRSTCR_REPT_OVER	SFRSTCR_REPT_OVER	VARCHAR2(1)	Yes
SFRSTCR_RPTH_OVER	SFRSTCR_RPTH_OVER	VARCHAR2(1)	Yes
SFRSTCR_TEST_OVER	SFRSTCR_TEST_OVER	VARCHAR2(1)	Yes
SFRSTCR_CAMP_OVER	SFRSTCR_CAMP_OVER	VARCHAR2(1)	Yes
SFRSTCR_USER	SFRSTCR_USER	VARCHAR2(30)	Yes
SFRSTCR_DEGC_OVER	SFRSTCR_DEGC_OVER	VARCHAR2(1)	Yes
SFRSTCR_PROG_OVER	SFRSTCR_PROG_OVER	VARCHAR2(1)	Yes
SFRSTCR_LAST_ATTEND	SFRSTCR_LAST_ATTEND	DATE	Yes
SFRSTCR_GCMT_CODE	SFRSTCR_GCMT_CODE	VARCHAR2(7)	Yes		*
SFRSTCR_DATA_ORIGIN	SFRSTCR_DATA_ORIGIN	VARCHAR2(30)	Yes
SFRSTCR_ASSESS_ACTIVITY_DATE		DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRSTCR_TERM_CODE	STVTERM_CODE	STVTERM
SFRSTCR_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRSTCR_LEVL_CODE	STVLEVL_CODE	STVLEVL
SFRSTCR_GMOD_CODE	STVGMOD_CODE	STVGMOD
SFRSTCR_PTRM_CODE	STVPTRM_CODE	STVPTRM
SFRSTCR_CAMP_CODE	STVCAMP_CODE	STVCAMP
SFRSTCR_GCMT_CODE	STVGCMT_CODE	STVGCMT
SFRSTCR_PIDM	SFBETRM_PIDM	SFBETRM
SFRSTCR_TERM_CODE	SFBETRM_TERM_CODE	SFBETRM
SFRSTCR_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SFRSTCR_CRN	SSBSECT_CRN	SSBSECT
SFRSTCR_TERM_CODE	SHRGCOM_TERM_CODE	SHRGCOM
SFRSTCR_CRN	SHRGCOM_CRN	SHRGCOM
SFRSTCR_TERM_CODE	SHRSCOM_TERM_CODE	SHRSCOM
SFRSTCR_CRN	SHRSCOM_CRN	SHRSCOM
SFRSTCR_TERM_CODE	RORENRL_TERM_CODE	RORENRL
SFRSTCR_PIDM	RORENRL_PIDM	RORENRL
SFRSTCR_TERM_CODE	SFRENRL_TERM_CODE	SFRENRL
SFRSTCR_PIDM	SFRENRL_PIDM	SFRENRL

Index

Index Name	Index Type	Column Name
PK_SFRSTCR	Unique	SFRSTCR_TERM_CODE
PK_SFRSTCR	Unique	SFRSTCR_PIDM
PK_SFRSTCR	Unique	SFRSTCR_CRN
SFRSTCR_INDEX2		SFRSTCR_TERM_CODE
SFRSTCR_INDEX2		SFRSTCR_CRN
SFRSTCR_INDEX2		SFRSTCR_CLASS_SORT_KEY
SFRSTCR_INDEX2		SFRSTCR_REG_SEQ
SFRSTCR_KEY_INDEX3		SFRSTCR_PIDM

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Student Course Registration Repeating Table

Columns Comments for SFRSTCR_TERM_CODE (# 1)

Source Code Comments

This field identifies the registration term code.

Columns Comments for SFRSTCR_PIDM (# 2)

Source Code Comments

Internal Identification Number of the person registered.

Columns Comments for SFRSTCR_CRN (# 3)

Source Code Comments

This field identifies the course reference number associated with the class section.

Columns Comments for SFRSTCR_CLASS_SORT_KEY (# 4)

Source Code Comments

This field identifies the class of the registrant.

Columns Comments for SFRSTCR_REG_SEQ (# 5)

Source Code Comments

This field identifies the sequence in which the student enrolled in the associated class section.

Columns Comments for SFRSTCR_PTRM_CODE (# 6)

Source Code Comments

This field identifies the part-of-term code associated with this CRN.

Columns Comments for SFRSTCR_RSTS_CODE (# 7)

Source Code Comments

This field identifies the course registration status associated with this CRN.

Columns Comments for SFRSTCR_RSTS_DATE (# 8)

Source Code Comments

This field identifies the date associated with the course registration status of this CRN.

Columns Comments for SFRSTCR_ERROR_FLAG (# 9)

Source Code Comments

This field identifies an error associated with the registration of this CRN. Valid values are F=Fatal, D=Do not count in enrollment, L=WaitListed, O=Override, W=Warning, X=Delete (used only by SFRSTCR POST
UPDATE DB trigger).

Columns Comments for SFRSTCR_MESSAGE (# 10)

Source Code Comments

This field identifies a message associated with the registration of the CRN

Columns Comments for SFRSTCR_BILL_HR (# 11)

Source Code Comments

This field identifies the billing hours associated with this CRN.

Columns Comments for SFRSTCR_WAIV_HR (# 12)

Source Code Comments

This field identifies the waived hours associated with this CRN.

Columns Comments for SFRSTCR_CREDIT_HR (# 13)

Source Code Comments

This field identifies the credit hours associated with this CRN.

Columns Comments for SFRSTCR_BILL_HR_HOLD (# 14)

Source Code Comments

This field identifies the billing hours to hold for reinstatements.

Columns Comments for SFRSTCR_CREDIT_HR_HOLD (# 15)

Source Code Comments

This field identifies the credit hours to hold for reinstatements.

Columns Comments for SFRSTCR_GMOD_CODE (# 16)

Source Code Comments

This field identifies the grade mode associated with this CRN.

Columns Comments for SFRSTCR_GRDE_CODE (# 17)

Source Code Comments

This field identifies the grade code associated with this CRN.

Columns Comments for SFRSTCR_GRDE_CODE_MID (# 18)

Source Code Comments

This field identifies the mid-term grade code associated with this CRN.

Columns Comments for SFRSTCR_GRDE_DATE (# 19)

Source Code Comments

This field identifies the date associated with the grade of this CRN.

Columns Comments for SFRSTCR_DUPL_OVER (# 20)

Source Code Comments

This field identifies the duplicate course override of this CRN.

Columns Comments for SFRSTCR_LINK_OVER (# 21)

Source Code Comments

This field identifies the link override of this CRN.

Columns Comments for SFRSTCR_CORQ_OVER (# 22)

Source Code Comments

This field identifies the corequisite override of this CRN.

Columns Comments for SFRSTCR_PREQ_OVER (# 23)

Source Code Comments

This field identifies the prerequisite override of this CRN.

Columns Comments for SFRSTCR_TIME_OVER (# 24)

Source Code Comments

This field identifies the time conflict override of this CRN.

Columns Comments for SFRSTCR_CAPC_OVER (# 25)

Source Code Comments

This field identifies the capacity override of this CRN.

Columns Comments for SFRSTCR_LEVL_OVER (# 26)

Source Code Comments

This field identifies the level restriction override of this CRN.

Columns Comments for SFRSTCR_COLL_OVER (# 27)

Source Code Comments

This field identifies the college restriction override of this CRN.

Columns Comments for SFRSTCR_MAJR_OVER (# 28)

Source Code Comments

This field identifies the major restriction override of this CRN.

Columns Comments for SFRSTCR_CLAS_OVER (# 29)

Source Code Comments

This field identifies the class restriction override of this CRN.

Columns Comments for SFRSTCR_APPR_OVER (# 30)

Source Code Comments

This field identifies the special approval override of this CRN.

Columns Comments for SFRSTCR_APPR_RECEIVED_IND (# 31)

Source Code Comments

This field identifies the special approval received indicator for this CRN.

Columns Comments for SFRSTCR_ADD_DATE (# 32)

Source Code Comments

This field identifies the add date of the registrant in this CRN.

Columns Comments for SFRSTCR_ACTIVITY_DATE (# 33)

Source Code Comments

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

Columns Comments for SFRSTCR_LEVL_CODE (# 34)

Source Code Comments

This field identifies the level the registrant is enrolled for this CRN.

Columns Comments for SFRSTCR_CAMP_CODE (# 35)

Source Code Comments

This field identifies the campus code of this CRN.

Columns Comments for SFRSTCR_RESERVED_KEY (# 36)

Source Code Comments

Student Course Registration Table Reserved Key.

Columns Comments for SFRSTCR_ATTEND_HR (# 37)

Source Code Comments

This column contains the number of hours the student attended this class

Columns Comments for SFRSTCR_REPT_OVER (# 38)

Source Code Comments

This field identifies the repeat course restriction override of the CRN

Columns Comments for SFRSTCR_RPTH_OVER (# 39)

Source Code Comments

This field identifies the repeat course hour restriction override of the CRN

Columns Comments for SFRSTCR_TEST_OVER (# 40)

Source Code Comments

This field identifies the test score restriction override of the CRN

Columns Comments for SFRSTCR_CAMP_OVER (# 41)

Source Code Comments

The Campus Registration Restriction override code

Columns Comments for SFRSTCR_USER (# 42)

Source Code Comments

Identifies the user who entered the registration request.

Columns Comments for SFRSTCR_DEGC_OVER (# 43)

Source Code Comments

Degree restriction override indicator

Columns Comments for SFRSTCR_PROG_OVER (# 44)

Source Code Comments

Program restriction override indicator

Columns Comments for SFRSTCR_LAST_ATTEND (# 45)

Source Code Comments

Date student last attended this class

Columns Comments for SFRSTCR_GCMT_CODE (# 46)

Source Code Comments

GRADE COMMENT CODE: This field indicates the grade comment (result code) for the section.

Columns Comments for SFRSTCR_DATA_ORIGIN (# 47)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SFRSTCR_ASSESS_ACTIVITY_DATE (# 48)

Source Code Comments

This field identifies the date when registration activity impacting Fee Assessment occurred. This date is used in flat charge refunding to determine courses that have been updated since the student's last assessment.

Table SIBCFTE

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIBCFTE

Table Columns information

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIBCFTE_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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Faculty Workload Contract FTE Rule Table

Columns Comments for SIBCFTE_FCNT_CODE (# 1)

Source Code Comments

The faculty member workload rule contract code

Columns Comments for SIBCFTE_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member workload FTE

Columns Comments for SIBCFTE_FTE_FACTOR (# 3)

Source Code Comments

The full time equivalent factor

Columns Comments for SIBCFTE_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIBFACD

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIBFACD

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Faculty Information Table

Columns Comments for SIBFACD_PIDM (# 1)

Source Code Comments

Faculty pidm

Columns Comments for SIBFACD_1ST_APPT_DATE (# 2)

Source Code Comments

First Appointment Date

Columns Comments for SIBFACD_RANK_CODE (# 3)

Source Code Comments

Faculty Rank Code

Columns Comments for SIBFACD_RANK_DATE (# 4)

Source Code Comments

Faculty Rank Code Date

Columns Comments for SIBFACD_DISP_CODE (# 5)

Source Code Comments

Faculty Discipline Code

Columns Comments for SIBFACD_TENR_CODE (# 6)

Source Code Comments

Faculty Tenure Code

Columns Comments for SIBFACD_TENURE_DATE (# 7)

Source Code Comments

Faculty Tenure Date

Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)

Source Code Comments

Faculty Tenure Review Date

Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)

Source Code Comments

Faculty Last Sabbatical Date

Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)

Source Code Comments

Faculty Next Sabbatical Date

Columns Comments for SIBFACD_YRS_EXP (# 11)

Source Code Comments

Years Experience

Columns Comments for SIBFACD_BIRTH_STATE (# 12)

Source Code Comments

State of Birth

Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)

Source Code Comments

American Association of University Professors member indicator

Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)

Source Code Comments

Activity Date

Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)

Source Code Comments

ACADEMIC TITLE: The formal title of this faculty member.

Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)

Source Code Comments

Indicate whether primary activity is Instructional, Research or Administrative.

Table SIBFACD_TMP

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIBFACD_TMP

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

No Foreign Key

Index

No Result

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Faculty Information Table

Columns Comments for SIBFACD_PIDM (# 1)

Source Code Comments

Faculty pidm

Columns Comments for SIBFACD_1ST_APPT_DT (# 2)

Source Code Comments

First Appointment Date

Columns Comments for SIBFACD_RANK_CODE (# 3)

Source Code Comments

Faculty Rank Code

Columns Comments for SIBFACD_RANK_DATE (# 4)

Source Code Comments

Faculty Rank Code Date

Columns Comments for SIBFACD_DISP_CODE (# 5)

Source Code Comments

Faculty Discipline Code

Columns Comments for SIBFACD_TENR_CODE (# 6)

Source Code Comments

Faculty Tenure Code

Columns Comments for SIBFACD_TENURE_DATE (# 7)

Source Code Comments

Faculty Tenure Date

Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)

Source Code Comments

Faculty Tenure Review Date

Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)

Source Code Comments

Faculty Last Sabbatical Date

Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)

Source Code Comments

Faculty Next Sabbatical Date

Columns Comments for SIBFACD_YRS_EXP (# 11)

Source Code Comments

Years Experience

Columns Comments for SIBFACD_BIRTH_STATE (# 12)

Source Code Comments

State of Birth

Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)

Source Code Comments

American Association of University Professors member indicator

Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)

Source Code Comments

Activity Date

Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)

Source Code Comments

ACADEMIC TITLE: The formal title of this faculty member.

Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)

Source Code Comments

Indicate whether primary activity is Instructional, Research or Administrative.

Table SIBINST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIBINST

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_WKLD_CODE	STVWKLD_CODE	STVWKLD
SIBINST_TERM_CODE_EFF	STVTERM_CODE	STVTERM
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

Index

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Faculty Member Base Table

Columns Comments for SIBINST_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIBINST_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIBINST_FCST_CODE (# 3)

Source Code Comments

Faculty member status

Columns Comments for SIBINST_FCTG_CODE (# 4)

Source Code Comments

Faculty member category

Columns Comments for SIBINST_FSTP_CODE (# 5)

Source Code Comments

Faculty member staff type which is required for workload calculation

Columns Comments for SIBINST_FCNT_CODE (# 6)

Source Code Comments

Faculty member contract rule which is required for workload calculation

Columns Comments for SIBINST_SCHD_IND (# 7)

Source Code Comments

Faculty member available of schedule indicator

Columns Comments for SIBINST_ADVR_IND (# 8)

Source Code Comments

Faculty member available of advisment indicator

Columns Comments for SIBINST_FCST_DATE (# 9)

Source Code Comments

Faculty member status date

Columns Comments for SIBINST_WKLD_CODE (# 10)

Source Code Comments

Faculty member workload rule code

Columns Comments for SIBINST_CNTR_CODE (# 11)

Source Code Comments

Faculty member contract rule code

Columns Comments for SIBINST_APPOINT_DATE (# 12)

Source Code Comments

The date the appointment was awarded

Columns Comments for SIBINST_ACTIVITY_DATE (# 13)

Source Code Comments

Activity date

Columns Comments for SIBINST_DATA_ORIGIN (# 14)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SIBINST_USER_ID (# 15)

Source Code Comments

USER ID: User who inserted or last update the data

Table SIBTERM

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIBTERM

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Faculty load FTE and calculation fators rules Base Table

Columns Comments for SIBTERM_TERM_CODE (# 1)

Source Code Comments

Term of the rule

Columns Comments for SIBTERM_FTE_FACTOR (# 2)

Source Code Comments

Faculty load FTE factor

Columns Comments for SIBTERM_CALC_DEV_FACTOR (# 3)

Source Code Comments

Faculty load calculation deviation factor

Columns Comments for SIBTERM_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRASGN

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRASGN

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_ASTY_CODE	STVASTY_CODE	STVASTY
SIRASGN_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRASGN_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SIRASGN_CRN	SSBSECT_CRN	SSBSECT
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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Faculty Member Instructional Assignment Repeating Table

Columns Comments for SIRASGN_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member assignment

Columns Comments for SIRASGN_CRN (# 2)

Source Code Comments

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

Columns Comments for SIRASGN_PIDM (# 3)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRASGN_CATEGORY (# 4)

Source Code Comments

The session indicator associated with the assignment

Columns Comments for SIRASGN_PERCENT_RESPONSE (# 5)

Source Code Comments

Faculty members percentage of responsibility to the assignment

Columns Comments for SIRASGN_WORKLOAD_ADJUST (# 6)

Source Code Comments

Faculty Adjustied Workload for instructional assignment.

Columns Comments for SIRASGN_PERCENT_SESS (# 7)

Source Code Comments

Faculty session percentage of responsibility of instructional assignment.

Columns Comments for SIRASGN_PRIMARY_IND (# 8)

Source Code Comments

The primary instructor of the course

Columns Comments for SIRASGN_OVER_RIDE (# 9)

Source Code Comments

Override Indicator.

Columns Comments for SIRASGN_POSITION (# 10)

Source Code Comments

Faculty Position.

Columns Comments for SIRASGN_ACTIVITY_DATE (# 11)

Source Code Comments

Activity date

Columns Comments for SIRASGN_FCNT_CODE (# 12)

Source Code Comments

The contract type that the instructional assignment is associated with

Columns Comments for SIRASGN_POSN (# 13)

Source Code Comments

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

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRATTR

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Attribute Information Repeating Table

Columns Comments for SIRATTR_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRATTR_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRATTR_FATT_CODE (# 3)

Source Code Comments

The faculty member attribute

Columns Comments for SIRATTR_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRCMNT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRCMNT

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Faculty Comment Information Repeating Table

Columns Comments for SIRCMNT_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRCMNT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRCMNT_SEQNO (# 3)

Source Code Comments

The sequence number of the faculty member comments

Columns Comments for SIRCMNT_TEXT (# 4)

Source Code Comments

The comments of the faculty member comments

Columns Comments for SIRCMNT_ACTIVITY_DATE (# 5)

Source Code Comments

Activity date

Table SIRCOLC

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRCOLC

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Member Collector Table

Columns Comments for SIRCOLC_SESSIONID (# 1)

Source Code Comments

Unique Session Id created for collected record.

Columns Comments for SIRCOLC_FATT_CODE (# 2)

Source Code Comments

Faculty Attribute Code for collected record.

Table SIRCOLR

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRCOLR

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
SIRCOLR_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRCOLR_TERM_CODE	STVTERM_CODE	STVTERM

Index

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Load Collector Repeating Table

Columns Comments for SIRCOLR_SESSIONID (# 1)

Source Code Comments

Unique Session Id created for collected record.

Columns Comments for SIRCOLR_PIDM (# 2)

Source Code Comments

Pidm created for the collected record.

Columns Comments for SIRCOLR_TERM_CODE (# 3)

Source Code Comments

Term Code created for collected record.

Columns Comments for SIRCOLR_FCNT_CODE (# 4)

Source Code Comments

Contract Code of the Collected Record.

Columns Comments for SIRCOLR_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for SIRCOLR_TERM_CODE_EFF (# 6)

Source Code Comments

The effective term of the contract summary processing

Table SIRDPCL

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRDPCL

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_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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Faculty Member Department and College Information Repeating Table

Columns Comments for SIRDPCL_PIDM (# 1)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRDPCL_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member

Columns Comments for SIRDPCL_COLL_CODE (# 3)

Source Code Comments

The college which faculty member is assigned to

Columns Comments for SIRDPCL_DEPT_CODE (# 4)

Source Code Comments

The department which faculty member is assigned to

Columns Comments for SIRDPCL_HOME_IND (# 5)

Source Code Comments

The home administrative department and college indicator

Columns Comments for SIRDPCL_PERCENTAGE (# 6)

Source Code Comments

Faculty members percentage of responsibility to the department and college

Columns Comments for SIRDPCL_ACTIVITY_DATE (# 7)

Source Code Comments

Activity date

Table SIRFCNT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRFCNT

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRFCNT_TERM_CODE	STVTERM_CODE	STVTERM
SIRFCNT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRFCNT_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN
SIRFCNT_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR

Index

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Faculty Contract Rule Information Repeating Table

Columns Comments for SIRFCNT_FCNT_CODE (# 1)

Source Code Comments

The faculty contract rule

Columns Comments for SIRFCNT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term for the faculty contract rule

Columns Comments for SIRFCNT_TERM_CODE (# 3)

Source Code Comments

Terms for the faculty contract type

Columns Comments for SIRFCNT_ACTIVITY_DATE (# 4)

Source Code Comments

Activity date

Table SIRFLCT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRFLCT

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	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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Faculty Member Contract Term Rule Table

Columns Comments for SIRFLCT_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member contract rule

Columns Comments for SIRFLCT_FCNT_CODE (# 2)

Source Code Comments

The faculty member contract type code

Columns Comments for SIRFLCT_STATUS (# 3)

Source Code Comments

The faculty member contract rule status

Columns Comments for SIRFLCT_CNTR_CODE (# 4)

Source Code Comments

The faculty member contract rule code

Columns Comments for SIRFLCT_CREDIT_HR_LOW (# 5)

Source Code Comments

The faculty member contract rule low range total credit hours

Columns Comments for SIRFLCT_CREDIT_HR_HIGH (# 6)

Source Code Comments

The faculty member contract rule high range total credit hours

Columns Comments for SIRFLCT_CREDIT_HR_LOW_GEN (# 7)

Source Code Comments

The faculty member contract rule low range total generated credit hours

Columns Comments for SIRFLCT_CREDIT_HR_HIGH_GEN (# 8)

Source Code Comments

The faculty member contract rule high range total generated credit hours

Columns Comments for SIRFLCT_CONTACT_HR_LOW (# 9)

Source Code Comments

The faculty member contract rule total low range total contact hours

Columns Comments for SIRFLCT_CONTACT_HR_HIGH (# 10)

Source Code Comments

The faculty member contract rule high range total contact hours

Columns Comments for SIRFLCT_CONTACT_HR_LOW_WEEK (# 11)

Source Code Comments

The faculty member contract rule low range total weekly contact hours

Columns Comments for SIRFLCT_CONTACT_HR_HIGH_WEEK (# 12)

Source Code Comments

The faculty member contract rule high range total weekly contact hours

Columns Comments for SIRFLCT_INST_WORKLOAD_LOW (# 13)

Source Code Comments

The faculty member contract rule low range total instructional workload

Columns Comments for SIRFLCT_INST_WORKLOAD_HIGH (# 14)

Source Code Comments

The faculty member contract rule total high range total instructional workload

Columns Comments for SIRFLCT_NIST_WORKLOAD_LOW (# 15)

Source Code Comments

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

Columns Comments for SIRFLCT_NIST_WORKLOAD_HIGH (# 16)

Source Code Comments

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

Columns Comments for SIRFLCT_TOT_WORKLOAD_LOW (# 17)

Source Code Comments

The faculty member contract rule low range total workload

Columns Comments for SIRFLCT_TOT_WORKLOAD_HIGH (# 18)

Source Code Comments

The faculty member contract rule high range total workload

Columns Comments for SIRFLCT_FTE_LOW (# 19)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLCT_FTE_HIGH (# 20)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLCT_ACTIVITY_DATE (# 21)

Source Code Comments

Activity date

Table SIRFLRC

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRFLRC

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SIRFLRC_CNTR_CODE	STVCNTR_CODE	STVCNTR
SIRFLRC_FCNT_CODE	STVFCNT_CODE	STVFCNT

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Faculty Member Workload Contract Rule Table

Columns Comments for SIRFLRC_FCNT_CODE (# 1)

Source Code Comments

The faculty member workload rule contract code

Columns Comments for SIRFLRC_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term of the faculty member workload rule

Columns Comments for SIRFLRC_STATUS (# 3)

Source Code Comments

The faculty member workload rule status

Columns Comments for SIRFLRC_CNTR_CODE (# 4)

Source Code Comments

The faculty member workload rule code

Columns Comments for SIRFLRC_CREDIT_HR_LOW (# 5)

Source Code Comments

The faculty member workload rule low range total credit hours

Columns Comments for SIRFLRC_CREDIT_HR_HIGH (# 6)

Source Code Comments

The faculty member workload rule high range total credit hours

Columns Comments for SIRFLRC_CREDIT_HR_LOW_GEN (# 7)

Source Code Comments

The faculty member workload rule low range total generated credit hours

Columns Comments for SIRFLRC_CREDIT_HR_HIGH_GEN (# 8)

Source Code Comments

The faculty member workload rule high range total generated credit hours

Columns Comments for SIRFLRC_CONTACT_HR_LOW (# 9)

Source Code Comments

The faculty member workload rule total low range total contact hours

Columns Comments for SIRFLRC_CONTACT_HR_HIGH (# 10)

Source Code Comments

The faculty member workload rule high range total contact hours

Columns Comments for SIRFLRC_CONTACT_HR_LOW_WEEK (# 11)

Source Code Comments

The faculty member workload rule low range total weekly contact hours

Columns Comments for SIRFLRC_CONTACT_HR_HIGH_WEEK (# 12)

Source Code Comments

The faculty member workload rule high range total weekly contact hours

Columns Comments for SIRFLRC_INST_WORKLOAD_LOW (# 13)

Source Code Comments

The faculty member workload rule low range total instructional workload

Columns Comments for SIRFLRC_INST_WORKLOAD_HIGH (# 14)

Source Code Comments

The faculty member workload rule total high range total instructional workload

Columns Comments for SIRFLRC_NIST_WORKLOAD_LOW (# 15)

Source Code Comments

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

Columns Comments for SIRFLRC_NIST_WORKLOAD_HIGH (# 16)

Source Code Comments

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

Columns Comments for SIRFLRC_TOT_WORKLOAD_LOW (# 17)

Source Code Comments

The faculty member workload rule low range total workload

Columns Comments for SIRFLRC_TOT_WORKLOAD_HIGH (# 18)

Source Code Comments

The faculty member workload rule high range total workload

Columns Comments for SIRFLRC_FTE_FACTOR (# 19)

Source Code Comments

The full time equivalent factor

Columns Comments for SIRFLRC_FTE_LOW (# 20)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLRC_FTE_HIGH (# 21)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLRC_ACTIVITY_DATE (# 22)

Source Code Comments

Activity date

Table SIRFLRT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRFLRT

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_TERM_CODE	STVTERM_CODE	STVTERM
SIRFLRT_WKLD_CODE	STVWKLD_CODE	STVWKLD

Index

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Faculty Member Workload Term Rule Table

Columns Comments for SIRFLRT_TERM_CODE (# 1)

Source Code Comments

Effective term of the faculty member workload rule

Columns Comments for SIRFLRT_STATUS (# 2)

Source Code Comments

The faculty member workload rule status

Columns Comments for SIRFLRT_WKLD_CODE (# 3)

Source Code Comments

The faculty member workload rule code

Columns Comments for SIRFLRT_CREDIT_HR_LOW (# 4)

Source Code Comments

The faculty member workload rule low range total credit hours

Columns Comments for SIRFLRT_CREDIT_HR_HIGH (# 5)

Source Code Comments

The faculty member workload rule high range total credit hours

Columns Comments for SIRFLRT_CREDIT_HR_LOW_GEN (# 6)

Source Code Comments

The faculty member workload rule low range total generated credit hours

Columns Comments for SIRFLRT_CREDIT_HR_HIGH_GEN (# 7)

Source Code Comments

The faculty member workload rule high range total generated credit hours

Columns Comments for SIRFLRT_CONTACT_HR_LOW (# 8)

Source Code Comments

The faculty member workload rule total low range total contact hours

Columns Comments for SIRFLRT_CONTACT_HR_HIGH (# 9)

Source Code Comments

The faculty member workload rule high range total contact hours

Columns Comments for SIRFLRT_CONTACT_HR_LOW_WEEK (# 10)

Source Code Comments

The faculty member workload rule low range total weekly contact hours

Columns Comments for SIRFLRT_CONTACT_HR_HIGH_WEEK (# 11)

Source Code Comments

The faculty member workload rule high range total weekly contact hours

Columns Comments for SIRFLRT_INST_WORKLOAD_LOW (# 12)

Source Code Comments

The faculty member workload rule low range total instructional workload

Columns Comments for SIRFLRT_INST_WORKLOAD_HIGH (# 13)

Source Code Comments

The faculty member workload rule total high range total instructional workload

Columns Comments for SIRFLRT_NIST_WORKLOAD_LOW (# 14)

Source Code Comments

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

Columns Comments for SIRFLRT_NIST_WORKLOAD_HIGH (# 15)

Source Code Comments

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

Columns Comments for SIRFLRT_TOT_WORKLOAD_LOW (# 16)

Source Code Comments

The faculty member workload rule low range total workload

Columns Comments for SIRFLRT_TOT_WORKLOAD_HIGH (# 17)

Source Code Comments

The faculty member workload rule high range total workload

Columns Comments for SIRFLRT_FTE_LOW (# 18)

Source Code Comments

The full time equivalent low range

Columns Comments for SIRFLRT_FTE_HIGH (# 19)

Source Code Comments

The full time equivalent high range

Columns Comments for SIRFLRT_ACTIVITY_DATE (# 20)

Source Code Comments

Activity date

Table SIRICNT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRICNT

Table Columns information

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:37:000

Source Code Comments

Faculty Contract Type Repeating Table

Columns Comments for SIRICNT_PIDM (# 1)

Source Code Comments

The internal system identifier of the faculty member

Columns Comments for SIRICNT_TERM_CODE_EFF (# 2)

Source Code Comments

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

Columns Comments for SIRICNT_FCNT_CODE (# 3)

Source Code Comments

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

Columns Comments for SIRICNT_CNTR_CODE (# 4)

Source Code Comments

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

Columns Comments for SIRICNT_DEF_IND (# 5)

Source Code Comments

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

Columns Comments for SIRICNT_ACTIVITY_DATE (# 6)

Source Code Comments

The date the record was created or last updated

Table SIRLVAS

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRLVAS

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	STVTERM_CODE	STVTERM
SIRLVAS_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SIRLVAS_CRN	SSBSECT_CRN	SSBSECT
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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Faculty Leave Assignment Table

Columns Comments for SIRLVAS_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member leave assignment.

Columns Comments for SIRLVAS_CRN (# 2)

Source Code Comments

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

Columns Comments for SIRLVAS_PIDM (# 3)

Source Code Comments

The pidm of the faculty member.

Columns Comments for SIRLVAS_CATEGORY (# 4)

Source Code Comments

The session indicator associated with the assignment.

Columns Comments for SIRLVAS_PERCENT_RESPONSE (# 5)

Source Code Comments

Faculty members percentage of the responsibility to the assignment.

Columns Comments for SIRLVAS_PERCENT_SESS (# 6)

Source Code Comments

Faculty session percentage of the responsibility of instructional assignment.

Columns Comments for SIRLVAS_ACTIVITY_DATE (# 7)

Source Code Comments

The Activity Date

Columns Comments for SIRLVAS_WORKLOAD_ADJUST (# 8)

Source Code Comments

Faculty Adjusted Workload for instructional assignment.

Columns Comments for SIRLVAS_PRIMARY_IND (# 9)

Source Code Comments

The primary instructor of the course.

Columns Comments for SIRLVAS_OVERRIDE_IND (# 10)

Source Code Comments

Override Indicator.

Columns Comments for SIRLVAS_POSITION (# 11)

Source Code Comments

Faculty Position.

Columns Comments for SIRLVAS_FCNT_CODE (# 12)

Source Code Comments

The contract type that the instructional assignment is associated with.

Columns Comments for SIRLVAS_POSN (# 13)

Source Code Comments

Position number.

Columns Comments for SIRLVAS_SUFF (# 14)

Source Code Comments

Position number suffix.

Columns Comments for SIRLVAS_ASTY_CODE (# 15)

Source Code Comments

Assignment Type Code

Table SIRNIST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRNIST

Table Columns information

Column Name	Label	Column Type	Allow NULL	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_COLL_CODE	STVCOLL_CODE	STVCOLL
SIRNIST_DEPT_CODE	STVDEPT_CODE	STVDEPT
SIRNIST_ASTY_CODE	STVASTY_CODE	STVASTY
SIRNIST_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRNIST_NIST_CODE	STVNIST_CODE	STVNIST
SIRNIST_TOPS_CODE	STVTOPS_CODE	STVTOPS
SIRNIST_TERM_CODE	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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Faculty Member Non-instructional Assignment Repeating Table

Columns Comments for SIRNIST_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member assignment

Columns Comments for SIRNIST_PIDM (# 2)

Source Code Comments

The Pidm of the faculty member

Columns Comments for SIRNIST_NIST_CODE (# 3)

Source Code Comments

The non-instructional type code

Columns Comments for SIRNIST_COLL_CODE (# 4)

Source Code Comments

The non-instructional college code

Columns Comments for SIRNIST_DEPT_CODE (# 5)

Source Code Comments

The non-instructional department code

Columns Comments for SIRNIST_NIST_WORKLOAD (# 6)

Source Code Comments

The non-instructional workload value

Columns Comments for SIRNIST_TOPS_CODE (# 7)

Source Code Comments

The TOP or CSS code

Columns Comments for SIRNIST_ACTIVITY_DATE (# 8)

Source Code Comments

Activity date

Columns Comments for SIRNIST_FCNT_CODE (# 9)

Source Code Comments

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

Columns Comments for SIRNIST_POSN (# 10)

Source Code Comments

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

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIRNLVA

Table Columns information

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Leave Non-Instructional Assignment Table

Columns Comments for SIRNLVA_TERM_CODE (# 1)

Source Code Comments

Term of the faculty member leave assignment.

Columns Comments for SIRNLVA_PIDM (# 2)

Source Code Comments

The pidm of the faculty member.

Columns Comments for SIRNLVA_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Columns Comments for SIRNLVA_NIST_CODE (# 4)

Source Code Comments

The non-instructional type code.

Columns Comments for SIRNLVA_COLL_CODE (# 5)

Source Code Comments

The non-instructional college code

Columns Comments for SIRNLVA_DEPT_CODE (# 6)

Source Code Comments

The non-instructional department code.

Columns Comments for SIRNLVA_NIST_WORKLOAD (# 7)

Source Code Comments

The non-instructional workload value.

Columns Comments for SIRNLVA_NIST_WEEKLY_HRS (# 8)

Source Code Comments

The non-instructional weekly contact hours.

Columns Comments for SIRNLVA_TOPS_CODE (# 9)

Source Code Comments

The TOP of CSS code.

Columns Comments for SIRNLVA_FCNT_CODE (# 10)

Source Code Comments

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

Columns Comments for SIRNLVA_POSN (# 11)

Source Code Comments

Position number.

Columns Comments for SIRNLVA_SUFF (# 12)

Source Code Comments

Position number suffix.

Columns Comments for SIRNLVA_ASTY_CODE (# 13)

Source Code Comments

Assignment Type Code

Table SIROFFC

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SIROFFC

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_TERM_CODE	STVTERM_CODE	STVTERM
SIROFFC_TELE_CODE	STVTELE_CODE	STVTELE

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

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

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

Columns Comments for SIROFFC_TERM_CODE (# 1)

Source Code Comments

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

Columns Comments for SIROFFC_CRN (# 2)

Source Code Comments

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

Columns Comments for SIROFFC_PIDM (# 3)

Source Code Comments

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

Columns Comments for SIROFFC_FROM_DATE (# 4)

Source Code Comments

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

Columns Comments for SIROFFC_TO_DATE (# 5)

Source Code Comments

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

Columns Comments for SIROFFC_FROM_TIME (# 6)

Source Code Comments

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

Columns Comments for SIROFFC_DISPLAY_IND (# 8)

Source Code Comments

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

Columns Comments for SIROFFC_ACTIVITY_DATE (# 9)

Source Code Comments

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

Columns Comments for SIROFFC_USER_ID (# 10)

Source Code Comments

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

Columns Comments for SIROFFC_LOCATION (# 11)

Source Code Comments

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

Columns Comments for SIROFFC_TELE_CODE (# 12)

Source Code Comments

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

Columns Comments for SIROFFC_PHONE_AREA (# 13)

Source Code Comments

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

Columns Comments for SIROFFC_PHONE_NUMBER (# 14)

Source Code Comments

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

Columns Comments for SIROFFC_PHONE_EXTN (# 15)

Source Code Comments

Phone Extension: This field contains the phone number extension.

Columns Comments for SIROFFC_SUN_DAY (# 16)

Source Code Comments

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

Columns Comments for SIROFFC_MON_DAY (# 17)

Source Code Comments

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

Columns Comments for SIROFFC_TUE_DAY (# 18)

Source Code Comments

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

Columns Comments for SIROFFC_WED_DAY (# 19)

Source Code Comments

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

Columns Comments for SIROFFC_THU_DAY (# 20)

Source Code Comments

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

Columns Comments for SIROFFC_FRI_DAY (# 21)

Source Code Comments

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

Columns Comments for SIROFFC_SAT_DAY (# 22)

Source Code Comments

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

Table SPRIDEN

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SPRIDEN

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_ID	SPRIDEN_ID	VARCHAR2(9)	No	*
SPRIDEN_LAST_NAME	SPRIDEN_LAST_NAME	VARCHAR2(60)	No
SPRIDEN_FIRST_NAME	SPRIDEN_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_MI	SPRIDEN_MI	VARCHAR2(15)	Yes
SPRIDEN_CHANGE_IND	SPRIDEN_CHANGE_IND	VARCHAR2(1)	Yes
SPRIDEN_ENTITY_IND	SPRIDEN_ENTITY_IND	VARCHAR2(1)	Yes
SPRIDEN_ACTIVITY_DATE	SPRIDEN_ACTIVITY_DATE	DATE	No
SPRIDEN_USER	SPRIDEN_USER	VARCHAR2(30)	Yes
SPRIDEN_ORIGIN	SPRIDEN_ORIGIN	VARCHAR2(30)	Yes
SPRIDEN_SEARCH_LAST_NAME	SPRIDEN_SEARCH_LAST_NAME	VARCHAR2(60)	Yes
SPRIDEN_SEARCH_FIRST_NAME	SPRIDEN_SEARCH_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_SEARCH_MI	SPRIDEN_SEARCH_MI	VARCHAR2(15)	Yes
SPRIDEN_SOUNDEX_LAST_NAME	SPRIDEN_SOUNDEX_LAST_NAME	CHAR(4)	Yes
SPRIDEN_SOUNDEX_FIRST_NAME	SPRIDEN_SOUNDEX_FIRST_NAME	CHAR(4)	Yes
SPRIDEN_NTYP_CODE	SPRIDEN_NTYP_CODE	VARCHAR2(4)	Yes
SPRIDEN_CREATE_USER	SPRIDEN_CREATE_USER	VARCHAR2(30)	Yes
SPRIDEN_CREATE_DATE	SPRIDEN_CREATE_DATE	DATE	Yes
SPRIDEN_DATA_ORIGIN	SPRIDEN_DATA_ORIGIN	VARCHAR2(30)	Yes
SPRIDEN_CREATE_FDMN_CODE	SPRIDEN_CREATE_FDMN_CODE	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRIDEN_PIDM	RPRATRM_PIDM	RPRATRM
SPRIDEN_PIDM	AGRPIDS_XREF_PIDM	AGRPIDS
SPRIDEN_PIDM	AGRPIDS_PIDM	AGRPIDS
SPRIDEN_PIDM	ASRSSAG_PIDM	ASRSSAG
SPRIDEN_PIDM	AOBORGN_PIDM	AOBORGN
SPRIDEN_PIDM	ASRSORG_PIDM	ASRSORG
SPRIDEN_PIDM	AGRGIDS_XREF_PIDM	AGRGIDS
SPRIDEN_PIDM	AGRGIDS_PIDM	AGRGIDS
SPRIDEN_PIDM	AGBPLDG_PIDM	AGBPLDG
SPRIDEN_PIDM	AGRPMEM_PIDM	AGRPMEM
SPRIDEN_PIDM	AGRPMEM_MEMO_PIDM	AGRPMEM
SPRIDEN_PIDM	AGRGMEM_PIDM	AGRGMEM
SPRIDEN_PIDM	AGRGMEM_MEMO_PIDM	AGRGMEM
SPRIDEN_PIDM	AGRGPAY_PIDM	AGRGPAY
SPRIDEN_PIDM	APRXREF_XREF_PIDM	APRXREF
SPRIDEN_PIDM	GLBEXTR_KEY	GLBEXTR
SPRIDEN_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
SPRIDEN_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
SPRIDEN_PIDM	FRRPRPI_ID_PIDM	FRRPRPI
SPRIDEN_PIDM	FIRBOND_IMGR_CODE_PIDM	FIRBOND
SPRIDEN_PIDM	FPBAGRH_VEND_PIDM	FPBAGRH
SPRIDEN_PIDM	FTVAGCY_AGCY_CODE_PIDM	FTVAGCY
SPRIDEN_PIDM	APRCATG_PIDM	APRCATG
SPRIDEN_PIDM	AARMEMB_RENEWAL_PIDM	AARMEMB
SPRIDEN_PIDM	AARMEMB_REMINDER_PIDM	AARMEMB
SPRIDEN_PIDM	APRDRVW_PIDM	APRDRVW
SPRIDEN_PIDM	FRBGRNT_AGENCY_PIDM	FRBGRNT
SPRIDEN_PIDM	FRRGRPI_ID_PIDM	FRRGRPI
SPRIDEN_PIDM	FPRBIDV_VEND_PIDM	FPRBIDV
SPRIDEN_PIDM	FPBREQH_VEND_PIDM	FPBREQH
SPRIDEN_PIDM	FIRCERD_IMGR_CODE_PIDM	FIRCERD
SPRIDEN_PIDM	FIRMMKT_IMGR_CODE_PIDM	FIRMMKT
SPRIDEN_PIDM	FIRPRTY_IMGR_CODE_PIDM	FIRPRTY
SPRIDEN_PIDM	FTVFMGR_FMGR_CODE_PIDM	FTVFMGR
SPRIDEN_PIDM	FIRSTCK_IMGR_CODE_PIDM	FIRSTCK
SPRIDEN_PIDM	FIRSTOP_IMGR_CODE_PIDM	FIRSTOP
SPRIDEN_PIDM	GERFGST_PIDM	GERFGST
SPRIDEN_PIDM	GERATTD_PIDM	GERATTD
SPRIDEN_PIDM	GEBFUNC_SPNSR_ORGN_PIDM	GEBFUNC
SPRIDEN_PIDM	GORSEVS_PIDM	GORSEVS
SPRIDEN_PIDM	GORSEVD_DEP_PIDM	GORSEVD
SPRIDEN_PIDM	GOBSEVS_PIDM	GOBSEVS
SPRIDEN_PIDM	GORSVAS_ACT_SITE_PIDM	GORSVAS
SPRIDEN_PIDM	GORSVEI_EMPLOYER_PIDM	GORSVEI
SPRIDEN_PIDM	PERTETH_TRANS_PIDM	PERTETH
SPRIDEN_PIDM	PERHSIP_PIDM	PERHSIP
SPRIDEN_PIDM	GOBSRVR_PIDM	GOBSRVR
SPRIDEN_PIDM	NBRJOBS_PIDM	NBRJOBS
SPRIDEN_PIDM	GOBEACC_PIDM	GOBEACC
SPRIDEN_PIDM	NOBTRAN_PIDM	NOBTRAN
SPRIDEN_PIDM	PCBPERS_COBRA_BFCTR_PIDM	PCBPERS
SPRIDEN_PIDM	PDRBENE_BENE_PIDM	PDRBENE
SPRIDEN_PIDM	NBRBJOB_PIDM	NBRBJOB
SPRIDEN_PIDM	PERBARG_PIDM	PERBARG
SPRIDEN_PIDM	PERJOBS_PIDM	PERJOBS
SPRIDEN_PIDM	TBBCONT_PIDM	TBBCONT
SPRIDEN_PIDM	TBRCOLC_PIDM	TBRCOLC
SPRIDEN_PIDM	TBBCSTU_STU_PIDM	TBBCSTU
SPRIDEN_PIDM	TBBACCT_PIDM	TBBACCT
SPRIDEN_PIDM	TBBESTU_PIDM	TBBESTU
SPRIDEN_PIDM	TBRACCD_PIDM	TBRACCD
SPRIDEN_PIDM	FTVCARD_CARDHOLDER_PIDM	FTVCARD
SPRIDEN_PIDM	FCREMPO_PIDM	FCREMPO
SPRIDEN_PIDM	FABINVH_VEND_PIDM	FABINVH
SPRIDEN_PIDM	APBCONS_PIDM	APBCONS
SPRIDEN_PIDM	APRERVW_PIDM	APRERVW
SPRIDEN_PIDM	APRSRVW_PIDM	APRSRVW
SPRIDEN_PIDM	APRCRVW_PIDM	APRCRVW
SPRIDEN_PIDM	SIBINST_PIDM	SIBINST
SPRIDEN_PIDM	SLBEVNT_AGENCY_PIDM	SLBEVNT
SPRIDEN_PIDM	SHTTRAN_PIDM	SHTTRAN
SPRIDEN_PIDM	SMBSLIB_PIDM	SMBSLIB
SPRIDEN_PIDM	SMBAOGN_PIDM	SMBAOGN
SPRIDEN_PIDM	SMRRQCM_ORIG_PIDM	SMRRQCM
SPRIDEN_PIDM	SMRRQCM_PIDM	SMRRQCM
SPRIDEN_ID	SRTIDEN_ID	SRTIDEN
SPRIDEN_PIDM	SRTIDEN_PIDM	SRTIDEN
SPRIDEN_PIDM	SHBDIPL_PIDM	SHBDIPL
SPRIDEN_PIDM	SORPCOL_PIDM	SORPCOL
SPRIDEN_PIDM	SLRRMAT_PIDM	SLRRMAT
SPRIDEN_PIDM	SORHSCH_PIDM	SORHSCH
SPRIDEN_PIDM	SHBCATT_PIDM	SHBCATT
SPRIDEN_PIDM	SORAINF_PIDM	SORAINF
SPRIDEN_PIDM	GERPART_PIDM	GERPART
SPRIDEN_PIDM	SPBPERS_PIDM	SPBPERS
SPRIDEN_PIDM	PEBEMPL_PIDM	PEBEMPL
SPRIDEN_PIDM	FTVVEND_PIDM	FTVVEND
SPRIDEN_PIDM	FTVCUST_PIDM	FTVCUST
SPRIDEN_PIDM	FRBPROP_AGENCY_PIDM	FRBPROP
SPRIDEN_PIDM	RNRTMNT_PIDM	RNRTMNT
SPRIDEN_PIDM	SIRASGN_PIDM	SIRASGN
SPRIDEN_PIDM	SORAROL_PIDM	SORAROL
SPRIDEN_PIDM	SABSTUD_PIDM	SABSTUD
SPRIDEN_PIDM	SGBSTDN_PIDM	SGBSTDN
SPRIDEN_PIDM	SFRENRL_PIDM	SFRENRL
SPRIDEN_PIDM	SMBPOGN_PIDM	SMBPOGN
SPRIDEN_PIDM	SGRASSI_PIDM	SGRASSI
SPRIDEN_PIDM	SHBHEAD_PIDM	SHBHEAD
SPRIDEN_PIDM	RORLOGM_PIDM	RORLOGM
SPRIDEN_PIDM	SFRSTCR_PIDM	SFRSTCR
SPRIDEN_PIDM	SHRDGMR_PIDM	SHRDGMR
SPRIDEN_PIDM	AMRCONF_PIDM	AMRCONF

Index

Index Name	Index Type	Column Name
SPRIDEN_INDEX_ID		SPRIDEN_ID
SPRIDEN_INDEX_ID		SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_ID		SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_PERS		SPRIDEN_LAST_NAME
SPRIDEN_INDEX_PERS		SPRIDEN_FIRST_NAME
SPRIDEN_INDEX_PERS		SPRIDEN_MI
SPRIDEN_INDEX_PERS		SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_PERS		SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_LAST_NAME
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_FIRST_NAME
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_MI
SPRIDEN_INDEX_SOUNDEX		SPRIDEN_SOUNDEX_LAST_NAME
SPRIDEN_INDEX_SOUNDEX		SPRIDEN_SOUNDEX_FIRST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_PIDM
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_ID
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_LAST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_FIRST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_MI
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_CHANGE_IND
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_NTYP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Person Identification/Name Repeating Table

Impact job : SPRIDEN_LAST_NAME SPRIDEN_LAST_NAME

Impact job : ln_spriden_first_name New Job

Impact job : ln_spriden_last_name New Job

Columns Comments for SPRIDEN_PIDM (# 1)

Source Code Comments

Internal identification number of the person.

Columns Comments for SPRIDEN_ID (# 2)

Source Code Comments

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

Columns Comments for SPRIDEN_LAST_NAME (# 3)

Source Code Comments

This field defines the last name of person.

Columns Comments for SPRIDEN_FIRST_NAME (# 4)

Source Code Comments

This field identifies the first name of person.

Columns Comments for SPRIDEN_MI (# 5)

Source Code Comments

This field identifies the middle name of person.

Columns Comments for SPRIDEN_CHANGE_IND (# 6)

Source Code Comments

This field identifies whether type of change made to the record was an ID number change or a name change. Valid values: I - ID change, N - name change.

Columns Comments for SPRIDEN_ENTITY_IND (# 7)

Source Code Comments

This field identifies whether record is person or non-person record. It does not display on the form. Valid values: P - person, C - non-person.

Columns Comments for SPRIDEN_ACTIVITY_DATE (# 8)

Source Code Comments

This field defines the most current date record is created or changed.

Columns Comments for SPRIDEN_USER (# 9)

Source Code Comments

USER: The ID for the user that most recently updated the record.

Columns Comments for SPRIDEN_ORIGIN (# 10)

Source Code Comments

ORIGIN: The name of the Banner Object that was used most recently to update the row in the spriden table.

Columns Comments for SPRIDEN_SEARCH_LAST_NAME (# 11)

Source Code Comments

The Last Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (# 12)

Source Code Comments

The First Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_MI (# 13)

Source Code Comments

The MI (Middle Initial) field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (# 14)

Source Code Comments

The Last Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (# 15)

Source Code Comments

The First Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_NTYP_CODE (# 16)

Source Code Comments

NAME TYPE CODE: The field is used to store the code that represents the name type associated with a person's name.

Columns Comments for SPRIDEN_CREATE_USER (# 17)

Source Code Comments

Record Create User: This field contains Banner User ID which created new record

Columns Comments for SPRIDEN_CREATE_DATE (# 18)

Source Code Comments

Record Create Date: This field contains date new record created

Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)

Source Code Comments

PII DOMAIN: PII Domain of the user who created the spriden row.

Table SSBSECT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SSBSECT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSBSECT_TERM_CODE	SSBSECT_TERM_CODE	VARCHAR2(6)	No	*	*
SSBSECT_CRN	SSBSECT_CRN	VARCHAR2(5)	No	*	*
SSBSECT_PTRM_CODE	SSBSECT_PTRM_CODE	VARCHAR2(3)	Yes		*
SSBSECT_SUBJ_CODE	SSBSECT_SUBJ_CODE	VARCHAR2(4)	No		*
SSBSECT_CRSE_NUMB	SSBSECT_CRSE_NUMB	VARCHAR2(5)	No		*
SSBSECT_SEQ_NUMB	SSBSECT_SEQ_NUMB	VARCHAR2(3)	No
SSBSECT_SSTS_CODE	SSBSECT_SSTS_CODE	VARCHAR2(1)	No		*
SSBSECT_SCHD_CODE	SSBSECT_SCHD_CODE	VARCHAR2(3)	No		*
SSBSECT_CAMP_CODE	SSBSECT_CAMP_CODE	VARCHAR2(3)	No		*
SSBSECT_CRSE_TITLE	SSBSECT_CRSE_TITLE	VARCHAR2(30)	Yes
SSBSECT_CREDIT_HRS	SSBSECT_CREDIT_HRS	NUMBER(7,3)	Yes
SSBSECT_BILL_HRS	SSBSECT_BILL_HRS	NUMBER(7,3)	Yes
SSBSECT_GMOD_CODE	SSBSECT_GMOD_CODE	VARCHAR2(1)	Yes		*
SSBSECT_SAPR_CODE	SSBSECT_SAPR_CODE	VARCHAR2(2)	Yes		*
SSBSECT_SESS_CODE	SSBSECT_SESS_CODE	VARCHAR2(1)	Yes		*
SSBSECT_LINK_IDENT	SSBSECT_LINK_IDENT	VARCHAR2(2)	Yes
SSBSECT_PRNT_IND	SSBSECT_PRNT_IND	VARCHAR2(1)	Yes
SSBSECT_GRADABLE_IND	SSBSECT_GRADABLE_IND	VARCHAR2(1)	Yes
SSBSECT_TUIW_IND	SSBSECT_TUIW_IND	VARCHAR2(1)	Yes
SSBSECT_REG_ONEUP	SSBSECT_REG_ONEUP	NUMBER(4,0)	No
SSBSECT_PRIOR_ENRL	SSBSECT_PRIOR_ENRL	NUMBER(4,0)	No
SSBSECT_PROJ_ENRL	SSBSECT_PROJ_ENRL	NUMBER(4,0)	No
SSBSECT_MAX_ENRL	SSBSECT_MAX_ENRL	NUMBER(4,0)	No
SSBSECT_ENRL	SSBSECT_ENRL	NUMBER(4,0)	No
SSBSECT_SEATS_AVAIL	SSBSECT_SEATS_AVAIL	NUMBER(4,0)	No
SSBSECT_TOT_CREDIT_HRS	SSBSECT_TOT_CREDIT_HRS	NUMBER(9,3)	Yes
SSBSECT_CENSUS_ENRL	SSBSECT_CENSUS_ENRL	NUMBER(4,0)	Yes
SSBSECT_CENSUS_ENRL_DATE	SSBSECT_CENSUS_ENRL_DATE	DATE	No
SSBSECT_ACTIVITY_DATE	SSBSECT_ACTIVITY_DATE	DATE	No
SSBSECT_PTRM_START_DATE	SSBSECT_PTRM_START_DATE	DATE	Yes
SSBSECT_PTRM_END_DATE	SSBSECT_PTRM_END_DATE	DATE	Yes
SSBSECT_PTRM_WEEKS	SSBSECT_PTRM_WEEKS	NUMBER(3,0)	Yes
SSBSECT_RESERVED_IND	SSBSECT_RESERVED_IND	VARCHAR2(1)	Yes
SSBSECT_WAIT_CAPACITY	SSBSECT_WAIT_CAPACITY	NUMBER(4,0)	Yes
SSBSECT_WAIT_COUNT	SSBSECT_WAIT_COUNT	NUMBER(4,0)	Yes
SSBSECT_WAIT_AVAIL	SSBSECT_WAIT_AVAIL	NUMBER(4,0)	Yes
SSBSECT_LEC_HR	SSBSECT_LEC_HR	NUMBER(9,3)	Yes
SSBSECT_LAB_HR	SSBSECT_LAB_HR	NUMBER(9,3)	Yes
SSBSECT_OTH_HR	SSBSECT_OTH_HR	NUMBER(9,3)	Yes
SSBSECT_CONT_HR	SSBSECT_CONT_HR	NUMBER(9,3)	Yes
SSBSECT_ACCT_CODE	SSBSECT_ACCT_CODE	VARCHAR2(2)	Yes		*
SSBSECT_ACCL_CODE	SSBSECT_ACCL_CODE	VARCHAR2(2)	Yes		*
SSBSECT_CENSUS_2_DATE	SSBSECT_CENSUS_2_DATE	DATE	Yes
SSBSECT_ENRL_CUT_OFF_DATE	SSBSECT_ENRL_CUT_OFF_DATE	DATE	Yes
SSBSECT_ACAD_CUT_OFF_DATE	SSBSECT_ACAD_CUT_OFF_DATE	DATE	Yes
SSBSECT_DROP_CUT_OFF_DATE	SSBSECT_DROP_CUT_OFF_DATE	DATE	Yes
SSBSECT_CENSUS_2_ENRL	SSBSECT_CENSUS_2_ENRL	NUMBER(4,0)	Yes
SSBSECT_VOICE_AVAIL	SSBSECT_VOICE_AVAIL	VARCHAR2(1)	No
SSBSECT_CAPP_PREREQ_TEST_IND	SSBSECT_CAPP_PREREQ_TEST_IND	VARCHAR2(1)	No
SSBSECT_GSCH_NAME	SSBSECT_GSCH_NAME	VARCHAR2(10)	Yes
SSBSECT_BEST_OF_COMP	SSBSECT_BEST_OF_COMP	NUMBER(3,0)	Yes
SSBSECT_SUBSET_OF_COMP	SSBSECT_SUBSET_OF_COMP	NUMBER(3,0)	Yes
SSBSECT_INSM_CODE	SSBSECT_INSM_CODE	VARCHAR2(5)	Yes		*
SSBSECT_REG_FROM_DATE	SSBSECT_REG_FROM_DATE	DATE	Yes
SSBSECT_REG_TO_DATE	SSBSECT_REG_TO_DATE	DATE	Yes
SSBSECT_LEARNER_REGSTART_FDATE	SSBSECT_LEARNER_REGSTART_FDATE	DATE	Yes
SSBSECT_LEARNER_REGSTART_TDATE	SSBSECT_LEARNER_REGSTART_TDATE	DATE	Yes
SSBSECT_DUNT_CODE	SSBSECT_DUNT_CODE	VARCHAR2(4)	Yes		*
SSBSECT_NUMBER_OF_UNITS	SSBSECT_NUMBER_OF_UNITS	NUMBER(7,2)	Yes
SSBSECT_NUMBER_OF_EXTENSIONS	SSBSECT_NUMBER_OF_EXTENSIONS	NUMBER(3,0)	No
SSBSECT_DATA_ORIGIN	SSBSECT_DATA_ORIGIN	VARCHAR2(30)	Yes
SSBSECT_USER_ID	SSBSECT_USER_ID	VARCHAR2(30)	Yes
SSBSECT_INTG_CDE		VARCHAR2(5)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSBSECT_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SSBSECT_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SSBSECT_ACCL_CODE	STVACCL_CODE	STVACCL
SSBSECT_ACCT_CODE	STVACCT_CODE	STVACCT
SSBSECT_CAMP_CODE	STVCAMP_CODE	STVCAMP
SSBSECT_GMOD_CODE	STVGMOD_CODE	STVGMOD
SSBSECT_PTRM_CODE	STVPTRM_CODE	STVPTRM
SSBSECT_SCHD_CODE	STVSCHD_CODE	STVSCHD
SSBSECT_SESS_CODE	STVSESS_CODE	STVSESS
SSBSECT_SSTS_CODE	STVSSTS_CODE	STVSSTS
SSBSECT_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SSBSECT_TERM_CODE	STVTERM_CODE	STVTERM
SSBSECT_SAPR_CODE	STVSAPR_CODE	STVSAPR
SSBSECT_INTG_CDE	GORINTG_INTEGRATION_CDE	GORINTG
SSBSECT_DUNT_CODE	GTVDUNT_CODE	GTVDUNT
SSBSECT_INSM_CODE	GTVINSM_CODE	GTVINSM
SSBSECT_CRN	RORSECT_CRN	RORSECT
SSBSECT_TERM_CODE	SFTREGS_TERM_CODE	SFTREGS
SSBSECT_CRN	SFTREGS_CRN	SFTREGS

Index

Index Name	Index Type	Column Name
PK_SSBSECT	Unique	SSBSECT_TERM_CODE
PK_SSBSECT	Unique	SSBSECT_CRN
SSBSECT_DATE_INDEX		SSBSECT_REG_FROM_DATE
SSBSECT_DATE_INDEX		SSBSECT_REG_TO_DATE
SSBSECT_DATE_INDEX		SSBSECT_TERM_CODE
SSBSECT_GSCH_INDEX		SSBSECT_GSCH_NAME
SSBSECT_INDEX_SUBJ	Unique	SSBSECT_SUBJ_CODE
SSBSECT_INDEX_SUBJ	Unique	SSBSECT_CRSE_NUMB
SSBSECT_INDEX_SUBJ	Unique	SSBSECT_TERM_CODE
SSBSECT_INDEX_SUBJ	Unique	SSBSECT_CRN
SSBSECT_PTRM_DATE_INDEX		SSBSECT_PTRM_START_DATE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Section General Information Base Table

Columns Comments for SSBSECT_TERM_CODE (# 1)

Source Code Comments

This field is not displayed on the form (page 0). It defines the Term code for the course section information. It is derived from the Key Block Term.

Columns Comments for SSBSECT_CRN (# 2)

Source Code Comments

This field is not displayed on the form (page 0). It will display the Course Reference Number (CRN) assigned to this course section when it was initially added.

Columns Comments for SSBSECT_PTRM_CODE (# 3)

Source Code Comments

This field is used to specify the part-of-term in which the section is offered. The value entered here must be valid as defined for the term on the Term Control Form - SOATERM. The default is "1".

Columns Comments for SSBSECT_SUBJ_CODE (# 4)

Source Code Comments

This field is required in order to add a section. In addition, the combina- tion of Subject, Course Number and Key Block Term must identify a valid course version as maintained in the Catalog Module.

Columns Comments for SSBSECT_CRSE_NUMB (# 5)

Source Code Comments

This field, the Key Block Term and Subject must identify a valid course ver- sion from the Catalog Module. If you try to schedule a section for a term restricted on the Schedule Restrictions Form - SCARRES,
an error occurs.

Columns Comments for SSBSECT_SEQ_NUMB (# 6)

Source Code Comments

This field identifies the section number of a course. A Section number can only be used once to identify a Subject/Course Number combination in a term, however, multiple sections of a course can share a 0 se
ction number.

Columns Comments for SSBSECT_SSTS_CODE (# 7)

Source Code Comments

This field maintains the status of a section. The "Allow Registration" switch on the Section Status Validation Form - STVSSTS determines whether the status entered will prevent or allow registration for thi
s section.

Columns Comments for SSBSECT_SCHD_CODE (# 8)

Source Code Comments

This field identifies the instructional type of the section being scheduled. It is a required field on an add. Use the LIST FIELD VALUES key to display the Schedule Type Validation Form - STVSCHD.

Columns Comments for SSBSECT_CAMP_CODE (# 9)

Source Code Comments

This field defines the campus on which the section is scheduled. If you attempt to schedule a course for a campus which is restricted on the Course Schedule Restrictions Form - SCASRES, an error will occur.

Columns Comments for SSBSECT_CRSE_TITLE (# 10)

Source Code Comments

This field will display the title of the course as defined on the Basic Course Information Form - SCACRSE.

Columns Comments for SSBSECT_CREDIT_HRS (# 11)

Source Code Comments

This field can be used to restrict a section to a single credit hr. value when the course was defined with variable credit hrs. on the Basic Course Info. Form - SCACRSE. This value must fall between the
variable values.

Columns Comments for SSBSECT_BILL_HRS (# 12)

Source Code Comments

This field can be used to restrict a section to a single billing hr. value when the course was defined with variable billing hrs. on the Basic Course Info. Form - SCACRSE. This value must fall between the
variable values.

Columns Comments for SSBSECT_GMOD_CODE (# 13)

Source Code Comments

This field can be used to specify one grading mode for this section from the grading mode(s) defined for the course on the Basic Course Information Form - SCACRSE. This field is optional.

Columns Comments for SSBSECT_SAPR_CODE (# 14)

Source Code Comments

This field can be used to specify the type of special approval a student must have to register. The Special Approval Severity switch on the Term Control Form - SOATERM, determines how this is checked at reg
istration.

Columns Comments for SSBSECT_SESS_CODE (# 15)

Source Code Comments

This field can be used to identify the session in which the section is scheduled. This is an optional field. Use the LIST FIELD VALUES key to display the Session Code Validation Form - STVSESS.

Columns Comments for SSBSECT_LINK_IDENT (# 16)

Source Code Comments

This field can be used to link other sections of the same course which must be taken concurrently. Enter a code in this field, then enter same code in Link connector field for linked section on Schedule De
tail Form - SSADETL.

Columns Comments for SSBSECT_PRNT_IND (# 17)

Source Code Comments

This field is used to specify whether the section should be printed in the Schedule Report - SSRSECT. "Y" - Yes, print section is the default value.

Columns Comments for SSBSECT_GRADABLE_IND (# 18)

Source Code Comments

This field is used to specify whether or not the section is gradable. It is a required field and "Y" - Yes, Gradable, is the default value.

Columns Comments for SSBSECT_TUIW_IND (# 19)

Source Code Comments

This field can be used to specify that this section be exempt from the assessment of tuition and fees as defined on the Registration Fees Process Control Form - SFARGFE (See Field Usage Notes).

Columns Comments for SSBSECT_REG_ONEUP (# 20)

Source Code Comments

This field is not displayed on the form (page 0). It displays the count associated with the last student registered for the course section.

Columns Comments for SSBSECT_PRIOR_ENRL (# 21)

Source Code Comments

This field is system maintained. When the Section Roll Process - SSRROLL, is used to create section entries based on a previous term"s sections, the Prior enrollment field is set to the enrollment from the
prior term.

Columns Comments for SSBSECT_PROJ_ENRL (# 22)

Source Code Comments

This field is used to record the anticipated enrollment in the section for the term. It is an optional field which defaults to "0" when a section is added, and it controls no system processing.

Columns Comments for SSBSECT_MAX_ENRL (# 23)

Source Code Comments

This field is used to set the maximum enrollment for a section. When the Capacity severity switch is set to "W" or "F" on the Term Control Form - SOATERM, the system issues warnings when enrollment exceeds t
his number.

Columns Comments for SSBSECT_ENRL (# 24)

Source Code Comments

This field is system maintained. It displays a running total of enrollments in the section which have a course status with a "Count in Enroll" flag of "Y" on the Registration Status Code Validation Form - STVRST
S.

Columns Comments for SSBSECT_SEATS_AVAIL (# 25)

Source Code Comments

This field is system maintained. It will display a running total of remain- ing avaialable seats in the section by subtracting the Actual enrollment field from the Maximum enrollment field defined for thi
s section.

Columns Comments for SSBSECT_TOT_CREDIT_HRS (# 26)

Source Code Comments

This field is system maintained. It will display a running total of all enrolled credit hours in the section.

Columns Comments for SSBSECT_CENSUS_ENRL (# 27)

Source Code Comments

This field is system maintained. It will display the running total of students registered for the section prior to the census date defined for the part of term.

Columns Comments for SSBSECT_CENSUS_ENRL_DATE (# 28)

Source Code Comments

This field is defined in the Census field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Secti
on Block of this form.

Columns Comments for SSBSECT_ACTIVITY_DATE (# 29)

Source Code Comments

This field specifies the most current date record was created or updated.

Columns Comments for SSBSECT_PTRM_START_DATE (# 30)

Source Code Comments

This field is defined in the Start field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section
Block of this form.

Columns Comments for SSBSECT_PTRM_END_DATE (# 31)

Source Code Comments

This field is defined in the End field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section Blo
ck of this form.

Columns Comments for SSBSECT_PTRM_WEEKS (# 32)

Source Code Comments

This field is defined in the "Wks" field in the Base Part of Term Block on the Term Control Form - SOATERM, and will default to this field based on the Key Block Term and Part/Term field in the Section Bloc
k of this form.

Columns Comments for SSBSECT_RESERVED_IND (# 33)

Source Code Comments

This field indicates whether reserved seats are defined for the section

Columns Comments for SSBSECT_WAIT_CAPACITY (# 34)

Source Code Comments

This field is used to set the maximum waitlist enrollment for a section

Columns Comments for SSBSECT_WAIT_COUNT (# 35)

Source Code Comments

This field is system maintained. It displays a running total of enrollments in the section which have course status with a waitlist flag set to Y on the Registration Status Code Validation Form - STVRSTS

Columns Comments for SSBSECT_WAIT_AVAIL (# 36)

Source Code Comments

This field is system maintained. It displays a running total of remaining available waitlist seats by subtracting the waitlist actual enrollment from the maximum waitlist enrollment for the section

Columns Comments for SSBSECT_LEC_HR (# 37)

Source Code Comments

This field is used to specify the lecture hours specific to this section.

Columns Comments for SSBSECT_LAB_HR (# 38)

Source Code Comments

This field is used to specify the lab hours specific to this section.

Columns Comments for SSBSECT_OTH_HR (# 39)

Source Code Comments

This field is used to specify the other hours specific to this section. Other hours is defined by the institution.

Columns Comments for SSBSECT_CONT_HR (# 40)

Source Code Comments

This column contains the sum of low lecture, lab and others hours. Contact hours divided by 10 are the continuing education units for a continuing education section. This calculated value is stored in the cr
edit hour field

Columns Comments for SSBSECT_ACCT_CODE (# 41)

Source Code Comments

Accounting Method Code

Columns Comments for SSBSECT_ACCL_CODE (# 42)

Source Code Comments

This field can be used to specify the Academic Calendar Type associated with a section.

Columns Comments for SSBSECT_CENSUS_2_DATE (# 43)

Source Code Comments

The census two date for the term and academic calendar year

Columns Comments for SSBSECT_ENRL_CUT_OFF_DATE (# 44)

Source Code Comments

The last date on which students may enroll for the academic calendar type and registration status

Columns Comments for SSBSECT_ACAD_CUT_OFF_DATE (# 45)

Source Code Comments

The last date when student may process a course without it appearing on their academic history information

Columns Comments for SSBSECT_DROP_CUT_OFF_DATE (# 46)

Source Code Comments

The last date on which students may drop a course without assessing a penalty

Columns Comments for SSBSECT_CENSUS_2_ENRL (# 47)

Source Code Comments

The census two enrollment

Columns Comments for SSBSECT_VOICE_AVAIL (# 48)

Source Code Comments

Indicates whether a section is available to Web and Voice Response Telephone Registration. "N" denotes course is not available, "Y" denotes course is available.

Columns Comments for SSBSECT_CAPP_PREREQ_TEST_IND (# 49)

Source Code Comments

Indicates whether CAPP areas or existing prerequisite and test score restrictions are in effect for the section.

Columns Comments for SSBSECT_BEST_OF_COMP (# 51)

Source Code Comments

SECTION BEST OF COMPONENTS: This field indicates the number of child components to be used in subset best of calculations when calculating a section score.

Columns Comments for SSBSECT_SUBSET_OF_COMP (# 52)

Source Code Comments

SECTION SUBSET OF COMPONENTS: This field indicates the number of child components to be used in subset calculations when calculating a section score.

Columns Comments for SSBSECT_INSM_CODE (# 53)

Source Code Comments

Instructional Method Code. The instructional method code assigned to the section

Columns Comments for SSBSECT_REG_FROM_DATE (# 54)

Source Code Comments

Registration From Date. The first date that registration will be open to the learner for this section

Columns Comments for SSBSECT_REG_TO_DATE (# 55)

Source Code Comments

Registration To Date. The last date that registrations will be accepted for this section.

Columns Comments for SSBSECT_LEARNER_REGSTART_FDATE (# 56)

Source Code Comments

Learner Registration Start Date. When registering for the course, the first date that the learner can start taking the course

Columns Comments for SSBSECT_LEARNER_REGSTART_TDATE (# 57)

Source Code Comments

Learner Registration To Date. When registering for the course, the last date that the learner can start taking the course

Columns Comments for SSBSECT_DUNT_CODE (# 58)

Source Code Comments

Duration Unit Code. The duration unit code assigned to the section

Columns Comments for SSBSECT_NUMBER_OF_UNITS (# 59)

Source Code Comments

Duration Number of Units. The number of units the student will be given to complete the course.

Columns Comments for SSBSECT_NUMBER_OF_EXTENSIONS (# 60)

Source Code Comments

Number of Extensions. The maximum number of extensions permitted for this section.

Columns Comments for SSBSECT_DATA_ORIGIN (# 61)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for SSBSECT_USER_ID (# 62)

Source Code Comments

USER ID: User who inserted or last update the data

Columns Comments for SSBSECT_INTG_CDE (# 63)

Source Code Comments

INTEGRATION PARTNER SYSTEM CODE: Code defined on GORINTG that associates with the User Integration Code.

Table SSRMEET

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SSRMEET

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SSRMEET_TERM_CODE	SSRMEET_TERM_CODE	VARCHAR2(6)	No	*
SSRMEET_CRN	SSRMEET_CRN	VARCHAR2(5)	No	*
SSRMEET_DAYS_CODE	SSRMEET_DAYS_CODE	VARCHAR2(1)	Yes
SSRMEET_DAY_NUMBER	SSRMEET_DAY_NUMBER	NUMBER(1,0)	Yes
SSRMEET_BEGIN_TIME	SSRMEET_BEGIN_TIME	VARCHAR2(4)	Yes
SSRMEET_END_TIME	SSRMEET_END_TIME	VARCHAR2(4)	Yes
SSRMEET_BLDG_CODE	SSRMEET_BLDG_CODE	VARCHAR2(6)	Yes	*
SSRMEET_ROOM_CODE	SSRMEET_ROOM_CODE	VARCHAR2(10)	Yes
SSRMEET_ACTIVITY_DATE	SSRMEET_ACTIVITY_DATE	DATE	No
SSRMEET_START_DATE	SSRMEET_START_DATE	DATE	No
SSRMEET_END_DATE	SSRMEET_END_DATE	DATE	No
SSRMEET_CATAGORY	SSRMEET_CATAGORY	VARCHAR2(2)	Yes	*
SSRMEET_SUN_DAY	SSRMEET_SUN_DAY	VARCHAR2(1)	Yes	*
SSRMEET_MON_DAY	SSRMEET_MON_DAY	VARCHAR2(1)	Yes	*
SSRMEET_TUE_DAY	SSRMEET_TUE_DAY	VARCHAR2(1)	Yes	*
SSRMEET_WED_DAY	SSRMEET_WED_DAY	VARCHAR2(1)	Yes	*
SSRMEET_THU_DAY	SSRMEET_THU_DAY	VARCHAR2(1)	Yes	*
SSRMEET_FRI_DAY	SSRMEET_FRI_DAY	VARCHAR2(1)	Yes	*
SSRMEET_SAT_DAY	SSRMEET_SAT_DAY	VARCHAR2(1)	Yes	*
SSRMEET_SCHD_CODE	SSRMEET_SCHD_CODE	VARCHAR2(3)	Yes	*
SSRMEET_OVER_RIDE	SSRMEET_OVER_RIDE	VARCHAR2(1)	Yes
SSRMEET_CREDIT_HR_SESS	SSRMEET_CREDIT_HR_SESS	NUMBER(7,3)	Yes
SSRMEET_MEET_NO	SSRMEET_MEET_NO	NUMBER(4,0)	Yes
SSRMEET_HRS_WEEK	SSRMEET_HRS_WEEK	NUMBER(5,2)	Yes
SSRMEET_FUNC_CODE	SSRMEET_FUNC_CODE	VARCHAR2(12)	Yes	*
SSRMEET_COMT_CODE	SSRMEET_COMT_CODE	VARCHAR2(6)	Yes	*
SSRMEET_SCHS_CODE	SSRMEET_SCHS_CODE	VARCHAR2(3)	Yes	*
SSRMEET_MTYP_CODE	SSRMEET_MTYP_CODE	VARCHAR2(4)	Yes	*
SSRMEET_DATA_ORIGIN	SSRMEET_DATA_ORIGIN	VARCHAR2(30)	Yes
SSRMEET_USER_ID	SSRMEET_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSRMEET_COMT_CODE	STVCOMT_CODE	STVCOMT
SSRMEET_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN
SSRMEET_CRN	SIRASGN_CRN	SIRASGN
SSRMEET_CATAGORY	SIRASGN_CATEGORY	SIRASGN
SSRMEET_FUNC_CODE	GEBFUNC_FUNC_CODE	GEBFUNC
SSRMEET_MON_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_TUE_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_WED_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_THU_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_FRI_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_SAT_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_SUN_DAY	SSREXCL_DAY	SSREXCL
SSRMEET_SCHD_CODE	SCRSCHD_SCHD_CODE	SCRSCHD
SSRMEET_CRN	SSRXLST_CRN	SSRXLST
SSRMEET_TERM_CODE	SSRXLST_TERM_CODE	SSRXLST
SSRMEET_BLDG_CODE	SLBBLDG_BLDG_CODE	SLBBLDG
SSRMEET_SCHS_CODE	GTVSCHS_CODE	GTVSCHS
SSRMEET_MTYP_CODE	GTVMTYP_CODE	GTVMTYP
SSRMEET_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SSRMEET_CRN	SSBSECT_CRN	SSBSECT
SSRMEET_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SSRMEET_CRN	SFRSTCR_CRN	SFRSTCR
SSRMEET_TERM_CODE	SFTREGS_TERM_CODE	SFTREGS
SSRMEET_CRN	SFTREGS_CRN	SFTREGS

Index

Index Name	Index Type	Column Name
SSRMEET_KEY_INDEX		SSRMEET_TERM_CODE
SSRMEET_KEY_INDEX		SSRMEET_CRN
SSRMEET_KEY_INDEX		SSRMEET_BEGIN_TIME
SSRMEET_KEY_INDEX		SSRMEET_MON_DAY
SSRMEET_KEY_INDEX		SSRMEET_TUE_DAY
SSRMEET_KEY_INDEX		SSRMEET_WED_DAY
SSRMEET_KEY_INDEX		SSRMEET_THU_DAY
SSRMEET_KEY_INDEX		SSRMEET_FRI_DAY
SSRMEET_KEY_INDEX		SSRMEET_SAT_DAY
SSRMEET_KEY_INDEX		SSRMEET_SUN_DAY
SSRMEET_KEY_INDEX2		SSRMEET_BLDG_CODE
SSRMEET_KEY_INDEX2		SSRMEET_ROOM_CODE
SSRMEET_KEY_INDEX2		SSRMEET_BEGIN_TIME
SSRMEET_KEY_INDEX2		SSRMEET_END_TIME
SSRMEET_KEY_INDEX2		SSRMEET_MON_DAY
SSRMEET_KEY_INDEX2		SSRMEET_TUE_DAY
SSRMEET_KEY_INDEX2		SSRMEET_WED_DAY
SSRMEET_KEY_INDEX2		SSRMEET_THU_DAY
SSRMEET_KEY_INDEX2		SSRMEET_FRI_DAY
SSRMEET_KEY_INDEX2		SSRMEET_SAT_DAY
SSRMEET_KEY_INDEX2		SSRMEET_SUN_DAY
SSRMEET_KEY_INDEX2		SSRMEET_START_DATE
SSRMEET_KEY_INDEX2		SSRMEET_END_DATE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Section Meeting Times Repeating Table

Columns Comments for SSRMEET_TERM_CODE (# 1)

Source Code Comments

This field is not displayed on the form (page 0). It defines the term for which you are creating meeting times for the course section. It is based on the Key Block Term.

Columns Comments for SSRMEET_CRN (# 2)

Source Code Comments

This field is not displayed on the form (page 0). It defines the Course Reference Number for the course section for which you are creating meeting times

Columns Comments for SSRMEET_DAYS_CODE (# 3)

Source Code Comments

This field defines the Day code for which the Key Block section will be scheduled. It is a required field to enter a meeting time record.

Columns Comments for SSRMEET_DAY_NUMBER (# 4)

Source Code Comments

This field is not displayed on the form (page 0). It defines the day number as defined on the STVDAYS Validation Form

Columns Comments for SSRMEET_BEGIN_TIME (# 5)

Source Code Comments

This field defines the Begin Time of the course section being scheduled. It is a required field and is in the format HHMM using military times. The SSRSECT (Schedule of Classes) converts this time to standard times.

Columns Comments for SSRMEET_END_TIME (# 6)

Source Code Comments

This field defines the End Time of the course section being scheduled. It is a required field and is in the format HHMM using military times. The SSRSECT (Schedule of Classes) converts this time to standard times.

Columns Comments for SSRMEET_BLDG_CODE (# 7)

Source Code Comments

This field defines the Building where the course section will be scheduled. It is not required when scheduling course section meeting times. It is required when scheduling course section meeting rooms.

Columns Comments for SSRMEET_ROOM_CODE (# 8)

Source Code Comments

This field defines the Room where the course section will be scheduled. It is not required when scheduling course section meeting times. It is required when scheduling a course section meeting building.

Columns Comments for SSRMEET_ACTIVITY_DATE (# 9)

Source Code Comments

This field specifies the most current date record was created or updated.

Columns Comments for SSRMEET_START_DATE (# 10)

Source Code Comments

Section Meeting Start Date.

Columns Comments for SSRMEET_END_DATE (# 11)

Source Code Comments

Section End Date.

Columns Comments for SSRMEET_CATAGORY (# 12)

Source Code Comments

Section Indicator.

Columns Comments for SSRMEET_SUN_DAY (# 13)

Source Code Comments

Section Meeting Time Sunday Indicator.

Columns Comments for SSRMEET_MON_DAY (# 14)

Source Code Comments

Section Meeting Time Monday Indicator.

Columns Comments for SSRMEET_TUE_DAY (# 15)

Source Code Comments

Section Meeting Time Tuesday Indicator.

Columns Comments for SSRMEET_WED_DAY (# 16)

Source Code Comments

Section Meeting Time Wednesday Indicator.

Columns Comments for SSRMEET_THU_DAY (# 17)

Source Code Comments

Section Meeting Time Thrusday Indicator.

Columns Comments for SSRMEET_FRI_DAY (# 18)

Source Code Comments

Section Meeting Time Friday Indicator.

Columns Comments for SSRMEET_SAT_DAY (# 19)

Source Code Comments

Section Meeting Time Saturday Indicator.

Columns Comments for SSRMEET_SCHD_CODE (# 20)

Source Code Comments

Section Schedule Type.

Columns Comments for SSRMEET_OVER_RIDE (# 21)

Source Code Comments

Section Time Conflict Override Indicator.

Columns Comments for SSRMEET_CREDIT_HR_SESS (# 22)

Source Code Comments

The session credit hours

Columns Comments for SSRMEET_MEET_NO (# 23)

Source Code Comments

Total Section Meeting Number which is system generated.

Columns Comments for SSRMEET_HRS_WEEK (# 24)

Source Code Comments

Section Metting Hours per Week.

Columns Comments for SSRMEET_FUNC_CODE (# 25)

Source Code Comments

Function code assigned to an event

Columns Comments for SSRMEET_COMT_CODE (# 26)

Source Code Comments

Committee/Service Type code.

Columns Comments for SSRMEET_SCHS_CODE (# 27)

Source Code Comments

Schedule Status Code for use with Scheduling Tool Interface .

Columns Comments for SSRMEET_MTYP_CODE (# 28)

Source Code Comments

Meeting Type Code. The meeting type code assigned to this meeting time of the section

Columns Comments for SSRMEET_DATA_ORIGIN (# 29)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SSRMEET_USER_ID (# 30)

Source Code Comments

USER ID: User who inserted or last update the data

Table SSRXLST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SSRXLST

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SSRXLST_TERM_CODE	SSRXLST_TERM_CODE	VARCHAR2(6)	No	*	*
SSRXLST_XLST_GROUP	SSRXLST_XLST_GROUP	VARCHAR2(2)	No	*	*
SSRXLST_CRN	SSRXLST_CRN	VARCHAR2(5)	No	*	*
SSRXLST_ACTIVITY_DATE	SSRXLST_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SSRXLST_TERM_CODE	STVTERM_CODE	STVTERM
SSRXLST_TERM_CODE	SSBXLST_TERM_CODE	SSBXLST
SSRXLST_XLST_GROUP	SSBXLST_XLST_GROUP	SSBXLST
SSRXLST_TERM_CODE	SIRASGN_TERM_CODE	SIRASGN
SSRXLST_CRN	SIRASGN_CRN	SIRASGN
SSRXLST_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SSRXLST_CRN	SFRSTCR_CRN	SFRSTCR
SSRXLST_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SSRXLST_CRN	SSBSECT_CRN	SSBSECT
SSRXLST_TERM_CODE	SFTREGS_TERM_CODE	SFTREGS
SSRXLST_CRN	SFTREGS_CRN	SFTREGS

Index

Index Name	Index Type	Column Name
PK_SSRXLST	Unique	SSRXLST_TERM_CODE
PK_SSRXLST	Unique	SSRXLST_XLST_GROUP
PK_SSRXLST	Unique	SSRXLST_CRN

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Cross List Section Repeating Table

Columns Comments for SSRXLST_TERM_CODE (# 1)

Source Code Comments

Cross List Section Term.

Columns Comments for SSRXLST_XLST_GROUP (# 2)

Source Code Comments

Cross List Group Identifier Number.

Columns Comments for SSRXLST_CRN (# 3)

Source Code Comments

Corss List Section CRN.

Columns Comments for SSRXLST_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table STVASTY

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVASTY

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVASTY_CODE	STVASTY_CODE	VARCHAR2(4)	No	*
STVASTY_DESC	STVASTY_DESC	VARCHAR2(30)	No
STVASTY_ACTIVITY_DATE	STVASTY_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVASTY	Unique	STVASTY_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Assignment Type Validation Table

Columns Comments for STVASTY_CODE (# 1)

Source Code Comments

Assignment Type Code

Columns Comments for STVASTY_DESC (# 2)

Source Code Comments

Description of Code

Columns Comments for STVASTY_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Table STVCNTR

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVCNTR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVCNTR_CODE	STVCNTR_CODE	VARCHAR2(6)	No	*
STVCNTR_DESC	STVCNTR_DESC	VARCHAR2(30)	No
STVCNTR_ACTIVITY_DATE	STVCNTR_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVCNTR	Unique	STVCNTR_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Contract Rules Code Validation Table

Columns Comments for STVCNTR_CODE (# 1)

Source Code Comments

Contract Rules Code

Columns Comments for STVCNTR_DESC (# 2)

Source Code Comments

Description of Contract Rules Code

Columns Comments for STVCNTR_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table STVCOLL

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVCOLL

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVCOLL_CODE	STVCOLL_CODE	VARCHAR2(2)	No	*
STVCOLL_DESC	STVCOLL_DESC	VARCHAR2(30)	No
STVCOLL_ADDR_STREET_LINE1	STVCOLL_ADDR_STREET_LINE1	VARCHAR2(30)	Yes
STVCOLL_ADDR_STREET_LINE2	STVCOLL_ADDR_STREET_LINE2	VARCHAR2(30)	Yes
STVCOLL_ADDR_STREET_LINE3	STVCOLL_ADDR_STREET_LINE3	VARCHAR2(30)	Yes
STVCOLL_ADDR_CITY	STVCOLL_ADDR_CITY	VARCHAR2(20)	Yes
STVCOLL_ADDR_STATE	STVCOLL_ADDR_STATE	VARCHAR2(2)	Yes
STVCOLL_ADDR_COUNTRY	STVCOLL_ADDR_COUNTRY	VARCHAR2(28)	Yes
STVCOLL_ADDR_ZIP_CODE	STVCOLL_ADDR_ZIP_CODE	VARCHAR2(10)	Yes
STVCOLL_ACTIVITY_DATE	STVCOLL_ACTIVITY_DATE	DATE	Yes
STVCOLL_SYSTEM_REQ_IND	STVCOLL_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVCOLL_VR_MSG_NO	STVCOLL_VR_MSG_NO	NUMBER(6,0)	Yes
STVCOLL_STATSCAN_CDE3	STVCOLL_STATSCAN_CDE3	VARCHAR2(6)	Yes
STVCOLL_DICD_CODE	STVCOLL_DICD_CODE	VARCHAR2(3)	Yes

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVCOLL	Unique	STVCOLL_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:38:000

Source Code Comments

College Validation Table

Columns Comments for STVCOLL_CODE (# 1)

Source Code Comments

This field identifies the college code referenced in the Catalog, Class Schedule, Recruiting, Admissions, General Student, Registration, Academic History and Degree Audit Modules. Reqd value: 00 - No College Designated.

Columns Comments for STVCOLL_DESC (# 2)

Source Code Comments

This field specifies the college or school (i.e. **Banner"s** highest administrative unit) associated with the college code.

Columns Comments for STVCOLL_ADDR_STREET_LINE1 (# 3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE2 (# 4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STREET_LINE3 (# 5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_CITY (# 6)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_STATE (# 7)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_COUNTRY (# 8)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ADDR_ZIP_CODE (# 9)

Source Code Comments

This field is not currently in use.

Columns Comments for STVCOLL_ACTIVITY_DATE (# 10)

Source Code Comments

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

Columns Comments for STVCOLL_SYSTEM_REQ_IND (# 11)

Source Code Comments

System Required Indicator

Columns Comments for STVCOLL_VR_MSG_NO (# 12)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the college code.

Columns Comments for STVCOLL_STATSCAN_CDE3 (# 13)

Source Code Comments

Statistics Canadian reporting institution specific code.

Columns Comments for STVCOLL_DICD_CODE (# 14)

Source Code Comments

MIS DISTRICT/DIVISION CODE: This field indicates equivalent district or division associated with an Institution.

Table STVDEPT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVDEPT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVDEPT_CODE	STVDEPT_CODE	VARCHAR2(4)	No	*
STVDEPT_DESC	STVDEPT_DESC	VARCHAR2(30)	No
STVDEPT_ACTIVITY_DATE	STVDEPT_ACTIVITY_DATE	DATE	No
STVDEPT_SYSTEM_REQ_IND	STVDEPT_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVDEPT_VR_MSG_NO	STVDEPT_VR_MSG_NO	NUMBER(6,0)	Yes

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVDEPT	Unique	STVDEPT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:37:000

Source Code Comments

Department Validation Table

Columns Comments for STVDEPT_CODE (# 1)

Source Code Comments

This field identifies the department code referenced in the Catalog, Recruiting, Admissions, and Acad. Hist. Modules. Required value: 0000 - Dept. Not Declared.

Columns Comments for STVDEPT_DESC (# 2)

Source Code Comments

This field specifies the department associated with the department code.

Columns Comments for STVDEPT_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for STVDEPT_SYSTEM_REQ_IND (# 4)

Source Code Comments

System Required Indicator

Columns Comments for STVDEPT_VR_MSG_NO (# 5)

Source Code Comments

The Voice Response message number assigned to the recorded message that describes the department code.

Table STVFATT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVFATT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVFATT_CODE	STVFATT_CODE	VARCHAR2(4)	No	*
STVFATT_DESC	STVFATT_DESC	VARCHAR2(30)	No
STVFATT_ACTIVITY_DATE	STVFATT_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVFATT	Unique	STVFATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Faculty Member Attributes Code Validation Table

Columns Comments for STVFATT_CODE (# 1)

Source Code Comments

Faculty member attribute code

Columns Comments for STVFATT_DESC (# 2)

Source Code Comments

Description of faculty member attribute code

Columns Comments for STVFATT_ACTIVITY_DATE (# 3)

Source Code Comments

The activity date

Table STVFCNT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVFCNT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVFCNT_CODE	STVFCNT_CODE	VARCHAR2(2)	No	*
STVFCNT_DESC	STVFCNT_DESC	VARCHAR2(30)	No
STVFCNT_ACTIVITY_DATE	STVFCNT_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVFCNT	Unique	STVFCNT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Faculty Contract Code Validation Table

Columns Comments for STVFCNT_CODE (# 1)

Source Code Comments

Faculty member contract type code

Columns Comments for STVFCNT_DESC (# 2)

Source Code Comments

Description of faculty member contract type code

Columns Comments for STVFCNT_ACTIVITY_DATE (# 3)

Source Code Comments

The activity date

Table STVFCST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVFCST

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVFCST_CODE	STVFCST_CODE	VARCHAR2(2)	No	*
STVFCST_DESC	STVFCST_DESC	VARCHAR2(30)	No
STVFCST_ACTIVE_IND	STVFCST_ACTIVE_IND	VARCHAR2(1)	No
STVFCST_ACTIVITY_DATE	STVFCST_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVFCST	Unique	STVFCST_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Status Validation Table

Columns Comments for STVFCST_CODE (# 1)

Source Code Comments

Faculty member status code

Columns Comments for STVFCST_DESC (# 2)

Source Code Comments

Description of faculty member status code

Columns Comments for STVFCST_ACTIVE_IND (# 3)

Source Code Comments

Active indicator

Columns Comments for STVFCST_ACTIVITY_DATE (# 4)

Source Code Comments

The activity date

Table STVFCTG

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVFCTG

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVFCTG_CODE	STVFCTG_CODE	VARCHAR2(6)	No	*
STVFCTG_DESC	STVFCTG_DESC	VARCHAR2(30)	No
STVFCTG_ACTIVITY_DATE	STVFCTG_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVFCTG	Unique	STVFCTG_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Faculty Category Validation Table

Columns Comments for STVFCTG_CODE (# 1)

Source Code Comments

Faculty member category code

Columns Comments for STVFCTG_DESC (# 2)

Source Code Comments

Description of faculty member category code

Columns Comments for STVFCTG_ACTIVITY_DATE (# 3)

Source Code Comments

The activity date

Table STVFSTP

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVFSTP

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVFSTP_CODE	STVFSTP_CODE	VARCHAR2(4)	No	*
STVFSTP_DESC	STVFSTP_DESC	VARCHAR2(30)	No
STVFSTP_ACTIVITY_DATE	STVFSTP_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVFSTP	Unique	STVFSTP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Faculty Staff Type Validation Table

Columns Comments for STVFSTP_CODE (# 1)

Source Code Comments

Faculty member staff type code

Columns Comments for STVFSTP_DESC (# 2)

Source Code Comments

Description of faculty member staff type code

Columns Comments for STVFSTP_ACTIVITY_DATE (# 3)

Source Code Comments

The activity date

Table STVNIST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVNIST

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVNIST_CODE	STVNIST_CODE	VARCHAR2(4)	No	*
STVNIST_DESC	STVNIST_DESC	VARCHAR2(30)	No
STVNIST_MAX_WORKLOAD	STVNIST_MAX_WORKLOAD	NUMBER(9,3)	Yes
STVNIST_MIN_WORKLOAD	STVNIST_MIN_WORKLOAD	NUMBER(9,3)	Yes
STVNIST_ACTIVITY_DATE	STVNIST_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVNIST	Unique	STVNIST_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:41:000

Source Code Comments

Faculty Non-instructional Validation Table

Columns Comments for STVNIST_CODE (# 1)

Source Code Comments

Faculty member non-instructional code

Columns Comments for STVNIST_DESC (# 2)

Source Code Comments

Description of faculty member non-instructional code

Columns Comments for STVNIST_MAX_WORKLOAD (# 3)

Source Code Comments

The maximum workload for the non-instructional assignment

Columns Comments for STVNIST_MIN_WORKLOAD (# 4)

Source Code Comments

The minimum workload for the non-instructional assignment

Columns Comments for STVNIST_ACTIVITY_DATE (# 5)

Source Code Comments

The activity date

Table STVTELE

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVTELE

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVTELE_CODE	STVTELE_CODE	VARCHAR2(4)	No	*
STVTELE_DESC	STVTELE_DESC	VARCHAR2(30)	No
STVTELE_ACTIVITY_DATE	STVTELE_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVTELE	Unique	STVTELE_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Telephone Type Validation Table.

Columns Comments for STVTELE_CODE (# 1)

Source Code Comments

Telephone Type code.

Columns Comments for STVTELE_DESC (# 2)

Source Code Comments

Telephone Type Description.

Columns Comments for STVTELE_ACTIVITY_DATE (# 3)

Source Code Comments

Date of last change for telephone type record.

Table STVTOPS

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVTOPS

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVTOPS_CODE	STVTOPS_CODE	VARCHAR2(6)	No	*
STVTOPS_DESC	STVTOPS_DESC	VARCHAR2(30)	No
STVTOPS_ACTIVITY_DATE	STVTOPS_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVTOPS	Unique	STVTOPS_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Taxonomy of Program Validation Table

Columns Comments for STVTOPS_CODE (# 1)

Source Code Comments

Taxonomy of Program Code

Columns Comments for STVTOPS_DESC (# 2)

Source Code Comments

Description of Taxonomy of Program Code

Columns Comments for STVTOPS_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table STVWKLD

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVWKLD

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVWKLD_CODE	STVWKLD_CODE	VARCHAR2(6)	No	*
STVWKLD_DESC	STVWKLD_DESC	VARCHAR2(30)	No
STVWKLD_ACTIVITY_DATE	STVWKLD_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVWKLD	Unique	STVWKLD_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Workload Rules Code Validation Table

Columns Comments for STVWKLD_CODE (# 1)

Source Code Comments

Workload Rules Code

Columns Comments for STVWKLD_DESC (# 2)

Source Code Comments

Description of Workload Rules Code

Columns Comments for STVWKLD_ACTIVITY_DATE (# 3)

Source Code Comments

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

Link between SFRSTCR and SSBSECT

Join Information

Objects list
schema-view : S4B70.BANINST1.ROVSTCR schema-view : S4B70.BANINST1.SFVENRL schema-view : S4B70.BANINST1.SFVRHST schema-view : S4B70.BANINST1.SFVSTUM schema-view : S4B70.BANINST1.SFVSTMS

Link List

Link Type	Link	Project
Join	Link Between SFRSTCR and SSBSECT	SATURN

List of Real link

Link type	Between	And
Join	SFRSTCR	SSBSECT

Link between SPRIDEN and SFRSTCR

Join Information

Objects list
scope-cursor : S4B70.BANINST1.SHKEGRB.STUDENT_CUR_C

Link List

Link Type	Link	Project
Join	Link Between SPRIDEN and SFRSTCR	SATURN

List of Real link

Link type	Between	And
Join	SPRIDEN	SFRSTCR

Link between SSRMEET and SSBSECT

Join Information

Objects list

schema-view : S4B70.BANINST1.SFVTSEC
schema-view : S4B70.BANINST1.SFVSECM
forms-data-block-trigger : BANNER7_FORMS.SFQSECM.SFVSECM.CHECK_TIME
forms-module-procedure : BANNER7_FORMS.SIAASGN.GET_SESSION
schema-view : S4B70.BANINST1.SIVCALC
schema-view : S4B70.BANINST1.SIVSECM
schema-view : S4B70.BANINST1.SSVMEET
schema-view : S4B70.BANINST1.SIVCONT
forms-data-block-trigger : BANNER7_FORMS.SIALVAS.SIRLVAS.GET_SESS
forms-data-block-item-trigger : BANNER7_FORMS.SIALVAS.SIRLVAS.SIRLVAS_CRN.KEY_NXTFLD
forms-data-block-item-trigger : BANNER7_FORMS.SIALVAS.SIRLVAS.SIRLVAS_CRN."POST-CHANGE"
forms-module-procedure : BANNER7_FORMS_10G.SIAASGN.GET_SESSION
forms-data-block-trigger : BANNER7_FORMS_10G.SFQSECM.SFVSECM.CHECK_TIME
forms-data-block-trigger : BANNER7_FORMS_10G.SIALVAS.SIRLVAS.GET_SESS
forms-data-block-item-trigger : BANNER7_FORMS_10G.SIALVAS.SIRLVAS.SIRLVAS_CRN.KEY_NXTFLD
forms-data-block-item-trigger : BANNER7_FORMS_10G.SIALVAS.SIRLVAS.SIRLVAS_CRN."POST-CHANGE"

Link List

Link Type	Link	Project
Join	Link Between SSRMEET and SSBSECT	SATURN

List of Real link

Link type	Between	And
Join	SSRMEET	SSBSECT

Link between SSRXLST and SFRSTCR

Join Information

Objects list
schema-view : S4B70.BANINST1.SFVSTUM schema-view : S4B70.BANINST1.SFVSTMS

Link List

Link Type	Link	Project
Join	Link Between SSRXLST and SFRSTCR	SATURN

List of Real link

Link type	Between	And
Join	SSRXLST	SFRSTCR

Link between SSRMEET and SFRSTCR

Join Information

Objects list
schema-view : S4B70.BANINST1.SFVSTUM schema-view : S4B70.BANINST1.SFVSTMS

Link List

Link Type	Link	Project
Join	Link Between SSRMEET and SFRSTCR	SATURN

List of Real link

Link type	Between	And
Join	SSRMEET	SFRSTCR

Link between SIRASGN and SFRSTCR

Join Information

Objects list
schema-view : S4B70.BANINST1.SFVSTMS

Link List

Link Type	Link	Project
Join	Link Between SIRASGN and SFRSTCR	SATURN

List of Real link

Link type	Between	And
Join	SIRASGN	SFRSTCR

Link between SPRIDEN and SIRASGN

Join Information

Objects list
schema-view : S4B70.BANINST1.SFVSTMS forms-module-function : BANNER7_FORMS.SIAASGN.SIRASGN_COUNT_INST forms-data-block-trigger : BANNER7_FORMS.SSASECT.SSRMEET."KEY-DUP-ITEM" forms-module-function : BANNER7_FORMS_10G.SIAASGN.SIRASGN_COUNT_INST

Link List

Link Type	Link	Project
Join	Link Between SPRIDEN and SIRASGN	SATURN

List of Real link

Link type	Between	And
Join	SPRIDEN	SIRASGN

Link between SSRXLST and SSBSECT

Join Information

Objects list
schema-view : S4B70.BANINST1.SFVSECM schema-view : S4B70.BANINST1.SSVSECT schema-view : S4B70.BANINST1.SIVSECM forms-module-trigger : BANNER7_FORMS.SSASECT.VALIDATE_CRN

Link List

Link Type	Link	Project
Join	Link Between SSRXLST and SSBSECT	SATURN

List of Real link

Link type	Between	And
Join	SSRXLST	SSBSECT

Link between SIRICNT and SIBINST

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVINST

Link List

Link Type	Link	Project
Join	Link Between SIRICNT and SIBINST	SATURN

List of Real link

Link type	Between	And
Join	SIRICNT	SIBINST

Link between SPRIDEN and SIBINST

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVINST schema-view : S4B70.BANINST1.SIVFACQ forms-data-block-item-trigger : BANNER7_FORMS.SHANCRS.SHRNCRS.ADVR_ID.CHECK_ADVR forms-data-block-item-trigger : BANNER7_FORMS_10G.SHANCRS.SHRNCRS.ADVR_ID.CHECK_ADVR

Link List

Link Type	Link	Project
Join	Link Between SPRIDEN and SIBINST	SATURN

List of Real link

Link type	Between	And
Join	SPRIDEN	SIBINST

Link between SSRXLST and SIRASGN

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVASGN

Link List

Link Type	Link	Project
Join	Link Between SSRXLST and SIRASGN	SATURN

List of Real link

Link type	Between	And
Join	SSRXLST	SIRASGN

Link between SSRMEET and SIRASGN

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between SSRMEET and SIRASGN	SATURN

List of Real link

Link type	Between	And
Join	SSRMEET	SIRASGN

Link between SIBTERM and 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

List of Real link

Link type	Between	And
Join	SIBTERM	SIRASGN

Link between SIRASGN and 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

List of Real link

Link type	Between	And
Join	SIRASGN	SIRCOLR

Link between SSRMEET and SSRXLST

Join Information

Objects list
schema-view : S4B70.BANINST1.SSVMEET schema-view : S4B70.BANINST1.SSVXMTI

Link List

Link Type	Link	Project
Join	Link Between SSRMEET and SSRXLST	SATURN

List of Real link

Link type	Between	And
Join	SSRMEET	SSRXLST

Link between SIBCFTE and 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

List of Real link

Link type	Between	And
Join	SIBCFTE	SIRCOLR

Link between SIRFCNT and SIRASGN

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type	Link	Project
Join	Link Between SIRFCNT and SIRASGN	SATURN

List of Real link

Link type	Between	And
Join	SIRFCNT	SIRASGN

Link between SIRFCNT and SIRCOLR

Join Information

Objects list
schema-view : S4B70.BANINST1.SIVCONT

Link List

Link Type	Link	Project
Join	Link Between SIRFCNT and SIRCOLR	SATURN

List of Real link

Link type	Between	And
Join	SIRFCNT	SIRCOLR

Link between SIRNIST and 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

List of Real link

Link type	Between	And
Join	SIRNIST	SIRFCNT

Link between SIRCOLR and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRCOLR and STVFCNT (FK1_SIRCOLR_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRCOLR	SIRCOLR_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIBCFTE and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBCFTE and STVFCNT (FK1_SIBCFTE_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBCFTE	SIBCFTE_FCNT_CODE	STVFCNT_CODE	STVFCNT	(1,1)-(0,n)

Link between SIRLVAS and STVASTY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRLVAS and STVASTY (FK1_SIRLVAS_INV_STVASTY_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRLVAS	SIRLVAS_ASTY_CODE	STVASTY_CODE	STVASTY	(0,1)-(0,n)

Link between SIRLVAS and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRLVAS and STVFCNT (FK1_SIRLVAS_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRLVAS	SIRLVAS_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIRNIST and STVASTY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVASTY (FK1_SIRNIST_INV_STVASTY_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_ASTY_CODE	STVASTY_CODE	STVASTY	(0,1)-(0,n)

Link between SIRNIST and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVFCNT (FK1_SIRNIST_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIRNIST and STVNIST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVNIST (FK1_SIRNIST_INV_STVNIST_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_NIST_CODE	STVNIST_CODE	STVNIST	(0,1)-(0,n)

Link between SIRNIST and STVTOPS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVTOPS (FK1_SIRNIST_INV_STVTOPS_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_TOPS_CODE	STVTOPS_CODE	STVTOPS	(0,1)-(0,n)

Link between SIRDPCL and STVCOLL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRDPCL and STVCOLL (FK1_SIRDPCL_INV_STVCOLL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRDPCL	SIRDPCL_COLL_CODE	STVCOLL_CODE	STVCOLL	(0,1)-(0,n)

Link between SIRNIST and STVCOLL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVCOLL (FK1_SIRNIST_INV_STVCOLL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_COLL_CODE	STVCOLL_CODE	STVCOLL	(0,1)-(0,n)

Link between SIRFCNT and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFCNT and STVFCNT (FK1_SIRFCNT_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFCNT	SIRFCNT_FCNT_CODE	STVFCNT_CODE	STVFCNT	(1,1)-(0,n)

Link between SIRDPCL and STVDEPT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRDPCL and STVDEPT (FK1_SIRDPCL_INV_STVDEPT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRDPCL	SIRDPCL_DEPT_CODE	STVDEPT_CODE	STVDEPT	(0,1)-(0,n)

Link between SIRNIST and STVDEPT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNIST and STVDEPT (FK1_SIRNIST_INV_STVDEPT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNIST	SIRNIST_DEPT_CODE	STVDEPT_CODE	STVDEPT	(0,1)-(0,n)

Link between SIBINST and STVCNTR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVCNTR (FK1_SIBINST_INV_STVCNTR_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_CNTR_CODE	STVCNTR_CODE	STVCNTR	(0,1)-(0,n)

Link between SIBINST and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVFCNT (FK1_SIBINST_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIBINST and STVFCST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVFCST (FK1_SIBINST_INV_STVFCST_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_FCST_CODE	STVFCST_CODE	STVFCST	(1,1)-(0,n)

Link between SIBINST and STVFCTG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVFCTG (FK1_SIBINST_INV_STVFCTG_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_FCTG_CODE	STVFCTG_CODE	STVFCTG	(0,1)-(0,n)

Link between SIBINST and STVFSTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVFSTP (FK1_SIBINST_INV_STVFSTP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_FSTP_CODE	STVFSTP_CODE	STVFSTP	(0,1)-(0,n)

Link between SIRFLCT and STVCNTR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFLCT and STVCNTR (FK1_SIRFLCT_INV_STVCNTR_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFLCT	SIRFLCT_CNTR_CODE	STVCNTR_CODE	STVCNTR	(0,1)-(0,n)

Link between SIRFLCT and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFLCT and STVFCNT (FK1_SIRFLCT_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFLCT	SIRFLCT_FCNT_CODE	STVFCNT_CODE	STVFCNT	(1,1)-(0,n)

Link between SIBINST and STVWKLD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBINST and STVWKLD (FK1_SIBINST_INV_STVWKLD_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBINST	SIBINST_WKLD_CODE	STVWKLD_CODE	STVWKLD	(0,1)-(0,n)

Link between SIRASGN and STVASTY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRASGN and STVASTY (FK1_SIRASGN_INV_STVASTY_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRASGN	SIRASGN_ASTY_CODE	STVASTY_CODE	STVASTY	(0,1)-(0,n)

Link between SIRASGN and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRASGN and STVFCNT (FK1_SIRASGN_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRASGN	SIRASGN_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIRICNT and STVCNTR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRICNT and STVCNTR (FK1_SIRICNT_INV_STVCNTR_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRICNT	SIRICNT_CNTR_CODE	STVCNTR_CODE	STVCNTR	(0,1)-(0,n)

Link between SIRICNT and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRICNT and STVFCNT (FK1_SIRICNT_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRICNT	SIRICNT_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIROFFC and STVTELE

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIROFFC and STVTELE (FK1_SIROFFC_INV_STVTELE_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIROFFC	SIROFFC_TELE_CODE	STVTELE_CODE	STVTELE	(0,1)-(0,n)

Link between SIRFLRC and STVCNTR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFLRC and STVCNTR (FK1_SIRFLRC_INV_STVCNTR_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFLRC	SIRFLRC_CNTR_CODE	STVCNTR_CODE	STVCNTR	(0,1)-(0,n)

Link between SIRFLRC and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFLRC and STVFCNT (FK1_SIRFLRC_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFLRC	SIRFLRC_FCNT_CODE	STVFCNT_CODE	STVFCNT	(1,1)-(0,n)

Link between SIRFLRT and STVWKLD

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRFLRT and STVWKLD (FK1_SIRFLRT_INV_STVWKLD_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRFLRT	SIRFLRT_WKLD_CODE	STVWKLD_CODE	STVWKLD	(0,1)-(0,n)

Link between SIRASGN and SSBSECT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRASGN and SSBSECT (FK1_SIRASGN_INV_SSBSECT_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRASGN	SIRASGN_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT	(1,1)-(0,n)
SIRASGN	SIRASGN_CRN	SSBSECT_CRN	SSBSECT	(1,1)-(0,n)

Link between SIRLVAS and SSBSECT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRLVAS and SSBSECT (FK1_SIRLVAS_INV_SSBSECT_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRLVAS	SIRLVAS_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT	(1,1)-(0,n)
SIRLVAS	SIRLVAS_CRN	SSBSECT_CRN	SSBSECT	(1,1)-(0,n)

Link between SIRCOLC and STVFATT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRCOLC and STVFATT (FK1_SIRCOLC_INV_STVFATT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRCOLC	SIRCOLC_FATT_CODE	STVFATT_CODE	STVFATT	(1,1)-(0,n)

Link between SIRNLVA and STVASTY

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVASTY (FK1_SIRNLVA_INV_STVASTY_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_ASTY_CODE	STVASTY_CODE	STVASTY	(0,1)-(0,n)

Link between SIRNLVA and STVCOLL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVCOLL (FK1_SIRNLVA_INV_STVCOLL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_COLL_CODE	STVCOLL_CODE	STVCOLL	(0,1)-(0,n)

Link between SIRNLVA and STVDEPT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVDEPT (FK1_SIRNLVA_INV_STVDEPT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_DEPT_CODE	STVDEPT_CODE	STVDEPT	(0,1)-(0,n)

Link between SIRNLVA and STVFCNT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVFCNT (FK1_SIRNLVA_INV_STVFCNT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_FCNT_CODE	STVFCNT_CODE	STVFCNT	(0,1)-(0,n)

Link between SIRNLVA and STVNIST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVNIST (FK1_SIRNLVA_INV_STVNIST_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_NIST_CODE	STVNIST_CODE	STVNIST	(0,1)-(0,n)

Link between SIRNLVA and STVTOPS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRNLVA and STVTOPS (FK1_SIRNLVA_INV_STVTOPS_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRNLVA	SIRNLVA_TOPS_CODE	STVTOPS_CODE	STVTOPS	(0,1)-(0,n)

Link between SIRATTR and STVFATT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIRATTR and STVFATT (FK1_SIRATTR_INV_STVFATT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIRATTR	SIRATTR_FATT_CODE	STVFATT_CODE	STVFATT	(0,1)-(0,n)

Link between SIBFACD and PTRTENR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SIBFACD and PTRTENR (FK1_SIBFACD_INV_PTRTENR_KEY)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SIBFACD	SIBFACD_TENR_CODE	PTRTENR_CODE	PTRTENR	(0,1)-(0,n)