DATAELEMENT

Parent table for all accounting element types.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
PREVENTDATAENTRYBEFOREDATE	datetime	yes		Date until data entry is prevented
PREVENTDATAENTRYAFTERDATE	datetime	yes		Date when data entry is prevented from
PREVENTPOST	bit		Default = 0	Whether posting is allowed to this segment
PREVENTPOSTBEFOREDATE	datetime	yes		Date until posting is prevented
PREVENTPOSTAFTERDATE	datetime	yes		Date when posting is prevented from
ACCOUNTSEQUENCE	int (Computed)	yes	([dbo].[UFN_ACCOUNTSTRUCTURE_GETSEQUENCE](GLACCOUNTSTRUCTUREID))	Sequence in the account string where this segment falls, based on accounting element
ELEMENTNAME	nvarchar(100) (Computed)	yes	([dbo].[UFN_TRANSLATIONFUNCTION_ACCOUNTSTRUCTURE_NAME](GLACCOUNTSTRUCTUREID))	User defined name of the element, from the Account Structure table

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
GLACCOUNTSTRUCTUREID	uniqueidentifier	yes	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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DATAELEMENT_DATEADDED	DATEADDED			yes
IX_DATAELEMENT_DATECHANGED	DATECHANGED
PK_DATAELEMENT	ID	yes	yes
UIX_DATAELEMENT_GLACCOUNTSTRUCTUREID_DESCRIPTION	GLACCOUNTSTRUCTUREID, DESCRIPTION	yes
UIX_DATAELEMENT_SHORTID_GLACCOUNTSTRUCTUREID	SHORTID, GLACCOUNTSTRUCTUREID	yes

Triggers

Trigger Name	Description
TR_DATAELEMENT_UPD_UPDATEACCOUNTSTRING
TR_DATAELEMENT_AUDIT_UPDATE
TR_DATAELEMENT_AUDIT_DELETE

Referenced by

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