Table of Contents

Table Reg_Code_Entries

Entity

Entity: Regulatory.Common.CodeEntries

Code Entries. Entity: Reg_Code_Entries (Introduced in version 26.2.0.62)

Owner Tables Hierarchy

Summary

Name Type Description
Additional_Data_Json nvarchar(max) Flexible JSON field for extended regulatory attributes.
Alt_Code nvarchar(64) Optional alternative/legacy code used for backward compatibility.
Code nvarchar(64) Official statutory code of the entry; may repeat across different validity periods.
Code_Entry_Id uniqueidentifier PK Unique identifier of the code entry.
Code_List_Id uniqueidentifier Reference to the regulatory code list containing this entry.
Data_1 nvarchar(64) Additional structured attribute for regulatory-specific data.
Data_2 nvarchar(64) Additional structured attribute for regulatory-specific data.
Data_3 nvarchar(64) Additional structured attribute for regulatory-specific data.
Is_Active bit Specifies whether the code entry is currently active.
Name nvarchar(254) ML Official regulatory name of the entry (multi-language).
Notes nvarchar(max) Free text notes or comments
Parent_Entry_Id uniqueidentifier Reference to a parent entry for hierarchical lists (regions / subregions / groups).
Row_Version timestamp
Short_Name nvarchar(64) ML Abbreviated or short name of the entry, if such exists.
Valid_From date Date from which this entry is valid.
Valid_To date Date until which this entry is valid.

Columns

Additional_Data_Json

Flexible JSON field for extended regulatory attributes.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 13
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Additional_Data_Json - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Alt_Code

Optional alternative/legacy code used for backward compatibility.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 3
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Alt_Code - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Code

Official statutory code of the entry; may repeat across different validity periods.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Code - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Like None no no

Code_Entry_Id

Unique identifier of the code entry.

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 0
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Code_Entry_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
GreaterThanOrLessThan None no yes

Code_List_Id

Reference to the regulatory code list containing this entry.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 1
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Reg_Code_Lists
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Code_List_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Data_1

Additional structured attribute for regulatory-specific data.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 10
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Data_1 - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Data_2

Additional structured attribute for regulatory-specific data.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 11
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Data_2 - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Data_3

Additional structured attribute for regulatory-specific data.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 12
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Data_3 - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Is_Active

Specifies whether the code entry is currently active.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 9
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Active - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Name

Official regulatory name of the entry (multi-language).

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 4
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254) (MultiLanguage) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Notes

Free text notes or comments

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 14
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Notes - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Like None no no

Parent_Entry_Id

Reference to a parent entry for hierarchical lists (regions / subregions / groups).

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 6
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Reg_Code_Entries
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Parent_Entry_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 15
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Short_Name

Abbreviated or short name of the entry, if such exists.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 64
Order 5
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(64) (MultiLanguage) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Short_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Valid_From

Date from which this entry is valid.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 7
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type date (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Valid_From - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
GreaterThanOrLessThan None no no

Valid_To

Date until which this entry is valid.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 8
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type date (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Valid_To - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
GreaterThanOrLessThan None no no
Suggest improvement to this page