Model SMRRQCM Base Table

Model Label : Diagram for base tables related to SMRRQCM
Path : BANNER DEV/Student/CAPP/SMRRQCM Base Table

List of Objects

Object Name	Object Type	Layer Name
SMBAOGN	TABLE	Layer(1)
SMBDRRQ	TABLE	Layer(1)
SMBGOGN	TABLE	Layer(1)
SMBGRRQ	TABLE	Layer(1)
SMBPOGN	TABLE	Layer(1)
SMRAOGD	TABLE	Layer(1)
SMRAOLV	TABLE	Layer(1)
SMRAOSA	TABLE	Layer(1)
SMRAOST	TABLE	Layer(1)
SMRDOAN	TABLE	Layer(1)
SMRDOCN	TABLE	Layer(1)
SMRDOEX	TABLE	Layer(1)
SMRDOLV	TABLE	Layer(1)
SMRDORJ	TABLE	Layer(1)
SMRDORQ	TABLE	Layer(1)
SMRDOST	TABLE	Layer(1)
SMRDOUS	TABLE	Layer(1)
SMRDREX	TABLE	Layer(1)
SMRDRLV	TABLE	Layer(1)
SMRDRRQ	TABLE	Layer(1)
SMRGOAT	TABLE	Layer(1)
SMRGOGD	TABLE	Layer(1)
SMRGOLV	TABLE	Layer(1)
SMRGOSA	TABLE	Layer(1)
SMRGRRQ	TABLE	Layer(1)
SMRPCRS	TABLE	Layer(1)
SMRPOAN	TABLE	Layer(1)
SMRPOAT	TABLE	Layer(1)
SMRPOGD	TABLE	Layer(1)
SMRPOLV	TABLE	Layer(1)
SMRPONC	TABLE	Layer(1)
SMRPOSA	TABLE	Layer(1)
SMRPRRQ	TABLE	Layer(1)
SMRRQCM	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 SMBDRRQ

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMBDRRQ_PIDM	SMBDRRQ_PIDM	NUMBER(8,0)	No	*
SMBDRRQ_REQUEST_NO	SMBDRRQ_REQUEST_NO	NUMBER(4,0)	No	*
SMBDRRQ_AREA	SMBDRRQ_AREA	VARCHAR2(10)	No
SMBDRRQ_CAA_SEQNO	SMBDRRQ_CAA_SEQNO	NUMBER(8,0)	No
SMBDRRQ_GROUP	SMBDRRQ_GROUP	VARCHAR2(10)	Yes
SMBDRRQ_KEY_RULE	SMBDRRQ_KEY_RULE	VARCHAR2(10)	No
SMBDRRQ_TERM_CODE_EFF	SMBDRRQ_TERM_CODE_EFF	VARCHAR2(6)	No
SMBDRRQ_PROGRAM	SMBDRRQ_PROGRAM	VARCHAR2(12)	No
SMBDRRQ_MET_IND	SMBDRRQ_MET_IND	VARCHAR2(1)	No
SMBDRRQ_SOURCE_IND	SMBDRRQ_SOURCE_IND	VARCHAR2(1)	No
SMBDRRQ_DESC	SMBDRRQ_DESC	VARCHAR2(30)	No
SMBDRRQ_ACTIVITY_DATE	SMBDRRQ_ACTIVITY_DATE	DATE	No
SMBDRRQ_REQ_CRED_COND	SMBDRRQ_REQ_CRED_COND	NUMBER(11,3)	Yes
SMBDRRQ_CONNECTOR_COND	SMBDRRQ_CONNECTOR_COND	VARCHAR2(1)	No
SMBDRRQ_REQ_COURSES_COND	SMBDRRQ_REQ_COURSES_COND	NUMBER(3,0)	Yes
SMBDRRQ_MAX_CRED_COND	SMBDRRQ_MAX_CRED_COND	NUMBER(11,3)	Yes
SMBDRRQ_CONNECTOR_MAX_COND	SMBDRRQ_CONNECTOR_MAX_COND	VARCHAR2(1)	No
SMBDRRQ_MAX_COURSES_COND	SMBDRRQ_MAX_COURSES_COND	NUMBER(3,0)	Yes
SMBDRRQ_REQ_NUMB_COND	SMBDRRQ_REQ_NUMB_COND	NUMBER(3,0)	Yes
SMBDRRQ_REQ_CREDITS	SMBDRRQ_REQ_CREDITS	NUMBER(11,3)	Yes
SMBDRRQ_CONNECTOR_REQ	SMBDRRQ_CONNECTOR_REQ	VARCHAR2(1)	No
SMBDRRQ_REQ_COURSES	SMBDRRQ_REQ_COURSES	NUMBER(3,0)	Yes
SMBDRRQ_MAX_CREDITS	SMBDRRQ_MAX_CREDITS	NUMBER(11,3)	Yes
SMBDRRQ_CONNECTOR_MAX	SMBDRRQ_CONNECTOR_MAX	VARCHAR2(1)	No
SMBDRRQ_MAX_COURSES	SMBDRRQ_MAX_COURSES	NUMBER(3,0)	Yes
SMBDRRQ_ACT_CREDITS	SMBDRRQ_ACT_CREDITS	NUMBER(11,3)	Yes
SMBDRRQ_ACT_COURSES	SMBDRRQ_ACT_COURSES	NUMBER(3,0)	Yes
SMBDRRQ_ACT_NUMB_COND	SMBDRRQ_ACT_NUMB_COND	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMBDRRQ_PIDM	SMRRQCM_PIDM	SMRRQCM
SMBDRRQ_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM

Index

Index Name	Index Type	Column Name
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_PIDM
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_REQUEST_NO
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_AREA
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_CAA_SEQNO
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_GROUP
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_KEY_RULE
SMBDRRQ_KEY_INDEX	Unique	SMBDRRQ_TERM_CODE_EFF

Comments

Source Code Comments

Detail Area/Group Rule Base Table

Columns Comments for SMBDRRQ_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 SMBDRRQ_REQUEST_NO (2)

Source Code Comments

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

Columns Comments for SMBDRRQ_AREA (3)

Source Code Comments

Area code.

Columns Comments for SMBDRRQ_CAA_SEQNO (4)

Source Code Comments

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

Columns Comments for SMBDRRQ_GROUP (5)

Source Code Comments

Group code.

Columns Comments for SMBDRRQ_KEY_RULE (6)

Source Code Comments

The rule code that defines the course requirements for special conditions.

Columns Comments for SMBDRRQ_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the detail rule requirements.

Columns Comments for SMBDRRQ_PROGRAM (8)

Source Code Comments

Program code.

Columns Comments for SMBDRRQ_MET_IND (9)

Source Code Comments

Met indicator. Y= area/group detail requirement has been met or satisfied. N= area/group detail requirement is not met or satisfied.

Columns Comments for SMBDRRQ_SOURCE_IND (10)

Source Code Comments

Source indicator. O= area/group requirements have been obtained from the original area/group requirements. A= Student adjustment requirements.

Columns Comments for SMBDRRQ_DESC (11)

Source Code Comments

The description of the rule.

Columns Comments for SMBDRRQ_ACTIVITY_DATE (12)

Source Code Comments

Date of most recent activity.

Columns Comments for SMBDRRQ_REQ_CRED_COND (13)

Source Code Comments

Required number of credits per condition.

Columns Comments for SMBDRRQ_CONNECTOR_COND (14)

Source Code Comments

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

Columns Comments for SMBDRRQ_REQ_COURSES_COND (15)

Source Code Comments

Required number of courses per condition.

Columns Comments for SMBDRRQ_MAX_CRED_COND (16)

Source Code Comments

Maximum number of credits per condition.

Columns Comments for SMBDRRQ_CONNECTOR_MAX_COND (17)

Source Code Comments

Rule condition connector used to designate whether max credits and max courses should be considered together or individually as a requirement.

Columns Comments for SMBDRRQ_MAX_COURSES_COND (18)

Source Code Comments

Maximum number of courses per condition.

Columns Comments for SMBDRRQ_REQ_NUMB_COND (19)

Source Code Comments

Required number of conditions for the rule.

Columns Comments for SMBDRRQ_REQ_CREDITS (20)

Source Code Comments

Required number of credits.

Columns Comments for SMBDRRQ_CONNECTOR_REQ (21)

Source Code Comments

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

Columns Comments for SMBDRRQ_REQ_COURSES (22)

Source Code Comments

Required number of courses.

Columns Comments for SMBDRRQ_MAX_CREDITS (23)

Source Code Comments

Maximum number of credits.

Columns Comments for SMBDRRQ_CONNECTOR_MAX (24)

Source Code Comments

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

Columns Comments for SMBDRRQ_MAX_COURSES (25)

Source Code Comments

Maximum number of courses.

Columns Comments for SMBDRRQ_ACT_CREDITS (26)

Source Code Comments

Student's actual number of credits.

Columns Comments for SMBDRRQ_ACT_COURSES (27)

Source Code Comments

Student's actual number of courses.

Columns Comments for SMBDRRQ_ACT_NUMB_COND (28)

Source Code Comments

Actual number of conditions for the rule.

Table SMBGOGN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMBGOGN_PIDM	SMBGOGN_PIDM	NUMBER(8,0)	No	*
SMBGOGN_REQUEST_NO	SMBGOGN_REQUEST_NO	NUMBER(4,0)	No	*
SMBGOGN_AREA	SMBGOGN_AREA	VARCHAR2(10)	No
SMBGOGN_GROUP	SMBGOGN_GROUP	VARCHAR2(10)	No
SMBGOGN_SET	SMBGOGN_SET	VARCHAR2(3)	Yes
SMBGOGN_SUBSET	SMBGOGN_SUBSET	NUMBER(3,0)	Yes
SMBGOGN_PROGRAM	SMBGOGN_PROGRAM	VARCHAR2(12)	No
SMBGOGN_MET_IND	SMBGOGN_MET_IND	VARCHAR2(1)	No
SMBGOGN_SOURCE_IND	SMBGOGN_SOURCE_IND	VARCHAR2(1)	No
SMBGOGN_TERM_CODE_EFF	SMBGOGN_TERM_CODE_EFF	VARCHAR2(6)	No
SMBGOGN_ACTIVE_IND	SMBGOGN_ACTIVE_IND	VARCHAR2(1)	No
SMBGOGN_LEVL_CODE	SMBGOGN_LEVL_CODE	VARCHAR2(2)	No
SMBGOGN_ADDL_LEVEL_IND	SMBGOGN_ADDL_LEVEL_IND	VARCHAR2(1)	No
SMBGOGN_EXCL_LEVEL_IND	SMBGOGN_EXCL_LEVEL_IND	VARCHAR2(1)	No
SMBGOGN_RSTR_S_A_IND	SMBGOGN_RSTR_S_A_IND	VARCHAR2(1)	No
SMBGOGN_RSTR_GRD_IND	SMBGOGN_RSTR_GRD_IND	VARCHAR2(1)	No
SMBGOGN_CRSE_REUSE_IND	SMBGOGN_CRSE_REUSE_IND	VARCHAR2(1)	No
SMBGOGN_ATTR_REUSE_IND	SMBGOGN_ATTR_REUSE_IND	VARCHAR2(1)	No
SMBGOGN_WITHIN_IND	SMBGOGN_WITHIN_IND	VARCHAR2(1)	No
SMBGOGN_GEN_REQ_MET_IND	SMBGOGN_GEN_REQ_MET_IND	VARCHAR2(1)	No
SMBGOGN_DETL_REQ_MET_IND	SMBGOGN_DETL_REQ_MET_IND	VARCHAR2(1)	No
SMBGOGN_ACTIVITY_DATE	SMBGOGN_ACTIVITY_DATE	DATE	No
SMBGOGN_YEAR_RULE	SMBGOGN_YEAR_RULE	NUMBER(2,0)	Yes
SMBGOGN_GRDE_CODE_MIN	SMBGOGN_GRDE_CODE_MIN	VARCHAR2(6)	Yes
SMBGOGN_COMPL_CREDITS	SMBGOGN_COMPL_CREDITS	NUMBER(11,3)	Yes
SMBGOGN_COMPL_COURSES	SMBGOGN_COMPL_COURSES	NUMBER(3,0)	Yes
SMBGOGN_REQ_CREDITS_OVERALL	SMBGOGN_REQ_CREDITS_OVERALL	NUMBER(11,3)	Yes
SMBGOGN_CONNECTOR_OVERALL	SMBGOGN_CONNECTOR_OVERALL	VARCHAR2(1)	No
SMBGOGN_REQ_COURSES_OVERALL	SMBGOGN_REQ_COURSES_OVERALL	NUMBER(3,0)	Yes
SMBGOGN_ACT_CREDITS_OVERALL	SMBGOGN_ACT_CREDITS_OVERALL	NUMBER(11,3)	Yes
SMBGOGN_ACT_COURSES_OVERALL	SMBGOGN_ACT_COURSES_OVERALL	NUMBER(3,0)	Yes
SMBGOGN_REQ_CREDITS_INST	SMBGOGN_REQ_CREDITS_INST	NUMBER(11,3)	Yes
SMBGOGN_CONNECTOR_INST	SMBGOGN_CONNECTOR_INST	VARCHAR2(1)	No
SMBGOGN_REQ_COURSES_INST	SMBGOGN_REQ_COURSES_INST	NUMBER(3,0)	Yes
SMBGOGN_ACT_CREDITS_INST	SMBGOGN_ACT_CREDITS_INST	NUMBER(11,3)	Yes
SMBGOGN_ACT_COURSES_INST	SMBGOGN_ACT_COURSES_INST	NUMBER(3,0)	Yes
SMBGOGN_REQ_CREDITS_I_TRAD	SMBGOGN_REQ_CREDITS_I_TRAD	NUMBER(11,3)	Yes
SMBGOGN_CONNECTOR_I_TRAD	SMBGOGN_CONNECTOR_I_TRAD	VARCHAR2(1)	No
SMBGOGN_REQ_COURSES_I_TRAD	SMBGOGN_REQ_COURSES_I_TRAD	NUMBER(3,0)	Yes
SMBGOGN_ACT_CREDITS_I_TRAD	SMBGOGN_ACT_CREDITS_I_TRAD	NUMBER(11,3)	Yes
SMBGOGN_ACT_COURSES_I_TRAD	SMBGOGN_ACT_COURSES_I_TRAD	NUMBER(3,0)	Yes
SMBGOGN_MAX_CREDITS_I_NONTRAD	SMBGOGN_MAX_CREDITS_I_NONTRAD	NUMBER(11,3)	Yes
SMBGOGN_CONNECTOR_I_NONTRAD	SMBGOGN_CONNECTOR_I_NONTRAD	VARCHAR2(1)	No
SMBGOGN_MAX_COURSES_I_NONTRAD	SMBGOGN_MAX_COURSES_I_NONTRAD	NUMBER(3,0)	Yes
SMBGOGN_ACT_CREDITS_I_NONTRAD	SMBGOGN_ACT_CREDITS_I_NONTRAD	NUMBER(11,3)	Yes
SMBGOGN_ACT_COURSES_I_NONTRAD	SMBGOGN_ACT_COURSES_I_NONTRAD	NUMBER(3,0)	Yes
SMBGOGN_MAX_CREDITS_TRANSFER	SMBGOGN_MAX_CREDITS_TRANSFER	NUMBER(11,3)	Yes
SMBGOGN_CONNECTOR_TRANSFER	SMBGOGN_CONNECTOR_TRANSFER	VARCHAR2(1)	No
SMBGOGN_MAX_COURSES_TRANSFER	SMBGOGN_MAX_COURSES_TRANSFER	NUMBER(3,0)	Yes
SMBGOGN_ACT_CREDITS_TRANSFER	SMBGOGN_ACT_CREDITS_TRANSFER	NUMBER(11,3)	Yes
SMBGOGN_ACT_COURSES_TRANSFER	SMBGOGN_ACT_COURSES_TRANSFER	NUMBER(3,0)	Yes
SMBGOGN_RULE	SMBGOGN_RULE	VARCHAR2(10)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMBGOGN_PIDM	SMRRQCM_PIDM	SMRRQCM
SMBGOGN_REQUEST_NO	SMRRQCM_REQUEST_NO	SMRRQCM

Index

Index Name	Index Type	Column Name
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_PIDM
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_REQUEST_NO
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_AREA
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_GROUP
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_SET
SMBGOGN_KEY_INDEX	Unique	SMBGOGN_SUBSET

Comments

Source Code Comments

General Group Overall Results Table

Columns Comments for SMBGOGN_PIDM (1)

Source Code Comments

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

Columns Comments for SMBGOGN_REQUEST_NO (2)

Source Code Comments

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

Columns Comments for SMBGOGN_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 SMBGOGN_GROUP (4)

Source Code Comments

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

Columns Comments for SMBGOGN_SET (5)

Source Code Comments

The main grouping of group attachments.

Columns Comments for SMBGOGN_SUBSET (6)

Source Code Comments

A subset of the main grouping of group attachments.

Columns Comments for SMBGOGN_PROGRAM (7)

Source Code Comments

A program which already exists on the Program Rules Form.

Columns Comments for SMBGOGN_MET_IND (8)

Source Code Comments

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

Columns Comments for SMBGOGN_SOURCE_IND (9)

Source Code Comments

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

Columns Comments for SMBGOGN_TERM_CODE_EFF (10)

Source Code Comments

Effective term of the general requirements.

Columns Comments for SMBGOGN_ACTIVE_IND (11)

Source Code Comments

Active indicator. Y =active,N = inactive.

Columns Comments for SMBGOGN_LEVL_CODE (12)

Source Code Comments

Level code

Columns Comments for SMBGOGN_ADDL_LEVEL_IND (13)

Source Code Comments

Additional Level indicator

Columns Comments for SMBGOGN_EXCL_LEVEL_IND (14)

Source Code Comments

Exclusion Level indicator

Columns Comments for SMBGOGN_RSTR_S_A_IND (15)

Source Code Comments

Restricted Subject/Atribute indicator

Columns Comments for SMBGOGN_RSTR_GRD_IND (16)

Source Code Comments

Restricted Grade indicator

Columns Comments for SMBGOGN_CRSE_REUSE_IND (17)

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 SMBGOGN_ATTR_REUSE_IND (18)

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 SMBGOGN_WITHIN_IND (19)

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 SMBGOGN_GEN_REQ_MET_IND (20)

Source Code Comments

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

Columns Comments for SMBGOGN_DETL_REQ_MET_IND (21)

Source Code Comments

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

Columns Comments for SMBGOGN_ACTIVITY_DATE (22)

Source Code Comments

Date of most recent activity.

Columns Comments for SMBGOGN_YEAR_RULE (23)

Source Code Comments

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

Columns Comments for SMBGOGN_GRDE_CODE_MIN (24)

Source Code Comments

Minimum grade per course required to complete area.

Columns Comments for SMBGOGN_COMPL_CREDITS (25)

Source Code Comments

Number of compliance credits which will be used to qualify a group for compliance.

Columns Comments for SMBGOGN_COMPL_COURSES (26)

Source Code Comments

Number of compliance courses which will be used to qualify a group for compliance.

Columns Comments for SMBGOGN_REQ_CREDITS_OVERALL (27)

Source Code Comments

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

Columns Comments for SMBGOGN_CONNECTOR_OVERALL (28)

Source Code Comments

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

Columns Comments for SMBGOGN_REQ_COURSES_OVERALL (29)

Source Code Comments

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

Columns Comments for SMBGOGN_ACT_CREDITS_OVERALL (30)

Source Code Comments

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

Columns Comments for SMBGOGN_ACT_COURSES_OVERALL (31)

Source Code Comments

Students's actual number of courses counted toward group overall requirement.

Columns Comments for SMBGOGN_REQ_CREDITS_INST (32)

Source Code Comments

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

Columns Comments for SMBGOGN_CONNECTOR_INST (33)

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 SMBGOGN_REQ_COURSES_INST (34)

Source Code Comments

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

Columns Comments for SMBGOGN_ACT_CREDITS_INST (35)

Source Code Comments

Students's actual number of credits counted toward group institutional requirement.

Columns Comments for SMBGOGN_ACT_COURSES_INST (36)

Source Code Comments

Students's actual number of courses counted toward group institutional requirement.

Columns Comments for SMBGOGN_REQ_CREDITS_I_TRAD (37)

Source Code Comments

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

Columns Comments for SMBGOGN_CONNECTOR_I_TRAD (38)

Source Code Comments

Group 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 SMBGOGN_REQ_COURSES_I_TRAD (39)

Source Code Comments

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

Columns Comments for SMBGOGN_ACT_CREDITS_I_TRAD (40)

Source Code Comments

Students's actual number of credits counted toward group institution traditional requirement.

Columns Comments for SMBGOGN_ACT_COURSES_I_TRAD (41)

Source Code Comments

Students's actual number of courses counted toward group institution traditional requirement.

Columns Comments for SMBGOGN_MAX_CREDITS_I_NONTRAD (42)

Source Code Comments

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

Columns Comments for SMBGOGN_CONNECTOR_I_NONTRAD (43)

Source Code Comments

Group instnon-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 SMBGOGN_MAX_COURSES_I_NONTRAD (44)

Source Code Comments

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

Columns Comments for SMBGOGN_ACT_CREDITS_I_NONTRAD (45)

Source Code Comments

Students's actual number of credits counted toward group institution non-traditional requirements.

Columns Comments for SMBGOGN_ACT_COURSES_I_NONTRAD (46)

Source Code Comments

Students's actual number of courses counted toward group institution non-traditional requirements.

Columns Comments for SMBGOGN_MAX_CREDITS_TRANSFER (47)

Source Code Comments

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

Columns Comments for SMBGOGN_CONNECTOR_TRANSFER (48)

Source Code Comments

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

Columns Comments for SMBGOGN_MAX_COURSES_TRANSFER (49)

Source Code Comments

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