Glossary
Valid time
Valid time is the period during which a statement applies in the world being represented.
Time and versioning
Valid time answers when a fact held in the represented domain, according to the available evidence. It may be a point, an interval, an open-ended period, or unknown. A contract effective date, for example, can differ from the date the contract was signed, received, or entered into a system. Valid time is a property of the assertion being made, so two assertions from the same document can have different valid periods.
A practical record names the source and the rule used to interpret its temporal language. Retroactive amendments and notices received late require particular care: they may alter the current account of an earlier interval. An unknown start or end should remain unknown rather than being replaced by the first or last date on a file. Explicit interval boundaries make overlap and succession checks interpretable across systems.
For a defensible decision, valid time identifies whether a value applied on the decision's target date. It does not identify when the organization learned that value; transaction time serves that separate question. Pairing the two avoids projecting today's corrected understanding into a past information state. An as-of query can then specify the date being assessed while making clear which recorded knowledge state it uses.
Example
A licence for Halden Therapeutics AG (fictional) is received on 12 March but states that it takes effect on 1 March; 1 March begins its valid period.
What valid time covers and what it does not
Valid time describes when a statement is true of the world. It belongs to the fact and is independent of any system: a lease that ran from 1 March 2023 to 28 February 2026 had that period before anyone wrote it down. Martin Fowler describes this as the actual history in his note on bitemporal history, and the Time Ontology in OWL provides web vocabulary for instants, intervals and their relations. Periods may be open-ended, as when a role is held until further notice, and may be uncertain, as when only the month is known.
Valid time is often confused with other dates attached to a record. The date a document was published, the date an observer saw something, and the date a record was entered are all different from the period during which the fact held. The article on valid time, transaction time and other clocks separates five such clocks and shows the errors that arise when they are conflated, including the common error of treating the publication date of a statement as the date from which it applies.
Representing and querying periods
A period needs a start, an end and a convention. Half-open intervals, which include the start and exclude the end, avoid the gaps and overlaps that occur when one period ends on the day another begins. Dates and times should follow a standard format such as that in RFC 3339, with a stated time zone where times matter. Where the true boundary is unknown, record the earliest and latest possible values and not a guess. Interval relations such as before, overlaps and during, formalised in the temporal reasoning literature, are the basis of queries like which statements were true at the same time.
Constraints help. For a property that can have only one value at a time, such as legal name, the periods for that entity and property should not overlap; a check for overlaps finds data errors. For properties that can have several values, such as directors, overlap is normal. The Wikipedia article on temporal databases surveys these ideas. Where a source gives no period, the claim should say so and should not be assigned the retrieval date as its start.
A worked example
Halden Therapeutics AG (fictional) leases an office. A lease document says the term runs from 1 March 2023 for three years. An amendment signed in June 2024 extends the term by two years. The valid time of the original lease statement is 1 March 2023 to 28 February 2026; the amendment gives a new statement valid from 1 March 2023 to 28 February 2028, and the system must decide whether the amendment replaces the original or is a correction of the system's belief. A bitemporal view keeps both: as of June 2023 the end date was February 2026; as of July 2024 it is February 2028. Valid time alone would show only the latest period and lose the fact that the earlier belief was held, correctly, for a year.
Checks a reviewer can run
For ten sampled facts, ask for the period during which each held and where the dates came from. Check that no date in the valid-time field is a retrieval or publication date by default. Check that the interval convention is documented and applied. Test an overlap query on a single-valued property. Test a date known to fall in a gap and confirm that the system reports no value and not the nearest one.
Related terms and boundaries
Valid time is one axis of bitemporal data, the other being transaction time. It determines whether two claims are in conflict or are consecutive, drives the choice of value in an as-of query, and, when blank, must be interpreted according to null semantics.
Common misreadings
- Equating receipt date with effective date.
- Inventing exact dates where the evidence gives only a month or an unknown bound.
- Ignoring retroactive amendments.
Appears in
- Snapshots vs bitemporal history
Snapshots preserve states at selected moments; bitemporal history distinguishes when a fact applied from when it was recorded.
- Reproducing a past state
Reconstruct what was known at a specified instant using observation time, effective time and earlier decisions.
- Anatomical Therapeutic Chemical (ATC) classification
A hierarchical classification for substances used in drug-utilization research.
- ClinicalTrials.gov identifier (NCT number)
A stable identifier for a clinical study record on ClinicalTrials.gov.
- D-U-N-S Number
A proprietary nine-digit identifier for a business location in Dun & Bradstreet data.
- EU consolidated financial sanctions list
A consolidated EU data source for persons and entities subject to financial sanctions.
- Global Location Number (GLN)
A GS1 identifier for parties and locations in business processes.
- ISO 3166 country codes
Codes for countries, dependent territories, and subdivisions under ISO 3166.
- ISO 4217 currency codes
Alphabetic and numeric codes for currencies and certain funds.
- ISO 8601 date and time representation
A standard for representing dates, times, intervals, and related temporal values.
- Market Identifier Code (MIC)
An ISO code for a trading venue or market segment.
- NACE classification
The European Union's statistical classification of economic activities.
- National Drug Code (NDC)
A U.S. identifier for a listed drug product and package configuration.
- North American Industry Classification System (NAICS)
A hierarchical industry classification for establishments in North America.
- OFAC Specially Designated Nationals and Blocked Persons List
A U.S. sanctions list of designated persons and entities published by OFAC.
- Unique Entity ID (UEI)
The entity identifier generated by SAM.gov for U.S. federal awards.
- VAT identification number
A jurisdiction-specific tax registration identifier used in value-added tax administration.
References
- Snodgrass, Developing Time-Oriented Database Applications in SQL (1999).
- Fowler, Bitemporal History.
- W3C (2022), Time Ontology in OWL.
- IETF (2002), RFC 3339: Date and Time on the Internet: Timestamps.
- Wikipedia, Temporal database.
Found an error on this page? See corrections for what counts as one, how to report it and the dated log.
Enquiry
Where does "Valid time" bear on a decision of yours?
This entry sits under time and versioning. If a decision in your organization turns on it, send the entity concerned, the sources you fuse to describe it and who may read which of them. We reply with what a first record would cover.
Or write to [email protected] in your own words.