Model STVDEGC

Model Label : ERD For Banner Student STVDEGC Table
Path : BANNER DEV/Student/Common/STVDEGC/STVDEGC_ERD

List of Objects

Object Name	Object Type	Layer Name
APRADEG	TABLE	Default
PARPCON	TABLE	Default
PARPDEG	TABLE	Default
PARPMAJ	TABLE	Default
PARPMIN	TABLE	Default
SARCHKB	TABLE	Default
SARQKER	TABLE	Default
SARRRFT	TABLE	Default
SCRRDEG	TABLE	Default
SDBPROG	TABLE	Default
SFRRGFE	TABLE	Default
SFRTMSL	TABLE	Default
SFRTMST	TABLE	Default
SGRASSI	TABLE	Default
SGRCOLR	TABLE	Default
SHRPREV	TABLE	Default
SHRTRAM	TABLE	Default
SMRAQUA	TABLE	Default
SMRIEDG	TABLE	Default
SMRPRLE	TABLE	Default
SMRRQCM	TABLE	Default
SOBCURR	TABLE	Default
SORBDEG	TABLE	Default
SORCCOL	TABLE	Default
SORCOMM	TABLE	Default
SORCONC	TABLE	Default
SORDEGR	TABLE	Default
SORMAJR	TABLE	Default
SORMINR	TABLE	Default
SRBPRED	TABLE	Default
SRBRECR	TABLE	Default
SRTPCOL	TABLE	Default
SRTPREL	TABLE	Default
SSRRDEG	TABLE	Default
STVACAT	TABLE	Default
STVDEGC	TABLE	Default
STVDLEV	TABLE	Default
TBRIADG	TABLE	Default

Comments

Model View

Table APRADEG

Schema Name ALUMNI
Label APRADEG
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
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_SEQ_NO	APRADEG_SEQ_NO	NUMBER(5,0)	No	*
APRADEG_SBGI_CODE	APRADEG_SBGI_CODE	VARCHAR2(6)	Yes		*
APRADEG_DEGC_CODE	APRADEG_DEGC_CODE	VARCHAR2(6)	Yes		*
APRADEG_DATE	APRADEG_DATE	DATE	Yes
APRADEG_HONR_CODE	APRADEG_HONR_CODE	VARCHAR2(6)	Yes		*
APRADEG_COLL_CODE	APRADEG_COLL_CODE	VARCHAR2(2)	Yes		*
APRADEG_ACTIVITY_DATE	APRADEG_ACTIVITY_DATE	DATE	No
APRADEG_ACYR_CODE	APRADEG_ACYR_CODE	VARCHAR2(4)	Yes		*
APRADEG_ACYR_CODE_BULLETIN	APRADEG_ACYR_CODE_BULLETIN	VARCHAR2(4)	Yes		*
APRADEG_CAMP_CODE	APRADEG_CAMP_CODE	VARCHAR2(3)	Yes		*
APRADEG_DEPT_CODE	APRADEG_DEPT_CODE	VARCHAR2(4)	Yes		*
APRADEG_COMMENTS	APRADEG_COMMENTS	VARCHAR2(2000)	Yes
APRADEG_MAJR_CODE_MINR_1	APRADEG_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_MINR_2	APRADEG_MAJR_CODE_MINR_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_1	APRADEG_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_2	APRADEG_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_3	APRADEG_MAJR_CODE_CONC_3	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_4	APRADEG_MAJR_CODE_CONC_4	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_5	APRADEG_MAJR_CODE_CONC_5	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_6	APRADEG_MAJR_CODE_CONC_6	VARCHAR2(4)	Yes		*
APRADEG_DEPT_CODE_2	APRADEG_DEPT_CODE_2	VARCHAR2(4)	Yes		*
APRADEG_HONR_CODE_2	APRADEG_HONR_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_3	APRADEG_HONR_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_4	APRADEG_HONR_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_5	APRADEG_HONR_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_1	APRADEG_HOND_CODE_1	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_2	APRADEG_HOND_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_3	APRADEG_HOND_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_4	APRADEG_HOND_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_5	APRADEG_HOND_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_OK_FOR_NOTES_IND	APRADEG_OK_FOR_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_IND	APRADEG_DISP_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_DATE	APRADEG_DISP_NOTES_DATE	DATE	Yes
APRADEG_USER	APRADEG_USER	VARCHAR2(30)	No
APRADEG_REVIEWED_IND	APRADEG_REVIEWED_IND	VARCHAR2(1)	Yes
APRADEG_REVIEWED_USER	APRADEG_REVIEWED_USER	VARCHAR2(30)	Yes
APRADEG_MAJOR_COMMENT	APRADEG_MAJOR_COMMENT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRADEG_PIDM	APBCONS_PIDM	APBCONS
APRADEG_COLL_CODE	STVCOLL_CODE	STVCOLL
APRADEG_DEGC_CODE	STVDEGC_CODE	STVDEGC
APRADEG_CAMP_CODE	STVCAMP_CODE	STVCAMP
APRADEG_SBGI_CODE	STVSBGI_CODE	STVSBGI
APRADEG_PIDM	APRACYR_PIDM	APRACYR

Index

Index Name	Index Type	Column Name
PK_APRADEG	Unique	APRADEG_PIDM
PK_APRADEG	Unique	APRADEG_SEQ_NO

Comments

Source Code Comments

Academic Degree Repeating Table

Columns Comments for APRADEG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRADEG_SBGI_CODE (3)

Source Code Comments

This field specifies the institution at which the constituent earned the degree.

Columns Comments for APRADEG_DEGC_CODE (4)

Source Code Comments

This field spsecifies the type of degree earned by the constituent.

Columns Comments for APRADEG_DATE (5)

Source Code Comments

This field specifies the date the degree was awarded to the constituent.

Columns Comments for APRADEG_HONR_CODE (6)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_COLL_CODE (7)

Source Code Comments

This field specifies the college that awarded the associated degree to the constituent.

Columns Comments for APRADEG_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for APRADEG_ACYR_CODE (9)

Source Code Comments

The Academic Year Code associated with this degree.

Columns Comments for APRADEG_ACYR_CODE_BULLETIN (10)

Source Code Comments

The Academic Year Bulletin Code associated with this degree.

Columns Comments for APRADEG_CAMP_CODE (11)

Source Code Comments

The campus associated with this degree.

Columns Comments for APRADEG_DEPT_CODE (12)

Source Code Comments

The first department associated with this degree.

Columns Comments for APRADEG_COMMENTS (13)

Source Code Comments

Free form text comments about this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_1 (14)

Source Code Comments

The first Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_2 (15)

Source Code Comments

The second Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_1 (16)

Source Code Comments

The first Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_2 (17)

Source Code Comments

The second Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_3 (18)

Source Code Comments

The third Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_4 (19)

Source Code Comments

The fourth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_5 (20)

Source Code Comments

The fifth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_6 (21)

Source Code Comments

The sixth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_DEPT_CODE_2 (22)

Source Code Comments

The second department associated with this degree.

Columns Comments for APRADEG_HONR_CODE_2 (23)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_3 (24)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_4 (25)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_5 (26)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_1 (27)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_2 (28)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_3 (29)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_4 (30)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_5 (31)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_OK_FOR_NOTES_IND (32)

Source Code Comments

OK for Notes Indicator, Y indicates that this degree can be used in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_IND (33)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this degree was displaeyd in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_DATE (34)

Source Code Comments

The date that this degree was displayed in Class Notes.

Columns Comments for APRADEG_USER (35)

Source Code Comments

The User ID of the person who created or last modified this degree record.

Columns Comments for APRADEG_REVIEWED_IND (36)

Source Code Comments

Reviewed Indicator, Y indicates that this degree has been reviewed and accepted.

Columns Comments for APRADEG_REVIEWED_USER (37)

Source Code Comments

The User ID of the person who reviewed and accepted this degree.

Columns Comments for APRADEG_MAJOR_COMMENT (38)

Source Code Comments

Free form text comments about this degree.

Table PARPCON

Schema Name PAYROLL
Label PARPCON
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
PARPCON_POSN	PARPCON_POSN	VARCHAR2(6)	No	*	*
PARPCON_DEGC_CODE	PARPCON_DEGC_CODE	VARCHAR2(6)	No	*	*
PARPCON_CONC_CODE	PARPCON_CONC_CODE	VARCHAR2(4)	No	*
PARPCON_CONC_REQR_IND	PARPCON_CONC_REQR_IND	VARCHAR2(1)	No
PARPCON_ACTIVITY_DATE	PARPCON_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PARPCON_POSN	NBBPOSN_POSN	NBBPOSN
PARPCON_DEGC_CODE	STVDEGC_CODE	STVDEGC

Index

Index Name	Index Type	Column Name
PK_PARPCON	Unique	PARPCON_POSN
PK_PARPCON	Unique	PARPCON_DEGC_CODE
PK_PARPCON	Unique	PARPCON_CONC_CODE

Comments

Source Code Comments

Position Area of Concentration Table

Columns Comments for PARPCON_POSN (1)

Source Code Comments

POSITION NUMBER: Position number associated with this degree/area of concentration combination.

Columns Comments for PARPCON_DEGC_CODE (2)

Source Code Comments

DEGREE CODE: Degree code required for this position.

Columns Comments for PARPCON_CONC_CODE (3)

Source Code Comments

AREAR OF CONCENTRATION CODE: Area of Concentration code required for this position and degree.

Columns Comments for PARPCON_CONC_REQR_IND (4)

Source Code Comments

REQUIRED/OPTIONAL IND: Indicates if the Area of Concentration is required or optional.

Columns Comments for PARPCON_ACTIVITY_DATE (5)

Source Code Comments

Date of Last Modification of the Record.

Table PARPDEG

Schema Name PAYROLL
Label PARPDEG
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PARPDEG_POSN	PARPDEG_POSN	VARCHAR2(6)	No	*	*
PARPDEG_DEGC_CODE	PARPDEG_DEGC_CODE	VARCHAR2(6)	No	*	*
PARPDEG_DEGC_REQR_IND	PARPDEG_DEGC_REQR_IND	VARCHAR2(1)	No
PARPDEG_DLEV_REQR_IND	PARPDEG_DLEV_REQR_IND	VARCHAR2(1)	Yes
PARPDEG_ACTIVITY_DATE	PARPDEG_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PARPDEG_POSN	NBBPOSN_POSN	NBBPOSN
PARPDEG_DEGC_CODE	STVDEGC_CODE	STVDEGC

Index

Index Name	Index Type	Column Name
PK_PARPDEG	Unique	PARPDEG_POSN
PK_PARPDEG	Unique	PARPDEG_DEGC_CODE

Comments

Source Code Comments

Position Degree Table

Columns Comments for PARPDEG_POSN (1)

Source Code Comments

POSITION NUMBER: Position number associated with this degree.

Columns Comments for PARPDEG_DEGC_CODE (2)

Source Code Comments

DEGREE CODE: Degree code required for this position.

Columns Comments for PARPDEG_DEGC_REQR_IND (3)

Source Code Comments

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

Columns Comments for PARPDEG_DLEV_REQR_IND (4)

Source Code Comments

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

Columns Comments for PARPDEG_ACTIVITY_DATE (5)

Source Code Comments

Date of Last Modification of the Record.

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 PARPMIN

Schema Name PAYROLL
Label PARPMIN
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
PARPMIN_POSN	PARPMIN_POSN	VARCHAR2(6)	No	*	*
PARPMIN_DEGC_CODE	PARPMIN_DEGC_CODE	VARCHAR2(6)	No	*	*
PARPMIN_MINR_CODE	PARPMIN_MINR_CODE	VARCHAR2(4)	No	*
PARPMIN_MINR_REQR_IND	PARPMIN_MINR_REQR_IND	VARCHAR2(1)	No
PARPMIN_ACTIVITY_DATE	PARPMIN_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PARPMIN_POSN	NBBPOSN_POSN	NBBPOSN
PARPMIN_DEGC_CODE	STVDEGC_CODE	STVDEGC

Index

Index Name	Index Type	Column Name
PK_PARPMIN	Unique	PARPMIN_POSN
PK_PARPMIN	Unique	PARPMIN_DEGC_CODE
PK_PARPMIN	Unique	PARPMIN_MINR_CODE

Comments

Source Code Comments

Position Minor Table

Columns Comments for PARPMIN_POSN (1)

Source Code Comments

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

Columns Comments for PARPMIN_DEGC_CODE (2)

Source Code Comments

DEGREE CODE: Degree code associated with this minor.

Columns Comments for PARPMIN_MINR_CODE (3)

Source Code Comments

MINOR CODE: Minor code required for this position and degree.

Columns Comments for PARPMIN_MINR_REQR_IND (4)

Source Code Comments

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

Columns Comments for PARPMIN_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