Model Registration Group #3

Model Label : ERD for Portions of Banner Student Registration Module
Path : BANNER DEV/Student/Registration/Registration_ERD/Registration Group #3

List of Objects

Object Name	Object Type	Layer Name
GTVSDAX	TABLE	Link_3
SFBCREQ	TABLE	Table_3
SFBPIPE	TABLE	Table_3
SFBREST	TABLE	Table_3
SFBSECT	TABLE	Table_3
SFRATWT	TABLE	Table_3
SFRBTCH	TABLE	Table_3
SFRCBRQ	TABLE	Table_3
SFRCTRL	TABLE	Table_3
SFREPRT	TABLE	Table_3
SFRFMAX	TABLE	Table_3
SFRFREQ	TABLE	Table_3
SFRMESG	TABLE	Table_3
SFRMHRS	TABLE	Table_3
SFRRACL	TABLE	Table_3
SFRRSTS	TABLE	Table_3
SFRSTCA	TABLE	Table_3
SFRTCTL	TABLE	Table_3
SFRTERM	TABLE	Table_3
SFRTHST	TABLE	Table_3
SFRTMSL	TABLE	Table_3
SFRTMST	TABLE	Table_3
SFRWDRL	TABLE	Table_3
SFTAREA	TABLE	Table_3
SFTFEES	TABLE	Table_3
SMBAOGN	TABLE	Link_3
SMRALIB	TABLE	Link_3
SOBPTRM	TABLE	Link_3
SOBTERM	TABLE	Link_3
SSBSECT	TABLE	Link_3
SSRATTR	TABLE	Link_3
STVCAMP	TABLE	Link_3
STVCLAS	TABLE	Link_3
STVCOLL	TABLE	Link_3
STVDEGC	TABLE	Link_3
STVEPRT	TABLE	Link_3
STVESTS	TABLE	Link_3
STVGMOD	TABLE	Link_3
STVLEVL	TABLE	Link_3
STVMAJR	TABLE	Link_3
STVPTRM	TABLE	Link_3
STVRSTS	TABLE	Link_3
STVSTYP	TABLE	Link_3
STVTERM	TABLE	Link_3
STVTMST	TABLE	Link_3
STVWDRL	TABLE	Link_3
TBBDETC	TABLE	Link_3

Comments

Model View

Table GTVSDAX

Schema Name GENERAL
Label GTVSDAX
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:08:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_REPORTING_DATE	GTVSDAX_REPORTING_DATE	DATE	Yes
GTVSDAX_TRANSLATION_CODE	GTVSDAX_TRANSLATION_CODE	VARCHAR2(15)	Yes
GTVSDAX_INTERNAL_CODE_SEQNO	GTVSDAX_INTERNAL_CODE_SEQNO	NUMBER(2,0)	Yes
GTVSDAX_INTERNAL_CODE_GROUP	GTVSDAX_INTERNAL_CODE_GROUP	VARCHAR2(20)	No
GTVSDAX_DESC	GTVSDAX_DESC	VARCHAR2(30)	No
GTVSDAX_SYSREQ_IND	GTVSDAX_SYSREQ_IND	VARCHAR2(1)	Yes
GTVSDAX_ACTIVITY_DATE	GTVSDAX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVSDAX_EXTERNAL_CODE	SSBSECT_SSTS_CODE	SSBSECT
GTVSDAX_INTERNAL_CODE	SORPCOL_SBGI_CODE	SORPCOL
GTVSDAX_INTERNAL_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
GTVSDAX_EXTERNAL_CODE	PERJTOT_EARN_CODE	PERJTOT
GTVSDAX_EXTERNAL_CODE	SRBRECR_LEVL_CODE	SRBRECR
GTVSDAX_EXTERNAL_CODE	SARADAP_LEVL_CODE	SARADAP
GTVSDAX_EXTERNAL_CODE	SFRRSTS_RSTS_CODE	SFRRSTS
GTVSDAX_EXTERNAL_CODE	SARAPPD_APDC_CODE	SARAPPD
GTVSDAX_EXTERNAL_CODE	SORBCHR_BCHR_CODE	SORBCHR
GTVSDAX_EXTERNAL_CODE	SORTEST_TESC_CODE	SORTEST

Index

Index Name	Index Type	Column Name
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_SEQNO

Comments

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (9)

Source Code Comments

The last activity date for this row of data

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	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 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
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
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 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
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	SFBSECT_FLVLR3	VARCHAR2(2)	Yes
SFBSECT_FLVLR4	SFBSECT_FLVLR4	VARCHAR2(2)	Yes
SFBSECT_FCLSCODE	SFBSECT_FCLSCODE	VARCHAR2(1)	Yes
SFBSECT_FCLSR1	SFBSECT_FCLSR1	VARCHAR2(2)	Yes
SFBSECT_FCLSR2	SFBSECT_FCLSR2	VARCHAR2(2)	Yes
SFBSECT_FCLSR3	SFBSECT_FCLSR3	VARCHAR2(2)	Yes
SFBSECT_FSPECIAL1	SFBSECT_FSPECIAL1	VARCHAR2(1)	Yes
SFBSECT_FSPECIAL2	SFBSECT_FSPECIAL2	VARCHAR2(1)	Yes
SFBSECT_FSPECIAL3	SFBSECT_FSPECIAL3	VARCHAR2(1)	Yes
SFBSECT_FSPECIAL4	SFBSECT_FSPECIAL4	VARCHAR2(1)	Yes
SFBSECT_FSPECIAL5	SFBSECT_FSPECIAL5	VARCHAR2(1)	Yes
SFBSECT_ACLIDEN	SFBSECT_ACLIDEN	VARCHAR2(2)	Yes
SFBSECT_FPGMR5	SFBSECT_FPGMR5	VARCHAR2(4)	Yes
SFBSECT_FPGMR6	SFBSECT_FPGMR6	VARCHAR2(4)	Yes
SFBSECT_FPGMR7	SFBSECT_FPGMR7	VARCHAR2(4)	Yes
SFBSECT_FPGMR8	SFBSECT_FPGMR8	VARCHAR2(4)	Yes
SFBSECT_FPGMR9	SFBSECT_FPGMR9	VARCHAR2(4)	Yes
SFBSECT_FPGMR10	SFBSECT_FPGMR10	VARCHAR2(4)	Yes
SFBSECT_FCMPCODE	SFBSECT_FCMPCODE	VARCHAR2(1)	Yes
SFBSECT_FCMPR1	SFBSECT_FCMPR1	VARCHAR2(3)	Yes
SFBSECT_FCMPR2	SFBSECT_FCMPR2	VARCHAR2(3)	Yes
SFBSECT_FCMPR3	SFBSECT_FCMPR3	VARCHAR2(3)	Yes
SFBSECT_FCMPR4	SFBSECT_FCMPR4	VARCHAR2(3)	Yes
SFBSECT_EPGMR5	SFBSECT_EPGMR5	VARCHAR2(4)	Yes
SFBSECT_EPGMR6	SFBSECT_EPGMR6	VARCHAR2(4)	Yes
SFBSECT_EPGMR7	SFBSECT_EPGMR7	VARCHAR2(4)	Yes
SFBSECT_EPGMR8	SFBSECT_EPGMR8	VARCHAR2(4)	Yes
SFBSECT_EPGMR9	SFBSECT_EPGMR9	VARCHAR2(4)	Yes
SFBSECT_EPGMR10	SFBSECT_EPGMR10	VARCHAR2(4)	Yes
SFBSECT_ECMPR1	SFBSECT_ECMPR1	VARCHAR2(3)	Yes
SFBSECT_ECMPR2	SFBSECT_ECMPR2	VARCHAR2(3)	Yes
SFBSECT_ECMPR3	SFBSECT_ECMPR3	VARCHAR2(3)	Yes
SFBSECT_ECMPR4	SFBSECT_ECMPR4	VARCHAR2(3)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SFBSECT_CRN_INDEX	Unique	SFBSECT_ACRNUM
SFBSECT_FCN_INDEX	Unique	SFBSECT_TERM
SFBSECT_FCN_INDEX	Unique	SFBSECT_SUBJ
SFBSECT_FCN_INDEX	Unique	SFBSECT_CRSE
SFBSECT_FCN_INDEX	Unique	SFBSECT_IDENT
SFBSECT_FCN_INDEX	Unique	SFBSECT_KCRNUM
SFBSECT_FCN_INDEX	Unique	SFBSECT_SECT9
SFBSECT_INX_INDEX	Unique	SFBSECT_AINDX