What This Field Means
The number of recognized subordinate unit records currently connected beneath this unit.
This is the number of subordinate unit records currently connected beneath the unit in the represented hierarchy. It gives a quick sense of how much of the organization’s structure is already represented on the site.
How to Read It Correctly
A zero does not prove that the real organization had no subordinates. It can mean that no subordinate records are currently connected, that the structure has not yet been researched, or that subordinate elements fall outside the chosen representation.
Example
A wing record may count its directly represented groups or squadrons.
Technical Specification
The database column is [USMIL-Unit].[Unit].[SubordinateUnitCount]. Required materialized integer count with a default of zero. Zero means no subordinate records are presently counted, not necessarily that the organization historically had none.
Store a whole-number count of represented subordinate unit records. The database defaults to zero; the value should be recalculated from the authoritative hierarchy rather than guessed from doctrine or a historical table of organization.
| Property | Definition or current value |
|---|---|
| Database column | SubordinateUnitCount |
| Column order | 22 |
| SQL data type | int |
| Kind of information | Whole-number measurement or count |
| Cardinality | One stored value per Unit row. |
| Required | Yes |
| Database default | ((0)) |
| 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 | 37 |
| Live profile measured | September 2, 2026, 20:43 UTC |
Allowed Values and Definitions
No preset menu applies to this field. It stores an identifier, relationship, measurement, date, timestamp, or evidence-derived narrative. Valid content is governed by the SQL type, key relationship, nullability, retained evidence, and the field-specific recording rule above. A list of observed contents would be data, not a list of allowed options.
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.
Connections to Other Fields
- Parent Unit — The immediate higher organization under which the unit is placed in this record.
- Organic Composition — The people or subordinate organizations that belong to the unit by its normal design rather than by a temporary assignment.
- Assigned Composition — Organizations or personnel formally assigned to the unit even though they may not be organic to its standard structure.
- Attached Composition — Organizations temporarily placed with the unit for support, control, or a particular mission.
- Normalized Unit Scale — A broad comparison level that helps relate differently named organizations across the services.