Model Miscellaneous
| Object Name | Object Type | Layer Name |
|---|---|---|
| FOBAPPH | TABLE | Default |
| FOBPROF | TABLE | Default |
| FOBUAPP | TABLE | Default |
| GLBAPPL | TABLE | Default |
| GOBEACC | TABLE | Default |
| GOBVUSR | TABLE | Default |
| GORCCRD | TABLE | Default |
| GORMERC | TABLE | Default |
| GORPGEO | TABLE | Default |
| GORSGEO | TABLE | Default |
| GTVCCRD | TABLE | Default |
| GTVPROC | TABLE | Default |
| GTVSDAX | TABLE | Default |
| GTVSYSI | TABLE | Default |
| GTVZIPC | TABLE | Default |
| GUBBHLP | TABLE | Default |
| GUBGISL | TABLE | Default |
| GUBINST | TABLE | Default |
| GUBLHLP | TABLE | Default |
| GUBPPRF | TABLE | Default |
| GURHLOG | TABLE | Default |
| GURIDEN | TABLE | Default |
| GUROPTM | TABLE | Default |
| GURTKLR | TABLE | Default |
| GUVALTI | VIEW | Default |
| NTRTPRX | TABLE | Default |
| PTRUSER | TABLE | Default |
| PTVESKL | TABLE | Default |
| SOBSBGI | TABLE | Default |
| SORHSCH | TABLE | Default |
| SORMGEO | TABLE | Default |
| SORPCOL | TABLE | Default |
| SPBPERS | TABLE | Default |
| SPBPERS link | User Object | Default |
| SPRIDEN | TABLE | Default |
| SPRIDEN link | User Object | Default |
| STVCNTY | TABLE | Default |
| STVGEOD | TABLE | Default |
| STVGEOR | TABLE | Default |
| STVNATN | TABLE | Default |
| STVSBGI | TABLE | Default |
| STVSTAT | TABLE | Default |

Table FOBAPPH
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| FOBAPPH_SEQ_NUM | FOBAPPH_SEQ_NUM | NUMBER(2,0) | No | * | |
| FOBAPPH_DOC_CODE | FOBAPPH_DOC_CODE | VARCHAR2(15) | No | ||
| FOBAPPH_CHG_SEQ_NUM | FOBAPPH_CHG_SEQ_NUM | NUMBER(3,0) | Yes | ||
| FOBAPPH_USER_ID | FOBAPPH_USER_ID | VARCHAR2(30) | No | * | |
| FOBAPPH_ACTIVITY_DATE | FOBAPPH_ACTIVITY_DATE | DATE | No | ||
| FOBAPPH_QUEUE_ID | FOBAPPH_QUEUE_ID | VARCHAR2(4) | Yes | ||
| FOBAPPH_QUEUE_LEVEL | FOBAPPH_QUEUE_LEVEL | NUMBER(4,0) | Yes | ||
| FOBAPPH_SUBMISSION_NUMBER | FOBAPPH_SUBMISSION_NUMBER | NUMBER(2,0) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| FOBAPPH_USER_ID | GURTKLR_USER_ID | GURTKLR |
| FOBAPPH_SEQ_NUM | FTVDTYP_SEQ_NUM | FTVDTYP |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| FOBAPPH_CODE_INDEX | FOBAPPH_DOC_CODE | |
| FOBAPPH_KEY_INDEX | FOBAPPH_SEQ_NUM | |
| FOBAPPH_KEY_INDEX | FOBAPPH_DOC_CODE | |
| FOBAPPH_KEY_INDEX | FOBAPPH_CHG_SEQ_NUM | |
| FOBAPPH_KEY_INDEX | FOBAPPH_USER_ID |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| implied_history | C/C++ Function | [F:\BANNER\C\FORAPPL.PC] | Use(insert ) |
| FOBAPPH | SYNONYM | S4B70.PUBLIC | Rely on () |
| FOVAPHT | VIEW | S4B70.BANINST1 | Use(select ) |
| FOVAPPH | VIEW | S4B70.BANINST1 | Use(select ) |
| DO_APPROVAL | Forms Trigger | BANNER7_FORMS_10G.FOAUAPP | Use(insert ) |
| DO_APPROVAL | Forms Trigger | BANNER7_FORMS.FOAAINP | Use(insert ) |
| DO_APPROVAL | Forms Trigger | BANNER7_FORMS_10G.FOAAINP | Use(insert ) |
| DO_APPROVAL | Forms Trigger | BANNER7_FORMS.FOAUAPP | Use(insert ) |
| DO_DISAPPROVAL | Forms Trigger | BANNER7_FORMS_10G.FOAUAPP | Use(insert,select ) |
| DO_DISAPPROVAL | Forms Trigger | BANNER7_FORMS_10G.FOAAINP | Use(insert,select ) |
| DO_DISAPPROVAL | Forms Trigger | BANNER7_FORMS.FOAAINP | Use(insert,select ) |
| DO_DISAPPROVAL | Forms Trigger | BANNER7_FORMS.FOAUAPP | Use(insert,select ) |
| MNU_APPROVAL_HISTORY | Forms Trigger | BANNER7_FORMS.FOADOCU | Use(select ) |
| MNU_APPROVAL_HISTORY | Forms Trigger | BANNER7_FORMS_10G.FOADOCU | Use(select ) |
| DENY_DOC | Forms Trigger | BANNER7_FORMS.FOADOCU.FOVDOCU | Use(insert ) |
| DENY_DOC | Forms Trigger | BANNER7_FORMS_10G.FOADOCU.FOVDOCU | Use(insert ) |
| P_DOAPPROVE | Package procedure | S4B70.BANINST1.BWFKUADI | Use(insert ) |
| P_DODISAPPROVE | Package procedure | S4B70.BANINST1.BWFKUADI | Use(insert ) |
| P_INSERTCOMMENT | Package procedure | S4B70.BANINST1.BWFKUADI | Use(select ) |
| P_VIEWAPH | Package procedure | S4B70.BANINST1.BWFKVAPH | Rely on () |
| P_VIEWAPH | Package procedure | S4B70.BANINST1.BWFKVAPH | Use(select ) |
| P_VIEWAPPR | Package procedure | S4B70.BANINST1.BWFKVAPH | Rely on () |
| FOBAPPH2 | Forms DataBlock | BANNER7_FORMS_10G.FOIAPPH | Rely on () Use(insert,update,delete,select ) |
| FOBAPPH2 | Forms DataBlock | BANNER7_FORMS.FOIAPPH | Rely on () Use(insert,update,delete,select ) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| FOBAPPH_CODE_INDEX | INDEX | S4B70.FIMSMGR | Rely on () |
| FOBAPPH_KEY_INDEX | INDEX | S4B70.FIMSMGR | Rely on () |
| FTVDTYP | TABLE | S4B70.FIMSMGR | Join |
| GURTKLR | TABLE | S4B70."GENERAL" | Join |
Table FOBPROF
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| FOBPROF_USER_ID | FOBPROF_USER_ID | VARCHAR2(30) | No | * | * |
| FOBPROF_ACTIVITY_DATE | FOBPROF_ACTIVITY_DATE | DATE | No | ||
| FOBPROF_USER_NAME | FOBPROF_USER_NAME | VARCHAR2(35) | Yes | ||
| FOBPROF_COAS_CODE | FOBPROF_COAS_CODE | VARCHAR2(1) | No | * | |
| FOBPROF_SECG_CODE | FOBPROF_SECG_CODE | VARCHAR2(1) | Yes | ||
| FOBPROF_NSF_OVERRIDE | FOBPROF_NSF_OVERRIDE | VARCHAR2(1) | Yes | ||
| FOBPROF_TOLERANCE | FOBPROF_TOLERANCE | NUMBER(5,2) | Yes | ||
| FOBPROF_BUD_ID | FOBPROF_BUD_ID | VARCHAR2(6) | Yes | ||
| FOBPROF_PIDM | FOBPROF_PIDM | NUMBER(8,0) | Yes | ||
| FOBPROF_MASTER_FUND_IND | FOBPROF_MASTER_FUND_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_MASTER_ORGN_IND | FOBPROF_MASTER_ORGN_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_MAX_TOLERANCE_AMT | FOBPROF_MAX_TOLERANCE_AMT | NUMBER(12,2) | Yes | ||
| FOBPROF_RCVD_OVERRIDE_IND | FOBPROF_RCVD_OVERRIDE_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_RCVD_TOLERANCE_PCT | FOBPROF_RCVD_TOLERANCE_PCT | NUMBER(5,2) | Yes | ||
| FOBPROF_TOL_OVERRIDE_IND | FOBPROF_TOL_OVERRIDE_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_DST_SPD_OVERRIDE_IND | FOBPROF_DST_SPD_OVERRIDE_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_SPD_OVERRIDE_IND | FOBPROF_SPD_OVERRIDE_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_INT_RATE_OVERRIDE_IND | FOBPROF_INT_RATE_OVERRIDE_IND | VARCHAR2(1) | Yes | ||
| FOBPROF_USER_INV_PRIV | FOBPROF_USER_INV_PRIV | VARCHAR2(1) | Yes | ||
| FOBPROF_EXP_END_POST_AUTH_IND | FOBPROF_EXP_END_POST_AUTH_IND | VARCHAR2(1) | No | ||
| FOBPROF_ACCRUAL_POST_AUTH_IND | FOBPROF_ACCRUAL_POST_AUTH_IND | VARCHAR2(1) | No | ||
| FOBPROF_REQUESTER_ORGN_CODE | FOBPROF_REQUESTER_ORGN_CODE | VARCHAR2(6) | Yes | ||
| FOBPROF_RCVD_TOLERANCE_QTY | FOBPROF_RCVD_TOLERANCE_QTY | NUMBER(8,2) | Yes | ||
| FOBPROF_RCVD_TOLERANCE_AMT | FOBPROF_RCVD_TOLERANCE_AMT | NUMBER(12,2) | Yes | ||
| FOBPROF_RCVD_TOLERANCE_AMT_PCT | FOBPROF_RCVD_TOLERANCE_AMT_PCT | NUMBER(5,2) | Yes | ||
| FOBPROF_REQUESTOR_EMAIL_ADDR | FOBPROF_REQUESTOR_EMAIL_ADDR | VARCHAR2(100) | Yes | ||
| FOBPROF_REQUESTOR_FAX_AREA | FOBPROF_REQUESTOR_FAX_AREA | VARCHAR2(3) | Yes | ||
| FOBPROF_REQUESTOR_FAX_NUMBER | FOBPROF_REQUESTOR_FAX_NUMBER | VARCHAR2(7) | Yes | ||
| FOBPROF_REQUESTOR_FAX_EXT | FOBPROF_REQUESTOR_FAX_EXT | VARCHAR2(4) | Yes | ||
| FOBPROF_REQUESTOR_PHONE_AREA | FOBPROF_REQUESTOR_PHONE_AREA | VARCHAR2(3) | Yes | ||
| FOBPROF_REQUESTOR_PHONE_NUMBER | FOBPROF_REQUESTOR_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| FOBPROF_REQUESTOR_PHONE_EXT | FOBPROF_REQUESTOR_PHONE_EXT | VARCHAR2(4) | Yes | ||
| FOBPROF_REQUESTOR_SHIP_CODE | FOBPROF_REQUESTOR_SHIP_CODE | VARCHAR2(6) | Yes | ||
| FOBPROF_EDI_OVERRIDE_IND | FOBPROF_EDI_OVERRIDE_IND | VARCHAR2(1) | No | ||
| FOBPROF_ACH_OVERRIDE_IND | FOBPROF_ACH_OVERRIDE_IND | VARCHAR2(1) | No | ||
| FOBPROF_CARD_OVERRIDE_IND | FOBPROF_CARD_OVERRIDE_IND | VARCHAR2(1) | No | ||
| FOBPROF_REQ_MATCH_OVRRD_IND | FOBPROF_REQ_MATCH_OVRRD_IND | VARCHAR2(1) | No | ||
| FOBPROF_PO_MATCH_OVRRD_IND | FOBPROF_PO_MATCH_OVRRD_IND | VARCHAR2(1) | No | ||
| FOBPROF_INV_MATCH_OVRRD_IND | FOBPROF_INV_MATCH_OVRRD_IND | VARCHAR2(1) | No | ||
| FOBPROF_WEB_ACCESS_IND | FOBPROF_WEB_ACCESS_IND | VARCHAR2(1) | No | ||
| FOBPROF_WBUD_ACCESS_IND | FOBPROF_WBUD_ACCESS_IND | VARCHAR2(1) | No | ||
| FOBPROF_WBUD_MSTR_FUND_IND | FOBPROF_WBUD_MSTR_FUND_IND | VARCHAR2(1) | No | ||
| FOBPROF_WBUD_MSTR_ORGN_IND | FOBPROF_WBUD_MSTR_ORGN_IND | VARCHAR2(1) | No |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| FOBPROF_COAS_CODE | FTVCOAS_COAS_CODE | FTVCOAS |
| FOBPROF_USER_ID | GOBEACC_USERNAME | GOBEACC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_FOBPROF | Unique | FOBPROF_USER_ID |