Merge appointments from Enterprise Directory that have the same title and department. Use min for startDate and max for endDate.

[paulalbert1]

Background

About 2% of all appointments have another appointment which is the exact same title and department. This happens when individuals change tenure track status among other things.

Example

For col2004, Associate Professor of Psychiatry is listed twice (RITM0295531).

Logic

See if this logic that I wrote in Splunk makes sense

| ldapsearch domain=ed-faculty search="(&(objectClass=weillCornellEduSORRoleRecord))" attrs="weillCornellEduCWID,weillCornellEduDepartment,weillCornellEduStartDate,weillCornellEduEndDate,title" 
| table weillCornellEduCWID,weillCornellEduDepartment,weillCornellEduStartDate,weillCornellEduEndDate,title
| stats min(weillCornellEduStartDate) as weillCornellEduStartDate, max(weillCornellEduEndDate) as weillCornellEduEndDate by weillCornellEduCWID, title, weillCornellEduDepartment