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 = Dependent Entity (but not a subtype entity); SE = Subtype Entity.6  depth_cnt& entity-depth-count-quantity'( The quantity that represents the specification of the level of dependency of the entity; specifically, it is the maximum number of parent entities above the entity itself or, in other words, the longest path to a completely independent entity taking into account the foreign keys. NUMBER(3)  stg_ty_co & entity-storage-type-code'( SThe code that represents whether the ENTITY as standard (non-loggable) or loggable. N VARCHAR(4) /Domain values: STD = Standard; LOG = Loggable.D  stdn_lvl_co& !entity-standardisation-level-code'( FThe code that represents the level of common agreement for the ENTITY. N VARCHAR(4) xDomain values: ATCO = ATCCIS Core; ATSF = ATCCIS Subfunctional Area; INAT = International; NAT = National; LOC = Local.(  mod_lvl_co& entity-model-level-code'( dThe specific value that represents or denotes the data model source of the ENTITY being represented. N VARCHAR(4) 6Domain values: APPL = Application; DICT = Dictionary.sdrdqdpdodndmdld   ddPK XPKENTITYYES PKent_idASCPROP  %h1I8attribute-foreign-key-indicator-codeforeign_key_indic(   dd  %rh1I8attribute-primary-key-indicator-codeprimary_key_indic(   dd   h1I8ATTRIBUTEoA specification of a description (or characteristic) of an ENTITY representing a single concept [WP 4-1, 1992].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.1 attr_na& attribute-name'( !The name of a specific attribute. VARCHAR(160) . col_na& attribute-column-name'( ZThe name assigned to represent the ATTRIBUTE as a specific physical column within a table.B attr_snr& attribute-sequence-number'( jThe unique number assigned to represent the specific physical position of the attribute inside the entity. NUMBER(3) pk_ind& $attribute-primary-key-indicator-code'( wThe code that denotes whether an ATTRIBUTE plays the role of part of the primary key in the ENTITY to which it belongs. N VARCHAR(2) BDomain values: PK = Primary Key Attribute; NK = Nonkey Attribute. fk_ind& $attribute-foreign-key-indicator-code'( ~The code that denotes whether the ATTRIBUTE plays the role of a foreign key in the ENTITY and thereby owned by another ENTITY. N VARCHAR(2) @Domain values: FK = Foreign Key Attribute; BA = Base Attribute.D  stdn_lvl_co& $attribute-standardisation-level-code'( IThe code that represents the level of common agreement for the ATTRIBUTE. N VARCHAR(4) xDomain values: ATCO = ATCCIS Core; ATSF = ATCCIS Subfunctional Area; INAT = International; NAT = National; LOC = Local..179kdjdidhdgdfd   ddPK XPKATTRIBUTEYES IF179 XIF179ATTRNO IF179ent_idASCPROP PKent_idASCPROP PKattr_ixASCPROP  i h1I8relationship-type-coderelation_type_code(   dd   Vh1I8RELATIONSHIPThe association of one instance of ENTITY (the "Parent ENTITY) with another (the "Child" ENTITY) that describes the degree and nature of the association [WP 4-1 1995c].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 the Parent ENTITY and the Child ENTITY. NUMBER(2)7 ty_co& relationship-type-code'( CThe code that represents the class of RELATIONSHIP being specified. N VARCHAR(2) IDomain values: CR = Cardinality Relationship; SR = Subtype Relationship..181.180|ed   ddPK XPKRELATIONYES IF180 XIF180RELNO IF181 XIF181RELNO IF180 ch_ent_idASCPROP IF181 pa_ent_idASCPROP PK pa_ent_idASCPROP PK ch_ent_idASCPROP PKrel_ixASCPROP  6h1I8NON-KEY-ATTRIBUTEAn ATTRIBUTE used to provide a descriptive data element of instances of the ENTITY to which the ATTRIBUTE belongs and that is not a member of the primary key of that ENTITY. [Based on WP 4-1 1995].NK_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.2 opt_ind& ,non-key-attribute-optionality-indicator-code'( N [The code that represents whether non-null domain value is required for a NON-KEY-ATTRIBUTE. VARCHAR(2) .Domain values: OP = Optional; MA = Mandatory. .179.174.173.174.173dd   ddPKXPKNON_KEY_ATTRYES IF173 XIF173NK_ATTRNO IF173ent_idASCPROP IF173attr_ixASCPROP PKent_idASCPROP PKattr_ixASCPROP  -h1I8FOREIGN-KEY-ATTRIBUTEzAn ATTRIBUTE that has been migrated under a RELATIONSHIP from the primary key of the "Parent" ENTITY of that RELATIONSHIP.FK_ATTR( 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.J  role_def_txt& *foreign-key-attribute-role-definition-text'( `The text that characterises the way in which a FOREIGN-KEY-ATTRIBUTE relates to the base ENTITY.  rona_ind& -foreign-key-attribute-rolename-indicator-code'( N VARCHAR(2) sThe code that represents whether a surrogate name is used for a migrating FOREIGN-KEY-ATTRIBUTE in the base ENTITY. oDomain values: RN = Role name is used; MN = Role name is not used (migrated name is used as the default name).  src_attr_ix& source-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.  migrating-relationship-index migr_rel_ix NUMBER(2)(' 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.  base_ent_id& base-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  base_attr_ix& base-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.  unif_attr_ix& unifying-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.  host_ent_id& host-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  src_ent_id& source-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  host_ent_id& host-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  host_ent_id& host-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs.  src_ent_id& source-entity-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. .179.177.175.177.175d.179.177.175.169 d.180.172 cdbdd.181.172 d.179.174.186.185 d .174.186.185|d.172d.179.177.176.170d .177.176.170d .177.175.169    ddPKXPKFOREIGN_KEY_ATTRYES IF169 XIF169FK_ATTRNO IF170 XIF170FK_ATTRNO IF172 XIF172FK_ATTRNO IF175 XIF175FK_ATTRNO IF185 XIF185FK_ATTRNO IF169 host_ent_idASCPROP IF169 unif_attr_ixASCPROP IF170 base_ent_idASCPROP IF170 base_attr_ixASCPROP IF172 host_ent_idASCPROP IF172 src_ent_idASCPROP IF172 migr_rel_ixASCPROP IF175 host_ent_idASCPROP IF175attr_ixASCPROP IF185 src_ent_idASCPROP IF185 src_attr_ixASCPROP PK host_ent_idASCPROP PKattr_ixASCPROP  lh1I8BASE-ATTRIBUTEThat subset of ATTRIBUTE owned by the ENTITY to which the members belong; that is, they are not foreign key attributes migrating from another ENTITY under some relationship. BASE_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.L  base_def_txt& base-attribute-definition-text'( 6The text that characterises a specific BASE-ATTRIBUTE. VARCHAR(255)I daty_dsc& (base-attribute-datatype-description-text'( >The text that characterises the datatype for a BASE-ATTRIBUTE. 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) 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.  .179.177.176.177.176ad`dd.165.168d.167d.168   ddPK XPKBASE_ATTRYES IF167XIF167BASE_ATTRNO IF168XIF168BASE_ATTRNO IF176XIF176BASE_ATTRNO IF167dom_idASCPROP IF168dom_idASCPROP IF168 dflt_val_ixASCPROP IF176ent_idASCPROP IF176attr_ixASCPROP PKent_idASCPROP PKattr_ixASCPROP  h1I8ALTERNATE-KEYtA collection of attributes of a specific ENTITY that can serve as a primary key, that is they are all non-null, are non-repeating (no duplicate values), and together provide unique identification of instances of the ENTITY; specifically, the specification of a key of an ENTITY which may be used instead of the PRIMARY-KEY-ATTRIBUTE to identify the ENTITY [WP 4-1 1995]. ALT_KEY(  entity-ident_id NUMBER(8)(' }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. ak_ix& alternate-key-index'( The unique number assigned to represent a specific ALTERNATE-KEY for a specific ENTITY and to distinguish it from all other ALTERNATE-KEYs for that ENTITY. NUMBER(2)3 ak_nr NUMBER(3)& alternate-key-number'( RThe number assigned to represent the alternate key or inversion key in the ENTITY. uniq_ind& 'alternate-key-uniqueness-indicator-code'( KThe code that denotes whether the alternate key or inversion key is unique. N VARCHAR(2) eDomain values: AU = Always Unique (e.g., Alternate Key); MU = Mostly Unique (e.g., Inversion Entry)..182_^d]d   ddPKXPKALTERNATE_KEYYES IF182 XIF182ALT_KEYNO IF182ent_idASCPROP PKent_idASCPROP PKak_ixASCPROP  0ah1I8ALTERNATE-KEY-ATTRIBUTEThe association of a specific ALTERNATE-KEY with a specific ATTRIBUTE that is used to list of attributes of a specific ENTITY that together form an ALTERNATE-KEY. Based on [WP 4-1 1995].AK_ATTR( attribute-indexattr_ix(' The unique number assigned to represent a specific ATTRIBUTE for a specific ENTITY and to distinguish it from all other ATTRIBUTEs for that ENTITY. ak_ix& alternate-key-index'( The unique number assigned to represent a specific ALTERNATE-KEY for a specific ENTITY and to distinguish it from all other ALTERNATE-KEYs for that ENTITY. NUMBER(2)  entity-ident_id(' }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8)  entity-ident_id(' }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8).179.178.182.166.178_.166   ddPKXPKALTERNATE_KEY_ATTRYES IF166 XIF166AK_ATTRNO IF178 XIF178AK_ATTRNO IF166ent_idASCPROP IF166ak_ixASCPROP IF178ent_idASCPROP IF178attr_ixASCPROP PKent_idASCPROP PKattr_ixASCPROP PKak_ixASCPROP   h1I8DOMAIN-VALUE2A valid data instance cited for a specific DOMAIN.DOM_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.   val_ix& 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)K val_dsc& domain-value-description-text'( 'The text that describes a DOMAIN-VALUE.1 val_na& domain-value-name'( $The name of a specific DOMAIN-VALUE.J def_txt& domain-value-definition-text'( +The text that characterises a DOMAIN-VALUE.C val_snr& domain-value-sequence-number'( =The number that represents a unique order for a DOMAIN-VALUE. NUMBER(4) pThis attribute may be used to specify the order in which domain values are presented to users in an application. ty_co & domain-value-type-code'( N 5The code that represents the class of a DOMAIN-VALUE. VARCHAR(6) Domain values: ELEM =-Element; DFLT = Default; EXAM = Example; MIN-IN = Minimum Inclusive; MIN-EX = Minimum Exclusive; MAX-IN = Maximum Inclusive; MAX-EX = Maximum Exclusive.D  stdn_lvl_co& 'domain-value-standardisation-level-code'( N KThe code that represents the level of common agreement of the DOMAIN-VALUE. VARCHAR(4) xDomain values: ATCO = ATCCIS Core; ATSF = ATCCIS Subfunctional Area; INAT = International; NAT = National; LOC = Local..165\d[dZdYdXdWd   ddPKXPKDOMAIN_VALUEYES IF165 XIF165DOM_VALNO IF165dom_idASCPROP PKdom_idASCPROP PKval_ixASCPROP  h1I8DOMAINThe specification for valid instances of ATTRIBUTE; specifically, the set of permissible data values from which actual values are taken for a particular ATTRIBUTE or specific data element [WP 4-1, 1992].DOM( 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. 1 dom_na& domain-name'( The name of a specific DOMAIN.J def_txt& domain-definition-text'( .The text that characterises a specific DOMAIN.+ class_na& domain-class-name'( BThe name that identifies the category to which the DOMAIN belongs. VARCHAR(16)  restr_ty_co & domain-restriction-type-code'( N SThe code that represents the type of constraint imposed upon values for the DOMAIN. VARCHAR(2) ;Domain values: EN = Enumerated; RA = Range; FU = Function.  data_ty_co & domain-data-type-code'( N FThe code that represents the technical form (datatype) for the DOMAIN. VARCHAR(4) QDomain values: INT = Integer; REAL = Real Number; CHAR = Character; TEXT = Text.4  data_len_cnt& !domain-data-length-count-quantity'( bThe quantity that represents the maximum number of characters permitted for a value of the DOMAIN. NUMBER(4)5  data_dec_cnt& #domain-data-decimals-count-quantity'( The quantity that represents the number of positions to the right of the decimal point for DOMAINs that are expressed as real numbers.  NUMBER(2)   data_null_ind& domain-data-null-indicator-code'( N VThe code that indicates whether a value of the DOMAIN is permitted to be empty (null). VARCHAR(2) 2Domain values: NA = Nulls Allowed; NN = No Nulls.K  data_patt_dsc& $domain-data-pattern-description-text'( =The text that describes the format for a value of the DOMAIN. This attribute could be used to specify a particular template in which domain values are to be captured (e.g., in the user presentation view of an application).K meas_unit_dsc& (domain-measurement-unit-description-text'( XThe text that describes the unit of measure for DOMAINs that permit quantitative values. pa-dom_id& parent-domain-id'( FThe domain-id of a specific parent DOMAIN (a role name for domain-id).D  stdn_lvl_co& !domain-standardisation-level-code'( N FThe code that represents the level of common agreement for the DOMAIN. VARCHAR(4) xDomain values: ATCO = ATCCIS Core; ATSF = ATCCIS Subfunctional Area; INAT = International; NAT = National; LOC = Local.(  mod_lvl_co& domain-model-level-code'( N =The code that represents the data model source of the DOMAIN. VARCHAR(4) 6Domain values: APPL = Application; DICT = Dictionary.VdUdTdSdRdQdPdOdNd Md d.164 Ld Kd    ddPK XPKDOMAINYES IF164 XIF164DOMNO IF164 pa_dom_idASCPROP PKdom_idASCPROP  p5mh1I8REPLICATION-NODE-LINKqAn association between a source REPLICATION-NODE and a destination REPLICATION-NODE that represents a connection. NODE_LINK(& 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.& ?replication-node-link-last-replication-data-id-description-text'(last_r_data_id_descr hThe text that characterises the most recent transaction, by recording the R_DATA_Id of that transaction.|8 & 7replication-node-link-destination-node-link-status-code'(dst_node_link_status_code N VARCHAR(2) 9Domain values: AC--Active, IN--Inactive, MA--Management. FThe code that represents the current state of a REPLICATION-NODE-LINK.}.125.126dd   ddPK XPKREPL_ASSOCYES IF125XIF125REPL_ASSOCNO IF126XIF126REPL_ASSOCNO IF125 src_node_idASCPROP IF126 dst_node_idASCPROP PK src_node_idASCPROP PK dst_node_idASCPROP  k6"jh1I8REPLICATION-NODE-ADDRESSTAn association between a specific REPLICATION-NODE and a specific TRANSFER-FACILITY. NODE_ADDR(& replication-node-id'( repl_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.i 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.jJ& )replication-node-address-description-text'( addr_descr xThe text in the REPLICATION-NODE-ADDRESS that defines the Transfer Facility's address for reaching the REPLICATION-NODE.l& replication-node-address-index'(node_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.G.101.102d   ddPKXPKREPL_NODE_ADDRYES IF101XIF101REPL_NODE_ADDRNO IF102XIF102REPL_NODE_ADDRNO IF101 repl_node_idASCPROP IF102 xfer_fac_idASCPROP PK repl_node_idASCPROP PK xfer_fac_idASCPROP PKnode_addr_indexASCPROP  j9h1I8TRANSFER-FACILITYcThe identification of a protocol used in a communication network used to connect two or more nodes.XFER_FAC(& transfer-facility-id'( xfer_fac_id NUMBER(10) The unique value, or set of characters, assigned to represent a specific TRANSFER-FACILITY and to distinguish it from all other TRANSFER-FACILITYs.f)& transfer-facility-name'( xfer_fac_name VARCHAR(50) )The name of a specific TRANSFER-FACILITY.gF& *transfer-facility-profile-description-text'( profile_descr VARCHAR(255) The text that specifies the main properties of the profile ("stack") of standards used for a specific instance of TRANSFER-FACILITY.hdd   ddPKXPKREPL_NETWORKYES PK xfer_fac_idASCPROP  d Ch1I8REPLICATION-NODE4A node that participates in a data exchange network. REPL_NODE( & replication-node-id'( repl_node_id NUMBER(9) zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.X/& replication-node-name'( node_name (The name of a specific REPLICATION-NODE.Y9 & replication-node-status-code'( status_code N VARCHAR(2) ?The code that denotes the state of a specific REPLICATION-NODE. Domain values: IN = Inactive--The REPLICATION-NODE is not ready to accept replicated data. AC = Active-The REPLICATION-NODE is ready to accept replicated data. MA = Management-The REPLICATION-NODE is ready to accept ARM data and process management events but no operational data. Z*& replication-node-function-name'( func_name xThe name of the functional area supported by the REPLICATION-NODE (e.g., C2, intelligence, logistics, mapping, weather).G& .replication-node-ades-version-description-text'(ades_version_descr wThe text that describes the version of the ATCCIS Data Exchange Schema (ADES) currently in use at the REPLICATION-NODE. G& 2replication-node-protocol-version-description-text'(repl_prot_version_descr mThe text that describes the version of the ARM replication protocol currently in use at the REPLICATION-NODE. J& replication-node-remark-text'( remark_text IThe text that provides additional information about the REPLICATION-NODE.`*& replication-node-role-name'( role_name jThe name of the level at which a REPLICATION-NODE is intended to operate (main, alternate, step-up, rear).o& 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.& %enclosing-replication-organisation-id'(encl_repl_org_id The unique value assigned to represent a specific REPLICATION-ORGANISATION and to distinguish it from all other REPLICATION-ORGANISATIONs.(IE1)d(IE1)dddd .242.243.244d.252 ddd    ddPK XPKREPL_NODEYES IE1 XIE1REPL_NODENO IF244XIF244REPL_NODENO IF252XIF252REPL_NODENO IE1 node_nameASCPROP IE1 repl_node_idASCPROP IF244 node_mgr_idASCPROP IF252encl_repl_org_idASCPROP PK repl_node_idASCPROP  ZJBh1I8NON-REPLICATION-DATA-OWNERWThe DATA-OWNER of non-replicated (static) data such as encyclopaedic data or meta data.NON_REPL_DATA_OWNER(/& )non-replication-data-owner-data-type-name'(non_repl_data_type_name DThe name that indicates the scope of the NON-REPLICATION-DATA-OWNER.W non-replication-data-owner-id NUMBER(11)(' The unique value, or set of characters, assigned to represent a specific DATA-OWNER and to distinguish it from all other DATA-OWNERs.non_repl_data_owner_id.264.266d   ddPKYES IF266NO IF266ASCPROP PKASCPROP   Yah1I8DATA-OWNERA person, role, or organisation that owns a data set of a certain type and that is responsible for creation, modification, and distribution of that data set. DATA_OWNER( & data-owner-id'( NUMBER(11) The unique value, or set of characters, assigned to represent a specific DATA-OWNER and to distinguish it from all other DATA-OWNERs.T  & %data-owner-operational-data-type-code'(data_owner_type_code N VARCHAR(2) WThe code that specifies whether a DATA-OWNER has operational responsibilities for data. MDomain values: RD = Replication Data Owner; ND = Non-Replication Data Owner.U/& data-owner-name'(data_owner_name "The name of a specific DATA-OWNER.J& data-owner-remark-text'( remark_text CThe text that provides additional information about the DATA-OWNER.& %enclosing-replication-organisation-id'(encl_repl_org_id The unique value assigned to represent a specific REPLICATION-ORGANISATION and to distinguish it from all other REPLICATION-ORGANISATIONs.@& &data-owner-last-update-sequence-number'(last_update_seqnr GThe most recent update_sequence_number associated with this DATA-OWNER.dndd.236dd   ddPK XPKDATA_OWNERYES IF236XIF236DATA_OWNERNO IF236encl_repl_org_idASCPROP PK data_owner_idASCPROP  Myh1I8REPLICATION-DOMAIN-COMPOSITE_The union of selected REPLICATION-DOMAIN-TYPEs (often combined to support a specific contract).RDC(& replication-domain-composite-id'(rdc_id NUMBER(12) 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.%)& !replication-domain-composite-name'(rdc_name VARCHAR(50) -The name of the REPLICATION-DOMAIN-COMPOSITE.&F& ,replication-domain-composite-definition-text'(def_text VARCHAR(255) ;The formal description of the REPLICATION-DOMAIN-COMPOSITE. d$d   ddPKXPKREPL_DOMAIN_COMPOSITEYES PKrdc_idASCPROP  %L;h1I8REPLICATION-DOMAIN-COMPOSITE-ELEMENTAn association between a specific REPLICATION-DOMAIN-COMPOSITE and a specific REPLICATION-DOMAIN-TYPE that serves to list all the instances of REPLICATION-DOMAIN-TYPE contained in specific REPLICATION-DOMAIN-COMPOSITE.RDC_ELEM( 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.! rdt_id& replication-domain-type-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8).58.198.59   ddPKXPKRDC_ELEMENTYES IF58XIF58RDC_ELEMENTNO IF59XIF59RDC_ELEMENTNO IF58rdc_idASCPROP IF59rdt_idASCPROP PKrdc_idASCPROP PKrdt_idASCPROP  ?ah1I8REPLICATION-DOMAIN-TYPEA minimum set of entities of a data model that is originated from a specific "leaf" ENTITY and that is referentially complete including all non-identifying relationships.RDT(1& replication-domain-type-name'(rdt_name /The name of a specific REPLICATION-DOMAIN-TYPE.  rdt_id& replication-domain-type-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8).198d   ddPKXPKREPL_DOMAIN_TYPEYES IF198 XIF198RDTNO IF198rdt_idASCPROP PKrdt_idASCPROP   A+h1I8REPLICATION-DOMAIN-TYPE-ELEMENTAn association between a specific REPLICATION-DOMAIN-TYPE and a specific ENTITY that serves to list all the instances of ENTITY contained in specific REPLICATION-DOMAIN-TYPE.RDT_ELEM( 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) rdt_id& replication-domain-type-id'( }The unique value, or set of characters, assigned to represent a specific ENTITY and to distinguish it from all other ENTITYs. NUMBER(8).198.26.199   ddPKXPKRDT_ELEMENTYES IF199XIF199RDT_ELEMNO IF26XIF26RDT_ELEMENTNO IF199 entity_idASCPROP IF26rdt_idASCPROP PKrdt_idASCPROP PK entity_idASCPROP  l^ h1I8REPLICATION-CONTRACTAn association between an instance of REPLICATION-SUBSCRIPTION and an instance of REPLICATION-DOMAIN-COMPOSITE that specifies the REPLICATION-DOMAIN-COMPOSITEs belonging to a specific REPLICATION-SUBSCRIPTION. REPL_CONTR(< & replication-contract-status-code'( status_code N VARCHAR(2) DThe code that represents whether the REPLICATION-CONTRACT is active. +Domain values: AC = Active; IN = Inactive.tJ& !replication-contract-content-text'( content_text DThe text that characterizes the content of the REPLICATION-CONTRACT.J& $replication-contract-constraint-text'( cnstrnt_text SThe text that characterizes any constraints pertaining to the REPLICATION-CONTRACT.J& replication-contract-remark-text'( remark_text GThe text that amplifies the characterisation of a REPLICATION-CONTRACT.& 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./& replication-contract-name'( contr_name ,The name of a specific REPLICATION-CONTRACT.& replication-domain-composite-id'(rdc_id NUMBER(12) 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.& replication-domain-composite-id'(rdc_id NUMBER(12) 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.A.114.269.272 .270.272 d.134.214d d"d#dd.214d    ddPKXPKRDS_ELEMENTYES IF114XIF114RDS_ELEMENTNO IF214XIF214RDS_ELEMNO IF272NO  IF114rdc_idASCPROP IF214rdc_idASCPROP IF214 rdc_filter_indexASCPROP IF272ASCPROP IF272ASCPROP PKrdc_idASCPROP PKrepl_contr_indexASCPROP PKASCPROP PKASCPROP  $v]h1I8REPLICATION-DOMAIN-COMPOSITE-FILTERA representation of means to select entities from a data model, attributes from these entities, and instances (records) in these entities for a specific REPLICATION-DOMAIN-COMPOSITE. RDC_FILTER( 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.& )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.)& (replication-domain-composite-filter-name'( filter_name VARCHAR(50) ;The name of a specific REPLICATION-DOMAIN-COMPOSITE-FILTER.F& 3replication-domain-composite-filter-definition-text'(def_text VARCHAR(255) ZThe text that provides a technical description of the REPLICATION-DOMAIN-COMPOSITE-FILTER..134'd%d   ddPK XPKRDC_FILTERYES IF134XIF134RDC_FILTERNO IF134rdc_idASCPROP PKrdc_idASCPROP PKrdc_filter_indexASCPROP  +w`Vh1I8REPLICATION-DOMAIN-COMPOSITE-FILTER-ENTITYAn association between REPLICATION-DOMAIN-COMPOSITE-FILTER and ENTITY that identifies all the ENTITYs included in a specific REPLICATION-DOMAIN-COMPOSITE-FILTER. FILTER_ENTITY(& )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.Jhoriz_filter_descr& Mreplication-domain-composite-filter-entity-horizontal-filter-description-text'( The text that provides a technical description of the selection of instances of the ENTITY identified for a specific REPLICATION-DOMAIN-COMPOSITE-FILTER to be included as a result of the filter being defined. 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) 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.2.134.136.136.201(d   ddPKXPKFILTER_ENTITYYES IF136XIF136FILTER_ENTITYNO IF201XIF201FILTER_ENTITYNO IF136rdc_idASCPROP IF136rdc_filter_indexASCPROP IF201 entity_idASCPROP PKrdc_idASCPROP PKrdc_filter_indexASCPROP PK entity_idASCPROP  .xpYh1I8REPLICATION-DOMAIN-COMPOSITE-FILTER-ATTRIBUTE@An association between REPLICATION-DOMAIN-COMPOSITE-FILTER-ENTITY and ATTRIBUTE that identifies the ATTRIBUTEs of a specific ENTITY to be excluded from a specific REPLICATION-DOMAIN-COMPOSITE-FILTER, which means that all the remaining attributes of that ENTITY are intended to be included within the scope of the filter. FILTER_ATTR(& )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.  & Ireplication-domain-composite-filter-attribute-vertical-filter-effect-code'(vert_filter_effect_code N VARCHAR(2) yThe code that represents the class of vertical behaviour that applies to a REPLICATION-DOMAIN-COMPOSITE-FILTER-ATTRIBUTE. 5Domain values: NU = Null; DF = Default; RM = Remove. 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. 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.4 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. 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. .134.136.138.136.138.179.202.201.138.202)d   ddPKXPKFILTER_ATTRYES IF138XIF138FILTER_ATTRNO IF202XIF202FILTER_ATTRNO  IF138rdc_idASCPROP IF138rdc_filter_indexASCPROP IF138 entity_idASCPROP IF202 entity_idASCPROP IF202attribute_indexASCPROP PKrdc_idASCPROP PKrdc_filter_indexASCPROP PK entity_idASCPROP PKattribute_indexASCPROP  .{<Nh1I8REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETERThe possible values for a specific REPLICATION-DOMAIN-COMPOSITE-FILTER that could be used by various functions to determine if an instance of a specific ENTITY within the scope of the REPLICATION-DOMAIN-COMPOSITE-FILTER is to be included for replication. FILTER_PARAM(4& 4replication-domain-composite-filter-parameter-number'(param_nr NUMBER(3) tThe number used to specify the order of occurrence for an instance of REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER.! 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.%& )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.',& 2replication-domain-composite-filter-parameter-name'( param_name QThe name of a specific instance of REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER.(J& =replication-domain-composite-filter-parameter-definition-text'(param_def_text fThe text that provides the technical description of the REPLICATION-DOMAIN-COMPOSITE-FILTER-PARAMETER.).134.144.144.*d+d,d   ddPKXPKFILTER_PARAMYES IF144XIF144FILTER_PARAMNO IF144rdc_idASCPROP IF144rdc_filter_indexASCPROP PKrdc_idASCPROP PKrdc_filter_indexASCPROP PKfilter_param_indexASCPROP  F-h1I8REPLICATION-ORGANISATIONSAn organisation that is involved in replication of data in a data exchange network.REPL_ORG(& replication-organisation-id'( repl_org_id The unique value assigned to represent a specific REPLICATION-ORGANISATION and to distinguish it from all other REPLICATION-ORGANISATIONs.Z/& replication-organisation-name'( repl_org_name 0The name of a specific REPLICATION-ORGANISATION.^: & "replication-organisation-type-code'( org_type_code N VARCHAR(2) ^The code that denotes whether a REPLICATION-ORGANISATION serves as a REPLICATION-NODE-MANAGER. "Domain values: NM = Node Manager.3 NUMBER(15)& >replication-organisation-similar-organisation-description-text'(similar_org_id_descr The text that contains the identifier of a specific ORGANISATION in the ADES or other specification that characterizes the organisation represented by a REPLICATION-ORGANISATION.](IE1)d(IE1)dd   ddPK XPKREPL_ORGYES IE1 XIE1REPL_ORGNO IE1 repl_org_nameASCPROP IE1 repl_org_idASCPROP PK repl_org_idASCPROP  Ih1I8MANAGEMENT-UPDATEA representation of modifications to the replication management information specified in ARM Management data that must be carried out by the receiver of the event in order to make the ARM work. MGT_UPDATE(& management-update-index'(mgt_update_index NUMBER(3) The unique number assigned to represent a MANAGEMENT-UPDATE for a specific MANAGEMENT-EVENT and to distinguish it from all other MANAGEMENT-UPDATEs for that MANAGEMENT-EVENT.& 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-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.  mgt_ent_id& management-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)J& )management-update-record-description-text'( record_descr VThe contents of the complete record that is the focus of a specific MANAGEMENT-UPDATE.' & 'management-update-operational-type-code'( op_type_code NCHAR(1) 8The code that represents the class of MANAGEMENT-UPDATE. BDomain values: I = Hard Insert; D = Hard Delete; U = Hard Update..249.256.256d.257dd   ddPK XPKMGT_UPDATEYES IF256XIF256MGT_UPDATENO IF257XIF257MGT_UPDATENO IF256 src_node_idASCPROP IF256mgt_event_indexASCPROP IF257 mgt_entity_idASCPROP PK src_node_idASCPROP PKmgt_event_indexASCPROP PKmgt_update_indexASCPROP  h1I8REPLICATION-DATA-OWNER4A DATA OWNER that manages replicated (dynamic) data.REPL_DATA_OWNER( replication-data-owner-id NUMBER(11)(' The unique value, or set of characters, assigned to represent a specific DATA-OWNER and to distinguish it from all other DATA-OWNERs.repl_data_owner_id residence-replication-node-id resid_node_id NUMBER(9)(' zThe unique value assigned to represent a specific REPLICATION-NODE and to distinguish it from all other REPLICATION-NODEs.=.264.265d.271   ddPKYES IF265NO IF271NO IF265ASCPROP IF271ASCPROP PKASCPROP  &j$h1I8data-owner-operational-data-type-code(   dd  h1I8*ARM Management View _(   dd  h1I8*Data Model View_(   dd  h1I8*Contract Management View_(   dd  h1I8*{Name changes in REPL370: CATEGORY-RELATIONSHIP.category-relationship-completeness-indicator-code DOMAIN-DEFAULT-VALUE.default-domain-value-index REPLICATION-NODE-ADDRESS-LINK.destination-replication-node-id REPLICATION-NODE-ADDRESS-LINK.source-replication-node-id REPLICATION-SUBSCRIPTION.provider-replication-node-id REPLICATION-SUBSCRIPTION.receiver-replication-node-id (   dd  h1I8*6Definition of replication-organisation-id was updated.(   dd  h1I8*`Changes tn MGT_EVENT from CP-US-V5-1 deleted session_nr changed r_data_id_descr to NUMERIC(9)(   dd  LdI?Asp''''psps is-composed-of Purpose Text"PurposeTemplate Handle"CHILD INSERT RESTRICT'CHILD UPDATE RESTRICT'PARENT DELETE RESTRICT'PARENT UPDATE RESTRICT':dML'''' is-composed-of Purpose Text"PurposeTemplate Handle"CHILD INSERT RESTRICT'CHILD UPDATE RESTRICT'PARENT DELETE RESTRICT'PARENT UPDATE RESTRICT' ;d?LOa;''''ONN is-used-in Purpose Text"PurposeTemplate Handle"CHILD INSERT RESTRICT'CHILD UPDATE RESTRICT'PARENT DELETE RESTRICT'PARENT UPDATE RESTRICT'eddkwj''''{w{ has fd"jkS6S'''' S S enclosesrdMly''''KK defines-replication-data-in }ddpum''''uu sis-source-in~ddpm'''' Xis-destination-indMvyN]''''oNo can-be-filtered-by d7vw+''''++ involves dTwxVY'''' excludesdv{'''' has dF9''''F is-basis-for dZ''''ZZ0contains d0'''' consists-ofeo6 ''''   describes-allowed-values-ford8E''''EE_is-default-value-fordrF''''F unifiese'''' is-originator-for di'''++ 5eV-'''' migrates-from-parent(source)- to-child(host)-entity d''' d''' d5\'''\\  d+l'''ZZ d '''  d f'''' f appears-ind''' is-characterised-by dV&)V''')) is-child-of dr2uV'''uu is-parent-ofd''''55 is-also-identified-by dI'''I de'''eeV)H7O''''HOHO is-source-for d6'''6e{^'''^ holdsdy,E;'''E,E, is-subtyped-viae-;''''--Fis-discriminator-for d<)W'''')<)<QcontainsdO"''''O" is-contained-ind''''%% haseA:q'''':A:A/is-default-ford?''''^^ acts-as-leaf-in d4A:'''':: 7appears-in dwO''''Ois-used-as dx*Y''''* is-used-asddvl$,'''',$,$ .filtersd7l w''''ww hasd''''3gets d{NA+''''<A< !is-used-indp500''''00 usesdk"11''''t1t1 is-destination-address-fordk"FF''''tFtF is-source-address-for dYF'''' encloses dj9 '''' Ris-used-in d-W''''BB dl''''dOdeC'''' fmanages dd'''' is-source-ofd`6''''`ll is-referred-to-by ddF''''22 encloses d66SI''''!S! involvese>D''''D )is-updated-by dWd'''' Fis-source-ofd!6#''''## causesdG''''uu is-involved-ind1''''1 Uis-involved-in dY a j'''' e e  d''''   dZJ'''' dmd0C''''00 !provides dzdC'''' 2receivesd dC''''ppis the residence of dl36^''''3GG consists ofdSdtC''''tt 8is-destination-ford6''''has-destinationDQ
Lw(xQv11v11A2_Replication Management SubvewlLw(xQ|8|8A3_Contract Mgmt SubviewlLw(xQ'8'8E13_Data Model ViewQlLw(xQ88E1_Complete ARM Mgmt DM ViewlLw(xQS;S;E2_Replication_ViewQlLw(xQ݃<݃<E3_Repl_NodexQlLw(xQ(;(; E4_Repl_ORG_Data_OwnerlLw(xQ6*;6*; E5_ARMMgt_SubViewQlLw(xQ88E6_Entity_AttrxQlLw(xQ+;+; E7_RDT_RDCxQlLw(xQx,;x,; E8_Repl_ContractQlLw(xQ-;-; E9_FilterxQlLw(xQ /; /;k*Y6"jqojPU9:9dA [  C  Tj CZ `XQJBKCY..e"a<05_M;0}yTUGLR;" ?aF 1oAXe+rr"\ llI^  Y lr4#;#l 4::::T .0. / / NyKK ''M'M':T J000Y Gl f\P\g\gg "+++Y$###G\F\\\\\ ""S S S6S  "+++Y$t9t(t((=e 11 $$_$_H_@@@@s {w{wj **zz 11 66o ;// //AA OO OaONN; Fmm okkk- T1T :}}]]ZZ'}5y5yR '5y5y[[" U~U~- ** II9I9IXHH9H9H`!!  Ispspsp   W"_F_]]r kkkk" [PJgJgJg p W[5moN4~^^  tPP +  tm XDUDUDD PP  X}O^^  )PP +  )uuum s1U1U11 PP  sxf.pYot)wDg<N`VOzTv;F\ ]gK}_*f qqq9 NF~F~. TVY CFF ETEAA) D   <<N 7+++ <<C  _ zzzz0iipp  }VV yoNoN] 44g $P$P$$ G?[?[* {u FA<N ]J; ==B=B= ppFp t8@_@ KK DR/qZ$NqanWn,yL0mQnk#< a^ uE;g7e75$~6qWUcdKM  XP kbbb+[bbbbbbb<Yrr['<3bK d}7}7}75e}7i }7}7}7}7}7}7i q&dV7z6&-+Z OL.l:"Ix1I_t#a0a{f:vk0%gzz sss/ ?gzzA:A:A:q/A:A:A:q/vehehR WfWf. Faaa WfWf. %% %% ff33TXTITII9P~~~~ OO"" 'SSy Lw"w"ww #qR3R3R3x#m$ 8|| <)<)<)WQK||ono <,Q|||| 0OOOi0[^^^  =OOOi0---;F---8F KPP <>>>  KPP y,E,E,E; y+J+J+J8 Q~Q^q q q  Q^{^^ {^^ ffggYccgg6666"&(  >> ee (  >> V)H7HOHOO V)H7HOHOO ''''MM''eeee FFFFIIII    g sI g 55 66 7q 7v]  mmd 7v] r2uuuV r2uuuV E000q E_v__] 2[2[d E_v__] V&)))V V&)))V  &e&e&& qq [ 3< pp <```K` ]]]K] @@ gggg a   ff !!dd ~~~~msmzzC<CC msmzz    322Z322hGG4|4|L322h+ZZl+ZZl:rrPrPP :rr\r\\ ==vyvy:rr\r\\ 5\\\ 5\\\ :: SsS[)))<SsS    Ybbz  !0&0W0WW@!..`.`<`@asSSS !..`.`<`@V- V- &QQ} KK} MMMM KK} ++i ++i + L  mm O 7M  mm   44  zz33  rFF rFF p@@@+CR   LCxO R   MC8EEE_8FFF_Gk A'D  A'D o6    o6       I[61a [0 * v1n1n1f1 7l7l7;7 0 3l3l3;3 ZZZ0ZZZ0RkR \\MDM x==^%^ \\MDM FF99 EE99 ... ;; ;   7zz. **Y 7}L}L) ))) WW//hhOO''C_...z% OO DMM PC4C4AA 4::: 7'44WW r J"9!!! 7 // D-- P   ^^ '__ J]b]b]] Cc?A+V;X6LgW uPMMMP" 7555 37A  g <<< <  **** I22?2M7 www 33x i7xx 7 ppp ;l .T .?   d$,$,$, .?6K>> .g7_ttt jd+++l .aualalac``rraYAYN<A<A+ !YtY   S~v@%W%E%EE ,, "ddd 2]2C2CC 50000 ohh ,, b4))@) 0{(9~F-g"~6,X{X{XX xxxx M^j^jbb @@@@ "FtFtFF @U@UAA xxxx  IoII Ub{b{bb jjjj Mljljpp eeee "1t1t11 +U+U,, kkkk ZoZyZyy Q__qq 3(VjVjVje1j44== k;!!o0o 3F ~``  F ee2 6 "N"N"" '''' 4444 )Z)Z)) 9  R?? &&&& K9K  Acjj'WWl'W#####{Wl/q eIfu/?? ;111  $11 OeC fsI _s _DfC ^{{{{>>>>l  MMI  l {|||| DWWj Z;Z??-BBW  ~     F "" ,AAW t*\6E*kk nn^^ ss zz mm^^ `6`ll nn^^ WWE '' (( [HH\HX& ((  (( HoCoo m7q7q (???? `` ;aa F22 gNBNBNN  ^^ 622 : :<8Idp`III)ppp8)ppp8)>DD )++ +-*-11:  xx   ? ?  LS$$^$^^ +--11H 66!S!SI  xx   !d "/ hK?~W:~eN6N6N6K 4Q :::6 4Q :::6 4Guu J *h kk? *--W %$hhh  - !6###  k k ?  Ejjj~j h  R((,(,~, =      W F j F9991ddd1ddd111 U?? US88j$QfQfQfQfQfj$ o5SF (~ oo  &&bb11Jfv+v+fvvK mmee   fuufuu **kkkk  a e e j J5JDDQ eDDDQ _ d d j - %.{S{v6f63'%]7A7{G{Gll Cpp2 hh2@hhCbb~\A. %KKzKzz1zC 2"f("]_]_] ] (A)&&& A)&&& TC{{  Puuu.{]]g]gg%m0C00 !###f&]_]_] ] &.% .% V0C0 p{ppp 363GG^ ,,  O  ] xar5<f@\*GGG aa /ll((<6aa E )AHHH >444 D>>##< StCtt 8444 D.zCz  7\!=8,J!/.Display1xLwxQDwXwa fv11v11File% -- %Display% / %SubjectArea%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f|8|8;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f88 %File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f88 %File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f'8'8 %File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa fS;S;B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' ) Display1xLwxQDwXwa f(;(;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' ) Display1xLwxQDwXwa f6*;6*;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' ) Display1xLwxQDwXwa f+;+;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' ) Display1xLwxQDwXwa fx,;x,;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' ) Display1xLwxQDwXwa f-;-;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f /; /;%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )Display1xLwxQDwXwa f݃<݃<Td%File% -- %Display% / %SubjectArea%%CurrentPage% / %TotalPages% -- %Time% , %Date%B,winspoolHP LaserJet 2100 Series PXLPT1:PHP LaserJet 2100 Series PXG 4dA4PRIV'''' )<@{p{Arch SQL Statement for WP      !"#$%&'()*+,-./0123456789:;<=>?9@@{{Schema Generation Report     !"#$%&'()*+,-./0123456789:;<=>?