Model General Student

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

List of Objects

Object Name	Object Type	Layer Name
SGBEOPS	TABLE	Default
SGBOEDU	TABLE	Default
SGBSTDN	TABLE	Default
SGBUSER	TABLE	Default
SGRACMT	TABLE	Default
SGRADVR	TABLE	Default
SGRASSI	TABLE	Default
SGRASST	TABLE	Default
SGRCATT	TABLE	Default
SGRCHRT	TABLE	Default
SGRCLSR	TABLE	Default
SGRCMNT	TABLE	Default
SGRCOLR	TABLE	Default
SGRCOOP	TABLE	Default
SGRDISA	TABLE	Default
SGRDSER	TABLE	Default
SGRDUTY	TABLE	Default
SGRESEL	TABLE	Default
SGRSACT	TABLE	Default
SGRSATT	TABLE	Default
SGRSCMT	TABLE	Default
SGRSPRT	TABLE	Default
SGRVETN	TABLE	Default

Comments

Model View

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

Columns Comments for SGBEOPS_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Columns Comments for SGBEOPS_TRAC_CODE (7)

Source Code Comments

EOPS Acceptance Period Code

Columns Comments for SGBEOPS_PLANNED_CREDITS (8)

Source Code Comments

EOPS Number of units the student plans to enroll in for the reporting term.

Columns Comments for SGBEOPS_WTHD_CODE (9)

Source Code Comments

Withdrawal Reason.

Table SGBOEDU

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SGBOEDU_PIDM	SGBOEDU_PIDM	NUMBER(8,0)	No
SGBOEDU_TERM_CODE_EFF	SGBOEDU_TERM_CODE_EFF	VARCHAR2(6)	No	*
SGBOEDU_EOPS_CODE	SGBOEDU_EOPS_CODE	VARCHAR2(2)	Yes	*
SGBOEDU_SFAE_CODE	SGBOEDU_SFAE_CODE	VARCHAR2(2)	Yes	*
SGBOEDU_ACCEPT_DATE	SGBOEDU_ACCEPT_DATE	DATE	Yes
SGBOEDU_TRAC_CODE	SGBOEDU_TRAC_CODE	VARCHAR2(3)	Yes
SGBOEDU_PLANNED_CREDITS	SGBOEDU_PLANNED_CREDITS	NUMBER(9,3)	Yes
SGBOEDU_ACTIVITY_DATE	SGBOEDU_ACTIVITY_DATE	DATE	No
SGBOEDU_MARS_CODE	SGBOEDU_MARS_CODE	VARCHAR2(1)	Yes	*
SGBOEDU_DEPS_CODE	SGBOEDU_DEPS_CODE	VARCHAR2(1)	Yes	*
SGBOEDU_AFDC_CODE	SGBOEDU_AFDC_CODE	VARCHAR2(1)	Yes	*
SGBOEDU_WTHD_CODE	SGBOEDU_WTHD_CODE	VARCHAR2(1)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBOEDU_EOPS_CODE	STVEOPS_CODE	STVEOPS
SGBOEDU_SFAE_CODE	STVSFAE_CODE	STVSFAE
SGBOEDU_AFDC_CODE	STVAFDC_CODE	STVAFDC
SGBOEDU_MARS_CODE	STVMARS_CODE	STVMARS
SGBOEDU_DEPS_CODE	STVDEPS_CODE	STVDEPS
SGBOEDU_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SGBOEDU_WTHD_CODE	STVWTHD_CODE	STVWTHD

Index

Index Name	Index Type	Column Name
SGBOEDU_KEY_INDEX	Unique	SGBOEDU_PIDM
SGBOEDU_KEY_INDEX	Unique	SGBOEDU_TERM_CODE_EFF
SGBOEDU_KEY_INDEX	Unique	SGBOEDU_EOPS_CODE

Comments

Source Code Comments

Student Other Educational Programs Table

Columns Comments for SGBOEDU_PIDM (1)

Source Code Comments

Person Internal Identification Number

Columns Comments for SGBOEDU_TERM_CODE_EFF (2)

Source Code Comments

Effective Term Code

Columns Comments for SGBOEDU_EOPS_CODE (3)

Source Code Comments

Educational Opportunity Program Code

Columns Comments for SGBOEDU_SFAE_CODE (4)

Source Code Comments

State Financial Aid Eligibility Code

Columns Comments for SGBOEDU_ACCEPT_DATE (5)

Source Code Comments

Acceptance Date

Columns Comments for SGBOEDU_TRAC_CODE (6)

Source Code Comments

Period of Acceptance Code.

Columns Comments for SGBOEDU_PLANNED_CREDITS (7)

Source Code Comments

Number of units the student plans to enroll in for the reporting term.

Columns Comments for SGBOEDU_ACTIVITY_DATE (8)

Source Code Comments

The Activity Date

Columns Comments for SGBOEDU_MARS_CODE (9)

Source Code Comments

CARE Student Marital Status.

Columns Comments for SGBOEDU_DEPS_CODE (10)

Source Code Comments

CARE Student Number of Dependents.

Columns Comments for SGBOEDU_AFDC_CODE (11)

Source Code Comments

CARE Student Time on AFDC.

Columns Comments for SGBOEDU_WTHD_CODE (12)

Source Code Comments

CARE Withdrawal Reason.

Table SGBSTDN

Schema Name SATURN
Label SGBSTDN
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:07:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGBSTDN_PIDM	SGBSTDN_PIDM	NUMBER(8,0)	No	*	*
SGBSTDN_PIDM	SGBSTDN_PIDM	NUMBER(8,0)	No	*	*
SGBSTDN_PIDM	SGBSTDN_PIDM	NUMBER(8,0)	No	*	*
SGBSTDN_PIDM	SGBSTDN_PIDM	NUMBER(8,0)	No	*	*
SGBSTDN_PIDM	SGBSTDN_PIDM	NUMBER(8,0)	No	*	*
SGBSTDN_TERM_CODE_EFF	SGBSTDN_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SGBSTDN_STST_CODE	SGBSTDN_STST_CODE	VARCHAR2(2)	No		*
SGBSTDN_LEVL_CODE	SGBSTDN_LEVL_CODE	VARCHAR2(2)	No		*
SGBSTDN_STYP_CODE	SGBSTDN_STYP_CODE	VARCHAR2(1)	No		*
SGBSTDN_TERM_CODE_MATRIC	SGBSTDN_TERM_CODE_MATRIC	VARCHAR2(6)	Yes		*
SGBSTDN_TERM_CODE_ADMIT	SGBSTDN_TERM_CODE_ADMIT	VARCHAR2(6)	Yes		*
SGBSTDN_EXP_GRAD_DATE	SGBSTDN_EXP_GRAD_DATE	DATE	Yes
SGBSTDN_CAMP_CODE	SGBSTDN_CAMP_CODE	VARCHAR2(3)	Yes		*
SGBSTDN_FULL_PART_IND	SGBSTDN_FULL_PART_IND	VARCHAR2(1)	Yes
SGBSTDN_SESS_CODE	SGBSTDN_SESS_CODE	VARCHAR2(1)	Yes		*
SGBSTDN_RESD_CODE	SGBSTDN_RESD_CODE	VARCHAR2(1)	Yes		*
SGBSTDN_COLL_CODE_1	SGBSTDN_COLL_CODE_1	VARCHAR2(2)	No		*
SGBSTDN_DEGC_CODE_1	SGBSTDN_DEGC_CODE_1	VARCHAR2(6)	No		*
SGBSTDN_MAJR_CODE_1	SGBSTDN_MAJR_CODE_1	VARCHAR2(4)	No		*
SGBSTDN_MAJR_CODE_MINR_1	SGBSTDN_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_MINR_1_2	SGBSTDN_MAJR_CODE_MINR_1_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_1	SGBSTDN_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_1_2	SGBSTDN_MAJR_CODE_CONC_1_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_1_3	SGBSTDN_MAJR_CODE_CONC_1_3	VARCHAR2(4)	Yes		*
SGBSTDN_COLL_CODE_2	SGBSTDN_COLL_CODE_2	VARCHAR2(2)	Yes		*
SGBSTDN_DEGC_CODE_2	SGBSTDN_DEGC_CODE_2	VARCHAR2(6)	Yes		*
SGBSTDN_MAJR_CODE_2	SGBSTDN_MAJR_CODE_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_MINR_2	SGBSTDN_MAJR_CODE_MINR_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_MINR_2_2	SGBSTDN_MAJR_CODE_MINR_2_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_2	SGBSTDN_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_2_2	SGBSTDN_MAJR_CODE_CONC_2_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_2_3	SGBSTDN_MAJR_CODE_CONC_2_3	VARCHAR2(4)	Yes		*
SGBSTDN_ORSN_CODE	SGBSTDN_ORSN_CODE	VARCHAR2(1)	Yes		*
SGBSTDN_PRAC_CODE	SGBSTDN_PRAC_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_ADVR_PIDM	SGBSTDN_ADVR_PIDM	NUMBER(8,0)	Yes
SGBSTDN_GRAD_CREDIT_APPR_IND	SGBSTDN_GRAD_CREDIT_APPR_IND	VARCHAR2(1)	Yes
SGBSTDN_CAPL_CODE	SGBSTDN_CAPL_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_LEAV_CODE	SGBSTDN_LEAV_CODE	VARCHAR2(1)	Yes		*
SGBSTDN_LEAV_FROM_DATE	SGBSTDN_LEAV_FROM_DATE	DATE	Yes
SGBSTDN_LEAV_TO_DATE	SGBSTDN_LEAV_TO_DATE	DATE	Yes
SGBSTDN_ASTD_CODE	SGBSTDN_ASTD_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_TERM_CODE_ASTD	SGBSTDN_TERM_CODE_ASTD	VARCHAR2(6)	Yes		*
SGBSTDN_RATE_CODE	SGBSTDN_RATE_CODE	VARCHAR2(5)	Yes		*
SGBSTDN_ACTIVITY_DATE	SGBSTDN_ACTIVITY_DATE	DATE	No
SGBSTDN_MAJR_CODE_1_2	SGBSTDN_MAJR_CODE_1_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_2_2	SGBSTDN_MAJR_CODE_2_2	VARCHAR2(4)	Yes		*
SGBSTDN_EDLV_CODE	SGBSTDN_EDLV_CODE	VARCHAR2(3)	Yes		*
SGBSTDN_INCM_CODE	SGBSTDN_INCM_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_ADMT_CODE	SGBSTDN_ADMT_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_EMEX_CODE	SGBSTDN_EMEX_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_APRN_CODE	SGBSTDN_APRN_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_TRCN_CODE	SGBSTDN_TRCN_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_GAIN_CODE	SGBSTDN_GAIN_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_VOED_CODE	SGBSTDN_VOED_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_BLCK_CODE	SGBSTDN_BLCK_CODE	VARCHAR2(10)	Yes		*
SGBSTDN_TERM_CODE_GRAD	SGBSTDN_TERM_CODE_GRAD	VARCHAR2(6)	Yes		*
SGBSTDN_ACYR_CODE	SGBSTDN_ACYR_CODE	VARCHAR2(4)	Yes		*
SGBSTDN_DEPT_CODE	SGBSTDN_DEPT_CODE	VARCHAR2(4)	Yes		*
SGBSTDN_SITE_CODE	SGBSTDN_SITE_CODE	VARCHAR2(3)	Yes		*
SGBSTDN_DEPT_CODE_2	SGBSTDN_DEPT_CODE_2	VARCHAR2(4)	Yes		*
SGBSTDN_EGOL_CODE	SGBSTDN_EGOL_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_DEGC_CODE_DUAL	SGBSTDN_DEGC_CODE_DUAL	VARCHAR2(6)	Yes		*
SGBSTDN_LEVL_CODE_DUAL	SGBSTDN_LEVL_CODE_DUAL	VARCHAR2(2)	Yes		*
SGBSTDN_DEPT_CODE_DUAL	SGBSTDN_DEPT_CODE_DUAL	VARCHAR2(4)	Yes		*
SGBSTDN_COLL_CODE_DUAL	SGBSTDN_COLL_CODE_DUAL	VARCHAR2(2)	Yes		*
SGBSTDN_MAJR_CODE_DUAL	SGBSTDN_MAJR_CODE_DUAL	VARCHAR2(4)	Yes		*
SGBSTDN_BSKL_CODE	SGBSTDN_BSKL_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_PRIM_ROLL_IND	SGBSTDN_PRIM_ROLL_IND	VARCHAR2(1)	No
SGBSTDN_PROGRAM_1	SGBSTDN_PROGRAM_1	VARCHAR2(12)	Yes		*
SGBSTDN_TERM_CODE_CTLG_1	SGBSTDN_TERM_CODE_CTLG_1	VARCHAR2(6)	Yes		*
SGBSTDN_DEPT_CODE_1_2	SGBSTDN_DEPT_CODE_1_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_121	SGBSTDN_MAJR_CODE_CONC_121	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_122	SGBSTDN_MAJR_CODE_CONC_122	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_123	SGBSTDN_MAJR_CODE_CONC_123	VARCHAR2(4)	Yes		*
SGBSTDN_SECD_ROLL_IND	SGBSTDN_SECD_ROLL_IND	VARCHAR2(1)	No
SGBSTDN_TERM_CODE_ADMIT_2	SGBSTDN_TERM_CODE_ADMIT_2	VARCHAR2(6)	Yes		*
SGBSTDN_ADMT_CODE_2	SGBSTDN_ADMT_CODE_2	VARCHAR2(2)	Yes		*
SGBSTDN_PROGRAM_2	SGBSTDN_PROGRAM_2	VARCHAR2(12)	Yes		*
SGBSTDN_TERM_CODE_CTLG_2	SGBSTDN_TERM_CODE_CTLG_2	VARCHAR2(6)	Yes		*
SGBSTDN_LEVL_CODE_2	SGBSTDN_LEVL_CODE_2	VARCHAR2(2)	Yes		*
SGBSTDN_CAMP_CODE_2	SGBSTDN_CAMP_CODE_2	VARCHAR2(3)	Yes		*
SGBSTDN_DEPT_CODE_2_2	SGBSTDN_DEPT_CODE_2_2	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_221	SGBSTDN_MAJR_CODE_CONC_221	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_222	SGBSTDN_MAJR_CODE_CONC_222	VARCHAR2(4)	Yes		*
SGBSTDN_MAJR_CODE_CONC_223	SGBSTDN_MAJR_CODE_CONC_223	VARCHAR2(4)	Yes		*
SGBSTDN_CURR_RULE_1	SGBSTDN_CURR_RULE_1	NUMBER(8,0)	Yes		*
SGBSTDN_CMJR_RULE_1_1	SGBSTDN_CMJR_RULE_1_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_11_1	SGBSTDN_CCON_RULE_11_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_11_2	SGBSTDN_CCON_RULE_11_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_11_3	SGBSTDN_CCON_RULE_11_3	NUMBER(8,0)	Yes		*
SGBSTDN_CMJR_RULE_1_2	SGBSTDN_CMJR_RULE_1_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_12_1	SGBSTDN_CCON_RULE_12_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_12_2	SGBSTDN_CCON_RULE_12_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_12_3	SGBSTDN_CCON_RULE_12_3	NUMBER(8,0)	Yes		*
SGBSTDN_CMNR_RULE_1_1	SGBSTDN_CMNR_RULE_1_1	NUMBER(8,0)	Yes		*
SGBSTDN_CMNR_RULE_1_2	SGBSTDN_CMNR_RULE_1_2	NUMBER(8,0)	Yes		*
SGBSTDN_CURR_RULE_2	SGBSTDN_CURR_RULE_2	NUMBER(8,0)	Yes		*
SGBSTDN_CMJR_RULE_2_1	SGBSTDN_CMJR_RULE_2_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_21_1	SGBSTDN_CCON_RULE_21_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_21_2	SGBSTDN_CCON_RULE_21_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_21_3	SGBSTDN_CCON_RULE_21_3	NUMBER(8,0)	Yes		*
SGBSTDN_CMJR_RULE_2_2	SGBSTDN_CMJR_RULE_2_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_22_1	SGBSTDN_CCON_RULE_22_1	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_22_2	SGBSTDN_CCON_RULE_22_2	NUMBER(8,0)	Yes		*
SGBSTDN_CCON_RULE_22_3	SGBSTDN_CCON_RULE_22_3	NUMBER(8,0)	Yes		*
SGBSTDN_CMNR_RULE_2_1	SGBSTDN_CMNR_RULE_2_1	NUMBER(8,0)	Yes		*
SGBSTDN_CMNR_RULE_2_2	SGBSTDN_CMNR_RULE_2_2	NUMBER(8,0)	Yes		*
SGBSTDN_PREV_CODE	SGBSTDN_PREV_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_TERM_CODE_PREV	SGBSTDN_TERM_CODE_PREV	VARCHAR2(6)	Yes		*
SGBSTDN_CAST_CODE	SGBSTDN_CAST_CODE	VARCHAR2(2)	Yes		*
SGBSTDN_TERM_CODE_CAST	SGBSTDN_TERM_CODE_CAST	VARCHAR2(6)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBSTDN_ACYR_CODE	STVACYR_CODE	STVACYR
SGBSTDN_ASTD_CODE	STVASTD_CODE	STVASTD
SGBSTDN_EGOL_CODE	STVEGOL_CODE	STVEGOL
SGBSTDN_EMEX_CODE	STVEMEX_CODE	STVEMEX
SGBSTDN_GAIN_CODE	STVGAIN_CODE	STVGAIN
SGBSTDN_RATE_CODE	STVRATE_CODE	STVRATE
SGBSTDN_RESD_CODE	STVRESD_CODE	STVRESD
SGBSTDN_SESS_CODE	STVSESS_CODE	STVSESS
SGBSTDN_STST_CODE	STVSTST_CODE	STVSTST
SGBSTDN_STYP_CODE	STVSTYP_CODE	STVSTYP
SGBSTDN_TRCN_CODE	STVTRCN_CODE	STVTRCN
SGBSTDN_ORSN_CODE	STVORSN_CODE	STVORSN
SGBSTDN_LEAV_CODE	STVLEAV_CODE	STVLEAV
SGBSTDN_BSKL_CODE	STVBSKL_CODE	STVBSKL
SGBSTDN_CAPL_CODE	STVCAPL_CODE	STVCAPL
SGBSTDN_INCM_CODE	STVINCM_CODE	STVINCM
SGBSTDN_CAST_CODE	STVCAST_CODE	STVCAST
SGBSTDN_BLCK_CODE	STVBLCK_CODE	STVBLCK
SGBSTDN_EDLV_CODE	STVEDLV_CODE	STVEDLV
SGBSTDN_VOED_CODE	STVVOED_CODE	STVVOED
SGBSTDN_APRN_CODE	STVAPRN_CODE	STVAPRN
SGBSTDN_PRAC_CODE	STVPRAC_CODE	STVPRAC
SGBSTDN_PREV_CODE	STVPREV_CODE	STVPREV
SGBSTDN_SITE_CODE	STVSITE_CODE	STVSITE
SGBSTDN_PIDM	SHRTTRM_PIDM	SHRTTRM
SGBSTDN_PIDM	TBRACCD_PIDM	TBRACCD
SGBSTDN_PIDM	SFRSTCR_PIDM	SFRSTCR
SGBSTDN_PIDM	SFRAREG_PIDM	SFRAREG
SGBSTDN_PIDM	SFBETRM_PIDM	SFBETRM

Index

Index Name	Index Type	Column Name
PK_SGBSTDN	Unique	SGBSTDN_PIDM
PK_SGBSTDN	Unique	SGBSTDN_TERM_CODE_EFF

Comments

Source Code Comments

Student Base Table

Columns Comments for SGBSTDN_PIDM (1)

Source Code Comments

This field identifies the internal identification number of student.

Columns Comments for SGBSTDN_TERM_CODE_EFF (2)

Source Code Comments

This field identifies the effective term associated with student record.

Columns Comments for SGBSTDN_STST_CODE (3)

Source Code Comments

This field identifies the students status for the effective term.

Columns Comments for SGBSTDN_LEVL_CODE (4)

Source Code Comments

This field identifies the level of the student for the effective term.

Columns Comments for SGBSTDN_STYP_CODE (5)

Source Code Comments

This field identifies the student type for the effective term.

Columns Comments for SGBSTDN_TERM_CODE_MATRIC (6)

Source Code Comments

This field identifies the effective term of matriculation.

Columns Comments for SGBSTDN_TERM_CODE_ADMIT (7)

Source Code Comments

This field identifies the term student was first admitted to institution.

Columns Comments for SGBSTDN_EXP_GRAD_DATE (8)

Source Code Comments

This field identifies expected graduation date.

Columns Comments for SGBSTDN_CAMP_CODE (9)

Source Code Comments

This field identifies the campus location associated with the student for the effective term.

Columns Comments for SGBSTDN_FULL_PART_IND (10)

Source Code Comments

This field identifies whether the student is a full or part-time student.

Columns Comments for SGBSTDN_SESS_CODE (11)

Source Code Comments

This field identifies the session student is attending for the effective term.

Columns Comments for SGBSTDN_RESD_CODE (12)

Source Code Comments

This field identifies the residency status of the student for the effective term.

Columns Comments for SGBSTDN_COLL_CODE_1 (13)

Source Code Comments

This field identifies the college associated with the primary curriculum for the effective term..

Columns Comments for SGBSTDN_DEGC_CODE_1 (14)

Source Code Comments

This field identifies the degree within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_1 (15)

Source Code Comments

This field identifies the primary major within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_1 (16)

Source Code Comments

This field identifies the primary minor within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_1_2 (17)

Source Code Comments

This field identifies the secondary minor of the student for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1 (18)

Source Code Comments

This field identifies the primary concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1_2 (19)

Source Code Comments

This field identifies the secondary concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_1_3 (20)

Source Code Comments

This field identifies the third concentration within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_COLL_CODE_2 (21)

Source Code Comments

This field identifies the college within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_DEGC_CODE_2 (22)

Source Code Comments

This field identifies the degree within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_2 (23)

Source Code Comments

This field identifies the primary major within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_2 (24)

Source Code Comments

This field identifies the primary minor within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_MINR_2_2 (25)

Source Code Comments

This field identifies the secondary minor within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2 (26)

Source Code Comments

This field identifies the primary concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2_2 (27)

Source Code Comments

This field identifies the secondary concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_CONC_2_3 (28)

Source Code Comments

This field identifies the third concentration within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_ORSN_CODE (29)

Source Code Comments

This field identifies the orientation session assigned to the student for the effective term.

Columns Comments for SGBSTDN_PRAC_CODE (30)

Source Code Comments

This field identifies the practical training experience of the student for the effective term.

Columns Comments for SGBSTDN_ADVR_PIDM (31)

Source Code Comments

This field identifies the internal identification number for the advisor assigned to the student for the effective term.

Columns Comments for SGBSTDN_GRAD_CREDIT_APPR_IND (32)

Source Code Comments

This field identifies eligibility of student to take graduate courses for credit for the effective term. Valid values are Y or blank only.

Columns Comments for SGBSTDN_CAPL_CODE (33)

Source Code Comments

This field identifies career plan of the student for the effective term.

Columns Comments for SGBSTDN_LEAV_CODE (34)

Source Code Comments

This field identifies reason of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_LEAV_FROM_DATE (35)

Source Code Comments

This field identifies the begin date of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_LEAV_TO_DATE (36)

Source Code Comments

This field identifies the end date of leave of absence of student for the effective term.

Columns Comments for SGBSTDN_ASTD_CODE (37)

Source Code Comments

This field identifies the academic standing override for a student for the effective term.

Columns Comments for SGBSTDN_TERM_CODE_ASTD (38)

Source Code Comments

This field identifies the term associated with the academic standing override.

Columns Comments for SGBSTDN_RATE_CODE (39)

Source Code Comments

This field identifies a specific assessment rate of the student for the effective term.

Columns Comments for SGBSTDN_ACTIVITY_DATE (40)

Source Code Comments

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

Columns Comments for SGBSTDN_MAJR_CODE_1_2 (41)

Source Code Comments

This field identifies the secondary major within the primary curriculum for the effective term.

Columns Comments for SGBSTDN_MAJR_CODE_2_2 (42)

Source Code Comments

This field identifies the secondary major within the secondary curriculum for the effective term.

Columns Comments for SGBSTDN_EDLV_CODE (43)

Source Code Comments

A two position alphanumeric field which indicate the highest level of the education that the student completed

Columns Comments for SGBSTDN_INCM_CODE (44)

Source Code Comments

A two position alphanumeric field which indicate the income range of the student

Columns Comments for SGBSTDN_ADMT_CODE (45)

Source Code Comments

Admissions type from the admissions application

Columns Comments for SGBSTDN_EMEX_CODE (46)

Source Code Comments

General Student Employment Expectation Code

Columns Comments for SGBSTDN_APRN_CODE (47)

Source Code Comments

General Student Apprenticeship Code

Columns Comments for SGBSTDN_TRCN_CODE (48)

Source Code Comments

General Student Transfer Center Code

Columns Comments for SGBSTDN_GAIN_CODE (49)

Source Code Comments

This field identifies the employment and training code of the student for the effective term.

Columns Comments for SGBSTDN_VOED_CODE (50)

Source Code Comments

General Student Vocation Eduaction Status Code

Columns Comments for SGBSTDN_BLCK_CODE (51)

Source Code Comments

Block Schedule Code

Columns Comments for SGBSTDN_TERM_CODE_GRAD (52)

Source Code Comments

Term student intends to graduate.

Columns Comments for SGBSTDN_ACYR_CODE (53)

Source Code Comments

Year student intends to graduate.

Columns Comments for SGBSTDN_DEPT_CODE (54)

Source Code Comments

Department Code.

Columns Comments for SGBSTDN_SITE_CODE (55)

Source Code Comments

Site Code.

Columns Comments for SGBSTDN_DEPT_CODE_2 (56)

Source Code Comments

Department Code for second curriculum.

Columns Comments for SGBSTDN_EGOL_CODE (57)

Source Code Comments

Educational Goal code.

Columns Comments for SGBSTDN_BSKL_CODE (63)

Source Code Comments

Student Basic Skills Code

Columns Comments for SGBSTDN_PRIM_ROLL_IND (64)

Source Code Comments

Indicates whether the Primary Curriculum should be Rolled to Academic History

Columns Comments for SGBSTDN_PROGRAM_1 (65)

Source Code Comments

Curriculum 1 Program Code

Columns Comments for SGBSTDN_TERM_CODE_CTLG_1 (66)

Source Code Comments

Curriculum 1 Catalog Term Code

Columns Comments for SGBSTDN_DEPT_CODE_1_2 (67)

Source Code Comments

Curriculum 1 - Department 2

Columns Comments for SGBSTDN_MAJR_CODE_CONC_121 (68)

Source Code Comments

Concentration Code 1 on Second Major of First Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_122 (69)

Source Code Comments

Concentration Code 2 on Second Major on First Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_123 (70)

Source Code Comments

Concentration Code 3 on Second Major on First Curriculum

Columns Comments for SGBSTDN_SECD_ROLL_IND (71)

Source Code Comments

Indicates whether the Secondary Curriculum should be Rolled to Academic History

Columns Comments for SGBSTDN_TERM_CODE_ADMIT_2 (72)

Source Code Comments

Admission Term Code associated with the Secondary Curriculum

Columns Comments for SGBSTDN_ADMT_CODE_2 (73)

Source Code Comments

Admissions Type Code associated with the Secondary Curriculum

Columns Comments for SGBSTDN_PROGRAM_2 (74)

Source Code Comments

Curriculum 2 Program Code

Columns Comments for SGBSTDN_TERM_CODE_CTLG_2 (75)

Source Code Comments

Curriculum 2 Catalog Term Code

Columns Comments for SGBSTDN_LEVL_CODE_2 (76)

Source Code Comments

Curriculum 2 Level Code

Columns Comments for SGBSTDN_CAMP_CODE_2 (77)

Source Code Comments

Curriculum 2 Campus Code

Columns Comments for SGBSTDN_DEPT_CODE_2_2 (78)

Source Code Comments

Curriculum 2 - Department 2

Columns Comments for SGBSTDN_MAJR_CODE_CONC_221 (79)

Source Code Comments

Concentration 1 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_222 (80)

Source Code Comments

Concentration 2 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_MAJR_CODE_CONC_223 (81)

Source Code Comments

Concentration 3 on Second Major of Second Curriculum

Columns Comments for SGBSTDN_CURR_RULE_1 (82)

Source Code Comments

Curriculum 1 Rule reference

Columns Comments for SGBSTDN_CMJR_RULE_1_1 (83)

Source Code Comments

Curriculum 1 Major 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_1 (84)

Source Code Comments

Concentration 1, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_2 (85)

Source Code Comments

Concentration 2, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_11_3 (86)

Source Code Comments

Concentration 3, Major 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_1_2 (87)

Source Code Comments

Major 2, Curriculum Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_1 (88)

Source Code Comments

Concentration 1, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_2 (89)

Source Code Comments

Concentration 2, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_12_3 (90)

Source Code Comments

Concentration 3, Major 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_1_1 (91)

Source Code Comments

Minor 1, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_1_2 (92)

Source Code Comments

Minor 2, Curriculum 1 Rule Reference

Columns Comments for SGBSTDN_CURR_RULE_2 (93)

Source Code Comments

Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_2_1 (94)

Source Code Comments

Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_1 (95)

Source Code Comments

Concentration 1, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_2 (96)

Source Code Comments

Concentration 2, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_21_3 (97)

Source Code Comments

Concentration 3, Major 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMJR_RULE_2_2 (98)

Source Code Comments

Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_1 (99)

Source Code Comments

Concentration 1, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_2 (100)

Source Code Comments

Concentration 2, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CCON_RULE_22_3 (101)

Source Code Comments

Concentration 3, Major 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_2_1 (102)

Source Code Comments

Minor 1, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_CMNR_RULE_2_2 (103)

Source Code Comments

Minor 2, Curriculum 2 Rule Reference

Columns Comments for SGBSTDN_PREV_CODE (104)

Source Code Comments

General Student record Progress Evaluation code. This code overrides the code in SHRTTRM.

Columns Comments for SGBSTDN_TERM_CODE_PREV (105)

Source Code Comments

General Student record Progress Evaluation term. This is the term for which the progress evaluation code override becomes effective.

Columns Comments for SGBSTDN_CAST_CODE (106)

Source Code Comments

General Student record Combined Academic Standing code. This code overrides the code in SHRTTRM.

Columns Comments for SGBSTDN_TERM_CODE_CAST (107)

Source Code Comments

General Student record Combined Academic Standing term. This is the term for which the combined academic standing code override becomes effective.

Table SGBUSER

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGBUSER_PIDM	SGBUSER_PIDM	NUMBER(8,0)	No	*
SGBUSER_TERM_CODE	SGBUSER_TERM_CODE	VARCHAR2(6)	No	*	*
SGBUSER_SUDA_CODE	SGBUSER_SUDA_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDB_CODE	SGBUSER_SUDB_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDC_CODE	SGBUSER_SUDC_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDD_CODE	SGBUSER_SUDD_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDE_CODE	SGBUSER_SUDE_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDF_CODE	SGBUSER_SUDF_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDG_CODE	SGBUSER_SUDG_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDH_CODE	SGBUSER_SUDH_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDI_CODE	SGBUSER_SUDI_CODE	VARCHAR2(15)	Yes		*
SGBUSER_SUDJ_CODE	SGBUSER_SUDJ_CODE	VARCHAR2(15)	Yes		*
SGBUSER_ACTIVITY_DATE	SGBUSER_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGBUSER_SUDA_CODE	STVSUDA_CODE	STVSUDA
SGBUSER_SUDB_CODE	STVSUDB_CODE	STVSUDB
SGBUSER_SUDC_CODE	STVSUDC_CODE	STVSUDC
SGBUSER_SUDD_CODE	STVSUDD_CODE	STVSUDD
SGBUSER_SUDE_CODE	STVSUDE_CODE	STVSUDE
SGBUSER_SUDF_CODE	STVSUDF_CODE	STVSUDF
SGBUSER_SUDG_CODE	STVSUDG_CODE	STVSUDG
SGBUSER_SUDH_CODE	STVSUDH_CODE	STVSUDH
SGBUSER_SUDI_CODE	STVSUDI_CODE	STVSUDI
SGBUSER_SUDJ_CODE