Body
Scope
Use this document to understand what a GUID (SYSTEM ID) is in DART and how to utilize Business Object reports to obtain a specific GUID.
What is a GUID?
GUIDs also known as System ID's are Globally Unique Identifiers. A GUID is often needed to make batch updates to data in DART. A GUID is used to isolate specific instances of data within DART. Similar to how a DART Constituent LookupID is the unique ID for an individual in DART, a GUID is a unique ID for specific data points within DART. To update a specific email address, mailing address, constituent affiliation, attribute, or education degree, a GUID is required. All pieces of data in DART have their own unique GUID and are required to make changes to the piece of data. E.g. in order to delete a Constituent Affiliation on a DART record, an Affiliation GUID would be required.
To update or delete data from DART you will need the correct GUID.
GUID vs. System ID?
GUID and System ID are interchangeable and refer to the same unique ID.
Specific GUIDs
| Name1 |
Name2 |
Name3 |
Why would I need this GUID? |
| Constituent GUID |
Constituent System ID |
|
This GUID is needed to make batch updates to a constituent record e.g. updating/deleting Attributes and Affiliation |
| Affiliation GUID |
Affiliation System ID |
Usr Cnst Affltn Sys Key |
This GUID is needed to identify a specific Constituent Affiliation Instances.
E.g., the exact “Constituent of Interest” tag on a constituent record |
| Education GUID |
Education System ID |
Education History GUID/Education History System ID |
This GUID is needed to identify a specific degree row within DART.
E.g., a constituent with an MBA |
| Educational Additional Information System ID |
|
|
This GUID is needed to identify additional degree row information that is located in the “education additional information” section of DART.
E.g., a constituent with an Economics major |
| Purpose System ID |
Designation System ID |
Designation GUID |
This GUID is needed to make updates to Designation Attributes.
|
| Educational Involvement SystemID |
|
|
This GUID is needed to make updates or delete educational involvements. |
Additional GUIDs
There are many additional GUIDs that could be required to make DART updates. If the GUID you require is not in the table above, please reach out to OUD-Integrated Data Services (IDS) and they can assist in obtaining the correct GUID.
Business Objects Reporting
There are several Business Objects reports that can be used in order to obtain a GUID.
Constituent System IDs by Constituent LookupIDs
This Business Objects report will pull Constituent System IDs or GUID for a prompted DART Constituent LookupID
E.g. if I have a DART Constituent LookupID but I need a Constituent System ID.
Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Constituent Reports/
Constituents by Constituent Affiliation with AffiliationSystemID
This Business Objects report will pull Constituents with a specific Constituent Affiliation, the report will then display the Constituent Affiliation's specific GUID.
Use this report if you need to pull a group of constituents by Affiliation and will need the Affiliation GUID's.
Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Constituent Reports/
Education System IDs by DART Constituent LookupID
This Business Objects report will pull Education System IDs for a prompted DART Constituent LookupID
E.g. if I have a DART Constituent LookupID and I need a degree row GUID.
Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Constituent Reports/
Purpose (Designations) with SystemID by Purpose (Designation) LookupID
This Business Objects report is designed to pull all Designations (based on Designation LookupID). On the first tab is the Designation and the associate GUID. On the second tab are all the attributes related to the Designation and the corresponding GUIDs.
Educational Involvements SystemIDs by Educational Involvement Name
This Business Objects report is designed to pull educational involvement GUIDs to be updated via batch upload.