Valuelists Values

All relations between valuelists 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 valuelist in any context, i.e. every class/property where the valuelist 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 valuelist to one value. If you would like to add x values to one valuelist, you have to fill out x lines for each value with the same valuelist 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 valuelist 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 valuelists 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 valuelists
preferred name VL The VL´s name
id_va_existing the 6-digit identifier mentioned in table valuelists
preferred name VA the VA’s name
CR Proposer CDP user name
Reason for request Your reason for the change