Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique ObjectId generated by Architecture. |
InstanceHFCID | smallint | NOT NULL | Instance HFCID generated by Architecture |
RecordId | int | NULL | Not Used |
Description | varchar(1) | NULL | Mostly not used , but can be valued to the Census type by client. |
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 row. |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
PatientOID | int | NULL | ObjectID of the patient. Must exist in HPatient table. |
Initial | varchar(64) | NULL | Not Used |
GenerationQualifier | varchar(30) | NULL | Suffix used with the person's name(e.g., Jr). |
LastName | varchar(60) | NULL | Last name of the patient |
FirstName | varchar(30) | NULL | First Name of the patient |
MiddleName | varchar(30) | NULL | Middle Name of the patient |
Sex | tinyint | NULL | Gender of the patient |
BirthDate | datetime | NULL | Date of birth of the patient. |
EntityName | varchar(75) | NULL | Entity name for the patient visit. |
EntityAbb | varchar(10) | NULL | Entity abbreviation for the patient visit. |
VisitOID | int | NULL | ObjectID of the visit. Must exist in HPatientvisit table. |
VisitStartDateTime | datetime | NULL | Visit start date and time. |
VisitEndDateTime | datetime | NULL | Visit End date and time. |
VIPIndicator | bit | NULL | Indicates if patient or visit is a VIP. Allowable Values: 0 - False, 1 - True |
PatientLocationName | varchar(75) | NULL | Patient visit location name. HCU entry must exist in HHealthcareUnit Table. |
LatestBedName | varchar(75) | NULL | Patient visit bed name. Must be valid name in HBed table. |
PurgeDate | datetime | NULL | The date and time when entry should be purged. This depends on how client set up the number of days in HCensusConfigItems table. |
IsolationIndicator | varchar(64) | NULL | Selected by the user during patient registration. This is DDI item. |
VisitStatus | tinyint | NULL | Status of the visit. The same as in HPatientvisit table. |
PatientLocationOID | int | NULL | Patient visit location objectid. |
UnitContactedOID | int | NULL | Patient visit unit contacted objectid. |
VisitType | varchar(30) | NULL | Type of the visit. The same as in HPatientvisit table. |
StaffOID | int | NULL | Staff member associated with the patient. |
RelationType | tinyint | NULL | 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 |
AssociationStartDate | datetime | NULL | Date when staff/patient association started. |
AssociationEndDate | datetime | NULL | Date when staff/patient association ended. |
EntityOID | int | NULL | Entity Objectid for the patient visit. |
LikeIP | tinyint, | | Indicates that visit is like IP type. Allowable Values: 0 - False, 1 - True |
DeathIndicator | bit | NULL | Indicates that patient is deceased. Allowable Values: 0 - False, 1 - True |
EntitySeqNo | int | NULL | Sequential number from HHealthcareunit Table for the visit entity. |
UnitSeqNo | int | NULL | Sequential number from HHealthcareunit Table for the visit unit. |
BedSeqNo | int | NULL | Sequential number from HBed Table for the visit bed. |
PatientStatusCode | varchar(255), | | Patient status code from the visit |
PublicityIndicator | varchar(64) | NULL | Publicity indicator for the visit. It is valued by user during registration. |
AlternateVisitID | Varchar(75) | NULL | Patient Alternate Visit ID. |
MRUAbbreviation | Varchar(10) | NULL | Represents visit Unit Contacted abbreviation. |
ExternalPatientID | varchar(20) | NULL | Medical Record number for the patient. |
MPINumber | varchar(20) | NULL | Master Patient Index(MPI) . |
PatientAccountID | varchar(20) | NULL | Account ID for the patient visit. |
TempLocationName | varchar(64) | NULL | Patient temporary location name. |
LastCngDTime | datetime | NULL | System UTC date /time when row was updated. |
|