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

Model Support Service


Model Label : ERD for Banner Student Support Service Module (SE% TAbles )
Path : BANNER DEV/Student/Support Service/Support_Service_ERD/Support Service

List of Objects

Object Name Object Type Layer Name
SERDTGL TABLE Default
SERDTND TABLE Default
SERDTSR TABLE Default
SERGLAT TABLE Default
SERGLCM TABLE Default
SERGOAL TABLE Default
SERNDAT TABLE Default
SERNDCM TABLE Default
SERNEED TABLE Default
SERSRAT TABLE Default
SERSRCM TABLE Default
SERSSER TABLE Default
SERSSGP TABLE Default
SETATND TABLE Default

Comments

Model View

''

Table SERDTGL

Schema Name SATURN
Label SERDTGL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:54: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_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
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:54: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_NDRF_CODE STVNDRF_CODE STVNDRF
SERDTND_NEED_CODE STVNEED_CODE STVNEED
SERDTND_SSGP_CODE STVSSGP_CODE STVSSGP
SERDTND_TERM_CODE_EFF STVTERM_CODE STVTERM
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:11:54: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_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
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

Comments

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

Schema Name SATURN
Label SERGLAT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:54:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERGLCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERGOAL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERNDAT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERNDCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERNEED
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERSRAT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERSRCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERSSER
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SERSSGP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:55:000

Table Columns information

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

Comments

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

Schema Name SATURN
Label SETATND
Server name MALDEV8_B60
Creation Date 08/27/2002 00:01:48:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

No Result

Comments

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