EN
Español
English
Português
    AFW_LICENSE_USAGE

    Snapshot of license usage by application at a particular point in time

    Data model

    Fields

    Field Type Description
    application_id* INT Identifier of the effective application (direct product or parent suite)
    concurrent* INT Number of different users with concurrent license assigned
    date_id* INT Identifier of the date (UTC) dimension when the license usage photograph was taken
    id* INT Unique identifier of the record
    named* INT Number of different users with named license assigned
    time_id* INT Identifier of the time dimension (UTC) when the license usage photo was taken
    total* INT Number of different users with any assigned license (named or concurrent)

    Primary Key

    PK_AFW_LICENSE_USAGE
    id

    References

    Column Referenced Table Referenced column Name
    application_id* dbo.AFW_APPLICATIONS appl_id FK01_AFW_LICENSE_USAGE
    date_id* dbo.ADW_DIM_DATE id FK02_AFW_LICENSE_USAGE
    time_id* dbo.ADW_DIM_TIME id FK03_AFW_LICENSE_USAGE