GTVINSM GTVMTYP GTVPARS GTVSCHS SCRSCHD SFRAREG SFRRGFE SFRSTCR SFTFEES SFTREGS SHRGRDE SHRTTRM SIRASGN SLBBLDG SMBAGEN SMRALIB SMRPRLE SORTEST SSBACRL SSBDESC SSBDFEE SSBFSEC SSBOVRR SSBSSEC SSBXLST SSRATTR SSRBLCK SSRCORQ SSRCTRL SSREVAL SSREXCL SSREXTN SSRFEES SSRLINK SSRMEET SSRMPRT SSRMRDF SSRRARE SSRRCLS SSRRCMP SSRRCOL SSRRDEG SSRRESV SSRRFND SSRRLVL SSRRMAJ SSRRPRG SSRRSTS SSRRTST SSRSCCD SSRSPRT SSRSRDF SSRSYLN SSRSYLO SSRSYRM SSRSYTR SSRTEXT SSRXLST SSTSCHW STVACCL STVATTR STVBLCK STVBLDG STVCAMP STVCLAS STVCOLL STVCOMT STVDAYS STVDEGC STVDEPT STVDIVS STVEVAL STVFTYP STVGMOD STVLEVL STVMAJR STVPTRM STVRDEF STVRSTS STVSCCD STVSCHD STVSUBJ STVTESC STVTOPS TBBDETC

Model Schedule


Model Label : ERD For Banner Student Schedule Module.
Path : BANNER DEV/Student/Schedule/Schedule_ERD/Schedule

List of Objects

Object Name Object Type Layer Name
GTVINSM TABLE Links
GTVMTYP TABLE Links
GTVPARS TABLE Links
GTVSCHS TABLE Links
SCRSCHD TABLE Links
SFRAREG TABLE Links
SFRRGFE TABLE Links
SFRSTCR TABLE Links
SFTFEES TABLE Links
SFTREGS TABLE Links
SHRGRDE TABLE Links
SHRTTRM TABLE Links
SIRASGN TABLE Links
SLBBLDG TABLE Links
SMBAGEN TABLE Links
SMRALIB TABLE Links
SMRPRLE TABLE Links
SORTEST TABLE Links
SSBACRL TABLE Tables
SSBDESC TABLE Tables
SSBDFEE TABLE Tables
SSBFSEC TABLE Tables
SSBOVRR TABLE Tables
SSBSSEC TABLE Tables
SSBXLST TABLE Tables
SSRATTR TABLE Tables
SSRBLCK TABLE Tables
SSRCORQ TABLE Tables
SSRCTRL TABLE Tables
SSREVAL TABLE Tables
SSREXCL TABLE Tables
SSREXTN TABLE Tables
SSRFEES TABLE Tables
SSRLINK TABLE Tables
SSRMEET TABLE Tables
SSRMPRT TABLE Tables
SSRMRDF TABLE Tables
SSRRARE TABLE Tables
SSRRCLS TABLE Tables
SSRRCMP TABLE Tables
SSRRCOL TABLE Tables
SSRRDEG TABLE Tables
SSRRESV TABLE Tables
SSRRFND TABLE Tables
SSRRLVL TABLE Tables
SSRRMAJ TABLE Tables
SSRRPRG TABLE Tables
SSRRSTS TABLE Tables
SSRRTST TABLE Tables
SSRSCCD TABLE Tables
SSRSPRT TABLE Tables
SSRSRDF TABLE Tables
SSRSYLN TABLE Tables
SSRSYLO TABLE Tables
SSRSYRM TABLE Tables
SSRSYTR TABLE Tables
SSRTEXT TABLE Tables
SSRXLST TABLE Tables
SSTSCHW TABLE Tables
STVACCL TABLE Links
STVATTR TABLE Links
STVBLCK TABLE Links
STVBLDG TABLE Links
STVCAMP TABLE Links
STVCLAS TABLE Links
STVCOLL TABLE Links
STVCOMT TABLE Links
STVDAYS TABLE Links
STVDEGC TABLE Links
STVDEPT TABLE Links
STVDIVS TABLE Links
STVEVAL TABLE Links
STVFTYP TABLE Links
STVGMOD TABLE Links
STVLEVL TABLE Links
STVMAJR TABLE Links
STVPTRM TABLE Links
STVRDEF TABLE Links
STVRSTS TABLE Links
STVSCCD TABLE Links
STVSCHD TABLE Links
STVSUBJ TABLE Links
STVTESC TABLE Links
STVTOPS TABLE Links
TBBDETC TABLE Links

Comments

Model View

''

Table GTVINSM

Schema Name GENERAL
Label GTVINSM
Server name MALDEV8_B60
Creation Date 02/17/2003 18:03:47:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVINSM_CODE GTVINSM_CODE VARCHAR2(5) No *
GTVINSM_DESC GTVINSM_DESC VARCHAR2(30) No
GTVINSM_ACTIVITY_DATE GTVINSM_ACTIVITY_DATE DATE No
GTVINSM_USER_ID GTVINSM_USER_ID VARCHAR2(30) No
GTVINSM_VR_MSG_NO GTVINSM_VR_MSG_NO NUMBER(6,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVINSM Unique GTVINSM_CODE

Comments

Source Code Comments

Instructional Method Code Validation Table

Columns Comments for GTVINSM_CODE (1)

Source Code Comments

Instructional Method Code: The Instructional Method Code

Columns Comments for GTVINSM_DESC (2)

Source Code Comments

Description: Description of the instructional method code

Columns Comments for GTVINSM_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date this record entered or last updated

Columns Comments for GTVINSM_USER_ID (4)

Source Code Comments

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

Columns Comments for GTVINSM_VR_MSG_NO (5)

Source Code Comments

Voice Response Message Number

Table GTVMTYP

Schema Name GENERAL
Label GTVMTYP
Server name MALDEV8_B60
Creation Date 02/17/2003 18:03:41:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVMTYP_CODE GTVMTYP_CODE VARCHAR2(4) No *
GTVMTYP_DESC GTVMTYP_DESC VARCHAR2(30) No
GTVMTYP_SYS_REQ_IND GTVMTYP_SYS_REQ_IND VARCHAR2(1) No
GTVMTYP_ACTIVITY_DATE GTVMTYP_ACTIVITY_DATE DATE No
GTVMTYP_USER_ID GTVMTYP_USER_ID VARCHAR2(30) No
GTVMTYP_VR_MSG_NO GTVMTYP_VR_MSG_NO NUMBER(6,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVMTYP Unique GTVMTYP_CODE

Comments

Source Code Comments

Meeting Type Code validation table

Columns Comments for GTVMTYP_CODE (1)

Source Code Comments

Meeting Type Code: The Meeting Type Code

Columns Comments for GTVMTYP_DESC (2)

Source Code Comments

Description: Description of the Meeting Type code

Columns Comments for GTVMTYP_SYS_REQ_IND (3)

Source Code Comments

System Required Indicator: Indicates whether or not this record is required to exist on the database

Columns Comments for GTVMTYP_ACTIVITY_DATE (4)

Source Code Comments

Activty Date: Date this record entered or last updated

Columns Comments for GTVMTYP_USER_ID (5)

Source Code Comments

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

Columns Comments for GTVMTYP_VR_MSG_NO (6)

Source Code Comments

Voice Response Message Number

Table GTVPARS

Schema Name GENERAL
Label GTVPARS
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:01:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVPARS_CODE GTVPARS_CODE VARCHAR2(7) No *
GTVPARS_DESC GTVPARS_DESC VARCHAR2(30) No
GTVPARS_SCHEDULER_NUMBER GTVPARS_SCHEDULER_NUMBER NUMBER(2,0) No
GTVPARS_USER_ID GTVPARS_USER_ID VARCHAR2(30) No
GTVPARS_ACTIVITY_DATE GTVPARS_ACTIVITY_DATE DATE No
GTVPARS_CAMP_CODE GTVPARS_CAMP_CODE VARCHAR2(3) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
GTVPARS_CAMP_CODE STVCAMP_CODE STVCAMP

Index

Index Name Index Type Column Name
PK_GTVPARS Unique GTVPARS_CODE

Comments

Source Code Comments

Validation entries for Partition codes. Partition Codes define campus zones, which are catagories or groupings of rooms.

Columns Comments for GTVPARS_CODE (1)

Source Code Comments

Partition code for campus zones for scheduling product.

Columns Comments for GTVPARS_DESC (2)

Source Code Comments

Description of partition code for scheduling product.

Columns Comments for GTVPARS_SCHEDULER_NUMBER (3)

Source Code Comments

Numeric identifying value for partition code for scheduling product.

Columns Comments for GTVPARS_USER_ID (4)

Source Code Comments

This field identifies the user wholast updated the record

Columns Comments for GTVPARS_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for GTVPARS_CAMP_CODE (6)

Source Code Comments

Campus code associated with partition for scheduling product.

Table GTVSCHS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSCHS_CODE GTVSCHS_CODE VARCHAR2(3) No *
GTVSCHS_DESC GTVSCHS_DESC VARCHAR2(30) No
GTVSCHS_SYSTEM_REQ_IND GTVSCHS_SYSTEM_REQ_IND VARCHAR2(1) No
GTVSCHS_ACTIVITY_DATE GTVSCHS_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVSCHS Unique GTVSCHS_CODE

Comments

Source Code Comments

Validation entries for Schedule Status Codes.

Columns Comments for GTVSCHS_CODE (1)

Source Code Comments

Code for Schedule Status.

Columns Comments for GTVSCHS_DESC (2)

Source Code Comments

Description of Schedule Status code.

Columns Comments for GTVSCHS_SYSTEM_REQ_IND (3)

Source Code Comments

A Y in this column indicates that the row is delivered by SCT and required for the system.

Columns Comments for GTVSCHS_ACTIVITY_DATE (4)

Source Code Comments

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

Table SCRSCHD

Schema Name SATURN
Label SCRSCHD
Server name MALDEV8_B60
Creation Date 01/24/2003 13:30:40:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRSCHD_SUBJ_CODE SCRSCHD_SUBJ_CODE VARCHAR2(4) No * *
SCRSCHD_SUBJ_CODE SCRSCHD_SUBJ_CODE VARCHAR2(4) No * *
SCRSCHD_CRSE_NUMB SCRSCHD_CRSE_NUMB VARCHAR2(5) No * *
SCRSCHD_EFF_TERM SCRSCHD_EFF_TERM VARCHAR2(6) No * *
SCRSCHD_SCHD_CODE SCRSCHD_SCHD_CODE VARCHAR2(3) No * *
SCRSCHD_ACTIVITY_DATE SCRSCHD_ACTIVITY_DATE DATE No
SCRSCHD_WORKLOAD SCRSCHD_WORKLOAD NUMBER(9,3) Yes
SCRSCHD_MAX_ENRL SCRSCHD_MAX_ENRL NUMBER(3,0) Yes
SCRSCHD_ADJ_WORKLOAD SCRSCHD_ADJ_WORKLOAD NUMBER(9,3) Yes
SCRSCHD_INSM_CODE SCRSCHD_INSM_CODE VARCHAR2(5) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SCRSCHD_INSM_CODE GTVINSM_CODE GTVINSM
SCRSCHD_SCHD_CODE STVSCHD_CODE STVSCHD
SCRSCHD_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SCRSCHD_EFF_TERM STVTERM_CODE STVTERM
SCRSCHD_SUBJ_CODE SSBSECT_SUBJ_CODE SSBSECT
SCRSCHD_CRSE_NUMB SSBSECT_CRSE_NUMB SSBSECT

Index

Index Name Index Type Column Name
PK_SCRSCHD Unique SCRSCHD_SUBJ_CODE
PK_SCRSCHD Unique SCRSCHD_CRSE_NUMB
PK_SCRSCHD Unique SCRSCHD_EFF_TERM
PK_SCRSCHD Unique SCRSCHD_SCHD_CODE

Comments

Source Code Comments

Course Schedule Type Repeating Table

Columns Comments for SCRSCHD_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRSCHD_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCRSCHD_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course schedule types becomes effective.

Columns Comments for SCRSCHD_SCHD_CODE (4)

Source Code Comments

This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.

Columns Comments for SCRSCHD_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for SCRSCHD_WORKLOAD (6)

Source Code Comments

Instructional workload value for the schedule type

Columns Comments for SCRSCHD_MAX_ENRL (7)

Source Code Comments

Maximum student enrollment for workload

Columns Comments for SCRSCHD_ADJ_WORKLOAD (8)

Source Code Comments

Adjust instructional workload value for the schedule type

Columns Comments for SCRSCHD_INSM_CODE (9)

Source Code Comments

Instructional Method code: This field indicates how the course is delivered to the learner. Examples are Web based, mixed media, face to face

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