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) Additional Data Json
Alt_Code nvarchar(64) Optional alternative/legacy code if needed.
Code nvarchar(64) The statutory code of the entry. The same code can appear multiple times for different validity periods.
Code_Entry_Id uniqueidentifier PK Code Entry
Code_List_Id uniqueidentifier Code List
Data_1 nvarchar(64) Data 1
Data_2 nvarchar(64) Data 2
Data_3 nvarchar(64) Data 3
Is_Active bit Specifies whether the code entry is active.
Name nvarchar(254) ML Official (regulatory) name.
Notes nvarchar(max) Notes for the entry.
Parent_Entry_Id uniqueidentifier Parent entry for hierarchical lists (regions / subregions / groups).
Row_Version timestamp
Short_Name nvarchar(64) ML Abbreviation, if such exists.
Valid_From date From when this entry is valid.
Valid_To date Until when it is valid.

Columns

Additional_Data_Json

Additional Data Json

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 if needed.

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

The statutory code of the entry. The same code can appear multiple times for 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

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

Code_List_Id

Code List

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

Data 1

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

Data 2

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

Data 3

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 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.

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

Notes for the 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 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

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

Abbreviation, 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

From when 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

Until when it 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