Model Registration Tables
| Object Name | Object Type | Layer Name |
|---|---|---|
| SFBCREQ | TABLE | Default |
| SFBESTS | TABLE | Default |
| SFBETRM | TABLE | Default |
| SFBPIPE | TABLE | Default |
| SFBREST | TABLE | Default |
| SFBRFST | TABLE | Default |
| SFBRGRP | TABLE | Default |
| SFBSECT | TABLE | Default |
| SFBWCTL | TABLE | Default |
| SFRAFEE | TABLE | Default |
| SFRAREG | TABLE | Default |
| SFRATWT | TABLE | Default |
| SFRBTCH | TABLE | Default |
| SFRCBRQ | TABLE | Default |
| SFRCOLR | TABLE | Default |
| SFRCTRL | TABLE | Default |
| SFREFEE | TABLE | Default |
| SFRENRL | TABLE | Default |
| SFREPRT | TABLE | Default |
| SFRFAUD | TABLE | Default |
| SFRFMAX | TABLE | Default |
| SFRFREQ | TABLE | Default |
| SFRMESG | TABLE | Default |
| SFRMHRS | TABLE | Default |
| SFRRACL | TABLE | Default |
| SFRRFCR | TABLE | Default |
| SFRRFND | TABLE | Default |
| SFRRGFE | TABLE | Default |
| SFRROVR | TABLE | Default |
| SFRRSTS | TABLE | Default |
| SFRSRPO | TABLE | Default |
| SFRSTCA | TABLE | Default |
| SFRSTCR | TABLE | Default |
| SFRTCTL | TABLE | Default |
| SFRTERM | TABLE | Default |
| SFRTHST | TABLE | Default |
| SFRTIME | TABLE | Default |
| SFRTMSL | TABLE | Default |
| SFRTMST | TABLE | Default |
| SFRWCTL | TABLE | Default |
| SFRWDRL | TABLE | Default |
| SFTAREA | TABLE | Default |
| SFTFEES | TABLE | Default |
| SFTREGS | TABLE | Default |
| SFTRGAM | TABLE | Default |

Table SFBCREQ
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SFBCREQ_STATUS | SFBCREQ_STATUS | VARCHAR2(1) | No | ||
| SFBCREQ_TERM | SFBCREQ_TERM | VARCHAR2(6) | No | * | |
| SFBCREQ_FCC | SFBCREQ_FCC | VARCHAR2(1) | No | ||
| SFBCREQ_IDNO | SFBCREQ_IDNO | VARCHAR2(9) | No | ||
| SFBCREQ_CRNUM | SFBCREQ_CRNUM | VARCHAR2(5) | No | ||
| SFBCREQ_ALTIND | SFBCREQ_ALTIND | VARCHAR2(1) | Yes | ||
| SFBCREQ_RECTYP | SFBCREQ_RECTYP | VARCHAR2(1) | No | ||
| SFBCREQ_BATCH | SFBCREQ_BATCH | VARCHAR2(6) | Yes | ||
| SFBCREQ_FUNCT | SFBCREQ_FUNCT | NUMBER(1,0) | No | ||
| SFBCREQ_TRANID | SFBCREQ_TRANID | VARCHAR2(2) | No | ||
| SFBCREQ_ORGCDE | SFBCREQ_ORGCDE | VARCHAR2(1) | Yes | ||
| SFBCREQ_CSTAT | SFBCREQ_CSTAT | VARCHAR2(4) | Yes | ||
| SFBCREQ_CREATE | SFBCREQ_CREATE | VARCHAR2(6) | Yes | ||
| SFBCREQ_CRHRS | SFBCREQ_CRHRS | NUMBER(7,3) | Yes | ||
| SFBCREQ_PRTY | SFBCREQ_PRTY | NUMBER(1,0) | No | ||
| SFBCREQ_OVRTCO | SFBCREQ_OVRTCO | NUMBER(1,0) | No | ||
| SFBCREQ_OVRMAJR | SFBCREQ_OVRMAJR | NUMBER(1,0) | No | ||
| SFBCREQ_OVRLEVL | SFBCREQ_OVRLEVL | NUMBER(1,0) | No | ||
| SFBCREQ_OVRCOLL | SFBCREQ_OVRCOLL | NUMBER(1,0) | No | ||
| SFBCREQ_OVRLINK | SFBCREQ_OVRLINK | NUMBER(1,0) | No | ||
| SFBCREQ_FIRST | SFBCREQ_FIRST | NUMBER(1,0) | No | ||
| SFBCREQ_ALTCRN | SFBCREQ_ALTCRN | VARCHAR2(5) | Yes | ||
| SFBCREQ_CRHRS_ALT | SFBCREQ_CRHRS_ALT | NUMBER(7,3) | Yes | ||
| SFBCREQ_STUD_PRTY | SFBCREQ_STUD_PRTY | VARCHAR2(9) | Yes | ||
| SFBCREQ_DESC | SFBCREQ_DESC | VARCHAR2(28) | Yes | ||
| SFBCREQ_ACTIVITY_DATE | SFBCREQ_ACTIVITY_DATE | DATE | No | ||
| SFBCREQ_GMOD_CODE | SFBCREQ_GMOD_CODE | VARCHAR2(1) | Yes | * | |
| SFBCREQ_GMOD_CODE_ALT | SFBCREQ_GMOD_CODE_ALT | VARCHAR2(1) | Yes | * | |
| SFBCREQ_LEVL_CODE_PRI | SFBCREQ_LEVL_CODE_PRI | VARCHAR2(2) | Yes | * | |
| SFBCREQ_LEVL_CODE_ALT | SFBCREQ_LEVL_CODE_ALT | VARCHAR2(2) | Yes | * | |
| SFBCREQ_BILL_HOURS | SFBCREQ_BILL_HOURS | NUMBER(7,3) | Yes | ||
| SFBCREQ_OVRCAMP | SFBCREQ_OVRCAMP | NUMBER(1,0) | No | ||
| SFBCREQ_OVRDEGC | SFBCREQ_OVRDEGC | NUMBER(1,0) | No | ||
| SFBCREQ_OVRPROG | SFBCREQ_OVRPROG | NUMBER(1,0) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SFBCREQ_LEVL_CODE_ALT | STVLEVL_CODE | STVLEVL |
| SFBCREQ_LEVL_CODE_PRI | STVLEVL_CODE | STVLEVL |
| SFBCREQ_TERM | STVTERM_CODE | STVTERM |
| SFBCREQ_GMOD_CODE_ALT | STVGMOD_CODE | STVGMOD |
| SFBCREQ_GMOD_CODE | STVGMOD_CODE | STVGMOD |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| SFBCREQ_KEY_INDEX | SFBCREQ_IDNO | |
| SFBCREQ_KEY_INDEX | SFBCREQ_TERM | |
| SFBCREQ_KEY_INDEX | SFBCREQ_CRNUM |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| BAA2 | Cobol Paragraph | [F:\banner\cobol].SCTH1000.AAA | Use(select ) |
| BAA7 | Cobol Paragraph | [F:\banner\cobol].SCTH1000.AAA | Use(select ) |
| BAA8 | Cobol Paragraph | [F:\banner\cobol].SCTH1000.AAA | Use(select ) |
| create_sfbcreq | C/C++ Function | [F:\BANNER\C\SFPBLCK.PC] | Use(insert ) |
| delealts | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(delete ) |
| deleterqst | C/C++ Function | [F:\BANNER\C\SFPFREQ.PC] | Use(delete ) |
| getlink | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(select ) |
| satisfyalt | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(insert,select ) |
| satisfylink | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(insert,select ) |
| selmacro | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(select ) |
| setton | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(update ) |
| updaterow | C/C++ Function | [F:\BANNER\C\SFPCREQ.PC] | Use(update ) |
| SCTC1000 | Cobol Program | F:\banner\cobol | Use() |
| SCTH1000 | Cobol Program | F:\banner\cobol | Use() |
| WHEN-VALIDATE-ITEM | Forms Trigger | BANNER7_FORMS.SFACREQ.KEY_BLOCK.ID | Use(select ) |
| WHEN-VALIDATE-ITEM | Forms Trigger | BANNER7_FORMS_10G.SFACREQ.KEY_BLOCK.ID | Use(select ) |
| DELETE_ALTERNATE_CRN | Forms Trigger | BANNER7_FORMS.SFACREQ | Use(delete ) |
| DELETE_ALTERNATE_CRN | Forms Trigger | BANNER7_FORMS_10G.SFACREQ | Use(delete ) |
| POST-INSERT | Forms Trigger | BANNER7_FORMS.SFACREQ.SFRSTCR | Use(select ) |
| POST-INSERT | Forms Trigger | BANNER7_FORMS_10G.SFACREQ.SFRSTCR | Use(select ) |
| PRE-INSERT | Forms Trigger | BANNER7_FORMS.SFACREQ.SFRSTCR | Use(select ) |
| PRE-INSERT | Forms Trigger | BANNER7_FORMS_10G.SFACREQ.SFRSTCR | Use(select ) |
| SETN | Forms Trigger | BANNER7_FORMS.SFACREQ.SFRSTCR | Use(update ) |
| SETN | Forms Trigger | BANNER7_FORMS_10G.SFACREQ.SFRSTCR | Use(update ) |
| SFBCREQ | SYNONYM | S4B70.PUBLIC | Rely on () |
| SFBCREQ | Forms DataBlock | BANNER7_FORMS.SFACREQ | Rely on () Use(insert,update,delete,select ) |
| SFBCREQ | Forms DataBlock | BANNER7_FORMS_10G.SFACREQ | Rely on () Use(insert,update,delete,select ) |
| SFRSTCR | Forms DataBlock | BANNER7_FORMS.SFACREQ | Rely on () Use(insert,update,delete,select ) |
| SFRSTCR | Forms DataBlock | BANNER7_FORMS_10G.SFACREQ | Rely on () Use(insert,update,delete,select ) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SFBCREQ_KEY_INDEX | INDEX | S4B70.SATURN | Rely on () |
| STVGMOD | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVLEVL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVTERM | TABLE | S4B70.SATURN | Refer( No Action ) |
Table SFBESTS
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SFBESTS_TERM_CODE | SFBESTS_TERM_CODE | VARCHAR2(6) | No | * | * |
| SFBESTS_ESTS_CODE | SFBESTS_ESTS_CODE | VARCHAR2(2) | No | * | * |
| SFBESTS_START_DATE | SFBESTS_START_DATE | DATE | Yes | ||
| SFBESTS_END_DATE | SFBESTS_END_DATE | DATE | Yes | ||
| SFBESTS_ACTIVITY_DATE | SFBESTS_ACTIVITY_DATE | DATE | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SFBESTS_ESTS_CODE | STVESTS_CODE | STVESTS |
| SFBESTS_TERM_CODE | SOBTERM_TERM_CODE | SOBTERM |
| SFBESTS_TERM_CODE | STVTERM_CODE | STVTERM |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SFBESTS | Unique | SFBESTS_TERM_CODE |
| PK_SFBESTS | Unique | SFBESTS_ESTS_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_SFBESTS | INDEX | S4B70.SATURN | Rely on () |
| SOBTERM | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVESTS | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVTERM | TABLE | S4B70.SATURN | Refer( No Action ) |
Table SFBETRM
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SFBETRM_TERM_CODE | SFBETRM_TERM_CODE | VARCHAR2(6) | No | * | * |
| SFBETRM_PIDM | SFBETRM_PIDM | NUMBER(8,0) | No | * | |
| SFBETRM_ESTS_CODE | SFBETRM_ESTS_CODE | VARCHAR2(2) | No | * | |
| SFBETRM_ESTS_DATE | SFBETRM_ESTS_DATE | DATE | Yes | ||
| SFBETRM_MHRS_OVER | SFBETRM_MHRS_OVER | NUMBER(9,3) | No | ||
| SFBETRM_AR_IND | SFBETRM_AR_IND | VARCHAR2(1) | No | ||
| SFBETRM_ASSESSMENT_DATE | SFBETRM_ASSESSMENT_DATE | DATE | Yes | ||
| SFBETRM_ADD_DATE | SFBETRM_ADD_DATE | DATE | No | ||
| SFBETRM_ACTIVITY_DATE | SFBETRM_ACTIVITY_DATE | DATE | No | ||
| SFBETRM_RGRE_CODE | SFBETRM_RGRE_CODE | VARCHAR2(2) | Yes | * | |
| SFBETRM_TMST_CODE | SFBETRM_TMST_CODE | VARCHAR2(2) | Yes | * | |
| SFBETRM_TMST_DATE | SFBETRM_TMST_DATE | DATE | Yes | ||
| SFBETRM_TMST_MAINT_IND | SFBETRM_TMST_MAINT_IND | VARCHAR2(1) | Yes | ||
| SFBETRM_USER | SFBETRM_USER | VARCHAR2(30) | Yes | ||
| SFBETRM_REFUND_DATE | SFBETRM_REFUND_DATE | DATE | Yes | ||
| SFBETRM_DATA_ORIGIN | SFBETRM_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SFBETRM_ESTS_CODE | STVESTS_CODE | STVESTS |
| SFBETRM_TMST_CODE | STVTMST_CODE | STVTMST |
| SFBETRM_TERM_CODE | STVTERM_CODE | STVTERM |
| SFBETRM_RGRE_CODE | STVRGRE_CODE | STVRGRE |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SFBETRM | Unique | SFBETRM_PIDM |
| PK_SFBETRM | Unique | SFBETRM_TERM_CODE |
| SFBETRM_KEY_INDEX2 | SFBETRM_TERM_CODE |