Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPatientVisit Rows |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID |
RecordId | int | NULL | RecordId of the Patient |
Description | varchar(75) | NULL | User entered data during registration. It can be visit location or Unit contacted name with additional free text information. |
IsDeleted | tinyint | NOT NULL | Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted) |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the visit |
CreationTime | smalldatetime | NULL | Date and Time when the row was created. |
VisitID | varchar(30) | NULL | VisitID is a running number starting with 1 and incremented everytime a new visit is created for a patient |
AlternateVisitID | varchar(75) | NULL | Alternate Visit ID entered by the user during registration. Combination of AlternateVisitID and Account ID used to uniquely identify patient visit. |
PatientAccountID | varchar(20) | NULL | Patient Account ID entered by the user during registration. Combination of AlternateVisitID and Account ID used to uniquely identify patient visit. |
VIPIndicator | bit | NULL | Indicates if the visit is a VIP. Allowable Values: 0 - False, 1 - True(VIP Patient) |
VisitStartDateTime | datetime | NOT NULL | Date and Time when visit was started. |
VisitEndDateTime | datetime | NULL | Date and Time when patient was discharged. |
VisitStatus | tinyint | NULL | Indicates if Visit is Active(0), Closed(1), Cancelled(2), Scheduled(3), MarkedForDischarge(4) |
VisitTypeCode | varchar(30) | NULL | Visit type like IP, OP etc. Value of this field must exist as Code in HPatientClass Table. |
Debtor | varchar(64) | NULL | Debtor is a Data Dictionary Item(DDI). |
PatientCategory1 | varchar(64) | NOT NULL | Patient Category |
PatientLocationName | varchar(75) | NULL | Healthcareunitname of the Patient Location. |
Remarks | varchar(255) | NULL | Remarks or Comments related to the visit and entered by the user as a free text. |
VisitCategory | varchar(64) | NOT NULL | Visit Category |
PrivacyText | varchar(50) | NULL | Additional free text comments related to the patient visit entered by the user. |
PatientReasonForSeekingHC | varchar(255) | NULL | Indicates Chief Complaint |
PaymentMode | varchar(64) | NULL | Payment Mode |
Financialclass | varchar(64) | NULL | Financial class |
ProviderGenderPreference | tinyint | NULL | Not Used |
ExpectedLengthofStay | smallint | NULL | Additional comments entered by the user with expected days of stay for the visit. |
ActualLengthofStay | smallint | NULL | Additional comments entered by the user during discharge with actual days of stay.(Not commonly used). |
CorrectedBy | varchar(255) | NULL | Not used |
Comments | varchar(120) | NULL | Additional Comments or Remarks related to the visit and entered by the user as a free text. |
LatestBedName | varchar(75) | NULL | Name of the most current bed occupied by the patient. |
DeltaValue | int | NULL | Delta value of the Visit Type. Valued by the client in ADT preferences. |
UnitContactedName | varchar(75) | NULL | Healthcareunitname of the Unit Contacted. |
VisitLocation | varchar(64) | NULL | Visit Location |
ReasonForVisit | varchar(64) | NULL | Reason For Visit |
DischargeDisposition | varchar(64) | NULL | Discharge Disposition |
IsolationIndicator | varchar(64) | NULL | IsolationIndicator |
PatientCondition | varchar(64) | NULL | PatientCondition |
EntityName | varchar(75) | NULL | Name of the Healthcare Entity. |
EntityAbb | varchar(10) | NULL | Abbreviation of the Healthcare Entity. |
AccommodationType | varchar(64) | NULL | AccommodationType |
DischargeFormID | int | NULL | Patient ID used during discharge process. This field can be valued to Objectid of HPatientIdentifiers table pointed to the specific ID type.(example: SSN#). |
Patient_oid | int | NOT NULL | ObjectID of the patient. Related to the objectID from HPatient table. |
UnitContacted_oid | int | NULL | ObjectID of the HCU that was contacted during registration. Related to Objectid in HHealthcareUnit table. |
ReferringInstitution_oid | int | NULL | Referring institution ObjectID. Related to the Objectid in HReferringInstitution table. |
PatientLocation_oid | int | NULL | ObjectID of the HCU where patient is located. Related to the Objectid in HHealthcareUnit table. |
PatientClass_oid | int | NOT NULL | Visit type objectid related to the ObjectID in HPatientClass table. |
Entity_oid | int | NULL | Entity of the visit. Related to the ObjectID from HHealthcareUnit table for the Entity. |
PatientVisitExtension_oid | int | NULL | ObjectID from HExtendedPatientVisit |
ClinicCode | varchar(64) | NULL | Clinic Code is a DDI. |
DNRValue | varchar(64) | NULL | DNRValue. Not commonly used. |
Confidentiality | varchar(64) | NULL | Confidentiality |
DischargeTo | varchar(64) | NULL | DischargeTo |
ExternalMidWife | varchar(64) | NULL | ExternalMidWife |
TypeCode | int | NULL | Visit type code. Allowable value : 2 - Service. |
DischargeTypeCode | varchar(64) | NULL | Discharge Type Code |
Weight | float(53) | NULL | Not Used |
VentilatorTime | float(53) | NULL | Not Used |
Complication | bit | NULL | Not Used |
AdmissionType | varchar(64) | NULL | Not Used |
ReasonforDischarge | varchar(64) | NULL | Reason for Discharge |
StartingVisitOID | int | NULL | This field is always valued and it can be the same as Initial Visit Objectid or can point to the Parent Visit Oid. |
PatientStatusCode | varchar(255), | | Patient Status Code |
PublicityIndicator | varchar(64) | NULL | Publicity Indicator. |
CriticalCare | tinyint, | | Indicates if the visit Is a CriticalCare, Was a Critical Care or Never a Critical Care. Allowable Values: 0 - False 1 - True |
LastCngDtime | datetime | NULL | System UTC date /time when row was updated. |
AdmitReasoncode | varchar(64) | NULL | Admit Reason Code |
PreVisitDate | smalldatetime | NULL | Previous Visit Date. Can be NULL or valued to the initial visit start date and time. |
LevelOfCare | varchar(64) | NULL | Level of Care is a DDI |
ReadmissionIndicator | char(2) | NULL | Not Used |
RTLSTagId | varchar(20) | NULL | Not used |
AdmitSource | varchar(64) | NULL | Admit Source |
ReferralSource | varchar(64) | NULL | Referral Source |
PrevDschDate | smalldatetime | NULL | Not Used |
ExpAdmDTime | smalldatetime | NULL | Expected Admit Date and time. This field can be valued by the user during registration. |
ExpDschDTime | smalldatetime | NULL | Expected Discharge Date and Time. This field can be valued by the user during registration. |
PreArrivalTrackingNo | varchar(30) | NULL | Unique visit identifier for Pre-Arrival - Auto generated by system |
PreArrivalMergeStatus | varchar(10) | NULL | Status of Merge. Can be valued to Null Or "Not_Merged". |
RegistrationStatus | varchar(10) | NULL | Track the progression of the pre-arrival. Values are No_Reg, Scheduled, Quick_Reg, Full_Reg, No_Show. |
ModeOfArrival | varchar(64) | NULL | Patient Arrival Mode. Examples: Ambulance, car, etc. |
TransportAgency | varchar(64) | NULL | Transport Agency |
IsNotInterfaceable | smallint | NULL | Field to indicate orders or results that can be assigned. Allowable Values: 1 - True , Null - not valued. |
SpecialNeeds | varchar(64) | NULL | Indication if the patient has any special needs for an appointment. |
RestrictionIndicator | varchar(64) | NULL | Indicator of the visit restrictions. |
IsAmbulatory | tinyint | NULL | Indicates whether visit is Ambulatory. Allowable Values: 1 - True(Ambulatory visit), 0 - False(Not Ambulatory visit), Null - not valued. |
ClinicOrg_oid | int | NULL | Valued to oid of the organization unit when ClinicCode holds a valid ExternalHCU value |
ClinicOrgName | varchar(75) | NULL | Valued to the name of the organization unit when ClinicCode matches valid ExternalHCU value. |
PresentingVisitType | varchar(30) | NULL | Initial Visit Type of when the Visit was created |
PresentingDateTime | datetime | NULL | Initial Visit Date time of when the visit was created |
ChiefComplaintCode | varchar(20) | NULL | Code for Chief Complaint of the patient's visit. |
ChiefComplaintCodingSystem | varchar(20) | NULL | Coding system for the chief complaint code. For Example SNM(SNOMED). |
IsOnLeaveOfAbsence | bit | NULL | Indicates if the patient is on a Leave of Absence(LOA) |
AdmitReasonText | varchar(255) | NULL | Admit reason for the patient |
AdmitReasonCodingSystem | varchar(20) | NULL | Admit reason coding system for the patient |
HIEConsent | varchar(3) | NULL | Health Information Exchange(HIE) Consent. Can be Null or valued by the user during registration. |
|