Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DESCRIPTION nvarchar(100)   Default = '' Account segment description
 SEQUENCE int   Default = 0 Order this element appears in account string
 LENGTH tinyint   Default = 2 Length of the segment
 SEPARATORCODE tinyint   Default = 1 Segment separator
 SEGMENTTYPE tinyint   Default = 0 Numeric representation of Segment type (Accountcode 1, fund 2, Regular 3, Composite 4
 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.
 ISPROJECTSEGMENT bit   Default = 0 This segment represents a project in FE7.
 ELEMENTDEFINITIONCODE tinyint   Default = 3 Accounting Element type this structure element is associated with. Should match Accounting Element.
 ELEMENTDEFINITION nvarchar(12) (Computed) CASE [ELEMENTDEFINITIONCODE] WHEN 1 THEN N'Account code' WHEN 2 THEN N'Fund' WHEN 3 THEN N'User-defined' WHEN 4 THEN N'Endowment' WHEN 5 THEN N'Program' WHEN 6 THEN N'Event' WHEN 7 THEN N'Project' WHEN 8 THEN N'Grant' WHEN 9 THEN N'Membership' END Provides a translation for the 'ELEMENTDEFINITIONCODE' field.
 SEGMENTSEQUENCE tinyint   Default = 0 sequence just for account segments
 SEGMENTCOLUMN tinyint   Default = 0 Which column is the segment stored in for the account and transaction tables.
 ELEMENTTYPECODE tinyint   Default = 1 Account segment or transaction characteristic
 ELEMENTTYPE nvarchar(26) (Computed) CASE [ELEMENTTYPECODE] WHEN 1 THEN N'Account segment' WHEN 2 THEN N'Transaction characteristic' END Provides a translation for the 'ELEMENTTYPECODE' field.
 CLOSINGELEMENT bit   Default = 0 Is this a closing accounting element?
 DEFAULTDESCRIPTIONSEQUENCE tinyint   Default = 0 Sequence for default account description
 DEFAULTDESCRIPTIONLENGTH tinyint   Default = 0 Length for the default account description
 ISBASICGL bit   Default = 1 Indicates whether account segment is for BasicGL or Financials.
 SEPARATOR nvarchar(14) (Computed) CASE [SEPARATORCODE] WHEN 1 THEN N'- Hyphen' WHEN 2 THEN N', Comma' WHEN 3 THEN N'/ Slash' WHEN 4 THEN N'; Semicolon' WHEN 5 THEN N'. Period' WHEN 6 THEN N'<No separator>' END Provides a translation for the 'SEPARATORCODE' field.
 ISCONSTANTVALUE bit   Default = 0 Flag for constant valued segments.

Foreign Key Field Type Null Notes Description
 PDACCOUNTTABLESAVAILABLEFORSEGMENTID uniqueidentifier PDACCOUNTTABLESAVAILABLEFORSEGMENT.ID Tables for segment use.
 SITEID uniqueidentifier SITE.ID Site used by this segment
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PDACCOUNTSYSTEMID uniqueidentifier   PDACCOUNTSYSTEM.ID Accounting system id

Index Name Field(s) Unique Primary Clustered
 IX_PDACCOUNTSTRUCTURE_DATEADDED DATEADDED    
 IX_PDACCOUNTSTRUCTURE_DATECHANGED DATECHANGED      
 PK_PDACCOUNTSTRUCTURE ID  
 UIX_PDACCOUNTSTRUCTURE_DESCRIPTION_PDACCOUNTSYSTEMID DESCRIPTION, PDACCOUNTSYSTEMID    

Trigger Name Description
 TR_PDACCOUNTSTRUCTURE_DEL
 TR_PDACCOUNTSTRUCTURE_VALIDATE
 TR_PDACCOUNTSTRUCTURE_AUDIT_UPDATE
 TR_PDACCOUNTSTRUCTURE_AUDIT_DELETE
 TR_PDACCOUNTSTRUCTURE_INS
 TR_PDACCOUNTSTRUCTURE_UPDDEL
 TR_PDACCOUNTSTRUCTURE_INSUPD

Referenced by Field
 ACCOUNTINGELEMENTRELATIONSHIP BASEELEMENTACCOUNTSTRUCTUREID
 ACCOUNTINGELEMENTRELATIONSHIPELEMENTPARAMETER PDACCOUNTSTRUCTUREID
 ACCOUNTINGELEMENTRELATIONSHIPQUERYPARAMETER PDACCOUNTSTRUCTUREID
 BATCHPDACCOUNTSEGMENTMAPPING PDACCOUNTSTRUCTUREID
 CLOSINGREQUIREMENTDETAIL ACCOUNTSTRUCTUREID
 PDACCOUNTSEGMENT PDACCOUNTSTRUCTUREID
 PDACCOUNTSEGMENTMAPPING PDACCOUNTSTRUCTUREID
 PDACCOUNTSEGMENTVALUE PDACCOUNTSTRUCTUREID
 PDCOMPOSITESEGMENTMAPPING PDACCOUNTSTRUCTUREID
 WORKSTAGE ACCOUNTSTRUCTUREID

Entity-Relationship diagram of this table