A Relationship connects two or more object types together (e.g., Company and Business Unit) in Core. Such relationships help you map the big picture for your organization and understand the impacts and accountabilities as you record, track, report, and manage information.
EXAMPLE |
|
Data entered into a relationship worksheet on the template.
|
To enter relationship data on the Data Import Template:
Click the Relationship tab to open its worksheet.
Tabs generate in alphabetical order, with relationship tabs labelled with the monogram of the object type they're saved on and their object type group (e.g., R - Control).
Object type tabs are highlighted. See more: Enter New Object Data on the Import Spreadsheet.
Tabs on a Data Import Template. Object type tabs are highlighted (e.g., Risk and Risk Category). The relationship tabs are labelled by their associated object type's monogram and object type group (e.g., R-Incident Type).
Enter the external reference ID (e.g., PERS-1) of the Person object with the relationship saved to it (Row 5, Column A) under OB1 Ext Ref ID.
Enter the external reference ID of the Location object (e.g., LOC-1) that the relationship will pull data from (Row 5, Column C) under OB2 Ext Ref ID.
To import relationships from one object to another (e.g., C-Business Unit), you must enter both objects’ unique External Reference IDs on the Excel spreadsheet.
Object Name in columns B and D are optional fields, meaning that your data import will not fail if those sections are left blank.
Regardless, we recommend adding the Object Name so that you can clearly see what objects are related to one another.
Existing relationships between Objects can't be removed using a Data Import. If required, objects can be unlinked from the reference or relationship object.
Save your changes.