I think I see what you mean; ‘Shots’s ‘Days Budgeted’ field type is Duration, while the other aforementioned fields’ types are Query.
But the problem is, the field types for the rest of the fields for both ‘Shots’ and ‘Episodes’ are all stuck at Query and I can’t change them to any other types as they’re all greyed out.
Is there another way to get the values from the fields that are stuck being a Query field type?