RPT_FEATURE Table

This table holds information about the license features that are found in the report logs that were imported.

RPT_FEATURE Table

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”