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.
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 |