RELATIONSHIPTYPECODE

This code table stores translations of relationship type codes.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DESCRIPTION	nvarchar(100)			Stores the description of the table entry
ACTIVE	bit		Default = 1	Indicates whether or not the table entry is active
SEQUENCE	int		Default = 0	Stores the user-defined sequence for the table entry
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	convert(bigint, TS)	Numeric representation of the timestamp.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_RELATIONSHIPTYPECODE_DATEADDED	DATEADDED			yes
PK_RELATIONSHIPTYPECODE	ID	yes	yes
UIX_RELATIONSHIPTYPECODE_DESCRIPTION	DESCRIPTION	yes

Triggers

Trigger Name	Description
TR_RELATIONSHIPTYPECODE_INSERT_BBNCCODETABLEIDMAP
TR_RELATIONSHIPTYPECODE_DELETE_BBNCCODETABLEIDMAP
TR_RELATIONSHIPTYPECODE_AUDIT_ETLDELETEDID
TR_RELATIONSHIPTYPECODE_AUDIT_UPDATE
TR_RELATIONSHIPTYPECODE_AUDIT_DELETE

Referenced by

Referenced by	Field
BATCHAUCTIONITEMCONSTITUENTRELATION	RELATIONSHIPTYPECODEID
BATCHAUCTIONITEMCONSTITUENTRELATION	RECIPROCALTYPECODEID
BATCHCONSTITUENT	SPOUSE_RELATIONSHIPTYPECODEID
BATCHCONSTITUENT	SPOUSE_RECIPROCALTYPECODEID
BATCHCONSTITUENT	PRIMARYBUSINESS_RELATIONSHIPTYPECODEID
BATCHCONSTITUENT	PRIMARYBUSINESS_RECIPROCALTYPECODEID
BATCHCONSTITUENTUPDATE	SPOUSE_RELATIONSHIPTYPECODEID
BATCHCONSTITUENTUPDATE	SPOUSE_RECIPROCALTYPECODEID
BATCHCONSTITUENTUPDATE	BUSINESS_RELATIONSHIPTYPECODEID
BATCHCONSTITUENTUPDATE	BUSINESS_RECIPROCALTYPECODEID
BATCHCONSTITUENTUPDATERELATIONSHIPS	RELATIONSHIPTYPECODEID
BATCHCONSTITUENTUPDATERELATIONSHIPS	RECIPROCALTYPECODEID
BATCHREVENUECONSTITUENTRELATION	RELATIONSHIPTYPECODEID
BATCHREVENUECONSTITUENTRELATION	RECIPROCALTYPECODEID
BATCHSPONSORSHIPCONSTITUENTRELATION	RELATIONSHIPTYPECODEID
BATCHSPONSORSHIPCONSTITUENTRELATION	RECIPROCALTYPECODEID
EMPLOYEECORPORATERELATIONSHIPTYPE	RELATIONSHIPTYPECODEID
MARRIAGEADDITIONALRELATIONSHIP	SPOUSERELATIONSHIPTYPECODEID
MARRIAGEADDITIONALRELATIONSHIP	RELATIONSHIPTYPECODEID
MARRIAGEADDITIONALRELATIONSHIPASSOCIATION	RELATIONSHIPTYPECODEID
MARRIAGERELATIONSHIP	SPOUSERELATIONSHIPTYPECODEID
MARRIAGERELATIONSHIPASSOCIATION	RELATIONSHIPTYPECODEID
MATCHFINDERCONFIGURATION	CONTACTRELATIONSHIPTYPECODEID
MATCHFINDERCONFIGURATION	CONTACTRECIPROCALRELATIONSHIPTYPECODEID
MATCHINGGIFTCONDITIONRELATIONSHIP	RELATIONSHIPTYPECODEID
NETCOMMUNITYDEFAULTCODEMAP	RELATIONSHIPTYPECODEID
NETCOMMUNITYDEFAULTCODEMAP	PRIMARYBUSINESSRELATIONSHIPTYPECODEID
NETCOMMUNITYDEFAULTCODEMAP	PRIMARYBUSINESSRECIPROCALTYPECODEID
NETCOMMUNITYDEFAULTCODEMAP	SPOUSEREMOVEDRELATIONSHIPTYPECODEID
PARTIALINFORMATIONSEARCHRESULT_REALESTATE	SPOUSE_RELATIONSHIPTYPECODEID
PARTIALINFORMATIONSEARCHRESULT_REALESTATE	SPOUSE_RECIPROCALTYPECODEID
RECOGNITIONRELATIONSHIPDEFAULT	RELATIONSHIPTYPECODEID
RELATIONSHIP	RELATIONSHIPTYPECODEID
RELATIONSHIP	RECIPROCALTYPECODEID
RELATIONSHIPCONFIGURATION	ID
RELATIONSHIPCONFIGURATIONCORPORATE	PARENTORGID
RELATIONSHIPCONFIGURATIONCORPORATE	SUBSIDIARYORGID
RELATIONSHIPCONFIGURATIONCORPORATE	PARENTOFPARENTORGID
RELATIONSHIPCONFIGURATIONCORPORATE	PARENTOFPARENTSUBSIDIARYORGID
RELATIONSHIPCONFIGURATIONCORPORATE	TOPPARENTORGID
RELATIONSHIPCONFIGURATIONCORPORATE	TOPSUBSIDIARYORGID
RELATIONSHIPTYPECODESITE	RELATIONSHIPTYPECODEID
SPONSORSHIPINFO	AFFILIATERELATIONSHIPTYPECODEID
SPONSORSHIPINFO	AFFILIATESPONSORRELATIONSHIPTYPECODEID
STUDENTRELATIONCONSTITUENCYTYPES	RELATIONSHIPTYPECODEID