EN
Español
English
Português
    AVS_AUDIT_FILE_TRANSFER

    Stores the additional data for AVS audit file transfer events

    Data model

    Fields

    Field Type Description
    action* INT Share ID code
    audit_device_id* INT Unique identifier of the associated materialized device
    audit_group_support_id INT Unique identifier of the associated materialized support group
    audit_user_id* INT Unique identifier of the associated materialized user
    creation_date* DATETIME Record creation date
    date_key* INT Key with date information
    mode* BIT Indicates transfer direction
    source_path* NVARCHAR (8000) File path on the specialist’s computer
    target_path* NVARCHAR (8000) File path on the device computer
    time_key* INT Key with time information

    Primary Key

    PK01_AVS_AUDIT_FILE_TRANSFER
    audit_user_id, audit_device_id, action, date_key, time_key

    References

    Column Referenced Table Referenced column Name
    audit_device_id* dbo.AVS_AUDIT_DEVICE id FK02_AVS_AUDIT_FILE_TRANSFER
    audit_group_support_id dbo.AVS_AUDIT_GROUP_SUPPORT id FK03_AVS_AUDIT_FILE_TRANSFER
    audit_user_id* dbo.AVS_AUDIT_USERS id FK01_AVS_AUDIT_FILE_TRANSFER