EN
Español
English
Português
    AVS_AUDIT_RECORDING

    Stores additional data from AVS audit recording files

    Data model

    Fields

    Field Type Description
    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
    end_date_key* INT Key with end date information
    end_datetime* DATETIME Final moment of recording
    end_time_key* INT Key with end time information
    file_name* VARCHAR (40) Recording File Key
    start_date_key* INT Key with start date information
    start_datetime* DATETIME Initial moment of recording
    start_time_key* INT Key with start time information
    time_key* INT Key with time information

    Primary Key

    PK01_AVS_AUDIT_RECORDING
    audit_user_id, audit_device_id, date_key, time_key

    References

    Column Referenced Table Referenced column Name
    audit_device_id* dbo.AVS_AUDIT_DEVICE id FK02_AVS_AUDIT_RECORDING
    audit_group_support_id dbo.AVS_AUDIT_GROUP_SUPPORT id FK03_AVS_AUDIT_RECORDING
    audit_user_id* dbo.AVS_AUDIT_USERS id FK01_AVS_AUDIT_RECORDING