Go to documentation repository
Page History
| Section | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
dbo.EVENT
| Column name | Type | Description | See also |
|---|---|---|---|
| action | nvarchar(32) | System names of the system objects events. | The Events tab |
| description | nvarchar(70) | Names of the system objects events in terms of the installed language pack. | |
| objtype | nvarchar(60) | System name of the event-related object. | |
| params | ntext | Event parameters for configuring the macros. They are configured in the ddi.exe utility on the Events tab. | |
| type | nvarchar(5) | Event parameters: alarm (A), info message (M), sound support (S), do not send to the network (H), do not log (N), Windows log (L). For example, if in the ddi.exe utility, on the Events tab, all specified checkboxes are set for any event, and the ALARM event handling type is selected, the parameter value for this event is HNSLA. |
dbo.OBJ_PERSON
| Column name | Type | Description | See also |
|---|---|---|---|
| all_param | nvarchar(32) | Not used. | |
| area_id | nvarchar(40) | Area object id, where the user is located according to the data of the emergency monitoring system which is a part of the ACFA-Intellect software package. | |
| auto_brand | nvarchar(32) | User's vehicle brand. | |
| auto_number | nvarchar(100) | User's vehicle license plate number. You can specify multiple vehicle numbers separated by a space. The field can be used as an identifier to provide the user access when ACFA-Intellect and Auto-Intellect operate together. | Virtual Access Server Integration Module Configuration and Operation Manual |
| auto_pass_type | int | Vehicle access type. Not used. | |
| begin | nvarchar(25) | Card operation start date. | |
| begin_temp_level | nvarchar(25) | Temporary access level operation start date. | |
| card | nvarchar(255) | Card code. | |
| card_date | nvarchar(255) | Card issue date. | |
| card_loss | int | Number of card losses. | |
| card_type | int | Not used. | |
| comment | ntext | Comment. | |
| department | nvarchar(255) | Department id, where the visitor is headed. | |
| drivers_license | nvarchar(120) | Driver's license id. | |
| nvarchar(60) | Email address. | ||
| end_temp_level | nvarchar(25) | Temporary access level expiration date. | |
| expired | nvarchar(25) | Card expiration date. | |
| external_id | nvarchar(40) | External id. Is used when the users are imported from the external databases. | |
| facility_code | nvarchar(255) | Facility code. | |
| finished_at | datetime | Job dismissal date. | |
| flags | int | "Enabled-disabled" object flag, which is displayed in the Intellect interface as the "Disable" option on the settings panel. | |
| guid | uniqueidentifier | User unique id (GUID). | |
| id | nvarchar(40) | User id. | |
| is_active_temp_level | smallint | Temporary access level activation status. | |
| is_apb | smallint | Enabling/disabling the double-entry control. | |
| is_locked | smallint | The user is blocked. | |
| level2_id | nvarchar(40) | Not used. | |
| level_id | ntext | Temporary access level id. If there is a list of ids, they are separated by a comma. | |
| levels_times | ntext | Is used for the temporary access levels operation. | |
| location | nvarchar(16) | - | |
| marketing_info | ntext | - | |
| name | nvarchar(255) | Name. | |
| owner_person_id | nvarchar(40) | For "embedded" cards — id of user - card owner. | |
| parent_id | nvarchar(40) | Department id. | |
| passport | nvarchar(120) | Passport details. | |
| patronymic | nvarchar(255) | Patronymic name. | |
| person | nvarchar(50) | User id, to whom the visitor is headed. | |
| phone | nvarchar(60) | Phone number. | |
| pin | nvarchar(255) | PIN code. | |
| post | nvarchar(255) | Job position. | |
| pur | int | Area management rights. | |
| rubeg8_zone_id | nvarchar(40) | Not used. | |
| schedule_id | nvarchar(40) | Employee schedule id. This id is related to the Time and Attendance module. It is not a time zone or an access level. | |
| started_at | datetime | Recruitment date. | |
| surname | nvarchar(255) | Last name. | |
| tabnum | nvarchar(60) | Personnel number. | |
| teleph_work | nvarchar(16) | Work phone number. | |
| temp_card | nvarchar(15) | Not used. | |
| temp_level_id | ntext | Temporary access level id. | |
| temp_levels_times | ntext | Is used for the temporary access levels operation. | |
| visit_birthplace | nvarchar(120) | Visitor's birth place. | |
| visit_document | nvarchar(120) | Visitor's document. | |
| visit_purpose | nvarchar(120) | Visitor's purpose of the visit. | |
| visit_reg | nvarchar(120) | Visitor's registration address. | |
| when_area_id_changed | datetime | User area change date. | |
| whence | nvarchar(60) | Visitor's workplace name. | |
| who_card | nvarchar(60) | Id of user who assigned the access card to the required user. | |
| who_level | nvarchar(60) | Id of user who assigned the access level to the required user. |
dbo.PROTOCOL
| Column name | Type | Description | See also |
|---|---|---|---|
| objtype | nvarchar(50) | Object type to which the event is related (you can view the list of objects and their names in the database and GUI using the ddi.exe utility). | |
| objid | nvarchar(50) | Object ID to which the event is related. | |
| action | nvarchar(50) | Event name (list of objects and events in ddi.exe). It is displayed in the Event column of the Event viewer. | Event control via event log |
| region_id | nvarchar(50) | Region id. It is displayed in the Region column of the Event viewer. | Event control via event log |
| param0 | nvarchar(255) | Additional event parameters. It is displayed in the Add.info column of the Event viewer. | Event control via event log |
| param1 | nvarchar(255) | Additional event parameters. | |
| param2 | nvarchar(255) | Additional event parameters. | |
| param3 | nvarchar(255) | Additional event parameters. Card code for the access-related events (for example, ACCESS_IN). | Event viewer parameters |
| user_param_double | float | Parameter for the Queue length detection module operation. | Operating the «Queue length detection» module |
| date | datetime | Event date and time. It is displayed in the Date and time column of the Event viewer. | Event control via event log |
| time | datetime | Event time (also contains the event date). It is a copy of the date parameter. | |
| time2 | datetime | Event time 2 (also contains the event date). It is a copy of the date parameter. | |
| owner | nvarchar(50) | Network name of the computer where the object, which caused the event, is located. |
| Info | ||
|---|---|---|
| ||
Each field of the datetime format contains both date and time. param0 – param3 columns contain additional data which can differ depending on the event type and object type to which the event is related. |
Overview
Content Tools