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

Model ERD Support Service


Model Label : ERD for Banner Student Support Service

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

Comments

Model View

''

Table SABAUDF

Schema Name SATURN
Label SABAUDF
Server name S4B70
Creation Date 09/29/2003 12:09:17:000

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABAUDF SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA11 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA18 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA16 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA10 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA9 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA7 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA5 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA19 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA8 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA3 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA20 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA17 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA13 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA14 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA2 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA6 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA15 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA4 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA11 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA20 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA19 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA17 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA5 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA13 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA7 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA14 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA9 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA2 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA8 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA12 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA1 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA3 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA16 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA6 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA4 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA10 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.INST_DATA17_DESC Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA15 Use(select )
PRE-TEXT-ITEM Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_INST_DATA18 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG7 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG6 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG10 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG5 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG4 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG3 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG2 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG1 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG9 Use(select )
WHEN-NEW-ITEM-INSTANCE Forms Trigger BANNER7_FORMS.SOASUPL.SABSUPL.SABSUPL_FLAG8 Use(select )
STVTERM_EXISTS_RG Forms Record Group BANNER7_FORMS.SAAAUDF Use(select )
STVTERM_EXISTS_RG Forms Record Group BANNER7_FORMS_10G.SAAAUDF Use(select )
POPULATE_SABAUDF_FIELDS Forms Procedure BANNER7_FORMS.SOASUPL Use(select )
POPULATE_SABAUDF_FIELDS Forms Procedure BANNER7_FORMS_10G.SOASUPL Use(select )
SABAUDF Forms DataBlock BANNER7_FORMS.SAAAUDF Rely on () Use(insert,update,delete,select )
SABAUDF Forms DataBlock BANNER7_FORMS_10G.SAAAUDF Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABAUDF INDEX S4B70.SATURN Rely on ()
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

Schema Name SATURN
Label SERDTGL
Server name S4B70
Creation Date 09/29/2003 12:09:29:000

Table Columns information

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA3 Cobol Paragraph [F:\banner\cobol].SERSMREC.MAA-MAINLINE-SECT Use(select )
MAA6 Cobol Paragraph [F:\banner\cobol].SERSMREC.MAA-MAINLINE-SECT Use(select )
addgoal C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(insert,select )
checkgoal C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(select )
SEVSSER VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SEAGDTL.SEAGDTL_KEY_BLOCK.SEAGDTL_GOAL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SEAGDTL.SEAGDTL_KEY_BLOCK.SEAGDTL_GOAL_CODE Use(select )
END_GOAL_TERM Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(insert )
END_GOAL_TERM Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(insert,select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(delete )
POST-INSERT Forms Trigger BANNER7_FORMS_10G.SEAASGN.SERSSGP Use(insert,select )
POST-INSERT Forms Trigger BANNER7_FORMS.SEAASGN.SERSSGP Use(insert,select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEAGQRY.SERDTGL Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEADETL.SERDTGL Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEAGQRY.SERDTGL Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTGL Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
SERDTGL SYNONYM S4B70.PUBLIC Rely on ()
SERDTGL Forms DataBlock BANNER7_FORMS.SEAGQRY Rely on () Use(insert,update,delete,select )
SERDTGL Forms DataBlock BANNER7_FORMS.SEADETL Rely on () Use(insert,update,delete,select )
SERDTGL Forms DataBlock BANNER7_FORMS_10G.SEADETL Rely on () Use(insert,update,delete,select )
SERDTGL Forms DataBlock BANNER7_FORMS_10G.SEAGQRY Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTGL_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
STVGOAL TABLE S4B70.SATURN Refer( No Action )
STVORIG TABLE S4B70.SATURN Refer( No Action )
STVSSGP TABLE S4B70.SATURN Refer( No Action )
STVSSRS TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )
STVTREQ TABLE S4B70.SATURN Refer( No Action )

Comments

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

Schema Name SATURN
Label SERDTND
Server name S4B70
Creation Date 09/29/2003 12:09:29:000

Table Columns information

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
addneed C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(insert,select )
checkneed C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(select )
SERDTND SYNONYM S4B70.PUBLIC Rely on ()
SEVSSER VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SEANDTL.SEANDTL_KEY_BLOCK.SEANDTL_NEED_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SEANDTL.SEANDTL_KEY_BLOCK.SEANDTL_NEED_CODE Use(select )
GLOBAL_COPY Forms Trigger BANNER7_FORMS_10G.SEANDTL Use(select )
GLOBAL_COPY Forms Trigger BANNER7_FORMS.SEANDTL Use(select )
VALIDATE_KEY Forms Trigger BANNER7_FORMS_10G.SEANDTL Use(select )
VALIDATE_KEY Forms Trigger BANNER7_FORMS.SEANDTL Use(select )
END_NEED_TERM Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(insert )
END_NEED_TERM Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(insert,select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(delete )
POST-INSERT Forms Trigger BANNER7_FORMS_10G.SEAASGN.SERSSGP Use(insert,select )
POST-INSERT Forms Trigger BANNER7_FORMS.SEAASGN.SERSSGP Use(insert,select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEANQRY.SERDTND Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTND Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEADETL.SERDTND Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEANQRY.SERDTND Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
SERDTND Forms DataBlock BANNER7_FORMS.SEANQRY Rely on () Use(insert,update,delete,select )
SERDTND Forms DataBlock BANNER7_FORMS_10G.SEANQRY Rely on () Use(insert,update,delete,select )
SERDTND Forms DataBlock BANNER7_FORMS.SEADETL Rely on () Use(insert,update,delete,select )
SERDTND Forms DataBlock BANNER7_FORMS_10G.SEADETL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTND_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
STVNDRF TABLE S4B70.SATURN Refer( No Action )
STVNEED TABLE S4B70.SATURN Refer( No Action )
STVSSGP TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

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

Schema Name SATURN
Label SERDTSR
Server name S4B70
Creation Date 09/29/2003 12:09:29:000

Table Columns information

Column Name Label Column Type Allow NULL PK 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_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_TERM_CODE_EFF STVTERM_CODE STVTERM
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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
MAA3 Cobol Paragraph [F:\banner\cobol].SERSMREC.MAA-MAINLINE-SECT Use(select )
MAA6 Cobol Paragraph [F:\banner\cobol].SERSMREC.MAA-MAINLINE-SECT Use(select )
addsser C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(insert,select )
checksser C/C++ Function [F:\BANNER\C\SERLOAD.PC] Use(select )
SEVSSER VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SEASDTL.SEASDTL_KEY_BLOCK.SEASDTL_SSER_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SEASDTL.SEASDTL_KEY_BLOCK.SEASDTL_SSER_CODE Use(select )
GLOBAL_COPY Forms Trigger BANNER7_FORMS.SEASDTL Use(select )
GLOBAL_COPY Forms Trigger BANNER7_FORMS_10G.SEASDTL Use(select )
END_SSER_TERM Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(insert )
END_SSER_TERM Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(insert )
INSERT_TRIG Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(insert,select )
INSERT_TRIG Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(insert,select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(delete )
POST-INSERT Forms Trigger BANNER7_FORMS_10G.SEAASGN.SERSSGP Use(insert,select )
POST-INSERT Forms Trigger BANNER7_FORMS.SEAASGN.SERSSGP Use(insert,select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(delete )
PRE-INSERT Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(delete )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEASQRY.SERDTSR Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEADETL.SERDTSR Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS_10G.SEASQRY.SERDTSR Use(select )
PRE-QUERY Forms Trigger BANNER7_FORMS.SEADETL.SERDTSR Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS_10G.SEAQGNS.SEVSSER Use(select )
VALIDATE_VIEW_DATA Forms Trigger BANNER7_FORMS.SEAQGNS.SEVSSER Use(select )
SERDTSR SYNONYM S4B70.PUBLIC Rely on ()
SERDTSR Forms DataBlock BANNER7_FORMS.SEASQRY Rely on () Use(insert,update,delete,select )
SERDTSR Forms DataBlock BANNER7_FORMS.SEADETL Rely on () Use(insert,update,delete,select )
SERDTSR Forms DataBlock BANNER7_FORMS_10G.SEASQRY Rely on () Use(insert,update,delete,select )
SERDTSR Forms DataBlock BANNER7_FORMS_10G.SEADETL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
SERDTSR_KEY_INDEX INDEX S4B70.SATURN Rely on ()
SPRIDEN TABLE S4B70.SATURN Join
STVORIG TABLE S4B70.SATURN Refer( No Action )
STVSEPR TABLE S4B70.SATURN Refer( No Action )
STVSPRV TABLE S4B70.SATURN Refer( No Action )
STVSSEP TABLE S4B70.SATURN Refer( No Action )
STVSSER TABLE S4B70.SATURN Refer( No Action )