Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPatientIdentifiers 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 | This field can be Null or user can put the patient name there(Often when entering MPI number). |
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 HPatientIdentifiers row |
CreationTime | smalldatetime | NULL | Date and time when HPatientIdentifiers row is created. |
TYpe | varchar(64) | NULL | Type of the patient identifier like MRN,MPI,SSN or any DDI item created by the client(ItemTypeCode = "Person.IDDocument.Type") |
Value | varchar(30) | NULL | Value associated with the type of the patient identifier. This can be any value entered by user during patient registration. |
AssigningAuthorityType | varchar(6) | NULL | Type of assigning authority associated with the patient identifier. |
| | | Allowable Values: H - Healthcare Entity or Unit, N - Nonaffiliated Organization Unit(NAOU) , NULL |
AssigningAuthority | varchar(30) | NULL | Abbreviation of the internal or the external healthcare organization associated with the patient identifier. |
VerificationKeyType | varchar(6) | NULL | Type of the verification key entered by the user. The verification key can be used to verify the details of a person. It can be any value(SSN for example) or NULL. |
VerificationKey | varchar(30) | NULL | Verification key as entered by the user. The verification key can be used to verify the details of a person. |
ValidOn | datetime | NULL | The date and time from when the patient identifier is valid. |
ExpiresOn | datetime | NULL | The date and time on which the patient identifier is no longer valid. |
Patient_oid | int | NOT NULL | Patient OID same as Objectid in HPatient Table. |
EntityOID | int | NULL | The object ID of the entity associated with the patient identifier. |
EntityName | varchar(75) | NULL | The name of the entity associated with the patient identifier. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|
|