Model Fine-Grained Access Control
| Object Name | Object Type | Layer Name |
|---|---|---|
| DBA_USERS | VIEW | Default |
| FOBPROF | TABLE | Default |
| GOBEACC | TABLE | Default |
| GOBFDMN | TABLE | Default |
| GOBFDTP | TABLE | Default |
| GOBFEOB | TABLE | Default |
| GOBFGAC | TABLE | Default |
| GOBFPUD | TABLE | Default |
| GOBVUSR | TABLE | Default |
| GORDMCL | TABLE | Default |
| GORDMSK | TABLE | Default |
| GORFBPI | TABLE | Default |
| GORFBPR | TABLE | Default |
| GORFDPI | TABLE | Default |
| GORFDPL | TABLE | Default |
| GORFGBP | TABLE | Default |
| GORFGUS | TABLE | Default |
| GORFPII | TABLE | Default |
| GORFPRD | TABLE | Default |
| GOVFGAC | VIEW | Default |
| GOVFPII | VIEW | Default |
| GOVFUSR | VIEW | Default |
| GTVFBPR | TABLE | Default |
| GTVFDMN | TABLE | Default |
| GTVFDTP | TABLE | Default |
| GTVFGAC | TABLE | Default |
| GUBOBJS | TABLE | Default |
| NOBTRAN | TABLE | Default |
| PHVTIME | VIEW | Default |
| SPRIDEN | TABLE | Default |

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 |