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_TMP_RPT#

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, SUPERVISOR_ID SUPERVISOR_ID, LOCATION_ID LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, SEL_SUPERVISOR_ID SEL_SUPERVISOR_ID, SEL_TC_STATUS SEL_TC_STATUS, RPT_STATUS RPT_STATUS, PERSON_TYPE PERSON_TYPE, PERSON_NAME PERSON_NAME, PERSON_NUMBER PERSON_NUMBER, APPROVAL_STATUS APPROVAL_STATUS, SUPERVISOR SUPERVISOR, ORGANIZATION ORGANIZATION, LOCATION LOCATION, PAYROLL PAYROLL, APPLICATION APPLICATION, TC_START_DATE TC_START_DATE, TC_END_DATE TC_END_DATE, LAST_MODIFIED_BY LAST_MODIFIED_BY, LAST_MODIFIED_DATE LAST_MODIFIED_DATE from "HXC"."HXC_TCD_TMP_RPT"

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
, SUPERVISOR_ID SUPERVISOR_ID
, LOCATION_ID LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SEL_SUPERVISOR_ID SEL_SUPERVISOR_ID
, SEL_TC_STATUS SEL_TC_STATUS
, RPT_STATUS RPT_STATUS
, PERSON_TYPE PERSON_TYPE
, PERSON_NAME PERSON_NAME
, PERSON_NUMBER PERSON_NUMBER
, APPROVAL_STATUS APPROVAL_STATUS
, SUPERVISOR SUPERVISOR
, ORGANIZATION ORGANIZATION
, LOCATION LOCATION
, PAYROLL PAYROLL
, APPLICATION APPLICATION
, TC_START_DATE TC_START_DATE
, TC_END_DATE TC_END_DATE
, LAST_MODIFIED_BY LAST_MODIFIED_BY
, LAST_MODIFIED_DATE LAST_MODIFIED_DATE
FROM "HXC"."HXC_TCD_TMP_RPT"