GORVRAC RORVIEW SFBETRM SFRAREG SFRRGFE SFRSTCR SGBSTDN SHRLGPA SHRTTRM SORMADM SORMDPT SORMMJR SORMSTY SPBPERS SPRIDEN STVACYR STVAPRN STVASTD STVBLCK STVBSKL STVCAPL STVCAST STVEDLV STVEGOL STVEMEX STVGAIN STVINCM STVLEAV STVORSN STVPRAC STVPREV STVRATE STVRESD STVSESS STVSITE STVSTST STVSTYP STVTRCN STVVOED TBRACCD

Model SGBSTDN


Model Label : ERD for Banner Student SGBSTDN Table.
Path : BANNER DEV/Student/Common/SGBSTDN/SGBSTDN_ERD

List of Objects

Object Name Object Type Layer Name
GORVRAC TABLE Default
RORVIEW TABLE Default
SFBETRM TABLE Default
SFRAREG TABLE Default
SFRRGFE TABLE Default
SFRSTCR TABLE Default
SGBSTDN TABLE Default
SHRLGPA TABLE Default
SHRTTRM TABLE Default
SORMADM TABLE Default
SORMDPT TABLE Default
SORMMJR TABLE Default
SORMSTY TABLE Default
SPBPERS TABLE Default
SPRIDEN TABLE Default
STVACYR TABLE Default
STVAPRN TABLE Default
STVASTD TABLE Default
STVBLCK TABLE Default
STVBSKL TABLE Default
STVCAPL TABLE Default
STVCAST TABLE Default
STVEDLV TABLE Default
STVEGOL TABLE Default
STVEMEX TABLE Default
STVGAIN TABLE Default
STVINCM TABLE Default
STVLEAV TABLE Default
STVORSN TABLE Default
STVPRAC TABLE Default
STVPREV TABLE Default
STVRATE TABLE Default
STVRESD TABLE Default
STVSESS TABLE Default
STVSITE TABLE Default
STVSTST TABLE Default
STVSTYP TABLE Default
STVTRCN TABLE Default
STVVOED TABLE Default
TBRACCD TABLE Default

Comments

Model View

''

Table GORVRAC

Schema Name GENERAL
Label GORVRAC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:31:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORVRAC_USER_ID GORVRAC_USER_ID VARCHAR2(30) No *
GORVRAC_VOBJ_CODE GORVRAC_VOBJ_CODE VARCHAR2(15) No * *
GORVRAC_BACR_SEQNO GORVRAC_BACR_SEQNO NUMBER(8,0) No * *
GORVRAC_VAPP_CODE_MODULE GORVRAC_VAPP_CODE_MODULE VARCHAR2(15) No *
GORVRAC_ACTIVE_IND GORVRAC_ACTIVE_IND VARCHAR2(1) No
GORVRAC_EFF_DATE GORVRAC_EFF_DATE DATE No
GORVRAC_ACTIVITY_DATE GORVRAC_ACTIVITY_DATE DATE No
GORVRAC_EXPIRE_DATE GORVRAC_EXPIRE_DATE DATE Yes
GORVRAC_VBS_ITEM1 GORVRAC_VBS_ITEM1 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM1 GORVRAC_VBS_ITEM1 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM1 GORVRAC_VBS_ITEM1 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM2 GORVRAC_VBS_ITEM2 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM2 GORVRAC_VBS_ITEM2 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM2 GORVRAC_VBS_ITEM2 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM3 GORVRAC_VBS_ITEM3 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM3 GORVRAC_VBS_ITEM3 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM3 GORVRAC_VBS_ITEM3 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM4 GORVRAC_VBS_ITEM4 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM4 GORVRAC_VBS_ITEM4 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM4 GORVRAC_VBS_ITEM4 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *
GORVRAC_VBS_ITEM5 GORVRAC_VBS_ITEM5 VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
GORVRAC_VOBJ_CODE GTVVOBJ_CODE GTVVOBJ
GORVRAC_BACR_SEQNO GOBBACR_SEQNO GOBBACR
GORVRAC_VBS_ITEM1 SRBRECR_PROGRAM_1 SRBRECR
GORVRAC_VBS_ITEM2 SRBRECR_CAMP_CODE SRBRECR
GORVRAC_VBS_ITEM3 SRBRECR_COLL_CODE SRBRECR
GORVRAC_VBS_ITEM4 SRBRECR_LEVL_CODE SRBRECR
GORVRAC_VBS_ITEM5 SRBRECR_DEPT_CODE SRBRECR
GORVRAC_VBS_ITEM5 SRBRECR_DEPT_CODE_2 SRBRECR
GORVRAC_VBS_ITEM1 SARADAP_PROGRAM_1 SARADAP
GORVRAC_VBS_ITEM2 SARADAP_CAMP_CODE SARADAP
GORVRAC_VBS_ITEM3 SARADAP_COLL_CODE_1 SARADAP
GORVRAC_VBS_ITEM4 SARADAP_LEVL_CODE SARADAP
GORVRAC_VBS_ITEM5 SARADAP_DEPT_CODE SARADAP
GORVRAC_VBS_ITEM5 SARADAP_DEPT_CODE_1_2 SARADAP
GORVRAC_VBS_ITEM1 SGBSTDN_PROGRAM_1 SGBSTDN
GORVRAC_VBS_ITEM2 SGBSTDN_CAMP_CODE SGBSTDN
GORVRAC_VBS_ITEM3 SGBSTDN_COLL_CODE_1 SGBSTDN
GORVRAC_VBS_ITEM4 SGBSTDN_LEVL_CODE SGBSTDN
GORVRAC_VBS_ITEM5 SGBSTDN_DEPT_CODE SGBSTDN
GORVRAC_VBS_ITEM5 SGBSTDN_DEPT_CODE_1_2 SGBSTDN

Index

Index Name Index Type Column Name
PK_GORVRAC Unique GORVRAC_USER_ID
PK_GORVRAC Unique GORVRAC_VOBJ_CODE
PK_GORVRAC Unique GORVRAC_BACR_SEQNO
PK_GORVRAC Unique GORVRAC_VAPP_CODE_MODULE

Comments

Source Code Comments

VBS User Access Rule Control

Columns Comments for GORVRAC_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVRAC_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GORVRAC_BACR_SEQNO (3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVRAC_VAPP_CODE_MODULE (4)

Source Code Comments

VBS Module associated with User and Access Rule

Columns Comments for GORVRAC_ACTIVE_IND (5)

Source Code Comments

Indicates User is Active

Columns Comments for GORVRAC_EFF_DATE (6)

Source Code Comments

Effective Date of Access

Columns Comments for GORVRAC_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORVRAC_EXPIRE_DATE (8)

Source Code Comments

Expiration Date of Access

Columns Comments for GORVRAC_VBS_ITEM1 (9)

Source Code Comments

Program Value

Columns Comments for GORVRAC_VBS_ITEM2 (10)

Source Code Comments

Campus Value

Columns Comments for GORVRAC_VBS_ITEM3 (11)

Source Code Comments

College Value

Columns Comments for GORVRAC_VBS_ITEM4 (12)

Source Code Comments

Level Value

Columns Comments for GORVRAC_VBS_ITEM5 (13)

Source Code Comments

Department Value

Table RORVIEW

Schema Name FAISMGR
Label RORVIEW
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORVIEW_SESSION_ID RORVIEW_SESSION_ID VARCHAR2(30) No
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_TYPE_IND RORVIEW_TYPE_IND VARCHAR2(1) No
RORVIEW_TERM_CODE RORVIEW_TERM_CODE VARCHAR2(6) Yes *
RORVIEW_TERM_CODE RORVIEW_TERM_CODE VARCHAR2(6) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RORVIEW_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RORVIEW_TERM_CODE STVTERM_CODE STVTERM
RORVIEW_PIDM TBBESTU_PIDM TBBESTU
RORVIEW_AIDY_CODE RPRATRM_AIDY_CODE RPRATRM
RORVIEW_PIDM RPRATRM_PIDM RPRATRM
RORVIEW_PIDM SGBSTDN_PIDM SGBSTDN
RORVIEW_TERM_CODE SFBETRM_TERM_CODE SFBETRM
RORVIEW_PIDM SFBETRM_PIDM SFBETRM
RORVIEW_PIDM SHRTGPA_PIDM SHRTGPA
RORVIEW_PIDM TBRACCD_PIDM TBRACCD
RORVIEW_PIDM TBBCSTU_STU_PIDM TBBCSTU
RORVIEW_AIDY_CODE RPRAWRD_AIDY_CODE RPRAWRD
RORVIEW_PIDM RPRAWRD_PIDM RPRAWRD

Index

Index Name Index Type Column Name
RORVIEW_KEY_INDEX Unique RORVIEW_SESSION_ID
RORVIEW_KEY_INDEX Unique RORVIEW_PIDM
RORVIEW_KEY_INDEX Unique RORVIEW_TYPE_IND
RORVIEW_KEY_INDEX Unique RORVIEW_TERM_CODE
RORVIEW_KEY_INDEX Unique RORVIEW_AIDY_CODE

Comments

Source Code Comments

View Selection Table

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 SFRRGFE

Schema Name SATURN
Label SFRRGFE
Server name MALDEV8_B60
Creation Date 01/18/2003 23:46:02:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFRRGFE_TERM_CODE SFRRGFE_TERM_CODE VARCHAR2(6) No * *
SFRRGFE_TERM_CODE SFRRGFE_TERM_CODE VARCHAR2(6) No * *
SFRRGFE_DETL_CODE SFRRGFE_DETL_CODE VARCHAR2(4) No *
SFRRGFE_ACTIVITY_DATE SFRRGFE_ACTIVITY_DATE DATE No
SFRRGFE_PER_CRED_CHARGE SFRRGFE_PER_CRED_CHARGE NUMBER(6,2) No
SFRRGFE_MIN_CHARGE SFRRGFE_MIN_CHARGE NUMBER(12,2) No
SFRRGFE_MAX_CHARGE SFRRGFE_MAX_CHARGE NUMBER(12,2) No
SFRRGFE_PTRM_CODE SFRRGFE_PTRM_CODE VARCHAR2(3) Yes *
SFRRGFE_RESD_CODE SFRRGFE_RESD_CODE VARCHAR2(1) Yes *
SFRRGFE_RESD_CODE SFRRGFE_RESD_CODE VARCHAR2(1) Yes *
SFRRGFE_LEVL_CODE SFRRGFE_LEVL_CODE VARCHAR2(2) Yes *
SFRRGFE_LEVL_CODE SFRRGFE_LEVL_CODE VARCHAR2(2) Yes *
SFRRGFE_COLL_CODE SFRRGFE_COLL_CODE VARCHAR2(2) Yes *
SFRRGFE_COLL_CODE SFRRGFE_COLL_CODE VARCHAR2(2) Yes *
SFRRGFE_MAJR_CODE SFRRGFE_MAJR_CODE VARCHAR2(4) Yes *
SFRRGFE_MAJR_CODE SFRRGFE_MAJR_CODE VARCHAR2(4) Yes *
SFRRGFE_CLAS_CODE SFRRGFE_CLAS_CODE VARCHAR2(2) Yes *
SFRRGFE_RATE_CODE SFRRGFE_RATE_CODE VARCHAR2(5) Yes *
SFRRGFE_RATE_CODE SFRRGFE_RATE_CODE VARCHAR2(5) Yes *
SFRRGFE_CRSE_WAIV_IND SFRRGFE_CRSE_WAIV_IND VARCHAR2(1) Yes
SFRRGFE_FROM_CRED_HRS SFRRGFE_FROM_CRED_HRS NUMBER(9,3) Yes
SFRRGFE_TO_CRED_HRS SFRRGFE_TO_CRED_HRS NUMBER(9,3) Yes
SFRRGFE_FROM_ADD_DATE SFRRGFE_FROM_ADD_DATE DATE Yes
SFRRGFE_TO_ADD_DATE SFRRGFE_TO_ADD_DATE DATE Yes
SFRRGFE_TYPE SFRRGFE_TYPE VARCHAR2(7) No * *
SFRRGFE_CAMP_CODE SFRRGFE_CAMP_CODE VARCHAR2(3) Yes *
SFRRGFE_CAMP_CODE SFRRGFE_CAMP_CODE VARCHAR2(3) Yes *
SFRRGFE_LEVL_CODE_CRSE SFRRGFE_LEVL_CODE_CRSE VARCHAR2(2) Yes *
SFRRGFE_CAMP_CODE_CRSE SFRRGFE_CAMP_CODE_CRSE VARCHAR2(3) Yes *
SFRRGFE_ENTRY_TYPE SFRRGFE_ENTRY_TYPE VARCHAR2(1) No
SFRRGFE_FROM_STUD_HRS SFRRGFE_FROM_STUD_HRS NUMBER(9,3) Yes
SFRRGFE_TO_STUD_HRS SFRRGFE_TO_STUD_HRS NUMBER(9,3) Yes
SFRRGFE_CRED_IND SFRRGFE_CRED_IND VARCHAR2(1) No
SFRRGFE_FLAT_HRS SFRRGFE_FLAT_HRS NUMBER(9,3) Yes
SFRRGFE_COPY_IND SFRRGFE_COPY_IND VARCHAR2(1) No
SFRRGFE_SEQNO SFRRGFE_SEQNO NUMBER(8,0) No * *
SFRRGFE_PROGRAM SFRRGFE_PROGRAM VARCHAR2(12) Yes *
SFRRGFE_DEPT_CODE SFRRGFE_DEPT_CODE VARCHAR2(4) Yes *
SFRRGFE_DEGC_CODE SFRRGFE_DEGC_CODE VARCHAR2(6) Yes *
SFRRGFE_STYP_CODE SFRRGFE_STYP_CODE VARCHAR2(1) Yes *
SFRRGFE_TERM_CODE_ADMIT SFRRGFE_TERM_CODE_ADMIT VARCHAR2(6) Yes *
SFRRGFE_ATTR_CODE_CRSE SFRRGFE_ATTR_CODE_CRSE VARCHAR2(4) Yes *
SFRRGFE_ATTR_CODE_CRSE SFRRGFE_ATTR_CODE_CRSE VARCHAR2(4) Yes *
SFRRGFE_ATTS_CODE SFRRGFE_ATTS_CODE VARCHAR2(4) Yes *
SFRRGFE_GMOD_CODE SFRRGFE_GMOD_CODE VARCHAR2(1) Yes *
SFRRGFE_ASSESS_BY_COURSE_IND SFRRGFE_ASSESS_BY_COURSE_IND VARCHAR2(1) No
SFRRGFE_USER_ID SFRRGFE_USER_ID VARCHAR2(30) No
SFRRGFE_FROM_FLAT_HRS SFRRGFE_FROM_FLAT_HRS NUMBER(9,3) Yes
SFRRGFE_TO_FLAT_HRS SFRRGFE_TO_FLAT_HRS NUMBER(9,3) Yes
SFRRGFE_FLAT_FEE_AMOUNT SFRRGFE_FLAT_FEE_AMOUNT NUMBER(12,2) Yes *
SFRRGFE_CRSE_OVERLOAD_START_HR SFRRGFE_CRSE_OVERLOAD_START_HR NUMBER(9,3) Yes
SFRRGFE_INSM_CODE SFRRGFE_INSM_CODE VARCHAR2(5) Yes *
SFRRGFE_SCHD_CODE SFRRGFE_SCHD_CODE VARCHAR2(3) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SFRRGFE_INSM_CODE GTVINSM_CODE GTVINSM
SFRRGFE_CLAS_CODE STVCLAS_CODE STVCLAS
SFRRGFE_RESD_CODE STVRESD_CODE STVRESD
SFRRGFE_SCHD_CODE STVSCHD_CODE STVSCHD
SFRRGFE_PTRM_CODE STVPTRM_CODE STVPTRM
SFRRGFE_STYP_CODE STVSTYP_CODE STVSTYP
SFRRGFE_ATTR_CODE_CRSE STVATTR_CODE STVATTR
SFRRGFE_ATTS_CODE STVATTS_CODE STVATTS
SFRRGFE_RATE_CODE STVRATE_CODE STVRATE
SFRRGFE_COLL_CODE STVCOLL_CODE STVCOLL
SFRRGFE_MAJR_CODE STVMAJR_CODE STVMAJR
SFRRGFE_DEGC_CODE STVDEGC_CODE STVDEGC
SFRRGFE_DEPT_CODE STVDEPT_CODE STVDEPT
SFRRGFE_TERM_CODE_ADMIT STVTERM_CODE STVTERM
SFRRGFE_GMOD_CODE STVGMOD_CODE STVGMOD
SFRRGFE_PROGRAM SMRPRLE_PROGRAM SMRPRLE
SFRRGFE_TERM_CODE SOBTERM_TERM_CODE SOBTERM
SFRRGFE_DETL_CODE TBBDETC_DETAIL_CODE TBBDETC
SFRRGFE_RESD_CODE SGBSTDN_RESD_CODE SGBSTDN
SFRRGFE_LEVL_CODE SGBSTDN_LEVL_CODE SGBSTDN
SFRRGFE_COLL_CODE SGBSTDN_COLL_CODE_1 SGBSTDN
SFRRGFE_MAJR_CODE SGBSTDN_MAJR_CODE_1 SGBSTDN
SFRRGFE_RATE_CODE SGBSTDN_RATE_CODE SGBSTDN
SFRRGFE_CAMP_CODE SGBSTDN_CAMP_CODE SGBSTDN
SFRRGFE_TYPE SFRFAUD_RGFE_TYPE SFRFAUD
SFRRGFE_SEQNO SFRFAUD_RGFE_SEQNO SFRFAUD
SFRRGFE_FLAT_FEE_AMOUNT SFRFAUD_FLAT_FEE_AMOUNT SFRFAUD
SFRRGFE_TERM_CODE SSRATTR_TERM_CODE SSRATTR
SFRRGFE_ATTR_CODE_CRSE SSRATTR_ATTR_CODE SSRATTR

Index

Index Name Index Type Column Name
PK_SFRRGFE Unique SFRRGFE_TERM_CODE
PK_SFRRGFE Unique SFRRGFE_TYPE
PK_SFRRGFE Unique SFRRGFE_SEQNO

Comments

Source Code Comments

Registration Fees Table

Columns Comments for SFRRGFE_TERM_CODE (1)

Source Code Comments

Registration term.

Columns Comments for SFRRGFE_DETL_CODE (2)

Source Code Comments

Detail code that the determined charges for this rule will be posted to.

Columns Comments for SFRRGFE_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for SFRRGFE_PER_CRED_CHARGE (4)

Source Code Comments

Per hour charge amount to use when calculating per credit charges for this rule.

Columns Comments for SFRRGFE_MIN_CHARGE (5)

Source Code Comments

Minimum charge that can be posted when this rule is being applied.

Columns Comments for SFRRGFE_MAX_CHARGE (6)

Source Code Comments

Maximum charge that can be posted when this rule is being applied.

Columns Comments for SFRRGFE_PTRM_CODE (7)

Source Code Comments

Part-of-term code for the student's course registration (STVPTRM).

Columns Comments for SFRRGFE_RESD_CODE (8)

Source Code Comments

Student's residency code (STVRESD).

Columns Comments for SFRRGFE_LEVL_CODE (9)

Source Code Comments

Student's level code (STVLEVL).

Columns Comments for SFRRGFE_COLL_CODE (10)

Source Code Comments

Student's college code (STVCOLL).

Columns Comments for SFRRGFE_MAJR_CODE (11)

Source Code Comments

Student's major code (STVMAJR).

Columns Comments for SFRRGFE_CLAS_CODE (12)

Source Code Comments

Student's class code (STVCLAS).

Columns Comments for SFRRGFE_RATE_CODE (13)

Source Code Comments

Student's rate code (STVRATE).

Columns Comments for SFRRGFE_CRSE_WAIV_IND (14)

Source Code Comments

Flag to indicate that this rule can be skipped if the course is marked as being exempt from rule assessment processing (SFRSTCR_WAIV_HR = 0). Valid values are Y and N.

Columns Comments for SFRRGFE_FROM_CRED_HRS (15)

Source Code Comments

Low end of the course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_TO_CRED_HRS (16)

Source Code Comments

High end of the course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_FROM_ADD_DATE (17)

Source Code Comments

The starting initial course registration date that defines the low end for the qualifying registration date range.

Columns Comments for SFRRGFE_TO_ADD_DATE (18)

Source Code Comments

The ending initial course registration date that defines the high end for the qualifying registration date range.

Columns Comments for SFRRGFE_TYPE (19)

Source Code Comments

Type of assessment rule. Valid values are STUDENT, LEVEL (course level), CAMPUS (course ca