PK_SABAUDF SABAUDF SERDTGL SERDTND SERDTSR SERGLAT SERGLCM SERGOAL SERNDAT SERNDCM SERNEED SERSRAT SERSRCM SERSSER SERSSGP SETATND

Model Support Service*


Model Label : Support Service SE% tables and some support tables

List of Objects

Object Name Object Type Layer Name
PK_SABAUDF SQL Index Default
SABAUDF SQL Table Default
SERDTGL SQL Table Default
SERDTND SQL Table Default
SERDTSR SQL Table Default
SERGLAT SQL Table Default
SERGLCM SQL Table Default
SERGOAL SQL Table Default
SERNDAT SQL Table Default
SERNDCM SQL Table Default
SERNEED SQL Table Default
SERSRAT SQL Table Default
SERSRCM SQL Table Default
SERSSER SQL Table Default
SERSSGP SQL Table Default
SETATND SQL Table Default

Model View

Index PK_SABAUDF

Server Name S10B80
Database Name SATURN
Index Label
Referenced Object name SABAUDF
Owner Name
Index Type UNIQUE

Index Columns information

Column Name Column Type Column Length Column precision
SABAUDF_TERM_CODE_EFF VARCHAR2 6 0

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABAUDF SQL Table S10B80.SATURN Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.PK_SABAUDF

Object Dates

Creation Date Analysis Date
04/02/2008 20:55:03:000 04/02/2008 20:55:03:000

Table SABAUDF

Server Name S10B80
Database Name SATURN
Table Label

Table Columns information

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABAUDF SQL Index S10B80.SATURN Rely On
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SABAUDF

Object Dates

Creation Date Analysis Date
04/02/2008 20:55:02:000 04/02/2008 21:18:16: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
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_TERM_CODE_EFF STVTERM_CODE STVTERM

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SPRIDEN SQL Table S10B80.SATURN Join
SEVSSER SQL View S10B80.BANINST1 Use (select)
SERDTGL Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTGL_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVGOAL SQL Table S10B80.SATURN Refer (no action)
STVORIG SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVSSRS SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)
STVTREQ SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERDTGL

Object Dates

Creation Date Analysis Date
04/02/2008 20:54:36:000 04/02/2008 21:18:16: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SPRIDEN SQL Table S10B80.SATURN Join
SEVSSER SQL View S10B80.BANINST1 Use (select)
SERDTND Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTND_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVNDRF SQL Table S10B80.SATURN Refer (no action)
STVNEED SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERDTND

Object Dates

Creation Date Analysis Date
04/02/2008 20:55:11:000 04/02/2008 21:18:16: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
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_TERM_CODE_EFF STVTERM_CODE STVTERM
SERDTSR_SPRV_CODE STVSPRV_CODE STVSPRV

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SPRIDEN SQL Table S10B80.SATURN Join
SEVSSER SQL View S10B80.BANINST1 Use (select)
SERDTSR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTSR_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVORIG SQL Table S10B80.SATURN Refer (no action)
STVSEPR SQL Table S10B80.SATURN Refer (no action)
STVSPRV SQL Table S10B80.SATURN Refer (no action)
STVSSEP SQL Table S10B80.SATURN Refer (no action)
STVSSER SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVSSRS SQL Table S10B80.SATURN Refer (no action)
STVSSST SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERDTSR

Object Dates

Creation Date Analysis Date
04/02/2008 20:56:00:000 04/02/2008 21:18:17: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERGLAT_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVGATT SQL Table S10B80.SATURN Refer (no action)
STVGOAL SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERGLAT

Object Dates

Creation Date Analysis Date
04/02/2008 20:56:58:000 04/02/2008 21:18:18: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERGLCM_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVGOAL SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERGLCM

Object Dates

Creation Date Analysis Date
04/02/2008 20:57:11:000 04/02/2008 21:18:18: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERGOAL_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVGOAL SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERGOAL

Object Dates

Creation Date Analysis Date
04/02/2008 20:37:29:000 04/02/2008 21:18:01: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERNDAT_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVNATT SQL Table S10B80.SATURN Refer (no action)
STVNEED SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERNDAT

Object Dates

Creation Date Analysis Date
04/02/2008 20:44:50:000 04/02/2008 21:18:08: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERNDCM_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVNEED SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERNDCM

Object Dates

Creation Date Analysis Date
04/02/2008 20:45:03:000 04/02/2008 21:18:08: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERNEED_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVNEED SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERNEED

Object Dates

Creation Date Analysis Date
04/02/2008 20:49:59:000 04/02/2008 21:18:12: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERSRAT_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVSATT SQL Table S10B80.SATURN Refer (no action)
STVSSER SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERSRAT

Object Dates

Creation Date Analysis Date
04/02/2008 20:39:19:000 04/02/2008 21:18:03: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERSRCM_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVSSER SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERSRCM

Object Dates

Creation Date Analysis Date
04/02/2008 20:39:33:000 04/02/2008 21:18:03: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERSSER_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVSSER SQL Table S10B80.SATURN Refer (no action)
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERSSER

Object Dates

Creation Date Analysis Date
04/02/2008 20:43:31:000 04/02/2008 21:18:07: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERSSGP_KEY_INDEX SQL Index S10B80.SATURN Rely On
STVSSGP SQL Table S10B80.SATURN Refer (no action)
STVTERM SQL Table S10B80.SATURN Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SERSSGP

Object Dates

Creation Date Analysis Date
04/02/2008 20:43:46:000 04/02/2008 21:18:07: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 S10B80
Database Name SATURN
Table Label

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.SATURN.SETATND

Object Dates

Creation Date Analysis Date
04/02/2008 20:36:05:000 04/02/2008 21:18:00: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

Link between SABAUDF and PK_SABAUDF


Link List

Link Type Link Project
Rely On Link Between SABAUDF and PK_SABAUDF SATURN

List of Real links

Link type Between And
Rely On SABAUDF PK_SABAUDF