Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Architecture generated unique id for the table row |
InstanceHFCID | smallint | NOT NULL | Architecture generated instance HFC(Healthcare Foundation Class) ID. |
RecordId | int | NULL | Not used. |
Description | varchar(50) | NULL | Description of the row being created by the client. It can be valued the same as the Name. |
IsVersioned | bit | NOT NULL | Indicates whether a row has been modified or not. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | Architecture generated ID of the user who created the row. |
CreationTime | smalldatetime | NULL | Date/Time of when the row is created in the table. |
Name | varchar(30) | NULL | Name of the Visit Type set up by the client. |
| | | For example: OutPatient, InPatient, Preadmit,IP-Ward,PreReg,PreArrival,Urgent Care |
CanAllocateBed | bit | NULL | Indicates whether a bed can be allotted for a particular visit type. Allowable Values: 0 - False, 1 - True |
CanHaveLeaveofAbsence | bit | NULL | Indicates whether leave of absence is permitted for a particular visit type. Allowable Values: 0 - False, 1 - True |
CanHaveSubVisits | bit | NULL | Indicates whether sub visits can be created for a particular visit type. Allowable Values: Null- not valued, 0 - False, 1 - True |
CanHaveMultipleActiveVisits | bit | NULL | Indicates whether multiple active visits can be created of a particular visit type.Allowable Values: 0 - False, 1 - True |
CandoPatientTransfer | bit | NULL | Indicates whether transfer is allowed for a particular visit type. Allowable Values: 0 - False, 1 - True |
CanbeScheduled | bit | NULL | Indicates whether a particular visit type can be used for scheduling or not. Allowable Values: 0 - False, 1 - True |
BedcanbeReleasedonLOA | bit | NULL | Indicates whether a bed can released for leave of absence of a particular visit type. Allowable Values: Null - Not valued, 0 - False, 1 - True |
Editable | bit | NULL | Indicates whether a row is editable in the table. Allowable Values:Null - Not Valued, 0 - False, 1 - True |
Code | varchar(30) | NULL | internal code of the visit type that's created by client. |
| | | For Example: OP,Preadmit,IP,IP-Ward,PreReg,BVC. |
Active | bit | NULL | Indicates whether a row is active or not. Allowable Values: 0 - Not Active 1 - Active |
BedAllocationOptional | bit | NULL | Indicates whether bed allocation is optional or not for a visit type. Allowable Values: 0 - False, 1 - True |
CanExpireAtMidnight | bit | NULL | Indicates whether a visit can be closed automatically at midnight. Allowable Values: 0 - False, 1 - True |
CanAllowDischarge | bit | NULL | Indicates whether a particular visit type can be allowed to discharge or not. Allowable Values: 0 - False, 1 - True |
LikeIP | bit | NULL | Indicates whether a visit type is Like Inpatient or not. Allowable Values: 0 - False, 1 - True |
DeltaValue | int | NULL | Value in this column specifies how long the visit info can be retained even after closure. Set up by the client. |
ActiveDaysforOP | int | NULL | Number of days that a visit has to be kept active before auto closing. Set up by the client. |
IncludeInDischargeReports | smallint | NOT NULL | Indicates whether to include a visit type in discharge reports or not. Allowable Values: 0 - False, 1 - True |
UrgentCare | smallint | NOT NULL | Indicates whether a visit is of Urgent care type or not. Allowable Values: 0 - False, 1 - True |
IsHidden | bit | NOT NULL | Indicates whether a visit type is hidden from common UI. Allowable Values: 0 - False, 1 - True |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|