Model SRBRECR

Model Label : ERD for Banner Student Table SRBRECR
Path : BANNER DEV/Student/Common/SRBRECR/SRBRECR_ERD

List of Objects

Object Name	Object Type	Layer Name
GORVRAC	TABLE	Default
GTVSDAX	TABLE	Default
SARADAP	TABLE	Default
SFBETRM	TABLE	Default
SMRPRLE	TABLE	Default
SOBCURR	TABLE	Default
SORCONT	TABLE	Default
SORHSCH	TABLE	Default
SORINTS	TABLE	Default
SORMADM	TABLE	Default
SORMDPT	TABLE	Default
SORMMJR	TABLE	Default
SORMRTY	TABLE	Default
SORMSTY	TABLE	Default
SORPCOL	TABLE	Default
SPBPERS	TABLE	Default
SPRADDR	TABLE	Default
SPRIDEN	TABLE	Default
SRBRECR	TABLE	Default
SRRCHRT	TABLE	Default
SRRLEND	TABLE	Default
SRRRSRC	TABLE	Default
STVCOLL	TABLE	Default
STVDEGC	TABLE	Default
STVEDLV	TABLE	Default
STVEGOL	TABLE	Default
STVLEVL	TABLE	Default
STVRECR	TABLE	Default
STVRESD	TABLE	Default
STVRSTA	TABLE	Default
STVRTYP	TABLE	Default
STVSBGI	TABLE	Default
STVSESS	TABLE	Default
STVSITE	TABLE	Default
STVSTYP	TABLE	Default
STVWRSN	TABLE	Default

Comments

Model View

Table GORVRAC

Schema Name GENERAL
Label GORVRAC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:31:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORVRAC_USER_ID	GORVRAC_USER_ID	VARCHAR2(30)	No	*
GORVRAC_VOBJ_CODE	GORVRAC_VOBJ_CODE	VARCHAR2(15)	No	*	*
GORVRAC_BACR_SEQNO	GORVRAC_BACR_SEQNO	NUMBER(8,0)	No	*	*
GORVRAC_VAPP_CODE_MODULE	GORVRAC_VAPP_CODE_MODULE	VARCHAR2(15)	No	*
GORVRAC_ACTIVE_IND	GORVRAC_ACTIVE_IND	VARCHAR2(1)	No
GORVRAC_EFF_DATE	GORVRAC_EFF_DATE	DATE	No
GORVRAC_ACTIVITY_DATE	GORVRAC_ACTIVITY_DATE	DATE	No
GORVRAC_EXPIRE_DATE	GORVRAC_EXPIRE_DATE	DATE	Yes
GORVRAC_VBS_ITEM1	GORVRAC_VBS_ITEM1	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM1	GORVRAC_VBS_ITEM1	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM1	GORVRAC_VBS_ITEM1	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM2	GORVRAC_VBS_ITEM2	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM2	GORVRAC_VBS_ITEM2	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM2	GORVRAC_VBS_ITEM2	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM3	GORVRAC_VBS_ITEM3	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM3	GORVRAC_VBS_ITEM3	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM3	GORVRAC_VBS_ITEM3	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM4	GORVRAC_VBS_ITEM4	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM4	GORVRAC_VBS_ITEM4	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM4	GORVRAC_VBS_ITEM4	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*
GORVRAC_VBS_ITEM5	GORVRAC_VBS_ITEM5	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORVRAC_VOBJ_CODE	GTVVOBJ_CODE	GTVVOBJ
GORVRAC_BACR_SEQNO	GOBBACR_SEQNO	GOBBACR
GORVRAC_VBS_ITEM1	SRBRECR_PROGRAM_1	SRBRECR
GORVRAC_VBS_ITEM2	SRBRECR_CAMP_CODE	SRBRECR
GORVRAC_VBS_ITEM3	SRBRECR_COLL_CODE	SRBRECR
GORVRAC_VBS_ITEM4	SRBRECR_LEVL_CODE	SRBRECR
GORVRAC_VBS_ITEM5	SRBRECR_DEPT_CODE	SRBRECR
GORVRAC_VBS_ITEM5	SRBRECR_DEPT_CODE_2	SRBRECR
GORVRAC_VBS_ITEM1	SARADAP_PROGRAM_1	SARADAP
GORVRAC_VBS_ITEM2	SARADAP_CAMP_CODE	SARADAP
GORVRAC_VBS_ITEM3	SARADAP_COLL_CODE_1	SARADAP
GORVRAC_VBS_ITEM4	SARADAP_LEVL_CODE	SARADAP
GORVRAC_VBS_ITEM5	SARADAP_DEPT_CODE	SARADAP
GORVRAC_VBS_ITEM5	SARADAP_DEPT_CODE_1_2	SARADAP
GORVRAC_VBS_ITEM1	SGBSTDN_PROGRAM_1	SGBSTDN
GORVRAC_VBS_ITEM2	SGBSTDN_CAMP_CODE	SGBSTDN
GORVRAC_VBS_ITEM3	SGBSTDN_COLL_CODE_1	SGBSTDN
GORVRAC_VBS_ITEM4	SGBSTDN_LEVL_CODE	SGBSTDN
GORVRAC_VBS_ITEM5	SGBSTDN_DEPT_CODE	SGBSTDN
GORVRAC_VBS_ITEM5	SGBSTDN_DEPT_CODE_1_2	SGBSTDN

Index

Index Name	Index Type	Column Name
PK_GORVRAC	Unique	GORVRAC_USER_ID
PK_GORVRAC	Unique	GORVRAC_VOBJ_CODE
PK_GORVRAC	Unique	GORVRAC_BACR_SEQNO
PK_GORVRAC	Unique	GORVRAC_VAPP_CODE_MODULE

Comments

Source Code Comments

VBS User Access Rule Control

Columns Comments for GORVRAC_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GORVRAC_VOBJ_CODE (2)

Source Code Comments

VBS Object Code

Columns Comments for GORVRAC_BACR_SEQNO (3)

Source Code Comments

Access Rule Sequence Number

Columns Comments for GORVRAC_VAPP_CODE_MODULE (4)

Source Code Comments

VBS Module associated with User and Access Rule

Columns Comments for GORVRAC_ACTIVE_IND (5)

Source Code Comments

Indicates User is Active

Columns Comments for GORVRAC_EFF_DATE (6)

Source Code Comments

Effective Date of Access

Columns Comments for GORVRAC_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GORVRAC_EXPIRE_DATE (8)

Source Code Comments

Expiration Date of Access

Columns Comments for GORVRAC_VBS_ITEM1 (9)

Source Code Comments

Program Value

Columns Comments for GORVRAC_VBS_ITEM2 (10)

Source Code Comments

Campus Value

Columns Comments for GORVRAC_VBS_ITEM3 (11)

Source Code Comments

College Value

Columns Comments for GORVRAC_VBS_ITEM4 (12)

Source Code Comments

Level Value

Columns Comments for GORVRAC_VBS_ITEM5 (13)

Source Code Comments

Department Value

Table GTVSDAX

Schema Name GENERAL
Label GTVSDAX
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:08:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_REPORTING_DATE	GTVSDAX_REPORTING_DATE	DATE	Yes
GTVSDAX_TRANSLATION_CODE	GTVSDAX_TRANSLATION_CODE	VARCHAR2(15)	Yes
GTVSDAX_INTERNAL_CODE_SEQNO	GTVSDAX_INTERNAL_CODE_SEQNO	NUMBER(2,0)	Yes
GTVSDAX_INTERNAL_CODE_GROUP	GTVSDAX_INTERNAL_CODE_GROUP	VARCHAR2(20)	No
GTVSDAX_DESC	GTVSDAX_DESC	VARCHAR2(30)	No
GTVSDAX_SYSREQ_IND	GTVSDAX_SYSREQ_IND	VARCHAR2(1)	Yes
GTVSDAX_ACTIVITY_DATE	GTVSDAX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVSDAX_EXTERNAL_CODE	SSBSECT_SSTS_CODE	SSBSECT
GTVSDAX_INTERNAL_CODE	SORPCOL_SBGI_CODE	SORPCOL
GTVSDAX_INTERNAL_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
GTVSDAX_EXTERNAL_CODE	PERJTOT_EARN_CODE	PERJTOT
GTVSDAX_EXTERNAL_CODE	SRBRECR_LEVL_CODE	SRBRECR
GTVSDAX_EXTERNAL_CODE	SARADAP_LEVL_CODE	SARADAP
GTVSDAX_EXTERNAL_CODE	SFRRSTS_RSTS_CODE	SFRRSTS
GTVSDAX_EXTERNAL_CODE	SARAPPD_APDC_CODE	SARAPPD
GTVSDAX_EXTERNAL_CODE	SORBCHR_BCHR_CODE	SORBCHR
GTVSDAX_EXTERNAL_CODE	SORTEST_TESC_CODE	SORTEST

Index

Index Name	Index Type	Column Name
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_SEQNO

Comments

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (9)

Source Code Comments

The last activity date for this row of data

Table SARADAP

Schema Name SATURN
Label SARADAP
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_TERM_CODE_ENTRY	SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SARADAP_TERM_CODE_ENTRY	SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	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)	No		*
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)	No		*
SARADAP_DEGC_CODE_1	SARADAP_DEGC_CODE_1	VARCHAR2(6)	No		*
SARADAP_MAJR_CODE_1	SARADAP_MAJR_CODE_1	VARCHAR2(4)	No		*
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		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARADAP_ADMT_CODE	STVADMT_CODE	STVADMT
SARADAP_APST_CODE	STVAPST_CODE	STVAPST
SARADAP_EDLV_CODE	STVEDLV_CODE	STVEDLV
SARADAP_EGOL_CODE	STVEGOL_CODE	STVEGOL
SARADAP_INTV_CODE	STVINTV_CODE	STVINTV
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_WAIV_CODE	STVWAIV_CODE	STVWAIV
SARADAP_WRSN_CODE	STVWRSN_CODE	STVWRSN
SARADAP_SITE_CODE	STVSITE_CODE	STVSITE
SARADAP_RECR_CODE	STVRECR_CODE	STVRECR
SARADAP_SBGI_CODE	STVSBGI_CODE	STVSBGI
SARADAP_PIDM	SRBRECR_PIDM	SRBRECR
SARADAP_TERM_CODE_ENTRY	SRBRECR_TERM_CODE	SRBRECR
SARADAP_TERM_CODE_ENTRY	SABVWID_TERM_CODE	SABVWID
SARADAP_APPL_NO	SABVWID_APPL_NO	SABVWID
SARADAP_PIDM	SABVWID_PIDM	SABVWID
SARADAP_PIDM	SORHSCH_PIDM	SORHSCH

Index

Index Name	Index Type	Column Name
PK_SARADAP	Unique	SARADAP_PIDM
PK_SARADAP	Unique	SARADAP_TERM_CODE_ENTRY
PK_SARADAP	Unique	SARADAP_APPL_NO

Comments

Source Code Comments

Admissions Application Repeating Table

Impact job : SARADAP New Job

Impacted objects

Object Name	Object Type
P_POPULATEGORVMGA	PROCEDURE
SORCCON	TABLE
SARADAP_SECURED	VIEW
SOVAREC	VIEW
SOVCURR	VIEW
SOVPCUR	VIEW
P_CREATE_APPLICATION	Package procedure
P_GET_SARADAP	Package procedure
ALL_CONC_ATTACH	Forms Function
ALL_CONC_ATTACH	Forms Function
ALL_CONC_ATTACH	Forms Function
CONC_BASE_ATTACH	Forms Function
CONC_MAJR_ATTACH	Forms Function
FIND_RECORD_CURSOR	Forms Function
SELECT_BASE_CCON_RULE	Forms Function
SELECT_CCON_RULE	Forms Function
SELECT_MAJR_CCON_RULE	Forms Function
TEST_CONC_ATTACH	Forms Function
TEST_CONC_BASE_ATTACH	Forms Function
APPL_EXISTS	Forms Procedure
APPL_INDICATOR	Forms Procedure
CHECK_AP_TERM	Forms Procedure
CHECK_AP_TERM	Forms Procedure
CHECK_AP_TERM	Forms Procedure
CHECK_FOR_VALID_APP	Forms Procedure
CHECK_KEY_BLOCK	Forms Procedure
CREATE_COLLECTOR_ENTRY_3	Forms Procedure
CREATE_COLLECTOR_ENTRY_4	Forms Procedure
SET_APST_CODE	Forms Procedure
SGBSTDN_INSERT	Forms Procedure
UPDATE_SARADAP_3	Forms Procedure
UPDATE_SARADAP_3	Forms Procedure
UPDATE_SARADAP_3	Forms Procedure
CCON_TERMS	Forms Trigger
CHECK_ATTACHMENTS	Forms Trigger
CHECK_CONCENTRATIONS	Forms Trigger
CHECK_CONCENTRATIONS	Forms Trigger
CHECK_DELETE_BASE	Forms Trigger
CHECK_ID	Forms Trigger
FILL_ADMR_OLD	Forms Trigger
FILL_ADMS	Forms Trigger
FILL_ADMS_TEST	Forms Trigger
GET_CCON_RULE	Forms Trigger
GET_CONCENTRATIONS	Forms Trigger
SET_SAASUMI	Forms Trigger
SORCCON_BASECOPY	Forms Trigger
SORCCON_BASEEND	Forms Trigger
SORCCON_COPY	Forms Trigger
SORCCON_END	Forms Trigger
SORCMJR_END	Forms Trigger
SORCMJR_TESTCOPY	Forms Trigger
SORCMJR_TESTCOPY1	Forms Trigger
SORCMJR_TESTCOPY2	Forms Trigger
UPDATE_STATUS	Forms Trigger
WHEN_NEW_BLOCK_INSTANCE_TRG	Forms Trigger
SARADAP	Forms DataBlock
SARADAP	Forms DataBlock
SARADAP	Forms DataBlock
SARADAP	Forms DataBlock
SARADAP	Forms DataBlock
SARADAP	Forms DataBlock
SARAPPD_CTRL	Forms DataBlock
SARASUM	Forms DataBlock
SORCCON	Forms DataBlock
CHECK_DELETE_CONC	Forms Trigger
CHECK_DELETE_MAJOR	Forms Trigger
CHECK_DELETE_MINOR	Forms Trigger
CHECK_MODULES	Forms Trigger
CHECK_MODULES	Forms Trigger
CHECK_MODULES	Forms Trigger
CHECK_MODULES	Forms Trigger
CHECK_MODULES	Forms Trigger
CHECK_MODULES	Forms Trigger
DISPLAY_INDICATORS	Forms Trigger
DISPLAY_INDICATORS	Forms Trigger
GET_CLASS_CODE	Forms Trigger
GET_CLASS_CODE	Forms Trigger
KEY-CREREC	Forms Trigger
KEY-DELREC	Forms Trigger
KEY-DELREC	Forms Trigger
POST-BLOCK	Forms Trigger
POST-QUERY	Forms Trigger
PRE-DELETE	Forms Trigger
PRE-INSERT	Forms Trigger
SET_DISPLAYS	Forms Trigger
UPDATE_ADAP	Forms Trigger
UPDATE_ADAP	Forms Trigger
UPD_CHKL_DATE	Forms Trigger
UPD_CHKL_DATE	Forms Trigger
UPD_CHKL_DATE	Forms Trigger
UPD_CHKL_DATE	Forms Trigger
PRE-TEXT-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
WHEN-VALIDATE-ITEM	Forms Trigger
ALL_CONC_ATTACH	Forms Function
CONC_ATTACH	Forms Function
CONC_BASE_ATTACH	Forms Function
R$_RECR_ADMIS_GENSTU_VIEW	Forms Function
SELECT_CCONBASE_RULE	Forms Function
SELECT_CCON_RULE	Forms Function
SORCCON_TERM1_RG	Forms Record Group
SORCCON_TERM2_RG	Forms Record Group
SORCCON_TERM3_RG	Forms Record Group
SORCCON_TERM4_RG	Forms Record Group
SORCCON_TERM5_RG	Forms Record Group
SORCMJR_TERM_TEST_RG	Forms Record Group
STVMAJR_CONCBASE_RG	Forms Record Group
STVMAJR_CONCBASE_RG	Forms Record Group
STVMAJR_CRESCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group
STVMAJR_CURRCONC_RG	Forms Record Group