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
- ores.refdata — component group overview.