Model STVACTN

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

List of Objects

Object Name	Object Type	Layer Name
SMBAOGN	TABLE	Layer(2)
SMRAOGD	TABLE	Layer(2)
SMRAOLV	TABLE	Layer(2)
SMRAOSA	TABLE	Layer(2)
SMRDOEX	TABLE	Layer(2)
SMRDOLV	TABLE	Layer(2)
SMRDORQ	TABLE	Layer(2)
SMRDOUS	TABLE	Layer(2)
SMRDREX	TABLE	Layer(2)
SMRDRLV	TABLE	Layer(2)
SMRDRRQ	TABLE	Layer(2)
SMRGOAT	TABLE	Layer(2)
SMRGOGD	TABLE	Layer(2)
SMRGOLV	TABLE	Layer(2)
SMRGOSA	TABLE	Layer(2)
SMRGRRQ	TABLE	Layer(2)
SMRPOAT	TABLE	Layer(2)
SMRPOGD	TABLE	Layer(2)
SMRPOLV	TABLE	Layer(2)
SMRPONC	TABLE	Layer(2)
SMRPOSA	TABLE	Layer(2)
SMRSACA	TABLE	Layer(2)
SMRSACE	TABLE	Layer(2)
SMRSACL	TABLE	Layer(2)
SMRSAGM	TABLE	Layer(2)
SMRSAGR	TABLE	Layer(2)
SMRSALV	TABLE	Layer(2)
SMRSARE	TABLE	Layer(2)
SMRSARG	TABLE	Layer(2)
SMRSARL	TABLE	Layer(2)
SMRSARS	TABLE	Layer(2)
SMRSARU	TABLE	Layer(2)
SMRSGCA	TABLE	Layer(2)
SMRSGCE	TABLE	Layer(2)
SMRSGCL	TABLE	Layer(2)
SMRSGLV	TABLE	Layer(2)
SMRSGRE	TABLE	Layer(2)
SMRSGRG	TABLE	Layer(2)
SMRSGRL	TABLE	Layer(2)
SMRSGRS	TABLE	Layer(2)
SMRSGRU	TABLE	Layer(2)
SMRSPAP	TABLE	Layer(2)
SMRSPAT	TABLE	Layer(2)
SMRSPLV	TABLE	Layer(2)
SMRSPNC	TABLE	Layer(2)
SMRSPRG	TABLE	Layer(2)
SMRSPRS	TABLE	Layer(2)
SMRSSUB	TABLE	Layer(2)
SMRSWAV	TABLE	Layer(2)
STVACTN	TABLE	Layer(1)

Comments

Model View

Table SMBAOGN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMBAOGN_PIDM	SMBAOGN_PIDM	NUMBER(8,0)	No	*	*
SMBAOGN_REQUEST_NO	SMBAOGN_REQUEST_NO	NUMBER(4,0)	No	*	*
SMBAOGN_AREA	SMBAOGN_AREA	VARCHAR2(10)	No	*
SMBAOGN_PROGRAM	SMBAOGN_PROGRAM	VARCHAR2(12)	No
SMBAOGN_MET_IND	SMBAOGN_MET_IND	VARCHAR2(1)	No
SMBAOGN_SOURCE_IND	SMBAOGN_SOURCE_IND	VARCHAR2(1)	No
SMBAOGN_TERM_CODE_EFF	SMBAOGN_TERM_CODE_EFF	VARCHAR2(6)	No
SMBAOGN_TERM_CODE_EFF_GROUP	SMBAOGN_TERM_CODE_EFF_GROUP	VARCHAR2(6)	Yes
SMBAOGN_ACTIVE_IND	SMBAOGN_ACTIVE_IND	VARCHAR2(1)	No
SMBAOGN_LEVL_CODE	SMBAOGN_LEVL_CODE	VARCHAR2(2)	No
SMBAOGN_ADDL_LEVEL_IND	SMBAOGN_ADDL_LEVEL_IND	VARCHAR2(1)	No
SMBAOGN_EXCL_LEVEL_IND	SMBAOGN_EXCL_LEVEL_IND	VARCHAR2(1)	No
SMBAOGN_RSTR_S_A_IND	SMBAOGN_RSTR_S_A_IND	VARCHAR2(1)	No
SMBAOGN_RSTR_GRD_IND	SMBAOGN_RSTR_GRD_IND	VARCHAR2(1)	No
SMBAOGN_CRSE_REUSE_IND	SMBAOGN_CRSE_REUSE_IND	VARCHAR2(1)	No
SMBAOGN_ATTR_REUSE_IND	SMBAOGN_ATTR_REUSE_IND	VARCHAR2(1)	No
SMBAOGN_WITHIN_IND	SMBAOGN_WITHIN_IND	VARCHAR2(1)	No
SMBAOGN_GEN_REQ_MET_IND	SMBAOGN_GEN_REQ_MET_IND	VARCHAR2(1)	No
SMBAOGN_DETL_REQ_MET_IND	SMBAOGN_DETL_REQ_MET_IND	VARCHAR2(1)	No
SMBAOGN_DYNAMIC_IND	SMBAOGN_DYNAMIC_IND	VARCHAR2(1)	No
SMBAOGN_ACTIVITY_DATE	SMBAOGN_ACTIVITY_DATE	DATE	No
SMBAOGN_GC_IND	SMBAOGN_GC_IND	VARCHAR2(1)	Yes
SMBAOGN_AREA_PRIORITY	SMBAOGN_AREA_PRIORITY	NUMBER(3,0)	Yes
SMBAOGN_YEAR_RULE	SMBAOGN_YEAR_RULE	NUMBER(2,0)	Yes
SMBAOGN_MIN_AREA_GPA	SMBAOGN_MIN_AREA_GPA	NUMBER(23,9)	Yes
SMBAOGN_ACT_AREA_GPA	SMBAOGN_ACT_AREA_GPA	NUMBER(23,9)	Yes
SMBAOGN_GRDE_CODE_MIN	SMBAOGN_GRDE_CODE_MIN	VARCHAR2(6)	Yes
SMBAOGN_COMPL_CREDITS	SMBAOGN_COMPL_CREDITS	NUMBER(11,3)	Yes
SMBAOGN_COMPL_COURSES	SMBAOGN_COMPL_COURSES	NUMBER(3,0)	Yes
SMBAOGN_REQ_CREDITS_OVERALL	SMBAOGN_REQ_CREDITS_OVERALL	NUMBER(11,3)	Yes
SMBAOGN_CONNECTOR_OVERALL	SMBAOGN_CONNECTOR_OVERALL	VARCHAR2(1)	No
SMBAOGN_REQ_COURSES_OVERALL	SMBAOGN_REQ_COURSES_OVERALL	NUMBER(3,0)	Yes
SMBAOGN_ACT_CREDITS_OVERALL	SMBAOGN_ACT_CREDITS_OVERALL	NUMBER(11,3)	Yes
SMBAOGN_ACT_COURSES_OVERALL	SMBAOGN_ACT_COURSES_OVERALL	NUMBER(3,0)	Yes
SMBAOGN_REQ_CREDITS_INST	SMBAOGN_REQ_CREDITS_INST	NUMBER(11,3)	Yes
SMBAOGN_CONNECTOR_INST	SMBAOGN_CONNECTOR_INST	VARCHAR2(1)	No
SMBAOGN_REQ_COURSES_INST	SMBAOGN_REQ_COURSES_INST	NUMBER(3,0)	Yes
SMBAOGN_ACT_CREDITS_INST	SMBAOGN_ACT_CREDITS_INST	NUMBER(11,3)	Yes
SMBAOGN_ACT_COURSES_INST	SMBAOGN_ACT_COURSES_INST	NUMBER(3,0)	Yes
SMBAOGN_REQ_CREDITS_I_TRAD	SMBAOGN_REQ_CREDITS_I_TRAD	NUMBER(11,3)	Yes
SMBAOGN_CONNECTOR_I_TRAD	SMBAOGN_CONNECTOR_I_TRAD	VARCHAR2(1)	No
SMBAOGN_REQ_COURSES_I_TRAD	SMBAOGN_REQ_COURSES_I_TRAD	NUMBER(3,0)	Yes
SMBAOGN_ACT_CREDITS_I_TRAD	SMBAOGN_ACT_CREDITS_I_TRAD	NUMBER(11,3)	Yes
SMBAOGN_ACT_COURSES_I_TRAD	SMBAOGN_ACT_COURSES_I_TRAD	NUMBER(3,0)	Yes
SMBAOGN_MAX_CREDITS_I_NONTRAD	SMBAOGN_MAX_CREDITS_I_NONTRAD	NUMBER(11,3)	Yes
SMBAOGN_CONNECTOR_I_NONTRAD	SMBAOGN_CONNECTOR_I_NONTRAD	VARCHAR2(1)	No
SMBAOGN_MAX_COURSES_I_NONTRAD	SMBAOGN_MAX_COURSES_I_NONTRAD	NUMBER(3,0)	Yes
SMBAOGN_ACT_CREDITS_I_NONTRAD	SMBAOGN_ACT_CREDITS_I_NONTRAD	NUMBER(11,3)	Yes
SMBAOGN_ACT_COURSES_I_NONTRAD	SMBAOGN_ACT_COURSES_I_NONTRAD	NUMBER(3,0)	Yes
SMBAOGN_MAX_CREDITS_TRANSFER	SMBAOGN_MAX_CREDITS_TRANSFER	NUMBER(11,3)	Yes
SMBAOGN_CONNECTOR_TRANSFER	SMBAOGN_CONNECTOR_TRANSFER	VARCHAR2(1)	No
SMBAOGN_MAX_COURSES_TRANSFER	SMBAOGN_MAX_COURSES_TRANSFER	NUMBER(3,0)	Yes
SMBAOGN_ACT_CREDITS_TRANSFER	SMBAOGN_ACT_CREDITS_TRANSFER	NUMBER(11,3)	Yes
SMBAOGN_ACT_COURSES_TRANSFER	SMBAOGN_ACT_COURSES_TRANSFER	NUMBER(3,0)	Yes
SMBAOGN_ACTN_CODE	SMBAOGN_ACTN_CODE	VARCHAR2(3)	Yes		*
SMBAOGN_ATTACH_SOURCE_IND	SMBAOGN_ATTACH_SOURCE_IND	VARCHAR2(1)	Yes
SMBAOGN_ADJ_CREDITS	SMBAOGN_ADJ_CREDITS	NUMBER(11,3)	Yes
SMBAOGN_ADJ_COURSES	SMBAOGN_ADJ_COURSES	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMBAOGN_ACTN_CODE	STVACTN_CODE	STVACTN
SMBAOGN_PIDM	SMRRQCM_PIDM	SMRRQCM
SMBAOGN_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM

Index

Index Name	Index Type	Column Name
PK_SMBAOGN	Unique	SMBAOGN_PIDM
PK_SMBAOGN	Unique	SMBAOGN_REQUEST_NO
PK_SMBAOGN	Unique	SMBAOGN_AREA

Functional domain

Functional Domain
gpa

Comments

Source Code Comments

General Area Overall Results Table

Columns Comments for SMBAOGN_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area has been designated as unique to a particular student

Columns Comments for SMBAOGN_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated

Columns Comments for SMBAOGN_AREA (3)

Source Code Comments

An area is an entity used to define general requirements and/or detail requirements for a subset of courses.

Columns Comments for SMBAOGN_PROGRAM (4)

Source Code Comments

A program which already exists on the Program Rules Form.

Columns Comments for SMBAOGN_MET_IND (5)

Source Code Comments

Met indicator. Y= overall area has been met or satisfied. N= overall area is not met or satisfied.

Columns Comments for SMBAOGN_SOURCE_IND (6)

Source Code Comments

Source indicator. O= original area requirements. A= student adjustment area requirements.

Columns Comments for SMBAOGN_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the area general requirements.

Columns Comments for SMBAOGN_TERM_CODE_EFF_GROUP (8)

Source Code Comments

Effective term of the group general requirements.

Columns Comments for SMBAOGN_ACTIVE_IND (9)

Source Code Comments

Active indicator. Y = active,N = inactive.

Columns Comments for SMBAOGN_LEVL_CODE (10)

Source Code Comments

Level code

Columns Comments for SMBAOGN_ADDL_LEVEL_IND (11)

Source Code Comments

Additional Level indicator

Columns Comments for SMBAOGN_EXCL_LEVEL_IND (12)

Source Code Comments

Exclusion Level indicator

Columns Comments for SMBAOGN_RSTR_S_A_IND (13)

Source Code Comments

Restricted Subject/Atribute indicator

Columns Comments for SMBAOGN_RSTR_GRD_IND (14)

Source Code Comments

Restricted Grade indicator

Columns Comments for SMBAOGN_CRSE_REUSE_IND (15)

Source Code Comments

This field contains the default course reuse rule which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_ATTR_REUSE_IND (16)

Source Code Comments

This field contains the default attribute reuse rule which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_WITHIN_IND (17)

Source Code Comments

The same course can be used to satisfy more than one distinct detail requirements within a group if value is yes, valid values Y/N.

Columns Comments for SMBAOGN_GEN_REQ_MET_IND (18)

Source Code Comments

Area General Requirement Met Indicator. Y= the area general requirements have been met or satisfied. N= they were not met or satisfied.

Columns Comments for SMBAOGN_DETL_REQ_MET_IND (19)

Source Code Comments

Detail Requirement Met Indicator. Y= the detail component of area requirements has been met or satisfied. N= it is not met or satisfied.

Columns Comments for SMBAOGN_DYNAMIC_IND (20)

Source Code Comments

Indicates whether the area was selected dynamically.

Columns Comments for SMBAOGN_ACTIVITY_DATE (21)

Source Code Comments

Date of most recent activity.

Columns Comments for SMBAOGN_GC_IND (22)

Source Code Comments

Group/Course indicator. Areas may attach either courses or groups as detail. Not both. G = groups attached, C =courses attached.

Columns Comments for SMBAOGN_AREA_PRIORITY (23)

Source Code Comments

This field contains the default priority which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_YEAR_RULE (24)

Source Code Comments

Field containing number of years course requirements may be considered as fullfilling requirements.

Columns Comments for SMBAOGN_MIN_AREA_GPA (25)

Source Code Comments

Minimum Overall GPA required to complete area.

Columns Comments for SMBAOGN_ACT_AREA_GPA (26)

Source Code Comments

Student's actual Overall GPA achieved.

Columns Comments for SMBAOGN_GRDE_CODE_MIN (27)

Source Code Comments

Minimum grade percourse required to complete area.

Columns Comments for SMBAOGN_COMPL_CREDITS (28)

Source Code Comments

Number of compliance credits which will be used to qualify an area for compliance.

Columns Comments for SMBAOGN_COMPL_COURSES (29)

Source Code Comments

Number of compliance courses which will be used to qualify an area for compliance.

Columns Comments for SMBAOGN_REQ_CREDITS_OVERALL (30)

Source Code Comments

Required number of credits which must be taken to complete area overall requirement.

Columns Comments for SMBAOGN_CONNECTOR_OVERALL (31)

Source Code Comments

Area overall connector used to designate whether overall credits and overall courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_OVERALL (32)

Source Code Comments

Required number of courses which must be taken to complete area overall requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_OVERALL (33)

Source Code Comments

Student's actual number of credits counted toward area overall requirement.

Columns Comments for SMBAOGN_ACT_COURSES_OVERALL (34)

Source Code Comments

Student's actual number of courses counted toward area overall requirement.

Columns Comments for SMBAOGN_REQ_CREDITS_INST (35)

Source Code Comments

Required number of credits which must be taken to complete area institutional requirement.

Columns Comments for SMBAOGN_CONNECTOR_INST (36)

Source Code Comments

Area institutional connector used to designate whether institutional credits and institutional courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_INST (37)

Source Code Comments

Required number of courses which must be taken to complete area institutional requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_INST (38)

Source Code Comments

Student's actual number of credits counted toward area institutional requirement.

Columns Comments for SMBAOGN_ACT_COURSES_INST (39)

Source Code Comments

Student's actual number of courses counted toward area institutional requirement.

Columns Comments for SMBAOGN_REQ_CREDITS_I_TRAD (40)

Source Code Comments

Required number of credits which must be taken to complete area institution traditional requirement.

Columns Comments for SMBAOGN_CONNECTOR_I_TRAD (41)

Source Code Comments

Area inst trad connector used to designate whether inst trad credits and inst trad courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_I_TRAD (42)

Source Code Comments

Required number of courses which must be taken to complete area institution traditional requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_I_TRAD (43)

Source Code Comments

Student's actual number of credits counted toward area institution traditional requirement.

Columns Comments for SMBAOGN_ACT_COURSES_I_TRAD (44)

Source Code Comments

Student's actual number of courses counted toward area institution traditional requirement.

Columns Comments for SMBAOGN_MAX_CREDITS_I_NONTRAD (45)

Source Code Comments

Maximum number of institution non-traditional credits which may be used to fill area requirements.

Columns Comments for SMBAOGN_CONNECTOR_I_NONTRAD (46)

Source Code Comments

Area inst non-trad connector used to designate whether inst non-trad credits and inst non-trad courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_MAX_COURSES_I_NONTRAD (47)

Source Code Comments

Maximum number of institution non-traditional courses which may be used to fill area requirements.

Columns Comments for SMBAOGN_ACT_CREDITS_I_NONTRAD (48)

Source Code Comments

Student's actual number of institution non-traditional credits counted toward area requirements.

Columns Comments for SMBAOGN_ACT_COURSES_I_NONTRAD (49)

Source Code Comments

Student's actual number of institution non-traditional courses counted toward area requirements.

Columns Comments for SMBAOGN_MAX_CREDITS_TRANSFER (50)

Source Code Comments

Maximum number of transfer credits which may be used to fill area requirements.

Columns Comments for SMBAOGN_CONNECTOR_TRANSFER (51)

Source Code Comments

Area transfer connector used to designate whether transfer credits and transfer courses should be considered together or individually as a requirement restriction.

Columns Comments for SMBAOGN_MAX_COURSES_TRANSFER (52)

Source Code Comments

Maximum number of transfer courses which may be used to fill area requirements.

Columns Comments for SMBAOGN_ACT_CREDITS_TRANSFER (53)

Source Code Comments

Student's actual number of transfer credits counted toward area requirements.

Columns Comments for SMBAOGN_ACT_COURSES_TRANSFER (54)

Source Code Comments

Student's actual number of transfer courses counted toward area requirements.

Columns Comments for SMBAOGN_ACTN_CODE (55)

Source Code Comments

Student adjustment action code with valid action indicator of (W)aive, (A)dd, or (S)ubstitution.

Columns Comments for SMBAOGN_ATTACH_SOURCE_IND (56)

Source Code Comments

Area attachment source indicator. Valid values: (O)riginal, or (A)djusted.

Columns Comments for SMBAOGN_ADJ_CREDITS (57)

Source Code Comments

Adjusted credits to be counted toward area and program overall totals.

Columns Comments for SMBAOGN_ADJ_COURSES (58)

Source Code Comments

Adjusted courses to be counted toward area and program overall totals.

Table SMRAOGD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMRAOGD_PIDM	SMRAOGD_PIDM	NUMBER(8,0)	No	*	*
SMRAOGD_REQUEST_NO	SMRAOGD_REQUEST_NO	NUMBER(4,0)	No	*	*
SMRAOGD_AREA	SMRAOGD_AREA	VARCHAR2(10)	No	*
SMRAOGD_GRDE_CODE	SMRAOGD_GRDE_CODE	VARCHAR2(6)	No	*
SMRAOGD_PROGRAM	SMRAOGD_PROGRAM	VARCHAR2(12)	No
SMRAOGD_SOURCE_IND	SMRAOGD_SOURCE_IND	VARCHAR2(1)	No
SMRAOGD_TERM_CODE_EFF	SMRAOGD_TERM_CODE_EFF	VARCHAR2(6)	No
SMRAOGD_ACTIVITY_DATE	SMRAOGD_ACTIVITY_DATE	DATE	No
SMRAOGD_MAX_CREDITS	SMRAOGD_MAX_CREDITS	NUMBER(11,3)	Yes
SMRAOGD_CONNECTOR_MAX	SMRAOGD_CONNECTOR_MAX	VARCHAR2(1)	No
SMRAOGD_MAX_COURSES	SMRAOGD_MAX_COURSES	NUMBER(3,0)	Yes
SMRAOGD_ACT_CREDITS	SMRAOGD_ACT_CREDITS	NUMBER(11,3)	Yes
SMRAOGD_ACT_COURSES	SMRAOGD_ACT_COURSES	NUMBER(3,0)	Yes
SMRAOGD_ACTN_CODE	SMRAOGD_ACTN_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRAOGD_PIDM	SMRRQCM_PIDM	SMRRQCM
SMRAOGD_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM
SMRAOGD_ACTN_CODE	STVACTN_CODE	STVACTN

Index

Index Name	Index Type	Column Name
PK_SMRAOGD	Unique	SMRAOGD_PIDM
PK_SMRAOGD	Unique	SMRAOGD_REQUEST_NO
PK_SMRAOGD	Unique	SMRAOGD_AREA
PK_SMRAOGD	Unique	SMRAOGD_GRDE_CODE

Comments

Source Code Comments

Area Restricted Grade Results Table

Columns Comments for SMRAOGD_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area has been designated as unique to a particular student

Columns Comments for SMRAOGD_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated.

Columns Comments for SMRAOGD_AREA (3)

Source Code Comments

An area is an entity used to define general requirements and/or detail requirements for a subset of courses.

Columns Comments for SMRAOGD_GRDE_CODE (4)

Source Code Comments

Restricted grade code.

Columns Comments for SMRAOGD_PROGRAM (5)

Source Code Comments

A program which already has general requirements defined and which has been defined on the Program Rules Screen.

Columns Comments for SMRAOGD_SOURCE_IND (6)

Source Code Comments

Source indicator. O= original area requirements. A= student adjustment area requirements.

Columns Comments for SMRAOGD_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the restricted grade code.

Columns Comments for SMRAOGD_ACTIVITY_DATE (8)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRAOGD_MAX_CREDITS (9)

Source Code Comments

Maximum number of credits allowed per restricted grade code.

Columns Comments for SMRAOGD_CONNECTOR_MAX (10)

Source Code Comments

Maximum connector used to indicate whether maximum credits per grade code and maximum courses per grade code should be considered together or individually.

Columns Comments for SMRAOGD_MAX_COURSES (11)

Source Code Comments

Maximum number of courses allowed per restricted grade code.

Columns Comments for SMRAOGD_ACT_CREDITS (12)

Source Code Comments

Student's actual number of credits counted per restricted grade code.

Columns Comments for SMRAOGD_ACT_COURSES (13)

Source Code Comments

Student's actual number of courses counted per restricted grade code.

Columns Comments for SMRAOGD_ACTN_CODE (14)

Source Code Comments

Student adjustment action code with valid action indicator of (E)liminate, (A)dd, or (S)ubstitution.

Table SMRAOLV

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMRAOLV_PIDM	SMRAOLV_PIDM	NUMBER(8,0)	No	*	*
SMRAOLV_REQUEST_NO	SMRAOLV_REQUEST_NO	NUMBER(4,0)	No	*	*
SMRAOLV_AREA	SMRAOLV_AREA	VARCHAR2(10)	No	*
SMRAOLV_LEVL_CODE	SMRAOLV_LEVL_CODE	VARCHAR2(2)	No	*
SMRAOLV_PROGRAM	SMRAOLV_PROGRAM	VARCHAR2(12)	No
SMRAOLV_SOURCE_IND	SMRAOLV_SOURCE_IND	VARCHAR2(1)	No
SMRAOLV_TERM_CODE_EFF	SMRAOLV_TERM_CODE_EFF	VARCHAR2(6)	No
SMRAOLV_INCL_EXCL_IND	SMRAOLV_INCL_EXCL_IND	VARCHAR2(1)	No
SMRAOLV_ACTIVITY_DATE	SMRAOLV_ACTIVITY_DATE	DATE	No
SMRAOLV_GRDE_CODE_MIN	SMRAOLV_GRDE_CODE_MIN	VARCHAR2(6)	Yes
SMRAOLV_MAX_CREDITS	SMRAOLV_MAX_CREDITS	NUMBER(11,3)	Yes
SMRAOLV_CONNECTOR_MAX	SMRAOLV_CONNECTOR_MAX	VARCHAR2(1)	No
SMRAOLV_MAX_COURSES	SMRAOLV_MAX_COURSES	NUMBER(3,0)	Yes
SMRAOLV_ACT_CREDITS	SMRAOLV_ACT_CREDITS	NUMBER(11,3)	Yes
SMRAOLV_ACT_COURSES	SMRAOLV_ACT_COURSES	NUMBER(3,0)	Yes
SMRAOLV_ACTN_CODE	SMRAOLV_ACTN_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRAOLV_PIDM	SMRRQCM_PIDM	SMRRQCM
SMRAOLV_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM
SMRAOLV_ACTN_CODE	STVACTN_CODE	STVACTN

Index

Index Name	Index Type	Column Name
PK_SMRAOLV	Unique	SMRAOLV_PIDM
PK_SMRAOLV	Unique	SMRAOLV_REQUEST_NO
PK_SMRAOLV	Unique	SMRAOLV_AREA
PK_SMRAOLV	Unique	SMRAOLV_LEVL_CODE

Comments

Source Code Comments

Area Additional Level Results Table

Columns Comments for SMRAOLV_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area has been designated as unique to a particular student

Columns Comments for SMRAOLV_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated

Columns Comments for SMRAOLV_AREA (3)

Source Code Comments

An area is an entity used to define general requirements and/or detail requirements for a subset of courses.

Columns Comments for SMRAOLV_LEVL_CODE (4)

Source Code Comments

Level code

Columns Comments for SMRAOLV_PROGRAM (5)

Source Code Comments

A program which already exists on the Program Rules Form.

Columns Comments for SMRAOLV_SOURCE_IND (6)

Source Code Comments

Source indicator. O= original area requirements. A= student adjustment area requirements.

Columns Comments for SMRAOLV_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the general requirements.

Columns Comments for SMRAOLV_INCL_EXCL_IND (8)

Source Code Comments

Include/Exclude indicator

Columns Comments for SMRAOLV_ACTIVITY_DATE (9)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRAOLV_GRDE_CODE_MIN (10)

Source Code Comments

Minimum grade percourse required to complete area.

Columns Comments for SMRAOLV_MAX_CREDITS (11)

Source Code Comments

Maximum number of transfer credits which may be used to fill area requirements.

Columns Comments for SMRAOLV_CONNECTOR_MAX (12)

Source Code Comments

Area transfer connector used to designate whether transfer credits and transfer courses should be considered together or individually as a requirement restriction.

Columns Comments for SMRAOLV_MAX_COURSES (13)

Source Code Comments

Maximum number of transfer courses which may be used to fill area requirements.

Columns Comments for SMRAOLV_ACT_CREDITS (14)

Source Code Comments

Student's actual number of transfer credits counted toward area requirements.

Columns Comments for SMRAOLV_ACT_COURSES (15)

Source Code Comments

Student's actual number of transfer courses counted toward area requirements.

Columns Comments for SMRAOLV_ACTN_CODE (16)

Source Code Comments

Student adjustment action code with valid action indicator of (E)liminate, (A)dd, or (S)ubstitution.

Table SMRAOSA

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMRAOSA_PIDM	SMRAOSA_PIDM	NUMBER(8,0)	No	*	*
SMRAOSA_REQUEST_NO	SMRAOSA_REQUEST_NO	NUMBER(4,0)	No	*	*
SMRAOSA_AREA	SMRAOSA_AREA	VARCHAR2(10)	No	*
SMRAOSA_ARSA_SEQNO	SMRAOSA_ARSA_SEQNO	NUMBER(8,0)	No	*
SMRAOSA_PROGRAM	SMRAOSA_PROGRAM	VARCHAR2(12)	No
SMRAOSA_SOURCE_IND	SMRAOSA_SOURCE_IND	VARCHAR2(1)	No
SMRAOSA_TERM_CODE_EFF	SMRAOSA_TERM_CODE_EFF	VARCHAR2(6)	No
SMRAOSA_ACTIVITY_DATE	SMRAOSA_ACTIVITY_DATE	DATE	No
SMRAOSA_SUBJ_CODE	SMRAOSA_SUBJ_CODE	VARCHAR2(4)	Yes
SMRAOSA_CRSE_NUMB_LOW	SMRAOSA_CRSE_NUMB_LOW	VARCHAR2(5)	Yes
SMRAOSA_CRSE_NUMB_HIGH	SMRAOSA_CRSE_NUMB_HIGH	VARCHAR2(5)	Yes
SMRAOSA_ATTR_CODE	SMRAOSA_ATTR_CODE	VARCHAR2(4)	Yes
SMRAOSA_CAMP_CODE	SMRAOSA_CAMP_CODE	VARCHAR2(3)	Yes
SMRAOSA_COLL_CODE	SMRAOSA_COLL_CODE	VARCHAR2(2)	Yes
SMRAOSA_DEPT_CODE	SMRAOSA_DEPT_CODE	VARCHAR2(4)	Yes
SMRAOSA_MAX_CREDITS	SMRAOSA_MAX_CREDITS	NUMBER(11,3)	Yes
SMRAOSA_CONNECTOR_MAX	SMRAOSA_CONNECTOR_MAX	VARCHAR2(1)	No
SMRAOSA_MAX_COURSES	SMRAOSA_MAX_COURSES	NUMBER(3,0)	Yes
SMRAOSA_ACT_CREDITS	SMRAOSA_ACT_CREDITS	NUMBER(11,3)	Yes
SMRAOSA_ACT_COURSES	SMRAOSA_ACT_COURSES	NUMBER(3,0)	Yes
SMRAOSA_ACTN_CODE	SMRAOSA_ACTN_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRAOSA_PIDM	SMRRQCM_PIDM	SMRRQCM
SMRAOSA_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM
SMRAOSA_ACTN_CODE	STVACTN_CODE	STVACTN

Index

Index Name	Index Type	Column Name
PK_SMRAOSA	Unique	SMRAOSA_PIDM
PK_SMRAOSA	Unique	SMRAOSA_REQUEST_NO
PK_SMRAOSA	Unique	SMRAOSA_AREA
PK_SMRAOSA	Unique	SMRAOSA_ARSA_SEQNO

Comments

Source Code Comments

Area Restricted Subject/Attribute Results Table

Columns Comments for SMRAOSA_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area has been designated as unique to a particular student

Columns Comments for SMRAOSA_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated.

Columns Comments for SMRAOSA_AREA (3)

Source Code Comments

An area is an entity used to define general requirements and/or detail requirements for a subset of courses.

Columns Comments for SMRAOSA_ARSA_SEQNO (4)

Source Code Comments

The sequence number of the area subject/attribute requirements.

Columns Comments for SMRAOSA_PROGRAM (5)

Source Code Comments

A program which already has genera l requirements defined and which has been defined on the Program Rules Screen.

Columns Comments for SMRAOSA_SOURCE_IND (6)

Source Code Comments

Source indicator. O= original area requirements. A= student adjustment area requirements.

Columns Comments for SMRAOSA_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the area subject/attribute requirements.

Columns Comments for SMRAOSA_ACTIVITY_DATE (8)

Source Code Comments

Date of most recent activity .

Columns Comments for SMRAOSA_SUBJ_CODE (9)

Source Code Comments

Restricted subject code.

Columns Comments for SMRAOSA_CRSE_NUMB_LOW (10)

Source Code Comments

Restricted low course number .

Columns Comments for SMRAOSA_CRSE_NUMB_HIGH (11)

Source Code Comments

Restricted high course number.

Columns Comments for SMRAOSA_ATTR_CODE (12)

Source Code Comments

Restricted attribute code for Courses.

Columns Comments for SMRAOSA_CAMP_CODE (13)

Source Code Comments

Campus Code.

Columns Comments for SMRAOSA_COLL_CODE (14)

Source Code Comments

College Code.

Columns Comments for SMRAOSA_DEPT_CODE (15)

Source Code Comments

Department Code.

Columns Comments for SMRAOSA_MAX_CREDITS (16)

Source Code Comments

Maximum number of credits which may be taken to complete area requirement.

Columns Comments for SMRAOSA_CONNECTOR_MAX (17)

Source Code Comments

Area maximum connector used to designate whether maximum credits and maximum courses should be considered together or individually as a restriction.

Columns Comments for SMRAOSA_MAX_COURSES (18)

Source Code Comments

Maximum number of courses which may be taken to complete area requirement.

Columns Comments for SMRAOSA_ACT_CREDITS (19)

Source Code Comments

Student's actual number of credits counted toward area requirement.

Columns Comments for SMRAOSA_ACT_COURSES (20)

Source Code Comments

Student's actual number of courses counted toward area requirement.

Columns Comments for SMRAOSA_ACTN_CODE (21)

Source Code Comments

Student adjustment action code with valid action indicator of (E)liminate, (A)dd, or (S)ubstitution.

Table SMRDOEX

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRDOEX_PIDM	SMRDOEX_PIDM	NUMBER(8,0)	No	*
SMRDOEX_REQUEST_NO	SMRDOEX_REQUEST_NO	NUMBER(4,0)	No	*
SMRDOEX_AREA	SMRDOEX_AREA	VARCHAR2(10)	No
SMRDOEX_CAA_SEQNO	SMRDOEX_CAA_SEQNO	NUMBER(8,0)	No
SMRDOEX_GROUP	SMRDOEX_GROUP	VARCHAR2(10)	Yes
SMRDOEX_PROGRAM	SMRDOEX_PROGRAM	VARCHAR2(12)	No
SMRDOEX_TERM_CODE_EFF	SMRDOEX_TERM_CODE_EFF	VARCHAR2(6)	No
SMRDOEX_SOURCE_IND	SMRDOEX_SOURCE_IND	VARCHAR2(1)	No
SMRDOEX_ACTIVITY_DATE	SMRDOEX_ACTIVITY_DATE	DATE	No
SMRDOEX_SUBJ_CODE	SMRDOEX_SUBJ_CODE	VARCHAR2(4)	Yes
SMRDOEX_CRSE_NUMB_LOW	SMRDOEX_CRSE_NUMB_LOW	VARCHAR2(5)	Yes
SMRDOEX_CRSE_NUMB_HIGH	SMRDOEX_CRSE_NUMB_HIGH	VARCHAR2(5)	Yes
SMRDOEX_ATTR_CODE	SMRDOEX_ATTR_CODE	VARCHAR2(4)	Yes
SMRDOEX_ATTS_CODE	SMRDOEX_ATTS_CODE	VARCHAR2(4)	Yes
SMRDOEX_CAMP_CODE	SMRDOEX_CAMP_CODE	VARCHAR2(3)	Yes
SMRDOEX_COLL_CODE	SMRDOEX_COLL_CODE	VARCHAR2(2)	Yes
SMRDOEX_DEPT_CODE	SMRDOEX_DEPT_CODE	VARCHAR2(4)	Yes
SMRDOEX_TERM_CODE_START	SMRDOEX_TERM_CODE_START	VARCHAR2(6)	Yes
SMRDOEX_TERM_CODE_END	SMRDOEX_TERM_CODE_END	VARCHAR2(6)	Yes
SMRDOEX_ACTN_CODE	SMRDOEX_ACTN_CODE	VARCHAR2(3)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRDOEX_PIDM	SMRRQCM_PIDM	SMRRQCM
SMRDOEX_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM
SMRDOEX_ACTN_CODE	STVACTN_CODE	STVACTN

Index

Index Name	Index Type	Column Name
SMRDOEX_KEY_INDEX		SMRDOEX_PIDM
SMRDOEX_KEY_INDEX		SMRDOEX_REQUEST_NO
SMRDOEX_KEY_INDEX		SMRDOEX_AREA
SMRDOEX_KEY_INDEX		SMRDOEX_CAA_SEQNO
SMRDOEX_KEY_INDEX		SMRDOEX_GROUP

Comments

Source Code Comments

Detail Area/Group Exclusions Table

Columns Comments for SMRDOEX_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area/group has been designated as unique to a particular student

Columns Comments for SMRDOEX_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated

Columns Comments for SMRDOEX_AREA (3)

Source Code Comments

Exclusion Area code.

Columns Comments for SMRDOEX_CAA_SEQNO (4)

Source Code Comments

The sequence number of the area/group course/attribute detail exclusion requirement.

Columns Comments for SMRDOEX_GROUP (5)

Source Code Comments

Exclusion Group code.