HXC Timecard Audit Trail

Description
Categories: BI Publisher
Columns: Entry Date, Attribute Info, Hours, Action, Action By Date, Action By, Comments, Cla Reason, Resource Name, Start Time ...
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 Name SQL text Validation
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