Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SHORTID nvarchar(10)   Default = '' A short identifier for this element. Used in the Account String if this element is used as a segment
 DESCRIPTION nvarchar(60)   Default = '' A friendly description of what this element represents
 TYPECODE tinyint   Default = 3 Defines the type of accounting element. Should match accounting values.
 TYPE nvarchar(16) (Computed) CASE [TYPECODE] WHEN 1 THEN N'Account Code' WHEN 2 THEN N'Fund' WHEN 3 THEN N'Standard Segment' WHEN 4 THEN N'Endowment' WHEN 5 THEN N'Program' WHEN 6 THEN N'Event' WHEN 7 THEN N'Special Project' WHEN 8 THEN N'Grant' WHEN 9 THEN N'Membership' END Provides a translation for the 'TYPECODE' field.
 ISACTIVE bit   Default = 1 Whether this account segment is currently usable for data entry
 PREVENTDATAENTRY bit   Default = 0 Whether data entry is allowed to this segment
 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.
 PREVENTDATAENTRYBEFOREDATE datetime Date until data entry is prevented
 PREVENTDATAENTRYAFTERDATE datetime Date when data entry is prevented from
 PREVENTPOST bit   Default = 0 Whether posting is allowed to this segment
 PREVENTPOSTBEFOREDATE datetime Date until posting is prevented
 PREVENTPOSTAFTERDATE datetime Date when posting is prevented from
 ACCOUNTSEQUENCE int (Computed) ([dbo].[UFN_ACCOUNTSTRUCTURE_GETSEQUENCE](GLACCOUNTSTRUCTUREID)) Sequence in the account string where this segment falls, based on accounting element
 ELEMENTNAME nvarchar(100) (Computed) ([dbo].[UFN_TRANSLATIONFUNCTION_ACCOUNTSTRUCTURE_NAME](GLACCOUNTSTRUCTUREID)) User defined name of the element, from the Account Structure table

Foreign Key Field Type Null Notes Description
 GLACCOUNTSTRUCTUREID uniqueidentifier ACCOUNTSTRUCTURE.ID If used as a segment, refers to the accounting element this represents.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DATAELEMENT_DATEADDED DATEADDED    
 IX_DATAELEMENT_DATECHANGED DATECHANGED      
 PK_DATAELEMENT ID  
 UIX_DATAELEMENT_GLACCOUNTSTRUCTUREID_DESCRIPTION GLACCOUNTSTRUCTUREID, DESCRIPTION    
 UIX_DATAELEMENT_SHORTID_GLACCOUNTSTRUCTUREID SHORTID, GLACCOUNTSTRUCTUREID    

Trigger Name Description
 TR_DATAELEMENT_AUDIT_UPDATE
 TR_DATAELEMENT_AUDIT_DELETE
 TR_DATAELEMENT_UPD_UPDATEACCOUNTSTRING

Referenced by Field
 LEDGERACCOUNT DATAELEMENT1ID
 LEDGERACCOUNT DATAELEMENT2ID
 LEDGERACCOUNT DATAELEMENT3ID
 LEDGERACCOUNT DATAELEMENT4ID
 LEDGERACCOUNT DATAELEMENT5ID
 LEDGERACCOUNT DATAELEMENT6ID
 LEDGERACCOUNT DATAELEMENT7ID
 LEDGERACCOUNT DATAELEMENT8ID
 LEDGERACCOUNT DATAELEMENT9ID
 LEDGERACCOUNT DATAELEMENT10ID
 LEDGERACCOUNT DATAELEMENT11ID
 LEDGERACCOUNT DATAELEMENT12ID
 LEDGERACCOUNT DATAELEMENT13ID
 LEDGERACCOUNT DATAELEMENT14ID
 LEDGERACCOUNT DATAELEMENT15ID
 LEDGERACCOUNT DATAELEMENT16ID
 LEDGERACCOUNT DATAELEMENT17ID
 LEDGERACCOUNT DATAELEMENT18ID
 LEDGERACCOUNT DATAELEMENT19ID
 LEDGERACCOUNT DATAELEMENT20ID
 LEDGERACCOUNT DATAELEMENT21ID
 LEDGERACCOUNT DATAELEMENT22ID
 LEDGERACCOUNT DATAELEMENT23ID
 LEDGERACCOUNT DATAELEMENT24ID
 LEDGERACCOUNT DATAELEMENT25ID
 LEDGERACCOUNT DATAELEMENT26ID
 LEDGERACCOUNT DATAELEMENT27ID
 LEDGERACCOUNT DATAELEMENT28ID
 LEDGERACCOUNT DATAELEMENT29ID
 LEDGERACCOUNT DATAELEMENT30ID

Entity-Relationship diagram of this table