Model SSRMEET

Model Label : Banner SSRMEET Table with Linked Tables
Path : BANNER DEV/COMMON/SSRMEET

List of Objects

Object Name	Object Type	Layer Name
GTVMTYP	TABLE	Default
GTVSCHS	TABLE	Default
SCRSCHD	TABLE	Default
SFRSTCR	TABLE	Default
SFTREGS	TABLE	Default
SIRASGN	TABLE	Default
SLBBLDG	TABLE	Default
SSBSECT	TABLE	Default
SSRMEET	TABLE	Default
SSRXLST	TABLE	Default
STVCOMT	TABLE	Default
STVDAYS	TABLE	Default

Comments

Model View

Table GTVMTYP

Schema Name GENERAL
Label GTVMTYP
Server name MALDEV8_B60
Creation Date 02/17/2003 18:03:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVMTYP_CODE	GTVMTYP_CODE	VARCHAR2(4)	No	*
GTVMTYP_DESC	GTVMTYP_DESC	VARCHAR2(30)	No
GTVMTYP_SYS_REQ_IND	GTVMTYP_SYS_REQ_IND	VARCHAR2(1)	No
GTVMTYP_ACTIVITY_DATE	GTVMTYP_ACTIVITY_DATE	DATE	No
GTVMTYP_USER_ID	GTVMTYP_USER_ID	VARCHAR2(30)	No
GTVMTYP_VR_MSG_NO	GTVMTYP_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVMTYP	Unique	GTVMTYP_CODE

Comments

Source Code Comments

Meeting Type Code validation table

Columns Comments for GTVMTYP_CODE (1)

Source Code Comments

Meeting Type Code: The Meeting Type Code

Columns Comments for GTVMTYP_DESC (2)

Source Code Comments

Description: Description of the Meeting Type code

Columns Comments for GTVMTYP_SYS_REQ_IND (3)

Source Code Comments

System Required Indicator: Indicates whether or not this record is required to exist on the database

Columns Comments for GTVMTYP_ACTIVITY_DATE (4)

Source Code Comments

Activty Date: Date this record entered or last updated

Columns Comments for GTVMTYP_USER_ID (5)

Source Code Comments

User ID: The username of the person who entered or last updated this record

Columns Comments for GTVMTYP_VR_MSG_NO (6)

Source Code Comments

Voice Response Message Number

Table GTVSCHS

Schema Name GENERAL
Label GTVSCHS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVSCHS_CODE	GTVSCHS_CODE	VARCHAR2(3)	No	*
GTVSCHS_DESC	GTVSCHS_DESC	VARCHAR2(30)	No
GTVSCHS_SYSTEM_REQ_IND	GTVSCHS_SYSTEM_REQ_IND	VARCHAR2(1)	No
GTVSCHS_ACTIVITY_DATE	GTVSCHS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSCHS	Unique	GTVSCHS_CODE

Comments

Source Code Comments

Validation entries for Schedule Status Codes.

Columns Comments for GTVSCHS_CODE (1)

Source Code Comments

Code for Schedule Status.

Columns Comments for GTVSCHS_DESC (2)

Source Code Comments

Description of Schedule Status code.

Columns Comments for GTVSCHS_SYSTEM_REQ_IND (3)

Source Code Comments

A Y in this column indicates that the row is delivered by SCT and required for the system.

Columns Comments for GTVSCHS_ACTIVITY_DATE (4)

Source Code Comments

This field identifies the date a record was created or updated.

Table SCRSCHD

Schema Name SATURN
Label SCRSCHD
Server name MALDEV8_B60
Creation Date 01/24/2003 13:30:40:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SCRSCHD_SUBJ_CODE	SCRSCHD_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCRSCHD_SUBJ_CODE	SCRSCHD_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCRSCHD_CRSE_NUMB	SCRSCHD_CRSE_NUMB	VARCHAR2(5)	No	*	*
SCRSCHD_EFF_TERM	SCRSCHD_EFF_TERM	VARCHAR2(6)	No	*	*
SCRSCHD_SCHD_CODE	SCRSCHD_SCHD_CODE	VARCHAR2(3)	No	*	*
SCRSCHD_ACTIVITY_DATE	SCRSCHD_ACTIVITY_DATE	DATE	No
SCRSCHD_WORKLOAD	SCRSCHD_WORKLOAD	NUMBER(9,3)	Yes
SCRSCHD_MAX_ENRL	SCRSCHD_MAX_ENRL	NUMBER(3,0)	Yes
SCRSCHD_ADJ_WORKLOAD	SCRSCHD_ADJ_WORKLOAD	NUMBER(9,3)	Yes
SCRSCHD_INSM_CODE	SCRSCHD_INSM_CODE	VARCHAR2(5)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRSCHD_INSM_CODE	GTVINSM_CODE	GTVINSM
SCRSCHD_SCHD_CODE	STVSCHD_CODE	STVSCHD
SCRSCHD_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRSCHD_EFF_TERM	STVTERM_CODE	STVTERM
SCRSCHD_SUBJ_CODE	SSBSECT_SUBJ_CODE	SSBSECT
SCRSCHD_CRSE_NUMB	SSBSECT_CRSE_NUMB	SSBSECT

Index

Index Name	Index Type	Column Name
PK_SCRSCHD	Unique	SCRSCHD_SUBJ_CODE
PK_SCRSCHD	Unique	SCRSCHD_CRSE_NUMB
PK_SCRSCHD	Unique	SCRSCHD_EFF_TERM
PK_SCRSCHD	Unique	SCRSCHD_SCHD_CODE

Comments

Source Code Comments

Course Schedule Type Repeating Table

Columns Comments for SCRSCHD_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRSCHD_CRSE_NUMB (2)

Source Code Comments

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

Columns Comments for SCRSCHD_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course schedule types becomes effective.

Columns Comments for SCRSCHD_SCHD_CODE (4)

Source Code Comments

This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.

Columns Comments for SCRSCHD_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for SCRSCHD_WORKLOAD (6)

Source Code Comments

Instructional workload value for the schedule type

Columns Comments for SCRSCHD_MAX_ENRL (7)

Source Code Comments

Maximum student enrollment for workload

Columns Comments for SCRSCHD_ADJ_WORKLOAD (8)

Source Code Comments

Adjust instructional workload value for the schedule type

Columns Comments for SCRSCHD_INSM_CODE (9)

Source Code Comments

Instructional Method code: This field indicates how the course is delivered to the learner. Examples are Web based, mixed media, face to face

Table SFRSTCR

Schema Name SATURN
Label SFRSTCR
Server name MALDEV8_B60
Creation Date 07/30/2003 16:03:46:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CLASS_SORT_KEY	SFRSTCR_CLASS_SORT_KEY	NUMBER(4,0)	Yes
SFRSTCR_REG_SEQ	SFRSTCR_REG_SEQ	NUMBER(4,0)	No
SFRSTCR_PTRM_CODE	SFRSTCR_PTRM_CODE	VARCHAR2(3)	Yes		*
SFRSTCR_RSTS_CODE	SFRSTCR_RSTS_CODE	VARCHAR2(2)	Yes		*
SFRSTCR_RSTS_DATE	SFRSTCR_RSTS_DATE	DATE	Yes
SFRSTCR_ERROR_FLAG	SFRSTCR_ERROR_FLAG	VARCHAR2(1)	Yes
SFRSTCR_MESSAGE	SFRSTCR_MESSAGE	VARCHAR2(25)	Yes
SFRSTCR_BILL_HR	SFRSTCR_BILL_HR	NUMBER(7,3)	Yes
SFRSTCR_WAIV_HR	SFRSTCR_WAIV_HR	NUMBER(7,3)	Yes
SFRSTCR_CREDIT_HR	SFRSTCR_CREDIT_HR	NUMBER(7,3)	Yes
SFRSTCR_BILL_HR_HOLD	SFRSTCR_BILL_HR_HOLD	NUMBER(7,3)	Yes
SFRSTCR_CREDIT_HR_HOLD	SFRSTCR_CREDIT_HR_HOLD	NUMBER(7,3)	Yes
SFRSTCR_GMOD_CODE	SFRSTCR_GMOD_CODE	VARCHAR2(1)	Yes		*
SFRSTCR_GRDE_CODE	SFRSTCR_GRDE_CODE	VARCHAR2(6)	Yes
SFRSTCR_GRDE_CODE_MID	SFRSTCR_GRDE_CODE_MID	VARCHAR2(6)	Yes
SFRSTCR_GRDE_DATE	SFRSTCR_GRDE_DATE	DATE	Yes
SFRSTCR_DUPL_OVER	SFRSTCR_DUPL_OVER	VARCHAR2(1)	Yes
SFRSTCR_LINK_OVER	SFRSTCR_LINK_OVER	VARCHAR2(1)	Yes
SFRSTCR_CORQ_OVER	SFRSTCR_CORQ_OVER	VARCHAR2(1)	Yes
SFRSTCR_PREQ_OVER	SFRSTCR_PREQ_OVER	VARCHAR2(1)	Yes
SFRSTCR_TIME_OVER	SFRSTCR_TIME_OVER	VARCHAR2(1)	Yes
SFRSTCR_CAPC_OVER	SFRSTCR_CAPC_OVER	VARCHAR2(1)	Yes
SFRSTCR_LEVL_OVER	SFRSTCR_LEVL_OVER	VARCHAR2(1)	Yes
SFRSTCR_COLL_OVER	SFRSTCR_COLL_OVER	VARCHAR2(1)	Yes
SFRSTCR_MAJR_OVER	SFRSTCR_MAJR_OVER	VARCHAR2(1)	Yes
SFRSTCR_CLAS_OVER	SFRSTCR_CLAS_OVER	VARCHAR2(1)	Yes
SFRSTCR_APPR_OVER	SFRSTCR_APPR_OVER	VARCHAR2(1)	Yes
SFRSTCR_APPR_RECEIVED_IND	SFRSTCR_APPR_RECEIVED_IND	VARCHAR2(1)	Yes
SFRSTCR_ADD_DATE	SFRSTCR_ADD_DATE	DATE	No
SFRSTCR_ACTIVITY_DATE	SFRSTCR_ACTIVITY_DATE	DATE	No
SFRSTCR_LEVL_CODE	SFRSTCR_LEVL_CODE	VARCHAR2(2)	No		*
SFRSTCR_CAMP_CODE	SFRSTCR_CAMP_CODE	VARCHAR2(3)	No		*
SFRSTCR_RESERVED_KEY	SFRSTCR_RESERVED_KEY	VARCHAR2(8)	Yes
SFRSTCR_ATTEND_HR	SFRSTCR_ATTEND_HR	NUMBER(9,3)	Yes
SFRSTCR_REPT_OVER	SFRSTCR_REPT_OVER	VARCHAR2(1)	Yes
SFRSTCR_RPTH_OVER	SFRSTCR_RPTH_OVER	VARCHAR2(1)	Yes
SFRSTCR_TEST_OVER	SFRSTCR_TEST_OVER	VARCHAR2(1)	Yes
SFRSTCR_CAMP_OVER	SFRSTCR_CAMP_OVER	VARCHAR2(1)	Yes
SFRSTCR_USER	SFRSTCR_USER	VARCHAR2(30)	Yes
SFRSTCR_DEGC_OVER	SFRSTCR_DEGC_OVER	VARCHAR2(1)	Yes
SFRSTCR_PROG_OVER	SFRSTCR_PROG_OVER	VARCHAR2(1)	Yes
SFRSTCR_LAST_ATTEND	SFRSTCR_LAST_ATTEND	DATE	Yes
SFRSTCR_GCMT_CODE	SFRSTCR_GCMT_CODE	VARCHAR2(7)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRSTCR_TERM_CODE	RORENRL_TERM_CODE	RORENRL
SFRSTCR_PIDM	RORENRL_PIDM	RORENRL
SFRSTCR_TERM_CODE	SSRSYLN_TERM_CODE	SSRSYLN
SFRSTCR_CRN	SSRSYLN_CRN	SSRSYLN
SFRSTCR_TERM_CODE	SHRSMRK_TERM_CODE	SHRSMRK
SFRSTCR_PIDM	SHRSMRK_PIDM	SHRSMRK
SFRSTCR_CRN	SHRSMRK_CRN	SHRSMRK
SFRSTCR_TERM_CODE	SFRENRL_TERM_CODE	SFRENRL
SFRSTCR_PIDM	SFRENRL_PIDM	SFRENRL
SFRSTCR_PTRM_CODE	STVPTRM_CODE	STVPTRM
SFRSTCR_PIDM	SFBETRM_PIDM	SFBETRM
SFRSTCR_TERM_CODE	SFBETRM_TERM_CODE	SFBETRM
SFRSTCR_TERM_CODE	SHRMRKS_TERM_CODE	SHRMRKS
SFRSTCR_PIDM	SHRMRKS_PIDM	SHRMRKS
SFRSTCR_CRN	SHRMRKS_CRN	SHRMRKS
SFRSTCR_GCMT_CODE	STVGCMT_CODE	STVGCMT
SFRSTCR_CAMP_CODE	STVCAMP_CODE	STVCAMP
SFRSTCR_LEVL_CODE	STVLEVL_CODE	STVLEVL
SFRSTCR_TERM_CODE	STVTERM_CODE	STVTERM
SFRSTCR_GMOD_CODE	STVGMOD_CODE	STVGMOD
SFRSTCR_CRN	SSBSECT_CRN	SSBSECT
SFRSTCR_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SFRSTCR_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SFRSTCR_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRSTCR_PIDM	TBRACCD_PIDM	TBRACCD
SFRSTCR_TERM_CODE	TBRACCD_TERM_CODE	TBRACCD
SFRSTCR_CRN	TBRACCD_CRN	TBRACCD

Index

Index Name	Index Type	Column Name
PK_SFRSTCR	Unique	SFRSTCR_TERM_CODE
PK_SFRSTCR	Unique	SFRSTCR_PIDM
PK_SFRSTCR	Unique	SFRSTCR_CRN
SFRSTCR_INDEX2		SFRSTCR_TERM_CODE
SFRSTCR_INDEX2		SFRSTCR_CRN
SFRSTCR_INDEX2		SFRSTCR_CLASS_SORT_KEY
SFRSTCR_INDEX2		SFRSTCR_REG_SEQ
SFRSTCR_KEY_INDEX3		SFRSTCR_PIDM

Comments

Source Code Comments

Student Course Registration Repeating Table

Columns Comments for SFRSTCR_TERM_CODE (1)

Source Code Comments

This field identifies the registration term code.

Columns Comments for SFRSTCR_PIDM (2)

Source Code Comments

Internal Identification Number of the person registered.

Columns Comments for SFRSTCR_CRN (3)

Source Code Comments

This field identifies the course reference number associated with the class section.

Columns Comments for SFRSTCR_CLASS_SORT_KEY (4)

Source Code Comments

This field identifies the class of the registrant.

Columns Comments for SFRSTCR_REG_SEQ (5)

Source Code Comments

This field identifies the sequence in which the student enrolled in the associated class section.

Columns Comments for SFRSTCR_PTRM_CODE (6)

Source Code Comments

This field identifies the part-of-term code associated with this CRN.

Columns Comments for SFRSTCR_RSTS_CODE (7)

Source Code Comments

This field identifies the course registration status associated with this CRN.

Columns Comments for SFRSTCR_RSTS_DATE (8)

Source Code Comments

This field identifies the date associated with the course registration status of this CRN.

Columns Comments for SFRSTCR_ERROR_FLAG (9)

Source Code Comments

This field identifies an error associated with the registration of this CRN. Valid values are F=Fatal, D=Do not count in enrollment, L=WaitListed, O=Override.

Columns Comments for SFRSTCR_MESSAGE (10)

Source Code Comments

This field identifies a message associated with the registration of the CRN

Columns Comments for SFRSTCR_BILL_HR (11)

Source Code Comments

This field identifies the billing hours associated with this CRN.

Columns Comments for SFRSTCR_WAIV_HR (12)

Source Code Comments

This field identifies the waived hours associated with this CRN.

Columns Comments for SFRSTCR_CREDIT_HR (13)

Source Code Comments

This field identifies the credit hours associated with this CRN.

Columns Comments for SFRSTCR_BILL_HR_HOLD (14)

Source Code Comments

This field identifies the billing hours to hold for reinstatements.

Columns Comments for SFRSTCR_CREDIT_HR_HOLD (15)

Source Code Comments

This field identifies the credit hours to hold for reinstatements.

Columns Comments for SFRSTCR_GMOD_CODE (16)

Source Code Comments

This field identifies the grade mode associated with this CRN.

Columns Comments for SFRSTCR_GRDE_CODE (17)

Source Code Comments

This field identifies the grade code associated with this CRN.

Columns Comments for SFRSTCR_GRDE_CODE_MID (18)

Source Code Comments

This field identifies the mid-term grade code associated with this CRN.

Columns Comments for SFRSTCR_GRDE_DATE (19)

Source Code Comments

This field identifies the date associated with the grade of this CRN.

Columns Comments for SFRSTCR_DUPL_OVER (20)

Source Code Comments

This field identifies the duplicate course override of this CRN.

Columns Comments for SFRSTCR_LINK_OVER (21)

Source Code Comments

This field identifies the link override of this CRN.

Columns Comments for SFRSTCR_CORQ_OVER (22)

Source Code Comments

This field identifies the corequisite override of this CRN.

Columns Comments for SFRSTCR_PREQ_OVER (23)

Source Code Comments

This field identifies the prerequisite override of this CRN.

Columns Comments for SFRSTCR_TIME_OVER (24)

Source Code Comments

This field identifies the time conflict override of this CRN.

Columns Comments for SFRSTCR_CAPC_OVER (25)

Source Code Comments

This field identifies the capacity override of this CRN.

Columns Comments for SFRSTCR_LEVL_OVER (26)

Source Code Comments

This field identifies the level restriction override of this CRN.

Columns Comments for SFRSTCR_COLL_OVER (27)

Source Code Comments

This field identifies the college restriction override of this CRN.

Columns Comments for SFRSTCR_MAJR_OVER (28)

Source Code Comments

This field identifies the major restriction override of this CRN.

Columns Comments for SFRSTCR_CLAS_OVER (29)

Source Code Comments

This field identifies the class restriction override of this CRN.

Columns Comments for SFRSTCR_APPR_OVER (30)

Source Code Comments

This field identifies the special approval override of this CRN.

Columns Comments for SFRSTCR_APPR_RECEIVED_IND (31)

Source Code Comments

This field identifies the special approval received indicator for this CRN.

Columns Comments for SFRSTCR_ADD_DATE (32)

Source Code Comments

This field identifies the add date of the registrant in this CRN.

Columns Comments for SFRSTCR_ACTIVITY_DATE (33)

Source Code Comments

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

Columns Comments for SFRSTCR_LEVL_CODE (34)

Source Code Comments

This field identifies the level the registrant is enrolled for this CRN.

Columns Comments for SFRSTCR_CAMP_CODE (35)

Source Code Comments

This field identifies the campus code of this CRN.

Columns Comments for SFRSTCR_RESERVED_KEY (36)

Source Code Comments

Student Course Registration Table Reserved Key.

Columns Comments for SFRSTCR_ATTEND_HR (37)

Source Code Comments

This column contains the number of hours the student attended this class

Columns Comments for SFRSTCR_REPT_OVER (38)

Source Code Comments

This field identifies the repeat course restriction override of the CRN

Columns Comments for SFRSTCR_RPTH_OVER (39)

Source Code Comments

This field identifies the repeat course hour restriction override of the CRN

Columns Comments for SFRSTCR_TEST_OVER (40)

Source Code Comments

This field identifies the test score restriction override of the CRN

Columns Comments for SFRSTCR_CAMP_OVER (41)

Source Code Comments

The Campus Registration Restriction override code

Columns Comments for SFRSTCR_USER (42)

Source Code Comments

Identifies the user who entered the registration request.

Columns Comments for SFRSTCR_DEGC_OVER (43)

Source Code Comments

Degree restriction override indicator

Columns Comments for SFRSTCR_PROG_OVER (44)

Source Code Comments

Program restriction override indicator

Columns Comments for SFRSTCR_LAST_ATTEND (45)

Source Code Comments

Date student last attended this class

Columns Comments for SFRSTCR_GCMT_CODE (46)

Source Code Comments

GRADE COMMENT CODE: This field indicates the grade comment (result code) for the section.

Table SFTREGS

Schema Name SATURN
Label SFTREGS
Server name MALDEV8_B60
Creation Date 08/04/2003 10:44:02:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFTREGS_TERM_CODE	SFTREGS_TERM_CODE	VARCHAR2(6)	No	*	*
SFTREGS_PIDM	SFTREGS_PIDM	NUMBER(8,0)	No	*
SFTREGS_CRN	SFTREGS_CRN	VARCHAR2(5)	No	*
SFTREGS_PTRM_CODE	SFTREGS_PTRM_CODE	VARCHAR2(3)	Yes
SFTREGS_RSTS_CODE	SFTREGS_RSTS_CODE	VARCHAR2(2)	Yes		*
SFTREGS_RSTS_DATE	SFTREGS_RSTS_DATE	DATE	Yes
SFTREGS_ERROR_FLAG	SFTREGS_ERROR_FLAG	VARCHAR2(1)	Yes
SFTREGS_MESSAGE	SFTREGS_MESSAGE	VARCHAR2(25)	Yes
SFTREGS_BILL_HR	SFTREGS_BILL_HR	NUMBER(7,3)	Yes
SFTREGS_WAIV_HR	SFTREGS_WAIV_HR	NUMBER(7,3)	Yes
SFTREGS_CREDIT_HR	SFTREGS_CREDIT_HR	NUMBER(7,3)	Yes
SFTREGS_BILL_HR_HOLD	SFTREGS_BILL_HR_HOLD	NUMBER(7,3)	Yes
SFTREGS_CREDIT_HR_HOLD	SFTREGS_CREDIT_HR_HOLD	NUMBER(7,3)	Yes
SFTREGS_GMOD_CODE	SFTREGS_GMOD_CODE	VARCHAR2(1)	Yes
SFTREGS_GRDE_CODE	SFTREGS_GRDE_CODE	VARCHAR2(6)	Yes
SFTREGS_GRDE_CODE_MID	SFTREGS_GRDE_CODE_MID	VARCHAR2(6)	Yes
SFTREGS_GRDE_DATE	SFTREGS_GRDE_DATE	DATE	Yes
SFTREGS_DUPL_OVER	SFTREGS_DUPL_OVER	VARCHAR2(1)	Yes
SFTREGS_LINK_OVER	SFTREGS_LINK_OVER	VARCHAR2(1)	Yes
SFTREGS_CORQ_OVER	SFTREGS_CORQ_OVER	VARCHAR2(1)	Yes
SFTREGS_PREQ_OVER	SFTREGS_PREQ_OVER	VARCHAR2(1)	Yes
SFTREGS_TIME_OVER	SFTREGS_TIME_OVER	VARCHAR2(1)	Yes
SFTREGS_CAPC_OVER	SFTREGS_CAPC_OVER	VARCHAR2(1)	Yes
SFTREGS_LEVL_OVER	SFTREGS_LEVL_OVER	VARCHAR2(1)	Yes
SFTREGS_COLL_OVER	SFTREGS_COLL_OVER	VARCHAR2(1)	Yes
SFTREGS_MAJR_OVER	SFTREGS_MAJR_OVER	VARCHAR2(1)	Yes
SFTREGS_CLAS_OVER	SFTREGS_CLAS_OVER	VARCHAR2(1)	Yes
SFTREGS_APPR_OVER	SFTREGS_APPR_OVER	VARCHAR2(1)	Yes
SFTREGS_APPR_RECEIVED_IND	SFTREGS_APPR_RECEIVED_IND	VARCHAR2(1)	Yes
SFTREGS_ADD_DATE	SFTREGS_ADD_DATE	DATE	Yes
SFTREGS_ACTIVITY_DATE	SFTREGS_ACTIVITY_DATE	DATE	Yes
SFTREGS_LEVL_CODE	SFTREGS_LEVL_CODE	VARCHAR2(2)	Yes
SFTREGS_CAMP_CODE	SFTREGS_CAMP_CODE	VARCHAR2(3)	Yes
SFTREGS_RESERVED_KEY	SFTREGS_RESERVED_KEY	VARCHAR2(8)	Yes
SFTREGS_REPT_OVER	SFTREGS_REPT_OVER	VARCHAR2(1)	Yes
SFTREGS_RPTH_OVER	SFTREGS_RPTH_OVER	VARCHAR2(1)	Yes
SFTREGS_TEST_OVER	SFTREGS_TEST_OVER	VARCHAR2(1)	Yes
SFTREGS_CAMP_OVER	SFTREGS_CAMP_OVER	VARCHAR2(1)	Yes
SFTREGS_USER	SFTREGS_USER	VARCHAR2(30)	Yes
SFTREGS_DEGC_OVER	SFTREGS_DEGC_OVER	VARCHAR2(1)	Yes
SFTREGS_PROG_OVER	SFTREGS_PROG_OVER	VARCHAR2(1)	Yes
SFTREGS_SECT_SUBJ_CODE	SFTREGS_SECT_SUBJ_CODE	VARCHAR2(4)	Yes
SFTREGS_SECT_CRSE_NUMB	SFTREGS_SECT_CRSE_NUMB	VARCHAR2(5)	Yes
SFTREGS_SECT_SEQ_NUMB	SFTREGS_SECT_SEQ_NUMB	VARCHAR2(5)	Yes
SFTREGS_CRSE_CEU_IND	SFTREGS_CRSE_CEU_IND	VARCHAR2(1)	Yes
SFTREGS_VR_STATUS_TYPE	SFTREGS_VR_STATUS_TYPE	VARCHAR2(1)	Yes
SFTREGS_WAIT_OVER	SFTREGS_WAIT_OVER	VARCHAR2(1)	Yes
SFTREGS_REC_STAT	SFTREGS_REC_STAT	VARCHAR2(1)	Yes
SFTREGS_GCMT_CDE	SFTREGS_GCMT_CDE	VARCHAR2(7)	Yes
SFTREGS_REMOVE_IND	SFTREGS_REMOVE_IND	VARCHAR2(1)	Yes
SFTREGS_START_DATE	SFTREGS_START_DATE	DATE	Yes
SFTREGS_COMPLETION_DATE	SFTREGS_COMPLETION_DATE	DATE	Yes
SFTREGS_NUMBER_OF_UNITS	SFTREGS_NUMBER_OF_UNITS	NUMBER(7,2)	Yes
SFTREGS_DUNT_CODE	SFTREGS_DUNT_CODE	VARCHAR2(4)	Yes		*
SFTREGS_SECT_SCHD_CODE	SFTREGS_SECT_SCHD_CODE	VARCHAR2(3)	Yes		*
SFTREGS_CRSE_TITLE	SFTREGS_CRSE_TITLE	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFTREGS_DUNT_CODE	GTVDUNT_CODE	GTVDUNT
SFTREGS_SECT_SCHD_CODE	STVSCHD_CODE	STVSCHD
SFTREGS_TERM_CODE	STVTERM_CODE	STVTERM
SFTREGS_RSTS_CODE	STVRSTS_CODE	STVRSTS

Index

Index Name	Index Type	Column Name
PK_SFTREGS	Unique	SFTREGS_PIDM
PK_SFTREGS	Unique	SFTREGS_TERM_CODE
PK_SFTREGS	Unique	SFTREGS_CRN

Comments

Columns Comments for SFTREGS_GCMT_CDE (49)

Source Code Comments

GRADE COMMENT CODE: This field indicates the grade comment (result code) for the section.

Columns Comments for SFTREGS_REMOVE_IND (50)

Source Code Comments

This field indicates whether the course will be physically removed from the student's list of classes. Y = Delete the record; N = Do not delete the record.

Columns Comments for SFTREGS_START_DATE (51)

Source Code Comments

Registration start date: This field contains the start date of the registration

Columns Comments for SFTREGS_COMPLETION_DATE (52)

Source Code Comments

Registration completion date: This field contains the completion date of the registration

Columns Comments for SFTREGS_NUMBER_OF_UNITS (53)

Source Code Comments

Duration number of units: indicates the total number of times the duration unit extends

Columns Comments for SFTREGS_DUNT_CODE (54)

Source Code Comments

Duration Unit code: The field contains the duration unit code assigned to the section registered for

Columns Comments for SFTREGS_SECT_SCHD_CODE (55)

Source Code Comments

This field identifies the instructional type of the section being scheduled. Validation form = STVSCHD.

Columns Comments for SFTREGS_CRSE_TITLE (56)

Source Code Comments

This field contains the title of the course.

Table SIRASGN

Schema Name SATURN
Label SIRASGN
Server name MALDEV8_B60
Creation Date 04/22/2003 16:14:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_TERM_CODE	SIRASGN_TERM_CODE	VARCHAR2(6)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_CRN	SIRASGN_CRN	VARCHAR2(5)	No	*	*
SIRASGN_PIDM	SIRASGN_PIDM	NUMBER(8,0)	No	*	*
SIRASGN_PIDM	SIRASGN_PIDM	NUMBER(8,0)	No	*	*
SIRASGN_CATEGORY	SIRASGN_CATEGORY	VARCHAR2(2)	No	*
SIRASGN_PERCENT_RESPONSE	SIRASGN_PERCENT_RESPONSE	NUMBER(3,0)	No
SIRASGN_WORKLOAD_ADJUST	SIRASGN_WORKLOAD_ADJUST	NUMBER(9,3)	Yes
SIRASGN_PERCENT_SESS	SIRASGN_PERCENT_SESS	NUMBER(3,0)	No
SIRASGN_PRIMARY_IND	SIRASGN_PRIMARY_IND	VARCHAR2(1)	Yes
SIRASGN_OVER_RIDE	SIRASGN_OVER_RIDE	VARCHAR2(1)	Yes
SIRASGN_POSITION	SIRASGN_POSITION	NUMBER(8,0)	Yes
SIRASGN_ACTIVITY_DATE	SIRASGN_ACTIVITY_DATE	DATE	No
SIRASGN_FCNT_CODE	SIRASGN_FCNT_CODE	VARCHAR2(2)	Yes		*
SIRASGN_FCNT_CODE	SIRASGN_FCNT_CODE	VARCHAR2(2)	Yes		*
SIRASGN_POSN	SIRASGN_POSN	VARCHAR2(6)	Yes
SIRASGN_SUFF	SIRASGN_SUFF	VARCHAR2(2)	Yes
SIRASGN_ASTY_CODE	SIRASGN_ASTY_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SIRASGN_PIDM	SIRCOLR_PIDM	SIRCOLR
SIRASGN_FCNT_CODE	SIRCOLR_FCNT_CODE	SIRCOLR
SIRASGN_TERM_CODE	SIRCOLR_TERM_CODE	SIRCOLR
SIRASGN_PIDM	SFRAREG_INSTRUCTOR_PIDM	SFRAREG
SIRASGN_TERM_CODE	SFRAREG_TERM_CODE	SFRAREG
SIRASGN_CRN	SFRAREG_CRN	SFRAREG
SIRASGN_FCNT_CODE	STVFCNT_CODE	STVFCNT
SIRASGN_CRN	SHRTCKN_CRN	SHRTCKN
SIRASGN_TERM_CODE	SHRTCKN_TERM_CODE	SHRTCKN
SIRASGN_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SIRASGN_CRN	SFRSTCR_CRN	SFRSTCR
SIRASGN_ASTY_CODE	STVASTY_CODE	STVASTY
SIRASGN_TERM_CODE	STVTERM_CODE	STVTERM
SIRASGN_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT
SIRASGN_CRN	SSBSECT_CRN	SSBSECT
SIRASGN_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM

Index

Index Name	Index Type	Column Name
PK_SIRASGN	Unique	SIRASGN_TERM_CODE
PK_SIRASGN	Unique	SIRASGN_CRN
PK_SIRASGN	Unique	SIRASGN_PIDM
PK_SIRASGN	Unique	SIRASGN_CATEGORY
SIRASGN_KEY_INDEX2	Unique	SIRASGN_PIDM
SIRASGN_KEY_INDEX2	Unique	SIRASGN_TERM_CODE
SIRASGN_KEY_INDEX2	Unique	SIRASGN_CRN
SIRASGN_KEY_INDEX2	Unique	SIRASGN_CATEGORY