Activity Failed Forms

The Activity Failed Forms entity records failed transactions from clocks during their offline mode. When clocks lose connectivity to the server, this entity continues to record all activity transactions at the clock without interaction with the server. When the clock regains connectivity, the clock sends all of the saved transactions to the server. Any errors that prevent the activity from being stored in the main table can be viewed in this entity.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides multiple rows per Activity Segment and Employee for the defined time period because there may be multiple results associated with this activity segment and employee for the defined time period.

Columns

Label

Description

Key

Created Date Time

Date/time at which this record was created.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_CREATED_DATE_TIME

Device ID

ID of the device being used to perform the transaction.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_DEVICE_ID

Effective Date Time

Date/time at which the transaction was intended to run.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EFFECTIVE_DATE_TIME

Executed By Badge Number

Badge number of the person who actually performed the transaction.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EXECUTED_BY_BADGE_NUM

Executed By Person Number

Person number of the person who actually performed the transaction.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EXECUTED_BY_PERSON_NUM

Form Code

Form code for this activity segment.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TRANSACTION_ID

Message

Message. It usually contains the validation error message for this failed activity segment.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_MESSAGE_TEXT

Raw Input ID

Unique activity segment identifier.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_ID

Result Field Definition ID

Identifier associated with this result value.

WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ACTIVITY_MAPPING_ID

Result Field Definition Name

Name of this result value: for example, Completed Quantity.

WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ACTIVITY_MAPPING_NAME

Result ID

Identifier key for the result associated with this activity segment.

WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ID

Result Values

Values entered for this activity segment.

WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_VALUES

Server Name

Server name.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_SERVER_NAME

Status

Status of this form input.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_PUNCH_STATUS_TYPE

Timezone

Timezone for this activity segment.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TIME_ZONE

Type ID

ID for the type of transaction.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TYPE

Web IP Address

IP address at which the activity segment originated.

WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_WEB_IP_NUM

Related entities

Core entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many

X