RPT_FEATURE Table
This table holds information about the license features that are found in the report logs that were imported.
Column Name | Data Type | Data Length | Description | Constraints |
---|---|---|---|---|
CATALOG_SECTION_ID | Integer | 4 | The ID of the section in the imported report log from where this feature was extracted. | Not nullable. Part of the primary key of the table. |
FEATURE_ID | Integer | 4 | An ID assigned to the feature record in the table. It is unique across all the feature records in a section of a report log; hence the two IDs, CATALOG_SECTION_ID and FEATURE_ID form the unique key for RPT_FEATURE Table. | Not nullable. Part of the primary key of the table. |
FEATURE_NAME | String | 255 | The name of the FEATURE . | Not nullable. |
FEATURE_VERSION | String | 100 | The version of the FEATURE or INCREMENT line in the license files of the vendor daemon. | Not nullable. |
POOLKEY | String | 255 | The license key on the FEATURE or INCREMENT line in the license file of the vendor daemon. | Not nullable. |
SECTION_START_TIME | Integer | 4 | Section start time identifies the moment a feature becomes available at the beginning of a section. The date is in seconds from Jan 1, 1970. | |
SECTION_END_TIME | Integer | 4 | Section end time identifies the moment of time when a feature becomes unavailable at the end of the section. The date is in seconds from Jan 1, 1970. | |
NUM_REGULAR | Nullable Integer | 2 | The number of regular licenses for this feature. A NULL value in this property denotes uncounted licenses. | |
NUM_OVERDRAFT | Nullable Integer | 2 | The number of overdraft licenses for this feature. | |
SERVER_HOST | Nullable String | 200 | The name of the server that hosted the vendor daemon that processed the event. | |
SERVER_HOSTID | Nullable String | 200 | The hostid of the server that hosted the vendor daemon that processed the event. | |
DAEMON | Nullable String | 200 | The name of the vendor daemon that processed the event. | |
DAEMON_VERSION | Nullable String | 100 | The version of the vendor daemon that processed the event. | |
VENDOR_STRING | Nullable String | 255 | The text value of the VENDOR\_STRING parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
ASSET_INFO | Nullable String | 255 | The text data that is provided with the asset\_info parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
DIST_INFO | Nullable String | 255 | The text data that is provided with the dist\_info parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
EXPIRATION_DATE | Integer | 8 | The expiration date of the FEATURE or INCREMENT line in the license file of the vendor daemon. The date is given in seconds from Jan 1, 1970. A NULL value in this property denotes a permanent license. | |
FEATURE_HOSTID | Nullable String | 200 | The text data for HOSTID found on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
ISSUED | Nullable Integer | 4 | The date on which the feature was issued, as defined by the ISSUED parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. The date is in seconds from Jan 1, 1970. | |
ISSUER | Nullable String | 200 | The text data that is the issuer of the feature line, as defined by the ISSUER parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
NOTICE | Nullable String | 255 | The text data that is the notice value, as defined by the NOTICE parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
SERIAL | Nullable String | 200 | The text data that is the serial number that is defined by the SN parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
USER_INFO | Nullable String | 255 | The text data that is the user information defined by the user\_info parameter on the FEATURE or INCREMENT line in the license file of the vendor daemon. | |
INCLUDE_LIST | Nullable String | 1024 | A string that concatenates the names—in alphabetical order—of all the users and user groups that have been INCLUDEd for this feature as defined in the options file. The feature’s license key is the only characteristic that is used to identify the feature. The user and user group names are surrounded by double quotes and separated by commas. | |
RESERVE_LIST | Nullable String | 1024 | A string that concatenates the names—in alphabetical order—of all the users and user groups that have been RESERVEd for this feature as defined in the options file. The feature’s license key is the only characteristic that is used to identify the feature. The user and user group names are surrounded by double quotes and separated by commas. | |
PACKAGE_COMPONENT | Nullable String | 1 | A value of “Y” denotes that the feature is a component of a package. Only the component of a package is flagged as “Y”; the package feature itself is not. A value of “N” denotes that the feature is not a component of a package. In this case, the feature can be either the package itself or not associated with any package. | Must be either “Y” or “N” |
SUITE_PACKAGE | Nullable String | 1 | A value of "Y" denotes that the feature is a suite package. Only the package feature of the suite package is flagged with a "Y". The components of the suite package are not. A value of "N" denotes that the feature is not a suite package. In this case, the feature can be either the component of the suite package itself or a package or component that is not associated with any suite package whatsoever or a feature that is not associated with any package. | Must be either “Y” or “N” |