Model STVATTR

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

List of Objects

Object Name	Object Type	Layer Name
SCRATTR	TABLE	ERD
SDBSMUC	TABLE	ERD
SDRCMAT	TABLE	ERD
SDRDPAT	TABLE	ERD
SDRDPSR	TABLE	ERD
SDRSCAD	TABLE	ERD
SDRSCSB	TABLE	ERD
SDRSMUR	TABLE	ERD
SDRSSSR	TABLE	ERD
SFRRGFE	TABLE	ERD
SHRATTC	TABLE	ERD
SHRATTR	TABLE	ERD
SHRTATT	TABLE	ERD
SHRTRAT	TABLE	ERD
SHRTRTA	TABLE	ERD
SMRACAA	TABLE	ERD
SMRAEXL	TABLE	ERD
SMRAREX	TABLE	ERD
SMRARSA	TABLE	ERD
SMRARUL	TABLE	ERD
SMRDOUS	TABLE	ERD
SMRGCAA	TABLE	ERD
SMRGEXL	TABLE	ERD
SMRGREX	TABLE	ERD
SMRGRSA	TABLE	ERD
SMRGRUL	TABLE	ERD
SMRPATR	TABLE	ERD
SMRPCRS	TABLE	ERD
SMRPOAT	TABLE	ERD
SMRPRSA	TABLE	ERD
SMRSACA	TABLE	ERD
SMRSACE	TABLE	ERD
SMRSARE	TABLE	ERD
SMRSARS	TABLE	ERD
SMRSARU	TABLE	ERD
SMRSGCA	TABLE	ERD
SMRSGCE	TABLE	ERD
SMRSGRE	TABLE	ERD
SMRSGRS	TABLE	ERD
SMRSGRU	TABLE	ERD
SMRSPAT	TABLE	ERD
SMRSPRS	TABLE	ERD
SMRSSUB	TABLE	ERD
SMRSTRG	TABLE	ERD
SMRSWAV	TABLE	ERD
SSRATTR	TABLE	ERD
STVATTR	TABLE	Tables

Comments

Model View

Table SCRATTR

Schema Name SATURN
Label SCRATTR
Server name S4B70
Creation Date 06/23/2004 10:54:25:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SCRATTR_SUBJ_CODE	SCRATTR_SUBJ_CODE	VARCHAR2(4)	No	*
SCRATTR_CRSE_NUMB	SCRATTR_CRSE_NUMB	VARCHAR2(5)	No	*
SCRATTR_EFF_TERM	SCRATTR_EFF_TERM	VARCHAR2(6)	No	*
SCRATTR_ATTR_CODE	SCRATTR_ATTR_CODE	VARCHAR2(4)	Yes	*
SCRATTR_ACTIVITY_DATE	SCRATTR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRATTR_SUBJ_CODE	SCBCRKY_SUBJ_CODE	SCBCRKY
SCRATTR_CRSE_NUMB	SCBCRKY_CRSE_NUMB	SCBCRKY
SCRATTR_ATTR_CODE	STVATTR_CODE	STVATTR
SCRATTR_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRATTR_EFF_TERM	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
SCRATTR_KEY_INDEX	Unique	SCRATTR_SUBJ_CODE
SCRATTR_KEY_INDEX	Unique	SCRATTR_CRSE_NUMB
SCRATTR_KEY_INDEX	Unique	SCRATTR_EFF_TERM
SCRATTR_KEY_INDEX	Unique	SCRATTR_ATTR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
smrjobs.pc	C/C++ File	N/A	Use(select )
MAA6	Cobol Paragraph	[F:\banner\cobol].SERCBREC.MAA-MAINLINE-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADA3202.RAA2-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADA3204.RAA2-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADA3205.RAA2-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADA3203.RAA2-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADA3206.RAA2-SECT	Use(select )
RAB2	Cobol Paragraph	[F:\banner\cobol].SADAFLEX.RAA2-SECT	Use(select )
SEA2	Cobol Paragraph	[F:\banner\cobol].SADA3202.SEA2-SECT	Use(select )
SEA2	Cobol Paragraph	[F:\banner\cobol].SADA3203.SEA2-SECT	Use(select )
SEA2	Cobol Paragraph	[F:\banner\cobol].SADA3204.SEA2-SECT	Use(select )
SEA2	Cobol Paragraph	[F:\banner\cobol].SADA3206.SEA2-SECT	Use(select )
SEA2	Cobol Paragraph	[F:\banner\cobol].SADA3205.SEA2-SECT	Use(select )
SFA2	Cobol Paragraph	[F:\banner\cobol].SADA3202.SFA2-SECT	Use(select )
SFA2	Cobol Paragraph	[F:\banner\cobol].SADA3204.SFA2-SECT	Use(select )
SFA2	Cobol Paragraph	[F:\banner\cobol].SADA3206.SFA2-SECT	Use(select )
SFA2	Cobol Paragraph	[F:\banner\cobol].SADA3205.SFA2-SECT	Use(select )
SFA2	Cobol Paragraph	[F:\banner\cobol].SADA3203.SFA2-SECT	Use(select )
SADA3202	Cobol Program	F:\banner\cobol	Use()
SADA3203	Cobol Program	F:\banner\cobol	Use()
SADA3204	Cobol Program	F:\banner\cobol	Use()
SADA3205	Cobol Program	F:\banner\cobol	Use()
SADA3206	Cobol Program	F:\banner\cobol	Use()
SADAFLEX	Cobol Program	F:\banner\cobol	Use()
AS_COURSE_ATTRIBUTE	VIEW	S4B70.BANINST1	Use(select )
SSVSEC2	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCADETL.SCRATTR.SCRATTR_ATTR_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCADETL.SCRATTR.SCRATTR_ATTR_CODE	Use(select )
COPY_SCRATTR	Forms Trigger	BANNER7_FORMS.SHATRNS	Use(select )
COPY_SCRATTR	Forms Trigger	BANNER7_FORMS_10G.SHATRNS	Use(select )
OLD_COPY_SCRATTR	Forms Trigger	BANNER7_FORMS.SHATRNS	Use(select )
OLD_COPY_SCRATTR	Forms Trigger	BANNER7_FORMS_10G.SHATRNS	Use(select )
CREATE_DETAIL	Forms Trigger	BANNER7_FORMS.SSASECT.STVDAYS	Use(select )
CREATE_DETAIL	Forms Trigger	BANNER7_FORMS_10G.SSASECT.STVDAYS	Use(select )
END_ATTR_TERM	Forms Trigger	BANNER7_FORMS.SCADETL.SCRATTR	Use(insert )
END_ATTR_TERM	Forms Trigger	BANNER7_FORMS_10G.SCADETL.SCRATTR	Use(insert )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS.SCADETL.SCRATTR	Use(insert,select )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS_10G.SCADETL.SCRATTR	Use(insert,select )
INSERT_TRTA	Forms Trigger	BANNER7_FORMS.SHATAEQ.SHRTRTK	Use(select )
INSERT_TRTA	Forms Trigger	BANNER7_FORMS_10G.SHATAEQ.SHRTRTK	Use(select )
OLD_COPY_SCRATTR	Forms Trigger	BANNER7_FORMS.SHATRNS.SHRTATT	Use(select )
OLD_COPY_SCRATTR	Forms Trigger	BANNER7_FORMS_10G.SHATRNS.SHRTATT	Use(select )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCBCRSE	Use(delete )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(delete )
POST-INSERT	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT	Use(select )
POST-INSERT	Forms Trigger	BANNER7_FORMS.SHATATR.SHRTATC	Use(select )
POST-INSERT	Forms Trigger	BANNER7_FORMS_10G.SHATATR.SHRTATC	Use(select )
POST-INSERT	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT	Use(select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SCABASE.SCBCRKY	Use(update,select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(update )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.SCADETL.SCRATTR	Use(delete )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.SCADETL.SCRATTR	Use(delete )
PRE-QUERY	Forms Trigger	BANNER7_FORMS.SCADETL.SCRATTR	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS_10G.SCADETL.SCRATTR	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SCABASE.SCBCRKY	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(select )
P_INSERT_SHRATTR	Forms Procedure	BANNER7_FORMS.SHATCKC	Use(select )
P_INSERT_SHRATTR	Forms Procedure	BANNER7_FORMS_10G.SHATCKC	Use(select )
F_GET_SCRATTR_ROWID	FUNCTION	S4B70.BANINST1	Use(select )
F_MORE_ATTRIBUTES	FUNCTION	S4B70.BANINST1	Use(select )
P_DELETE	Package procedure	S4B70.BANINST1.SB_COURSE	Use(delete )
P_DISPLAY_COURSES	Package procedure	S4B70.BANINST1.BWCKCTLG	Rely on ()
P_DISPLAY_COURSES	Package procedure	S4B70.BANINST1.BWCKCTLG	Rely on () Use(select )
P_DISPLAY_INFO	Package procedure	S4B70.BANINST1.BWCKCTLG	Rely on ()
P_DISPLAY_INFO	Package procedure	S4B70.BANINST1.BWCKCTLG	Use(select )
F_GET_END_SCRATTR_TERM	Package function	S4B70.BANINST1.SOKODSF	Use(select )
SCRATTR	SYNONYM	S4B70.PUBLIC	Rely on ()
SCRATTR	Forms DataBlock	BANNER7_FORMS.SCADETL	Rely on () Use(insert,update,delete,select )
SCRATTR	Forms DataBlock	BANNER7_FORMS_10G.SCADETL	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SCRATTR_KEY_INDEX	INDEX	S4B70.SATURN	Rely on ()
ST_SCRATTR_DELETE_ROW	TRIGGER	S4B70.SATURN	Fire(delete before each row )
ST_SCRATTR_INSERT_ROW	TRIGGER	S4B70.SATURN	Fire(insert before each row )
ST_SCRATTR_UPDATE_ROW	TRIGGER	S4B70.SATURN	Fire(update before each row )
SCBCRKY	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )
STVSUBJ	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Course Attribute Repeating Table

Columns Comments for SCRATTR_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course

Columns Comments for SCRATTR_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course

Columns Comments for SCRATTR_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course attributes become effective

Columns Comments for SCRATTR_ATTR_CODE (4)

Source Code Comments

This field defines the attribute code of the course

Columns Comments for SCRATTR_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the date the record was created or updated

Table SDBSMUC

Schema Name SATURN
Label SDBSMUC
Server name S4B70
Creation Date 09/29/2003 12:09:27:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDBSMUC_ACTIVITY_DATE	SDBSMUC_ACTIVITY_DATE	DATE	No
SDBSMUC_PIDM	SDBSMUC_PIDM	NUMBER(8,0)	No	*
SDBSMUC_PROGRAM	SDBSMUC_PROGRAM	VARCHAR2(6)	No	*
SDBSMUC_BLTN_YEAR	SDBSMUC_BLTN_YEAR	VARCHAR2(4)	No	*	*
SDBSMUC_SEQ_NO	SDBSMUC_SEQ_NO	NUMBER(2,0)	No	*
SDBSMUC_TERM_CODE	SDBSMUC_TERM_CODE	VARCHAR2(6)	No		*
SDBSMUC_SUBJ_CODE	SDBSMUC_SUBJ_CODE	VARCHAR2(4)	No		*
SDBSMUC_CRSE_NUMB	SDBSMUC_CRSE_NUMB	VARCHAR2(4)	No
SDBSMUC_HOURS	SDBSMUC_HOURS	NUMBER(4,2)	No
SDBSMUC_TRANSFER_IND	SDBSMUC_TRANSFER_IND	VARCHAR2(1)	No
SDBSMUC_ATTR_CODE	SDBSMUC_ATTR_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDBSMUC_TERM_CODE	STVTERM_CODE	STVTERM
SDBSMUC_BLTN_YEAR	STVACYR_CODE	STVACYR
SDBSMUC_ATTR_CODE	STVATTR_CODE	STVATTR
SDBSMUC_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ

Index

Index Name	Index Type	Column Name
PK_SDBSMUC	Unique	SDBSMUC_PIDM
PK_SDBSMUC	Unique	SDBSMUC_PROGRAM
PK_SDBSMUC	Unique	SDBSMUC_BLTN_YEAR
PK_SDBSMUC	Unique	SDBSMUC_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDBSMUC	SYNONYM	S4B70.PUBLIC	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SDBSMUC	INDEX	S4B70.SATURN	Rely on ()
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )
STVSUBJ	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Student Degree Program Multiple Use Course Table

Columns Comments for SDBSMUC_ACTIVITY_DATE (1)

Source Code Comments

This field specifies the date record was created or updated.

Columns Comments for SDBSMUC_PIDM (2)

Source Code Comments

Internal Identification Number of the student.

Columns Comments for SDBSMUC_PROGRAM (3)

Source Code Comments

This field identifies the degree program to specify the student"s multiple use courses.

Columns Comments for SDBSMUC_BLTN_YEAR (4)

Source Code Comments

This field identifies the bulletin year associated with the degree program.

Columns Comments for SDBSMUC_SEQ_NO (5)

Source Code Comments

This field specifies the sequence number associated with the multiple use course.

Columns Comments for SDBSMUC_TERM_CODE (6)

Source Code Comments

This field specifies the term of the student"s course that is being identified to satisfy multiple course requirements.

Columns Comments for SDBSMUC_SUBJ_CODE (7)

Source Code Comments

This field specifies the subject of the student"s course that is being identified to satisfy multiple course requirements.

Columns Comments for SDBSMUC_CRSE_NUMB (8)

Source Code Comments

This field specifies the course number of the student"s course that is being identified to satisfy multiple course requirements.

Columns Comments for SDBSMUC_HOURS (9)

Source Code Comments

This field specifies the number of credit hours of the student"s course that is being identified to satisfy multiple course requirements.

Columns Comments for SDBSMUC_TRANSFER_IND (10)

Source Code Comments

This field indicates if the student"s course that is being identified to satisfy multiple course requirements is an institutional or transfer course. Valid values are: I - Institutional course, T - Transfer course.

Columns Comments for SDBSMUC_ATTR_CODE (11)

Source Code Comments

Multiple use course attribute code

Table SDRCMAT

Schema Name SATURN
Label SDRCMAT
Server name S4B70
Creation Date 09/29/2003 12:09:27:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SDRCMAT_PIDM	SDRCMAT_PIDM	NUMBER(8,0)	No
SDRCMAT_PROGRAM	SDRCMAT_PROGRAM	VARCHAR2(6)	No
SDRCMAT_EFFECTIVE_BLTN_YEAR	SDRCMAT_EFFECTIVE_BLTN_YEAR	VARCHAR2(4)	No	*
SDRCMAT_ATTR_CODE	SDRCMAT_ATTR_CODE	VARCHAR2(4)	Yes	*
SDRCMAT_REQD_MIN_HOURS	SDRCMAT_REQD_MIN_HOURS	NUMBER(5,2)	Yes
SDRCMAT_REQD_MIN_HOURS_RES	SDRCMAT_REQD_MIN_HOURS_RES	NUMBER(5,2)	Yes
SDRCMAT_ACTL_MIN_HOURS	SDRCMAT_ACTL_MIN_HOURS	NUMBER(5,2)	Yes
SDRCMAT_ACTL_MIN_HOURS_RES	SDRCMAT_ACTL_MIN_HOURS_RES	NUMBER(5,2)	Yes
SDRCMAT_ACTIVITY_DATE	SDRCMAT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRCMAT_EFFECTIVE_BLTN_YEAR	STVACYR_CODE	STVACYR
SDRCMAT_ATTR_CODE	STVATTR_CODE	STVATTR

Index

Index Name	Index Type	Column Name
SDRCMAT_KEY_INDEX	Unique	SDRCMAT_PIDM
SDRCMAT_KEY_INDEX	Unique	SDRCMAT_PROGRAM
SDRCMAT_KEY_INDEX	Unique	SDRCMAT_EFFECTIVE_BLTN_YEAR
SDRCMAT_KEY_INDEX	Unique	SDRCMAT_ATTR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRCMAT	SYNONYM	S4B70.PUBLIC	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRCMAT_KEY_INDEX	INDEX	S4B70.SATURN	Rely on ()
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Attribute General Requirements Compliance Repeating Table

Columns Comments for SDRCMAT_PIDM (1)

Source Code Comments

Student Pidm.

Columns Comments for SDRCMAT_PROGRAM (2)

Source Code Comments

Degree Program

Columns Comments for SDRCMAT_EFFECTIVE_BLTN_YEAR (3)

Source Code Comments

Degree Program Effective Bulletin Year

Columns Comments for SDRCMAT_ATTR_CODE (4)

Source Code Comments

General Requirements Attribute code

Columns Comments for SDRCMAT_REQD_MIN_HOURS (5)

Source Code Comments

Attribute General Requirements Actual Minimum Hours

Columns Comments for SDRCMAT_REQD_MIN_HOURS_RES (6)

Source Code Comments

Attribute General Requirements Actual Minimum Hours Residence

Columns Comments for SDRCMAT_ACTL_MIN_HOURS (7)

Source Code Comments

Student Actual Minimum Hours.

Columns Comments for SDRCMAT_ACTL_MIN_HOURS_RES (8)

Source Code Comments

Student Actual Residence Minimum Hours.

Columns Comments for SDRCMAT_ACTIVITY_DATE (9)

Source Code Comments

Activity Date

Table SDRDPAT

Schema Name SATURN
Label SDRDPAT
Server name S4B70
Creation Date 09/29/2003 12:09:28:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SDRDPAT_PROGRAM	SDRDPAT_PROGRAM	VARCHAR2(6)	No	*
SDRDPAT_EFFECTIVE_BLTN_YEAR	SDRDPAT_EFFECTIVE_BLTN_YEAR	VARCHAR2(4)	No	*
SDRDPAT_ATTR_CODE	SDRDPAT_ATTR_CODE	VARCHAR2(4)	Yes	*
SDRDPAT_MIN_HOURS	SDRDPAT_MIN_HOURS	NUMBER(5,2)	Yes
SDRDPAT_MIN_HOURS_RES	SDRDPAT_MIN_HOURS_RES	NUMBER(5,2)	Yes
SDRDPAT_ACTIVITY_DATE	SDRDPAT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRDPAT_EFFECTIVE_BLTN_YEAR	STVACYR_CODE	STVACYR
SDRDPAT_ATTR_CODE	STVATTR_CODE	STVATTR
SDRDPAT_PROGRAM	SDBPROG_PROGRAM	SDBPROG

Index

Index Name	Index Type	Column Name
SDRDPAT_KEY_INDEX	Unique	SDRDPAT_PROGRAM
SDRDPAT_KEY_INDEX	Unique	SDRDPAT_EFFECTIVE_BLTN_YEAR
SDRDPAT_KEY_INDEX	Unique	SDRDPAT_ATTR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRDPAT	SYNONYM	S4B70.PUBLIC	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRDPAT_KEY_INDEX	INDEX	S4B70.SATURN	Rely on ()
SDBPROG	TABLE	S4B70.SATURN	Refer( No Action )
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Attribute General Requirements Repeating Table

Columns Comments for SDRDPAT_PROGRAM (1)

Source Code Comments

Dgree Program

Columns Comments for SDRDPAT_EFFECTIVE_BLTN_YEAR (2)

Source Code Comments

Dgree Program Effective Bulletin Year

Columns Comments for SDRDPAT_ATTR_CODE (3)

Source Code Comments

General Requirements Attribute code

Columns Comments for SDRDPAT_MIN_HOURS (4)

Source Code Comments

Attribute General Requirements Minimum Hours

Columns Comments for SDRDPAT_MIN_HOURS_RES (5)

Source Code Comments

Attribute General Requirements Minimum Hours Residence

Columns Comments for SDRDPAT_ACTIVITY_DATE (6)

Source Code Comments

Activity Date

Table SDRDPSR

Schema Name SATURN
Label SDRDPSR
Server name S4B70
Creation Date 09/29/2003 12:09:28:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDRDPSR_ACTIVITY_DATE	SDRDPSR_ACTIVITY_DATE	DATE	No
SDRDPSR_PROGRAM	SDRDPSR_PROGRAM	VARCHAR2(6)	No	*	*
SDRDPSR_AREA_CODE	SDRDPSR_AREA_CODE	VARCHAR2(4)	No	*	*
SDRDPSR_DPPR_SEQ_NO	SDRDPSR_DPPR_SEQ_NO	NUMBER(2,0)	No	*
SDRDPSR_DPCR_SEQ_NO	SDRDPSR_DPCR_SEQ_NO	NUMBER(2,0)	No	*
SDRDPSR_EFFECTIVE_BLTN_YEAR	SDRDPSR_EFFECTIVE_BLTN_YEAR	VARCHAR2(4)	No	*	*
SDRDPSR_SEQ_NO	SDRDPSR_SEQ_NO	NUMBER(2,0)	No	*
SDRDPSR_ACTION_IND	SDRDPSR_ACTION_IND	VARCHAR2(1)	Yes
SDRDPSR_SUBJ_CODE	SDRDPSR_SUBJ_CODE	VARCHAR2(4)	Yes
SDRDPSR_MIN_GRDE_CODE	SDRDPSR_MIN_GRDE_CODE	VARCHAR2(3)	Yes
SDRDPSR_TRANSFER_IND	SDRDPSR_TRANSFER_IND	VARCHAR2(1)	Yes
SDRDPSR_FROM_CRSE_NUMB	SDRDPSR_FROM_CRSE_NUMB	VARCHAR2(4)	Yes
SDRDPSR_TO_CRSE_NUMB	SDRDPSR_TO_CRSE_NUMB	VARCHAR2(4)	Yes
SDRDPSR_TERM_CODE_FROM	SDRDPSR_TERM_CODE_FROM	VARCHAR2(6)	Yes		*
SDRDPSR_TERM_CODE_TO	SDRDPSR_TERM_CODE_TO	VARCHAR2(6)	Yes		*
SDRDPSR_FROM_HOURS	SDRDPSR_FROM_HOURS	NUMBER(4,2)	Yes
SDRDPSR_TO_HOURS	SDRDPSR_TO_HOURS	NUMBER(4,2)	Yes
SDRDPSR_ATTR_CODE	SDRDPSR_ATTR_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRDPSR_TERM_CODE_TO	STVTERM_CODE	STVTERM
SDRDPSR_TERM_CODE_FROM	STVTERM_CODE	STVTERM
SDRDPSR_EFFECTIVE_BLTN_YEAR	STVACYR_CODE	STVACYR
SDRDPSR_AREA_CODE	STVAREA_CODE	STVAREA
SDRDPSR_ATTR_CODE	STVATTR_CODE	STVATTR
SDRDPSR_PROGRAM	SDBPROG_PROGRAM	SDBPROG

Index

Index Name	Index Type	Column Name
PK_SDRDPSR	Unique	SDRDPSR_PROGRAM
PK_SDRDPSR	Unique	SDRDPSR_AREA_CODE
PK_SDRDPSR	Unique	SDRDPSR_DPPR_SEQ_NO
PK_SDRDPSR	Unique	SDRDPSR_DPCR_SEQ_NO
PK_SDRDPSR	Unique	SDRDPSR_EFFECTIVE_BLTN_YEAR
PK_SDRDPSR	Unique	SDRDPSR_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRDPSR	SYNONYM	S4B70.PUBLIC	Rely on ()
SDVCMRR	VIEW	S4B70.BANINST1	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SDRDPSR	INDEX	S4B70.SATURN	Rely on ()
SDBPROG	TABLE	S4B70.SATURN	Refer( No Action )
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVAREA	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Degree Program Course Requirements Repeating Table

Columns Comments for SDRDPSR_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRDPSR_PROGRAM (2)

Source Code Comments

This field identifies the degree program associated with the course requirements.

Columns Comments for SDRDPSR_AREA_CODE (3)

Source Code Comments

This field identifies the area code (math, social sciences, etc.) associated with the course requirements.

Columns Comments for SDRDPSR_DPPR_SEQ_NO (4)

Source Code Comments

This field identifies the sequence number of the group within the area associated with the course requirements.

Columns Comments for SDRDPSR_DPCR_SEQ_NO (5)

Source Code Comments

This field identifies the sequence number of the cluster within the group and area associated with the course requirements.

Columns Comments for SDRDPSR_EFFECTIVE_BLTN_YEAR (6)

Source Code Comments

This field identifies the bulletin year this version of the course requirements becomes effective.

Columns Comments for SDRDPSR_SEQ_NO (7)

Source Code Comments

This field specifies the sequence number assigned to the course requirement. A course requirement identifies the specific course or range of courses to be used to satisfy the requirements for a cluster, group, area, degree program.

Columns Comments for SDRDPSR_ACTION_IND (8)

Source Code Comments

This field indicates the type of course requirement. Valid values are: O - Optional course requirement, R - Required course requirement, E - Exclude course from previous range.

Columns Comments for SDRDPSR_SUBJ_CODE (9)

Source Code Comments

This field identifies the subject code of the course requirement. Value of "XXXX" indicates that all subjects are valid.

Columns Comments for SDRDPSR_MIN_GRDE_CODE (10)

Source Code Comments

This field identifies the minimum grade needed to meet the course requirement.

Columns Comments for SDRDPSR_TRANSFER_IND (11)

Source Code Comments

This field indicates if a transfer course may be used to satisfy the course requirement. Valid values are: N - No restrictions on using transfer courses, Y - Institutional courses only may be used.

Columns Comments for SDRDPSR_FROM_CRSE_NUMB (12)

Source Code Comments

This field indicates the beginning range of the course number for a course requirement. If the requirement consists of only one course, the course number would be here.

Columns Comments for SDRDPSR_TO_CRSE_NUMB (13)

Source Code Comments

This field indicates the endng range of the course number for a course requirement. The field would be blank if the requirement consists of only one course.

Columns Comments for SDRDPSR_TERM_CODE_FROM (14)

Source Code Comments

This field indicates the beginning range of the terms the course is valid as a requirement. If the course is valid for only one term, the term would be here. If the course requirement is valid for all terms, no term would be entered.

Columns Comments for SDRDPSR_TERM_CODE_TO (15)

Source Code Comments

This field indicates the ending range of the terms the course is valid as a requirement. If course is valid for only one term, this field would be blank.

Columns Comments for SDRDPSR_FROM_HOURS (16)

Source Code Comments

This field indicates the beginning range of the valid credit hours the course requirement may be taken for. If there is no range, the single value would be in this field.

Columns Comments for SDRDPSR_TO_HOURS (17)

Source Code Comments

This field indicates the ending range of the valid credit hours the course requirement may be taken for. If there is no range, this field would be blank.

Columns Comments for SDRDPSR_ATTR_CODE (18)

Source Code Comments

The course attribute code

Table SDRSCAD

Schema Name SATURN
Label SDRSCAD
Server name S4B70
Creation Date 09/29/2003 12:09:28:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SDRSCAD_ACTIVITY_DATE	SDRSCAD_ACTIVITY_DATE	DATE	No
SDRSCAD_PIDM	SDRSCAD_PIDM	NUMBER(8,0)	No	*
SDRSCAD_PROGRAM	SDRSCAD_PROGRAM	VARCHAR2(6)	No	*
SDRSCAD_BLTN_YEAR	SDRSCAD_BLTN_YEAR	VARCHAR2(4)	No	*	*
SDRSCAD_AREA_CODE	SDRSCAD_AREA_CODE	VARCHAR2(4)	No	*	*
SDRSCAD_DPPR_SEQ_NO	SDRSCAD_DPPR_SEQ_NO	NUMBER(2,0)	No	*
SDRSCAD_DPCR_SEQ_NO	SDRSCAD_DPCR_SEQ_NO	NUMBER(2,0)	No	*
SDRSCAD_SEQ_NO	SDRSCAD_SEQ_NO	NUMBER(2,0)	No	*
SDRSCAD_ACTION_IND	SDRSCAD_ACTION_IND	VARCHAR2(1)	No
SDRSCAD_SUBJ_CODE	SDRSCAD_SUBJ_CODE	VARCHAR2(4)	Yes		*
SDRSCAD_MIN_GRDE_CODE	SDRSCAD_MIN_GRDE_CODE	VARCHAR2(3)	Yes
SDRSCAD_TRANSFER_IND	SDRSCAD_TRANSFER_IND	VARCHAR2(1)	No
SDRSCAD_FROM_CRSE_NUMB	SDRSCAD_FROM_CRSE_NUMB	VARCHAR2(4)	Yes
SDRSCAD_TO_CRSE_NUMB	SDRSCAD_TO_CRSE_NUMB	VARCHAR2(4)	Yes
SDRSCAD_FROM_TERM_CODE	SDRSCAD_FROM_TERM_CODE	VARCHAR2(6)	Yes		*
SDRSCAD_TO_TERM_CODE	SDRSCAD_TO_TERM_CODE	VARCHAR2(6)	Yes		*
SDRSCAD_FROM_HOURS	SDRSCAD_FROM_HOURS	NUMBER(4,2)	Yes
SDRSCAD_TO_HOURS	SDRSCAD_TO_HOURS	NUMBER(4,2)	Yes
SDRSCAD_ATTR_CODE	SDRSCAD_ATTR_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SDRSCAD_TO_TERM_CODE	STVTERM_CODE	STVTERM
SDRSCAD_FROM_TERM_CODE	STVTERM_CODE	STVTERM
SDRSCAD_BLTN_YEAR	STVACYR_CODE	STVACYR
SDRSCAD_AREA_CODE	STVAREA_CODE	STVAREA
SDRSCAD_ATTR_CODE	STVATTR_CODE	STVATTR
SDRSCAD_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ

Index

Index Name	Index Type	Column Name
PK_SDRSCAD	Unique	SDRSCAD_PIDM
PK_SDRSCAD	Unique	SDRSCAD_PROGRAM
PK_SDRSCAD	Unique	SDRSCAD_BLTN_YEAR
PK_SDRSCAD	Unique	SDRSCAD_AREA_CODE
PK_SDRSCAD	Unique	SDRSCAD_DPPR_SEQ_NO
PK_SDRSCAD	Unique	SDRSCAD_DPCR_SEQ_NO
PK_SDRSCAD	Unique	SDRSCAD_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SDRSCAD	SYNONYM	S4B70.PUBLIC	Rely on ()
SDVCMRR	VIEW	S4B70.BANINST1	Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SDRSCAD	INDEX	S4B70.SATURN	Rely on ()
STVACYR	TABLE	S4B70.SATURN	Refer( No Action )
STVAREA	TABLE	S4B70.SATURN	Refer( No Action )
STVATTR	TABLE	S4B70.SATURN	Refer( No Action )
STVSUBJ	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Student Degree Program Course Additions Table

Columns Comments for SDRSCAD_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRSCAD_PIDM (2)

Source Code Comments

Internal Identification Number of the student who has additional course requirements for their degree program.

Columns Comments for SDRSCAD_PROGRAM (3)

Source Code Comments

This field identifies the student"s degree program that has additional course requirements.

Columns Comments for SDRSCAD_BLTN_YEAR (4)

Source Code Comments

This field identifies the bulletin year associated with the degree program.

Columns Comments for SDRSCAD_AREA_CODE (5)

Source Code Comments

This field identifies the area code (math, social sciences, etc.) of the degree program.