Adding Object Class Relationships to Administered Items
After installing the OneData MDR package, add the Object Class Relationship to Administered Items.
To add Object Class relationship to Administered Items
1. On the Menu toolbar, click Define > Objects and select the folder, 99. Base Objects.
2. Select the folder, Sub-type specific children.
3. Click Add Object.
4. Click Update Schema.
5. Update the table schema as follows:
a. In Tables Available, select OBJ_CLS_REL and click Get Table Structure.
b. Click Next and edit the definition to provide the following values.
Field | Value |
Name | Object Class Relationship |
Owner/Steward | admin |
Object Type | Data Object |
Mode | Nova |
c. Click Save.
6. Select the new object Object Class Relationship and update the object owner as follows:
a. Click the Structure tab.
b. Click the Edit icon for each column and verify that Owner is set as admin. Save the changes, if any.
7. Add a foreign key constraint between Object Class Relationship and Object Class:
a. In the Command toolbar, click Edit Constraints.
b. Click Add new Foreign Key Constraint.
c. Enter the following values.
Field | Value |
Constraint Name | FK_OBJ_CLS_PRMRY_REL |
XML Element Name | FK_OBJ_CLS_PRMRY_REL |
Related Table Name | Select OBJECT CLASS (STG - OBJ_CLS). |
Related Column Description | Click the Select a Value icon and define the following:  In Single Column Related Description, set Select Related Description as ITEM_ID. In Multiple Column Related Description, set Select Table as Administered Item - FK_AI_OBJ_CLS#ITEM_ID; VER_NR. In Available Columns, select Item Long Name (Administered Item - FK_AI_OBJ_CLS#ITEM_ID; VER_NR) and move it to Selected Columns. Click Set Values. |
d. In Available Columns, select PRMRY_ITEM_ID and PRMRY_VER_NR and move them to Selected Columns. Click Save to save the foreign key constraint.
8. Add a second foreign key constraint between Object Class Relationship and Object Classes.
a. Click Add new Foreign Key Constraint and enter the following values.
Field | Value |
Constraint Name | FK_OBJ_CLS_SCNDRY_REL |
XML Element Name | FK_OBJ_CLS_SCNDRY_REL |
Related Table Name | Select OBJECT CLASSES (STG- VW_OBJ_CLS) |
Related Column Description | Click the Select a Value icon and define the following: In Single Column Related Description, select Select Related Description as ITEM_NM. In Multiple Column Related Description, set Select Table as Object Classes. In Available Columns, select Object Class Name (Object Classes) and move it to Selected Columns. Click Set Values. |
b. In Available Columns, select SCNDRY_ITEM_ID and SCNDRY_VER_NR and move them to Selected Columns. Click Save to save the foreign key constraint.
9. On the Menu toolbar, click Define > Objects and select the Administered Items conceptual object.
10. Click Structure tab.
11. Select the options Object Class Relationship (Object Class Relationship) and Classification Scheme Item (Classification Scheme Item), and click Save.
