What This Field Means
When this unit record was first added to the guide’s underlying record system.
This records when the database row was first created. It supports audit trails, ingestion review, and reconstruction of how the catalog grew.
How to Read It Correctly
Creation time is not the unit’s activation, constitution, commissioning, first historical appearance, or effective start date. A Civil War unit can have a database creation timestamp from 2026.
Example
2026-09-02 18:51:42 UTC.
Technical Specification
The database column is [USMIL-Unit].[Unit].[CreatedUTC]. Required UTC creation timestamp with a database default. It records database provenance, not the unit’s activation date.
The database supplies a UTC timestamp automatically when the row is inserted. Preserve it as system provenance; corrections to historical facts must not rewrite the original creation time.
| Property | Definition or current value |
|---|---|
| Database column | CreatedUTC |
| Column order | 56 |
| SQL data type | datetime2(0) |
| Kind of information | UTC database audit timestamp |
| Cardinality | One stored value per Unit row. |
| Required | Yes |
| Database default | (sysutcdatetime()) |
| 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 | 1882 |
| 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
- Record Updated Time — When the unit record was most recently revised as evidence or understanding changed.
- Process Version — The documented research or review method that produced the present record.
- Activation or Commission Date — The documented date the unit was activated or a ship or cutter command was commissioned.
- Effective From — The date from which the facts represented by this unit record are known to apply.
- Primary Evidence — The principal retained source supporting the unit’s identity in this record.