| CreatedDateTime |
date and time for creating the organizational unit in the database |
| UpdatedDateTime |
Date and time for lastest update of the organizational unit in the database |
| DeletedDateTime |
date and time for logically deletion of the organizational unit in the database |
| CreatedBy |
Employee id for employee who created the organizational unit in the database |
| UpdatedBy |
Employee id for latest employee who has updated the organizational unit in the database |
| DeletedBy |
Employee id for employee who logically deleted the organizational unit in the database |
| Type |
Refers to a type defined in the OrgUnitType table |
| Code |
Identifying code (not unique) |
| Name |
The name of the organizational unit |
| ShortName |
The short name of the organizational unit |
| alias_ |
Id felt |
| Capacity |
The capacity of the organizational unit. Can be used looesely to define things such as; number of beds, number of patients etc. |
| ParentType |
The organizational unit can refer to another organizational unit that is the parent. ParentType holds the type of that organizational unit. Refers to a type defined in the OrgUnitType table |
| ParentCode |
The identifying code of the parent organizational unit. |
| ReferenceType |
The organizational unit referes to another organization unit with this type.Refers to a type defined in the OrgUnitType table. |
| ReferenceCode |
The organizational unit referes to another organization unit with this code. |
| Location |
The location part of the organizational unit address |
| Road |
The road part of the organizational unit address |
| HouseNum |
The house number part of the organizational unit address |
| ZipNum |
For holding numeric zip codes. ZipCode text can be found in lookup table ZipCodeNumeric if it exists. If this is not the case the ZipText table is used for holding the zipcode text. |
| ZipString |
For holding non numeric zip codes. ZipCode text can be stored in lookup table or in ZipText column. |
| ZipText |
If no lookup table exists for finding text for ZipNum or ZipString, ZipText can be used for holding this text. |
| CountryCode |
Holds the country code for the organization unit. Together with the OrgUnitCountryTypeString in the .config file. this refers to another organizational unit |
| Phone |
The phone number for the organizational unit |
| Fax |
The fax number for the organizational unit |
| Email |
The email address for the organizational unit |
| EANIdentifier |
The EANIdentifier for the organizational unit (used for MedCom communication) |
| Rate |
This field can be loosely used for holding price ratings |
| GUID |
For integration with Microsoft Active Directory (NOT IMPLEMENTED YET!) |
| Distribution |
Id felt |
| DistributeByFunctions |
Used in accreditation (see Accreditation documentation for more info) |
| Accreditation |
Used in accreditation (see Accreditation documentation for more info) |
| AccreditationBodyNumber |
Used in accreditation (see Accreditation documentation for more info) |
| id |
Id felt |