802 lines
34 KiB
HTML
802 lines
34 KiB
HTML
<HTML>
|
|
<BODY bgcolor="#ffffff" text="#000000">
|
|
<A NAME = "Rel_0bed59ad042746c0bb7707d3bb21b0e1"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"observation to outmigration" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_09a4e5b6c89b44469640d14875389e9d.htm">observation</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_4bf8f22b245d455f933f036a7748fa01.htm">outmigration</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Zero or One to Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Optional </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"observation to outmigration" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"observation to outmigration" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">observeid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">observeid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"observation to outmigration" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"observation to outmigration" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Rel_54b187040a554c72bce29e8b906f0127"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"location to observation" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_361d58898696491db5776641b7e72606.htm">location</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_09a4e5b6c89b44469640d14875389e9d.htm">observation</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Zero or One to Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Optional </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to observation" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to observation" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">locationid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">locationid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to observation" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to observation" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Rel_82b24c4361384e6c85eb587eeab746f5"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"socialgroup to observation" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_dad1f9903f51426093b35c653b92a3de.htm">socialgroup</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_09a4e5b6c89b44469640d14875389e9d.htm">observation</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Zero or One to Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Optional </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to observation" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to observation" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">socialgpid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">socialgpid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to observation" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to observation" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Rel_0cfdad586d3f47aeb8c820c011883732"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"individual to outmigration" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_515e05b4935a4686a5adf11ec39312d5.htm">individual</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_4bf8f22b245d455f933f036a7748fa01.htm">outmigration</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Zero or One to Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Optional </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"individual to outmigration" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"individual to outmigration" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">individid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">individid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"individual to outmigration" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"individual to outmigration" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Rel_4a3d70a693474421b4ab5793f4673c6c"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"location to outmigration" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_361d58898696491db5776641b7e72606.htm">location</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_4bf8f22b245d455f933f036a7748fa01.htm">outmigration</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">One To Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Mandatory </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to outmigration" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to outmigration" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">locationid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">locationid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to outmigration" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"location to outmigration" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Rel_10342dfb1d3648368d5b23debd5a86c5"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">"socialgroup to outmigration" </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">RelationshipType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Do Not Generate </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">False </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Relationship Business Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Only </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">No </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_dad1f9903f51426093b35c653b92a3de.htm">socialgroup</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Entity </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><A HREF="Tbl_4bf8f22b245d455f933f036a7748fa01.htm">outmigration</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Zero or One to Zero or More </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Existence </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Optional </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Propagated Key </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Primary Key </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to outmigration" Relationship Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Inverse Verb Sentence </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to outmigration" Foreign Keys </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Parent Key </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Child Key </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">socialgpid </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">socialgpid </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to outmigration" Trigger Templates </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ParentDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildInsert </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildUpdate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ChildDelete </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">None </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">"socialgroup to outmigration" Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=30% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Current Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
</BODY>
|
|
</HTML>
|