SAPActivityCheckWorkTime Table

FlexNet Manager Suite (Cloud)

This table stores SAP activity check data related to work time.

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 SAPActivityCheckWorkTime table

Database Column

Details

SAPActivityCheckWork TimeID

Type: integer. Key. Generated ID

A unique identifier for the SAP activity check work time data.

SAPActivityCheckWork TimeUID

Type: text (max 32 characters). Key

The SAP unique identifier for the SAP activity check work time data.

SAPUserID

Type: integer. Key

Foreign key to the SAP user.

SAPSystemLandscapeID

Type: integer. Key

Foreign key to the system landscape that the SAP activity check work time data belongs to.

MeasurementDate

Type: datetime

The date that the SAP activity check work time data was measured.

MeasurementPeriodStart Date

Type: datetime

The start date that the SAP activity check work time data was measured from.

MeasurementPeriodEndDate

Type: datetime

The end date that the SAP activity check work time data was measured to.

BreakDurationSetting

Type: integer

The minimum number of seconds that a user must not be running any transactions in a 24 hour period.

TableName

Type: text (max 256 characters). Key

The name of the SAP table that was accessed during the minimum required break period.

BreakDurationResult

Type: integer

The number of days that the user has not meet the minimum break duration setting during the measurement period.

FlexNet Manager Suite (Cloud)

Current