ores.refdata.party_id_scheme

Table of Contents

Reference data table defining valid party identifier scheme types. Examples: 'LEI', 'BIC', 'MIC', 'DUNS'.

Party ID schemes are managed by the system tenant. The optional coding_scheme_code field cross-references the DQ coding scheme table.

Flags

Columns

code

Unique scheme code.

Examples: 'LEI', 'BIC', 'MIC'.

name

Human-readable name for the identifier scheme.

std::string(faker::word::adjective()) + " Scheme"

description

Detailed description of the identifier scheme.

std::string(faker::lorem::sentence())

coding_scheme_code

Cross-reference to DQ coding scheme table.

Optional link to ores_dq_coding_schemes_tbl for validation.

// Rotate through the codes ores_dq_coding_schemes_tbl is guaranteed to
// have seeded (see refdata_party_id_schemes_populate.sql) -- a random
// faker word never matches a real coding scheme and fails the soft-FK
// validation trigger.
[idx]{
    static constexpr const char* schemes[] = {
        "LEI", "BIC", "MIC", "NATIONAL_ID", "CEDB",
        "NATURAL_PERSON", "ACER", "DTCC_PARTICIPANT_ID", "MPID", "INTERNAL"};
    return std::string(schemes[idx % 10]);
}()

display_order

Order for UI display purposes.

faker::number::integer(1, 100)

max_cardinality

Optional maximum cardinality constraint for the identifier scheme.

faker::number::integer(1, 100)

SQL

Flags

Extra drops

drop function if exists ores_refdata_validate_party_id_scheme_fn;
drop function if exists ores_refdata_validate_party_id_scheme_coding_scheme_fn;

Validation function

Insert trigger

Validations

column validation_function
change_reason_code ores_dq_validate_change_reason_fn
coding_scheme_code ores_refdata_validate_party_id_scheme_coding_scheme_fn

Check constraints

check_1

C++

Flags

Repository

Domain includes

#include <chrono>
#include <string>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"

Conventions

Table display

column header
code Code
name Name
description Description
coding_scheme_code Coding Scheme
display_order Order
modified_by Modified By
version Version

Qt

Detail fields

field label widget type is_key is_required placeholder
code Code codeEdit line_edit true true Enter scheme code
name Name nameEdit line_edit   true Enter scheme name
description Description descriptionEdit text_edit   true Enter a description
coding_scheme_code Coding Scheme codingSchemeCodeEdit line_edit     Enter coding scheme code
display_order Display Order displayOrderEdit spin_box      
max_cardinality Max Cardinality maxCardinalityEdit spin_box      

Columns (Qt model)

enum_name field header type width
Code code Code string 150
Name name Name string 200
Description description Description string 300
CodingSchemeCode coding_scheme_code Coding Scheme string 150
DisplayOrder display_order Order int 80
Version version Version int 80
ModifiedBy modified_by Modified By string 120
RecordedAt recorded_at Recorded At timestamp 150

Custom repository methods

See also

Emacs 29.3 (Org mode 9.6.15)