# Country

A sovereign country identified by its name and ISO alpha-2 code.

Source table: Countries in Core Record Types (`schema:Country`). A Country is a sovereign state identified by its name and its ISO 3166-1 alpha-2 code.

## Rules and relationships

Enter Name and the two-letter Abbreviation. States lists its first-level divisions; Address lists addresses that name the country directly. Compliance Global is a legacy text column whose description still promises links to compliance requirements; compliance now lives in KPIs & OKRs. The primary field is ID, an auto number.

## Lifecycle and checks

Active marks a country available for current operations. V3 · Reference status and V3 · Next action give the next fix; V3 · State count counts linked states. There is no Record health or Health check pair.

## Source fields

Names, types, options and links are those configured in Core Record Types. The meaning is the first line of each field description in Airtable. Options describe configuration; they do not prove a rule is enforced elsewhere.

### Recorded values

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| Name | Text | Stores the plain-language name of the country. | Entered value. |
| Abbreviation | Text | Stores the country's two-letter ISO 3166-1 alpha-2 code. | Entered value. |
| Active | Checkbox | Stores whether this country is available for current operations. | Entered value. |
| Compliance Global | Text | Links the compliance requirements whose jurisdiction is this country. | Entered value. |

### Links

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| States | Linked records | Links every state, province, or region in this country. | → [State](/systems/core/state) · several records |
| Address | Linked records | Links the addresses that name this country directly. | → [Address](/systems/core/address) · several records |
| Tags | Linked records | Links optional labels from the shared Core Tags catalog. | → [Tag](/systems/core/tag) · several records |

### Calculated

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| V3 · State count | Formula | Counts the states, provinces, and regions linked to this country. | Formula below. |
| V3 · Reference status | Formula | Shows whether this country row is complete enough to be used. | Formula below. |
| V3 · Next action | Formula | Shows the next thing to fix on this country row. | Formula below. |

### Generated by Airtable

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| ID | Auto number | Shows the running number Airtable gave this country when the row was created. | Airtable system value. |
| Created By | Created by | Shows who created this row in Airtable. | Airtable system value. |
| Created | Created time | Shows when this row was created in Airtable. | Airtable system value. |
| Last Modified By | Last modified by | Shows who last changed any value in this row. | Airtable system value. |
| Last Modified | Last modified time | Shows when any value in this row last changed. | Airtable system value. |

## Current formulas

Field IDs are rendered as current field names.

### V3 · State count

```text
COUNTA({States})
```

### V3 · Reference status

```text
IF({Name} = "", "Needs country name", IF({Abbreviation} = "", "Needs abbreviation", IF({Active}, "Ready", "Inactive")))
```

### V3 · Next action

```text
IF({Name} = "", "Enter country name", IF({Abbreviation} = "", "Enter abbreviation", IF(NOT({Active}), "Review inactive country", IF({V3 · State count} = 0, "Review state coverage", "Ready"))))
```

## Example (fictitious)

United States has Abbreviation US and Active checked; its States include Texas. V3 · Reference status reads Ready.

## Use by other systems

No other system mirrors this table.

[Correct shared records](/systems/core/maintain-shared-records) · [All entities](/systems/core/entities)