Attendance Transactions

The Attendance Transactions entity exposes the transactional data generated by the Attendance application. Data can be retrieved for the following types of Attendance transactions:

  • Action
  • Balance Reset
  • Balance Update
  • Event
  • Expiring Point
  • Perfect Attendance Award
  • Perfect Attendance Deduction
  • Perfect Attendance Disqualification
In addition, the Attendance Transactions provides daily balance data and period start and end balance data. The data provided in this entity is also available on the Attendance Details page of the application.

The data columns in the Attendance Transactions entity are organized by the type of transaction and the same data column, such as Balance Name, exists for each transaction type. Use the Category name in the data column selector to identify the transaction type and select the data columns necessary to report on that particular type of transaction. Each transaction type has all the data columns necessary for reporting on that specific area. It is recommended that Dataviews and reports use only those data columns related to a single transaction type.

Data Granularity

Provides one row per employee per Attendance transaction.

Supported Dataview/RDO Type

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

Columns
Action Code DP_ACTION_CODE String No
Action Completed Indicator DP_ACTION_COMPLETED Boolean No
Action Completion Date DP_COMPLETION_DATE Date No
Action Description DP_ACTION_DESCRIPTION String No
Action ID DP_ACTION_ID String No
Action Initiated Date DP_ACTION_INITIATED_DATE Date No
Action Name DP_ACTION_NAME String No
Action Status DP_ACTION_STATUS String No
Action Status Date DP_ACTION_STATUS_DATE Date No
Action Trigger Balance Amount DP_ACTION_TRIGGER_BALANCE_AMOUNT Number No
Action Trigger Time Balance Amount DP_ACTION_TRIGGER_BALANCE_TIME_AMOUNT Number No
Action Triggered Date DP_ACTION_TRIGGERED_DATE Date No
Apply Date DP_DATE Date No
Award Date DP_EXPIRING_POINT_AWARD_DATE Date No
Balance Amount DP_EVENT_BALANCE_AMOUNT Number No
Balance Amount DP_DL_BALANCE_DAY_AMOUNT Number No
Balance Amount DP_BALANCE_RESET_AMOUNT Number No
Balance Amount DP_ACTION_BALANCE_AMOUNT Number No
Balance Change DP_BALANCE_UPDATE_CHANGE Number No
Balance Change DP_EVENT_BALANCE_CHANGE Number No
Balance ID DP_BALANCE_ID String No
Balance ID DP_ACTION_BALANCE_ID String No
Balance Name DP_BALANCE_UPDATE_NAME String No
Balance Name DP_ACTION_BALANCE_NAME String No
Balance Name DP_DL_BALANCE_NAME String No
Balance Name DP_EVENT_BALANCE_NAME String No
Balance Name DP_BALANCE_RESET_NAME String No
Balance Name DP_DAY_BALANCE_NAME String No
Balance Percentage Amount DP_EVENT_BALANCE_PERCENTAGE_AMOUNT Number No
Balance Reset ID DP_BALANCE_RESET_ID String No
Balance Reset Policy ID DP_BALANCE_RESET_POLICY_ID String No
Balance Reset Rule ID DP_BALANCE_RESET_RULE_ID String No
Balance Time Change DP_EVENT_BALANCE_TIME_CHANGE Number No
Balance Type DP_BALANCE_TYPE String No
Balance Type DP_ACTION_BALANCE_TYPE String No
Balance Type DP_BALANCE_UPDATE_TYPE String No
Balance Type DP_BALANCE_RESET_TYPE String No
Balance Type DP_DL_BALANCE_TYPE String No
Balance Type Name DP_DL_BALANCE_TYPE_NAME String No
Balance Type Name DP_BALANCE_TYPE_NAME String No
Balance Type Name DP_BALANCE_RESET_TYPE_NAME String No
Balance Type Name DP_ACTION_BALANCE_TYPE_NAME String No
Balance Type Name DP_BALANCE_UPDATE_TYPE_NAME String No
Balance Update ID DP_BALANCE_UPDATE_ID String No
Daily Balance Amount DP_EVENT_BALANCE_DAY_AMOUNT Number No
Daily Summary Balance Name DP_DAY_BALANCE_SUMMARY_NAME String No
Daily Summary Balance Type Name DP_DAY_BALANCE_SUMMARY_TYPE_NAME String No
Daily Summary Ending Balance Amount DP_DAY_END_BALANCE_SUMMARY_AMOUNT Number No
Daily Summary Ending Time Balance Amount DP_DAY_END_BALANCE_SUMMARY_TIME_AMOUNT Number No
Daily Summary Starting Balance Amount DP_DAY_START_BALANCE_SUMMARY_AMOUNT Number No
Daily Summary Starting Time Balance Amount DP_DAY_START_BALANCE_SUMMARY_TIME_AMOUNT Number No
Day-based Indicator DP_EVENT_IS_DAY_BASED Boolean No
Day Balance Type DP_DAY_BALANCE_SUMMARY_TYPE String No
Day Balance Type DP_DAY_BALANCE_TYPE String No
Day Balance Type Name DP_DAY_BALANCE_TYPE_NAME String No
Day Ending Balance Amount DP_DAY_END_BALANCE_AMOUNT Number No
Day Ending Balance Name DP_DAY_END_BALANCE_NAME String No
Day Ending Time Balance Amount DP_DAY_END_BALANCE_TIME_AMOUNT Number No
Day Starting Balance Amount DP_DAY_START_BALANCE_AMOUNT Number No
Day Starting Balance Name DP_DAY_START_BALANCE_NAME String No
Day Starting Time Balance Amount DP_DAY_START_BALANCE_TIME_AMOUNT Number No
Discipline Level End Date DP_DL_END_DATE Date No
Discipline Level Name DP_DL_NAME String No
Discipline Level Name DP_DL_CHANGE_NAME String No
Discipline Level Start Date DP_DL_START_DATE Date No
Effective Date ID DP_EFFECTIVE_DATE_ID String No
Event Code DP_EVENT_CODE String No
Event Group DP_EVENT_GROUP String No
Event ID DP_EVENT_ID String No
Event Name DP_EVENT_NAME String No
Event Time DP_EVENT_TIME DateTime No
Event Type DP_EVENT_TYPE String No
Event Type Name DP_EVENT_TYPE_NAME String No
Expiration Date DP_EXPIRING_POINT_EXPIRATION_DATE Date No
Has Documents Indicator DP_HAS_DOCUMENTS Boolean No
History Marker Date DP_HISTORY_MARKER_DATE Date No
Normalized Wage Liability DP_EVENT_NORMALIZED_WAGE_LIABILITY Number No
Perfect Attendance Award Date DP_PA_DEDUCTION_PERFECT_ATTENDANCE_DATE Date No
Perfect Attendance Balance Change DP_PA_DEDUCTION_POINT_CHANGE Number No
Perfect Attendance Balance Change DP_PA_AWARD_BALANCE_CHANGE Number No
Perfect Attendance Balance Name DP_PA_AWARD_BALANCE_NAME String No
Perfect Attendance Balance Name DP_PA_DEDUCTION_POINT_NAME String No
Perfect Attendance Balance Type DP_PA_DEDUCTION_POINT_TYPE String No
Perfect Attendance Balance Type Name DP_PA_DEDUCTION_POINT_TYPE_NAME String No
Perfect Attendance Definition ID DP_PERFECT_ATTENDANCE_DEF_ID String No
Perfect Attendance Definition Name DP_PA_DISQUALIFICATION_DEFINITION_NAME String No
Perfect Attendance Definition Name DP_PA_AWARD_DEFINITION_NAME String No
Perfect Attendance ID DP_PERFECT_ATTENDANCE_ID String No
Perfect Attendance Policy Detail Label DP_PA_AWARD_POLICY_DETAIL_LABEL String No
Perfect Attendance Policy Detail Label DP_PA_DISQUALIFICATION_POLICY_DETAIL_LABEL String No
Perfect Attendance Policy Detail Label DP_PA_DEDUCTION_POLICY_DETAIL_LABEL String No
Perfect Attendance Policy ID DP_PA_DEDUCTION_POLICY_ID String No
Perfect Attendance Policy Name DP_PA_AWARD_POLICY_NAME String No
Perfect Attendance Policy Name DP_PA_DISQUALIFICATION_POLICY_NAME String No
Perfect Attendance Policy Name DP_PA_DEDUCTION_POLICY_NAME String No
Perfect Attendance Time Balance Change DP_PA_DEDUCTION_POINT_TIME_CHANGE Number No
Perfect Attendance Time Balance Change DP_PA_AWARD_BALANCE_TIME_CHANGE Number No
Perfect Indicator DP_ACTION_PERFECT_ATTENDANCE Boolean No
Period End Balance Amount DP_PERIOD_END_BALANCE_AMOUNT Number No
Period End Balance Name DP_PERIOD_END_BALANCE_NAME String No
Period End Time Balance Amount DP_PERIOD_END_BALANCE_TIME_AMOUNT Number No
Period Start Balance Amount DP_PERIOD_START_BALANCE_AMOUNT Number No
Period Start Balance Name DP_PERIOD_START_BALANCE_NAME String No
Period Start Time Balance Amount DP_PERIOD_START_BALANCE_TIME_AMOUNT Number No
Point Change DP_EXPIRING_POINT_CHANGE Number No
Point Name DP_EXPIRING_POINT_NAME String No
Point Policy ID DP_EXPIRING_POINT_POLICY_ID String No
Point Policy Name DP_EXPIRING_POINT_POLICY_NAME String No
Point Type DP_EXPIRING_POINT_TYPE String No
Point Type Name DP_EXPIRING_POINT_TYPE_NAME String No
Policy Detail Label DP_BALANCE_UPDATE_POLICY_DETAIL_LABEL String No
Policy Detail Label DP_EVENT_POLICY_DETAIL_LABEL String No
Policy Detail Label DP_EXPIRING_POINT_POLICY_DETAIL_LABEL String No
Policy Detail Label DP_BALANCE_RESET_POLICY_DETAIL_LABEL String No
Policy ID DP_POLICY_ID String No
Policy Label DP_ACTION_POLICY_DETAIL_LABEL String No
Policy Label DP_DL_CHANGE_POLICY_DETAIL_LABEL String No
Policy Name DP_BALANCE_UPDATE_POLICY_NAME String No
Policy Name DP_DL_CHANGE_POLICY_NAME String No
Policy Name DP_ACTION_POLICY_NAME String No
Policy Name DP_BALANCE_RESET_POLICY_NAME String No
Policy Name DP_EVENT_POLICY_NAME String No
Profile Change Type DP_PROFILE_CHANGE_TYPE String No
Profile Change Type Name DP_PROFILE_CHANGE_TYPE_NAME String No
Profile ID DP_PROFILE_ID String No
Profile Name DP_PROFILE_NAME String No
Profile Name DP_DL_PROFILE_NAME String No
Reset Date DP_EXPIRING_POINT_RESET_DATE Date No
Rule ID DP_RULE_ID String No
Rule Name DP_BALANCE_RESET_RULE_NAME String No
Rule Name DP_RULE_NAME String No
Rule Name DP_BALANCE_UPDATE_RULE_NAME String No
System Generated Indicator DP_BALANCE_RESET_IS_SYSTEM Boolean No
System Generated Indicator DP_BALANCE_UPDATE_IS_SYSTEM Boolean No
System Generated Indicator DP_EVENT_IS_SYSTEM Boolean No
Time Balance Amount DP_BALANCE_RESET_TIME_AMOUNT Number No
Time Balance Amount DP_DL_BALANCE_DAY_TIME_AMOUNT Number No
Time Balance Amount DP_ACTION_BALANCE_TIME_AMOUNT Number No
Time Balance Change DP_BALANCE_UPDATE_TIME_CHANGE Number No
Time Change DP_EXPIRING_POINT_TIME_CHANGE Number No
Timecard Marker Date DP_TIMECARD_MARKER_DATE Date No
Transaction ID DP_TRANSACTION_ID String No
Type DP_TYPE String No
Type Name DP_TYPE_NAME String No
Update Policy ID DP_BALANCE_UPDATE_POLICY_ID String No
Update Rule ID DP_BALANCE_UPDATE_RULE_ID String No
Updated By DP_BALANCE_UPDATE_UPDATED_BY_USER_ID String No
Updated By DP_BALANCE_RESET_UPDATED_BY_USER_ID String No
Updated By User ID DP_UPDATED_BY_USER_ID String No
User Note DP_USER_NOTE String No
Wage Liability DP_EVENT_WAGE_LIABILITY Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many