EN
Español
English
Português
    CMDB_AUDIT

    Control table of audits carried out on an IC

    Data model

    Fields

    Field Type Description
    fl_bol_hasalarm* BIT Indicates if an alarm is generated for the Audit
    fl_dat_auditend DATETIME Audit Completion Date
    fl_dat_auditstart DATETIME Audit Start Date
    fl_int_audit_id* INT Audit ID
    fl_int_limit_days INT Days in advance before the end date, when the alarm should be triggered
    fl_int_responsible_id INT Audit Owner Identifier, reference table AFW_USERS.user_id
    fl_str_description NVARCHAR (8000) Description of the audit
    name NVARCHAR (100) Audit Name
    projectid INT Project ID, reference table ASMS_PROJECTS.proj_id
    template_id INT Mail template ID, reference the ASMS_MAIL_TEMPLATE.id table

    Primary Key

    PK_CMDB_AUDIT
    fl_int_audit_id

    References

    Column Referenced Table Referenced column Name
    fl_int_responsible_id dbo.AFW_USERS user_id FK01_CMDB_AUDIT
    projectid dbo.ASMS_PROJECTS proj_id FK02_CMDB_AUDIT
    template_id dbo.ASMS_MAIL_TEMPLATE id FK04_CMDB_AUDIT