Model General Student Processing

Model Label : ERD For Banner Student General Student Module (SG% Tables)
Path : BANNER DEV/Student/General_Student/General Student Processing

List of Objects

Object Name	Object Type	Layer Name
SFBETRM	TABLE	Links
SFRAREG	TABLE	Links
SFRSTCR	TABLE	Links
SGBEOPS	TABLE	Tables
SGBOEDU	TABLE	Tables
SGBUSER	TABLE	Tables
SGRACMT	TABLE	Tables
SGRADVR	TABLE	Tables
SGRASSI	TABLE	Tables
SGRASST	TABLE	Tables
SGRCATT	TABLE	Tables
SGRCHRT	TABLE	Tables
SGRCLSR	TABLE	Tables
SGRCMNT	TABLE	Tables
SGRCOLR	TABLE	Tables
SGRCOOP	TABLE	Tables
SGRDISA	TABLE	Tables
SGRDSER	TABLE	Tables
SGRDUTY	TABLE	Tables
SGRESEL	TABLE	Tables
SGRSACT	TABLE	Tables
SGRSATT	TABLE	Tables
SGRSCMT	TABLE	Tables
SGRSPRT	TABLE	Tables
SGRVETN	TABLE	Tables
SORMATT	TABLE	Links
SPRIDEN	TABLE	Links
STVACTC	TABLE	Links
STVADVR	TABLE	Links
STVAFDC	TABLE	Links
STVATTS	TABLE	Links
STVCAMP	TABLE	Links
STVCHRT	TABLE	Links
STVCLAS	TABLE	Links
STVCOLL	TABLE	Links
STVCOPC	TABLE	Links
STVCREA	TABLE	Links
STVDEGC	TABLE	Links
STVDEPS	TABLE	Links
STVDEPT	TABLE	Links
STVDISA	TABLE	Links
STVDLEV	TABLE	Links
STVELIG	TABLE	Links
STVEMPL	TABLE	Links
STVEOPS	TABLE	Links
STVESEL	TABLE	Links
STVGSTA	TABLE	Links
STVGTYP	TABLE	Links
STVLEVL	TABLE	Links
STVMAJR	TABLE	Links
STVMARS	TABLE	Links
STVMEDI	TABLE	Links
STVORIG	TABLE	Links
STVSEPR	TABLE	Links
STVSFAE	TABLE	Links
STVSOFF	TABLE	Links
STVSPRV	TABLE	Links
STVSPSR	TABLE	Links
STVSPST	TABLE	Links
STVSSEP	TABLE	Links
STVSSER	TABLE	Links
STVSSRS	TABLE	Links
STVSSST	TABLE	Links
STVSUDA	TABLE	Links
STVSUDB	TABLE	Links
STVSUDC	TABLE	Links
STVSUDD	TABLE	Links
STVSUDE	TABLE	Links
STVSUDF	TABLE	Links
STVSUDG	TABLE	Links
STVSUDH	TABLE	Links
STVSUDI	TABLE	Links
STVSUDJ	TABLE	Links
STVTASK	TABLE	Links
STVVETC	TABLE	Links
STVWTHD	TABLE	Links

Comments

Model View

Table SFBETRM

Schema Name SATURN
Label SFBETRM
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFBETRM_TERM_CODE	SFBETRM_TERM_CODE	VARCHAR2(6)	No	*	*
SFBETRM_TERM_CODE	SFBETRM_TERM_CODE	VARCHAR2(6)	No	*	*
SFBETRM_PIDM	SFBETRM_PIDM	NUMBER(8,0)	No	*	*
SFBETRM_ESTS_CODE	SFBETRM_ESTS_CODE	VARCHAR2(2)	No		*
SFBETRM_ESTS_DATE	SFBETRM_ESTS_DATE	DATE	Yes
SFBETRM_MHRS_OVER	SFBETRM_MHRS_OVER	NUMBER(9,3)	No
SFBETRM_AR_IND	SFBETRM_AR_IND	VARCHAR2(1)	No
SFBETRM_ASSESSMENT_DATE	SFBETRM_ASSESSMENT_DATE	DATE	Yes
SFBETRM_ADD_DATE	SFBETRM_ADD_DATE	DATE	No
SFBETRM_ACTIVITY_DATE	SFBETRM_ACTIVITY_DATE	DATE	No
SFBETRM_RGRE_CODE	SFBETRM_RGRE_CODE	VARCHAR2(2)	Yes		*
SFBETRM_TMST_CODE	SFBETRM_TMST_CODE	VARCHAR2(2)	Yes		*
SFBETRM_TMST_DATE	SFBETRM_TMST_DATE	DATE	Yes
SFBETRM_TMST_MAINT_IND	SFBETRM_TMST_MAINT_IND	VARCHAR2(1)	Yes
SFBETRM_USER	SFBETRM_USER	VARCHAR2(30)	Yes
SFBETRM_REFUND_DATE	SFBETRM_REFUND_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFBETRM_RGRE_CODE	STVRGRE_CODE	STVRGRE
SFBETRM_TERM_CODE	STVTERM_CODE	STVTERM
SFBETRM_ESTS_CODE	STVESTS_CODE	STVESTS
SFBETRM_TMST_CODE	STVTMST_CODE	STVTMST
SFBETRM_PIDM	SRBRECR_PIDM	SRBRECR
SFBETRM_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR

Index

Index Name	Index Type	Column Name
PK_SFBETRM	Unique	SFBETRM_PIDM
PK_SFBETRM	Unique	SFBETRM_TERM_CODE
SFBETRM_KEY_INDEX2		SFBETRM_TERM_CODE

Comments

Source Code Comments

Student Registration Table

Impact job : SFBETRM_ESTS_CODE SFBETRM_ESTS_CODE

Columns Comments for SFBETRM_TERM_CODE (1)

Source Code Comments

This field identifies term associated with this registration.

Columns Comments for SFBETRM_PIDM (2)

Source Code Comments

Internal Identification Number of the person registered .

Columns Comments for SFBETRM_ESTS_CODE (3)

Source Code Comments

This field identifies the student enrollment status code.

Columns Comments for SFBETRM_ESTS_DATE (4)

Source Code Comments

This field identifies the date associated with the student enrollment status code.

Columns Comments for SFBETRM_MHRS_OVER (5)

Source Code Comments

This field identifies the maximum hours override for this term.

Columns Comments for SFBETRM_AR_IND (6)

Source Code Comments

This field identifies the term charges acceptance indicator.

Columns Comments for SFBETRM_ASSESSMENT_DATE (7)

Source Code Comments

This field identifies the date of the assessment for this term.

Columns Comments for SFBETRM_ADD_DATE (8)

Source Code Comments

This field identifies the date of the initial registration for this term.

Columns Comments for SFBETRM_ACTIVITY_DATE (9)

Source Code Comments

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

Columns Comments for SFBETRM_RGRE_CODE (10)

Source Code Comments

Student Registration Reason Code.

Columns Comments for SFBETRM_TMST_CODE (11)

Source Code Comments

Most recently calculated time status code.

Columns Comments for SFBETRM_TMST_DATE (12)

Source Code Comments

Date change in time status occurred.

Columns Comments for SFBETRM_TMST_MAINT_IND (13)

Source Code Comments

Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user.

Columns Comments for SFBETRM_USER (14)

Source Code Comments

The ID of the user who updated or created the record.

Columns Comments for SFBETRM_REFUND_DATE (15)

Source Code Comments

Refund by total refund date used in performing fee assessment. Date is needed for refund by total processing to determine the refund period used in the last assessment.

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 SGBEOPS

Schema Name SATURN
Label SGBEOPS
Server name MALDEV8_B60
Creation Date 08/27/2002 00:00:50:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGBEOPS_PIDM	SGBEOPS_PIDM	NUMBER(8,0)	No	*
SGBEOPS_TERM_CODE_EFF	SGBEOPS_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SGBEOPS_EOPS_CODE	SGBEOPS_EOPS_CODE	VARCHAR2(2)	Yes		*
SGBEOPS_ACCEPT_DATE	SGBEOPS_ACCEPT_DATE	DATE	Yes
SGBEOPS_SFAE_CODE	SGBEOPS_SFAE_CODE	VARCHAR2(2)	Yes		*
SGBEOPS_ACTIVITY_DATE	SGBEOPS_ACTIVITY_DATE	DATE	No
SGBEOPS_TRAC_CODE	SGBEOPS_TRAC_CODE	VARCHAR2(3)	Yes
SGBEOPS_PLANNED_CREDITS	SGBEOPS_PLANNED_CREDITS	NUMBER(9,3)	Yes
SGBEOPS_WTHD_CODE	SGBEOPS_WTHD_CODE	VARCHAR2(1)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBEOPS_EOPS_CODE	STVEOPS_CODE	STVEOPS
SGBEOPS_SFAE_CODE	STVSFAE_CODE	STVSFAE
SGBEOPS_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SGBEOPS_WTHD_CODE	STVWTHD_CODE	STVWTHD

Index

Index Name	Index Type	Column Name
PK_SGBEOPS	Unique	SGBEOPS_PIDM
PK_SGBEOPS	Unique	SGBEOPS_TERM_CODE_EFF

Comments

Source Code Comments

Education Opportunity Programs and Services Base Table

Columns Comments for SGBEOPS_PIDM (1)

Source Code Comments

The Pidm of the student

Columns Comments for SGBEOPS_TERM_CODE_EFF (2)

Source Code Comments

The Effective Term

Columns Comments for SGBEOPS_EOPS_CODE (3)

Source Code Comments

Education Opportunity Programs and Services Code

Columns Comments for SGBEOPS_ACCEPT_DATE (4)

Source Code Comments

The date the student was accepted into the EOPS program

Columns Comments for SGBEOPS_SFAE_CODE (5)

Source Code Comments

Represents the method which was used to determine that the student was eligible for the EOPS program