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

Model Admissions Tables


Model Label : Tables used for Banner Student Admissions

List of Objects

Object Name Object Type Layer Name
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

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 SABBTCH

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABBTCH_PIDM SABBTCH_PIDM NUMBER(8,0) No *
SABBTCH_TERM_CODE SABBTCH_TERM_CODE VARCHAR2(6) No * *
SABBTCH_APPL_NO SABBTCH_APPL_NO NUMBER(4,0) No *
SABBTCH_JOB_NAME SABBTCH_JOB_NAME VARCHAR2(7) No *
SABBTCH_ACTIVITY_DATE SABBTCH_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SABBTCH_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SABBTCH Unique SABBTCH_PIDM
PK_SABBTCH Unique SABBTCH_TERM_CODE
PK_SABBTCH Unique SABBTCH_APPL_NO
PK_SABBTCH Unique SABBTCH_JOB_NAME

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABBTCH SYNONYM S4B70.PUBLIC Rely on ()

Called objects (non escalated)

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

Comments

Source Code Comments

Admission Report Id Selection Table

Columns Comments for SABBTCH_PIDM (1)

Source Code Comments

Internal identification number of student.

Columns Comments for SABBTCH_TERM_CODE (2)

Source Code Comments

This field identifies the term for which information is to be generated.

Columns Comments for SABBTCH_APPL_NO (3)

Source Code Comments

This field identifies the application number associated with the student record.

Columns Comments for SABBTCH_JOB_NAME (4)

Source Code Comments

This field identifies the name of the job to be generated.

Columns Comments for SABBTCH_ACTIVITY_DATE (5)

Source Code Comments

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

Table SABECRL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABECRL_WAPP_CODE SABECRL_WAPP_CODE VARCHAR2(2) No * *
SABECRL_PROC_LABEL SABECRL_PROC_LABEL VARCHAR2(5) No * *
SABECRL_PROC_LABEL_DESC SABECRL_PROC_LABEL_DESC VARCHAR2(30) No
SABECRL_REQUIRED_IND SABECRL_REQUIRED_IND VARCHAR2(1) No
SABECRL_OVERRIDE_IND SABECRL_OVERRIDE_IND VARCHAR2(1) No
SABECRL_SYSTEM_REQ_IND SABECRL_SYSTEM_REQ_IND VARCHAR2(1) No
SABECRL_ACTIVITY_DATE SABECRL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SABECRL_PROC_LABEL SARPRTN_PROC_LABEL SARPRTN
SABECRL_WAPP_CODE SARPRTN_WAPP_CODE SARPRTN

Index

Index Name Index Type Column Name
PK_SABECRL Unique SABECRL_WAPP_CODE
PK_SABECRL Unique SABECRL_PROC_LABEL

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABECRL SYNONYM S4B70.PUBLIC Rely on ()
ST_SARHEAD_ASTA_INSERTS TRIGGER S4B70.SATURN Use(select )
SARRLST TABLE S4B70.SATURN Join
STVWAPP TABLE S4B70.SATURN Join
POST-CHANGE Forms Trigger BANNER7_FORMS.SAAEAPS.SARRLST.SARRLST_PROC_LABEL Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SARRLST.SARRLST_PROC_LABEL Use(select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS_10G.SAAECRL.KEY_BLOCK.COPY_BTN Use(insert,select )
WHEN-BUTTON-PRESSED Forms Trigger BANNER7_FORMS.SAAECRL.KEY_BLOCK.COPY_BTN Use(insert,select )
SABECRL_RG Forms Record Group BANNER7_FORMS_10G.SAAECRL Use(select )
SABECRL_RG Forms Record Group BANNER7_FORMS.SAAECRL Use(select )
SARRLST_PROC_RG Forms Record Group BANNER7_FORMS.SAAEAPS Use(select )
SARRLST_PROC_RG Forms Record Group BANNER7_FORMS_10G.SAAEAPS Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS_10G.SAAECRL.SARPRTN Use(select )
KEY-NXTBLK Forms Trigger BANNER7_FORMS.SAAECRL.SARPRTN Use(select )
KEY-PRVBLK Forms Trigger BANNER7_FORMS_10G.SAAECRL.SARPRTN Use(select )
KEY-PRVBLK Forms Trigger BANNER7_FORMS.SAAECRL.SARPRTN Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SAAEAPS.SARRLST Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.SAAECRL.SABECRL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SAAECRL.SABECRL Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SARRLST Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.SAAECRL.SABECRL Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.SAAECRL.SABECRL Use(select )
CHECK_PROC_OVERRIDE Forms Function BANNER7_FORMS.SAAEAPS Use(select )
CHECK_PROC_OVERRIDE Forms Function BANNER7_FORMS_10G.SAAEAPS Use(select )
CHK_PROC_REQ Forms Function BANNER7_FORMS_10G.SAAWADF Use(select )
CHK_PROC_REQ Forms Function BANNER7_FORMS_10G.SAAECRL Use(select )
CHK_PROC_REQ Forms Function BANNER7_FORMS.SAAECRL Use(select )
CHK_PROC_REQ Forms Function BANNER7_FORMS.SAAWADF Use(select )
P_RESULTS_INSERT Package procedure S4B70.BANINST1.SAKPCOM Use(select )
F_CHECK_OVERRIDE Package function S4B70.BANINST1.SAKPCOM Use(select )
SABECRL Forms DataBlock BANNER7_FORMS_10G.SAAECRL Rely on () Use(insert,update,delete,select )
SABECRL Forms DataBlock BANNER7_FORMS.SAAECRL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABECRL INDEX S4B70.SATURN Rely on ()
SARPRTN TABLE S4B70.SATURN Join

Comments

Source Code Comments

Electronic Admissions Control Table

Columns Comments for SABECRL_WAPP_CODE (1)

Source Code Comments

Web Application Code

Columns Comments for SABECRL_PROC_LABEL (2)

Source Code Comments

Procedure Label

Columns Comments for SABECRL_PROC_LABEL_DESC (3)

Source Code Comments

Procedure Label Description

Columns Comments for SABECRL_REQUIRED_IND (4)

Source Code Comments

Procedure Required Indicator

Columns Comments for SABECRL_OVERRIDE_IND (5)

Source Code Comments

Procedure Over-Ride Indicator

Columns Comments for SABECRL_SYSTEM_REQ_IND (6)

Source Code Comments

System Requirement Indicator

Columns Comments for SABECRL_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Table SABECTM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABECTM_START_DATE SABECTM_START_DATE DATE No *
SABECTM_END_DATE SABECTM_END_DATE DATE No
SABECTM_TERM_CODE SABECTM_TERM_CODE VARCHAR2(6) No
SABECTM_ACTIVITY_DATE SABECTM_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_SABECTM Unique SABECTM_START_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
SABECTM SYNONYM S4B70.PUBLIC Rely on ()
CHK_DATE Forms Function BANNER7_FORMS.SAAECTM Use(select )
CHK_DATE Forms Function BANNER7_FORMS_10G.SAAECTM Use(select )
GET_TERM Forms Function BANNER7_FORMS.SAAECTM Use(select )
GET_TERM Forms Function BANNER7_FORMS_10G.SAAECTM Use(select )
SABECTM Forms DataBlock BANNER7_FORMS.SAAECTM Rely on () Use(insert,update,delete,select )
SABECTM Forms DataBlock BANNER7_FORMS_10G.SAAECTM Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABECTM INDEX S4B70.SATURN Rely on ()

Comments

Source Code Comments

EDI Cross-Reference Term Code Rules

Columns Comments for SABECTM_START_DATE (1)

Source Code Comments

Starting Date of Date Range for associated Term

Columns Comments for SABECTM_END_DATE (2)

Source Code Comments

End Date of Date Range for associated Term

Columns Comments for SABECTM_TERM_CODE (3)

Source Code Comments

Term associated with the Date Range

Columns Comments for SABECTM_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table SABIDEN

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABIDEN_AIDM SABIDEN_AIDM NUMBER(8,0) No * *
SABIDEN_PIDM SABIDEN_PIDM NUMBER(8,0) No
SABIDEN_SRCE_IND SABIDEN_SRCE_IND VARCHAR2(1) No
SABIDEN_ACTIVITY_DATE SABIDEN_ACTIVITY_DATE DATE No
SABIDEN_ID_EDI SABIDEN_ID_EDI VARCHAR2(9) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SABIDEN_AIDM SARHEAD_AIDM SARHEAD

Index

Index Name Index Type Column Name
PK_SABIDEN Unique SABIDEN_AIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
create_sabiden C/C++ Function [F:\BANNER\C\SARETMT.PC] Use(insert,select )
purge_process C/C++ Function [F:\BANNER\C\SARETPG.PC] Use(delete )
selbanid C/C++ Function [F:\BANNER\C\SARETMT.PC] Use(select )
seliden C/C++ Function [F:\BANNER\C\SARETPG.PC] Use(select )
SABIDEN SYNONYM S4B70.PUBLIC Rely on ()
ST_SABSTUD_PSTA_INSERTS TRIGGER S4B70.SATURN Use(insert )
SAVEAP1 VIEW S4B70.BANINST1 Use(select )
CREATE_PERSON Forms Trigger BANNER7_FORMS.SAAEAPS.SPAIDEN_ENTRY Use(insert )
CREATE_PERSON Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SPAIDEN_ENTRY Use(insert )
CREATE_PERSONX Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SPAIDEN_ENTRY Use(insert )
KEY-DELREC Forms Trigger BANNER7_FORMS.SAAEAPS.SAVHEAD Use(delete )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SAVHEAD Use(delete )
SABIDEN_INSERT Forms Trigger BANNER7_FORMS.SAAEAPS.SARPSTA Use(insert )
SABIDEN_INSERT Forms Trigger BANNER7_FORMS_10G.SAAEAPS.SARPSTA Use(insert )
CHECK_SABIDEN Forms Function BANNER7_FORMS.SAAEAPS Use(select )
CHECK_SABIDEN Forms Function BANNER7_FORMS_10G.SAAEAPS Use(select )
CHK_SABIDEN Forms Function BANNER7_FORMS.SAAEAPS Use(select )
CHK_SABIDEN Forms Function BANNER7_FORMS_10G.SAAEAPS Use(select )
GET_PIDM Forms Function BANNER7_FORMS.SRQMTCH Use(select )
GET_PIDM Forms Function BANNER7_FORMS_10G.SAAETBL Use(select )
GET_PIDM Forms Function BANNER7_FORMS.SAAETBL Use(select )
GET_PIDM Forms Function BANNER7_FORMS.SOQMTCH Use(select )
GET_PIDM Forms Function BANNER7_FORMS_10G.SOQMTCH Use(select )
GET_PIDM Forms Function BANNER7_FORMS_10G.SRQMTCH Use(select )
GET_PIDMA Forms Function BANNER7_FORMS.SAAEAPS Use(select )
GET_PIDMA Forms Function BANNER7_FORMS_10G.SAAEAPS Use(select )
P_P010_CHECK Package procedure S4B70.BANINST1.SAKP010 Use(select )
GETSABIDENAIDMC Package cursor S4B70.BANINST1.BWSKASTA Use(select )
GETSABIDENAIDMC Package cursor S4B70.BANINST1.BWSKALOG Use(select )
GETSABIDENC Package cursor S4B70.BANINST1.BWSKAPMT Use(select )
GETSABIDENC Package cursor S4B70.BANINST1.BWSKALOG Use(select )
AIDM Package variable S4B70.BANINST1.BWSKAPMT Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKASTA Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKAPMT Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKASTA Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKALOG Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKAPMT Rely on ()
SABIDEN_REC Package variable S4B70.BANINST1.BWSKALOG Rely on ()
P_INSERT_SABIDEN Package procedure S4B70.BANINST1.SAKMODS Use(insert,select )
P_PROCLOGINNON Package procedure S4B70.BANINST1.BWSKALOG Use(insert )
P_REGISTERNOW Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
P_REGISTERNOW Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
P_UPDATEGOBTPAC Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
P_UPDATEGOBTPAC Package procedure S4B70.BANINST1.BWSKALOG Rely on ()
GETCHOICESC Package cursor S4B70.BANINST1.BWSKALOG Use(select )
SARHEADC Package cursor S4B70.BANINST1.SAKLIBS Use(select )
SARHEAD_NOT_REVIEWED_C Package cursor S4B70.BANINST1.SAKLIBS Rely on ()
SARHEAD_NOT_REVIEWED_C Package cursor S4B70.BANINST1.SAKLIBS Use(select )
F_CHECK_SECURED_SIDE Package function S4B70.BANINST1.SAKQADM Use(select )
F_GETAIDMSTU Package function S4B70.BANINST1.BWSKALOG Rely on ()
F_GETAIDMSTU Package function S4B70.BANINST1.BWSKALOG Rely on ()
F_GET_PIDM Package function S4B70.BANINST1.SAKPCOM Use(select )
F_SABIDEN_CHK Package function S4B70.BANINST1.SAKPCOM Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SABIDEN INDEX S4B70.SATURN Rely on ()
SARHEAD TABLE S4B70.SATURN Join

Comments

Source Code Comments

Person ID Control Table

Columns Comments for SABIDEN_AIDM (1)

Source Code Comments

Person Reference Number

Columns Comments for SABIDEN_PIDM (2)

Source Code Comments

Person PIDM Reference

Columns Comments for SABIDEN_SRCE_IND (3)

Source Code Comments

Source of Record

Columns Comments for SABIDEN_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for SABIDEN_ID_EDI (5)

Source Code Comments

EDI ID

Table SABNSTU

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABNSTU_ID SABNSTU_ID VARCHAR2(9) No *
SABNSTU_AIDM SABNSTU_AIDM NUMBER(8,0) No *
SABNSTU_LOCKED_IND SABNSTU_LOCKED_IND VARCHAR2(1) No
SABNSTU_ACTIVITY_DATE SABNSTU_ACTIVITY_DATE DATE