Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCensusPatientList Contains list of patients/Visits to be displayed in the census.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique ObjectId generated by Architecture.
InstanceHFCIDsmallintNOT NULL Instance HFCID generated by Architecture
RecordIdintNULL Not Used
Descriptionvarchar(1)NULL Mostly not used , but can be valued to the Census type by client.
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the row.
CreationTimesmalldatetimeNULL Date and Time when row was created.
PatientOIDintNULL ObjectID of the patient. Must exist in HPatient table.
Initialvarchar(64)NULL Not Used
GenerationQualifiervarchar(30)NULL Suffix used with the person's name(e.g., Jr).
LastNamevarchar(60)NULL Last name of the patient
FirstNamevarchar(30)NULL First Name of the patient
MiddleNamevarchar(30)NULL Middle Name of the patient
SextinyintNULL Gender of the patient
BirthDatedatetimeNULL Date of birth of the patient.
EntityNamevarchar(75)NULL Entity name for the patient visit.
EntityAbbvarchar(10)NULL Entity abbreviation for the patient visit.
VisitOIDintNULL ObjectID of the visit. Must exist in HPatientvisit table.
VisitStartDateTimedatetimeNULL Visit start date and time.
VisitEndDateTimedatetimeNULL Visit End date and time.
VIPIndicatorbitNULL Indicates if patient or visit is a VIP. Allowable Values: 0 - False, 1 - True
PatientLocationNamevarchar(75)NULL Patient visit location name. HCU entry must exist in HHealthcareUnit Table.
LatestBedNamevarchar(75)NULL Patient visit bed name. Must be valid name in HBed table.
PurgeDatedatetimeNULL The date and time when entry should be purged. This depends on how client set up the number of days in HCensusConfigItems table.
IsolationIndicatorvarchar(64)NULL Selected by the user during patient registration. This is DDI item.
VisitStatustinyintNULL Status of the visit. The same as in HPatientvisit table.
PatientLocationOIDintNULL Patient visit location objectid.
UnitContactedOIDintNULL Patient visit unit contacted objectid.
VisitTypevarchar(30)NULL Type of the visit. The same as in HPatientvisit table.
StaffOIDintNULL Staff member associated with the patient.
RelationTypetinyintNULL Relation between the patient and staff member.
0-AttendingDoctor, 1-PrimaryPhysician, 2-ReferringDoctor, 3-ConsultingDoctor, 4-AdmittingDoctor, 5-OperatingDoctor,
6-DischargingDoctor, 7-ResponsibleDoctor,8-DeathDeclaredDoctor,9-OtherCareGiver,10-AdditionalDoctor,11-DeathApprovedDoctor,
12-CoveringDoctor,13-Census,14-NurseAssignment, 15-LetterCosigner, 16-LetterTypist,17-Resident,18-OtherDoctors,19-CareTeamProvider, 20-ORDERING,21-PCMH
AssociationStartDatedatetimeNULL Date when staff/patient association started.
AssociationEndDatedatetimeNULL Date when staff/patient association ended.
EntityOIDintNULL Entity Objectid for the patient visit.
LikeIPtinyint, Indicates that visit is like IP type. Allowable Values: 0 - False, 1 - True
DeathIndicatorbitNULL Indicates that patient is deceased. Allowable Values: 0 - False, 1 - True
EntitySeqNointNULL Sequential number from HHealthcareunit Table for the visit entity.
UnitSeqNointNULL Sequential number from HHealthcareunit Table for the visit unit.
BedSeqNointNULL Sequential number from HBed Table for the visit bed.
PatientStatusCodevarchar(255), Patient status code from the visit
PublicityIndicatorvarchar(64)NULL Publicity indicator for the visit. It is valued by user during registration.
AlternateVisitIDVarchar(75)NULL Patient Alternate Visit ID.
MRUAbbreviationVarchar(10)NULL Represents visit Unit Contacted abbreviation.
ExternalPatientIDvarchar(20)NULL Medical Record number for the patient.
MPINumbervarchar(20)NULL Master Patient Index(MPI) .
PatientAccountIDvarchar(20)NULL Account ID for the patient visit.
TempLocationNamevarchar(64)NULL Patient temporary location name.
LastCngDTimedatetimeNULL System UTC date /time when row was updated.

Return to Table-Index

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