Model Fine-Grained_Access_Control
Object Name | Object Type | Layer Name |
---|---|---|
DBA_USERS | SQL View | Default |
FOBPROF | SQL Table | Default |
GOBEACC | SQL Table | Default |
GOBFDMN | SQL Table | Default |
GOBFDTP | SQL Table | Default |
GOBFEOB | SQL Table | Default |
GOBFGAC | SQL Table | Default |
GOBFPUD | SQL Table | Default |
GOBVUSR | SQL Table | Default |
GORDMCL | SQL Table | Default |
GORDMSK | SQL Table | Default |
GORFBPI | SQL Table | Default |
GORFBPR | SQL Table | Default |
GORFDPI | SQL Table | Default |
GORFDPL | SQL Table | Default |
GORFGBP | SQL Table | Default |
GORFGUS | SQL Table | Default |
GORFPII | SQL Table | Default |
GORFPRD | SQL Table | Default |
GOVFGAC | SQL View | Default |
GOVFPII | SQL View | Default |
GOVFUSR | SQL View | Default |
GTVFBPR | SQL Table | Default |
GTVFDMN | SQL Table | Default |
GTVFDTP | SQL Table | Default |
GTVFGAC | SQL Table | Default |
GUBOBJS | SQL Table | Default |
NOBTRAN | SQL Table | Default |
PHVTIME | SQL View | Default |
SPRIDEN | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBEACC_PIDM |   | NUMBER(8,0) | No | * |   |
GOBEACC_USERNAME |   | VARCHAR2(30) | No |   | * |
GOBEACC_USER_ID |   | VARCHAR2(30) | No |   |   |
GOBEACC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBEACC_USERNAME | NTRPROX_PROXY_USER_ID | NTRPROX |
GOBEACC_USERNAME | NTRPROX_USER_ID | NTRPROX |
Index Name | Index Type | Column Name |
---|---|---|
GOBEACC_KEY_INDEX | Unique | GOBEACC_USERNAME |
PK_GOBEACC | Unique | GOBEACC_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBEACC_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GOBEACC | SQL Index | S10B80.GENERAL | Rely On |
NTRPROX | SQL Table | S10B80.POSNCTL | Join |
GT_GOBEACC_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:08:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBFDMN_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GOBFDMN_TABLE_NAME |   | VARCHAR2(30) | No |   |   |
GOBFDMN_FDTP_CODE |   | VARCHAR2(5) | No |   | * |
GOBFDMN_SYS_REQ_IND |   | VARCHAR2(1) | No |   |   |
GOBFDMN_ENABLE_PII_IND |   | VARCHAR2(1) | No |   |   |
GOBFDMN_ACTIVITY_DATE |   | DATE | No |   |   |
GOBFDMN_USER_ID |   | VARCHAR2(30) | No |   |   |
GOBFDMN_PII_COLUMN_NAME |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBFDMN_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
GOBFDMN_FDTP_CODE | GTVFDTP_CODE | GTVFDTP |
GOBFDMN_FDMN_CODE | GORFPRD_FDMN_CODE | GORFPRD |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBFDMN | Unique | GOBFDMN_FDMN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBFDMN | SQL Index | S10B80.GENERAL | Rely On |
GORFPRD | SQL Table | S10B80.GENERAL | Join |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDTP | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GOBFDMN_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:20:000 | 04/02/2008 21:17:55:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBFDTP_FDTP_CODE |   | VARCHAR2(5) | No | * | * |
GOBFDTP_PREDICATE_IND |   | VARCHAR2(1) | No |   |   |
GOBFDTP_SYS_REQ_IND |   | VARCHAR2(1) | No |   |   |
GOBFDTP_ACTIVITY_DATE |   | DATE | No |   |   |
GOBFDTP_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBFDTP_FDTP_CODE | GTVFDTP_CODE | GTVFDTP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBFDTP | Unique | GOBFDTP_FDTP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBFDTP | SQL Index | S10B80.GENERAL | Rely On |
GTVFDTP | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:26:000 | 04/02/2008 21:17:55:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBFEOB_OBJECT |   | VARCHAR2(30) | No | * |   |
GOBFEOB_ACTIVITY_DATE |   | DATE | No |   |   |
GOBFEOB_USER_ID |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBFEOB | Unique | GOBFEOB_OBJECT |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBFEOB | SQL Index | S10B80.GENERAL | Rely On |
GT_GOBFEOB_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:02:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBFGAC_FGAC_CODE |   | VARCHAR2(30) | No | * | * |
GOBFGAC_ACTIVE_IND |   | VARCHAR2(1) | No |   |   |
GOBFGAC_EFF_DATE |   | DATE | No |   |   |
GOBFGAC_ACTIVITY_DATE |   | DATE | No |   |   |
GOBFGAC_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBFGAC_FGAC_CODE | GTVFGAC_CODE | GTVFGAC |
GOBFGAC_FGAC_CODE | GORFGUS_FGAC_CODE | GORFGUS |
GOBFGAC_FGAC_CODE | GORFGBP_FGAC_CODE | GORFGBP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBFGAC | Unique | GOBFGAC_FGAC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBFGAC | SQL Index | S10B80.GENERAL | Rely On |
GORFGBP | SQL Table | S10B80.GENERAL | Join |
GORFGUS | SQL Table | S10B80.GENERAL | Join |
GTVFGAC | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GOBFGAC_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:33:35:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBFPUD_FGAC_USER_ID |   | VARCHAR2(30) | No | * |   |
GOBFPUD_EXEMPT_IND |   | VARCHAR2(1) | No |   |   |
GOBFPUD_CROSS_DOMAIN_IND |   | VARCHAR2(1) | No |   |   |
GOBFPUD_ACTIVITY_DATE |   | DATE | No |   |   |
GOBFPUD_USER_ID |   | VARCHAR2(30) | No |   |   |
GOBFPUD_FDMN_CODE |   | VARCHAR2(30) | Yes |   | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBFPUD_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBFPUD | Unique | GOBFPUD_FGAC_USER_ID |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBFPUD | SQL Index | S10B80.GENERAL | Rely On |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GOBFPUD_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:59:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBVUSR_USER_ID |   | VARCHAR2(30) | No | * |   |
GOBVUSR_ACTIVE_IND |   | VARCHAR2(1) | No |   |   |
GOBVUSR_EFF_DATE |   | DATE | No |   |   |
GOBVUSR_ADMIN_IND |   | VARCHAR2(1) | No |   |   |
GOBVUSR_MGR_IND |   | VARCHAR2(1) | No |   |   |
GOBVUSR_ACTIVITY_DATE |   | DATE | No |   |   |
GOBVUSR_EXPIRE_DATE |   | DATE | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBVUSR | Unique | GOBVUSR_USER_ID |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBVUSR | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:12:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORDMCL_OBJS_CODE |   | VARCHAR2(30) | No | * |   |
GORDMCL_BLOCK_NAME |   | VARCHAR2(30) | No | * |   |
GORDMCL_COLUMN_NAME |   | VARCHAR2(30) | No | * |   |
GORDMCL_SYS_REQ_IND |   | VARCHAR2(1) | No |   |   |
GORDMCL_DATA_TYPE_CDE |   | VARCHAR2(1) | No |   |   |
GORDMCL_DATA_LENGTH |   | NUMBER(3,0) | No |   |   |
GORDMCL_ACTIVITY_DATE |   | DATE | No |   |   |
GORDMCL_USER_ID |   | VARCHAR2(30) | No |   |   |
GORDMCL_QUERY_COLUMN |   | VARCHAR2(30) | Yes |   |   |
GORDMCL_NUMERIC_PRECISION |   | NUMBER(3,0) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORDMCL | Unique | GORDMCL_OBJS_CODE |
PK_GORDMCL | Unique | GORDMCL_BLOCK_NAME |
PK_GORDMCL | Unique | GORDMCL_COLUMN_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORDMCL | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:44:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORDMSK_OBJS_CODE |   | VARCHAR2(30) | No | * | * |
GORDMSK_BLOCK_NAME |   | VARCHAR2(30) | No | * | * |
GORDMSK_COLUMN_NAME |   | VARCHAR2(30) | No | * | * |
GORDMSK_SEQNO |   | NUMBER(8,0) | No | * |   |
GORDMSK_DISPLAY_IND |   | VARCHAR2(1) | No |   |   |
GORDMSK_CONCEAL_IND |   | VARCHAR2(1) | No |   |   |
GORDMSK_ALL_USER_IND |   | VARCHAR2(1) | No |   |   |
GORDMSK_ACTIVITY_DATE |   | DATE | No |   |   |
GORDMSK_USER_ID |   | VARCHAR2(30) | No |   |   |
GORDMSK_DATA_MASK |   | VARCHAR2(60) | Yes |   |   |
GORDMSK_FGAC_USER_ID |   | VARCHAR2(30) | Yes |   |   |
GORDMSK_FBPR_CODE |   | VARCHAR2(30) | Yes |   | * |
GORDMSK_MASK_DIRECTION |   | VARCHAR2(1) | Yes |   |   |
GORDMSK_MASK_LENGTH |   | NUMBER(4,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORDMSK_OBJS_CODE | GORDMCL_OBJS_CODE | GORDMCL |
GORDMSK_BLOCK_NAME | GORDMCL_BLOCK_NAME | GORDMCL |
GORDMSK_COLUMN_NAME | GORDMCL_COLUMN_NAME | GORDMCL |
GORDMSK_FBPR_CODE | GTVFBPR_CODE | GTVFBPR |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORDMSK | Unique | GORDMSK_OBJS_CODE |
PK_GORDMSK | Unique | GORDMSK_BLOCK_NAME |
PK_GORDMSK | Unique | GORDMSK_COLUMN_NAME |
PK_GORDMSK | Unique | GORDMSK_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORDMSK | SQL Index | S10B80.GENERAL | Rely On |
GORDMCL | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFBPR | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORDMSK_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:10:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFBPI_FBPR_CODE |   | VARCHAR2(30) | No | * | * |
GORFBPI_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GORFBPI_ACTIVITY_DATE |   | DATE | No |   |   |
GORFBPI_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFBPI_FBPR_CODE | GTVFBPR_CODE | GTVFBPR |
GORFBPI_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
GORFBPI_FBPR_CODE | GORFBPR_FBPR_CODE | GORFBPR |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORFBPI | Unique | GORFBPI_FBPR_CODE |
PK_GORFBPI | Unique | GORFBPI_FDMN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORFBPI | SQL Index | S10B80.GENERAL | Rely On |
GORFBPR | SQL Table | S10B80.GENERAL | Join |
GTVFBPR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFBPI_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:57:000 | 04/02/2008 21:17:57:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFBPR_FGAC_USER_ID |   | VARCHAR2(30) | No | * |   |
GORFBPR_FBPR_CODE |   | VARCHAR2(30) | No | * | * |
GORFBPR_ACTIVITY_DATE |   | DATE | No |   |   |
GORFBPR_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFBPR_FBPR_CODE | GTVFBPR_CODE | GTVFBPR |
GORFBPR_FBPR_CODE | GORDMSK_FBPR_CODE | GORDMSK |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORFBPR | Unique | GORFBPR_FGAC_USER_ID |
PK_GORFBPR | Unique | GORFBPR_FBPR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORFBPR | SQL Index | S10B80.GENERAL | Rely On |
GORDMSK | SQL Table | S10B80.GENERAL | Join |
GTVFBPR | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFBPR_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:58:000 | 04/02/2008 21:17:57:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFDPI_TABLE_NAME |   | VARCHAR2(30) | No | * |   |
GORFDPI_COLUMN_NAME |   | VARCHAR2(30) | No |   |   |
GORFDPI_SYS_REQ_IND |   | VARCHAR2(1) | No |   |   |
GORFDPI_ACTIVE_IND |   | VARCHAR2(1) | No |   |   |
GORFDPI_USER_ID |   | VARCHAR2(30) | No |   |   |
GORFDPI_ACTIVITY_DATE |   | DATE | No |   |   |
GORFDPI_DRIVER_SQL |   | VARCHAR2(2000) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORFDPI | Unique | GORFDPI_TABLE_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORFDPI | SQL Index | S10B80.GENERAL | Rely On |
GT_GORFDPI_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:36:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFDPL_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GORFDPL_TABLE_NAME |   | VARCHAR2(30) | No | * | * |
GORFDPL_SYS_REQ_IND |   | VARCHAR2(1) | No |   |   |
GORFDPL_ACTIVE_IND |   | VARCHAR2(1) | No |   |   |
GORFDPL_USER_ID |   | VARCHAR2(30) | No |   |   |
GORFDPL_ACTIVITY_DATE |   | DATE | No |   |   |
GORFDPL_DRIVER_SQL |   | VARCHAR2(2000) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFDPL_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
GORFDPL_FDMN_CODE | GOBFDMN_FDMN_CODE | GOBFDMN |
GORFDPL_TABLE_NAME | GORFDPI_TABLE_NAME | GORFDPI |
Index Name | Index Type | Column Name |
---|---|---|
GORFDPL_KEY_INDEX |   | GORFDPL_TABLE_NAME |
PK_GORFDPL | Unique | GORFDPL_FDMN_CODE |
PK_GORFDPL | Unique | GORFDPL_TABLE_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFDPL_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GORFDPL | SQL Index | S10B80.GENERAL | Rely On |
GOBFDMN | SQL Table | S10B80.GENERAL | Join |
GORFDPI | SQL Table | S10B80.GENERAL | Join |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFDPL_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:37:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFGBP_FGAC_CODE |   | VARCHAR2(30) | No | * | * |
GORFGBP_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GORFGBP_FPRD_SEQNO |   | NUMBER(4,0) | No | * | * |
GORFGBP_FBPR_CODE |   | VARCHAR2(30) | No | * | * |
GORFGBP_SELECT_IND |   | VARCHAR2(1) | No |   |   |
GORFGBP_INSERT_IND |   | VARCHAR2(1) | No |   |   |
GORFGBP_UPDATE_IND |   | VARCHAR2(1) | No |   |   |
GORFGBP_DELETE_IND |   | VARCHAR2(1) | No |   |   |
GORFGBP_ACTIVITY_DATE |   | DATE | No |   |   |
GORFGBP_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFGBP_FGAC_CODE | GORFPRD_FGAC_CODE | GORFPRD |
GORFGBP_FDMN_CODE | GORFPRD_FDMN_CODE | GORFPRD |
GORFGBP_FPRD_SEQNO | GORFPRD_SEQNO | GORFPRD |
GORFGBP_FGAC_CODE | GTVFGAC_CODE | GTVFGAC |
GORFGBP_FBPR_CODE | GORFBPR_FBPR_CODE | GORFBPR |
Index Name | Index Type | Column Name |
---|---|---|
GORFGBP_KEY_INDEX |   | GORFGBP_FBPR_CODE |
PK_GORFGBP | Unique | GORFGBP_FGAC_CODE |
PK_GORFGBP | Unique | GORFGBP_FDMN_CODE |
PK_GORFGBP | Unique | GORFGBP_FPRD_SEQNO |
PK_GORFGBP | Unique | GORFGBP_FBPR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFGBP_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GORFGBP | SQL Index | S10B80.GENERAL | Rely On |
GORFBPR | SQL Table | S10B80.GENERAL | Join |
GORFPRD | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFGAC | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFGBP_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:34:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFGUS_FGAC_CODE |   | VARCHAR2(30) | No | * | * |
GORFGUS_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GORFGUS_FPRD_SEQNO |   | NUMBER(4,0) | No | * | * |
GORFGUS_FGAC_USER_ID |   | VARCHAR2(30) | No | * |   |
GORFGUS_SELECT_IND |   | VARCHAR2(1) | No |   |   |
GORFGUS_INSERT_IND |   | VARCHAR2(1) | No |   |   |
GORFGUS_UPDATE_IND |   | VARCHAR2(1) | No |   |   |
GORFGUS_DELETE_IND |   | VARCHAR2(1) | No |   |   |
GORFGUS_ACTIVITY_DATE |   | DATE | No |   |   |
GORFGUS_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFGUS_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
GORFGUS_FGAC_CODE | GORFPRD_FGAC_CODE | GORFPRD |
GORFGUS_FDMN_CODE | GORFPRD_FDMN_CODE | GORFPRD |
GORFGUS_FPRD_SEQNO | GORFPRD_SEQNO | GORFPRD |
GORFGUS_FGAC_CODE | GTVFGAC_CODE | GTVFGAC |
Index Name | Index Type | Column Name |
---|---|---|
GORFGUS_KEY_INDEX |   | GORFGUS_FGAC_USER_ID |
PK_GORFGUS | Unique | GORFGUS_FGAC_CODE |
PK_GORFGUS | Unique | GORFGUS_FDMN_CODE |
PK_GORFGUS | Unique | GORFGUS_FPRD_SEQNO |
PK_GORFGUS | Unique | GORFGUS_FGAC_USER_ID |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFGUS_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GORFGUS | SQL Index | S10B80.GENERAL | Rely On |
GORFPRD | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFGAC | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFGUS_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:04:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFPII_FGAC_USER_ID |   | VARCHAR2(30) | No | * |   |
GORFPII_FDMN_CODE_PII |   | VARCHAR2(30) | No | * | * |
GORFPII_ACTIVITY_DATE |   | DATE | No |   |   |
GORFPII_USER_ID |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFPII_FDMN_CODE_PII | GTVFDMN_CODE | GTVFDMN |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORFPII | Unique | GORFPII_FGAC_USER_ID |
PK_GORFPII | Unique | GORFPII_FDMN_CODE_PII |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORFPII | SQL Index | S10B80.GENERAL | Rely On |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:57:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORFPRD_FGAC_CODE |   | VARCHAR2(30) | No | * | * |
GORFPRD_FDMN_CODE |   | VARCHAR2(30) | No | * | * |
GORFPRD_SEQNO |   | NUMBER(4,0) | No | * |   |
GORFPRD_ACTIVITY_DATE |   | DATE | No |   |   |
GORFPRD_USER_ID |   | VARCHAR2(30) | No |   |   |
GORFPRD_PREDICATE |   | VARCHAR2(4000) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORFPRD_FDMN_CODE | GTVFDMN_CODE | GTVFDMN |
GORFPRD_FGAC_CODE | GOBFGAC_FGAC_CODE | GOBFGAC |
Index Name | Index Type | Column Name |
---|---|---|
GORFPRD_KEY_INDEX |   | GORFPRD_FDMN_CODE |
PK_GORFPRD | Unique | GORFPRD_FGAC_CODE |
PK_GORFPRD | Unique | GORFPRD_FDMN_CODE |
PK_GORFPRD | Unique | GORFPRD_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFPRD_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GORFPRD | SQL Index | S10B80.GENERAL | Rely On |
GOBFGAC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GT_GORFPRD_AUDIT_ROW | SQL Trigger | S10B80.BANSECR | Fire (Insert,update,delete,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:05:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVFBPR_CODE |   | VARCHAR2(30) | No | * |   |
GTVFBPR_DESC |   | VARCHAR2(60) | No |   |   |
GTVFBPR_ACTIVITY_DATE |   | DATE | No |   |   |
GTVFBPR_USER_ID |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVFBPR | Unique | GTVFBPR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORDMSK | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFBPI | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFBPR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFBPR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFBPR | Rely On |
GTVFBPR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFBPR | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_USERPIIDOMAINS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUSINESSPROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUSPROFPII | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DISPLAYMASK | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUS_PROF_RULE | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVFBPR | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVFBPR | Rely On |
GTVFBPR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVFBPR | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:29:07:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVFDMN_CODE |   | VARCHAR2(30) | No | * |   |
GTVFDMN_DESC |   | VARCHAR2(60) | No |   |   |
GTVFDMN_ACTIVITY_DATE |   | DATE | No |   |   |
GTVFDMN_USER_ID |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVFDMN | Unique | GTVFDMN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GOBFPUD | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFBPI | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFDPL | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFGUS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFPII | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFPRD | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDMN_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFDMN | Rely On |
GTVFDMN_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFDMN | Use (select)Rely On |
P_FIND_USER_PII_DOMAINS | Oracle Package Procedure | S10B80.BANINST1.GOKFGAC | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_VBS_PREDICATE_RULES | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_VBS_PREDICATE_RULES | Use (select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_USERPIIDOMAINS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUSINESSPROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DOMAINTYPE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUSPROFPII | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DOMAINS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VBS_TABLES | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_USERDEFAULT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUS_PROF_RULE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VBS_PREDICATE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_FGAC_USER_RULE | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVFDMN | Rely On |
F_FIND_PII_DOMAIN | Oracle Package Function | S10B80.BANINST1.GOKFGAC | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVFDMN | Rely On |
GTVFDMN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVFDMN | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:48:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVFDTP_CODE |   | VARCHAR2(5) | No | * |   |
GTVFDTP_DESC |   | VARCHAR2(60) | No |   |   |
GTVFDTP_ACTIVITY_DATE |   | DATE | No |   |   |
GTVFDTP_USER_ID |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVFDTP | Unique | GTVFDTP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBFDMN | SQL Table | S10B80.GENERAL | Refer (no action) |
GOBFDTP | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFDTP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFDTP | Rely On |
GTVFDTP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFDTP | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DOMAINTYPE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DOMAINS | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVFDTP | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVFDTP | Rely On |
GTVFDTP | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVFDTP | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:59:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVFGAC_CODE |   | VARCHAR2(30) | No | * |   |
GTVFGAC_DESC |   | VARCHAR2(60) | No |   |   |
GTVFGAC_ACTIVITY_DATE |   | DATE | No |   |   |
GTVFGAC_USER_ID |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVFGAC | Unique | GTVFGAC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBFGAC | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFGBP | SQL Table | S10B80.GENERAL | Refer (no action) |
GORFGUS | SQL Table | S10B80.GENERAL | Refer (no action) |
UT_GB_DOMAINSDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DOMAINS | Use (Insert) |
GTVFGAC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFGAC | Rely On |
GTVFGAC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFGAC | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_GROUP_RULES | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BUS_PROF_RULE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VBS_PREDICATE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_FGAC_USER_RULE | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVFGAC | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVFGAC | Rely On |
GTVFGAC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVFGAC | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:54:000 | 04/02/2008 21:17:57:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GUBOBJS_NAME |   | VARCHAR2(30) | No | * |   |
GUBOBJS_DESC |   | VARCHAR2(80) | No |   |   |
GUBOBJS_OBJT_CODE |   | VARCHAR2(10) | No |   | * |
GUBOBJS_SYSI_CODE |   | VARCHAR2(2) | No |   | * |
GUBOBJS_USER_ID |   | VARCHAR2(30) | No |   |   |
GUBOBJS_ACTIVITY_DATE |   | DATE | No |   |   |
GUBOBJS_HELP_IND |   | VARCHAR2(1) | No |   |   |
GUBOBJS_EXTRACT_ENABLED_IND |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GUBOBJS_OBJT_CODE | GTVOBJT_CODE | GTVOBJT |
GUBOBJS_SYSI_CODE | GTVSYSI_CODE | GTVSYSI |
Index Name | Index Type | Column Name |
---|---|---|
GUBOBJS_OBJT_INDEX |   | GUBOBJS_OBJT_CODE |
PK_GUBOBJS | Unique | GUBOBJS_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GURHMNU | SQL Table | S10B80.GENERAL | Join |
GURMENU | SQL Table | S10B80.GENERAL | Join |
GUBOBJS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GUBOBJS | Rely On |
GUBOBJS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GUBOBJS | Use (select)Rely On |
P_BLD_PERS_MENU | Oracle Package Procedure | S10B80.BANINST1.GUKMENU | Use (select) |
P_BLD_PROD_MENU | Oracle Package Procedure | S10B80.BANINST1.GUKMENU | Use (select) |
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.DML_GUBOBJS | Use (delete) |
P_INSERT | Oracle Package Procedure | S10B80.BANINST1.DML_GUBOBJS | Use (Insert)Rely On |
P_REFRESH_MENU | Oracle Package Procedure | S10B80.BANINST1.GUKMENU | Use (select) |
P_UPDATE | Oracle Package Procedure | S10B80.BANINST1.DML_GUBOBJS | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_DISPLAYCOLUMNS_RULES | Use (select) |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_CM_DISPLAY_OPTIONS_RULES | Use (select) |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_DISPLAYMASK_RULES | Use (select) |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.GB_FGACEXCLUDEDOBJECTS_RULES | Use (select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_FGACEXCLUDEDOBJECTS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DISPLAYMASK | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_DISPLAYCOLUMNS | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GUBOBJS | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GUBOBJS | Rely On |
F_PERS_BANNER | Oracle Package Function | S10B80.BANINST1.BWGCXCHN | Rely On |
F_PERS_BANNER | Oracle Package Function | S10B80.BANINST1.BWGCXCHN | Use (select) |
GUBOBJS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GUBOBJS_OBJT_INDEX | SQL Index | S10B80.GENERAL | Rely On |
PK_GUBOBJS | SQL Index | S10B80.GENERAL | Rely On |
GTVOBJT | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVSYSI | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:33:15:000 | 04/02/2008 21:17:57:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
NOBTRAN_TRANSACTION_NO |   | NUMBER(15,0) | No | * | * |
NOBTRAN_PIDM |   | NUMBER(8,0) | Yes |   |   |
NOBTRAN_EFFECTIVE_DATE |   | DATE | Yes |   |   |
NOBTRAN_ACAT_CODE |   | VARCHAR2(6) | No |   | * |
NOBTRAN_TRANS_STATUS_IND |   | VARCHAR2(1) | No |   |   |
NOBTRAN_SUBMITTOR_USER_ID |   | VARCHAR2(30) | Yes |   |   |
NOBTRAN_CREATED_DATE |   | DATE | No |   |   |
NOBTRAN_ORIGINATOR_USER_ID |   | VARCHAR2(30) | No |   |   |
NOBTRAN_SUBMISSION_DATE |   | DATE | Yes |   |   |
NOBTRAN_APPLY_IND |   | VARCHAR2(1) | No |   |   |
NOBTRAN_APPLY_DATE |   | DATE | Yes |   |   |
NOBTRAN_APPLY_USER_ID |   | VARCHAR2(30) | Yes |   |   |
NOBTRAN_ACTIVITY_DATE |   | DATE | No |   |   |
NOBTRAN_COMMENTS |   | RAW(1) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
NOBTRAN_ACAT_CODE | NTVACAT_CODE | NTVACAT |
NOBTRAN_TRANSACTION_NO | NORTRAN_TRANSACTION_NO | NORTRAN |
Index Name | Index Type | Column Name |
---|---|---|
NOBTRAN_KEY1_INDEX |   | NOBTRAN_ACAT_CODE |
NOBTRAN_KEY2_INDEX |   | NOBTRAN_APPLY_IND |
NOBTRAN_KEY2_INDEX |   | NOBTRAN_APPLY_USER_ID |
NOBTRAN_KEY3_INDEX |   | NOBTRAN_TRANS_STATUS_IND |
NOBTRAN_KEY3_INDEX |   | NOBTRAN_SUBMISSION_DATE |
NOBTRAN_KEY_INDEX |   | NOBTRAN_PIDM |
PK_NOBTRAN | Unique | NOBTRAN_TRANSACTION_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
NOBTRAN_KEY1_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
NOBTRAN_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
NOBTRAN_KEY3_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
NOBTRAN_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
PK_NOBTRAN | SQL Index | S10B80.POSNCTL | Rely On |
NORTRAN | SQL Table | S10B80.POSNCTL | Join |
NTVACAT | SQL Table | S10B80.POSNCTL | Refer (no action) |
NT_WFAIR_PAFCHANGE_INSERT | SQL Trigger | S10B80.POSNCTL | Fire (Insert,after,each row) |
NT_WFAUR_PAFCHANGE_UPDATE | SQL Trigger | S10B80.POSNCTL | Fire (update,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:30:38:000 | 04/02/2008 13:49:04:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
Index Name | Index Type | Column Name |
---|---|---|
SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
This Object is |
---|
Light Imported |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
FOBPROF_USER_ID |   | VARCHAR2(30) | No | * | * |
FOBPROF_ACTIVITY_DATE |   | DATE | No |   |   |
FOBPROF_USER_NAME |   | VARCHAR2(35) | Yes |   |   |
FOBPROF_COAS_CODE |   | VARCHAR2(1) | No |   |   |
FOBPROF_SECG_CODE |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_NSF_OVERRIDE |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_TOLERANCE |   | NUMBER(5,2) | Yes |   |   |
FOBPROF_BUD_ID |   | VARCHAR2(6) | Yes |   |   |
FOBPROF_PIDM |   | NUMBER(8,0) | Yes |   |   |
FOBPROF_MASTER_FUND_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_MASTER_ORGN_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_MAX_TOLERANCE_AMT |   | NUMBER(17,2) | Yes |   |   |
FOBPROF_RCVD_OVERRIDE_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_RCVD_TOLERANCE_PCT |   | NUMBER(5,2) | Yes |   |   |
FOBPROF_TOL_OVERRIDE_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_DST_SPD_OVERRIDE_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_SPD_OVERRIDE_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_INT_RATE_OVERRIDE_IND |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_USER_INV_PRIV |   | VARCHAR2(1) | Yes |   |   |
FOBPROF_EXP_END_POST_AUTH_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_ACCRUAL_POST_AUTH_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_REQUESTER_ORGN_CODE |   | VARCHAR2(6) | Yes |   |   |
FOBPROF_RCVD_TOLERANCE_QTY |   | NUMBER(8,2) | Yes |   |   |
FOBPROF_RCVD_TOLERANCE_AMT |   | NUMBER(17,2) | Yes |   |   |
FOBPROF_RCVD_TOLERANCE_AMT_PCT |   | NUMBER(5,2) | Yes |   |   |
FOBPROF_REQUESTOR_EMAIL_ADDR |   | VARCHAR2(128) | Yes |   |   |
FOBPROF_REQUESTOR_FAX_AREA |   | VARCHAR2(6) | Yes |   |   |
FOBPROF_REQUESTOR_FAX_NUMBER |   | VARCHAR2(12) | Yes |   |   |
FOBPROF_REQUESTOR_FAX_EXT |   | VARCHAR2(10) | Yes |   |   |
FOBPROF_REQUESTOR_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
FOBPROF_REQUESTOR_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
FOBPROF_REQUESTOR_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
FOBPROF_REQUESTOR_SHIP_CODE |   | VARCHAR2(6) | Yes |   |   |
FOBPROF_EDI_OVERRIDE_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_ACH_OVERRIDE_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_CARD_OVERRIDE_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_REQ_MATCH_OVRRD_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_PO_MATCH_OVRRD_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_INV_MATCH_OVRRD_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_WEB_ACCESS_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_WBUD_ACCESS_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_WBUD_MSTR_FUND_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_WBUD_MSTR_ORGN_IND |   | VARCHAR2(1) | No |   |   |
FOBPROF_CTRY_CODE_REQ_PHONE |   | VARCHAR2(4) | Yes |   |   |
FOBPROF_CTRY_CODE_REQ_FAX |   | VARCHAR2(4) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
FOBPROF_USER_ID | GOBEACC_USERNAME | GOBEACC |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBEACC | SQL Table | S10B80.GENERAL | Join |
Creation Date | Analysis Date |
---|---|
04/05/2008 03:35:55:000 | 01/01/1900 00:00:00:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
GOVFGAC_FGAC_USER_ID | VARCHAR2(120) | Yes |   |   |
GOVFGAC_TABLE_NAME | VARCHAR2(30) | Yes |   |   |
GOVFGAC_INSERT_POLICY_STATUS | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_INSERT_PREDICATE | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_SELECT_POLICY_STATUS | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_SELECT_PREDICATE | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_UPDATE_POLICY_STATUS | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_UPDATE_PREDICATE | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_DELETE_POLICY_STATUS | VARCHAR2(4000) | Yes |   |   |
GOVFGAC_DELETE_PREDICATE | VARCHAR2(4000) | Yes |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_OPENDOC | Oracle Package Procedure | S10B80.WTAILOR.TWBKWBIS | Use (select) |
GOVFGAC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFDPI | SQL Table | S10B80.GENERAL | Use (select) |
GORFDPL | SQL Table | S10B80.GENERAL | Use (select) |
GOVFUSR | SQL View | S10B80.BANINST1 | Use (select) |
VARCHAR2 | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
F_QUERY_POLICY | Oracle Package Function | S10B80.BANINST1.GOKFGAC | Call |
F_QUERY_PREDICATE | Oracle Package Function | S10B80.BANINST1.GOKFGAC | Call |
DBA_USERS | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFDPI | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFDPL | Oracle Synonym | S10B80.PUBLIC | Use (select) |
DBA_USERS | SQL View | S10B80.SYS | Use (select) |
Creation Date | Analysis Date |
---|---|
04/02/2008 21:15:50:000 | 04/04/2008 21:57:33:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
GOVFPII_FGAC_USER_ID | VARCHAR2(30) | Yes |   |   |
GOVFPII_FDMN_CODE | VARCHAR2(30) | Yes |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_FIND_USER_PII_DOMAINS | Oracle Package Procedure | S10B80.BANINST1.GOKFGAC | Use (select) |
F_FIND_PII_DOMAIN | Oracle Package Function | S10B80.BANINST1.GOKFGAC | Use (select) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORFBPI | SQL Table | S10B80.GENERAL | Use (select) |
GORFBPR | SQL Table | S10B80.GENERAL | Use (select) |
GORFPII | SQL Table | S10B80.GENERAL | Use (select) |
VARCHAR2 | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
GORFBPI | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFBPR | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFPII | Oracle Synonym | S10B80.PUBLIC | Use (select) |
Creation Date | Analysis Date |
---|---|
04/04/2008 21:22:58:000 | 04/04/2008 21:57:51:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
GOVFUSR_FGAC_USER_ID | VARCHAR2(30) | Yes |   | * |
GOVFUSR_FDMN_CODE | VARCHAR2(30) | Yes |   | * |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOVFGAC | SQL View | S10B80.BANINST1 | Use (select) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBFGAC | SQL Table | S10B80.GENERAL | Use (select) |
GORFBPR | SQL Table | S10B80.GENERAL | Use (select) |
GORFDPL | SQL Table | S10B80.GENERAL | Join |
GORFGBP | SQL Table | S10B80.GENERAL | Use (select) |
GORFGUS | SQL Table | S10B80.GENERAL | Use (select) |
VARCHAR2 | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
GOBFGAC | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFBPR | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFGBP | Oracle Synonym | S10B80.PUBLIC | Use (select) |
GORFGUS | Oracle Synonym | S10B80.PUBLIC | Use (select) |
DBA_USERS | SQL View | S10B80.SYS | Join |
NVL | Oracle Package Function | S10B80.SYS.STANDARD | Call |
SYSDATE | Oracle Package Function | S10B80.SYS.STANDARD | Call |
TRUNC | Oracle Package Function | S10B80.SYS.STANDARD | Call |
Creation Date | Analysis Date |
---|---|
04/02/2008 21:15:53:000 | 04/04/2008 21:57:33:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
PHVTIME_SEQNO | NUMBER(0,0) | Yes |   |   |
PHVTIME_PIDM | NUMBER(8,0) | Yes |   |   |
PHVTIME_POSN | VARCHAR2(6) | Yes |   |   |
PHVTIME_SUFF | VARCHAR2(2) | Yes |   |   |
PHVTIME_COAS_CODE_TS | VARCHAR2(1) | Yes |   |   |
PHVTIME_ORGN_CODE_TS | VARCHAR2(6) | Yes |   |   |
PHVTIME_JOBS_EFFECTIVE_DATE | DATE | Yes |   |   |
PHVTIME_STATUS_IND | VARCHAR2(1) | Yes |   |   |
PHVTIME_JOB_TITLE | VARCHAR2(30) | Yes |   |   |
PHVTIME_SHIFT | VARCHAR2(1) | Yes |   |   |
PHVTIME_ECLS_CODE | VARCHAR2(2) | Yes |   |   |
PHVTIME_TIME_ENTRY_METHOD | VARCHAR2(1) | Yes |   |   |
PHVTIME_TIME_ENTRY_TYPE | VARCHAR2(1) | Yes |   |   |
PHVTIME_TIME_IN_OUT_IND | VARCHAR2(1) | Yes |   |   |
PHVTIME_ACAT_CODE | VARCHAR2(6) | Yes |   |   |
PHVTIME_LCAT_CODE | VARCHAR2(2) | Yes |   |   |
PHVTIME_ID | VARCHAR2(9) | Yes |   |   |
PHVTIME_LAST_NAME | VARCHAR2(60) | Yes |   |   |
PHVTIME_FIRST_NAME | VARCHAR2(60) | Yes |   |   |
PHVTIME_MI | VARCHAR2(60) | Yes |   |   |
PHVTIME_SECURITY_IND | VARCHAR2(1) | Yes |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_MASS_EXTRACT | Oracle Package Procedure | S10B80.BANINST1.PEKTEEX | Use (select)Rely On |
P_OPEN_TIME_CV | Oracle Package Procedure | S10B80.BANINST1.PEKTECM | Use (select) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBEACC | SQL Table | S10B80.GENERAL | Use (select) |
NBRBJOB | SQL Table | S10B80.POSNCTL | Use (select) |
NBRJOBS | SQL Table | S10B80.POSNCTL | Use (select) |
PEBEMPL | SQL Table | S10B80.PAYROLL | Use (select) |
PERJOBS | SQL Table | S10B80.PAYROLL | Use (select) |
PERROUT | SQL Table | S10B80.PAYROLL | Use (select) |
PTRCALN | SQL Table | S10B80.PAYROLL | Use (select) |
PTRINST | SQL Table | S10B80.PAYROLL | Use (select) |
PTVLCAT | SQL Table | S10B80.PAYROLL | Use (select) |
SPRIDEN | SQL Table | S10B80.SATURN | Use (select) |
DATE | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
NUMBER | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
VARCHAR2 | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
F_PHVTIME_ACTION_IND | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_COAS_CODE_TS | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_ORGN_CODE_TS | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_PAYNO | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_PICT_CODE | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_PROXY_FOR_PIDM | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_STATUS_IND | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_TIME_ENTRY_METHOD | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_USER_PIDM | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_USER_ROLE | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_PHVTIME_YEAR | Oracle Package Function | S10B80.BANINST1.PEKTECM | Call |
F_TIME_ENTRY_SECURITY | Oracle Package Function | S10B80.BANINST1.NOKSECR | Call |
GOBEACC | Oracle Synonym | S10B80.PUBLIC | Use (select) |
NBRBJOB | Oracle Synonym | S10B80.PUBLIC | Use (select) |
NBRJOBS | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PEBEMPL | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PERJOBS | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PERROUT | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PTRCALN | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PTRINST | Oracle Synonym | S10B80.PUBLIC | Use (select) |
PTVLCAT | Oracle Synonym | S10B80.PUBLIC | Use (select) |
SPRIDEN | Oracle Synonym | S10B80.PUBLIC | Use (select) |
DECODE | Oracle Package Function | S10B80.SYS.STANDARD | Call |
NVL | Oracle Package Function | S10B80.SYS.STANDARD | Call |
NVL | Oracle Package Function | S10B80.SYS.STANDARD | Call |
SUBSTR | Oracle Package Function | S10B80.SYS.STANDARD | Call |
Creation Date | Analysis Date |
---|---|
04/04/2008 21:19:27:000 | 04/04/2008 21:57:47:000 |
This Object is |
---|
Light Imported |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
USERNAME | VARCHAR2 | No |   |   |
USER_ID | NUMBER | No |   |   |
PASSWORD | VARCHAR2 | Yes |   |   |
ACCOUNT_STATUS | VARCHAR2 | No |   |   |
LOCK_DATE | DATE | Yes |   |   |
EXPIRY_DATE | DATE | Yes |   |   |
DEFAULT_TABLESPACE | VARCHAR2 | No |   |   |
TEMPORARY_TABLESPACE | VARCHAR2 | No |   |   |
CREATED | DATE | No |   |   |
PROFILE | VARCHAR2 | No |   |   |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR2 | Yes |   |   |
EXTERNAL_NAME | VARCHAR2 | Yes |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOVFGAC | SQL View | S10B80.BANINST1 | Use (select) |
GOVFUSR | SQL View | S10B80.BANINST1 | Join |
GET_DEFAULT_PROFILE | Oracle Package Function | S10B80.BANSECR.GP_UDC_ORACLE_ID | Use (select) |
GET_DEFAULT_TABLESPACE | Oracle Package Function | S10B80.BANSECR.GP_UDC_ORACLE_ID | Use (select) |
GET_TEMPORARY_TABLESPACE | Oracle Package Function | S10B80.BANSECR.GP_UDC_ORACLE_ID | Use (select) |
F_IDM_CREATE_USER | Oracle Package Function | S10B80.BANSECR.GP_UDC_ORACLE_ID | Use (select) |
DBA_USERS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Creation Date | Analysis Date |
---|---|
04/03/2008 10:47:03:000 | 01/01/1900 00:00:00:000 |
Objects list |
---|
scope-function : S10B80.WTAILOR.TWBKWBIS.F_VALIDUSER
scope-function : S10B80.BANINST1.CHNLSKXM.F_FIN_ALERT scope-function : S10B80.BANINST1.GOKEDVD.F_VALIDATESPRIDENID scope-function : S10B80.BANINST1.GOKEDVD.F_GETSPRIDENNAME scope-function : S10B80.BANINST1.GOKEDVD.F_GETUSER scope-cursor : S10B80.BANINST1.BWPKTAIS.GET_PROXY_NAME scope-procedure : S10B80.BANINST1.BWPKTAIS.P_DISPLAYPROXY scope-procedure : S10B80.BANINST1.BWPKTAIS.P_DISPLAYPROXYSETUP scope-procedure : S10B80.BANINST1.POKWLIB.P_GET_PAF_POSN_INFO scope-cursor : S10B80.BANINST1.BWAKLIBS.GETGOBEACCC scope-cursor : S10B80.BANINST1.BWPKLRED.GET_PROXY_NAME scope-procedure : S10B80.BANINST1.BWPKLRED.P_DISPLAYPROXY scope-procedure : S10B80.BANINST1.BWPKLRED.P_DISPLAYPROXYSETUP scope-procedure : S10B80.BANINST1.BWPKEPID.P_PRINT_PROXY_SETUP scope-function : S10B80.BANINST1.BWPKEPID.F_OPEN_ROUTUSER_RC scope-function : S10B80.BANINST1.BWACBREF.F_GET_MOVES scope-procedure : S10B80.BANINST1.BWPKEPSM.P_BUILD_PROXY_LIST |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and GOBEACC | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | GOBEACC |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFUSR |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOBFGAC and GORFGUS | GENERAL |
Link type | Between | And |
---|---|---|
Join | GOBFGAC | GORFGUS |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFUSR |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOBFGAC and GORFGBP | GENERAL |
Link type | Between | And |
---|---|---|
Join | GOBFGAC | GORFGBP |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFUSR
scope-cursor : S10B80.BANINST1.GOKFGAC.GETGROUP_C scope-cursor : S10B80.BANINST1.GOKFGAC.GETPREDICATE_C |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORFGBP and GORFBPR | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORFGBP | GORFBPR |
Objects list |
---|
scope-cursor : S10B80.BANINST1.GOKFGAC.GORFDPL_VBS_C |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORFDPL and GOBFDMN | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORFDPL | GOBFDMN |
Objects list |
---|
scope-cursor : S10B80.BANINST1.GOKFGAC.GETGROUP_C
scope-cursor : S10B80.BANINST1.GOKFGAC.GETPREDICATE_C |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOBFDMN and GORFPRD | GENERAL |
Link type | Between | And |
---|---|---|
Join | GOBFDMN | GORFPRD |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFGAC |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORFDPL and GORFDPI | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORFDPL | GORFDPI |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFGAC |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOVFUSR and GORFDPL | BANINST1 |
Link type | Between | And |
---|---|---|
Join | GOVFUSR | GORFDPL |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFGAC |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOVFUSR and DBA_USERS | BANINST1 |
Link type | Between | And |
---|---|---|
Join | GOVFUSR | DBA_USERS |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVFPII
scope-procedure : S10B80.BANINST1.GB_USERPIIDOMAINS.P_DELETE scope-function : S10B80.BANINST1.GB_BUSINESSPROFILE.F_CHILD_EXISTS scope-procedure : S10B80.BANINST1.GB_BUSPROFPII.P_DELETE |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORFBPI and GORFBPR | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORFBPI | GORFBPR |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFGAC and GORFDPI | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFGAC | GORFDPI |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFGAC and GORFDPL | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFGAC | GORFDPL |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFGAC and GOVFUSR | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFGAC | GOVFUSR |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFGAC and DBA_USERS | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFGAC | DBA_USERS |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFUSR and GORFGBP | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFUSR | GORFGBP |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFUSR and GORFGUS | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFUSR | GORFGUS |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFUSR and GORFBPR | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFUSR | GORFBPR |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFUSR and GOBFGAC | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFUSR | GOBFGAC |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between PHVTIME and SPRIDEN | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | PHVTIME | SPRIDEN |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between PHVTIME and GOBEACC | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | PHVTIME | GOBEACC |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFPII and GORFPII | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFPII | GORFPII |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFPII and GORFBPI | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFPII | GORFBPI |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GOVFPII and GORFBPR | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GOVFPII | GORFBPR |
Objects list |
---|
schema-function : S10B80.BANINST1.F_FINANCE_USER_IC
schema-function : S10B80.BANINST1.F_FINANCE_USER_IND |
Link Type | Link | Project |
---|---|---|
Join | Link Between FOBPROF and GOBEACC | FIMSMGR |
Link type | Between | And |
---|---|---|
Join | FOBPROF | GOBEACC |
Objects list |
---|
scope-procedure : S10B80.BANINST1.BWPKOLIB.P_STARTUP_MASK |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORFBPR and GORDMSK | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORFBPR | GORDMSK |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBFPUD and GTVFDMN (FK1_GOBFPUD_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBFPUD | GOBFPUD_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFDPL and GTVFDMN (FK1_GORFDPL_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFDPL | GORFDPL_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFGUS and GTVFDMN (FK1_GORFGUS_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFGUS | GORFGUS_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDMSK and GORDMCL (FK1_GORDMSK_INV_GORDMCL_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDMSK | GORDMSK_OBJS_CODE | GORDMCL_OBJS_CODE | GORDMCL | (1,1)-(0,n) |
GORDMSK | GORDMSK_BLOCK_NAME | GORDMCL_BLOCK_NAME | GORDMCL | (1,1)-(0,n) |
GORDMSK | GORDMSK_COLUMN_NAME | GORDMCL_COLUMN_NAME | GORDMCL | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDMSK and GTVFBPR (FK1_GORDMSK_INV_GTVFBPR_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDMSK | GORDMSK_FBPR_CODE | GTVFBPR_CODE | GTVFBPR | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBFDMN and GTVFDMN (FK1_GOBFDMN_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBFDMN | GOBFDMN_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,1) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBFDMN and GTVFDTP (FK1_GOBFDMN_INV_GTVFDTP_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBFDMN | GOBFDMN_FDTP_CODE | GTVFDTP_CODE | GTVFDTP | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBFDTP and GTVFDTP (FK1_GOBFDTP_INV_GTVFDTP_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBFDTP | GOBFDTP_FDTP_CODE | GTVFDTP_CODE | GTVFDTP | (1,1)-(0,1) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFPII and GTVFDMN (FK1_GORFPII_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFPII | GORFPII_FDMN_CODE_PII | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFGBP and GORFPRD (FK1_GORFGBP_INV_GORFPRD_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFGBP | GORFGBP_FGAC_CODE | GORFPRD_FGAC_CODE | GORFPRD | (1,1)-(0,n) |
GORFGBP | GORFGBP_FDMN_CODE | GORFPRD_FDMN_CODE | GORFPRD | (1,1)-(0,n) |
GORFGBP | GORFGBP_FPRD_SEQNO | GORFPRD_SEQNO | GORFPRD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFGUS and GORFPRD (FK1_GORFGUS_INV_GORFPRD_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFGUS | GORFGUS_FGAC_CODE | GORFPRD_FGAC_CODE | GORFPRD | (1,1)-(0,n) |
GORFGUS | GORFGUS_FDMN_CODE | GORFPRD_FDMN_CODE | GORFPRD | (1,1)-(0,n) |
GORFGUS | GORFGUS_FPRD_SEQNO | GORFPRD_SEQNO | GORFPRD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFPRD and GTVFDMN (FK1_GORFPRD_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFPRD | GORFPRD_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFGBP and GTVFGAC (FK1_GORFGBP_INV_GTVFGAC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFGBP | GORFGBP_FGAC_CODE | GTVFGAC_CODE | GTVFGAC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFGUS and GTVFGAC (FK1_GORFGUS_INV_GTVFGAC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFGUS | GORFGUS_FGAC_CODE | GTVFGAC_CODE | GTVFGAC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFBPI and GTVFBPR (FK1_GORFBPI_INV_GTVFBPR_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFBPI | GORFBPI_FBPR_CODE | GTVFBPR_CODE | GTVFBPR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFBPI and GTVFDMN (FK1_GORFBPI_INV_GTVFDMN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFBPI | GORFBPI_FDMN_CODE | GTVFDMN_CODE | GTVFDMN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFBPR and GTVFBPR (FK1_GORFBPR_INV_GTVFBPR_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFBPR | GORFBPR_FBPR_CODE | GTVFBPR_CODE | GTVFBPR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORFPRD and GOBFGAC (FK1_GORFPRD_INV_GOBFGAC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORFPRD | GORFPRD_FGAC_CODE | GOBFGAC_FGAC_CODE | GOBFGAC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBFGAC and GTVFGAC (FK1_GOBFGAC_INV_GTVFGAC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBFGAC | GOBFGAC_FGAC_CODE | GTVFGAC_CODE | GTVFGAC | (1,1)-(0,1) |