BusinessImportLogSummary Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The BusinessImportLogSummary table stores summary data for each business import execution.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for BusinessImportLogSummary table

Database Column

Details

ImportID

Type: integer. Key. Generated ID

Surrogate ID that uniquely identifies a business import.

ImportName

Type: text (max 255 characters). Nullable

Import name of the business import.

ImportType

Type: text (max 50 characters). Nullable

Import type of the business import.

Action

Type: text (max 20 characters). Nullable

The mode the business import is operating in e.g. Import, Simulation.

StartDate

Type: datetime. Nullable

Date and time when the business import is started on FNMS server.

EndDate

Type: datetime. Nullable

Date and time when the business import is completed on FNMS server.

Status

Type: integer. Nullable

Status of the business import: 0 - Not completed, 1 - Completed.

Processed

Type: integer. Nullable

Number of rows from data source that are processed for import.

Rejected

Type: integer. Nullable

Number of rows from data source that are rejected from importing.

SessionUID

Type: unique identifier. Key. Nullable

Unique task run identifier of the business import, nullable for business import initiated on the server.

FlexNet Manager Suite (On-Premises)

2020 R1