Skip to content

Custom Attributes in Database
Copy for LLM
Copy page as Markdown for LLMs
View as Markdown
Open this page as Markdown
Open in ChatGPT
Get insights from ChatGPT
Open in Claude
Get insights from Claude
Connect to Cursor
Install MCP server on Cursor
Connect to VS Code
Install MCP server on VS Code

The following tables list the custom attributes in the database.

Accounts
Entitlement
Fulfillment
Line Item
License Model Attribute
License Model Custom Attribute
Maintenance Line Item
Product
User

Account

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
ORG_ID	Unique identifier in the database of the account from the Account table.	Equivalent to: ID in SEC_VW_ACCOUNT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

Entitlement

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
ENTITLEMENT_ID	Unique identifier in the database of the entitlement from the Entitlement table.	Equivalent to: ENTITLEMENT_ID_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

Fulfillment

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
FULFILLMENT_ID	Unique identifier in the database of the fulfillment from the Fulfillment table.	Equivalent to: ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

Line Item

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
ACTIVATION_ID	Unique identifier in the database of the Activation Id from the Entitlement table.	Equivalent to: LINEITEM_ID_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

License Model Attribute

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
LINE_ITEM_ID	Unique identifier in the database of the Activation Id from the Entitlement table.	Equivalent to: LINEITEM_ID_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

License Model Custom Attribute

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
LICENSE_MODEL_ID	Unique identifier in the database of the License Model from the Entitlement table.	Equivalent to: LICENSEMODEL_ID_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

Maintenance Line Item

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
ACTIVATION_ID	Unique identifier in the database of the Activation Id from the Entitlement table.	Equivalent to: MAINT_ID_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

Product

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
PRODUCT_ID	Unique identifier in the database of the Activation Id from the Entitlement table.	Equivalent to: PRODUCT_ID in SEC_VW_ENTITLEMENT view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.

User

Field in Database	Description	Equivalent To
ID	Unique identifier in the database.
USER_ID	Unique identifier in the database of the User Id from the User table.	Equivalent to: ID in SEC_VW_USER view
NAME	Name of the custom attribute as defined in FlexNet Operations.
VALUE	Value of the custom attribute.
DWH_LASTUPDATED_DATE	The last date that the record was refreshed in the data warehouse.
LASTMODIFIED	Last timestamp the custom attribute was updated.
REPORTING_ORDER	Order in which the custom attribute was defined in FlexNet Operations.
TYPE	Data type of the custom attribute defined in FlexNet Operations.