Model Catalog Tables
| Object Name | Object Type | Layer Name |
|---|---|---|
| SCBCDEP | TABLE | Tables |
| SCBCDTL | TABLE | Tables |
| SCBCRKY | TABLE | Tables |
| SCBCRSE | TABLE | Tables |
| SCBDESC | TABLE | Tables |
| SCBSUPP | TABLE | Tables |
| SCRATTR | TABLE | Tables |
| SCRCDTX | TABLE | Tables |
| SCRCORQ | TABLE | Tables |
| SCRCPRT | TABLE | Tables |
| SCRCRDF | TABLE | Tables |
| SCREQIV | TABLE | Tables |
| SCRFEES | TABLE | Tables |
| SCRGMOD | TABLE | Tables |
| SCRLEVL | TABLE | Tables |
| SCRRARE | TABLE | Tables |
| SCRRCAM | TABLE | Tables |
| SCRRCLS | TABLE | Tables |
| SCRRCMP | TABLE | Tables |
| SCRRCOL | TABLE | Tables |
| SCRRDEG | TABLE | Tables |
| SCRRLVL | TABLE | Tables |
| SCRRMAJ | TABLE | Tables |
| SCRRPRG | TABLE | Tables |
| SCRRTRM | TABLE | Tables |
| SCRRTST | TABLE | Tables |
| SCRSBGI | TABLE | Tables |
| SCRSCHD | TABLE | Tables |
| SCRSECT | TABLE | Tables |
| SCRSPRT | TABLE | Tables |
| SCRSRDF | TABLE | Tables |
| SCRSYLN | TABLE | Tables |
| SCRSYLO | TABLE | Tables |
| SCRSYRM | TABLE | Tables |
| SCRSYTR | TABLE | Tables |
| SCRTEXT | TABLE | Tables |

Table SCBCDEP
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SCBCDEP_COLL_CODE | SCBCDEP_COLL_CODE | VARCHAR2(2) | No | * | |
| SCBCDEP_DEPT_CODE | SCBCDEP_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SCBCDEP_TERM_CODE_START | SCBCDEP_TERM_CODE_START | VARCHAR2(6) | No | * | |
| SCBCDEP_TERM_CODE_END | SCBCDEP_TERM_CODE_END | VARCHAR2(6) | No | * | |
| SCBCDEP_ACTIVITY_DATE | SCBCDEP_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SCBCDEP_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SCBCDEP_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SCBCDEP_TERM_CODE_START | STVTERM_CODE | STVTERM |
| SCBCDEP_TERM_CODE_END | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SCBCDEP_KEY_INDEX | Unique | SCBCDEP_COLL_CODE |
| SCBCDEP_KEY_INDEX | Unique | SCBCDEP_DEPT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SCBCDEP_KEY_INDEX | INDEX | S4B70.SATURN | Rely on () |
| STVCOLL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVDEPT | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVTERM | TABLE | S4B70.SATURN | Refer( No Action ) |
Table SCBCDTL
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SCBCDTL_COLL_CODE | SCBCDTL_COLL_CODE | VARCHAR2(2) | No | * | |
| SCBCDTL_TERM_CODE_EFF | SCBCDTL_TERM_CODE_EFF | VARCHAR2(6) | No | ||
| SCBCDTL_ACTIVITY_DATE | SCBCDTL_ACTIVITY_DATE | DATE | No | ||
| SCBCDTL_USER_ID | SCBCDTL_USER_ID | VARCHAR2(30) | No | ||
| SCBCDTL_DEPT_CODE | SCBCDTL_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SCBCDTL_TEXT_NARRATIVE | SCBCDTL_TEXT_NARRATIVE | CLOB | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SCBCDTL_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SCBCDTL_DEPT_CODE | STVDEPT_CODE | STVDEPT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| UK_SCBCDTL | Unique | SCBCDTL_COLL_CODE |
| UK_SCBCDTL | Unique | SCBCDTL_DEPT_CODE |
| UK_SCBCDTL | Unique | SCBCDTL_TERM_CODE_EFF |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SCBCDTL | SYNONYM | S4B70.PUBLIC | Rely on () |
| END_TEXT_TERM | Forms Trigger | BANNER7_FORMS_10G.SCATEXT.SCBCDTL | Use(insert ) |
| END_TEXT_TERM | Forms Trigger | BANNER7_FORMS.SCATEXT.SCBCDTL | Use(insert ) |
| INSERT_TRIG | Forms Trigger | BANNER7_FORMS_10G.SCATEXT.SCBCDTL | Use(insert,select ) |
| INSERT_TRIG | Forms Trigger | BANNER7_FORMS.SCATEXT.SCBCDTL | Use(insert,select ) |
| PRE-QUERY | Forms Trigger | BANNER7_FORMS_10G.SCATEXT.SCBCDTL | Use(select ) |
| PRE-QUERY | Forms Trigger | BANNER7_FORMS.SCATEXT.SCBCDTL | Use(select ) |
| SCBCDTL | Forms DataBlock | BANNER7_FORMS_10G.SCATEXT | Rely on () Use(insert,update,delete,select ) |
| SCBCDTL | Forms DataBlock | BANNER7_FORMS.SCATEXT | Rely on () Use(insert,update,delete,select ) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| UK_SCBCDTL | INDEX | S4B70.SATURN | Rely on () |
| STVCOLL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVDEPT | TABLE | S4B70.SATURN | Refer( No Action ) |
Table SCBCRKY
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SCBCRKY_SUBJ_CODE | SCBCRKY_SUBJ_CODE | VARCHAR2(4) | No | * | * |
| SCBCRKY_CRSE_NUMB | SCBCRKY_CRSE_NUMB | VARCHAR2(5) | No | * | |
| SCBCRKY_TERM_CODE_START | SCBCRKY_TERM_CODE_START | VARCHAR2(6) | No | * | |
| SCBCRKY_TERM_CODE_END | SCBCRKY_TERM_CODE_END | VARCHAR2(6) | No | * | |
| SCBCRKY_ACTIVITY_DATE | SCBCRKY_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SCBCRKY_SUBJ_CODE | STVSUBJ_CODE | STVSUBJ |
| SCBCRKY_TERM_CODE_END | STVTERM_CODE | STVTERM |
| SCBCRKY_TERM_CODE_START | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SCBCRKY | Unique | SCBCRKY_SUBJ_CODE |
| PK_SCBCRKY | Unique | SCBCRKY_CRSE_NUMB |