Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectID of HHealthCareUnit table generated by Architecture |
InstanceHFCID | smallint | NOT NULL | InstanceHFCID of HHealthCareUnit table generated by Architecture |
RecordId | int | NULL | NOt used. |
Description | varchar(255) | NULL | Description of the HealthCareUnit that is being created. Can be valued to HCU Name. |
IsVersioned | bit | NOT NULL | Indicates if the row in the table is modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserID of the user who created the row in the database |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
DefaultStore_oid | int | NULL | Not Used. |
HealthcareUnitName | varchar(75) | NOT NULL | HealthCareUnit Name that is being created. |
Abbreviation | varchar(10) | NOT NULL | Abbreviation of HealthCareUnit Name |
Active | bit | NOT NULL | Active indicator.(1-Active, 0-Non Active) |
Capacity | int | NULL | Not Used |
ActivationDate | datetime | NULL | Date and Time when HealthCareUnit's became active. |
InActivationDate | datetime | NULL | Date and Time when HealthCareUnit's became inactive. |
IsLeaf | bit | NULL | Not Used |
NetworkType | tinyint | NULL | Network Type of HealthCareUnit. Allowable Values: 0 - Internal HCU, 1 - External HCU |
HealthcareUnitPath | varchar(2000) | NOT NULL | Path - Folder structure of Health Care Units. |
| | | Hospital Organization\Internal HCU\Enterprise Medical Center |
| | | Hospital Organization\Internal HCU\Enterprise Medical Center\Entity |
| | | Hospital Organization\Internal HCU\Enterprise Medical Center\Entity\UnitA |
IsValidMedialocationIndicator | bit | NULL | Not Used |
CanHaveMedia | bit | NULL | Indicates whether healthcareunit can have media. Allowable Values: 0 - No, 1 - Yes |
OrganizationType | tinyint | NULL | Organization Type of HealthCareUnit. Allowable Values: 0 - Entity, 1 - Enterprise, 2 - Unit |
IsIsolated | bit | NULL | Indicates whether this healthcareunit is isolated. Allowable Values: 0 - No, 1 - Yes |
UnitForQuickRegistration | bit | NULL | Indicates whether this healthcareunit is a unit for Quick Registration. Allowable Values: 0 - No, 1 - Yes |
IsNameModified | bit | NULL | HealthCareUnit Name Modified indicator. Allowable Values: 0 - Not Modified 1 - Modified |
PreviousName | varchar(75) | NULL | Previous name of HealthCareUnit |
EntityMappingID | int | NULL | Entity ID of HealthCareUnit |
InterfacedSystemType | varchar(8) | NULL | Interfaced System Type of HealthCareunit. Allowable Values: 0 - Internal HCU, 1 - External HCU |
InterfaceRouteCode | varchar(8) | NULL | Not Used. |
HCUExternalAbb | varchar(30) | NULL | HealthCareUnit External Abbreviation. Set Up by client and can match the HCU Abbreviation. |
EntityAbb | varchar(10) | NULL | Abbreviation of the Entity that HCU belong to. |
UnitType_oid | int | NOT NULL | Objectid of the HCU Type with relation to the Objectid in HHealthcareUnitType. |
SeqNo | int | NULL | Sequence No of HealthCareUnit can be set up by the client. |
IsClinicallyResponsibleUnit | bit | NULL | Indicates if HCU is Clinically Responsible Unit. Allowable Values: 0 - No, 1 - Yes |
CanHavePatientLocation | bit | NULL | Indicates this healthcareunit can have patient location. Allowable Values: 0 - No, 1 - Yes |
EntityGroup_oid | int | NULL | Not Used |
IsExclusiveHCU | TinyInt | NULL | Indicates this HealthCareUnit is Exclusive HCU. Allowable Values: 0 - No, 1 - Yes, Null - Not valued. |
Specialty_OID | INT | NULL | Speicalty OID of this HealthCareUnit |
LastCngDtime | datetime | NULL DEFAULT(getutcdate( | Indicates the current Universal Time Coordinate or Greenwich Mean Time |
IsFollowUpCareProvider | TinyInt | NULL | Indicate whether HealthCareUnit is a Follow up Health Care Provider. Allowable Values: 0 - No, 1 - Yes |
IsAmbulatoryUnit | TinyInt | NOT NULL | Indicates whether a healthcareunit is an ambulatory type or not. Allowable Values: 0 - No, 1 - Yes |
ISOguid | varchar(128) | NULL | Globally unique ID for an entity. This is valued by the client. |
NPI | varchar(20) | NULL | NPI(National Provider Identifier) |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|