What This Field Means
The documented number of people actually assigned to the unit at a particular time.
This is the documented number of people assigned to the unit for a stated reporting period. Comparing it with authorized strength can reveal whether the organization was staffed below, at, or above its designed level.
How to Read It Correctly
Assigned personnel is not necessarily the number present, deployed, attached, available, or on duty that day. It must not be treated as a permanent characteristic of the unit.
Example
Assigned strength reported for a specific roster or reporting period.
Technical Specification
The database column is [USMIL-Unit].[Unit].[AssignedPersonnel]. Optional integer assigned-strength measure. It requires an effective date or source context and must not be treated as permanent strength.
Store a whole-number count with source and date context. If a report mixes assigned, attached, civilian, reserve, or contractor personnel, preserve that distinction rather than placing an ambiguous total here.
| Property | Definition or current value |
|---|---|
| Database column | AssignedPersonnel |
| Column order | 27 |
| SQL data type | int |
| Kind of information | Whole-number measurement or count |
| Cardinality | One stored value per Unit row. |
| Required | No; NULL is permitted |
| 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 | 22 of 9341 Unit records (0.24%) |
| Distinct nonblank values in the live table | 20 |
| 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
A database NULL is permitted and means that no value is presently stored. It does not prove that the fact never existed, that the answer is no, or that the concept does not apply. Missing information must remain visibly different from a supported negative or inapplicable conclusion.
Connections to Other Fields
- Authorized Personnel — The number of positions the unit is officially designed or permitted to have.
- Assigned Composition — Organizations or personnel formally assigned to the unit even though they may not be organic to its standard structure.
- 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.
- Primary Evidence — The principal retained source supporting the unit’s identity in this record.