Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FROMRECORDTYPE nvarchar(50)   Default = '' The name of the record type to map from.
 TORECORDTYPE nvarchar(50)   Default = '' The name of the record type to map to.
 MAPPINGFUNCTION nvarchar(255)   Default = '' The SQL user-defined scalar or table function which takes an ID of the FROMRECORDTYPE and returns an ID of the TORECORDTYPE.
 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.
 ISTVF bit   Default = 0 This value is set to true when the MAPPINGFUNCTION is a SQL user-defined table function.
 MAPPINGFUNCTIONFORQUERY nvarchar(255)   Default = '' The SQL user-defined table function for the FROMRECORDTYPE for use in query which takes an APPUSERID and QUERYVIEWCATALOGID and returns IDs of the TORECORDTYPE.

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_RECORDSECURITYIDMAP_DATEADDED DATEADDED    
 IX_RECORDSECURITYIDMAP_DATECHANGED DATECHANGED      
 IX_RECORDSECURITYIDMAP_TORECORDTYPE TORECORDTYPE      
 PK_RECORDSECURITYIDMAP ID  
 UIX_RECORDSECURITYIDMAP_FROMRECORDTYPE_TORECORDTYPE FROMRECORDTYPE, TORECORDTYPE    

Trigger Name Description
 TR_RECORDSECURITYIDMAP_AUDIT_UPDATE
 TR_RECORDSECURITYIDMAP_AUDIT_DELETE