create views for the acs tables