Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HName Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the Name |
Description | varchar(90) | NULL | User can value this field to the person name. Format : First Name followed by the Last Name. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified, 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HName row |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
Title | varchar(64) | NULL | Title(e.g., Mr, Mrs, Ms) of the person. |
FirstName | varchar(30) | NULL | Person's first name |
MiddleName | varchar(30) | NULL | Person's middle name |
LastName | varchar(60) | NOT NULL | Person's last name |
AliasName | varchar(30) | NULL | Person's alias(alternate) name by which the person would like to be known or is known temporarily. |
UnStructuredName | varchar(30) | NULL | Person's name, where the name is not structured by first, middle and last name. |
GenerationQualifier | varchar(30) | NULL | Suffix used with the person's name(e.g., Jr). |
StartDateOfValidity | datetime | NULL | First date and time when the person's name is valid. |
EndDateOfValidity | datetime | NULL | Last date and time when the person's name is valid. |
Initial | varchar(64) | NULL | Initials of the person's name. |
Person_oid | int | NULL | ObjectID of the person that name is belong to. Must exist in HPerson table. |
LastCngDtime | datetime | NULL | UTC date and time when name was last changed. |
NormalizedFirstName | varchar(60) | NULL | Persons's firstName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1 |
NormalizedMiddleName | varchar(60) | NULL | Persons's MiddleName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1 |
NormalizedLastName | varchar(120) | NULL | Persons's LastName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1 |
|