HXC Timecard Audit Trail
Description
- Categories
- BI Publisher
- Application
- Time and Labor Engine
- Source
- OTL: Timecard Audit Trail Report
- Short Name
- HXCRPTAUD
- DB package
- HXC_RPT_TC_AUDIT_TRAIL
SQL 21 lines
SELECT TO_CHAR(TIME_ENTRY_DATE,'dd-MON-yyyy') ENTRY_DATE, ATTRIBUTE_INFO, NVL(start_stop_time,hours) HOURS, ACTION, TO_CHAR(ACTION_DATE,'dd-MON-yy HH24:MI:SS') ACTION_BY_DATE, ACTION_BY, COMMENTS, CLA_REASON, RESOURCE_NAME, TO_CHAR(TC_START_TIME,'dd-MON-yyyy') START_TIME, TO_CHAR(TC_STOP_TIME,'dd-MON-yyyy') STOP_TIME, SUBSTR(ACTION_TYPE,1,1) ACTION_ON FROM hxc_rpt_tc_audit ORDER BY resource_name, tc_start_time, transaction_id, TRUNC(time_entry_date), action_type, action_date |
Parameters 9
| Parameter | Type | List of values SQL |
|---|---|---|
| From Date | Date | |
| To Date | Date | |
| Delete and Regenerate Data? | LOV Oracle | |
| Display Records with Working Status? | LOV Oracle | |
| Organization | LOV Oracle | |
| Location | LOV Oracle | |
| Payroll | LOV Oracle | |
| Supervisor | LOV Oracle | |
| Person | LOV Oracle |