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

Model STVATTR


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

List of Objects

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

Comments

Model View

''

Table SCRATTR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCRATTR_SUBJ_CODE SCRATTR_SUBJ_CODE VARCHAR2(4) No *
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:52: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_BLTN_YEAR STVACYR_CODE STVACYR
SDBSMUC_ATTR_CODE STVATTR_CODE STVATTR
SDBSMUC_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SDBSMUC_TERM_CODE STVTERM_CODE STVTERM

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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:52:000

Table Columns information

Column Name Label Column Type Allow NULL PK 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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:53:000

Table Columns information

Column Name Label Column Type Allow NULL PK 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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:53: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_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_EFFECTIVE_BLTN_YEAR STVACYR_CODE STVACYR
SDRDPSR_AREA_CODE STVAREA_CODE STVAREA
SDRDPSR_ATTR_CODE STVATTR_CODE STVATTR
SDRDPSR_PROGRAM SDBPROG_PROGRAM SDBPROG
SDRDPSR_PROGRAM SDRCOLR_PROGRAM SDRCOLR

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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:54: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_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_BLTN_YEAR STVACYR_CODE STVACYR
SDRSCAD_AREA_CODE STVAREA_CODE STVAREA
SDRSCAD_ATTR_CODE STVATTR_CODE STVATTR
SDRSCAD_SUBJ_CODE STVSUBJ_CODE STVSUBJ
SDRSCAD_PROGRAM SDRCOLR_PROGRAM SDRCOLR
SDRSCAD_BLTN_YEAR SDRCOLR_BLTN_YEAR SDRCOLR
SDRSCAD_PIDM SDRCOLR_PIDM SDRCOLR

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

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.

Columns Comments for SDRSCAD_DPPR_SEQ_NO (6)

Source Code Comments

This field specifies the sequence number of the group within the area that additional course requirements are being added for.

Columns Comments for SDRSCAD_DPCR_SEQ_NO (7)

Source Code Comments

This field specifies the sequence number of the cluster within the group that additional course requirements are being added for.

Columns Comments for SDRSCAD_SEQ_NO (8)

Source Code Comments

This field specifies the sequence number associated with the new course requirement being added. Must be different than existing course sequence numbers for the area/group/cluster.

Columns Comments for SDRSCAD_ACTION_IND (9)

Source Code Comments

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

Columns Comments for SDRSCAD_SUBJ_CODE (10)

Source Code Comments

This field identifies the subject code of the additional course requirement for the student.

Columns Comments for SDRSCAD_MIN_GRDE_CODE (11)

Source Code Comments

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

Columns Comments for SDRSCAD_TRANSFER_IND (12)

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 SDRSCAD_FROM_CRSE_NUMB (13)

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

Source Code Comments

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

Columns Comments for SDRSCAD_FROM_TERM_CODE (15)

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 SDRSCAD_TO_TERM_CODE (16)

Source Code Comments

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

Columns Comments for SDRSCAD_FROM_HOURS (17)

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

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

Source Code Comments

The additional course attribute code

Table SDRSCSB

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SDRSCSB_ACTIVITY_DATE SDRSCSB_ACTIVITY_DATE DATE No
SDRSCSB_PIDM SDRSCSB_PIDM NUMBER(8,0) No *
SDRSCSB_PROGRAM SDRSCSB_PROGRAM VARCHAR2(6) No *
SDRSCSB_BLTN_YEAR SDRSCSB_BLTN_YEAR VARCHAR2(4) No * *
SDRSCSB_AREA_CODE SDRSCSB_AREA_CODE VARCHAR2(4) No * *
SDRSCSB_DPPR_SEQ_NO SDRSCSB_DPPR_SEQ_NO NUMBER(2,0) No *
SDRSCSB_DPCR_SEQ_NO SDRSCSB_DPCR_SEQ_NO NUMBER(2,0) No *
SDRSCSB_DPSR_SEQ_NO SDRSCSB_DPSR_SEQ_NO NUMBER(2,0) No *
SDRSCSB_ADVR_PIDM SDRSCSB_ADVR_PIDM NUMBER(8,0) No
SDRSCSB_REAS_CODE SDRSCSB_REAS_CODE VARCHAR2(2) No *
SDRSCSB_SUBJ_CODE_SUBS SDRSCSB_SUBJ_CODE_SUBS VARCHAR2(4) Yes *
SDRSCSB_FROM_CRSE_NUMB_SUBS SDRSCSB_FROM_CRSE_NUMB_SUBS VARCHAR2(4) Yes
SDRSCSB_TO_CRSE_NUMB_SUBS SDRSCSB_TO_CRSE_NUMB_SUBS VARCHAR2(4) Yes
SDRSCSB_FROM_HOURS_SUBS SDRSCSB_FROM_HOURS_SUBS NUMBER(4,2) Yes
SDRSCSB_TO_HOURS_SUBS SDRSCSB_TO_HOURS_SUBS NUMBER(4,2) Yes
SDRSCSB_ATTR_CODE SDRSCSB_ATTR_CODE VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SDRSCSB_BLTN_YEAR STVACYR_CODE STVACYR
SDRSCSB_AREA_CODE STVAREA_CODE STVAREA
SDRSCSB_ATTR_CODE STVATTR_CODE STVATTR
SDRSCSB_SUBJ_CODE_SUBS STVSUBJ_CODE STVSUBJ
SDRSCSB_REAS_CODE STVREAS_CODE STVREAS

Index

Index Name Index Type Column Name
PK_SDRSCSB Unique SDRSCSB_PIDM
PK_SDRSCSB Unique SDRSCSB_PROGRAM
PK_SDRSCSB Unique SDRSCSB_BLTN_YEAR
PK_SDRSCSB Unique SDRSCSB_AREA_CODE
PK_SDRSCSB Unique SDRSCSB_DPPR_SEQ_NO
PK_SDRSCSB Unique SDRSCSB_DPCR_SEQ_NO
PK_SDRSCSB Unique SDRSCSB_DPSR_SEQ_NO

Comments

Source Code Comments

Student Degree Program Course Substitutions Repeating Table

Columns Comments for SDRSCSB_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRSCSB_PIDM (2)

Source Code Comments

Internal Identification Number of student who has substitutions to their degree program.

Columns Comments for SDRSCSB_PROGRAM (3)

Source Code Comments

This field identifies the degree program the student has substitutions to.

Columns Comments for SDRSCSB_BLTN_YEAR (4)

Source Code Comments

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

Columns Comments for SDRSCSB_AREA_CODE (5)

Source Code Comments

This field identifies the area code (math,social sciences, etc.) of the degree program for substitutions to be made.

Columns Comments for SDRSCSB_DPPR_SEQ_NO (6)

Source Code Comments

This field specifies the sequence number of the group for a substitution to be made.

Columns Comments for SDRSCSB_DPCR_SEQ_NO (7)

Source Code Comments

This field specifies the sequence number of the cluster within the group for a substitution to be made.

Columns Comments for SDRSCSB_DPSR_SEQ_NO (8)

Source Code Comments

This field specifies the sequence number of the course requirement within the cluster and group that is to be substituted.

Columns Comments for SDRSCSB_ADVR_PIDM (9)

Source Code Comments

This field identifies the internal identification number of the advisor who approved the substitution.

Columns Comments for SDRSCSB_REAS_CODE (10)

Source Code Comments

This field identifies the reason code for why the substitution was made.

Columns Comments for SDRSCSB_SUBJ_CODE_SUBS (11)

Source Code Comments

This field identifies the subject that is being substituted for the course requirement.

Columns Comments for SDRSCSB_FROM_CRSE_NUMB_SUBS (12)

Source Code Comments

This field identifies the beginning course number that is being substituted for the course requirement.

Columns Comments for SDRSCSB_TO_CRSE_NUMB_SUBS (13)

Source Code Comments

This field identifies the ending course number of the course number range that is being substituted for the course requirement.

Columns Comments for SDRSCSB_FROM_HOURS_SUBS (14)

Source Code Comments

This field identifies the beginning range of the valid credit hours that is being substituted for the course requirement.

Columns Comments for SDRSCSB_TO_HOURS_SUBS (15)

Source Code Comments

This field identifies the ending range of the the valid credit hours that is being substituted for the course requirement.

Columns Comments for SDRSCSB_ATTR_CODE (16)

Source Code Comments

The substitute course attribute code

Table SDRSMUR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SDRSMUR_ACTIVITY_DATE SDRSMUR_ACTIVITY_DATE DATE No
SDRSMUR_PIDM SDRSMUR_PIDM NUMBER(8,0) No *
SDRSMUR_PROGRAM SDRSMUR_PROGRAM VARCHAR2(6) No *
SDRSMUR_BLTN_YEAR SDRSMUR_BLTN_YEAR VARCHAR2(4) No * *
SDRSMUR_SMUC_SEQ_NO SDRSMUR_SMUC_SEQ_NO NUMBER(2,0) No *
SDRSMUR_SEQ_NO SDRSMUR_SEQ_NO NUMBER(2,0) No *
SDRSMUR_AREA_CODE SDRSMUR_AREA_CODE VARCHAR2(4) No *
SDRSMUR_DPPR_SEQ_NO SDRSMUR_DPPR_SEQ_NO NUMBER(2,0) No
SDRSMUR_DPCR_SEQ_NO SDRSMUR_DPCR_SEQ_NO NUMBER(2,0) No
SDRSMUR_DPSR_SEQ_NO SDRSMUR_DPSR_SEQ_NO NUMBER(2,0) No
SDRSMUR_PRIMARY_IND SDRSMUR_PRIMARY_IND VARCHAR2(1) No
SDRSMUR_ADVR_PIDM SDRSMUR_ADVR_PIDM NUMBER(8,0) No
SDRSMUR_REAS_CODE SDRSMUR_REAS_CODE VARCHAR2(2) No *
SDRSMUR_ATTR_CODE SDRSMUR_ATTR_CODE VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SDRSMUR_BLTN_YEAR STVACYR_CODE STVACYR
SDRSMUR_AREA_CODE STVAREA_CODE STVAREA
SDRSMUR_ATTR_CODE STVATTR_CODE STVATTR
SDRSMUR_REAS_CODE STVREAS_CODE STVREAS

Index

Index Name Index Type Column Name
PK_SDRSMUR Unique SDRSMUR_PIDM
PK_SDRSMUR Unique SDRSMUR_PROGRAM
PK_SDRSMUR Unique SDRSMUR_BLTN_YEAR
PK_SDRSMUR Unique SDRSMUR_SMUC_SEQ_NO
PK_SDRSMUR Unique SDRSMUR_SEQ_NO

Comments

Source Code Comments

Student Degree Program Multiple Use Requirement Repeating Table

Columns Comments for SDRSMUR_ACTIVITY_DATE (1)

Source Code Comments

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

Columns Comments for SDRSMUR_PIDM (2)

Source Code Comments

Internal identification number of the student who has a course that is being used to satisfy multiple course requirements.

Columns Comments for SDRSMUR_PROGRAM (3)

Source Code Comments

This field identifies the student"s degree program that contains the course requirements for the multiple use course.

Columns Comments for SDRSMUR_BLTN_YEAR (4)

Source Code Comments

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

Columns Comments for SDRSMUR_SMUC_SEQ_NO (5)

Source Code Comments

This field specifies the internal sequence number associated with the course that has been specified as a multiple use course.

Columns Comments for SDRSMUR_SEQ_NO (6)

Source Code Comments

This field specifies the internal sequence number associated with the course requirement that is being satisfied by the multiple use course.

Columns Comments for SDRSMUR_AREA_CODE (7)

Source Code Comments

This field identifies the area code (math, social sciences, etc.) within the degree program that has a course requirement being satisfied by a multiple use course.

Columns Comments for SDRSMUR_DPPR_SEQ_NO (8)

Source Code Comments

This field specifies the sequence number of the group that has a course requirement being satisfied by a multiple use course.

Columns Comments for SDRSMUR_DPCR_SEQ_NO (9)

Source Code Comments

This field specifies the sequence number of the cluster that has a course requirement being satisfied by a multiple use course.

Columns Comments for SDRSMUR_DPSR_SEQ_NO (10)

Source Code Comments

This field specifies the sequence number of the course requirement being satisfied by a multiple use course.

Columns Comments for SDRSMUR_PRIMARY_IND (11)

Source Code Comments

This field indicates the course requirement that is considered the primary requirement of the multiple use course. Valid value is: Y - Primary requirement. Only one requirement is primary.

Columns Comments for SDRSMUR_ADVR_PIDM (12)

Source Code Comments

This field identifies the internal identification number of the advisor who approved the use of one course to satisfy multiple requirements.

Columns Comments for SDRSMUR_REAS_CODE (13)

Source Code Comments

This field identifies the reason why the course requirement was approved to be satisfied by a multiple use course.

Columns Comments for SDRSMUR_ATTR_CODE (14)

Source Code Comments

Multiple use course attribute code

Table SDRSSSR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SDRSSSR_ACTIVITY_DATE SDRSSSR_ACTIVITY_DATE DATE No
SDRSSSR_PIDM SDRSSSR_PIDM NUMBER(8,0) No * *
SDRSSSR_PROGRAM SDRSSSR_PROGRAM VARCHAR2(6) No