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
    approved_status_id INT Identifier of the status to which the item passes if approval is approved
    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 Identifier for Approval
    max_number_attempts INT Number of attempts
    model_id INT Model identifier
    more_reason_id INT Identifier of the reason for the state transition, if the approval needs more information
    more_status_id INT Identifier of the state to which the item passes, if the approval needs more information
    name* NVARCHAR (200) Approval Name
    profile_id INT Profile ID for Approval
    project_id INT Project ID for Approval
    refused_reason_id INT Identifier of the reason for the state transition, if approval is rejected
    refused_status_id INT Identifier of the state to which the item passes, if approval is rejected
    reminder_active BIT Represents the status of the reminder, (0 = inactive, 1 = active)
    reminder_date DATETIME Reminder activation date
    responsible_boss_approve* BIT Identifies whether the specialist’s head should be included in the approval
    schedule_id INT Unique identifier of the schedule
    server_id INT Mail server ID for approval
    status_id* INT Current Approval Status Identifier
    template_id INT Template ID for Approval

    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
    schedule_id dbo.AFW_SCHEDULER sche_id FK13_ASMS_APPROVALS
    server_id dbo.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