Classes Properties

All relations between classes and properties are to be documented here. Each line is the relationship of one class to one property. If you would like to add x properties to one class, you have to fill out x lines for each property with the same class identifier. The connection is related by either the id_class_non-existing (if class is new) or the id_class_existing (if class is existing) of the class and either the id_pr_non-existing (if PR is new) or the id_pr_existing (if PR is existing) of the property.

ADD CC_PR

ADD CC_PR = A PR (new or existing) shall be related to a CC (new or existing).

Mandatory fields:

CR type	ADD CC_PR
id_class_non-existing or id_class_existing	in case of a new CC, insert the unique internal ID mentioned in table classes or the 8-digit CR ID in case of an existing CC, it is the 6-digit identifier
class coded name	8-digit ECLASS identifier (optional)
preferred name class	the CC’s name (See naming rules)
id_pr_non-existing or id_pr_existing	in case of a new PR, insert the unique internal ID mentioned in table properties, or the 8-digit CR ID in case of an existing PR, it is the 6-digit identifier
preferred name PR	the PR’s name
Basic relevant	Y = PR is basic relevant, N = PR is not basic relevant
CR Proposer	CDP user name
Reason for request	Your reason for the change

NOTE: In case of ADD CC_PR the system has to check in database if assignment already exists and announce error on duplication. Duplications will be checked via Value ID.

ADD AS_PR / ADD BL_PR

ADD AS_PR / ADD BL_PR = A PR (new or existing) shall be related to an AS (new or existing) or BL (new or existing).

Mandatory fields:

CR type	ADD AS_PR / ADD BL_PR
id_class_non-existing or id_class_existing	in case of a new CC, insert the unique internal ID mentioned in table classes or the 8-digit CR ID in case of an existing CC, it is the 6-digit identifier
preferred name class	the CC’s (BL or AS) name (See naming rules)
id_pr_non-existing or id_pr_existing	in case of a new PR, insert the unique internal ID mentioned in table properties, or the 8-digit CR ID in case of an existing PR, it is the 6-digit identifier
preferred name PR	the PR’s name
Basic relevant	Y = PR is basic relevant, N = PR is not basic relevant
CR Proposer	CDP user name
Reason for request	Your reason for the change

NOTE: In case of ADD AS_PR or ADD BL_PR the system has to check in database if assignment already exists and announce error on duplication. Duplications will be checked via Value ID.

UNASS CC_PR

UNASS CC_PR = The existing relation between a CC and a PR shall be deleted

Mandatory fields:

CR type	UNASS CC_PR
id_class_existing	the 6-digit identifier mentioned in table classes
class coded name	8-digit ECLASS identifier (optional)
preferred name class	the CC’s name (See naming rules)
id_pr_existing	the 6-digit identifier mentioned in table properties
preferred name PR	the PR’s name
CR Proposer	CDP user name
Reason for request	Your reason for the change

UNASS AS_PR / UNASS BL_PR

UNASS AS_PR / UNASS BL_PR = The existing relation between an AS or BL and a PR shall be deleted

Mandatory fields:

CR type	UNASS AS_PR / UNASS BL_PR
id_class_existing	the 6-digit identifier mentioned in table classes
preferred name class	the CC’s (BL or AS) name (See naming rules)
id_pr_existing	the 6-digit identifier mentioned in table properties
preferred name PR	the PR’s name
CR Proposer	CDP user name
Reason for request	Your reason for the change