SAPActivityCheckWorkTime Table

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.