Several changes were made to ELEMENT_GLOBAL_RANK, ELEMENT_NATIONAL_RANK, and ELEMENT_SUBNATL_RANK in Biotics 5 to make these tables compatible with the Rank Calculator (also see the Solution titled Rank Calculator Export for Biotics 5).

All the changes are summarized in the spreadsheet attached to the Solution titled Data Model changes between Biotics 4 and Biotics 5.5, but a couple deserve special note. 

As of version 5.5.2, the fields d_area_of_occupancy_id and d_lin_dist_of occupancy_id have been removed from the ranking tables. They were replaced as follows:

For species, d_area_of_occupancy_id is replaced by d_aoo_4km_id and d_lin_dist_of_occupancy_id is now replaced by d_aoo_1km_id.

For communities, d_area_of_occupancy_id is replaced by one of the following, depending on patch size of the community:

d_aoo_direct_default_id for either large patch or unknown size

d_aoo_direct_matrix for matrix communities

d_aoo_direct_small for small patch

These fields should also be used instead of d_lin_dist_of_occupancy_id (no distinction of "linear" is made for communities, but it should be included in the comments as appropriate). Any data in community ESRs from d_lin_dist_of_occupancy_id was moved to d_aoo_direct_default_id, unless there was also a value in d_area_of_occupancy_id, in which case the value in d_lin_dist_of_occupancy was not migrated.

The data in d_area_of_occupancy_id and d_lin_dist_of_occupancy_id were converted to values in the new fields during your database's conversion to Biotics 5. For communities, data from either of these fields went into d_aoo_direct_default_id, since patch size was unknown.

The old fields were left in the table for reference until recently. However, to avoid confusion, they have been removed (as of 30 Sept 2014). If you have queries or views that include the fields d_area_of_occupancy_id or d_lin_dist_of_occupancy_id, you will need to update them.