257 lines
13 KiB
HTML
257 lines
13 KiB
HTML
<HTML>
|
|
<HEAD>
|
|
<TITLE>dic_DeathReason</TITLE>
|
|
</HEAD>
|
|
<BODY bgcolor=""#ffffff"" text=""#000000"">
|
|
<TABLE WIDTH=100% CELLPADDING=1 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="darkblue" ><B><FONT SIZE=5 COLOR="white" FACE="Arial">dic_DeathReason </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">EntityType </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">Independent </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Logical Entity Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">dic_DeathReason </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=20%% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Default Table Name </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">dic_DeathReason </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">Owner </FONT></B></TD>
|
|
<TD><FONT SIZE=2 FACE="Arial">dbo </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">dic_DeathReason Attributes </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">Attribute/Logical Rolename </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=20% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Domain </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=18% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Datatype </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=7% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">NULL </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=46% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Definition </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = "Tbl_5c7204567fe54628a172c240013950a1_Attr.htm#Attr_83ac63a7e9af431ebc267ddd15d4ef01">dth_ReasonID</A><img src="../Support/Gif/pk.gif" alt="(PK)"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">INTEGER </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NO </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><PRE><FONT SIZE=2 FACE="Arial"></FONT></PRE> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = "Tbl_5c7204567fe54628a172c240013950a1_Attr.htm#Attr_e2c538fbee2a4608b6407792b5a91e43">dth_ReasonDes</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">NVARCHAR(50) </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">YES </FONT></TD>
|
|
<TD VALIGN=TOP ><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">dic_DeathReason 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">Key Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Key Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Keys </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">PK__dic_Deat__94B0A32FAFFC447E </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">PrimaryKey </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">dth_ReasonID </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">dic_DeathReason Relationships </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=3 FACE="Arial">Parent Relationships: </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Entity Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Business Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">VerbPhrase </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">InversePhrase </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Foreign Keys </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is Supertype </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=3 FACE="Arial">Child Relationships: </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Entity Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Cardinality </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Business Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">VerbPhrase </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">InversePhrase </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=14% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Foreign Keys </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=8% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is Subtype </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = "./Tbl_e41ef371567e49acad153dff8eec6e98.htm">death</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">Non-Identifying </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial">One To Zero or More </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"> </FONT></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">dic_DeathReason Check Constraints </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">Check Constraint Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=66% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">CheckConstraint </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">dic_DeathReason Object Permissions </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">User/Role Name </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Grantee Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Permission Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Action Type </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is Action Extended </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=22% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Is System </FONT></B></TD>
|
|
</TR>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">dic_DeathReason 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">dic_DeathReason 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">dic_DeathReason Where Used - Model Usage </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=20% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Denormalization Mappings </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=27% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Description </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=27% 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_5c7204567fe54628a172c240013950a1.htm>dbo.dic_DeathReason</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>
|
|
<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_a21372bbb9fb465f899d624023a78814.htm>dbo.dic_DeathReason</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>
|
|
<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">dic_DeathReason Where Used - Submodel Usage </FONT></B></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<TABLE WIDTH=100% CELLPADDING=2 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP WIDTH=40% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Model </FONT></B></TD>
|
|
<TD VALIGN=TOP WIDTH=60% bgcolor="#87BCFF"><B><FONT SIZE=2 FACE="Arial">Submodel Usage </FONT></B></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_53aab83c7ad641e393c84d36f944eb13.htm>Logical</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Submodel_758cf20ad25c4ee4b68af86712ce9a7f_img.htm>Main Model</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_53aab83c7ad641e393c84d36f944eb13.htm>Logical</A> </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Submodel_e7f18c4979f54304b5b3f81141a8f0b4_img.htm>death</A> </FONT></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Model_cfbc9cd44e9e45838892e6b3b5c398c3.htm>Physical</A> (Microsoft SQL Server) </FONT></TD>
|
|
<TD VALIGN=TOP ><FONT SIZE=2 FACE="Arial"><A HREF = ./Submodel_1b19ac25513d4808bd1ea24b5182b9f3_img.htm>Main Model</A> </FONT></TD>
|
|
</TR>
|
|
</TABLE>
|
|
<P>
|
|
<TABLE WIDTH=100% CELLPADDING=3 BORDER=2>
|
|
<TR>
|
|
<TD VALIGN=TOP BGCOLOR="LIGHTGREY" ><B><FONT SIZE=4 FACE="Arial">dic_DeathReason 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>
|
|
</BODY>
|
|
</HTML>
|