Reports2017-11-18T12:27:27+00:00

HXC Timecard Audit Trail

Description
Categories: BI Publisher, Human Resources
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
Person
 
LOV Oracle
Supervisor
 
LOV Oracle
Payroll
 
LOV Oracle
Location
 
LOV Oracle
Organization
 
LOV Oracle
Display Records with Working Status?
 
LOV Oracle
Delete and Regenerate Data?
 
LOV Oracle
To Date
 
Date
From Date
 
Date
By continuing to use the site, you agree to the use of cookies. Accept