Go to documentation repository
On the page:
dbo.EVENT
| Column name | Type | Description | See also |
|---|---|---|---|
| action | nvarchar(32) | System names of the system objects events | The Events tab |
| description | nvarchar(255) | Names of the system objects events in terms of the installed language pack | |
| objtype | nvarchar(255) | 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 PSIM software package | |
| auto_brand | nvarchar(32) | User's vehicle brand | |
| auto_number | nvarchar(300) | 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 PSIM and Auto PSIM 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(25) | 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 Axxon PSIM 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 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(255) | 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) | The ddi.exe utility for editing database templates and external settings files |
| 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 Viewer |
| region_id | nvarchar(50) | Region id. It is displayed in the Region column of the Event viewer | Event control via Event Viewer |
| param0 | nvarchar(255) | Additional event parameters, for example, computer name and user name. They are displayed in the Add.info column of the Event viewer | Event control via Event Viewer |
| 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 Viewer |
| 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 | |
| operator_id | nvarchar(60) | Id of the User object logged into the system when a command was executed |
Note
Each field of the datetime format contains both date and time.
The param0—param3 columns contain additional data that may differ depending on the event type and object type to which the event is related.
dbo.UPDATE_PROTOCOL
| Column name | Type | Description | See also |
|---|---|---|---|
| objtype | nvarchar(255) | 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) | The ddi.exe utility for editing database templates and external settings files |
| objid | nvarchar(255) | Object id to which the event is related | |
| old_param | ntext | Object parameters before the event | |
| new_param | ntext | Object parameters after the event | |
| user_id | nvarchar(255) | The id of Axxon PSIM user who made the change | |
| date | datetime | Event date and time | |
| time | datetime | Event date and time | |
| owner | nvarchar(255) | Network name of the computer from which the change was made | |
| action | int | The type of changes made. Possible values:
|
Overview
Content Tools