The Campus Time & Attendance Dataview is a tool that allows users to analyze data and take action on one or more employees within their view. It provides immediate access to current business information in either table (Dataview) or chart (Homepage tile) format. Users can sort, group, and filter within a Dataview. Additionally, users can select one or more employees within a Dataview and navigate to another editor to perform actions, such as reviewing scheduled time off in the Schedule or adjusting missing punches in the Timecard. Dataviews can be printed or exported/downloaded to a .csv file. Unless otherwise indicated, Dataviews are available to Managers/Time Editors only.
Training Document: How to Use Dataviews in CTA
| Dataview Name | Dataview Fields |
| Accrual Details - Basic (available to Exempt Employee and Manager/Time Editor) | Employee Full Name, Accrual Code Name, Reporting Period, Opening Balance, Taken to Date, Current Balance Planned Takings, Available Balance, Ending Balance |
| Accrual Transactions Details (available to Exempt Employee and Manager/Time Editor) | Grouped By Employee Full Name, Grouped By Accrual Code Name, Employee ID, Accrual Code Type, Update Date, Effective Date, Accrual Transaction Type (Display Name), Accrual Amount (Hours), Paycode Name, Accrual Data Source, Edited By, Edited Date Probation Amount (Hours), Limit Amount (Hours) |
| Pending Time Off Requests | Employee ID, Employee Full Name, Pending Request Count, Primary Job |
| Time Off Requests History | Employee ID, Employee Full Name, Time-off Request ID (Status History), Time-off Request Status Change Date, Time-off Request Status Change User, Time-off Request Status Changed From, Time-off Request Status Changed To |
| Time Off Requests Info | Employee ID, Employee Full Name, Creator Full Name, Time-off Request ID, Subtype Name, Subtype Description, Subtype Symbol, Creation Date Status, Status Code, Manager Comments & Notes, Employee Comments & Notes, Time-off Request Actors, Start Date, End Date, Duration, Symbolic Amount, Paycode Name |
| Time Audit | Grouped By Datasource, Employee ID, Employee Full Name, Org Number, Org Description, Revision User, Revision Date, Revision Type, Datasource - IP Address, Application, Entity Event Date, Entity Type, Paycode Name, Duration (Hours), Comment Text, Note Text |
| Employee Summary – Basic | Employee ID, Employee Full Name, Email, Primary Location (Path), Primary Job, Home Labor Category, Adjusted Service Date, Reports To, Workforce Group, Essential, Assignment Status, Work Location, Primary Job Effective Date, Time Entry Method, Time Entry Method Effective Date |
| Employee Hours by Labor Category | Employee ID, Employee Full Name, Payroll Frequency, Primary Job, Organization Number, Organization Name, Job Code Name, Job Title, Paycode Name, Paycode Combined Indicator, Actual Total Hours (Include Corrections) |
| Punch Audit | Employee ID, Employee Full Name, Org Number, Org Description, Apply Date, Start Time, In Punch Geolocation, In Punch Accuracy, End Time, Out Punch Geolocation, Out Punch Accuracy |
| UAB Accrual Balances | Employee Full Name, Employee ID, Org, Org Description, Assignment Status, Assign Cat Name, Assignment Category, Sick Balance, Vacation Balance, PH Balance, Comp Time Balance |
| UAB Employees with Unapproved Timecards | Employee Full Name, Employee ID, Org, Org Description, Assignment Category, Assign Cat Description, Manager Approval Status |
| UAB Exceptions and Missed Punches | Employee Full Name, Employee ID, Org, Org Description, Assignment Category, Assign Cat Description, Missed In Punch, Missed Out Punch, Short Break |
| UAB Manager Biweekly Approval | Employee Full Name, Employee ID, Org, Org Description Assignment Category, Assign Cat Description, Regular Hours, Overtime Hours, Non Worked Hours, Total Hours, Dollar Premiums, Hour Premiums, Employee Approval Status, Manager Approval, Signed Off Indicator |
| UAB Manager Monthly Approval | Employee Full Name, Employee ID, Org, Org Description, Assignment Category, Assign Cat Description, Regular Hours, Overtime Hours, Non Worked Hours, Total Hours, Dollar Premiums, Hour Premiums, Employee Approval Status, Manager Approval, Signed Off Indicator |
| UAB Total Hours by Combined Pay Code | Employee Full Name, Employee ID, Org, Org Description, Assignment Category, Assign Cat Description, Total Hours, Paycode Name |
More Details
| Base user population Who has access to this system | Dataviews are available to Campus Time & Attendance Managers and Time Editors only unless otherwise noted |
| Administrator access How users get admin access | See Campus Time & Attendance Access Types |
| System Admin The current system administrator | Human Resources Information Systems |
| Support Contact Who to ask if you have questions | HRIS@uab.edu |