Model Support_Services_ERD

Model Label : ba student support services ERD

List of Objects

Object Name	Object Type	Layer Name
SABAUDF	TABLE	Tables
SERDTGL	TABLE	Tables
SERDTND	TABLE	Tables
SERDTSR	TABLE	Tables
SERGLAT	TABLE	Tables
SERGLCM	TABLE	Tables
SERGOAL	TABLE	Tables
SERNDAT	TABLE	Tables
SERNDCM	TABLE	Tables
SERNEED	TABLE	Tables
SERSRAT	TABLE	Tables
SERSRCM	TABLE	Tables
SERSSER	TABLE	Tables
SERSSGP	TABLE	Tables
SETATND	TABLE	Tables
SPRIDEN	TABLE	ERD
STVGATT	TABLE	ERD
STVGOAL	TABLE	ERD
STVNATT	TABLE	ERD
STVNDRF	TABLE	ERD
STVNEED	TABLE	ERD
STVORIG	TABLE	ERD
STVSATT	TABLE	ERD
STVSEPR	TABLE	ERD
STVSPRV	TABLE	ERD
STVSSEP	TABLE	ERD
STVSSER	TABLE	ERD
STVSSGP	TABLE	ERD
STVSSRS	TABLE	ERD
STVSSST	TABLE	ERD
STVTERM	TABLE	ERD
STVTREQ	TABLE	ERD

Model View

Table SABAUDF

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SABAUDF

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABAUDF_TERM_CODE_EFF	SABAUDF_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SABAUDF_FLAG1_DESC	SABAUDF_FLAG1_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG2_DESC	SABAUDF_FLAG2_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG3_DESC	SABAUDF_FLAG3_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG4_DESC	SABAUDF_FLAG4_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG5_DESC	SABAUDF_FLAG5_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG6_DESC	SABAUDF_FLAG6_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG7_DESC	SABAUDF_FLAG7_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG8_DESC	SABAUDF_FLAG8_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG9_DESC	SABAUDF_FLAG9_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG10_DESC	SABAUDF_FLAG10_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA1_DESC	SABAUDF_DATA1_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA2_DESC	SABAUDF_DATA2_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA3_DESC	SABAUDF_DATA3_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA4_DESC	SABAUDF_DATA4_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA5_DESC	SABAUDF_DATA5_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA6_DESC	SABAUDF_DATA6_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA7_DESC	SABAUDF_DATA7_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA8_DESC	SABAUDF_DATA8_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA9_DESC	SABAUDF_DATA9_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA10_DESC	SABAUDF_DATA10_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA11_DESC	SABAUDF_DATA11_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA12_DESC	SABAUDF_DATA12_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA13_DESC	SABAUDF_DATA13_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA14_DESC	SABAUDF_DATA14_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA15_DESC	SABAUDF_DATA15_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA16_DESC	SABAUDF_DATA16_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA17_DESC	SABAUDF_DATA17_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA18_DESC	SABAUDF_DATA18_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA19_DESC	SABAUDF_DATA19_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA20_DESC	SABAUDF_DATA20_DESC	VARCHAR2(20)	Yes
SABAUDF_ACTIVITY_DATE	SABAUDF_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABAUDF_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SABAUDF	Unique	SABAUDF_TERM_CODE_EFF

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (# 1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (# 32)

Source Code Comments

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

Table SERDTGL

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERDTGL

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERDTGL_PIDM	SERDTGL_PIDM	NUMBER(8,0)	No	*
SERDTGL_TERM_CODE_EFF	SERDTGL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERDTGL_SSGP_CODE	SERDTGL_SSGP_CODE	VARCHAR2(4)	Yes	*
SERDTGL_GOAL_CODE	SERDTGL_GOAL_CODE	VARCHAR2(4)	Yes	*
SERDTGL_PRIORITY_NBR	SERDTGL_PRIORITY_NBR	NUMBER(3,0)	Yes
SERDTGL_TREQ_CODE	SERDTGL_TREQ_CODE	VARCHAR2(2)	Yes	*
SERDTGL_ESTIMATE_DATE	SERDTGL_ESTIMATE_DATE	DATE	Yes
SERDTGL_ACTUAL_DATE	SERDTGL_ACTUAL_DATE	DATE	Yes
SERDTGL_SSRS_CODE	SERDTGL_SSRS_CODE	VARCHAR2(2)	Yes	*
SERDTGL_ORIG_CODE	SERDTGL_ORIG_CODE	VARCHAR2(4)	Yes	*
SERDTGL_ACTIVITY_DATE	SERDTGL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERDTGL_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERDTGL_GOAL_CODE	STVGOAL_CODE	STVGOAL
SERDTGL_ORIG_CODE	STVORIG_CODE	STVORIG
SERDTGL_SSGP_CODE	STVSSGP_CODE	STVSSGP
SERDTGL_SSRS_CODE	STVSSRS_CODE	STVSSRS
SERDTGL_TREQ_CODE	STVTREQ_CODE	STVTREQ
SERDTGL_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
SERDTGL_KEY_INDEX	Unique	SERDTGL_PIDM
SERDTGL_KEY_INDEX	Unique	SERDTGL_TERM_CODE_EFF
SERDTGL_KEY_INDEX	Unique	SERDTGL_SSGP_CODE
SERDTGL_KEY_INDEX	Unique	SERDTGL_GOAL_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Student service group assignments

Columns Comments for SERDTGL_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERDTGL_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERDTGL_SSGP_CODE (# 3)

Source Code Comments

Service group code

Columns Comments for SERDTGL_GOAL_CODE (# 4)

Source Code Comments

Goal code

Columns Comments for SERDTGL_PRIORITY_NBR (# 5)

Source Code Comments

Priority number

Columns Comments for SERDTGL_TREQ_CODE (# 6)

Source Code Comments

Time required code

Columns Comments for SERDTGL_ESTIMATE_DATE (# 7)

Source Code Comments

Goal estimated completion date

Columns Comments for SERDTGL_ACTUAL_DATE (# 8)

Source Code Comments

Goal actual completion date

Columns Comments for SERDTGL_SSRS_CODE (# 9)

Source Code Comments

Result code

Columns Comments for SERDTGL_ORIG_CODE (# 10)

Source Code Comments

Originator code

Columns Comments for SERDTGL_ACTIVITY_DATE (# 11)

Source Code Comments

The Activity Date

Table SERDTND

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERDTND

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERDTND_PIDM	SERDTND_PIDM	NUMBER(8,0)	No	*
SERDTND_TERM_CODE_EFF	SERDTND_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERDTND_SSGP_CODE	SERDTND_SSGP_CODE	VARCHAR2(4)	Yes	*
SERDTND_NEED_CODE	SERDTND_NEED_CODE	VARCHAR2(4)	Yes	*
SERDTND_NDRF_CODE	SERDTND_NDRF_CODE	VARCHAR2(4)	Yes	*
SERDTND_SELF_IND	SERDTND_SELF_IND	VARCHAR2(1)	Yes
SERDTND_ACTIVITY_DATE	SERDTND_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERDTND_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERDTND_NDRF_CODE	STVNDRF_CODE	STVNDRF
SERDTND_NEED_CODE	STVNEED_CODE	STVNEED
SERDTND_SSGP_CODE	STVSSGP_CODE	STVSSGP
SERDTND_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
SERDTND_KEY_INDEX	Unique	SERDTND_PIDM
SERDTND_KEY_INDEX	Unique	SERDTND_TERM_CODE_EFF
SERDTND_KEY_INDEX	Unique	SERDTND_SSGP_CODE
SERDTND_KEY_INDEX	Unique	SERDTND_NEED_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Student service need assignments

Columns Comments for SERDTND_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERDTND_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERDTND_SSGP_CODE (# 3)

Source Code Comments

Service group code

Columns Comments for SERDTND_NEED_CODE (# 4)

Source Code Comments

Need code

Columns Comments for SERDTND_NDRF_CODE (# 5)

Source Code Comments

Need Referral code

Columns Comments for SERDTND_SELF_IND (# 6)

Source Code Comments

Self reported indicator

Columns Comments for SERDTND_ACTIVITY_DATE (# 7)

Source Code Comments

The Activity Date

Table SERDTSR

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERDTSR

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERDTSR_PIDM	SERDTSR_PIDM	NUMBER(8,0)	No	*
SERDTSR_TERM_CODE_EFF	SERDTSR_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERDTSR_SSGP_CODE	SERDTSR_SSGP_CODE	VARCHAR2(4)	Yes	*
SERDTSR_SSER_CODE	SERDTSR_SSER_CODE	VARCHAR2(4)	Yes	*
SERDTSR_SSST_CODE	SERDTSR_SSST_CODE	VARCHAR2(2)	Yes	*
SERDTSR_SEPR_CODE	SERDTSR_SEPR_CODE	VARCHAR2(2)	Yes	*
SERDTSR_SPRV_CODE	SERDTSR_SPRV_CODE	VARCHAR2(6)	Yes	*
SERDTSR_SSEP_CODE	SERDTSR_SSEP_CODE	VARCHAR2(4)	Yes	*
SERDTSR_BEGIN_DATE	SERDTSR_BEGIN_DATE	DATE	Yes
SERDTSR_END_DATE	SERDTSR_END_DATE	DATE	Yes
SERDTSR_SSRS_CODE	SERDTSR_SSRS_CODE	VARCHAR2(2)	Yes	*
SERDTSR_ORIG_CODE	SERDTSR_ORIG_CODE	VARCHAR2(4)	Yes	*
SERDTSR_ACTIVITY_DATE	SERDTSR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERDTSR_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERDTSR_SPRV_CODE	STVSPRV_CODE	STVSPRV
SERDTSR_ORIG_CODE	STVORIG_CODE	STVORIG
SERDTSR_SEPR_CODE	STVSEPR_CODE	STVSEPR
SERDTSR_SSEP_CODE	STVSSEP_CODE	STVSSEP
SERDTSR_SSER_CODE	STVSSER_CODE	STVSSER
SERDTSR_SSGP_CODE	STVSSGP_CODE	STVSSGP
SERDTSR_SSRS_CODE	STVSSRS_CODE	STVSSRS
SERDTSR_SSST_CODE	STVSSST_CODE	STVSSST
SERDTSR_PIDM	SPRIDEN_PIDM	SPRIDEN

Index

Index Name	Index Type	Column Name
SERDTSR_KEY_INDEX	Unique	SERDTSR_PIDM
SERDTSR_KEY_INDEX	Unique	SERDTSR_TERM_CODE_EFF
SERDTSR_KEY_INDEX	Unique	SERDTSR_SSGP_CODE
SERDTSR_KEY_INDEX	Unique	SERDTSR_SSER_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Student service group assignments

Columns Comments for SERDTSR_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERDTSR_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERDTSR_SSGP_CODE (# 3)

Source Code Comments

Service group code

Columns Comments for SERDTSR_SSER_CODE (# 4)

Source Code Comments

Service code

Columns Comments for SERDTSR_SSST_CODE (# 5)

Source Code Comments

Status code

Columns Comments for SERDTSR_SEPR_CODE (# 6)

Source Code Comments

Provided by code

Columns Comments for SERDTSR_SPRV_CODE (# 7)

Source Code Comments

Provider code

Columns Comments for SERDTSR_SSEP_CODE (# 8)

Source Code Comments

Exemption code

Columns Comments for SERDTSR_BEGIN_DATE (# 9)

Source Code Comments

Service begin date

Columns Comments for SERDTSR_END_DATE (# 10)

Source Code Comments

Service end date

Columns Comments for SERDTSR_SSRS_CODE (# 11)

Source Code Comments

Result code

Columns Comments for SERDTSR_ORIG_CODE (# 12)

Source Code Comments

Originator code

Columns Comments for SERDTSR_ACTIVITY_DATE (# 13)

Source Code Comments

The Activity Date

Table SERGLAT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERGLAT

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERGLAT_PIDM	SERGLAT_PIDM	NUMBER(8,0)	No
SERGLAT_TERM_CODE_EFF	SERGLAT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERGLAT_GOAL_CODE	SERGLAT_GOAL_CODE	VARCHAR2(4)	No	*
SERGLAT_GATT_CODE	SERGLAT_GATT_CODE	VARCHAR2(4)	Yes	*
SERGLAT_ACTIVITY_DATE	SERGLAT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERGLAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERGLAT_GATT_CODE	STVGATT_CODE	STVGATT
SERGLAT_GOAL_CODE	STVGOAL_CODE	STVGOAL

Index

Index Name	Index Type	Column Name
SERGLAT_KEY_INDEX	Unique	SERGLAT_PIDM
SERGLAT_KEY_INDEX	Unique	SERGLAT_TERM_CODE_EFF
SERGLAT_KEY_INDEX	Unique	SERGLAT_GOAL_CODE
SERGLAT_KEY_INDEX	Unique	SERGLAT_GATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Student service goal attribute assignments

Columns Comments for SERGLAT_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERGLAT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERGLAT_GOAL_CODE (# 3)

Source Code Comments

Goal code

Columns Comments for SERGLAT_GATT_CODE (# 4)

Source Code Comments

Goal attribute code

Columns Comments for SERGLAT_ACTIVITY_DATE (# 5)

Source Code Comments

The Activity Date

Table SERGLCM

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERGLCM

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERGLCM_PIDM	SERGLCM_PIDM	NUMBER(8,0)	No
SERGLCM_TERM_CODE_EFF	SERGLCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERGLCM_GOAL_CODE	SERGLCM_GOAL_CODE	VARCHAR2(4)	No	*
SERGLCM_SEQNO	SERGLCM_SEQNO	NUMBER(23,20)	Yes
SERGLCM_TEXT	SERGLCM_TEXT	VARCHAR2(4000)	Yes
SERGLCM_ACTIVITY_DATE	SERGLCM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERGLCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERGLCM_GOAL_CODE	STVGOAL_CODE	STVGOAL

Index

Index Name	Index Type	Column Name
SERGLCM_KEY_INDEX		SERGLCM_PIDM
SERGLCM_KEY_INDEX		SERGLCM_TERM_CODE_EFF
SERGLCM_KEY_INDEX		SERGLCM_GOAL_CODE
SERGLCM_KEY_INDEX		SERGLCM_SEQNO

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:38:000

Source Code Comments

Student service goal comment assignments

Columns Comments for SERGLCM_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERGLCM_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERGLCM_GOAL_CODE (# 3)

Source Code Comments

Goal code

Columns Comments for SERGLCM_SEQNO (# 4)

Source Code Comments

Goal sequence number

Columns Comments for SERGLCM_TEXT (# 5)

Source Code Comments

Goal text

Columns Comments for SERGLCM_ACTIVITY_DATE (# 6)

Source Code Comments

The Activity Date

Table SERGOAL

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERGOAL

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERGOAL_SSGP_CODE	SERGOAL_SSGP_CODE	VARCHAR2(4)	No	*
SERGOAL_TERM_CODE_EFF	SERGOAL_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERGOAL_GOAL_CODE	SERGOAL_GOAL_CODE	VARCHAR2(4)	Yes	*
SERGOAL_ACTIVITY_DATE	SERGOAL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERGOAL_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERGOAL_GOAL_CODE	STVGOAL_CODE	STVGOAL
SERGOAL_SSGP_CODE	STVSSGP_CODE	STVSSGP

Index

Index Name	Index Type	Column Name
SERGOAL_KEY_INDEX	Unique	SERGOAL_SSGP_CODE
SERGOAL_KEY_INDEX	Unique	SERGOAL_TERM_CODE_EFF
SERGOAL_KEY_INDEX	Unique	SERGOAL_GOAL_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Service group code goal code rules table

Columns Comments for SERGOAL_SSGP_CODE (# 1)

Source Code Comments

Service group code

Columns Comments for SERGOAL_TERM_CODE_EFF (# 2)

Source Code Comments

Goal code effective term

Columns Comments for SERGOAL_GOAL_CODE (# 3)

Source Code Comments

Goal code

Columns Comments for SERGOAL_ACTIVITY_DATE (# 4)

Source Code Comments

The Activity Date

Table SERNDAT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERNDAT

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERNDAT_PIDM	SERNDAT_PIDM	NUMBER(8,0)	No
SERNDAT_TERM_CODE_EFF	SERNDAT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERNDAT_NEED_CODE	SERNDAT_NEED_CODE	VARCHAR2(4)	No	*
SERNDAT_NATT_CODE	SERNDAT_NATT_CODE	VARCHAR2(4)	Yes	*
SERNDAT_ACTIVITY_DATE	SERNDAT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERNDAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERNDAT_NATT_CODE	STVNATT_CODE	STVNATT
SERNDAT_NEED_CODE	STVNEED_CODE	STVNEED

Index

Index Name	Index Type	Column Name
SERNDAT_KEY_INDEX	Unique	SERNDAT_PIDM
SERNDAT_KEY_INDEX	Unique	SERNDAT_TERM_CODE_EFF
SERNDAT_KEY_INDEX	Unique	SERNDAT_NEED_CODE
SERNDAT_KEY_INDEX	Unique	SERNDAT_NATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Student service need attribute assignments

Columns Comments for SERNDAT_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERNDAT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERNDAT_NEED_CODE (# 3)

Source Code Comments

Need code

Columns Comments for SERNDAT_NATT_CODE (# 4)

Source Code Comments

Need attribute code

Columns Comments for SERNDAT_ACTIVITY_DATE (# 5)

Source Code Comments

The Activity Date

Table SERNDCM

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERNDCM

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERNDCM_PIDM	SERNDCM_PIDM	NUMBER(8,0)	No
SERNDCM_TERM_CODE_EFF	SERNDCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERNDCM_NEED_CODE	SERNDCM_NEED_CODE	VARCHAR2(4)	No	*
SERNDCM_SEQNO	SERNDCM_SEQNO	NUMBER(23,20)	Yes
SERNDCM_TEXT	SERNDCM_TEXT	VARCHAR2(4000)	Yes
SERNDCM_ACTIVITY_DATE	SERNDCM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERNDCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERNDCM_NEED_CODE	STVNEED_CODE	STVNEED

Index

Index Name	Index Type	Column Name
SERNDCM_KEY_INDEX		SERNDCM_PIDM
SERNDCM_KEY_INDEX		SERNDCM_TERM_CODE_EFF
SERNDCM_KEY_INDEX		SERNDCM_NEED_CODE
SERNDCM_KEY_INDEX		SERNDCM_SEQNO

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student service need comment assignments

Columns Comments for SERNDCM_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERNDCM_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERNDCM_NEED_CODE (# 3)

Source Code Comments

Need code

Columns Comments for SERNDCM_SEQNO (# 4)

Source Code Comments

Need sequence number

Columns Comments for SERNDCM_TEXT (# 5)

Source Code Comments

Need text

Columns Comments for SERNDCM_ACTIVITY_DATE (# 6)

Source Code Comments

The Activity Date

Table SERNEED

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERNEED

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERNEED_SSGP_CODE	SERNEED_SSGP_CODE	VARCHAR2(4)	No	*
SERNEED_TERM_CODE_EFF	SERNEED_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERNEED_NEED_CODE	SERNEED_NEED_CODE	VARCHAR2(4)	Yes	*
SERNEED_ACTIVITY_DATE	SERNEED_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERNEED_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERNEED_NEED_CODE	STVNEED_CODE	STVNEED
SERNEED_SSGP_CODE	STVSSGP_CODE	STVSSGP

Index

Index Name	Index Type	Column Name
SERNEED_KEY_INDEX	Unique	SERNEED_SSGP_CODE
SERNEED_KEY_INDEX	Unique	SERNEED_TERM_CODE_EFF
SERNEED_KEY_INDEX	Unique	SERNEED_NEED_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Service group code Need code rules table

Columns Comments for SERNEED_SSGP_CODE (# 1)

Source Code Comments

Service group code

Columns Comments for SERNEED_TERM_CODE_EFF (# 2)

Source Code Comments

Need code effective term

Columns Comments for SERNEED_NEED_CODE (# 3)

Source Code Comments

Need code

Columns Comments for SERNEED_ACTIVITY_DATE (# 4)

Source Code Comments

The Activity Date

Table SERSRAT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERSRAT

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERSRAT_PIDM	SERSRAT_PIDM	NUMBER(8,0)	No
SERSRAT_TERM_CODE_EFF	SERSRAT_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERSRAT_SSER_CODE	SERSRAT_SSER_CODE	VARCHAR2(4)	No	*
SERSRAT_SATT_CODE	SERSRAT_SATT_CODE	VARCHAR2(4)	Yes	*
SERSRAT_ACTIVITY_DATE	SERSRAT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERSRAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERSRAT_SATT_CODE	STVSATT_CODE	STVSATT
SERSRAT_SSER_CODE	STVSSER_CODE	STVSSER

Index

Index Name	Index Type	Column Name
SERSRAT_KEY_INDEX	Unique	SERSRAT_PIDM
SERSRAT_KEY_INDEX	Unique	SERSRAT_TERM_CODE_EFF
SERSRAT_KEY_INDEX	Unique	SERSRAT_SSER_CODE
SERSRAT_KEY_INDEX	Unique	SERSRAT_SATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Student service service attribute assignments

Columns Comments for SERSRAT_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERSRAT_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERSRAT_SSER_CODE (# 3)

Source Code Comments

Service code

Columns Comments for SERSRAT_SATT_CODE (# 4)

Source Code Comments

Service attribute code

Columns Comments for SERSRAT_ACTIVITY_DATE (# 5)

Source Code Comments

The Activity Date

Table SERSRCM

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERSRCM

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERSRCM_PIDM	SERSRCM_PIDM	NUMBER(8,0)	No
SERSRCM_TERM_CODE_EFF	SERSRCM_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERSRCM_SSER_CODE	SERSRCM_SSER_CODE	VARCHAR2(4)	No	*
SERSRCM_SEQNO	SERSRCM_SEQNO	NUMBER(23,20)	Yes
SERSRCM_TEXT	SERSRCM_TEXT	VARCHAR2(4000)	Yes
SERSRCM_ACTIVITY_DATE	SERSRCM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERSRCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERSRCM_SSER_CODE	STVSSER_CODE	STVSSER

Index

Index Name	Index Type	Column Name
SERSRCM_KEY_INDEX		SERSRCM_PIDM
SERSRCM_KEY_INDEX		SERSRCM_TERM_CODE_EFF
SERSRCM_KEY_INDEX		SERSRCM_SSER_CODE
SERSRCM_KEY_INDEX		SERSRCM_SEQNO

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student service need comment assignments

Columns Comments for SERSRCM_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERSRCM_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERSRCM_SSER_CODE (# 3)

Source Code Comments

Service code

Columns Comments for SERSRCM_SEQNO (# 4)

Source Code Comments

Service sequence number

Columns Comments for SERSRCM_TEXT (# 5)

Source Code Comments

Service text

Columns Comments for SERSRCM_ACTIVITY_DATE (# 6)

Source Code Comments

The Activity Date

Table SERSSER

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERSSER

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERSSER_SSGP_CODE	SERSSER_SSGP_CODE	VARCHAR2(4)	No	*
SERSSER_TERM_CODE_EFF	SERSSER_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERSSER_SSER_CODE	SERSSER_SSER_CODE	VARCHAR2(4)	Yes	*
SERSSER_ACTIVITY_DATE	SERSSER_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERSSER_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERSSER_SSER_CODE	STVSSER_CODE	STVSSER
SERSSER_SSGP_CODE	STVSSGP_CODE	STVSSGP

Index

Index Name	Index Type	Column Name
SERSSER_KEY_INDEX	Unique	SERSSER_SSGP_CODE
SERSSER_KEY_INDEX	Unique	SERSSER_TERM_CODE_EFF
SERSSER_KEY_INDEX	Unique	SERSSER_SSER_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Service group code service code rules table

Columns Comments for SERSSER_SSGP_CODE (# 1)

Source Code Comments

Service group code

Columns Comments for SERSSER_TERM_CODE_EFF (# 2)

Source Code Comments

Service code effective term

Columns Comments for SERSSER_SSER_CODE (# 3)

Source Code Comments

Service code

Columns Comments for SERSSER_ACTIVITY_DATE (# 4)

Source Code Comments

The Activity Date

Table SERSSGP

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SERSSGP

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SERSSGP_PIDM	SERSSGP_PIDM	NUMBER(8,0)	No
SERSSGP_TERM_CODE_EFF	SERSSGP_TERM_CODE_EFF	VARCHAR2(6)	No	*
SERSSGP_SSGP_CODE	SERSSGP_SSGP_CODE	VARCHAR2(4)	Yes	*
SERSSGP_ACTIVITY_DATE	SERSSGP_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SERSSGP_TERM_CODE_EFF	STVTERM_CODE	STVTERM
SERSSGP_SSGP_CODE	STVSSGP_CODE	STVSSGP

Index

Index Name	Index Type	Column Name
SERSSGP_KEY_INDEX	Unique	SERSSGP_PIDM
SERSSGP_KEY_INDEX	Unique	SERSSGP_TERM_CODE_EFF
SERSSGP_KEY_INDEX	Unique	SERSSGP_SSGP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Student service group assignments

Columns Comments for SERSSGP_PIDM (# 1)

Source Code Comments

Person id number

Columns Comments for SERSSGP_TERM_CODE_EFF (# 2)

Source Code Comments

Effective term

Columns Comments for SERSSGP_SSGP_CODE (# 3)

Source Code Comments

Service group code

Columns Comments for SERSSGP_ACTIVITY_DATE (# 4)

Source Code Comments

The Activity Date

Table SETATND

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SETATND

Table Columns information

Column Name	Label	Column Type	Allow NULL
SETATND_ACYR_CODE	SETATND_ACYR_CODE	VARCHAR2(4)	No
SETATND_CAMP_CODE	SETATND_CAMP_CODE	VARCHAR2(3)	No
SETATND_REPORT_NO	SETATND_REPORT_NO	VARCHAR2(2)	No
SETATND_PERIOD	SETATND_PERIOD	VARCHAR2(1)	No
SETATND_TERM_CODE	SETATND_TERM_CODE	VARCHAR2(6)	No
SETATND_SUBJ_CODE	SETATND_SUBJ_CODE	VARCHAR2(4)	No
SETATND_CRSE_NUMB	SETATND_CRSE_NUMB	VARCHAR2(5)	No
SETATND_CRN	SETATND_CRN	VARCHAR2(5)	No
SETATND_PIDM	SETATND_PIDM	NUMBER(8,0)	No
SETATND_ACTIVITY_DATE	SETATND_ACTIVITY_DATE	DATE	No
SETATND_SEQ_NO	SETATND_SEQ_NO	VARCHAR2(3)	Yes
SETATND_ACCT_CODE	SETATND_ACCT_CODE	VARCHAR2(2)	Yes
SETATND_RSTS_CODE	SETATND_RSTS_CODE	VARCHAR2(2)	Yes
SETATND_RSTS_DATE	SETATND_RSTS_DATE	DATE	Yes
SETATND_RESD_CODE	SETATND_RESD_CODE	VARCHAR2(1)	Yes
SETATND_GAIN_IND	SETATND_GAIN_IND	VARCHAR2(1)	Yes
SETATND_HOURS_ATTEND	SETATND_HOURS_ATTEND	NUMBER(9,3)	Yes

No Foreign Key

Index

No Result

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Temporary table to hold attendance detail data for FTES

Columns Comments for SETATND_ACYR_CODE (# 1)

Source Code Comments

Academic Year

Columns Comments for SETATND_CAMP_CODE (# 2)

Source Code Comments

Code for Campus

Columns Comments for SETATND_REPORT_NO (# 3)

Source Code Comments

02-WSCH, 03-DSCH, 04-Pos. Attn., 05-WEXP(WSCH), 06-WEXP(DSCH)

Columns Comments for SETATND_PERIOD (# 4)

Source Code Comments

1-01 Jul to 31 Dec, 2-01 Jan to 15 Apr, 3-16 Apr to 30 Jun

Columns Comments for SETATND_TERM_CODE (# 5)

Source Code Comments

Code for Term

Columns Comments for SETATND_SUBJ_CODE (# 6)

Source Code Comments

Code for the Subject

Columns Comments for SETATND_CRSE_NUMB (# 7)

Source Code Comments

Course Number

Columns Comments for SETATND_CRN (# 8)

Source Code Comments

Course Reference Number

Columns Comments for SETATND_PIDM (# 9)

Source Code Comments

PIDM - for student

Columns Comments for SETATND_ACTIVITY_DATE (# 10)

Source Code Comments

System date on when row was created/updated

Columns Comments for SETATND_SEQ_NO (# 11)

Source Code Comments

To be filled

Columns Comments for SETATND_ACCT_CODE (# 12)

Source Code Comments

Attendance Method Code

Columns Comments for SETATND_RSTS_CODE (# 13)

Source Code Comments

Registration Status Code

Columns Comments for SETATND_RESD_CODE (# 15)

Source Code Comments

R/D-CA resident, F-Foreign, N/O-Nonresident Res

Columns Comments for SETATND_GAIN_IND (# 16)

Source Code Comments

Y-GAIN Student, N or NULL-NOT a GAIN Student

Columns Comments for SETATND_HOURS_ATTEND (# 17)

Source Code Comments

Hours attended

Table SPRIDEN

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label SPRIDEN

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_ID	SPRIDEN_ID	VARCHAR2(9)	No	*
SPRIDEN_LAST_NAME	SPRIDEN_LAST_NAME	VARCHAR2(60)	No
SPRIDEN_FIRST_NAME	SPRIDEN_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_MI	SPRIDEN_MI	VARCHAR2(15)	Yes
SPRIDEN_CHANGE_IND	SPRIDEN_CHANGE_IND	VARCHAR2(1)	Yes
SPRIDEN_ENTITY_IND	SPRIDEN_ENTITY_IND	VARCHAR2(1)	Yes
SPRIDEN_ACTIVITY_DATE	SPRIDEN_ACTIVITY_DATE	DATE	No
SPRIDEN_USER	SPRIDEN_USER	VARCHAR2(30)	Yes
SPRIDEN_ORIGIN	SPRIDEN_ORIGIN	VARCHAR2(30)	Yes
SPRIDEN_SEARCH_LAST_NAME	SPRIDEN_SEARCH_LAST_NAME	VARCHAR2(60)	Yes
SPRIDEN_SEARCH_FIRST_NAME	SPRIDEN_SEARCH_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_SEARCH_MI	SPRIDEN_SEARCH_MI	VARCHAR2(15)	Yes
SPRIDEN_SOUNDEX_LAST_NAME	SPRIDEN_SOUNDEX_LAST_NAME	CHAR(4)	Yes
SPRIDEN_SOUNDEX_FIRST_NAME	SPRIDEN_SOUNDEX_FIRST_NAME	CHAR(4)	Yes
SPRIDEN_NTYP_CODE	SPRIDEN_NTYP_CODE	VARCHAR2(4)	Yes
SPRIDEN_CREATE_USER	SPRIDEN_CREATE_USER	VARCHAR2(30)	Yes
SPRIDEN_CREATE_DATE	SPRIDEN_CREATE_DATE	DATE	Yes
SPRIDEN_DATA_ORIGIN	SPRIDEN_DATA_ORIGIN	VARCHAR2(30)	Yes
SPRIDEN_CREATE_FDMN_CODE	SPRIDEN_CREATE_FDMN_CODE	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRIDEN_PIDM	RPRATRM_PIDM	RPRATRM
SPRIDEN_PIDM	AGRPIDS_XREF_PIDM	AGRPIDS
SPRIDEN_PIDM	AGRPIDS_PIDM	AGRPIDS
SPRIDEN_PIDM	ASRSSAG_PIDM	ASRSSAG
SPRIDEN_PIDM	AOBORGN_PIDM	AOBORGN
SPRIDEN_PIDM	ASRSORG_PIDM	ASRSORG
SPRIDEN_PIDM	AGRGIDS_XREF_PIDM	AGRGIDS
SPRIDEN_PIDM	AGRGIDS_PIDM	AGRGIDS
SPRIDEN_PIDM	AGBPLDG_PIDM	AGBPLDG
SPRIDEN_PIDM	AGRPMEM_PIDM	AGRPMEM
SPRIDEN_PIDM	AGRPMEM_MEMO_PIDM	AGRPMEM
SPRIDEN_PIDM	AGRGMEM_PIDM	AGRGMEM
SPRIDEN_PIDM	AGRGMEM_MEMO_PIDM	AGRGMEM
SPRIDEN_PIDM	AGRGPAY_PIDM	AGRGPAY
SPRIDEN_PIDM	APRXREF_XREF_PIDM	APRXREF
SPRIDEN_PIDM	GLBEXTR_KEY	GLBEXTR
SPRIDEN_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
SPRIDEN_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
SPRIDEN_PIDM	FRRPRPI_ID_PIDM	FRRPRPI
SPRIDEN_PIDM	FIRBOND_IMGR_CODE_PIDM	FIRBOND
SPRIDEN_PIDM	FPBAGRH_VEND_PIDM	FPBAGRH
SPRIDEN_PIDM	FTVAGCY_AGCY_CODE_PIDM	FTVAGCY
SPRIDEN_PIDM	APRCATG_PIDM	APRCATG
SPRIDEN_PIDM	AARMEMB_RENEWAL_PIDM	AARMEMB
SPRIDEN_PIDM	AARMEMB_REMINDER_PIDM	AARMEMB
SPRIDEN_PIDM	APRDRVW_PIDM	APRDRVW
SPRIDEN_PIDM	FRBGRNT_AGENCY_PIDM	FRBGRNT
SPRIDEN_PIDM	FRRGRPI_ID_PIDM	FRRGRPI
SPRIDEN_PIDM	FPRBIDV_VEND_PIDM	FPRBIDV
SPRIDEN_PIDM	FPBREQH_VEND_PIDM	FPBREQH
SPRIDEN_PIDM	FIRCERD_IMGR_CODE_PIDM	FIRCERD
SPRIDEN_PIDM	FIRMMKT_IMGR_CODE_PIDM	FIRMMKT
SPRIDEN_PIDM	FIRPRTY_IMGR_CODE_PIDM	FIRPRTY
SPRIDEN_PIDM	FTVFMGR_FMGR_CODE_PIDM	FTVFMGR
SPRIDEN_PIDM	FIRSTCK_IMGR_CODE_PIDM	FIRSTCK
SPRIDEN_PIDM	FIRSTOP_IMGR_CODE_PIDM	FIRSTOP
SPRIDEN_PIDM	GERFGST_PIDM	GERFGST
SPRIDEN_PIDM	GERATTD_PIDM	GERATTD
SPRIDEN_PIDM	GEBFUNC_SPNSR_ORGN_PIDM	GEBFUNC
SPRIDEN_PIDM	GORSEVS_PIDM	GORSEVS
SPRIDEN_PIDM	GORSEVD_DEP_PIDM	GORSEVD
SPRIDEN_PIDM	GOBSEVS_PIDM	GOBSEVS
SPRIDEN_PIDM	GORSVAS_ACT_SITE_PIDM	GORSVAS
SPRIDEN_PIDM	GORSVEI_EMPLOYER_PIDM	GORSVEI
SPRIDEN_PIDM	PERTETH_TRANS_PIDM	PERTETH
SPRIDEN_PIDM	PERHSIP_PIDM	PERHSIP
SPRIDEN_PIDM	GOBSRVR_PIDM	GOBSRVR
SPRIDEN_PIDM	NBRJOBS_PIDM	NBRJOBS
SPRIDEN_PIDM	GOBEACC_PIDM	GOBEACC
SPRIDEN_PIDM	NOBTRAN_PIDM	NOBTRAN
SPRIDEN_PIDM	PCBPERS_COBRA_BFCTR_PIDM	PCBPERS
SPRIDEN_PIDM	PDRBENE_BENE_PIDM	PDRBENE
SPRIDEN_PIDM	NBRBJOB_PIDM	NBRBJOB
SPRIDEN_PIDM	PERBARG_PIDM	PERBARG
SPRIDEN_PIDM	PERJOBS_PIDM	PERJOBS
SPRIDEN_PIDM	TBBCONT_PIDM	TBBCONT
SPRIDEN_PIDM	TBRCOLC_PIDM	TBRCOLC
SPRIDEN_PIDM	TBBCSTU_STU_PIDM	TBBCSTU
SPRIDEN_PIDM	TBBACCT_PIDM	TBBACCT
SPRIDEN_PIDM	TBBESTU_PIDM	TBBESTU
SPRIDEN_PIDM	TBRACCD_PIDM	TBRACCD
SPRIDEN_PIDM	FTVCARD_CARDHOLDER_PIDM	FTVCARD
SPRIDEN_PIDM	FCREMPO_PIDM	FCREMPO
SPRIDEN_PIDM	FABINVH_VEND_PIDM	FABINVH
SPRIDEN_PIDM	APBCONS_PIDM	APBCONS
SPRIDEN_PIDM	APRERVW_PIDM	APRERVW
SPRIDEN_PIDM	APRSRVW_PIDM	APRSRVW
SPRIDEN_PIDM	APRCRVW_PIDM	APRCRVW
SPRIDEN_PIDM	SIBINST_PIDM	SIBINST
SPRIDEN_PIDM	SLBEVNT_AGENCY_PIDM	SLBEVNT
SPRIDEN_PIDM	SHTTRAN_PIDM	SHTTRAN
SPRIDEN_PIDM	SMBSLIB_PIDM	SMBSLIB
SPRIDEN_PIDM	SMBAOGN_PIDM	SMBAOGN
SPRIDEN_PIDM	SMRRQCM_ORIG_PIDM	SMRRQCM
SPRIDEN_PIDM	SMRRQCM_PIDM	SMRRQCM
SPRIDEN_ID	SRTIDEN_ID	SRTIDEN
SPRIDEN_PIDM	SRTIDEN_PIDM	SRTIDEN
SPRIDEN_PIDM	SHBDIPL_PIDM	SHBDIPL
SPRIDEN_PIDM	SORPCOL_PIDM	SORPCOL
SPRIDEN_PIDM	SLRRMAT_PIDM	SLRRMAT
SPRIDEN_PIDM	SORHSCH_PIDM	SORHSCH
SPRIDEN_PIDM	SHBCATT_PIDM	SHBCATT
SPRIDEN_PIDM	SORAINF_PIDM	SORAINF
SPRIDEN_PIDM	GERPART_PIDM	GERPART
SPRIDEN_PIDM	SPBPERS_PIDM	SPBPERS
SPRIDEN_PIDM	PEBEMPL_PIDM	PEBEMPL
SPRIDEN_PIDM	FTVVEND_PIDM	FTVVEND
SPRIDEN_PIDM	FTVCUST_PIDM	FTVCUST
SPRIDEN_PIDM	FRBPROP_AGENCY_PIDM	FRBPROP
SPRIDEN_PIDM	RNRTMNT_PIDM	RNRTMNT
SPRIDEN_PIDM	SIRASGN_PIDM	SIRASGN
SPRIDEN_PIDM	SORAROL_PIDM	SORAROL
SPRIDEN_PIDM	SABSTUD_PIDM	SABSTUD
SPRIDEN_PIDM	SGBSTDN_PIDM	SGBSTDN
SPRIDEN_PIDM	SFRENRL_PIDM	SFRENRL
SPRIDEN_PIDM	SMBPOGN_PIDM	SMBPOGN
SPRIDEN_PIDM	SGRASSI_PIDM	SGRASSI
SPRIDEN_PIDM	SHBHEAD_PIDM	SHBHEAD
SPRIDEN_PIDM	RORLOGM_PIDM	RORLOGM
SPRIDEN_PIDM	SFRSTCR_PIDM	SFRSTCR
SPRIDEN_PIDM	SHRDGMR_PIDM	SHRDGMR
SPRIDEN_PIDM	AMRCONF_PIDM	AMRCONF

Index

Index Name	Index Type	Column Name
SPRIDEN_INDEX_ID		SPRIDEN_ID
SPRIDEN_INDEX_ID		SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_ID		SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_PERS		SPRIDEN_LAST_NAME
SPRIDEN_INDEX_PERS		SPRIDEN_FIRST_NAME
SPRIDEN_INDEX_PERS		SPRIDEN_MI
SPRIDEN_INDEX_PERS		SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_PERS		SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_LAST_NAME
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_FIRST_NAME
SPRIDEN_INDEX_SEARCH		SPRIDEN_SEARCH_MI
SPRIDEN_INDEX_SOUNDEX		SPRIDEN_SOUNDEX_LAST_NAME
SPRIDEN_INDEX_SOUNDEX		SPRIDEN_SOUNDEX_FIRST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_PIDM
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_ID
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_LAST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_FIRST_NAME
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_MI
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_CHANGE_IND
SPRIDEN_KEY_INDEX	Unique	SPRIDEN_NTYP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Person Identification/Name Repeating Table

Impact job : SPRIDEN_LAST_NAME SPRIDEN_LAST_NAME

Impact job : ln_spriden_first_name New Job

Impact job : ln_spriden_last_name New Job

Columns Comments for SPRIDEN_PIDM (# 1)

Source Code Comments

Internal identification number of the person.

Columns Comments for SPRIDEN_ID (# 2)

Source Code Comments

This field defines the identification number used to access person on-line.

Columns Comments for SPRIDEN_LAST_NAME (# 3)

Source Code Comments

This field defines the last name of person.

Columns Comments for SPRIDEN_FIRST_NAME (# 4)

Source Code Comments

This field identifies the first name of person.

Columns Comments for SPRIDEN_MI (# 5)

Source Code Comments

This field identifies the middle name of person.

Columns Comments for SPRIDEN_CHANGE_IND (# 6)

Source Code Comments

This field identifies whether type of change made to the record was an ID number change or a name change. Valid values: I - ID change, N - name change.

Columns Comments for SPRIDEN_ENTITY_IND (# 7)

Source Code Comments

This field identifies whether record is person or non-person record. It does not display on the form. Valid values: P - person, C - non-person.

Columns Comments for SPRIDEN_ACTIVITY_DATE (# 8)

Source Code Comments

This field defines the most current date record is created or changed.

Columns Comments for SPRIDEN_USER (# 9)

Source Code Comments

USER: The ID for the user that most recently updated the record.

Columns Comments for SPRIDEN_ORIGIN (# 10)

Source Code Comments

ORIGIN: The name of the Banner Object that was used most recently to update the row in the spriden table.

Columns Comments for SPRIDEN_SEARCH_LAST_NAME (# 11)

Source Code Comments

The Last Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (# 12)

Source Code Comments

The First Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_MI (# 13)

Source Code Comments

The MI (Middle Initial) field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (# 14)

Source Code Comments

The Last Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (# 15)

Source Code Comments

The First Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_NTYP_CODE (# 16)

Source Code Comments

NAME TYPE CODE: The field is used to store the code that represents the name type associated with a person's name.

Columns Comments for SPRIDEN_CREATE_USER (# 17)

Source Code Comments

Record Create User: This field contains Banner User ID which created new record

Columns Comments for SPRIDEN_CREATE_DATE (# 18)

Source Code Comments

Record Create Date: This field contains date new record created

Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)

Source Code Comments

DATA SOURCE: Source system that generated the data

Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)

Source Code Comments

PII DOMAIN: PII Domain of the user who created the spriden row.

Table STVGATT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVGATT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVGATT_CODE	STVGATT_CODE	VARCHAR2(4)	No	*
STVGATT_DESC	STVGATT_DESC	VARCHAR2(30)	No
STVGATT_ACTIVITY_DATE	STVGATT_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVGATT	Unique	STVGATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Student services goal attribute code table

Columns Comments for STVGATT_CODE (# 1)

Source Code Comments

Goal attribute code

Columns Comments for STVGATT_DESC (# 2)

Source Code Comments

Description of goal attribute code

Columns Comments for STVGATT_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Table STVGOAL

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVGOAL

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVGOAL_CODE	STVGOAL_CODE	VARCHAR2(4)	No	*
STVGOAL_DESC	STVGOAL_DESC	VARCHAR2(30)	No
STVGOAL_ACTIVITY_DATE	STVGOAL_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVGOAL	Unique	STVGOAL_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:43:000

Source Code Comments

Student Goal Code Validation Table

Columns Comments for STVGOAL_CODE (# 1)

Source Code Comments

Student Goal Code

Columns Comments for STVGOAL_DESC (# 2)

Source Code Comments

Description of student goal code

Columns Comments for STVGOAL_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVNATT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVNATT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVNATT_CODE	STVNATT_CODE	VARCHAR2(4)	No	*
STVNATT_DESC	STVNATT_DESC	VARCHAR2(30)	No
STVNATT_ACTIVITY_DATE	STVNATT_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVNATT	Unique	STVNATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:40:000

Source Code Comments

Student services need attribute code table

Columns Comments for STVNATT_CODE (# 1)

Source Code Comments

Need attribute code

Columns Comments for STVNATT_DESC (# 2)

Source Code Comments

Description of need attribute code

Columns Comments for STVNATT_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Table STVNDRF

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVNDRF

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVNDRF_CODE	STVNDRF_CODE	VARCHAR2(4)	No	*
STVNDRF_DESC	STVNDRF_DESC	VARCHAR2(30)	No
STVNDRF_ACTIVITY_DATE	STVNDRF_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVNDRF	Unique	STVNDRF_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Need Referral Validation Table

Columns Comments for STVNDRF_CODE (# 1)

Source Code Comments

Need Referral Code

Columns Comments for STVNDRF_DESC (# 2)

Source Code Comments

Description of need referral code

Columns Comments for STVNDRF_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVNEED

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVNEED

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVNEED_CODE	STVNEED_CODE	VARCHAR2(4)	No	*
STVNEED_DESC	STVNEED_DESC	VARCHAR2(30)	No
STVNEED_ACTIVITY_DATE	STVNEED_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVNEED	Unique	STVNEED_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Student Needs Validation Table

Columns Comments for STVNEED_CODE (# 1)

Source Code Comments

Student Needs Code

Columns Comments for STVNEED_DESC (# 2)

Source Code Comments

Description of student needs code

Columns Comments for STVNEED_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVORIG

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVORIG

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVORIG_CODE	STVORIG_CODE	VARCHAR2(4)	No	*
STVORIG_DESC	STVORIG_DESC	VARCHAR2(30)	Yes
STVORIG_ACTIVITY_DATE	STVORIG_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVORIG	Unique	STVORIG_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Originator Validation Table

Columns Comments for STVORIG_CODE (# 1)

Source Code Comments

This field identifies the originator code referenced in the Gen. Person, Recruiting, Student Billing, and Acad. Hist. Modules.

Columns Comments for STVORIG_DESC (# 2)

Source Code Comments

This field specifies the originator associated with the originator code. Table is used to identify origin of comments.

Columns Comments for STVORIG_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table STVSATT

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSATT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSATT_CODE	STVSATT_CODE	VARCHAR2(4)	No	*
STVSATT_DESC	STVSATT_DESC	VARCHAR2(30)	No
STVSATT_ACTIVITY_DATE	STVSATT_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSATT	Unique	STVSATT_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Student services service attribute code table

Columns Comments for STVSATT_CODE (# 1)

Source Code Comments

service attribute code

Columns Comments for STVSATT_DESC (# 2)

Source Code Comments

Description of service attribute code

Columns Comments for STVSATT_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Table STVSEPR

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSEPR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSEPR_CODE	STVSEPR_CODE	VARCHAR2(2)	No	*
STVSEPR_DESC	STVSEPR_DESC	VARCHAR2(30)	No
STVSEPR_ACTIVITY_DATE	STVSEPR_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSEPR	Unique	STVSEPR_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:45:000

Source Code Comments

Student Services Provided Validation Table

Columns Comments for STVSEPR_CODE (# 1)

Source Code Comments

Services Provided Code

Columns Comments for STVSEPR_DESC (# 2)

Source Code Comments

Description of services provided code

Columns Comments for STVSEPR_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVSPRV

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSPRV

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSPRV_CODE	STVSPRV_CODE	VARCHAR2(6)	No	*
STVSPRV_DESC	STVSPRV_DESC	VARCHAR2(30)	No
STVSPRV_ACTIVITY_DATE	STVSPRV_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSPRV	Unique	STVSPRV_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:39:000

Source Code Comments

Student services provider code table

Columns Comments for STVSPRV_CODE (# 1)

Source Code Comments

Service provider code

Columns Comments for STVSPRV_DESC (# 2)

Source Code Comments

Description of provider code

Columns Comments for STVSPRV_ACTIVITY_DATE (# 3)

Source Code Comments

The Activity Date

Table STVSSEP

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSSEP

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSSEP_CODE	STVSSEP_CODE	VARCHAR2(4)	No	*
STVSSEP_DESC	STVSSEP_DESC	VARCHAR2(30)	No
STVSSEP_ACTIVITY_DATE	STVSSEP_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSSEP	Unique	STVSSEP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student Services Exemption Validation Table

Columns Comments for STVSSEP_CODE (# 1)

Source Code Comments

Exemption Code

Columns Comments for STVSSEP_DESC (# 2)

Source Code Comments

Description of exemption code

Columns Comments for STVSSEP_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVSSER

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSSER

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSSER_CODE	STVSSER_CODE	VARCHAR2(4)	No	*
STVSSER_DESC	STVSSER_DESC	VARCHAR2(30)	No
STVSSER_TYPE	STVSSER_TYPE	VARCHAR2(2)	Yes
STVSSER_ACTIVITY_DATE	STVSSER_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSSER	Unique	STVSSER_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student Services Code Validation Table

Columns Comments for STVSSER_CODE (# 1)

Source Code Comments

Support Service Code

Columns Comments for STVSSER_DESC (# 2)

Source Code Comments

Description of support service code

Columns Comments for STVSSER_TYPE (# 3)

Source Code Comments

Support Service Type

Columns Comments for STVSSER_ACTIVITY_DATE (# 4)

Source Code Comments

Indicates the date the record was created or updated

Table STVSSGP

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSSGP

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSSGP_CODE	STVSSGP_CODE	VARCHAR2(4)	No	*
STVSSGP_DESC	STVSSGP_DESC	VARCHAR2(30)	No
STVSSGP_ACTIVITY_DATE	STVSSGP_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSSGP	Unique	STVSSGP_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:44:000

Source Code Comments

Student Service Group Validation Table

Columns Comments for STVSSGP_CODE (# 1)

Source Code Comments

Group Validation Code

Columns Comments for STVSSGP_DESC (# 2)

Source Code Comments

Description of group validation code

Columns Comments for STVSSGP_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVSSRS

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSSRS

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSSRS_CODE	STVSSRS_CODE	VARCHAR2(2)	No	*
STVSSRS_DESC	STVSSRS_DESC	VARCHAR2(30)	No
STVSSRS_ACTIVITY_DATE	STVSSRS_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSSRS	Unique	STVSSRS_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student Services Result Validation Table

Columns Comments for STVSSRS_CODE (# 1)

Source Code Comments

Services Result Code

Columns Comments for STVSSRS_DESC (# 2)

Source Code Comments

Description of student goal code

Columns Comments for STVSSRS_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVSSST

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVSSST

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVSSST_CODE	STVSSST_CODE	VARCHAR2(2)	No	*
STVSSST_DESC	STVSSST_DESC	VARCHAR2(30)	No
STVSSST_ACTIVITY_DATE	STVSSST_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVSSST	Unique	STVSSST_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student Services Status Validation Table

Columns Comments for STVSSST_CODE (# 1)

Source Code Comments

Service Status Code

Columns Comments for STVSSST_DESC (# 2)

Source Code Comments

Description of service status code

Columns Comments for STVSSST_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Table STVTERM

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVTERM

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVTERM_CODE	STVTERM_CODE	VARCHAR2(6)	No	*	*
STVTERM_DESC	STVTERM_DESC	VARCHAR2(30)	No
STVTERM_START_DATE	STVTERM_START_DATE	DATE	No
STVTERM_END_DATE	STVTERM_END_DATE	DATE	No
STVTERM_FA_PROC_YR	STVTERM_FA_PROC_YR	VARCHAR2(4)	Yes
STVTERM_ACTIVITY_DATE	STVTERM_ACTIVITY_DATE	DATE	No
STVTERM_FA_TERM	STVTERM_FA_TERM	VARCHAR2(1)	Yes
STVTERM_FA_PERIOD	STVTERM_FA_PERIOD	NUMBER(2,0)	Yes
STVTERM_FA_END_PERIOD	STVTERM_FA_END_PERIOD	NUMBER(2,0)	Yes
STVTERM_ACYR_CODE	STVTERM_ACYR_CODE	VARCHAR2(4)	No		*
STVTERM_HOUSING_START_DATE	STVTERM_HOUSING_START_DATE	DATE	No
STVTERM_HOUSING_END_DATE	STVTERM_HOUSING_END_DATE	DATE	No
STVTERM_SYSTEM_REQ_IND	STVTERM_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVTERM_TRMT_CODE	STVTERM_TRMT_CODE	VARCHAR2(1)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVTERM_CODE	TBRACCD_TERM_CODE	TBRACCD
STVTERM_ACYR_CODE	STVACYR_CODE	STVACYR
STVTERM_TRMT_CODE	STVTRMT_CODE	STVTRMT

Index

Index Name	Index Type	Column Name
PK_STVTERM	Unique	STVTERM_CODE
STVTERM_ACYR_INDEX	Unique	STVTERM_ACYR_CODE
STVTERM_ACYR_INDEX	Unique	STVTERM_CODE
STVTERM_AIDY_INDEX		STVTERM_FA_PROC_YR
STVTERM_AIDY_INDEX		STVTERM_CODE
STVTERM_END_DATE_INDEX		STVTERM_END_DATE
STVTERM_START_DATE_INDEX		STVTERM_START_DATE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/07/2004 04:58:27:000

Source Code Comments

Term Code Validation Table

Columns Comments for STVTERM_CODE (# 1)

Source Code Comments

This field identifies the term code referenced in the Catalog, Recruiting, Admissions, Gen. Student, Registration, Student Billing and Acad. Hist. Modules. Reqd. value: 999999 - End of Time.

Columns Comments for STVTERM_DESC (# 2)

Source Code Comments

This field specifies the term associated with the term code. The term is identified by the academic year and term number and is formatted YYYYTT.

Columns Comments for STVTERM_START_DATE (# 3)

Source Code Comments

This field identifies the term start date and is formatted DD-MON-YY.

Columns Comments for STVTERM_END_DATE (# 4)

Source Code Comments

This field identifies the term end date and is fomatted DD-MON-YY.

Columns Comments for STVTERM_FA_PROC_YR (# 5)

Source Code Comments

This field identifies the financial aid processing start and end years (e.g. The financial aid processing year 1988 - 1989 is formatted 8889.).

Columns Comments for STVTERM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for STVTERM_FA_TERM (# 7)

Source Code Comments

This field identifies the financial aid award term.

Columns Comments for STVTERM_FA_PERIOD (# 8)

Source Code Comments

This field identifies the financial aid award beginning period.

Columns Comments for STVTERM_FA_END_PERIOD (# 9)

Source Code Comments

This field identifies the financial aid award ending period.

Columns Comments for STVTERM_ACYR_CODE (# 10)

Source Code Comments

This field is not currently in use.

Columns Comments for STVTERM_HOUSING_START_DATE (# 11)

Source Code Comments

Housing Start Date.

Columns Comments for STVTERM_HOUSING_END_DATE (# 12)

Source Code Comments

Housing End Date.

Columns Comments for STVTERM_SYSTEM_REQ_IND (# 13)

Source Code Comments

System Required Indicator

Columns Comments for STVTERM_TRMT_CODE (# 14)

Source Code Comments

Term type for this term. Will default from SHBCGPA_TRMT_CODE.

Table STVTREQ

Server Name S4B70.SCT.COM
Database Name SATURN
Table Label STVTREQ

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVTREQ_CODE	STVTREQ_CODE	VARCHAR2(2)	No	*
STVTREQ_DESC	STVTREQ_DESC	VARCHAR2(30)	No
STVTREQ_ACTIVITY_DATE	STVTREQ_ACTIVITY_DATE	DATE	No

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVTREQ	Unique	STVTREQ_CODE

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:42:000

Source Code Comments

Student Time Requirement Validation Table

Columns Comments for STVTREQ_CODE (# 1)

Source Code Comments

Time Requirement Code

Columns Comments for STVTREQ_DESC (# 2)

Source Code Comments

Description of time requirement code

Columns Comments for STVTREQ_ACTIVITY_DATE (# 3)

Source Code Comments

Indicates the date the record was created or updated

Link between SERDTGL and SPRIDEN

Join Information

Objects list
schema-view : S4B70.BANINST1.SEVSSER

Link List

Link Type	Link	Project
Join	Link Between SERDTGL and SPRIDEN	SATURN

List of Real link

Link type	Between	And
Join	SERDTGL	SPRIDEN

Link between SERDTND and SPRIDEN

Join Information

Objects list
schema-view : S4B70.BANINST1.SEVSSER

Link List

Link Type	Link	Project
Join	Link Between SERDTND and SPRIDEN	SATURN

List of Real link

Link type	Between	And
Join	SERDTND	SPRIDEN

Link between SERDTSR and SPRIDEN

Join Information

Objects list
schema-view : S4B70.BANINST1.SEVSSER

Link List

Link Type	Link	Project
Join	Link Between SERDTSR and SPRIDEN	SATURN

List of Real link

Link type	Between	And
Join	SERDTSR	SPRIDEN

Link between SERGOAL and STVGOAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGOAL and STVGOAL (FK1_SERGOAL_INV_STVGOAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGOAL	SERGOAL_GOAL_CODE	STVGOAL_CODE	STVGOAL	(0,1)-(0,n)

Link between SERSRAT and STVSSER

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSRAT and STVSSER (FK1_SERSRAT_INV_STVSSER_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSRAT	SERSRAT_SSER_CODE	STVSSER_CODE	STVSSER	(1,1)-(0,n)

Link between SERSRCM and STVSSER

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSRCM and STVSSER (FK1_SERSRCM_INV_STVSSER_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSRCM	SERSRCM_SSER_CODE	STVSSER_CODE	STVSSER	(1,1)-(0,n)

Link between SERGOAL and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGOAL and STVSSGP (FK1_SERGOAL_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGOAL	SERGOAL_SSGP_CODE	STVSSGP_CODE	STVSSGP	(1,1)-(0,n)

Link between SERSSER and STVSSER

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSSER and STVSSER (FK1_SERSSER_INV_STVSSER_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSSER	SERSSER_SSER_CODE	STVSSER_CODE	STVSSER	(0,1)-(0,n)

Link between SERSSER and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSSER and STVSSGP (FK1_SERSSER_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSSER	SERSSER_SSGP_CODE	STVSSGP_CODE	STVSSGP	(1,1)-(0,n)

Link between SERSSGP and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSSGP and STVSSGP (FK1_SERSSGP_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSSGP	SERSSGP_SSGP_CODE	STVSSGP_CODE	STVSSGP	(0,1)-(0,n)

Link between SERNDAT and STVNEED

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNDAT and STVNEED (FK1_SERNDAT_INV_STVNEED_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNDAT	SERNDAT_NEED_CODE	STVNEED_CODE	STVNEED	(1,1)-(0,n)

Link between SERNDCM and STVNEED

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNDCM and STVNEED (FK1_SERNDCM_INV_STVNEED_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNDCM	SERNDCM_NEED_CODE	STVNEED_CODE	STVNEED	(1,1)-(0,n)

Link between SERNEED and STVNEED

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNEED and STVNEED (FK1_SERNEED_INV_STVNEED_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNEED	SERNEED_NEED_CODE	STVNEED_CODE	STVNEED	(0,1)-(0,n)

Link between SERNEED and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNEED and STVSSGP (FK1_SERNEED_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNEED	SERNEED_SSGP_CODE	STVSSGP_CODE	STVSSGP	(1,1)-(0,n)

Link between SERDTGL and STVGOAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVGOAL (FK1_SERDTGL_INV_STVGOAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_GOAL_CODE	STVGOAL_CODE	STVGOAL	(0,1)-(0,n)

Link between SERDTGL and STVORIG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVORIG (FK1_SERDTGL_INV_STVORIG_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_ORIG_CODE	STVORIG_CODE	STVORIG	(0,1)-(0,n)

Link between SERDTGL and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVSSGP (FK1_SERDTGL_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_SSGP_CODE	STVSSGP_CODE	STVSSGP	(0,1)-(0,n)

Link between SERDTGL and STVSSRS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVSSRS (FK1_SERDTGL_INV_STVSSRS_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_SSRS_CODE	STVSSRS_CODE	STVSSRS	(0,1)-(0,n)

Link between SERDTGL and STVTREQ

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVTREQ (FK1_SERDTGL_INV_STVTREQ_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_TREQ_CODE	STVTREQ_CODE	STVTREQ	(0,1)-(0,n)

Link between SERDTND and STVNDRF

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTND and STVNDRF (FK1_SERDTND_INV_STVNDRF_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTND	SERDTND_NDRF_CODE	STVNDRF_CODE	STVNDRF	(0,1)-(0,n)

Link between SERDTND and STVNEED

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTND and STVNEED (FK1_SERDTND_INV_STVNEED_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTND	SERDTND_NEED_CODE	STVNEED_CODE	STVNEED	(0,1)-(0,n)

Link between SERDTND and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTND and STVSSGP (FK1_SERDTND_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTND	SERDTND_SSGP_CODE	STVSSGP_CODE	STVSSGP	(0,1)-(0,n)

Link between SERDTSR and STVORIG

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVORIG (FK1_SERDTSR_INV_STVORIG_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_ORIG_CODE	STVORIG_CODE	STVORIG	(0,1)-(0,n)

Link between SERDTSR and STVSEPR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSEPR (FK1_SERDTSR_INV_STVSEPR_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SEPR_CODE	STVSEPR_CODE	STVSEPR	(0,1)-(0,n)

Link between SERDTSR and STVSSEP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSSEP (FK1_SERDTSR_INV_STVSSEP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SSEP_CODE	STVSSEP_CODE	STVSSEP	(0,1)-(0,n)

Link between SERDTSR and STVSSER

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSSER (FK1_SERDTSR_INV_STVSSER_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SSER_CODE	STVSSER_CODE	STVSSER	(0,1)-(0,n)

Link between SERDTSR and STVSSGP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSSGP (FK1_SERDTSR_INV_STVSSGP_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SSGP_CODE	STVSSGP_CODE	STVSSGP	(0,1)-(0,n)

Link between SERDTSR and STVSSRS

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSSRS (FK1_SERDTSR_INV_STVSSRS_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SSRS_CODE	STVSSRS_CODE	STVSSRS	(0,1)-(0,n)

Link between SERDTSR and STVSSST

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSSST (FK1_SERDTSR_INV_STVSSST_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SSST_CODE	STVSSST_CODE	STVSSST	(0,1)-(0,n)

Link between SERGLAT and STVGATT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGLAT and STVGATT (FK1_SERGLAT_INV_STVGATT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGLAT	SERGLAT_GATT_CODE	STVGATT_CODE	STVGATT	(0,1)-(0,n)

Link between SERGLAT and STVGOAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGLAT and STVGOAL (FK1_SERGLAT_INV_STVGOAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGLAT	SERGLAT_GOAL_CODE	STVGOAL_CODE	STVGOAL	(1,1)-(0,n)

Link between SERGLCM and STVGOAL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGLCM and STVGOAL (FK1_SERGLCM_INV_STVGOAL_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGLCM	SERGLCM_GOAL_CODE	STVGOAL_CODE	STVGOAL	(1,1)-(0,n)

Link between SABAUDF and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SABAUDF and STVTERM (FK1_SABAUDF_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SABAUDF	SABAUDF_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,1)

Link between SERDTGL and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTGL and STVTERM (FK1_SERDTGL_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTGL	SERDTGL_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERDTND and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTND and STVTERM (FK1_SERDTND_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTND	SERDTND_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERDTSR and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVTERM (FK1_SERDTSR_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERGLAT and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGLAT and STVTERM (FK1_SERGLAT_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGLAT	SERGLAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERGLCM and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGLCM and STVTERM (FK1_SERGLCM_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGLCM	SERGLCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERGOAL and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERGOAL and STVTERM (FK1_SERGOAL_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERGOAL	SERGOAL_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERNDAT and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNDAT and STVTERM (FK1_SERNDAT_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNDAT	SERNDAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERNDCM and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNDCM and STVTERM (FK1_SERNDCM_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNDCM	SERNDCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERNEED and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNEED and STVTERM (FK1_SERNEED_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNEED	SERNEED_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERSRAT and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSRAT and STVTERM (FK1_SERSRAT_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSRAT	SERSRAT_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERSRCM and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSRCM and STVTERM (FK1_SERSRCM_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSRCM	SERSRCM_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERSSER and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSSER and STVTERM (FK1_SERSSER_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSSER	SERSSER_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERSSGP and STVTERM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSSGP and STVTERM (FK1_SERSSGP_INV_STVTERM_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSSGP	SERSSGP_TERM_CODE_EFF	STVTERM_CODE	STVTERM	(1,1)-(0,n)

Link between SERDTSR and STVSPRV

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERDTSR and STVSPRV (FK1_SERDTSR_INV_STVSPRV_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERDTSR	SERDTSR_SPRV_CODE	STVSPRV_CODE	STVSPRV	(0,1)-(0,n)

Link between SERSRAT and STVSATT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERSRAT and STVSATT (FK1_SERSRAT_INV_STVSATT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERSRAT	SERSRAT_SATT_CODE	STVSATT_CODE	STVSATT	(0,1)-(0,n)

Link between SERNDAT and STVNATT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between SERNDAT and STVNATT (FK1_SERNDAT_INV_STVNATT_CODE)	SATURN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SERNDAT	SERNDAT_NATT_CODE	STVNATT_CODE	STVNATT	(0,1)-(0,n)