Model STVATTS

Model Label : ERD for Banner Student STVATTS Table

Path : BANNER DEV/Student/Common/STVATTS/STVATTS_ERD

List of Objects

Object Name	Object Type	Layer Name
SARAATT	TABLE	Default
SFRRGFE	TABLE	Default
SGRCATT	TABLE	Default
SGRSATT	TABLE	Default
SMRACAA	TABLE	Default
SMRAEXL	TABLE	Default
SMRAQUA	TABLE	Default
SMRAREX	TABLE	Default
SMRARUL	TABLE	Default
SMRGCAA	TABLE	Default
SMRGEXL	TABLE	Default
SMRGREX	TABLE	Default
SMRGRUL	TABLE	Default
SMRIEAT	TABLE	Default
SMRPATR	TABLE	Default
SMRSACA	TABLE	Default
SMRSACE	TABLE	Default
SMRSARE	TABLE	Default
SMRSARU	TABLE	Default
SMRSGCA	TABLE	Default
SMRSGCE	TABLE	Default
SMRSGRE	TABLE	Default
SMRSGRU	TABLE	Default
SMRSPAT	TABLE	Default
SRRRATT	TABLE	Default
STVATTS	TABLE	Default

Comments

Model View

Table SARAATT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SARAATT_PIDM	SARAATT_PIDM	NUMBER(8,0)	No	*
SARAATT_TERM_CODE	SARAATT_TERM_CODE	VARCHAR2(6)	No	*	*
SARAATT_APPL_NO	SARAATT_APPL_NO	NUMBER(2,0)	No	*
SARAATT_ATTS_CODE	SARAATT_ATTS_CODE	VARCHAR2(4)	No	*	*
SARAATT_ACTIVITY_DATE	SARAATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARAATT_ATTS_CODE	STVATTS_CODE	STVATTS
SARAATT_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SARAATT	Unique	SARAATT_PIDM
PK_SARAATT	Unique	SARAATT_TERM_CODE
PK_SARAATT	Unique	SARAATT_APPL_NO
PK_SARAATT	Unique	SARAATT_ATTS_CODE

Comments

Source Code Comments

Admissions Attribute Repeating Table.

Columns Comments for SARAATT_PIDM (1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SARAATT_TERM_CODE (2)

Source Code Comments

The term associated with the attributes.

Columns Comments for SARAATT_APPL_NO (3)

Source Code Comments

The Application Number associated with the attributes.

Columns Comments for SARAATT_ATTS_CODE (4)

Source Code Comments

The admissions attributes for the person and term.

Columns Comments for SARAATT_ACTIVITY_DATE (5)

Source Code Comments

The date the record was last updated.

Table SFRRGFE

Schema Name SATURN
Label SFRRGFE
Server name MALDEV8_B60
Creation Date 01/18/2003 23:46:02:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRRGFE_TERM_CODE	SFRRGFE_TERM_CODE	VARCHAR2(6)	No	*	*
SFRRGFE_TERM_CODE	SFRRGFE_TERM_CODE	VARCHAR2(6)	No	*	*
SFRRGFE_DETL_CODE	SFRRGFE_DETL_CODE	VARCHAR2(4)	No		*
SFRRGFE_ACTIVITY_DATE	SFRRGFE_ACTIVITY_DATE	DATE	No
SFRRGFE_PER_CRED_CHARGE	SFRRGFE_PER_CRED_CHARGE	NUMBER(6,2)	No
SFRRGFE_MIN_CHARGE	SFRRGFE_MIN_CHARGE	NUMBER(12,2)	No
SFRRGFE_MAX_CHARGE	SFRRGFE_MAX_CHARGE	NUMBER(12,2)	No
SFRRGFE_PTRM_CODE	SFRRGFE_PTRM_CODE	VARCHAR2(3)	Yes		*
SFRRGFE_RESD_CODE	SFRRGFE_RESD_CODE	VARCHAR2(1)	Yes		*
SFRRGFE_RESD_CODE	SFRRGFE_RESD_CODE	VARCHAR2(1)	Yes		*
SFRRGFE_LEVL_CODE	SFRRGFE_LEVL_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_LEVL_CODE	SFRRGFE_LEVL_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_COLL_CODE	SFRRGFE_COLL_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_COLL_CODE	SFRRGFE_COLL_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_MAJR_CODE	SFRRGFE_MAJR_CODE	VARCHAR2(4)	Yes		*
SFRRGFE_MAJR_CODE	SFRRGFE_MAJR_CODE	VARCHAR2(4)	Yes		*
SFRRGFE_CLAS_CODE	SFRRGFE_CLAS_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_RATE_CODE	SFRRGFE_RATE_CODE	VARCHAR2(5)	Yes		*
SFRRGFE_RATE_CODE	SFRRGFE_RATE_CODE	VARCHAR2(5)	Yes		*
SFRRGFE_CRSE_WAIV_IND	SFRRGFE_CRSE_WAIV_IND	VARCHAR2(1)	Yes
SFRRGFE_FROM_CRED_HRS	SFRRGFE_FROM_CRED_HRS	NUMBER(9,3)	Yes
SFRRGFE_TO_CRED_HRS	SFRRGFE_TO_CRED_HRS	NUMBER(9,3)	Yes
SFRRGFE_FROM_ADD_DATE	SFRRGFE_FROM_ADD_DATE	DATE	Yes
SFRRGFE_TO_ADD_DATE	SFRRGFE_TO_ADD_DATE	DATE	Yes
SFRRGFE_TYPE	SFRRGFE_TYPE	VARCHAR2(7)	No	*	*
SFRRGFE_CAMP_CODE	SFRRGFE_CAMP_CODE	VARCHAR2(3)	Yes		*
SFRRGFE_CAMP_CODE	SFRRGFE_CAMP_CODE	VARCHAR2(3)	Yes		*
SFRRGFE_LEVL_CODE_CRSE	SFRRGFE_LEVL_CODE_CRSE	VARCHAR2(2)	Yes		*
SFRRGFE_CAMP_CODE_CRSE	SFRRGFE_CAMP_CODE_CRSE	VARCHAR2(3)	Yes		*
SFRRGFE_ENTRY_TYPE	SFRRGFE_ENTRY_TYPE	VARCHAR2(1)	No
SFRRGFE_FROM_STUD_HRS	SFRRGFE_FROM_STUD_HRS	NUMBER(9,3)	Yes
SFRRGFE_TO_STUD_HRS	SFRRGFE_TO_STUD_HRS	NUMBER(9,3)	Yes
SFRRGFE_CRED_IND	SFRRGFE_CRED_IND	VARCHAR2(1)	No
SFRRGFE_FLAT_HRS	SFRRGFE_FLAT_HRS	NUMBER(9,3)	Yes
SFRRGFE_COPY_IND	SFRRGFE_COPY_IND	VARCHAR2(1)	No
SFRRGFE_SEQNO	SFRRGFE_SEQNO	NUMBER(8,0)	No	*	*
SFRRGFE_PROGRAM	SFRRGFE_PROGRAM	VARCHAR2(12)	Yes		*
SFRRGFE_DEPT_CODE	SFRRGFE_DEPT_CODE	VARCHAR2(4)	Yes		*
SFRRGFE_DEGC_CODE	SFRRGFE_DEGC_CODE	VARCHAR2(6)	Yes		*
SFRRGFE_STYP_CODE	SFRRGFE_STYP_CODE	VARCHAR2(1)	Yes		*
SFRRGFE_TERM_CODE_ADMIT	SFRRGFE_TERM_CODE_ADMIT	VARCHAR2(6)	Yes		*
SFRRGFE_ATTR_CODE_CRSE	SFRRGFE_ATTR_CODE_CRSE	VARCHAR2(4)	Yes		*
SFRRGFE_ATTR_CODE_CRSE	SFRRGFE_ATTR_CODE_CRSE	VARCHAR2(4)	Yes		*
SFRRGFE_ATTS_CODE	SFRRGFE_ATTS_CODE	VARCHAR2(4)	Yes		*
SFRRGFE_GMOD_CODE	SFRRGFE_GMOD_CODE	VARCHAR2(1)	Yes		*
SFRRGFE_ASSESS_BY_COURSE_IND	SFRRGFE_ASSESS_BY_COURSE_IND	VARCHAR2(1)	No
SFRRGFE_USER_ID	SFRRGFE_USER_ID	VARCHAR2(30)	No
SFRRGFE_FROM_FLAT_HRS	SFRRGFE_FROM_FLAT_HRS	NUMBER(9,3)	Yes
SFRRGFE_TO_FLAT_HRS	SFRRGFE_TO_FLAT_HRS	NUMBER(9,3)	Yes
SFRRGFE_FLAT_FEE_AMOUNT	SFRRGFE_FLAT_FEE_AMOUNT	NUMBER(12,2)	Yes		*
SFRRGFE_CRSE_OVERLOAD_START_HR	SFRRGFE_CRSE_OVERLOAD_START_HR	NUMBER(9,3)	Yes
SFRRGFE_INSM_CODE	SFRRGFE_INSM_CODE	VARCHAR2(5)	Yes		*
SFRRGFE_SCHD_CODE	SFRRGFE_SCHD_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRRGFE_INSM_CODE	GTVINSM_CODE	GTVINSM
SFRRGFE_CLAS_CODE	STVCLAS_CODE	STVCLAS
SFRRGFE_RESD_CODE	STVRESD_CODE	STVRESD
SFRRGFE_SCHD_CODE	STVSCHD_CODE	STVSCHD
SFRRGFE_PTRM_CODE	STVPTRM_CODE	STVPTRM
SFRRGFE_STYP_CODE	STVSTYP_CODE	STVSTYP
SFRRGFE_ATTR_CODE_CRSE	STVATTR_CODE	STVATTR
SFRRGFE_ATTS_CODE	STVATTS_CODE	STVATTS
SFRRGFE_RATE_CODE	STVRATE_CODE	STVRATE
SFRRGFE_COLL_CODE	STVCOLL_CODE	STVCOLL
SFRRGFE_MAJR_CODE	STVMAJR_CODE	STVMAJR
SFRRGFE_DEGC_CODE	STVDEGC_CODE	STVDEGC
SFRRGFE_DEPT_CODE	STVDEPT_CODE	STVDEPT
SFRRGFE_TERM_CODE_ADMIT	STVTERM_CODE	STVTERM
SFRRGFE_GMOD_CODE	STVGMOD_CODE	STVGMOD
SFRRGFE_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE
SFRRGFE_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SFRRGFE_DETL_CODE	TBBDETC_DETAIL_CODE	TBBDETC
SFRRGFE_RESD_CODE	SGBSTDN_RESD_CODE	SGBSTDN
SFRRGFE_LEVL_CODE	SGBSTDN_LEVL_CODE	SGBSTDN
SFRRGFE_COLL_CODE	SGBSTDN_COLL_CODE_1	SGBSTDN
SFRRGFE_MAJR_CODE	SGBSTDN_MAJR_CODE_1	SGBSTDN
SFRRGFE_RATE_CODE	SGBSTDN_RATE_CODE	SGBSTDN
SFRRGFE_CAMP_CODE	SGBSTDN_CAMP_CODE	SGBSTDN
SFRRGFE_TYPE	SFRFAUD_RGFE_TYPE	SFRFAUD
SFRRGFE_SEQNO	SFRFAUD_RGFE_SEQNO	SFRFAUD
SFRRGFE_FLAT_FEE_AMOUNT	SFRFAUD_FLAT_FEE_AMOUNT	SFRFAUD
SFRRGFE_TERM_CODE	SSRATTR_TERM_CODE	SSRATTR
SFRRGFE_ATTR_CODE_CRSE	SSRATTR_ATTR_CODE	SSRATTR

Index

Index Name	Index Type	Column Name
PK_SFRRGFE	Unique	SFRRGFE_TERM_CODE
PK_SFRRGFE	Unique	SFRRGFE_TYPE
PK_SFRRGFE	Unique	SFRRGFE_SEQNO

Comments

Source Code Comments

Registration Fees Table

Columns Comments for SFRRGFE_TERM_CODE (1)

Source Code Comments

Registration term.

Columns Comments for SFRRGFE_DETL_CODE (2)

Source Code Comments

Detail code that the determined charges for this rule will be posted to.

Columns Comments for SFRRGFE_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for SFRRGFE_PER_CRED_CHARGE (4)

Source Code Comments

Per hour charge amount to use when calculating per credit charges for this rule.

Columns Comments for SFRRGFE_MIN_CHARGE (5)

Source Code Comments

Minimum charge that can be posted when this rule is being applied.

Columns Comments for SFRRGFE_MAX_CHARGE (6)

Source Code Comments

Maximum charge that can be posted when this rule is being applied.

Columns Comments for SFRRGFE_PTRM_CODE (7)

Source Code Comments

Part-of-term code for the student's course registration (STVPTRM).

Columns Comments for SFRRGFE_RESD_CODE (8)

Source Code Comments

Student's residency code (STVRESD).

Columns Comments for SFRRGFE_LEVL_CODE (9)

Source Code Comments

Student's level code (STVLEVL).

Columns Comments for SFRRGFE_COLL_CODE (10)

Source Code Comments

Student's college code (STVCOLL).

Columns Comments for SFRRGFE_MAJR_CODE (11)

Source Code Comments

Student's major code (STVMAJR).

Columns Comments for SFRRGFE_CLAS_CODE (12)

Source Code Comments

Student's class code (STVCLAS).

Columns Comments for SFRRGFE_RATE_CODE (13)

Source Code Comments

Student's rate code (STVRATE).

Columns Comments for SFRRGFE_CRSE_WAIV_IND (14)

Source Code Comments

Flag to indicate that this rule can be skipped if the course is marked as being exempt from rule assessment processing (SFRSTCR_WAIV_HR = 0). Valid values are Y and N.

Columns Comments for SFRRGFE_FROM_CRED_HRS (15)

Source Code Comments

Low end of the course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_TO_CRED_HRS (16)

Source Code Comments

High end of the course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_FROM_ADD_DATE (17)

Source Code Comments

The starting initial course registration date that defines the low end for the qualifying registration date range.

Columns Comments for SFRRGFE_TO_ADD_DATE (18)

Source Code Comments

The ending initial course registration date that defines the high end for the qualifying registration date range.

Columns Comments for SFRRGFE_TYPE (19)

Source Code Comments

Type of assessment rule. Valid values are STUDENT, LEVEL (course level), CAMPUS (course campus)and ATTR (course attribute).

Columns Comments for SFRRGFE_CAMP_CODE (20)

Source Code Comments

Student's campus code (STVCAMP).

Columns Comments for SFRRGFE_LEVL_CODE_CRSE (21)

Source Code Comments

Course level code (STVLEVL).

Columns Comments for SFRRGFE_CAMP_CODE_CRSE (22)

Source Code Comments

Course campus code (STVCAMP).

Columns Comments for SFRRGFE_ENTRY_TYPE (23)

Source Code Comments

Assessment type. Valid values are 'R'egistration or 'P're-registration assessment.

Columns Comments for SFRRGFE_FROM_STUD_HRS (24)

Source Code Comments

Low end of the total course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_TO_STUD_HRS (25)

Source Code Comments

High end of the total course hours range to use when determining if a student qualifies for this rule.

Columns Comments for SFRRGFE_CRED_IND (26)

Source Code Comments

When the rule course waive indicator (SFRRGFE_CRSE_WAIV_IND) is set to 'Y', this flag indicates the hours to use in rule hour determination: 'N' indicates to use waive hours; 'Y' indicates to use bill h
ours.

Columns Comments for SFRRGFE_FLAT_HRS (27)

Source Code Comments

This column is no longer used.

Columns Comments for SFRRGFE_COPY_IND (28)

Source Code Comments

Flag to denote that this rule is able to be copied forward to another term for maintenance/data entry sake. Valid values are Y or N.

Columns Comments for SFRRGFE_SEQNO (29)

Source Code Comments

Unique one up number defined within term code and rule type. This will uniquely identify the rule.

Columns Comments for SFRRGFE_PROGRAM (30)

Source Code Comments

Student's general student program (SMRPRLE_PROGRAM).

Columns Comments for SFRRGFE_DEPT_CODE (31)

Source Code Comments

Student's general student department code (STVDEPT).

Columns Comments for SFRRGFE_DEGC_CODE (32)

Source Code Comments

Student's general student degree code (STVDEGC).

Columns Comments for SFRRGFE_STYP_CODE (33)

Source Code Comments

Student's general student - student type code (STVSTYP).

Columns Comments for SFRRGFE_TERM_CODE_ADMIT (34)

Source Code Comments

Student's general student admit term code.

Columns Comments for SFRRGFE_ATTR_CODE_CRSE (35)

Source Code Comments

Course attribute as defined on the course schedule (STVATTR).

Columns Comments for SFRRGFE_ATTS_CODE (36)

Source Code Comments

Student's general student attribute code (STVATTS).

Columns Comments for SFRRGFE_GMOD_CODE (37)

Source Code Comments

Student's grade mod code on the course registration record.(STVGMOD).

Columns Comments for SFRRGFE_ASSESS_BY_COURSE_IND (38)

Source Code Comments

Flag to indicate whether or not to assess charges by course. Valid values are Y or N.

Columns Comments for SFRRGFE_USER_ID (39)

Source Code Comments

ID of the user who created or last updated this record.

Columns Comments for SFRRGFE_FROM_FLAT_HRS (40)

Source Code Comments

Low end of the hours range to use when determining if a student qualifies for a flat fee.

Columns Comments for SFRRGFE_TO_FLAT_HRS (41)

Source Code Comments

High end of the hours range to use when determining if a student qualifies for a flat fee. These hours also serve as the starting point for additional per credit charges for flat plus per credit processing
or for a high credit hour charge.

Columns Comments for SFRRGFE_FLAT_FEE_AMOUNT (42)

Source Code Comments

Flat fee amount to charge for students whose course hours are within the flat hour range for the rule.

Columns Comments for SFRRGFE_CRSE_OVERLOAD_START_HR (43)

Source Code Comments

Starting hours for plus per credit charging used in 'flat and plus per credit' charging.

Columns Comments for SFRRGFE_INSM_CODE (44)

Source Code Comments

Instructional method for course.

Columns Comments for SFRRGFE_SCHD_CODE (45)

Source Code Comments

Schedule code for course.

Table SGRCATT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGRCATT_SEQ_NO	SGRCATT_SEQ_NO	NUMBER(3,0)	No	*
SGRCATT_ATTS_CODE	SGRCATT_ATTS_CODE	VARCHAR2(4)	No	*	*
SGRCATT_ACTIVITY_DATE	SGRCATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRCATT_ATTS_CODE	STVATTS_CODE	STVATTS

Index

Index Name	Index Type	Column Name
PK_SGRCATT	Unique	SGRCATT_SEQ_NO
PK_SGRCATT	Unique	SGRCATT_ATTS_CODE

Comments

Source Code Comments

Class Attribute Repeating Table.

Columns Comments for SGRCATT_SEQ_NO (1)

Source Code Comments

The classification rule attribute sequence number.

Columns Comments for SGRCATT_ATTS_CODE (2)

Source Code Comments

The attributes for the class and level.

Columns Comments for SGRCATT_ACTIVITY_DATE (3)

Source Code Comments

The date the record was last updated.

Table SGRSATT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SGRSATT_PIDM	SGRSATT_PIDM	NUMBER(8,0)	No	*
SGRSATT_TERM_CODE_EFF	SGRSATT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SGRSATT_ATTS_CODE	SGRSATT_ATTS_CODE	VARCHAR2(4)	Yes	*
SGRSATT_ATTS_CODE	SGRSATT_ATTS_CODE	VARCHAR2(4)	Yes	*
SGRSATT_ATTS_CODE	SGRSATT_ATTS_CODE	VARCHAR2(4)	Yes	*
SGRSATT_ACTIVITY_DATE	SGRSATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRSATT_ATTS_CODE	STVATTS_CODE	STVATTS
SGRSATT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SGRSATT_PIDM	SFBETRM_PIDM	SFBETRM
SGRSATT_ATTS_CODE	SGRCATT_ATTS_CODE	SGRCATT
SGRSATT_ATTS_CODE	SORMATT_ATTR_CODE	SORMATT

Index

Index Name	Index Type	Column Name
SGRSATT_KEY_INDEX	Unique	SGRSATT_PIDM
SGRSATT_KEY_INDEX	Unique	SGRSATT_TERM_CODE_EFF
SGRSATT_KEY_INDEX	Unique	SGRSATT_ATTS_CODE

Comments

Source Code Comments

Student Attribute Repeating Table.

Columns Comments for SGRSATT_PIDM (1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SGRSATT_TERM_CODE_EFF (2)

Source Code Comments

The effective term associated with the attributes.

Columns Comments for SGRSATT_ATTS_CODE (3)

Source Code Comments

The student attributes for the person and term.

Columns Comments for SGRSATT_ACTIVITY_DATE (4)

Source Code Comments

The date the record was last updated.

Table SMRACAA

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMRACAA_AREA	SMRACAA_AREA	VARCHAR2(10)	No	*	*
SMRACAA_TERM_CODE_EFF	SMRACAA_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SMRACAA_ACTIVITY_DATE	SMRACAA_ACTIVITY_DATE	DATE	No
SMRACAA_TRANSFER_IND	SMRACAA_TRANSFER_IND	VARCHAR2(1)	No
SMRACAA_SEQNO	SMRACAA_SEQNO	NUMBER(8,0)	No	*
SMRACAA_SPLIT_COURSE_IND	SMRACAA_SPLIT_COURSE_IND	VARCHAR2(1)	No
SMRACAA_CONNECTOR_REQ	SMRACAA_CONNECTOR_REQ	VARCHAR2(1)	No
SMRACAA_CONNECTOR_MAX	SMRACAA_CONNECTOR_MAX	VARCHAR2(1)	No
SMRACAA_CONNECTOR_TRANSFER	SMRACAA_CONNECTOR_TRANSFER	VARCHAR2(1)	No
SMRACAA_CNT_IN_GPA_IND	SMRACAA_CNT_IN_GPA_IND	VARCHAR2(1)	No
SMRACAA_SET	SMRACAA_SET	VARCHAR2(3)	Yes
SMRACAA_SUBSET	SMRACAA_SUBSET	NUMBER(3,0)	Yes
SMRACAA_RULE	SMRACAA_RULE	VARCHAR2(10)	Yes
SMRACAA_SUBJ_CODE	SMRACAA_SUBJ_CODE	VARCHAR2(4)	Yes		*
SMRACAA_CRSE_NUMB_LOW	SMRACAA_CRSE_NUMB_LOW	VARCHAR2(5)	Yes
SMRACAA_CRSE_NUMB_HIGH	SMRACAA_CRSE_NUMB_HIGH	VARCHAR2(5)	Yes
SMRACAA_ATTR_CODE	SMRACAA_ATTR_CODE	VARCHAR2(4)	Yes		*
SMRACAA_ATTS_CODE	SMRACAA_ATTS_CODE	VARCHAR2(4)	Yes		*
SMRACAA_CAMP_CODE	SMRACAA_CAMP_CODE	VARCHAR2(3)	Yes		*
SMRACAA_COLL_CODE	SMRACAA_COLL_CODE	VARCHAR2(2)	Yes		*
SMRACAA_DEPT_CODE	SMRACAA_DEPT_CODE	VARCHAR2(4)	Yes		*
SMRACAA_YEAR_RULE	SMRACAA_YEAR_RULE	NUMBER(2,0)	Yes
SMRACAA_TERM_CODE_FROM	SMRACAA_TERM_CODE_FROM	VARCHAR2(6)	Yes		*
SMRACAA_TERM_CODE_TO	SMRACAA_TERM_CODE_TO	VARCHAR2(6)	Yes		*
SMRACAA_REQ_CREDITS	SMRACAA_REQ_CREDITS	NUMBER(11,3)	Yes
SMRACAA_REQ_COURSES	SMRACAA_REQ_COURSES	NUMBER(3,0)	Yes
SMRACAA_MAX_CREDITS	SMRACAA_MAX_CREDITS	NUMBER(11,3)	Yes
SMRACAA_MAX_COURSES	SMRACAA_MAX_COURSES	NUMBER(3,0)	Yes
SMRACAA_MIN_CRED_CRSE	SMRACAA_MIN_CRED_CRSE	NUMBER(7,3)	Yes
SMRACAA_MAX_CRED_CRSE	SMRACAA_MAX_CRED_CRSE	NUMBER(7,3)	Yes
SMRACAA_COMPL_CREDITS	SMRACAA_COMPL_CREDITS	NUMBER(11,3)	Yes
SMRACAA_COMPL_COURSES	SMRACAA_COMPL_COURSES	NUMBER(3,0)	Yes
SMRACAA_GRDE_CODE_MIN	SMRACAA_GRDE_CODE_MIN	VARCHAR2(6)	Yes
SMRACAA_MAX_CREDITS_TRANSFER	SMRACAA_MAX_CREDITS_TRANSFER	NUMBER(11,3)	Yes
SMRACAA_MAX_COURSES_TRANSFER	SMRACAA_MAX_COURSES_TRANSFER	NUMBER(3,0)	Yes
SMRACAA_END_FUNCTION	SMRACAA_END_FUNCTION	VARCHAR2(1)	Yes
SMRACAA_CATALOG_IND	SMRACAA_CATALOG_IND	VARCHAR2(1)	No
SMRACAA_TESC_CODE	SMRACAA_TESC_CODE	VARCHAR2(4)	Yes		*
SMRACAA_MIN_VALUE	SMRACAA_MIN_VALUE	VARCHAR2(5)	Yes
SMRACAA_MAX_VALUE	SMRACAA_MAX_VALUE	VARCHAR2(5)	Yes
SMRACAA_CONCURRENCY_IND	SMRACAA_CONCURRENCY_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRACAA_AREA	SMRALIB_AREA	SMRALIB
SMRACAA_ATTR_CODE	STVATTR_CODE	STVATTR
SMRACAA_ATTS_CODE	STVATTS_CODE	STVATTS
SMRACAA_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SMRACAA_COLL_CODE	STVCOLL_CODE	STVCOLL
SMRACAA_DEPT_CODE	STVDEPT_CODE	STVDEPT
SMRACAA_CAMP_CODE	STVCAMP_CODE	STVCAMP
SMRACAA_TESC_CODE	STVTESC_CODE	STVTESC

Index

Index Name	Index Type	Column Name
PK_SMRACAA	Unique	SMRACAA_AREA
PK_SMRACAA	Unique	SMRACAA_TERM_CODE_EFF
PK_SMRACAA	Unique	SMRACAA_SEQNO
SMRACAA_KEY_INDEX	Unique	SMRACAA_AREA
SMRACAA_KEY_INDEX	Unique	SMRACAA_TERM_CODE_EFF
SMRACAA_KEY_INDEX	Unique	SMRACAA_SET
SMRACAA_KEY_INDEX	Unique	SMRACAA_SUBSET
SMRACAA_KEY_INDEX	Unique	SMRACAA_RULE
SMRACAA_KEY_INDEX	Unique	SMRACAA_SUBJ_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_CRSE_NUMB_LOW
SMRACAA_KEY_INDEX	Unique	SMRACAA_CRSE_NUMB_HIGH
SMRACAA_KEY_INDEX	Unique	SMRACAA_ATTR_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_ATTS_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_CAMP_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_COLL_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_DEPT_CODE
SMRACAA_KEY_INDEX	Unique	SMRACAA_SEQNO

Functional domain

Functional Domain
gpa

Comments

Source Code Comments

Area Course/Attribute Attachment Table

Columns Comments for SMRACAA_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 SMRACAA_TERM_CODE_EFF (2)

Source Code Comments

Effective term of the area course/attribute attachments.

Columns Comments for SMRACAA_ACTIVITY_DATE (3)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRACAA_TRANSFER_IND (4)

Source Code Comments

Transfer indicator. Y = Active, N = Inactive.

Columns Comments for SMRACAA_SEQNO (5)

Source Code Comments

The sequence number of the area attachments.

Columns Comments for SMRACAA_SPLIT_COURSE_IND (6)

Source Code Comments

Split course indicator. Y = Split course in compliance, N = No split course allowed in compliance.

Columns Comments for SMRACAA_CONNECTOR_REQ (7)

Source Code Comments

The connector between Required number of credits and courses.

Columns Comments for SMRACAA_CONNECTOR_MAX (8)

Source Code Comments

The connector between maximum number of credits and courses.

Columns Comments for SMRACAA_CONNECTOR_TRANSFER (9)

Source Code Comments

Maximum transfer connector that designates whether credits/courses can be transferred by none or with an or.

Columns Comments for SMRACAA_CNT_IN_GPA_IND (10)

Source Code Comments

Count in GPA indicator. Y = Count course in GPA, N = Do not count course in GPA.

Columns Comments for SMRACAA_SET (11)

Source Code Comments

Set is a way to tie together individual detail requirements. It is a 3 position character field. Subset is a required accompaniment.

Columns Comments for SMRACAA_SUBSET (12)

Source Code Comments

Subset defines the relationship of the detail requirements denoted by its associated Set. It is a 3 position numeric field. Set must have been defined previously.

Columns Comments for SMRACAA_RULE (13)

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 SMRACAA_SUBJ_CODE (14)

Source Code Comments

Subject code.

Columns Comments for SMRACAA_CRSE_NUMB_LOW (15)

Source Code Comments

Low course number.

Columns Comments for SMRACAA_CRSE_NUMB_HIGH (16)

Source Code Comments

High course number.

Columns Comments for SMRACAA_ATTR_CODE (17)

Source Code Comments

Attribute for Courses.

Columns Comments for SMRACAA_ATTS_CODE (18)

Source Code Comments

Attribute code for Students.

Columns Comments for SMRACAA_CAMP_CODE (19)

Source Code Comments

Campus code.

Columns Comments for SMRACAA_COLL_CODE (20)

Source Code Comments

College code.

Columns Comments for SMRACAA_DEPT_CODE (21)

Source Code Comments

Department code.

Columns Comments for SMRACAA_YEAR_RULE (22)

Source Code Comments

Number of years within which course must have been taken.

Columns Comments for SMRACAA_TERM_CODE_FROM (23)

Source Code Comments

Low end of term range.

Columns Comments for SMRACAA_TERM_CODE_TO (24)

Source Code Comments

High end of term range.

Columns Comments for SMRACAA_REQ_CREDITS (25)

Source Code Comments

Required number of credits.

Columns Comments for SMRACAA_REQ_COURSES (26)

Source Code Comments

Required number of courses.

Columns Comments for SMRACAA_MAX_CREDITS (27)

Source Code Comments

Maximum number of credits.

Columns Comments for SMRACAA_MAX_COURSES (28)

Source Code Comments

Maximum number of courses.

Columns Comments for SMRACAA_MIN_CRED_CRSE (29)

Source Code Comments

Minimum number of credits per course.

Columns Comments for SMRACAA_MAX_CRED_CRSE (30)

Source Code Comments

Maximum number of credits per course.

Columns Comments for SMRACAA_COMPL_CREDITS (31)

Source Code Comments

The number of compliance credits used by compliance toward area requirement completion.

Columns Comments for SMRACAA_COMPL_COURSES (32)

Source Code Comments

The number of compliance courses used by compliance toward area requirement completion.

Columns Comments for SMRACAA_GRDE_CODE_MIN (33)

Source Code Comments

Minimum grade.

Columns Comments for SMRACAA_MAX_CREDITS_TRANSFER (34)

Source Code Comments

Maximum number of credits that can be transferred.

Columns Comments for SMRACAA_MAX_COURSES_TRANSFER (35)

Source Code Comments

Maximum number of courses that can be transferred.

Columns Comments for SMRACAA_END_FUNCTION (36)

Source Code Comments

E indicates that end function was performed.

Columns Comments for SMRACAA_CATALOG_IND (37)

Source Code Comments

Y denotes catalog will be used to find courses in a range. This is effective only if subject entered with range.

Columns Comments for SMRACAA_TESC_CODE (38)

Source Code Comments

Test score code necessary to satisfy the requirement

Columns Comments for SMRACAA_MIN_VALUE (39)

Source Code Comments

Minimum test score necessary to satisfy the requirement

Columns Comments for SMRACAA_MAX_VALUE (40)

Source Code Comments

Maximum test score allowed to satisfy the requirement

Columns Comments for SMRACAA_CONCURRENCY_IND (41)

Source Code Comments

Indicates whether concurrent enrollment allowed

Table SMRAEXL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SMRAEXL_AREA	SMRAEXL_AREA	VARCHAR2(10)	No	*
SMRAEXL_AREA	SMRAEXL_AREA	VARCHAR2(10)	No	*
SMRAEXL_TERM_CODE_EFF	SMRAEXL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRAEXL_TERM_CODE_EFF	SMRAEXL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SMRAEXL_SMRACAA_SEQNO	SMRAEXL_SMRACAA_SEQNO	NUMBER(8,0)	No	*
SMRAEXL_ACTIVITY_DATE	SMRAEXL_ACTIVITY_DATE	DATE	No
SMRAEXL_SUBJ_CODE	SMRAEXL_SUBJ_CODE	VARCHAR2(4)	Yes	*
SMRAEXL_CRSE_NUMB_LOW	SMRAEXL_CRSE_NUMB_LOW	VARCHAR2(5)	Yes
SMRAEXL_CRSE_NUMB_HIGH	SMRAEXL_CRSE_NUMB_HIGH	VARCHAR2(5)	Yes
SMRAEXL_ATTR_CODE	SMRAEXL_ATTR_CODE	VARCHAR2(4)	Yes	*
SMRAEXL_ATTS_CODE	SMRAEXL_ATTS_CODE	VARCHAR2(4)	Yes	*
SMRAEXL_CAMP_CODE	SMRAEXL_CAMP_CODE	VARCHAR2(3)	Yes
SMRAEXL_COLL_CODE	SMRAEXL_COLL_CODE	VARCHAR2(2)	Yes
SMRAEXL_DEPT_CODE	SMRAEXL_DEPT_CODE	VARCHAR2(4)	Yes
SMRAEXL_TERM_CODE_FROM	SMRAEXL_TERM_CODE_FROM	VARCHAR2(6)	Yes	*
SMRAEXL_TERM_CODE_TO	SMRAEXL_TERM_CODE_TO	VARCHAR2(6)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRAEXL_AREA	SMRACAA_AREA	SMRACAA
SMRAEXL_TERM_CODE_EFF	SMRACAA_TERM_CODE_EFF	SMRACAA
SMRAEXL_SMRACAA_SEQNO	SMRACAA_SEQNO	SMRACAA
SMRAEXL_AREA	SMRALIB_AREA	SMRALIB
SMRAEXL_ATTR_CODE	STVATTR_CODE	STVATTR
SMRAEXL_ATTS_CODE	STVATTS_CODE	STVATTS
SMRAEXL_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ

Index

Index Name	Index Type	Column Name
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_AREA
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_TERM_CODE_EFF
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_SMRACAA_SEQNO
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_SUBJ_CODE
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_CRSE_NUMB_LOW
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_CRSE_NUMB_HIGH
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_ATTR_CODE
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_ATTS_CODE
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_CAMP_CODE
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_COLL_CODE
SMRAEXL_KEY_INDEX	Unique	SMRAEXL_DEPT_CODE