GTVEMAL GTVLETR SABAUDF SABBTCH SABECRL SABECTM SABIDEN SABNSTU SABSTUD SABSUPL SABVWID SABXMIT SARAATT SARACMT SARACTV SARADAP SARADDR SARADHS SARADRT SARADTS SARAMCC SARAPPD SARASTA SARCHKB SARCHKL SARCHRT SARCTRL SARDCSN SARDFOS SARDNTE SARDSCL SAREFOS SAREMPL SARERUL SARETRY SAREVAL SARHCRS SARHEAD SARHLTH SARHSCH SARHSES SARHSUM SARIMMZ SARLANG SARLCOM SARLMSG SARLREC SARLXMS SARLXNO SARMATL SARMONY SARORTN SARPCOL SARPCRS SARPDEG SARPERR SARPERS SARPHON SARPRFN SARPRTN SARPSES SARPSTA SARQKER SARQUAN SARRESD SARRFNO SARRLGN SARRLST SARRQST SARRRAT SARRRCT SARRRDF SARRRFT SARRRRT SARRSRC SARTERM SARTEST SARWAAD SARWADF SARWADP SARWALT SARWAPC SARWAPF SARWAPP SARWATD SARWATR SARWSCT SARWUDQ SATAHLD SATAMAL SATARPT SMRPRLE SOBCURR SORAROL SORCCON SORCMJR SORCMNR SORELTL SORHSCH SORPCOL SPBPERS SPRIDEN

Model ERD Admissions


Model Label : ERD for Banner Student Admissions

List of Objects

Object Name Object Type Layer Name
GTVEMAL TABLE ERD
GTVLETR TABLE ERD
SABAUDF TABLE Admissions
SABBTCH TABLE Admissions
SABECRL TABLE Admissions
SABECTM TABLE Admissions
SABIDEN TABLE Admissions
SABNSTU TABLE Admissions
SABSTUD TABLE Admissions
SABSUPL TABLE Admissions
SABVWID TABLE Admissions
SABXMIT TABLE Admissions
SARAATT TABLE Admissions
SARACMT TABLE Admissions
SARACTV TABLE Admissions
SARADAP TABLE Admissions
SARADDR TABLE Admissions
SARADHS TABLE Admissions
SARADRT TABLE Admissions
SARADTS TABLE Admissions
SARAMCC TABLE Admissions
SARAPPD TABLE Admissions
SARASTA TABLE Admissions
SARCHKB TABLE Admissions
SARCHKL TABLE Admissions
SARCHRT TABLE Admissions
SARCTRL TABLE Admissions
SARDCSN TABLE Admissions
SARDFOS TABLE Admissions
SARDNTE TABLE Admissions
SARDSCL TABLE Admissions
SAREFOS TABLE Admissions
SAREMPL TABLE Admissions
SARERUL TABLE Admissions
SARETRY TABLE Admissions
SAREVAL TABLE Admissions
SARHCRS TABLE Admissions
SARHEAD TABLE Admissions
SARHLTH TABLE Admissions
SARHSCH TABLE Admissions
SARHSES TABLE Admissions
SARHSUM TABLE Admissions
SARIMMZ TABLE Admissions
SARLANG TABLE Admissions
SARLCOM TABLE Admissions
SARLMSG TABLE Admissions
SARLREC TABLE Admissions
SARLXMS TABLE Admissions
SARLXNO TABLE Admissions
SARMATL TABLE Admissions
SARMONY TABLE Admissions
SARORTN TABLE Admissions
SARPCOL TABLE Admissions
SARPCRS TABLE Admissions
SARPDEG TABLE Admissions
SARPERR TABLE Admissions
SARPERS TABLE Admissions
SARPHON TABLE Admissions
SARPRFN TABLE Admissions
SARPRTN TABLE Admissions
SARPSES TABLE Admissions
SARPSTA TABLE Admissions
SARQKER TABLE Admissions
SARQUAN TABLE Admissions
SARRESD TABLE Admissions
SARRFNO TABLE Admissions
SARRLGN TABLE Admissions
SARRLST TABLE Admissions
SARRQST TABLE Admissions
SARRRAT TABLE Admissions
SARRRCT TABLE Admissions
SARRRDF TABLE Admissions
SARRRFT TABLE Admissions
SARRRRT TABLE Admissions
SARRSRC TABLE Admissions
SARTERM TABLE Admissions
SARTEST TABLE Admissions
SARWAAD TABLE Admissions
SARWADF TABLE Admissions
SARWADP TABLE Admissions
SARWALT TABLE Admissions
SARWAPC TABLE Admissions
SARWAPF TABLE Admissions
SARWAPP TABLE Admissions
SARWATD TABLE Admissions
SARWATR TABLE Admissions
SARWSCT TABLE Admissions
SARWUDQ TABLE Admissions
SATAHLD TABLE Admissions
SATAMAL TABLE Admissions
SATARPT TABLE Admissions
SMRPRLE TABLE ERD
SOBCURR TABLE ERD
SORAROL TABLE ERD
SORCCON TABLE ERD
SORCMJR TABLE ERD
SORCMNR TABLE ERD
SORELTL TABLE ERD
SORHSCH TABLE ERD
SORPCOL TABLE ERD
SPBPERS TABLE ERD
SPRIDEN TABLE ERD

Comments

Model View

''

Table GTVEMAL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVEMAL_CODE GTVEMAL_CODE VARCHAR2(4) No *
GTVEMAL_DESC GTVEMAL_DESC VARCHAR2(60) Yes
GTVEMAL_ACTIVITY_DATE GTVEMAL_ACTIVITY_DATE DATE No
GTVEMAL_DISP_WEB_IND GTVEMAL_DISP_WEB_IND VARCHAR2(1) No
GTVEMAL_URL_IND GTVEMAL_URL_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEMAL Unique GTVEMAL_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT00.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT02.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT01.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT03.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT05.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBCT04.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBTP03.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBTP04.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBTP02.BAA-CHECK-PARMS-SECT Use(select )
BAA9 Cobol Paragraph [F:\banner\cobol].RCBTP05.BAA-CHECK-PARMS-SECT Use(select )
get_emal_disp_web_ind C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
get_emal_ind C/C++ Function [F:\BANNER\C\SRTLOAD.PC] Use(select )
get_job_parameters C/C++ Function [F:\BANNER\C\AGPMATC.PC] Use(select )
get_job_parameters C/C++ Function [F:\BANNER\C\APPDEXT.PC] Use(select )
get_valid_emal C/C++ Function [F:\BANNER\C\SARAMCV.PC] Use(select )
validate_parms C/C++ Function [F:\BANNER\C\APPCUPD.PC] Use()
RCBCT00 Cobol Program F:\banner\cobol Use()
RCBCT01 Cobol Program F:\banner\cobol Use()
RCBCT02 Cobol Program F:\banner\cobol Use()
RCBCT03 Cobol Program F:\banner\cobol Use()
RCBCT04 Cobol Program F:\banner\cobol Use()
RCBCT05 Cobol Program F:\banner\cobol Use()
RCBTP02 Cobol Program F:\banner\cobol Use()
RCBTP03 Cobol Program F:\banner\cobol Use()
RCBTP04 Cobol Program F:\banner\cobol Use()
RCBTP05 Cobol Program F:\banner\cobol Use()
GTVEMAL SYNONYM S4B70.FAISMGR Rely on ()
GTVEMAL SYNONYM S4B70.PUBLIC Rely on ()
APBWIDN TABLE S4B70.ALUMNI Refer( No Action )
GORCMSC TABLE S4B70."GENERAL" Refer( No Action )
GOREMAL TABLE S4B70."GENERAL" Refer( No Action )
ROTEMAL TABLE S4B70.FAISMGR Refer( No Action )
SARWAPP TABLE S4B70.SATURN Refer( No Action )
SMBWCRL TABLE S4B70.SATURN Refer( No Action )
SRBWPRO TABLE S4B70.SATURN Refer( No Action )
SRTEMAL TABLE S4B70.SATURN Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.SMAWCRL.SMBWCRL.SMBWCRL_FAC_EMAIL_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SMAWCRL.SMBWCRL.SMBWCRL_STU_EMAIL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAEMAL.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAERVW.APRERVW.APRERVW_EMAIL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APAIDEN.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.APASRVW.APRSRVW.APRSRVW_EMAIL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOAEMAL.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SAAWADP.SARWADP.SARWADP_VAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SPAIDEN.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOAEMAL.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOQCLIB.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAERVW.APRERVW.APRERVW_EMAIL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APASRVW.APRSRVW.APRSRVW_EMAIL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAIDEN.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.FOAIDEN.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SRAWPRO.SRBWPRO.SRBWPRO_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SPAIDEN.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SRAWPDS.SRBWPDS.SRBWPDS_VAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SAAWADP.SARWADP.SARWADP_VAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.APAEMAL.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SRAWPRO.SRBWPRO.SRBWPRO_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SRAWPDS.SRBWPDS.SRBWPDS_VAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOQCLIB.GOREMAL.GOREMAL_EMAL_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOQOLIB.GOREMAL.GOREMAL_EMAL_CODE Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.APAEMAL Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.APAERVW Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.APASRVW Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.APAWPRS Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.SRAWPDS Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.SAAWADP Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.APAEMAL Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.SMAWCRL Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.SRAWPRO Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.SPAIDEN Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.SRAWPDS Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.SAAWADP Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GUAPPRF Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GOQOLIB Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GOQCLIB Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.APASRVW Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.APAIDEN Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.APAERVW Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.FOAIDEN Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.APAWPRS Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.SPAIDEN Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.SRAWPRO Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GOAEMAL Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GORCMSC Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GUAPPRF Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS_10G.GOAMTCH Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GOQCLIB Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GOAEMAL Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GORCMSC Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GOAMTCH Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.GOQOLIB Use(select )
GTVEMAL_RG Forms Record Group BANNER7_FORMS.APAIDEN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.APAEMAL.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.APAIDEN.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GOQCLIB.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.APAIDEN.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.APAERVW.APRERVW Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.APASRVW.APRSRVW Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.FOAIDEN.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SPAIDEN.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.APAEMAL.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SPAIDEN.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GOQCLIB.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GOAEMAL.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GOAEMAL.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GOQOLIB.GOREMAL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.APAERVW.APRERVW Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.APASRVW.APRSRVW Use(select )
F_SORXREF_DESC Forms Function BANNER7_FORMS.SAAETBL Use(select )
F_SORXREF_DESC Forms Function BANNER7_FORMS_10G.SAAETBL Use(select )
EMAIL_RECORD Package Type S4B70.BANINST1.GOKSEVN Rely on ()
EMAL_TYPE Package Type S4B70.BANINST1.BWAKADVS Rely on ()
GOREMAL_LINK_TYPE Package Type S4B70.BANINST1.BWGKOADR Rely on ()
GOREMAL_LINK_TYPE Package Type S4B70.BANINST1.EFDTEST Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.EFDTEST Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.EFDTEST Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWDKCPRF Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWGKOADR Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWGKOADR Rely on ()
GETGTVEMALC Package cursor S4B70.BANINST1.BWAKALOG Rely on () Use(select )
GOREMALEMALEADDC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALEMALEADDC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALERIDC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALERIDC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALLINKC Package cursor S4B70.BANINST1.EFDTEST Use(select )
GOREMALLINKC Package cursor S4B70.BANINST1.BWGKOADR Use(select )
GOREMALVIEWC Package cursor S4B70.BANINST1.BWAKADVS Use(select )
GTVEMALC Package cursor S4B70.BANINST1.BWGKOPRF Use(select )
GTVEMALVIEWC Package cursor S4B70.BANINST1.BWDKCPRF Rely on () Use(select )
GTVEMAL_REC Package variable S4B70.BANINST1.BWLKOSAD Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWLKOSAD Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWAKALOG Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWGKOPRF Rely on ()
GTVEMAL_REC Package variable S4B70.BANINST1.BWAKALOG Rely on ()
F_CHECK_EMAL_CODE Package function S4B70.BANINST1.SAKL045 Use(select )
P_PA_GTVEMAL_EQUAL Package procedure S4B70.BANINST1.ROKPVAL Use(select )
UT_SETUP Package procedure S4B70.BANINST1.UT_GB_EMERGENCY_CONTACT Use(insert )
UT_SETUP Package procedure S4B70.BANINST1.UT_GB_CM_SOURCE_RULES Use(insert,select )
UT_SETUP Package procedure S4B70.BANINST1.UT_GB_EMAIL Use(insert )
UT_SETUP Package procedure S4B70.BANINST1.UT_GB_CM_DISPLAY_OPTIONS Use(insert,select )
GTVEMALC Package cursor S4B70.BANINST1.GTKEMAL Rely on () Use(select )
GTVEMALLISTC Package cursor S4B70.BANINST1.GOKLIBS Rely on () Use(select )
GTVEMALVIEWC Package cursor S4B70.BANINST1.EFDTEST Rely on () Use(select )
GTVEMALVIEWC Package cursor S4B70.BANINST1.BWGKOADR Rely on () Use(select )
GTVEMALWEBC Package cursor S4B70.BANINST1.EFDTEST Rely on () Use(select )
GTVEMALWEBC Package cursor S4B70.BANINST1.BWGKOADR Rely on () Use(select )
GTVEMALWEBLISTC Package cursor S4B70.BANINST1.EFDTEST Rely on () Use(select )
GTVEMALWEBLISTC Package cursor S4B70.BANINST1.BWGKOADR Rely on () Use(select )
GTVEMAL_C Package cursor S4B70.BANINST1.GB_GTVEMAL Rely on ()
GTVEMAL_C Package cursor S4B70.BANINST1.GB_GTVEMAL Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVEMAL Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVEMAL Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVEMAL Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVEMAL Rely on ()
F_GTVEMAL_EQUAL Package function S4B70.BANINST1.AOKPVAL Use(select )
F_SORXREF_CHK Package function S4B70.BANINST1.SAKPCOM Use(select )
F_SORXREF_VAL Package function S4B70.BANINST1.SAKPCOM Use(select )
GTVEMAL Forms DataBlock BANNER7_FORMS.GTVEMAL Rely on () Use(insert,update,delete,select )
GTVEMAL Forms DataBlock BANNER7_FORMS_10G.GTVEMAL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

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

Comments

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table GTVLETR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVLETR_CODE GTVLETR_CODE VARCHAR2(15) No *
GTVLETR_ACTIVITY_DATE GTVLETR_ACTIVITY_DATE DATE No
GTVLETR_DUPL_IND GTVLETR_DUPL_IND VARCHAR2(1) No
GTVLETR_DESC GTVLETR_DESC VARCHAR2(30) Yes
GTVLETR_PRINT_COMMAND GTVLETR_PRINT_COMMAND VARCHAR2(10) Yes
GTVLETR_LETR_CODE_ALT GTVLETR_LETR_CODE_ALT VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
GTVLETR_LETR_CODE_ALT GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_GTVLETR Unique GTVLETR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
check_letr_dup C/C++ Function [F:\BANNER\C\SURLOAD.PC] Use(select )
val_letr_code C/C++ Function [F:\BANNER\C\SURDELT.PC] Use(select )
val_letr_code C/C++ Function [F:\BANNER\C\SURLOAD.PC] Use(select )
C02-CONT Cobol Paragraph [F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE Use(select )
check_lcode C/C++ Function [F:\BANNER\C\AGPTLMK.PC] Use(select )
chk_no_dup_letr_exists C/C++ Function [F:\BANNER\C\RORBPST.PC] Use(select )
does_letter_allow_dups C/C++ Function [F:\BANNER\C\GLRLETR.PC] Use(select )
selletr C/C++ Function [F:\BANNER\C\AGPACKR.PC] Use(select )
test_dups C/C++ Function [F:\BANNER\C\AAPACKN.PC] Use(select )
test_dups C/C++ Function [F:\BANNER\C\AGPACKN.PC] Use(select )
test_dups_memb C/C++ Function [F:\BANNER\C\AAPACKN.PC] Use(select )
test_dups_mtch C/C++ Function [F:\BANNER\C\AGPACKN.PC] Use(select )
test_dups_recpt C/C++ Function [F:\BANNER\C\AAPACKN.PC] Use(select )
test_dups_recpt C/C++ Function [F:\BANNER\C\AGPACKN.PC] Use(select )
GTVLETR SYNONYM S4B70.FAISMGR Rely on ()
GTVLETR SYNONYM S4B70.PUBLIC Rely on ()
AABDINS TABLE S4B70.ALUMNI Refer( No Action )
AABMSHP TABLE S4B70.ALUMNI Refer( No Action )
AARACKN TABLE S4B70.ALUMNI Refer( No Action )
AARACKR TABLE S4B70.ALUMNI Refer( No Action )
AARAKCT TABLE S4B70.ALUMNI Refer( No Action )
AARAKDN TABLE S4B70.ALUMNI Refer( No Action )
AARAKEX TABLE S4B70.ALUMNI Refer( No Action )
AARAKIN TABLE S4B70.ALUMNI Refer( No Action )
AARAKMB TABLE S4B70.ALUMNI Refer( No Action )
AARDINS TABLE S4B70.ALUMNI Refer( No Action )
AARMEMB TABLE S4B70.ALUMNI Refer( No Action )
AARRLET TABLE S4B70.ALUMNI Refer( No Action )
AGBWPLG TABLE S4B70.ALUMNI Refer( No Action )
AGRACKN TABLE S4B70.ALUMNI Refer( No Action )
AGRACKR TABLE S4B70.ALUMNI Refer( No Action )
AGRAKCP TABLE S4B70.ALUMNI Refer( No Action )
AGRAKCT TABLE S4B70.ALUMNI Refer( No Action )
AGRAKDC TABLE S4B70.ALUMNI Refer( No Action )
AGRAKDG TABLE S4B70.ALUMNI Refer( No Action )
AGRAKDN TABLE S4B70.ALUMNI Refer( No Action )
AGRAKEX TABLE S4B70.ALUMNI Refer( No Action )
AGRAKGC TABLE S4B70.ALUMNI Refer( No Action )
AGRAKGT TABLE S4B70.ALUMNI Refer( No Action )
AGRAKPC TABLE S4B70.ALUMNI Refer( No Action )
AGRALET TABLE S4B70.ALUMNI Refer( No Action )
AUBINST TABLE S4B70.ALUMNI Refer( No Action )
GEBFUNC TABLE S4B70."GENERAL" Refer( No Action )
GERFCOR TABLE S4B70."GENERAL" Refer( No Action )
GLRCALC TABLE S4B70."GENERAL" Refer( No Action )
GLRCOLR TABLE S4B70."GENERAL" Refer( No Action )
GLRORDR TABLE S4B70."GENERAL" Refer( No Action )
GTVLETR TABLE S4B70."GENERAL" Refer( No Action )
GUBLETR TABLE S4B70."GENERAL" Refer( No Action )
GUBPPRF TABLE S4B70."GENERAL" Refer( No Action )
GURMAIL TABLE S4B70."GENERAL" Refer( No Action )
RBRGMSG TABLE S4B70.FAISMGR Refer( No Action )
RFRMESG TABLE S4B70.FAISMGR Refer( No Action )
RORSTRF TABLE S4B70.FAISMGR Refer( No Action )
RRRTMSG TABLE S4B70.FAISMGR Refer( No Action )
RTVSAPR TABLE S4B70.FAISMGR Refer( No Action )
SARWALT TABLE S4B70.SATURN Refer( No Action )
SHRTPRT TABLE S4B70.SATURN Refer( No Action )
SOBMATL TABLE S4B70.SATURN Refer( No Action )
SORELTL TABLE S4B70.SATURN Refer( No Action )
KEY-NEXT-ITEM Forms Trigger BANNER7_FORMS.SAAWADF.SARWADF.SARWADF_LETR_CODE_SIGNATURE Use(select )
KEY-NEXT-ITEM Forms Trigger BANNER7_FORMS_10G.SAAWADF.SARWADF.SARWADF_LETR_CODE_SIGNATURE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.AGAPREC.KEY_BLOCK.KEYBLCK_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GTVLETR.GTVLETR.GTVLETR_LETR_CODE_ALT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SUAMAIL.GURMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.ROAIMMP.RORSTAT.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PUAMAIL.PUIMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GTVLETR.GTVLETR.GTVLETR_LETR_CODE_ALT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GUALETR.KEY_BLOCK.KEYBLOC_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GUAPPRF.GUBPPRF.GUBPPRF_LETR_CODE_LETTER Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAMATL.SOBMATL.SOBMATL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SOAELTL.SORELTL.SORELTL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SAAADMS.GURMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SAADCRV.GURMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.ROAIMMP.RORSTAT.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PUAMAIL.PUIMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GUALETR.KEY_BLOCK.KEYBLOC_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GUQLETR.KEY_BLOCK.KEYBLCK_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GUAPPRF.GUBPPRF.GUBPPRF_LETR_CODE_LETTER Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GUAPPRF.GUBPPRF.GUBPPRF_LETR_CODE_EMAIL Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FUAMAIL.GURMAIL.GURMAIL_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SHATPRT.SHRTPRT_CTRL.SHRTPRT_LETR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SAAWADF.SARWADF.SARWADF_LETR_CODE_SIGNATURE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SAAWADF.SARWALT.SARWALT_LETR_CODE Use(select )
POST-CHANGE Forms Trigger