Personnel Fields - Attendance Group

HRMS Employee Self Service displays the Attendance group in the Available field when you select Personnel in the Data Source field on the Select Fields tab of the View Builder.

The following table shows the fields available in the Attendance group.

Attendance Group field information

 

Field Database Field Name Associated Database Column Data Type
Plan Start Date PlanStartDate Ste.hatsum.t_dplan System.DateTime
Seniority Start Date SeniorityStartDate Ste.hatsum.t_dsnstart System.DateTime
Months of Seniority SeniorityMonths Ste.hatsum.t_msenior System.Decimal
Plan Threshold PlanThreshold Ste.hatsum.t_thresh System.Decimal
Carryover Hours CarryoverHours Ste.hatsum.t_carry System.Decimal
Carryover Date CarryoverDate Ste.hatsum.t_dcarry System.DateTime
Last Accrual Date AccruedThroughDate Ste.hatsum.t_daccrue System.DateTime
Hours Taken TakenHours Ste.hatsum.t_taken System.Decimal
Year End Eligibility YearEndEligibility Ste.hatsum.t_yrend System.Decimal
Year End Date YearEndDate Ste.hatsum.t_dyrend System.DateTime
Hours Accrued Through Last Close AccruedHoursSinceClose Ste.hatsum.t_close System.Decimal
Last Close Date LastCloseDate Ste.hatsum.t_dclose System.DateTime
Hours Accrued Since Last Close AccruedHours Ste.hatsum.t_accrued System.Decimal
Suspend Accrual SuspendAccrualInd Ste.hatsum.t_noaccrue Boolean
Plan Code PlanId Ste.hatplan.p_id String
Plan Description PlanDescription Ste.hatplan.p_desc String
Plan Type PlanType Ste.hatplan.p_type String
Plan Year AccrualMethod Ste.hatplan.p_method String
Lump Sum Indicator Lumpsum Ste.hatplan.p_lump Boolean
Accrual Period CalculationPeriod Ste.hatplan.p_period String
Perfect Attendance Indicator PerfectAttendanceIndicator Ste.hatplan.p_perfect Boolean
Maximum Available MaximumAccrualAmount Ste.hatplan.p_maxaccr System.Decimal
Maximum Carryover Per Year MaximumCarryover Ste.hatplan.p_yrcarry1 System.Decimal
Maximum Total Carryover MaximumTotalCarryover Ste.hatplan.p_totcar1 System.Decimal
Seniority Level 1 P_Senior1 Ste.hatplan.p_senior1 Int
Hours/Days for Level 1 P_Hours1 Ste.hatplan.p_hours1 System.Decimal
Seniority Level 2 P_Senior2 Ste.hatplan.p_senior2 Int
Hours/Days for Level 2 P_Hours2 Ste.hatplan.p_hours2 System.Decimal
Seniority Level 3 P_Senior3 Ste.hatplan.p_senior3 Int
Hours/Days for Level 3 P_Hours3 Ste.hatplan.p_hours3 System.Decimal
Seniority Level 4 P_Senior4 Ste.hatplan.p_senior4 Int
Hours/Days for Level 4 P_Hours4 Ste.hatplan.p_hours4 System.Decimal
Seniority Level 5 P_Senior5 Ste.hatplan.p_senior5 Int
Hours/Days for Level 5 P_Hours5 Ste.hatplan.p_hours5 System.Decimal
Seniority Level 6 P_Senior6 Ste.hatplan.p_senior6 Int
Hours/Days for Level 6 P_Hours6 Ste.hatplan.p_hours6 System.Decimal
Seniority Level 7 P_Senior7 Ste.hatplan.p_senior7 Int
Hours/Days for Level 7 P_Hours7 Ste.hatplan.p_hours7 System.Decimal
Seniority Level 8 P_Senior8 Ste.hatplan.p_senior8 Int
Hours/Days for Level 8 P_Hours8 Ste.hatplan.p_hours8 System.Decimal
Seniority Level 9 P_Senior9 Ste.hatplan.p_senior9 Int
Hours/Days for Level 9 P_Hours9 Ste.hatplan.p_hours9 System.Decimal
Seniority Level 10 P_Senior10 Ste.hatplan.p_senior10 Int
Hours/Days for Level 10 P_Hours10 Ste.hatplan.p_hours10 System.Decimal
Absence Reason Codes AssociatedAbsenceTypes Ste.hatplan.p_abtype String
Threshold Points ThresholdPoints Ste.hatplan.p_ptthre System.Decimal
Points per Occurrence PointsPerOccurrence Ste.hatplan.p_ptoccur System.Decimal
Points per Hour PointsPerHour Ste.hatplan.p_ppthours System.Decimal
Units per Threshold UnitsPerThreshold Ste.hatplan.p_ptper String
Absence Start Date TransactionStartDate Ste.hattran.a_date System.DateTime
Absence Day of Week TransactionDayofWeekCode Ste.hattran.a_day String
Absence Reason Code ReasonCode Ste.hattran.a_reason String
Absence Reason Description N/A N/A N/A
Absence Hours TransactionHours Ste.hattran.a_hours System.Decimal
Absence Comments Comments Ste.hattran.a_comments String