Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPatient 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(184) | NULL | Valued by the user as a name. Format : First Name, Last Name. |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted or Patient has been Merged. 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 HPatient row |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
InternalPatientID | varchar(20) | NOT NULL | A running number whose format depends on ADT Preference |
VIPIndicator | bit | NULL | Indicates if the patient is a VIP. Allowable Values: 0 - False(Not VIP), 1 - True(VIP patient) |
PatientRegistrationDate | datetime | NOT NULL | Date and time when patient was registered in the system. |
Remarks | varchar(255) | NULL | Additional comments by user during patient registration. |
InterpretTo | varchar(50) | NULL | Valued by the user during patient registration. |
Title | varchar(64) | NULL | Title is a Data DictionaryItem(DDI) |
FirstName | varchar(30) | NULL | First Name of the Patient |
MiddleName | varchar(30) | NULL | Middle Name of the Patient |
LastName | varchar(60) | NOT NULL | Last Name of the Patient |
GenerationQualifier | varchar(30) | NULL | Person generation. For example, Jr. or II. Valued by the user during patient registration. |
IsMerged | bit | NULL | Indicates if the patient is Merged. Allowable Values: 0 - Not Merged, 1 - Merged |
Confidentiality | varchar(64) | NULL | Confidentiality is a DDI |
AdvancedDirectiveonFile | varchar(64) | NULL | AdvancedDirectiveonFile is a DDI |
HasImages | bit | NULL | Indicates if there is an image attached to the patient. Allowable Values: 0 - No, 1 - Yes |
SubScriberNumber | varchar(75) | NULL | Not Used |
RegistrationType | tinyint | NULL | RegistrationType :Registration(0) ModalityRegistration(1) |
OrganDonor | varchar(64) | NULL | OrganDonor is a DDI. |
MPINumber | varchar(20) | NULL | Master Patient Index Number |
StreetAddress | varchar(255) | NULL | Street Address of Patient Permanent Home Address |
POBoxNo | varchar(50) | NULL | POBoxNo of Patient Permanent Home Address |
City | varchar(64) | NULL | City of Patient Permanent Home Address |
Country | varchar(64) | NULL | Country Patient Permanent Home Address |
DeathInformation_oid | int | NULL | When patient is deceased, this field contains the objectid to HDeathInformation table. |
PatientExtension_oid | int | NULL | ObjectID of HExtendedPatient table |
Initial | varchar(64) | NULL | Initial is a DDI. |
LivingWill | varchar(64) | NULL | LivingWill is a DDI. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
VeteranStatus | varchar(64) | NULL | VeteranStatus is a DDI. |
LivingArrangement | varchar(64) | NULL | LivingArrangement is a DDI. |
LivingDependency | varchar(64) | NULL | Not used |
IsPatientUnidentified | smallint | NULL | Indicated if the patient has been identified or Not. Allowable Values: 0 -identified, 1 - Unidentified, NULL - not valued |
GestationalAge | varchar(15) | NULL | Gestational Age of a patient(in weeks). |
PrefContactMethod | varchar(64) | NULL | Preferred Contact Method of a patient(E-mail, Phone etc.). |
PrimaryLanguage | varchar(64) | NULL | Primary Language of a Patient. |
MedHistoryConsent | varchar(64) | NULL | Patient consent to whether he/she agrees or not if a physician can review their Medication History. Valued by the user. |
| | | Allowable Values: Yes - Yes, No - No, Null - Not valued, space - Not valued. |
|