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.

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.

Supported Dataview/RDO Type

Employee	Business Structure	Employee - Time Series	Business Structure - Time Series	Work Unit	Work Unit - Time Series

Columns


Created Date Time	Date/time at which this record was created.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_CREATED_DATE_TIME	DateTime	No
Device ID	ID of the device being used to perform the transaction.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_DEVICE_ID	String	No
Effective Date Time	Date/time at which the transaction was intended to run.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EFFECTIVE_DATE_TIME	DateTime	No
Executed By Badge Number	Badge number of the person who actually performed the transaction.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EXECUTED_BY_BADGE_NUM	String	No
Executed By Person Number	Person number of the person who actually performed the transaction.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_EXECUTED_BY_PERSON_NUM	String	No
Form Code	Form code for this activity segment.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TRANSACTION_ID	String	No
Message	Message. It usually contains the validation error message for this failed activity segment.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_MESSAGE_TEXT	String	No
Raw Input ID	Unique activity segment identifier.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_ID	String	No
Result Field Definition ID	Identifier associated with this result value.	WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ACTIVITY_MAPPING_ID	String	No
Result Field Definition Name	Name of this result value: for example, Completed Quantity.	WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ACTIVITY_MAPPING_NAME	String	No
Result ID	Identifier key for the result associated with this activity segment.	WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_ID	String	No
Result Values	Values entered for this activity segment.	WORK_ACTIVITY_FAILED_FORMS_RAW_RESULTS_VALUES	String	No
Server Name	Server name.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_SERVER_NAME	String	No
Status	Status of this form input.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_PUNCH_STATUS_TYPE	String	No
Timezone	Timezone for this activity segment.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TIME_ZONE	String	No
Type ID	ID for the type of transaction.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_TYPE	String	No
Web IP Address	IP address at which the activity segment originated.	WORK_ACTIVITY_FAILED_FORMS_RAW_INPUT_WEB_IP_NUM	String	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many