SFBCREQ SFBESTS SFBETRM SFBPIPE SFBREST SFBRFST SFBRGRP SFBSECT SFBWCTL SFRAFEE SFRAREG SFRATWT SFRBTCH SFRCBRQ SFRCOLR SFRCTRL SFREFEE SFRENRL SFREPRT SFRFAUD SFRFMAX SFRFREQ SFRMESG SFRMHRS SFRRACL SFRRFCR SFRRFND SFRRGFE SFRROVR SFRRSTS SFRSRPO SFRSTCA SFRSTCR SFRTCTL SFRTERM SFRTHST SFRTIME SFRTMSL SFRTMST SFRWCTL SFRWDRL SFTAREA SFTFEES SFTREGS

Model Registration


Model Label : ERD For Banner Student Registration Module (SF% Tables )
Path : BANNER DEV/Student/Registration/Registration

List of Objects

Object Name Object Type Layer Name
SFBCREQ TABLE Table_3
SFBESTS TABLE Table_1
SFBETRM TABLE Table_1
SFBPIPE TABLE Table_3
SFBREST TABLE Table_3
SFBRFST TABLE Table_1
SFBRGRP TABLE Table_2
SFBSECT TABLE Table_3
SFBWCTL TABLE Table_2
SFRAFEE TABLE Table_1
SFRAREG TABLE Table_1
SFRATWT TABLE Table_3
SFRBTCH TABLE Table_3
SFRCBRQ TABLE Table_3
SFRCOLR TABLE Table_2
SFRCTRL TABLE Table_3
SFREFEE TABLE Table_1
SFRENRL TABLE Table_1
SFREPRT TABLE Table_3
SFRFAUD TABLE Table_2
SFRFMAX TABLE Table_3
SFRFREQ TABLE Table_3
SFRMESG TABLE Table_3
SFRMHRS TABLE Table_3
SFRRACL TABLE Table_3
SFRRFCR TABLE Table_1
SFRRFND TABLE Table_2
SFRRGFE TABLE Table_2
SFRROVR TABLE Table_1
SFRRSTS TABLE Table_3
SFRSRPO TABLE Table_1
SFRSTCA TABLE Table_3
SFRSTCR TABLE Table_1
SFRTCTL TABLE Table_3
SFRTERM TABLE Table_3
SFRTHST TABLE Table_3
SFRTIME TABLE Table_1
SFRTMSL TABLE Table_3
SFRTMST TABLE Table_3
SFRWCTL TABLE Table_2
SFRWDRL TABLE Table_3
SFTAREA TABLE Table_3
SFTFEES TABLE Table_3
SFTREGS TABLE Table_1

Comments

Model View

''

Table SFBCREQ

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBCREQ_STATUS SFBCREQ_STATUS VARCHAR2(1) No
SFBCREQ_TERM SFBCREQ_TERM VARCHAR2(6) No *
SFBCREQ_FCC SFBCREQ_FCC VARCHAR2(1) No
SFBCREQ_IDNO SFBCREQ_IDNO VARCHAR2(9) No
SFBCREQ_CRNUM SFBCREQ_CRNUM VARCHAR2(5) No
SFBCREQ_ALTIND SFBCREQ_ALTIND VARCHAR2(1) Yes
SFBCREQ_RECTYP SFBCREQ_RECTYP VARCHAR2(1) No
SFBCREQ_BATCH SFBCREQ_BATCH VARCHAR2(6) Yes
SFBCREQ_FUNCT SFBCREQ_FUNCT NUMBER(1,0) No
SFBCREQ_TRANID SFBCREQ_TRANID VARCHAR2(2) No
SFBCREQ_ORGCDE SFBCREQ_ORGCDE VARCHAR2(1) Yes
SFBCREQ_CSTAT SFBCREQ_CSTAT VARCHAR2(4) Yes
SFBCREQ_CREATE SFBCREQ_CREATE VARCHAR2(6) Yes
SFBCREQ_CRHRS SFBCREQ_CRHRS NUMBER(7,3) Yes
SFBCREQ_PRTY SFBCREQ_PRTY NUMBER(1,0) No
SFBCREQ_OVRTCO SFBCREQ_OVRTCO NUMBER(1,0) No
SFBCREQ_OVRMAJR SFBCREQ_OVRMAJR NUMBER(1,0) No
SFBCREQ_OVRLEVL SFBCREQ_OVRLEVL NUMBER(1,0) No
SFBCREQ_OVRCOLL SFBCREQ_OVRCOLL NUMBER(1,0) No
SFBCREQ_OVRLINK SFBCREQ_OVRLINK NUMBER(1,0) No
SFBCREQ_FIRST SFBCREQ_FIRST NUMBER(1,0) No
SFBCREQ_ALTCRN SFBCREQ_ALTCRN VARCHAR2(5) Yes
SFBCREQ_CRHRS_ALT SFBCREQ_CRHRS_ALT NUMBER(7,3) Yes
SFBCREQ_STUD_PRTY SFBCREQ_STUD_PRTY VARCHAR2(9) Yes
SFBCREQ_DESC SFBCREQ_DESC VARCHAR2(28) Yes
SFBCREQ_ACTIVITY_DATE SFBCREQ_ACTIVITY_DATE DATE No
SFBCREQ_GMOD_CODE SFBCREQ_GMOD_CODE VARCHAR2(1) Yes *
SFBCREQ_GMOD_CODE_ALT SFBCREQ_GMOD_CODE_ALT VARCHAR2(1) Yes *
SFBCREQ_LEVL_CODE_PRI SFBCREQ_LEVL_CODE_PRI VARCHAR2(2) Yes *
SFBCREQ_LEVL_CODE_ALT SFBCREQ_LEVL_CODE_ALT VARCHAR2(2) Yes *
SFBCREQ_BILL_HOURS SFBCREQ_BILL_HOURS NUMBER(7,3) Yes
SFBCREQ_OVRCAMP SFBCREQ_OVRCAMP NUMBER(1,0) No
SFBCREQ_OVRDEGC SFBCREQ_OVRDEGC NUMBER(1,0) No
SFBCREQ_OVRPROG SFBCREQ_OVRPROG NUMBER(1,0) No

Foreign Key information

Column name is Foreign Key For Column on Table
SFBCREQ_TERM STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SFBCREQ_KEY_INDEX SFBCREQ_IDNO
SFBCREQ_KEY_INDEX SFBCREQ_TERM
SFBCREQ_KEY_INDEX SFBCREQ_CRNUM

Comments

Source Code Comments

Course Request Transaction Table

Columns Comments for SFBCREQ_STATUS (1)

Source Code Comments

This field identifies the status of the course request. Valid values are Y and N - Y means passed edit.

Columns Comments for SFBCREQ_TERM (2)

Source Code Comments

This field identifies the term associated with the course requests.

Columns Comments for SFBCREQ_FCC (3)

Source Code Comments

This field identifies the file control code - value equals three.

Columns Comments for SFBCREQ_IDNO (4)

Source Code Comments

This field identifies the ID Number of the student requesting courses.

Columns Comments for SFBCREQ_CRNUM (5)

Source Code Comments

This field identifies the course reference number of the requested course.

Columns Comments for SFBCREQ_ALTIND (6)

Source Code Comments

This field identifies the alternate course indicater. Value of three means this request is an alternate course.

Columns Comments for SFBCREQ_RECTYP (7)

Source Code Comments

This field identifies the record type of K .

Columns Comments for SFBCREQ_BATCH (8)

Source Code Comments

This field identifies the batch number if this is done as a batch process.

Columns Comments for SFBCREQ_FUNCT (9)

Source Code Comments

This field identifies the function being performed. Value of 0 for add transactions is valid.

Columns Comments for SFBCREQ_TRANID (10)

Source Code Comments

This field identifies the transaction ID. C1 for course request and C2 for priority request.

Columns Comments for SFBCREQ_ORGCDE (11)

Source Code Comments

This field is not currently in use.

Columns Comments for SFBCREQ_CREATE (13)

Source Code Comments

This field identifies the creation date. Format of MMDDYY.

Columns Comments for SFBCREQ_CRHRS (14)

Source Code Comments

This field identifies the credit hours associated with the request.

Columns Comments for SFBCREQ_PRTY (15)

Source Code Comments

This field identifies the priority of request. A 1 means no priority and a 0 means if student does not get all courses this will be scheduled first.

Columns Comments for SFBCREQ_OVRTCO (16)

Source Code Comments

This field identifies the time conflict override of the requested course. Values are one equals yes and zero equals no.

Columns Comments for SFBCREQ_OVRMAJR (17)

Source Code Comments

This field identifies the major restriction override of the requested course. Values are one equals yes and zero equals no.

Columns Comments for SFBCREQ_OVRLEVL (18)

Source Code Comments

This field identifies the level restriction override of the requested course. Values are one equals yes and zero equals no.

Columns Comments for SFBCREQ_OVRCOLL (19)

Source Code Comments

This field identifies the college restriction override of the requested course.Values are one equals yes and zero equals no.

Columns Comments for SFBCREQ_OVRLINK (20)

Source Code Comments

This field identifies the link override of the requested course. Values are oneequals yes and zero equals no.

Columns Comments for SFBCREQ_FIRST (21)

Source Code Comments

This field indicates when to process. Zero means yes process in first pass and one means no.

Columns Comments for SFBCREQ_ALTCRN (22)

Source Code Comments

This field identifies an alternate course reference number in case original course not available.

Columns Comments for SFBCREQ_CRHRS_ALT (23)

Source Code Comments

This field identifies the credit hours associated with the alternate CRN.

Columns Comments for SFBCREQ_STUD_PRTY (24)

Source Code Comments

This field indicates the priority of how student will be processed. Ascending order.

Columns Comments for SFBCREQ_DESC (25)

Source Code Comments

This field identifies this is a COURSE REQUEST.

Columns Comments for SFBCREQ_ACTIVITY_DATE (26)

Source Code Comments

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

Columns Comments for SFBCREQ_GMOD_CODE (27)

Source Code Comments

This column is the grading mode of the original request.

Columns Comments for SFBCREQ_GMOD_CODE_ALT (28)

Source Code Comments

This column is the grading mode of the alternate request.

Columns Comments for SFBCREQ_LEVL_CODE_PRI (29)

Source Code Comments

This field identifies the level (undergraduate,gradulate,etc) for the course the student is requesting

Columns Comments for SFBCREQ_LEVL_CODE_ALT (30)

Source Code Comments

This field identifies the level (undergraduate,graduate,etc) for the alternate course the student is requesting

Columns Comments for SFBCREQ_BILL_HOURS (31)

Source Code Comments

Billing Hours Override

Columns Comments for SFBCREQ_OVRCAMP (32)

Source Code Comments

Campus restriction override

Columns Comments for SFBCREQ_OVRDEGC (33)

Source Code Comments

Degree restriction override indicator

Columns Comments for SFBCREQ_OVRPROG (34)

Source Code Comments

Program restriction override indicator

Table SFBESTS

Schema Name SATURN
Label SFBESTS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:56:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBESTS_TERM_CODE SFBESTS_TERM_CODE VARCHAR2(6) No * *
SFBESTS_TERM_CODE SFBESTS_TERM_CODE VARCHAR2(6) No * *
SFBESTS_ESTS_CODE SFBESTS_ESTS_CODE VARCHAR2(2) No * *
SFBESTS_START_DATE SFBESTS_START_DATE DATE Yes
SFBESTS_END_DATE SFBESTS_END_DATE DATE Yes
SFBESTS_ACTIVITY_DATE SFBESTS_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SFBESTS_TERM_CODE STVTERM_CODE STVTERM
SFBESTS_ESTS_CODE STVESTS_CODE STVESTS
SFBESTS_TERM_CODE SOBTERM_TERM_CODE SOBTERM

Index

Index Name Index Type Column Name
PK_SFBESTS Unique SFBESTS_TERM_CODE
PK_SFBESTS Unique SFBESTS_ESTS_CODE

Comments

Source Code Comments

Student Registration Status Table

Columns Comments for SFBESTS_TERM_CODE (1)

Source Code Comments

This field identifies the term associated with the student registration status code.

Columns Comments for SFBESTS_ESTS_CODE (2)

Source Code Comments

This field identifies the student registration status code .

Columns Comments for SFBESTS_START_DATE (3)

Source Code Comments

This field identifies the starting date associated with the student registration status code.

Columns Comments for SFBESTS_END_DATE (4)

Source Code Comments

This field identifies the ending date associated with the student registration status code.

Columns Comments for SFBESTS_ACTIVITY_DATE (5)

Source Code Comments

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

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 SFBPIPE

Schema Name SATURN
Label SFBPIPE
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:56:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBPIPE_NAME SFBPIPE_NAME VARCHAR2(9) No
SFBPIPE_QDEPTH SFBPIPE_QDEPTH NUMBER(7,0) No
SFBPIPE_ACTIVITY_DATE SFBPIPE_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
SFBPIPE_KEY_INDEX Unique SFBPIPE_NAME

Comments

Source Code Comments

Registration DBMS PIPE Identifier Table

Columns Comments for SFBPIPE_NAME (1)

Source Code Comments

User identified pipe name

Columns Comments for SFBPIPE_QDEPTH (2)

Source Code Comments

Number of allocations currently assigned to the pipe name

Columns Comments for SFBPIPE_ACTIVITY_DATE (3)

Source Code Comments

Date of last update or insert

Table SFBREST

Schema Name SATURN
Label SFBREST
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:56:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBREST_AINDX SFBREST_AINDX NUMBER(4,0) No *
SFBREST_ACRN SFBREST_ACRN VARCHAR2(5) Yes
SFBREST_TIMES SFBREST_TIMES VARCHAR2(120) Yes
SFBREST_APOTS SFBREST_APOTS VARCHAR2(3) Yes
SFBREST_LNKCD SFBREST_LNKCD VARCHAR2(2) Yes
SFBREST_PGMREST SFBREST_PGMREST VARCHAR2(41) Yes
SFBREST_LVLREST SFBREST_LVLREST VARCHAR2(9) Yes
SFBREST_CLSREST SFBREST_CLSREST VARCHAR2(7) Yes
SFBREST_SPEC SFBREST_SPEC VARCHAR2(5) Yes
SFBREST_PASS1PGM SFBREST_PASS1PGM VARCHAR2(40) Yes
SFBREST_PASS1CLS SFBREST_PASS1CLS VARCHAR2(6) Yes
SFBREST_CMPREST SFBREST_CMPREST VARCHAR2(13) Yes
SFBREST_PASS1CMP SFBREST_PASS1CMP VARCHAR2(12) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_SFBREST Unique SFBREST_AINDX

Comments

Source Code Comments

Course Request Restriction Table

Columns Comments for SFBREST_AINDX (1)

Source Code Comments

Restriction Table Index Number

Columns Comments for SFBREST_ACRN (2)

Source Code Comments

Restriction Table Course Reference Number

Columns Comments for SFBREST_TIMES (3)

Source Code Comments

Restriction Table Section Meeting Times

Columns Comments for SFBREST_APOTS (4)

Source Code Comments

Restriction Table Part of Term Indicator

Columns Comments for SFBREST_LNKCD (5)

Source Code Comments

Restriction Table Link Code

Columns Comments for SFBREST_PGMREST (6)

Source Code Comments

Restriction Table Major Restrictions

Columns Comments for SFBREST_LVLREST (7)

Source Code Comments

Restriction Table Level Restrictions

Columns Comments for SFBREST_CLSREST (8)

Source Code Comments

Restriction Table Class Restrictions

Columns Comments for SFBREST_SPEC (9)

Source Code Comments

Restriction Table Special Restrictions

Columns Comments for SFBREST_PASS1PGM (10)

Source Code Comments

Restriction Table PASS1 Major Restrictions

Columns Comments for SFBREST_PASS1CLS (11)

Source Code Comments

Restriction Table PASS1 Class Restrictions

Columns Comments for SFBREST_CMPREST (12)

Source Code Comments

Campus restrictions

Columns Comments for SFBREST_PASS1CMP (13)

Source Code Comments

Campus restrictions

Table SFBRFST

Schema Name SATURN
Label SFBRFST
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:56:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBRFST_TERM_CODE SFBRFST_TERM_CODE VARCHAR2(6) No *
SFBRFST_TERM_CODE SFBRFST_TERM_CODE VARCHAR2(6) No *
SFBRFST_TERM_CODE SFBRFST_TERM_CODE VARCHAR2(6) No *
SFBRFST_ESTS_CODE SFBRFST_ESTS_CODE VARCHAR2(2) No *
SFBRFST_ESTS_CODE SFBRFST_ESTS_CODE VARCHAR2(2) No *
SFBRFST_ESTS_CODE SFBRFST_ESTS_CODE VARCHAR2(2) No *
SFBRFST_FROM_DATE SFBRFST_FROM_DATE DATE Yes
SFBRFST_TO_DATE SFBRFST_TO_DATE DATE Yes
SFBRFST_TUIT_REFUND SFBRFST_TUIT_REFUND NUMBER(3,0) No
SFBRFST_FEES_REFUND SFBRFST_FEES_REFUND NUMBER(3,0) No
SFBRFST_ACTIVITY_DATE SFBRFST_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SFBRFST_TERM_CODE SFBESTS_TERM_CODE SFBESTS
SFBRFST_ESTS_CODE SFBESTS_ESTS_CODE SFBESTS
SFBRFST_TERM_CODE STVTERM_CODE STVTERM
SFBRFST_ESTS_CODE STVESTS_CODE STVESTS
SFBRFST_ESTS_CODE SFBETRM_ESTS_CODE SFBETRM
SFBRFST_TERM_CODE SFBETRM_TERM_CODE SFBETRM

Index

Index Name Index Type Column Name
SFBRFST_KEY_INDEX Unique SFBRFST_TERM_CODE
SFBRFST_KEY_INDEX Unique SFBRFST_ESTS_CODE
SFBRFST_KEY_INDEX Unique SFBRFST_FROM_DATE

Comments

Source Code Comments

Student Refund Percentage Table

Columns Comments for SFBRFST_TERM_CODE (1)

Source Code Comments

This field identifies the term associated with the refund percentage.

Columns Comments for SFBRFST_ESTS_CODE (2)

Source Code Comments

This field identifies the student enrollment status associated with the refund percentage.

Columns Comments for SFBRFST_FROM_DATE (3)

Source Code Comments

This field identifies the from date associated with the refund percentage.

Columns Comments for SFBRFST_TO_DATE (4)

Source Code Comments

This field identifies the to date associated with the refund percentage.

Columns Comments for SFBRFST_TUIT_REFUND (5)

Source Code Comments

This field identifies the percent tuition refund associated with the status and date range.

Columns Comments for SFBRFST_FEES_REFUND (6)

Source Code Comments

This field identifies the percent fees refund associated with the status and date range.

Columns Comments for SFBRFST_ACTIVITY_DATE (7)

Source Code Comments

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

Table SFBRGRP

Schema Name SATURN
Label SFBRGRP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:56:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBRGRP_TERM_CODE SFBRGRP_TERM_CODE VARCHAR2(6) No * *
SFBRGRP_PIDM SFBRGRP_PIDM NUMBER(8,0) No *
SFBRGRP_RGRP_CODE SFBRGRP_RGRP_CODE VARCHAR2(10) No
SFBRGRP_USER SFBRGRP_USER VARCHAR2(30) No
SFBRGRP_ACTIVITY_DATE SFBRGRP_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SFBRGRP_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SFBRGRP Unique SFBRGRP_TERM_CODE
PK_SFBRGRP Unique SFBRGRP_PIDM

Comments

Source Code Comments

Student Registration Group Code Table

Columns Comments for SFBRGRP_TERM_CODE (1)

Source Code Comments

Registration term code that group code is to be used

Columns Comments for SFBRGRP_PIDM (2)

Source Code Comments

Unique person internal identification number.

Columns Comments for SFBRGRP_RGRP_CODE (3)

Source Code Comments

Registration time ticketing group code.

Columns Comments for SFBRGRP_USER (4)

Source Code Comments

User ID that created this record.

Columns Comments for SFBRGRP_ACTIVITY_DATE (5)

Source Code Comments

Date of most recent activity.

Table SFBSECT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBSECT_TERM SFBSECT_TERM VARCHAR2(6) No
SFBSECT_SUBJ SFBSECT_SUBJ VARCHAR2(4) No
SFBSECT_CRSE SFBSECT_CRSE VARCHAR2(5) No
SFBSECT_IDENT SFBSECT_IDENT VARCHAR2(2) Yes
SFBSECT_KCRNUM SFBSECT_KCRNUM VARCHAR2(5) No
SFBSECT_SECT9 SFBSECT_SECT9 VARCHAR2(3) No
SFBSECT_STATS SFBSECT_STATS VARCHAR2(4) Yes
SFBSECT_ACRNUM SFBSECT_ACRNUM VARCHAR2(5) Yes
SFBSECT_AINDX SFBSECT_AINDX NUMBER(4,0) Yes
SFBSECT_ABEG SFBSECT_ABEG NUMBER(4,0) Yes
SFBSECT_AEND SFBSECT_AEND NUMBER(4,0) Yes
SFBSECT_ACAP SFBSECT_ACAP NUMBER(4,0) Yes
SFBSECT_AREQ SFBSECT_AREQ NUMBER(4,0) Yes
SFBSECT_AREM SFBSECT_AREM NUMBER(4,0) Yes
SFBSECT_AHRSIND SFBSECT_AHRSIND VARCHAR2(2) Yes
SFBSECT_A9HRSL SFBSECT_A9HRSL NUMBER(7,3) Yes
SFBSECT_A9HRSH SFBSECT_A9HRSH NUMBER(7,3) Yes
SFBSECT_APOTD SFBSECT_APOTD VARCHAR2(1) Yes
SFBSECT_APOTS SFBSECT_APOTS VARCHAR2(3) Yes
SFBSECT_ABSCODE SFBSECT_ABSCODE VARCHAR2(1) Yes
SFBSECT_A9ENRCRH SFBSECT_A9ENRCRH NUMBER(7,3) Yes
SFBSECT_AABS SFBSECT_AABS NUMBER(3,0) Yes
SFBSECT_ACLTERM SFBSECT_ACLTERM VARCHAR2(6) Yes
SFBSECT_ACLSUBJ SFBSECT_ACLSUBJ VARCHAR2(4) Yes
SFBSECT_ACLCRSE SFBSECT_ACLCRSE VARCHAR2(5) Yes
SFBSECT_ACLSECT9 SFBSECT_ACLSECT9 VARCHAR2(3) Yes
SFBSECT_ACRLCRN SFBSECT_ACRLCRN VARCHAR2(5) Yes
SFBSECT_ACRLINDX SFBSECT_ACRLINDX NUMBER(4,0) Yes
SFBSECT_A9CRLCAP SFBSECT_A9CRLCAP NUMBER(4,0) Yes
SFBSECT_A9CRLREQ SFBSECT_A9CRLREQ NUMBER(4,0) Yes
SFBSECT_A9CRLREM SFBSECT_A9CRLREM NUMBER(4,0) Yes
SFBSECT_A9CRLABS SFBSECT_A9CRLABS NUMBER(3,0) Yes
SFBSECT_A9CRLENR SFBSECT_A9CRLENR NUMBER(4,0) Yes
SFBSECT_CLSDAYS1 SFBSECT_CLSDAYS1 VARCHAR2(7) Yes
SFBSECT_CLSBEG1 SFBSECT_CLSBEG1 NUMBER(4,0) Yes
SFBSECT_CLSEND1 SFBSECT_CLSEND1 NUMBER(4,0) Yes
SFBSECT_CLSBLDG1 SFBSECT_CLSBLDG1 VARCHAR2(6) Yes
SFBSECT_CLSROOM1 SFBSECT_CLSROOM1 VARCHAR2(10) Yes
SFBSECT_CLSMEMO1 SFBSECT_CLSMEMO1 VARCHAR2(2) Yes
SFBSECT_CLSDAYS2 SFBSECT_CLSDAYS2 VARCHAR2(7) Yes
SFBSECT_CLSBEG2 SFBSECT_CLSBEG2 NUMBER(4,0) Yes
SFBSECT_CLSEND2 SFBSECT_CLSEND2 NUMBER(4,0) Yes
SFBSECT_CLSBLDG2 SFBSECT_CLSBLDG2 VARCHAR2(6) Yes
SFBSECT_CLSROOM2 SFBSECT_CLSROOM2 VARCHAR2(10) Yes
SFBSECT_CLSMEMO2 SFBSECT_CLSMEMO2 VARCHAR2(2) Yes
SFBSECT_CLSDAYS3 SFBSECT_CLSDAYS3 VARCHAR2(7) Yes
SFBSECT_CLSBEG3 SFBSECT_CLSBEG3 NUMBER(4,0) Yes
SFBSECT_CLSEND3 SFBSECT_CLSEND3 NUMBER(4,0) Yes
SFBSECT_CLSBLDG3 SFBSECT_CLSBLDG3 VARCHAR2(6) Yes
SFBSECT_CLSROOM3 SFBSECT_CLSROOM3 VARCHAR2(10) Yes
SFBSECT_CLSMEMO3 SFBSECT_CLSMEMO3 VARCHAR2(2) Yes
SFBSECT_DLSDAYS SFBSECT_DLSDAYS VARCHAR2(7) Yes
SFBSECT_DLSBEG SFBSECT_DLSBEG NUMBER(4,0) Yes
SFBSECT_DLSEND SFBSECT_DLSEND NUMBER(4,0) Yes
SFBSECT_DLSBLDG SFBSECT_DLSBLDG VARCHAR2(6) Yes
SFBSECT_DLSROOM SFBSECT_DLSROOM VARCHAR2(10) Yes
SFBSECT_DLSMEMO SFBSECT_DLSMEMO VARCHAR2(2) Yes
SFBSECT_EPGMR1 SFBSECT_EPGMR1 VARCHAR2(4) Yes
SFBSECT_EPGMR2 SFBSECT_EPGMR2 VARCHAR2(4) Yes
SFBSECT_EPGMR3 SFBSECT_EPGMR3 VARCHAR2(4) Yes
SFBSECT_EPGMR4 SFBSECT_EPGMR4 VARCHAR2(4) Yes
SFBSECT_ECLSR1 SFBSECT_ECLSR1 VARCHAR2(2) Yes
SFBSECT_ECLSR2 SFBSECT_ECLSR2 VARCHAR2(2) Yes
SFBSECT_ECLSR3 SFBSECT_ECLSR3 VARCHAR2(2) Yes
SFBSECT_ALKTERM SFBSECT_ALKTERM VARCHAR2(6) Yes
SFBSECT_ALKSUBJ SFBSECT_ALKSUBJ VARCHAR2(4) Yes
SFBSECT_ALKCRSE SFBSECT_ALKCRSE VARCHAR2(5) Yes
SFBSECT_ALKSECT9 SFBSECT_ALKSECT9 VARCHAR2(3) Yes
SFBSECT_ALKCRN9 SFBSECT_ALKCRN9 VARCHAR2(5) Yes
SFBSECT_ALNKCD SFBSECT_ALNKCD VARCHAR2(1) Yes
SFBSECT_ALNKGRP SFBSECT_ALNKGRP VARCHAR2(2) Yes
SFBSECT_ALNKCRN SFBSECT_ALNKCRN VARCHAR2(5) Yes
SFBSECT_ALNKINDX SFBSECT_ALNKINDX NUMBER(4,0) Yes
SFBSECT_FTITLE SFBSECT_FTITLE VARCHAR2(30) Yes
SFBSECT_FINSTNO SFBSECT_FINSTNO VARCHAR2(9) Yes
SFBSECT_FINSTNAME SFBSECT_FINSTNAME VARCHAR2(15) Yes
SFBSECT_FPGMCDE SFBSECT_FPGMCDE VARCHAR2(1) Yes
SFBSECT_FPGMR1 SFBSECT_FPGMR1 VARCHAR2(4) Yes
SFBSECT_FPGMR2 SFBSECT_FPGMR2 VARCHAR2(4) Yes
SFBSECT_FPGMR3 SFBSECT_FPGMR3 VARCHAR2(4) Yes
SFBSECT_FPGMR4 SFBSECT_FPGMR4 VARCHAR2(4) Yes
SFBSECT_FLVLCODE SFBSECT_FLVLCODE VARCHAR2(1) Yes
SFBSECT_FLVLR1 SFBSECT_FLVLR1 VARCHAR2(2) Yes
SFBSECT_FLVLR2 SFBSECT_FLVLR2 VARCHAR2(2) Yes
SFBSECT_FLVLR3