Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAddress Contains person's Address information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique ObjectID of each row generated by Architecture. Primary key.
InstanceHFCIDsmallintNOT NULL Instance HFCID generated by Architecture
RecordIdintNULL This can be valued to Record ID of the person.
Descriptionvarchar(80)NULL Free text entered by user.
IsVersionedbitNOT NULL Indicates if the row was modified. Allowable Values: 0 - Not Modified, 1 - Modified
CreatedUserIdintNULL User ID that created initial row.
CreationTimesmalldatetimeNULL Date and Time when row was created.
StreetAddressvarchar(255)NULL Street Address(address Line 1)
PostalCodevarchar(10)NULL Postal code / Zip code
POBoxNovarchar(50)NULL PO Box
CityDistrictvarchar(50)NULL City District
Cityvarchar(64)NULL City
Countryvarchar(64)NULL Country Name
AreaofCountryvarchar(50)NULL State
UnstructuredAddressLinevarchar(50)NULL Unstructured Address Line
PhoneNovarchar(30)NULL Telephone number
FaxNovarchar(30)NULL Fax number
EMailAddressvarchar(320)NULL E-mail address
StartDateofAddressValiditydatetimeNULL Starting date and Time of address validity
EndDateofAddressValiditydatetimeNULL Ending date and time of address validity(null or 1899-12-30 00:00:00.000 are valid)
IsMailingAddressbitNULL Indicates if address is a mailing address. Allowable Values: 0 - Not Mailing, 1 - Yes, Mailing address.
Municipalityvarchar(64)NULL Municipality
Countyvarchar(64)NULL County
AddressTypetinyintNULL Type of an address. Allowable values: 0-Permanent Home,1-temporary Home, 2-Office, 3-Other, 4-Birth, 5-Country of origin, 6-legal, 7-mailing, 8-business
PrimaryCareAreaCodevarchar(64)NULL Primary Care Area Code
Communityvarchar(64)NULL Community
CityZonevarchar(50)NULL City Zone
Remarksvarchar(255)NULL Remarks - Free text comments.
OtherGeographicDesignationvarchar(50)NULL Other Geographic Designation
PhoneCountryCodevarchar(6)NULL Phone Country code. Normally would be 1 for USA
PhoneAreaCodevarchar(6)NULL Phone Area Code(3 digits number for USA)
FaxCountryCodevarchar(6)NULL Fax Country code. Normally would be 1 for USA
FaxAreaCodevarchar(6)NULL Fax Area Code(3 digits number for USA)
Person_oidintNULL ObjectId of the person(Patient, staff member, NOK(Next of Kin) to the patient, etc) who the address belongs to. Must exist in HPerson table.
LastCngDtimedatetimeNULL Last system date /time when row was updated.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates