eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: HXC.HXC_TCD_TIMECARDS#

Source

View Text - Preformatted


select RESOURCE_ID RESOURCE_ID, REC_PERIOD_ID REC_PERIOD_ID, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, PERSON_NUMBER PERSON_NUMBER, PERSON_NAME PERSON_NAME, APPROVAL_STATUS APPROVAL_STATUS, SUPERVISOR SUPERVISOR, ORGANIZATION ORGANIZATION, LOCATION LOCATION, PERSON_TYPE PERSON_TYPE, PAYROLL_NAME PAYROLL_NAME, LAST_MODIFIED_BY LAST_MODIFIED_BY, LAST_MODIFIED_DATE LAST_MODIFIED_DATE, APPLICATION APPLICATION, USER_ID USER_ID, SUPERVISOR_ID SUPERVISOR_ID, NOTIFICATION_ID NOTIFICATION_ID, TIMECARD_ID TIMECARD_ID, TIMECARD_OVN TIMECARD_OVN, MEANING MEANING from "HXC"."HXC_TCD_TIMECARDS"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, REC_PERIOD_ID REC_PERIOD_ID
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, PERSON_NUMBER PERSON_NUMBER
, PERSON_NAME PERSON_NAME
, APPROVAL_STATUS APPROVAL_STATUS
, SUPERVISOR SUPERVISOR
, ORGANIZATION ORGANIZATION
, LOCATION LOCATION
, PERSON_TYPE PERSON_TYPE
, PAYROLL_NAME PAYROLL_NAME
, LAST_MODIFIED_BY LAST_MODIFIED_BY
, LAST_MODIFIED_DATE LAST_MODIFIED_DATE
, APPLICATION APPLICATION
, USER_ID USER_ID
, SUPERVISOR_ID SUPERVISOR_ID
, NOTIFICATION_ID NOTIFICATION_ID
, TIMECARD_ID TIMECARD_ID
, TIMECARD_OVN TIMECARD_OVN
, MEANING MEANING
FROM "HXC"."HXC_TCD_TIMECARDS"