Model Prospect_Management*
Object Name | Object Type | Layer Name |
---|---|---|
AMBPLAN | SQL Table | Default |
AMBSTGY | SQL Table | Default |
AMRCONF | SQL Table | Default |
AMRCONT | SQL Table | Default |
AMRDESG | SQL Table | Default |
AMREXRT | SQL Table | Default |
AMRINFO | SQL Table | Default |
AMRPCMT | SQL Table | Default |
AMRPLAN | SQL Table | Default |
AMRPRIN | SQL Table | Default |
AMRPROP | SQL Table | Default |
AMRPRRT | SQL Table | Default |
AMRPRSC | SQL Table | Default |
AMRPSRC | SQL Table | Default |
AMRPUSR | SQL Table | Default |
AMRSTAF | SQL Table | Default |
AMRSTGY | SQL Table | Default |
AMRSUBJ | SQL Table | Default |
APTPCHN | SQL Table | Default |
ATVEXRS | SQL Table | Default |
ATVGIVH | SQL Table | Default |
ATVMOVE | SQL Table | Default |
ATVPROJ | SQL Table | Default |
ATVPROP | SQL Table | Default |
ATVPRST | SQL Table | Default |
ATVREFR | SQL Table | Default |
ATVSCNT | SQL Table | Default |
ATVSORC | SQL Table | Default |
ATVSTFT | SQL Table | Default |
ATVUSRC | SQL Table | Default |
SPRADDR | SQL Table | Default |
SPRIDEN | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMBPLAN_PIDM |   | NUMBER(8,0) | No | * |   |
AMBPLAN_STGY_PLAN |   | VARCHAR2(15) | No | * |   |
AMBPLAN_PROJ_CODE |   | VARCHAR2(6) | No | * | * |
AMBPLAN_IDEN_CODE |   | VARCHAR2(5) | No |   |   |
AMBPLAN_START_DATE |   | DATE | No |   |   |
AMBPLAN_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMBPLAN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
Index Name | Index Type | Column Name |
---|---|---|
AMBPLAN_KEY_INDEX2 |   | AMBPLAN_STGY_PLAN |
AMBPLAN_KEY_INDEX3 |   | AMBPLAN_PROJ_CODE |
AMBPLAN_KEY_INDEX4 |   | AMBPLAN_IDEN_CODE |
PK_AMBPLAN | Unique | AMBPLAN_PIDM |
PK_AMBPLAN | Unique | AMBPLAN_STGY_PLAN |
PK_AMBPLAN | Unique | AMBPLAN_PROJ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GURIDEN | SQL Table | S10B80.GENERAL | Join |
AMBPLAN_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKMOVE | Rely On |
AMBPLAN_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKPPRF | Rely On |
AMBPLANVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMBPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMBPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
AMBPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMBPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMBPLANVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
AMBPLANVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
AMBPLANVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETAMBPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANDESCC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANDESCC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETAMBPLANIDENC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANSTGYC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANSTGYC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETSTRATEGIESC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
AMBPLAN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMBPLAN_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
AMBPLAN_KEY_INDEX3 | SQL Index | S10B80.ALUMNI | Rely On |
AMBPLAN_KEY_INDEX4 | SQL Index | S10B80.ALUMNI | Rely On |
PK_AMBPLAN | SQL Index | S10B80.ALUMNI | Rely On |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:25:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMBSTGY_STGY_PLAN |   | VARCHAR2(15) | No |   |   |
AMBSTGY_ACTIVITY_DATE |   | DATE | No |   |   |
AMBSTGY_PROJ_CODE |   | VARCHAR2(6) | Yes |   | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMBSTGY_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
Index Name | Index Type | Column Name |
---|---|---|
AMBSTGY_KEY_INDEX |   | AMBSTGY_STGY_PLAN |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMBSTGY_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:59:000 | 04/02/2008 13:49:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRCONF_PIDM |   | NUMBER(8,0) | No | * | * |
AMRCONF_IDEN_CODE |   | VARCHAR2(5) | No | * | * |
AMRCONF_USER_ID |   | VARCHAR2(30) | No | * |   |
AMRCONF_GRP_SEQ_NO |   | NUMBER(15,0) | No | * |   |
AMRCONF_ACTIVITY_DATE |   | DATE | No |   |   |
AMRCONF_ENTRY_DATE |   | DATE | No |   |   |
AMRCONF_CONFID_IND |   | VARCHAR2(1) | Yes |   |   |
AMRCONF_USER |   | VARCHAR2(30) | No |   |   |
AMRCONF_COMMENT |   | LONG | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRCONF_IDEN_CODE | GURIDEN_IDEN_CODE | GURIDEN |
AMRCONF_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRCONF | Unique | AMRCONF_PIDM |
PK_AMRCONF | Unique | AMRCONF_GRP_SEQ_NO |
PK_AMRCONF | Unique | AMRCONF_IDEN_CODE |
PK_AMRCONF | Unique | AMRCONF_USER_ID |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMVPCMT | SQL View | S10B80.BANINST1 | Use (select) |
AMRCONF_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRCONFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
F_INLONG_AMRCONF | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
F_LONGTOCHAR_AMRCONF | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
AMRCONF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRCONF | SQL Index | S10B80.ALUMNI | Rely On |
GURIDEN | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:57:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRCONT_PIDM |   | NUMBER(8,0) | No | * |   |
AMRCONT_IDEN_CODE |   | VARCHAR2(5) | No |   | * |
AMRCONT_PROJ_CODE |   | VARCHAR2(6) | Yes |   | * |
AMRCONT_SCNT_CODE |   | VARCHAR2(3) | No |   | * |
AMRCONT_ITEM_REFNO |   | NUMBER(15,0) | No | * |   |
AMRCONT_ACTIVITY_DATE |   | DATE | No |   |   |
AMRCONT_IDEN_CODE_ASGN |   | VARCHAR2(5) | Yes |   | * |
AMRCONT_CONTACT |   | VARCHAR2(2000) | No |   |   |
AMRCONT_CONTACT_DATE |   | DATE | No |   |   |
AMRCONT_CREATE_TICKLER |   | VARCHAR2(1) | Yes |   |   |
AMRCONT_TICKLER |   | VARCHAR2(180) | Yes |   |   |
AMRCONT_TICK_DATE |   | DATE | Yes |   |   |
AMRCONT_TICK_STATUS |   | VARCHAR2(1) | Yes |   |   |
AMRCONT_CONFID_IND |   | VARCHAR2(1) | Yes |   |   |
AMRCONT_MOVE_CODE |   | VARCHAR2(4) | Yes |   | * |
AMRCONT_ASK_AMT |   | NUMBER(11,2) | Yes |   |   |
AMRCONT_PROJ_CODE_2 |   | VARCHAR2(6) | Yes |   | * |
AMRCONT_PROJ_CODE_3 |   | VARCHAR2(6) | Yes |   | * |
AMRCONT_PROJ_CODE_4 |   | VARCHAR2(6) | Yes |   | * |
AMRCONT_ASK_AMT_2 |   | NUMBER(11,2) | Yes |   |   |
AMRCONT_ASK_AMT_3 |   | NUMBER(11,2) | Yes |   |   |
AMRCONT_ASK_AMT_4 |   | NUMBER(11,2) | Yes |   |   |
AMRCONT_PROP_CODE |   | VARCHAR2(6) | Yes |   | * |
AMRCONT_CALL_REPORT |   | LONG | Yes |   |   |
AMRCONT_USER_ID |   | VARCHAR2(30) | No |   |   |
AMRCONT_GEN_CONTACT_IND |   | VARCHAR2(1) | No |   |   |
AMRCONT_STGY_PLAN |   | VARCHAR2(15) | Yes |   |   |
AMRCONT_MOVE_SEQNO |   | NUMBER(15,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRCONT_MOVE_CODE | ATVMOVE_CODE | ATVMOVE |
AMRCONT_IDEN_CODE | GURIDEN_IDEN_CODE | GURIDEN |
AMRCONT_IDEN_CODE_ASGN | GURIDEN_IDEN_CODE | GURIDEN |
AMRCONT_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
AMRCONT_PROJ_CODE_2 | ATVPROJ_CODE | ATVPROJ |
AMRCONT_PROJ_CODE_3 | ATVPROJ_CODE | ATVPROJ |
AMRCONT_PROJ_CODE_4 | ATVPROJ_CODE | ATVPROJ |
AMRCONT_PROP_CODE | ATVPROP_CODE | ATVPROP |
AMRCONT_SCNT_CODE | ATVSCNT_CODE | ATVSCNT |
Index Name | Index Type | Column Name |
---|---|---|
AMRCONT_INDEX_SEQNO |   | AMRCONT_MOVE_SEQNO |
PK_AMRCONT | Unique | AMRCONT_PIDM |
PK_AMRCONT | Unique | AMRCONT_ITEM_REFNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRSTAF | SQL Table | S10B80.ALUMNI | Join |
APTPCHN | SQL Table | S10B80.ALUMNI | Join |
AMVCONT | SQL View | S10B80.BANINST1 | Use (select) |
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_CONTACT_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
REFNO_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKPCNT | Rely On |
AMRCONTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRCONT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
AMRCONT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRCONT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKMOVE | Rely On |
AMRCONT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRCONTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETAMRCONTC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
GETAMRCONTC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRCONTMC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETPASSEDAMRPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
REFNOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
P_GET_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
P_INSERT_CONTACT | Oracle Package Procedure | S10B80.BANINST1.BWDKPCNT | Use (Insert) |
P_SAVE_THE_CHANGES | Oracle Package Procedure | S10B80.BANINST1.BWDKMOVE | Use (update) |
F_ADV_PROSPECT_COUNT | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_ADV_PROSPECT_ROWNUM | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_INLONG_AMRCONT | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
F_LONGTOCHAR_AMRCONT | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
AMRCONT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRCONT_INDEX_SEQNO | SQL Index | S10B80.ALUMNI | Rely On |
PK_AMRCONT | SQL Index | S10B80.ALUMNI | Rely On |
ATVMOVE | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVSCNT | SQL Table | S10B80.ALUMNI | Refer (no action) |
GURIDEN | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:58:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRDESG_PROJ_CODE |   | VARCHAR2(6) | No | * | * |
AMRDESG_DESG |   | VARCHAR2(10) | No | * | * |
AMRDESG_USER |   | VARCHAR2(30) | No |   |   |
AMRDESG_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRDESG_DESG | ADBDESG_DESG | ADBDESG |
AMRDESG_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRDESG | Unique | AMRDESG_PROJ_CODE |
PK_AMRDESG | Unique | AMRDESG_DESG |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRDESG | SQL Index | S10B80.ALUMNI | Rely On |
ADBDESG | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:35:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMREXRT_PIDM |   | NUMBER(8,0) | No |   | * |
AMREXRT_EXRS_CODE |   | VARCHAR2(5) | No |   | * |
AMREXRT_EXT_VALUE |   | VARCHAR2(4) | Yes |   |   |
AMREXRT_EXT_SCORE |   | VARCHAR2(4) | Yes |   |   |
AMREXRT_EXT_LEVEL |   | VARCHAR2(4) | Yes |   |   |
AMREXRT_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMREXRT_EXRS_CODE | ATVEXRS_CODE | ATVEXRS |
AMREXRT_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
AMREXRT_KEY_INDEX | Unique | AMREXRT_PIDM |
AMREXRT_KEY_INDEX | Unique | AMREXRT_EXRS_CODE |
AMREXRT_KEY_INDEX | Unique | AMREXRT_EXT_VALUE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
APVSHR1 | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_EXTERNAL_SOURCE_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
AMREXRTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMREXRT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMREXRT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMREXRT_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
ATVEXRS | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:51:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRINFO_PIDM |   | NUMBER(8,0) | No | * | * |
AMRINFO_REFR_CODE |   | VARCHAR2(2) | No |   | * |
AMRINFO_SYS_IND |   | VARCHAR2(1) | No |   |   |
AMRINFO_STATUS |   | VARCHAR2(1) | No |   | * |
AMRINFO_ACTIVITY_DATE |   | DATE | No |   |   |
AMRINFO_RATE_ENTRY_DATE |   | DATE | Yes |   |   |
AMRINFO_REFERENCE |   | VARCHAR2(30) | Yes |   |   |
AMRINFO_PROSP_RATE |   | NUMBER(11,2) | Yes |   |   |
AMRINFO_TARGET_ASK_DATE |   | DATE | Yes |   |   |
AMRINFO_WEB_GIFT_IND |   | VARCHAR2(1) | Yes |   |   |
AMRINFO_WEB_PLDG_IND |   | VARCHAR2(1) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRINFO_REFR_CODE | ATVREFR_CODE | ATVREFR |
AMRINFO_PIDM | APTPCHN_ASSIGNEE_PIDM | APTPCHN |
AMRINFO_STATUS | ATVPRST_CODE | ATVPRST |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRINFO | Unique | AMRINFO_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPRIN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPRRT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRSTAF | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPRADDR | SQL Table | S10B80.SATURN | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
AMVGEOR | SQL View | S10B80.BANINST1 | Use (select) |
AMVINFO | SQL View | S10B80.BANINST1 | Use (select) |
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
F_PROSPECT_IND | SQL Function | S10B80.BANINST1 | Use (select) |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWAKPLDG | Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWAKLIBS | Rely On |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
PARENT_AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
SPOUSE_AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
WORK_PRST_CODE | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKPLDG | Use (select)Rely On |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
AMRINFOVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKGIFT | Use (select)Rely On |
GETAMRINFOC | Oracle Package Cursor | S10B80.BANINST1.BWAKLIBS | Use (select)Rely On |
PROSPECTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
AMRINFO_REC | Oracle Package Variable | S10B80.BANINST1.BWAKGIFT | Rely On |
P_ADV_PROSPECT_COUNT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
P_ADV_PROSPECT_ROWNUM | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
P_GET_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
F_ADV_PROSPECT_COUNT | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_ADV_PROSPECT_ROWNUM | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_AMRINFO_EXISTS | Oracle Package Function | S10B80.BANINST1.BWAKLIBS | Rely On |
F_GET_PROSPECTS_XML | Oracle Package Function | S10B80.BANINST1.XCHAPERS | Use (select) |
AMRINFO | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRINFO | SQL Index | S10B80.ALUMNI | Rely On |
APTPCHN | SQL Table | S10B80.ALUMNI | Join |
ATVPRST | SQL Table | S10B80.ALUMNI | Join |
ATVREFR | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:08:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPCMT_PIDM |   | NUMBER(8,0) | No | * | * |
AMRPCMT_IDEN_CODE |   | VARCHAR2(5) | No |   |   |
AMRPCMT_GRP_SEQ_NO |   | NUMBER(15,0) | No | * |   |
AMRPCMT_LNE_SEQ_NO |   | NUMBER(23,20) | No | * |   |
AMRPCMT_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPCMT_COMMENT |   | VARCHAR2(60) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPCMT_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRPCMT | Unique | AMRPCMT_PIDM |
PK_AMRPCMT | Unique | AMRPCMT_GRP_SEQ_NO |
PK_AMRPCMT | Unique | AMRPCMT_LNE_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRPCMT | SQL Index | S10B80.ALUMNI | Rely On |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:58:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPLAN_PIDM |   | NUMBER(8,0) | No |   |   |
AMRPLAN_STGY_PLAN |   | VARCHAR2(15) | No |   |   |
AMRPLAN_PROJ_CODE |   | VARCHAR2(6) | No |   | * |
AMRPLAN_IDEN_CODE |   | VARCHAR2(5) | No |   | * |
AMRPLAN_MOVE_CODE |   | VARCHAR2(4) | No |   | * |
AMRPLAN_WAIT_DAYS |   | NUMBER(3,0) | No |   |   |
AMRPLAN_PLAN_DATE |   | DATE | No |   |   |
AMRPLAN_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPLAN_COMMENT |   | VARCHAR2(180) | Yes |   |   |
AMRPLAN_MESSAGE_IND |   | VARCHAR2(1) | Yes |   |   |
AMRPLAN_ACTION_DATE |   | DATE | Yes |   |   |
AMRPLAN_SYS_IND |   | VARCHAR2(1) | Yes |   |   |
AMRPLAN_MOVE_SEQNO |   | NUMBER(15,0) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPLAN_MOVE_CODE | ATVMOVE_CODE | ATVMOVE |
AMRPLAN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
AMRPLAN_IDEN_CODE | GURIDEN_IDEN_CODE | GURIDEN |
Index Name | Index Type | Column Name |
---|---|---|
AMRPLAN_KEY_INDEX |   | AMRPLAN_PIDM |
AMRPLAN_KEY_INDEX |   | AMRPLAN_STGY_PLAN |
AMRPLAN_KEY_INDEX |   | AMRPLAN_PROJ_CODE |
AMRPLAN_KEY_INDEX2 |   | AMRPLAN_STGY_PLAN |
AMRPLAN_KEY_INDEX3 |   | AMRPLAN_PROJ_CODE |
AMRPLAN_KEY_INDEX4 |   | AMRPLAN_IDEN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
ADVMOVE_REC | Oracle Package Type | S10B80.BANINST1.BWACBREF | Rely On |
AMRPLAN_SEARCH_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKMOVE | Rely On |
AMRPLANC_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
AMRPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKMOVE | Rely On |
AMRPLAN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRPLANVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETAMRPLANBYDATEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
GETAMRPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETAMRPLANDATEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANGEORC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANNAMEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANSEQNOC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETPASSEDAMRPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
P_SCHEDULE_DATES | Oracle Package Procedure | S10B80.BANINST1.BWDKMOVE | Use (update) |
P_SAVE_THE_CHANGES | Oracle Package Procedure | S10B80.BANINST1.BWDKMOVE | Use (update,delete) |
P_SAVE_THE_MOVE | Oracle Package Procedure | S10B80.BANINST1.BWDKMOVE | Use (Insert) |
F_BUILD_MONTH | Oracle Package Function | S10B80.BANINST1.BWACXALU | Rely On |
F_BUILD_MONTH | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Rely On |
F_GET_MOVES | Oracle Package Function | S10B80.BANINST1.BWACBREF | Rely On |
F_GET_MOVES | Oracle Package Function | S10B80.BANINST1.BWACBREF | Use (select) |
AMRPLAN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPLAN_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AMRPLAN_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
AMRPLAN_KEY_INDEX3 | SQL Index | S10B80.ALUMNI | Rely On |
AMRPLAN_KEY_INDEX4 | SQL Index | S10B80.ALUMNI | Rely On |
ATVMOVE | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
GURIDEN | SQL Table | S10B80.GENERAL | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:15:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPRIN_PIDM |   | NUMBER(8,0) | No | * | * |
AMRPRIN_PROJ_CODE |   | VARCHAR2(6) | No | * | * |
AMRPRIN_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPRIN_GIVH_CODE |   | VARCHAR2(2) | Yes |   | * |
AMRPRIN_TARGET_ASK_AMT |   | NUMBER(10,2) | Yes |   |   |
AMRPRIN_TARGET_ASK_DATE |   | DATE | Yes |   |   |
AMRPRIN_USER |   | VARCHAR2(30) | No |   |   |
AMRPRIN_PRST_CODE |   | VARCHAR2(1) | Yes |   | * |
AMRPRIN_PRST_DATE |   | DATE | Yes |   |   |
AMRPRIN_PROJ_EFF_FROM_DATE |   | DATE | Yes |   |   |
AMRPRIN_PROJ_EFF_TO_DATE |   | DATE | Yes |   |   |
AMRPRIN_PROJ_TEXT |   | VARCHAR2(2000) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPRIN_PIDM | AMRINFO_PIDM | AMRINFO |
AMRPRIN_GIVH_CODE | ATVGIVH_CODE | ATVGIVH |
AMRPRIN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
AMRPRIN_PRST_CODE | ATVPRST_CODE | ATVPRST |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRPRIN | Unique | AMRPRIN_PIDM |
PK_AMRPRIN | Unique | AMRPRIN_PROJ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_PROJECT_CODE_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
AMRPRIN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
AMRPRIN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMRPRIN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
AMRPRIN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRPRINVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
AMRPRINVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
P_INSERT_CONTACT | Oracle Package Procedure | S10B80.BANINST1.BWDKPCNT | Use (Insert) |
AMRPRIN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRPRIN | SQL Index | S10B80.ALUMNI | Rely On |
AMRINFO | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVGIVH | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPRST | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:51:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPROP_PIDM |   | NUMBER(8,0) | No | * | * |
AMRPROP_PROP_CODE |   | VARCHAR2(6) | No | * | * |
AMRPROP_PROJ_CODE |   | VARCHAR2(6) | No | * |   |
AMRPROP_USER |   | VARCHAR2(30) | No |   |   |
AMRPROP_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPROP_GIVH_CODE |   | VARCHAR2(2) | Yes |   | * |
AMRPROP_TARGET_ASK_AMOUNT |   | NUMBER(11,2) | Yes |   |   |
AMRPROP_TARGET_ASK_DATE |   | DATE | Yes |   |   |
AMRPROP_PRST_CODE |   | VARCHAR2(1) | Yes |   | * |
AMRPROP_PRST_DATE |   | DATE | Yes |   |   |
AMRPROP_PROJ_EFF_FROM_DATE |   | DATE | Yes |   |   |
AMRPROP_PROJ_EFF_TO_DATE |   | DATE | Yes |   |   |
AMRPROP_PROJ_TEXT |   | VARCHAR2(2000) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPROP_GIVH_CODE | ATVGIVH_CODE | ATVGIVH |
AMRPROP_PIDM | AMBPROP_PIDM | AMBPROP |
AMRPROP_PROP_CODE | AMBPROP_PROP_CODE | AMBPROP |
AMRPROP_PRST_CODE | ATVPRST_CODE | ATVPRST |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRPROP | Unique | AMRPROP_PIDM |
PK_AMRPROP | Unique | AMRPROP_PROP_CODE |
PK_AMRPROP | Unique | AMRPROP_PROJ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPROP_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRPROPVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
PROPPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
AMRPROP | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRPROP | SQL Index | S10B80.ALUMNI | Rely On |
AMBPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVGIVH | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPRST | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:00:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPRRT_PIDM |   | NUMBER(8,0) | No |   | * |
AMRPRRT_RTGT_CODE |   | VARCHAR2(1) | No |   | * |
AMRPRRT_RATE_CODE |   | VARCHAR2(2) | No |   | * |
AMRPRRT_RSCR_CODE |   | VARCHAR2(5) | No |   | * |
AMRPRRT_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPRRT_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
AMRPRRT_IDEN_CODE |   | VARCHAR2(5) | Yes |   |   |
AMRPRRT_RATING_PIDM |   | NUMBER(8,0) | Yes |   |   |
AMRPRRT_USER |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPRRT_PIDM | AMRINFO_PIDM | AMRINFO |
AMRPRRT_RATE_CODE | ATVRATE_CODE | ATVRATE |
AMRPRRT_RSCR_CODE | ATVRSCR_CODE | ATVRSCR |
AMRPRRT_RTGT_CODE | ATVRTGT_CODE | ATVRTGT |
Index Name | Index Type | Column Name |
---|---|---|
AMRPRRT_KEY_INDEX |   | AMRPRRT_PIDM |
AMRPRRT_KEY_INDEX2 |   | AMRPRRT_PIDM |
AMRPRRT_KEY_INDEX2 |   | AMRPRRT_RATE_CODE |
AMRPRRT_KEY_INDEX2 |   | AMRPRRT_RTGT_CODE |
AMRPRRT_KEY_INDEX2 |   | AMRPRRT_RSCR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_RATING_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
AMRPRRTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRPRRT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMRPRRT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
AMRPRRT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPRRT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPRRT_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AMRPRRT_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
AMRINFO | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVRATE | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVRSCR | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVRTGT | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:02:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPRSC_PIDM |   | NUMBER(8,0) | No |   | * |
AMRPRSC_IDEN_CODE_RSCH |   | VARCHAR2(5) | No |   | * |
AMRPRSC_PREPARED_DATE |   | DATE | No |   |   |
AMRPRSC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPRSC_IDEN_CODE_RSCH | GURIDEN_IDEN_CODE | GURIDEN |
AMRPRSC_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
AMRPRSC_KEY_INDEX |   | AMRPRSC_PIDM |
AMRPRSC_KEY_INDEX |   | AMRPRSC_IDEN_CODE_RSCH |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMVPRSC | SQL View | S10B80.BANINST1 | Use (select) |
AMRPRSC_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPRSCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
AMRPRSC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPRSC_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
GURIDEN | SQL Table | S10B80.GENERAL | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:05:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPSRC_PIDM |   | NUMBER(8,0) | No |   | * |
AMRPSRC_SORC_CODE |   | VARCHAR2(6) | No |   | * |
AMRPSRC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPSRC_SORC_CODE | ATVSORC_CODE | ATVSORC |
AMRPSRC_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
AMRPSRC_KEY_INDEX |   | AMRPSRC_PIDM |
AMRPSRC_KEY_INDEX |   | AMRPSRC_SORC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPSRC_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPSRCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
AMRPSRC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPSRC_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
ATVSORC | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:13:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRPUSR_PIDM |   | NUMBER(8,0) | No |   | * |
AMRPUSR_USRC_CODE |   | VARCHAR2(20) | No |   | * |
AMRPUSR_ACTIVITY_DATE |   | DATE | No |   |   |
AMRPUSR_SEQNO |   | NUMBER(23,20) | No |   |   |
AMRPUSR_VALUE |   | LONG | No |   |   |
AMRPUSR_EFFECT_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRPUSR_USRC_CODE | ATVUSRC_CODE | ATVUSRC |
AMRPUSR_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
AMRPUSR_KEY_INDEX | Unique | AMRPUSR_PIDM |
AMRPUSR_KEY_INDEX | Unique | AMRPUSR_USRC_CODE |
AMRPUSR_KEY_INDEX2 | Unique | AMRPUSR_PIDM |
AMRPUSR_KEY_INDEX2 | Unique | AMRPUSR_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPUSR_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPUSRVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
F_INLONG_AMRPUSR | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
F_LONGTOCHAR_AMRPUSR | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
AMRPUSR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPUSR_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AMRPUSR_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
ATVUSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:51:000 | 04/02/2008 13:49:23:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRSTAF_PIDM |   | NUMBER(8,0) | No |   | * |
AMRSTAF_STFT_CODE |   | VARCHAR2(4) | No |   | * |
AMRSTAF_IDEN_CODE |   | VARCHAR2(5) | Yes |   | * |
AMRSTAF_ACTIVITY_DATE |   | DATE | No |   |   |
AMRSTAF_SOLICIT_IND |   | VARCHAR2(1) | Yes |   |   |
AMRSTAF_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
AMRSTAF_STAFF_PIDM |   | NUMBER(8,0) | Yes |   |   |
AMRSTAF_USER |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRSTAF_STFT_CODE | ATVSTFT_CODE | ATVSTFT |
AMRSTAF_PIDM | AMRINFO_PIDM | AMRINFO |
AMRSTAF_IDEN_CODE | GURIDEN_IDEN_CODE | GURIDEN |
AMRSTAF_PIDM | APBGHIS_PIDM | APBGHIS |
AMRSTAF_PIDM | AMRCONT_PIDM | AMRCONT |
AMRSTAF_IDEN_CODE | AMRCONT_IDEN_CODE | AMRCONT |
Index Name | Index Type | Column Name |
---|---|---|
AMRSTAF_KEY_INDEX1 |   | AMRSTAF_PIDM |
AMRSTAF_KEY_INDEX1 |   | AMRSTAF_STFT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
AMVPRS1 | SQL View | S10B80.BANINST1 | Use (select) |
AMVSTAF | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_STAFF_ASSIGNMENT_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
AMRSTAF_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKPCNT | Rely On |
PROSPECT_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKLIBS | Rely On |
AMRSTAFALLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRSTAFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
AMRSTAF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRSTAFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
AMRSTAFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GET_AMRSTAF_C | Oracle Package Cursor | S10B80.BANINST1.BWACBREF | Rely On |
GET_AMRSTAF_C | Oracle Package Cursor | S10B80.BANINST1.BWACBREF | Use (select) |
STAFIDENVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select) |
STAFSPRIDENVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select) |
STAFSPRIDENVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select) |
P_BUILD_TEMP_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Rely On |
GETPROSPECTSC | Oracle Package Cursor | S10B80.BANINST1.BWAKLIBS | Use (select) |
P_GET_GIFT_INFO | Oracle Package Procedure | S10B80.BANINST1.AOKWEVN | Rely On |
P_GET_GIFT_INFO | Oracle Package Procedure | S10B80.BANINST1.AOKWEVN | Use (select) |
F_ADV_PROSPECT_COUNT | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_ADV_PROSPECT_ROWNUM | Oracle Package Function | S10B80.BANINST1.BWACXALU | Use (select) |
F_GET_PROSPECTS_XML | Oracle Package Function | S10B80.BANINST1.XCHAPERS | Use (select) |
AMRSTAF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRSTAF_KEY_INDEX1 | SQL Index | S10B80.ALUMNI | Rely On |
AMRCONT | SQL Table | S10B80.ALUMNI | Join |
AMRINFO | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBGHIS | SQL Table | S10B80.ALUMNI | Join |
ATVSTFT | SQL Table | S10B80.ALUMNI | Refer (no action) |
GURIDEN | SQL Table | S10B80.GENERAL | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:35:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRSTGY_STGY_PLAN |   | VARCHAR2(15) | No |   |   |
AMRSTGY_MOVE_CODE |   | VARCHAR2(4) | No |   | * |
AMRSTGY_STGY_SEQNO |   | NUMBER(23,20) | No |   |   |
AMRSTGY_WAIT_DAYS |   | NUMBER(3,0) | No |   |   |
AMRSTGY_ACTIVITY_DATE |   | DATE | No |   |   |
AMRSTGY_PROJ_CODE |   | VARCHAR2(6) | Yes |   | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRSTGY_MOVE_CODE | ATVMOVE_CODE | ATVMOVE |
AMRSTGY_PROJ_CODE | ATVPROJ_CODE | ATVPROJ |
Index Name | Index Type | Column Name |
---|---|---|
AMRSTGY_KEY_INDEX | Unique | AMRSTGY_STGY_PLAN |
AMRSTGY_KEY_INDEX | Unique | AMRSTGY_PROJ_CODE |
AMRSTGY_KEY_INDEX | Unique | AMRSTGY_MOVE_CODE |
AMRSTGY_KEY_INDEX | Unique | AMRSTGY_STGY_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRSTGY_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
ATVMOVE | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:43:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AMRSUBJ_PIDM |   | NUMBER(8,0) | No | * | * |
AMRSUBJ_IDEN_CODE |   | VARCHAR2(5) | No | * |   |
AMRSUBJ_SUBJ_CODE |   | VARCHAR2(6) | No | * | * |
AMRSUBJ_GRP_SEQ_NO |   | NUMBER(15,0) | No | * |   |
AMRSUBJ_ACTIVITY_DATE |   | DATE | No |   |   |
AMRSUBJ_USER |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AMRSUBJ_SUBJ_CODE | GTVSUBJ_CODE | GTVSUBJ |
AMRSUBJ_PIDM | SPRIDEN_PIDM | SPRIDEN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AMRSUBJ | Unique | AMRSUBJ_PIDM |
PK_AMRSUBJ | Unique | AMRSUBJ_GRP_SEQ_NO |
PK_AMRSUBJ | Unique | AMRSUBJ_SUBJ_CODE |
PK_AMRSUBJ | Unique | AMRSUBJ_IDEN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRSUBJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
AMRSUBJ_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRSUBJ | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AMRSUBJ | SQL Index | S10B80.ALUMNI | Rely On |
GTVSUBJ | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:47:27:000 | 04/02/2008 13:49:23:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APTPCHN_STAFF_PIDM |   | NUMBER(8,0) | No | * |   |
APTPCHN_ASSIGNEE_PIDM |   | NUMBER(8,0) | No | * | * |
APTPCHN_ID |   | VARCHAR2(9) | No |   |   |
APTPCHN_ENTITY_IND |   | VARCHAR2(1) | No |   |   |
APTPCHN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
APTPCHN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APTPCHN_MI |   | VARCHAR2(60) | Yes |   |   |
APTPCHN_USER |   | VARCHAR2(30) | No |   |   |
APTPCHN_ACTIVITY_DATE |   | DATE | No |   |   |
APTPCHN_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
APTPCHN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APTPCHN_ASSIGNEE_PIDM | APBGHIS_PIDM | APBGHIS |
APTPCHN_ASSIGNEE_PIDM | AMRCONT_PIDM | AMRCONT |
Index Name | Index Type | Column Name |
---|---|---|
APTPCHN_NAME_INDEX |   | APTPCHN_LAST_NAME |
APTPCHN_NAME_INDEX |   | APTPCHN_FIRST_NAME |
APTPCHN_NAME_INDEX |   | APTPCHN_MI |
SYS_C0016386 | Unique | APTPCHN_STAFF_PIDM |
SYS_C0016386 | Unique | APTPCHN_ASSIGNEE_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRINFO | SQL Table | S10B80.ALUMNI | Join |
SEL_APTPCHN_TYPE | Oracle Package Type | S10B80.BANINST1.BWACBREF | Rely On |
P_BUILD_TEMP_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Rely On |
P_BUILD_TEMP_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (Insert,delete) |
P_ADV_PROSPECT_COUNT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
P_ADV_PROSPECT_ROWNUM | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
P_GET_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Use (select) |
F_GET_ADV_PROSPECT | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Use (delete) |
APTPCHN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APTPCHN_NAME_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
SYS_C0016386 | SQL Index | S10B80.ALUMNI | Rely On |
AMRCONT | SQL Table | S10B80.ALUMNI | Join |
APBGHIS | SQL Table | S10B80.ALUMNI | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:50:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVEXRS_CODE |   | VARCHAR2(5) | No | * |   |
ATVEXRS_DESC |   | VARCHAR2(30) | No |   |   |
ATVEXRS_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVEXRS | Unique | ATVEXRS_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMREXRT | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
ATVEXRSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
ATVEXRS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
ATVEXRSC | Oracle Package Cursor | S10B80.BANINST1.ATKEXRS | Use (select)Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.AOKPVAL | Rely On |
ATVEXRS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVEXRS | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:44:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVGIVH_CODE |   | VARCHAR2(2) | No | * |   |
ATVGIVH_DESC |   | VARCHAR2(30) | No |   |   |
ATVGIVH_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVGIVH | Unique | ATVGIVH_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPRIN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
ATVGIVH_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
ATVGIVHVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
ATVGIVH | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVGIVH | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:47:05:000 | 04/02/2008 13:49:23:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVMOVE_CODE |   | VARCHAR2(4) | No | * |   |
ATVMOVE_DESC |   | VARCHAR2(30) | No |   |   |
ATVMOVE_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVMOVE | Unique | ATVMOVE_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPLAN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRSTGY | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMOVE_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
ATVMOVE_REC | Oracle Package Variable | S10B80.BANINST1.BWDKMOVE | Rely On |
ATVMOVE_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
ATVMOVEVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
ATVMOVEVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETATVMOVEC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
GETATVMOVEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETATVMOVEC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
MOVE_CODE | Oracle Package Variable | S10B80.BANINST1.BWDKMOVE | Rely On |
ATVMOVE | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVMOVE | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:03:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVPROJ_CODE |   | VARCHAR2(6) | No | * |   |
ATVPROJ_DESC |   | VARCHAR2(30) | No |   |   |
ATVPROJ_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVPROJ | Unique | ATVPROJ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMBPLAN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMBSTGY | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRDESG | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPLAN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPRIN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRSTGY | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMVCONT | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
AMBPLAN_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKMOVE | Rely On |
AMBPLAN_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKPPRF | Rely On |
AMRPLAN_SEARCH_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKMOVE | Rely On |
ATVPROJ_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
ATVPROJ_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
ATVPROJ_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
ATVPROJ_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
ATVPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
ATVPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETAMBPLANC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANDESCC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANDESCC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETAMBPLANIDENC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANSTGYC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMBPLANSTGYC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETAMRPLANDATEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANGEORC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANNAMEC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETAMRPLANPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETATVPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
GETATVPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
GETATVPROJC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select) |
GETSTRATEGIESC | Oracle Package Cursor | S10B80.BANINST1.BWDKMOVE | Use (select) |
PROPPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
PROSPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
PROSPROJVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
ATVPROJ | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVPROJ | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:51:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVPROP_CODE |   | VARCHAR2(6) | No | * |   |
ATVPROP_DESC |   | VARCHAR2(30) | No |   |   |
ATVPROP_ACTIVITY_DATE |   | DATE | No |   |   |
ATVPROP_USER |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVPROP | Unique | ATVPROP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMBPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVPROP_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
ATVPROP_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
ATVPROPVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
ATVPROPVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
ATVPROP | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVPROP | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:52:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVPRST_CODE |   | VARCHAR2(1) | No | * |   |
ATVPRST_DESC |   | VARCHAR2(30) | No |   |   |
ATVPRST_ACTIVITY_DATE |   | DATE | No |   |   |
ATVPRST_ACTIVE_IND |   | VARCHAR2(1) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVPRST | Unique | ATVPRST_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMBPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRINFO | SQL Table | S10B80.ALUMNI | Join |
AMRPRIN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPROP | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
STATUS_REC | Oracle Package Type | S10B80.BANINST1.BWACBREF | Rely On |
ATVPRSTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
ATVPRST_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
ATVPRST_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
ATVPRST_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
ATVPRST_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVPRST_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
ATVPRSTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
ATVPRSTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
ATVPRSTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVPRSTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
F_GET_STATUS_DESC | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Rely On |
F_GET_STATUS_DESC | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Use (select) |
P_ADV_PROSPECT_COUNT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Rely On |
P_ADV_PROSPECT_ROWNUM | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Rely On |
P_GET_ADV_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.BWACBREF | Rely On |
F_GET_ADV_PROSPECT | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Rely On |
F_GET_ADV_STATUS_EDIT | Oracle Package Function | S10B80.BANINST1.BWACXCHN | Rely On |
F_GET_PREF_STATUS | Oracle Package Function | S10B80.BANINST1.BWACBREF | Rely On |
F_GET_PREF_STATUS | Oracle Package Function | S10B80.BANINST1.BWACBREF | Use (select) |
F_GET_PROSPECTS_XML | Oracle Package Function | S10B80.BANINST1.XCHAPERS | Use (select) |
F_GET_STATUSES | Oracle Package Function | S10B80.BANINST1.BWACBREF | Rely On |
F_GET_STATUSES | Oracle Package Function | S10B80.BANINST1.BWACBREF | Use (select) |
ATVPRST | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVPRST | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:01:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVREFR_CODE |   | VARCHAR2(2) | No | * |   |
ATVREFR_DESC |   | VARCHAR2(30) | No |   |   |
ATVREFR_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVREFR | Unique | ATVREFR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRINFO | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMVINFO | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
ATVREFR_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVREFRVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVREFR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVREFR | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:57:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVSCNT_CODE |   | VARCHAR2(3) | No | * |   |
ATVSCNT_DESC |   | VARCHAR2(30) | No |   |   |
ATVSCNT_ACTIVITY_DATE |   | DATE | No |   |   |
ATVSCNT_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVSCNT | Unique | ATVSCNT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AFRCRES | SQL Table | S10B80.ALUMNI | Refer (no action) |
AGBPDEF | SQL Table | S10B80.ALUMNI | Refer (no action) |
AGBWPLG | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMVCONT | SQL View | S10B80.BANINST1 | Use (select) |
RESULT_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKVOPP | Rely On |
ATVSCNTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
ATVSCNT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPCNT | Rely On |
ATVSCNT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
ATVSCNT_REC | Oracle Package Variable | S10B80.BANINST1.BWAKVOPP | Rely On |
ATVSCNT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
AFRCRESVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKVOPP | Use (select) |
ATVSCNTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select)Rely On |
ATVSCNTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
GETATVSCNTC | Oracle Package Cursor | S10B80.BANINST1.BWDKPCNT | Use (select) |
ATVSCNTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKVOPP | Use (select)Rely On |
ATVSCNT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVSCNT | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:03:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVSORC_CODE |   | VARCHAR2(6) | No | * |   |
ATVSORC_DESC |   | VARCHAR2(60) | No |   |   |
ATVSORC_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVSORC | Unique | ATVSORC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPSRC_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPSRCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
ATVSORC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVSORC | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:14:000 | 04/02/2008 13:49:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVSTFT_CODE |   | VARCHAR2(4) | No | * |   |
ATVSTFT_DESC |   | VARCHAR2(30) | No |   |   |
ATVSTFT_ACTIVITY_DATE |   | DATE | No |   |   |
ATVSTFT_SOLICIT_IND |   | VARCHAR2(1) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVSTFT | Unique | ATVSTFT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRSTAF | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMVSTAF | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
ATVSTFTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
ATVSTFT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
ATVSTFTC | Oracle Package Cursor | S10B80.BANINST1.ATKSTFT | Use (select)Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.AOKPVAL | Rely On |
ATVSTFT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVSTFT | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:47:22:000 | 04/02/2008 13:49:23:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVUSRC_CODE |   | VARCHAR2(20) | No | * |   |
ATVUSRC_DESC |   | VARCHAR2(40) | No |   |   |
ATVUSRC_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVUSRC | Unique | ATVUSRC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AMRPUSR | SQL Table | S10B80.ALUMNI | Refer (no action) |
AMRPUSR_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKLIBS | Rely On |
AMRPUSRVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select) |
ATVUSRC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVUSRC | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:36:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRADDR_PIDM |   | NUMBER(8,0) | No |   | * |
SPRADDR_ATYP_CODE |   | VARCHAR2(2) | No |   | * |
SPRADDR_SEQNO |   | NUMBER(2,0) | No |   | * |
SPRADDR_FROM_DATE |   | DATE | Yes |   |   |
SPRADDR_TO_DATE |   | DATE | Yes |   |   |
SPRADDR_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_CITY |   | VARCHAR2(50) | No |   | * |
SPRADDR_STAT_CODE |   | VARCHAR2(3) | Yes |   | * |
SPRADDR_ZIP |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_CNTY_CODE |   | VARCHAR2(5) | Yes |   | * |
SPRADDR_NATN_CODE |   | VARCHAR2(5) | Yes |   | * |
SPRADDR_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
SPRADDR_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
SPRADDR_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
SPRADDR_STATUS_IND |   | VARCHAR2(1) | Yes |   |   |
SPRADDR_ACTIVITY_DATE |   | DATE | No |   |   |
SPRADDR_USER |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_ASRC_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRADDR_DELIVERY_POINT |   | NUMBER(2,0) | Yes |   |   |
SPRADDR_CORRECTION_DIGIT |   | NUMBER(1,0) | Yes |   |   |
SPRADDR_CARRIER_ROUTE |   | VARCHAR2(4) | Yes |   |   |
SPRADDR_GST_TAX_ID |   | VARCHAR2(15) | Yes |   |   |
SPRADDR_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
SPRADDR_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
SPRADDR_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
SPRADDR_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRADDR_ASRC_CODE | STVASRC_CODE | STVASRC |
SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP |
SPRADDR_CNTY_CODE | STVCNTY_CODE | STVCNTY |
SPRADDR_NATN_CODE | STVNATN_CODE | STVNATN |
SPRADDR_STAT_CODE | STVSTAT_CODE | STVSTAT |
SPRADDR_PIDM | GORCGEO_PIDM | GORCGEO |
SPRADDR_ATYP_CODE | GORCGEO_ATYP_CODE | GORCGEO |
SPRADDR_SEQNO | GORCGEO_ADDR_SEQNO | GORCGEO |
SPRADDR_ATYP_CODE | GTVSDAX_EXTERNAL_CODE | GTVSDAX |
SPRADDR_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRADDR_PIDM | SARADAP_PIDM | SARADAP |
SPRADDR_PIDM | AMRINFO_PIDM | AMRINFO |
SPRADDR_CITY | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_STAT_CODE | SORGEOR_END_RANGE | SORGEOR |
SPRADDR_STAT_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_CNTY_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_NATN_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_PIDM | SFBETRM_PIDM | SFBETRM |
SPRADDR_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRADDR_PIDM | PABAPPL_PIDM | PABAPPL |
SPRADDR_ATYP_CODE | APBCONS_ATYP_CODE_PREF | APBCONS |
SPRADDR_PIDM | SRBRECR_PIDM | SRBRECR |
SPRADDR_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRADDR_ATYP_CODE | GORSVAS_ATYP_CODE | GORSVAS |
SPRADDR_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRADDR_ATYP_CODE | GORSVEI_ATYP_CODE | GORSVEI |
SPRADDR_ATYP_CODE | AOBORGN_ATYP_CODE | AOBORGN |
SPRADDR_SEQNO | SPRTELE_ADDR_SEQNO | SPRTELE |
SPRADDR_ATYP_CODE | SPRTELE_ATYP_CODE | SPRTELE |
SPRADDR_PIDM | SPRTELE_PIDM | SPRTELE |
SPRADDR_ATYP_CODE | SARERUL_VALUE | SARERUL |
SPRADDR_ATYP_CODE | GORICCR_VALUE | GORICCR |
SPRADDR_STAT_CODE | SPRCOLR_VALUE_ATYP | SPRCOLR |
SPRADDR_ATYP_CODE | GORADRL_ATYP_CODE | GORADRL |
SPRADDR_ATYP_CODE | SORMSTA_ATYP_CODE | SORMSTA |
SPRADDR_STAT_CODE | SORMSTA_STAT_CODE | SORMSTA |
Index Name | Index Type | Column Name |
---|---|---|
SPRADDR_KEY_INDEX | Unique | SPRADDR_PIDM |
SPRADDR_KEY_INDEX | Unique | SPRADDR_ATYP_CODE |
SPRADDR_KEY_INDEX | Unique | SPRADDR_SEQNO |
SPRADDR_KEY_INDEX | Unique | SPRADDR_STATUS_IND |
SPRADDR_KEY_INDEX2 |   | SPRADDR_PIDM |
SPRADDR_KEY_INDEX2 |   | SPRADDR_ATYP_CODE |
SPRADDR_KEY_INDEX2 |   | SPRADDR_SEQNO |
SPRADDR_KEY_INDEX2 |   | SPRADDR_STATUS_IND |
SPRADDR_KEY_INDEX2 |   | SPRADDR_FROM_DATE |
SPRADDR_KEY_INDEX2 |   | SPRADDR_TO_DATE |
SPRADDR_KEY_INDEX3 |   | SPRADDR_USER |
SPRADDR_KEY_INDEX3 |   | SPRADDR_ASRC_CODE |
SPRADDR_KEY_INDEX3 |   | SPRADDR_ACTIVITY_DATE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRADDR_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
SPRADDR_KEY_INDEX2 | SQL Index | S10B80.SATURN | Rely On |
SPRADDR_KEY_INDEX3 | SQL Index | S10B80.SATURN | Rely On |
AMRINFO | SQL Table | S10B80.ALUMNI | Join |
AOBORGN | SQL Table | S10B80.ALUMNI | Join |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
GORADRL | SQL Table | S10B80.GENERAL | Join |
GORCGEO | SQL Table | S10B80.GENERAL | Join |
GORICCR | SQL Table | S10B80.GENERAL | Join |
GORSVAS | SQL Table | S10B80.GENERAL | Join |
GORSVEI | SQL Table | S10B80.GENERAL | Join |
GTVSDAX | SQL Table | S10B80.GENERAL | Join |
NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
PABAPPL | SQL Table | S10B80.PAYROLL | Join |
PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
SARADAP | SQL Table | S10B80.SATURN | Join |
SARERUL | SQL Table | S10B80.SATURN | Join |
SFBETRM | SQL Table | S10B80.SATURN | Join |
SORGEOR | SQL Table | S10B80.SATURN | Join |
SORMSTA | SQL Table | S10B80.SATURN | Join |
SPRCOLR | SQL Table | S10B80.SATURN | Join |
SPRTELE | SQL Table | S10B80.SATURN | Join |
SRBRECR | SQL Table | S10B80.SATURN | Join |
STVASRC | SQL Table | S10B80.SATURN | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCNTY | SQL Table | S10B80.SATURN | Refer (no action) |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
ST_SPRADDR_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
ST_SPRADDR_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
ST_SPRADDR_DELETE_ROW | SQL Trigger | S10B80.SATURN | Fire (delete,before,each row) |
ST_SPRADDR_INSERT_ROW | SQL Trigger | S10B80.SATURN | Fire (Insert,before,each row) |
ST_SPRADDR_UPDATE_ROW | SQL Trigger | S10B80.SATURN | Fire (update,before,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:57:07:000 | 04/02/2008 21:18:18: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 |
Objects list |
---|
schema-view : S10B80.BANINST1.AMVINFO
schema-view : S10B80.BANINST1.AMVPRS1 scope-cursor : S10B80.BANINST1.BWDKPCNT.PROSPECTVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AMRINFO | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AMRINFO |
Objects list |
---|
schema-view : S10B80.BANINST1.AMVGEOR |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRADDR and AMRINFO | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRADDR | AMRINFO |
Objects list |
---|
schema-view : S10B80.BANINST1.SPVADDF_OJ
schema-view : S10B80.BANINST1.SPVADDS_OJ schema-view : S10B80.BANINST1.SOVGEOR schema-view : S10B80.BANINST1.AOVIDEN schema-view : S10B80.BANINST1.AOVCOMP schema-view : S10B80.BANINST1.SPVADDF schema-view : S10B80.BANINST1.SPVADDR schema-view : S10B80.BANINST1.SPVPERS schema-view : S10B80.BANINST1.SPVADDS schema-view : S10B80.BANINST1.ALVADDS scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_IDNAME_SEARCH scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_SSNNAME_SEARCH scope-procedure : S10B80.BANINST1.BWFKVREQ.P_VIEWREQ scope-function : S10B80.BANINST1.TEST_LVH.F_IDNAME_SEARCH scope-procedure : S10B80.BANINST1.BWFKVPUR.P_VIEWPUR scope-procedure : S10B80.BANINST1.BWFKVINV.P_VIEWINV |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and SPRADDR | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | SPRADDR |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRPRSC and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRPRSC | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRCONF and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRCONF | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRSUBJ and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRSUBJ | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRPSRC and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRPSRC | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRPUSR and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRPUSR | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRPCMT and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRPCMT | SPRIDEN |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMREXRT and SPRIDEN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMREXRT | SPRIDEN |
Objects list |
---|
scope-function : S10B80.BANINST1.BWACXALU.F_ADV_PROSPECT_COUNT
scope-function : S10B80.BANINST1.BWACXALU.F_ADV_PROSPECT_ROWNUM scope-cursor : S10B80.BANINST1.BWAKLIBS.GETPROSPECTSC scope-cursor : S10B80.BANINST1.BWACBREF.GET_AMRSTAF_C scope-function : S10B80.BANINST1.XCHAPERS.F_GET_PROSPECTS_XML |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AMRSTAF | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AMRSTAF |
Objects list |
---|
scope-function : S10B80.BANINST1.BWACXALU.F_ADV_PROSPECT_COUNT
scope-function : S10B80.BANINST1.BWACXALU.F_ADV_PROSPECT_ROWNUM |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRSTAF and AMRCONT | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRSTAF | AMRCONT |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWDKMOVE.GETAMRPLANNAMEC
scope-cursor : S10B80.BANINST1.BWDKMOVE.GETAMRPLANDATEC scope-cursor : S10B80.BANINST1.BWDKMOVE.GETAMRPLANPROJC scope-cursor : S10B80.BANINST1.BWDKMOVE.GETAMRPLANGEORC |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AMRPLAN | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AMRPLAN |
Objects list |
---|
scope-procedure : S10B80.BANINST1.BWACBREF.P_GET_ADV_PROSPECT
scope-procedure : S10B80.BANINST1.BWACBREF.P_ADV_PROSPECT_COUNT scope-procedure : S10B80.BANINST1.BWACBREF.P_ADV_PROSPECT_ROWNUM |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRINFO and APTPCHN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRINFO | APTPCHN |
Objects list |
---|
scope-procedure : S10B80.BANINST1.BWACBREF.P_GET_ADV_PROSPECT |
Link Type | Link | Project |
---|---|---|
Join | Link Between APTPCHN and AMRCONT | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APTPCHN | AMRCONT |
Objects list |
---|
scope-function : S10B80.BANINST1.XCHAPERS.F_GET_PROSPECTS_XML |
Link Type | Link | Project |
---|---|---|
Join | Link Between AMRINFO and ATVPRST | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AMRINFO | ATVPRST |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVMOVE (FK1_AMRCONT_INV_ATVMOVE_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_MOVE_CODE | ATVMOVE_CODE | ATVMOVE | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMREXRT and ATVEXRS (FK1_AMREXRT_EXRS_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMREXRT | AMREXRT_EXRS_CODE | ATVEXRS_CODE | ATVEXRS | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPRIN and AMRINFO (FK1_AMRPRIN_INV_AMRINFO_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPRIN | AMRPRIN_PIDM | AMRINFO_PIDM | AMRINFO | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPRRT and AMRINFO (FK1_AMRPRRT_INV_AMRINFO_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPRRT | AMRPRRT_PIDM | AMRINFO_PIDM | AMRINFO | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMBPLAN and ATVPROJ (FK1_AMBPLAN_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMBPLAN | AMBPLAN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMBSTGY and ATVPROJ (FK1_AMBSTGY_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMBSTGY | AMBSTGY_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVPROJ (FK1_AMRCONT_INV_ATVPROJ_CODE) | ALUMNI |
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVPROJ (FK2_AMRCONT_INV_ATVPROJ_CODE) | ALUMNI |
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVPROJ (FK3_AMRCONT_INV_ATVPROJ_CODE) | ALUMNI |
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVPROJ (FK4_AMRCONT_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_PROJ_CODE_2 | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_PROJ_CODE_3 | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_PROJ_CODE_4 | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRDESG and ATVPROJ (FK1_AMRDESG_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRDESG | AMRDESG_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPRIN and ATVPROJ (FK1_AMRPRIN_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPRIN | AMRPRIN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVPROP (FK1_AMRCONT_INV_ATVPROP_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_PROP_CODE | ATVPROP_CODE | ATVPROP | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRINFO and ATVREFR (FK1_AMRINFO_INV_ATVREFR_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRINFO | AMRINFO_REFR_CODE | ATVREFR_CODE | ATVREFR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPRIN and ATVPRST (FK1_AMRPRIN_INV_ATVPRST_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPRIN | AMRPRIN_PRST_CODE | ATVPRST_CODE | ATVPRST | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPROP and ATVPRST (FK1_AMRPROP_INV_ATVPRST_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPROP | AMRPROP_PRST_CODE | ATVPRST_CODE | ATVPRST | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPSRC and ATVSORC (FK1_AMRPSRC_INV_ATVSORC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPSRC | AMRPSRC_SORC_CODE | ATVSORC_CODE | ATVSORC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPLAN and ATVMOVE (FK1_AMRPLAN_INV_ATVMOVE_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPLAN | AMRPLAN_MOVE_CODE | ATVMOVE_CODE | ATVMOVE | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPLAN and ATVPROJ (FK1_AMRPLAN_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPLAN | AMRPLAN_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRCONT and ATVSCNT (FK1_AMRCONT_INV_ATVSCNT_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRCONT | AMRCONT_SCNT_CODE | ATVSCNT_CODE | ATVSCNT | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRSTAF and AMRINFO (FK1_AMRSTAF_INV_AMRINFO_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRSTAF | AMRSTAF_PIDM | AMRINFO_PIDM | AMRINFO | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRSTGY and ATVMOVE (FK1_AMRSTGY_INV_ATVMOVE_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRSTGY | AMRSTGY_MOVE_CODE | ATVMOVE_CODE | ATVMOVE | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRSTGY and ATVPROJ (FK1_AMRSTGY_INV_ATVPROJ_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRSTGY | AMRSTGY_PROJ_CODE | ATVPROJ_CODE | ATVPROJ | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPUSR and ATVUSRC (FK1_AMRPUSR_INV_ATVUSRC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPUSR | AMRPUSR_USRC_CODE | ATVUSRC_CODE | ATVUSRC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPRIN and ATVGIVH (FK1_AMRPRIN_INV_ATVGIVH_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPRIN | AMRPRIN_GIVH_CODE | ATVGIVH_CODE | ATVGIVH | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRPROP and ATVGIVH (FK1_AMRPROP_INV_ATVGIVH_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRPROP | AMRPROP_GIVH_CODE | ATVGIVH_CODE | ATVGIVH | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AMRSTAF and ATVSTFT (FK1_AMRSTAF_INV_ATVSTFT_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AMRSTAF | AMRSTAF_STFT_CODE | ATVSTFT_CODE | ATVSTFT | (1,1)-(0,n) |