Model SSRMEET

Model Label : SSRMEET table with called links
Path : Default Folder/B70/Common/SSRMEET

List of Objects

Object Name	Object Type	Layer Name
GEBFUNC	TABLE	Default
GTVMTYP	TABLE	Default
GTVSCHS	TABLE	Default
SCRSCHD	TABLE	Default
SFRSTCR	TABLE	Default
SFTREGS	TABLE	Default
SIRASGN	TABLE	Default
SLBBLDG	TABLE	Default
SSBSECT	TABLE	Default
SSREXCL	TABLE	Default
SSRMEET	TABLE	Default
SSRXLST	TABLE	Default
STVCOMT	TABLE	Default

Comments

Model View

Table GEBFUNC

Schema Name GENERAL
Label GEBFUNC
Server name S4B70
Creation Date 09/29/2003 12:04:32:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GEBFUNC_EVNT_CRN	GEBFUNC_EVNT_CRN	VARCHAR2(5)	No	*
GEBFUNC_FUNC_CODE	GEBFUNC_FUNC_CODE	VARCHAR2(12)	No	*	*
GEBFUNC_ACTIVITY_DATE	GEBFUNC_ACTIVITY_DATE	DATE	No
GEBFUNC_ETYP_CODE	GEBFUNC_ETYP_CODE	VARCHAR2(4)	No		*
GEBFUNC_FSTA_CODE	GEBFUNC_FSTA_CODE	VARCHAR2(1)	No		*
GEBFUNC_PURP_CODE	GEBFUNC_PURP_CODE	VARCHAR2(10)	Yes		*
GEBFUNC_PURP_DESC	GEBFUNC_PURP_DESC	VARCHAR2(60)	Yes
GEBFUNC_EMPH_CODE	GEBFUNC_EMPH_CODE	VARCHAR2(10)	Yes		*
GEBFUNC_INVITATION_DATE	GEBFUNC_INVITATION_DATE	DATE	Yes
GEBFUNC_LETR_CODE	GEBFUNC_LETR_CODE	VARCHAR2(15)	Yes		*
GEBFUNC_RSVP_CONFIRM_DATE	GEBFUNC_RSVP_CONFIRM_DATE	DATE	Yes
GEBFUNC_SPNSR_ORGN_PIDM	GEBFUNC_SPNSR_ORGN_PIDM	NUMBER(8,0)	Yes
GEBFUNC_COMMITTEE_NAME	GEBFUNC_COMMITTEE_NAME	VARCHAR2(60)	Yes
GEBFUNC_PLAN_ATTEND	GEBFUNC_PLAN_ATTEND	NUMBER(7,0)	Yes
GEBFUNC_BRK_EVEN_ATTEND	GEBFUNC_BRK_EVEN_ATTEND	NUMBER(7,0)	Yes
GEBFUNC_LOCATION	GEBFUNC_LOCATION	VARCHAR2(60)	Yes
GEBFUNC_LOCATION_DATE	GEBFUNC_LOCATION_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GEBFUNC_LETR_CODE	GTVLETR_CODE	GTVLETR
GEBFUNC_ETYP_CODE	STVETYP_CODE	STVETYP
GEBFUNC_EMPH_CODE	GTVEMPH_CODE	GTVEMPH
GEBFUNC_FSTA_CODE	GTVFSTA_CODE	GTVFSTA
GEBFUNC_PURP_CODE	GTVPURP_CODE	GTVPURP
GEBFUNC_FUNC_CODE	GTVFUNC_CODE	GTVFUNC

Index

Index Name	Index Type	Column Name
PK_GEBFUNC	Unique	GEBFUNC_EVNT_CRN
PK_GEBFUNC	Unique	GEBFUNC_FUNC_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GEBFUNC	SYNONYM	S4B70.PUBLIC	Rely on ()
GERATTD	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCOM	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCON	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFCOR	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFEXP	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFFEE	TABLE	S4B70."GENERAL"	Refer( No Action )
GERFREV	TABLE	S4B70."GENERAL"	Refer( No Action )
GERMENU	TABLE	S4B70."GENERAL"	Refer( No Action )
GERPART	TABLE	S4B70."GENERAL"	Refer( No Action )
GERTASK	TABLE	S4B70."GENERAL"	Refer( No Action )
SPRIDEN	TABLE	S4B70.SATURN	Join
SSRMEET	TABLE	S4B70.SATURN	Join
AG_EVENT	VIEW	S4B70.BANINST1	Use(select )
GEVEVN2	VIEW	S4B70.BANINST1	Use(select )
KEY-EDIT	Forms Trigger	BANNER7_FORMS.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-EDIT	Forms Trigger	BANNER7_FORMS_10G.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-HELP	Forms Trigger	BANNER7_FORMS.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
KEY-HELP	Forms Trigger	BANNER7_FORMS_10G.GEAPART.GERPART.PARTICIPANT_ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFUNC.GEBFUNC.GEBFUNC_FUNC_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFCOM.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAATTD.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEATASK.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEATASK.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAFCOM.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAPART.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAPART.KEY_BLOCK.FUNCTION	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.GEBFUNC.GEBFUNC_FUNC_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GEAATTD.KEY_BLOCK.FUNCTION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAATID.GERATTD.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAATID.REGISTRATION_BLOCK.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEIATTD.ATTENDEE_INQUIRY.QUERY_FUNCTION	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAATID.REGISTRATION_BLOCK.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAATID.GERATTD.GERATTD_FUNC_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEIATTD.ATTENDEE_INQUIRY.QUERY_FUNCTION	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEAATTD	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEAFCOM	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEAFCOM	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEAATTD	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.GEATASK	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.GEATASK	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS.GEAATID.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS.GEAATTD.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS_10G.GEAATTD.GERATTD	Use(select )
GET_LETR_INFO	Forms Trigger	BANNER7_FORMS_10G.GEAATID.GERATTD	Use(select )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS.GEAFUNC.SSRMEET	Use(insert )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS.SLAEVNT.SSRMEET	Use(insert,select )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS_10G.GEAFUNC.SSRMEET	Use(insert )
INSERT_GEBFUNC	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SSRMEET	Use(insert,select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.GEIFUNC.SSRMEET	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.GEIFUNC.SSRMEET	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.SLAEVNT.SLBEVNT	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.SLAEVNT.SLBEVNT	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
SELECT_GEBFUNC	Forms Sub Procedure	BANNER7_FORMS.GOQRPLS.G$_GOQOLIB_FUNC_INFO_BLOCK	Rely on () Use(select )
SELECT_GEBFUNC	Forms Sub Procedure	BANNER7_FORMS_10G.GOQRPLS.G$_GOQOLIB_FUNC_INFO_BLOCK	Rely on () Use(select )
GEBFUNC	Forms DataBlock	BANNER7_FORMS.GEAFUNC	Rely on () Use(insert,update,delete,select )
GEBFUNC	Forms DataBlock	BANNER7_FORMS_10G.GEAFUNC	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GEBFUNC	INDEX	S4B70."GENERAL"	Rely on ()
GTVEMPH	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVFSTA	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVFUNC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVLETR	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVPURP	TABLE	S4B70."GENERAL"	Refer( No Action )
STVETYP	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Function Header Table

Columns Comments for GEBFUNC_EVNT_CRN (1)

Source Code Comments

Event associated with the function.

Columns Comments for GEBFUNC_FUNC_CODE (2)

Source Code Comments

Code for the Function.

Columns Comments for GEBFUNC_ACTIVITY_DATE (3)

Source Code Comments

Date on which the Function was added or last changed.

Columns Comments for GEBFUNC_ETYP_CODE (4)

Source Code Comments

Function Type Code.

Columns Comments for GEBFUNC_FSTA_CODE (5)

Source Code Comments

Function Status Code.

Columns Comments for GEBFUNC_PURP_CODE (6)

Source Code Comments

Purpose Code for the Function.

Columns Comments for GEBFUNC_PURP_DESC (7)

Source Code Comments

Purpose Code Description for the Function.

Columns Comments for GEBFUNC_EMPH_CODE (8)

Source Code Comments

Emphasis Code for the Function.

Columns Comments for GEBFUNC_INVITATION_DATE (9)

Source Code Comments

Date of the Invitations to the Function.

Columns Comments for GEBFUNC_LETR_CODE (10)

Source Code Comments

Letter Code of the letter accompanying the invitation.

Columns Comments for GEBFUNC_RSVP_CONFIRM_DATE (11)

Source Code Comments

Latest date the RSVP should be received.

Columns Comments for GEBFUNC_SPNSR_ORGN_PIDM (12)

Source Code Comments

PIDM of the Sponsoring Organization of the Function.

Columns Comments for GEBFUNC_COMMITTEE_NAME (13)

Source Code Comments

Name of the Committee associated with the Function.

Columns Comments for GEBFUNC_PLAN_ATTEND (14)

Source Code Comments

Planned Attendance number.

Columns Comments for GEBFUNC_BRK_EVEN_ATTEND (15)

Source Code Comments

attendance required for the Function to break even.

Columns Comments for GEBFUNC_LOCATION (16)

Source Code Comments

Location of the Function if the Function is not associated with an Event.

Columns Comments for GEBFUNC_LOCATION_DATE (17)

Source Code Comments

Date of the Function if the Function is not associated with an Event.

Table GTVMTYP

Schema Name GENERAL
Label GTVMTYP
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVMTYP_CODE	GTVMTYP_CODE	VARCHAR2(4)	No	*
GTVMTYP_DESC	GTVMTYP_DESC	VARCHAR2(30)	No
GTVMTYP_SYS_REQ_IND	GTVMTYP_SYS_REQ_IND	VARCHAR2(1)	No
GTVMTYP_ACTIVITY_DATE	GTVMTYP_ACTIVITY_DATE	DATE	No
GTVMTYP_USER_ID	GTVMTYP_USER_ID	VARCHAR2(30)	No
GTVMTYP_VR_MSG_NO	GTVMTYP_VR_MSG_NO	NUMBER(6,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVMTYP	Unique	GTVMTYP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
selmeettype	C/C++ Function	[F:\BANNER\C\SSRTALY.PC]	Use(select )
GTVMTYP	SYNONYM	S4B70.PUBLIC	Rely on ()
SSRMEET	TABLE	S4B70.SATURN	Refer( No Action )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.SSRMEET_MTYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.MEET_MTYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.MEET_MTYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.SSRMEET_MTYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GTVMTYP.GTVMTYP.GTVMTYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GTVMTYP.GTVMTYP.GTVMTYP_CODE	Use(select )
GTVMTYP_RG	Forms Record Group	BANNER7_FORMS.GOQOLIB	Use(select )
GTVMTYP_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
GTVMTYP_RG	Forms Record Group	BANNER7_FORMS.SSAXMTI	Use(select )
GTVMTYP_RG	Forms Record Group	BANNER7_FORMS_10G.GOQOLIB	Use(select )
GTVMTYP_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
FACSCH_REC	Package Type	S4B70.BANINST1.BWLCBREF	Rely on ()
MEETING_REC_TYPE	Package Type	S4B70.BANINST1.BWCKWEEK	Rely on ()
GTVMTYP_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Rely on ()
GTVMTYP_ROW_BY_CODE_C	Package cursor	S4B70.BANINST1.VRSKFOLR	Use(select )
SSRMEETC	Package cursor	S4B70.BANINST1.BWCKLIBS	Use(select )
P_CRSESCHD	Package procedure	S4B70.BANINST1.BWSKFSHD	Use(select )
P_FACDAYSCHED	Package procedure	S4B70.BANINST1.BWLKIFAC	Use(select )
P_VR_LIST_CLASSES	Package procedure	S4B70.BANINST1.VRSKFORG	Rely on ()
P_VR_LIST_CLASSES	Package procedure	S4B70.BANINST1.VRSKFORG	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
GTVMTYP_C	Package cursor	S4B70.BANINST1.GB_GTVMTYP	Rely on ()
GTVMTYP_C	Package cursor	S4B70.BANINST1.GB_GTVMTYP	Rely on () Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVMTYP	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVMTYP	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVMTYP	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVMTYP	Rely on ()
F_GET_FACSCH	Package function	S4B70.BANINST1.BWLCBREF	Use(select )
GTVMTYP	Forms DataBlock	BANNER7_FORMS.GTVMTYP	Rely on () Use(insert,update,delete,select )
GTVMTYP	Forms DataBlock	BANNER7_FORMS_10G.GTVMTYP	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVMTYP	INDEX	S4B70."GENERAL"	Rely on ()

Comments

Source Code Comments

Meeting Type Code validation table

Columns Comments for GTVMTYP_CODE (1)

Source Code Comments

Meeting Type Code: The Meeting Type Code

Columns Comments for GTVMTYP_DESC (2)

Source Code Comments

Description: Description of the Meeting Type code

Columns Comments for GTVMTYP_SYS_REQ_IND (3)

Source Code Comments

System Required Indicator: Indicates whether or not this record is required to exist on the database

Columns Comments for GTVMTYP_ACTIVITY_DATE (4)

Source Code Comments

Activty Date: Date this record entered or last updated

Columns Comments for GTVMTYP_USER_ID (5)

Source Code Comments

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

Columns Comments for GTVMTYP_VR_MSG_NO (6)

Source Code Comments

Voice Response Message Number

Table GTVSCHS

Schema Name GENERAL
Label GTVSCHS
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVSCHS_CODE	GTVSCHS_CODE	VARCHAR2(3)	No	*
GTVSCHS_DESC	GTVSCHS_DESC	VARCHAR2(30)	No
GTVSCHS_SYSTEM_REQ_IND	GTVSCHS_SYSTEM_REQ_IND	VARCHAR2(1)	No
GTVSCHS_ACTIVITY_DATE	GTVSCHS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSCHS	Unique	GTVSCHS_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
update_work_table	C/C++ Function	[F:\BANNER\C\SSRSCRM.PC]	Use(select )
GTVSCHS	SYNONYM	S4B70.PUBLIC	Rely on ()
SSRMEET	TABLE	S4B70.SATURN	Refer( No Action )
SSTSCHW	TABLE	S4B70.SATURN	Refer( No Action )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GTVSCHS.GTVSCHS.GTVSCHS_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.MEET_SCHS_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.MEET_COMT_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.SSRMEET_SCHS_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.MEET_COMT_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.SSRMEET_SCHS_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.MEET_SCHS_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GTVSCHS.GTVSCHS.GTVSCHS_CODE	Use(select )
GTVSCHS_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
GTVSCHS_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
GTVSCHS_RG	Forms Record Group	BANNER7_FORMS.SSASCHW	Use(select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
GTVSCHSC	Package cursor	S4B70.BANINST1.GTKSCHS	Rely on () Use(select )
GTVSCHS_C	Package cursor	S4B70.BANINST1.GB_GTVSCHS	Rely on ()
GTVSCHS_C	Package cursor	S4B70.BANINST1.GB_GTVSCHS	Rely on () Use(select )
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVSCHS	Rely on ()
F_CODE_EXISTS	Package function	S4B70.BANINST1.GB_GTVSCHS	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVSCHS	Rely on ()
F_GET_DESCRIPTION	Package function	S4B70.BANINST1.GB_GTVSCHS	Rely on ()
GTVSCHS	Forms DataBlock	BANNER7_FORMS.GTVSCHS	Rely on () Use(insert,update,delete,select )
GTVSCHS	Forms DataBlock	BANNER7_FORMS_10G.GTVSCHS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVSCHS	INDEX	S4B70."GENERAL"	Rely on ()

Comments

Source Code Comments

Validation entries for Schedule Status Codes.

Columns Comments for GTVSCHS_CODE (1)

Source Code Comments

Code for Schedule Status.

Columns Comments for GTVSCHS_DESC (2)

Source Code Comments

Description of Schedule Status code.

Columns Comments for GTVSCHS_SYSTEM_REQ_IND (3)

Source Code Comments

A Y in this column indicates that the row is delivered by SCT and required for the system.

Columns Comments for GTVSCHS_ACTIVITY_DATE (4)

Source Code Comments

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

Table SCRSCHD

Schema Name SATURN
Label SCRSCHD
Server name S4B70
Creation Date 09/10/2004 00:33:55:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SCRSCHD_SUBJ_CODE	SCRSCHD_SUBJ_CODE	VARCHAR2(4)	No	*	*
SCRSCHD_CRSE_NUMB	SCRSCHD_CRSE_NUMB	VARCHAR2(5)	No	*	*
SCRSCHD_EFF_TERM	SCRSCHD_EFF_TERM	VARCHAR2(6)	No	*	*
SCRSCHD_SCHD_CODE	SCRSCHD_SCHD_CODE	VARCHAR2(3)	No	*	*
SCRSCHD_ACTIVITY_DATE	SCRSCHD_ACTIVITY_DATE	DATE	No
SCRSCHD_WORKLOAD	SCRSCHD_WORKLOAD	NUMBER(9,3)	Yes
SCRSCHD_MAX_ENRL	SCRSCHD_MAX_ENRL	NUMBER(3,0)	Yes
SCRSCHD_ADJ_WORKLOAD	SCRSCHD_ADJ_WORKLOAD	NUMBER(9,3)	Yes
SCRSCHD_INSM_CODE	SCRSCHD_INSM_CODE	VARCHAR2(5)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SCRSCHD_EFF_TERM	STVTERM_CODE	STVTERM
SCRSCHD_INSM_CODE	GTVINSM_CODE	GTVINSM
SCRSCHD_SCHD_CODE	STVSCHD_CODE	STVSCHD
SCRSCHD_SUBJ_CODE	STVSUBJ_CODE	STVSUBJ
SCRSCHD_SUBJ_CODE	SSBSECT_SUBJ_CODE	SSBSECT
SCRSCHD_CRSE_NUMB	SSBSECT_CRSE_NUMB	SSBSECT

Index

Index Name	Index Type	Column Name
PK_SCRSCHD	Unique	SCRSCHD_SUBJ_CODE
PK_SCRSCHD	Unique	SCRSCHD_CRSE_NUMB
PK_SCRSCHD	Unique	SCRSCHD_EFF_TERM
PK_SCRSCHD	Unique	SCRSCHD_SCHD_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
getSchedType	C/C++ Function	[F:\BANNER\C\SCRRFUN.PC]	Use(select )
NBB2	Cobol Paragraph	[F:\banner\cobol].SERXEREC.NBB-CALC-FTE	Use(select )
checkschd	C/C++ Function	[F:\BANNER\C\SSRROLL.PC]	Use(select )
get_fcnt_wkld	C/C++ Function	[F:\BANNER\C\SIRCTAL.PC]	Use(select )
get_workload	C/C++ Function	[F:\BANNER\C\SIRTRAL.PC]	Use(select )
get_workload2	C/C++ Function	[F:\BANNER\C\SIRTRAL.PC]	Use(select )
sel_faculty_fte1	C/C++ Function	[F:\BANNER\C\PEPAEXT.PC]	Use(select )
write_course	C/C++ Function	[F:\BANNER\C\ICGORLDI.PC]	Use(select )
SERXEREC	Cobol Program	F:\banner\cobol	Use()
ST_SCRSCHD_AR_LDI	TRIGGER	S4B70.SATURN	Rely on ()
SSRMEET	TABLE	S4B70.SATURN	Join
AS_COURSE_SCHEDULE	VIEW	S4B70.BANINST1	Use(select )
SIVCALC	VIEW	S4B70.BANINST1	Use(select )
SIVCONT	VIEW	S4B70.BANINST1	Use(select )
SIVPFAC	VIEW	S4B70.BANINST1	Use(select )
SSVSEC2	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSBSECT.SSBSECT_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_ADJ_WORKLOAD	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_MAX_ENRL	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_WORKLOAD	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_WORKLOAD	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_MAX_ENRL	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD.SCRSCHD_ADJ_WORKLOAD	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSRMEET.SSRMEET_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SSBSECT.SSBSECT_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SIALVAS.SIRLVAS.SIRLVAS_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHATCKC.SHRTCKN.SHRTCKN_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD.SCRSCHD_INSM_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SIALVAS.SIRLVAS.SIRLVAS_CRN	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHATCKC.SHRTCKN.SHRTCKN_SCHD_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SSASECT.SSRMEET.SSRMEET_SCHD_CODE	Use(select )
INST_SUMMARY	Forms Trigger	BANNER7_FORMS.SIAASGN	Use(select )
INST_SUMMARY	Forms Trigger	BANNER7_FORMS_10G.SIAASGN	Use(select )
SUM_WORKLOAD	Forms Trigger	BANNER7_FORMS.SIACONA	Use(select )
SUM_WORKLOAD	Forms Trigger	BANNER7_FORMS_10G.SIACONA	Use(select )
SCRSCHD	Forms DataBlock	BANNER7_FORMS_10G.SCACRSE	Rely on () Use(insert,update,delete,select )
SCRSCHD	Forms DataBlock	BANNER7_FORMS.SCACRSE	Rely on () Use(insert,update,delete,select )
SCRSCHD_RG	Forms Record Group	BANNER7_FORMS.SHATCKC	Use(select )
SCRSCHD_RG	Forms Record Group	BANNER7_FORMS_10G.SHATCKC	Use(select )
STQSCHDM_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
STQSCHDM_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS.SSASECT	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS_10G.ROASECT	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS_10G.SSASECT	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS_10G.SSAPREQ	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS.SSAPREQ	Use(select )
STQSCHD_RG	Forms Record Group	BANNER7_FORMS.ROASECT	Use(select )
CHECK_CRSE	Forms Trigger	BANNER7_FORMS.SSASECT.STVDAYS	Use(select )
CHECK_CRSE	Forms Trigger	BANNER7_FORMS_10G.SSASECT.STVDAYS	Use(select )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD	Use(insert,select )
INSERT_TRIG	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD	Use(insert,select )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SCACRSE.SCBCRSE	Use(delete )
ON-DELETE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(delete )
POST-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SCABASE.SCBCRKY	Use(update,select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(update,select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS_10G.SCACRSE.SCRSCHD	Use(select )
PRE-QUERY	Forms Trigger	BANNER7_FORMS.SCACRSE.SCRSCHD	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS_10G.SCABASE.SCBCRKY	Use(select )
PRE-UPDATE	Forms Trigger	BANNER7_FORMS.SCABASE.SCBCRKY	Use(select )
SETUP_PERCENTS	Forms Trigger	BANNER7_FORMS.SSASECT.SIRASGN	Use(select )
SETUP_PERCENTS	Forms Trigger	BANNER7_FORMS_10G.SSASECT.SIRASGN	Use(select )
GET_WORKLOAD	Forms Procedure	BANNER7_FORMS.SSASECT	Use(select )
GET_WORKLOAD	Forms Procedure	BANNER7_FORMS.SIAASGN	Use(select )
GET_WORKLOAD	Forms Procedure	BANNER7_FORMS_10G.SSASECT	Use(select )
GET_WORKLOAD	Forms Procedure	BANNER7_FORMS_10G.SIAASGN	Use(select )
UPDATE_PERCENT_RESP	Forms Procedure	BANNER7_FORMS.SSASECT	Use(select )
UPDATE_PERCENT_RESP	Forms Procedure	BANNER7_FORMS_10G.SSASECT	Use(select )
F_GET_SCRSCHD_ROWID	FUNCTION	S4B70.BANINST1	Use(select )
SELECT_SCRSCHD_3	Forms Function	BANNER7_FORMS.SIALVAS	Use(select )
SELECT_SCRSCHD_3	Forms Function	BANNER7_FORMS_10G.SIALVAS	Use(select )
SELECT_SCRSCHD_3	Forms Function	BANNER7_FORMS_10G.SIAASGN	Use(select )
SELECT_SCRSCHD_3	Forms Function	BANNER7_FORMS.SIAASGN	Use(select )
F_CALC_DELIVERY_SYSTEM	Package function	S4B70.BANINST1.ICSCKCOM	Use(select )
F_CALC_DELIVERY_SYSTEM	Package function	S4B70.BANINST1.ICSCKCOM	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.SB_COURSE	Use(insert )
P_CREATE	Package procedure	S4B70.BANINST1.SB_COURSE	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.SB_COURSE	Use(delete )
P_DISPLAY_COURSES	Package procedure	S4B70.BANINST1.BWCKCTLG	Rely on ()
P_DISPLAY_COURSES	Package procedure	S4B70.BANINST1.BWCKCTLG	Rely on () Use(select )
P_DISPLAY_INFO	Package procedure	S4B70.BANINST1.BWCKCTLG	Use(select )
P_VALIDATE_CHILDREN	Package procedure	S4B70.BANINST1.SB_COURSE_RULES	Rely on ()
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_FACULTY	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_ROOMDEFINITION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_GB_CLASSTIMES	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_SECTION	Use(insert,select )
UT_SETUP	Package procedure	S4B70.BANINST1.UT_SB_FACASSIGNMENT	Use(insert,select )
UT_TEARDOWN	Package procedure	S4B70.BANINST1.UT_GB_SECTION	Use(delete )
F_CALC_WORKLOAD	Package function	S4B70.BANINST1.SB_FACASSIGNMENT	Rely on ()
F_CALC_WORKLOAD	Package function	S4B70.BANINST1.SB_FACASSIGNMENT	Use(select )
F_CHECK_SCHD	Package function	S4B70.BANINST1.SB_SECTION_RULES	Use(select )
F_CHECK_SCHD	Package function	S4B70.BANINST1.GB_SECTION_RULES	Use(select )
F_GET_END_SCRSCHD_TERM	Package function	S4B70.BANINST1.SOKODSF	Use(select )
SCRSCHD	SYNONYM	S4B70.PUBLIC	Rely on ()

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SCRSCHD	INDEX	S4B70.SATURN	Rely on ()
ST_SCRSCHD_AR_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update after each row )
ST_SCRSCHD_AS_LDI	TRIGGER	S4B70.SATURN	Fire(insert,update after all rows )
ST_SCRSCHD_DELETE_ROW	TRIGGER	S4B70.SATURN	Fire(delete before each row )
ST_SCRSCHD_INSERT_ROW	TRIGGER	S4B70.SATURN	Fire(insert before each row )
ST_SCRSCHD_UPDATE_ROW	TRIGGER	S4B70.SATURN	Fire(update before each row )
GTVINSM	TABLE	S4B70."GENERAL"	Refer( No Action )
SSBSECT	TABLE	S4B70.SATURN	Join
STVSCHD	TABLE	S4B70.SATURN	Refer( No Action )
STVSUBJ	TABLE	S4B70.SATURN	Refer( No Action )
STVTERM	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Course Schedule Type Repeating Table

Columns Comments for SCRSCHD_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCRSCHD_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCRSCHD_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course schedule types becomes effective.

Columns Comments for SCRSCHD_SCHD_CODE (4)

Source Code Comments

This field defines the schedule type codes which can be authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course.

Columns Comments for SCRSCHD_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for SCRSCHD_WORKLOAD (6)

Source Code Comments

Instructional workload value for the schedule type

Columns Comments for SCRSCHD_MAX_ENRL (7)

Source Code Comments

Maximum student enrollment for workload

Columns Comments for SCRSCHD_ADJ_WORKLOAD (8)

Source Code Comments

Adjust instructional workload value for the schedule type

Columns Comments for SCRSCHD_INSM_CODE (9)

Source Code Comments

Instructional Method code: This field indicates how the course is delivered to the learner. Examples are Web based, mixed media, face to face

Table SFRSTCR

Schema Name SATURN
Label SFRSTCR
Server name S4B70
Creation Date 09/10/2004 01:06:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFRSTCR_TERM_CODE	SFRSTCR_TERM_CODE	VARCHAR2(6)	No	*	*
SFRSTCR_PIDM	SFRSTCR_PIDM	NUMBER(8,0)	No	*	*
SFRSTCR_CRN	SFRSTCR_CRN	VARCHAR2(5)	No	*	*
SFRSTCR_CLASS_SORT_KEY	SFRSTCR_CLASS_SORT_KEY	NUMBER(4,0)	Yes
SFRSTCR_REG_SEQ	SFRSTCR_REG_SEQ	NUMBER(4,0)	No
SFRSTCR_PTRM_CODE