[Home] [Help]
View: HXC_TIMECARD_DAYS_V
View Text
SELECT HTB.TIME_BUILDING_BLOCK_ID
, HTB.OBJECT_VERSION_NUMBER
, HTB.PARENT_BUILDING_BLOCK_ID
, HTB.PARENT_BUILDING_BLOCK_OVN
, HTB.START_TIME
, HTB.STOP_TIME
, HTB.RESOURCE_ID
FROM HXC_TIME_BUILDING_BLOCKS HTB
WHERE HTB.SCOPE = 'DAY'
AND HTB.TYPE = 'RANGE'
AND HTB.DATE_TO = HR_GENERAL.END_OF_TIME
AND HTB.RESOURCE_TYPE = 'PERSON'
Columns
Name |
DAY_TIMECARD_ID |
DAY_TIMECARD_OVN |
DAY_PARENT_ID |
DAY_PARENT_OVN |
DAY_START_TIME |
DAY_STOP_TIME |
DAY_RESOURCE_ID |