Question:
When querying Calls created from a Medical Event, there appear to be duplicates. Why are two records appearing for the same Call in the report. Why do both calls have different Call names but both refer to the same Call?
Answer:
If no Account is specified on the Medical_Event_vod record, then the Parent Call does not have a populated account. The Account field on the Medical_Event_vod record appears blank. Creating a Call from a Medical Event generates a new call2_vod record for each attendee which is a Child Call.
This behavior is working as designed. Any time a call2_vod record that is a Child Call is opened, the Parent call2_vod record is loaded. These are not duplicate records.
For example, if a Medical Event has five attendees and a Call is recorded, six call2_vod records are created. One Parent call2_vod record and five Child call2_vod records all load the Parent Call when they are accessed.
The call2_vod.Is_Parent_Call_vod field is used to determine which Calls are Parent Calls. Parent_Call_vod records have a value of 1.0. Any call2_vod record which has a value of 0.0 in the call2_vod.is_Parent_call_vod field is a Child Call.
Related Documentation:
N/A