Value Lists Values
All relations between Value Lists and Values are to be documented here (for a global change). Local changes (i.e. a constraint) can be defined in table values_constraints. Global change means that a Value is assigned to or withdrawn from a Value List in any context, i.e. every Class/Property where the Value List is used. Local change (constraint) means that a Value is only assigned to or withdrawn from a Property in the context of a certain Class.
Each line is the relationship of one Value List to one Value. If you would like to add x Values to one Value List, you have to fill out x lines for each Value with the same Value List identifier. The connection is related by either the id_vl_non-existing (if VL is new) or id_vl_existing (if VL is existing) of the Value List and either the id_va_non-existing (if VA is new) or id_va_existing (if VA is existing) of the Value.
ADD VL_VA
ADD VL_VA = A VA (new or existing) shall be related to a VL (new or existing).
Mandatory fields:
CR type | ADD VL_VA |
id_vl_non-existing or id_vl_existing | in case of a new PR, insert the unique internal ID mentioned in table Value Lists or the 8-digit CR ID in case of an existing VL, it is the 6-digit identifier |
preferred name VL | The VL´s name |
id_va_non-existing or id_va_existing | in case of a new VA, insert the unique internal ID mentioned in table Values or the 8-digit CR ID in case of an existing VA, it is the 6-digit identifier |
preferred name VA | the VA’s name |
CR Proposer | CDP user name |
Reason for request | Your reason for the change |
NOTE: In case of ADD VL_VA the system has to check in database if assignment already exists and announce error on duplication. Duplications will be checked via Value ID and not by the preferred name of the VA.
UNASS VL_VA
UNASS VL_VA = The existing relation between a VL and a VA shall be deleted
Mandatory fields:
CR type | UNASS VL_VA |
id_vl_existing | the 6-digit identifier mentioned in table Value Lists |
preferred name VL | The VL´s name |
id_va_existing | the 6-digit identifier mentioned in table Value Lists |
preferred name VA | the VA’s name |
CR Proposer | CDP user name |
Reason for request | Your reason for the change |