Model Event_Function_Process_Inquiry
Object Name | Object Type | Layer Name |
---|---|---|
GEBFUNC | SQL Table | Default |
GERATTD | SQL Table | Default |
GERFCOM | SQL Table | Default |
GERFCON | SQL Table | Default |
GERFCOR | SQL Table | Default |
GERFEXP | SQL Table | Default |
GERFFEE | SQL Table | Default |
GERFGST | SQL Table | Default |
GERFREV | SQL Table | Default |
GERMENU | SQL Table | Default |
GERPART | SQL Table | Default |
GERSUBJ | SQL Table | Default |
GERTASK | SQL Table | Default |
GERTKID | SQL Table | Default |
GEVATTD | SQL View | Default |
GTVFUNC | SQL Table | Default |
SLBBLDG | SQL Table | Default |
SLBEVNT | SQL Table | Default |
SLBRDEF | SQL Table | Default |
SLRBCAT | SQL Table | Default |
SLRBCMT | SQL Table | Default |
SLRBDEF | SQL Table | Default |
SLRCMNT | SQL Table | Default |
SLRECMT | SQL Table | Default |
SLRRASG | SQL Table | Default |
SLRRDEF | SQL Table | Default |
SLRRUSE | SQL Table | Default |
SPRIDEN | SQL Table | Default |
SSRMEET | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GEBFUNC_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GEBFUNC_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GEBFUNC_ACTIVITY_DATE |   | DATE | No |   |   |
GEBFUNC_ETYP_CODE |   | VARCHAR2(4) | No |   | * |
GEBFUNC_FSTA_CODE |   | VARCHAR2(1) | No |   | * |
GEBFUNC_PURP_CODE |   | VARCHAR2(10) | Yes |   | * |
GEBFUNC_PURP_DESC |   | VARCHAR2(60) | Yes |   |   |
GEBFUNC_EMPH_CODE |   | VARCHAR2(10) | Yes |   | * |
GEBFUNC_INVITATION_DATE |   | DATE | Yes |   |   |
GEBFUNC_LETR_CODE |   | VARCHAR2(15) | Yes |   | * |
GEBFUNC_RSVP_CONFIRM_DATE |   | DATE | Yes |   |   |
GEBFUNC_SPNSR_ORGN_PIDM |   | NUMBER(8,0) | Yes |   |   |
GEBFUNC_COMMITTEE_NAME |   | VARCHAR2(60) | Yes |   |   |
GEBFUNC_PLAN_ATTEND |   | NUMBER(7,0) | Yes |   |   |
GEBFUNC_BRK_EVEN_ATTEND |   | NUMBER(7,0) | Yes |   |   |
GEBFUNC_LOCATION |   | VARCHAR2(60) | Yes |   |   |
GEBFUNC_LOCATION_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GEBFUNC_PURP_CODE | GTVPURP_CODE | GTVPURP |
GEBFUNC_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GEBFUNC_LETR_CODE | GTVLETR_CODE | GTVLETR |
GEBFUNC_EMPH_CODE | GTVEMPH_CODE | GTVEMPH |
GEBFUNC_FSTA_CODE | GTVFSTA_CODE | GTVFSTA |
GEBFUNC_ETYP_CODE | STVETYP_CODE | STVETYP |
GEBFUNC_EVNT_CRN | SLBEVNT_CRN | SLBEVNT |
Index Name | Index Type | Column Name |
---|---|---|
PK_GEBFUNC | Unique | GEBFUNC_EVNT_CRN |
PK_GEBFUNC | Unique | GEBFUNC_FUNC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERATTD | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCOM | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCON | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCOR | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFEXP | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFFEE | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFREV | SQL Table | S10B80.GENERAL | Refer (no action) |
GERMENU | SQL Table | S10B80.GENERAL | Refer (no action) |
GERPART | SQL Table | S10B80.GENERAL | Refer (no action) |
GERTASK | SQL Table | S10B80.GENERAL | Refer (no action) |
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
GEBFUNC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GEBFUNC | SQL Index | S10B80.GENERAL | Rely On |
GTVEMPH | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFSTA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVLETR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVPURP | SQL Table | S10B80.GENERAL | Refer (no action) |
SLBEVNT | SQL Table | S10B80.SATURN | Join |
STVETYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:29:19:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERATTD_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERATTD_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERATTD_PIDM |   | NUMBER(8,0) | No | * |   |
GERATTD_ACTIVITY_DATE |   | DATE | No |   |   |
GERATTD_RSVP_CODE |   | VARCHAR2(6) | Yes |   | * |
GERATTD_RSVP_DATE |   | DATE | Yes |   |   |
GERATTD_FEES_CODE |   | VARCHAR2(5) | Yes |   | * |
GERATTD_FEE_DATE |   | DATE | Yes |   |   |
GERATTD_ATYP_CODE |   | VARCHAR2(2) | Yes |   | * |
GERATTD_NAME_TAG_NAME |   | VARCHAR2(230) | Yes |   |   |
GERATTD_PLACE_CARD_NAME |   | VARCHAR2(230) | Yes |   |   |
GERATTD_TICKET_CNT |   | VARCHAR2(3) | Yes |   |   |
GERATTD_MENU_CODE |   | VARCHAR2(10) | Yes |   | * |
GERATTD_ATTENDANCE_IND |   | VARCHAR2(1) | Yes |   |   |
GERATTD_INVOLVE_IND |   | VARCHAR2(1) | Yes |   |   |
GERATTD_COMMENT |   | LONG | Yes |   |   |
GERATTD_FEES_DESC |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERATTD_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERATTD_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERATTD_FEES_CODE | GTVFEES_CODE | GTVFEES |
GERATTD_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERATTD_MENU_CODE | GTVMENU_CODE | GTVMENU |
GERATTD_RSVP_CODE | GTVRSVP_CODE | GTVRSVP |
GERATTD_ATYP_CODE | STVATYP_CODE | STVATYP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERATTD | Unique | GERATTD_EVNT_CRN |
PK_GERATTD | Unique | GERATTD_FUNC_CODE |
PK_GERATTD | Unique | GERATTD_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERFGST | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
GEVATTD | SQL View | S10B80.BANINST1 | Use (select) |
F_COUNT_ATTENDEES | SQL Function | S10B80.BANINST1 | Use (select) |
GERATTD | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERATTD | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFEES | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVMENU | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVRSVP | SQL Table | S10B80.GENERAL | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:35:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFCOM_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERFCOM_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERFCOM_GRP_SEQ_NO |   | NUMBER(23,20) | No | * |   |
GERFCOM_ACTIVITY_DATE |   | DATE | No |   |   |
GERFCOM_USER_ID |   | VARCHAR2(30) | No |   |   |
GERFCOM_COMMENT |   | LONG | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFCOM_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERFCOM_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFCOM_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERFCOM | Unique | GERFCOM_EVNT_CRN |
PK_GERFCOM | Unique | GERFCOM_FUNC_CODE |
PK_GERFCOM | Unique | GERFCOM_GRP_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERSUBJ | SQL Table | S10B80.GENERAL | Refer (no action) |
F_CHECK_FOR_EVENT_COMMENTS | SQL Function | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_SUBJ_CMNTS | SQL Function | S10B80.BANINST1 | Use (select) |
GERFCOM | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERFCOM | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:27:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFCON_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERFCON_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERFCON_TARG_CODE |   | VARCHAR2(5) | No | * | * |
GERFCON_ACTIVITY_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFCON_TARG_CODE | GTVTARG_CODE | GTVTARG |
GERFCON_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERFCON_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFCON_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERFCON | Unique | GERFCON_EVNT_CRN |
PK_GERFCON | Unique | GERFCON_FUNC_CODE |
PK_GERFCON | Unique | GERFCON_TARG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERFCON | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTARG | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:28:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFCOR_EVNT_CRN |   | VARCHAR2(5) | No |   | * |
GERFCOR_FUNC_CODE |   | VARCHAR2(12) | No |   | * |
GERFCOR_MAIL_CODE |   | VARCHAR2(3) | No |   | * |
GERFCOR_ACTIVITY_DATE |   | DATE | No |   |   |
GERFCOR_MAIL_DATE |   | DATE | Yes |   |   |
GERFCOR_NUM_MAILINGS |   | NUMBER(7,0) | Yes |   |   |
GERFCOR_TARG_CODE |   | VARCHAR2(5) | Yes |   | * |
GERFCOR_LETR_CODE |   | VARCHAR2(15) | Yes |   | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFCOR_TARG_CODE | GTVTARG_CODE | GTVTARG |
GERFCOR_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERFCOR_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFCOR_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERFCOR_LETR_CODE | GTVLETR_CODE | GTVLETR |
GERFCOR_MAIL_CODE | GTVMAIL_CODE | GTVMAIL |
Index Name | Index Type | Column Name |
---|---|---|
GERFCOR_KEY_INDEX | Unique | GERFCOR_EVNT_CRN |
GERFCOR_KEY_INDEX | Unique | GERFCOR_FUNC_CODE |
GERFCOR_KEY_INDEX | Unique | GERFCOR_MAIL_CODE |
GERFCOR_KEY_INDEX | Unique | GERFCOR_TARG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERFCOR_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVLETR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVMAIL | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTARG | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:29:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFEXP_EVNT_CRN |   | VARCHAR2(5) | No |   | * |
GERFEXP_FUNC_CODE |   | VARCHAR2(12) | No |   | * |
GERFEXP_EXPN_CODE |   | VARCHAR2(2) | No |   |   |
GERFEXP_ACTIVITY_DATE |   | DATE | No |   |   |
GERFEXP_BUDGET_AMT |   | NUMBER(8,2) | Yes |   |   |
GERFEXP_ACTUAL_AMT |   | NUMBER(8,2) | Yes |   |   |
GERFEXP_EXPENSE_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFEXP_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFEXP_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
Index Name | Index Type | Column Name |
---|---|---|
GERFEXP_KEY_INDEX |   | GERFEXP_EVNT_CRN |
GERFEXP_KEY_INDEX |   | GERFEXP_FUNC_CODE |
GERFEXP_KEY_INDEX |   | GERFEXP_EXPN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_GERFEXP_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
GERFEXP | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERFEXP_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:12:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFFEE_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERFFEE_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERFFEE_FTYP_CODE |   | VARCHAR2(6) | No | * | * |
GERFFEE_RATE_CODE |   | VARCHAR2(6) | No | * | * |
GERFFEE_AMT |   | NUMBER(7,2) | No |   |   |
GERFFEE_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFFEE_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFFEE_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERFFEE_FTYP_CODE | GTVFTYP_CODE | GTVFTYP |
GERFFEE_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERFFEE_RATE_CODE | GTVRATE_CODE | GTVRATE |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERFFEE | Unique | GERFFEE_EVNT_CRN |
PK_GERFFEE | Unique | GERFFEE_FUNC_CODE |
PK_GERFFEE | Unique | GERFFEE_FTYP_CODE |
PK_GERFFEE | Unique | GERFFEE_RATE_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_GERFFEE_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
GERFFEE | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERFFEE | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFTYP | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVRATE | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:39:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFGST_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERFGST_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERFGST_PIDM |   | NUMBER(8,0) | No | * | * |
GERFGST_GUEST_PIDM |   | NUMBER(8,0) | No | * |   |
GERFGST_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFGST_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERFGST_EVNT_CRN | GERATTD_EVNT_CRN | GERATTD |
GERFGST_FUNC_CODE | GERATTD_FUNC_CODE | GERATTD |
GERFGST_PIDM | GERATTD_PIDM | GERATTD |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERFGST | Unique | GERFGST_EVNT_CRN |
PK_GERFGST | Unique | GERFGST_FUNC_CODE |
PK_GERFGST | Unique | GERFGST_PIDM |
PK_GERFGST | Unique | GERFGST_GUEST_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERFGST | SQL Index | S10B80.GENERAL | Rely On |
GERATTD | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:02:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERFREV_EVNT_CRN |   | VARCHAR2(5) | No |   | * |
GERFREV_FUNC_CODE |   | VARCHAR2(12) | No |   | * |
GERFREV_REVN_CODE |   | VARCHAR2(2) | No |   |   |
GERFREV_ACTIVITY_DATE |   | DATE | No |   |   |
GERFREV_BUDGET_AMT |   | NUMBER(8,2) | Yes |   |   |
GERFREV_ACTUAL_AMT |   | NUMBER(8,2) | Yes |   |   |
GERFREV_REVENUE_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERFREV_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERFREV_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
Index Name | Index Type | Column Name |
---|---|---|
GERFREV_KEY_INDEX |   | GERFREV_EVNT_CRN |
GERFREV_KEY_INDEX |   | GERFREV_FUNC_CODE |
GERFREV_KEY_INDEX |   | GERFREV_REVN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_GERFREV_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
GERFREV | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERFREV_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:09:000 | 04/02/2008 21:17:53:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERMENU_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERMENU_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERMENU_MENU_CODE |   | VARCHAR2(10) | No | * | * |
GERMENU_ACTIVITY_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERMENU_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERMENU_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERMENU_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERMENU_MENU_CODE | GTVMENU_CODE | GTVMENU |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERMENU | Unique | GERMENU_EVNT_CRN |
PK_GERMENU | Unique | GERMENU_FUNC_CODE |
PK_GERMENU | Unique | GERMENU_MENU_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERMENU | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVMENU | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:18:000 | 04/02/2008 21:17:53:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERPART_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERPART_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERPART_PIDM |   | NUMBER(8,0) | No | * |   |
GERPART_PTYP_CODE |   | VARCHAR2(5) | No | * | * |
GERPART_ACTIVITY_DATE |   | DATE | No |   |   |
GERPART_ATYP_CODE |   | VARCHAR2(2) | Yes |   | * |
GERPART_DATE |   | DATE | Yes |   |   |
GERPART_RTNG_CODE |   | VARCHAR2(2) | Yes |   | * |
GERPART_COMMENT |   | LONG | Yes |   |   |
GERPART_CONTACT_IND |   | VARCHAR2(1) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERPART_PTYP_CODE | GTVPTYP_CODE | GTVPTYP |
GERPART_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERPART_RTNG_CODE | GTVRTNG_CODE | GTVRTNG |
GERPART_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERPART_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERPART_ATYP_CODE | STVATYP_CODE | STVATYP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERPART | Unique | GERPART_EVNT_CRN |
PK_GERPART | Unique | GERPART_FUNC_CODE |
PK_GERPART | Unique | GERPART_PIDM |
PK_GERPART | Unique | GERPART_PTYP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_PARTICIPANTS | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_GERPART_ROWID | SQL Function | S10B80.BANINST1 | Use (select) |
GERPART | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERPART | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVPTYP | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVRTNG | SQL Table | S10B80.GENERAL | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:18:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERSUBJ_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERSUBJ_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERSUBJ_SUBJ_CODE |   | VARCHAR2(6) | No | * | * |
GERSUBJ_GRP_SEQ_NO |   | NUMBER(23,20) | No | * | * |
GERSUBJ_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERSUBJ_EVNT_CRN | GERFCOM_EVNT_CRN | GERFCOM |
GERSUBJ_FUNC_CODE | GERFCOM_FUNC_CODE | GERFCOM |
GERSUBJ_GRP_SEQ_NO | GERFCOM_GRP_SEQ_NO | GERFCOM |
GERSUBJ_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERSUBJ_SUBJ_CODE | GTVSUBJ_CODE | GTVSUBJ |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERSUBJ | Unique | GERSUBJ_EVNT_CRN |
PK_GERSUBJ | Unique | GERSUBJ_FUNC_CODE |
PK_GERSUBJ | Unique | GERSUBJ_GRP_SEQ_NO |
PK_GERSUBJ | Unique | GERSUBJ_SUBJ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
F_CHECK_FOR_MORE_SUBJ_INDEXES | SQL Function | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_SUBJ_CMNTS | SQL Function | S10B80.BANINST1 | Use (select) |
GERSUBJ | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERSUBJ | SQL Index | S10B80.GENERAL | Rely On |
GERFCOM | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVSUBJ | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:45:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERTASK_EVNT_CRN |   | VARCHAR2(5) | No | * | * |
GERTASK_FUNC_CODE |   | VARCHAR2(12) | No | * | * |
GERTASK_TASK_CODE |   | VARCHAR2(10) | No | * | * |
GERTASK_ACTIVITY_DATE |   | DATE | No |   |   |
GERTASK_TTYP_CODE |   | VARCHAR2(5) | Yes |   | * |
GERTASK_MESSAGE_IND |   | VARCHAR2(1) | Yes |   |   |
GERTASK_MESSAGE_RECIPIENT |   | VARCHAR2(15) | Yes |   |   |
GERTASK_MESSAGE_DATE |   | DATE | Yes |   |   |
GERTASK_TSTA_CODE |   | VARCHAR2(6) | Yes |   | * |
GERTASK_TSTA_DATE |   | DATE | Yes |   |   |
GERTASK_TARGET_COMPL_DATE |   | DATE | Yes |   |   |
GERTASK_BEGIN_DATE |   | DATE | Yes |   |   |
GERTASK_END_DATE |   | DATE | Yes |   |   |
GERTASK_START_TIME |   | VARCHAR2(4) | Yes |   |   |
GERTASK_END_TIME |   | VARCHAR2(4) | Yes |   |   |
GERTASK_COMMENT |   | VARCHAR2(180) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERTASK_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC |
GERTASK_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC |
GERTASK_TASK_CODE | GTVTASK_CODE | GTVTASK |
GERTASK_TTYP_CODE | GTVTTYP_CODE | GTVTTYP |
GERTASK_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERTASK_TSTA_CODE | GTVTSTA_CODE | GTVTSTA |
Index Name | Index Type | Column Name |
---|---|---|
PK_GERTASK | Unique | GERTASK_EVNT_CRN |
PK_GERTASK | Unique | GERTASK_FUNC_CODE |
PK_GERTASK | Unique | GERTASK_TASK_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERTKID | SQL Table | S10B80.GENERAL | Refer (no action) |
F_CHECK_FOR_MORE_TASKS | SQL Function | S10B80.BANINST1 | Use (select) |
F_COMPLETED_TASK_FLAG | SQL Function | S10B80.BANINST1 | Rely On |
F_COMPLETED_TASK_FLAG | SQL Function | S10B80.BANINST1 | Use (select) |
F_COUNT_TASKS | SQL Function | S10B80.BANINST1 | Use (select) |
GERTASK | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GERTASK | SQL Index | S10B80.GENERAL | Rely On |
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTASK | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTSTA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTTYP | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:36:000 | 04/02/2008 21:17:55:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GERTKID_EVNT_CRN |   | VARCHAR2(5) | No |   | * |
GERTKID_FUNC_CODE |   | VARCHAR2(12) | No |   | * |
GERTKID_TASK_CODE |   | VARCHAR2(10) | No |   | * |
GERTKID_ACTIVITY_DATE |   | DATE | No |   |   |
GERTKID_PIDM |   | NUMBER(8,0) | Yes |   |   |
GERTKID_COMMENT |   | VARCHAR2(240) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GERTKID_EVNT_CRN | GERTASK_EVNT_CRN | GERTASK |
GERTKID_FUNC_CODE | GERTASK_FUNC_CODE | GERTASK |
GERTKID_TASK_CODE | GERTASK_TASK_CODE | GERTASK |
GERTKID_FUNC_CODE | GTVFUNC_CODE | GTVFUNC |
GERTKID_TASK_CODE | GTVTASK_CODE | GTVTASK |
Index Name | Index Type | Column Name |
---|---|---|
GERTKID_KEY_INDEX | Unique | GERTKID_EVNT_CRN |
GERTKID_KEY_INDEX | Unique | GERTKID_FUNC_CODE |
GERTKID_KEY_INDEX | Unique | GERTKID_TASK_CODE |
GERTKID_KEY_INDEX | Unique | GERTKID_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERTKID_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
GERTASK | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVTASK | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:33:27:000 | 04/02/2008 21:17:57:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVFUNC_CODE |   | VARCHAR2(12) | No | * |   |
GTVFUNC_DESC |   | VARCHAR2(60) | No |   |   |
GTVFUNC_ETYP_CODE |   | VARCHAR2(4) | No |   | * |
GTVFUNC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GTVFUNC_ETYP_CODE | STVETYP_CODE | STVETYP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVFUNC | Unique | GTVFUNC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEBFUNC | SQL Table | S10B80.GENERAL | Refer (no action) |
GERATTD | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCOM | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCON | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFCOR | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFFEE | SQL Table | S10B80.GENERAL | Refer (no action) |
GERFGST | SQL Table | S10B80.GENERAL | Refer (no action) |
GERMENU | SQL Table | S10B80.GENERAL | Refer (no action) |
GERPART | SQL Table | S10B80.GENERAL | Refer (no action) |
GERSUBJ | SQL Table | S10B80.GENERAL | Refer (no action) |
GERTASK | SQL Table | S10B80.GENERAL | Refer (no action) |
GERTKID | SQL Table | S10B80.GENERAL | Refer (no action) |
AG_EVENTS_AND_FUNCTIONS | SQL View | S10B80.BANINST1 | Use (select) |
GEVEVN1 | SQL View | S10B80.BANINST1 | Join |
GTVFUNCC | Oracle Package Cursor | S10B80.BANINST1.GTKFUNC | Use (select)Rely On |
GTVFUNC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFUNC | Rely On |
GTVFUNC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVFUNC | Use (select)Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVFUNC | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVFUNC | Rely On |
GTVFUNC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVFUNC | SQL Index | S10B80.GENERAL | Rely On |
STVETYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:16:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLBBLDG_BLDG_CODE |   | VARCHAR2(6) | No | * | * |
SLBBLDG_CAMP_CODE |   | VARCHAR2(3) | No |   | * |
SLBBLDG_CAPACITY |   | NUMBER(5,0) | No |   |   |
SLBBLDG_MAXIMUM_CAPACITY |   | NUMBER(5,0) | Yes |   |   |
SLBBLDG_RRCD_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBBLDG_PRCD_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBBLDG_SITE_CODE |   | VARCHAR2(3) | Yes |   |   |
SLBBLDG_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
SLBBLDG_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
SLBBLDG_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
SLBBLDG_CITY |   | VARCHAR2(50) | Yes |   |   |
SLBBLDG_STAT_CODE |   | VARCHAR2(3) | Yes |   |   |
SLBBLDG_ZIP |   | VARCHAR2(30) | Yes |   |   |
SLBBLDG_CNTY_CODE |   | VARCHAR2(5) | Yes |   |   |
SLBBLDG_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
SLBBLDG_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
SLBBLDG_PHONE_EXTENSION |   | VARCHAR2(10) | Yes |   |   |
SLBBLDG_ACTIVITY_DATE |   | DATE | No |   |   |
SLBBLDG_SEX |   | VARCHAR2(1) | Yes |   |   |
SLBBLDG_COLL_CODE |   | VARCHAR2(2) | Yes |   |   |
SLBBLDG_DEPT_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBBLDG_KEY_NUMBER |   | VARCHAR2(5) | Yes |   |   |
SLBBLDG_PARS_CODE |   | VARCHAR2(7) | Yes |   | * |
SLBBLDG_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SLBBLDG_USER_ID |   | VARCHAR2(30) | Yes |   |   |
SLBBLDG_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
SLBBLDG_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
SLBBLDG_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SLBBLDG_PARS_CODE | GTVPARS_CODE | GTVPARS |
SLBBLDG_BLDG_CODE | STVBLDG_CODE | STVBLDG |
SLBBLDG_BLDG_CODE | SLBRMPF_BLDG_CODE | SLBRMPF |
SLBBLDG_CAMP_CODE | SLBRMPF_CAMP_CODE | SLBRMPF |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLBBLDG | Unique | SLBBLDG_BLDG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLBBLDG | SQL Index | S10B80.SATURN | Rely On |
GTVPARS | SQL Table | S10B80.GENERAL | Refer (no action) |
SLBRMPF | SQL Table | S10B80.SATURN | Join |
STVBLDG | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:41:01:000 | 04/02/2008 21:18:04:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLBEVNT_CRN |   | VARCHAR2(5) | No | * |   |
SLBEVNT_ETYP_CODE |   | VARCHAR2(4) | No |   |   |
SLBEVNT_DESC |   | VARCHAR2(30) | Yes |   |   |
SLBEVNT_AGENCY_PIDM |   | NUMBER(8,0) | Yes |   |   |
SLBEVNT_CONTACT_NAME |   | VARCHAR2(230) | Yes |   |   |
SLBEVNT_CAMP_CODE |   | VARCHAR2(3) | Yes |   |   |
SLBEVNT_SITE_CODE |   | VARCHAR2(3) | Yes |   |   |
SLBEVNT_COLL_CODE |   | VARCHAR2(2) | Yes |   |   |
SLBEVNT_DEPT_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBEVNT_ACTIVITY_DATE |   | DATE | Yes |   |   |
SLBEVNT_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
SLBEVNT_PHONE |   | VARCHAR2(7) | Yes |   |   |
SLBEVNT_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
SLBEVNT_CONTACT_PIDM |   | NUMBER(8,0) | Yes |   |   |
SLBEVNT_ATYP_CODE |   | VARCHAR2(2) | Yes |   |   |
SLBEVNT_SYSI_CODE |   | VARCHAR2(2) | Yes |   |   |
SLBEVNT_COMM_IND |   | VARCHAR2(1) | No |   |   |
SLBEVNT_DICD_CODE |   | VARCHAR2(3) | Yes |   | * |
SLBEVNT_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SLBEVNT_DICD_CODE | GTVDICD_CODE | GTVDICD |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLBEVNT | Unique | SLBEVNT_CRN |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GEBFUNC | SQL Table | S10B80.GENERAL | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
GEVEVN2 | SQL View | S10B80.BANINST1 | Use (select) |
F_SLBEVNT_CRN_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_CLASSTIMES_RULES | Rely On |
F_SLBEVNT_CRN_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_CLASSTIMES_RULES | Use (select) |
SLBEVNT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLBEVNT | SQL Index | S10B80.SATURN | Rely On |
GTVDICD | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:58:28:000 | 04/02/2008 21:18:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLBRDEF_BLDG_CODE |   | VARCHAR2(6) | No | * | * |
SLBRDEF_ROOM_NUMBER |   | VARCHAR2(10) | No | * | * |
SLBRDEF_ACTIVITY_DATE |   | DATE | No |   |   |
SLBRDEF_DESC |   | VARCHAR2(50) | Yes |   |   |
SLBRDEF_CAPACITY |   | NUMBER(5,0) | No |   |   |
SLBRDEF_MAXIMUM_CAPACITY |   | NUMBER(5,0) | Yes |   |   |
SLBRDEF_RMST_CODE |   | VARCHAR2(2) | Yes |   | * |
SLBRDEF_RRCD_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBRDEF_PRCD_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBRDEF_UTILITY_RATE |   | NUMBER(7,2) | Yes |   |   |
SLBRDEF_UTILITY_RATE_PERIOD |   | VARCHAR2(2) | Yes |   |   |
SLBRDEF_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
SLBRDEF_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
SLBRDEF_PHONE_EXTENSION |   | VARCHAR2(10) | Yes |   |   |
SLBRDEF_BCAT_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBRDEF_SEX |   | VARCHAR2(1) | Yes |   |   |
SLBRDEF_ROOM_TYPE |   | VARCHAR2(1) | No |   |   |
SLBRDEF_PRIORITY |   | VARCHAR2(8) | Yes |   |   |
SLBRDEF_COLL_CODE |   | VARCHAR2(2) | Yes |   |   |
SLBRDEF_DEPT_CODE |   | VARCHAR2(4) | Yes |   |   |
SLBRDEF_KEY_NUMBER |   | VARCHAR2(5) | Yes |   |   |
SLBRDEF_WIDTH |   | NUMBER(6,2) | Yes |   |   |
SLBRDEF_LENGTH |   | NUMBER(6,2) | Yes |   |   |
SLBRDEF_AREA |   | NUMBER(10,2) | Yes |   |   |
SLBRDEF_TERM_CODE_EFF |   | VARCHAR2(6) | No | * |   |
SLBRDEF_PARS_CODE |   | VARCHAR2(7) | Yes |   | * |
SLBRDEF_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SLBRDEF_PARS_CODE | GTVPARS_CODE | GTVPARS |
SLBRDEF_RMST_CODE | STVRMST_CODE | STVRMST |
SLBRDEF_ROOM_NUMBER | SLBRMPF_ROOM_NUMBER | SLBRMPF |
SLBRDEF_BLDG_CODE | SLBRMPF_BLDG_CODE | SLBRMPF |
SLBRDEF_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLBRDEF | Unique | SLBRDEF_BLDG_CODE |
PK_SLBRDEF | Unique | SLBRDEF_ROOM_NUMBER |
PK_SLBRDEF | Unique | SLBRDEF_TERM_CODE_EFF |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLBRDEF | SQL Index | S10B80.SATURN | Rely On |
GTVPARS | SQL Table | S10B80.GENERAL | Refer (no action) |
SLBBLDG | SQL Table | S10B80.SATURN | Join |
SLBRMPF | SQL Table | S10B80.SATURN | Join |
STVRMST | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:44:48:000 | 04/02/2008 21:18:08:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRBCAT_BLDG_CODE |   | VARCHAR2(6) | No | * |   |
SLRBCAT_CODE |   | VARCHAR2(4) | No | * |   |
SLRBCAT_DESC |   | VARCHAR2(30) | No |   |   |
SLRBCAT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLRBCAT | Unique | SLRBCAT_BLDG_CODE |
PK_SLRBCAT | Unique | SLRBCAT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLRBCAT | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:51:37:000 | 04/02/2008 21:18:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRBCMT_BLDG_CODE |   | VARCHAR2(6) | No |   |   |
SLRBCMT_SEQNO |   | NUMBER(23,20) | No |   |   |
SLRBCMT_COMMENTS |   | VARCHAR2(60) | No |   |   |
SLRBCMT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
SLRBCMT_KEY_INDEX |   | SLRBCMT_BLDG_CODE |
SLRBCMT_KEY_INDEX |   | SLRBCMT_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_BLDGDEFINITION | Use (delete,select) |
SLRBCMT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SLRBCMT_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:53:28:000 | 04/02/2008 21:18:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRBDEF_BLDG_CODE |   | VARCHAR2(6) | No | * |   |
SLRBDEF_RDEF_CODE |   | VARCHAR2(5) | No | * |   |
SLRBDEF_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLRBDEF | Unique | SLRBDEF_BLDG_CODE |
PK_SLRBDEF | Unique | SLRBDEF_RDEF_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_CREATE | Oracle Package Procedure | S10B80.BANINST1.GB_ROOMDEFINITION | Use (select) |
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_BLDGDEFINITION | Use (delete,select) |
SLRBDEF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLRBDEF | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:56:16:000 | 04/02/2008 21:18:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRCMNT_BLDG_CODE |   | VARCHAR2(6) | No | * |   |
SLRCMNT_ROOM_NUMBER |   | VARCHAR2(10) | No | * |   |
SLRCMNT_COMMENTS |   | VARCHAR2(60) | No |   |   |
SLRCMNT_SEQNO |   | NUMBER(23,20) | No | * |   |
SLRCMNT_ACTIVITY_DATE |   | DATE | No |   |   |
SLRCMNT_TERM_CODE_EFF |   | VARCHAR2(6) | No | * |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLRCMNT | Unique | SLRCMNT_BLDG_CODE |
PK_SLRCMNT | Unique | SLRCMNT_ROOM_NUMBER |
PK_SLRCMNT | Unique | SLRCMNT_TERM_CODE_EFF |
PK_SLRCMNT | Unique | SLRCMNT_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_ROOMDEFINITION | Use (delete,select) |
SLRCMNT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLRCMNT | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:43:51:000 | 04/02/2008 21:18:07:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRECMT_CRN |   | VARCHAR2(6) | No |   |   |
SLRECMT_SEQNO |   | NUMBER(23,20) | No |   |   |
SLRECMT_COMMENTS |   | VARCHAR2(60) | No |   |   |
SLRECMT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
SLRECMT_KEY_INDEX |   | SLRECMT_CRN |
SLRECMT_KEY_INDEX |   | SLRECMT_SEQNO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SLRECMT_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:58:44:000 | 04/02/2008 21:18:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRRASG_PIDM |   | NUMBER(8,0) | No |   | * |
SLRRASG_BLDG_CODE |   | VARCHAR2(6) | No |   | * |
SLRRASG_ROOM_NUMBER |   | VARCHAR2(10) | No |   | * |
SLRRASG_TERM_CODE |   | VARCHAR2(6) | No |   | * |
SLRRASG_RRCD_CODE |   | VARCHAR2(4) | No |   | * |
SLRRASG_BEGIN_DATE |   | DATE | No |   |   |
SLRRASG_END_DATE |   | DATE | No |   |   |
SLRRASG_TOTAL_DAYS |   | NUMBER(9,5) | No |   |   |
SLRRASG_TOTAL_MONTHS |   | NUMBER(7,5) | No |   |   |
SLRRASG_TOTAL_TERMS |   | NUMBER(7,5) | No |   |   |
SLRRASG_ASCD_CODE |   | VARCHAR2(2) | No |   | * |
SLRRASG_ASCD_DATE |   | DATE | No |   |   |
SLRRASG_ONL_OR_BAT |   | VARCHAR2(1) | No |   |   |
SLRRASG_ACTIVITY_DATE |   | DATE | No |   |   |
SLRRASG_AR_IND |   | VARCHAR2(1) | No |   |   |
SLRRASG_OVERLOAD_IND |   | VARCHAR2(1) | Yes |   |   |
SLRRASG_ROLL_IND |   | VARCHAR2(1) | Yes |   |   |
SLRRASG_OVERRIDE_ERROR |   | VARCHAR2(1) | Yes |   |   |
SLRRASG_ASSESS_NEEDED |   | VARCHAR2(1) | No |   |   |
SLRRASG_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SLRRASG_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SLRRASG_RRCD_CODE | STVRRCD_CODE | STVRRCD |
SLRRASG_BLDG_CODE | STVBLDG_CODE | STVBLDG |
SLRRASG_ASCD_CODE | STVASCD_CODE | STVASCD |
SLRRASG_TERM_CODE | STVTERM_CODE | STVTERM |
SLRRASG_BLDG_CODE | SLBRDEF_BLDG_CODE | SLBRDEF |
SLRRASG_ROOM_NUMBER | SLBRDEF_ROOM_NUMBER | SLBRDEF |
SLRRASG_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
SLRRASG_PIDM | SPBPERS_PIDM | SPBPERS |
Index Name | Index Type | Column Name |
---|---|---|
SLRRASG_BLDG_INDEX |   | SLRRASG_BLDG_CODE |
SLRRASG_BLDG_INDEX |   | SLRRASG_ROOM_NUMBER |
SLRRASG_KEY_INDEX |   | SLRRASG_PIDM |
SLRRASG_KEY_INDEX |   | SLRRASG_BLDG_CODE |
SLRRASG_KEY_INDEX |   | SLRRASG_ROOM_NUMBER |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SLRRASG_BLDG_INDEX | SQL Index | S10B80.SATURN | Rely On |
SLRRASG_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
SLBBLDG | SQL Table | S10B80.SATURN | Join |
SLBRDEF | SQL Table | S10B80.SATURN | Join |
SPBPERS | SQL Table | S10B80.SATURN | Join |
STVASCD | SQL Table | S10B80.SATURN | Refer (no action) |
STVBLDG | SQL Table | S10B80.SATURN | Refer (no action) |
STVRRCD | SQL Table | S10B80.SATURN | Refer (no action) |
STVTERM | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:51:48:000 | 04/02/2008 21:18:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRRDEF_BLDG_CODE |   | VARCHAR2(6) | No | * |   |
SLRRDEF_ROOM_NUMBER |   | VARCHAR2(10) | No | * |   |
SLRRDEF_RDEF_CODE |   | VARCHAR2(4) | No | * | * |
SLRRDEF_MUST_MATCH |   | VARCHAR2(1) | Yes |   |   |
SLRRDEF_ACTIVITY_DATE |   | DATE | No |   |   |
SLRRDEF_TERM_CODE_EFF |   | VARCHAR2(6) | No | * |   |
SLRRDEF_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SLRRDEF_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SLRRDEF_RDEF_CODE | STVRDEF_CODE | STVRDEF |
Index Name | Index Type | Column Name |
---|---|---|
PK_SLRRDEF | Unique | SLRRDEF_BLDG_CODE |
PK_SLRRDEF | Unique | SLRRDEF_ROOM_NUMBER |
PK_SLRRDEF | Unique | SLRRDEF_TERM_CODE_EFF |
PK_SLRRDEF | Unique | SLRRDEF_RDEF_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_CREATE | Oracle Package Procedure | S10B80.BANINST1.GB_ROOMDEFINITION | Use (Insert,select) |
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_ROOMDEFINITION | Use (delete,select) |
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.DML_SLRRDEF | Use (delete)Rely On |
P_INSERT | Oracle Package Procedure | S10B80.BANINST1.DML_SLRRDEF | Use (Insert)Rely On |
P_UPDATE | Oracle Package Procedure | S10B80.BANINST1.DML_SLRRDEF | Rely On |
SLRRDEF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SLRRDEF | SQL Index | S10B80.SATURN | Rely On |
STVRDEF | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 21:03:53:000 | 04/02/2008 21:18:23:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SLRRUSE_BLDG_CODE |   | VARCHAR2(6) | No |   |   |
SLRRUSE_ROOM_NUMBER |   | VARCHAR2(10) | No |   |   |
SLRRUSE_START_DATE |   | DATE | No |   |   |
SLRRUSE_END_DATE |   | DATE | Yes |   |   |
SLRRUSE_ACTIVITY_DATE |   | DATE | No |   |   |
SLRRUSE_BEGIN_TIME |   | VARCHAR2(4) | Yes |   |   |
SLRRUSE_END_TIME |   | VARCHAR2(4) | Yes |   |   |
SLRRUSE_SUN_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_MON_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_TUE_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_WED_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_THU_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_FRI_DAY |   | VARCHAR2(1) | Yes |   |   |
SLRRUSE_SAT_DAY |   | VARCHAR2(1) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
SLRRUSE_KEY_INDEX |   | SLRRUSE_BLDG_CODE |
SLRRUSE_KEY_INDEX |   | SLRRUSE_ROOM_NUMBER |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
F_CHECK_ROOM_RESTRICTION | Oracle Package Function | S10B80.BANINST1.GB_CLASSTIMES_RULES | Rely On |
F_CHECK_ROOM_RESTRICTION | Oracle Package Function | S10B80.BANINST1.GB_CLASSTIMES_RULES | Use (select) |
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_ROOMDEFINITION | Use (delete,select) |
F_CHECK_ROOM | Oracle Package Function | S10B80.BANINST1.GB_ROOMASSIGNMENT_RULES | Use (select) |
SLRRUSE | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SLRRUSE_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:40:46:000 | 04/02/2008 21:18: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 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SSRMEET_TERM_CODE |   | VARCHAR2(6) | No |   | * |
SSRMEET_CRN |   | VARCHAR2(5) | No |   | * |
SSRMEET_DAYS_CODE |   | VARCHAR2(1) | Yes |   |   |
SSRMEET_DAY_NUMBER |   | NUMBER(1,0) | Yes |   |   |
SSRMEET_BEGIN_TIME |   | VARCHAR2(4) | Yes |   |   |
SSRMEET_END_TIME |   | VARCHAR2(4) | Yes |   |   |
SSRMEET_BLDG_CODE |   | VARCHAR2(6) | Yes |   | * |
SSRMEET_ROOM_CODE |   | VARCHAR2(10) | Yes |   |   |
SSRMEET_ACTIVITY_DATE |   | DATE | No |   |   |
SSRMEET_START_DATE |   | DATE | No |   |   |
SSRMEET_END_DATE |   | DATE | No |   |   |
SSRMEET_CATAGORY |   | VARCHAR2(2) | Yes |   | * |
SSRMEET_SUN_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_MON_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_TUE_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_WED_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_THU_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_FRI_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_SAT_DAY |   | VARCHAR2(1) | Yes |   | * |
SSRMEET_SCHD_CODE |   | VARCHAR2(3) | Yes |   | * |
SSRMEET_OVER_RIDE |   | VARCHAR2(1) | Yes |   |   |
SSRMEET_CREDIT_HR_SESS |   | NUMBER(7,3) | Yes |   |   |
SSRMEET_MEET_NO |   | NUMBER(4,0) | Yes |   |   |
SSRMEET_HRS_WEEK |   | NUMBER(5,2) | Yes |   |   |
SSRMEET_FUNC_CODE |   | VARCHAR2(12) | Yes |   |   |
SSRMEET_COMT_CODE |   | VARCHAR2(6) | Yes |   | * |
SSRMEET_SCHS_CODE |   | VARCHAR2(3) | Yes |   | * |
SSRMEET_MTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SSRMEET_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SSRMEET_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SSRMEET_MTYP_CODE | GTVMTYP_CODE | GTVMTYP |
SSRMEET_SCHS_CODE | GTVSCHS_CODE | GTVSCHS |
SSRMEET_SCHD_CODE | STVSCHD_CODE | STVSCHD |
SSRMEET_COMT_CODE | STVCOMT_CODE | STVCOMT |
SSRMEET_BLDG_CODE | STVBLDG_CODE | STVBLDG |
SSRMEET_TERM_CODE | SSBSECT_TERM_CODE | SSBSECT |
SSRMEET_CRN | SSBSECT_CRN | SSBSECT |
SSRMEET_TERM_CODE | SFRSTCR_TERM_CODE | SFRSTCR |
SSRMEET_CRN | SFRSTCR_CRN | SFRSTCR |
SSRMEET_SUN_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_MON_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_TUE_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_WED_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_THU_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_FRI_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_SAT_DAY | STVDAYS_CODE | STVDAYS |
SSRMEET_TERM_CODE | SIRASGN_TERM_CODE | SIRASGN |
SSRMEET_CRN | SIRASGN_CRN | SIRASGN |
SSRMEET_CATAGORY | SIRASGN_CATEGORY | SIRASGN |
SSRMEET_SCHD_CODE | SCRSCHD_SCHD_CODE | SCRSCHD |
SSRMEET_CRN | SSRXLST_CRN | SSRXLST |
SSRMEET_TERM_CODE | SSRXLST_TERM_CODE | SSRXLST |
SSRMEET_BLDG_CODE | SLBBLDG_BLDG_CODE | SLBBLDG |
SSRMEET_TERM_CODE | SFTREGS_TERM_CODE | SFTREGS |
SSRMEET_CRN | SFTREGS_CRN | SFTREGS |
Index Name | Index Type | Column Name |
---|---|---|
SSRMEET_KEY_INDEX |   | SSRMEET_TERM_CODE |
SSRMEET_KEY_INDEX |   | SSRMEET_CRN |
SSRMEET_KEY_INDEX |   | SSRMEET_BEGIN_TIME |
SSRMEET_KEY_INDEX |   | SSRMEET_MON_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_TUE_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_WED_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_THU_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_FRI_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_SAT_DAY |
SSRMEET_KEY_INDEX |   | SSRMEET_SUN_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_BLDG_CODE |
SSRMEET_KEY_INDEX2 |   | SSRMEET_ROOM_CODE |
SSRMEET_KEY_INDEX2 |   | SSRMEET_BEGIN_TIME |
SSRMEET_KEY_INDEX2 |   | SSRMEET_END_TIME |
SSRMEET_KEY_INDEX2 |   | SSRMEET_MON_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_TUE_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_WED_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_THU_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_FRI_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_SAT_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_SUN_DAY |
SSRMEET_KEY_INDEX2 |   | SSRMEET_START_DATE |
SSRMEET_KEY_INDEX2 |   | SSRMEET_END_DATE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SSRMEET_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
SSRMEET_KEY_INDEX2 | SQL Index | S10B80.SATURN | Rely On |
GTVMTYP | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVSCHS | SQL Table | S10B80.GENERAL | Refer (no action) |
SCRSCHD | SQL Table | S10B80.SATURN | Join |
SFRSTCR | SQL Table | S10B80.SATURN | Join |
SFTREGS | SQL Table | S10B80.SATURN | Join |
SIRASGN | SQL Table | S10B80.SATURN | Join |
SLBBLDG | SQL Table | S10B80.SATURN | Join |
SSBSECT | SQL Table | S10B80.SATURN | Join |
SSRXLST | SQL Table | S10B80.SATURN | Join |
STVBLDG | SQL Table | S10B80.SATURN | Refer (no action) |
STVCOMT | SQL Table | S10B80.SATURN | Refer (no action) |
STVDAYS | SQL Table | S10B80.SATURN | Join |
STVSCHD | SQL Table | S10B80.SATURN | Refer (no action) |
ST_SSRMEET_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
ST_SSRMEET_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:35:48:000 | 04/02/2008 21:17:59:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
GEVATTD_EVNT_CRN | VARCHAR2(5) | No |   |   |
GEVATTD_FUNC_CODE | VARCHAR2(12) | No |   |   |
GEVATTD_LAST_NAME | VARCHAR2(60) | No |   |   |
GEVATTD_FIRST_NAME | VARCHAR2(60) | Yes |   |   |
GEVATTD_MI | VARCHAR2(60) | Yes |   |   |
GEVATTD_ID | VARCHAR2(9) | No |   |   |
GEVATTD_FULL_NAME | VARCHAR2(182) | Yes |   |   |
GEVATTD_PIDM | NUMBER(8,0) | No |   |   |
GEVATTD_ACTIVITY_DATE | DATE | No |   |   |
GEVATTD_RSVP_CODE | VARCHAR2(6) | Yes |   |   |
GEVATTD_RSVP_DATE | DATE | Yes |   |   |
GEVATTD_FEES_CODE | VARCHAR2(5) | Yes |   |   |
GEVATTD_FEE_DATE | DATE | Yes |   |   |
GEVATTD_ATYP_CODE | VARCHAR2(2) | Yes |   |   |
GEVATTD_NAME_TAG_NAME | VARCHAR2(230) | Yes |   |   |
GEVATTD_PLACE_CARD_NAME | VARCHAR2(230) | Yes |   |   |
GEVATTD_TICKET_CNT | VARCHAR2(3) | Yes |   |   |
GEVATTD_MENU_CODE | VARCHAR2(10) | Yes |   |   |
GEVATTD_ATTENDANCE_IND | VARCHAR2(1) | Yes |   |   |
GEVATTD_INVOLVE_IND | VARCHAR2(1) | Yes |   |   |
GEVATTD_COMMENT | LONG | Yes |   |   |
GEVATTD_FEES_DESC | VARCHAR2(30) | Yes |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GERATTD | SQL Table | S10B80.GENERAL | 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 |
LONG | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
GERATTD | Oracle Synonym | S10B80.PUBLIC | Use (select) |
SPRIDEN | Oracle Synonym | S10B80.PUBLIC | Use (select) |
DECODE | Oracle Package Function | S10B80.SYS.STANDARD | Call |
Creation Date | Analysis Date |
---|---|
04/04/2008 21:24:57:000 | 04/04/2008 21:57:53:000 |
Objects list |
---|
schema-view : S10B80.BANINST1.ROVRASG |
Link Type | Link | Project |
---|---|---|
Join | Link Between SLRRASG and SLBRDEF | SATURN |
Link type | Between | And |
---|---|---|
Join | SLRRASG | SLBRDEF |
Objects list |
---|
schema-view : S10B80.BANINST1.SSVMEET |
Link Type | Link | Project |
---|---|---|
Join | Link Between SSRMEET and SLBBLDG | SATURN |
Link type | Between | And |
---|---|---|
Join | SSRMEET | SLBBLDG |
Objects list |
---|
schema-view : S10B80.BANINST1.SLVRUSE |
Link Type | Link | Project |
---|---|---|
Join | Link Between SLRRASG and SLBBLDG | SATURN |
Link type | Between | And |
---|---|---|
Join | SLRRASG | SLBBLDG |
Objects list |
---|
schema-view : S10B80.BANINST1.SLVRUSE |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and SLRRASG | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | SLRRASG |
Objects list |
---|
schema-view : S10B80.BANINST1.GEVEVN2 |
Link Type | Link | Project |
---|---|---|
Join | Link Between GEBFUNC and SLBEVNT | GENERAL |
Link type | Between | And |
---|---|---|
Join | GEBFUNC | SLBEVNT |
Objects list |
---|
schema-view : S10B80.BANINST1.GEVEVN2 |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and SLBEVNT | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | SLBEVNT |
Objects list |
---|
schema-view : S10B80.BANINST1.GEVATTD |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and GERATTD | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | GERATTD |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GEVATTD and SPRIDEN | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GEVATTD | SPRIDEN |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GEVATTD and GERATTD | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GEVATTD | GERATTD |
Objects list |
---|
scope-function : S10B80.BANINST1.GB_ROOMASSIGNMENT.F_GET_RATE |
Link Type | Link | Project |
---|---|---|
Join | Link Between SLBRDEF and SLBBLDG | SATURN |
Link type | Between | And |
---|---|---|
Join | SLBRDEF | SLBBLDG |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERPART and GEBFUNC (FK1_GERPART_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERPART | GERPART_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERPART | GERPART_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFREV and GEBFUNC (FK1_GERFREV_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFREV | GERFREV_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFREV | GERFREV_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERMENU and GEBFUNC (FK1_GERMENU_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERMENU | GERMENU_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERMENU | GERMENU_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCOM and GEBFUNC (FK1_GERFCOM_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCOM | GERFCOM_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFCOM | GERFCOM_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCON and GEBFUNC (FK1_GERFCON_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCON | GERFCON_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFCON | GERFCON_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCOR and GEBFUNC (FK1_GERFCOR_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCOR | GERFCOR_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFCOR | GERFCOR_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERTASK and GEBFUNC (FK1_GERTASK_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERTASK | GERTASK_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERTASK | GERTASK_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFEXP and GEBFUNC (FK1_GERFEXP_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFEXP | GERFEXP_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFEXP | GERFEXP_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GEBFUNC and GTVFUNC (FK1_GEBFUNC_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GEBFUNC | GEBFUNC_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCOM and GTVFUNC (FK1_GERFCOM_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCOM | GERFCOM_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCON and GTVFUNC (FK1_GERFCON_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCON | GERFCON_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFCOR and GTVFUNC (FK1_GERFCOR_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFCOR | GERFCOR_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFGST and GTVFUNC (FK1_GERFGST_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFGST | GERFGST_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERMENU and GTVFUNC (FK1_GERMENU_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERMENU | GERMENU_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERPART and GTVFUNC (FK1_GERPART_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERPART | GERPART_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERTASK and GTVFUNC (FK1_GERTASK_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERTASK | GERTASK_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFGST and GERATTD (FK1_GERFGST_INV_GERATTD_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFGST | GERFGST_EVNT_CRN | GERATTD_EVNT_CRN | GERATTD | (1,1)-(0,n) |
GERFGST | GERFGST_FUNC_CODE | GERATTD_FUNC_CODE | GERATTD | (1,1)-(0,n) |
GERFGST | GERFGST_PIDM | GERATTD_PIDM | GERATTD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERATTD and GEBFUNC (FK1_GERATTD_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERATTD | GERATTD_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERATTD | GERATTD_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERATTD and GTVFUNC (FK1_GERATTD_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERATTD | GERATTD_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFFEE and GEBFUNC (FK1_GERFFEE_INV_GEBFUNC_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFFEE | GERFFEE_EVNT_CRN | GEBFUNC_EVNT_CRN | GEBFUNC | (1,1)-(0,n) |
GERFFEE | GERFFEE_FUNC_CODE | GEBFUNC_FUNC_CODE | GEBFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERFFEE and GTVFUNC (FK1_GERFFEE_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERFFEE | GERFFEE_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERSUBJ and GERFCOM (FK1_GERSUBJ_INV_GERFCOM_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERSUBJ | GERSUBJ_EVNT_CRN | GERFCOM_EVNT_CRN | GERFCOM | (1,1)-(0,n) |
GERSUBJ | GERSUBJ_FUNC_CODE | GERFCOM_FUNC_CODE | GERFCOM | (1,1)-(0,n) |
GERSUBJ | GERSUBJ_GRP_SEQ_NO | GERFCOM_GRP_SEQ_NO | GERFCOM | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERSUBJ and GTVFUNC (FK1_GERSUBJ_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERSUBJ | GERSUBJ_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERTKID and GERTASK (FK1_GERTKID_INV_GERTASK_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERTKID | GERTKID_EVNT_CRN | GERTASK_EVNT_CRN | GERTASK | (1,1)-(0,n) |
GERTKID | GERTKID_FUNC_CODE | GERTASK_FUNC_CODE | GERTASK | (1,1)-(0,n) |
GERTKID | GERTKID_TASK_CODE | GERTASK_TASK_CODE | GERTASK | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GERTKID and GTVFUNC (FK1_GERTKID_INV_GTVFUNC_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GERTKID | GERTKID_FUNC_CODE | GTVFUNC_CODE | GTVFUNC | (1,1)-(0,n) |