What This Field Means
Whether the unit is currently operating, belongs to history, was formally inactivated, is planned, or has an unresolved present status.
This gives the record’s best-supported present lifecycle conclusion: current, historical, inactive, planned, or status unknown. It allows the site to preserve every confirmed identity without falsely presenting every historical unit as active today.
How to Read It Correctly
Historical does not automatically mean formally inactivated, and Status unknown does not mean inactive. Current Status also does not describe temporary deployment posture or whether the unit is deployable.
Example
Historical preserves a documented past identity without claiming that it is active today.
Technical Specification
The database column is [USMIL-Unit].[Unit].[CurrentStatus]. Required lifecycle summary constrained by the Unit table to exactly five stored values.
Use exactly one of the five database-enforced values. The choice must be supported by lifecycle evidence; absence from a current roster alone is not sufficient proof of inactivation.
| Property | Definition or current value |
|---|---|
| Database column | CurrentStatus |
| Column order | 42 |
| SQL data type | nvarchar(64) |
| Kind of information | Database-constrained status value |
| Cardinality | One stored value per Unit row. |
| Required | Yes |
| Database default | No database default |
| Key or relationship | None |
| Database check constraint | ([CurrentStatus]=N'Planned' OR [CurrentStatus]=N'Status unknown' OR [CurrentStatus]=N'Historical' OR [CurrentStatus]=N'Inactive' OR [CurrentStatus]=N'Current') |
| Live population | 9341 of 9341 Unit records (100%) |
| Distinct nonblank values in the live table | 5 |
| Live profile measured | September 2, 2026, 20:43 UTC |
Allowed Values and Definitions
This field has a finite vocabulary. The table below lists every value physically stored in the live Unit table, explains it in ordinary language, gives its exact technical meaning, and shows current use.
| Stored value | Plain-language definition | Technical definition | Live Unit records |
|---|---|---|---|
| Current | Official evidence supports that the unit is presently operating. | The identity has retained current-status evidence as of the applicable review date. | 5388 |
| Status unknown | The unit identity is confirmed, but its present status has not been established. | Lifecycle state is unresolved; the value must not be interpreted as current or inactive. | 3000 |
| Historical | The unit is documented in the past, but the record does not claim it operates today. | Historical identity is retained for all-time use without asserting a current lifecycle state. | 942 |
| Inactive | Official evidence establishes that the unit was inactivated. | A documented inactivation state is present; this is stronger than mere absence from current sources. | 9 |
| Planned | The organization has been officially planned or announced but is not confirmed as activated. | Prospective identity has planning evidence but lacks completed activation or commissioning evidence. | 2 |
Missing, Unknown, and Conflicting Information
This column cannot be NULL in the Unit table. When the underlying fact is incomplete, the record must use an allowed explicit disposition or a supported evidence-derived statement. Required storage does not mean that every historical fact is known, and it never authorizes a guessed value.
Status unknown preserves an unresolved present lifecycle state. It must not be converted to Historical or Inactive without evidence.
Connections to Other Fields
- Activation or Commission Date — The documented date the unit was activated or a ship or cutter command was commissioned.
- Inactivation or Decommission Date — The documented date the unit was inactivated or a commissioned command ended.
- Effective From — The date from which the facts represented by this unit record are known to apply.
- Effective To — The date through which the represented facts are known to apply.
- Posture — How the unit is positioned for service—at home, forward, rotating, deployed, mobilized, or expeditionary.