Common App fields in every export
Each member record carries the institution name, state and country, control type where published, the application platforms it accepts, and the identifiers used on the platform.
Deadline fields are delivered as rows rather than a column, because most institutions have several: early decision, early action, regular decision, rolling and transfer, each with its own date, and several run more than one early round. A single deadline column is wrong for most members.
Requirement fields cover the application fee and whether waivers are offered, testing policy including test optional and test free where stated, recommendation requirements by type and count, essay and supplemental question requirements, and portfolio or audition expectations where they apply.
Cycle is recorded on every row. A requirement without the admission year it applies to is not usable, and mixing cycles in one table is how an advice product starts telling students the wrong thing.
Change records are delivered alongside: what moved since the previous collection, for which institution and when we saw it, because mid cycle amendments are exactly the thing a counsellor needs to hear about.