Model STVPRNT

Model Label : ERD for Banner Student STVPRNT Table
Path : BANNER DEV/Student/Common/STVPRNT/STVPRNT_ERD

List of Objects

Object Name	Object Type	Layer Name
SMRACCM	TABLE	Default
SMRACMT	TABLE	Default
SMRAGRT	TABLE	Default
SMRARCM	TABLE	Default
SMRARGC	TABLE	Default
SMRARLT	TABLE	Default
SMRARSC	TABLE	Default
SMRGCCM	TABLE	Default
SMRGCMT	TABLE	Default
SMRGRCM	TABLE	Default
SMRGRGC	TABLE	Default
SMRGRLT	TABLE	Default
SMRGRSC	TABLE	Default
SMRPCMT	TABLE	Default
SMRPRGC	TABLE	Default
SMRPRSC	TABLE	Default
SMRSACM	TABLE	Default
SMRSACT	TABLE	Default
SMRSAGC	TABLE	Default
SMRSAGD	TABLE	Default
SMRSARC	TABLE	Default
SMRSARD	TABLE	Default
SMRSART	TABLE	Default
SMRSGCM	TABLE	Default
SMRSGCT	TABLE	Default
SMRSGGC	TABLE	Default
SMRSGRC	TABLE	Default
SMRSGRD	TABLE	Default
SMRSGRT	TABLE	Default
SMRSPCM	TABLE	Default
SMRSPGC	TABLE	Default
SMRSPRC	TABLE	Default
STVPRNT	TABLE	Default

Comments

Model View

Table SMRACCM

Schema Name SATURN
Label SMRACCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRACCM_AREA	SMRACCM_AREA	VARCHAR2(10)	No	*
SMRACCM_AREA	SMRACCM_AREA	VARCHAR2(10)	No	*
SMRACCM_TERM_CODE_EFF	SMRACCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRACCM_TERM_CODE_EFF	SMRACCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRACCM_SMRACAA_SEQNO	SMRACCM_SMRACAA_SEQNO	NUMBER(8,0)	No	*
SMRACCM_ACTIVITY_DATE	SMRACCM_ACTIVITY_DATE	DATE	No
SMRACCM_TEXT_SEQNO	SMRACCM_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRACCM_TEXT	SMRACCM_TEXT	VARCHAR2(60)	Yes
SMRACCM_PRNT_CODE	SMRACCM_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRACCM_AREA	SMRACAA_AREA	SMRACAA
SMRACCM_TERM_CODE_EFF	SMRACAA_TERM_CODE_EFF	SMRACAA
SMRACCM_SMRACAA_SEQNO	SMRACAA_SEQNO	SMRACAA
SMRACCM_AREA	SMRALIB_AREA	SMRALIB
SMRACCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRACCM_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRACCM_KEY_INDEX		SMRACCM_AREA
SMRACCM_KEY_INDEX		SMRACCM_TERM_CODE_EFF
SMRACCM_KEY_INDEX		SMRACCM_SMRACAA_SEQNO
SMRACCM_KEY_INDEX		SMRACCM_TEXT_SEQNO

Comments

Source Code Comments

Area Attached Course Comment Table

Columns Comments for SMRACCM_AREA (1)

Source Code Comments

Area code.

Columns Comments for SMRACCM_TERM_CODE_EFF (2)

Source Code Comments

Term code effective date.

Columns Comments for SMRACCM_SMRACAA_SEQNO (3)

Source Code Comments

The sequence number of the area course/attribute requirement.

Columns Comments for SMRACCM_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRACCM_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the area requirement comments.

Columns Comments for SMRACCM_TEXT (6)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRACCM_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRACMT

Schema Name SATURN
Label SMRACMT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRACMT_AREA	SMRACMT_AREA	VARCHAR2(10)	No	*
SMRACMT_TERM_CODE_EFF	SMRACMT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRACMT_ACTIVITY_DATE	SMRACMT_ACTIVITY_DATE	DATE	No
SMRACMT_TEXT_SEQNO	SMRACMT_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRACMT_TEXT	SMRACMT_TEXT	VARCHAR2(60)	Yes
SMRACMT_PRNT_CODE	SMRACMT_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRACMT_AREA	SMRALIB_AREA	SMRALIB
SMRACMT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRACMT_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRACMT_KEY_INDEX		SMRACMT_AREA
SMRACMT_KEY_INDEX		SMRACMT_TERM_CODE_EFF
SMRACMT_KEY_INDEX		SMRACMT_TEXT_SEQNO

Comments

Source Code Comments

Area Requirements Comment Table

Columns Comments for SMRACMT_AREA (1)

Source Code Comments

An area is an entity used to define general requirements and any related detail requirements for use as a program component.

Columns Comments for SMRACMT_TERM_CODE_EFF (2)

Source Code Comments

Effective term of the area comments.

Columns Comments for SMRACMT_ACTIVITY_DATE (3)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRACMT_TEXT_SEQNO (4)

Source Code Comments

The sequence number of the area requirement comments.

Columns Comments for SMRACMT_TEXT (5)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRACMT_PRNT_CODE (6)

Source Code Comments

Print Type Code.

Table SMRAGRT

Schema Name SATURN
Label SMRAGRT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRAGRT_KEY_RULE	SMRAGRT_KEY_RULE	VARCHAR2(10)	No	*
SMRAGRT_AREA	SMRAGRT_AREA	VARCHAR2(10)	No	*
SMRAGRT_AREA	SMRAGRT_AREA	VARCHAR2(10)	No	*
SMRAGRT_TERM_CODE_EFF	SMRAGRT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRAGRT_TERM_CODE_EFF	SMRAGRT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRAGRT_ACTIVITY_DATE	SMRAGRT_ACTIVITY_DATE	DATE	No
SMRAGRT_TEXT_SEQNO	SMRAGRT_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRAGRT_TEXT	SMRAGRT_TEXT	VARCHAR2(60)	Yes
SMRAGRT_PRNT_CODE	SMRAGRT_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRAGRT_KEY_RULE	SMBAGRL_KEY_RULE	SMBAGRL
SMRAGRT_AREA	SMBAGRL_AREA	SMBAGRL
SMRAGRT_TERM_CODE_EFF	SMBAGRL_TERM_CODE_EFF	SMBAGRL
SMRAGRT_AREA	SMRALIB_AREA	SMRALIB
SMRAGRT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRAGRT_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRAGRT_KEY_INDEX		SMRAGRT_KEY_RULE
SMRAGRT_KEY_INDEX		SMRAGRT_AREA
SMRAGRT_KEY_INDEX		SMRAGRT_TERM_CODE_EFF
SMRAGRT_KEY_INDEX		SMRAGRT_TEXT_SEQNO

Comments

Source Code Comments

Area Group Attachment Rule Comment Table

Columns Comments for SMRAGRT_KEY_RULE (1)

Source Code Comments

A rule is a way to segregate detail requirements which need additional controls over and above the controls already specified for the area detail requirements.

Columns Comments for SMRAGRT_AREA (2)

Source Code Comments

Area code.

Columns Comments for SMRAGRT_TERM_CODE_EFF (3)

Source Code Comments

Term code effective date.

Columns Comments for SMRAGRT_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRAGRT_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the area rule comments.

Columns Comments for SMRAGRT_TEXT (6)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRAGRT_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRARCM

Schema Name SATURN
Label SMRARCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRARCM_KEY_RULE	SMRARCM_KEY_RULE	VARCHAR2(10)	No	*
SMRARCM_AREA	SMRARCM_AREA	VARCHAR2(10)	No	*
SMRARCM_AREA	SMRARCM_AREA	VARCHAR2(10)	No	*
SMRARCM_TERM_CODE_EFF	SMRARCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARCM_TERM_CODE_EFF	SMRARCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARCM_SMRARUL_SEQNO	SMRARCM_SMRARUL_SEQNO	NUMBER(8,0)	No	*
SMRARCM_ACTIVITY_DATE	SMRARCM_ACTIVITY_DATE	DATE	No
SMRARCM_TEXT_SEQNO	SMRARCM_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRARCM_TEXT	SMRARCM_TEXT	VARCHAR2(60)	Yes
SMRARCM_PRNT_CODE	SMRARCM_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRARCM_KEY_RULE	SMRARUL_KEY_RULE	SMRARUL
SMRARCM_AREA	SMRARUL_AREA	SMRARUL
SMRARCM_TERM_CODE_EFF	SMRARUL_TERM_CODE_EFF	SMRARUL
SMRARCM_SMRARUL_SEQNO	SMRARUL_SEQNO	SMRARUL
SMRARCM_AREA	SMRALIB_AREA	SMRALIB
SMRARCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRARCM_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRARCM_KEY_INDEX		SMRARCM_KEY_RULE
SMRARCM_KEY_INDEX		SMRARCM_AREA
SMRARCM_KEY_INDEX		SMRARCM_TERM_CODE_EFF
SMRARCM_KEY_INDEX		SMRARCM_SMRARUL_SEQNO
SMRARCM_KEY_INDEX		SMRARCM_TEXT_SEQNO

Comments

Source Code Comments

Area Rule Attached Course Comment Table

Columns Comments for SMRARCM_KEY_RULE (1)

Source Code Comments

Rule code.

Columns Comments for SMRARCM_AREA (2)

Source Code Comments

Area code.

Columns Comments for SMRARCM_TERM_CODE_EFF (3)

Source Code Comments

Term code effective date.

Columns Comments for SMRARCM_SMRARUL_SEQNO (4)

Source Code Comments

The sequence number of the area course/attribute requirement.

Columns Comments for SMRARCM_ACTIVITY_DATE (5)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRARCM_TEXT_SEQNO (6)

Source Code Comments

The sequence number of the area requirement comments.

Columns Comments for SMRARCM_TEXT (7)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRARCM_PRNT_CODE (8)

Source Code Comments

Print type code.

Table SMRARGC

Schema Name SATURN
Label SMRARGC
Server name MALDEV8_B60
Creation Date 08/27/2002 00:01:22:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRARGC_AREA	SMRARGC_AREA	VARCHAR2(10)	No	*
SMRARGC_TERM_CODE_EFF	SMRARGC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARGC_GRDE_CODE	SMRARGC_GRDE_CODE	VARCHAR2(6)	No
SMRARGC_ACTIVITY_DATE	SMRARGC_ACTIVITY_DATE	DATE	No
SMRARGC_TEXT_SEQNO	SMRARGC_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRARGC_TEXT	SMRARGC_TEXT	VARCHAR2(60)	Yes
SMRARGC_PRNT_CODE	SMRARGC_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRARGC_AREA	SMRALIB_AREA	SMRALIB
SMRARGC_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRARGC_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRARGC_KEY_INDEX		SMRARGC_AREA
SMRARGC_KEY_INDEX		SMRARGC_TERM_CODE_EFF
SMRARGC_KEY_INDEX		SMRARGC_GRDE_CODE
SMRARGC_KEY_INDEX		SMRARGC_TEXT_SEQNO

Comments

Source Code Comments

Area Restricted Grade Comment Table

Columns Comments for SMRARGC_AREA (1)

Source Code Comments

Area code.

Columns Comments for SMRARGC_TERM_CODE_EFF (2)

Source Code Comments

Term code effective date.

Columns Comments for SMRARGC_GRDE_CODE (3)

Source Code Comments

The grade code of the area restricted grade requirement.

Columns Comments for SMRARGC_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRARGC_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the area requirement comments.

Columns Comments for SMRARGC_TEXT (6)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRARGC_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRARLT

Schema Name SATURN
Label SMRARLT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRARLT_KEY_RULE	SMRARLT_KEY_RULE	VARCHAR2(10)	No	*
SMRARLT_AREA	SMRARLT_AREA	VARCHAR2(10)	No	*
SMRARLT_AREA	SMRARLT_AREA	VARCHAR2(10)	No	*
SMRARLT_TERM_CODE_EFF	SMRARLT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARLT_TERM_CODE_EFF	SMRARLT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARLT_ACTIVITY_DATE	SMRARLT_ACTIVITY_DATE	DATE	No
SMRARLT_TEXT_SEQNO	SMRARLT_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRARLT_TEXT	SMRARLT_TEXT	VARCHAR2(60)	Yes
SMRARLT_PRNT_CODE	SMRARLT_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRARLT_AREA	SMRALIB_AREA	SMRALIB
SMRARLT_KEY_RULE	SMBARUL_KEY_RULE	SMBARUL
SMRARLT_AREA	SMBARUL_AREA	SMBARUL
SMRARLT_TERM_CODE_EFF	SMBARUL_TERM_CODE_EFF	SMBARUL
SMRARLT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRARLT_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRARLT_KEY_INDEX		SMRARLT_KEY_RULE
SMRARLT_KEY_INDEX		SMRARLT_AREA
SMRARLT_KEY_INDEX		SMRARLT_TERM_CODE_EFF
SMRARLT_KEY_INDEX		SMRARLT_TEXT_SEQNO

Comments

Source Code Comments

Area Course Attachment Rule Comment Table

Columns Comments for SMRARLT_KEY_RULE (1)

Source Code Comments

A rule is a way to segregate detail requirements which need additional controls over and above the controls already specified for the area detail requirements.

Columns Comments for SMRARLT_AREA (2)

Source Code Comments

Area code.

Columns Comments for SMRARLT_TERM_CODE_EFF (3)

Source Code Comments

Term code effective date.

Columns Comments for SMRARLT_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRARLT_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the area rule comments.

Columns Comments for SMRARLT_TEXT (6)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRARLT_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRARSC

Schema Name SATURN
Label SMRARSC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:17:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRARSC_AREA	SMRARSC_AREA	VARCHAR2(10)	No	*
SMRARSC_AREA	SMRARSC_AREA	VARCHAR2(10)	No	*
SMRARSC_TERM_CODE_EFF	SMRARSC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARSC_TERM_CODE_EFF	SMRARSC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRARSC_SMRARSA_SEQNO	SMRARSC_SMRARSA_SEQNO	NUMBER(8,0)	No	*
SMRARSC_ACTIVITY_DATE	SMRARSC_ACTIVITY_DATE	DATE	No
SMRARSC_TEXT_SEQNO	SMRARSC_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRARSC_TEXT	SMRARSC_TEXT	VARCHAR2(60)	Yes
SMRARSC_PRNT_CODE	SMRARSC_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRARSC_AREA	SMRARSA_AREA	SMRARSA
SMRARSC_TERM_CODE_EFF	SMRARSA_TERM_CODE_EFF	SMRARSA
SMRARSC_SMRARSA_SEQNO	SMRARSA_SEQNO	SMRARSA
SMRARSC_AREA	SMRALIB_AREA	SMRALIB
SMRARSC_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRARSC_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRARSC_KEY_INDEX		SMRARSC_AREA
SMRARSC_KEY_INDEX		SMRARSC_TERM_CODE_EFF
SMRARSC_KEY_INDEX		SMRARSC_SMRARSA_SEQNO
SMRARSC_KEY_INDEX		SMRARSC_TEXT_SEQNO

Comments

Source Code Comments

Area Restricted Subject Attribute Comments Table

Columns Comments for SMRARSC_AREA (1)

Source Code Comments

Area code.

Columns Comments for SMRARSC_TERM_CODE_EFF (2)

Source Code Comments

Term code effective date.

Columns Comments for SMRARSC_SMRARSA_SEQNO (3)

Source Code Comments

The sequence number of the area course/attribute requirement.

Columns Comments for SMRARSC_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRARSC_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the area requirement comments.

Columns Comments for SMRARSC_TEXT (6)

Source Code Comments

Text of the area requirement comments.

Columns Comments for SMRARSC_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRGCCM

Schema Name SATURN
Label SMRGCCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:19:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGCCM_GROUP	SMRGCCM_GROUP	VARCHAR2(10)	No	*
SMRGCCM_GROUP	SMRGCCM_GROUP	VARCHAR2(10)	No	*
SMRGCCM_TERM_CODE_EFF	SMRGCCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGCCM_TERM_CODE_EFF	SMRGCCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGCCM_SMRGCAA_SEQNO	SMRGCCM_SMRGCAA_SEQNO	NUMBER(8,0)	No	*
SMRGCCM_ACTIVITY_DATE	SMRGCCM_ACTIVITY_DATE	DATE	No
SMRGCCM_TEXT_SEQNO	SMRGCCM_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGCCM_TEXT	SMRGCCM_TEXT	VARCHAR2(60)	Yes
SMRGCCM_PRNT_CODE	SMRGCCM_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRGCCM_GROUP	SMRGCAA_GROUP	SMRGCAA
SMRGCCM_TERM_CODE_EFF	SMRGCAA_TERM_CODE_EFF	SMRGCAA
SMRGCCM_SMRGCAA_SEQNO	SMRGCAA_SEQNO	SMRGCAA
SMRGCCM_GROUP	SMRGLIB_GROUP	SMRGLIB
SMRGCCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRGCCM_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRGCCM_KEY_INDEX		SMRGCCM_GROUP
SMRGCCM_KEY_INDEX		SMRGCCM_TERM_CODE_EFF
SMRGCCM_KEY_INDEX		SMRGCCM_SMRGCAA_SEQNO
SMRGCCM_KEY_INDEX		SMRGCCM_TEXT_SEQNO

Comments

Source Code Comments

Group Attached Course Comment Table

Columns Comments for SMRGCCM_TERM_CODE_EFF (2)

Source Code Comments

Effective term of the group comments.

Columns Comments for SMRGCCM_SMRGCAA_SEQNO (3)

Source Code Comments

The sequence number of the group course/attribute requirement.

Columns Comments for SMRGCCM_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRGCCM_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the group requirement comments.

Columns Comments for SMRGCCM_TEXT (6)

Source Code Comments

Text of the group requirement comments.

Columns Comments for SMRGCCM_PRNT_CODE (7)

Source Code Comments

Print type code.

Table SMRGCMT

Schema Name SATURN
Label SMRGCMT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:19:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGCMT_GROUP	SMRGCMT_GROUP	VARCHAR2(10)	No	*
SMRGCMT_TERM_CODE_EFF	SMRGCMT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGCMT_ACTIVITY_DATE	SMRGCMT_ACTIVITY_DATE	DATE	No
SMRGCMT_TEXT_SEQNO	SMRGCMT_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGCMT_TEXT	SMRGCMT_TEXT	VARCHAR2(60)	Yes
SMRGCMT_PRNT_CODE	SMRGCMT_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRGCMT_GROUP	SMRGLIB_GROUP	SMRGLIB
SMRGCMT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRGCMT_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRGCMT_KEY_INDEX		SMRGCMT_GROUP
SMRGCMT_KEY_INDEX		SMRGCMT_TERM_CODE_EFF
SMRGCMT_KEY_INDEX		SMRGCMT_TEXT_SEQNO

Comments

Source Code Comments

Group Requirement Comments Table

Columns Comments for SMRGCMT_GROUP (1)

Source Code Comments

A group is an entity used to define general requirements and any related detail requirements for use as an area component.

Columns Comments for SMRGCMT_TERM_CODE_EFF (2)

Source Code Comments

Effective term of the group text.

Columns Comments for SMRGCMT_ACTIVITY_DATE (3)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRGCMT_TEXT_SEQNO (4)

Source Code Comments

The sequence number of the group requirement comments.

Columns Comments for SMRGCMT_TEXT (5)

Source Code Comments

Text of the group requirement comments.

Columns Comments for SMRGCMT_PRNT_CODE (6)

Source Code Comments

Print type code.

Table SMRGRCM

Schema Name SATURN
Label SMRGRCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:20:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGRCM_KEY_RULE	SMRGRCM_KEY_RULE	VARCHAR2(10)	No	*
SMRGRCM_GROUP	SMRGRCM_GROUP	VARCHAR2(10)	No	*
SMRGRCM_GROUP	SMRGRCM_GROUP	VARCHAR2(10)	No	*
SMRGRCM_TERM_CODE_EFF	SMRGRCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRCM_TERM_CODE_EFF	SMRGRCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRCM_SMRGRUL_SEQNO	SMRGRCM_SMRGRUL_SEQNO	NUMBER(8,0)	No	*
SMRGRCM_ACTIVITY_DATE	SMRGRCM_ACTIVITY_DATE	DATE	No
SMRGRCM_TEXT_SEQNO	SMRGRCM_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGRCM_TEXT	SMRGRCM_TEXT	VARCHAR2(60)	Yes
SMRGRCM_PRNT_CODE	SMRGRCM_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRGRCM_KEY_RULE	SMRGRUL_KEY_RULE	SMRGRUL
SMRGRCM_GROUP	SMRGRUL_GROUP	SMRGRUL
SMRGRCM_TERM_CODE_EFF	SMRGRUL_TERM_CODE_EFF	SMRGRUL
SMRGRCM_SMRGRUL_SEQNO	SMRGRUL_SEQNO	SMRGRUL
SMRGRCM_GROUP	SMRGLIB_GROUP	SMRGLIB
SMRGRCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRGRCM_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRGRCM_KEY_INDEX		SMRGRCM_KEY_RULE
SMRGRCM_KEY_INDEX		SMRGRCM_GROUP
SMRGRCM_KEY_INDEX		SMRGRCM_TERM_CODE_EFF
SMRGRCM_KEY_INDEX		SMRGRCM_SMRGRUL_SEQNO
SMRGRCM_KEY_INDEX		SMRGRCM_TEXT_SEQNO

Comments

Source Code Comments

Group Rule Attached Course Comment Table

Columns Comments for SMRGRCM_KEY_RULE (1)

Source Code Comments

Rule code.

Columns Comments for SMRGRCM_GROUP (2)

Source Code Comments

Group code.

Columns Comments for SMRGRCM_TERM_CODE_EFF (3)

Source Code Comments

Term code effective date.

Columns Comments for SMRGRCM_SMRGRUL_SEQNO (4)

Source Code Comments

The sequence number of the group course/attribute requirement.

Columns Comments for SMRGRCM_ACTIVITY_DATE (5)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRGRCM_TEXT_SEQNO (6)

Source Code Comments

The sequence number of the group requirement comments.

Columns Comments for SMRGRCM_TEXT (7)

Source Code Comments

Text of the group requirement comments.

Columns Comments for SMRGRCM_PRNT_CODE (8)

Source Code Comments

Print type code.

Table SMRGRGC

Schema Name SATURN
Label SMRGRGC
Server name MALDEV8_B60
Creation Date 08/27/2002 00:01:31:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGRGC_GROUP	SMRGRGC_GROUP	VARCHAR2(10)	No	*
SMRGRGC_TERM_CODE_EFF	SMRGRGC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRGC_GRDE_CODE	SMRGRGC_GRDE_CODE	VARCHAR2(6)	No
SMRGRGC_ACTIVITY_DATE	SMRGRGC_ACTIVITY_DATE	DATE	No
SMRGRGC_TEXT_SEQNO	SMRGRGC_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGRGC_TEXT	SMRGRGC_TEXT	VARCHAR2(60)	Yes
SMRGRGC_PRNT_CODE	SMRGRGC_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRGRGC_GROUP	SMRGLIB_GROUP	SMRGLIB
SMRGRGC_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRGRGC_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRGRGC_KEY_INDEX		SMRGRGC_GROUP
SMRGRGC_KEY_INDEX		SMRGRGC_TERM_CODE_EFF
SMRGRGC_KEY_INDEX		SMRGRGC_GRDE_CODE
SMRGRGC_KEY_INDEX		SMRGRGC_TEXT_SEQNO

Comments

Source Code Comments

Group Restricted Grade Comment Table

Columns Comments for SMRGRGC_GROUP (1)

Source Code Comments

Group code.

Columns Comments for SMRGRGC_TERM_CODE_EFF (2)

Source Code Comments

Term code effective date.

Columns Comments for SMRGRGC_GRDE_CODE (3)

Source Code Comments

The grade code of the group restricted grade requirement.

Columns Comments for SMRGRGC_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRGRGC_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the group requirement comments.

Columns Comments for SMRGRGC_TEXT (6)

Source Code Comments

Text of the group requirement comments.

Columns Comments for SMRGRGC_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRGRLT

Schema Name SATURN
Label SMRGRLT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:20:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGRLT_KEY_RULE	SMRGRLT_KEY_RULE	VARCHAR2(10)	No	*
SMRGRLT_GROUP	SMRGRLT_GROUP	VARCHAR2(10)	No	*
SMRGRLT_GROUP	SMRGRLT_GROUP	VARCHAR2(10)	No	*
SMRGRLT_TERM_CODE_EFF	SMRGRLT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRLT_TERM_CODE_EFF	SMRGRLT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRLT_ACTIVITY_DATE	SMRGRLT_ACTIVITY_DATE	DATE	No
SMRGRLT_TEXT_SEQNO	SMRGRLT_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGRLT_TEXT	SMRGRLT_TEXT	VARCHAR2(60)	Yes
SMRGRLT_PRNT_CODE	SMRGRLT_PRNT_CODE	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRGRLT_GROUP	SMRGLIB_GROUP	SMRGLIB
SMRGRLT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SMRGRLT_KEY_RULE	SMBGRUL_KEY_RULE	SMBGRUL
SMRGRLT_GROUP	SMBGRUL_GROUP	SMBGRUL
SMRGRLT_TERM_CODE_EFF	SMBGRUL_TERM_CODE_EFF	SMBGRUL
SMRGRLT_PRNT_CODE	STVPRNT_CODE	STVPRNT

Index

Index Name	Index Type	Column Name
SMRGRLT_KEY_INDEX		SMRGRLT_KEY_RULE
SMRGRLT_KEY_INDEX		SMRGRLT_GROUP
SMRGRLT_KEY_INDEX		SMRGRLT_TERM_CODE_EFF
SMRGRLT_KEY_INDEX		SMRGRLT_TEXT_SEQNO

Comments

Source Code Comments

Group Course Attachment Rule Comment Table

Columns Comments for SMRGRLT_KEY_RULE (1)

Source Code Comments

A rule is a way to segregate detail requirements which need additional controls over and above the controls already specified for the group detail requirements.

Columns Comments for SMRGRLT_GROUP (2)

Source Code Comments

Group code.

Columns Comments for SMRGRLT_TERM_CODE_EFF (3)

Source Code Comments

Term code effective date.

Columns Comments for SMRGRLT_ACTIVITY_DATE (4)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRGRLT_TEXT_SEQNO (5)

Source Code Comments

The sequence number of the group rule comments.

Columns Comments for SMRGRLT_TEXT (6)

Source Code Comments

Text of the group requirement comments.

Columns Comments for SMRGRLT_PRNT_CODE (7)

Source Code Comments

Print Type Code.

Table SMRGRSC

Schema Name SATURN
Label SMRGRSC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:20:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRGRSC_GROUP	SMRGRSC_GROUP	VARCHAR2(10)	No	*
SMRGRSC_GROUP	SMRGRSC_GROUP	VARCHAR2(10)	No	*
SMRGRSC_TERM_CODE_EFF	SMRGRSC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRSC_TERM_CODE_EFF	SMRGRSC_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRGRSC_SMRGRSA_SEQNO	SMRGRSC_SMRGRSA_SEQNO	NUMBER(8,0)	No	*
SMRGRSC_ACTIVITY_DATE	SMRGRSC_ACTIVITY_DATE	DATE	No
SMRGRSC_TEXT_SEQNO	SMRGRSC_TEXT_SEQNO	NUMBER(23,20)	Yes
SMRGRSC_TEXT	SMRGRSC_TEXT	VARCHAR2(60)	Yes
SMRGRSC_PRNT_CODE	SMRGRSC_PRNT_CODE	VARCHAR2(6)	Yes	*