Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HName Contains person's name information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HName Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Name
Descriptionvarchar(90)NULL User can value this field to the person name. Format : First Name followed by the Last Name.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified, 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HName row
CreationTimesmalldatetimeNULL Date and Time when row was created.
Titlevarchar(64)NULL Title(e.g., Mr, Mrs, Ms) of the person.
FirstNamevarchar(30)NULL Person's first name
MiddleNamevarchar(30)NULL Person's middle name
LastNamevarchar(60)NOT NULL Person's last name
AliasNamevarchar(30)NULL Person's alias(alternate) name by which the person would like to be known or is known temporarily.
UnStructuredNamevarchar(30)NULL Person's name, where the name is not structured by first, middle and last name.
GenerationQualifiervarchar(30)NULL Suffix used with the person's name(e.g., Jr).
StartDateOfValiditydatetimeNULL First date and time when the person's name is valid.
EndDateOfValiditydatetimeNULL Last date and time when the person's name is valid.
Initialvarchar(64)NULL Initials of the person's name.
Person_oidintNULL ObjectID of the person that name is belong to. Must exist in HPerson table.
LastCngDtimedatetimeNULL UTC date and time when name was last changed.
NormalizedFirstNamevarchar(60)NULL Persons's firstName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1
NormalizedMiddleNamevarchar(60)NULL Persons's MiddleName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1
NormalizedLastNamevarchar(120)NULL Persons's LastName stripped of special characters and accent characters transformed to their eqivalent base characters as per ISO 8859-1

Return to Table-Index

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