V2.44 ERwiY 0P2(( varchar()X%KeyType%TableName %EntityName()Note ID Note Text ! AK_uniq_ind_codedAU Always uniqueMUExample - Inversion entry Mostly unique ATTR_fk_ind_codedBABase attributeFKForeign key attribute ATTR_pk_ind_codedNKNonkey attributePKPrimary key attribute CARD_REL_ch_card_codedEX Exactly NPO (one or more)PositiveRARangeSPSpecialZMZero, one, or moreZO Zero or one CARD_REL_ident_ind_codedID IdentifyingNINonidentifying CARD_REL_pa_card_codedOP (zero or one)OptionalMA(one) Mandatory CAT_compl_ind_codedCCCategory CompleteICIncomplete Category DATA_OWNER_data_type_codedRDREPLICATION-DATA-OWNERNDNON-REPLICATION-DATA-OWNER DOM_data_null_ind_codedNA Nulls AllowedNNNo Nulls DOM_data_type_codedCHAR CharacterINTIntegerREAL Real NumberTEXTText DOM_restr_type_codedEN EnumeratedFUFunctionRARange DOM_VAL_type_codedDFLTgDefault value to a domain means that generally attributes with that domain use that value as a default.DefaultELEMGEnumerated domains are associated with a complete set of domain values.ElementEXAMNExample values are common during the early development stages of a data model.ExampleMAX-EX*The maximum value excluded from the range.Maximum ExclusiveMAX-IN(The maximum value included in the range.Maximum InclusiveMIN-EX*The minimum value excluded from the range.Minimum ExclusiveMIN-IN(The minimum value included in the range.Minimum Inclusive ENT_depen_codedDE(but not a subtype entity)Dependent EntityIEIndependent EntitySESubtype Entity ENT_storage_type_codedLOGLoggableSTDStandard FILTER_PARAM_func_codedBETWbetweenDIFFnot-likeEQequalEXCLnot inEXSTnot-nullGEQgreater-than-or-equalGREA greater-thanINinLEQless-than-or-equalLESS less-thanLIKElikeNEQ not-equalNULLnullOUTS not-between FK_ATTR_role_name_ind_codedMN Migrated NameRN Role Name MGT_ERROR_reason_coded3010AAn Irrecoverable Referential Integrity Problem has been detected. Reason 010020Attribute out of Domain Value. Reason 020030Entity does not exist in ADES. Reason 030040Incorrect Number of Attributes. Reason 040050Duplicate Key exists. Reason 0500702ADES Transaction can not be decoded (at DM level). Reason 070100:The ARM is not ready to accept the Opening of the Session. Reason 100110$RDU no longer exists or has changed. Reason 110111-Node wants unilaterally to close the session. Reason 111113Shut down of node. Reason 113114Communication problem. Reason 114120=A problem prevents the ARM from maintaining the Open Session. Reason 120121Unable to decode REPMAN PDU. Reason 121122Flow control problem. Reason 1221230Irrecoverable REPMAN Data Manager level problem. Reason 123124Protocol Error (state tables). Reason 1241254Bulk update required but DR denies its transmission. Reason 125130 Unspecified. Reason 130131,R_Data_Id Range Expired for current Session. Reason 131210;System is not ready to accept the opening of a connectrion. Reason 210220HThe TC_DATA PDU corresponding to the received T_Seq_Nr was not received. Reason 220221Message decoding problem. Reason 2212300Node wants to unilaterally close the connection. Reason 230231Shut down of node. Reason 231240Local problem. Reason 240241Communication problem. Reason 241242Protocol error (state table). Reason 242243!Retransmission threshold expired. Reason 243244;The Session was aborted due to REPMAN Data Manager problem. Reason 244250Closing using TC_ABRT. Reason 250251Session Open refused. Reason 251252/Closing using TC_ABRT due to shut down of node. Reason 252260Connection Index Range Expired. Reason 260300Event would break doctrine. Reason 300301Node is becoming inactive. Reason 301302No active contracts. Reason 302303Node status is management mode. Reason 303304Subscriptions are inactive. Reason 304305$The referenced event does not exist. Reason 305306&The referenced event is not confirmed. Reason 306307The contract already exists. Reason 307308Contract not known. Reason 3083096Contract status is already set to the indicated value. Reason 309310Contract status is active. Reason 310312Owner is already resident. Reason 312311 Owner exists. Reason 311313Owner does not exist. Reason 313317Node already has the address. Reason 317318Node does not have the address. Reason 3183212Node status is already set to the indicated value. Reason 3214004Unable to recover lost Transfer Facility connection. Reason 400 MGT_ERROR_severity_coded1fThe error has placed the ARM in an unrecoverable state (perhaps the association should be terminated). Catastrophic2The error has placed the ARM in a state which requires special action (perhaps the node could go into maintenance mode and attempt recover through resynchronisation).Fatal3XThe operation has been rejected and can not be recovered without additional information.Error4@A problem has occurred which required extra recovery procedures.Warning5USome operation of significance has occurred (association between nodes, COLOC, etc.). Informational6WMessages to allow developers to determine the state of the ARM, trace operations, etc.. Debugging MGT_EVENT_confirm_indic_codedN3The MANAGEMENT-EVENT does not have to be confirmed.NoY)The MANAGEMENT-EVENT has to be confirmed.Yes MGT_EVENT_subtype_codedNENegativePOPositivePCPositive CheckNCNegative Check MGT_EVENT_type_codedCA Cancel a future scheduled event.M_CANCELCDWithdraw Contract. M_CONT_DELCPPropose Contract. M_CONT_PROPCSChange Contract Status. M_CONT_STAT_CHGEEV General. M_EVENTMR)ARM Management Resynchronisation request.M_MGT_SYNC_REQNAChange Node Address. M_NODE_ADDR_CHGENSChange Node Status. M_NODE_STAT_CHGEOA Add Owner. M_OWNER_ADDODWithdraw Owner. M_OWNER_DELOR+Operational Data Resynchronisation Request. M_OP_SYNC_REQOSActivate/Deactivate Owner.M_OWNER_STAT_CHGERS Response. M_RESPSS$Change the status of a subscription.M_SUBS_STAT_CHGE mod_lvl_codedAPPL3Application level, denoting a part of a data model. ApplicationDICT2Dictionary level, denoting a part of a data model. DictionaryARM"ATCCIS Replication Mechanism levelARM Management NK_ATTR_opt_ind_codedMA MandatoryOPOptional oper_type_codedIInsertUUpdateDDelete RDC_FILTER_ATTR_vert_eff_codedNUNullDFDefaultRMRemove REL_type_codedCRCardinality RelationSRSubtype Relation REPL_NODE_LINK_stat_coddACActiveINInactiveMA Management REPL_NODE_stat_codedAC@The REPLICATION-NODE is ready to send or accept replicated data.ActiveINDThe REPLICATION-NODE is not ready to send or accept replicated data.InactiveMA*The node can only receive management data.Management mode REPL_ORG_type_codedNM Node Manager REPL_SU_CONT_active_indic_codedAC=Data replication from the Data Provider to the Data Receiver.ActiveIN@No data replication from the Data Provider to the Data Receiver.Inactive stdn_lvl_codedATCOJAll common meta data distributed in support of the Generic Hub data model. ATCCIS CoreATSF=ATCCIS subfunctional areas are extensions to the Generic Hub.ATCCIS Subfunctional AreaINAT>International extensions to the ATCCIS Generic Hub data model. InternationalLOC6Local extensions to the ATCCIS Generic Hub data model.LocalNAT9National extensions to the ATCCIS Generic Hub data model.National2Fill With SpacesspacesSet To Empty Stringempty Set To Nullnull Set To Zero0 Template Name" Template Code Template TypeTemplate CSX IdPARENT UPDATE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE RESTRICT */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or ") */ %JoinPKPK(:%Old,:%New," <> "," or ") then select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); if (numrows > 0) then raise_application_error( -20005, 'Cannot UPDATE %Parent because %Child exists.' ); end if; end if; 'PARENT UPDATE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE CASCADE */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or ") */ %JoinPKPK(:%Old,:%New," <> "," or ") then update %Child set /* %%JoinFKPK(%Child,:%%New," = ",",") */ %JoinFKPK(%Child,:%New," = ",",") where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); end if; 'PARENT UPDATE SET NULL /* %Parent %VerbPhrase %Child ON PARENT UPDATE SET NULL */ if /* %%JoinPKPK(:%%Old,:%%New," <> "," or " */ %JoinPKPK(:%Old,:%New," <> "," or ") then update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where /* %%JoinFKPK(%Child,:%%Old," = ",",") */ %JoinFKPK(%Child,:%Old," = "," and"); end if; 'PARENT DELETE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE RESTRICT */ select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); if (numrows > 0) then raise_application_error( -20001, 'Cannot DELETE %Parent because %Child exists.' ); end if; 'PARENT DELETE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE CASCADE */ delete from %Child where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); 'PARENT DELETE SET NULL4 /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where /* %%JoinFKPK(%Child,:%%Old," = "," and") */ %JoinFKPK(%Child,:%Old," = "," and"); 'CHILD INSERT RESTRICT" /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and"); if ( /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") numrows = 0 ) then raise_application_error( -20002, 'Cannot INSERT %Child because %Parent does not exist.' ); end if; 'CHILD INSERT CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT CASCADE */ insert into %Parent (%ParentPK(",",)) select %ChildFK(",",) from %Child where /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ); 'CHILD INSERT SETNULL /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ) and /* %%JoinPKPK(%Child,:%%New," = "," and") */ %JoinPKPK(%Child,:%New," = "," and"); 'CHILD UPDATE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and"); if ( /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") numrows = 0 ) then raise_application_error( -20007, 'Cannot UPDATE %Child because %Parent does not exist.' ); end if; 'CHILD UPDATE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE CASCADE */ insert into %Parent (%ParentPK(",",)) select %ChildFK(",",) from %Child where /* %%NotnullFK(:%%New," is not null and") */ %NotnullFK(:%New," is not null and") not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ); 'CHILD UPDATE SETNULL /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE SET NULL */ update %Child set /* %%SetFK(%Child,NULL) */ %SetFK(%Child,NULL) where not exists ( select * from %Parent where /* %%JoinFKPK(:%%New,%Parent," = "," and") */ %JoinFKPK(:%New,%Parent," = "," and") ) and /* %%JoinPKPK(%Child,:%%New," = "," and") */ %JoinPKPK(%Child,:%New," = "," and"); 'CHILD DELETE RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE RESTRICT */ select count(*) into numrows from %Parent where /* %%JoinFKPK(:%%Old,%Parent," = "," and") */ %JoinFKPK(:%Old,%Parent," = "," and"); if (numrows > 0) then raise_application_error( -20010, 'Cannot DELETE %Child because %Parent exists.' ); end if; 'CHILD DELETE CASCADE /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE CASCADE */ delete from %Parent where /* %%JoinFKPK(:%%Old,%Parent," = "," and") */ %JoinFKPK(:%Old,%Parent," = "," and"); !'PARENT INSERT RESTRICT /* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT RESTRICT */ select count(*) into numrows from %Child where /* %%JoinFKPK(%Child,:%%New," = "," and") */ %JoinFKPK(%Child,:%New," = "," and"); if (numrows = 0) then raise_application_error( -20011, 'Cannot INSERT %Parent because %Child does not.' ); end if; $' UPDATE HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin(' UPDATE FOOTER%-- ERwin Builtin %Datetime end; / )' DELETE HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin*' DELETE FOOTER%-- ERwin Builtin %Datetime end; / +' INSERT HEADERcreate trigger t%1Action_%27TableName after %Action on %TableName for each row -- ERwin Builtin %Datetime -- %Action trigger on %TableName declare numrows INTEGER; begin,' INSERT FOOTER%-- ERwin Builtin %Datetime end; / -'CUSTOM TRIGGER HEADER`create trigger %TriggerName %Fire %Actions(" or ") on %TableName %RefClause %Scope .'CUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER FOOTERCUSTOM TRIGGER DEFAULT BODY!create trigger %TriggerName %Fire %Actions(" or ") on %TableName %RefClause %Scope /* ERwin Builtin %Datetime */ /* default body for %TriggerName */ declare numrows INTEGER; begin %ForEachChildRel() { %RelTemplate } %ForEachParentRel() { %RelTemplate } end; / 0'PARENT UPDATE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT UPDATE SET DEFAULT */ /* Application specific. Left out intentionally. */'PARENT DELETE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT DELETE SET DEFAULT */ /* Application specific. Left out intentionally. */'PARENT INSERT SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT SET DEFAULT */ /* Application specific. Left out intentionally. */''CHILD INSERT SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD INSERT SET DEFAULT */ /* Application specific. Left out intentionally. */'CHILD UPDATE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD UPDATE SET DEFAULT */ /* Application specific. Left out intentionally. */'CHILD DELETE SET DEFAULT/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE SET DEFAULT */ /* Application specific. Left out intentionally. */#'CHILD DELETE SET NULL/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON CHILD DELETE SET NULL */ /* Application specific. Left out intentionally. */"'PARENT INSERT SET NULL/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT SET NULL */ /* Application specific. Left out intentionally. */&'PARENT INSERT CASCADE/* ERwin Builtin %Datetime */ /* %Parent %VerbPhrase %Child ON PARENT INSERT CASCADE */ /* Application specific. Left out intentionally. */%' Template Name"Template Handle Purpose Text"PurposeTemplate Handle""CHILD DELETE CASCADE!'!'CHILD DELETE RESTRICT ' 'CHILD DELETE SET DEFAULT#'#'CHILD DELETE SET NULL"'"'CHILD INSERT CASCADE''CHILD INSERT RESTRICT''CHILD INSERT SET DEFAULT''CHILD INSERT SET NULL''CHILD UPDATE CASCADE''CHILD UPDATE RESTRICT''CHILD UPDATE SET DEFAULT''CHILD UPDATE SET NULL''CUSTOM TRIGGER DEFAULT BODY0'0'CUSTOM TRIGGER FOOTER/'CUSTOM TRIGGER HEADER.'.'PARENT DELETE CASCADE''PARENT DELETE RESTRICT''PARENT DELETE SET DEFAULT''PARENT DELETE SET NULL''PARENT INSERT CASCADE%'%'PARENT INSERT RESTRICT$'$'PARENT INSERT SET DEFAULT''''PARENT INSERT SET NULL&'&'PARENT UPDATE CASCADE''PARENT UPDATE RESTRICT''PARENT UPDATE SET DEFAULT''PARENT UPDATE SET NULL''RAISE EXCEPTION PROC1'TRIGGER DELETE FOOTER+'+'TRIGGER DELETE HEADER*'*'TRIGGER INSERT FOOTER-'-'TRIGGER INSERT HEADER,','TRIGGER UPDATE FOOTER)')'TRIGGER UPDATE HEADER('('#@ #@ @ @ ''''''''''''''''Default Icon((Default Blob Iconh(@Default Datetime Icon(Default Number Iconh(@Default String Iconh(@ Default Entity Icon ( 𿿿2ADefault Entity Small Iconh(@(((((PN! & !'alternate-key-uniqueness-indicator-code$ !$attribute_standardisation_level_codeattribute_standard_level_cod$ %ColDomainQ !$attribute-foreign-key-indicator-code$ !$attribute-primary-key-indicator-code$attribute_primary_key_indicatoLONG RAW!Blob& !/cardinality-relationship-child-cardinality-code$ !3cardinality-relationship-identifying-indicator-code$ !0cardinality-relationship-parent-cardinality-code$ !%category-completeness-indication-code$E!code$ Yj !%data-owner-operational-data-type-code$DATE!Datetime& !domain-data-null-indicator-code$ !domain-data-type-code$   !domain-restriction-type-code$   !domain-value-type-code$   !entity-dependency-code$   !entity-storage-type-code$   !-foreign-key-attribute-rolename-indicator-code$E! identifier$p! identifier_10$ NUMBER(10)! identifier_11$ NUMBER(11)! identifier_12$ NUMBER(12)! identifier_6$ NUMBER(6)~! identifier_8$ NUMBER(8)|! identifier_9$ NUMBER(9)3!index$y!index-12$ NUMBER(12)!index-2$!index-3$!index-6$ NUMBER(6)!index-7$ !&management-error-operational-type-code$ !management-error-reason-code$ !management-error-severity-code$ !,management-event-confirmation-indicator-code$ !management-event-subtype-code$ !management-event-type-code$ !'management-update-operational-type-code$ !model-level-code$E!name$r)!name-10$ VARCHAR(10))!name-16$)!name-20$ VARCHAR(20))!name-24$ VARCHAR(24))!name-30$ VARCHAR(30))!name-50$ VARCHAR(50))!name-60$ VARCHAR(60))!name-80$ VARCHAR(80) !,non-key-attribute-optionality-indicator-code$NUMBER!Number& 3!quantity$h4! quantity-2$4! quantity-3$ !relation-type-code$ !7replicating-node-link-destination-node-link-status-code$ !replicating-node-status-code$ !"replicating-organisation-type-code$ !3replication-contract-filter-parameter-function-code$ ! replication-contract-status-code$ !Ireplication-domain-composite-filter-attribute-vertical-filter-effect-code$ !,replication-subscriber-active-indicator-code$3!sequence-number$?!sequence-number-15$ NUMBER(15)?!sequence-number-2$ NUMBER(2)?!sequence-number-3$?!sequence-number-4$ !standardisation-level-code$ VARCHAR2(20)!String&E!text$sF!text-10$ VARCHAR(10)F!text-100$ VARCHAR(100)F!text-20$ VARCHAR(20)F!text-255$ VARCHAR(255)F!text-32$ VARCHAR(32)F!text-999$ VARCHAR(999)text_9993!time$time_14 NUMBER(14)w varchar()%AttName %AttName:%AttName%AttDef %DomainDef %DomainName%AttDefny& %AttDomain  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId  UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId5 DiagTitle4 DiagAuth3DiagDef7 DiagImpType6 DiagDbName   UdpKeyList Key ID Key Name Key Flags Key Def Key TypeKey Default Key Seq Key List Key MMId((( Times New RomanTimes New Roman Arial ArialnYYdd?ZjjjkdMMlvYYd l"l#l$M%v'v(w)x*{+{,{.{KLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~lddkddpplYBDBMS DPO_CLASSDPO_IDDPO_NAME DPO_LAST_NAMEA DPO_EPP_UDS DPO_CSX_IDDPO_UDPS<.h1I8*5ARM Managment Data Model Version 5.0 (18 March 2002)(   dd  h1I8*rChanges to NODE_LINK from CP-US-V5-1 deleted last_session_index_descr changed last_r_data_id_descr to NUMERIC(9)(   dd  h1I8*Replication Management View _(   dd  h1I8MANAGEMENT-EVENT-DESTINATIONThe association of a specific MANAGEMENT-EVENT with a specific REPLICATION-NODE that identifies the nodes to which each MANAGEMENT-EVENT is to be sent. MGT_EVENT_DST( distribution-replication-node-id dst_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.D source-replication-node-id src_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.E management-event-indexmgt_event_index(' The unique number assigned to represent a MANAGEMENT-EVENT for a specific REPLICATION-NODE and to distinguish it from all other MANAGEMENT-EVENTs for that REPLICATION-NODE.F.249.274.274.273   ddPKYES IF273NO IF274NO IF273ASCPROP IF274ASCPROP IF274ASCPROP PKASCPROP PKASCPROP PKASCPROP  v6h1I8REPLICATION-SUBSCRIPTIONThe association of an instance of REPLICATION-NODE (the data provider or DP) and another instance of REPLICATION-NODE (the data receiver or DR). REPL_SUBSCR(   status_code VARCHAR(2) $replication-subscription-status-code N  GThe code that indicates whether the REPLICATION-SUBSCRIPTION is active. +Domain values: IN = Inactive; AC = Active.- provider-replication-node-id prov_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.; receiver-replication-node-id recv_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.<.269.270Bd   ddPKXPKREPL_SUBSCRYES IF269NO IF270NO IF269ASCPROP IF270ASCPROP PKASCPROP PKASCPROP  h1I8MANAGEMENT-ERRORZA representation of information about replication failure for a specific REPLICATION-NODE. MGT_ERROR(& source-replication-node-id'( src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.0& %referenced-source-replication-node-id'(refd_src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.1& !referenced-management-event-index'(refd_mgt_event_index The unique number assigned to represent a MANAGEMENT-EVENT for a specific REPLICATION-NODE and to distinguish it from all other MANAGEMENT-EVENTs for that REPLICATION-NODE.2attr_ix& attribute-index'( The unique number assigned to represent a specific ATTRIBUTE for a specific ENTITY and to distinguish it from all other ATTRIBUTEs for that ENTITY.4& management-error-index'(mgt_error_index The unique number assigned to represent a MANAGEMENT-ERROR for a specific REPLICATION-NODE and to distinguish it from all other MANAGEMENT-ERRORs for that REPLICATION-NODE.=3 NUMBER(9)& 2management-error-replication-data-description-text'(r_data_id_descr tThe text that contains the R_Data_Id of a failed REPMAN Data Manager transaction referenced in the MANAGEMENT-ERROR. ?" & management-error-reason-code'( reason_code N VARCHAR(3) 4The code that represents the type of error detected. ZDomain values: 010 = An Irrecoverable Referential Integrity Problem has been detected; 020 = Attribute out of Domain Value; 030 = Entity does not exist in ADES; 040 = Incorrect Number of Attributes; 050 = Duplicate Key exists; 070 = ADES Transaction can not be decoded (at DM level); 100 = The ARM is not ready to accept the Opening of the Session; 110 = RDU no longer exists or has changed; 111 = Node wants unilaterally to close the session; 113 = Shut down of node; 114 = Communication problem; 120 = A problem prevents the ARM from maintaining the Open Session; 121 = Unable to decode REPMAN PDU; 122 = Flow control problem; 123 = Irrecoverable REPMAN Data Manager level problem; 124 = Protocol Error (state tables); 125 = Bulk update required but DR denies its transmission; 130 = Not Specified; Expired; 131 = R_Data_Id Range Expired for current Session; 210 = System is not ready to accept the opening of a connection; 220 = The TC_DATA PDU corresponding to the received T_Seq_Nr was not received; 221 = Message decoding problem; 230 = Node wants to unilaterally close the connection; 231 = Shut down of node; 240 = Local problem; 241 = Communication problem; 242 = Protocol error (state table); 243 = Retransmission threshold expired; 244 = The Session was aborted due to REPMAN Data Manager problem; 250 = Closing using TC_ABRT; 251 = Session Open refused; 252 = Closing using TC_ABRT due to shut down of node; 260 = Connection Index Range Expired; 300 = Event would break doctrine; 301 = Node is becoming inactive; 302 = No active contracts; 303 = Node status is management mode; 304 = Subscriptions are inactive; 305 = The referenced event does not exist; 306 = The referenced event is not confirmed; 307 = The contract already exists; 308 = Contract not known; 309 = Contract status is already set to the indicated value; 310 = Contract status is active; 311 = Owner exists; 312 = Owner is already resident; 313 = Owner does not exist; 317 = Node already has the address; 318 = Node does not have the address; 321 = Node status is already set to the indicated value; 400 = Unable to recover lost Transfer Facility connection.J! & &management-error-operational-type-code'( op_type_code NCHAR(1) 7The code that represents the class of MANAGEMENT-ERROR. BDomain values: I = Hard Insert; D = Hard Delete; U = Hard Update.K# & management-error-severity-code'( severity_code N VARCHAR(2) PThe code that represents the importance of the error detected (mandatory field). fDomain values: 1 = Catastrophic; 2 = Fatal; 3 = Error; 4 = Warning; 5 = Informational; 6 = Debugging.UJ& -management-error-primary-key-description-text'(primary_key_descr The text that contains primary key values separated by vertical bars for the precise operation that failed in a REPMAN Data Manager transaction.VJ& 3management-error-extra-information-description-text'(extra_info_descr KThe text that describes the type of error detected in user-readable format.WM& management-error-creation-time'( creat_time NUMBER(14) @The absolute time the MANAGEMENT-ERROR was created at the senderXent_id& entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.ent_id& entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs..260d dddd dd.179.262 d.263 d.262 d d.249.261 d.261    ddPK XPKMGT_ERRORYES IF260XIF260MGT_ERRORNO IF261XIF261MGT_ERRORNO IF262XIF262MGT_ERRORNO IF263XIF263MGT_ERRORNO IF260 src_node_idASCPROP IF261 refd_src_node_idASCPROP IF261 refd_mgt_event_indexASCPROP IF262 entity_idASCPROP IF262 attribute_indexASCPROP IF263 entity_idASCPROP PK src_node_idASCPROP PKmgt_error_indexASCPROP  h1I8*above this line all entities, except XFER-FAC, NON-REPL- DATA-OWNER and DATA-OWNER (partly), represent dynamic management data about the actual replication topology and events <--------------------------------------------------------------------------> below this line all entities represent static encyclopedic management data about replication contract types and the ADES_(   dd  h1I8*ABBREVIATIONS (max. 7 chars per term) addr address ades ATCCIS Data Exchange Schema arm ATCCIS Replication Mechanism assoc association cat category concl conclusion confirm confirmation cnstrnt constraint def definition dst destination elem element encl enclosing fac facility func function horiz horizontal incr incremental info information mgr manager mgt management obj object op operation oper operational org organisation param parameter prot protocol prov provider r-data REPMAN data rdc Replication Domain Composite rdt Replication Domain Type recv receiver refd referred repl replication resid residence rspbl responsible src source subj subject subscr subscription topo topology xfer transfer vert vertical CLASSWORDS code descr description id identification index indic indication name nr number seqnr sequence number text time _(   dd  6h1I8MANAGEMENT-EVENT|A representation of a set of distributed ARM Management actions to be performed or requested by a specific REPLICATION-NODE. MGT_EVENT(& & management-event-type-code'(event_type_code N VARCHAR(2) TThe code that represents the class of MANAGEMENT-EVENT being performed or requested. Domain values: MR = M_MGT_SYNC_REQ-ARM Management Resynchronisation request-This event is generally triggered by the operator through a Local ARM Management directive perhaps in response to errors; OR = M_OP_SYNC_REQ-Operational Data Resynchronisation Request-This event is generally triggered by the operator through a Local ARM Management directive or in response to irrecoverable errors in the user/operational data; CP = M_CONT_PROP-Propose Contract-This event is generally triggered by the operator through a Local ARM Management directive; CS = M_CONT_STAT_CHGE-Change Contract Status-This event is used to activate or deactivate a contract-Changes to REPLICATION-CONTRACT-FILTER-PARAMETER-FUNCTION, REPLICATION-CONTRACT-FILTER-PARAMETER-VALUE are implemented as new contracts; CD = M_CONT_DEL-Withdraw Contract-This is used to delete a contract and associated filters-If this is the only contract for the subscription, the subscription would also be removed; NS = M_NODE_STAT_CHGE-Change Node Status-This event is used to activate and deactivate a node; NA = M_NODE_ADDR_CHGE-Change Node Address-Change the address of a node (REPLICATION-NODE-ADDRESS) or add or delete the address of REPLICATION-NODE; OS = M_OWNER_RESID_CHGE-Changes the residence of an owner (including changing this value to/from Null, which indicates that this owner does not currently have a residence); OA = M_OWNER_ADD-Add Owner-This adds an owner to a node by creating a residence-This event may also be used to create the owner at the same time; RS = M_RESP-Response-This is used to respond to a confirmed event; EV = M_EVENT-General-Used to exchange all other forms of management exchange; CA = M_CANCEL-Cancel a future scheduled event; SS = M_SUBS_STAT_CHGE-Change the status of a subscription.$ & ,management-event-confirmation-indicator-code'( confirm_indic NCHAR(1) The code that indicates whether the requesting node has asked for a confirmation in which the receiving node will return an event indicating the result of the request. Domain values: Y = Yes; N = No.& !referenced-management-event-index'(refd_mgt_event_index eThe management-event-index of the referred MANAGEMENT-EVENT (a role name for management-event-index).& management-event-index'(mgt_event_index The unique number assigned to represent a MANAGEMENT-EVENT for a specific REPLICATION-NODE and to distinguish it from all other MANAGEMENT-EVENTs for that REPLICATION-NODE.M& management-event-creation-time'( creat_time NUMBER(14) cThe absolute time the MANAGEMENT-EVENT was created at the sender (i.e., issued at the source node).M& management-event-start-time'( start_time NUMBER(14) ]The time at which the MANAGEMENT-EVENT is to be processed when queued for future application. A management-event-start-time attribute of NULL implies that the event is processed immediately in the order it arrives. The management-event-start-time is the beginning of the period of validity for the MANAGEMENT-EVENT.& %referenced-source-replication-node-id'(refd_src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.& source-replication-node-id'( src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.% & management-event-subtype-code'(event_subtype_code N VARCHAR(4) nThe code that represents a detailed class that describes the M_RESP to a specific Referenced MANAGEMENT-EVENT. Domain values: PO = Positive, the confirmed event was accepted; NE = Negative, the confirmed event was rejected; PC = Positive Check; NC = Negative Check.J& 3management-event-extra-information-description-text'(extra_info_descr @The text that amplifies the description of the MANAGEMENT-EVENT..249dddddd d.249.250d.250    ddPK XPKMGT_EVENTYES IF249XIF249MGT_EVENTNO IF250XIF250MGT_EVENTNO IF249 src_node_idASCPROP IF250refd_src_node_idASCPROP IF250 refd_mgt_event_indexASCPROP PK src_node_idASCPROP PKmgt_event_indexASCPROP  #Wlh1I8replication-organisation-type-code org_type_code(   dd  eh1I8REPLICATION-NODE-MANAGERA REPLICATION-ORGANISATION responsible for node management, to include arranging the topology of nodes and establishing contracts.NODE_MGR(& replication-node-manager-id'( node_mgr_id The unique value assigned to represent a specific REPLICATION-ORGANISATION and to distinguish it from all other REPLICATION-ORGANISATIONs.H& 1replication-node-manager-contact-description-text'( contact_descr The text that provides detailed point-of-contact information for the REPLICATION-NODE-MANAGER (such as address, telephone numbers, and email addresses)..242.243d   ddPK XPKREPL_MGRYES IF243XIF243REPL_MGRNO IF243 node_mgr_idASCPROP PK node_mgr_idASCPROP  ~h1I8REPLICATION-NODE-ADDRESS-LINK{An association of a specific TRANSFER-FACILITY to a specific REPLICATION-NODE-LINK for a specific REPLICATION-NODE-ADDRESS.NODE_ADDR_LINK( & *destination-replication-node-address-index'(dst_addr_index NUMBER(2) The unique value assigned to represent a REPLICATION-NODE-ADDRESS for a specific TRANSFER-FACILITY and a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODE-ADDRESSs for that TRANSFER-FACILITY and that REPLICATION-NODE.V& %source-replication-node-address-index'(src_addr_index NUMBER(2) The unique value assigned to represent a REPLICATION-NODE-ADDRESS for a specific TRANSFER-FACILITY and a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODE-ADDRESSs for that TRANSFER-FACILITY and that REPLICATION-NODE.YA& 6replication-node-address-link-priority-sequence-number'( prio_seqnr eThe number that expresses the unique order of importance of a specific REPLICATION-NODE-ADDRESS-LINK.w& source-replication-node-id'( src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.& destination-replication-node-id'( dst_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.& source-replication-node-id'( src_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.F& destination-replication-node-id'( dst_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.G NUMBER(10)& transfer-facility-id'( xfer_fac_id The unique value, or set of characters, assigned to represent a specific TRANSFER-FACILITY and to distinguish it from all other TRANSFER-FACILITYs.r NUMBER(10)& transfer-facility-id'( xfer_fac_id The unique value, or set of characters, assigned to represent a specific TRANSFER-FACILITY and to distinguish it from all other TRANSFER-FACILITYs.v NUMBER(10)& transfer-facility-id'( xfer_fac_id The unique value, or set of characters, assigned to represent a specific TRANSFER-FACILITY and to distinguish it from all other TRANSFER-FACILITYs.w.125.231.126.231.101.233.237.102.233.233d.101.234d.102.234 d.234d   ddPKXPKE_182YES IF231 XIF231E_182NO IF233XIF233NODE_NETWORK_ASSOCNO IF234XIF234NODE_NETWORK_ASSOCNO IF237XIF237NODE_NETWORK_ASSOCNO  IF231 src_node_idASCPROP IF231 dst_node_idASCPROP IF233 dst_node_idASCPROP IF233dst_addr_indexASCPROP IF233 xfer_fac_idASCPROP IF234 src_node_idASCPROP IF234src_addr_indexASCPROP IF234 xfer_fac_idASCPROP IF237 xfer_fac_idASCPROP PK src_node_idASCPROP PK dst_node_idASCPROP PK xfer_fac_idASCPROP PKASCPROP  /A+h1I8REPLICATION-CONTRACT-FILTER-PARAMETER-FUNCTIONAn association between a specific REPLICATION-CONTRACT and a specific REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER representing a computational rule that may be referenced for defining a filter.FILTER_PARAM_FUNC( & replication-contract-index'(repl_contr_index The unique number assigned to represent a REPLICATION-CONTRACT for a specific REPLICATION-DOMAIN-COMPOSITE and a specific REPLICATION-SUBSCRIPTION and to distinguish it from all other REPLICATION-CONTRACTs for that REPLICATION-DOMAIN-COMPOSITE and REPLICATION-SUBSCRIPTION.& )replication-domain-composite-filter-index'(rdc_filter_index The unique number assigned to represent a REPLICATION-DOMAIN-COMPOSITE-FILTER for a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITE-FILTERs for that REPLICATION-DOMAIN-COMPOSITE.& 3replication-domain-composite-filter-parameter-index'(filter_param_index NUMBER(3) The unique number assigned to represent a REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER for a specific REPLICATION-DOMAIN-COMPOSITE-FILTER and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETERs for that REPLICATION-DOMAIN-COMPOSITE-FILTER."; & 3replication-contract-filter-parameter-function-code'( func_code N VARCHAR(4) uThe code that represents the mathematical relationship for a specific REPLICATION-CONTRACT-FILTER-PARAMETER-FUNCTION. Domain values: EQ = Equal; GREA = Greater than; LESS = Less than; GEQ = Greater than or equal; LEQ = Less than or equal; NEQ = Not equal; BETW = Between; OUTS = Not between; IN = In; EXCL = Not in; NULL = Null; EXST = Not null; LIKE = Like; DIFF = Not like.% NUMBER(12)& replication-domain-composite-id'(rdc_id The unique value, or set of characters, assigned to represent a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITEs. NUMBER(12)& replication-domain-composite-id'(rdc_id The unique value, or set of characters, assigned to represent a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITEs. provider-replication-node-id prov_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.? receiver-replication-node-id recv_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.B .134.144.219.114.217.217.144.219..219 .269.272.217 .270.272.217d   ddPKXPKE_177YES IF217 XIF217E_177NO IF219 XIF219E_177NO  IF217rdc_idASCPROP IF217repl_contr_indexASCPROP IF217ASCPROP IF217ASCPROP IF219rdc_idASCPROP IF219rdc_filter_indexASCPROP IF219filter_param_indexASCPROP PKrdc_idASCPROP PKrepl_contr_indexASCPROP PKrdc_filter_indexASCPROP PKfilter_param_indexASCPROP PKASCPROP PKASCPROP  ,Lh1I8REPLICATION-CONTRACT-FILTER-PARAMETER-VALUE A representation of the various values (e.g., codes, numbers, dates) that may be referenced for defining a filter for use in obtaining the truth or falsehood of a REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER when applied to data elements of the replicated database.FILTER_PARAM_VALUE( J& <replication-contract-filter-parameter-value-description-text'( value_descr [The text that provides the actual value of the REPLICATION-CONTRACT-FILTER-PARAMETER-VALUE. & replication-contract-index'(repl_contr_index The unique number assigned to represent a REPLICATION-CONTRACT for a specific REPLICATION-DOMAIN-COMPOSITE and a specific REPLICATION-SUBSCRIPTION and to distinguish it from all other REPLICATION-CONTRACTs for that REPLICATION-DOMAIN-COMPOSITE and REPLICATION-SUBSCRIPTION.& )replication-domain-composite-filter-index'(rdc_filter_index The unique number assigned to represent a REPLICATION-DOMAIN-COMPOSITE-FILTER for a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITE-FILTERs for that REPLICATION-DOMAIN-COMPOSITE.  NUMBER(3)& 3replication-domain-composite-filter-parameter-index'(filter_param_index The unique number assigned to represent a REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER for a specific REPLICATION-DOMAIN-COMPOSITE-FILTER and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETERs for that REPLICATION-DOMAIN-COMPOSITE-FILTER.#& 1replication-contract-filter-parameter-value-index'(filter_param_value_index The unique number assigned to represent a REPLICATION-CONTRACT-FILTER-PARAMETER-VALUE for a specific REPLICATION-CONTRACT-FILTER-PARAMETER-FUNCTION and to distinguish it from all other REPLICATION-CONTRACT-FILTER-PARAMETER-VALUEs for that REPLICATION-CONTRACT-FILTER-PARAMETER-FUNCTION. NUMBER(2)A& ;replication-contract-filter-parameter-value-sequence-number'( value_seqnr zThe number that represents the order in which an instance of REPLICATION-CONTRACT-FILTER-PARAMETER-VALUE is to be applied. NUMBER(12)& replication-domain-composite-id'(rdc_id The unique value, or set of characters, assigned to represent a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITEs. NUMBER(12)& replication-domain-composite-id'(rdc_id The unique value, or set of characters, assigned to represent a specific REPLICATION-DOMAIN-COMPOSITE and to distinguish it from all other REPLICATION-DOMAIN-COMPOSITEs. provider-replication-node-id prov_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.@ receiver-replication-node-id recv_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.C.134.144.219.218 .114.217.218.217.218 .144.219.218..219.218.269.272.217.218.270.272.217.218 dd   ddPKXPKFILTER_PARAM_VALUEYES IF218XIF218FILTER_PARAM_VALUENO  IF218rdc_idASCPROP IF218repl_contr_indexASCPROP IF218rdc_filter_indexASCPROP IF218filter_param_indexASCPROP IF218ASCPROP IF218ASCPROP PKrdc_idASCPROP PKrepl_contr_indexASCPROP PKrdc_filter_indexASCPROP PKfilter_param_indexASCPROP PKfilter_param_value_indexASCPROP PKASCPROP PKASCPROP  h1I8* META DOMAINS (ADES View) *.st-l-co (ATCO,ATSF,INAT,NAT,LOC) *.mo-l-co (APPL,DICT,ARM) ENT.dep-co (IE,DE,SE) ENT.st-ty-co (STD,LOG) ATTR.pk-ind (PK,NK) ATTR.fk-ind (FK,BA) AK.un-ind (AU,MU) NKA.opt-ind (OP,MA) FKA .rona-ind (RN,MN) CAT.com-ind (CC,IC) REL.rel-ty-co (CR,SR) CREL.id-ind (ID,NI) CREL.pa-c-co (MA,OP) CREL.ch-c-co (ZM,PO,ZO,EX,RA,SP) DOM.res-ty (EN,RA,FU,null) DOM.da-ty-co (INT,REAL,CHAR,TEXT) DOM.da-nu-ind (NA,NN) DVAL.val-ty (ELEM,DFLT,EXAM,MIN-IN, MIN-EX,MAX-IN,MAX-EX)_(   dd  qh1I8DOMAIN-DEFAULT-VALUEA specific DOMAIN-VALUE that is designated to be used as a representative of the DOMAIN unless another specific DOMAIN-VALUE is selected. DOM_DFLT_VAL( dom_id& domain-id'( The unique value, or set of characters, assigned to represent a specific DOMAIN and to distinguish it from all other DOMAINs.  dom_id& domain-id'( The unique value, or set of characters, assigned to represent a specific DOMAIN and to distinguish it from all other DOMAINs.    dflt_val_ix& default-domain-value-index'( The unique number assigned to represent a specific DOMAIN-VALUE for a specific DOMAIN and to distinguish it from all other DOMAIN-VALUEs for that DOMAIN. NUMBER(7).192d.165.193d.193   ddPKXPK_DOMAIN_VALUE_YES IF192XIF192DOM_DFLT_VALNO IF193XIF193DOM_DFLT_VALNO IF192dom_idASCPROP IF193dom_idASCPROP IF193 dflt_val_ixASCPROP PKdom_idASCPROP   Wnh1I8VIEW-ENTITYThe association of an instance of REPLICATION-NODE (the data provider or DP) and another instance of REPLICATION-NODE (the data receiver or DR).VIEW_ENT(  NUMBER(6)& subject-view-id'( rThe unique value assigned to represent a specific SUBJECT-VIEW and to distinguish it from all other SUBJECT-VIEWs.view_id ent_id& entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8).190.191   ddPKXPKVIEW_ELEMENTYES IF190XIF190VIEW_ENTNO IF191XIF191VIEW_ENTNO IF190view_idASCPROP IF191ent_idASCPROP PKview_idASCPROP PKent_idASCPROP   #h1I8SUBJECT-VIEWrA collection of ENTITYs used to depict a portion of the data model from which the ENTITYs are drawn [WP 4-1 1995]. SUBJ_VIEW( & subject-view-id'( rThe unique value assigned to represent a specific SUBJECT-VIEW and to distinguish it from all other SUBJECT-VIEWs.view_id NUMBER(6) / view_na& subject-view-name'( $The name of a specific SUBJECT-VIEW. J def_txt& subject-view-definition-text'( @The text that provides the meaning of the specific SUBJECT-VIEW. D  stdn_lvl_co& 'subject-view-standardisation-level-code'( LThe code that represents the level of common agreement for the SUBJECT-VIEW. N VARCHAR(4) xDomain values: ATCO = ATCCIS Core; ATSF = ATCCIS Subfunctional Area; INAT = International; NAT = National; LOC = Local. (  mod_lvl_co& subject-view-model-level-code'( UThe code that represents the data model source of the SUBJECT-VIEW being represented. N VARCHAR(4) 6Domain values: APPL = Application; DICT = Dictionary. dddd   ddPKXPKSUBJECT_VIEWYES PKview_idASCPROP  E;gh1I8CATEGORY-RELATIONSHIPThe specification of information required to define disjoint subsets (known as subtypes) for a specific ENTITY, the most important of which is the attribute of that ENTITY that will serve as category discriminator (based on [WP 4-1 1995]).CAT( cat_ix& category-relationship-index'( The unique number assigned to represent a specific CATEGORY-RELATIONSHIP for a specific ENTITY and to distinguish it from all other CATEGORY-RELATIONSHIPs for that ENTITY. NUMBER(2)J def_txt& %category-relationship-definition-text'( 6The text that characterises the CATEGORY-RELATIONSHIP. discr_ix& discriminator-attribute-index'( The unique number assigned to represent a specific ATTRIBUTE for a specific ENTITY and to distinguish it from all other ATTRIBUTEs for that ENTITY.   compl_ind& 1category-relationship-completeness-indicator-code'( rThe code that represents whether all the possible subtypes of the Super ENTITY explicitly occur in the data model. N VARCHAR(2) ADomain values: CC = Category Complete; IC = Incomplete Category.  sup_ent_id& super-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  sup_ent_id& super-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs..188d.179.189~dd.189}d   ddPK XPKCATEGORYYES IF188 XIF188CATNO IF189 XIF189CATNO IF188 sup_ent_idASCPROP IF189 sup_ent_idASCPROP IF189discr_ixASCPROP PK sup_ent_idASCPROP PKcat_ixASCPROP  7h1I8PRIMARY-KEY-ATTRIBUTEAn ATTRIBUTE used to provide the unique identifier(s) of an instance of the ENTITY to which the attributes belong [WP 4-1 1995].PK_ATTR( ent_id& entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. attr_ix& attribute-index'( The unique number assigned to represent a specific ATTRIBUTE for a specific ENTITY and to distinguish it from all other ATTRIBUTEs for that ENTITY. .179.174.186.174.186   ddPKXPKPRIMARY_KEY_ATTRYES IF186 XIF186PK_ATTRNO IF186ent_idASCPROP IF186attr_ixASCPROP PKent_idASCPROP PKattr_ixASCPROP  WUh1I8SUBTYPE-RELATIONSHIPA RELATIONSHIP that identifies a subset of instances of a Parent ENTITY as an entity itself, which has a set of primary key attributes that are identical to those of the Parent ENTITY [Based on WP 4-1 1995].SUBT_REL(  sub_ent_id& sub-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8) rel_ix NUMBER(2)& relationship-index'( The unique number assigned to represent a RELATIONSHIP for a specific Parent ENTITY and a specific Child ENTITY and to distinguish it from all other RELATIONSHIPs for the Parent ENTITY and the Child ENTITY. cat_ix& category-relationship-index'( The unique number assigned to represent a specific CATEGORY-RELATIONSHIP for a specific ENTITY and to distinguish it from all other CATEGORY-RELATIONSHIPs for that ENTITY. NUMBER(2)  sup_ent_id& super-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8)  sup_ent_id& super-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8) .181.171.184 .180.171.184|.171.184d.188.187d.187   ddPKXPKSUBTYPE_RELYES IF184XIF184SUBT_RELNO IF187XIF187SUBT_RELNO IF184 sup_ent_idASCPROP IF184 sub_ent_idASCPROP IF184rel_ixASCPROP IF187 sup_ent_idASCPROP IF187cat_ixASCPROP PK sup_ent_idASCPROP PK sub_ent_idASCPROP PKrel_ixASCPROP  Mh1I8CARDINALITY-RELATIONSHIPA RELATIONSHIP that identifies zero or one instances of the "Parent" ENTITY with zero, one, or many instances of the "Child" ENTITY (abbreviated "one-to-many"). By definition, a CARDINALITY-RELATIONSHIP is a one-way RELATIONSHIP, implying nothing about how the Child ENTITY relates back to the Parent Entity. By definition, it is a RELATIONSHIP whose child entity is a dependent ENTITY that has a set of key attributes that includes the key attributes of the parent but may otherwise differ from the set of keys of the PARENT [WP 4-1 1995c].CARD_REL(   pa_ent_id& parent-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8)  ch_ent_id& child-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8) rel_ix& relationship-index'( The unique number assigned to represent a RELATIONSHIP for a specific Parent ENTITY and a specific Child ENTITY and to distinguish it from all other RELATIONSHIPs for that Parent ENTITY and Child ENTITY. NUMBER(2)0 verb_na& "cardinality-relationship-verb-name'( The name of the action phrase describing the association from the parent to the child instances of ENTITY for a CARDINALITY-RELATIONSHIP.0  inv_verb_na& *cardinality-relationship-inverse-verb-name'( The name of the action phrase describing the relationship from the child and to the parent instances of ENTITY for a CARDINALITY-RELATIONSHIP.J def_txt& (cardinality-relationship-definition-text'( AThe text that characterises what the CARDINALITY-RELATIONSHIP is.  ident_ind& 3cardinality-relationship-identifying-indicator-code'( KThe code that represents the class of CARDINALITY-RELATIONSHIP represented. N VARCHAR(2) 6Domain values: ID = Identifying; NI = Nonidentifying.  pa_card_co& 0cardinality-relationship-parent-cardinality-code'( The code that represents the range in the number of occurrences associated with the parent entity in the CARDINALITY-RELATIONSHIP represented. N VARCHAR(2) BDomain values: OP = Optional (zero or one); MA = Mandatory (one).  ch_card_co& /cardinality-relationship-child-cardinality-code'( The code that represents the range in the number of occurrences associated with the child entity in the CARDINALITY-RELATIONSHIP represented. N VARCHAR(2) Domain values: ZM = Zero, one, or more; PO = Positive (one or more); ZO = Zero or one, EX = Exactly N; RA = Range; SP = Special.5 ch_min_card_cnt& ;cardinality-relationship-child-minimum-cardinality-quantity'( The quantify representing the number of the minimum exact cardinality associated with the child entity in the CARDINALITY-RELATIONSHIP represented. NUMBER(3)6 ch_max_card_cnt& ;cardinality-relationship-child-maximum-cardinality-quantity'( The quantity representing the number of the maximum exact cardinality associated with the child entity in the CARDINALITY-RELATIONSHIP represented. NUMBER(3) .181.171.183 .180.171.183|.171.183{dzdydxdwdvdud td    ddPKXPKCARDINALITY_RELYES IF183XIF183CARD_RELNO IF183 pa_ent_idASCPROP IF183 ch_ent_idASCPROP IF183rel_ixASCPROP PK pa_ent_idASCPROP PK ch_ent_idASCPROP PKrel_ixASCPROP  h1I8ENTITYA distinguishable person, place, thing, event, or concept about which information is kept. Source: Designing Quality Databases with IDEF1X Information Models (Tom Bruce), 1992; and WP 4-1, 1995. ENT(  ent_id& entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8)1 ent_na& entity-name'( The name of a specific ENTITY.- tab_na& entity-table-name'( yThe name of the physical table or other object of a physical schema that represents data specified for a specific ENTITY.J def_txt& entity-definition-text'( AThe unformatted character string that defines what the entity is. depen_co & entity-dependency-code'( {The code that represents whether the ENTITY is independent for its meaning and instances from all other instance of ENTITY. N VARCHAR(2) oDomain values: IE = Independent Entity; DE = Depen