[Home] [Help]
View: HXC_TIMECARDS_V
View Text
SELECT TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER
, START_TIME
, STOP_TIME
, PARENT_BUILDING_BLOCK_ID
, PARENT_BUILDING_BLOCK_OVN
, APPROVAL_STATUS
, RESOURCE_ID
, COMMENT_TEXT
, DATE_FROM
, RESOURCE_TYPE
FROM HXC_TIME_BUILDING_BLOCKS HTB
WHERE HTB.SCOPE = 'TIMECARD'
AND HTB.TYPE = 'RANGE'
AND HTB.DATE_TO = HR_GENERAL.END_OF_TIME
AND HTB.RESOURCE_TYPE = 'PERSON'
Columns
Name |
TCRD_TIME_BUILDING_BLOCK_ID |
TCRD_OBJECT_VERSION_NUMBER |
TCRD_START_TIME |
TCRD_STOP_TIME |
TCRD_PARENT_BUILDING_BLOCK_ID |
TCRD_PARENT_BUILDING_BLOCK_OVN |
TCRD_APPROVAL_STATUS |
TCRD_RESOURCE_ID |
TCRD_COMMENT_TEXT |
TCRD_SUBMISSION_DATE |
TCRD_RESOURCE_TYPE |