Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HStaff Contains information about staff members.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectID of the staff created
InstanceHFCIDsmallintNOT NULL InstanceHFCID of the staff created
RecordIdintNULL Not Used.
Descriptionvarchar(187)NULL Description about the staff created. User can value this field to the staff name(Format: First,Middle,Last).
IsVersionedbitNOT NULL Describes about the row is modified or not. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserID of the person who created the staff record.
CreationTimesmalldatetimeNULL Date and Time when the staff record is created.
StaffIDvarchar(30)NOT NULL Staff's internal identifier - system generated next available number.
ExternalIDvarchar(20)NULL Staff's External Identifier - Unique identifier for external staff.
PrescriberCodevarchar(75)NULL Staff's prescriber code - DEA Number
Identifier assigned to a health care provider(such as a physician, physician assistant, nurse practitioner, optometrist, dentist, or veterinarian) by the United States Drug Enforcement Administration allowing them to write prescriptions for controlled substances.
ActivationDatesmalldatetimeNOT NULL Staff's Activation date and time - Date when staff member became active.
InactivationDatedatetimeNULL Staff's Inactivation date and time - Date when staff member became InActive.
ActivebitNULL Active indicator. Allowable Values: 0 - Not Active 1 - Active
DateEnteredPracticedatetimeNULL Date and time when the staff has started to practice.
StaffTypetinyintNOT NULL StaffType. Allowable values : 0-Medical,1-Paramedical,2-Nursing,3-Support,4-OtherStaff,5-ExternalProvider,6-ExternalProviderOrg.
IsSchedulablebitNULL describes whether the staff can be scheduled or not. Allowable values: 0 - false, 1 - True
Namevarchar(187)NOT NULL Full Name of the staff. Format : Last Name, First Name, Middle Name.
MSINumbervarchar(30)NULL Staff's MSI number
StaffSignaturevarchar(75)NULL Staff Signature
Remarksvarchar(255)NULL Any remarks about the staff entered by admin user.
IsUserbitNULL Denotes whether this staff is also a user or not. Allowable values : Null - not valued, 0 - false, 1 - True
PrimarySpeciality_oidintNULL The objectid of primary speciality DDI's objectID
SecondarySpeciality_oidintNULL The objectid of secondary speciality DDI's objectID
ProviderTypevarchar(64)NULL Additional ED staff types. eg, Physician,Mid-Level,Resident,Nurse etc. This is a DDI items(type Staff.ProviderType) that client can set up.
eRenewEnabledsmallintNOT NULL Staff capability to renew Rx(prescription): Available Values : 1-Yes, 0-No
EPCS_Authority_Statusvarchar(20)NULL Staff authority for e-Prescribing Controlled Substances
Available Values :
NotRequested
Requested
Approved
ApprovedandSSsync
RevokeRequested
RevokeApproved
IsSupervisorbitNULL Identifies a staff member as a supervisor. Available Values : 1-Yes, 0-No , Null - Not valued
DirectAddressvarchar(256)NULL Identifies the direct secured contact email address for a heathcare provider or Organization
PreferredContactMethodvarchar(6)NULL Preferred contact Method. Allowable Values : Email,Fax,Mail.
OrgAffiliationvarchar(256)NULL Name of the Organization provider staff is affiliated with.
HCPTaxonomy_oidintNULL Objectid of Healthcare Provider Taxonomy DDI.
HCPDeliveryDirectoryIDvarchar(16)NULL Delivery Directory ID field returned from Healthcare Provider Directory search.
eRxChangeEnabledbitNOT NULL Staff capability to change Rx(prescription) : Available Values : 1-Yes, 0-No
eRxCancelEnabledbitNOT NULL Staff capability to cancel Rx(prescription) : Available Values : 1-Yes, 0-No
eRxFillEnabledbitNOT NULL Staff capability to refill Rx(prescription) : Available Values : 1-Yes, 0-No
ExternalProviderIdVARCHAR(256)NULL Provider ID provided by document management(DM) from the the Healthcare Provider Directory(HPD).
ExternalOrganizationIdVARCHAR(256)NULL Organization ID provided by document management(DM) from the Healthcare Provider Directory(HPD)
ExternalDestinationIdINTNULL Value provided by document management(DM).
IsInvalidbitNULL Describes if the external Provider data could not be correctly refreshed or is Invalid. 1-yes(Invalid) , 0 or Null - No
Applicable Only to the External StaffTypes of 5 and 6
DmSecurityIdvarchar(64)NULL Identifies the Staff in document management. Value is the Unique Security Identifier of the Staff.
PDMPRolevarchar(64)NULL Stores additional staff attribute for Prescription Drug Monitoring Program. eg, Physician,Pharmacist etc.
PdmpTermsOfUseAcceptedDatesmalldatetimeNULL Stores date when clinician accepted Terms of Use agreement.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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