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.

[Home] [Help]

View: HXT_TIM_SUMMARY

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASG.ORGANIZATION_ID
, ORG.NAME
, ASGV.HXT_ROTATION_PLAN
, PTP.END_DATE
, PPF.PAYROLL_ID
, PPF.PAYROLL_NAME
, PER.EMPLOYEE_NUMBER
, PER.FULL_NAME
, TIM.APPROV_PERSON_ID
, PER2.FULL_NAME
, TIM.APPROVED_TIMESTAMP
, ROT.NAME
, PER.PERSON_ID
, TIM.ID
, TIM.TIME_PERIOD_ID
FROM PER_PEOPLE_F PER
, PER_TIME_PERIODS PTP
, HXT_TIMECARDS TIM
, PER_ASSIGNMENTS_F ASG
, HXT_PER_AEI_DDF_V ASGV
, HXT_ROTATION_PLANS ROT
, PER_PEOPLE_F PER2
, HR_ORGANIZATION_UNITS ORG
, PAY_PAYROLLS_F PPF
WHERE PER.PERSON_ID=TIM.FOR_PERSON_ID
AND TIM.TIME_PERIOD_ID=PTP.TIME_PERIOD_ID
AND PTP.END_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASGV.ASSIGNMENT_ID=ASG.ASSIGNMENT_ID
AND ASGV.INFORMATION_TYPE = 'HXT_ASS_INFO'
AND ASG.PERSON_ID=PER.PERSON_ID
AND ASGV.HXT_ROTATION_PLAN=ROT.ID
AND ORG.ORGANIZATION_ID=ASG.ORGANIZATION_ID
AND TIM.PAYROLL_ID=PPF.PAYROLL_ID
AND TIM.APPROV_PERSON_ID=PER2.PERSON_ID(+)

Columns

Name
ORGANIZATION_ID
ORGANIZATION_NAME
HXT_ROTATION_PLAN_ID
END_DATE
PAYROLL_ID
PAYROLL_NAME
EMPLOYEE_NUMBER
FULL_NAME
APPROV_PERSON_ID
APPROV_PERSON_NAME
APPROVED_TIMESTAMP
ROTATION_PLAN_NAME
PERSON_ID
TIM_ID
TIME_PERIOD_ID