Model STVMAJR

Model Label : ERD for Banner Student STVMAJR Table

Path : BANNER DEV/Student/Common/STVMAJR/STVMAJR_ERD

List of Objects

Object Name	Object Type	Layer Name
APRAMAJ	TABLE	Default
PARPMAJ	TABLE	Default
SARCHKB	TABLE	Default
SARQKER	TABLE	Default
SARRRFT	TABLE	Default
SCRRMAJ	TABLE	Default
SDRPCNC	TABLE	Default
SDRPMJR	TABLE	Default
SDRPMNR	TABLE	Default
SFRRGFE	TABLE	Default
SFRTMSL	TABLE	Default
SFRTMST	TABLE	Default
SGRASSI	TABLE	Default
SGRCOLR	TABLE	Default
SHRPREV	TABLE	Default
SMRIECC	TABLE	Default
SMRIEMJ	TABLE	Default
SMRIEMN	TABLE	Default
SORCCON	TABLE	Default
SORCMJR	TABLE	Default
SORCMNR	TABLE	Default
SORCOMM	TABLE	Default
SORCONC	TABLE	Default
SORMAJR	TABLE	Default
SORMINR	TABLE	Default
SORMMJR	TABLE	Default
SRBPRED	TABLE	Default
SSRRESV	TABLE	Default
SSRRMAJ	TABLE	Default
STVCIPC	TABLE	Default
STVMAJR	TABLE	Default
TBRIAMJ	TABLE	Default

Comments

Model View

Table APRAMAJ

Schema Name ALUMNI
Label APRAMAJ
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:05:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APRAMAJ_PIDM	APRAMAJ_PIDM	NUMBER(8,0)	No	*	*
APRAMAJ_PIDM	APRAMAJ_PIDM	NUMBER(8,0)	No	*	*
APRAMAJ_ADEG_SEQ_NO	APRAMAJ_ADEG_SEQ_NO	NUMBER(5,0)	No	*	*
APRAMAJ_MAJR_CODE	APRAMAJ_MAJR_CODE	VARCHAR2(4)	No	*	*
APRAMAJ_ACTIVITY_DATE	APRAMAJ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRAMAJ_PIDM	APRADEG_PIDM	APRADEG
APRAMAJ_ADEG_SEQ_NO	APRADEG_SEQ_NO	APRADEG
APRAMAJ_MAJR_CODE	STVMAJR_CODE	STVMAJR
APRAMAJ_PIDM	APRACYR_PIDM	APRACYR

Index

Index Name	Index Type	Column Name
PK_APRAMAJ	Unique	APRAMAJ_PIDM
PK_APRAMAJ	Unique	APRAMAJ_ADEG_SEQ_NO
PK_APRAMAJ	Unique	APRAMAJ_MAJR_CODE

Comments

Source Code Comments

Academic Major Repeating Table

Columns Comments for APRAMAJ_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRAMAJ_ADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRAMAJ_MAJR_CODE (3)

Source Code Comments

This field specifies the constituents major area(s) of study.

Columns Comments for APRAMAJ_ACTIVITY_DATE (4)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Table PARPMAJ

Schema Name PAYROLL
Label PARPMAJ
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:45:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PARPMAJ_POSN	PARPMAJ_POSN	VARCHAR2(6)	No	*	*
PARPMAJ_DEGC_CODE	PARPMAJ_DEGC_CODE	VARCHAR2(6)	No	*	*
PARPMAJ_MAJR_CODE	PARPMAJ_MAJR_CODE	VARCHAR2(4)	No	*	*
PARPMAJ_MAJR_REQR_IND	PARPMAJ_MAJR_REQR_IND	VARCHAR2(1)	No
PARPMAJ_ACTIVITY_DATE	PARPMAJ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PARPMAJ_POSN	NBBPOSN_POSN	NBBPOSN
PARPMAJ_MAJR_CODE	STVMAJR_CODE	STVMAJR
PARPMAJ_DEGC_CODE	STVDEGC_CODE	STVDEGC

Index

Index Name	Index Type	Column Name
PK_PARPMAJ	Unique	PARPMAJ_POSN
PK_PARPMAJ	Unique	PARPMAJ_DEGC_CODE
PK_PARPMAJ	Unique	PARPMAJ_MAJR_CODE

Comments

Source Code Comments

Position Major Table

Columns Comments for PARPMAJ_POSN (1)

Source Code Comments

POSITION NUMBER: Position number associated with this degree/major combination.

Columns Comments for PARPMAJ_DEGC_CODE (2)

Source Code Comments

DEGREE CODE: Degree code required for this position.

Columns Comments for PARPMAJ_MAJR_CODE (3)

Source Code Comments

MAJOR CODE: Major code required for this position and degree.

Columns Comments for PARPMAJ_MAJR_REQR_IND (4)

Source Code Comments

REQUIRED/OPTIONAL IND: Indicates if the Major is required or optional.

Columns Comments for PARPMAJ_ACTIVITY_DATE (5)

Source Code Comments

Date of Last Modification of the Record.

Table SARCHKB

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SARCHKB_TERM_CODE	SARCHKB_TERM_CODE	VARCHAR2(6)	No	*
SARCHKB_ADMR_CODE	SARCHKB_ADMR_CODE	VARCHAR2(4)	No	*
SARCHKB_MANDATORY_IND	SARCHKB_MANDATORY_IND	VARCHAR2(1)	Yes
SARCHKB_LEVL_CODE	SARCHKB_LEVL_CODE	VARCHAR2(2)	Yes	*
SARCHKB_STYP_CODE	SARCHKB_STYP_CODE	VARCHAR2(1)	Yes	*
SARCHKB_ADMT_CODE	SARCHKB_ADMT_CODE	VARCHAR2(2)	Yes	*
SARCHKB_COLL_CODE	SARCHKB_COLL_CODE	VARCHAR2(2)	Yes	*
SARCHKB_DEGC_CODE	SARCHKB_DEGC_CODE	VARCHAR2(6)	Yes	*
SARCHKB_MAJR_CODE	SARCHKB_MAJR_CODE	VARCHAR2(4)	Yes	*
SARCHKB_RESD_CODE	SARCHKB_RESD_CODE	VARCHAR2(1)	Yes	*
SARCHKB_INACTIVE_IND	SARCHKB_INACTIVE_IND	VARCHAR2(1)	Yes
SARCHKB_ACTIVITY_DATE	SARCHKB_ACTIVITY_DATE	DATE	No
SARCHKB_CAMP_CODE	SARCHKB_CAMP_CODE	VARCHAR2(3)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARCHKB_RESD_CODE	STVRESD_CODE	STVRESD
SARCHKB_ADMR_CODE	STVADMR_CODE	STVADMR
SARCHKB_ADMT_CODE	STVADMT_CODE	STVADMT
SARCHKB_STYP_CODE	STVSTYP_CODE	STVSTYP
SARCHKB_COLL_CODE	STVCOLL_CODE	STVCOLL
SARCHKB_MAJR_CODE	STVMAJR_CODE	STVMAJR
SARCHKB_DEGC_CODE	STVDEGC_CODE	STVDEGC
SARCHKB_CAMP_CODE	STVCAMP_CODE	STVCAMP
SARCHKB_LEVL_CODE	STVLEVL_CODE	STVLEVL
SARCHKB_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SARCHKB_KEY_INDEX		SARCHKB_TERM_CODE

Comments

Source Code Comments

Admission Request Checklist Build Table

Columns Comments for SARCHKB_TERM_CODE (1)

Source Code Comments

This field identifies the effective term of the admissions checklist requirement.

Columns Comments for SARCHKB_ADMR_CODE (2)

Source Code Comments

This field identifies the type of admissions checklist requirement being requested.

Columns Comments for SARCHKB_MANDATORY_IND (3)

Source Code Comments

This field identifies whether the checklist requirement created is required to meet admissions decision criteria.

Columns Comments for SARCHKB_LEVL_CODE (4)

Source Code Comments

This field identifies the level of the applicant which the admissions checklist requirement applies to.

Columns Comments for SARCHKB_STYP_CODE (5)

Source Code Comments

This field identifies the student type that the checklist requirement applies to.

Columns Comments for SARCHKB_ADMT_CODE (6)

Source Code Comments

This field identifies the admission type that the checklist requirement applies to.

Columns Comments for SARCHKB_COLL_CODE (7)

Source Code Comments

This field identifies the specific college that the checklist requirement applies to.

Columns Comments for SARCHKB_DEGC_CODE (8)

Source Code Comments

This field identifies the specific degree that the checklist requirement applies to.

Columns Comments for SARCHKB_MAJR_CODE (9)

Source Code Comments

This field identifies the specific major that the checklist requirement applies to.

Columns Comments for SARCHKB_RESD_CODE (10)

Source Code Comments

This field identifies the specific residency type that the checklist requirement applies to.

Columns Comments for SARCHKB_INACTIVE_IND (11)

Source Code Comments

This field identifies whether the checklist requirement is inactive.

Columns Comments for SARCHKB_ACTIVITY_DATE (12)

Source Code Comments

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

Table SARQKER

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SARQKER_TERM_CODE	SARQKER_TERM_CODE	VARCHAR2(6)	No	*	*
SARQKER_LEVL_CODE	SARQKER_LEVL_CODE	VARCHAR2(2)	No	*	*
SARQKER_APST_CODE	SARQKER_APST_CODE	VARCHAR2(1)	Yes		*
SARQKER_APDC_CODE	SARQKER_APDC_CODE	VARCHAR2(2)	Yes		*
SARQKER_ADMT_CODE	SARQKER_ADMT_CODE	VARCHAR2(2)	Yes		*
SARQKER_STYP_CODE	SARQKER_STYP_CODE	VARCHAR2(1)	Yes		*
SARQKER_STST_CODE	SARQKER_STST_CODE	VARCHAR2(2)	Yes		*
SARQKER_CAMP_CODE	SARQKER_CAMP_CODE	VARCHAR2(3)	Yes		*
SARQKER_COLL_CODE	SARQKER_COLL_CODE	VARCHAR2(2)	Yes		*
SARQKER_DEGC_CODE	SARQKER_DEGC_CODE	VARCHAR2(6)	Yes		*
SARQKER_MAJR_CODE	SARQKER_MAJR_CODE	VARCHAR2(4)	Yes		*
SARQKER_RESD_CODE	SARQKER_RESD_CODE	VARCHAR2(1)	Yes		*
SARQKER_RATE_CODE	SARQKER_RATE_CODE	VARCHAR2(5)	Yes		*
SARQKER_DEPT_CODE	SARQKER_DEPT_CODE	VARCHAR2(4)	Yes		*
SARQKER_SBGI_CODE	SARQKER_SBGI_CODE	VARCHAR2(6)	Yes		*
SARQKER_ADD_ADM_IND	SARQKER_ADD_ADM_IND	VARCHAR2(1)	Yes
SARQKER_ADD_RECR_IND	SARQKER_ADD_RECR_IND	VARCHAR2(1)	Yes
SARQKER_ACTIVITY_DATE	SARQKER_ACTIVITY_DATE	DATE	No
SARQKER_EGOL_CODE	SARQKER_EGOL_CODE	VARCHAR2(2)	Yes		*
SARQKER_EDLV_CODE	SARQKER_EDLV_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARQKER_RESD_CODE	STVRESD_CODE	STVRESD
SARQKER_EGOL_CODE	STVEGOL_CODE	STVEGOL
SARQKER_ADMT_CODE	STVADMT_CODE	STVADMT
SARQKER_STST_CODE	STVSTST_CODE	STVSTST
SARQKER_STYP_CODE	STVSTYP_CODE	STVSTYP
SARQKER_RATE_CODE	STVRATE_CODE	STVRATE
SARQKER_COLL_CODE	STVCOLL_CODE	STVCOLL
SARQKER_MAJR_CODE	STVMAJR_CODE	STVMAJR
SARQKER_DEGC_CODE	STVDEGC_CODE	STVDEGC
SARQKER_DEPT_CODE	STVDEPT_CODE	STVDEPT
SARQKER_CAMP_CODE	STVCAMP_CODE	STVCAMP
SARQKER_LEVL_CODE	STVLEVL_CODE	STVLEVL
SARQKER_TERM_CODE	STVTERM_CODE	STVTERM
SARQKER_EDLV_CODE	STVEDLV_CODE	STVEDLV
SARQKER_APDC_CODE	STVAPDC_CODE	STVAPDC
SARQKER_APST_CODE	STVAPST_CODE	STVAPST
SARQKER_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_SARQKER	Unique	SARQKER_TERM_CODE
PK_SARQKER	Unique	SARQKER_LEVL_CODE

Comments

Source Code Comments

Quick Entry Rules Repeating Table

Columns Comments for SARQKER_TERM_CODE (1)

Source Code Comments

This field identifies the effective term for the specific quick entry rule.

Columns Comments for SARQKER_LEVL_CODE (2)

Source Code Comments

This field identifies the level of the applicant associated with the quick entry rule.

Columns Comments for SARQKER_APDC_CODE (4)

Source Code Comments

This field identifies the decision associated with the application.

Columns Comments for SARQKER_ADMT_CODE (5)

Source Code Comments

This field identifies the admissions type of the applicant.

Columns Comments for SARQKER_STYP_CODE (6)

Source Code Comments

This field identifies the student type of the applicant.

Columns Comments for SARQKER_STST_CODE (7)

Source Code Comments

This field identifies the student status of the applicant.

Columns Comments for SARQKER_CAMP_CODE (8)

Source Code Comments

This field identifies the campus associated with the applicant.

Columns Comments for SARQKER_COLL_CODE (9)

Source Code Comments

This field identifies the college associated with the applicant.

Columns Comments for SARQKER_DEGC_CODE (10)

Source Code Comments

This field identifies the degree associated with the applicant.

Columns Comments for SARQKER_MAJR_CODE (11)

Source Code Comments

This field identifies the major associated with the applicant.

Columns Comments for SARQKER_RESD_CODE (12)

Source Code Comments

This field identifies the residence type associated with the applicant.

Columns Comments for SARQKER_RATE_CODE (13)

Source Code Comments

This field identifies the fee rate associated with the applicant.

Columns Comments for SARQKER_DEPT_CODE (14)

Source Code Comments

This field identifies the department associated with the applicant.

Columns Comments for SARQKER_SBGI_CODE (15)

Source Code Comments

This field identifies the primary source of the applicant.

Columns Comments for SARQKER_ADD_ADM_IND (16)

Source Code Comments

This field identifies whether an admissions application should be created for this applicant.

Columns Comments for SARQKER_ADD_RECR_IND (17)

Source Code Comments

This field identifies whether a recruiting record should be created for the applicant.

Columns Comments for SARQKER_ACTIVITY_DATE (18)

Source Code Comments

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

Columns Comments for SARQKER_EGOL_CODE (19)

Source Code Comments

Educational Goal Code

Columns Comments for SARQKER_EDLV_CODE (20)

Source Code Comments

Education Level Code

Table SARRRFT

Schema Name SATURN
Label SARRRFT
Server name MALDEV8_B60
Creation Date 07/18/2003 18:24:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SARRRFT_TERM_CODE_EFF	SARRRFT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SARRRFT_LEVL_CODE	SARRRFT_LEVL_CODE	VARCHAR2(2)	Yes	*
SARRRFT_CAMP_CODE	SARRRFT_CAMP_CODE	VARCHAR2(3)	Yes	*
SARRRFT_COLL_CODE	SARRRFT_COLL_CODE	VARCHAR2(2)	Yes	*
SARRRFT_DEGC_CODE	SARRRFT_DEGC_CODE	VARCHAR2(6)	Yes	*
SARRRFT_PROGRAM	SARRRFT_PROGRAM	VARCHAR2(12)	Yes	*
SARRRFT_ADMT_CODE	SARRRFT_ADMT_CODE	VARCHAR2(2)	Yes	*
SARRRFT_STYP_CODE	SARRRFT_STYP_CODE	VARCHAR2(1)	Yes	*
SARRRFT_RESD_CODE	SARRRFT_RESD_CODE	VARCHAR2(1)	Yes	*
SARRRFT_MAJR_CODE	SARRRFT_MAJR_CODE	VARCHAR2(4)	Yes	*
SARRRFT_AFCT_CODE	SARRRFT_AFCT_CODE	VARCHAR2(15)	No	*
SARRRFT_TABLE_NAME	SARRRFT_TABLE_NAME	VARCHAR2(30)	Yes
SARRRFT_SELECT_COLUMN	SARRRFT_SELECT_COLUMN	VARCHAR2(30)	Yes
SARRRFT_WHERE_COLUMN	SARRRFT_WHERE_COLUMN	VARCHAR2(30)	Yes
SARRRFT_VALUE	SARRRFT_VALUE	VARCHAR2(15)	Yes
SARRRFT_USER_ID	SARRRFT_USER_ID	VARCHAR2(30)	No
SARRRFT_ACTIVITY_DATE	SARRRFT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARRRFT_ADMT_CODE	STVADMT_CODE	STVADMT
SARRRFT_RESD_CODE	STVRESD_CODE	STVRESD
SARRRFT_STYP_CODE	STVSTYP_CODE	STVSTYP
SARRRFT_AFCT_CODE	STVAFCT_CODE	STVAFCT
SARRRFT_COLL_CODE	STVCOLL_CODE	STVCOLL
SARRRFT_MAJR_CODE	STVMAJR_CODE	STVMAJR
SARRRFT_DEGC_CODE	STVDEGC_CODE	STVDEGC
SARRRFT_CAMP_CODE	STVCAMP_CODE	STVCAMP
SARRRFT_LEVL_CODE	STVLEVL_CODE	STVLEVL
SARRRFT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SARRRFT_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE

Index

Index Name	Index Type	Column Name
UK_SARRRFT	Unique	SARRRFT_TERM_CODE_EFF
UK_SARRRFT	Unique	SARRRFT_LEVL_CODE
UK_SARRRFT	Unique	SARRRFT_CAMP_CODE
UK_SARRRFT	Unique	SARRRFT_COLL_CODE
UK_SARRRFT	Unique	SARRRFT_PROGRAM
UK_SARRRFT	Unique	SARRRFT_ADMT_CODE
UK_SARRRFT	Unique	SARRRFT_STYP_CODE
UK_SARRRFT	Unique	SARRRFT_RESD_CODE
UK_SARRRFT	Unique	SARRRFT_MAJR_CODE
UK_SARRRFT	Unique	SARRRFT_AFCT_CODE

Comments

Source Code Comments

This table contains Rating Factor Rules and Rating Factor Value definitions. The available values for specifying rules include term, level, campus, college, program, admit type, student type, residency and major. Institutions can enter any combination of
values to tailor the rating factors to meet their needs. The value of a Rating Factor can be a static value or can be a key value that will be used in the generation of dynamic SQL to retrieve a factor value from the database.

Columns Comments for SARRRFT_TERM_CODE_EFF (1)

Source Code Comments

Effective Term for Admissions Rating Factor evaluation. Only admissions rating factors with this effective term will be evaluated using this rule.

Columns Comments for SARRRFT_LEVL_CODE (2)

Source Code Comments

Level Code for Admissions Rating Factor evaluation. Only admissions rating factors with this level code will be evaluated using this rule.

Columns Comments for SARRRFT_CAMP_CODE (3)

Source Code Comments

Campus Code for Admissions Rating Factor evaluation. Only admissions rating factors with this campus code will be evaluated using this rule.

Columns Comments for SARRRFT_COLL_CODE (4)

Source Code Comments

College Code for Admissions Rating Factor evaluation. Only admissions rating factors with this college code will be evaluated using this rule.

Columns Comments for SARRRFT_DEGC_CODE (5)

Source Code Comments

Degree Code for Admissions Rating Factor evaluation. Only admissions rating factors with this degree code will be evaluated using this rule.

Columns Comments for SARRRFT_PROGRAM (6)

Source Code Comments

Program for Admissions Rating Factor evaluation. Only admissions rating factors with this program will be evaluated using this rule.

Columns Comments for SARRRFT_ADMT_CODE (7)

Source Code Comments

Admit Type Code for Admissions Rating Factor evaluation. Only admissions rating factors with this admit type code will be evaluated using this rule.

Columns Comments for SARRRFT_STYP_CODE (8)

Source Code Comments

Student Type Code for Admissions Rating Factor evaluation. Only admissions rating factors with this student type code will be evaluated using this rule.

Columns Comments for SARRRFT_RESD_CODE (9)

Source Code Comments

Residency Code for Admissions Rating Factor evaluation. Only admissions rating factors with this residency code will be evaluated using this rule.

Columns Comments for SARRRFT_MAJR_CODE (10)

Source Code Comments

Major Code for Admissions Rating Factor evaluation. Only admissions rating factors with this major code will be evaluated using this rule.

Columns Comments for SARRRFT_AFCT_CODE (11)

Source Code Comments

Admissions Rating Factor Code for Admissions Rating Factor evaluation. Only admissions rating factors meeting the rule criteria will be available to an applicant as part of the index/rating calculation for that applicant.

Columns Comments for SARRRFT_TABLE_NAME (12)

Source Code Comments

Database Table Name to optionally specify for use in dynamic retrieval of factor value from database. Existence of table name along with SARRRFT_SELECT_COLUMN and SARRRFT_WHERE_COLUMN is indicative that factor value will be retrieved from database.

Columns Comments for SARRRFT_SELECT_COLUMN (13)

Source Code Comments

Database Table Column to optionally specify for use in dynamic retrieval of factor value from database. This will be the column name used in the generated SELECT statement. Existence of select column along with SARRRFT_TABLE_NAME and SARRRFT_WHERE_COLUMN
is indicative that factor value will be retrieved from database.

Columns Comments for SARRRFT_WHERE_COLUMN (14)

Source Code Comments

Database Table Column name to optionally specify for use in retrieval of factor value from database. This will be the column name used in the WHERE clause of the generated SELECT statement. Existence of where column along with SARRRFT_TABLE_NAME and SARR
RFT_WHERE_COLUMN is indicative that factor value will be retrieved from database.

Columns Comments for SARRRFT_VALUE (15)

Source Code Comments

Actual Value to be used for Admissions Factor Code. Value can be static value or can be key value that will be used in the dynamic retrieval of the factor value from the database. The existence of data in SAARRFT_TABLE_NAME, SAARRFT_SELECT_COLUMN and SA
ARRFT_WHERE_COLUMN is indicative that the value will be retrieved from the database. When being retrieved from the database, the contents of SAARRFT_VALUE will be used in the construction of the WHERE clause with the contents of SAARRFT_VALUE being to the
right of the '=' in the WHERE clause of the generated SELECT statement.

Columns Comments for SARRRFT_USER_ID (16)

Source Code Comments

Banner User ID. The user ID of the person who is inserting or updating the SARRRFT record.

Columns Comments for SARRRFT_ACTIVITY_DATE (17)

Source Code Comments

Activity date. The date that the information for the row was inserted or last updated in the SARRRFT table.

Table SCRRMAJ

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRRMAJ_SUBJ_CODE	SCRRMAJ_SUBJ_CODE	VARCHAR2(4)	No	*
SCRRMAJ_SUBJ_CODE	SCRRMAJ_SUBJ_CODE	VARCHAR2(4)	No	*
SCRRMAJ_CRSE_NUMB	SCRRMAJ_CRSE_NUMB	VARCHAR2(5)	No	*
SCRRMAJ_EFF_TERM	SCRRMAJ_EFF_TERM	VARCHAR2(6)	No	*
SCRRMAJ_REC_TYPE	SCRRMAJ_REC_TYPE	VARCHAR2(1)	No
SCRRMAJ_MAJOR_IND	SCRRMAJ_MAJOR_IND	VARCHAR2(1)	Yes
SCRRMAJ_MAJR_CODE	SCRRMAJ_MAJR_CODE	VARCHAR2(4)	Yes	*
SCRRMAJ_ACTIVITY_DATE	SCRRMAJ_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRRMAJ_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRRMAJ_MAJR_CODE	STVMAJR_CODE	STVMAJR
SCRRMAJ_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCRRMAJ_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCRRMAJ_EFF_TERM	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_SUBJ_CODE
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_CRSE_NUMB
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_EFF_TERM
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_REC_TYPE
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_MAJOR_IND
SCRRMAJ_KEY_INDEX	Unique	SCRRMAJ_MAJR_CODE

Comments

Source Code Comments

Course Major Restriction Repeating Table

Columns Comments for SCRRMAJ_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRRMAJ_CRSE_NUMB (2)

Source Code Comments

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

Columns Comments for SCRRMAJ_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course registration major restrictions becomes effective.

Columns Comments for SCRRMAJ_REC_TYPE (4)

Source Code Comments

This field defines if the record contains a major indicator or a major code. Valid values are: 1 - Major indicator, 2 - Major code.

Columns Comments for SCRRMAJ_MAJOR_IND (5)

Source Code Comments

This field indicates if the major codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude.

Columns Comments for SCRRMAJ_MAJR_CODE (6)

Source Code Comments

This field defines the majors of students for which registration restrictions exist. The Include/Exclude field will determine how the major is restricted. An unlimited number of majors may be defined.

Columns Comments for SCRRMAJ_ACTIVITY_DATE (7)

Source Code Comments

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

Table SDRPCNC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDRPCNC_ACTIVITY_DATE	SDRPCNC_ACTIVITY_DATE	DATE	No
SDRPCNC_PROGRAM	SDRPCNC_PROGRAM	VARCHAR2(6)	No	*	*
SDRPCNC_MAJR_CODE_AREA	SDRPCNC_MAJR_CODE_AREA	VARCHAR2(4)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRPCNC_MAJR_CODE_AREA	STVMAJR_CODE	STVMAJR
SDRPCNC_PROGRAM	SDBPROG_PROGRAM	SDBPROG

Index

Index Name	Index Type	Column Name
PK_SDRPCNC	Unique	SDRPCNC_PROGRAM
PK_SDRPCNC	Unique	SDRPCNC_MAJR_CODE_AREA

Comments

Source Code Comments

Program Code Area Of Concentration Repeating Table

Columns Comments for SDRPCNC_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRPCNC_PROGRAM (2)

Source Code Comments

This field identifies the degree program code associated with the major.

Columns Comments for SDRPCNC_MAJR_CODE_AREA (3)

Source Code Comments

This field identifies the concentration code that is valid for the degree program.

Table SDRPMJR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDRPMJR_ACTIVITY_DATE	SDRPMJR_ACTIVITY_DATE	DATE	No
SDRPMJR_PROGRAM	SDRPMJR_PROGRAM	VARCHAR2(6)	No	*	*
SDRPMJR_MAJR_CODE_MAJOR	SDRPMJR_MAJR_CODE_MAJOR	VARCHAR2(4)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRPMJR_MAJR_CODE_MAJOR	STVMAJR_CODE	STVMAJR
SDRPMJR_PROGRAM	SDBPROG_PROGRAM	SDBPROG

Index

Index Name	Index Type	Column Name
PK_SDRPMJR	Unique	SDRPMJR_PROGRAM
PK_SDRPMJR	Unique	SDRPMJR_MAJR_CODE_MAJOR

Comments

Source Code Comments

Program Code Major Repeating Table

Columns Comments for SDRPMJR_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRPMJR_PROGRAM (2)

Source Code Comments

This field identifies the degree program associated with the major.

Columns Comments for SDRPMJR_MAJR_CODE_MAJOR (3)

Source Code Comments

This field identifies the major code that is valid for the degree program.

Table SDRPMNR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDRPMNR_ACTIVITY_DATE	SDRPMNR_ACTIVITY_DATE	DATE	No
SDRPMNR_PROGRAM	SDRPMNR_PROGRAM	VARCHAR2(6)	No	*	*
SDRPMNR_MAJR_CODE_MINOR	SDRPMNR_MAJR_CODE_MINOR	VARCHAR2(4)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRPMNR_MAJR_CODE_MINOR	STVMAJR_CODE	STVMAJR
SDRPMNR_PROGRAM	SDBPROG_PROGRAM	SDBPROG

Index

Index Name	Index Type	Column Name
PK_SDRPMNR	Unique	SDRPMNR_PROGRAM
PK_SDRPMNR	Unique	SDRPMNR_MAJR_CODE_MINOR

Comments

Source Code Comments

Program Code Minor Repeating Table

Columns Comments for SDRPMNR_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRPMNR_PROGRAM (2)

Source Code Comments

This field identifies the degreee program code associated with the minor.

Columns Comments for SDRPMNR_MAJR_CODE_MINOR (3)

Source Code Comments

This field identifies the minor code that is valid for the degree program.

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