HXC Timecard Audit Trail

➜ Back to Library
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
    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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
HXC Missing Timecard PA Payroll Distribution Employee Detail INV Lot Transaction Register HXC Retrieval Error Handling JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use ORB Report Columns AR Automatic Transactions Batch CAC Calculate ICP PII Item Costs by Where Used FV Data Act File B
Blitz Report™