Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HExternalHCProfessional Contains information about External Healthcare Professional
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique Architecture generated objectID of this table.
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not used
Descriptionvarchar(187)NULL Can be vaued by the user as Healthcare Professional Name. Format : First Name, Middle Name, Last Name.
IsVersionedbitNOT NULL Indicates if any changes were done on a row. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL ObjectID of the user that created the row.
CreationTimesmalldatetimeNULL Date/time of when the row is created
Namevarchar(187)NULL Name of the external healthcare professional
RegistrationNovarchar(20)NULL Registration No of the external healthcare professional
WorkPlacevarchar(255)NULL Workplace address information of the healthcare professional.
RelationTypevarchar(5)NULL Healthcare professional relation type to the patient. Entered by the user as free text. For example : PCP.
ExternalIDvarchar(20)NULL StaffID of the professional if he's registered to any affiliate hospital
ExternalStaffTypetinyintNULL Not Used.

Return to Table-Index

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