Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TABLEID nvarchar(36)   Default = '' Guid for the table, from either TABLECATALOG or CODETABLECATOLOG
 TABLENAME nvarchar(255)   Default = '' Name of the source table
 FRIENDLYTABLENAME nvarchar(25)   Default = '' Name of the source table
 DESCRIPTIONCOLUMNNAME nvarchar(512)   Default = '' Name of the column within the source table that contains the description
 ISCODETABLE tinyint   Default = 0 Indicates whether or not the source table is a code table(1), regular table(2), or Composite Segment(3).
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 SEGMENTTYPECODE tinyint   Default = 0 Indicates whether the table is a builtin segment create by Blackbaud. Note that all builtin segments must support all information sources in GL mapping.
 SEGMENTTYPE nvarchar(7) (Computed) CASE [SEGMENTTYPECODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Builtin' WHEN 2 THEN N'Custom' END Provides a translation for the 'SEGMENTTYPECODE' field.

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

Index Name Field(s) Unique Primary Clustered
 IX_PDACCOUNTTABLESAVAILABLEFORSEGMENT_DATEADDED DATEADDED    
 IX_PDACCOUNTTABLESAVAILABLEFORSEGMENT_DATECHANGED DATECHANGED      
 PK_PDACCOUNTTABLESAVAILABLEFORSEGMENT ID  

Trigger Name Description
 TR_PDACCOUNTTABLESAVAILABLEFORSEGMENT_AUDIT_UPDATE
 TR_PDACCOUNTTABLESAVAILABLEFORSEGMENT_AUDIT_DELETE

Referenced by Field
 PDACCOUNTSTRUCTURE PDACCOUNTTABLESAVAILABLEFORSEGMENTID
 PDACCOUNTTABLESAVAILABLEFORSEGMENTPRODUCTFLAG PDACCOUNTTABLESAVAILABLEFORSEGMENTID
 PDCOMPOSITESEGMENTTABLELIST PDACCOUNTTABLESAVAILABLEFORSEGMENTID

Entity-Relationship diagram of this table