Open topic with navigation

SYSTEMROLEPERM_CODETABLEENTRY (4.0SP13)

System permissions for code table entries.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

SYSTEMROLEID

uniqueidentifier

false

System role ID for which permission has been assigned.

CODETABLECATALOGID

uniqueidentifier

false

Code table ID where the code table entry comes from.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

CODETABLEENTRYID

uniqueidentifier

false

ID of the code table entry for which permission has been assigned.

ISDENIED

bit

false

1

Specifies whether or not the code table entry is denied to the system role.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_SYSTEMROLEPERM_CODETABLEENTRY_CODETABLECATALOGID

CODETABLECATALOGID

False

False

False

IX_SYSTEMROLEPERM_CODETABLEENTRY_CODETABLEENTRYID

CODETABLEENTRYID

False

False

False

IX_SYSTEMROLEPERM_CODETABLEENTRY_DATEADDED

DATEADDED

False

False

True

IX_SYSTEMROLEPERM_CODETABLEENTRY_DATECHANGED

DATECHANGED

False

False

False

PK_SYSTEMROLEPERM_CODETABLEENTRY

ID

True

True

False

UIX_SYSTEMROLEPERM_CODETABLEENTRY_SYSTEMROLEID_CODETABLEENTRYID

SYSTEMROLEID

CODETABLEENTRYID

True

False

False
Triggers
Trigger Name Description

TR_SYSTEMROLEPERM_CODETABLEENTRY_AUDIT_UPDATE

TR_SYSTEMROLEPERM_CODETABLEENTRY_AUDIT_DELETE