471 lines
20 KiB
HTML
471 lines
20 KiB
HTML
<HTML>
|
|
<HEAD>
|
|
<TITLE>dic_roof Column Details</TITLE>
|
|
</HEAD>
|
|
<BODY bgcolor=""#ffffff"" text=""#000000"">
|
|
<A NAME = "Attr_c067ef4792064d0ea3a247db18db0c1c"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">ID </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">Base Object </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">dic_roof </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Attribute Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">ID </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ColumnName </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">ID </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Rolename </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">RoleName </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">Domain </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">Physical 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">Definition </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Column Properties </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">Datatype </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">smallint </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Nullable </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Growth Metrics </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">COLUMN METRIC </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=60% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">COLUMN METRIC VALUE </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">Average Width </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">2 </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">Percent Null </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">0 </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Domain Restrictions </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">CheckConstraint </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Check Constraint Name </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Rule </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Declared Default </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">((0)) </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Declared Default Name </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">DF__dic_roof__ID__5535A963 </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Default </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">ID Security Types </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>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID 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>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Data Movement Rules </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=10% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Rule Text/Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Where Used </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=18% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Mapped Object </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is User Defined? </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=37% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Description </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=37% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_53aab83c7ad641e393c84d36f944eb13.htm>Logical</A><BR><A HREF = ./Tbl_72582bb008dc4022b71b2a55aef5ec62.htm>dic_roof</A><BR><A HREF = ./Tbl_72582bb008dc4022b71b2a55aef5ec62_Attr.htm#Attr_9d418153687f4c549c6ddf7da39222ba>ID</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_cfbc9cd44e9e45838892e6b3b5c398c3.htm>Physical</A> (Microsoft SQL Server)<BR><A HREF = ./Tbl_8ef88d13223e41a4b13b70dc61c258e3.htm>dic_roof</A><BR><A HREF = ./Tbl_8ef88d13223e41a4b13b70dc61c258e3_Attr.htm#Attr_c067ef4792064d0ea3a247db18db0c1c>ID</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></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">ID Direct Source Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Secondary Source Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Direct Target Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">ID Secondary Target Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<HR>
|
|
<A NAME = "Attr_47f8ddc3bc0f4b89ba844e41aba81c74"></A>
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">Describtion </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">Base Object </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">dic_roof </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Attribute Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Describtion </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">ColumnName </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Describtion </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Rolename </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">RoleName </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">Domain </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">Physical 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">Definition </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Note </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Column Properties </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">Datatype </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">nvarchar(50) </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Nullable </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">YES </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Collate </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Sparse </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Growth Metrics </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">COLUMN METRIC </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=60% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">COLUMN METRIC VALUE </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">Average Width </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">100 </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">Percent Null </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">0 </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Domain Restrictions </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">CheckConstraint </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Check Constraint Name </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Rule </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Declared Default </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Declared Default Name </FONT></B></TD>
|
|
<TD VALIGN = TOP><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Default </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">Describtion Security Types </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>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion 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>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Data Movement Rules </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=10% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Rule Text/Value </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Where Used </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=18% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Mapped Object </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is User Defined? </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=37% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Description </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=37% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Bound Attachments </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_53aab83c7ad641e393c84d36f944eb13.htm>Logical</A><BR><A HREF = ./Tbl_72582bb008dc4022b71b2a55aef5ec62.htm>dic_roof</A><BR><A HREF = ./Tbl_72582bb008dc4022b71b2a55aef5ec62_Attr.htm#Attr_db4874a233154539879a4fd24b4540a8>Describtion</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_cfbc9cd44e9e45838892e6b3b5c398c3.htm>Physical</A> (Microsoft SQL Server)<BR><A HREF = ./Tbl_8ef88d13223e41a4b13b70dc61c258e3.htm>dic_roof</A><BR><A HREF = ./Tbl_8ef88d13223e41a4b13b70dc61c258e3_Attr.htm#Attr_47f8ddc3bc0f4b89ba844e41aba81c74>Describtion</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></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">Describtion Direct Source Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Secondary Source Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Direct Target Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">Describtion Secondary Target Mappings </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">Columns </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=12% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Logic </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Transformation Description </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
</BODY>
|
|
</HTML>
|