Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique ObjectID of each row generated by Architecture. Primary key. |
InstanceHFCID | smallint | NOT NULL | Instance HFCID generated by Architecture |
RecordId | int | NULL | This can be valued to Record ID of the person. |
Description | varchar(80) | NULL | Free text entered by user. |
IsVersioned | bit | NOT NULL | Indicates if the row was modified. Allowable Values: 0 - Not Modified, 1 - Modified |
CreatedUserId | int | NULL | User ID that created initial row. |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
StreetAddress | varchar(255) | NULL | Street Address(address Line 1) |
PostalCode | varchar(10) | NULL | Postal code / Zip code |
POBoxNo | varchar(50) | NULL | PO Box |
CityDistrict | varchar(50) | NULL | City District |
City | varchar(64) | NULL | City |
Country | varchar(64) | NULL | Country Name |
AreaofCountry | varchar(50) | NULL | State |
UnstructuredAddressLine | varchar(50) | NULL | Unstructured Address Line |
PhoneNo | varchar(30) | NULL | Telephone number |
FaxNo | varchar(30) | NULL | Fax number |
EMailAddress | varchar(320) | NULL | E-mail address |
StartDateofAddressValidity | datetime | NULL | Starting date and Time of address validity |
EndDateofAddressValidity | datetime | NULL | Ending date and time of address validity(null or 1899-12-30 00:00:00.000 are valid) |
IsMailingAddress | bit | NULL | Indicates if address is a mailing address. Allowable Values: 0 - Not Mailing, 1 - Yes, Mailing address. |
Municipality | varchar(64) | NULL | Municipality |
County | varchar(64) | NULL | County |
AddressType | tinyint | NULL | 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 |
PrimaryCareAreaCode | varchar(64) | NULL | Primary Care Area Code |
Community | varchar(64) | NULL | Community |
CityZone | varchar(50) | NULL | City Zone |
Remarks | varchar(255) | NULL | Remarks - Free text comments. |
OtherGeographicDesignation | varchar(50) | NULL | Other Geographic Designation |
PhoneCountryCode | varchar(6) | NULL | Phone Country code. Normally would be 1 for USA |
PhoneAreaCode | varchar(6) | NULL | Phone Area Code(3 digits number for USA) |
FaxCountryCode | varchar(6) | NULL | Fax Country code. Normally would be 1 for USA |
FaxAreaCode | varchar(6) | NULL | Fax Area Code(3 digits number for USA) |
Person_oid | int | NULL | 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. |
LastCngDtime | datetime | NULL | Last system date /time when row was updated. |
|