Trade Register Structure Modeling

This page defines the factual fields used in the proposed Trade Register data structure.

Examples are intentionally omitted.

Table	Field	Requirement	Description
registered_subject	subject_id	Required / PK	Internal Trade Register subject identifier.
	issuing_reference	Required / Indexed	Unique reference at registration authority level.
	subject_identifier	Required / Indexed	Globally unique reference starting with the issuing country code and optional state code, and including check digits.
	issuing_jurisdiction	Required	Jurisdiction code.
	subject_from	Required	UTC date-time from which the subject record applies.
	subject_to	Optional	UTC date-time until which the subject record applied. Empty means currently valid.
subject_classification	classification_id	Required / PK	Internal identifier for the classification record.
	sc_subject_id	Required / FK	Reference to the registered subject.
	main_type	Required	Recorded main type of the registered subject.
	legal_form	Required	Recorded legal form of the registered subject.
	issuing_status	Required	Status as recorded in the issuing jurisdiction.
	global_status	Optional	Corresponding international standardized status.
	classification_from	Required	UTC date-time from which the classification applies.
	classification_to	Optional	UTC date-time until which the classification applied. Empty means currently valid.
subject_name	name_id	Required / PK	Internal identifier for the name record.
	sn_subject_id	Required / FK	Reference to the registered subject.
	name_type	Required	Classification of the name, such as legal, legalized, or trade.
	name_value	Required	Recorded name value.
	is_case_sensitive	Required	Indicates whether uppercase and lowercase letters are distinguished.
	name_from	Required	UTC date-time from which the name applies.
	name_to	Optional	UTC date-time until which the name applied. Empty means currently valid.
primary_trade_name	primary_name_id	Required / PK	Internal identifier for the primary trade name designation.
	ptn_subject_id	Required / FK	Reference to the registered subject.
	ptn_name_id	Required / FK	Reference to the name record designated as primary trade name.
	primary_from	Required	UTC date-time from which the name is designated as primary.
	primary_to	Optional	UTC date-time until which the name was primary. Empty means currently primary.
subject_year_end	year_end_id	Required / PK	Internal identifier for the subject year-end designation.
	sye_subject_id	Required / FK	Reference to the registered subject.
	year_end_month	Required	Month in which the subject's financial year ends.
	year_end_day	Required	Day of the month on which the subject's financial year ends.
	year_end_from	Required	UTC date-time from which this year-end applies.
	year_end_to	Optional	UTC date-time until which this year-end applied. Empty means currently applicable.
subject_location	location_id	Required / PK	Internal identifier for the subject location record.
	sl_subject_id	Required / FK	Reference to the registered subject.
	sl_name_id	Optional / FK	Reference to the trade name associated with this location.
	street_address1	Optional	Primary street address line.
	street_address2	Optional	Additional street address line.
	postal_code	Optional	Postal or ZIP code.
	city	Optional	City or locality.
	state_region	Optional	State, province, or region.
	country_code	Optional	ISO 3166-1 alpha-2 country code.
	location_from	Required	UTC date-time from which the location applies.
	location_to	Optional	UTC date-time until which the location applied. Empty means currently valid.
subject_attribute	attribute_id	Required / PK	Internal identifier for the subject attribute record.
	sa_subject_id	Required / FK	Reference to the registered subject.
	sa_code	Required	JSON layered field identifying the attribute.
	sa_value	Optional	The provided attribute value. Empty means the value is not provided.
	sa_person_confidential	Required	Disclosure limited to authorized recipients.
	sa_consent_required	Required	Disclosure requires consent from the person.
	attribute_from	Required	UTC date-time from which the attribute applies.
	attribute_to	Optional	UTC date-time until which the attribute applied. Empty means currently valid.
subject_responsible	responsible_id	Required / PK	Internal identifier for the responsible party record.
	sr_subject_id	Required / FK	Reference to the registered subject.
	responsible_subject_code	Required / Indexed	Subject code identifying the responsible natural person. The code begins with the ISO 3166-1 alpha-2 country code.
	responsible_name	Required	Recorded name of the responsible party.
	responsible_role	Required	Role of the responsible party in relation to the registered subject.
	authority_to_represent	Optional	Indicates whether the responsible party has authority to represent the registered subject.
	responsible_from	Required	UTC date-time from which the responsibility applies.
	responsible_to	Optional	UTC date-time until which the responsibility applied. Empty means currently valid.
subject_relationship	relationship_id	Required / PK	Internal identifier for the subject relationship record.
	from_subject_id	Required / FK	Reference to the subject from which the relationship is defined.
	to_subject_id	Required / FK	Reference to the subject to which the relationship applies.
	relationship_type	Required	Type of relationship between the registered subjects.
	relationship_from	Required	UTC date-time from which the relationship applies.
	relationship_to	Optional	UTC date-time until which the relationship applied. Empty means currently valid.
subject_relationship_attribute	relationship_attribute_id	Required / PK	Internal identifier for the subject relationship attribute record.
	sra_relationship_id	Required / FK	Reference to the subject relationship.
	sra_type	Required	Type of attribute describing the relationship.
	sra_value	Required	Value of the relationship attribute, interpreted according to its type.
	relationship_attribute_from	Required	UTC date-time from which the attribute value applies.
	relationship_attribute_to	Optional	UTC date-time until which the attribute value applied. Empty means currently valid.