Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HIDDocuments Collection of different person's identity numbers (SSN, Driver License Number, etc)
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HIDDocuments Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used
Descriptionvarchar(80)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HIDDocuments row.
CreationTimesmalldatetimeNULL Date and Time when the row was created.
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
Valuevarchar(30)NULL Person's unique identity number.
Typevarchar(64)NULL Type of identity number used as the person's identity(SSN, Driver License Number, etc).
AssigningAuthorityvarchar(10)NULL Assigning authority who has authority to assign the person's unique identity number.
AssigningAuthorityTypechar(6)NULL Assigning authority type. Allowable Values: H, N, or NULL
ValidOndatetimeNULL The date and time from which the person's unique identity number is valid.
ExpiresOndatetimeNULL The date and time on which the person's unique identity number expires.
Person_oidintNOT NULL Object ID of the associated Person object.
VerificationKeyvarchar(30)NULL Verification key as entered by the user.
VerificationKeyTypechar(6)NULL Type of the verification key entered by the user.
IDNumberVarchar(30)NULL Person's unique identity number.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates