Table of Contents

Table Reg_Code_Lists

Entity

Entity: Regulatory.Common.CodeLists

Code Lists. Entity: Reg_Code_Lists (Introduced in version 26.2.0.62)

Summary

Name Type Description
Authority nvarchar(128) Issuing or controlling authority (agency, institution).
Code_List_Id uniqueidentifier PK Unique identifier of the regulatory code list.
Description nvarchar(254) Short description of the list’s purpose or scope.
Entity_Type_Name nvarchar(128) Internal system entity type mapped to entries in this list.
Is_Active bit Specifies whether the list version is currently active.
Jurisdiction_Id uniqueidentifier The jurisdiction to which the list belongs.
Legal_Reference nvarchar(254) Reference to the legal basis (law, article, ordinance, URL, file).
List_Code nvarchar(16) Regulatory code of the list, unique within the jurisdiction
List_Name nvarchar(254) ML Official regulatory name of the list (multi-language).
Notes nvarchar(max) Additional notes or comments
Row_Version timestamp
Valid_From date When not null specifies the first date when the list is valid.
Valid_To date When not null specifies the last date (inclusive) when the list is valid.

Columns

Authority

Issuing or controlling authority (agency, institution).

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 128
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(128) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Authority - Supported Filters

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

Code_List_Id

Unique identifier of the regulatory code list.

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_List_Id - Supported Filters

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

Description

Short description of the list’s purpose or scope.

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) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Description - Supported Filters

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

Entity_Type_Name

Internal system entity type mapped to entries in this list.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name yes
Max Length 128
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 nvarchar(128) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Entity_Type_Name - Supported Filters

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

Is_Active

Specifies whether the list version 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 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 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

Jurisdiction_Id

The jurisdiction to which the list belongs.

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 no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Reg_Jurisdictions
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

Jurisdiction_Id - Supported Filters

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

Reference to the legal basis (law, article, ordinance, URL, file).

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 6
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) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Legal_Reference - Supported Filters

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

List_Code

Regulatory code of the list, unique within the jurisdiction

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 16
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(16)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

List_Code - Supported Filters

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

List_Name

Official regulatory name of the list (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 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(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

List_Name - Supported Filters

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

Notes

Additional 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 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(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

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 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 timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Valid_From

When not null specifies the first date when the list 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_From - Supported Filters

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

Valid_To

When not null specifies the last date (inclusive) when the list 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 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 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