Model Faculty Load

Model Label : ERD for Banner Student Faculty Load Module
Path : BANNER DEV/Student/Faculty_Load/Faculty_Load_ERD/Faculty Load

List of Objects

Object Name	Object Type	Layer Name
PTRTENR	TABLE	Links
PTVDISP	TABLE	Links
PTVRANK	TABLE	Links
SFRAREG	TABLE	Links
SFRSTCR	TABLE	Links
SHRTCKN	TABLE	Links
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
SOBTERM	TABLE	Links
SPBPERS	TABLE	Links
SPRIDEN	TABLE	Links
SSBSECT	TABLE	Links
SSRMEET	TABLE	Links
SSRXLST	TABLE	Links
STVASTY	TABLE	Links
STVCNTR	TABLE	Links
STVCOLL	TABLE	Links
STVDEPT	TABLE	Links
STVFATT	TABLE	Links
STVFCNT	TABLE	Links
STVFCST	TABLE	Links
STVFCTG	TABLE	Links
STVFSTP	TABLE	Links
STVNIST	TABLE	Links
STVSTAT	TABLE	Links
STVTELE	TABLE	Links
STVTOPS	TABLE	Links
STVWKLD	TABLE	Links

Comments

Model View

Table PTRTENR

Schema Name PAYROLL
Label PTRTENR
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:13:000

Table Columns information

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

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_PTRTENR	Unique	PTRTENR_CODE

Comments

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 PTVDISP

Schema Name PAYROLL
Label PTVDISP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:20:07:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PTVDISP_CODE	PTVDISP_CODE	VARCHAR2(5)	No	*	*
PTVDISP_DESC	PTVDISP_DESC	VARCHAR2(30)	No
PTVDISP_ACTIVITY_DATE	PTVDISP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTVDISP_CODE	SIBFACD_DISP_CODE	SIBFACD

Index

Index Name	Index Type	Column Name
PK_PTVDISP	Unique	PTVDISP_CODE

Comments

Source Code Comments

Discipline Code Validation Table.

Columns Comments for PTVDISP_CODE (1)

Source Code Comments

Discipline Code.

Columns Comments for PTVDISP_DESC (2)

Source Code Comments

Discipline Description.

Columns Comments for PTVDISP_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of the last activity (update or insert) on this record.

Table PTVRANK

Schema Name PAYROLL
Label PTVRANK
Server name MALDEV8_B60
Creation Date 04/15/2002 18:20:09:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PTVRANK_CODE	PTVRANK_CODE	VARCHAR2(1)	No	*	*
PTVRANK_DESC	PTVRANK_DESC	VARCHAR2(30)	No
PTVRANK_ACTIVITY_DATE	PTVRANK_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTVRANK_CODE	SIBFACD_RANK_CODE	SIBFACD

Index

Index Name	Index Type	Column Name
PK_PTVRANK	Unique	PTVRANK_CODE

Comments

Source Code Comments

Rank Code Validation Table

Columns Comments for PTVRANK_CODE (1)

Source Code Comments

RANK CODE.

Columns Comments for PTVRANK_DESC (2)

Source Code Comments

RANK DESCRIPTION.

Columns Comments for PTVRANK_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last activity (update or insert) on this record.

Table SFRAREG

Schema Name SATURN
Label SFRAREG
Server name MALDEV8_B60
Creation Date 04/13/2003 21:12:31:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRAREG_PIDM	SFRAREG_PIDM	NUMBER(8,0)	No	*	*
SFRAREG_PIDM	SFRAREG_PIDM	NUMBER(8,0)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_CRN	SFRAREG_CRN	VARCHAR2(5)	No	*	*
SFRAREG_CRN	SFRAREG_CRN	VARCHAR2(5)	No	*	*
SFRAREG_EXTENSION_NUMBER	SFRAREG_EXTENSION_NUMBER	NUMBER(3,0)	No	*
SFRAREG_RSTS_CODE	SFRAREG_RSTS_CODE	VARCHAR2(2)	No		*
SFRAREG_START_DATE	SFRAREG_START_DATE	DATE	No
SFRAREG_COMPLETION_DATE	SFRAREG_COMPLETION_DATE	DATE	No
SFRAREG_FEE_WAIVER_IND	SFRAREG_FEE_WAIVER_IND	VARCHAR2(1)	No
SFRAREG_SAPR_OVERRIDE_IND	SFRAREG_SAPR_OVERRIDE_IND	VARCHAR2(1)	No
SFRAREG_ACTIVITY_DATE	SFRAREG_ACTIVITY_DATE	DATE	No
SFRAREG_USER_ID	SFRAREG_USER_ID	VARCHAR2(30)	No
SFRAREG_NUMBER_OF_UNITS	SFRAREG_NUMBER_OF_UNITS	NUMBER(7,2)	Yes
SFRAREG_DUNT_CODE	SFRAREG_DUNT_CODE	VARCHAR2(4)	Yes		*
SFRAREG_DETL_CODE	SFRAREG_DETL_CODE	VARCHAR2(4)	Yes		*
SFRAREG_AMOUNT	SFRAREG_AMOUNT	NUMBER(7,2)	Yes
SFRAREG_INSTRUCTOR_PIDM	SFRAREG_INSTRUCTOR_PIDM	NUMBER(8,0)	Yes
SFRAREG_TRAN_NUMBER	SFRAREG_TRAN_NUMBER	NUMBER(8,0)	Yes
SFRAREG_EFFECTIVE_DATE	SFRAREG_EFFECTIVE_DATE	DATE	Yes
SFRAREG_COMMENTS	SFRAREG_COMMENTS	CLOB	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRAREG_DUNT_CODE	GTVDUNT_CODE	GTVDUNT
SFRAREG_TERM_CODE	STVTERM_CODE	STVTERM
SFRAREG_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRAREG_DETL_CODE	TBBDETC_DETAIL_CODE	TBBDETC
SFRAREG_CRN	SFTREGS_CRN	SFTREGS
SFRAREG_TERM_CODE	SFTREGS_TERM_CODE	SFTREGS
SFRAREG_PIDM	SFTREGS_PIDM	SFTREGS
SFRAREG_PIDM	SFRSTCR_PIDM	SFRSTCR
SFRAREG_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SFRAREG_CRN	SFRSTCR_CRN	SFRSTCR

Index

Index Name	Index Type	Column Name
PK_SFRAREG	Unique	SFRAREG_PIDM
PK_SFRAREG	Unique	SFRAREG_TERM_CODE
PK_SFRAREG	Unique	SFRAREG_CRN
PK_SFRAREG	Unique	SFRAREG_EXTENSION_NUMBER
SFRAREG_START_DATE_INDEX		SFRAREG_START_DATE
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_TERM_CODE
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_CRN
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_INSTRUCTOR_PIDM

Comments

Source Code Comments

Open Learning Additional Registration Information table

Columns Comments for SFRAREG_PIDM (1)

Source Code Comments

Personal Identification Number: The system generated internal identification number

Columns Comments for SFRAREG_TERM_CODE (2)

Source Code Comments

Term code: Indicates the term of the registration information/extension

Columns Comments for SFRAREG_CRN (3)

Source Code Comments

Course Reference Number: Indicates the section that is registered for

Columns Comments for SFRAREG_EXTENSION_NUMBER (4)

Source Code Comments

Extension number: The number in sequence of how many extensions have been granted for the section

Columns Comments for SFRAREG_RSTS_CODE (5)

Source Code Comments

Registration status code: Indicates the registration status code assigned to the registration

Columns Comments for SFRAREG_START_DATE (6)

Source Code Comments

Extension Start date: Date the extension or registration starts

Columns Comments for SFRAREG_COMPLETION_DATE (7)

Source Code Comments

Extension Completion date: Date this extension should finish

Columns Comments for SFRAREG_FEE_WAIVER_IND (8)

Source Code Comments

Fee Waiver Indicator: This field used to waive the charge normally generated by this extension

Columns Comments for SFRAREG_SAPR_OVERRIDE_IND (9)

Source Code Comments

Special Approval Override indicator. This field used to provide a registration override for sections that normally require special approval

Columns Comments for SFRAREG_ACTIVITY_DATE (10)

Source Code Comments

Activity date: Date this record entered or last updated

Columns Comments for SFRAREG_USER_ID (11)

Source Code Comments

User ID: The username of the person who entered or last updated this record

Columns Comments for SFRAREG_NUMBER_OF_UNITS (12)

Source Code Comments

Duration number of units: The number of duration units awarded this extension

Columns Comments for SFRAREG_DUNT_CODE (13)

Source Code Comments

Duration Unit Code: The duration unit code assigned to the extension

Columns Comments for SFRAREG_DETL_CODE (14)

Source Code Comments

Detail Code: The detail fee code assigned to the extension

Columns Comments for SFRAREG_AMOUNT (15)

Source Code Comments

Amount: The amount to be charged to the student for this extension

Columns Comments for SFRAREG_INSTRUCTOR_PIDM (16)

Source Code Comments

Instructor personal identification number: The system defined personal identification number of the instructor assigned to this extension

Columns Comments for SFRAREG_TRAN_NUMBER (17)

Source Code Comments

Transaction number: The transaction number written to the accounting record when fee assessment is run.

Columns Comments for SFRAREG_EFFECTIVE_DATE (18)

Source Code Comments

Effective Date: The effective date of the charge generated by fee assessment for this extension

Columns Comments for SFRAREG_COMMENTS (19)

Source Code Comments

Comments: This area provided to house comments or reason related to the course extension

Table SFRSTCR

Schema Name SATURN
Label SFRSTCR
Server name MALDEV8_B60
Creation Date 07/30/2003 16:03:46:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	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		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRSTCR_PTRM_CODE	STVPTRM_CODE	STVPTRM
SFRSTCR_PIDM	SFBETRM_PIDM	SFBETRM
SFRSTCR_TERM_CODE	SFBETRM_TERM_CODE	SFBETRM
SFRSTCR_GCMT_CODE	STVGCMT_CODE	STVGCMT
SFRSTCR_CAMP_CODE	STVCAMP_CODE	STVCAMP
SFRSTCR_LEVL_CODE	STVLEVL_CODE	STVLEVL
SFRSTCR_TERM_CODE	STVTERM_CODE	STVTERM
SFRSTCR_GMOD_CODE	STVGMOD_CODE	STVGMOD
SFRSTCR_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRSTCR_TERM_CODE	SFRENRL_TERM_CODE	SFRENRL
SFRSTCR_PIDM	SFRENRL_PIDM	SFRENRL
SFRSTCR_PIDM	TBRACCD_PIDM	TBRACCD
SFRSTCR_TERM_CODE	TBRACCD_TERM_CODE	TBRACCD
SFRSTCR_CRN	TBRACCD_CRN	TBRACCD
SFRSTCR_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SFRSTCR_TERM_CODE	SSRSYLN_TERM_CODE	SSRSYLN
SFRSTCR_CRN	SSRSYLN_CRN	SSRSYLN
SFRSTCR_TERM_CODE	RORENRL_TERM_CODE	RORENRL
SFRSTCR_PIDM	RORENRL_PIDM	RORENRL
SFRSTCR_TERM_CODE	SHRMRKS_TERM_CODE	SHRMRKS
SFRSTCR_PIDM	SHRMRKS_PIDM	SHRMRKS
SFRSTCR_CRN	SHRMRKS_CRN	SHRMRKS
SFRSTCR_TERM_CODE	SHRSMRK_TERM_CODE	SHRSMRK
SFRSTCR_PIDM	SHRSMRK_PIDM	SHRSMRK
SFRSTCR_CRN	SHRSMRK_CRN	SHRSMRK
SFRSTCR_CRN	SSBSECT_CRN	SSBSECT
SFRSTCR_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT

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

Comments

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.

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.

Table SHRTCKN

Schema Name SATURN
Label SHRTCKN
Server name MALDEV8_B60
Creation Date 07/30/2003 16:04:04:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SHRTCKN_PIDM	SHRTCKN_PIDM	NUMBER(8,0)	No	*	*
SHRTCKN_PIDM	SHRTCKN_PIDM	NUMBER(8,0)	No	*	*
SHRTCKN_PIDM	SHRTCKN_PIDM	NUMBER(8,0)	No	*	*
SHRTCKN_TERM_CODE	SHRTCKN_TERM_CODE	VARCHAR2(6)	No	*	*
SHRTCKN_TERM_CODE	SHRTCKN_TERM_CODE	VARCHAR2(6)	No	*	*
SHRTCKN_TERM_CODE	SHRTCKN_TERM_CODE	VARCHAR2(6)	No	*	*
SHRTCKN_TERM_CODE	SHRTCKN_TERM_CODE	VARCHAR2(6)	No	*	*
SHRTCKN_SEQ_NO	SHRTCKN_SEQ_NO	NUMBER(2,0)	No		*
SHRTCKN_CRN	SHRTCKN_CRN	VARCHAR2(5)	No	*	*
SHRTCKN_SUBJ_CODE	SHRTCKN_SUBJ_CODE	VARCHAR2(4)	No		*
SHRTCKN_SUBJ_CODE	SHRTCKN_SUBJ_CODE	VARCHAR2(4)	No		*
SHRTCKN_SUBJ_CODE	SHRTCKN_SUBJ_CODE	VARCHAR2(4)	No		*
SHRTCKN_CRSE_NUMB	SHRTCKN_CRSE_NUMB	VARCHAR2(5)	No		*
SHRTCKN_CRSE_NUMB	SHRTCKN_CRSE_NUMB	VARCHAR2(5)	No		*
SHRTCKN_COLL_CODE	SHRTCKN_COLL_CODE	VARCHAR2(2)	Yes		*
SHRTCKN_CAMP_CODE	SHRTCKN_CAMP_CODE	VARCHAR2(3)	Yes		*
SHRTCKN_DEPT_CODE	SHRTCKN_DEPT_CODE	VARCHAR2(4)	Yes		*
SHRTCKN_DIVS_CODE	SHRTCKN_DIVS_CODE	VARCHAR2(4)	Yes		*
SHRTCKN_SESS_CODE	SHRTCKN_SESS_CODE	VARCHAR2(1)	Yes		*
SHRTCKN_CRSE_TITLE	SHRTCKN_CRSE_TITLE	VARCHAR2(30)	Yes
SHRTCKN_REG_SEQ	SHRTCKN_REG_SEQ	NUMBER(4,0)	Yes
SHRTCKN_COURSE_COMMENT	SHRTCKN_COURSE_COMMENT	VARCHAR2(30)	Yes
SHRTCKN_REPEAT_COURSE_IND	SHRTCKN_REPEAT_COURSE_IND	VARCHAR2(1)	Yes
SHRTCKN_ACTIVITY_DATE	SHRTCKN_ACTIVITY_DATE	DATE	No
SHRTCKN_PTRM_CODE	SHRTCKN_PTRM_CODE	VARCHAR2(3)	Yes		*
SHRTCKN_SEQ_NUMB	SHRTCKN_SEQ_NUMB	VARCHAR2(3)	Yes
SHRTCKN_PTRM_START_DATE	SHRTCKN_PTRM_START_DATE	DATE	Yes
SHRTCKN_PTRM_END_DATE	SHRTCKN_PTRM_END_DATE	DATE	Yes
SHRTCKN_CONT_HR	SHRTCKN_CONT_HR	NUMBER(7,3)	Yes
SHRTCKN_SCHD_CODE	SHRTCKN_SCHD_CODE	VARCHAR2(3)	Yes		*
SHRTCKN_REPEAT_SYS_IND	SHRTCKN_REPEAT_SYS_IND	VARCHAR2(1)	Yes
SHRTCKN_REG_START_DATE	SHRTCKN_REG_START_DATE	DATE	Yes
SHRTCKN_REG_COMPLETION_DATE	SHRTCKN_REG_COMPLETION_DATE	DATE	Yes
SHRTCKN_NUMBER_OF_EXTENSIONS	SHRTCKN_NUMBER_OF_EXTENSIONS	NUMBER(3,0)	Yes
SHRTCKN_LONG_COURSE_TITLE	SHRTCKN_LONG_COURSE_TITLE	VARCHAR2(100)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SHRTCKN_SCHD_CODE	STVSCHD_CODE	STVSCHD
SHRTCKN_DIVS_CODE	STVDIVS_CODE	STVDIVS
SHRTCKN_PTRM_CODE	STVPTRM_CODE	STVPTRM
SHRTCKN_SESS_CODE	STVSESS_CODE	STVSESS
SHRTCKN_PIDM	SHRTTRM_PIDM	SHRTTRM
SHRTCKN_TERM_CODE	SHRTTRM_TERM_CODE	SHRTTRM
SHRTCKN_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SHRTCKN_COLL_CODE	STVCOLL_CODE	STVCOLL
SHRTCKN_DEPT_CODE	STVDEPT_CODE	STVDEPT
SHRTCKN_CAMP_CODE	STVCAMP_CODE	STVCAMP
SHRTCKN_TERM_CODE	STVTERM_CODE	STVTERM
SHRTCKN_PIDM	SFBETRM_PIDM	SFBETRM
SHRTCKN_SEQ_NO	SHRTCKD_TCKN_SEQ_NO	SHRTCKD
SHRTCKN_TERM_CODE	SHRTCKD_TERM_CODE	SHRTCKD
SHRTCKN_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SHRTCKN_CRN	SSBSECT_CRN	SSBSECT
SHRTCKN_PIDM	SHRDGMR_PIDM	SHRDGMR
SHRTCKN_SUBJ_CODE	SC