Model SGRCOOP

Model Label : ERD for Banner Student Table SGRCOOP
Path : BANNER DEV/Student/Common/SGRCOOP/SGRCOOP_ERD

List of Objects

Object Name	Object Type	Layer Name
SFRAREG	TABLE	Default
SFRSTCR	TABLE	Default
SGRCOOP	TABLE	Default
SGRDUTY	TABLE	Default
STVCOPC	TABLE	Default
STVEMPL	TABLE	Default
STVLEVL	TABLE	Default
STVTERM	TABLE	Default

Comments

Model View

Table SFRAREG

Schema Name SATURN
Label SFRAREG
Server name MALDEV8_B60
Creation Date 04/13/2003 21:12:31:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRAREG_PIDM	SFRAREG_PIDM	NUMBER(8,0)	No	*	*
SFRAREG_PIDM	SFRAREG_PIDM	NUMBER(8,0)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_TERM_CODE	SFRAREG_TERM_CODE	VARCHAR2(6)	No	*	*
SFRAREG_CRN	SFRAREG_CRN	VARCHAR2(5)	No	*	*
SFRAREG_CRN	SFRAREG_CRN	VARCHAR2(5)	No	*	*
SFRAREG_EXTENSION_NUMBER	SFRAREG_EXTENSION_NUMBER	NUMBER(3,0)	No	*
SFRAREG_RSTS_CODE	SFRAREG_RSTS_CODE	VARCHAR2(2)	No		*
SFRAREG_START_DATE	SFRAREG_START_DATE	DATE	No
SFRAREG_COMPLETION_DATE	SFRAREG_COMPLETION_DATE	DATE	No
SFRAREG_FEE_WAIVER_IND	SFRAREG_FEE_WAIVER_IND	VARCHAR2(1)	No
SFRAREG_SAPR_OVERRIDE_IND	SFRAREG_SAPR_OVERRIDE_IND	VARCHAR2(1)	No
SFRAREG_ACTIVITY_DATE	SFRAREG_ACTIVITY_DATE	DATE	No
SFRAREG_USER_ID	SFRAREG_USER_ID	VARCHAR2(30)	No
SFRAREG_NUMBER_OF_UNITS	SFRAREG_NUMBER_OF_UNITS	NUMBER(7,2)	Yes
SFRAREG_DUNT_CODE	SFRAREG_DUNT_CODE	VARCHAR2(4)	Yes		*
SFRAREG_DETL_CODE	SFRAREG_DETL_CODE	VARCHAR2(4)	Yes		*
SFRAREG_AMOUNT	SFRAREG_AMOUNT	NUMBER(7,2)	Yes
SFRAREG_INSTRUCTOR_PIDM	SFRAREG_INSTRUCTOR_PIDM	NUMBER(8,0)	Yes
SFRAREG_TRAN_NUMBER	SFRAREG_TRAN_NUMBER	NUMBER(8,0)	Yes
SFRAREG_EFFECTIVE_DATE	SFRAREG_EFFECTIVE_DATE	DATE	Yes
SFRAREG_COMMENTS	SFRAREG_COMMENTS	CLOB	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFRAREG_DUNT_CODE	GTVDUNT_CODE	GTVDUNT
SFRAREG_TERM_CODE	STVTERM_CODE	STVTERM
SFRAREG_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRAREG_DETL_CODE	TBBDETC_DETAIL_CODE	TBBDETC
SFRAREG_CRN	SFTREGS_CRN	SFTREGS
SFRAREG_TERM_CODE	SFTREGS_TERM_CODE	SFTREGS
SFRAREG_PIDM	SFTREGS_PIDM	SFTREGS
SFRAREG_PIDM	SFRSTCR_PIDM	SFRSTCR
SFRAREG_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SFRAREG_CRN	SFRSTCR_CRN	SFRSTCR

Index

Index Name	Index Type	Column Name
PK_SFRAREG	Unique	SFRAREG_PIDM
PK_SFRAREG	Unique	SFRAREG_TERM_CODE
PK_SFRAREG	Unique	SFRAREG_CRN
PK_SFRAREG	Unique	SFRAREG_EXTENSION_NUMBER
SFRAREG_START_DATE_INDEX		SFRAREG_START_DATE
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_TERM_CODE
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_CRN
SFRAREG_TERM_CRN_INSTRUC_INDEX		SFRAREG_INSTRUCTOR_PIDM

Comments

Source Code Comments

Open Learning Additional Registration Information table

Columns Comments for SFRAREG_PIDM (1)

Source Code Comments

Personal Identification Number: The system generated internal identification number

Columns Comments for SFRAREG_TERM_CODE (2)

Source Code Comments

Term code: Indicates the term of the registration information/extension

Columns Comments for SFRAREG_CRN (3)

Source Code Comments

Course Reference Number: Indicates the section that is registered for

Columns Comments for SFRAREG_EXTENSION_NUMBER (4)

Source Code Comments

Extension number: The number in sequence of how many extensions have been granted for the section

Columns Comments for SFRAREG_RSTS_CODE (5)

Source Code Comments

Registration status code: Indicates the registration status code assigned to the registration

Columns Comments for SFRAREG_START_DATE (6)

Source Code Comments

Extension Start date: Date the extension or registration starts

Columns Comments for SFRAREG_COMPLETION_DATE (7)

Source Code Comments

Extension Completion date: Date this extension should finish

Columns Comments for SFRAREG_FEE_WAIVER_IND (8)

Source Code Comments

Fee Waiver Indicator: This field used to waive the charge normally generated by this extension

Columns Comments for SFRAREG_SAPR_OVERRIDE_IND (9)

Source Code Comments

Special Approval Override indicator. This field used to provide a registration override for sections that normally require special approval

Columns Comments for SFRAREG_ACTIVITY_DATE (10)

Source Code Comments

Activity date: Date this record entered or last updated

Columns Comments for SFRAREG_USER_ID (11)

Source Code Comments

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

Columns Comments for SFRAREG_NUMBER_OF_UNITS (12)

Source Code Comments

Duration number of units: The number of duration units awarded this extension

Columns Comments for SFRAREG_DUNT_CODE (13)

Source Code Comments

Duration Unit Code: The duration unit code assigned to the extension

Columns Comments for SFRAREG_DETL_CODE (14)

Source Code Comments

Detail Code: The detail fee code assigned to the extension

Columns Comments for SFRAREG_AMOUNT (15)

Source Code Comments

Amount: The amount to be charged to the student for this extension

Columns Comments for SFRAREG_INSTRUCTOR_PIDM (16)

Source Code Comments

Instructor personal identification number: The system defined personal identification number of the instructor assigned to this extension

Columns Comments for SFRAREG_TRAN_NUMBER (17)

Source Code Comments

Transaction number: The transaction number written to the accounting record when fee assessment is run.

Columns Comments for SFRAREG_EFFECTIVE_DATE (18)

Source Code Comments

Effective Date: The effective date of the charge generated by fee assessment for this extension

Columns Comments for SFRAREG_COMMENTS (19)

Source Code Comments

Comments: This area provided to house comments or reason related to the course extension

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_PTRM_CODE	STVPTRM_CODE	STVPTRM
SFRSTCR_PIDM	SFBETRM_PIDM	SFBETRM
SFRSTCR_TERM_CODE	SFBETRM_TERM_CODE	SFBETRM
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_RSTS_CODE	STVRSTS_CODE	STVRSTS
SFRSTCR_TERM_CODE	SFRENRL_TERM_CODE	SFRENRL
SFRSTCR_PIDM	SFRENRL_PIDM	SFRENRL
SFRSTCR_PIDM	TBRACCD_PIDM	TBRACCD
SFRSTCR_TERM_CODE	TBRACCD_TERM_CODE	TBRACCD
SFRSTCR_CRN	TBRACCD_CRN	TBRACCD
SFRSTCR_TERM_CODE	SOBTERM_TERM_CODE	SOBTERM
SFRSTCR_TERM_CODE	SSRSYLN_TERM_CODE	SSRSYLN
SFRSTCR_CRN	SSRSYLN_CRN	SSRSYLN
SFRSTCR_TERM_CODE	RORENRL_TERM_CODE	RORENRL
SFRSTCR_PIDM	RORENRL_PIDM	RORENRL
SFRSTCR_TERM_CODE	SHRMRKS_TERM_CODE	SHRMRKS
SFRSTCR_PIDM	SHRMRKS_PIDM	SHRMRKS
SFRSTCR_CRN	SHRMRKS_CRN	SHRMRKS
SFRSTCR_TERM_CODE	SHRSMRK_TERM_CODE	SHRSMRK
SFRSTCR_PIDM	SHRSMRK_PIDM	SHRSMRK
SFRSTCR_CRN	SHRSMRK_CRN	SHRSMRK
SFRSTCR_CRN	SSBSECT_CRN	SSBSECT
SFRSTCR_TERM_CODE	SSBSECT_TERM_CODE	SSBSECT

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 SGRCOOP

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGRCOOP_PIDM	SGRCOOP_PIDM	NUMBER(8,0)	No	*	*
SGRCOOP_PIDM	SGRCOOP_PIDM	NUMBER(8,0)	No	*	*
SGRCOOP_TERM_CODE	SGRCOOP_TERM_CODE	VARCHAR2(6)	No	*	*
SGRCOOP_TERM_CODE	SGRCOOP_TERM_CODE	VARCHAR2(6)	No	*	*
SGRCOOP_TERM_CODE	SGRCOOP_TERM_CODE	VARCHAR2(6)	No	*	*
SGRCOOP_LEVL_CODE	SGRCOOP_LEVL_CODE	VARCHAR2(2)	No	*	*
SGRCOOP_EMPL_CODE	SGRCOOP_EMPL_CODE	VARCHAR2(4)	Yes		*
SGRCOOP_COPC_CODE	SGRCOOP_COPC_CODE	VARCHAR2(6)	Yes		*
SGRCOOP_END_DATE	SGRCOOP_END_DATE	DATE	Yes
SGRCOOP_BEGIN_DATE	SGRCOOP_BEGIN_DATE	DATE	Yes
SGRCOOP_INTEREST_IND	SGRCOOP_INTEREST_IND	VARCHAR2(1)	Yes
SGRCOOP_EMPL_CONTACT_NAME	SGRCOOP_EMPL_CONTACT_NAME	VARCHAR2(30)	Yes
SGRCOOP_EMPL_CONTACT_TITLE	SGRCOOP_EMPL_CONTACT_TITLE	VARCHAR2(30)	Yes
SGRCOOP_ACTIVITY_DATE	SGRCOOP_ACTIVITY_DATE	DATE	No
SGRCOOP_PHONE_AREA	SGRCOOP_PHONE_AREA	VARCHAR2(3)	Yes
SGRCOOP_PHONE_NUMBER	SGRCOOP_PHONE_NUMBER	VARCHAR2(7)	Yes
SGRCOOP_PHONE_EXT	SGRCOOP_PHONE_EXT	VARCHAR2(4)	Yes
SGRCOOP_SEQ_NO	SGRCOOP_SEQ_NO	NUMBER(4,0)	No	*
SGRCOOP_CRN	SGRCOOP_CRN	VARCHAR2(5)	Yes		*
SGRCOOP_CRN	SGRCOOP_CRN	VARCHAR2(5)	Yes		*
SGRCOOP_EVAL_PREPARED_DATE	SGRCOOP_EVAL_PREPARED_DATE	DATE	Yes
SGRCOOP_EVAL_RECEIVED_DATE	SGRCOOP_EVAL_RECEIVED_DATE	DATE	Yes
SGRCOOP_OVERRIDE_IND	SGRCOOP_OVERRIDE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRCOOP_EMPL_CODE	STVEMPL_CODE	STVEMPL
SGRCOOP_COPC_CODE	STVCOPC_CODE	STVCOPC
SGRCOOP_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRCOOP_TERM_CODE	STVTERM_CODE	STVTERM
SGRCOOP_PIDM	SFRSTCR_PIDM	SFRSTCR
SGRCOOP_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
SGRCOOP_CRN	SFRSTCR_CRN	SFRSTCR
SGRCOOP_PIDM	SFRAREG_PIDM	SFRAREG
SGRCOOP_TERM_CODE	SFRAREG_TERM_CODE	SFRAREG
SGRCOOP_CRN	SFRAREG_CRN	SFRAREG

Index

Index Name	Index Type	Column Name
PK_SGRCOOP	Unique	SGRCOOP_PIDM
PK_SGRCOOP	Unique	SGRCOOP_TERM_CODE
PK_SGRCOOP	Unique	SGRCOOP_LEVL_CODE
PK_SGRCOOP	Unique	SGRCOOP_SEQ_NO

Comments

Source Code Comments

Cooperative Education Repeating Table

Columns Comments for SGRCOOP_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRCOOP_TERM_CODE (2)

Source Code Comments

This field identifies the effective term to create or display information.

Columns Comments for SGRCOOP_LEVL_CODE (3)

Source Code Comments

This field identifies the level of the student for which the record is being created or displayed.

Columns Comments for SGRCOOP_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRCOOP_COPC_CODE (5)

Source Code Comments

This field identifies the type of cooperative education experience.

Columns Comments for SGRCOOP_END_DATE (6)

Source Code Comments

This field identifies the effective end date of the cooperative education experience.

Columns Comments for SGRCOOP_BEGIN_DATE (7)

Source Code Comments

This field identifies the effective start date of the cooperative education experience.

Columns Comments for SGRCOOP_INTEREST_IND (8)

Source Code Comments

This field indicates if the cooperative education experience is a field of interest to the student. Value is Y or blank only.

Columns Comments for SGRCOOP_EMPL_CONTACT_NAME (9)

Source Code Comments

This field identifies the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_EMPL_CONTACT_TITLE (10)

Source Code Comments

This field identifies the title of the contact person of the cooperative education employer.

Columns Comments for SGRCOOP_ACTIVITY_DATE (11)

Source Code Comments

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

Columns Comments for SGRCOOP_PHONE_AREA (12)

Source Code Comments

This field maintains the telephone area code of the employer contact.

Columns Comments for SGRCOOP_PHONE_NUMBER (13)

Source Code Comments

This field maintains the telephone exchange and number of the employer contact.

Columns Comments for SGRCOOP_PHONE_EXT (14)

Source Code Comments

This field maintains the telephone extension of the employer contact.

Columns Comments for SGRCOOP_SEQ_NO (15)

Source Code Comments

The Coop Assignment Sequence Number.

Columns Comments for SGRCOOP_CRN (16)

Source Code Comments

The Coop Assignment CRN.

Columns Comments for SGRCOOP_EVAL_PREPARED_DATE (17)

Source Code Comments

The Coop Assignment Evaluation Prepared Date.

Columns Comments for SGRCOOP_EVAL_RECEIVED_DATE (18)

Source Code Comments

The Coop Assignment Evaluation Received Date.

Columns Comments for SGRCOOP_OVERRIDE_IND (19)

Source Code Comments

The Coop Assignment Override Indicator.

Table SGRDUTY

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SGRDUTY_PIDM	SGRDUTY_PIDM	NUMBER(8,0)	No	*	*
SGRDUTY_LEVL_CODE	SGRDUTY_LEVL_CODE	VARCHAR2(2)	No	*	*
SGRDUTY_LEVL_CODE	SGRDUTY_LEVL_CODE	VARCHAR2(2)	No	*	*
SGRDUTY_TERM_CODE	SGRDUTY_TERM_CODE	VARCHAR2(6)	No	*	*
SGRDUTY_TERM_CODE	SGRDUTY_TERM_CODE	VARCHAR2(6)	No	*	*
SGRDUTY_EMPL_CODE	SGRDUTY_EMPL_CODE	VARCHAR2(4)	No	*	*
SGRDUTY_SEQ_NO	SGRDUTY_SEQ_NO	NUMBER(4,0)	No	*
SGRDUTY_DESC	SGRDUTY_DESC	VARCHAR2(60)	Yes
SGRDUTY_ACTIVITY_DATE	SGRDUTY_ACTIVITY_DATE	DATE	No
SGRDUTY_COOP_SEQ_NO	SGRDUTY_COOP_SEQ_NO	NUMBER(4,0)	No	*	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SGRDUTY_PIDM	SGRCOOP_PIDM	SGRCOOP
SGRDUTY_TERM_CODE	SGRCOOP_TERM_CODE	SGRCOOP
SGRDUTY_LEVL_CODE	SGRCOOP_LEVL_CODE	SGRCOOP
SGRDUTY_COOP_SEQ_NO	SGRCOOP_SEQ_NO	SGRCOOP
SGRDUTY_EMPL_CODE	STVEMPL_CODE	STVEMPL
SGRDUTY_LEVL_CODE	STVLEVL_CODE	STVLEVL
SGRDUTY_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SGRDUTY	Unique	SGRDUTY_PIDM
PK_SGRDUTY	Unique	SGRDUTY_TERM_CODE
PK_SGRDUTY	Unique	SGRDUTY_LEVL_CODE
PK_SGRDUTY	Unique	SGRDUTY_COOP_SEQ_NO
PK_SGRDUTY	Unique	SGRDUTY_EMPL_CODE
PK_SGRDUTY	Unique	SGRDUTY_SEQ_NO

Comments

Source Code Comments

Cooperative Education Duties Repeating Table

Columns Comments for SGRDUTY_PIDM (1)

Source Code Comments

This field identifies the student internal identification number.

Columns Comments for SGRDUTY_LEVL_CODE (2)

Source Code Comments

This field identifies the level of the student for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_TERM_CODE (3)

Source Code Comments

This field identifies the effective term for which the cooperative education duties are being created.

Columns Comments for SGRDUTY_EMPL_CODE (4)

Source Code Comments

This field identifies the cooperative education employer.

Columns Comments for SGRDUTY_SEQ_NO (5)

Source Code Comments

This field assigns an internal sequence number associated with each cooperative education duties being created.

Columns Comments for SGRDUTY_DESC (6)

Source Code Comments

This field identifies the description of the cooperative education duties being created.

Columns Comments for SGRDUTY_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for SGRDUTY_COOP_SEQ_NO (8)

Source Code Comments

The Coop Assignment Sequence N
umber. This SGRDUTY_COOP_SEQ_NO corresponds to the SGRCOOP_SEQ_NO.

Table STVCOPC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVCOPC_CODE	STVCOPC_CODE	VARCHAR2(6)	No	*
STVCOPC_DESC	STVCOPC_DESC	VARCHAR2(30)	Yes
STVCOPC_ACTIVITY_DATE	STVCOPC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVCOPC	Unique	STVCOPC_CODE

Comments

Source Code Comments

Cooperative Education Code Validation Table.

Columns Comments for STVCOPC_CODE (1)

Source Code Comments

Cooperative education code.

Columns Comments for STVCOPC_DESC (2)

Source Code Comments

Cooperative education code description.

Columns Comments for STVCOPC_ACTIVITY_DATE (3)

Source Code Comments

The Activity date.

Table STVEMPL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVEMPL_CODE	STVEMPL_CODE	VARCHAR2(4)	No	*
STVEMPL_DESC	STVEMPL_DESC	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE1	STVEMPL_STREET_LINE1	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE2	STVEMPL_STREET_LINE2	VARCHAR2(30)	Yes
STVEMPL_STREET_LINE3	STVEMPL_STREET_LINE3	VARCHAR2(30)	Yes
STVEMPL_CITY	STVEMPL_CITY	VARCHAR2(20)	Yes
STVEMPL_STAT_CODE	STVEMPL_STAT_CODE	VARCHAR2(3)	Yes		*
STVEMPL_ZIP	STVEMPL_ZIP	VARCHAR2(10)	Yes
STVEMPL_NATN_CODE	STVEMPL_NATN_CODE	VARCHAR2(5)	Yes		*
STVEMPL_PHONE_AREA	STVEMPL_PHONE_AREA	VARCHAR2(3)	Yes
STVEMPL_PHONE_NUMBER	STVEMPL_PHONE_NUMBER	VARCHAR2(7)	Yes
STVEMPL_PHONE_EXT	STVEMPL_PHONE_EXT	VARCHAR2(4)	Yes
STVEMPL_ACTIVITY_DATE	STVEMPL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVEMPL_STAT_CODE	STVSTAT_CODE	STVSTAT
STVEMPL_NATN_CODE	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
PK_STVEMPL	Unique	STVEMPL_CODE

Comments

Source Code Comments

Employer Validation Table

Columns Comments for STVEMPL_CODE (1)

Source Code Comments

This field identifies the employer code referenced on the Cooperative Education Form (SGACOOP).

Columns Comments for STVEMPL_DESC (2)

Source Code Comments

This field specifies the name of employer associated with the employer code.

Columns Comments for STVEMPL_STREET_LINE1 (3)

Source Code Comments

This field maintains line one of the employer street address.

Columns Comments for STVEMPL_STREET_LINE2 (4)

Source Code Comments

This field maintains line two of the employer street address.

Columns Comments for STVEMPL_STREET_LINE3 (5)

Source Code Comments

This field maintains line three of the employer street address.

Columns Comments for STVEMPL_CITY (6)

Source Code Comments

This field identifies the city/town in which the employer is located.

Columns Comments for STVEMPL_STAT_CODE (7)

Source Code Comments

This field identifies the abbreviation for the state in which the employer is located.

Columns Comments for STVEMPL_ZIP (8)

Source Code Comments

This field identifies the zip code/postal code of the employer.

Columns Comments for STVEMPL_NATN_CODE (9)

Source Code Comments

This field identifies the nation/country in which the employer is located.

Columns Comments for STVEMPL_PHONE_AREA (10)

Source Code Comments

This field maintains the telephone area code of the employer.

Columns Comments for STVEMPL_PHONE_NUMBER (11)

Source Code Comments

This field maintains the telephone exchange and number of the employer.

Columns Comments for STVEMPL_PHONE_EXT (12)

Source Code Comments

This field maintains the telephone extension of the employer.

Columns Comments for STVEMPL_ACTIVITY_DATE (13)

Source Code Comments

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

Table STVLEVL

Schema Name SATURN
Label STVLEVL
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:00:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVLEVL_CODE	STVLEVL_CODE	VARCHAR2(2)	No	*	*
STVLEVL_DESC	STVLEVL_DESC	VARCHAR2(30)	No
STVLEVL_ACTIVITY_DATE	STVLEVL_ACTIVITY_DATE	DATE	No
STVLEVL_ACAD_IND	STVLEVL_ACAD_IND	VARCHAR2(1)	Yes
STVLEVL_CEU_IND	STVLEVL_CEU_IND	VARCHAR2(1)	No
STVLEVL_SYSTEM_REQ_IND