Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPerson Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the Patient |
Description | varchar(90) | NULL | Not used |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
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 HPerson row |
CreationTime | smalldatetime | NULL | Creation Date and Time of the row creation |
Sex | tinyint | NULL | Gender of the Person. Allowable Values: 0 - Male, 1 - Female, 3 - Unknown |
Religion | varchar(64) | NULL | Religion is a Data DictionaryItem(DDI). |
Nationality | varchar(64) | NULL | Nationality is a DDI. |
MotherMaidenName | varchar(30) | NULL | Mother Maiden Name |
MotherIdentifier | varchar(20) | NULL | Mother Identifier entered by user. It can be valued to SSN. |
Race | varchar(255) | NULL | Race is a DDI item where Item Type Code is "Person.Race" |
MaritalStatus | varchar(64) | NULL | Marital Status is a DDI item entered by client. As an example Item Type Code can be "Person.MaritalStatus" |
PagerNo | varchar(30) | NULL | Person Pager Number entered by user. |
MobilePhoneNo | varchar(30) | NULL | Person Mobile Phone Number entered by user. |
BirthDate | datetime | NULL | Birth Date of the Person |
MobileCountryCode | varchar(6) | NULL | Country Code for the Mobile Phone Number |
MobileAreaCode | varchar(6) | NULL | Area Code for the Mobile Phone Number |
PagerCountryCode | varchar(6) | NULL | Country Code for the Pager Number |
PagerAreaCode | varchar(6) | NULL | Area Code for the Pager Number |
BirthTime | datetime | NULL | Birth Time of the Person |
LastCngDtime | datetime | NULL | System UTC date /time when row was updated. |
Ethnicity | varchar(255) | NULL | Ethnicity.May contain up to three ethnicities, separated by comma. Each Ethnicity is a DDI item where Item Type Code is "Person.Ethnicity" |
IsDOBEstimated | smallint | NULL | Indicates whether DOB is estimated or not. 0: means DOB is not estimated, 1: means DOB is estimated. |
MaidenOrAliasLastName | varchar(60) | NULL | Maiden or Alias Last Name. |
BirthSex | tinyint | NULL | Gender of the Person at birth. Allowable Values: 0 - Male, 1 - Female, 3 - Unknown |
GenderIdentity | varchar(64) | NULL | Gender Identity of the Person. This is a DDI item with item type code "Person.GenderIdentity". |
SexualOrientation | varchar(64) | NULL | Sexual Orientation of the Person. This is a DDI item with item type code "Person.SexualOrientation". |
PreferredName | varchar(128) | NULL | The name that patient preferred to use during registration. |
IDAlias | varchar(32) | NULL | This is used as FHIR patient resource logical-Id that needs to be unique. |
|