| "SHIFT to SHIFT_SUMM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT |
| Child Table | SHIFT_SUMM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT to SHIFT_SUMM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT to SHIFT_SUMM" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID | SHIFT_ID |
| "SHIFT to SHIFT_SUMM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT to SHIFT_SUMM" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP1 to BEAM_DOWNTIME_ACCT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP1 |
| Child Table | BEAM_DOWNTIME_ACCT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP1 to BEAM_DOWNTIME_ACCT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP1 to BEAM_DOWNTIME_ACCT" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID | OPER_GRP_ID, OPER_SUBGRP1_ID |
| "OPER_SUBGRP1 to BEAM_DOWNTIME_ACCT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP1 to BEAM_DOWNTIME_ACCT" Bound Attachments |
| Name | Current Value |
| "OPER_PROC_MAN to OPER_PROC_MAN_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_PROC_MAN |
| Child Table | OPER_PROC_MAN_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_PROC_MAN to OPER_PROC_MAN_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_PROC_MAN to OPER_PROC_MAN_REV" Foreign Keys |
| Parent Key | Child Key |
| OPER_PROC_MAN_ID | OPER_PROC_MAN_ID |
| "OPER_PROC_MAN to OPER_PROC_MAN_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_PROC_MAN to OPER_PROC_MAN_REV" Bound Attachments |
| Name | Current Value |
| "BEAM_ACCT_DELIV_TYPE to BEAM_ACCT_ACT_DELIV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | BEAM_ACCT_RPT_ACT_DELIV_FK2 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BEAM_ACCT_DELIV_TYPE |
| Child Table | BEAM_ACCT_ACT_DELIV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BEAM_ACCT_DELIV_TYPE to BEAM_ACCT_ACT_DELIV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BEAM_ACCT_DELIV_TYPE to BEAM_ACCT_ACT_DELIV" Foreign Keys |
| Parent Key | Child Key |
| DELIV_TYPE | DELIV_TYPE |
| "BEAM_ACCT_DELIV_TYPE to BEAM_ACCT_ACT_DELIV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BEAM_ACCT_DELIV_TYPE to BEAM_ACCT_ACT_DELIV" Bound Attachments |
| Name | Current Value |
| "BEAM_ACCT_REQ_TYPE to BEAM_ACCT_ACT_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | BEAM_ACCT_RPT_ACT_REQ_FK2 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BEAM_ACCT_REQ_TYPE |
| Child Table | BEAM_ACCT_ACT_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BEAM_ACCT_REQ_TYPE to BEAM_ACCT_ACT_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BEAM_ACCT_REQ_TYPE to BEAM_ACCT_ACT_REQ" Foreign Keys |
| Parent Key | Child Key |
| REQ_TYPE | REQ_TYPE |
| "BEAM_ACCT_REQ_TYPE to BEAM_ACCT_ACT_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BEAM_ACCT_REQ_TYPE to BEAM_ACCT_ACT_REQ" Bound Attachments |
| Name | Current Value |
| "CHKLST to CHKLST_STEP" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | chklst_chklst_step_rf |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CHKLST |
| Child Table | CHKLST_STEP |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CHKLST to CHKLST_STEP" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CHKLST to CHKLST_STEP" Foreign Keys |
| Parent Key | Child Key |
| Chklst Id, Chklst Rev | Chklst Id, Chklst Rev |
| "CHKLST to CHKLST_STEP" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CHKLST to CHKLST_STEP" Bound Attachments |
| Name | Current Value |
| "FISCAL_YEAR to ACCEL_RUN_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_accel_run_sched_to_fy |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | FISCAL_YEAR |
| Child Table | ACCEL_RUN_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "FISCAL_YEAR to ACCEL_RUN_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "FISCAL_YEAR to ACCEL_RUN_SCHED" Foreign Keys |
| Parent Key | Child Key |
| FY_ID | FY_ID |
| "FISCAL_YEAR to ACCEL_RUN_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "FISCAL_YEAR to ACCEL_RUN_SCHED" Bound Attachments |
| Name | Current Value |
| "ACCEL_RUN_SCHED_ACT to ACCEL_PROD_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_aps_to_accel_run_sched_act |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | ACCEL_RUN_SCHED_ACT |
| Child Table | ACCEL_PROD_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "ACCEL_RUN_SCHED_ACT to ACCEL_PROD_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "ACCEL_RUN_SCHED_ACT to ACCEL_PROD_SCHED" Foreign Keys |
| Parent Key | Child Key |
| RUN_SCHED_ACT_ID | RUN_SCHED_ACT_ID |
| "ACCEL_RUN_SCHED_ACT to ACCEL_PROD_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "ACCEL_RUN_SCHED_ACT to ACCEL_PROD_SCHED" Bound Attachments |
| Name | Current Value |
| "RUN_SCHED_STAT to ACCEL_RUN_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ars_to_run_sched_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RUN_SCHED_STAT |
| Child Table | ACCEL_RUN_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RUN_SCHED_STAT to ACCEL_RUN_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RUN_SCHED_STAT to ACCEL_RUN_SCHED" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "RUN_SCHED_STAT to ACCEL_RUN_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RUN_SCHED_STAT to ACCEL_RUN_SCHED" Bound Attachments |
| Name | Current Value |
| "BEAM_DOWNTIME_ACCT to DT_TIMER_ACCT_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_beam_dt_acct_to_dtaa |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BEAM_DOWNTIME_ACCT |
| Child Table | DT_TIMER_ACCT_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BEAM_DOWNTIME_ACCT to DT_TIMER_ACCT_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BEAM_DOWNTIME_ACCT to DT_TIMER_ACCT_ASSC" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID, downtime_dte | OPER_GRP_ID, OPER_SUBGRP1_ID, downtime_dte |
| "BEAM_DOWNTIME_ACCT to DT_TIMER_ACCT_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BEAM_DOWNTIME_ACCT to DT_TIMER_ACCT_ASSC" Bound Attachments |
| Name | Current Value |
| "BYPASS_REQ to BYPASS_DVC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BYPASS_DVC_TO_BYPASS_REQ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BYPASS_REQ |
| Child Table | BYPASS_DVC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BYPASS_REQ to BYPASS_DVC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BYPASS_REQ to BYPASS_DVC" Foreign Keys |
| Parent Key | Child Key |
| BYPASS_NBR | BYPASS_NBR |
| "BYPASS_REQ to BYPASS_DVC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BYPASS_REQ to BYPASS_DVC" Bound Attachments |
| Name | Current Value |
| "BYPASS_REQ to BYPASS_IMG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BYPASS_IMG_TO_BYPASS_REQ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BYPASS_REQ |
| Child Table | BYPASS_IMG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BYPASS_REQ to BYPASS_IMG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BYPASS_REQ to BYPASS_IMG" Foreign Keys |
| Parent Key | Child Key |
| BYPASS_NBR | BYPASS_NBR |
| "BYPASS_REQ to BYPASS_IMG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BYPASS_REQ to BYPASS_IMG" Bound Attachments |
| Name | Current Value |
| "BYPASS_MECH to BYPASS_REQ" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BYPASS_REQ_BYPASS_MECH |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BYPASS_MECH |
| Child Table | BYPASS_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BYPASS_MECH to BYPASS_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BYPASS_MECH to BYPASS_REQ" Foreign Keys |
| Parent Key | Child Key |
| BYPASS_MECH_NM | BYPASS_MECH_NM |
| "BYPASS_MECH to BYPASS_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BYPASS_MECH to BYPASS_REQ" Bound Attachments |
| Name | Current Value |
| "DELEG_OF_AUTH to DELEG_PER" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_deleg_per_to_deleg_of_auth |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DELEG_OF_AUTH |
| Child Table | DELEG_PER |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DELEG_OF_AUTH to DELEG_PER" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DELEG_OF_AUTH to DELEG_PER" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "DELEG_OF_AUTH to DELEG_PER" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DELEG_OF_AUTH to DELEG_PER" Bound Attachments |
| Name | Current Value |
| "DELEG_OF_AUTH to DELEG_PROXY" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_deleg_proxy_to_doa |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DELEG_OF_AUTH |
| Child Table | DELEG_PROXY |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DELEG_OF_AUTH to DELEG_PROXY" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DELEG_OF_AUTH to DELEG_PROXY" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "DELEG_OF_AUTH to DELEG_PROXY" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DELEG_OF_AUTH to DELEG_PROXY" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to DELEG_PROXY" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_deleg_proxy_to_employee |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | DELEG_PROXY |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to DELEG_PROXY" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to DELEG_PROXY" Foreign Keys |
| Parent Key | Child Key |
| BN | PROX_BN |
| "EMPLOYEE to DELEG_PROXY" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to DELEG_PROXY" Bound Attachments |
| Name | Current Value |
| "DELEG_PER to DELEG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_deleg_to_deleg_per |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DELEG_PER |
| Child Table | DELEG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DELEG_PER to DELEG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DELEG_PER to DELEG" Foreign Keys |
| Parent Key | Child Key |
| BN, START_DTE | BN, START_DTE |
| "DELEG_PER to DELEG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DELEG_PER to DELEG" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to DELEG" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_deleg_to_employee |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | DELEG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to DELEG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to DELEG" Foreign Keys |
| Parent Key | Child Key |
| BN | DELEG_BN |
| "EMPLOYEE to DELEG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to DELEG" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to DELEG_OF_AUTH" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_doa_to_employee |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | DELEG_OF_AUTH |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to DELEG_OF_AUTH" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to DELEG_OF_AUTH" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to DELEG_OF_AUTH" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to DELEG_OF_AUTH" Bound Attachments |
| Name | Current Value |
| "DELEG_OF_AUTH to DELEG_OF_AUTH_NOTIF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_doan_to_deleg_of_auth |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DELEG_OF_AUTH |
| Child Table | DELEG_OF_AUTH_NOTIF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DELEG_OF_AUTH to DELEG_OF_AUTH_NOTIF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DELEG_OF_AUTH to DELEG_OF_AUTH_NOTIF" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "DELEG_OF_AUTH to DELEG_OF_AUTH_NOTIF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DELEG_OF_AUTH to DELEG_OF_AUTH_NOTIF" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to DELEG_OF_AUTH_NOTIF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_doan_to_employee |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | DELEG_OF_AUTH_NOTIF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to DELEG_OF_AUTH_NOTIF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to DELEG_OF_AUTH_NOTIF" Foreign Keys |
| Parent Key | Child Key |
| BN | NOTIF_BN |
| "EMPLOYEE to DELEG_OF_AUTH_NOTIF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to DELEG_OF_AUTH_NOTIF" Bound Attachments |
| Name | Current Value |
| "DOWNTIME_EVT to DOWNTIME_TIMER" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dt_timer_to_dt_evt |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DOWNTIME_EVT |
| Child Table | DOWNTIME_TIMER |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DOWNTIME_EVT to DOWNTIME_TIMER" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DOWNTIME_EVT to DOWNTIME_TIMER" Foreign Keys |
| Parent Key | Child Key |
| DOWNTIME_EVT_ID | DOWNTIME_EVT_ID |
| "DOWNTIME_EVT to DOWNTIME_TIMER" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DOWNTIME_EVT to DOWNTIME_TIMER" Bound Attachments |
| Name | Current Value |
| "DOWNTIME_TIMER to DT_TIMER_ACCT_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dtaa_to_downtime_timer |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DOWNTIME_TIMER |
| Child Table | DT_TIMER_ACCT_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DOWNTIME_TIMER to DT_TIMER_ACCT_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DOWNTIME_TIMER to DT_TIMER_ACCT_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SEQ_ID | timer_seq_id |
| "DOWNTIME_TIMER to DT_TIMER_ACCT_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DOWNTIME_TIMER to DT_TIMER_ACCT_ASSC" Bound Attachments |
| Name | Current Value |
| "DOWNTIME_TIMER to DT_TIMER_EVT_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dtea_to_downtime_timer |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DOWNTIME_TIMER |
| Child Table | DT_TIMER_EVT_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DOWNTIME_TIMER to DT_TIMER_EVT_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DOWNTIME_TIMER to DT_TIMER_EVT_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SEQ_ID | SEQ_ID |
| "DOWNTIME_TIMER to DT_TIMER_EVT_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DOWNTIME_TIMER to DT_TIMER_EVT_ASSC" Bound Attachments |
| Name | Current Value |
| "DOWNTIME_TIMER_EVT to DT_TIMER_EVT_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dtea_to_dt_timer_evt |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DOWNTIME_TIMER_EVT |
| Child Table | DT_TIMER_EVT_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DOWNTIME_TIMER_EVT to DT_TIMER_EVT_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DOWNTIME_TIMER_EVT to DT_TIMER_EVT_ASSC" Foreign Keys |
| Parent Key | Child Key |
| DT_TIMER_EVT_ID | DT_TIMER_EVT_ID |
| "DOWNTIME_TIMER_EVT to DT_TIMER_EVT_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DOWNTIME_TIMER_EVT to DT_TIMER_EVT_ASSC" Bound Attachments |
| Name | Current Value |
| "PERS_ROLES to PERS_ROLE_EQUIP_SUBCAT_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_FRESA_PERS_ROLES_BN |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERS_ROLES |
| Child Table | PERS_ROLE_EQUIP_SUBCAT_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERS_ROLES to PERS_ROLE_EQUIP_SUBCAT_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERS_ROLES to PERS_ROLE_EQUIP_SUBCAT_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "PERS_ROLES to PERS_ROLE_EQUIP_SUBCAT_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERS_ROLES to PERS_ROLE_EQUIP_SUBCAT_ASGN" Bound Attachments |
| Name | Current Value |
| "HOLIDAY to HOLIDAY_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_holiday_sched_to_holiday |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | HOLIDAY |
| Child Table | HOLIDAY_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "HOLIDAY to HOLIDAY_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "HOLIDAY to HOLIDAY_SCHED" Foreign Keys |
| Parent Key | Child Key |
| NM | NM |
| "HOLIDAY to HOLIDAY_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "HOLIDAY to HOLIDAY_SCHED" Bound Attachments |
| Name | Current Value |
| "MSG_CHAN_ACCESS to MSG_CHAN" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_MSG_CHAN_ACCESS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | MSG_CHAN_ACCESS |
| Child Table | MSG_CHAN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "MSG_CHAN_ACCESS to MSG_CHAN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "MSG_CHAN_ACCESS to MSG_CHAN" Foreign Keys |
| Parent Key | Child Key |
| ACCESS_ID | ACCESS_ID |
| "MSG_CHAN_ACCESS to MSG_CHAN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "MSG_CHAN_ACCESS to MSG_CHAN" Bound Attachments |
| Name | Current Value |
| "MSG_CHAN to MSG_CHAN_MSG" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_MSG_CHAN_MSG_CHAN |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | MSG_CHAN |
| Child Table | MSG_CHAN_MSG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "MSG_CHAN to MSG_CHAN_MSG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "MSG_CHAN to MSG_CHAN_MSG" Foreign Keys |
| Parent Key | Child Key |
| MSG_CHAN_ID | MSG_CHAN_ID |
| "MSG_CHAN to MSG_CHAN_MSG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "MSG_CHAN to MSG_CHAN_MSG" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to OPER_SUBGRP1" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_oper_subgrp1_oper_grp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | OPER_SUBGRP1 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_GRP to OPER_SUBGRP1" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to OPER_SUBGRP1" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | OPER_GRP_ID |
| "OPER_GRP to OPER_SUBGRP1" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to OPER_SUBGRP1" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP1 to OPER_SUBGRP2" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_oper_subgrp2_oper_subgrp1 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP1 |
| Child Table | OPER_SUBGRP2 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP1 to OPER_SUBGRP2" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP1 to OPER_SUBGRP2" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID | OPER_GRP_ID, OPER_SUBGRP1_ID |
| "OPER_SUBGRP1 to OPER_SUBGRP2" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP1 to OPER_SUBGRP2" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP2 to OPER_SUBGRP3" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_oper_subgrp3_oper_subgrp2 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP2 |
| Child Table | OPER_SUBGRP3 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP2 to OPER_SUBGRP3" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP2 to OPER_SUBGRP3" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID | OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID |
| "OPER_SUBGRP2 to OPER_SUBGRP3" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP2 to OPER_SUBGRP3" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP3 to OPER_SUBGRP4" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_oper_subgrp3_oper_subgrp4 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP3 |
| Child Table | OPER_SUBGRP4 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP3 to OPER_SUBGRP4" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP3 to OPER_SUBGRP4" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID, OPER_SUBGRP3_ID | OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID, OPER_SUBGRP3_ID |
| "OPER_SUBGRP3 to OPER_SUBGRP4" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP3 to OPER_SUBGRP4" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP4 to OPER_SUBGRP5" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_oper_subgrp4_oper_subgrp5 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP4 |
| Child Table | OPER_SUBGRP5 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP4 to OPER_SUBGRP5" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP4 to OPER_SUBGRP5" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID, OPER_SUBGRP3_ID, OPER_SUBGRP4_ID | OPER_GRP_ID, OPER_SUBGRP1_ID, OPER_SUBGRP2_ID, OPER_SUBGRP3_ID, OPER_SUBGRP4_ID |
| "OPER_SUBGRP4 to OPER_SUBGRP5" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP4 to OPER_SUBGRP5" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to OPM_AUTHOR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_auth_assc_to_emp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | OPM_AUTHOR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to OPM_AUTHOR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to OPM_AUTHOR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to OPM_AUTHOR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to OPM_AUTHOR_ASSC" Bound Attachments |
| Name | Current Value |
| "OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_auth_assc_to_opm_rev |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_PROC_MAN_REV |
| Child Table | OPM_AUTHOR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
| "OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Bound Attachments |
| Name | Current Value |
| "OPER_PROC_MAN_REV to OPM_CHAP" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_chap_to_opm_rev |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_PROC_MAN_REV |
| Child Table | OPM_CHAP |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_PROC_MAN_REV to OPM_CHAP" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_PROC_MAN_REV to OPM_CHAP" Foreign Keys |
| Parent Key | Child Key |
| OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
| "OPER_PROC_MAN_REV to OPM_CHAP" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_PROC_MAN_REV to OPM_CHAP" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to OPM_GRP" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_grp_to_oper_grp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | OPM_GRP |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_GRP to OPM_GRP" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to OPM_GRP" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | OPER_GRP_ID |
| "OPER_GRP to OPM_GRP" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to OPM_GRP" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP1 to OPM_GRP" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_grp_to_oper_subgrp1 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP1 |
| Child Table | OPM_GRP |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP1 to OPM_GRP" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP1 to OPM_GRP" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID | OPER_GRP_ID, OPER_SUBGRP1_ID |
| "OPER_SUBGRP1 to OPM_GRP" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP1 to OPM_GRP" Bound Attachments |
| Name | Current Value |
| "OPM_GRP to OPER_PROC_MAN" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_grp_to_opm |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPM_GRP |
| Child Table | OPER_PROC_MAN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPM_GRP to OPER_PROC_MAN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPM_GRP to OPER_PROC_MAN" Foreign Keys |
| Parent Key | Child Key |
| GRP_ID | GRP_ID |
| "OPM_GRP to OPER_PROC_MAN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPM_GRP to OPER_PROC_MAN" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to OPM_REVIEWER_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_rev_assc_to_emp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | OPM_REVIEWER_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to OPM_REVIEWER_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to OPM_REVIEWER_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to OPM_REVIEWER_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to OPM_REVIEWER_ASSC" Bound Attachments |
| Name | Current Value |
| "OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_rev_assc_to_opm_rev |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_PROC_MAN_REV |
| Child Table | OPM_REVIEWER_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Foreign Keys |
| Parent Key | Child Key |
| OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
| "OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Bound Attachments |
| Name | Current Value |
| "OPM_REVIEW_STAT to OPER_PROC_MAN_REV" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_opm_to_opm_rev_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPM_REVIEW_STAT |
| Child Table | OPER_PROC_MAN_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Foreign Keys |
| Parent Key | Child Key |
| REVIEW_STAT_ID | REVIEW_STAT_ID |
| "OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to ORG_MATRIX" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_org_matrix_to_emp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | ORG_MATRIX |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to ORG_MATRIX" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to ORG_MATRIX" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to ORG_MATRIX" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to ORG_MATRIX" Bound Attachments |
| Name | Current Value |
| "OPER_ACT to OPER_STATE" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_os_to_oper_act |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_ACT |
| Child Table | OPER_STATE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_ACT to OPER_STATE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_ACT to OPER_STATE" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "OPER_ACT to OPER_STATE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_ACT to OPER_STATE" Bound Attachments |
| Name | Current Value |
| "OPER_STAT to OPER_STATE" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_os_to_oper_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_STAT |
| Child Table | OPER_STATE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_STAT to OPER_STATE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_STAT to OPER_STATE" Foreign Keys |
| Parent Key | Child Key |
| OPER_STAT_ID | OPER_STAT_ID |
| "OPER_STAT to OPER_STATE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_STAT to OPER_STATE" Bound Attachments |
| Name | Current Value |
| "DELEG_OF_AUTH to PERS_LOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pers_loc_to_del_auth |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | DELEG_OF_AUTH |
| Child Table | PERS_LOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "DELEG_OF_AUTH to PERS_LOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "DELEG_OF_AUTH to PERS_LOC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "DELEG_OF_AUTH to PERS_LOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "DELEG_OF_AUTH to PERS_LOC" Bound Attachments |
| Name | Current Value |
| "JOB_TITLE to PERS_ROLES" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pers_role_to_job_title |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | JOB_TITLE |
| Child Table | PERS_ROLES |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "JOB_TITLE to PERS_ROLES" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "JOB_TITLE to PERS_ROLES" Foreign Keys |
| Parent Key | Child Key |
| JOB_TITLE_ID | JOB_TITLE_ID |
| "JOB_TITLE to PERS_ROLES" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "JOB_TITLE to PERS_ROLES" Bound Attachments |
| Name | Current Value |
| "PERS_ROLES to PERS_ROLE_EQUIP_CAT_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRECA_PERS_ROLES_BN |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERS_ROLES |
| Child Table | PERS_ROLE_EQUIP_CAT_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERS_ROLES to PERS_ROLE_EQUIP_CAT_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERS_ROLES to PERS_ROLE_EQUIP_CAT_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | Personnel Role_BN |
| "PERS_ROLES to PERS_ROLE_EQUIP_CAT_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERS_ROLES to PERS_ROLE_EQUIP_CAT_ASGN" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to PERS_ROLE_EQUIP_CAT_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRECA_TO_OPER_GRP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | PERS_ROLE_EQUIP_CAT_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_GRP to PERS_ROLE_EQUIP_CAT_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to PERS_ROLE_EQUIP_CAT_ASGN" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | EQUIP_CAT_ID |
| "OPER_GRP to PERS_ROLE_EQUIP_CAT_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to PERS_ROLE_EQUIP_CAT_ASGN" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP1 to PERS_ROLE_EQUIP_SUBCAT_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROSG1_TO_OPER_SUBGRP1 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP1 |
| Child Table | PERS_ROLE_EQUIP_SUBCAT_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP1 to PERS_ROLE_EQUIP_SUBCAT_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP1 to PERS_ROLE_EQUIP_SUBCAT_ASGN" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID | EQUIP_CAT_ID, EQUIP_SUBCAT_ID |
| "OPER_SUBGRP1 to PERS_ROLE_EQUIP_SUBCAT_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP1 to PERS_ROLE_EQUIP_SUBCAT_ASGN" Bound Attachments |
| Name | Current Value |
| "RAD_AREA to RAD_AREA_ROLE_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rad_asgn_area |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RAD_AREA |
| Child Table | RAD_AREA_ROLE_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RAD_AREA to RAD_AREA_ROLE_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RAD_AREA to RAD_AREA_ROLE_ASGN" Foreign Keys |
| Parent Key | Child Key |
| AREA_ID | AREA_ID |
| "RAD_AREA to RAD_AREA_ROLE_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RAD_AREA to RAD_AREA_ROLE_ASGN" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to RAD_AREA_ROLE_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rad_asgn_emp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | RAD_AREA_ROLE_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to RAD_AREA_ROLE_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to RAD_AREA_ROLE_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to RAD_AREA_ROLE_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to RAD_AREA_ROLE_ASGN" Bound Attachments |
| Name | Current Value |
| "RAD_AREA_ROLE to RAD_AREA_ROLE_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rad_asgn_role |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RAD_AREA_ROLE |
| Child Table | RAD_AREA_ROLE_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RAD_AREA_ROLE to RAD_AREA_ROLE_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RAD_AREA_ROLE to RAD_AREA_ROLE_ASGN" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "RAD_AREA_ROLE to RAD_AREA_ROLE_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RAD_AREA_ROLE to RAD_AREA_ROLE_ASGN" Bound Attachments |
| Name | Current Value |
| "RUN_SCHED_STAT to REAC_FUEL_CYC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rfc_to_run_sched_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RUN_SCHED_STAT |
| Child Table | REAC_FUEL_CYC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RUN_SCHED_STAT to REAC_FUEL_CYC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RUN_SCHED_STAT to REAC_FUEL_CYC" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "RUN_SCHED_STAT to REAC_FUEL_CYC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RUN_SCHED_STAT to REAC_FUEL_CYC" Bound Attachments |
| Name | Current Value |
| "REAC_FUEL_CYC to REAC_RUN_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rrs_to_reac_fuel_cyc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | REAC_FUEL_CYC |
| Child Table | REAC_RUN_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "REAC_FUEL_CYC to REAC_RUN_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "REAC_FUEL_CYC to REAC_RUN_SCHED" Foreign Keys |
| Parent Key | Child Key |
| FUEL_CYC_ID | FUEL_CYC_ID |
| "REAC_FUEL_CYC to REAC_RUN_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "REAC_FUEL_CYC to REAC_RUN_SCHED" Bound Attachments |
| Name | Current Value |
| "REAC_OPER_ACT to REAC_RUN_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rrs_to_reac_oper_act |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | REAC_OPER_ACT |
| Child Table | REAC_RUN_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "REAC_OPER_ACT to REAC_RUN_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "REAC_OPER_ACT to REAC_RUN_SCHED" Foreign Keys |
| Parent Key | Child Key |
| ACT_TYPE_ID | ACT_TYPE_ID |
| "REAC_OPER_ACT to REAC_RUN_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "REAC_OPER_ACT to REAC_RUN_SCHED" Bound Attachments |
| Name | Current Value |
| "SHIFT to SHIFT_HOLI_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_shift_holi_sched_to_shift |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT |
| Child Table | SHIFT_HOLI_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT to SHIFT_HOLI_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT to SHIFT_HOLI_SCHED" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID | SHIFT_ID |
| "SHIFT to SHIFT_HOLI_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT to SHIFT_HOLI_SCHED" Bound Attachments |
| Name | Current Value |
| "SHIFT to SHIFT_SCHED_WORK_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_shift_pers_asgn_to_shift |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT |
| Child Table | SHIFT_SCHED_WORK_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT to SHIFT_SCHED_WORK_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT to SHIFT_SCHED_WORK_ASGN" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID | SHIFT_ID |
| "SHIFT to SHIFT_SCHED_WORK_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT to SHIFT_SCHED_WORK_ASGN" Bound Attachments |
| Name | Current Value |
| "SHIFT to SHIFT_WORK_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_shift_work_sched_to_shift |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT |
| Child Table | SHIFT_WORK_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT to SHIFT_WORK_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT to SHIFT_WORK_SCHED" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID | SHIFT_ID |
| "SHIFT to SHIFT_WORK_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT to SHIFT_WORK_SCHED" Bound Attachments |
| Name | Current Value |
| "PERS_ROLES to SHIFT_SCHED_WORK_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_spa_to_pers_role |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERS_ROLES |
| Child Table | SHIFT_SCHED_WORK_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERS_ROLES to SHIFT_SCHED_WORK_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERS_ROLES to SHIFT_SCHED_WORK_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "PERS_ROLES to SHIFT_SCHED_WORK_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERS_ROLES to SHIFT_SCHED_WORK_ASGN" Bound Attachments |
| Name | Current Value |
| "SHIFT_WORK_SCHED to SHIFT_SCHED_WORK_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_spa_to_shift_work_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT_WORK_SCHED |
| Child Table | SHIFT_SCHED_WORK_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT_WORK_SCHED to SHIFT_SCHED_WORK_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT_WORK_SCHED to SHIFT_SCHED_WORK_ASGN" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID, CAL_DTE | SHIFT_ID, CAL_DTE |
| "SHIFT_WORK_SCHED to SHIFT_SCHED_WORK_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT_WORK_SCHED to SHIFT_SCHED_WORK_ASGN" Bound Attachments |
| Name | Current Value |
| "SHIFT_SUMM to SHIFT_SUMM_FILE_ATTACH" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ssfa_to_shift_summ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT_SUMM |
| Child Table | SHIFT_SUMM_FILE_ATTACH |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT_SUMM to SHIFT_SUMM_FILE_ATTACH" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT_SUMM to SHIFT_SUMM_FILE_ATTACH" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID, CAL_DTE | SHIFT_ID, CAL_DTE |
| "SHIFT_SUMM to SHIFT_SUMM_FILE_ATTACH" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT_SUMM to SHIFT_SUMM_FILE_ATTACH" Bound Attachments |
| Name | Current Value |
| "SHIFT_SUMM to SHIFT_SUM_PROC_VAR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_sspva_to_shift_summ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT_SUMM |
| Child Table | SHIFT_SUM_PROC_VAR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT_SUMM to SHIFT_SUM_PROC_VAR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT_SUMM to SHIFT_SUM_PROC_VAR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID, CAL_DTE | SHIFT_ID, CAL_DTE |
| "SHIFT_SUMM to SHIFT_SUM_PROC_VAR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT_SUMM to SHIFT_SUM_PROC_VAR_ASSC" Bound Attachments |
| Name | Current Value |
| "SHIFT_SUMM_PROC_VAR to SHIFT_SUM_PROC_VAR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_sspva_to_shpv |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT_SUMM_PROC_VAR |
| Child Table | SHIFT_SUM_PROC_VAR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT_SUMM_PROC_VAR to SHIFT_SUM_PROC_VAR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT_SUMM_PROC_VAR to SHIFT_SUM_PROC_VAR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SGNL_ID | SGNL_ID |
| "SHIFT_SUMM_PROC_VAR to SHIFT_SUM_PROC_VAR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT_SUMM_PROC_VAR to SHIFT_SUM_PROC_VAR_ASSC" Bound Attachments |
| Name | Current Value |
| "SHIFT_ACT to SHIFT_SCHED_WORK_ASGN" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_sswa_to_shift_act |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SHIFT_ACT |
| Child Table | SHIFT_SCHED_WORK_ASGN |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SHIFT_ACT to SHIFT_SCHED_WORK_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SHIFT_ACT to SHIFT_SCHED_WORK_ASGN" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ACT_ID | SHIFT_ACT_ID |
| "SHIFT_ACT to SHIFT_SCHED_WORK_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SHIFT_ACT to SHIFT_SCHED_WORK_ASGN" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to TGT_BEAM_PARM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_tgt_beam_parm_emp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | TGT_BEAM_PARM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to TGT_BEAM_PARM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to TGT_BEAM_PARM" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to TGT_BEAM_PARM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to TGT_BEAM_PARM" Bound Attachments |
| Name | Current Value |
| "CHKLST to OPR_CHKLST" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | opr_chklst_chklst_rf |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CHKLST |
| Child Table | OPR_CHKLST |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CHKLST to OPR_CHKLST" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CHKLST to OPR_CHKLST" Foreign Keys |
| Parent Key | Child Key |
| Chklst Id, Chklst Rev | Chklst Id, Chklst Rev |
| "CHKLST to OPR_CHKLST" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CHKLST to OPR_CHKLST" Bound Attachments |
| Name | Current Value |
| "CHKLST_STEP to OPR_CHKLST_ITEM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | opr_chklst_item_chklst_step_rf |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CHKLST_STEP |
| Child Table | OPR_CHKLST_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CHKLST_STEP to OPR_CHKLST_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CHKLST_STEP to OPR_CHKLST_ITEM" Foreign Keys |
| Parent Key | Child Key |
| Chklst Id, Chklst Rev, Step Nbr | Chklst Id, Chklst Rev, Step Nbr |
| "CHKLST_STEP to OPR_CHKLST_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CHKLST_STEP to OPR_CHKLST_ITEM" Bound Attachments |
| Name | Current Value |
| "OPR_CHKLST to OPR_CHKLST_ITEM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | opr_chklst_item_opr_chklst_rf |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPR_CHKLST |
| Child Table | OPR_CHKLST_ITEM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPR_CHKLST to OPR_CHKLST_ITEM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPR_CHKLST to OPR_CHKLST_ITEM" Foreign Keys |
| Parent Key | Child Key |
| Chklst Id, Chklst Rev, Chklst Dte | Chklst Id, Chklst Rev, Chklst Dte |
| "OPR_CHKLST to OPR_CHKLST_ITEM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPR_CHKLST to OPR_CHKLST_ITEM" Bound Attachments |
| Name | Current Value |