Go to documentation repository
Page History
...
| 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(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 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(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 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 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(120255) | 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. |
...
Overview
Content Tools