EN
Español
English
Português
    ASMS_APPROVALS

    Contains the information of an approval process

    Data model

    Fields

    Field Type Description
    approved_reason_id INT Identifier of the reason for the state transition, if approval is approved, reference to the ASMS_STATUS_REASON.reas_id table
    approved_status_id INT Identifier of the state to which the article passes if approval is approved, reference to the ASMS_STATUS.stat_id table
    approved_type_id INT Enumeration of the approval type (1 = Internal, 2 = Customer)
    by_ammount INT Number of voters needed for approval
    by_percent INT Percentage of voters required for approval
    customer_boss_approve* BIT Identify if the customer’s boss should be included in the approval
    description NVARCHAR (500) Description of the approval
    disapproval_amount INT Number of voters needed for disapproval
    disapproval_percent INT Percentage of voters needed to disapprove
    id* INT Unique Approval Identifier
    is_active* INT Represents the status of an approval, (0 = inactive, 1 = active)
    item_type_id* INT Type ID for approval, reference to ASMS_TYPES.id table
    model_id INT Model ID, reference to ASMS_MODEL.id table
    more_reason_id INT Identifier of the reason for the state transition, if the approval needs more information, reference to the ASMS_STATUS_REASON.reas_id table
    more_status_id INT Identifier of the state to which the item passes, if approval needs more information, reference to the ASMS_STATUS.stat_id table
    name* NVARCHAR (200) Approval Name
    profile_id INT Profile ID for approval, reference to ASMS_MODELPROFILES.id table
    project_id INT Project ID for approval, reference to ASMS_PROJECTS.proj_id table
    refused_reason_id INT Identifier of the reason for the state transition, if approval is rejected, reference to the ASMS_STATUS_REASON.reas_id table
    refused_status_id INT ID of the state to which the item passes, if approval is rejected, reference to the ASMS_STATUS.stat_id table
    responsible_boss_approve* BIT Identifies whether the specialist’s head should be included in the approval
    server_id INT Mail server ID for approval, reference to AFW_MAIL_ACCOUNT.maac_id table
    status_id* INT Identifier of the current status of the approval, reference to the ASMS_STATUS.stat_id table
    template_id INT Template ID for approval, reference to ASMS_MAIL_TEMPLATE.id table

    Primary Key

    PK_ASMS_APPROVALS
    id

    References

    Column Referenced Table Referenced column Name
    approved_reason_id dbo.ASMS_STATUS_REASON reas_id FK05_ASMS_APPROVALS
    approved_status_id dbo.ASMS_STATUS stat_id FK03_ASMS_APPROVALS
    item_type_id* dbo.ASMS_TYPES id FK09_ASMS_APPROVALS
    model_id dbo.ASMS_MODEL id FK02_ASMS_APPROVALS
    more_reason_id dbo.ASMS_STATUS_REASON reas_id FK07_ASMS_APPROVALS
    more_status_id dbo.ASMS_STATUS stat_id FK08_ASMS_APPROVALS
    project_id dbo.ASMS_PROJECTS proj_id FK10_ASMS_APPROVALS
    refused_reason_id dbo.ASMS_STATUS_REASON reas_id FK06_ASMS_APPROVALS
    refused_status_id dbo.ASMS_STATUS stat_id FK04_ASMS_APPROVALS
    server_id Bod. AFW_MAIL_ACCOUNT maac_id FK12_ASMS_APPROVALS
    status_id* dbo.ASMS_STATUS stat_id FK01_ASMS_APPROVALS
    template_id dbo.ASMS_MAIL_TEMPLATE id FK11_ASMS_APPROVALS