Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HIDDocuments Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Not Used |
Description | varchar(80) | NULL | Not Used |
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 HIDDocuments row. |
CreationTime | smalldatetime | NULL | Date and Time when the row was created. |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
Value | varchar(30) | NULL | Person's unique identity number. |
Type | varchar(64) | NULL | Type of identity number used as the person's identity(SSN, Driver License Number, etc). |
AssigningAuthority | varchar(10) | NULL | Assigning authority who has authority to assign the person's unique identity number. |
AssigningAuthorityType | char(6) | NULL | Assigning authority type. Allowable Values: H, N, or NULL |
ValidOn | datetime | NULL | The date and time from which the person's unique identity number is valid. |
ExpiresOn | datetime | NULL | The date and time on which the person's unique identity number expires. |
Person_oid | int | NOT NULL | Object ID of the associated Person object. |
VerificationKey | varchar(30) | NULL | Verification key as entered by the user. |
VerificationKeyType | char(6) | NULL | Type of the verification key entered by the user. |
IDNumber | Varchar(30) | NULL | Person's unique identity number. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|