Model STVATTS

Model Label : Banner STVATTS ERD
Path : Default Folder/B70/Common/STVATTS

List of Objects

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

Comments

Model View

Table SARAATT

Schema Name SATURN
Label SARAATT
Server name S4B70
Creation Date 09/29/2003 12:09:18: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_TERM_CODE	STVTERM_CODE	STVTERM
SARAATT_ATTS_CODE	STVATTS_CODE	STVATTS

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
main	C/C++ Function	[F:\BANNER\C\SAPADMS.PC]	Use()
delaatt	C/C++ Function	[F:\BANNER\C\SAPADMS.PC]	Use(delete )
selaatt	C/C++ Function	[F:\BANNER\C\SAPADMS.PC]	Use(select )
selmacrod	C/C++ Function	[F:\BANNER\C\SAPADMS.PC]	Use(select )
SARAATT	SYNONYM	S4B70.PUBLIC	Rely on ()
AS_ADMISSIONS_ATTRIBUTE	VIEW	S4B70.BANINST1	Use(select )
GET_ATTR_ITEMS	Forms Trigger	BANNER7_FORMS_10G.SAAADMS.SARADAP	Use(insert )
GET_ATTR_ITEMS	Forms Trigger	BANNER7_FORMS.SAAADMS.SARADAP	Use(insert )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.SAAADMS.SARADAP	Use(delete,select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.SAAADMS.SARADAP	Use(delete,select )
P_MATERIAL_MATCHING	Package procedure	S4B70.BANINST1.SOKCPLN	Use(select )
F_MATCH_SARAATT	Package function	S4B70.BANINST1.SOKAINF	Use(select )
P_DELETE	Package procedure	S4B70.BANINST1.SB_ADMISSIONSAPPLICATION	Use(delete )
P_INSERT_ATTRIBUTE	Package procedure	S4B70.BANINST1.SAKMODS	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use(insert )
SARAATT	Forms DataBlock	BANNER7_FORMS_10G.SAAADMS	Rely on () Use(insert,update,delete,select )
SARAATT	Forms DataBlock	BANNER7_FORMS.SAAADMS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SARAATT	INDEX	S4B70.SATURN	Rely on ()
STVATTS	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:09:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
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_LEVL_CODE	SFRRGFE_LEVL_CODE	VARCHAR2(2)	Yes		*
SFRRGFE_COLL_CODE	SFRRGFE_COLL_CODE	VARCHAR2(2)	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_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_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,4)	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_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_PROGRAM	SMRPRLE_PROGRAM	SMRPRLE
SFRRGFE_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SFRRGFE_CAMP_CODE	STVCAMP_CODE	STVCAMP
SFRRGFE_CAMP_CODE_CRSE	STVCAMP_CODE	STVCAMP
SFRRGFE_LEVL_CODE	STVLEVL_CODE	STVLEVL
SFRRGFE_LEVL_CODE_CRSE	STVLEVL_CODE	STVLEVL
SFRRGFE_TERM_CODE	STVTERM_CODE	STVTERM
SFRRGFE_TERM_CODE_ADMIT	STVTERM_CODE	STVTERM
SFRRGFE_GMOD_CODE	STVGMOD_CODE	STVGMOD
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_DETL_CODE	TBBDETC_DETAIL_CODE	TBBDETC

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SFRRGFE	SYNONYM	S4B70.PUBLIC	Rely on ()
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.SFAFAUD.SFVFAUD	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.SFAFAUD.SFVFAUD	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SFARGFE.SFRRGFE	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SFARGFE.SFRRGFE	Use(select )
COPY_RULES	Forms Procedure	BANNER7_FORMS.SFARGFE	Rely on ()
COPY_RULES	Forms Procedure	BANNER7_FORMS.SFARGFE	Rely on () Use(insert,select )
COPY_RULES	Forms Procedure	BANNER7_FORMS_10G.SFARGFE	Rely on () Use(insert,select )
COPY_RULES	Forms Procedure	BANNER7_FORMS_10G.SFARGFE	Rely on ()
F_OPT_RANGE_FNC	FUNCTION	S4B70.BANINST1	Use(select )
F_OPT_TERM_FNC	FUNCTION	S4B70.BANINST1	Use(select )
F_REQ_RANGE_FNC	FUNCTION	S4B70.BANINST1	Use(select )
F_REQ_TERM_FNC	FUNCTION	S4B70.BANINST1	Use(select )
RULE_EXISTS	Forms Function	BANNER7_FORMS_10G.SFARGFE	Rely on () Use(select )
RULE_EXISTS	Forms Function	BANNER7_FORMS.SFARGFE	Rely on () Use(select )
RULE_ENTRY_TYPE	Package variable	S4B70.BANINST1.SFKFEES	Rely on ()
T_OVERLOAD_HR_FEES	Package variable	S4B70.BANINST1.SFKFEES	Rely on ()
T_OVERLOAD_HR_TUIT	Package variable	S4B70.BANINST1.SFKFEES	Rely on ()
P_APPLYRULES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_APPLYRULES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on () Use(select )
P_ATTRIBUTEFEES	Package procedure	S4B70.BANINST1.SFKFEES	Use(select )
P_ATTRIBUTEFEES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_CALC_FLAT_HR_LIABILITY	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_CAMPUSFEES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_GET_LAST_ASSESS_FLAT_DATA	Package procedure	S4B70.BANINST1.SFKFEES	Use(select )
P_GET_LAST_ASSESS_FLAT_DATA	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_LEVELFEES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_PROCESSFEEASSESSMENT	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
P_STUDENTFEES	Package procedure	S4B70.BANINST1.SFKFEES	Rely on ()
F_CALC_PER_CRED_CHARGE	Package function	S4B70.BANINST1.SFKFEES	Rely on ()
F_CALC_RULE_HRS	Package function	S4B70.BANINST1.SFKFEES	Rely on ()
F_PREV_FLAT_RULE_MET	Package function	S4B70.BANINST1.SFKFEES	Use(select )
F_RULE_TYPE_DEFINED	Package function	S4B70.BANINST1.SFKFEES	Rely on ()
F_RULE_TYPE_DEFINED	Package function	S4B70.BANINST1.SFKFEES	Use(select )
SFRRGFE	Forms DataBlock	BANNER7_FORMS_10G.SFARGFE	Rely on () Use(insert,update,delete,select )
SFRRGFE	Forms DataBlock	BANNER7_FORMS.SFARGFE	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SFRRGFE	INDEX	S4B70.SATURN	Rely on ()
GTVINSM	TABLE	S4B70."GENERAL"	Refer( No Action )
SMRPRLE	TABLE	S4B70.SATURN	Refer( No Action )
SOBTERM	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )
STVATTS	TABLE	S4B70.SATURN	Refer( No Action )
STVCAMP	TABLE	S4B70.SATURN	Refer( No Action )
STVCLAS	TABLE	S4B70.SATURN	Refer( No Action )
STVCOLL	TABLE	S4B70.SATURN	Refer( No Action )
STVDEGC	TABLE	S4B70.SATURN	Refer( No Action )
STVDEPT	TABLE	S4B70.SATURN	Refer( No Action )
STVGMOD	TABLE	S4B70.SATURN	Refer( No Action )
STVLEVL	TABLE	S4B70.SATURN	Refer( No Action )
STVMAJR	TABLE	S4B70.SATURN	Refer( No Action )
STVPTRM	TABLE	S4B70.SATURN	Refer( No Action )
STVRATE	TABLE	S4B70.SATURN	Refer( No Action )
STVRESD	TABLE	S4B70.SATURN	Refer( No Action )
STVSCHD	TABLE	S4B70.SATURN	Refer( No Action )
STVSTYP	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )
TBBDETC	TABLE	S4B70.TAISMGR	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:09:34: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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
select_student_class	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
select_student_class2	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
CAA10	Cobol Paragraph	[F:\banner\cobol].SCTH1000.AAA	Use(select )
CAA9	Cobol Paragraph	[F:\banner\cobol].SCTH1000.AAA	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.SGACLSR.SGRCLSR	Use(delete )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.SGACLSR.SGRCLSR	Use(delete )
S$_CLASS_CALC	Forms Procedure	BANNER7_FORMS.SOQRPLS	Use(select )
S$_CLASS_CALC	Forms Procedure	BANNER7_FORMS_10G.SOQRPLS	Use(select )
F_CLASS_CALC_FNC	FUNCTION	S4B70.BANINST1	Use(select )
P_CLASS_CALC	Package procedure	S4B70.BANINST1.SOKLIBS	Use(select )
F_CLASS_CODE	Package function	S4B70.BANINST1.SGKCLAS	Use(select )
SGRCATT	SYNONYM	S4B70.PUBLIC	Rely on ()
SGRCATT	Forms DataBlock	BANNER7_FORMS.SGACLSR	Rely on () Use(insert,update,delete,select )
SGRCATT	Forms DataBlock	BANNER7_FORMS_10G.SGACLSR	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SGRCATT	INDEX	S4B70.SATURN	Rely on ()
STVATTS	TABLE	S4B70.SATURN	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:09:35: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_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

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
select_student_class	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
CAA9	Cobol Paragraph	[F:\banner\cobol].SCTH1000.AAA	Use(select )
delsatt	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(delete )
get_stu_attributes	C/C++ Function	[F:\BANNER\C\SMRJOBS.PC]	Use(select )
getdata	C/C++ Function	[F:\BANNER\C\SFRNSLC.PC]	Use(select )
process_prog_attr	C/C++ Function	[F:\BANNER\C\SMRGEVL.PC]	Use(select )
selsatt	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(select )
selsatt1	C/C++ Function	[F:\BANNER\C\SGPSTDN.PC]	Use(select )
AS_STUDENT_ATTRIBUTE	VIEW	S4B70.BANINST1	Use(select )
SGVSATT	VIEW	S4B70.BANINST1	Use(select )
SOVSATT	VIEW	S4B70.BANINST1	Use(select )
END_SATT_TERM	Forms Trigger	BANNER7_FORMS_10G.SGASADD.SGRSATT	Use(insert )
END_SATT_TERM	Forms Trigger	BANNER7_FORMS.SGASADD.SGRSATT	Lock
INSERT_TRIG	Forms Trigger	BANNER7_FORMS_10G.SGASADD.SGRSATT	Lock
INSERT_TRIG	Forms Trigger	BANNER7_FORMS.SGASADD.SGRSATT	Lock
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.SGASADD.SGRSATT	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.SGASADD.SGRSATT	Use(select )
KEY_DELREC	Forms Trigger	BANNER7_FORMS_10G.SGASTDN.SGBSTDN	Use(select )
KEY_DELREC	Forms Trigger	BANNER7_FORMS.SGASTDN.SGBSTDN	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SGASADD.SGRSATT	Use(delete )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SGASADD.SGRSATT	Use(delete )
PRE-QUERY	Forms Trigger	BANNER7_FORMS_10G.SGASADD.SGRSATT	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS.SGASADD.SGRSATT	Use(select )
S$_CLASS_CALC	Forms Procedure	BANNER7_FORMS.SOQRPLS	Use(select )
S$_CLASS_CALC	Forms Procedure	BANNER7_FORMS_10G.SOQRPLS	Use(select )
F_CLASS_CALC_FNC	FUNCTION	S4B70.BANINST1	Use(select )
P_MATERIAL_MATCHING	Package procedure	S4B70.BANINST1.SOKCPLN	Use(select )
P_CLASS_CALC	Package procedure	S4B70.BANINST1.SOKLIBS	Use(select )
P_INSERT_ATTRIBUTE	Package procedure	S4B70.BANINST1.SAKMODS	Use(insert,select )
F_CLASS_CODE	Package function	S4B70.BANINST1.SGKCLAS	Use(select )
F_GET_END_SGRSATT_TERM	Package function	S4B70.BANINST1.SOKODSF	Use(select )
F_SGRSATT_EXISTS	Package function	S4B70.BANINST1.SFKFEES	Use(select )
SGRSATT	SYNONYM	S4B70.PUBLIC	Rely on ()
SGRSATT	Forms DataBlock	BANNER7_FORMS_10G.SGASADD	Rely on () Use(insert,update,delete,select )
SGRSATT	Forms DataBlock	BANNER7_FORMS.SGASADD	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SGRSATT_KEY_INDEX	INDEX	S4B70.SATURN	Rely on ()
STVATTS	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

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 S4B70
Creation Date 09/29/2003 12:09:49: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