RORCRHR RPRCLSS SARADAP SARCHKB SARDCSN SARQKER SARRRFT SARWAAD SCRLEVL SCRRTST SDBDEGR SFBCREQ SFRFREQ SFRMHRS SFRRGFE SFRSTCR SFRTMSL SFRTMST SFTREGS SGBSTDN SGRASSI SGRCLSR SGRCOOP SGRDUTY SHBGEDI SHBGSCH SHBRPTR SHRASDL SHRASGE SHRASTR SHRCAST SHRCGDR SHRDGMR SHREGPA SHREVNT SHRGPAC SHRGPAL SHRGRDE SHRGRDO SHRGRDS SHRIPED SHRLGDR SHRLGPA SHRLGSC SHRNCRS SHRPREV SHRPRGE SHRRPEQ SHRTCKL SHRTGPA SHRTMCM SHRTRAM SHRTRCE SHRTRTA SHRTRTK SHRTTCM SHTTRTC SMRACLV SMRALIB SMRALVL SMRARLV SMRGCLV SMRGLIB SMRGLVL SMRGRLV SMRPCRS SMRPLVL SMRPRLE SMRRQCM SMRSACL SMRSALV SMRSARL SMRSGCL SMRSGLV SMRSGRL SMRSPLV SOBCURR SORCCOL SORCOMM SOREQUI SORLCUR SORT22A SRBPRED SRBRECR SRTPREL SSBDFEE SSRFEES SSRRESV SSRRLVL SSRRTST STVLEVL STVWAPP TBRIALV

Model STVLEVL


Model Label : Banner STVLEVL ERD
Path : Default Folder/B70/Common/STVLEVL

List of Objects

Object Name Object Type Layer Name
RORCRHR TABLE ERD
RPRCLSS TABLE ERD
SARADAP TABLE ERD
SARCHKB TABLE ERD
SARDCSN TABLE ERD
SARQKER TABLE ERD
SARRRFT TABLE ERD
SARWAAD TABLE ERD
SCRLEVL TABLE ERD
SCRRTST TABLE ERD
SDBDEGR TABLE ERD
SFBCREQ TABLE ERD
SFRFREQ TABLE ERD
SFRMHRS TABLE ERD
SFRRGFE TABLE ERD
SFRSTCR TABLE ERD
SFRTMSL TABLE ERD
SFRTMST TABLE ERD
SFTREGS TABLE ERD
SGBSTDN TABLE ERD
SGRASSI TABLE ERD
SGRCLSR TABLE ERD
SGRCOOP TABLE ERD
SGRDUTY TABLE ERD
SHBGEDI TABLE ERD
SHBGSCH TABLE ERD
SHBRPTR TABLE ERD
SHRASDL TABLE ERD
SHRASGE TABLE ERD
SHRASTR TABLE ERD
SHRCAST TABLE ERD
SHRCGDR TABLE ERD
SHRDGMR TABLE ERD
SHREGPA TABLE ERD
SHREVNT TABLE ERD
SHRGPAC TABLE ERD
SHRGPAL TABLE ERD
SHRGRDE TABLE ERD
SHRGRDO TABLE ERD
SHRGRDS TABLE ERD
SHRIPED TABLE ERD
SHRLGDR TABLE ERD
SHRLGPA TABLE ERD
SHRLGSC TABLE ERD
SHRNCRS TABLE ERD
SHRPREV TABLE ERD
SHRPRGE TABLE ERD
SHRRPEQ TABLE ERD
SHRTCKL TABLE ERD
SHRTGPA TABLE ERD
SHRTMCM TABLE ERD
SHRTRAM TABLE ERD
SHRTRCE TABLE ERD
SHRTRTA TABLE ERD
SHRTRTK TABLE ERD
SHRTTCM TABLE ERD
SHTTRTC TABLE ERD
SMRACLV TABLE ERD
SMRALIB TABLE ERD
SMRALVL TABLE ERD
SMRARLV TABLE ERD
SMRGCLV TABLE ERD
SMRGLIB TABLE ERD
SMRGLVL TABLE ERD
SMRGRLV TABLE ERD
SMRPCRS TABLE ERD
SMRPLVL TABLE ERD
SMRPRLE TABLE ERD
SMRRQCM TABLE ERD
SMRSACL TABLE ERD
SMRSALV TABLE ERD
SMRSARL TABLE ERD
SMRSGCL TABLE ERD
SMRSGLV TABLE ERD
SMRSGRL TABLE ERD
SMRSPLV TABLE ERD
SOBCURR TABLE ERD
SORCCOL TABLE ERD
SORCOMM TABLE ERD
SOREQUI TABLE ERD
SORLCUR TABLE ERD
SORT22A TABLE ERD
SRBPRED TABLE ERD
SRBRECR TABLE ERD
SRTPREL TABLE ERD
SSBDFEE TABLE ERD
SSRFEES TABLE ERD
SSRRESV TABLE ERD
SSRRLVL TABLE ERD
SSRRTST TABLE ERD
STVLEVL TABLE Tables
STVWAPP TABLE ERD
TBRIALV TABLE ERD

Comments

Model View

''

Table RORCRHR

Schema Name FAISMGR
Label RORCRHR
Server name S4B70
Creation Date 09/29/2003 12:14:17:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORCRHR_AIDY_CODE RORCRHR_AIDY_CODE VARCHAR2(4) No * *
RORCRHR_LEVL_CODE RORCRHR_LEVL_CODE VARCHAR2(2) No * *
RORCRHR_TERM_CODE RORCRHR_TERM_CODE VARCHAR2(6) No * *
RORCRHR_ACTIVITY_DATE RORCRHR_ACTIVITY_DATE DATE No
RORCRHR_FULL_TIME_CR_HRS RORCRHR_FULL_TIME_CR_HRS NUMBER(9,3) Yes
RORCRHR_3QUARTER_CR_HRS RORCRHR_3QUARTER_CR_HRS NUMBER(9,3) Yes
RORCRHR_HALF_TIME_CR_HRS RORCRHR_HALF_TIME_CR_HRS NUMBER(9,3) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RORCRHR_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RORCRHR_LEVL_CODE STVLEVL_CODE STVLEVL
RORCRHR_TERM_CODE STVTERM_CODE STVTERM
RORCRHR_TERM_CODE SFRSTCR_TERM_CODE SFRSTCR
RORCRHR_LEVL_CODE SFRSTCR_LEVL_CODE SFRSTCR
RORCRHR_LEVL_CODE SGBSTDN_LEVL_CODE SGBSTDN

Index

Index Name Index Type Column Name
PK_RORCRHR Unique RORCRHR_AIDY_CODE
PK_RORCRHR Unique RORCRHR_LEVL_CODE
PK_RORCRHR Unique RORCRHR_TERM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
UCL7 Cobol Paragraph [F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD Use(select )
UCL7 Cobol Paragraph [F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD Use(select )
check_curterm C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
check_preterm C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
chk_enrl_hrs C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
find_candidate C/C++ Function [F:\BANNER\C\RRREXIT.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL00.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL01.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL02.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL03.PC] Use(select )
sel_fa_term_count C/C++ Function [F:\BANNER\C\RERPL04.PC] Use(select )
sel_rorcrhr C/C++ Function [F:\BANNER\C\RRRAREQ.PC] Use(select )
select_enrollments C/C++ Function [F:\BANNER\C\RPBLMIE.PC] Use(select )
RORENRL TABLE S4B70.FAISMGR Join
NEW_RECORD_3 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_3 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_4 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_4 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_5 Forms Trigger BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_5 Forms Trigger BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR01 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR02 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR03 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR00 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR02 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR05 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR03 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS_10G.REAOR04 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR04 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAPV99 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAPV98 Use(select )
NEW_RECORD_2A Forms Procedure BANNER7_FORMS.REAOR05 Use(select )
F_GET_DEFAULT_ENROLL_STATUS Package function S4B70.BANINST1.RPKLOAN Rely on ()
P_CALC_LOAN_ENROLL_STATUS Package procedure S4B70.BANINST1.RPKLOAN Rely on ()
P_CALC_LOAN_ENROLL_STATUS Package procedure S4B70.BANINST1.RPKLOAN Use(select )
RORCRHR SYNONYM S4B70.PUBLIC Rely on ()
RORCRHR Forms DataBlock BANNER7_FORMS_10G.ROAINST Rely on () Use(insert,update,delete,select )
RORCRHR Forms DataBlock BANNER7_FORMS.ROAINST Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_RORCRHR INDEX S4B70.FAISMGR Rely on ()
ROBINST TABLE S4B70.FAISMGR Refer( No Action )
SFRSTCR TABLE S4B70.SATURN Join
SGBSTDN TABLE S4B70.SATURN Join
STVLEVL TABLE S4B70.SATURN Refer( No Action )
STVTERM TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Credit Hours Table

Columns Comments for RORCRHR_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RORCRHR_LEVL_CODE (2)

Source Code Comments

LEVEL CODE: This field identifies the educational level associated with the valid credit hours.

Columns Comments for RORCRHR_TERM_CODE (3)

Source Code Comments

TERM CODE: This field represents the valid term code associated with the credit hours listed.

Columns Comments for RORCRHR_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RORCRHR_FULL_TIME_CR_HRS (5)

Source Code Comments

FULL TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled full time.

Columns Comments for RORCRHR_3QUARTER_CR_HRS (6)

Source Code Comments

THREE QUARTER CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled to be considered three quarter time.

Columns Comments for RORCRHR_HALF_TIME_CR_HRS (7)

Source Code Comments

HALF TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled on a half time basis.

Table RPRCLSS

Schema Name FAISMGR
Label RPRCLSS
Server name S4B70
Creation Date 06/21/2004 11:49:28:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRCLSS_AIDY_CODE RPRCLSS_AIDY_CODE VARCHAR2(4) No *
RPRCLSS_LEVL_CODE RPRCLSS_LEVL_CODE VARCHAR2(2) No *
RPRCLSS_FINAID_CLASS RPRCLSS_FINAID_CLASS VARCHAR2(1) No
RPRCLSS_ACTIVITY_DATE RPRCLSS_ACTIVITY_DATE DATE No
RPRCLSS_CLAS_CODE RPRCLSS_CLAS_CODE VARCHAR2(2) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RPRCLSS_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RPRCLSS_LEVL_CODE STVLEVL_CODE STVLEVL

Index

Index Name Index Type Column Name
RPRCLSS_KEY_INDEX Unique RPRCLSS_AIDY_CODE
RPRCLSS_KEY_INDEX Unique RPRCLSS_LEVL_CODE
RPRCLSS_KEY_INDEX Unique RPRCLSS_CLAS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
UVD3A-CHECK-OFFICIAL Cobol Paragraph [F:\banner\cobol].RPBVLDT.UVD-VALIDATE-DISBURSEMENTS Use(select )
UVD3A-CHECK-OFFICIAL Cobol Paragraph [F:\banner\cobol].RPEDISB.UVD-VALIDATE-DISBURSEMENTS Use(select )
execute_packaging_roll C/C++ Function [F:\BANNER\C\ROPROLL.PC] Use(insert,select )
get_class_code C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
sel_fa_clas_code C/C++ Function [F:\BANNER\C\RRRAREQ.PC] Use(select )
select_rprclss C/C++ Function [F:\BANNER\C\RPRELAP.PC] Use(select )
GET_CLASS_CODE Forms Trigger BANNER7_FORMS_10G.RPALAPP.RPRLCRT Use(select )
GET_CLASS_CODE Forms Trigger BANNER7_FORMS.RPALAPP.RPRLCRT Use(select )
GET_CLASS_CODE Forms Trigger BANNER7_FORMS_10G.RPAELAP.RPRLCRT Use(select )
GET_CLASS_CODE Forms Trigger BANNER7_FORMS.RPAELAP.RPRLCRT Use(select )
RPRCLSS SYNONYM S4B70.PUBLIC Rely on ()
RPRCLSS Forms DataBlock BANNER7_FORMS.RPRCLSS Rely on () Use(insert,update,delete,select )
RPRCLSS Forms DataBlock BANNER7_FORMS_10G.RPRCLSS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
RPRCLSS_KEY_INDEX INDEX S4B70.FAISMGR Rely on ()
ROBINST TABLE S4B70.FAISMGR Refer( No Action )
STVLEVL TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Class Code Translation Table

Columns Comments for RPRCLSS_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year associated with the information in this record.

Columns Comments for RPRCLSS_LEVL_CODE (2)

Source Code Comments

LEVEL CODE: This field identifies the Student System level code and associates it to the Student System Class code and Financial Aid Class Code.

Columns Comments for RPRCLSS_FINAID_CLASS (3)

Source Code Comments

FINANCIAL AID CLASS CODE: This field identifies the Financial Aid Class Code as associated with the Student System Level Code and Class Code. Beginning with 2001-2002, the Banner Year in College, which is converted from EDE values, is used for the Financial Aid Class Code.

Columns Comments for RPRCLSS_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the information in this record was entered or last updated.

Columns Comments for RPRCLSS_CLAS_CODE (5)

Source Code Comments

CLASS CODE: This optional field associates the Student System Class Code and Level Code to the Financial Aid Class Code.

Table SARADAP

Schema Name SATURN
Label SARADAP
Server name S4B70
Creation Date 09/09/2004 23:42:29:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SARADAP_PIDM SARADAP_PIDM NUMBER(8,0) No * *
SARADAP_TERM_CODE_ENTRY SARADAP_TERM_CODE_ENTRY VARCHAR2(6) No * *
SARADAP_APPL_NO SARADAP_APPL_NO NUMBER(2,0) No * *
SARADAP_LEVL_CODE SARADAP_LEVL_CODE VARCHAR2(2) Yes *
SARADAP_APPL_DATE SARADAP_APPL_DATE DATE No
SARADAP_APST_CODE SARADAP_APST_CODE VARCHAR2(1) No *
SARADAP_APST_DATE SARADAP_APST_DATE DATE No
SARADAP_MAINT_IND SARADAP_MAINT_IND VARCHAR2(1) No
SARADAP_ADMT_CODE SARADAP_ADMT_CODE VARCHAR2(2) Yes *
SARADAP_STYP_CODE SARADAP_STYP_CODE VARCHAR2(1) No *
SARADAP_CAMP_CODE SARADAP_CAMP_CODE VARCHAR2(3) Yes *
SARADAP_SITE_CODE SARADAP_SITE_CODE VARCHAR2(3) Yes *
SARADAP_COLL_CODE_1 SARADAP_COLL_CODE_1 VARCHAR2(2) Yes *
SARADAP_DEGC_CODE_1 SARADAP_DEGC_CODE_1 VARCHAR2(6) Yes *
SARADAP_MAJR_CODE_1 SARADAP_MAJR_CODE_1 VARCHAR2(4) Yes *
SARADAP_COLL_CODE_2 SARADAP_COLL_CODE_2 VARCHAR2(2) Yes *
SARADAP_DEGC_CODE_2 SARADAP_DEGC_CODE_2 VARCHAR2(6) Yes *
SARADAP_MAJR_CODE_2 SARADAP_MAJR_CODE_2 VARCHAR2(4) Yes *
SARADAP_RESD_CODE SARADAP_RESD_CODE VARCHAR2(1) No *
SARADAP_FULL_PART_IND SARADAP_FULL_PART_IND VARCHAR2(1) Yes
SARADAP_SESS_CODE SARADAP_SESS_CODE VARCHAR2(1) Yes *
SARADAP_WRSN_CODE SARADAP_WRSN_CODE VARCHAR2(2) Yes *
SARADAP_INTV_CODE SARADAP_INTV_CODE VARCHAR2(1) Yes *
SARADAP_FEE_IND SARADAP_FEE_IND VARCHAR2(1) Yes
SARADAP_FEE_DATE SARADAP_FEE_DATE DATE Yes
SARADAP_ACTIVITY_DATE SARADAP_ACTIVITY_DATE DATE No
SARADAP_RATE_CODE SARADAP_RATE_CODE VARCHAR2(5) Yes *
SARADAP_EGOL_CODE SARADAP_EGOL_CODE VARCHAR2(2) Yes *
SARADAP_EDLV_CODE SARADAP_EDLV_CODE VARCHAR2(3) Yes *
SARADAP_MAJR_CODE_CONC_1 SARADAP_MAJR_CODE_CONC_1 VARCHAR2(4) Yes *
SARADAP_DEPT_CODE SARADAP_DEPT_CODE VARCHAR2(4) Yes *
SARADAP_SBGI_CODE SARADAP_SBGI_CODE VARCHAR2(6) Yes *
SARADAP_RECR_CODE SARADAP_RECR_CODE VARCHAR2(3) Yes *
SARADAP_RTYP_CODE SARADAP_RTYP_CODE VARCHAR2(2) Yes *
SARADAP_DEPT_CODE_2 SARADAP_DEPT_CODE_2 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_2 SARADAP_MAJR_CODE_CONC_2 VARCHAR2(4) Yes *
SARADAP_PROGRAM_1 SARADAP_PROGRAM_1 VARCHAR2(12) Yes *
SARADAP_TERM_CODE_CTLG_1 SARADAP_TERM_CODE_CTLG_1 VARCHAR2(6) Yes *
SARADAP_MAJR_CODE_1_2 SARADAP_MAJR_CODE_1_2 VARCHAR2(4) Yes *
SARADAP_DEPT_CODE_1_2 SARADAP_DEPT_CODE_1_2 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_1_2 SARADAP_MAJR_CODE_CONC_1_2 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_1_3 SARADAP_MAJR_CODE_CONC_1_3 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_121 SARADAP_MAJR_CODE_CONC_121 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_122 SARADAP_MAJR_CODE_CONC_122 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_123 SARADAP_MAJR_CODE_CONC_123 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_MINR_1_1 SARADAP_MAJR_CODE_MINR_1_1 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_MINR_1_2 SARADAP_MAJR_CODE_MINR_1_2 VARCHAR2(4) Yes *
SARADAP_PROGRAM_2 SARADAP_PROGRAM_2 VARCHAR2(12) Yes *
SARADAP_TERM_CODE_CTLG_2 SARADAP_TERM_CODE_CTLG_2 VARCHAR2(6) Yes *
SARADAP_LEVL_CODE_2 SARADAP_LEVL_CODE_2 VARCHAR2(2) Yes *
SARADAP_CAMP_CODE_2 SARADAP_CAMP_CODE_2 VARCHAR2(3) Yes *
SARADAP_MAJR_CODE_2_2 SARADAP_MAJR_CODE_2_2 VARCHAR2(4) Yes *
SARADAP_DEPT_CODE_2_2 SARADAP_DEPT_CODE_2_2 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_211 SARADAP_MAJR_CODE_CONC_211 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_212 SARADAP_MAJR_CODE_CONC_212 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_213 SARADAP_MAJR_CODE_CONC_213 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_221 SARADAP_MAJR_CODE_CONC_221 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_222 SARADAP_MAJR_CODE_CONC_222 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_CONC_223 SARADAP_MAJR_CODE_CONC_223 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_MINR_2_1 SARADAP_MAJR_CODE_MINR_2_1 VARCHAR2(4) Yes *
SARADAP_MAJR_CODE_MINR_2_2 SARADAP_MAJR_CODE_MINR_2_2 VARCHAR2(4) Yes *
SARADAP_CURR_RULE_1 SARADAP_CURR_RULE_1 NUMBER(8,0) Yes *
SARADAP_CMJR_RULE_1_1 SARADAP_CMJR_RULE_1_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_11_1 SARADAP_CCON_RULE_11_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_11_2 SARADAP_CCON_RULE_11_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_11_3 SARADAP_CCON_RULE_11_3 NUMBER(8,0) Yes *
SARADAP_CMJR_RULE_1_2 SARADAP_CMJR_RULE_1_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_12_1 SARADAP_CCON_RULE_12_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_12_2 SARADAP_CCON_RULE_12_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_12_3 SARADAP_CCON_RULE_12_3 NUMBER(8,0) Yes *
SARADAP_CMNR_RULE_1_1 SARADAP_CMNR_RULE_1_1 NUMBER(8,0) Yes *
SARADAP_CMNR_RULE_1_2 SARADAP_CMNR_RULE_1_2 NUMBER(8,0) Yes *
SARADAP_CURR_RULE_2 SARADAP_CURR_RULE_2 NUMBER(8,0) Yes *
SARADAP_CMJR_RULE_2_1 SARADAP_CMJR_RULE_2_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_21_1 SARADAP_CCON_RULE_21_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_21_2 SARADAP_CCON_RULE_21_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_21_3 SARADAP_CCON_RULE_21_3 NUMBER(8,0) Yes *
SARADAP_CMJR_RULE_2_2 SARADAP_CMJR_RULE_2_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_22_1 SARADAP_CCON_RULE_22_1 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_22_2 SARADAP_CCON_RULE_22_2 NUMBER(8,0) Yes *
SARADAP_CCON_RULE_22_3 SARADAP_CCON_RULE_22_3 NUMBER(8,0) Yes *
SARADAP_CMNR_RULE_2_1 SARADAP_CMNR_RULE_2_1 NUMBER(8,0) Yes *
SARADAP_CMNR_RULE_2_2 SARADAP_CMNR_RULE_2_2 NUMBER(8,0) Yes *
SARADAP_WEB_ACCT_MISC_IND SARADAP_WEB_ACCT_MISC_IND VARCHAR2(1) Yes
SARADAP_WEB_CASHIER_USER SARADAP_WEB_CASHIER_USER VARCHAR2(30) Yes
SARADAP_WEB_TRANS_NO SARADAP_WEB_TRANS_NO NUMBER(8,0) Yes
SARADAP_WEB_AMOUNT SARADAP_WEB_AMOUNT NUMBER(12,2) Yes
SARADAP_WEB_RECEIPT_NUMBER SARADAP_WEB_RECEIPT_NUMBER NUMBER(8,0) Yes
SARADAP_WAIV_CODE SARADAP_WAIV_CODE VARCHAR2(4) Yes *
SARADAP_DATA_ORIGIN SARADAP_DATA_ORIGIN VARCHAR2(30) Yes
SARADAP_USER_ID SARADAP_USER_ID VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SARADAP_CCON_RULE_22_1 SORCCON_CCON_RULE SORCCON
SARADAP_MAJR_CODE_MINR_1_2 STVMAJR_CODE STVMAJR
SARADAP_CCON_RULE_22_2 SORCCON_CCON_RULE SORCCON
SARADAP_MAJR_CODE_2_2 STVMAJR_CODE STVMAJR
SARADAP_CCON_RULE_22_3 SORCCON_CCON_RULE SORCCON
SARADAP_MAJR_CODE_CONC_1_3 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_221 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_222 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_223 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_MINR_1_1 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_213 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_MINR_2_1 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_212 STVMAJR_CODE STVMAJR
SARADAP_PROGRAM_1 SMRPRLE_PROGRAM SMRPRLE
SARADAP_CURR_RULE_1 SOBCURR_CURR_RULE SOBCURR
SARADAP_CCON_RULE_11_1 SORCCON_CCON_RULE SORCCON
SARADAP_CMJR_RULE_1_1 SORCMJR_CMJR_RULE SORCMJR
SARADAP_CMNR_RULE_1_1 SORCMNR_CMNR_RULE SORCMNR
SARADAP_ADMT_CODE STVADMT_CODE STVADMT
SARADAP_APST_CODE STVAPST_CODE STVAPST
SARADAP_CAMP_CODE STVCAMP_CODE STVCAMP
SARADAP_COLL_CODE_1 STVCOLL_CODE STVCOLL
SARADAP_DEGC_CODE_1 STVDEGC_CODE STVDEGC
SARADAP_DEPT_CODE STVDEPT_CODE STVDEPT
SARADAP_EDLV_CODE STVEDLV_CODE STVEDLV
SARADAP_EGOL_CODE STVEGOL_CODE STVEGOL
SARADAP_INTV_CODE STVINTV_CODE STVINTV
SARADAP_LEVL_CODE STVLEVL_CODE STVLEVL
SARADAP_MAJR_CODE_1 STVMAJR_CODE STVMAJR
SARADAP_RATE_CODE STVRATE_CODE STVRATE
SARADAP_RESD_CODE STVRESD_CODE STVRESD
SARADAP_RTYP_CODE STVRTYP_CODE STVRTYP
SARADAP_SESS_CODE STVSESS_CODE STVSESS
SARADAP_STYP_CODE STVSTYP_CODE STVSTYP
SARADAP_TERM_CODE_ENTRY STVTERM_CODE STVTERM
SARADAP_WAIV_CODE STVWAIV_CODE STVWAIV
SARADAP_WRSN_CODE STVWRSN_CODE STVWRSN
SARADAP_MAJR_CODE_MINR_2_2 STVMAJR_CODE STVMAJR
SARADAP_MAJR_CODE_CONC_211 STVMAJR_CODE STVMAJR
SARADAP_PROGRAM_2 SMRPRLE_PROGRAM SMRPRLE
SARADAP_CURR_RULE_2 SOBCURR_CURR_RULE SOBCURR
SARADAP_CCON_RULE_11_2 SORCCON_CCON_RULE SORCCON
SARADAP_CMJR_RULE_1_2 SORCMJR_CMJR_RULE SORCMJR
SARADAP_CMNR_RULE_1_2 SORCMNR_CMNR_RULE SORCMNR
SARADAP_CAMP_CODE_2 STVCAMP_CODE STVCAMP
SARADAP_COLL_CODE_2 STVCOLL_CODE STVCOLL
SARADAP_DEGC_CODE_2 STVDEGC_CODE STVDEGC
SARADAP_DEPT_CODE_2 STVDEPT_CODE STVDEPT
SARADAP_LEVL_CODE_2 STVLEVL_CODE