VIEW: HXT.HXT_TIMECLOCK_ERRORS#

Source

View Text - Preformatted

select ID ID, OTM_ERROR OTM_ERROR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ORA_ERROR ORA_ERROR, TIMECARD_SOURCE TIMECARD_SOURCE, APPROVER_NUMBER APPROVER_NUMBER, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, DATE_WORKED DATE_WORKED, START_TIME START_TIME, END_TIME END_TIME, HOURS HOURS, EARNING_POLICY EARNING_POLICY, HOURS_TYPE HOURS_TYPE, EARN_REASON_CODE EARN_REASON_CODE, PROJECT PROJECT, TASK_NUMBER TASK_NUMBER, LOCATION_CODE LOCATION_CODE, HRW_COMMENT HRW_COMMENT, RATE_MULTIPLE RATE_MULTIPLE, HOURLY_RATE HOURLY_RATE, AMOUNT AMOUNT, SEPARATE_CHECK_FLAG SEPARATE_CHECK_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CONCAT_COST_SEGMENTS CONCAT_COST_SEGMENTS, COST_SEGMENT1 COST_SEGMENT1, COST_SEGMENT2 COST_SEGMENT2, COST_SEGMENT3 COST_SEGMENT3, COST_SEGMENT4 COST_SEGMENT4, COST_SEGMENT5 COST_SEGMENT5, COST_SEGMENT6 COST_SEGMENT6, COST_SEGMENT7 COST_SEGMENT7, COST_SEGMENT8 COST_SEGMENT8, COST_SEGMENT9 COST_SEGMENT9, COST_SEGMENT10 COST_SEGMENT10, COST_SEGMENT11 COST_SEGMENT11, COST_SEGMENT12 COST_SEGMENT12, COST_SEGMENT13 COST_SEGMENT13, COST_SEGMENT14 COST_SEGMENT14, COST_SEGMENT15 COST_SEGMENT15, COST_SEGMENT16 COST_SEGMENT16, COST_SEGMENT17 COST_SEGMENT17, COST_SEGMENT18 COST_SEGMENT18, COST_SEGMENT19 COST_SEGMENT19, COST_SEGMENT20 COST_SEGMENT20, COST_SEGMENT21 COST_SEGMENT21, COST_SEGMENT22 COST_SEGMENT22, COST_SEGMENT23 COST_SEGMENT23, COST_SEGMENT24 COST_SEGMENT24, COST_SEGMENT25 COST_SEGMENT25, COST_SEGMENT26 COST_SEGMENT26, COST_SEGMENT27 COST_SEGMENT27, COST_SEGMENT28 COST_SEGMENT28, COST_SEGMENT29 COST_SEGMENT29, COST_SEGMENT30 COST_SEGMENT30, TIME_SUMMARY_ID TIME_SUMMARY_ID, TIM_SUM_EFF_END_DATE TIM_SUM_EFF_END_DATE, TIM_SUM_EFF_START_DATE TIM_SUM_EFF_START_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HXT"."HXT_TIMECLOCK_ERRORS"

View Text - HTML Formatted

SELECT ID ID
, OTM_ERROR OTM_ERROR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ORA_ERROR ORA_ERROR
, TIMECARD_SOURCE TIMECARD_SOURCE
, APPROVER_NUMBER APPROVER_NUMBER
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, DATE_WORKED DATE_WORKED
, START_TIME START_TIME
, END_TIME END_TIME
, HOURS HOURS
, EARNING_POLICY EARNING_POLICY
, HOURS_TYPE HOURS_TYPE
, EARN_REASON_CODE EARN_REASON_CODE
, PROJECT PROJECT
, TASK_NUMBER TASK_NUMBER
, LOCATION_CODE LOCATION_CODE
, HRW_COMMENT HRW_COMMENT
, RATE_MULTIPLE RATE_MULTIPLE
, HOURLY_RATE HOURLY_RATE
, AMOUNT AMOUNT
, SEPARATE_CHECK_FLAG SEPARATE_CHECK_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CONCAT_COST_SEGMENTS CONCAT_COST_SEGMENTS
, COST_SEGMENT1 COST_SEGMENT1
, COST_SEGMENT2 COST_SEGMENT2
, COST_SEGMENT3 COST_SEGMENT3
, COST_SEGMENT4 COST_SEGMENT4
, COST_SEGMENT5 COST_SEGMENT5
, COST_SEGMENT6 COST_SEGMENT6
, COST_SEGMENT7 COST_SEGMENT7
, COST_SEGMENT8 COST_SEGMENT8
, COST_SEGMENT9 COST_SEGMENT9
, COST_SEGMENT10 COST_SEGMENT10
, COST_SEGMENT11 COST_SEGMENT11
, COST_SEGMENT12 COST_SEGMENT12
, COST_SEGMENT13 COST_SEGMENT13
, COST_SEGMENT14 COST_SEGMENT14
, COST_SEGMENT15 COST_SEGMENT15
, COST_SEGMENT16 COST_SEGMENT16
, COST_SEGMENT17 COST_SEGMENT17
, COST_SEGMENT18 COST_SEGMENT18
, COST_SEGMENT19 COST_SEGMENT19
, COST_SEGMENT20 COST_SEGMENT20
, COST_SEGMENT21 COST_SEGMENT21
, COST_SEGMENT22 COST_SEGMENT22
, COST_SEGMENT23 COST_SEGMENT23
, COST_SEGMENT24 COST_SEGMENT24
, COST_SEGMENT25 COST_SEGMENT25
, COST_SEGMENT26 COST_SEGMENT26
, COST_SEGMENT27 COST_SEGMENT27
, COST_SEGMENT28 COST_SEGMENT28
, COST_SEGMENT29 COST_SEGMENT29
, COST_SEGMENT30 COST_SEGMENT30
, TIME_SUMMARY_ID TIME_SUMMARY_ID
, TIM_SUM_EFF_END_DATE TIM_SUM_EFF_END_DATE
, TIM_SUM_EFF_START_DATE TIM_SUM_EFF_START_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HXT"."HXT_TIMECLOCK_ERRORS"